QuickBooks Online "File Too Large" Upload Error: How to Fix It

You try to upload a bank file to QuickBooks Online and it refuses it because the file is too large. The fix is to split the file into smaller ones covering consecutive date ranges, then import them one after the other. Here’s how to do it without losing or doubling a transaction.

What the error means

QuickBooks Online accepts bank file uploads, whether QBO (Web Connect) or CSV, of up to 350 KB each. The limit is on the file size, not on the number of transactions or the date range.

How many transactions fit depends mostly on how long the descriptions are:

• In a CSV, a typical row (date, description, amount) takes 50 to 100 bytes, so 350 KB holds roughly 3,500 to 7,000 transactions.
• In a QBO file, each transaction is wrapped in tags (type, date, amount, ID, name, memo) and takes about 180 to 300 bytes, so 350 KB holds roughly 1,200 to 1,900 transactions.

A year of activity for a busy business account, or several years for a quieter one, easily goes over.

Splitting a CSV

A CSV can be split safely as long as two rules are respected:

1. Every part keeps the header row. QuickBooks maps columns using the header; a part without one is either rejected or imported with its first transaction treated as column names.
2. Each part stays under the limit with a margin. Aim for 300 to 340 KB rather than exactly 350 KB.

The CSV splitter does both: it has a preset for QuickBooks Online’s limit, repeats the header in every file and never cuts a row in half.

It’s also worth splitting on date boundaries, so that no single day is spread across two files. Then if you ever need to re-import one part, you know exactly which dates it covers.

Splitting a QBO file

A QBO file can’t be cut with a text editor. It has a header, an account block, a statement period and a balance, and each part needs all of them to be a valid file. Cutting it in the middle produces files QuickBooks rejects, or worse, files that import with a wrong balance.

Instead, regenerate the file as several complete ones:

• If you’re converting from a PDF statement, CSV or Excel file, the statement converter splits automatically when the QBO would be over 350 KB. You get a ZIP with consecutive date ranges, each a complete QBO file, plus a README that lists the import order.
• If the QBO came from your bank, download it again in smaller date ranges, such as one month or one quarter at a time.

Each transaction keeps the same ID whichever part it lands in, so QuickBooks still recognizes it if an earlier import already included it.

Importing the parts

1. Oldest first. Import the files in date order. Any running balances and the For review list then read naturally.
2. Same account every time. When QuickBooks asks which account the file belongs to, pick the same one for every part.
3. Review each part in the For review tab before moving on to the next, or import them all and then review; either works, as long as you don’t add the same transaction twice by hand.

Checking the result

After the last part:

• Compare the number of transactions imported with the total in your source files.
• Open the account register and check the balance on the last date against the bank statement.
• If the counts don’t match, look at the days where two parts meet. A transaction posted on the last day of one file and the first day of the next is the usual suspect; the duplicate finder can compare the parts with what’s already in QuickBooks.

Avoiding the problem next time

• Import monthly. A single month almost never comes near 350 KB.
• When downloading history, choose smaller date ranges at the bank.
• If a QBO file is rejected and you’re not sure why, open it in the QBO file viewer: it shows the size, the date range and anything else QuickBooks would object to.