I have a personal check-book built into Excel.
One column is there for a check mark (I use *)(you can use anything you
want)
I put in this mark when I get my bank statement and the item is on the
statement.
Than I perform 3 separate totals for the data.
The first Adds everything (In) and subtracts everything (Out)
this is my personal tally.
The second adds all entries which do not have an * (SumIf())
The third adds the first and second to give the bank balance.

All the formulas act on the full columns (avoiding the need for range
settings)

Again the only way to automate this is to have an identifier column...

--
steveB

Remove "AYN" from email to respond
"boliwj" wrote in
message ...

I was going to include the date that the money was deposited per bank
records as well as the date the cash receipt was approved on our end.
Hopefully this well help.


--
boliwj
------------------------------------------------------------------------
boliwj's Profile:
http://www.excelforum.com/member.php...o&userid=27354
View this thread: http://www.excelforum.com/showthread...hreadid=468605