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)!
The file contains a Microsoft Excel (version 4.0 and above) spreadsheet template.
Download: Monthly 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.