What Is Bank Reconciliation? Statement, Template & Example

Bank reconciliation is the process of comparing the transactions recorded in your company’s accounting records with those shown on your bank statement to make sure both balances match.

It helps businesses detect errors, identify unrecorded transactions, prevent fraud, and maintain an accurate view of cash flow. A complete bank reconciliation usually involves reviewing the bank reconciliation statement, identifying common differences, adjusting the cash book and bank statement where needed, and confirming that the final balances agree. In this guide, you’ll learn:

• What Is Bank Reconciliation?

• Importance of Bank Reconciliation

• What is a Bank Reconciliation Statement?

• How to Reconcile a Bank Statement (Step-by-Step)

• Bank Reconciliation Statement Template and Format

• Bank Reconciliation Example

• Bank Reconciliation Formula and Journal Entries

• Common Bank Reconciliation Differences

• How Automation Helps With Bank Reconciliation

What Is Bank Reconciliation?

Bank reconciliation is the process of comparing the transactions recorded in your company’s accounting records with those shown on your bank statement to ensure both balances match and your cash position is accurate.

In simple terms, the meaning of bank reconciliation is verifying that the amount of cash recorded in your books reflects what is actually available in your bank account. If the balances do not match, the difference is usually due to timing differences, missing transactions, bank fees such as card processing fees, or recording errors.

The purpose of bank reconciliation is to identify and resolve these differences so that financial records remain complete and reliable. This process is typically performed at regular intervals (such as monthly) and forms a core part of maintaining accurate accounting records.

By performing bank reconciliation regularly, businesses can detect discrepancies early, maintain accurate financial data, and ensure they have a reliable view of their cash position.

Importance of Bank Reconciliation

The importance of bank reconciliation lies in its ability to ensure accurate financial records, detect discrepancies, and maintain control over a company’s cash flow. Without regular reconciliation, errors and mismatches can go unnoticed, leading to financial mismanagement, fraud risks, and compliance issues.

Error detection

Bank reconciliation helps identify duplicate transactions, incorrect entries, and missing deposits before they impact financial reporting. Detecting these issues early prevents inaccuracies and avoids compounding errors over time, ensuring reliable financial reporting.

Fraud prevention

Regular reconciliation makes it easier to spot unauthorized transactions, forged checks, or unusual withdrawals. By comparing bank activity with internal records, businesses can quickly detect suspicious activity and take corrective action.

Accurate cash flow visibility

Reconciliation ensures that the cash balance in your books reflects reality. Without it, businesses may overestimate available cash, leading to poor financial decisions or unexpected cash shortages.

Compliance and audit readiness

Maintaining accurate and up-to-date financial records is essential for meeting tax and regulatory requirements. Regular bank reconciliation helps ensure consistency, reduces audit risks, and prevents potential penalties.

Avoiding overdrafts and fees

By tracking all transactions accurately, reconciliation reduces the risk of issuing payments with insufficient funds. This helps avoid overdraft fees and protects relationships with vendors and suppliers.

In short, bank reconciliation is a core financial control that improves accuracy, reduces risk, and gives businesses confidence in their financial data.

What Is a Bank Reconciliation Statement?

A bank reconciliation statement is a document prepared by a business to explain the difference between the balance shown in its cash book and the balance shown on its bank statement on a specific date.

In simple terms, the bank reconciliation statement shows why the two balances do not match and what adjustments are needed to reconcile them. These differences are usually caused by timing differences, unrecorded bank transactions, or errors in the company’s accounting records.

The purpose of a bank reconciliation statement is to help businesses confirm that their financial records are accurate and complete. It provides a clear summary of the items affecting the reconciliation process and shows how the adjusted balances are brought into agreement.

A bank reconciliation statement is typically prepared at the end of an accounting period, such as monthly, after comparing the company’s internal records with the latest bank statement. Once all valid differences are identified and adjustments are made, the final balances should match.

It is important to note that a bank reconciliation statement is different from a bank statement. A bank statement is issued by the bank and shows account activity, while the bank reconciliation statement is prepared by the business to identify discrepancies and document the reconciliation.

How to Reconcile a Bank Statement (Step-by-Step)

Knowing how to reconcile a bank statement is a core part of maintaining accurate accounting records. The bank reconciliation process involves comparing your internal financial records with your bank statement, identifying differences, and making the adjustments needed so that both balances match.

Follow these bank reconciliation steps to complete the process accurately.

What Documents Do You Need for Bank Reconciliation?

Before you begin, gather the documents and records needed for the reconciliation process. These typically include:

• your latest bank statement

• your cash book or general ledger

• records of outstanding checks

• records of deposits in transit

• details of bank fees, direct debits, interest income, or returned payments

• the previous bank reconciliation, if available

Having these documents ready makes it easier to compare transactions, identify discrepancies, and complete the reconciliation without missing important items.

Step 1: Compare opening balances

Start by checking that the opening balance in your cash book matches the opening balance on your bank statement for the same period. If the balances do not match, review the previous reconciliation and look for any unresolved discrepancies or incorrect carry-forward balances.

Step 2: Match all transactions

Compare the deposits, withdrawals, checks, transfers, and other payments recorded in your books with those shown on the bank statement. Mark off each matching transaction as you go so you can quickly see which items have already been accounted for.

Step 3: Identify discrepancies

Look for transactions that appear in one record but not the other. Common bank reconciliation differences include deposits in transit, outstanding checks, bank fees, direct debits, interest income, and recording errors.

Step 4: Record missing entries

Update your accounting records for any items that appear on the bank statement but have not yet been entered in your books. These may include bank charges, interest earned, automatic payments, returned payments, or corrections to previously recorded amounts.

Step 5: Adjust the balances

Once all differences have been identified, calculate the adjusted balances. Timing differences such as deposits in transit and outstanding checks affect the bank side, while missing or incorrect entries must be adjusted in the company’s books. After these adjustments, the final balances should match.

Step 6: Verify and document the reconciliation

Review the reconciliation carefully to confirm that all adjustments are accurate and both balances now agree. Once the reconciliation is complete, document it clearly so there is a record of the differences identified and the actions taken.

How Often Should You Reconcile a Bank Statement?

Most businesses reconcile their bank statements at least once a month, usually at the end of each accounting period. However, businesses with high transaction volumes, multiple payment methods, or tighter cash flow controls may benefit from reconciling weekly or even daily.

More frequent bank reconciliation helps businesses detect errors sooner, prevent fraud, and maintain a more accurate view of available cash.

Bank Reconciliation Statement Template and Format

A bank reconciliation statement template gives businesses a consistent way to compare the balance in their cash book with the balance on their bank statement and document the adjustments needed to make both records match.

Using a bank reconciliation statement format helps standardize the reconciliation process, reduce manual errors, and make it easier to review discrepancies across reporting periods. It also ensures that timing differences, bank charges, and missing entries are clearly recorded.

A typical bank reconciliation statement template includes two parts: adjustments to the bank statement balance and adjustments to the cash book balance. Once these adjustments are recorded, the final adjusted balances should match.

Bank Reconciliation Statement Format

A standard bank reconciliation statement format usually looks like this:

Bank statement side

Balance as per bank statement: [Amount]
Add: Deposits in transit: [Amount]
Less: Outstanding checks: [Amount]

Adjusted bank balance: [Amount]

Cash book side

Balance as per cash book: [Amount]
Add: Interest income or direct credits: [Amount]
Less: Bank fees and charges: [Amount]
Less: Direct debits, returned payments, or recording errors: [Amount]

Adjusted cash book balance: [Amount]

If the reconciliation has been prepared correctly, the adjusted bank balance and adjusted cash book balance should be the same.

This bank reconciliation statement format helps businesses clearly show where differences come from and how they are resolved during the reconciliation process.

What a Bank Reconciliation Statement Template Should Include

A complete bank reconciliation statement template should usually include:

• the date of the reconciliation

• the closing balance as per bank statement

• the closing balance as per cash book

• deposits in transit

• outstanding checks

• bank fees and charges

• interest income or direct credits

• direct debits or automatic withdrawals

• any corrections for recording errors

• the final adjusted balance

Including these items makes the template easier to use and ensures the reconciliation is accurate, complete, and easy to review.

Bank Reconciliation Example

This bank reconciliation example shows how to reconcile a bank statement step by step by adjusting the bank statement balance and the cash book balance until both amounts match.

A company’s cash book shows a balance of $10,000, while the bank statement shows a balance of $8,500.

The difference is due to the following:

• Outstanding checks: $800

• Bank fees: $200

• Deposits in transit: $500

• Unrecorded payment: $1,600

To complete the reconciliation, the bank statement is adjusted for timing differences, while the cash book is adjusted for transactions that have not yet been recorded in the company’s books.

Bank Reconciliation Calculation

Bank statement side

Balance as per bank statement: $8,500
Add: Deposits in transit: $500
Less: Outstanding checks: $800

Adjusted bank balance: $8,200

Cash book side

Balance as per cash book: $10,000
Less: Bank fees: $200
Less: Unrecorded payment: $1,600

Adjusted cash book balance: $8,200

After adjusting both the bank statement and the cash book, the final balances match at $8,200, confirming that the reconciliation is complete.

This example shows that bank reconciliation works by adjusting both sides separately until the adjusted bank balance and adjusted cash book balance are the same. Timing differences such as deposits in transit and outstanding checks affect the bank statement, while missing or incorrect entries are adjusted in the company’s books.

Bank Reconciliation Formula and Journal Entries

There is no single fixed bank reconciliation formula, but the goal of the process is always the same: the adjusted bank balance and the adjusted cash book balance should match.

A simple way to think about the bank reconciliation formula is:

Adjusted bank balance = Adjusted cash book balance

To arrive at that final matched balance, businesses adjust each side separately.

Bank Reconciliation Formula

In practice, the formula works like this:

Bank statement side
Bank statement balance

• Deposits in transit
  – Outstanding checks
  = Adjusted bank balance

Cash book side
Cash book balance

• Interest income or direct credits
  – Bank fees and charges
  – Direct debits, returned payments, or errors
  = Adjusted cash book balance

If the reconciliation has been prepared correctly, the adjusted bank balance and adjusted cash book balance should be equal.

Bank Reconciliation Journal Entries

Not every item in a bank reconciliation requires a journal entry.

Timing differences such as deposits in transit and outstanding checks usually do not need journal entries, because those transactions have already been recorded in the company’s books. They simply have not yet appeared on the bank statement.

Journal entries are usually needed for items that appear on the bank statement but have not yet been recorded in the cash book.

Common examples include:

Journal entry for bank fees

If the bank charges a fee that has not yet been recorded, the journal entry would be:

Debit: Bank charges expense
Credit: Cash

This reduces the cash balance in the company’s books and records the expense.

Journal entry for interest income

If the bank adds interest income that has not yet been recorded, the journal entry would be:

Debit: Cash
Credit: Interest income

This increases the cash balance in the books and records the income.

Journal entry for a direct debit or automatic payment

If the bank processes an automatic payment that is missing from the cash book, the journal entry would depend on the nature of the payment. For example:

Debit: Utilities expense
Credit: Cash

This records the expense and updates the cash balance.

Journal entry for a returned payment or NSF item

If a customer payment is returned by the bank, the journal entry may look like this:

Debit: Accounts receivable
Credit: Cash

This reverses the cash receipt and restores the amount owed by the customer.

Journal entry for a recording error

If a transaction was recorded incorrectly in the company’s books, a correcting journal entry is needed to fix the amount or account used. The exact entry will depend on the type of error identified during reconciliation.

In short, the bank reconciliation process uses a simple formula: adjust the bank statement balance, adjust the cash book balance, and confirm that both final balances match. Journal entries are only required for items that have not yet been recorded or were recorded incorrectly in the company’s books.

Common Bank Reconciliation Differences

Bank reconciliation differences are common and do not always mean something is wrong. In many cases, they reflect timing differences between when a transaction is recorded in the company’s books and when it appears on the bank statement. In other cases, they may be caused by missing entries, duplicate records, or incorrect amounts.

Understanding these common bank reconciliation differences makes it easier to identify the cause of a mismatch and resolve it quickly.

Outstanding checks

Outstanding checks are payments that have been recorded in the cash book but have not yet cleared the bank. This is one of the most common bank reconciliation differences and usually reflects a timing issue rather than an accounting error.

Deposits in transit

Deposits in transit are amounts received and recorded in the company’s books but not yet reflected on the bank statement. Like outstanding checks, these are normal timing differences that are usually resolved once the bank processes the transaction.

Bank fees and charges

Bank fees, card processing fees, and other service charges often appear on the bank statement before they are recorded in the company’s books. If these charges are not entered promptly, they can create discrepancies between internal records and the bank balance.

Interest income and direct debits

Banks may automatically add interest income or process direct debits, loan payments, or subscription charges without those entries being immediately reflected in the cash book. These unrecorded items are a common cause of reconciliation differences.

Missing, duplicate, or incorrect entries

Manual processes can lead to missing transactions, duplicate entries, or incorrect amounts in the books. These errors can make reconciliation more time-consuming because finance teams must investigate the source of the mismatch before adjusting the records.

Unapplied or misapplied payments

Payments that are not matched correctly to invoices can create confusion during reconciliation. Unapplied credit, partial payments, short payments, or cash posted against the wrong invoice may cause balances to appear incorrect even when cash has already been received.

Delayed reconciliation

When reconciliation is delayed, more transactions build up between review periods, making it harder to trace differences and identify the reason balances do not match. This increases manual work and raises the risk of missed or unresolved discrepancies.

These bank reconciliation differences show why the process can become complex as transaction volumes increase. The more payments, bank entries, exceptions, and timing issues a business handles, the harder it becomes to reconcile manually and maintain a consistently accurate cash position.

How Automation Helps With Bank Reconciliation

As transaction volumes grow, manual bank reconciliation becomes harder to manage, more time-consuming, and more prone to errors. Automation helps businesses streamline the reconciliation process by reducing manual matching, improving visibility, and making it easier to identify and resolve differences quickly.

Automated cash application

One of the biggest challenges in reconciliation is ensuring that incoming payments are matched to the correct invoices. Automated cash application helps solve this by matching receipts to open invoices in real time, reducing unapplied or misapplied payments and improving reconciliation accuracy.

Faster identification of discrepancies

Automation makes it easier to detect common bank reconciliation differences such as missing entries, incorrect amounts, duplicate transactions, and unrecorded bank charges. Instead of relying on manual review, finance teams can quickly identify mismatches and investigate exceptions before they affect reporting.

Better handling of timing differences and exceptions

Timing differences such as deposits in transit and outstanding checks are a normal part of reconciliation, but they still need to be tracked correctly. Automated workflows help finance teams monitor these items more consistently while also flagging exceptions such as short payments, overpayments, returned payments, or duplicate records.

Reduced manual work

Manual reconciliation often involves repetitive tasks such as downloading statements, comparing transactions line by line, and updating records by hand. Automation reduces that workload, helping teams complete reconciliations faster and freeing up time for higher-value finance work.

Real-time visibility into cash and receivables

When bank data, payment activity, and accounting records are connected, teams gain a more accurate and up-to-date view of cash flow. This improves decision-making and helps businesses monitor outstanding balances, payment activity, and reconciliation status more closely.

More accurate payment tracking

Digital payment methods and connected systems improve visibility into the status of incoming payments. This makes it easier to understand what has been paid, what is still outstanding, and what needs follow-up, reducing the risk of mismatches caused by delayed or incomplete payment information.

Scalable reconciliation processes

As a business grows, the volume of transactions, customers, and exceptions increases. Automation makes bank reconciliation more scalable by helping teams maintain accuracy and consistency without increasing manual effort at the same pace.

Tools like Upflow help support this process by improving payment matching, reducing unapplied cash, syncing with accounting systems, and giving finance teams better visibility into accounts receivable activity. This helps businesses reconcile faster, resolve discrepancies sooner, and maintain more accurate financial records as they scale.

FAQs