Home › Guides › Import Old Bank Transactions into QuickBooks Online Beyond 90 Days
Import Old Bank Transactions into QuickBooks Online Beyond 90 Days
You can manually upload historical bank transactions into QuickBooks Online when the bank feed does not reach far enough back. Download the missing period from the bank as a transaction file, or convert an older PDF statement, then upload only the missing lines. A bank feed history limit is not the same as a manual-file import date limit.
Updated November 6, 2026
Separate three different history limits
The bank feed's initial download window, the bank website's export window and its archive of PDF statements can cover different periods. A feed showing only recent transactions does not prove older records are unavailable. Intuit's CSV formatting article explicitly discusses uploading more than 90 days of transactions; the actual records you can obtain still depend on your bank.
| Source | What to check |
|---|---|
| Connected bank feed | The oldest transaction actually received, including pending review |
| Bank CSV/QBO download | Available custom date range and transaction export format |
| Statement archive | Older monthly PDFs when the transaction export no longer covers the period |
1. Establish the missing period before downloading
Check both the register and the bank transaction review area for the account. A transaction already added to the books and an imported line waiting for review both matter. Note the first date reliably covered, the desired bookkeeping start date and any gaps inside the period.
For example, if a feed starts on September 15 but you need July onward, create a missing-period plan for July 1 through September 14, then inspect the boundary around September 15. Real bank posting dates and overlapping exports may require selecting individual lines rather than treating a calendar cutoff as perfect.
2. Prefer the bank's transaction export
Look for a CSV or QuickBooks download for each missing range. Use one account per file. If only monthly PDFs remain, convert those statements separately and compare the extracted payments and deposits with the printed balances. Do not use a converter if the bank already supplies a valid file for the same rows; that adds an unnecessary transformation.
3. Prepare manageable upload batches
For CSV, use Date, Description, Amount with signed amounts, or Intuit's four-column format. Use one consistent date convention. Intuit's transaction-list limits are 350 KB per file and up to 1,000 transaction lines per upload, so a year of activity may require several batches.
Keep a simple import log: account, source statement, covered dates, transaction count and status. Preserve each original file. Upload oldest to newest as an organisational choice so that missing or repeated periods are easier to notice; it is not a requirement that changes whether QuickBooks accepts the file.
4. Upload and review the historical lines
- In QuickBooks Online, go to Bank transactions and choose Upload from file from the Link account menu.
- Choose the existing account that matches the statement. Avoid creating a second account for the same bank simply to hold older data.
- Map the CSV fields and date format if needed.
- Select only missing transactions, paying particular attention to the overlap with current feeds or previous imports.
- Confirm the upload, then match or categorise the lines. Check each batch before starting the next.
5. Review opening balances and closed periods
Adding transactions before the current bookkeeping start date can change what the opening balance should represent. It can also affect a previously reconciled or closed period. Ask your accountant to review the start date and opening balance rather than entering an unexplained adjustment to force the ending total to agree.
A balance check on the extracted statement is useful but not sufficient: it does not establish that the books have no duplicates or that the historical entries use the right categories. Complete reconciliation against each statement and keep a record of the files used.
From a PDF to reviewed transaction data
Need an older month that is only available as a PDF? Convert that statement to QBO or QuickBooks CSV and check the extracted rows before importing.
Open the converter → · Plans and limits · How balance checks work
Conversion runs in your browser; statement files are not uploaded to CSVLedger. A balance check helps identify extraction issues, but does not replace review or accounting reconciliation.
Frequently asked questions
Is there a universal 90-day manual import limit?
No. The bank feed download window and manual-file imports are different. Availability of older source records depends on the bank.
What if the bank only has old PDF statements?
Convert the missing statement periods to an importable transaction file and review dates, amounts and balances before uploading.
Should I reimport the whole year to fill one gap?
Usually prepare only the missing period and check overlap against existing and pending transactions. Reimporting the year can create duplicate work.
Related guides
- QuickBooks Online CSV Format: 3 Columns vs 4 Columns
- QuickBooks Online Bank Upload Errors: A File Checklist
- Complete QuickBooks Online import walkthrough
Sources and scope
Based on official help documentation reviewed through search results on November 6, 2026. Menus, regional availability and product requirements can change; use the current official instructions if your screen differs. Examples are fictional. These instructions are documentation-based, not a claim of a completed live import test.