Reconciliation

Reconciliation compares independent records or balances, explains every difference, and documents the corrections or timing items needed to reach agreement.

Reconciliation is the control process of comparing two records or independently derived balances, identifying every difference, and documenting the correction or timing explanation needed to bring them into agreement. A completed reconciliation shows not only that totals match, but why they match and who reviewed unresolved items.

Reconciliation does not mean changing one record until the numbers agree. Valid reconciling items must be supported, errors must be corrected in the record where they occurred, and old exceptions must be investigated.

Key Takeaways

  • The two sides should come from meaningfully independent records, such as a subledger and general ledger or a bank statement and cash ledger.
  • Every difference needs a source, amount, date, owner, and expected resolution.
  • Timing differences are not journal entries unless the entity’s own records are incomplete or wrong.
  • Bank statements, customer confirmations, and vendor statements are not edited by the company to force agreement.
  • Preparation and independent review should be timely and evidenced.
  • Automated matching reduces manual work but does not validate poor source data or unexplained exceptions.
  • Reconciliations support completeness, existence, valuation, cutoff, and fraud-detection controls, but do not prove all assertions by themselves.

Common Reconciliation Types

ReconciliationRecords comparedTypical reconciling items
BankBank statement or confirmation vs. cash ledgerDeposits in transit, outstanding payments, fees, interest, errors
Subledger to general ledgerCustomer, vendor, inventory, payroll, or fixed-asset detail vs. control accountUnposted batches, duplicate entries, mapping errors, write-offs
IntercompanyReceivable, payable, revenue, expense, and funding records between group entitiesTiming, currency, markup, settlement, and entity-code differences
InventoryPhysical counts and movement records vs. inventory ledgerShrinkage, receiving cutoff, unit-of-measure errors, obsolete stock
DebtLender statements and contracts vs. debt ledgerPrincipal, accrued interest, fees, foreign exchange, covenant adjustments
Tax and payrollReturns, remittances, and agency records vs. ledgerAccrual timing, withheld amounts, payments, assessments, and amendments
Financial-statement roll-forwardOpening balance plus activity vs. closing balanceAcquisitions, disposals, remeasurement, reclassification, and translation

The frequency should reflect risk, transaction volume, close deadlines, and the consequences of error. Daily cash or trading reconciliations can be necessary, while a low-volume account may be reconciled monthly or quarterly.

Worked Example: Bank Reconciliation

At month-end, a company’s cash ledger shows $147,300 and its bank statement shows $151,900. Review identifies:

  • outstanding checks issued by the company: $9,200
  • deposit recorded by the company but not yet credited by the bank: $5,400
  • customer electronic payment on the bank statement but not in the ledger: $1,100
  • bank service fee not yet recorded in the ledger: $300

Bank Side

Bank-side reconciliationAmount
Balance per bank statement$151,900
Add deposit in transit+$5,400
Subtract outstanding checks-$9,200
Adjusted bank balance$148,100

The company does not post entries for the deposit in transit or outstanding checks because both are already in its ledger. They are timing differences in bank processing.

Ledger Side

Book-side reconciliationAmount
Balance per cash ledger$147,300
Add customer electronic payment+$1,100
Subtract bank service fee-$300
Adjusted ledger balance$148,100

The company records the missing bank activity:

1Dr Cash                          $1,100
2  Cr Accounts Receivable                  $1,100
3
4Dr Bank Fee Expense                $300
5  Cr Cash                                    $300

Both adjusted balances now equal $148,100. The reconciliation should retain evidence for the electronic receipt and fee, list the outstanding items, and confirm that they clear after month-end.

A Strong Reconciliation Workflow

  1. Define the account, period, source records, and expected frequency.
  2. Obtain complete source data without silently excluding unmatched items.
  3. Verify opening balances and prior-period unresolved items.
  4. Match transactions using amount, date, reference, counterparty, currency, and other relevant fields.
  5. Investigate differences rather than labeling them miscellaneous.
  6. Record valid corrections with approval and supporting evidence.
  7. List timing items with expected clearing dates.
  8. Recalculate the bridge and agree the adjusted balances.
  9. Have a qualified reviewer challenge old, unusual, manual, or high-value items.
  10. Track exceptions to resolution and retain the preparation and review evidence.

The preparer and reviewer should be identifiable. A signature without evidence of review is weaker than documented questions, follow-up, and resolution.

Reconciling Items vs. Errors

DifferenceTypical treatment
Valid timing differenceDocument and monitor until it clears
Missing entity transactionRecord a journal entry in the entity’s books
Duplicate or incorrect entity entryCorrect or reverse the entity’s entry
Bank, vendor, or counterparty errorContact the external party and track correction
Unsupported differenceEscalate; do not carry indefinitely as a plug
Difference below an administrative thresholdApply policy, but still consider aggregation, fraud, and qualitative risk

A reconciling item should not remain open merely because it repeats each month. Persistent differences can indicate broken interfaces, duplicate records, unrecorded liabilities, fraud, or poor cutoff.

Automation and Data Quality

Reconciliation software can match large transaction volumes, enforce workflows, age exceptions, and retain approvals. It can also produce false confidence when:

  • both records originate from the same flawed data source
  • matching tolerances are too wide
  • many-to-one matches hide duplicate transactions
  • users override exceptions without evidence
  • stale items are automatically rolled forward
  • interface failures omit transactions from both sides

Controls should cover source completeness, matching rules, access, overrides, exception reporting, and changes to automation logic.

Common Mistakes and Limitations

  • Treating a trial balance that mathematically balances as a completed reconciliation.
  • Adjusting an external statement rather than correcting the record that is wrong.
  • Posting journal entries for valid timing differences already recorded in the ledger.
  • Clearing differences to a miscellaneous account without investigation.
  • Carrying old reconciling items forward indefinitely.
  • Allowing the preparer to approve their own high-risk reconciliation without oversight.
  • Reconciling two reports produced from the same incomplete source.
  • Assuming automation removes the need for exception review.
  • Ignoring individually small items that are material in aggregate or indicate control failure.

This page is educational and does not provide accounting, audit, fraud-investigation, tax, banking, legal, or investment advice.

FAQs

Does a reconciliation require both balances to be identical before adjustment?

No. Legitimate timing differences can exist. The reconciliation must explain them and show that both records reach the same supported adjusted balance.

Should outstanding checks create a new journal entry?

Usually not when the checks were already recorded in the cash ledger. They remain bank-side timing items until presented or otherwise resolved. Stale checks require separate review under the applicable policy and law.

How often should accounts be reconciled?

Frequency depends on risk, volume, volatility, close needs, and regulatory or contractual requirements. High-volume cash accounts may require daily review, while other accounts may be monthly or quarterly.

Authoritative Sources

  • Bank Reconciliation applies the general process specifically to cash records and bank evidence.
  • Bank Statement is an external source used in cash reconciliation.
  • Accounts Payable should reconcile vendor and invoice detail to the general-ledger control account.
  • Inventory requires quantity, cost, movement, and physical-count reconciliations.
  • Imprest System uses a fixed authorized balance and replenishment controls for specified cash funds.
Browse Accounting