QuickBooks guide

QuickBooks only pulled 90 days of transactions. Here's how to get the rest in.

Updated October 21, 2026 · By the CleanStatement team

Convert your older statements free — 3 pages a day, no signup

or click to browse · one or more text-based PDFs (up to 24), 20 MB each No PDF handy? Sample uses fictional data and none of your free pages.
3 free pages a dayNo account neededExcel · CSV · QBO · Xero

Need more than 3 pages a day? See pricing.

QuickBooks Online's bank feed doesn't download transactions older than 90 days, and reconnecting usually won't change that. To fill the gap, get the older months from your bank as a CSV or QBO file, or convert your PDF statements, and upload them under Bank transactions > Link account > Upload from file, ending the day before your oldest existing transaction.

This is a limit of the bank connection, not a setting you missed.

Why QuickBooks stops at 90 days

When you connect a bank or card account, QuickBooks Online asks the bank for recent history and then downloads new transactions every day. Intuit's help article on missing transactions says it plainly: QuickBooks doesn't download pending transactions or transactions older than 90 days. Its connection guide adds that the download timespan varies by bank, from 90 days up to 24 months. So some banks give more on the first connection, but you can't count on it, and many people get roughly three months.

Reconnecting the account usually doesn't help. The bank offers the same window to every new connection, so you get the same recent months back. Waiting makes things worse, because the window moves forward every day and the gap behind it grows.

This tends to come up in a few situations:

  • You started using QuickBooks Online partway through the year.
  • A bank feed disconnected months ago and nobody noticed until year-end.
  • You're moving the books over from another system or from spreadsheets.
  • Your bank doesn't connect to QuickBooks at all.

In every case the fix is the same: bring the older months in from a file.

Three ways to get older transactions into QuickBooks Online

RouteWhen to use itEffortWatch-outs
1. Download a CSV or QBO file from your bankYour bank still offers downloadable activity for the months you needLowThe download window may be shorter than the statement archive
2. Upload the PDF statement to QuickBooksOne or two English-language statementsLow to mediumYou review every extracted line; some statements go to Intuit's reviewers
3. Convert PDF statements first, then uploadMany months or accounts, or you want a balance check firstLow per monthText-based PDFs only; you still review before accepting

Route 1: Download a file from your bank

Sign in to online banking, open the account's activity or transaction history, and look for a download or export option. Choose QuickBooks Web Connect (.qbo) if it's offered, otherwise CSV. Set the date range to start at your target start date and end the day before your cutoff (more on that below).

The catch is that some banks keep PDF statements longer than they keep downloadable activity. If the export only reaches back a year or so, the older months will have to come from your PDF statements. Our bank pages explain where statements usually live for Chase, Bank of America and Wells Fargo, plus other banks.

Route 2: Let QuickBooks read the PDF

Intuit's help article Manually upload transactions into QuickBooks Online (updated August 24, 2026) describes a built-in way to upload a statement as a PDF or image (JPG, PNG or HEIC):

  1. Go to Bank transactions and select the account's tile.
  2. Open the Link account dropdown and choose Upload from file.
  3. Upload the PDF and choose the QuickBooks account it belongs to.
  4. Review the side-by-side view of the statement and what QuickBooks extracted, fix anything that needs attention, and select Save.

Intuit notes a few limits. The statement must be in English. When some items need review, the statement may be checked by Intuit's "team of global experts" before it's ready, which is worth knowing if your client is sensitive about who sees their statements. And you're reviewing each line on screen, which is fine for a short statement but slow for a year of them. For one or two statements, this is a perfectly good choice.

Route 3: Convert the PDF statements first

If you're catching up many months, it can be quicker to turn each PDF into a file first and upload the files. CleanStatement does this for text-based PDFs downloaded from online banking: convert each month in seconds, no signup for the first 3 pages a day, $9 for 100 pages.

  • Files you get: it downloads a .qbo (Web Connect) file and a CSV you can upload to QuickBooks Online's bank upload, plus Excel if you want to edit rows first.
  • Balance check: each conversion is compared with the statement's opening and closing balances where the statement shows them, and you get a warning if it doesn't add up. A PDF that covers several accounts, such as checking and savings, gets a check for each account.
  • Several months at once: upload up to 24 PDFs (20 MB each) at once. Each gets its own balance check; download one merged Excel or CSV file, plus a .qbo file per account.
  • Text-based PDFs only: scanned or photographed statements aren't supported.
  • Privacy: files are deleted within an hour.

Whichever file you use, review the transactions in QuickBooks before you accept them.

Convert your first statement free3 pages a day, no signup. Get a QBO or CSV file checked against your statement's opening and closing balances. Convert a PDF bank statement to QuickBooks (QBO).

Step by step: import older months without duplicates

  1. Find your cutoff date. Open the account register in QuickBooks, sort by date, and note the oldest transaction that's already there. Everything you import must be dated before it.
  2. List the months you need. For each account, write down every month between your target start date and the cutoff. Collect a statement for each one and name them consistently, for example Checking-0000_2026-03.pdf.
  3. Get a file for each month. Download CSV or QBO files from the bank if it offers them for those months, or convert your PDF statements. Cover the period up to the day before your cutoff.
  4. Check that the months chain together. Each statement's closing balance should equal the next statement's opening balance. A gap means a missing statement or a missing page.
  5. Upload the files. In QuickBooks Online go to Bank transactions, select the account, then Link account, then Upload from file. Pick the account, map the columns if asked, and check that money in and money out have the right signs.
  6. Review and reconcile, oldest month first. Match or categorize the uploaded transactions, then reconcile each month against its statement. Only move to the next month when the difference is zero.
  7. Spot-check the cutoff. Look at a few days either side of the cutoff date for transactions that appear twice, and exclude any duplicates.

Here's what step 4 looks like with made-up numbers for a fictional "Example Checking ••0000" account:

StatementOpening balanceClosing balanceChains to next?
March (example)$3,940.12$4,812.37Yes: April opens at $4,812.37
April (example)$4,812.37$4,275.90Yes: May opens at $4,275.90
May (example)$4,275.90$5,018.44Last month before the cutoff
If the bank feed suddenly starts working again, check for duplicates.A feed that reconnects can download transactions you've already uploaded from a file. Compare the dates around your cutoff and exclude anything that appears twice.

When the older transactions are before your opening balance

When you create an account in QuickBooks, you choose a start date and enter the bank balance on that day. That's the opening balance, and it stands in for all the history before it. If you now add transactions dated before the opening balance, QuickBooks would count that history twice.

Intuit's article "Reconcile transactions that are older than your opening balance" covers the fix. After importing the older transactions, find the opening balance entry in the account register (it's labeled Opening Balance Equity, with "Opening Balance" in the memo) and change its date and amount to match your bank records for the new start date. Using the opening balance from your first imported statement makes the first reconciliation easier.

Intuit notes this is much easier before an account has been reconciled. If the account has already been reconciled, or the period is already closed, talk to your accountant before changing balances. This guide describes the process only and isn't tax or accounting advice.

What QuickBooks Online accepts

As of October 2026, Intuit's help lists two kinds of upload. You can upload a statement as a PDF or image, or upload a transaction list as a QBO, QFX or CSV file. Intuit suggests QBO for transaction lists. CleanStatement produces QBO and CSV (plus Excel and Xero CSV); it doesn't produce QFX.

For CSV files, Intuit's help asks for:

RuleWhat it means
3-column layoutDate, Description, Amount. Money out is negative, money in is positive.
4-column layoutDate, Description, Credit, Debit. Fill one of Credit or Debit per row and leave the other blank.
No zerosLeave cells blank instead of entering 0.
HeadersCredit and Debit headers shouldn't include the word "amount".
DatesUse one date format throughout. Intuit recommends dd/mm/yyyy.
SizeEnglish, 350 KB or less. For larger uploads, Intuit suggests shorter date ranges in smaller batches.

CleanStatement's CSV has Date, Description, Amount and Balance columns, with every date in YYYY-MM-DD format. If QuickBooks doesn't accept the extra Balance column, delete it in Excel so the file matches the 3-column layout. If it misreads the dates, reformat that column. When a PDF covers several accounts, the CSV adds an Account column; split it into one file per account, because each upload goes into a single QuickBooks account. Uploading one month per file keeps you comfortably under the size limit.

Credit card accounts

The process for credit cards is the same, with one common trap: signs. On a card, purchases increase what you owe and payments reduce it, and Intuit's CSV help warns that card files can show amounts in reverse. Intuit's advice is to upload into the credit card account in QuickBooks, not a bank account. Before you accept anything, check that a purchase shows as a charge and a payment as a payment. If the card issuer's download doesn't reach back far enough, the older months can come from PDF statements. See credit card statement to Excel or CSV.

QuickBooks Desktop

QuickBooks Desktop imports bank transactions from Web Connect (.qbo) files. Intuit's community answers give the path as File > Utilities > Import > Web Connect Files, and Intuit's help notes that importing Web Connect files requires you to sign in to your Intuit account inside QuickBooks Desktop. Desktop can be stricter about Web Connect files from unknown banks. If it rejects the QBO file, use the CSV with a CSV-to-QuickBooks import tool. We don't promise Desktop compatibility, so test with one month before doing a whole year.

Using Xero instead? See PDF bank statement to Xero CSV.

Frequently asked questions

Why does QuickBooks only download 90 days of transactions?

The bank connection decides how much history QuickBooks can pull. Intuit's help says QuickBooks Online doesn't download pending transactions or transactions older than 90 days, and that the window on a new connection varies by bank, from 90 days up to 24 months.

Will reconnecting the bank get older transactions?

Usually not. A new connection asks the bank for the same window it offers everyone, so you typically get the same recent history back. If the old transactions are still in the register, reconnecting can also create duplicates.

Can QuickBooks Online read a PDF bank statement?

Yes. Intuit's help (article updated August 24, 2026) says QuickBooks Online can upload an English PDF or image statement, extract the transactions and show them side by side with the statement for you to review. Converting first can be faster when you have many months to catch up.

What CSV format does QuickBooks Online need?

Intuit's help asks for either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one consistent date format, blank cells instead of zeros, and a file of 350 KB or less.

How do I avoid duplicate transactions?

Find the oldest transaction already in the QuickBooks account and only import transactions dated before it. Intuit recommends that your file start at least one day before that oldest transaction. After importing, check a few days either side of the cutoff.

Does this work for credit card accounts?

Yes. The process is the same. Upload into the credit card account, not a bank account, and check that charges and payments have the right signs before you accept them.

Does CleanStatement work with scanned statements?

No. CleanStatement only reads text-based PDFs, the kind you download from online banking. Scanned or photographed statements aren't supported.

Catching up a whole year?

Convert your first statement free: 3 pages a day, no signup. You get a QBO or CSV file checked against your statement's opening and closing balances.

For bigger catch-ups, Pro is $15/month for 500 pages, Business is $30/month for 2,000 pages, or a one-time 100-page pack is $9. See pricing.

For the full month-by-month workflow, see catch-up bookkeeping from PDF bank statements. Preparing the year for your accountant? See getting your bank statements ready for your CPA.

Convert a statement free

Also useful: PDF bank statement to CSV · PDF bank statement to Excel (edit rows before importing)

Sources

QuickBooks steps and limits are from Intuit's US help articles, checked October 21, 2026. Intuit changes menu labels often, so follow what you see on screen.

QuickBooks is a trademark of Intuit Inc. CleanStatement is independent and not affiliated with Intuit or any bank.