Ten Rivers SystemsGet in touch
All guides

What to do when your QuickBooks file is too big to convert

Most people meet this problem on migration day. The file has been fine for years, the new QuickBooks Online company is already set up, and the import stops because of a number nobody mentioned until now. The number is real, it is easy to check in advance, and the figure you will find quoted online is very often out of date.

Check your own number first

QuickBooks Online limits an import by target count, not by how many megabytes the file takes up. In Desktop, press F2 or Ctrl+1 on Windows, or Cmd+1 on Mac to open Product Information and read Total Targets under File Information. Intuit's current instruction is to confirm that count is below 4,000,000. Do that before anyone creates the Online company, not on the day you plan to move.

The number you found online is probably wrong

Three different limits are live on Intuit's own properties right now. A conversion checklist still hosted by Intuit tells accountants to verify the count is below 350,000. Community answers from 2023 say 750,000, one of them from an Intuit moderator, and other posters in the same threads split that figure by plan. The current help articles say 4,000,000, flat, whatever plan you are moving to, and three separately maintained pages say it the same way. If you are working from a number you found in a forum, check it against a current help article before you act on it.

There is a deadline as well as a limit

One limit has nothing to do with size. Once a QuickBooks Online company exists, you have 90 days to import your Desktop data into it, or 180 days if an accountant created the company. After that, Intuit's documented routes are importing your data manually from Excel, or cancelling the QuickBooks Online account, creating a new one, and moving the data again. The clock runs whether or not your file is oversized, so a file that needs weeks of work before it can be imported is a file with two problems rather than one.

What condensing actually costs

Condensing is Desktop's own tool for making a file smaller: File, then Utilities, then Condense Data. It works by removing detail, either older closed transactions or unused list entries. Two things are worth knowing before anyone runs it.

It cannot be undone. Intuit's wording is blunt: once you condense your company file, it can't be undone. Take a backup you keep somewhere else first.

It changes what your reports can tell you afterwards. Intuit lists the effects itself: item-based reports come back blank, because the item data behind the condensed transactions is gone; cash-basis reports for the condensed period are no longer accurate; sales-tax liability reports show incorrect data; and reconciliation reports for that period may be incorrect, because the checks and deposits behind them no longer exist.

The other route: lists and balances only

Intuit's import also offers an option to bring only your lists and balances: customers, vendors, chart of accounts, employees and items, with no transaction history at all. It keeps you under any limit by definition, because almost nothing comes across, and Intuit does not spell out what the balances themselves contain. What you give up is every historical transaction, which means the Desktop file stays the only place your history exists. Keep it, and keep a way to open it.

When the file is a long way over

Intuit's documentation covers running the condense utility once. It does not say what to do when the count is still over the limit afterwards, and people do get stuck exactly there. If one condense does not bring a file under the limit, that usually means the volume is in the current year, which condensing does not reach: it works on closed transactions on or before a date you choose. At that point another pass is not the answer. The route is a different migration, one that brings the transaction detail across outside Intuit's own import. That is the kind of migration I do.

Ten Rivers Systems handles technical setup, configuration, and data migration only. I am not an accountant or tax adviser. How you keep your books and what you owe stays between you and your own professionals.

Common questions

How do I check whether my QuickBooks file is too big to convert?

In QuickBooks Desktop, press F2 or Ctrl+1 on Windows, or Cmd+1 on Mac to open Product Information, and read Total Targets under File Information. Intuit's current limit is under 4,000,000 targets. The limit counts targets, not megabytes, so the file's size on disk does not answer the question.

Why do I keep seeing 350,000 or 750,000 as the limit?

Both numbers were current once and both are still discoverable. A conversion checklist on Intuit's own site still says 350,000, and community answers from 2023 say 750,000. The current help articles say under 4,000,000, on three separate pages.

Is there a time limit as well as a size limit?

Yes, and they are separate. Once a QuickBooks Online company is created you have 90 days to import Desktop data into it, or 180 days if an accountant created the company. After that, Intuit's documented routes are importing the data manually from Excel, or cancelling the account and starting again.

Start a conversation

Stuck over the limit?

Tell me your target count and roughly how many years are in the file. I'll tell you which route gets it across.

A free thirty-minute call.A first-pass review and written scope in two days, at no cost.If it isn't something I do, I'll say so.

Prefer a conversation? Book a call