PreciseBankFlowPreciseBankFlow home

Reconciliation Off by a Few Cents: Find or Write Off

By PreciseBankFlowPublished March 18, 2026Updated March 18, 2026

A reconciliation off by a few cents usually comes from rounding: interest computed daily, a card fee charged as a percentage, a split payment, or a currency conversion. Check the beginning balance first, then search lines under a dollar. If the gap is still unexplained and stays immaterial, write it off with a dated note, never silently.

Why is a reconciliation off by a few cents?

A reconciliation is off by a few cents when one side computed an amount the other side rounded differently, or when a person keyed a cents figure wrong. Amounts that arrive whole, such as rent or a payroll transfer, almost never cause it. Calculated amounts do.

The bank calculates some figures itself and posts the result. Your books may calculate the same figure independently, from an invoice, a rate or a spreadsheet. When two systems round at different steps, they can land a cent or two apart. Over a month with many such lines, the cents add up to a gap that looks mysterious but has a plain cause.

Keying is the other source. A fee of 2.35 entered as 2.53, or 0.90 entered as 0.09, leaves a gap of a few cents and passes most eyeball checks.

Rounding sources behind a cents-sized reconciliation gap

Rounding sources are entries where an amount is derived from a rate or a split rather than copied from a document. These lines are where the bank and the books are most likely to disagree by a cent. Search them before anything else once the opening balance is confirmed.

  • Interest. Banks often accrue interest daily and post a monthly total. A ledger entry estimated from the annual rate can differ by cents.
  • Percentage fees. Card processors and payment platforms deduct a percentage plus a fixed fee per transaction. Rounding per transaction gives a different total from rounding the batch.
  • Sales tax and split lines. An invoice split across several accounts can lose or gain a cent in the split.
  • Foreign currency. A payment converted at the bank's rate rarely matches a conversion done in the books on another day.
  • Loan payments. Principal and interest splits from an amortisation schedule may not match the lender's split to the cent.

Checking the beginning balance before chasing cents

The beginning balance on this month's reconciliation must equal the ending balance on last month's. If it does not, the few cents you are hunting were inherited, and no amount of searching this month's lines will find them. Compare the two figures before doing anything else.

A gap can be inherited in several ways. A line in a reconciled month was edited or deleted after sign-off. A prior reconciliation was finished with a small unexplained adjustment. Someone typed the opening balance by hand when the books were set up. Each leaves a constant difference that rolls forward.

If the opening figures disagree, fix that first. When the beginning balance does not match the bank statement walks through tracing an inherited difference back to the month it started.

A search order for a few-cents difference

A search order keeps the hunt short. The checklist below uses an example difference of 0.03, with the bank side higher than the books. Work the steps in order and stop once the difference reaches zero.

  1. Confirm the beginning balance equals last month's ending balance.
  2. Foot the bank statement: opening balance plus credits less debits should equal the printed closing balance.
  3. List every statement line with an amount under 1.00, and compare each with the ledger.
  4. Compare interest and fee lines with the ledger to the cent.
  5. Look for percentage-based deductions on merchant deposits and match their net amounts.
  6. Search the ledger for amounts that differ from a statement line by exactly 0.03.
  7. Check whether one entry was recorded twice: a doubled 0.03 fee would explain this example by itself.
  8. If the gap has changed since last month, compare the two reports line by line to see which entry moved.

Step 7 is worth a moment even for tiny amounts. A duplicate small fee is rare, but a duplicate large entry offset by another error is not, and a deposit recorded twice explains how that shows up.

When can a few-cents reconciliation difference be written off?

A few-cents reconciliation difference can be written off when you have searched in good faith, the amount is clearly immaterial, and the write-off is documented. It should be a visible journal entry with a description and a date. It should never be a silent edit to a cleared line.

Set the threshold in your close policy before you need it, per account and per month, and require a reviewer's initials on any write-off. Book it to a miscellaneous or rounding expense account, not to cash over and short if your business has one for tills, since that account means something different.

The note should say what you searched, what remained and why you stopped. That gives the next reviewer a reason to trust the write-off, and it gives you a starting point if the gap grows. Two months in a row of the same small write-off means the cause is still in the books.

When a cents gap on the reconciliation is a warning sign

A cents gap is a warning sign when it is the net of two larger errors. An unrecorded 512.40 check and a 512.37 payment booked twice leave 0.03 between them, and a write-off would bury both. The small number tells you the size of the net, not the size of what went wrong.

Watch for these signals:

  • The gap changes month to month even though nothing should have changed.
  • A large ledger line has no match on the statement, but the total still almost agrees.
  • The difference reappears after you write it off.

Auditors who need comfort over receivables at year end often look at cash received after the period, and subsequent receipts testing can surface a receipt that went missing from the books. On the bank side, PreciseBankFlow proves every statement foots before matching and lists unmatched lines with their amounts, so offsetting errors appear as separate items instead of a single small net.

All posts in Finding reconciliation errors