Benefits: If you find yourself spending
lots of time every month reconciling your bank statement and still aren't able
to nail it down to the penny, our specially designed monthly bank reconciliation
form contained in the attached file might be able to help you. It can help make
the process far less painful and much more accurate, and will even do some of
the clerical work for you. Just plug in the account balance shown on your bank
statement, your deposits in transit, your outstanding checks, and your account
balance according to your books in the spaces provided. The reconciliation will
add up all the amounts, and immediately tell you if your books agree with your
bank balance. If they don't agree, you can get right to the business of finding
your errors (sorry, the spreadsheet can't do that for you)!
File Description: The file contains a
Microsoft Excel (version 4.0 and above) spreadsheet template. Once you've
downloaded the file, you must copy it to your EXCEL\XLSTART directory in order
to use it.
bank reconciliation template
- Download this spreadsheet template just once,
and be able to use it to reconcile your bank statement every month.
- Items that need to be considered when
reconciling your bank statement are already listed - just take a couple of
minutes each month to plug in your amounts.
Back to Template Menu