How to Clean Up Two Years of Neglected Books (and Not Lose Your Mind)

We get this call every January: "I have not touched the books since 2024. Can you fix it?" Yes — but the order you do it in matters more than how long you spend.

Here is the playbook we actually use, written for owner-operators doing it themselves. It is also exactly what Foxel's cleanup engagement does, if you would rather hand it off.

Rule zero: do not start with the current month

The temptation is to open December, square it, then work backward. Do not. December's numbers depend on November's opening balances, which depend on October's, which depend on how the prior year closed. If you start at the top, you end up redoing everything after you find the mistake at the bottom.

Start at the oldest open month. Close it. Move forward one month at a time. Each month's opening balance comes from the previous month's closing — this is the only way the arithmetic survives.

Step 1: Decide the scope honestly

• 1–6 months behind: solo cleanup is realistic. Weekend project.
• 6–12 months: you can still do it yourself, but block out 20–40 hours. Resist the "I'll do it in evenings" plan.
• 12–24 months: hire this out. The IRS statute means these years still matter but your time is better spent on your business.
• 24+ months and no returns filed: you may be able to use the IRS Streamlined Filing Compliance Procedures or request penalty abatement. Get a licensed preparer involved before you file.

Step 2: Gather every statement before you touch QuickBooks

Open a folder on your desktop. Download:

• Every month's bank statement for every account (business checking, savings, credit cards, loans, PayPal, Stripe, Shopify)
• Every month's merchant processor statement (Square, Stripe, Shopify, Toast)
• Every payroll report if you ran payroll (Gusto, ADP, QuickBooks Payroll)
• The last filed tax return (so you have the opening balances)
• A list of fixed assets you own with purchase date and amount

Do not skip this. If you start categorizing in QuickBooks before you have the statements, you will double-count anything that landed in two places (e.g., a Stripe payout vs the Stripe deposits in your bank account).

Step 3: Reconcile, do not categorize

For each month, in order:

1. Open the bank reconciliation screen in QuickBooks or Xero.
2. Enter the statement's ending balance.
3. Check off every transaction that matches the statement.
4. Resolve the difference. If reconciliation does not balance, you have duplicates, missing transactions, or wrong amounts. Fix those before worrying about which category each transaction goes into.

Reconciliation is boring but it is the only way to know your books are correct. Categorization makes your P&L look pretty — reconciliation makes it true.

Step 4: Categorize in bulk

Once reconciled, categorize in batches:

• Sort transactions by vendor name, categorize all Amazon purchases at once, all Uber rides at once, all SaaS subscriptions at once.
• For recurring items, set up a bank rule so future months auto-categorize. This is the single highest ROI action you can take.
• Flag anything over $500 that you are not sure about with a question mark; come back to those at the end.

Step 5: Fix the balance sheet

Most self-done cleanups look great on the P&L and are a disaster on the balance sheet. Specific traps:

• Owner contributions and distributions often get miscategorized as income or expense. They are equity movements.
• Loan principal payments are not expenses. Only the interest is. The principal reduces the loan liability.
• Credit card debt that is just sitting there as "uncategorized expense" is actually a liability movement.
• Depreciation was likely not booked. On fixed assets, calculate straight-line depreciation and book the monthly entry.

If your balance sheet does not balance, the P&L is wrong somewhere. Full stop.

Step 6: Reconcile intercompany if you have multiple entities

If you have an LLC and an S-corp, or two different businesses that share accounts, each entity needs its own clean books. Movements between them need an intercompany receivable/payable, not just a lump "transfer."

This is the single most common place DIY cleanups go wrong. If you are here, you may want help.

Step 7: Close the year and lock it

Once a year is clean:

1. Run a trial balance.
2. Run a P&L and a balance sheet.
3. Compare the P&L totals to what was reported on the tax return (if filed).
4. Lock the books by setting a closing date so no one can accidentally change prior-year entries.

When to just start fresh

If the books are so bad that cleaning them would cost more than the IRS statute period cares about, there is a legal option called beginning a new set of books — opening a new file as of a specific date, with reconciled opening balances, and reconstructing the needed tax info from bank statements. Only use this if the destroyed-books cost truly exceeds the forward value. In most cases, cleanup is cheaper.

What this costs if you hire it out

Industry rates:

• Small/clean: 6 months, 100 txns/mo, 2 accounts, no payroll. $800–$1,500.
• Medium: 12 months, 300 txns/mo, 3 accounts, payroll. $2,000–$4,000.
• Large/messy: 24 months, 500+ txns/mo, multiple entities. $5,000–$12,000.

Foxel's cleanup pricing is at the low end of that range, and we fold the forward engagement into the quote. Get a cleanup quote.