A file gets behind for ordinary reasons. Someone left, a busy season ran long, the bookkeeper was doing their best with no instructions. By the time anyone looks properly, the reports produce numbers that nobody believes, and the instinct is to start fixing whatever looks most wrong.
That instinct costs the most time. Cleanup has an order, and most of the order exists specifically so that work is not repeated. Here is the sequence, with what to expect at each stage.
Before anything: establish what is actually verified
The first task is not a fix. It is finding the last date the file was genuinely reconciled.
Genuinely means reconciled to a bank statement, with a reconciliation report you can open, not a bank feed that imported without error. Those are different things, and the difference is the whole problem: a feed can import cleanly and still be missing a week nobody noticed, and everything after that point is unverified regardless of how confident the reports look.
Check the reconciliation history for every account: operating accounts, savings, every credit card, every line of credit, and any loan account being tracked. The earliest last-reconciled date across all of them is your real starting line, because a file is only as verified as its least verified account.
Write that date down. Everything after it is provisional, and treating it as provisional is what stops you from building corrections on top of unverified data.
Collect the source documents first
Cleanup without statements is guesswork with extra steps. Before touching a transaction, gather everything covering the gap.
- Bank statements for every account, every month.
- Credit card statements, including the card nobody mentions until the statement arrives.
- Loan statements and amortization schedules for every financed item.
- Payroll reports from the provider, by pay period, including tax filings if available.
- Merchant processor statements, which are a frequent source of unexplained differences because of fee netting.
- Prior year tax returns, which establish what the closing balances were supposed to be.
- Closing statements for any property or major asset purchased in the period.
This stage feels like administration and it determines everything downstream. A cleanup where 80 percent of statements are available and 20 percent are chased later will revisit months that were already declared finished.
The prior year return deserves particular attention. It gives you a set of balances someone signed, which is the only external anchor most small business files have.
Take a backup and work with a plan
Before making changes, export the current state: a Profit and Loss and balance sheet for each affected period, a trial balance, and the general ledger detail. QuickBooks Online does not have a restore point in the way desktop software does, so the exported reports are your record of what the file said before.
This matters for two reasons. It lets you show your CPA what changed, which they will want to know. And it protects against the situation where a correction turns out to have been based on a misunderstanding, and you need to see the original.
Then decide the scope explicitly. Cleaning up two years is a different engagement from cleaning up two months, and the honest question is how far back the information is worth having. Balance sheet accuracy usually needs to go back as far as the error goes, because a wrong asset or loan balance stays wrong. Income statement detail from three years ago frequently is not worth reconstructing, because no decision depends on it any more.
Find and remove duplicates
Duplicated transactions are the highest yield early step, because they are common, they distort everything, and they are relatively easy to find.
The usual causes: a bank feed disconnected and reconnected, importing a period twice; a manual entry created beside a transaction the feed had already matched; a deposit recorded both as an invoice payment and as a bank deposit; and a check entered and then also imported.
Look for them by scanning the general ledger detail sorted by amount within each account, which brings identical pairs adjacent. Pay particular attention to periods around any feed reconnection, because duplicates cluster there rather than spreading evenly.
Remove them before reconciling, not during. Reconciling a period that contains duplicates means finding the difference, hunting the cause, and redoing the reconciliation, for every affected month.
Fix the chart of accounts before recategorizing
This is the step most often done in the wrong order, and getting it wrong doubles the largest piece of work in the project.
If you recategorize thousands of transactions into the existing chart of accounts and then decide the chart needs restructuring, you recategorize them again. So the structure comes first.
What usually needs fixing:
- Accounts that mix distinct things. Field wages with office wages, job materials with shop supplies, owner draws with expenses.
- Missing structure for segment reporting. No way to separate direct cost from overhead, or no class structure for properties or entities.
- Duplicate accounts. Three variations on the same expense, created by different people over time.
- Balance sheet accounts used as expense accounts. And, more often, the reverse.
- Accounts with no clear meaning. If nobody can say what belongs in it, nothing should.
Decide the structure against the reports you actually want. For a contractor that means direct cost separated from overhead and job level coding available. For a rental owner it means property level segmentation and correct fixed asset and loan accounts. For a management company it means owner funds separated from management company revenue.
Write the structure down before implementing it, and agree it with whoever will code transactions afterwards. A structure that only its designer understands degrades within a quarter.
Rebuild reconciliation forward, month by month
Start at the last verified date and move forward. Not backward from today.
Working backwards feels faster and hides where the divergence started, which means you find the symptom and not the cause. Working forward, each month either reconciles or does not, and the first month that does not is the month that contains the problem.
For each month, in order: match every transaction to the statement, investigate anything that does not match, record missing transactions, remove any remaining duplicates, and complete the reconciliation so a reconciliation report exists.
Some months will take twenty minutes and some will take three hours. The distribution is uneven and impossible to predict from the outside, which is why cleanup scoping is a range rather than a number until the first few months are done.
Handle every account for a month before moving to the next one, rather than doing all months of one account and then starting over. Accounts interact through transfers, and a transfer that is wrong shows up as a difference in two accounts in the same month.
Recategorize, then rebuild segment coding
With the structure fixed and the reconciliation rebuilt, categorization becomes mechanical.
Work account by account rather than transaction by transaction. Reviewing everything currently sitting in one account is faster and produces more consistent decisions than reviewing chronologically, because you see the pattern.
Clear the catch-all accounts completely. Uncategorized income, uncategorized expense, and ask-my-accountant should end at zero. Anything genuinely ambiguous becomes a specific question to the owner, not a default posting.
Then rebuild segment coding, job, property, class, or entity, as far as the source documents support. Some of it will be recoverable from invoice detail and vendor records. Some of it, particularly labor allocation, will not be recoverable at all if the underlying time detail was never captured.
Where detail is unrecoverable, report that rather than estimating. An owner who knows that job level labor is unavailable before a certain date can plan around it. An owner given allocated estimates presented as actuals makes decisions on numbers that were invented.
Correct the balance sheet, which is where the real errors live
The income statement usually gets attention because people read it. The balance sheet is where errors persist for years, because it carries forward.
The accounts that most often need correcting:
- Opening balance equity. A balance here almost always means an unresolved setup or conversion issue. It should generally be zero, and if it is not, something was never properly allocated.
- Loan balances. Tied to the amortization schedule, with each payment split between principal and interest. A loan that never decreases means the whole payment is being expensed.
- Undeposited funds. Old balances here usually mean payments recorded but never matched to a deposit.
- Accounts receivable. Stale invoices that were paid, written off informally, or never real. Retainage mixed into ordinary aging, if you are a contractor.
- Accounts payable. Bills paid outside the system, duplicated bills, and vendor credits never applied.
- Fixed assets. Purchases expensed that should have been capitalized, or capitalized items that were disposed of and never removed.
- Security deposits and customer deposits. Liability balances that should tie to cash actually held.
- Payroll liabilities. Withholding and employer tax accounts checked against what was actually remitted.
- Credit card balances. Which should equal the statement balance, and often do not because of a period of unrecorded transactions.
Capitalization thresholds, depreciation methods, and the treatment of specific items have tax consequences, and your CPA or tax professional will have requirements. Meridian Ledger Group LLC does not provide tax advice and does not prepare or file tax returns, so the sensible approach is to identify the issues, correct the mechanical errors, and flag the treatment questions for the tax professional to decide.
Document what changed, then close the periods
Two final steps, both of which are skipped often enough to be worth naming.
Document the material corrections. A short schedule of what was changed, in which period, and why. Your CPA will need this to reconcile the corrected books to what was previously filed, and if a prior year return was based on materially different numbers, that is a conversation for them to have with you.
Close the caught-up periods and set a closing date. This is the step that makes the whole project durable. Without a closing date, a later transaction can post into a corrected period and silently change a report that was already relied on. With one, the corrected history stays corrected.
Then, and this is the part that determines whether the cleanup was worth doing, start a monthly cycle from the caught-up position. A file that has been cleaned up and then left alone for eight months is a file that needs cleaning up again, and the second cleanup costs roughly what the first one did.
Meridian handles cleanup as a defined engagement, scoped after reviewing the file rather than quoted blind, and it is described on cleanup and catch-up. The ongoing cycle that follows it is monthly bookkeeping.
The short version
Find the last genuinely reconciled date, collect every statement before touching a transaction, remove duplicates, then fix the chart of accounts before recategorizing anything. Rebuild reconciliation forward month by month rather than backward from today, correct the balance sheet where errors persist, document the material changes for your CPA, and set a closing date so the corrected history stays corrected.
