Missing Bank Transactions in QuickBooks: How to Import Last Year's Gaps Before Tax Season
You open last year’s books to prepare for taxes and the bank account is short: whole months are missing, or the balance in QuickBooks doesn’t match the December statement. This is common, and fixable in an afternoon. The missing transactions are still at your bank; you just need to bring them in as a file.
Why transactions go missing
- The bank feed only goes back so far. When you connect or reconnect an account, QuickBooks Online typically downloads only about the last 90 days. Anything older than that never arrives through the feed.
- The feed disconnected quietly. A password change, a new security step at the bank, or a bank switching connection types can stop downloads for weeks without an obvious error. (On QuickBooks Desktop, see bank feeds not working.)
- The account was added mid-year, or a new card replaced an old one and the old account was never connected.
- Transactions were excluded or deleted by mistake in the bank feed review screen.
Step 1: Find exactly which dates are missing
Don’t download “everything”: you’ll create duplicates. Pin down the gap first:
- Open the account’s register (QuickBooks Online: Chart of accounts → View register; Desktop: double-click the account in the Chart of Accounts) and sort by date. Look for weeks with no activity.
- Compare each month’s ending balance in QuickBooks with the bank statement. The first month that doesn’t match is where the gap starts.
- Check the excluded list (QuickBooks Online Banking → Excluded) in case the transactions are there and only need to be restored.
Write down two dates: the last transaction QuickBooks has before the gap and the first one after it.
Step 2: Download the missing months from your bank
Sign in to online banking on a computer, open the account’s activity and look for Download or Export:
- Choose exactly the missing date range.
- Pick QuickBooks / Web Connect (.qbo) if offered. Otherwise choose Quicken (.qfx), OFX, or CSV.
- How far back you can download depends on the bank. Older periods are often available only as PDF statements; see converting a PDF bank statement to Excel.
Bank-specific steps: Chase, Bank of America, American Express.
Step 3: Convert the file if QuickBooks won’t take it
- QuickBooks Desktop imports bank files only as .qbo (Web Connect). A .qfx, .ofx or CSV has to be converted first.
- QuickBooks Online accepts .qbo, .qfx, .ofx and CSV, but CSV uploads often fail with “Darn, file upload failed” unless the file has exactly 3 or 4 columns (Date, Description, Amount or Credit/Debit), one header row and nothing else.
A .qbo file avoids both problems and carries a unique ID per transaction, which QuickBooks uses to recognise transactions it already has. Convert with:
- CSV to QBO or Excel to QBO for spreadsheet downloads (columns and date formats are detected automatically; check the preview: money out must be negative),
- QFX to QBO for Quicken files.
Everything runs in your browser, so the bank file is never uploaded anywhere.
For a whole year, split the file into a few months at a time. Smaller files are easier to review, and QuickBooks Online handles them more reliably.
Step 4: Import into the right account
QuickBooks Online: Banking → Link account ▾ → Upload from file, choose the file, then pick the existing QuickBooks account the transactions belong to. They land in For review.
QuickBooks Desktop: File → Utilities → Import → Web Connect Files, choose the file and link it to the existing account. Review in the Bank Feeds Center.
Back up the company file (Desktop) before the first import.
Step 5: Review before adding
- Sort For review by date and check the first and last transactions match your two dates from step 1.
- QuickBooks suggests matches where you already entered something by hand (a check, a deposit). Accept the match instead of adding a second copy.
- Categorise the rest, using bank rules for recurring vendors.
Step 6: Reconcile the months you filled in
Reconcile each month against its statement, oldest first, until December balances. Step-by-step: how to reconcile bank accounts in QuickBooks.
If the year is already closed: QuickBooks warns you, or asks for the closing date password, when you add transactions before the closing date. That’s expected. Check with your accountant if last year’s return was already filed, because adding transactions changes those numbers.