Bookkeeping clean up: checklist, process and pricing in Xero

Short answer: a bookkeeping clean up gets a set of books from “behind or wrong” to “reconciled and trustworthy” up to an agreed date. In Xero it runs in this order: agree the scope and the cut-off, get every statement for every account, prove the opening balance, reconcile each account month by month, fix sales, bills and miscoded transactions, check payroll and tax returns against Xero, review the Balance Sheet line by line, then set a lock date and start the monthly routine. Price it as a separate one-off job, not inside the monthly fee: in the worked example below, nine months behind is 60 hours, quoted at A$4,800 before the monthly fee starts.

Clean up or catch up?

The two words are used loosely, but the work differs:

• Catch-up bookkeeping: the books are behind. Transactions have not been entered or reconciled for some months, but what is there is roughly right. Most of the time goes on reconciling bank lines.
• Clean-up bookkeeping: the books are up to date (or look it) but wrong. Transactions are coded to the wrong accounts, invoices show as unpaid when they were paid, the bank balance in Xero does not match the bank. Most of the time goes on finding and fixing errors.

Most files you inherit need some of both, so the checklist below covers both.

The checklist

#	Step	Done when
1	Agree the scope: which accounts, which months, which returns, and what is out of scope	Written in the engagement letter, with a cut-off date
2	Confirm the last filed period and keep it locked	Lock date at the last year end or return the tax office has
3	Collect every statement for every account that moves money	Bank, cards, loans and payment apps, for every month in scope
4	Fill the gaps in the bank feeds and delete duplicate statement lines	Each account’s statement lines in Xero match the bank’s statements
5	Prove the opening balance against the last final accounts	Xero’s Balance Sheet agrees at the start date
6	Reconcile each account, one month at a time	Statement balance equals Xero’s balance at every month end
7	Clear suspense, “uncategorised” and Historical Adjustment balances	Each is zero, or explained in a note
8	Sales: match receipts to invoices, remove double-counted income	Aged receivables shows only what customers really owe
9	Purchases: match payments to bills, remove duplicates	Aged payables shows only what the business really owes
10	Recode wrongly coded transactions	Each expense and income account holds what its name says
11	Payroll: wages, tax and super or pension in Xero against payroll records	Year-to-date figures agree with the payroll filing
12	Tax: VAT, GST or BAS returns against Xero; fix and file	Every return in scope filed, errors corrected under the tax office’s rules
13	Review the Balance Sheet line by line	Loans, director’s or shareholder loans, assets and tax balances agree with outside evidence
14	Lock the cleaned period and hand over to the monthly routine	Lock date at the cut-off; the first normal month starts

Do the steps in this order. Reconciling before the opening balance is proven means reconciling to the wrong starting point, and recoding before the bank is reconciled means recoding transactions that may later be deleted as duplicates.

The steps in Xero

Scope and cut-off (steps 1 and 2). Agree a cut-off date that is a period end, usually the end of the last complete month or VAT, GST or BAS quarter, so the clean-up has a clear finish line. Leave the lock date on the last period the tax office or the final accounts already have. If an earlier filed year turns out to be wrong, that is a conversation with the client’s accountant, not something to change quietly in Xero.

Statements and feeds (steps 3 and 4). When a bank feed is connected, most banks only send a limited amount of history, so older months usually have to be imported from statement files (OFX or CSV from online banking). Import only the missing date range: overlapping a feed creates duplicate statement lines, which Xero does not merge and you have to delete. Payment apps such as Stripe or PayPal count as accounts too; if their money goes into Xero only as net payouts, the fees and refunds inside them are missing.

Opening balance (step 5). Run Xero’s Balance Sheet (or the trial balance) at the start date and compare it with the last final accounts. The client onboarding checklist has a worked example of this check and the journal that fixes it.

Reconcile (step 6). Work one account and one month at a time, oldest first. Create bank rules for anything that repeats (rent, software, wages, merchant fees) as soon as you see it twice, and check that Xero’s statement balance agrees with the bank statement at each month end before moving on. The bank reconciliation report guide shows how to prove each account, and why your Xero bank balance does not match covers the usual causes when it will not agree.

Suspense and adjustments (step 7). Anything parked during reconciliation has to come out again. The suspense account and Historical Adjustment guides explain where these balances come from and how to clear them.

Sales and bills (steps 8 and 9). Run the aged receivables and payables reports and go through every old item. An invoice that shows as unpaid but was paid usually means the receipt was coded straight to sales instead of matched to the invoice: income is then counted twice. Debts that will not be paid are written off, not left in the report.

Recoding (step 10). For a few transactions, open each one. For many, Xero’s Find and recode tool changes the account, tax rate or tracking on a whole set of transactions at once. It needs the Administrator user role (called Adviser until July 2026; see Xero user roles), and Xero recommends recoding no more than about 200 lines at a time. Check the result with the Profit and Loss by month: a cleaned account should look steady month to month, without one-off spikes.

Payroll and tax (steps 11 and 12). Compare wages, payroll tax and super or pension in Xero with the payroll filings for the same period (the payroll reports guide lists which reports to run). Then compare each VAT, GST or BAS return with Xero’s figures for the same period (VAT return, BAS, NZ GST return). In the UK, a net VAT error from an earlier return can be corrected on the next return if it is no more than £10,000, or up to 1% of that return’s box 6 turnover with a ceiling of £50,000; larger errors are reported to HMRC separately. Australia and New Zealand have their own rules for correcting earlier GST, so check the tax office’s guidance before deciding where a correction goes.

Balance Sheet review (step 13). Every Balance Sheet line should agree with something outside Xero: loans with the lender’s statement (loan repayments in Xero), the director’s loan account (in Australia, a shareholder loan raises Division 7A) with what the owner took and put in, fixed assets with the asset register, and the VAT or GST control account with what is owed on the last return.

Lock and hand over (step 14). Set the lock date at the cut-off, send the client a short summary of what you changed and what they need to do differently, and start the normal monthly close (the month end checklist).

The errors you will find most often

• Income counted twice: an invoice raised in Xero and the customer’s payment coded straight to sales, so both count.
• Transfers coded as income or expenses: money moved between the business’s own accounts, or a credit card paid off from the bank, coded to sales or to an expense instead of as a transfer.
• Whole loan repayments as an expense: only the interest is an expense; the rest reduces the loan.
• Owner’s spending in business expenses: personal costs paid from the business account belong in drawings or the director’s loan, not in the Profit and Loss.
• Duplicate statement lines: from an imported statement that overlaps the feed, or a feed that was reconnected.
• Lines reconciled to the wrong transaction: a bank line matched to the wrong invoice or bill, which leaves both the bank and the aged reports quietly wrong until you remove and redo it.

Worked example: pricing a catch-up

These figures are made up. Kestrel Plumbing Pty Ltd, an Australian business with a business bank account, a credit card and a loan, was last reconciled at 31 January 2026. A new bookkeeper takes it on in November 2026, nine months behind (February to October 2026). About 140 bank and card lines go through each month, and the BAS for the March, June and September quarters still have to be prepared and lodged. The bookkeeper’s rate is A$80 an hour, before GST.

Task	Basis	Hours
Statements, feed gaps and duplicates	3 accounts, 9 months	3.0
Reconcile bank and card lines	1,260 lines at 1.5 minutes each	31.5
Sales: match receipts to invoices, aged receivables	Review of every open invoice	2.0
Purchases: bills, receipts, aged payables	Review of every open bill	2.5
Payroll against the payroll filings	9 months	1.5
BAS: prepare and review	3 quarters at 1.5 hours	4.5
Balance Sheet review and journals	Loan, shareholder loan, assets, GST	3.0
Queries with the owner	Two calls and emails	2.0
Estimate		50.0
Contingency (20%)	Missing statements, errors found on the way	10.0
Quote		60.0

At A$80 an hour, 60 hours is A$4,800 plus GST, which is about A$533 for each month behind. The bookkeeper quotes it as a fixed one-off fee with half (A$2,400) up front, lists what is out of scope (the 2025 year’s accounts and tax return, which stay with the accountant), and starts the monthly fee from November, the first month the books are current. The bookkeeping pricing calculator works out that monthly fee from the same transaction count.

Two things drive most of the estimate: the number of lines to reconcile and the minutes each takes. Bank rules and a tidy file bring 1.5 minutes down; missing statements, cash businesses and mixed personal spending push it up, which is what the contingency is for. If you cannot see the file before quoting, quote the first month as a paid diagnostic and the rest once you know.

How to price a clean-up

• Hourly: safest when you cannot see the file, but the client cannot budget for it. Give an estimate range and a cap that needs their approval to pass.
• Fixed fee for the whole job: what most clients prefer. Build it from an estimate like the one above, with a contingency and a written scope, so a missing year of statements becomes a new quote instead of free work.
• Per month behind: a quick way to quote a catch-up when the volume is steady (A$533 a month in the example). It works badly for clean-ups, where the time depends on the errors, not the months.

Whichever you choose, keep the clean-up separate from the monthly fee, ask for part of it up front, and put the cut-off date and what is excluded in the engagement letter.

Common questions

What is a bookkeeping clean up? A one-off job that takes books that are behind or wrong and makes them reconciled and trustworthy up to an agreed date: every account reconciled to its statements, transactions coded to the right accounts, unpaid invoices and bills that really are unpaid, payroll and tax returns that agree with the books, and a Balance Sheet that agrees with outside evidence.

What is the difference between catch-up and clean-up bookkeeping? Catch-up is books that are behind: transactions not yet entered or reconciled. Clean-up is books that are up to date but wrong: miscoded transactions, wrong balances, duplicates. Most files need some of both.

How long does a bookkeeping clean up take? It depends mostly on the number of transactions and how messy they are. Count the bank and card lines in the period, allow one to three minutes each, then add time for sales, bills, payroll, each tax return, the Balance Sheet review and queries. The worked example, nine months at about 140 lines a month, comes to 60 hours including contingency.

How much should I charge for a bookkeeping clean up? Estimate the hours task by task, add a contingency (often 15 to 25%), multiply by your hourly rate, and quote it as a fixed one-off fee with a deposit and a written scope. In the worked example, 60 hours at A$80 is A$4,800 plus GST.

What should a bookkeeping clean up checklist include? Scope and cut-off, the last filed period kept locked, every statement, feed gaps and duplicates, the opening balance check, month-by-month reconciliation, suspense and adjustment balances, sales and receivables, bills and payables, recoding, payroll, tax returns, a Balance Sheet review, and a lock date at the end.

Can you recode lots of transactions at once in Xero? Yes. Find and recode changes the account, tax rate or tracking on many transactions in one go. It needs the Administrator role (formerly Adviser), and Xero recommends no more than about 200 lines at a time.

Should a clean-up change earlier years? Not without the client’s accountant. Years that have final accounts or tax returns filed should stay locked. If they are wrong, the accountant decides whether to amend them or correct the error in the current year.

After the clean-up: keeping the client current

ReportPilot does not do the clean-up. Once a client’s books are current, it connects to their Xero with read-only access and sends them a plain-English email every Monday with their key figures (sales and profit against last month, cash, who owes them and what is overdue, bills due soon) under your practice’s name, plus scheduled report packs, so the client sees what the clean-up was for. The Bookkeeper plan covers 15 organisations for US$49 a month, after a 14-day free trial with no card (pricing). You can see a sample email first.