Bookkeeping Ledger Template?

On Aug 26, 8:10 am, Gord Dibben <gorddibbATshawDOTca> wrote:
> Browse through this list. May be something you can use.
>
> http://office.microsoft.com/en-us/templates/results.aspx?qu=ledger&av...
>
> Gord Dibben MS Excel MVP
>
>
>
> On Sat, 25 Aug 2007 21:53:57 -0700, Arcadian <philo....RemoveThis@verizon.net> wrote:
> >Is there a template of a three-column bookkeeeping ledger, compatible
> >with Excel 2007, which I can download?- Hide quoted text -
>
> - Show quoted text -

Thanks, Gord, but none of them are what I'm seeking. Anyway, I just
made my own template & now have another plroblem. I want to insert
the formula to add to the balance if there's a value in the debit
column or subtract from the balance if there's a value in the credit
column, but I don't know how to say value or blank value in Excel
language. How do I say "If x=a value" or "if y=blank"?

In simple terms.........

=IF(A1>0,do something) for a cell with a positive value

=IF(A1="",do something else) for a cell with no value

=IF(A1<=0,do something different) for a negative value or a 0


Gord



On Tue, 28 Aug 2007 12:47:57 -0700, Arcadian <philobat.DeleteThis@verizon.net> wrote:

>On Aug 26, 8:10 am, Gord Dibben <gorddibbATshawDOTca> wrote:
>> Browse through this list. May be something you can use.
>>
>> http://office.microsoft.com/en-us/templates/results.aspx?qu=ledger&av...
>>
>> Gord Dibben MS Excel MVP
>>
>>
>>
>> On Sat, 25 Aug 2007 21:53:57 -0700, Arcadian <philo....DeleteThis@verizon.net> wrote:
>> >Is there a template of a three-column bookkeeeping ledger, compatible
>> >with Excel 2007, which I can download?- Hide quoted text -
>>
>> - Show quoted text -
>
>Thanks, Gord, but none of them are what I'm seeking. Anyway, I just
>made my own template & now have another plroblem. I want to insert
>the formula to add to the balance if there's a value in the debit
>column or subtract from the balance if there's a value in the credit
>column, but I don't know how to say value or blank value in Excel
>language. How do I say "If x=a value" or "if y=blank"?

On Aug 28, 1:31 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> In simple terms.........
>
> =IF(A1>0,do something) for a cell with a positive value
>
> =IF(A1="",do something else) for a cell with no value
>
> =IF(A1<=0,do something different) for a negative value or a 0
>
> Gord
>
>
Wouldn't double quotes refer to a text? I'm working only with
number. In my research I found the IF ISBLANK function. Could I use
that in my situation? From what I've seen it goes:
IF(ISBLANK(location)true, false). What I want for my formula is
IF(ISBLANK(Credit cell)add value in debit cell to above balance, minus
value in credit cell from above balance).Would this work?

In another group, someone suggested the formula previous balance +
current debit - current credit, which makes a lot of sense. I tried
that & now got new problems.

When clicking & dragging a formula, to copy it down a column, Excel
2007 doesnt alter the position values to suit its cell position as in
Excel 2003. So all it does is repeat the function of the first row's
values over & over again. So to repeat the formula with different
location values, I have to enter a different formula for each row,
which is a lot of typing.

When entering a value in the opening balance cell, it repeats all the
way down the column. How do I program it so that a value only appears
when a value is inserted in its row?

If your formulas do not increment as you drag them down, you may have absolute
references or your calculation mode may be set to manual.

Change to relative references or set calculation mode to automatic.

Second question...............

Trap for no data.

=IF(A1="","",A1)


Gord Dibben MS Excel MVP

On Sun, 09 Sep 2007 14:29:10 -0700, Arcadian <philobat.DeleteThis@verizon.net> wrote:

>In another group, someone suggested the formula previous balance +
>current debit - current credit, which makes a lot of sense. I tried
>that & now got new problems.
>
>When clicking & dragging a formula, to copy it down a column, Excel
>2007 doesnt alter the position values to suit its cell position as in
>Excel 2003. So all it does is repeat the function of the first row's
>values over & over again. So to repeat the formula with different
>location values, I have to enter a different formula for each row,
>which is a lot of typing.
>
>When entering a value in the opening balance cell, it repeats all the
>way down the column. How do I program it so that a value only appears
>when a value is inserted in its row?
>

I have written and used an Excel template for bookkeeping.
The basic input is a check register.
The output are P&L statements: current, monthly, quarterly and year-to-date.

It is a very comprehensive program, which include expense payments by:
check, cash, debit card, and credit card.
It has a checking account reconciliation sheet.
The chart of accounts may be customized to your business.

I have just started to market it.
But I could send you a FREE copy for your evaluation.
Just promise not to give it to others.
Send me your E-mail address and I will send you the template as an
attachment. It has no Macros, nor viruses, etc. It is just a spreadsheet.

Reply to: lenshapiro.RemoveThis@hotmail.com

url:http://www.ureader.com/msg/1041285.aspx