Excel spreadsheet template for bank reconciliation

Excel spreadsheet template for bank reconciliation

This article provides detailed Excel spreadsheet for bank reconciliation templates that you can download now.

Microsoft Excel software under a Windows environment is required to use this template

These Excel spreadsheet for bank reconciliation templates have been running on all versions of Excel since 2007.

Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information.

To be able to use these models correctly, you must first activate the macros at startup.

The download folder has two different Excel spreadsheet for bank reconciliation templates:

Cashbook & Bank Reconciliation Template

This template enables users to record deposit and withdrawal transactions for multiple bank accounts and automatically produces a monthly cashbook report and a bank reconciliation. The cashbook report can be compiled for any 12 month reporting period by simply entering the appropriate start date in a single input cell and the report can be viewed on an individual account or consolidated basis. The 30 default accounts that are included on the report can be customized and an unlimited number of additional accounts can be added if required. The template also accommodates petty cash transactions and sales tax calculations.

• Template Excel bank reconciliation