QuickBooks cleanup vs catch-up

The difference, in two sentences

Cleanup corrects months that exist in QuickBooks and are wrong. The transactions are there; they are miscategorized, duplicated, unreconciled, or sitting in a holding account that never cleared.

Catch-up enters months that were never recorded at all. There is nothing to correct, because there is nothing there.

Everything else in this post is how to tell which one a file needs, and what happens when it needs both.

How to tell which one a file needs

Open the file and answer four questions in this order. Each one takes a minute and none of them requires judgement.

Check	Where	What it tells you
Do the months exist at all?	Profit and loss, by month, for the last two years	Blank columns are catch-up. Populated columns are cleanup.
When did an account last reconcile?	Reconciliation history, per account	The last reconciled month is your starting line, whichever job this is.
Is anything sitting in the review queue?	Bank transactions, For review	A queue thousands deep is catch-up wearing cleanup’s clothes.
Do the holding accounts carry a balance?	Balance sheet	Undeposited Funds, Opening Balance Equity, uncategorized income and expense. Any balance is cleanup.

A profit and loss run by month is the fastest of the four and usually settles it. Twelve columns with numbers in them and a balance sheet that will not tie is a cleanup. Four columns populated and eight blank is a catch-up with a cleanup on the front of it.

One trap in that first check. A month can look populated and be empty of anything real, because the bank feed dropped transactions into the register uncategorized and they landed in Uncategorized Expense. The column has a number, so the file looks recorded. It is not. Check whether the month’s expenses are spread across the chart of accounts or piled into one line.

Most files need both, and the order is not what people assume

The common advice is to catch up first and clean up afterwards. That is close enough to be repeated everywhere and wrong often enough to cost real time.

The rule that actually holds: find the last month that reconciles to a statement, and work forward from there chronologically, doing whatever each month needs.

The reason is that the two jobs are not sequential phases, they are the same pass. A file six months behind and also wrong for the year before it has one break point, not two. Everything before the break is finished. Everything after it is unfinished, and the unfinished part has to be rebuilt in date order because each month’s opening balance is the previous month’s closing balance.

Clean a period that still has missing history underneath it and the corrections get made against balances that are about to change. When the missing months are entered, the reconciliations break again and the categorizations have to be revisited. That is the doing-it-twice failure, and it is the single most expensive mistake in this work.

There is one exception worth knowing. If the break point is in Opening Balance Equity, a balance nobody ever cleared from setup or from a Desktop conversion, that is fixed before anything else, because every reconciliation after it inherits the error. Opening Balance Equity has its own page for that reason.

What actually determines the timeline

Not transaction volume. Document availability.

This surprises people, and it is the part almost no published guide says out loud. A twelve-month catch-up on a business with two accounts and modest volume can take longer than a cleanup with ten times the transactions, because of two hard limits that have nothing to do with bookkeeping.

The bank feed will not go back far enough. How far back QuickBooks Online can download when an account is connected depends on the bank: Intuit puts the range at 90 days to 24 months, and many banks sit near the short end. Anything older has to be brought in as a file: .qbo, .qfx, .ofx or CSV, downloaded from the bank’s own portal and imported by hand. So the first real question on any catch-up is not “how many transactions” but “how far back does this feed reach, and who has the bank login for the rest”.

The statements may not be online. Reconciling needs statements, not feed data, and banks vary enormously in how far back the portal goes. Bank of America publishes 18 months. US Bank publishes two years. Capital One publishes up to seven. Past whatever that limit is, statements are an archive request: typically a fee in the $5 to $50 range per statement, and a wait measured in weeks rather than days.

A three-year catch-up therefore has a step in the middle where the work stops and somebody waits for a bank. Planning around that is the difference between a catch-up that lands on a date and one that slips indefinitely. Get statement access established at the start, every account and every month in scope, before any transaction is entered. How long catch-up bookkeeping takes puts numbers on each stage.

What cleanup does not fix

A cleanup fixes the books. It does not fix a tax return that was already filed off the old numbers. Those are two separate jobs that happen to share one clean ledger.

This matters more than it sounds, and it is the question a firm should settle before the work starts rather than after. If the corrections land in a year a return was already filed on, somebody has to decide whether that return needs amending or whether the difference is immaterial and the next year is simply filed correctly. That is a call for the signing CPA or EA, not for the bookkeeper, and it should be made deliberately instead of discovered in March.

The practical consequence for scope: agree in writing which periods are in scope and which are closed, before touching anything. A cleanup that silently reopens a filed year has created a problem rather than solved one.

The holding accounts, and one naming change worth knowing

Four accounts carry most of what a cleanup finds. They are the same four every time.

Undeposited Funds. Note that some QuickBooks Online subscriptions now show this account as Payments to Deposit. Same account, same behaviour, different label, and if you are following a guide written before the change it will name the old one. A balance means payments were recorded and never swept into a deposit that matches the bank, which usually means the same money is on the books twice. The pileup version is one of the most common things in an inherited file.

Opening Balance Equity. Should be zero after the first close and stay zero forever.

Uncategorized income and uncategorized expense. Whatever the feed could not place, still sitting where it landed.

Ask my accountant. Legitimate during a month, a list of unanswered questions at the end of one.

Duplicates deserve their own mention because they are created by the thing that is supposed to help. Reconnecting or re-authorizing a bank connection can backfill transactions the file already has, and a third-party app pushing sales receipts alongside a direct feed does the same. Excluding them rather than deleting them is what keeps past reconciliations intact.

Which one is cheaper

Neither. They are the same rate at Ledgerbrook, per month of backlog rather than per hour, which is the only way a firm can work out the cost before committing a client file. The instinct is that catch-up must be the bigger job because more months are involved, and that is often wrong: entering a clean month from a statement is faster than untangling a month somebody else half-did.

$99per month of backlog20% off 6+ months

Every month counted as backlog is documented in writing before any billing, because “how many months is this” is the whole basis of the number and it should not be a matter of trust. Cleanup and catch-up have their own pages, and the pricing page carries every figure in one table.

The one-line version

Count the months that are missing. Count the months that are wrong. Find the last month that reconciles. Then work forward from it, and do not start the categorizing until you know who has the bank logins.

Once the file is current, keeping it current is a monthly close, and the close checklist is the seven steps that stop it drifting back. A tax practice sorting a client roster into cleanup and catch-up files can send the whole list through outsourced bookkeeping for CPA firms.