Open Xero and look at the number next to your bank account on the dashboard. That's the count of bank transactions nobody has matched yet. Boring Barry says any number is fine "as long as it's reconciled by EOFY". Barry also thinks a receipt photographed on a car dashboard in direct sunlight counts as "digitised". Here is the scale a Sydney bookkeeper actually uses.

Published: October 2026

‍

What Is an Unreconciled Transaction?

Every transaction that hits your bank account comes into Xero through the bank feed. Reconciling it means matching it to the right invoice, bill, transfer or expense, with the right account and GST code.

Until that happens, the transaction is in your bank but not properly in your books. Your P&L and GST figures are incomplete, and your view of how much cash you really have spare is partly guesswork.

‍

The Scale

This scale is our rule of thumb, not an industry standard. It assumes a business with staff and steady transaction volume. A café with 900 card settlements a month and a consultancy with 60 bank lines a month will sit differently, so read the scale against your own volume.

0 to 20: Actually decent

Someone is probably reconciling weekly, and your reports mean something. Don't fire them.

21 to 100: Mid Barry

Likely a few weeks behind. Often fixable in an afternoon, but the GST on those transactions isn't in your figures yet. Salvageable. Barely.

101 to 500: Peak Barry

Possibly a quarter or more behind, depending on volume. Your BAS may be late or prepared from incomplete books, and supplier and customer balances may be unreliable. You're in the danger zone.

500+: Apex Barry

Months behind, maybe more. Reports built on these books can't be relied on, and any BAS lodged from them needs checking. Get a Free Xero Roast.

Take the Roast-O-Meter to see where your current bookkeeper lands.

‍

What a Backlog Costs You

Your BAS is built on missing numbers

Any unreconciled transaction can carry GST. If it isn't coded, its GST isn't in your BAS. Either the BAS is late while someone catches up, or it's lodged on incomplete figures and corrected later.

Your cash position is partly a guess

The Xero dashboard shows two balances. The statement balance comes from your bank feed. The balance in Xero reflects only reconciled transactions. Until they match, what you owe, what you're owed and what's genuinely yours to spend are all uncertain.

Catch-up time grows with age

Recent transactions are quick to match because you remember them. Six-month-old transactions take longer, because someone has to dig through emails, statements and memories to work out what they were.

Hypothetical example: the catch-up maths

Assumptions: a Sydney agency has 480 unreconciled transactions. A transaction reconciled within a week takes 30 seconds. One investigated months later takes 3 minutes. Both times are illustrative.

• Reconciled weekly as they arrive: 480 × 0.5 minutes = 240 minutes, or 4 hours, spread across the weeks they came in
• Caught up months later: 480 × 3 minutes = 1,440 minutes, or 24 hours of work, often just before a BAS deadline

Same transactions, six times the work. That's the Barry tax.

‍

How to Check the Real Size of the Backlog

The dashboard count is a start, not the whole story. Also check:

• The two balances. Compare the statement balance with the balance in Xero for each account. A gap with a low count can mean transactions were reconciled to the wrong place, or deleted.
• The oldest unreconciled line. Five transactions from last week and five from last year are not the same problem.
• Every account. Credit cards, loan accounts, PayPal, Stripe and savings accounts all have their own feeds and their own counts.
• The bank reconciliation report. Run it at the end of the last BAS period to see whether the statement balance and the balance in Xero agreed on that date.
• Items marked as reconciled without a match. Xero lets users mark transactions as reconciled manually. Used carelessly, that hides problems instead of fixing them.

‍

Why Transactions Pile Up

"I'll do it on the weekend"

You won't. Nobody does.

Missing receipts and bills

The bank line is there, but there's nothing to match it to. If supplier bills aren't in Xero, the transaction sits.

Bank rules that never got set up

Rent, software subscriptions and loan repayments happen every month, and Xero bank rules can code them for you. Barry does them by hand and bills by the hour. Draw your own conclusions.

Payment gateways and clearing accounts

Stripe, Square and other gateways pay you net of fees, in batches. Without a clearing account, those deposits won't match your invoices cleanly.

Transfers between accounts

Money moved from your everyday account to savings shows up in both feeds. Unless it's reconciled as a transfer, it sits in both.

‍

Mistakes That Make a Catch-Up Worse

Creating new transactions instead of matching

If an invoice is already in Xero and the customer's payment is reconciled with "Create" instead of matched to that invoice, the income goes in twice.

Hypothetical example: an invoice for $11,000 including GST is already in Xero. The payment is coded as a new $11,000 sale instead of being matched. On the accruals basis, revenue is overstated by $10,000 and GST on sales by $1,000, and the original invoice still shows as owing in your receivables.

Deleting bank statement lines to bring the number down

The count drops, but the money still moved. Those transactions are now missing from your books.

Coding everything to a suspense account

A suspense account is fine for a few days. Months of unexplained items in it means the P&L and the BAS are still missing the real coding.

Ignoring duplicate feed lines

Bank feeds occasionally import the same transaction twice, or a manual statement import overlaps the feed. Reconciling both doubles the figure.

‍

Fixing GST Errors Found During a Catch-Up

A catch-up often turns up GST mistakes in BAS already lodged. The ATO lets you correct some GST errors in a later activity statement, if the error is within time and value limits that depend on your turnover and wasn't caused by recklessness or intentional disregard. Errors outside those limits need the original BAS revised (ATO, Correcting GST errors). Your BAS agent should work out which applies before the next lodgement.

‍

A 20-Minute Weekly Routine

1. Open each bank account in Xero and reconcile the suggested matches.
2. Add any missing bills or receipts, then match them.
3. Create bank rules for anything that will happen again.
4. Reconcile transfers between accounts as transfers.
5. Check the payment gateway clearing account.
6. Note anything you can't identify and ask about it the same week.

‍

How a Sydney Bookkeeper Fixes It

1. Work out the size of the hole. Count unreconciled transactions per account and how far back they go.
2. Get the source documents. Download statements, pull supplier bills and receipts, and export gateway reports.
3. Set up the plumbing. Bank rules for repeat transactions, clearing accounts for gateways, and transfers between accounts.
4. Start with the oldest unlodged BAS period. Fix the periods that affect a BAS first, so lodgements can catch up.
5. Lock periods once they're clean. Set a lock date in Xero once a period is reconciled and lodged, so nobody changes it by accident.
6. Don't let it pile up again. Reconcile weekly.

Our books catch-up service clears the backlog and gets lodgements up to date. After that, monthly bookkeeping with a Sydney bookkeeper keeps the number near zero. More on the habit itself: weekly reconciliation.

‍

FAQ

How many unreconciled transactions is normal in Xero?

It depends on volume. For a business that reconciles weekly, the count is usually small, often under 20. Hundreds usually means the books are well behind.

What happens if I don't reconcile my bank account?

Your P&L, balance sheet and GST figures are incomplete, so your BAS may be late or wrong and your reports can't be relied on.

How often should I reconcile in Xero?

Weekly suits most businesses with staff and regular transactions.

Can I lodge my BAS if my bank isn't reconciled?

You can, but the figures may be wrong. It's better to reconcile the BAS period first.

What is a bank rule in Xero?

A rule that tells Xero how to code a repeat transaction automatically, such as rent or a software subscription.

How long does a catch-up take?

It depends on volume, how far back the backlog goes and whether the source documents can be found. Older transactions take longer, because each one needs investigating. Counting the transactions and their age first gives a realistic estimate.

Can I just delete old unreconciled transactions?

No. Deleting statement lines removes real transactions from your books. Match or code them, and ask your bookkeeper about any you can't identify.

What if the catch-up finds a GST error in a BAS I've already lodged?

Some errors can be corrected in a later BAS, within ATO time and value limits. Larger or older errors need the original BAS revised.

‍

About Sydney Bookkeeper

Sydney Bookkeeper is a fixed-price Sydney bookkeeper for businesses with staff: monthly bookkeeping, BAS lodgement, payroll and Xero clean-ups, with no lock-in.

Books catch-up | BAS lodgement | Free Xero Roast

‍

Legal

The team uses a registered BAS Agent for all BAS and IAS lodgement services. Registration details are available on request. This content is general information only. It is not tax, financial product or legal advice. Information was current at publication and may change.

‍

Sources

• Xero Central, Reconcile and close a period: https://central.xero.com/0/article/Reconcile-a-period
• Xero Central, Set up or remove lock dates: https://central.xero.com/0/article/Set-up-and-work-with-lock-dates
• ATO, Due dates for lodging and paying your BAS: https://www.ato.gov.au/businesses-and-organisations/preparing-lodging-and-paying/business-activity-statements-bas/due-dates-for-lodging-and-paying-your-bas
• ATO, Correcting GST errors: https://www.ato.gov.au/businesses-and-organisations/gst-excise-and-indirect-taxes/gst/in-detail/managing-gst-in-your-business/reporting-paying-and-activity-statements/correcting-gst-errors

‍