QuickBooks bank feed vs CSV upload: when to use which
QuickBooks Online can get your bank transactions two ways: a bank feed that downloads them automatically, or a file upload that you do yourself from a CSV (or QBO/OFX) file. They are not rivals. Most people use the feed day to day and the upload to fill gaps.
Based on QuickBooks' own help pages (linked at the end). Details differ by country and edition, and the figures below are the ones QuickBooks stated on the pages we read.
The short answer
- Use the bank feed when your bank can be connected and you only need recent transactions. It is automatic. QuickBooks' help says it "automatically downloads transactions up to a certain date".
- Use a CSV upload when your bank can't be connected, when you need transactions from before you connected, or when you don't want to link the account at all. QuickBooks says to use it "if you can't connect your bank or want to add transactions from before you did so."
Side by side
| Bank feed | CSV (file) upload | |
|---|---|---|
| Effort | Set up once, then automatic | You download and upload each time |
| Coverage | Banks QuickBooks can connect to; if yours isn't listed you can search by name or URL | Any bank that lets you download a file |
| How far back | QuickBooks' Australian page says standard feeds import up to two years per account; a 2020 QuickBooks staff reply in the US community said 90 days, and that it can vary by bank. Expect the amount to depend on your bank and region. | Whatever date range your bank lets you download |
| Limits | Depends on the connection | CSV: 350 KB per file and 1,000 lines per upload, three or four specific columns |
| Setup risk | Bank sign-in or connection can break and need re-linking | File layout, dates and number formats must be right or the upload fails |
| Best for | Ongoing bookkeeping | Backfilling history, unsupported banks, one-off imports |
A simple rule
- Can QuickBooks connect to your bank? Connect it and let the feed do the daily work.
- Do you need older transactions than the feed brought in? Upload a file for the gap. QuickBooks suggests the file's date range should start at least a day before your oldest QuickBooks transaction for that account, and to check your Chart of accounts first to avoid duplicates.
- Bank not supported, or you'd rather not connect? Use file upload for everything.
- Using a direct feed? QuickBooks' Australian help page says direct-feed users should use CSV import for historical transactions.
Practical tips for the upload route
- A file must be Date, Description, Amount, or Date, Description, Credit, Debit, with one date format and no zeros in the Credit/Debit cells.
- For a year of history, split it into batches under 1,000 lines and under 350 KB.
- If you have both a feed and uploads for the same account, check for duplicates before accepting transactions.
- Credit card exports can list transactions in reverse order, so check that payments and refunds come out with the signs you expect.
The step-by-step is in our guide How to import bank transactions into QuickBooks Online (CSV, step by step) and there is a free QuickBooks CSV template. If your bank's CSV needs reshaping, StatementSnap is a free browser tool we make that converts it to the QuickBooks layout (free for the first 25 rows; your file isn't uploaded).
Sources
- QuickBooks: Manually upload transactions into QuickBooks Online (read 2026-10-08)
- QuickBooks Australia: Connect your account to QuickBooks (read 2026-10-08)
- QuickBooks Community, staff reply (9 March 2020): How can I get my bank records to download. It is old, so the 90-day figure may have changed.
Disclosure: we make StatementSnap, linked above, and used AI assistance to write this guide. We are not affiliated with Intuit or QuickBooks. Rules, limits and menus change; check QuickBooks' current help pages for your country.