How to add bank transactions older than your QuickBooks bank feed

When you connect a bank account to QuickBooks Online, it downloads history only back to a start date. How far back depends on the bank: Intuit's help pages describe spans from about 90 days to 24 months. Anything older has to come in by file upload. If your bank no longer offers a CSV for those months, or the account is closed, the PDF statements may be the only record left. QuickBooks Online can read a statement PDF itself, but converting first lets you check each statement against its printed balances and cut it at the right date before anything goes in. This guide turns the statements into an upload with no gap and no duplicates.

Step 1: find the cut-off date

  1. In QuickBooks Online, open the account's bank transactions and sort them by date, oldest first. Note the date of the oldest downloaded transaction. That is your cut-off date.
  2. Decide where the upload should start. For a new company file that is often the first day of the year, or the date of your opening balance. If an accountant keeps your books, ask which date they want.
  3. List the statements that cover the gap. Statement periods rarely match calendar months, so you may need the statement that contains the start date and the one that contains the cut-off date.

Step 2: convert each statement

  1. Download each statement from your bank's website as a PDF.
  2. Open the StatementLocal converter and drop the PDFs on the page. Each statement is read inside your browser and checked on its own.
  3. Get every statement to Reconciled before you go on. A statement that says Off by highlights the rows to check; fix them in the grid.
  4. Download the QuickBooks CSV of each statement.

Step 3: trim each file to the gap

  1. Open the CSV of the statement that contains the cut-off date.
  2. Delete every row dated after the cut-off date: QuickBooks already has those from the bank connection. For rows dated on the cut-off date itself, compare with QuickBooks and keep only the ones it does not list.
  3. In the first statement, delete the rows dated before your start date.
  4. Save the file as CSV again. On a Mac, Intuit's help asks for the Windows CSV format. Excel may rewrite 03/02/2026 as 3/2/2026 when it saves, so check the dates and pick the matching date format when QuickBooks asks, or trim the file in a plain text editor, which saves it exactly as you see it.

Trim after the check, not before. A trimmed file no longer runs from the statement's opening balance to its closing balance, so it can no longer show Reconciled.

Step 4: upload, oldest first

  1. Upload the files one at a time, oldest first, to the right account. The upload steps are in importing a PDF bank statement into QuickBooks Online.
  2. For the few days on either side of the cut-off date, look in the rows for review for pairs with the same amount and description before you add anything.
  3. When all the rows are added, reconcile the account in QuickBooks against the closing balance of the last statement that ends before the cut-off date.

A worked example

A business connected its checking account in June. The connection downloaded transactions back to March 12, so the cut-off date is March 12. The owner wants the books to start on January 1. The gap is January 1 to March 11, covered by three statements:

Statement periodRowsKeep
Dec 16 to Jan 1538the 21 rows dated Jan 1 to Jan 15
Jan 16 to Feb 1541all 41
Feb 16 to Mar 1536the 29 rows dated Feb 16 to Mar 11, plus any Mar 12 rows QuickBooks does not list

Each statement is converted and shows Reconciled before it is trimmed. The three trimmed CSVs hold 91 rows. With the January 1 opening balance entered and the 91 rows added, reconciling the account in QuickBooks against the February 15 closing balance shows a difference of zero. A difference other than zero means a row is missing, doubled or dated wrong.

Limits of this method

Try it on one of your statements

Open the StatementLocal converter and drop one statement PDF on the page. Converting and previewing are always free, and you can download 3 statements a day free, as CSV, Excel or QuickBooks CSV. The file is read inside your browser and is never uploaded.

What has and has not been tested

We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on every bank's real statements, and we quote no accuracy figure for them.

Related guides

StatementLocal is not affiliated with any bank, card issuer or software company named on this page. Names are used only to say what the steps are for.

Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.

Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.