When converting your QuickBooks Desktop data to QuickBooks Online, your total targets must be less than 350,000. Since you're exceeding 350,000, you may want to consider condensing your company file as our champ user Fiat Lux - ASIA has suggested. I've included some steps to condense your data below.

From the QuickBooks File menu, select Utilities and then Condense Data.
Click on Yes to the message Budget data may be moved during cleanup. Do you want to continue anyway?
In the Condense Data window, select Transactions before a specific date.
Use the Date field to select a date. QuickBooks will remove closed transactions on or before the date you choose.
Hit Next.
Select a method to summarize the transactions you're removing, then Next. If you're not sure, tap on Help me choose.
(Optional) Click on any of the checkboxes for the dialog boxes that follow, then hit Next.
Select Begin Condense.

For additional information about this process, check out Condense your QuickBooks Desktop file for import to QuickBooks Online.

Please let me know if you have any questions or concerns. I'm always around to lend a hand. Take care!

update I was able to get file condensed to around 200K targets. tried to migrate and still getting same error.

K

Kathykb123

I'm having the exact same issue. How did you solve it?

A

Anonymous

Hey, everyone! I had this exact same issue several times, and after a couple of successful migrations mixed in with a ton that failed this exact same way, I *THINK* I know what fixed it for me.

Background:

In my case, I have my QB Desktop files saved in DropBox. It's commonly understood in the tech community that "databases" of any sort should "never" be stored in a file sync tool such as DropBox, OneDrive, Google Drive, etc... however, I've been doing it for years without issue. I just have to cleanup "conflicted copies" every now and then, but overall, I've never had any database corruption as a result of storing my QBW in DropBox.

Possible Resolution:

In any case, the couple times I got the migration to complete, I 1) freshly reboot my computer, 2) logged back in and let all my startup apps settle down, 3) PAUSED DropBox sync (you may have OneDrive), 4) opened QuickBooks & performed a data validation to ensure no errors, then 5) pressed F2 --> CTRL+B+Q --> OK to begin the migration. Done this way, my QBW file with about 38k targets uploaded successfully in less than a minute and I received the e-mail confirmation from QuickBooks Online not much longer after.

For anyone having issues, please confirm if your QBW file is saved in a file sync tool. For example, Windows these days automatically moves your normal Documents folder to OneDrive for protection, but this means your QBW database is saved in a folder that is constantly being checked for changes which may be interfering with the migration process. Unsure exactly why and if I'm even correct, but I'm curious to know if this helps anyone.

GOOD LUCK!! --Matt

S

SEckmann

This did it for me! Thanks for this!

K

Kevin_C

Moderator

Thanks for updating us on this, SEckmann.

We're glad to hear that you're able to isolate the issue using the steps shared above.

Also, you can always visit our Help articles page for reference. There, you can read some of our helpful articles that will guide you in your future tasks.

In case you need assistance or if you have additional questions about using the QuickBooks product, let me know. Our team is always around for you.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded