Bookkeeping clean up checklist: scope, collect, reconcile, sign off
By Arthur Teboul, DokuTrak · Published
In brief
A bookkeeping clean up checklist walks you through repairing books that fell behind: scope the period, collect every missing statement, fix duplicates and miscoded lines, reconcile month by month, then sign off with the client. Most of the delay sits in the second step, so request records before you touch the file.
The checklist: Bookkeeping clean-up checklist
Work the groups in order. Send the whole collection group to the client on day one, and keep the statement grid next to this list until every cell reads reconciled.
- PDFPrint it or tick it off on screen.Free, no email
- WordEdit it and send it under your name.Free, with your email
- Excel trackerOne row per item, with a status column.Free, with your email
Scope
- Find the last month whose reconciliations still tieIts ending balances become the clean-up starting point.
- List every account used in the periodBank, card, loan and merchant accounts, closed ones included.
- List filings that wait on the clean-upUnfiled income tax, payroll returns, Forms 1099.
- Agree the end date and fee in writing
Collect from the client
- Bank statements for every account and month in scopePDF from the bank, not a spreadsheet export.
- Credit card statements for every card and month
- Loan or mortgage statements for the periodShowing principal, interest and ending balance.
- Form 1098 for each year in scope, if the lender issues oneSole proprietors only; corporations and partnerships use the lender’s year-end statement.
- Merchant processor reportsGross sales, fees, refunds and payouts by month.
- Payroll registers and pay stubsEvery pay date in the period, from the provider.
- Last tax returns filedTo compare opening balances.
- Form W-9 for each vendor paid for services
- Vendor invoices for large or unclear payments
Fix the ledger
- Delete duplicate transactions after matching to the statement
- Code uncategorized lines; send the unknowns list to the client
- Clear undeposited funds against real deposits
- Void stale checks with the client’s written agreement
Reconcile
- Reconcile each account month by month from the last good monthMark each cell of the statement grid as reconciled.
- Clean receivables and payablesRemove paid or duplicate invoices; match bills to payments.
- Tie payroll liabilities to filed returns and deposits
- Confirm a Form 941 and deposits exist for every quarter in scopeEFTPS payment history or an IRS account transcript.
- List late Forms 1099 by payment year$600 floor for 2025 and earlier payments; $2,000 after 2025.
- Compare opening balances to the last tax returnDocument any difference in a note.
Sign off
- Write the sign-off memoPeriod, accounts, adjustments and any month lacking a statement.
- Get the client’s signature on the memo
- Set the closing date at the clean-up end date
- Start a monthly document request for the next period
Scope the job before you quote it
A clean-up quoted blind turns into unpaid hours. Before you name a price, find out how far the damage goes and what it blocks, such as an unfiled tax return or a loan renewal.
The last good month is the most recent month whose reconciliations still tie to the bank statements. Everything after it is in scope; everything before it can usually stay as it is.
Ask the client to list every account the business used in the period, including ones now closed. Closed accounts are where statements go missing, because the client no longer logs in to them.
- Open the file and find the last month whose reconciliations still match the statements.
- List every bank, card, loan and merchant account active since then.
- Note the filings that wait on the clean-up: income tax returns, payroll returns, Forms 1099.
- Set the end date of the clean-up and agree on it in writing.
Request everything at once, then track it on a grid
A clean-up runs on statements. Send one request on day one for every account and month in scope, not one email per gap as you find it.
Track the replies on a grid with accounts down the side and months across the top. Mark each cell requested, received or reconciled. The missing bank statement tracker gives you that grid ready to fill.
| Record | Why the clean-up needs it | Where the client gets it |
|---|---|---|
| Bank statements, every account and month | Each reconciliation starts from the bank’s ending balance | Online banking archive, or the branch for older months |
| Credit card statements | Charges need a closing balance to tie to | Card issuer’s website |
| Loan statements, and Form 1098 for an individual or sole-proprietor borrower | Payments mix principal and interest | Lender; Form 1098 is not issued to corporations or partnerships (IRS, Instructions for Form 1098) |
| Merchant processor reports | Deposits arrive net of fees and refunds | Processor dashboard export |
| Payroll registers and filed returns | Payroll liabilities must tie to what was filed | Payroll provider |
| Prior tax returns | Opening balances should match the last return filed | Client’s CPA or own copies |
| Form W-9 from service vendors | Forms 1099 may never have been filed | The vendors themselves |
How far back the clean-up should go
Go back to the last good month, and at least to the start of the oldest tax year still open. The IRS says to keep records for 3 years in most cases, the window in which a return can still be examined (IRS, How long should I keep records?).
Some situations reach further. The IRS says to keep records for 6 years when income of more than 25% of the gross income on the return went unreported (IRS, How long should I keep records?). Employment tax records stay for at least 4 years after the tax is due or paid (IRS, How long should I keep records?).
If the client never filed a return for a year, the IRS says to keep records indefinitely (IRS, How long should I keep records?). In that case the clean-up is the first step toward filing, and the scope follows the unfiled years.
Fix the ledger, then reconcile month by month
Start with duplicates. A bank feed plus a manual entry for the same payment is the classic case. Match each pair to the statement, keep the one that clears, and delete the other.
Next, code what is left uncategorized and build one list of unknown items for the client. Then reconcile each account, one month at a time, from the last good month forward. IRS Publication 583 describes the check: the statement, the checkbook and the books should agree, with differences such as bank charges or uncleared checks explained (IRS Publication 583, Starting a Business and Keeping Records).
By contrast, a stale check is a check written months ago that never cleared the bank. Voiding it puts the money back on the books, so get the client’s sign-off first and note the reason.
- Clear the undeposited funds account: every receipt there should match a real deposit.
- Remove paid or duplicated customer invoices from receivables.
- Match vendor bills to the payments that settled them.
- Tie payroll liability accounts to the filed returns and tax deposits.
Opening balances, contractors and missing papers
Compare the clean-up’s opening balance sheet to the balance sheet on the last tax return filed. A difference you cannot explain needs a written note, not a plug to retained earnings without comment.
A clean-up often uncovers contractors who never got a Form 1099. The floor depends on the payment year: $600 for payments made in 2025 and earlier (IRS, Instructions for Forms 1099-MISC and 1099-NEC (Rev. April 2025)), and $2,000 for tax years beginning after 2025 (IRS, Instructions for Forms 1099-MISC and 1099-NEC). Collect Form W-9 from each of them before you prepare late forms, and warn the client that a late or missing return can carry a penalty for each form (IRS, General Instructions for Certain Information Returns).
Check the payroll side the same way. Confirm that a Form 941 was filed and the deposits made for every quarter in scope, using the client’s EFTPS payment history and, where needed, an IRS account transcript.
Some statements cannot be found at all. When the bank cannot produce one, rebuild the month from the bank feed and transaction history. Mark that month as unreconciled in your sign-off memo so the client and the CPA know where the evidence is thinner.
Sign off, lock the period, keep it clean
A sign-off memo is a short note to the client listing the period cleaned, the accounts reconciled, the adjustments made and any months still lacking a statement. The client reads it and signs before you close the job.
Then set the closing date in the accounting software at the clean-up end date, so nobody edits the repaired months. Move the client onto a monthly routine with a fixed date for statements; the bookkeeping checklist sets out that rhythm.
Questions people ask
How do you clean up messy books step by step?
Find the last month that still reconciles, request every statement for the months after it, delete duplicates, code uncategorized lines, reconcile each account month by month, and fix receivables, payables and payroll liabilities. Finish with a sign-off memo and a locked period.
What do I need from the client before starting a clean-up?
You need statements for every bank, card and loan account in the period, merchant processor reports, payroll registers and filed payroll returns, the last tax returns filed, and Form W-9 from each service vendor.
What if the client cannot get an old bank statement?
Ask the bank first: many keep statement archives for years. If none exists, rebuild the month from the transaction history and flag it as unreconciled in the sign-off memo, so the gap is documented.
How far back should a bookkeeping clean-up go?
Back to the last month that still reconciles, and at least to the oldest tax year still open. The IRS says most records should be kept 3 years, and longer in some cases, such as large unreported income (IRS, How long should I keep records?).
Sources
- IRS Publication 583, Starting a Business and Keeping Records: Describes reconciling the checking account: the statement, checkbook and books should agree, with differences explained.
- IRS, How long should I keep records?: Keep records 3 years in most cases, 6 years if more than 25% of gross income went unreported, indefinitely if no return was filed, employment tax records at least 4 years.
- IRS, Instructions for Forms 1099-MISC and 1099-NEC: For tax years beginning after 2025, the threshold for reporting certain payments, including nonemployee compensation, is $2,000.
- IRS, Instructions for Forms 1099-MISC and 1099-NEC (Rev. April 2025): For 2025 payments, Form 1099-NEC reports nonemployee compensation of at least $600.
- IRS, Instructions for Form 1098: Form 1098 reports mortgage interest received from an individual, including a sole proprietor; it is not filed for interest received from a corporation, partnership, trust or estate.
- IRS, General Instructions for Certain Information Returns: A payer that fails to file a correct information return by the due date, without reasonable cause, may be subject to a penalty.
About the author
Arthur Teboul (Founder, DokuTrak) is building DokuTrak after watching professionals lose hours chasing clients for documents over email. Arthur Teboul.
Editorial standards
How this page was made (methodology): it is built from the primary sources listed under Sources, and every rule and figure on it links to the source it comes from. Last updated October 25, 2026. Spotted an error or a rule that changed? Contact us.
Ask once. DokuTrak does the chasing.
- Your client uploads from one link, with no account and no password.
- Reminders go out on a schedule, by default 2, 5, 10 and 14 days after the request, until the file arrives.
- With AI review switched on in your workspace (it is off by default), each upload gets a first pass that flags a file that is not the requested document or an unreadable or blurry scan. It says so when it is not sure.
- You accept every file or mark it for re-upload, and your client gets the note by email. The AI never accepts a file.