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.
Monthly bank reconciliation template
For background information as well as information on related topics, see bank reconciliation.