 |
Monthly Bank Reconciliation
Template: Aid for Quicker, More Accurate Reconciliation
| 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. |
Download
Now:
Monthly bank
reconciliation template |
|
|
| Special Features:
 |
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. |
|
|
|
|
 |