Bookkeeping Clean-Up and Catch-Up: A Step-by-Step Guide

Few things worry a small business owner more than books that are months behind, a tax deadline approaching and a pile of unopened statements. Accountants and bookkeepers see it constantly: a business that started with good intentions, a bank feed that disconnected, a bookkeeper who left, a year of transactions dumped into "uncategorized" or a software migration that went wrong.

Bookkeeping clean-up, also called catch-up or remedial bookkeeping, is the process of getting those books into a complete and reconciled state. This guide gives a practical, step-by-step method that works for owners doing it themselves and for professionals running clean-up projects for clients. It covers assessment, data gathering, rebuilding from bank statements, reconciliation, balance sheet fixes, quality review and how to price the work.

Clean-up vs catch-up

The terms are often used interchangeably, but they describe different starting points:

Situation	Typical cause	Main work
Catch-up	Books simply not kept for a period	Enter and categorize transactions from scratch
Clean-up	Books kept, but with errors	Find and correct mistakes, reconcile
Both	Partial, error-ridden records	Assess, decide whether to fix or rebuild

Many projects are both: some months were entered, badly, and others not at all. One of the first decisions is whether to fix the existing entries or delete them and rebuild from the bank statements. Rebuilding is often faster when the existing records are badly wrong.

Step 1: Assess the current state

Before touching anything, take stock:

• Which software is in use, and who has access?
• Last reliable point: when were the books last reconciled or used for a tax return?
• Accounts: list every bank account, credit card, loan, payment processor and merchant account.
• Bank feeds: are they connected, and since when? Are there gaps?
• Volume: roughly how many transactions per month?
• Problem indicators: unreconciled accounts, large "uncategorized" or "ask my accountant" balances, negative bank balances in the books, opening balance equity, suspense accounts.
• Other systems: payroll, invoicing, inventory, point of sale.
• Deadlines: tax filings, lender reporting, a sale or a funding round.

Write a short assessment with findings, proposed approach and estimate. Include a list of what you need from the owner and by when, because missing information is the most common reason clean-ups overrun. For professionals, this becomes the basis for the engagement letter.

Step 2: Choose a start date and opening balances

Clean-up needs an anchor: a date at which you trust the balances. Usually this is the end of the last financial year that was filed with the tax authority, because those balances are already reported.

• If the books agree with the filed return at that date, start the day after.
• If they do not, decide with the client's accountant whether to correct prior periods or post adjustments in the current period.
• If no reliable year-end exists, choose a date and build opening balances from bank statements, loan statements and lists of receivables and payables at that date.

Lock the period before the start date in the software, so nothing changes it accidentally.

Step 3: Gather every statement

The bank and card statements are the backbone of a clean-up, because they are complete and independent. Collect:

• Bank statements for every account for every month from the start date to today.
• Credit card statements.
• Loan statements showing principal, interest and balances.
• Payment processor and marketplace reports (PayPal, Stripe, Square, Shopify, Amazon).
• Payroll reports.
• Sales invoices and supplier bills where they exist.
• Receipts for significant expenses.

Check continuity for each account: every month present, closing balance equals next opening. If statements are missing, download them from online banking or request them from the bank. See how to get old bank statements for older or closed accounts.

Step 4: Get transactions into the software

There are three sources of transaction data:

1. Bank feeds, if connected, but often only for recent months. Many banks provide only a limited history when a feed is first connected.
2. CSV, OFX or QBO downloads from online banking, often limited to a certain number of months back.
3. PDF statements, which are always available but need converting.

For gaps and history, convert PDF statements into importable files. A bank statement converter creates Excel, CSV or QBO files from PDFs and scans; StatementPilot checks every statement's balances so you know the file is complete. Then import into the accounting software:

• How to import bank statements into QuickBooks
• How to import bank statements into Xero
• How to import bank statements into Sage

Avoid duplicates. Before importing, check which dates already have transactions from a feed or earlier import. Import only the missing periods. Duplicates are the most common clean-up mistake and can double revenue or expenses.

Step 5: Clear out the junk

Existing books often contain:

• Duplicate transactions from overlapping feeds and imports.
• Manually entered transactions that were later also imported.
• Transactions in the wrong account, such as card spending posted to the bank account.
• Deleted or voided items that left reconciliation gaps.
• Entries dated in the wrong year.

Run a report of transactions by account and date. Sort by amount and date to find duplicates. Use the bank statement as the arbiter: if a transaction does not appear on the statement, it should not be in the bank account in the books (except genuine uncleared items).

Step 6: Categorize transactions

With a complete set of transactions, categorize them. Work in this order:

1. Transfers between accounts, including credit card payments, which are not income or expenses.
2. Loans, owner contributions and drawings, which go to balance sheet accounts.
3. Recurring payees, using bank rules. Most transactions in a typical small business come from a short list of payees.
4. Revenue, matched to invoices where accounts receivable is used.
5. Bills, matched to supplier bills where accounts payable is used.
6. Everything else, with a "to review" account for items the owner must explain.

Our transaction categorization guide explains how to combine rules and AI suggestions, and how to categorize business expenses gives a sensible category list.

Collect the questions for the owner in one list with date, amount, description and your best guess. A single meeting or a shared spreadsheet resolves them far faster than piecemeal emails.

Step 7: Reconcile every account, every month

Reconciliation proves the books match the bank. Do it month by month, oldest first, for each account:

• Statement closing balance in the reconciliation equals the actual statement.
• Every transaction on the statement is matched or added.
• Uncleared items at month-end are genuine (cheques issued, deposits in transit) and clear the following month.

Do not move on to the next month until the current one reconciles. A difference carried forward becomes much harder to find. Our guide on how to reconcile a bank statement covers the mechanics, and our reconciliation calculator helps check the arithmetic.

Worked example: finding a reconciliation difference

A clean-up of a café's books reaches March. The statement closing balance is 8,412.60; the books show 8,672.60, a difference of 260.00. Steps:

1. Is 260 a single transaction? Search for 260.00: none.
2. Is it half of a transposed or duplicated amount? 130.00 appears twice in the books on 14 March but once on the statement: a duplicate. Removing it leaves a 130.00 difference.
3. Search again for 130: no other candidate. Check for transposition: a difference divisible by 9 often indicates swapped digits. 130 is not divisible by 9.
4. Compare deposit totals: the books show one more deposit of 130.00 on 22 March, a card settlement that appears on the statement on 1 April. It is a genuine deposit in transit, dated in the books on the sale date.

After removing the duplicate and treating the 22 March settlement as uncleared, March reconciles. The deposit clears in April, as it should.

Step 8: Fix the balance sheet

Profit and loss errors are visible; balance sheet errors hide. Review every balance sheet account at the end of the clean-up period:

• Bank and cards: equal to reconciled statement balances.
• Accounts receivable: aged list of open invoices that customers really owe. Remove duplicates, apply unmatched payments, write off genuinely uncollectable amounts with the owner's approval.
• Accounts payable: open bills that are really owed. Match payments made through the bank to bills.
• Loans: agree balances to lender statements; split payments into principal and interest.
• Payroll liabilities: agree to payroll reports and tax authority accounts.
• Sales tax or VAT: agree to returns filed and payments made.
• Fixed assets: record significant purchases and depreciation as required.
• Suspense, uncategorized and opening balance equity: should be zero or explained.

Each corrected balance should be supported by a document: a statement, a schedule or a report.

Step 9: Review the financial statements

When everything is reconciled, step back:

• Does the profit and loss look reasonable month by month? Large swings may reveal miscategorization.
• Are gross margins in line with the business model?
• Do revenue totals agree with sales platform reports?
• Are payroll costs consistent with payroll reports?
• Is owner pay recorded correctly for the entity type?

A second person's review catches things the preparer cannot see. For accountants, this is often where the clean-up hands over to year-end work.

Step 10: Document and set up a routine

Finish by documenting what you did and setting up a process that keeps the books clean:

• Clean-up memo: start date, accounts covered, key adjustments, open issues.
• Locked periods up to the end of the clean-up.
• Bank feeds reconnected and working, with rules for recurring payees.
• A monthly routine: categorize weekly, reconcile monthly, review receivables and payables. Our month-end close checklist is a useful template.
• Receipt capture for expenses.

Clean-up after a software migration

Moving from one accounting system to another, for example from a desktop product to a cloud one, is a frequent cause of messy books. Conversions can bring across duplicate accounts, unmatched payments, broken links between invoices and payments, and opening balances that do not agree with the old system.

If a migration caused the problem:

1. Compare trial balances from the old and new systems at the conversion date. Every account should agree.
2. Compare open receivables and payables lists at the same date.
3. Check bank reconciliation status: reconciled transactions in the old system may arrive unreconciled in the new one, and uncleared items may be lost.
4. Decide the conversion approach: many businesses bring across only balances and open items at a year-end, then import detailed history from bank statements if needed, rather than migrating every historical transaction.

Fixing migration issues early, at the conversion date, prevents months of compounding differences.

A clean-up checklist you can reuse

Use this as a working checklist for each project:

• Assessment written and agreed, with start date and scope
• Periods before start date locked
• All accounts listed: bank, card, loan, processor, payroll
• Statements complete for every account and month
• Missing periods converted and imported, no overlaps
• Duplicates and wrongly posted items removed
• Transfers and card payments matched
• Loans, contributions and drawings posted to balance sheet
• Transactions categorized; owner question list resolved
• Every account reconciled monthly
• Receivables, payables, payroll and tax balances agreed
• Suspense and uncategorized accounts cleared
• Financial statements reviewed by a second person
• Clean-up memo written; routine agreed with the client

Pricing a clean-up project

For professionals, clean-ups are notoriously hard to estimate. Common approaches:

Pricing method	When it works	Risk
Fixed fee per month of catch-up	Volume is predictable	Messy months take far longer
Fixed fee per account-month	Several accounts with varying activity	Needs a good transaction count
Hourly	Scope is unclear	Client uncertainty, less incentive to be efficient
Fixed fee with assessment phase	Large or messy projects	Requires a paid assessment first

Base estimates on transaction counts, number of accounts, whether PDF conversion is needed, the state of receivables and payables, and the client's responsiveness. Converting statements automatically rather than typing them is one of the largest efficiency gains available and makes fixed fees much safer. See our bookkeeping clean-up use case and bookkeepers page.

How long does a clean-up take?

It varies with volume and complexity. A sole trader with one account and a few hundred transactions a year might take a day or two. A busy business with several accounts, card processors, inventory and payroll, twelve months behind, can take weeks. The biggest time sinks are typically:

• Missing statements that must be requested.
• Unresponsive owners with unanswered questions.
• Duplicates from overlapping feeds and imports.
• Receivables and payables that were never maintained.
• Typing transactions from PDFs, which automation removes.

Common pitfalls

• Starting without a reliable opening balance.
• Importing overlapping periods, creating duplicates.
• Categorizing before transactions are complete, then redoing the work.
• Skipping months in reconciliation, so differences compound.
• Ignoring the balance sheet once the profit and loss looks right.
• Changing filed periods without coordinating with the accountant.
• No documentation, so the next person cannot understand the adjustments.

Frequently asked questions

What is a bookkeeping clean-up?

It is the process of correcting and completing a business's books so that every account is reconciled to bank and other statements, transactions are correctly categorized and balance sheet accounts are accurate. It is needed when books are behind, contain errors or have been neglected.

Should I fix the existing books or start over?

If most existing entries are correct, fix them. If the books are badly wrong, with duplicates, missing months and unreconciled accounts, deleting the transactions after the start date and rebuilding from bank statements is often faster and more reliable. Keep a backup before deleting anything.

Can I catch up bookkeeping from PDF bank statements?

Yes. Convert the PDFs into CSV or QBO files with a converter, check that each statement's balances reconcile, and import them into your accounting software. This is usually much faster than typing transactions and avoids transcription errors.

How far back should a clean-up go?

Back to the last date when balances were reliable and accepted, usually the end of the last filed tax year. Going further back is only necessary if earlier filed figures are known to be wrong, which is a decision to make with your accountant.

Who should do a bookkeeping clean-up?

Owners with simple books and time can do it themselves using the steps above. For several accounts, payroll, inventory, sales tax or a looming deadline, a bookkeeper or accountant who does clean-ups regularly will usually be faster and will spot balance sheet problems an owner might miss.

What does a bookkeeping clean-up cost?

Costs depend on the number of months, accounts and transactions, the condition of the records, and the provider's pricing method. Get a quote after an assessment, and ask how statement conversion and owner questions are handled, since those drive time.

Summary

A bookkeeping clean-up succeeds when it is systematic: assess, set a trusted start date, gather every statement, convert and import missing periods without duplicates, categorize in a sensible order, reconcile month by month, fix the balance sheet, review and document. Then put a routine in place so the books never fall behind again.

Start converting statements with StatementPilot to turn months of PDFs into import-ready files in minutes and take the typing out of catch-up work.