Six Signs Your Xero File Has Drifted, and What to Do About Each One

By Jeme Ann Bregente, CPA (Philippines), Camellia Consulting · Sources checked 24 October 2026

A bank feed that is fully reconciled does not prove a Xero file is right. Transactions can be matched to the wrong account, coded with the wrong GST, or left sitting in suspense for months, and none of it shows on the dashboard. These six checks, each with the Xero report that shows it, are where we start with a New Zealand file. Where a check turns up something that affects GST or a filed return, the owner and their New Zealand tax adviser decide how it is corrected.

1. The bank balance in Xero does not match the statement

Run the Bank Reconciliation Summary for each account at month end and compare the statement balance in Xero with the closing balance on the actual bank statement. They should agree exactly. If they do not, look for missing or duplicated statement lines or deleted transactions. Then check that the difference between the statement balance and the balance in Xero is explained by genuinely outstanding items, and that nothing has been reconciled to the wrong line.

Find the first month where they stop agreeing and work forward from there. A balancing journal makes the numbers agree and hides the cause.

2. The suspense account keeps growing

Most files have an account where unclear items go. A small balance is normal. One that grows every month means questions are not getting answered.

Open Account Transactions for that account and sort by date. Send the owner one list of questions each month and clear what comes back. Items more than a couple of months old are much harder to explain.

3. Bank rules are coding things they should not

A rule written for one supplier often catches others. GST is where this hurts: a rule that applies 15% GST can wrongly claim GST on interest or on bank charges that are exempt financial services. Not every bank charge is exempt, so check what each one is.

Review the list of bank rules, then run Account Transactions for the accounts those rules post to, filtered by tax rate. Narrow the rules so they match on more than one condition. If miscoded transactions fall in a period already filed, ask the tax adviser whether to correct them in a later return or amend the earlier one before changing anything in that period.

4. The GST account does not reconcile to the returns

Reconcile the GST control account to the returns filed, the payments and refunds, and the current unfiled period, using the GST Reconciliation report alongside the balance sheet. Differences can come from transactions changed after a return was filed, payments coded elsewhere, opening balances, the GST accounting basis or manual adjustments. Each one needs an explanation, not a journal.

Once a return is filed, set the lock date and restrict who can change it. Any authorised change to a filed period should then be reviewed for its GST effect.

5. Old items in receivables and payables

Invoices from last year still showing as owing, credit notes never applied, supplier bills paid twice. Run Aged Receivables and Aged Payables, oldest first, and match payments to invoices.

A debt that will not be collected needs the owner’s approval to write off, with the evidence kept. If you account for GST on an invoice basis, ask the tax adviser whether the debt qualifies for a GST adjustment; being overdue is not enough on its own.

6. Payroll liabilities that do not reconcile

PAYE, KiwiSaver, ESCT and other deductions should reconcile to what is due to Inland Revenue for each period. A balance on these accounts can be correct if it relates to a period not yet due. Amounts still there after their payment date are the ones to investigate.

Match each payment to the deductions due for the period it covers, then reconcile the total to the employment information filed and to the employer’s myIR account. Employers filing electronically send employment information within two working days of payday; filing and payment have separate deadlines.

Keeping it from drifting again

• Reconcile weekly rather than at month end.
• Review bank rules every quarter.
• Set lock dates after each GST return.
• Keep one running list of questions for the owner and clear it monthly.

Clean-up time depends on the number of transactions and the records available. If someone is doing it for you, ask for a separate scope and fee before work starts.

Handing the file over

Before giving any bookkeeper access, agree who approves corrections, which Xero permissions they need and how payroll and customer information will be protected. Use individual logins and multi-factor authentication.

Our outsourced bookkeeping for New Zealand businesses keeps Xero reconciled weekly, and our checklist of what a monthly bookkeeping package should include shows what to expect from any provider.

Camellia Consulting is a tax and accounting firm in the Philippines. We are not a registered tax agent in New Zealand, we do not file with Inland Revenue, and this article is not tax advice.

Sources

• Xero Central, help articles on the Bank Reconciliation Summary, GST Reconciliation report, bank rules and lock dates
• Inland Revenue, GST guide: Working with GST (IR375)
• Inland Revenue, Payday filing

All checked 24 October 2026.