Bank Reconciliation Template

This Bank Reconciliation Template is designed for financial controllers, accounting managers, and bank reconciliation professionals who want to streamline their month-end close process for bank reconciliations. Whether you're working in a small business or a large company, this template will help you ensure accuracy, identify discrepancies, and maintain financial integrity.

Read our full overview on what’s involved in bank reconciliations here. ‍

What is Bank Reconciliation?‍

Bank reconciliation is the process that helps you ensure your company's accounting records match your bank statements. It's a core account reconciliation and a way to double-check that the money you think you have matches what's in your company’s bank account. This process is crucial for performing accurate financial reporting and managing cash flow effectively.

Bank reconciliations can be classified into two main types: month-end and ongoing. 

Month-end Bank Reconciliation

As a key part of the balance sheet reconciliation process, month-end bank reconciliations are performed at the end of each month to ensure that all bank transactions for the period are accounted for. This process involves matching the bank statement with the company's general ledger account balance, identifying discrepancies, and making necessary adjustments. We’ll dive deeper into how to perform this recon below.

Ongoing Bank Reconciliation

Ongoing bank reconciliations are conducted more frequently, such as weekly or even daily, to maintain real-time accuracy in financial records. These reconciliations typically involve live transaction matching between an accounting system and a live feed from a financial institution, and reduce the risk of errors and fraud. 

Early fraud detection is critical to mitigating harm to an organization, which is why reconciliation and data monitoring processes are so important. According to a report by the Association of Certified Fraud Examiners, account reconciliation and automated transaction/data monitoring were found to be the quickest ways to stop fraud in its tracks.

‍

How to Use This Template‍

This Bank Reconciliation Template is designed to be customizable.

Template Purpose: Summarize reconciling items between bank statements and general ledger balance.
Template Sources: Bank statement from "XYZ Bank", listing of Deposits in Transit and Checks Outstanding maintained by the accounting team.

Process Overview

Bank Reconciliation at month-end typically involves referencing:

1. The trial balance from your GL account
2. Your bank statements
3. Any additional reconciling items (deposits in transit, checks outstanding, etc.)

If your general ledger balance matches the bank statement balance, you may very well not need this template! In those cases, the bank statement may be uploaded directly as a reconciling source. Here’s a deep dive on bank reconciliation that breaks down this process in greater detail.

That being said, in some situations the necessary detail for bank recons isn’t pulled into your GL or, due to business nuance, you may want to manage bank reconciliations manually.

If that’s the case, then make a copy of this template and follow these procedures:

1. During the month, ensure that any manual checks issued are added to the "Checks Outstanding" tracker
2. On the last day of the month, evaluate any deposits recorded in the general ledger that may not have yet cleared the bank
3. When available (usually the first or second business day of the month), download the bank statement and update the "Balance per Bank" for the month
4. Analyze any remaining variance between GL and Bank that’s not explained

If using Numeric: Add this sheet as a reconciliation source for bank recs and we’ll automatically pull in the trial balance from your GL and the total in this worksheet from the tab labeled "Numeric" for you to tie out each month.

If not using Numeric: each month-end you’ll cross reference worksheet totals & your downloaded trial balance to reconcile the account. Delete the tab labeled "Numeric".

See a full list of account reconciliation templates here.

What's Included in This Template

This template is built for accounting teams that need a structured, reliable way to reconcile bank accounts at month-end. It includes six tabs, each serving a distinct purpose in the bank reconciliation workflow.

Tabs

• Cover & Instructions: An overview of the template's purpose, data sources, and step-by-step instructions for how to use it. New users should start here. You can also reference the instructions above.
• Numeric: A data tab used specifically by teams using Numeric. It automatically pulls in the GL trial balance and worksheet totals for monthly tie-out. Teams not using Numeric should either delete this tab or use it to record your own GL balance at each month-end.
• Bank Recon: The main reconciliation worksheet. This is where the GL balance and bank statement balance are compared and all reconciling items are summarized. The fields in this tab should update as you continue to fill out your Deposits in Transit and Checks Outstanding.
• Reconciling Items →: This tab is not functional and you will not need to populate it. The tab serves as a divider, indicating that the two tabs to the right — Deposits in Transit and Checks Outstanding — contain reconciling item detail. 
• Deposits in Transit: A tracker for deposits recorded in the GL that have not yet cleared the bank. Update this tab throughout the month as deposits post and clear.
• Checks Outstanding: A tracker for checks issued but not yet cleared the bank. Updated throughout the month as checks are issued and cleared.

Key Fields

The Bank Recon tab includes the following fields:

• Company name and GL account number
• Period end date
• Balance per Bank (pulled from the bank statement)
• Reconciling items (including deposits in transit and outstanding checks) with space to add additional items as needed
• Balance per GL (the cash account balance from the general ledger trial balance)

The Deposits in Transit and Checks Outstanding tabs each include:

• GL Reference (transaction identifier)
• GL Posting Date
• Amount
• Memo (description of the transaction)
• Bank Posting Date
• Cleared (yes/no indicator)
• Reconciling Month

Underlying Formulas

The Bank Recon tab calculates the reconciliation using the following logic: 

• Balance per GL = Balance per Bank + Deposits in Transit − Checks Outstanding.
• Each component of the equation corresponds to a line item in the Bank Recon template, with the final Balance per GL confirming whether the account reconciles.
• Outstanding check and deposit aging is tracked by GL Posting Date and Reconciling Month in the Deposits in Transit and Checks Outstanding Tabs, making it easy to identify items that have not cleared within the expected timeframe.

Status Logic and Outputs

The core logic of the Bank Recon tab is straightforward: 

• Balance Per GL: The Balance per Bank and Reconciling Items fields are adjusted for deposits in transit and outstanding checks. This determines the Balance per GL. 
• Reconciled: If the Balance per GL matches the adjusted Balance per Bank, the reconciliation is complete.
• Unreconciled: If a variance remains between the two balances, then one or more reconciling items require investigation and resolution before the period can close.

Remember: The Deposits in Transit and Checks Outstanding tabs serve as the supporting detail behind the reconciling item totals on the Bank Recon tab — each individual item should be logged with enough detail to trace it back to source documentation and confirm when it clears.

A Note on the Numeric Tab

• For teams using Numeric: The Numeric tab allows the platform to automatically pull in the GL trial balance and the worksheet total each month, eliminating the need to manually cross-reference the two. 
• For teams not using Numeric: This tab can be deleted and the monthly tie-out is done manually by comparing the worksheet totals to the downloaded trial balance.

When to Move Beyond Templates

Spreadsheet-based templates are a practical starting point for bank reconciliation. They're free, flexible, and can be used without support from other SaaS tools. But they have limits in terms of automations and function, and knowing when you've hit a wall can save your team significant time and risk.

The data makes the case, according to an article authored by Higher Education Press: More than 90% of spreadsheets used for making business decisions contain errors. This can lead to poor decision making, financial loss, audit errors, and compliance risks, especially for larger organizations with bigger budgets and transaction volume.

Here's a simple framework, broken down by company size, for thinking about when it’s time to move on from a spreadsheet template:

Small Businesses and Early-Stage Companies

A spreadsheet template can work well when transaction volumes are low, the number of bank accounts is manageable, and the accounting team is small enough that one person can own the reconciliation process from start to finish. At this stage, the manual process can be straightforward.

Mid-Sized and Growth-Stage Companies

At this stage, a template becomes a bottleneck rather than a tool. As transaction volume increases, the manual effort required to maintain a spreadsheet-based reconciliation process grows proportionally — which means the error rate does too. Mid-sized companies typically benefit from automated bank and ledger reconciliation that can match transactions at scale, flag exceptions automatically, and route items to the right reviewer without manual coordination.

Enterprises and Multi-Entity Organizations

Enterprise accounting teams generally require full-scale account reconciliation solutions with deep Enterprise Resource Planning (ERP) integration, multi-entity support, and audit-ready documentation built into the workflow. Spreadsheet templates are simply not designed for this level of complexity, which can be troublesome for reconciliation and auditing practices.

Knowing When to Re-evaluate Reconciliation Methods

If your team is spending more time maintaining the template than reconciling the accounts, it's probably time to evaluate what's next.

Many teams find that as they grow, they naturally shift toward continuous reconciliation that takes place throughout the month rather than in one concentrated push at month-end. This approach reduces close-time pressure and catches errors earlier; however, it’s difficult to execute reliably with a spreadsheet template alone.

The Bank Reconciliation Process at Month-End

At month-end for the bank reconciliation process, typically teams will:

1. Compare the bank account balance to the cash balance on your company’s balance sheet. The balances will rarely match so don’t be alarmed.
2. Dive into your bank statement to find transactions not yet reflected in your company’s books.
3. Identify transactions recorded on your books that don’t appear on your bank statement — ex. outstanding checks and deposits in transit.
4. Once you’ve identified the discrepancies, make any necessary adjustments.
5. Document the entire reconciliation process.

Across the month, ongoing recs will catch any missing transactions, where then teams can make journal entries with the relevant debits and credits to the general ledger.

The Importance of Bank Reconciliation

The bank reconciliation process plays a pivotal role in producing accurate financial statements as well as establishing solid cash flow management. By understanding and implementing bank reconciliation, you can keep polished financial records, detect any bookkeeping discrepancies, and ensure that your recorded cash balances are precise. 

1. Pinpointing Cash Flow: Bank reconciliation ensures you have a precise understanding of the money flowing in and out of your accounts. Knowing your exact cash position helps you make informed decisions, whether it’s paying a vendor or investing in new equipment. Without reconciliation, you might assume you have more or less money than you actually do, leading to poor financial decisions.
2. Highlight Fraudulent Activity: Regular bank reconciliation helps detect discrepancies that may indicate fraud. For instance, if you notice a check amount that doesn’t match the recorded amount in your books, this could be a sign of tampering. By catching these issues early, you can take corrective actions before they escalate.
3. Accounts Receivable Management: No one wants to leave money on the table – regular reconciliations help to spot invoices that haven’t been paid. Once identified, you can take steps to collect the payments, such as sending reminders or contacting the customer directly. Addressing these problems promptly ensures that your business maintains a healthy cash flow and reduces the risk of bad debts.

By incorporating this Bank Reconciliation Template into your month-end close workflows, you can streamline your reconciliation efforts, reduce the risk of errors, and ensure the accuracy of your financial records.

How Numeric Helps with Bank Reconciliation

• Stay on top of month-end bank reconciliations with AI scanning of bank statements: For month-end bank recs, teams can pull account balance totals automatically from their bank statements with AI and the trial balance from their GLs. To add, prior period balance monitoring catches any changes since accounts were reconciled. 

• Stay organized and audit-ready with clear controls and documentation: Numeric makes it easy to assign tasks to preparers and reviewers, and keeps track of all comments, changes, and submissions in a clear month-end close checklist. When audit time rolls around, auditors can log straight into Numeric and see a complete activity trail, no need for your team to spend hours resurfacing required documentation.

FAQ