Thinking about migrating from QuickBooks desktop to QuickBooks Online Edition? What if your file is too big?
There is a way around this obstacle, but first, a little background.
It used to be that if your QuickBooks file was bigger than 200MB, it wouldn’t migrate to QuickBooks Online…too big. You’d get an error when you tried to create the QuickBooks Online export file.
Then the limit changed, and it was a limit on the total number of transactions that your file contained.
As of today’s writing, the limiting factor is on how many “targets” exist within your file. A “target” is basically a line of detail within a transaction. If your file has more than 350,000 targets in it, it’s too big to migrate to QuickBooks Online.
You can find out how many targets your file has by opening your company in QuickBooks and pressing the F2 key.
In the screenshot above, the total targets is less than 6,000. This is from a sample set of data, and an actual working set of data — particularly with lots of inventory or jobs transactions — will have a high total targets figure.
So if you have a ton of transaction detail in your file — move than 350K lines — but you want the advantages found in QuickBooks Online Edition, what can you do?
The first thing to try would be the built-in Condense command in QuickBooks. Try it on a copy of your file. If the Condense command is found in your version of QuickBooks, it’ll be in the File / Utilities menu (the command is not in all versions).
Why would you want to run Condense on a copy? Because sometimes the Condense command will freeze and you’ll have to exit QuickBooks abnormally. If that happens, you don’t want it happening on your live data. But when the Condense command works well, it works well, so try it and see what happens.
If the Condense command succeeds, then you can strip out lots of old transaction lines, and possibly bring the file down to the point where you can successfully create the export migration file.
If the Condense command doesn’t work, or doesn’t get enough reduction to make the data migration possible, then you could consider getting your file prepared for migration. This is an external process we provide that can reduce your file’s size (and targets) by 50-80%. We remove all but the last 1-7 years of data (your choice), and create the export file (OE.qbw) that is ready to send into QuickBooks Online.
Learn more about the file preparation service here.