Guides
How to Do a Bookkeeping Cleanup for a New Client Without Redoing the Year
Bookkeeping cleanup for new client: a step-by-step method to triage and fix messy books without redoing the year, plus checks for a clean handoff.
What to take away
- A cleanup fixes the books from the point you take over, without reconstructing every month of the prior year.
- Cash reconciliation comes first because it exposes the largest share of errors.
- Each corrected account needs a visible tie-out to a bank, credit card, loan, or tax statement.
- Stop and hand the file to a CPA or EA when payroll, sales tax, or omitted income appears materially wrong.
Begin with the takeover date and the state of the existing file. Ask the client for bank statements, credit card statements, loan statements, and prior tax returns. Do not accept a summary profit and loss as the source of truth. Use underlying records, not a re-created report.
Start with a full-year trial balance
Export or print a full-year trial balance from the current accounting system. If the client has no software, build a working trial balance from bank and credit card downloads. Mark the last reconciled month. That month is the cutoff for what you fix and what you leave alone.
Set the Cleanup Cutoff
- Export full-year trial balance
- Build working trial balance if no software
- Mark last reconciled month
- Treat that month as cutoff
- Write one-page cleanup scope
IRS Publication 538, Accounting Periods and Methods, explains the rules for accounting periods and methods you need to apply. An unclean cutoff can lead to duplicated income or missed deductions. Before touching any account, write a one-page cleanup scope.
The cleanup sequence
- Pull a full-year trial balance and a list of all bank, credit card, and loan accounts.
- Reconcile every cash account first, month by month, from the oldest unreconciled period to the takeover date.
- Confirm the opening balance for each balance sheet account using a statement, loan amortization schedule, or prior tax return.
- Run the uncategorized transaction report and post each item to the correct income, expense, asset, or liability account.
- Compare the profit and loss categories to the relevant IRS Schedule C expense categories.
- Add missing receivables, payables, payroll liabilities, and sales tax liabilities from source documents.
- Post the adjusting entries with a brief note or attached support in the cleanup file.
- Produce a final trial balance at the takeover date and tie the net income to the prior year tax return if that return exists.
Build this sequence into the firm’s client onboarding and ongoing-service scope; the bookkeeping firm plan can help keep the cleanup from drifting into advisory work. The visible result is a clean starting set of books.
Eight-Step Cleanup Sequence
- Pull trial balance and account list
- Reconcile every cash account month by month
- Confirm opening balance sheet balances
- Clear uncategorized transaction report
- Compare P&L to IRS categories
- Add missing receivables and liabilities
- Post adjusting entries with support
- Produce final trial balance at takeover
The step that decides the result
Cash reconciliation decides nearly everything. If the bank and credit card accounts do not tie to statements, every other account remains suspect because cash is the hub for income and expenses. Reconcile cash before touching accounts receivable, fixed assets, or loans. A balanced cash history gives you a reliable anchor for the rest of the cleanup.
For firms that repeat this work, a bookkeeping firm SOP checklist can define who pulls statements, who clears old transactions, and who signs off before closing a month.
How to check each step came out right
Each cleanup step has a visible check. Do not move on until the check passes. Use this table as a running scorecard.
| Check | Pass condition |
|---|
Cleanup Scorecard Checks
- Bank and credit card ties to statement
- Trial balance debits equal credits
- Uncategorized count zero or explained
- Balance sheet accounts have support
| Check | Pass condition |
|---|---|
| Trial balance and cutoff | The account list is complete, the last reconciled month is marked, and the cleanup scope identifies what is included. |
| Cash reconciliation | Each account’s ledger balance ties to its statement for each month reviewed; unresolved items are listed rather than concealed. |
| Opening balances | Each balance sheet opening balance is supported by a statement, loan schedule, or prior tax return, with any difference documented. |
| Uncategorized transactions | Every item is categorized with support or recorded as an unresolved exception; no item is silently written off. |
| Profit and loss categories | Each category is mapped to an appropriate bookkeeping or tax-reporting category, with personal or otherwise nondeductible items identified. |
| Receivables, payables, and tax liabilities | Balances are supported by source documents and available payroll or sales tax filings; unsupported amounts are flagged. |
| Adjusting entries | Entries balance, include a brief explanation, and have attached or linked support in the cleanup file. |
| Final trial balance | The report is dated at the takeover cutoff, account tie-outs are attached, and any difference from prior-year tax-return net income is explained. |
IRS Schedule C (Form 1040), Profit or Loss From Business, lists expense categories including advertising; car and truck expenses; commissions and fees; contract labor; depletion; depreciation; employee benefit programs; insurance; interest; legal and professional services; office expense; pension and profit-sharing plans; rent or lease; repairs and maintenance; supplies; taxes and licenses; travel; deductible meals; utilities; wages; and other expenses. Map bookkeeping accounts to the relevant tax categories rather than forcing every account into a tax line. Your bookkeeping firm software and KPI guide should support clear tie-outs. For example, in QuickBooks Online, use reconciliation reports and Transaction Detail by Account; check the account, statement ending date and balance, cleared status, and any unexplained difference. A complete scorecard means the cleanup file can be handed to monthly bookkeeping with confidence.
What to do when a step goes wrong
The most common failure is a missing bank statement or a corrupted file. Ask the client to download PDF statements from the bank portal. If a statement no longer exists, mark the gap and do not invent transactions. Rebuild the period from payroll registers, merchant reports, and tax filings, then note that the missing period was reconstructed rather than reconciled.
A wrong opening balance usually comes from an account that was never reconciled. Fix the earliest unreconciled month before correcting later ones.
When to stop and hand it to a professional
Stop the cleanup and bring in a CPA or an enrolled agent when you find any of these conditions. Payroll tax returns appear unfiled. Sales tax collected in the ledger does not match state filings. Income appears to have been omitted from prior returns. Do not adjust those items yourself. A cleanup is a bookkeeping repair, not a legal or tax representation.
Federal payroll filings may include IRS Forms 941, Employer’s Quarterly Federal Tax Return, and 940, Employer’s Annual Federal Unemployment (FUTA) Tax Return. State requirements depend on the client’s location; for example, California payroll tax filings involve the Employment Development Department (EDD), including Forms DE 9 and DE 9C. For sales tax, California’s Department of Tax and Fee Administration (CDTFA) and New York State’s Department of Taxation and Finance are examples of state agencies; New York sales tax filers may use Form ST-100. Confirm the client’s state, tax account, and filing history before identifying a missing return. The IRS state government websites directory can help locate the relevant state government website.
For the monthly retainer after cleanup, avoid taking on tax filing liability by keeping your bookkeeping firm service menu focused on bookkeeping, not tax preparation.
Example: An overstated vendor account
A new client's ledger showed a $12,000 balance in a vendor account that had been closed for two years. The cleanup found that each monthly bill was entered twice. The recovery was to void the duplicate entries, attach the vendor statement, and mark the account reconciled to zero. The visible check was a zero balance on the trial balance plus a note linking to the vendor statement.
