CHECK BOOK LEDGER

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Looking for a good check book ledger for balancing check book. Any
suggestions as to where to look.
Thanks for any help

Jerry
 
JB, do a surch here for check book
http://office.microsoft.com/templates/default.aspx

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
In the Balance column (specifically cell F5), the MS template uses the
formula
=IF(AND(ISBLANK(D5),ISBLANK(E5)),"",F4-D5+E5)
A safer formula would be
=IF(AND(ISBLANK(D5),ISBLANK(E5)),"",ROUND(OFFSET(F5,-1,0)-D5+E5,2))
and copy it down.

ROUND(,2) avoids accumulation of binary approximations to decimal
fractions that cannot be exactly represented in binary. OFFSET(F5-1,0),
instead of F4, insures that if you have to insert an entry you will
still get the correct balance.

Jerry
 
Back
Top