Offshore BookkeepersPowered by StealthAgentsPlan my role

Bookkeeping Operations

What a bank reconciliation exception count can and cannot prove

A research brief on reconciliation exception counts, separating an open item from a control failure and a clean reconciliation from an accurate ledger.

A research brief on reconciliation exception counts, separating an open item from a control failure and a clean reconciliation from an accurate ledger.
Table of contents

Key takeaways

  • An exception count shows how many items remain unmatched, not why they are unmatched.
  • Separate timing differences, errors, and duplicates before drawing a conclusion.
  • Report the age and the owner of each open item, not only the total.
  • A zero-exception reconciliation is not proof that the ledger is accurate.

A reconciliation shows four open items and a difference of 240 dollars. The bookkeeper carries the difference to a suspense account, marks the reconciliation complete, and moves on. The count looks small; the cause is unknown.

A reconciliation exception count is a useful operational measure and a weak control on its own. This brief examines what the number can show, what it hides, and how to report it.

Defining an exception

An exception is an item that cannot be matched between the bank statement and the ledger at the time of reconciliation. The definition should say whether timing differences, bank fees, and unrecorded items all count.

Write the definition down. A count that changes as the team learns the problem cannot be compared month to month.

What the count can show

The count can show whether the reconciliation has unresolved items and whether the number is growing. It can show where the items sit, by account and by type.

It can support a workload decision when paired with the age of the items. Four new items are a different problem from four items that have been open for three months.

What the count cannot show

The count cannot show why an item is open. A timing difference, a duplicate entry, and a missing invoice all produce one open line.

It cannot show whether the reconciliation was completed honestly. A difference can be forced to zero, and a suspense account can hide items indefinitely.

It also cannot show whether the ledger is accurate. A reconciliation can match every bank line while the coding or the period is wrong.

Methodology and limits

This brief reviews public guidance on internal control, recordkeeping, and small-business operations, and maps it to a private reconciliation record. The sources support documentation and review discipline; they do not set a materiality threshold.

We tested the proposed fields against four common cases: a bank fee, a customer payment posted twice, a cheque that cleared late, and a transfer between accounts. The fields kept those cases distinguishable.

Classify the exception

Record the type: timing, bank error, ledger error, duplicate, or unknown. The type determines the action and the owner.

A report with only a count forces the reviewer to reopen every item. A typed report lets the team fix the recurring causes.

Record the owner and the age

Every open item should have an owner and the date it opened. The age is the field that turns the count into a priority.

Review items older than the agreed window with the client. An item that stays open for a quarter is not a reconciliation issue; it is a records issue.

Review the pattern quarterly

Group the exceptions by type and by source. A cluster of duplicates may indicate a feed problem; a cluster of unrecorded fees may indicate a mapping gap.

Share the pattern with the client and agree on one fix. The count starts the conversation; the pattern is what changes the process.

Bank fees and interest

Fees and interest are common exceptions because they are recorded by the bank first. Add a line to the reconciliation for the expected fees and compare the amount.

Record the fee type. A recurring fee that is never recorded is a mapping gap, not a one-off surprise.

Transfers between accounts

A transfer appears twice, once on each statement. Match both sides and record the pair; a one-sided match is not a complete reconciliation.

If only one side appears, check the timing and the statement date. A transfer recorded in the wrong period creates an exception that looks like a missing payment.

Unrecorded items

An item on the statement with no ledger entry is the most important exception. It may be an unrecorded expense, a duplicated payment, or a bank error.

Record the investigation and the resolution. A count that includes unrecorded items without a note is a list that cannot be acted on.

Reviewer independence

The person who prepared the reconciliation should not be the only reviewer. In a small team, a second bookkeeper or the owner can review the exceptions and the suspense balance.

Record the reviewer and the date. The record does not need to be formal; it needs to show that a second look happened.

Reporting cadence

Review the exceptions at each reconciliation and the pattern monthly. The monthly pass groups by type and by client account.

Keep the same definitions. A count that changes shape cannot show whether the process improved.

A worked example

A reconciliation has six exceptions. Two are bank fees that were not recorded, two are customer payments that cleared late, one is a duplicate, and one is unknown.

The fees are recorded, the payments are matched to the next period, the duplicate is removed, and the unknown item is assigned. The count drops to zero, and the type data shows two process fixes for the next month.

Suspense accounts

A suspense account is not a solution. If items are held there, the report should show the balance, the age, and the owner.

Review the suspense balance monthly and clear what can be cleared. A growing balance is a sign that the reconciliation is being closed, not completed.

Limits and appropriate use

This brief is a method note, not an empirical study. It does not establish a target exception count or a materiality threshold. Results depend on the quality of the records and the honesty of the classification.

Small entities may have few transactions and a high proportion of timing differences. The count should be read with the type and the age, not as a score.

Conclusion

A reconciliation exception count shows how many items remain open. Used with type, age, and owner, it shows what to fix and what to escalate. Used alone, it invites a false sense of control and rewards a reconciliation forced to zero.

Listed sources

  1. U.S. GAO, Standards for Internal Control in the Federal Government
  2. IRS, Recordkeeping
  3. U.S. Small Business Administration, Manage your business

Related research