simple petty cash ledger

  • Thread starter Thread starter Leanin' Cedar
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
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.
 
Back
Top