SME Toolkit Logo
Partner Logo
Home  > Monthly Bank Reconciliation Template
 Share  Print Version  Email

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.

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.


Monthly Bank Reconciliation Template
 Share  Print Version  Email
Ratings (0)
If you are a human, do not fill in this field.
Click stars to rate.