A bookkeeping cleanup checklist is the ordered list of tests and fixes you run on client books that are up to date but wrong. It starts with opening balances, removes duplicate entries, corrects miscoded months and ends with every account reconciled to its statements. Each item has a pass condition, so you know when the cleanup is done.
What does a bookkeeping cleanup cover that catch-up work does not?
A bookkeeping cleanup repairs books that already contain entries for every month but cannot be trusted. Catch-up work fills in months that were never recorded. In a cleanup, the problem is not missing work. It is wrong work: balances that never tied, transactions entered twice, and accounts used one way in spring and another way in autumn.
Signs a client needs a cleanup
- The bank balance in the books does not match the bank statement, and nobody knows why.
- Reconciliations were marked complete, but with a large "adjustment" line to force them through.
- The profit and loss shows months with no rent, or two rent payments.
- Uncategorized or "ask my accountant" balances have been growing for months.
- The client's tax preparer has sent the books back with questions.
Why the distinction matters
Cleanup and catch-up need different starting points. Catch-up starts from the last good month and moves forward. Cleanup has no last good month until you find one. That is why the checklist begins by testing balances rather than entering anything. If the books turn out to have whole months missing as well, run the catch-up after the cleanup has fixed the starting point.
Testing opening balances before any other cleanup fix
Testing opening balances means checking that each balance sheet account starts the cleanup period at the right figure. Every later reconciliation depends on that figure. If the opening cash balance is wrong by 1,200.00, every month after it will be wrong by the same amount, and no amount of recoding will make the reconciliation tie.
The test for bank and card accounts
For each bank and card account, compare the balance in the books on the first day of the cleanup period with the opening balance printed on that month's statement. They should be equal. If they are not, step back one month at a time until you find the first month where the books and the statement agree. That month is your true starting point.
Balances that are not on a statement
Loans, owner equity, fixed assets and payables do not come from a bank statement. Check them against the source that does carry them: a loan statement, the prior year's tax return or the year-end figures from the client's preparer. The guide to setting opening balances for new client books covers where each of those figures comes from and how to enter them.
When a statement is missing
You cannot test a balance without the statement for that month. If a client cannot find one, or the file they have is unreadable, ask the bank for a copy before going further. How to request a replacement bank statement explains what to ask for and what to post in the meantime.
Duplicate entries left by bank feeds and statement imports
Duplicate entries are transactions recorded twice, usually because two routes brought the same bank activity into the books. A bank feed and a manual import overlap. A statement is imported, then imported again after a fix. Each duplicate inflates income or expenses and pushes the bank balance away from the statement.
Where duplicates hide
- Months where a bank feed was reconnected. Feeds often re-download a window of history when they reconnect.
- Months where the bookkeeper changed, and the new person re-imported "to be safe".
- Card payments recorded once as a transfer and once as an expense.
- Deposits entered from a sales report and again from the statement.
A worked example of a duplicate found by the balance gap
The figures below are an example. A client's checking account shows a book balance of 18,640.00 at the end of March. The March statement's closing balance is 19,890.00. The books are 1,250.00 lower than the bank.
Sorting March's book entries by amount shows two payments of 1,250.00 to the same landlord, dated March 1 and March 3. The statement shows one. The second entry came from a CSV import that overlapped with the feed. Deleting it brings the book balance to 19,890.00, and the March reconciliation ties without an adjustment.
That is the general method. Find the gap between books and statement, then look for a single entry, or a pair, that matches the gap. A gap that matches no entry usually means more than one problem in the same month.
Removing them safely
Delete the duplicate, not the original. Keep the entry that matches the statement line's date and description, and remove the other. Note each removal in your cleanup log with the date and amount, so the client and their preparer can see what changed.
Miscoded months and category drift in a cleanup
Category drift is when the same kind of transaction is coded to different accounts in different months. Software subscriptions go to "Office expenses" until June and "Dues and subscriptions" after. A loan payment is coded fully to expense for half the year. Drift does not affect the bank balance, so reconciliations pass while the profit and loss is wrong.
How to find drift
Run a report of each expense account by month for the cleanup period. Look for accounts that are empty for a stretch and then full, or two accounts that seem to swap. Then pick the client's largest vendors and list where each one was coded month by month. A vendor that lands in two or three accounts is a drift candidate.
Fix by rule, not by line
Once you know where a vendor belongs, recode every line for that vendor at once, then write a rule so new lines go to the same place. Recoding one line at a time takes longer and misses some. Industry clients have their own traps here. A landlord's books, for example, often mix tenant deposits with rent income, which property management bookkeeping from bank statements separates.
Ask before you move large amounts
When a recode would change profit by a material amount for a year already filed, raise it with the client and their tax preparer before posting. The fix may belong in the current year as a correction rather than in the filed year.
The bookkeeping cleanup checklist, item by item
The bookkeeping cleanup checklist below runs in order. Each item has a pass condition, which is the evidence that the item is finished. Do not start an item until the one above it passes, because each fix assumes the earlier ones are in place.
| # | Item | Pass condition |
|---|---|---|
| 1 | Collect every bank and card statement for the cleanup period | A statement for each account and month is on file |
| 2 | Find the last month where books and statement agree | Book balance equals statement opening balance for that month |
| 3 | Correct non-bank opening balances | Loans, equity and assets match their source documents |
| 4 | Remove duplicate entries month by month | Each month's gap to the statement is zero or explained |
| 5 | Recode drifted vendors and accounts | Each major vendor is coded to one account across the period |
| 6 | Clear uncategorized and suspense balances | Those accounts are at zero, or each remaining line has an open question |
| 7 | Reconcile every account for every month | Each reconciliation ties with no forcing adjustment |
| 8 | Review the profit and loss by month | No missing or doubled recurring costs |
| 9 | Write rules for the client's recurring vendors | Next month's lines code without manual work |
| 10 | Send the client and preparer a change summary | They have a list of what was changed and why |
Keep a cleanup log
Alongside the checklist, keep a short log: date, account, what was wrong, what you changed and the amount. The log is what you hand the client at the end, and it answers the preparer's questions before they ask.
Use the statements as the record
The statements are the one record of the period nobody has edited. Converting each month's statement into rows gives you something to compare the books against line by line. AutoBankConvert converts a whole period of a client's statements in one batch and checks each one's opening balance, transactions and closing balance, so the comparison starts from statements known to be complete.
How long does a books cleanup take per client year?
A books cleanup takes as long as the number of problems it finds, which is why an estimate made before testing is a guess. A year with a correct opening balance and a few drifted vendors may take a few hours. A year with a bad starting point, a reconnected feed and a change of bookkeeper can take days.
Estimate after item 2
Run the first two checklist items before you quote. Once you know the true starting point and the size of each month's gap, you can count the months that need work and the likely causes. Then estimate per month, not per year.
Time the work you can measure
Some parts are predictable: collecting and converting statements, and reconciling clean months. Time them on one month before you extrapolate. The method in timing data entry for one client statement applies here, and it gives you a real number per statement to multiply.
When cleanup fixes should stop and the books be rebuilt
A cleanup should stop and become a rebuild when fixing the existing entries would take longer than recording the period again from statements. That point arrives when most months have duplicates, when nobody can say which entries came from where, or when the chart of accounts itself needs replacing.
Signs to rebuild instead
- More than half the months fail to reconcile by amounts that match no single entry.
- Entries were imported from several sources and no one kept track of which.
- The chart of accounts has dozens of overlapping accounts the client does not use.
- Earlier reconciliations were forced with adjustments in nearly every month.
What a rebuild looks like
A rebuild sets a starting balance at the last good month, removes or reverses the period's bank entries, and records the period again from the statements with a clean set of accounts and rules. It sounds larger than a cleanup, but on a badly damaged file it is often faster, and the result is books you can prove.
Whichever path you take, agree the choice with the client in writing, and keep the old file or a backup until the new books have been reviewed. If the next step is converting a year of statements to rebuild from, AutoBankConvert is set up for that kind of batch.