simple petty cash ledger

L

Leanin' Cedar

My employer wants me to account for $300.00 I receive at the start of the
school year. He gave me a printed sheet with the following columns:

Date Description Deductions Additions
Balance.

The first entry would be for the $300.00 I receive at the start of the
school year, and then enter each purchase I make and a balance after each
expense. Then I receive a reimbursement twice a month to bring my balance
back up to $300.00.

Is there an easy way of doing this in Excel instead of on the printout he
gave me? I would like to be able to update the balance automatically after
each deduction or addition.

Did some googling but couldn't find (or wasn't sure what I was looking for)
anything.

Thanks for any help
Bob

Excel 2002
 
B

Bob Phillips

Assuming those are headings in row 1, columns A,B,C & D, In E2 add

=E1+(D2-C2)

and then just copy that down all rows
 
L

Leanin' Cedar

Thanks for the quick reply.
Since row one would be the "headings" the first entry would be in E2 of
$300.00 for the first check that I receive.
Then I used =E2+(D3-C3) and then copied that down E4 etc. The only problem
is the current balance shows in all of the rows until I make an entry in
that row and then the new balance shows all the way down E. Is there a way
to hide the balance in rows that I have not made an entry in.

I hope that is sort of clear. Sorry to be a bit dense here.
Bob
 
B

Biff

Hi!

Try this:

=IF(AND(D3="",C3=""),"",E2+(D3-C3))

Copy down as needed.

The balance cell will remain blank until you make an entry in either C3 or
D3.

Biff
 
L

Leanin' Cedar

Bob Phillips said:
I did allow for headings. Row 2 would still be correct.
Click to expand...

Probably me being new to this and did not quite understand.

Biff posted another formula and that one worked for me.

Thanks for your quick reply to my problem;
Bob
 
B

Bob Phillips

Leanin' Cedar said:
Probably me being new to this and did not quite understand.

Biff posted another formula and that one worked for me.
Click to expand...

I saw that, which is why I didn't answer that bit, Just explaining that you
didn't need to start at row 3.
 
Top