The bookkeeping cleanup checklist

This is written for the person doing the cleanup, not the person buying one. Most published versions of this list are written to a business owner deciding whether their books need help. This one assumes you have already agreed to do the work on somebody else’s client file and want to not lose money on it.

The same nine steps as a spreadsheet, with a column to sign off each one: download the checklist (Excel). No email needed.

The checklist

Three steps before the file is opened, six after.

1. Get access, and get statement access separately. Accountant-level user in the client’s own QuickBooks Online company. Then, as a distinct task, the bank and card portal logins or downloaded statements for every account and every month in scope.
2. Agree which periods are closed. In writing, before anything is touched.
3. Record the starting point. Export the trial balance, the balance sheet and the profit and loss by month as they are on day one, before a single change.
4. Find the last month that reconciles, per account, and start there.
5. Complete the months, forward. Every transaction in, every transaction categorized, review queue empty.
6. Reconcile each account to its statement, in date order, never to the feed. The QuickBooks Online reconcile walkthrough covers the screen itself.
7. Clear the holding accounts. Undeposited Funds, Opening Balance Equity, uncategorized income and expense, ask-my-accountant.
8. Post the adjusting entries and tie the sub-ledgers: receivables and payables aging against the balance sheet.
9. Lock the period and hand back a written summary of what changed.

Step	Phase	Action item	Deliverable / Output	Risk if skipped
1	Pre-work	QBO & bank portal access	Accountant user invite + downloaded monthly PDF statements	Cleanup stalls waiting for statements older than the feed reaches
2	Pre-work	Establish closed tax periods	Written scope of filed returns with CPA/client sign-off	Bookkeeper accidentally alters numbers on a filed tax return
3	Pre-work	Export baseline financial state	Exported trial balance, balance sheet, and P&L by month	No documentation to prove what changed vs what was originally broken
4	Execution	Identify last reconciled month	Account-by-account cut-off date where books agreed with bank	Re-doing work by starting reconciliations in an arbitrary month
5	Execution	Complete historical months forward	Zero uncategorized bank feed transactions in review queue	Uncategorized feed items distort downstream expense categories
6	Execution	Reconcile accounts to bank statements	Saved month-by-month reconciliation reports with $0 difference	Cleared transactions fail to agree with verified cash balances
7	Execution	Clear holding & suspense accounts	Undeposited Funds, Opening Balance Equity zeroed out	Revenue counted twice; equity inflated with unverified entries
8	Execution	Post adjustments & tie sub-ledgers	Amortization, depreciation, accruals; tied AR/AP aging	Open invoices do not match balance sheet; tax deductions missed
9	Closing	Lock books & deliver change log	Closing date password set; itemized summary of adjustments	Accidental edits overwrite reconciled prior-period numbers

The first three are the ones that decide whether the job runs to plan. The rest is craft.

Step 1 is two jobs, and the second one is the one that slips

Being invited into a QuickBooks file feels like being given access. It is not, quite.

Accountant-level access lets you categorize, reconcile and run reports, and deliberately does not let you touch billing or delete the company. That is the right level and it is enough for all nine steps here. What it does not give you is anything from the bank.

Reconciling needs statements, and statements live in the bank’s portal, not in QuickBooks. On a cleanup reaching back more than a few months this is the constraint that sets the schedule, because the bank feed only reaches back as far as the bank allows when the account is connected: from 90 days up to 24 months, depending on the bank, and often at the short end. Everything older arrives as a .qbo, .qfx, .ofx or CSV that somebody has to go and download.

Ask for statement access as an explicit deliverable at the start, with a named person responsible for it. A cleanup that begins before this is settled will stop in the middle and wait, and the waiting is not billable.

Step 2 is the one that turns a cleanup into a problem

Find out which periods have already had a tax return filed on them, and get the answer in writing.

A cleanup corrects the books. It does not correct a return already filed off the old numbers, and if your corrections land inside a filed year, somebody now has to decide whether that return needs amending or whether the difference is immaterial. That decision belongs to the signing CPA or EA. It is not a bookkeeping judgement and it should not be made by accident in the course of recategorizing a vendor.

So the scope agreement names the periods that are in scope and the periods that are closed, and says what happens if something material turns up inside a closed one, which it will. The usual answer is that it gets documented and escalated, not silently fixed.

If this is subcontracted work, that term belongs in the engagement alongside the other seven things worth checking before a client file changes hands. The checklist for that is separate from this one.

Step 3 takes ten minutes and is the only proof you will have

Before changing anything, export the trial balance, the balance sheet and a profit and loss by month, and keep them.

Nobody does this and everybody needs it. Three weeks in, a partner asks why last year’s net income moved. Without the day-one snapshot the honest answer is that a lot of things changed and they all needed to. With it, the answer is a comparison, and the conversation takes two minutes instead of an afternoon.

It also protects the person doing the work. A cleanup changes prior numbers by design. The difference between that and having broken something is entirely a matter of whether the before state was recorded.

Why the order, and why it is chronological

Steps 5 through 8 are one forward pass, not four phases.

Categorization comes before reconciliation because reconciling a month that still has uncategorized transactions in it means reconciling it again. Reconciliation comes before adjusting entries because an accrual posted onto an unreconciled ledger gets reconsidered the moment the reconciliation turns up three missing transactions. Holding accounts are cleared before the sub-ledgers are tied, because a payment stuck in Undeposited Funds is a receivable that looks settled and is not.

And the whole pass runs in date order, oldest first, because every month’s opening balance is the previous month’s closing balance. Jumping to the worst-looking month and fixing it first is the most natural instinct in this work and the most reliable way to do it twice.

If the file is also missing months entirely, that is a catch-up sitting inside a cleanup, and the two are the same forward pass rather than two jobs. Which one a file needs covers telling them apart.

The accounts that hide everything

The same four, every time, and a balance in any of them is an unanswered question rather than a number.

Undeposited Funds. Appears as Payments to Deposit in some QuickBooks Online subscriptions now, same account either way. A balance means payments were recorded and never swept into a deposit matching the bank, which usually means the same money is on the books twice. The pileup version.

Opening Balance Equity. Zero after the first close, forever. A balance means the file was set up with a figure nobody verified, and every reconciliation since has inherited it. Fix this before anything downstream of it. Why it never clears on its own.

Uncategorized income and expense. Whatever the feed could not place. A cleanup that leaves these carrying a balance has not finished.

Ask my accountant. A list of questions. The answer is not to leave them there.

Alongside those, expect duplicates, and expect them to have been created by the bank feed rather than by carelessness. Re-authorizing a connection can backfill transactions the file already holds. Exclude them rather than delete them, or you break the reconciliations that already passed. If a balance simply will not tie, finding the period the break started in is its own procedure.

Where cleanups overrun

Three things, in order of how often they happen.

Waiting. Statements that are not online, a login nobody has, four transactions only the owner can explain. Banks publish a limited window: 18 months at Bank of America, two years at US Bank, up to seven at Capital One. Past that, statements become an archive request, which means a fee per statement and a wait measured in weeks. Establish this in step 1 or absorb it in the middle.

Scope drift. “While you’re in there” is how a twelve-month cleanup becomes a chart of accounts redesign and a class-tracking implementation. Both may be worth doing. Neither is this engagement, and each is priced separately or it is free.

The file that should be rebuilt instead. Sometimes the honest answer after step 4 is that the existing file cannot be economically repaired and a fresh one with correct opening balances is cheaper. That judgement belongs at step 4, not at step 8. Repair or start over is the diagnostic.

Step 9, which most checklists leave out

Lock the period, then write down what you did.

Setting the closing date stops the month you just proved from quietly changing when somebody categorizes a feed in a hurry. That part is mechanical.

The written summary is the deliverable. What changed and roughly by how much, which periods were touched, what is still open and waiting on whom, and anything found inside a closed period that somebody else has to decide about. A firm handing this to a client, or a partner reviewing it before signing, needs the summary more than they need the file. What a QuickBooks cleanup should include lists everything that should come back at the end, and how to check it.

A cleanup with no write-up is indistinguishable from a cleanup that did not happen, three months later, to everyone except the person who did it.

What this costs when it is bought rather than done

Priced per month of backlog needing correction, not per hour, so a firm can work out the number before committing a client file:

$99per month of backlog20% off 6+ months

Every month counted as backlog is documented in writing before billing, and what QuickBooks cleanup costs compares that rate with every firm that publishes one. Cleanup has the full scope, and once a file is current, the month-end close checklist is what stops it drifting back.