Sage help & support
Setup, support, and ongoing bookkeeping in Sage — the full overview.
Sage · Troubleshooting
Sage 50 bank reconciliation problems (and how to fix them)
If your Sage 50 bank reconciliation won't match, shows a discrepancy, or hasn't cleared in months, it's almost always one of a handful of causes. Here's how to find the difference — and how we fix it for good.
(805) 219-7294Quick answer
A Sage 50 reconciliation that won't match is almost always a wrong opening balance, a duplicate or missing entry, a wrong-dated transaction, or an edited prior entry. Check the opening balance first, then tick each statement line — that finds most differences. Stuck or months behind? We rebuild it.
Start here
Common causes of a Sage 50 reconciliation that won't match
Work through these in order — one of them is almost always the culprit.
Wrong opening balance
The reconciliation's opening balance doesn't match last month's cleared balance — everything after it will be off.
Duplicate transactions
A payment or deposit entered twice (often once manually and once via bank feed) throws the total off.
Wrong-dated entries
A transaction dated in the wrong period sits outside the statement window you're reconciling.
Edited or deleted history
A previously reconciled transaction was later changed or deleted, breaking a prior period.
Missing bank fees / interest
Charges or interest on the statement that were never entered in Sage 50.
Transposed figures
A simple digit swap — 54 entered as 45 — creates a difference divisible by nine.
Fix it
How to clear the discrepancy
Check the opening balance
Confirm it equals last month's final cleared balance. If not, fix that period first.
Tick line by line
Match each statement line to Sage 50, flagging anything missing, duplicated, or wrong-dated.
Hunt the usual suspects
A difference divisible by nine hints at a transposition; a round number often means a whole entry is missing or doubled.
Correct & re-reconcile
Fix the offending entries (and any broken prior period), then complete the reconciliation so it ties to the bank.
When to get help
Stuck, or months behind?
If a prior reconciliation was broken, or several months have gone un-reconciled, the difference can compound and become hard to trace on your own. That's routine work for us — we rebuild the reconciliations, correct the underlying entries, and get every account tying out to the bank again.
Questions
Sage 50 reconciliation — FAQs
Why won't my Sage 50 bank reconciliation match?
The usual causes are duplicate or missing transactions, entries dated in the wrong period, a changed or deleted transaction from a prior reconciliation, an incorrect statement opening balance, or uncleared items that were never matched. Working through these in order almost always finds the difference.
My Sage 50 reconciliation is off by a small amount — why?
Small discrepancies are often bank fees or interest not yet entered, a transposed figure (for example 54 entered as 45), or a payment entered twice. A quick review of transactions around the statement date usually pinpoints it.
How do I fix a Sage 50 reconciliation discrepancy?
Confirm the opening balance matches last month's cleared balance, compare each statement line to Sage, look for duplicates and wrong-dated entries, and check whether a previously reconciled transaction was later edited or deleted. Once the offending entries are corrected, the reconciliation clears.
Can you fix months of un-reconciled Sage 50 accounts?
Yes. We regularly rebuild reconciliations that are months behind or that drifted out of balance — correcting the underlying entries and reconciling each period until every account ties out to the bank.
More Sage help
Related Sage guides
Sage 50 cleanup & catch-up
Fix out-of-balance files, reconciliations, and months of backlog.
Sage 50 common errors
Won't open, can't open your file, activation and update errors — fixed.
Free consult
Can't get Sage 50 to reconcile?
Book a free 30-minute call. We'll find the discrepancy, fix the cause, and get your accounts tying out again.
Reviewed by the Northline team — QuickBooks Certified ProAdvisors & Sage Certified · Updated September 2026