How to clean up a clearing account in Xero
A clearing or “undeposited funds” account that never returns to zero is one of the most common Xero messes. Here’s why it grows, and how to clear it back to zero without breaking your bank reconciliation.
What it’s for — and how it goes wrong
A clearing account is meant to be temporary: money sits there briefly on its way between two places, then clears. The trouble starts when an integration routes every payment through it but the offsetting entry never gets made. Entries accumulate, the balance climbs, and after a year or two it’s a graveyard that no longer means anything — while quietly inflating your books.
Clear it back to zero, safely
- 1. Work on a copy. Investigate on an export, not the live file — a clearing account is easy to make worse.
- 2. Match against the bank. For each entry, find the real bank movement and the invoice or bill it relates to.
- 3. Move the misfiled. Payments that belong in a real bank account get moved there, keeping the invoice link.
- 4. Reverse the leftovers by name. Genuine phantoms get an offsetting, referenced entry — not a blanket write-off that hides what happened.
The Stripe connection
If your clearing account is fed by a payment processor, the root cause is often batched payouts that were never decomposed. That has its own fix — see the Stripe payouts guide.
Years of build-up in there?
Extrua Reconcile empties a clearing-account graveyard on a read-only copy, every change evidenced.
FAQ
What is a clearing account meant to do?
It's a temporary holding account — money lands there briefly on its way between two places (say, a payment processor and your bank). Used properly it should return to zero regularly.
Why does my clearing account keep growing?
Usually an integration routes every payment through it but the offsetting side is never recorded, so entries pile up for months or years. The balance becomes meaningless and inflates your accounts.
How do I clear it back to zero?
Match each entry to the real bank movement and invoice it relates to, move misfiled payments to the right account, and reverse genuine leftovers by name — never with a single blanket write-off that hides the detail.