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.

F2 screen in QuickBooks
F2 screen in QuickBooks

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.

Please follow and like us:

2 thoughts on “I’m Thinking About Migrating to QuickBooks Online, But My File’s Too Big!

  1. DO NOT MIGRATE to QB Online!

    It’s frustrating as H@ll when doing transactions, creating multiple windows for report viewing (you have to open a window first then copy the web address then view the reports), editing chart of accounts, etc…

    It’s a real pain in the Ahse for tax professionals!
    Also, there’s NO way of RESTRICTING the access so when you’re done with a particular year and everything has been reconciled to the best that you can, you can NOT close it!

    You can’t even make a backup of the file!!!

    IF a company has lots of transactions or complex transactions, AVOID QB ONLINE AT ALL COSTS!

    • A lot of things have changed since September 2015. I specialise in taxes and I have moved my practice from QB to QBOA and am very happy. Very easy to close a prior year with a password so client can’t mess with the books. They say the QBO App will deal with multiple windows but I use QBOA and the App is too slow.
      I did bring over a client that had 12,450 customers. It would take almost a minute to find a client. In QBO it takes a few seconds.


Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>