Bookkeeping guide

Catch-up bookkeeping from PDF bank statements: a month-by-month workflow

Updated October 21, 2026 · By the CleanStatement team

Convert your statements free — 3 pages a day, no signup

or click to browse · one or more text-based PDFs (up to 24), 20 MB each No PDF handy? Sample uses fictional data and none of your free pages.
3 free pages a dayNo account neededExcel · CSV · QBO · Xero

Need more than 3 pages a day? See pricing.

To catch up bookkeeping from PDF bank statements, collect every statement for each account since the last reconciled month, check that each opening balance matches the prior closing balance, convert the PDFs to a spreadsheet or bank-upload file, then import and reconcile one month at a time, oldest first, until each difference is zero.

This is a bookkeeping workflow, not tax or financial advice.

Scope the catch-up first

Scoping first prevents rework later. Before you open a single PDF, pin down three things:

  • Start date: the day after the last month that was reconciled to a statement. If nothing was ever reconciled, agree a start date with the client and their CPA.
  • End date: usually the last full statement month, so the bank feed can take over from there.
  • Accounts: every bank account, savings account, credit card and loan the business used in the period, including any opened or closed along the way. Other kinds of accounts are outside this workflow.

Then send the client one request covering everything:

  • Original PDF statements from online banking for each account and month, not scans or photos
  • Logins or read-only access, if they'd rather you download statements yourself
  • A list of accounts opened or closed during the period
  • Any loan or line-of-credit statements
  • Notes on unusual items: owner transfers, large one-off purchases, refunds

Step 1: Gather statements and build a tracker

A tracker is a grid of accounts down the side and months across the top. Mark each cell received, missing or not applicable. It tells you at a glance what's left to chase, and it becomes part of your hand-off. Here's a made-up example covering 6 months:

AccountJanFebMarAprMayJun
Checking ••0000✓✓✓Missing✓✓
Savings ••0000✓✓✓✓✓✓
Card ••0000 (opened in March)N/AN/A✓✓✓Missing

Name files consistently so they sort in order, for example Checking-0000_2026-03.pdf. Ask for the online-banking PDF every time: scanned statements aren't supported by CleanStatement, and they're harder to check by eye too.

Step 2: Prove the set is complete

A tracker shows which files you have, not whether they're the right ones. The balance chain proves it: each statement's opening balance must equal the previous statement's closing balance. Made-up example for "Example Checking ••0000":

StatementOpeningClosingChain
January (example)$12,480.00$11,906.55Start
February (example)$11,906.55$13,214.08Matches
March (example)$13,214.08$12,377.91Matches
May (example)$10,942.30$11,605.17Break: March closed at $12,377.91, so April is missing

Credit cards follow the same logic with the previous balance and new balance. Only move on once every chain is unbroken, or each gap is logged with a plan to get the statement.

Step 3: Pick the route for each period

Not every month needs the same treatment. Pick the simplest source that covers it:

PeriodBest routeNotes
Recent months inside the bank feed's windowThe bank feedSee why the QuickBooks bank feed stops at about 90 days
Older months the bank still lets you downloadThe bank's own transaction downloadDownload windows vary by bank and are often shorter than the statement archive
PDF-only months, or closed accountsConvert the PDF statements, or upload each PDF to QuickBooks OnlineQuickBooks Online can read a PDF statement itself (Upload from file), one statement at a time with a side-by-side review. Converting in a batch (step 4) gives a balance check per statement and one merged file to check against the tracker

Closed accounts need the most care. Once an account is closed, online access to it may end, so download or request its statements early, before you need them. Bank downloads for older months are worth checking too: when they exist they save a conversion step, but compare a downloaded month against its statement's balances before you trust the whole range.

Keep one route per account per month. Mixing a bank download and a converted statement for the same month is the easiest way to create duplicates.

Write the route for each account and period into the tracker so the import plan is clear before you start.

Step 4: Convert in batches

Converting statements in batches saves re-typing. CleanStatement converts the PDF-only months together:

  • Up to 24 PDFs at once, 20 MB each.
  • A balance check per statement: each one is compared with its opening and closing balances where the statement shows them, and you get a warning if it doesn't add up. A PDF that covers several accounts gets a check for each account.
  • One merged spreadsheet: Excel or CSV with every transaction sorted by date, plus Account and Source file columns, so each row traces back to its PDF. There's also a merged Xero CSV, with the account and source file in the Reference column.
  • QuickBooks: it downloads a .qbo (Web Connect) file for each account. Statements are combined into one file only when they show the same printed account number, so different accounts aren't combined. There's also a CSV you can upload to QuickBooks Online's bank upload.
  • Rule-based extraction, no AI: the text in your PDF is read with fixed rules, not sent to an AI model.
  • Text-based PDFs only: scanned or photographed statements aren't supported.

A batch of 24 covers, for example, 12 months for two accounts. The balance check matters most here: a statement that doesn't add up gets flagged before it touches the books, so you fix one file instead of hunting for a difference across a year of reconciliations. More on merging and checking a batch: combining a year of bank statements into one spreadsheet.

Batch by account and yearOne batch per account per year keeps the merged spreadsheet easy to check against your tracker, and makes each .qbo file line up with one account in the books.

What it costs. Every page of every PDF counts. Free use is 3 pages a day across all files. After that, the 100-page pack is $9 one-time, Pro is $15/month for 500 pages, and Business is $30/month for 2,000 pages. See pricing.

Step 5: Set the opening balance and import oldest first

When a QuickBooks account was set up, someone picked a start date and entered an opening balance that stands in for all earlier history. If you import transactions dated before it, QuickBooks counts that history twice.

Intuit's article "Reconcile transactions that are older than your opening balance" covers the fix. After entering the older transactions, go to Settings, then Chart of accounts, open the account, and find the opening balance entry in the register (labeled Opening Balance Equity, with "Opening Balance" in the Memo column). Edit its date and amount to match your bank records for the new start date. Intuit recommends setting the opening balance at the beginning of a bank statement, which makes the first reconciliation much easier.

Intuit also notes it's much easier to add older transactions before an account has been reconciled; if it has been, you may need help from the accountant. Coordinate with the client's CPA before touching periods that were already filed.

Import the oldest month first and work forward. End the last import the day before the first transaction the bank feed downloaded, then spot-check a few days either side of that date for duplicates. In QuickBooks Online, file uploads are under Bank transactions, then Link account, then Upload from file. Using Xero instead? See PDF bank statement to Xero CSV.

Step 6: Categorize and reconcile month by month

Set up bank rules for the recurring payees first: rent, payroll, software subscriptions, card payments. Rules do most of the categorizing, and you handle what's left. Then reconcile each month against its statement, and don't start the next month until the difference is zero.

Work through the months in the same order you imported them. Reconciling oldest first means each month starts from a balance you've already proven, so a difference can only come from the month in front of you. Note each finished month in the tracker as you go.

When a month won't reconcile, it's usually one of these:

  • Credit card sign flips: charges imported as payments or the other way round.
  • Transfers imported on both sides: a transfer from checking to savings recorded as an expense in one account and income in the other, instead of a single transfer.
  • Overlap with the bank feed: the same transactions from both the feed and a file around the cutoff date.
  • A missing statement: go back to the balance chain in Step 2.

Step 7: Log exceptions and hand off

Keep an exceptions log as you go: missing statements and when you requested them, transactions you couldn't identify, and anything you need the client to explain. A made-up example:

AccountMonthIssueStatus
Checking ••0000Apr (example)Statement missing (chain break)Requested from the bank; month not imported
Card ••0000Jun (example)Statement missingClient to download
Checking ••0000Feb (example)$1,500.00 transfer out, payee unclearPosted to Ask My Accountant; client to explain

Keep each entry factual: what's missing or unclear, what you did about it, and what you're waiting for. When an item is resolved, note the date rather than deleting the line, so the log doubles as a record of the work. Hand it over with the reconciled books, the tracker, and the merged spreadsheet, whose Source file column lets the CPA trace any row back to its PDF. If the catch-up feeds tax prep, see getting your bank statements ready for your CPA.

How long does catch-up take?

It depends on the number of accounts and months, how many statements you have to chase, and how messy the transactions are. Gathering and chasing statements often takes longer than the bookkeeping itself, which is why the tracker and balance chain come first. Converting in batches and reconciling oldest first keeps the rest predictable.

Frequently asked questions

Can I rely on the bank feed for the old months?

Usually not. Intuit's help says QuickBooks Online doesn't download transactions older than 90 days, and the window on a new connection varies by bank, from 90 days up to 24 months. Reconnecting doesn't reliably bring back older history. See why the QuickBooks bank feed stops at about 90 days.

How do I know a statement is missing?

Use the balance chain: each statement's opening balance should equal the previous statement's closing balance. A break means a missing statement, a missing page or a shifted cycle.

What if the client can't find a statement?

Download it from online banking or request a copy from the bank. Don't estimate the month. Log it as missing until the statement arrives.

Can I convert many statements at once?

Yes. CleanStatement takes up to 24 PDFs at once, 20 MB each, and checks each statement against its balances where they're shown. You get one merged spreadsheet with Account and Source file columns, plus a .qbo (Web Connect) file per account.

Convert a catch-up in batches

Convert up to 24 statements at once. Each one is balance-checked, and you get one merged spreadsheet with Account and Source file columns, plus a .qbo (Web Connect) file per account. 3 free pages a day, no signup.

Doing catch-up for several clients? Pro is $15/month for 500 pages, and Business is $30/month for 2,000 pages.

Convert your statements

Uploaded files are deleted within 1 hour. Also useful: PDF bank statement to QuickBooks · to Excel · to CSV · credit card statement to Excel · bank guides

Sources

QuickBooks steps are from Intuit's US help articles, checked October 21, 2026. Intuit changes menu labels often, so follow what you see on screen.

QuickBooks is a trademark of Intuit Inc. CleanStatement is independent and not affiliated with Intuit or any bank.