How Many Transactions Can QuickBooks Import at Once?

QuickBooks Online lets you import up to 1,000 transactions (lines) per file when you upload a bank statement manually, and the file must be 350 KB or less and written in English. If you have more than that, you split the statements into separate files (for example one .qbo or CSV per statement or per month) and upload them one after another. The converter at the top of this page turns each PDF statement into a clean .qbo Web Connect file so every upload lands under the limit without hand editing.

Last updated July 2026.

The exact limits for a QuickBooks import

When you upload a file yourself in QuickBooks Online (rather than using a live bank feed), three hard rules apply. The file can hold no more than 1,000 lines, it has to be 350 KB or smaller, and the content has to be in English. Accepted formats are .csv, .txt, .qbo, .qfx, and .ofx. If you go with CSV, the layout needs to be either three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). One nice detail: a manual upload has no date limit, so you can bring in transactions from years ago as long as each file stays under 1,000 lines.

QuickBooks Desktop takes a different path. It imports through Web Connect using .qbo files, and also reads .qfx, .ofx, and .qif. Desktop is not bound by the same 1,000-line manual-upload cap that QuickBooks Online uses, but keeping files reasonable in size still helps them import cleanly.

Why the limit exists

The 1,000-line and 350 KB ceilings are there to keep the browser upload fast and reliable. A massive file is more likely to time out, choke on a stray character, or fail partway through and leave you unsure which rows made it in. By capping the size, QuickBooks Online keeps each import quick and, more importantly, keeps it all-or-nothing so you are not left reconciling a half-loaded batch. The practical takeaway is simple: smaller, tidy files import the first time, and one statement per file is almost always the right unit.

How to import more than 1,000 transactions

The fix for a high-volume account is to split the data, not to force it. Break the year into pieces, most naturally one file per monthly statement, and import them in sequence. A busy checking account rarely crosses 1,000 lines in a single month, so a per-month split almost always drops you under the cap with room to spare.

The cleanest way to do this is to convert each statement to its own .qbo file and upload them one at a time. Because each monthly PDF becomes a self-contained Web Connect file, you never touch the 1,000-line ceiling and QuickBooks matches the transactions to the right account automatically. If you would rather work in CSV, you can open the statement in a spreadsheet, trim it to the required columns, and slice any oversized month into two files before you upload. Either way, the rule is one manageable file at a time, uploaded in order.

For anyone bringing in a full year or catching up several clients at once, the bulk bank statement to QuickBooks workflow is built for exactly this: drop in a stack of statements, get back one file per statement, and upload the set.

Do bank-feed connections have a different limit?

Yes, and this trips people up. A live bank feed does not use the 1,000-line manual cap. Instead, when you first connect an account, the feed pulls only recent history, usually about 90 days, and the exact window varies by bank. Some institutions hand over a little more, some a little less. That is why a fresh connection almost never gives you last year's transactions. When you need older history or a specific closed period, the manual upload route is the answer, since it has no date limit and simply asks that each file stay under the size rules. Many bookkeepers combine both: the feed for going-forward activity, manual .qbo uploads for the back catalog.

File-size troubleshooting

If an import fails, the culprit is usually the 350 KB size rule or the 1,000-line count rather than anything exotic. Two moves fix most cases. First, trim unnecessary columns; a CSV only needs Date, Description, and Amount (or the four-column Credit and Debit version), so delete running balances, reference codes, and other extras that bloat the file. Second, split the file: cut a heavy month or quarter into two, and upload each half. Also confirm the content is in English and that the date column reads consistently, since a mixed or non-English format is a common quiet failure. A converted .qbo file sidesteps most of this because it is already structured the way QuickBooks expects.

A practical workflow for a full year or multi-client catch-up

Here is the batch approach that holds up whether you are cleaning up one account for the year or onboarding several clients at once. Gather every monthly PDF statement for the account. Convert each one to its own .qbo file so you end up with a labeled file per month. Upload them to QuickBooks Online in date order, oldest first, and let each finish before starting the next. Review the imported batch, categorize, and reconcile against the statement you just brought in. Because every file is one month and stays under the 1,000-line cap, the whole year moves in without a single size error, and you always know exactly which period you are looking at.

To go deeper on the upload steps themselves, see the guide on how to import a bank statement into QuickBooks Online, and if you are starting from PDFs, the PDF to QBO converter handles the format conversion. You can also start straight from the tool on the homepage.

Frequently asked questions

What is the transaction limit for importing into QuickBooks Online?

QuickBooks Online accepts up to 1,000 transactions (lines) per manual upload. The file also has to be 350 KB or less and written in English. There is no date limit on a manual upload, so the only real ceiling is the per-file line and size count, which you clear by splitting large statements.

How do I import more than 1,000 transactions into QuickBooks?

Split the data into multiple files, usually one per monthly statement, and upload them in sequence. Convert each statement to its own .qbo file so every upload stays under 1,000 lines, then bring them in oldest first. For a full year or several clients, batch the statements one file each.

Why won't my bank file import into QuickBooks?

Most failures come down to the rules: the file is over 1,000 lines, larger than 350 KB, not in English, or the columns are wrong. QuickBooks Online wants three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). Trim extra columns, fix the date format, or split the file, then retry.

Is there a file size limit for QuickBooks imports?

Yes. A QuickBooks Online manual upload must be 350 KB or smaller, on top of the 1,000-line cap. If your file is too big, remove unneeded columns such as running balances, or split it into two smaller files and upload each one. A structured .qbo file usually stays well under the size limit.

How many years of transactions can I import into QuickBooks?

A manual upload has no date limit, so you can import transactions from any year as far back as your statements go. The only constraint is per file, not per date: each file must stay under 1,000 lines and 350 KB. A live bank feed is different and typically pulls only about 90 days.