How to reconcile in Xero, and what the green tick does not tell you

What does reconciled actually mean in Xero?

Reconciled means a line on your bank feed has been matched to a transaction in your Xero file, and both are now treated as the same event. It is a statement about one line. It is not a statement about the period, the balance or the accuracy of anything else.

That distinction is where most of the trouble starts. A file can show every line reconciled and still be wrong, because the reconciliation only confirms that somebody accounted for each bank line somehow. It does not confirm that the transaction chosen was the right one, that the amount belongs in this financial year, or that nothing is missing. If your bank reconciliation is out, everything is out, and a screen full of green is not proof that it is in.

A green tick means somebody clicked something. It does not mean the period is closed.

Should I use Match, Create or Transfer?

Use Match when the transaction already exists in Xero, Create only when it genuinely does not, and Transfer when the money moved between two accounts you own. Getting this choice right prevents almost every duplicate we are asked to clean up.

1. Match. The invoice or bill is already in the file, so the bank line just needs pairing with it. Xero suggests matches, but it suggests on amount and date, so it will happily offer you the wrong invoice from the same customer for the same round figure. Check the reference before you accept.
2. Create. This posts a brand new transaction from the bank line. It does not look for the bill you entered last week. Using Create on a payment for a bill already in the file records the cost twice, claims the GST twice, and leaves the original bill sitting in your payables looking unpaid.
3. Transfer. Money moving from your business account to your savings account is one movement seen from both ends. Recorded as a transfer once, it clears both lines. Recorded as an expense on one side and income on the other, it inflates your turnover and your costs by the same amount and lands in your reported sales.

The one to watch. Find Match is the tab people never open. When the payment does not match cleanly because the customer paid three invoices in one deposit, Find Match is where you allocate the deposit across all three. Reaching for Create instead is what creates the phantom income.

Why does my Xero balance not match my bank statement?

Almost always because a transaction exists in Xero that never happened at the bank, or happened on a different date. The bank feed is a record of what the bank did. Xero holds both what the bank did and what somebody entered by hand, and the gap between the two is where the difference lives.

Work through it in this order:

1. Run the Bank Reconciliation Summary for the account and read the statement balance against the Xero balance.
2. Look at the unreconciled items list. Payments entered manually and never matched to a feed line are the most common cause.
3. Check for transactions dated outside the period, especially anything dated in a prior financial year.
4. Check the account has no gap in the feed. A feed that dropped for a few days leaves a hole nothing can be matched into. Refresh the feed first, because it only imports transactions the bank has cleared and a recent line may simply not have arrived. If one is genuinely missing, export those dates from your online banking and import them, or build a small CSV for the few that are absent. See identify and fix missing bank transactions at Xero Central.
5. Only then start looking for duplicates.

A file where the two balances agree to the cent is worth more than a file where every line is ticked.

How do bank rules help, and where do they hurt?

A bank rule automates a transaction you code the same way every time, which is genuinely useful for rent, bank fees, insurance and subscriptions. The cost is that a rule repeats its instructions exactly, including the wrong account code and the wrong tax rate, on every future transaction that fits the pattern.

Two habits keep rules safe. Set the rule narrowly, so it matches on the payee and a tight amount rather than on a loose keyword that catches unrelated payments. Then review your rule list once a quarter, because a rule written two years ago is still applying two-year-old assumptions to this month's transactions. If you have just corrected a coding error in your chart of accounts, check whether a rule is about to reintroduce it.

What about Stripe, Square and PayPal?

Payment platforms deposit net of their fee, so the bank line will never equal the invoice. Reconciling that deposit against the invoice as though it did understates both your income and your costs.

The deposit needs splitting: the gross amount against the invoice, and the fee coded to merchant fees as an expense. Xero lets you add the fee as a second line during reconciliation, so this is a habit rather than a workaround. Getting it wrong does not just misstate your profit, it understates the fees you are entitled to deduct.

The same principle applies to a batch payment leaving your account. One bank line covers several supplier bills, so it reconciles against the batch, not against each bill separately. Our post on batch payments in Xero covers the mechanics of building the batch in the first place.

How often should I reconcile?

Weekly, in about ten minutes, for most small businesses. Not because ten minutes a week is less time in total than an afternoon a quarter, but because you still remember what the payments were. A deposit from four months ago with no reference on it is a research project. The same deposit last Tuesday is a five second decision.

Weekly also means the number on your dashboard is true, and you can make a decision on it. Quarterly means you find out in October how March went.

The four report check before you rely on a file

When we open a Xero file for the first time, four reports tell us where we stand, in this order:

1. Bank Reconciliation report. Every line reconciled, and the closing balance agrees with the bank statement to the cent.
2. Wages Payable. Nil after the most recent pay run has been paid out.
3. GST and PAYG liability. Agrees with the last lodged activity statement to the cent.
4. Balance Sheet, bank accounts. Agrees with the latest statement to the cent.

If those four agree, the file will carry weight with a lender, an accountant and the Australian Taxation Office. If they do not, the reports built on top of them cannot be right, however tidy the reconciliation screen looks.

Those four reports are all in your own file, and running them costs you a quarter of an hour. If the answers point at something structural rather than a habit, our Xero tune-up and repair session is built for exactly that: finding the cause in your own file rather than a demo one, and showing you the fix.

Book a Call Today