Reconciled Balance: A Beginner’s Guide

A reconciled balance is an account balance that has been compared with an independent source and explained as of a specific date. For a bank account, the book balance is adjusted for supported corrections and compared with the statement balance after accounting for valid timing differences such as outstanding checks and deposits in transit.

“Reconciled” does not mean the bank balance and accounting balance must display the same number at every moment. It means the difference can be reproduced from dated, supported items and the final comparison has been reviewed. The reconciliation belongs to an account, entity, currency, and period.

Book balance, bank balance, and reconciled balance

A live online balance is not always the statement balance. It can include transactions after the close date or pending activity. Use a complete statement for the defined period and retain it with the reconciliation.

Simple reconciliation formula

A common bank-side calculation starts with the statement ending balance, adds deposits in transit, subtracts outstanding payments, and adjusts for confirmed bank errors. A book-side calculation starts with the ledger balance and records items such as bank fees, interest, returned payments, or accounting errors. The adjusted bank and adjusted book amounts should agree.

For example, assume a statement ends at $28,400. A $3,200 customer deposit was recorded on the last day but cleared the next month, while $1,150 of issued checks remained outstanding. The adjusted bank balance is $30,450. If the ledger shows $30,475 and a $25 bank fee has not been recorded, posting the supported fee brings the book balance to the same $30,450.

The $3,200 and $1,150 are timing items. The $25 fee is a book correction. Mixing those categories makes follow-up difficult and can result in duplicate entries next month.

How to produce a reconciled balance

1. Select the exact account, legal entity, currency, and statement period.
2. Obtain the complete external statement from an authorized source.
3. Confirm the beginning balance agrees with the prior completed reconciliation.
4. Compare deposits, payments, transfers, fees, interest, and other activity.
5. Record supported book-side items that are missing or incorrect.
6. List valid timing differences without posting duplicate transactions.
7. Research unexplained differences to source documents and the audit trail.
8. Confirm the adjusted amounts agree and the software difference is zero.
9. Save the statement, reconciliation report, support, and approvals.

When several months are behind, begin with the oldest complete statement. A later balance depends on every earlier period, so combining months can hide when a discrepancy arose.

What can remain outstanding?

An item may remain outstanding when it is valid in the books but has not appeared on the external record by the closing date. Common examples include a mailed check, an electronic payment initiated near month-end, a deposit made after the bank’s cutoff, or a transfer still moving between accounts.

Outstanding does not mean permanent. Carry each item into the next reconciliation and confirm that it clears. Age old items, assign owners, and investigate stale checks, rejected payments, reversed deposits, duplicate transactions, and possible unclaimed-property obligations.

Why a reconciliation difference appears

• The statement ending date or balance was entered incorrectly.
• A transaction is missing, duplicated, or posted to the wrong account.
• An amount, date, sign, or currency is wrong.
• A downloaded transaction was added instead of matched.
• A prior reconciled transaction was edited or deleted.
• A transfer was recorded as income or expense.
• A check or deposit was marked cleared in the wrong period.
• The opening balance was never established correctly.

Research exact amounts first, then compare deposits and withdrawals separately. A difference that is divisible by nine may suggest transposed digits, but it is only a clue. Correct the underlying supported transaction rather than posting an unexplained balancing entry.

Does zero mean the account is correct?

A zero reconciliation difference is necessary, but it does not prove every classification is correct. A customer receipt posted as owner contribution can clear the bank and still misstate revenue and equity. A loan payment recorded entirely as expense can clear while misstating debt and interest.

After reaching zero, review unusual, large, related-party, round-dollar, and suspense transactions. Confirm transfers have both sides, deposits have a business purpose, and withdrawals have receipts, approvals, or other support.

Reconciled balance in accounting software

QuickBooks, Xero, and other systems may display a reconciled, cleared, statement, or current balance. These labels are product-specific. Read the current product guidance and determine which transactions each number includes before relying on it.

Imported bank data can speed matching, but it is not the independent control by itself. The preparer still needs the statement period, opening balance, ending balance, outstanding-item review, and evidence that exceptions were resolved.

Reconciliation adjustments

A reconciliation adjustment should not be the routine method for reaching zero. First test the statement details, prior-period changes, missing activity, duplicates, wrong accounts, wrong dates, transfers, and opening balance. If a residual adjustment is justified, document the cause, account, date, amount, materiality, approver, and financial-statement effect.

Review recurring adjustments as a process problem. They may reveal poor bank-feed matching, delayed transaction entry, unclear ownership, weak access controls, or an incomplete month-end calendar.

Other reconciled balances

The same principle applies beyond cash. Accounts receivable should reconcile the customer-detail aging to the general ledger. Accounts payable should reconcile vendor detail and statements to the liability account. Payroll liabilities should reconcile payroll reports, tax filings, payments, and ledger balances.

Debt balances can be reconciled to lender statements and amortization schedules. Fixed assets can be reconciled to the asset register. Payment-processor and marketplace clearing balances can be reconciled from gross sales through fees, refunds, reserves, and cash payouts.

Reconciliation documentation

• Account, entity, currency, period, and statement source.
• Beginning, ending, book, and adjusted balances.
• Detailed outstanding items with dates and expected resolution.
• Support for fees, interest, corrections, transfers, and adjustments.
• Explanation of any prior-period change.
• Preparer and reviewer names with completion dates.

The reviewer should be able to reproduce the reconciled balance without relying on the preparer’s memory. Store the final version in the close package and protect it from silent replacement.

Monthly control checklist

Confirm every expected statement arrived, every high-risk account was reconciled, differences reached zero, outstanding items were aged, unusual classifications were reviewed, and required approvals were completed. Track missing reconciliations centrally so an account cannot disappear from the close merely because it has little activity.

How reviewers can test the balance

A reviewer should obtain the statement independently or confirm its source, compare the account and dates, recalculate the reconciliation, and inspect selected outstanding items. Trace book-side corrections to source evidence and the ledger. Look for entries posted after the preparer finished, because a saved reconciliation can become stale when the account changes.

Reviewers should also compare old outstanding items with the next statement. A supposedly valid timing difference that never clears may be a duplicate, stopped payment, rejected deposit, wrong account, or stale obligation. Document the conclusion, supporting evidence, resolution date, and any follow-up owner rather than simply carrying the item forward again.

Continue with how to reconcile accounts in QuickBooks or review a month-end checklist in Excel. Businesses needing recurring reconciliations can explore bookkeeping services.