Catch-up bookkeeping: a 30-day cleanup playbook

The worst set of books we ever inherited had fourteen months of unreconciled Shopify deposits sitting in a suspense account the previous bookkeeper had renamed “Ask Accountant” and then never asked. That’s not a rare story. Catch-up bookkeeping engagements almost never arrive because a business owner planned one — they arrive because a lender asked for financials, a tax deadline forced the question, or a new bookkeeper opened the file and went quiet for a week. This is the methodology we run every time, in the same order, because the order is what keeps a 30-day engagement from becoming a 90-day one.

Stage 1: Triage (days 1–4)

Before touching a single transaction, we build an inventory of what’s actually broken. This is not optional and it is the stage most cleanups skip, which is why they run long.

Pull a full transaction export and bank/credit card statement history for the entire gap period — every account, every month, no assumptions about what’s “probably fine.”
Identify the last date the books were genuinely reconciled (not the last date someone clicked “reconciled” — those are frequently different dates).
Flag categories of damage: uncategorized transactions, duplicate entries, missing bank feeds, unreconciled clearing/suspense accounts, negative balances that shouldn’t be negative (a bank account or AR balance in the red is usually a symptom, not a fact).
Size the job in transaction count and account count, not months — a business with 40 transactions a month and 14 months of gap is a different job than one with 800 transactions a month and four months of gap, even though the second has a shorter gap.

Output of Stage 1: a written scope memo with an effort estimate and a materiality threshold for the cleanup (we typically use a threshold of $50–$250 depending on entity size — differences below that line get a standard adjusting entry rather than individual investigation, or the engagement never ends).

Stage 2: Bank and credit card reconciliation (days 3–14, overlapping Stage 1’s tail)

This is the spine of the whole engagement. Every other stage depends on the bank data being right first.

Reconcile every bank and credit card account, month by month, in chronological order — never skip ahead to “catch up” a later month before an earlier one balances, because unresolved variances compound and become impossible to trace back.
Match every transaction to a bank feed line; anything without a matching source (a check, a wire, a cash deposit) gets flagged and sent back to the client with a specific, dated question — not a general “please clarify these 40 items” list that guarantees a two-week non-response.
Clear or properly reclassify suspense and undeposited funds accounts. These accumulate because someone didn’t know where an item belonged and parked it “temporarily” — temporarily, in our experience, has a median length of 11 months.
For payment-gateway businesses (Shopify, Stripe, PayPal), reconcile gross sales, fees, and payouts separately — the deposit hitting the bank is a net figure, and booking it as revenue without backing out fees and refunds is the single most common error we find in e-commerce books.

By the end of Stage 2, every bank and card account ties to a bank statement balance to the cent, for every month in the gap.

Stage 3: AR/AP aging reconstruction (days 10–20, overlapping Stage 2)

With cash accounts clean, we turn to what the business is owed and owes.

Rebuild the AR aging from actual invoices and payments, not from a stale aging report carried forward — invoices marked paid that weren’t, and vice versa, are the norm in neglected files.
Write off aged receivables the client confirms are uncollectible, with client sign-off documented (this is a client decision, not a bookkeeping one, though we flag anything aged past 180 days as a candidate).
Rebuild AP the same way against vendor statements where available; unrecorded liabilities (a bill the business paid outside the accounting system, or one that arrived late) are the most common source of a “surprise” expense that surfaces at tax time.
Reconcile any loan, credit card, or line-of-credit balance against the lender’s statement directly, not against what the books assumed the balance was.

Stage 4: Equity and loan account cleanup (days 15–24, overlapping Stage 3)

The account that gets the least attention and causes the most tax-season pain.

Reconcile owner draws, contributions, and retained earnings roll-forward against actual bank transfers — a common finding is personal expenses run through the business account for a year and never reclassified, which distorts both the P&L and the balance sheet equity position.
Confirm loan principal and interest are split correctly — we regularly find an entire loan payment booked to interest expense (or vice versa) for a year or more, which misstates both interest expense and the loan balance on the balance sheet.
True up any related-party or intercompany balances if the business has more than one entity — these tend to drift silently for years without a monthly intercompany reconciliation.

Stage 5: Re-close and financial statement re-issue (days 25–30)

Re-run and lock each month’s close in chronological order, generating a clean trial balance for every closed period in the gap.
Produce a variance summary against whatever financials existed before the cleanup (if any) — a lender, tax preparer, or the owner needs to see what changed and why, not just a new set of numbers with no bridge to the old ones.
Issue a findings memo alongside the financials: what was broken, what was corrected, what needs an ongoing process change to avoid recurrence (the most common recommendation we make is a monthly bank reconciliation cadence — the single highest-leverage habit that prevents this exact engagement from recurring).

Realistic effort ranges

For a single-entity SMB with one or two bank/card accounts and standard transaction volume (under 300 transactions/month):

6-month gap: 25–40 hours
12-month gap: 45–70 hours
24-month gap: 80–130 hours (rarely fits inside 30 calendar days at this volume — expect 45–60 calendar days, run in parallel workstreams rather than sequential months)

Multi-entity structures, inventory accounting, or payroll reconciliation gaps add 20–40% on top of these ranges. Any quote that doesn’t move with transaction volume and account count is guessing.

Q&A

Can a 24-month bookkeeping gap really be closed in 30 days? Usually not at full accuracy for higher-volume businesses — 24 months of neglected books at meaningful transaction volume typically needs 45–60 calendar days run across parallel workstreams (different months or account groups handled simultaneously by different preparers), rather than one person working sequentially. Anyone quoting a fixed 30 days regardless of volume hasn’t sized the job yet.

What do we do about receivables we know we’ll never collect? Flag them during Stage 3, get explicit client sign-off on the write-off (this is a business decision with tax implications, not a bookkeeping call to make unilaterally), and record the write-off with a dated memo referencing the client’s confirmation.

Do you reconcile Shopify/Stripe payouts differently from a regular bank deposit? Yes — the bank deposit is a net figure after fees, refunds, and holds are netted out by the payment processor. Booking the deposit directly as revenue, without separately recording gross sales, processing fees, and refunds, is the most common misstatement we find in e-commerce books, and it distorts both revenue and expense lines.