Now accepting new clients! Get Started

Tax Glossary

Reconciliation Discrepancy: Causes and Fixes

Learn what causes a reconciliation discrepancy, how to trace changed or missing transactions, and why unexplained adjustments can hide bookkeeping errors.

A reconciliation discrepancy is an unexplained difference between a financial statement or other independent record and the corresponding balance or activity in the accounting records. The term can also describe a beginning-balance difference caused when a previously reconciled transaction is later changed, deleted, duplicated, or moved.

A discrepancy is a signal to investigate. It is not itself an expense, income item, or permanent adjustment category.

Key warning Entering an adjustment to force a zero difference before the cause is identified can hide omitted revenue, duplicate expenses, personal purchases, payroll errors, or unauthorized transactions.

Timing difference or bookkeeping error?

Not every difference is an error. A bank reconciliation can properly include an outstanding check or deposit in transit. Those are timing differences: the books recorded the transaction, but the bank had not processed it by the statement date.

An actual discrepancy may arise from:

  • A transaction entered for the wrong amount or date
  • A cleared transaction that was deleted
  • An entry moved to another bank or credit card account
  • A duplicate created by a bank feed
  • A transfer posted on only one side
  • A missing fee, interest item, refund, or returned payment
  • The wrong statement balance or ending date
  • An opening-balance entry created during setup
  • Several accounts combined incorrectly
  • Currency, conversion, or data-import issues

The response depends on the cause. Timing items are documented and carried forward. Book errors are corrected.

How to investigate a discrepancy

Begin with the last period known to be correct. Confirm the statement, ending date, and ending balance used. Then:

  1. Compare the saved reconciliation report with the current ledger.
  2. Look for changes to previously cleared transactions.
  3. Review the audit log or change history if available.
  4. Search the discrepancy amount and likely combinations of amounts.
  5. Check for duplicate imports and one-sided transfers.
  6. Confirm that the transaction belongs to the correct entity and account.
  7. Inspect opening-balance, suspense, uncategorized, and reconciliation-adjustment accounts.
  8. Trace the entry to the bank or card statement and supporting document.
  9. Correct the original classification or enter a dated correction with a clear explanation.
  10. Reperform the reconciliation and retain the investigation notes.

Do not assume the newest transaction caused the problem. A current-period alert may reflect an edit to a much older reconciled item.

Reconciliation discrepancy example

The consulting business completed June with a zero difference. In August, the beginning balance is $450 lower than expected.

The audit history shows that the June $450 equipment payment was moved from Checking to a different bank account during cleanup. The expense or asset side of the original entry still exists, but the cash side no longer appears in the reconciled checking ledger.

The appropriate fix is based on what actually happened:

  • If Checking truly paid the vendor, restore or correct the transaction in Checking.
  • If the other bank account paid it, the June reconciliation and possibly that account's reconciliation must be revised using the real statement activity.
  • If it was a transfer or owner-paid expense, record the complete transaction according to the evidence.

Entering a new $450 "reconciliation expense" may make the screen agree, but it would duplicate the economic effect and could distort taxable profit.

Why forced adjustments are risky

A reconciliation adjustment is not automatically wrong. A small historical difference may sometimes require a documented correction when source records cannot be recovered and professional judgment supports the treatment.

The risk is using an adjustment before investigating. A plug can hide omitted revenue, duplicate expenses, personal purchases, payroll errors, loan balances, or unauthorized transactions. It can also create an artificial deduction or income amount.

Materiality, age, available evidence, entity type, tax impact, and financial-statement purpose all matter. When the cause remains unknown, document the limitation and obtain qualified review.

Reconciliation discrepancy vs. reconciliation difference

During an active reconciliation, the software may display a "difference" equal to statement balance minus selected cleared activity. That number changes as transactions are matched and should reach zero when the period is complete.

A "reconciliation discrepancy" often refers to a problem carried into the process or created after an earlier reconciliation. Software uses the labels differently, so focus on the facts: which balance changed, when, and why?

Federal and California tax connection

Neither the IRS nor California FTB treats "reconciliation discrepancy" as a general deductible category. Tax returns must be supported by records that clearly show income and expenses. If resolving a discrepancy uncovers omitted income, duplicate expense, personal activity, fixed assets, payroll, or an incorrect liability, the tax treatment follows the underlying transaction.

Corrections affecting a previously filed year may require a tax-return review. Not every book correction changes tax; some move amounts between balance-sheet accounts or correct timing without changing taxable income.

Retain the original statement, prior reconciliation, audit history, correction entry, and supporting documents. California FTB guidance emphasizes records that document transactions and support filed returns.

Common mistakes

  • Entering a plug before identifying the cause
  • Deleting reconciled transactions
  • Changing old dates to make items disappear
  • Treating an opening-balance problem as current expense
  • Ignoring a recurring discrepancy because it is small
  • Correcting one side of a transfer but not the other
  • Failing to assess whether a prior tax return is affected
  • Allowing unrestricted edits to closed periods
Heath Income Tax

Heath Income Tax can help Santa Maria and Central Coast businesses trace reconciliation differences, clean up prior periods, and establish dependable monthly bookkeeping.

Frequently asked questions

Can I delete a reconciliation discrepancy?

Do not delete the signal without resolving the underlying entries. Trace the difference, correct the records, and preserve the audit trail.

Why did a discrepancy appear after I reconciled?

A previously reconciled transaction may have been edited, deleted, moved, or had its cleared status changed.

Can I use a reconciliation adjustment?

Only after reasonable investigation and with documentation. An unexplained adjustment can conceal a larger accounting or tax problem.

Does every discrepancy change taxable income?

No. The effect depends on the underlying transaction. Some corrections affect cash and another balance-sheet account without changing profit.

Related terms

Official sources

The definitions and examples on this page are for informational purposes only and do not constitute tax advice. Tax laws change frequently and individual circumstances vary. Consult a qualified tax professional before making decisions based on this content.