Monthly Bank Reconciliation Template
The monthly bank reconciliation helps analyzing and adjusting the differences between the cash balance shown on a bank statement, and the amount shown in the account holder's records. This matching process involves making allowances for payments issued but not yet presented, and for payments deposited but not yet cleared or credited. This is intended to be a simple and practical tool to be adjusted and used by SMEs working in all sectors. You may adapt it to reflect your business needs, type of clientele, products and services you offer.
File Description: The file contains a Microsoft Excel spreadsheet template. Once you've downloaded the file, you must copy it to your EXCEL\XLSTART directory in order to use it.
- 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.
|Monthly Bank Reconciliation Template|