How Far Back Can QuickBooks Import Bank Transactions?

QuickBooks imports about the last 90 days of bank transactions automatically. When you connect a bank account, QuickBooks Online pulls roughly 90 days of history through the bank's feed. A few banks send up to 24 months, but most stop near 90 days, and QuickBooks cannot retrieve anything the bank does not offer. To go further back, you import the older transactions yourself from a file, which is where a converted statement comes in.

That 90-day number trips up almost everyone setting up a new QuickBooks company or catching up a year of books. The recent transactions appear, the older ones do not, and there is no setting that makes the feed reach further. This guide explains why the limit exists, how to check how far your feed actually went, and the exact steps to import older transactions into both QuickBooks Online and QuickBooks Desktop.

Why QuickBooks limits the bank feed to about 90 days

The limit is not really QuickBooks's choice. When you link an account, QuickBooks asks your bank for transaction history and the bank decides how much to hand over. Most US banks expose around the last 90 days through the connection that feeds QuickBooks, a smaller number go back 18 to 24 months, and a few send less than 90 days. QuickBooks shows you whatever arrives and cannot force the bank to send more. That is why two businesses connecting on the same day can see different amounts of history, and why there is no toggle that extends the feed.

The 90-day window also resets if a connection breaks and you reconnect the account. A reconnect pulls about 90 days again, not the full gap since it dropped, so a feed that silently disconnects for several months can leave a hole you only notice at reconciliation. For anything outside that window, the answer is the same: bring the transactions in from a file.

How to check how far back your bank feed went

Before you import anything, find the earliest transaction QuickBooks already has so you know exactly where the gap starts:

1. Select the Gear icon, then Chart of Accounts.
2. Find the bank or credit card account and choose View register.
3. Scroll to the bottom of the register and note the date of the oldest transaction.

That date is your finish line. Your historical import should cover everything from the start of the period you need up to one day before it, so you fill the gap without creating overlapping duplicates.

How to import bank transactions older than 90 days in QuickBooks Online

QuickBooks Online accepts uploaded files for any date range, so the fix is to give it a file that covers the older months. The cleanest file is a .qbo Web Connect, because it imports without column mapping:

1. Download each old statement from your bank as a PDF, or export it if your bank still offers older CSV or .qbo downloads.
2. Convert each PDF statement to a .qbo file with the bank statement to QuickBooks converter at the top of this page.
3. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file.
4. Select the .qbo or CSV, choose the matching bank account, and continue.
5. Review the transactions in For Review, then categorize and match them.

Upload the files oldest to newest. QuickBooks builds the register balance in the order transactions arrive, so importing in date order keeps the running balance correct and surfaces any month you skipped.

How to import old transactions into QuickBooks Desktop

QuickBooks Desktop does not read PDF or CSV in its banking import. It uses the Web Connect format, a .qbo file, the same format it creates when you download a feed inside the software. So convert each old statement to .qbo first, then:

1. Open QuickBooks Desktop and go to File, then Utilities, then Import, then Web Connect Files.
2. Select the .qbo file and choose the bank account it belongs to.
3. Repeat for each month, oldest to newest.
4. Match and add the transactions in the Bank Feeds Center.

Because Desktop reads only .qbo and .qfx, converting the statement is not optional here the way a CSV sometimes is in Online. Our walkthrough on how to convert a bank statement to QuickBooks Desktop covers the import screen and the errors that trip people up.

How to import a previous year of transactions

A full prior year is just twelve monthly statements handled in sequence. Pull each month's PDF from your bank, convert each to its own .qbo, and import them in date order. The transactions post to last year's dates, not today's, so the prior-year books reconcile against the statements and your tax numbers land in the correct period. This is the normal way to finish a late return or rebuild books that were never kept in QuickBooks.

How to avoid duplicate transactions when importing old statements

Duplicates happen when an uploaded date range overlaps transactions QuickBooks already has. Two habits prevent almost all of them. First, check your oldest existing transaction date, as above, and convert statements that end just before it. Second, watch For Review, where QuickBooks flags likely matches against entries already in the register. If a duplicate still slips through, exclude or delete it in the bank feed before you categorize the rest, rather than after it has been added to the books.

Can QuickBooks Self-Employed import old transactions?

QuickBooks Self-Employed takes a CSV of past transactions rather than a .qbo Web Connect file. Convert your old PDF statement and use the CSV copy the converter produces alongside the .qbo, then import it through the transactions import option. Older transactions come in uncategorized, so plan to review and assign categories after the upload. The same converted file works if you later move up to QuickBooks Online.

Convert your old PDF statements first

The single thing that makes every method above work is a clean file. A PDF is a picture of a statement, not structured data, so QuickBooks cannot read it directly. Converting each statement to a .qbo turns those pages into dated, described, signed transactions that import like a live feed and reconcile to the statement total. Upload a statement in the converter at the top of this page to get a QuickBooks-ready .qbo back, then follow the Online or Desktop steps above to backfill as far as you need.

For more on the workflow, see the full guide to import old bank statements into QuickBooks, the QBO file format explainer, and how to import bank statements into QuickBooks in general. Firms running catch-up work for many clients should read bank statement to QuickBooks for accountants. If your bank only exports old activity as CSV, a CSV to QBO converter turns that file into a Web Connect import, a bank statement to Excel converter gives you a spreadsheet to audit the year against, and accounts payable teams can route the bills you find during cleanup through accounts payable automation.