Monthly Bank Reconciliation Template
Provided by the International Finance Corporation
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|
Copyright © 2000 - 2017, International Finance Corporation. All Rights Reserved.
2121 Pennsylvania Avenue, N.W., Washington, D.C. 20433, www.ifc.org
The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law. IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon.