Another checkbook registry problem...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put together a checkbook registry much like the Excel
Checkbook Registry Template, and I know how to make the columns/ rows a
certain function (i.e. currency, date, etc.) but I can't figure out the
formula to get the running balance. If someone could help, i would greatly
appreciate it!

Jazz
P.S. I'm using MS Excel 2003.
 
Lets say column A has the transaction date.
Column B (starting in B2) has the deposits
Column C (starting in C2) has the withdrawls
Column D will have the running balance

In D1 put 0
In D2 enter:

=D1+B2-C2 and copy down

We just take the previous balance and update it.
 
I tried your advice and I still can't get it to work... I just don't know
what I'm doing wrong... it comes out saying $10.00 every time and the formula
changes to =REF#!+B1-C1... any more adivce??
 
how are you copying your formula down the sheet?
perhaps you can also tell us which columns and rows your sheet has its
1)Balance bought forward cell
2)which row and column is the first withdrawal cell
3)which row and column has the first deposit cell
4)which row and column has the first"balance" cell?
 
Try this, it works if you delete rows later, and shows zero if there is no
date in column A

=IF(ISBLANK(A2),0,SUM($B$2:B2)-SUM($C$2:C2))

Regards
Peter
 
I already have this done, probably in more details then you are trying to do.
My spreadsheet calculates the difference between the ending balance in the
spreadsheet vs the ending balance that you indicate for the check register.
Also pulls the ending balance from the previous register (in spreadsheet) to
make beginning balance in new register and more. If you would like me to
email you my copy (template), I will with instructions on how it works.

Les
 
Back
Top