There was $47,600 sitting unresolved in the Xero file.
The business had not lost $47,600, and there was no single transaction that explained the balance. It was a pool of duplicate, unmatched and unexplained items that had accumulated across several workflows.
In this illustrative case study, a nine-person IT services business generates approximately $1.6 million in annual revenue. It invoices recurring support, sells hardware occasionally and receives some customer payments through an external payment processor.
The scenario shows why reconciliation problems rarely arrive as one obvious error. They build quietly.
What “unreconciled” actually means
Bank reconciliation compares the accounting records with independent evidence of what happened at the bank.
If the bank says $500 left the account, the books should contain the corresponding transaction. If the books say $2,000 was received, there should be a corresponding deposit or a documented reason it has not cleared.
Accounting software can import transactions and suggest matches. That makes the process faster, but it does not remove the distinction between categorising a transaction and establishing that the records agree.
Categorisation asks: what type of transaction is this?
Reconciliation asks: does the accounting record agree with independent evidence?
The business needed both.
How the $47,600 built up
$18,900 came from duplicated transactions
The business had reconnected a bank feed after a short interruption and imported a CSV covering part of the same period. Transactions from the overlapping dates entered the file twice.
Because the duplicate items included ordinary supplier payments, fuel, software and bank charges, no single amount looked obviously wrong. The pattern became visible only when transaction dates, values and descriptions were compared across the two sources.
Automation repeated the data accurately. The setup allowed the same underlying activity to enter twice.
$14,200 came from customer receipts posted as new income
Several customer invoices already existed in Xero. When the cash arrived, the bank receipts were coded to sales instead of being matched against those invoices.
The economic event was effectively represented twice: once by the original invoice and again by the bank receipt.
Cash at bank remained real, but revenue and receivables no longer told a reliable story.
$9,700 sat in a payment-processor clearing account
The business received settlements net of processing fees. Sales, fees and settlement deposits were not being mapped consistently, leaving $9,700 in a clearing account.
The bank showed the net cash received. The processor reported the underlying customer payments and fees. The accounting file needed to connect those two records rather than treating the bank deposit as the complete transaction.
A clearing account is temporary by design. If it carries an old balance, the workflow has stopped before the full economic event has been recorded.
$4,800 required evidence before it could be resolved
The remaining $4,800 included recent timing items, transfers and entries for which supporting records were not yet available.
Not every outstanding item was an error. Some were legitimate differences between when an accounting entry was recorded and when cash cleared.
Age and evidence mattered. A transfer from yesterday is different from an unexplained item that has remained open for nine months.
Why a green screen can create false confidence
Accounting software is designed to make administration faster and clearer. The risk appears when speed is mistaken for proof.
A transaction can be assigned to the wrong account while the bank still reconciles. A transfer can be treated as revenue. A payment can be matched to the wrong invoice. A duplicate can exist elsewhere in the ledger. An old manually created transaction can remain outstanding while a separate bank-feed item has already been processed.
The interface can look complete while the accounting story underneath it remains unresolved.
How the problem should be traced
- Establish the external truth. Start with bank, card and processor statements rather than assuming Xero is correct.
- Compare closing balances. Confirm that the statement balance and accounting balance relate to the same date and account.
- Isolate old items. Separate ordinary timing differences from exceptions beyond a reasonable clearing window.
- Check for duplicates. Compare source, date, amount and description—especially after imports or feed changes.
- Trace invoices and payments. Determine whether cash was matched to an existing transaction or recorded again.
- Reconstruct processor settlements. Connect gross customer payments, fees, refunds and net deposits.
- Document the correction. A journal without an explanation may balance the file while making it harder to understand later.
The last step matters. Clean-up work should reduce future uncertainty, not simply move it to another account.
Check this in your own Xero file
Compare Xero with the actual bank statement
Does the statement balance agree for the same account and date? If not, start with the earliest point at which the records diverge.
Look at the age of unresolved items
Recent timing differences are normal. Items sitting unresolved for months deserve an explanation.
Search for duplicate amounts
Repeated supplier, date and amount combinations are worth checking after bank-feed changes or manual imports.
Review transfers between your own accounts
Moving money between two business accounts is not income or an expense merely because it appears in a bank feed.
Reconcile payment processors separately
Understand the path from customer payment to processor balance, processing fees and bank settlement.
Ask one direct question
For every material old item: what exactly is this?
If nobody can answer without guessing, it remains an exception.
How the problem is prevented
The sustainable fix is not a large clean-up at BAS or year end. It is regular reconciliation with exceptions separated from routine processing.
Routine items can move quickly. Unusual transactions should remain visible until the relevant evidence or business context is available. At month end, the reviewer should be able to see what remains unresolved, why it remains unresolved and who owns the next action.
That is how a $100 exception stays a $100 exception instead of becoming a $47,600 case study.
Sources and further reading
- How to do bank reconciliation — Xero ↗
- What is bank reconciliation? — Xero ↗
- EOFY reconciliation guide — Xero ↗
This article is not tax, accounting or financial advice for your circumstances. Accounting treatment depends on the facts of a transaction and the requirements applying to the business. Seek professional advice before making a material accounting or tax decision.