Bank Reconciliation Calculator: Formula, Example and Monthly Checklist

Bank Reconciliation Calculator: Adjusted Bank and Book Balance

A bank reconciliation calculator turns the figures from your statement and ledger into two adjusted balances, then shows the difference between them. Enter your numbers above to finish the arithmetic of your monthly bank reconciliation in under a minute.

Quick answer: Enter the statement balance and its adjustments on the bank side. Enter the ledger balance and its adjustments on the book side. When the two adjusted balances are equal, the account is reconciled, and that figure is your reconciled balance.

How to Use the Bank Reconciliation Calculator

1. Enter the closing balance per bank statement. Use the balance on the last day of the period.
2. Add the bank-side items. Enter deposits in transit, outstanding cheques and any bank error.
3. Enter the closing balance per your books. Use the ledger balance for the same date.
4. Add the book-side items. Enter interest, collections made by the bank, bank charges, bounced cheques and any book error.
5. Read the result. The calculator shows both adjusted balances and the unreconciled difference.

Your figures stay in your browser. Nothing is uploaded or stored.

Which Field Does Each Item Belong In?

Use this table to avoid putting an item on the wrong side.

Bank Reconciliation Formula

The bank reconciliation formula has two halves that must end at the same number.

Adjusted Bank Balance Formula

> Adjusted bank balance = balance per bank statement + deposits in transit − outstanding cheques ± bank errors

Adjusted Book Balance Formula

> Adjusted book balance = balance per books + bank credits not yet recorded − bank debits not yet recorded ± book errors

Unreconciled Difference Formula

> Unreconciled difference = adjusted bank balance − adjusted book balance

A difference of zero means you reconciled the account. Any other figure means an item is missing, wrong or on the wrong side.

Bank Reconciliation Example With Calculation

This bank reconciliation statement example shows the calculator inputs for a month-end. All amounts are in rupees.

The Facts

• The bank statement closes at 58,300.
• The ledger shows 55,935.
• Two deposits are in transit: 6,000 and 3,200.
• Three cheques are outstanding: 8,000, 4,500 and 2,000.
• The bank wrongly debited 1,500 from your account.
• The bank credited 840 interest.
• The bank collected 3,000 from a customer by NEFT.
• The bank charged 410 in fees.
• A customer cheque for 5,000 bounced.
• You entered a receipt of 1,350 as 1,215.

Step-by-Step Calculation

Bank side

Book side

Both sides reach 54,500, so the unreconciled difference is zero.

Journal Entries for the Book-Side Items

• Debit Bank 840 and credit Interest Income 840.
• Debit Bank 3,000 and credit the customer's account 3,000.
• Debit Bank Charges 410 and credit Bank 410.
• Debit the customer's account 5,000 and credit Bank 5,000.
• Debit Bank 135 and credit the customer's account 135.

The deposits in transit and outstanding cheques need no entry. Contact the bank about the 1,500 error, and expect it to reverse on a later statement.

How to Calculate Bank Reconciliation Discrepancies

When the unreconciled difference is not zero, use the number itself as a clue.

Divide the Difference by 9

If the difference divides evenly by 9, you probably transposed digits. For example, entering 540 as 450 creates a difference of 90.

Divide the Difference by 2

A payment recorded as a receipt, or the reverse, creates a difference of twice the amount. Halve the difference and search your records for that figure.

Search for an Exact Match

If the difference equals one amount on the statement, you probably missed that item, or recorded it twice. Look in the "bank only" list and the duplicates.

Check the Opening Balance

Confirm that this month's opening balance equals last month's reconciled closing balance on both sides. A mismatch means someone changed a closed period.

Let the Tool Find It

The calculator cannot see your transactions. If the clues above do not solve it, upload both documents to the bank reconciliation tool, which lists every item on one side only.

Bank Reconciliation Statement Format

Present the finished calculation in a format a reviewer can sign off.

Two-Column Format

List the bank side and the book side next to each other, as in the example above. Auditors prefer this layout, because it shows both adjusted balances at once.

Single-Column Format

Start with the bank balance and list adjustments until you reach the book balance. This layout works for accounts with few reconciling items.

What Every Statement Should Include

• Account name and number
• Statement date
• Both adjusted balances
• Preparer's name and date
• Reviewer's name and date

Monthly Bank Reconciliation Checklist

Use this checklist each month.

• Confirm the opening balances match last month's reconciliation.
• Match every bank line to a ledger entry.
• List deposits in transit and outstanding cheques.
• List bank-only items such as fees, interest and bounced cheques.
• Run the calculator and check that the difference is zero.
• Post journal entries for the book-side items.
• Follow up on cheques outstanding for more than a few months.
• Sign, date and file the reconciliation.

A person who does not handle receipts or payments should prepare or review the reconciliation. That separation of duties makes errors and misuse easier to spot.

Finding the Reconciling Items Automatically

The calculator does the arithmetic, but the slow part of reconciliation is finding the items in the first place. Upload your bank statement and ledger above and every transaction is compared. The tool lists items only on the statement and only in the ledger with their amounts. The book-to-bank check then confirms whether those items explain the whole difference.

See the bank reconciliation tool for supported files and a step-by-step monthly guide, or read how transactions are matched. To compare a statement against a cash book line by line, use the bank statement vs ledger comparison.