QuickBooks Online bank feeds bring recent history; older data needs a file import
New QuickBooks Online users find their bank feed starts with a month or more of history, and older transactions must be uploaded by hand.
QuickBooks Online setup threads in Canada keep circling the same question: why does a freshly linked bank account arrive with only a sliver of its past? The accepted guidance has not moved. Feeds cover activity from the day you connect, most banks add an opening window of roughly one to three months, and everything older comes in by hand.
The surprise is common because linking itself is fast. Users connect an account, watch the first transactions land within a day, and then go looking for last year. What they find instead is a cutoff, and it is not a bug in their file.
How much history does the first link deliver?
Most Canadian financial institutions send between 30 and 90 days of transactions when an account is first connected. The window varies by bank, and a few send less than others. After that opening batch, the connection works forward only. New activity appears as the bank clears it, but earlier months are never fetched on their own. Waiting longer, or forcing repeated updates, does not reach back further.
Some users try deleting the connection and starting over. That rarely adds depth. It usually returns the same opening window, so treat the first download as the feed’s earliest point and plan around it.
Older statements live outside the feed
The limit is structural, not a preference you can switch on. The connection is authorized at the moment you sign in through the linking screen, and the data service starts recording from that point. Your earlier statements still exist, sitting in your online banking portal. They are simply outside the channel the feed reads, so moving them is a manual job.
File formats the upload accepts
A backfill needs a file, and QuickBooks Online accepts a short list. A plain CSV export is the dependable choice, since every Canadian bank portal offers one. The upload also reads the common bank-download formats, including Web Connect and the OFX and QFX types. Excel workbooks should be saved as CSV first. If your bank hands you something unusual, open it in a spreadsheet and save it back out as CSV.
The upload, step by step
Start at your bank, not at QuickBooks.
- Sign in to online banking, choose the account and the date range you want, and download the transactions as CSV or another supported format.
- Check the date layout before going further. Canadian exports sometimes list the day before the month, and a mismatch scrambles every date.
- Open Transactions in the left menu of QuickBooks Online, then Bank transactions. Older layouts call this Banking.
- Select the account, click the small arrow beside the Update button, and choose File upload. First-time screens may label it Connect account.
- Browse to your file, confirm which account it belongs to, and map the columns: date, description, and either one signed amount or separate money-in and money-out columns.
- Save the mapping. The rows then appear in the For review list alongside your live feed items.
Long histories should not go up in one piece. A multi-year file can stall partway, so split the backfill into monthly or quarterly chunks and load them in date order.
Match, do not duplicate
The real hazard in a backfill is overlap. If your file covers dates the feed already delivered, the review list will show near-identical pairs. Accept the match when one is offered, because adding the row as new leaves a double that surfaces during reconciliation. The cleaner route is to export starting the day after your feed’s earliest transaction.
Credit cards behave the same way as chequing accounts here. The opening window rule and the manual upload path apply to both, so plan one backfill exercise for every account you link.
Decide where the books start
Not all history deserves importing. Many firms open their QuickBooks file at a fiscal year start, enter opening balances for bank and credit accounts, and import only from that date forward. A decade of old card purchases rarely improves a new set of books, and it makes the review queue punishing. Choose a cutover date before you export anything.
Once the backfill is in, bank rules can pre-sort recurring charges so the queue shrinks to only the odd items. The setup answer, across every thread we reviewed, has stayed the same: link the account, accept the opening month or three the bank sends, and carry the rest in by hand.