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

 

bullet For assistance on downloading and saving a file, click here.
bullet To return to main menu, click here.
 
Special Features:

 

bullet Download this spreadsheet template just once, and be able to use it to reconcile your bank statement every month.
bullet 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.