How to Import Old Bank Transactions into QuickBooks Online

Short answer: To import old bank transactions into QuickBooks Online, do not rely on the bank feed, which only backfills about 90 days. Instead upload the transactions from a file: go to Transactions, then Bank transactions, select the account, open the Link account dropdown, and choose Upload from file. There is no date limit on a file you upload, so you can bring in statements from any prior year. If your bank no longer lets you download that far back, convert the PDF statements to a QuickBooks ready CSV or QBO file first, then upload them.

Why QuickBooks only pulls about 90 days from the bank feed

When you connect a bank account, QuickBooks Online pulls roughly the last 90 days of transactions, and reconnecting an account does the same, so a year end catch up starts with most of the year missing. This is a limit of the bank feed itself, not of QuickBooks, and the banks decide how much history they hand over through the feed. The fix is not to keep reconnecting the feed and hoping for more. The fix is to stop using the feed for the old period and upload those months as a file instead, because uploaded files have no date restriction at all.

How do I import old bank transactions into QuickBooks Online?

Upload them as a file rather than through the feed. The path is Transactions, then Bank transactions, then click the tile for the account you are importing into, then open the Link account dropdown and choose Upload from file. Select the file, map the columns when QuickBooks asks, pick the correct account, and confirm. QuickBooks accepts CSV, plus QBO, QFX, and OFX files. Because there is no time limit on an uploaded file, this is how you get January through today into the books even though the feed refused to reach back that far.

If you no longer have the download from your bank, or the account is closed, start from the saved PDF statements. Convert each statement with a QuickBooks bank statement converter to get either a mapped CSV or a QBO file, then upload that. This is the standard route for catch up and cleanup work, and it is covered end to end in the guide on catch up bookkeeping in QuickBooks.

Getting the CSV format right

QuickBooks Online accepts a three column CSV with Date, Description, and Amount, or a four column CSV with Date, Description, Credit, and Debit. In the three column layout, money out is negative and money in is positive. Keep dates in a single consistent format, remove dollar signs and thousands separators, and delete any extra columns such as a running balance or a category, because an unexpected column fails the import. Two more caps matter on historical loads: QuickBooks Online takes up to 1,000 transactions and 350 KB per file, so a busy year usually has to be split into several files, most simply one per month or one per quarter.

Can QuickBooks import transactions older than 90 days?

Yes, through a file upload rather than the bank feed. The 90 day limit applies only to what the feed downloads automatically. A CSV or QBO file you upload under Bank transactions has no date restriction, so you can import transactions from last year or several years ago as long as you have the data, which you can recover from saved PDF statements when the bank download no longer reaches that far. The detail on the feed limit is in why QuickBooks only imports 90 days of transactions.

How far back can you import bank transactions into QuickBooks?

As far back as you have statements. There is no built in cutoff on uploaded files, so the real limit is how much history your bank still lets you download or how many PDF statements you saved. Most US banks keep PDF statements available online for up to about seven years, and converting those statements gives you the rows to upload for any period, including closed accounts that no longer appear in the feed.

How do I import a full year of bank transactions into QuickBooks?

Gather the twelve monthly statements, convert each to a QuickBooks ready CSV, and upload them in batches that stay under the 1,000 row and 350 KB caps, which usually means one file per month or per quarter. Import in date order, and after each upload review the transactions before you accept them into the register. Doing it month by month also makes it easy to spot a gap or a duplicate.

How do I avoid duplicate transactions?

Duplicates happen when an uploaded file overlaps a period the bank feed already brought in. Before you upload, note the oldest date the feed reached, and only upload dates earlier than that. If you do overlap, QuickBooks will show the repeated lines in the For review tab, where you can exclude them rather than adding them. Reconciling each month against the statement balance right after import is the surest way to confirm nothing doubled up. To speed up the coding once everything is in, categorizing the transactions in the spreadsheet before upload gives every row a head start.

The bottom line

The QuickBooks bank feed is built for going forward, not backward, which is why it stops around 90 days. For old and historical transactions, upload a file instead, because uploaded CSV and QBO files carry no date limit. When the bank download no longer reaches the period you need, the saved PDF statement is the source, and you can convert the statement straight to a QuickBooks file so the older months import as cleanly as the current ones.