Bookkeeping catch-up: how to turn months of bank statements into clean books

A bookkeeping catch-up starts with your bank statements, because they hold a full record of every dollar that moved while the books sat untouched. Collect a PDF for every month on every account and card, turn each one into a spreadsheet, prove each month balances, then categorize, import and reconcile one account at a time.

On this page

1. Why the bank statements come first
2. Step 1: gather every statement for the full date range
3. Step 2: convert the statements to spreadsheets
4. Step 3: check that each month balances
5. Step 4: categorize the transactions
6. Step 5: import into QuickBooks or Xero
7. Step 6: reconcile each account month by month
8. Common bookkeeping catch-up mistakes
9. How long to keep the statements and rebuilt books
10. Bookkeeping catch-up questions

Why the bank statements come first

Receipts get lost and invoices go unsent, but the bank keeps a statement for every month whether you looked at it or not. That makes the statements the skeleton of the catch-up: once every deposit and payment from them is in your books, the rest of the work is labeling and matching.

Working from statements also gives you a fixed target. Each statement ends with a closing balance printed by the bank, and your books for that account are right for that month only when they reach the same number.

Step 1: gather every statement for the full date range

Pick the start date first. It is the day after the last month you reconciled, or the start of the fiscal year if the books were never reconciled. The end date is the last statement the bank has closed.

Then list every account money passed through in that period:

• Business checking and savings accounts
• Business credit cards, including any card you closed during the gap
• Lines of credit and loan accounts
• Any personal account or card that paid a business cost or received a business payment

A simple grid stops months from slipping through. Put accounts down the side and months across the top, and tick each cell when the PDF is saved.

Download the PDFs from online banking where you can. For older months, or an account that is now closed, ask the bank how to request copies; our bank guides explain where each bank keeps its statements and how far back they go online.

Step 2: convert the statements to spreadsheets

Typing months of transactions by hand is slow and invites mistakes, so convert the PDFs instead. Our bank statement converter turns each statement into Excel or CSV with date, description, amount and balance, with money out as a negative number. Upload several PDFs together and you get one spreadsheet, with a column showing which file each row came from.

Keep each account in its own file. Mixing checking and credit card rows in one sheet makes the balance checks in the next step much harder to read.

A long catch-up can run past the free allowance of 3 pages a day without an account, or 15 with a free account. You can spread the work over several days, or use a paid plan if you also want QuickBooks or Xero files.

Step 3: check that each month balances

Before you categorize anything, prove the rows are complete. For every statement, opening balance plus deposits minus withdrawals has to equal the closing balance the bank printed.

The converter does this row by row. It checks every running balance against the row before it and flags any row that doesn't add up, and its Summary sheet checks the opening and closing balances against the statement. A flagged row usually means a misread amount or a line that wrapped oddly on the PDF, so fix it against the original page before you move on.

Then check the joins between months. The closing balance on March has to match the opening balance on April. If it doesn't, a statement is missing, or you saved two different versions of the same month.

Step 4: categorize the transactions

With clean rows, add a category column and label each transaction with an account from your chart of accounts. If you work with an accountant, ask for their list first so you don't have to relabel everything at year end.

Sorting by description speeds this up, because the same vendor usually appears every month. Watch these types of rows closely:

• Transfers between your own accounts, which are not income or expenses
• Owner contributions and owner draws
• Credit card payments, which move money between two accounts you already track
• Loan payments, which your accountant may want split into principal and interest

On the Bookkeeper plan, tax mode assigns a category to each row and puts the ones it is unsure about in a Needs review list, and the Accountant Pack turns the categorized rows into a one-page PDF your accountant can review. Check the suggestions; you know your business better than any rule does.

Step 5: import into QuickBooks or Xero

Import one account at a time, oldest month first. On paid plans you can download a QBO file for QuickBooks or an OFX file for Xero, which need no column mapping. A CSV works in both if you match the date, description and amount columns during import.

Check what the bank feed already brought in before you upload anything. Feeds often reach back only part of the way, so the newest months may already be in the software. Set your file to cover only the months the feed missed. Our guides to importing into QuickBooks and importing into Xero cover file limits and the errors people hit most.

Step 6: reconcile each account month by month

Reconciling is where the catch-up is proven. In QuickBooks or Xero, start the reconciliation for the oldest month, enter the statement's closing balance and date, and match the imported transactions to it.

Don't start the next month until the difference is zero. A small gap is much easier to trace inside one month than after you have stacked six months on top of it. When every account reconciles to its latest statement, the catch-up is done.

Common bookkeeping catch-up mistakes

Most catch-up problems trace back to the statements themselves: a month that never got downloaded, one that got imported twice, or money that moved between your own accounts.

A missing month

One absent statement leaves a hole you only notice when a later reconciliation won't balance. The account grid from step 1 and the month-to-month balance check from step 3 catch this before you import.

Duplicate imports

Uploading the same file twice, or uploading months the bank feed already pulled in, doubles those transactions. If the balance in your software runs higher or lower than the bank's by a round, familiar amount, look for a pair of identical rows.

Transfers counted as income

Moving $5,000 from savings to checking shows up as a deposit on the checking statement. Label it as a transfer, or your revenue for that month is overstated by $5,000.

A wrong opening balance

If the first month you rebuild starts from a balance that was never reconciled, every month after it inherits the error. Check the opening balance against the bank's statement for that month before you begin.

How long to keep the statements and rebuilt books

Keep the original PDFs and the spreadsheets you made from them after the catch-up. Tax offices can ask to see the records behind your figures years later. The general business rules from each tax office are below; some situations need records kept longer.

For a personal return built from statements, see our page on bank statements for taxes.

Bookkeeping catch-up questions

How far back should a bookkeeping catch-up go?

Go back to the last month you know was reconciled, or the start of the fiscal year if nothing was. If you haven't filed returns for earlier years, ask an accountant how far back you need to rebuild.

Can I use the bank feed instead of statements?

Use the feed for the months it covers, and statements for anything older. Feeds often don't reach back to the start of a long gap, and the statement's closing balance is still what you reconcile to.

Should I catch up one account at a time?

Yes. Finish converting, checking, importing and reconciling one account before you start the next. Transfers between accounts then match cleanly, because one side is already in the books.

What if a statement won't balance after converting?

Look at the flagged row first and compare it with the PDF page. If no row is flagged but the month is still off, check whether a page of the statement is missing from the file.

Do I need an accountant for a catch-up?

You can do the data work yourself, but an accountant should review categories and opening balances before you file anything. Our page for accountants and bookkeepers shows how they handle client statements.

Start with the account that has the most months missing, download its statements and run them through the bank statement converter. Once the first account reconciles, the rest of the bookkeeping catch-up follows the same six steps.