In one paragraph: scope it in writing, get every statement, then work from the last filed figures forwards. Agree the months, accounts and fee. Request statements for every account and month (closed accounts and payment processors too). Agree the opening balances to the last accounts or return that was filed and lock everything before that date. Reconcile each account month by month, oldest first. Only then code what's left, clear suspense, fix debtors, creditors and the balance sheet, and compare the cleaned figures with the VAT, sales tax and payroll returns already filed. Hand the accountant the reports with a list of every adjustment, and move the client onto a monthly routine so it doesn't happen again.
Jump to: Free cleanup plan builder · The checklist · Why this order · Signs the books need a cleanup · Opening balances · Suspense and personal spending · Mistakes on filed returns · Pricing and scope · Using AI · FAQ
Free tool: build a cleanup plan
Describe the job and get the statements to request (every account, every month), the filing deadlines those months feed with any that have already passed, the order to work in, a checklist tailored to the business, and an email to the client asking for everything. Downloads for Excel or Google Sheets. Nothing you type leaves your browser.
Deadlines are the usual ones for that business type (UK: Self Assessment, or Companies House accounts, Corporation Tax and the CT600; US: the federal income tax return for a calendar year, or the company's fiscal year for a C corporation). They aren't moved for weekends or holidays, and they don't cover extensions, first-year accounts, VAT, payroll or state returns. Check each one for the client.
The bookkeeping cleanup checklist
1. Scope and agree
- Write the scope down before you start: the months, every account, what's included and what isn't (filing or correcting returns is usually separate), the fee, and what changes it. Take a deposit. A cleanup with no written scope grows until it's free.
- New client? Do the onboarding first: client due diligence in the UK, and an engagement letter in both countries (our onboarding checklist lists the steps).
- Get access: the accounting software as an adviser user, the statements, the payment processors.
- Find the last return or accounts that were filed, and who prepared them. That's the last point anyone agreed the figures.
2. Gather the records
- A full list of every account used in the period, including ones now closed: bank, savings, credit cards, loans, Stripe, PayPal, Square, Shopify, Amazon, petty cash.
- A statement for every account for every month, as PDFs. A bank feed is a copy that can miss or double lines; the statement is the evidence.
- Processor reports showing gross sales, fees, refunds and payouts.
- Sales records (invoices, or the till or booking system's totals), receipts and bills over an agreed amount, supplier statements.
- Loan and finance statements, payroll reports, and copies of every VAT or sales tax return filed in the period.
Asking is the easy part; getting it is the job. Our chase planner schedules the reminders.
3. Opening position
- Agree the opening balances to the last filed figures: bank, debtors, creditors, loans, VAT or sales tax owed, and the owner's or director's account.
- Software already in use? Run a trial balance at the start date and compare it with the filed figures before you change anything. Note every difference.
- Lock the periods before the start date, so nothing you do changes figures that were already filed.
4. Bank, cards and processors
- Reconcile each account month by month, oldest first, to the closing balance on each statement. Don't move to the next month until the last one agrees (our bank reconciliation guide and checker shows how to find a difference).
- Delete duplicate feed lines (common after a feed reconnects) and add the ones the feed missed.
- Record processor sales gross, with fees and refunds separately, and payouts as transfers to the bank. Posting only the net payouts hides the fees and makes sales and VAT figures wrong.
- Match every transfer between the client's own accounts on both sides.
5. Categorise and clear
- Set up bank rules for recurring suppliers and income first; they clear most lines in bulk.
- Code what's left, then send the client one grouped query list for the lines only they can explain, with a reply-by date (our query list guide has the wording).
- Move personal spending out of expenses (see below).
- Clear suspense, uncategorised and "ask my accountant" to nil, or list what's left and why.
6. Sales, bills and the balance sheet
- Aged debtors: invoices still showing unpaid that were paid (the receipt was coded to sales instead of matched to the invoice, so sales are counted twice), and real bad debts for the client to decide on.
- Aged creditors: bills showing unpaid that were paid, and duplicates.
- Loans split into interest and capital from the lender's statements; equipment and vehicles listed for the accountant; stock at each year end.
- Every balance sheet figure at each year end explained by a statement, a list or a note.
7. Tax and payroll checks
- Compare each filed VAT or sales tax return with the cleaned books for the same period, and list every difference against the return it belongs to (what to do with them).
- UK and not VAT registered: check the rolling 12-month taxable turnover in the cleaned books against the threshold (£90,000 since 1 April 2024, gov.uk) for every month in the range. Cleanups often find a business that should have registered.
- Payroll journals agree with the payroll reports; PAYE or payroll tax paid agrees with what was due.
- UK: CIS deductions, if the business works in construction. US: the contractors who need a 1099-NEC each year ($600 for payments up to 2025; $2,000 for payments made from 2026, irs.gov).
8. Hand over and stay current
- Send the accountant or tax preparer, for each year: trial balance, profit and loss, balance sheet, the reconciliations and a list of every adjustment you made.
- Send the client one page: what was wrong, what you fixed, what's still open, and which returns need filing or correcting.
- Lock every cleaned period.
- Move the client onto a monthly routine (our month-end close checklist), priced as a fixed monthly fee. A cleanup client who goes back to a shoebox will need another cleanup next year.
Why this order saves rework
Almost every cleanup that goes wrong does so because something was done before the thing it depends on:
| If you do this first… | …this happens |
|---|---|
| Start coding before the statements arrive | You code from a feed with gaps and duplicates, then recode when the statements show different balances. |
| Skip agreeing the opening balances | Every month reconciles but the year-end figures still don't agree with the last accounts, and the difference has to be traced back through every month. |
| Work newest month first | Each month's opening balance depends on the one before it, so a mistake found in an earlier month changes everything you've already done. |
| Fix debtors and creditors before the bank | Half the "unpaid" invoices are paid; you only find out which from the reconciled bank. |
| Compare with filed returns before the books are clean | You chase differences that are really your own unfinished work. |
On long jobs, stage the work by year, oldest first, and sign off each year before starting the next. The client sees progress, you can bill by stage, and the year with the nearest deadline is usually the oldest open one anyway. The tool's work order does this split for you.
Signs the books need a cleanup (and not just catching up)
- The bank balance in the software doesn't match the statement, or nobody has checked.
- A large balance in suspense, uncategorised or "ask my accountant".
- Aged debtors full of invoices the client says were paid long ago.
- Negative balances where there shouldn't be (a bank account that's never been overdrawn showing overdrawn; a negative creditor).
- Sales that look too high (receipts coded to sales and invoices raised for the same money) or too low (processor payouts posted net).
- VAT or sales tax returns filed from figures that can't be traced to the books.
- Opening balances that don't match last year's accounts.
Catch-up means entering months that were never done; clean-up means fixing months that were done wrong. Most jobs are both, and clean-up months take longer per transaction because you have to undo before you can redo. Ask for a look at the file (or a trial balance and the bank reconciliation report) before you quote.
Opening balances: start from the last filed figures
The last accounts or tax return filed are the last figures anyone agreed. The cleaned books must start from them, or next year's accounts won't follow on from last year's. Ask the accountant who prepared them for the closing trial balance (or the balance sheet and any adjusting journals) and agree each opening figure to it: bank, debtors, creditors, loans, VAT or sales tax owed, fixed assets and the owner's or director's account.
If the software's figures at that date differ, don't overwrite them silently. List each difference, ask the accountant how they want it handled (usually an opening-balance journal they approve), and lock the period once it's agreed. If nothing was ever filed, agree a start date and starting position with the client and the accountant in writing before you do any coding.
Suspense and personal spending
Suspense should be empty at the end of a cleanup. Whatever is left needs a reason: a line the client hasn't explained yet, with a date for the answer. Don't clear it to "general expenses" to make it go away.
Personal spending from the business account is the most common fix:
- Sole traders and partners (UK and US): post it to drawings, not expenses. It isn't a business cost.
- UK limited companies: post it to the director's loan account. An overdrawn director's loan account at the year end can have tax consequences for the company and the director (gov.uk), so flag the balance to the accountant rather than deciding it yourself.
- US corporations: post it to a shareholder loan or distributions account as the tax preparer directs, and flag it. Personal costs paid by an S or C corporation shouldn't sit in expenses.
Mistakes on returns already filed
Cleanups regularly find that a filed return was wrong. Your job is to find and document it; deciding how to correct it is for the client and their accountant or tax adviser. Keep a list: the return, the period, the figure filed, the correct figure and the difference.
- UK VAT: a net error up to £10,000, or up to 1% of the return's box 6 turnover with a £50,000 cap, can usually be corrected on the next VAT return; bigger or deliberate errors are reported on form VAT652, and there's a 4-year time limit (VAT Notice 700/45).
- UK Self Assessment: a return can be amended up to 12 months after the 31 January filing deadline (gov.uk); older years need a different route.
- UK late filing: a Self Assessment return filed late gets an initial £100 penalty even if there's no tax to pay, with more after 3 months (gov.uk). Late company accounts start at £150 for up to a month late (gov.uk). If the plan shows a passed deadline, find out today whether the return was filed.
- US: an individual return is corrected on Form 1040-X; business returns have their own amended-return routes. Sales tax corrections depend on the state.
Pricing and scoping a cleanup
Price it as a fixed project from your own time and rate, never "we'll see". The numbers you need are in the plan: months, accounts (so account-months to reconcile), transactions per month, and the state of the records. Add a contingency for missing documents, take a deposit, and quote anything outside the assumptions before you do it. The catch-up section of our free fee calculator does the sums and writes the assumptions for the quote.
Two scope lines that save arguments: "Work starts when all the statements in the attached list have arrived" and "Filing or correcting tax returns is not included unless listed above."
Using ChatGPT, Gemini or Claude on a cleanup, safely
- Good jobs for AI: suggesting categories for a pasted list of bank lines, spotting likely duplicates and transfers, grouping the lines only the client can explain into a short query list, and drafting the summary for the client and accountant.
- Strip identifiers first: a client code instead of the name, no account numbers or sort codes (or just the last 4 digits), no NI or Social Security numbers, no logins. Check your practice's data-protection policy and the AI app's data settings.
- Check every suggestion. AI tools guess categories confidently and can misread a column. Reconciliations and balances come from the statements and your software, never from the chat.
- Keep the decisions: write-offs, opening-balance journals, director's loan treatment and return corrections are for you, the client and the accountant.
Clear the uncoded lines faster. The free transaction-queries skill takes the bank lines you couldn't code and writes a short, grouped query list for the client with the likely options for each line, and the free records-chaser skill writes the follow-ups when the statements don't arrive. Set-up takes about 3 minutes, no coding.
Bookkeeper Skills Pro adds month-end-close (findings, fixes and client questions from a trial balance and the reconciliation status), year-end-pack for the accountant, and fee-review, which prices catch-up work from your own numbers.
FAQ
What is a bookkeeping cleanup?
Bringing a business's books from wrong or out of date to correct and current. It covers catch-up work (entering months that were never done) and clean-up work (fixing months that were done badly): agreeing the opening balances to the last filed accounts or return, reconciling every bank, card and payment processor account month by month, coding everything that's uncategorised, fixing the debtors, creditors and balance sheet, and checking the figures against the tax returns already filed.
What should a bookkeeping cleanup checklist include?
1. A written scope: the months, the accounts and the fee. 2. Every statement for every account and month, including closed accounts and processors. 3. Opening balances agreed to the last filed accounts or return, and earlier periods locked. 4. Each account reconciled month by month, oldest first. 5. Everything coded, personal spending moved to drawings or the director's loan account, and suspense cleared. 6. Debtors, creditors, loans and every balance sheet figure explained. 7. Filed VAT, sales tax and payroll figures compared with the cleaned books. 8. Reports and a list of adjustments for the accountant, and the client moved onto a monthly routine.
Where do you start when cleaning up messy books?
With the last return or accounts that were filed, because that's the last point the figures were agreed. Agree the opening balances to it, lock everything before that date, then reconcile the bank accounts month by month from there, oldest first. Coding and fixing reports before the bank is reconciled means doing them twice.
How long does a bookkeeping cleanup take?
It depends on the months behind, the number of accounts and transactions, and how many records are missing. Count account-months (accounts multiplied by months) and transactions, estimate the time from your own speed, then add a contingency: around 20% if full statements exist, 40% if documents are missing, more if statements still need requesting. Missing statements are the usual reason a cleanup overruns, so get them first.
How much should I charge for a bookkeeping cleanup?
Price it as a fixed project from your own time and target rate, with the assumptions written down (months, accounts, transactions per month, state of the records), a contingency for missing documents and a deposit before you start. Quote work outside the assumptions separately. Our free fee calculator has a catch-up section that does the sums.
What if the cleanup finds mistakes on returns already filed?
Note each difference, which return it belongs to and how much, and tell the client and their accountant or tax preparer. In the UK, small net VAT errors can usually be corrected on the next VAT return and bigger ones are reported on form VAT652 (VAT Notice 700/45), and a Self Assessment return can be amended up to 12 months after the 31 January deadline. In the US, an individual return is corrected on Form 1040-X. Deciding how to correct a filed return is for the client and their tax adviser.
This page is general information written by an AI agent and checked on 29 October 2026 against gov.uk (Self Assessment deadlines, penalties and corrections; filing company accounts and late filing penalties; paying Corporation Tax; Company Tax Returns; VAT registration; correcting VAT errors, VAT Notice 700/45; director's loans) and irs.gov (filing dates; Form 1120 instructions; 1099-MISC and 1099-NEC instructions). It isn't accounting or tax advice: follow your professional body's guidance and check each client's own position.