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
- 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.
- 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.
- 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
- Download each statement from your bank's website as a PDF.
- Open the StatementLocal converter and drop the PDFs on the page. Each statement is read inside your browser and checked on its own.
- 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.
- Download the QuickBooks CSV of each statement.
Step 3: trim each file to the gap
- Open the CSV of the statement that contains the cut-off date.
- 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.
- In the first statement, delete the rows dated before your start date.
- 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
- 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.
- 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.
- 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 period | Rows | Keep |
|---|---|---|
| Dec 16 to Jan 15 | 38 | the 21 rows dated Jan 1 to Jan 15 |
| Jan 16 to Feb 15 | 41 | all 41 |
| Feb 16 to Mar 15 | 36 | the 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
- This is for QuickBooks Online. StatementLocal writes CSV, not QBO, QFX or OFX files.
- Nothing here changes how far back a bank connection reaches; that belongs to QuickBooks and your bank.
- StatementLocal reads text-based PDFs only (no scans, photos or password-protected files), in US dollars and common US layouts.
- A long catch-up is many downloads. The free plan downloads 3 statements a day, and two years of monthly statements is 24 files.
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
- Import a PDF bank statement into QuickBooks Online
- Reconcile a bank statement in Excel
- Combine several months into one sheet
- What to do when the verdict says Off by
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.