Bank Reconciliation Calculator

Bank reconciliation explains why the cash balance in a company’s books differs from the balance on the bank statement. Some differences are timing items. A deposit may be recorded by the company before the bank processes it. A cheque may be recorded in the books before the payee deposits it. Other differences are bank-side activity that the company has not posted yet, such as service charges, interest, automatic payments, NSF cheques, or collections made directly by the bank.

This calculator adjusts both sides and reports the unreconciled difference. It does not try to guess the missing item. Instead, it shows whether the book-side adjustments and bank-side adjustments lead to the same corrected cash balance. When the difference is zero, the reconciliation is arithmetically balanced. When it is not zero, the amount shown is the difference to investigate.

How the calculator works

Start with the cash book balance from your ledger or accounting software. Enter automatic bank payments, bank charges, and NSF cheques as positive amounts in their own fields; the calculator subtracts them from the book side. Enter interest earned and receivables collected by the bank as positive amounts; the calculator adds them to the book side. These items are on the book side because the bank already knows about them, but the company’s records may not.

Next, enter the bank statement balance. Add deposits in transit, meaning deposits recorded by the company but not yet credited by the bank. Enter unpresented cheques, also called outstanding cheques, as positive amounts; the calculator subtracts them from the bank side. These items are on the bank side because the company already recorded them, but the bank statement has not caught up.

The calculator allows positive or negative starting book and bank balances because accounts can be overdrawn. It requires all adjustment fields to be finite numbers. It treats the reconciliation as balanced when the absolute difference is less than half a cent, which avoids false warnings from currency rounding. For cash planning, use this page with the budget calculator, loan calculator, and accounting profit calculator.

Formula

The adjusted cash book balance is:

$\text{adjusted cash book} = \text{cash book balance} + \text{interest earned} + \text{receivables collected by bank} - \text{automatic bank payments} - \text{bank charges} - \text{NSF cheques}$

The adjusted bank statement balance is:

$\text{adjusted bank} = \text{bank statement balance} + \text{deposits in transit} - \text{unpresented cheques}$

The unreconciled difference is:

$\text{unreconciled difference} = \text{adjusted cash book} - \text{adjusted bank}$

Example: using bank reconciliation

Use the default values: cash book balance of $10,000, automatic bank payments of $350, bank charges of $25, NSF cheques of $200, interest earned of $12, receivables collected by bank of $500, bank statement balance of $10,450, deposits in transit of $600, and unpresented cheques of $1,113.

The cash book side is adjusted first:

$\text{adjusted cash book} = 10000 + 12 + 500 - 350 - 25 - 200 = 9937$

The bank statement side is adjusted next:

$\text{adjusted bank} = 10450 + 600 - 1113 = 9937$

The difference is:

$\text{unreconciled difference} = 9937 - 9937 = 0$

The calculator’s primary result is $0.00 and the label says the books and bank agree. The detail panel shows an adjusted cash book balance of $9,937, an adjusted bank statement balance of $9,937, and a reconciliation status of “Balanced.”

Accounting context

A clean bank reconciliation supports the cash number on the balance sheet. It also protects the business. Unreconciled cash can hide duplicate payments, missed deposits, bank errors, unauthorized withdrawals, stale cheques, or accounting entries posted to the wrong account. The reconciliation process is part accounting, part internal control, and part operational discipline.

Sign discipline is the most common problem. Deposits in transit are added to the bank side because they will increase the bank statement when processed. Unpresented cheques are subtracted from the bank side because they will reduce the bank statement later. Bank charges, NSF cheques, and automatic payments reduce the book side because the bank has already taken the money. Interest and bank-collected receivables increase the book side because the bank has already credited the account.

Do not force a difference to zero by entering a plug number. A plug hides the problem and weakens the audit trail. Trace the difference by comparing dates, amounts, cheque numbers, deposit batches, electronic payment references, and bank fees. If the difference equals a familiar amount, look for a duplicate or missing transaction. If it is divisible by nine, check for transposed digits. If it is small but persistent, review rounding and foreign currency conversions.

Tips for a stronger reconciliation

• Reconcile soon after the statement date while supporting documents are easy to find.
• Use the same cutoff date for the book balance and bank statement balance.
• Do not enter the same item on both sides after it has cleared.
• Review old outstanding cheques and deposits in transit for stale or erroneous items.
• Attach bank statements, deposit slips, payment reports, and journal entries to the reconciliation.
• Investigate the unreconciled difference before closing the period or reporting cash.

Sources

• AccountingTools, Bank Reconciliation — bank reconciliation process and common reconciling items.
• AccountingCoach, Bank Reconciliation Explanation — book and bank adjustment examples.
• Corporate Finance Institute, Bank Reconciliation — overview of reconciliation purpose and procedure.