Bank Reconciliation Template 2023


This is the new 2023 version of the bank reconciliation template. Key changes include:

  • New layout, including room for headers and bank and GL account names.
  • The ability to do both 1-to-1 matching along with 1-to-many and many-to-many matches.
  • It will check for duplicates and if there are any, the 1-to-1 matching will be disabled.

The trial version for this file is available here and for more in-depth examples of how the file works, please refer to this post.




Streamline your bank reconciliation process with our ultimate Bank Reconciliation template.

This powerful tool automatically matches transactions, saving you time and effort. With a user-friendly interface, you can easily manually match transactions using the intuitive user form. Our template also checks for duplicates and prevents automatic matching when duplicates are present, ensuring accuracy in your records.

Customize matching rules to suit your needs, whether it’s a 1-to-1, 1-to-many, or many-to-many basis. Generate instant reports summarizing outstanding items with just a click.

This Excel template is designed to maximize efficiency, helping you save time and complete your bank reconciliations effortlessly. Take control of your financial management today. You can also test it out before buying with the trial version.