When you connect a bank account, QuickBooks pulls roughly the last 90 days of transactions — that's all most banks expose through their live feeds. Anything older (a new client's back months, a year-end cleanup, an account you connected late) never arrives on its own. The fix is a manual file import, and it takes about ten minutes.
Step 1: Export the missing months from your bank
Sign in to online banking and download the missing date range. A CSV export is ideal; if your bank only offers PDF statements for older months, that works too. Our bank-by-bank guides show where the export lives for the major banks.
Step 2: Convert it to a QBO (Web Connect) file
QuickBooks doesn't reliably accept raw bank CSVs — column layouts vary by bank, and Desktop wants Web Connect format specifically. Drop your export into the CSV to QBO converter (or the PDF converter for statements), check the preview against your statement, and download a .QBO file.
Step 3: Import into QuickBooks
QuickBooks Online: Transactions → Bank transactions → Upload from file. QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then pick the account when prompted.
Avoiding duplicates
Import only the date range that's missing — if your feed already covers the last 90 days, cut the file off where the feed picks up. Our converter stamps every transaction with a stable ID, so re-importing the same file won't create duplicates, but overlapping a live feed can.