How to Do Catch Up Bookkeeping in QuickBooks (Import a Year of Statements)

Last updated July 2026.

To do catch up bookkeeping in QuickBooks Online, convert each old bank and credit card statement to a CSV, then upload the files under Transactions so they land in the bank review queue. This bypasses the QuickBooks bank feed, which only pulls about 90 days of history, and it works for closed accounts and cards that have no live connection at all. Once the transactions are in, you categorize them in bulk and reconcile month by month against the statement balances. The conversion is the step that turns a year of catch-up from days of typing into an afternoon.

Here is the full workflow, in the order that actually keeps the books tying out.

Why the QuickBooks bank feed will not catch you up

When you connect an account, QuickBooks Online imports roughly the last 90 days of transactions. A few banks return up to a year, but none go back far enough for a real catch-up job that spans twelve or twenty-four months. The feed is built to keep current books current, not to rebuild a backlog. For older periods, a closed business checking account, or a credit card you stopped using, there is no feed to connect. The record of what happened lives only on the PDF statements, so catching up means getting those statements into QuickBooks yourself.

The manual CSV upload is the supported path for exactly this. QuickBooks accepts a spreadsheet of transactions and drops them into the same review queue the bank feed uses, so once the data is in, the rest of the process is identical.

Step 1: Gather every statement for the catch-up period

List each account the business used during the gap: checking, savings, every credit card, and any payment app such as PayPal or a merchant processor. Then download every monthly PDF for the whole period, including accounts that are now closed. Most US banks keep statements available online for about seven years, so even a two-year-old period is usually recoverable by logging in or calling the bank. Pull the complete set before you start entering anything. A missing month forces you to redo reconciliation later, which is the slowest way to find out you skipped one.

Step 2: Convert each statement to a QuickBooks-ready CSV

QuickBooks Online reads a simple three-column CSV: date, description, and amount, where deposits are positive and withdrawals are negative. It also accepts a four-column layout with separate debit and credit columns. The problem is that a PDF statement is not a spreadsheet, so you have to get the transactions into those columns first.

Rather than retype them, convert the statement to Excel or CSV. Upload each PDF and download a clean file with the date, description, amount, and running balance already in columns. Keep the format consistent across every month so the files import the same way. A converter reads digital PDFs, scanned statements, and even phone photos, so a mixed backlog from different banks becomes one normalized set of import files in minutes. Save each month as its own CSV, or stack a few months into one file per account, whichever is easier to reconcile afterward.

Before you import, open each CSV and check the date format is MM/DD/YYYY, the amounts have no dollar signs or thousands commas, and the withdrawals carry a minus sign. Those three things cause most failed QuickBooks uploads.

Step 3: Import the CSV into QuickBooks Online

In QuickBooks Online, go to Transactions, then Bank transactions. If the account is connected, use the drop-down by Link account and choose Upload from file. If it is not connected, the same upload option appears. Select your CSV, pick the QuickBooks account it belongs to, and map the columns: tell QuickBooks which column is the date, which is the description, and which holds the amount. Confirm whether your file uses one amount column or separate debit and credit columns, then finish the import.

The transactions land in the For review tab exactly as if they had come through the bank feed. Import one account at a time so you do not mix a checking file into a credit card register. If you run QuickBooks Desktop instead, the same idea applies but the file goes in through the WebConnect import or a third-party file, and a QBO-format file behaves like a downloaded bank transaction.

Step 4: Categorize the backlog in bulk

With a full year in the review queue, do not code transactions one at a time. Sort or filter the list by description or payee so all the charges from the same vendor group together, then categorize them in a batch. QuickBooks also learns bank rules as you go, so once you tell it that a recurring payment is a software subscription, it will suggest the same category for the rest. Set up a few bank rules early in the catch-up and they will clear large chunks of the backlog automatically. Our guide on categorizing transactions from a bank statement covers how to group spend quickly before and after import.

As you categorize, keep the supporting documents together. Catch-up work often means matching old charges to receipts and bills you no longer remember, and digitizing them with receipt scanning software gives you searchable records to attach, which matters if the return is ever examined.

Step 5: Reconcile each month against the statement

Categorizing gets the transactions coded; reconciling proves they are complete and correct. In QuickBooks Online, open Reconcile, choose the account, and enter the ending date and ending balance from the statement for the earliest month in your backlog. Match every transaction, confirm the difference is zero, and finish. Then move to the next month. Work oldest to newest so each month starts from a reconciled opening balance.

This is where converting the statements pays off a second time. Because the converted rows preserve the running balance, you can confirm each month ties out to what the bank actually showed before you close it. Reconciling from real statement data, rather than a memory or an estimate, is what makes caught-up books defensible to an accountant, a lender, or the IRS.

How long does catch up bookkeeping take in QuickBooks?

The categorizing and reconciling is skilled work that takes real time no matter what. What you can compress is the data entry. Hand-keying one active month into QuickBooks runs one to two hours per account; converting the same statement and importing it takes a couple of minutes. Across a year and two accounts, that is the difference between several full days and a single afternoon of getting the data in, after which you spend your time on the judgment calls instead of typing.

Frequently asked questions

Can I import old bank statements into QuickBooks Online?

Yes. QuickBooks Online accepts a CSV upload of bank transactions under Transactions, then Bank transactions, then Upload from file. This bypasses the roughly 90-day limit on the live bank feed, so you can load history from old periods and closed accounts. Convert each PDF statement to a three-column CSV of date, description, and amount first, then map the columns during the import.

How far back can the QuickBooks bank feed go?

The QuickBooks Online bank feed typically imports about 90 days of transactions when you first connect an account, and some banks return up to a year. Neither reaches far enough for a multi-month catch-up. For anything older, or for a closed account with no feed, upload the transactions from a CSV built from the PDF statements instead.

What CSV format does QuickBooks Online need?

QuickBooks accepts a three-column CSV with date, description, and amount, where deposits are positive and withdrawals are negative, or a four-column layout with separate debit and credit columns. Use MM/DD/YYYY dates, remove dollar signs and thousands commas from amounts, and keep the minus sign on withdrawals. Formatting mistakes in these fields cause most failed uploads.

Do I have to categorize before or after importing?

Import first, then categorize inside QuickBooks. Uploaded transactions land in the For review tab just like bank feed items, so you can sort by payee and batch-categorize, and let bank rules auto-code recurring charges. Categorizing in QuickBooks rather than in the spreadsheet keeps the audit trail inside your accounting software.

Will imported statements let me reconcile in QuickBooks?

Yes, and reconciling is the step that confirms the catch-up is complete. After importing and categorizing, use Reconcile, enter each statement's ending date and balance, match the transactions, and confirm the difference is zero. Work oldest month to newest so every month opens from a reconciled balance. Converted statements that preserve the running balance make this check fast.

Get your statements ready to import

The slow part of catching up in QuickBooks is turning a stack of PDFs into files you can upload. Convert your bank statements to Excel or CSV in under a minute each, then import, categorize, and reconcile. For the QuickBooks-specific export options, the QuickBooks bank statement converter page covers the CSV and QBO routes in detail.