cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
DS127
Level 5

QB Desktop Enterprise to QBO conversion - statements not matching

I am soooo frustrated. I am converting a client's QBD Enterprise account to QBO. I've done a lot of these conversions and this is definitely the messiest.

 

Client has data starting 2000 in QBDE.  I condensed the data to 1/1/2019 before taking it to QBO. I've done the migration TWICE on the advice of Intuit, and the result is the same:  a number of items on the P&L and Balance sheet (around 15) are NOT the same in QBO as they are in the original file.  

 

I realize that the reason must be that certain transactions were not uploaded to QBO on the migration. What is people's advice on that? Intuit says I can get it to Data Services, but it will take a week for them to do the JE's to make the categories right. If I do it, the client for sure doesn't want to pay for my time. Do you all think I should try converting the whole thing, without condensing (which is scary to me bc of all the data) and would this work?  Meanwhile my client has had to wait WAY TOO LONG to get into his books.

thanks much.

 

3 Comments 3
MarsStephanieL
QuickBooks Team

QB Desktop Enterprise to QBO conversion - statements not matching

I understand how important it is to get successful results when migrating the data, @DS127. I can share more details about the migration process from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO).

 

The targets will matter when importing to QBO. You can consider checking it before migrating. Sometimes it is the cause of missing items in the company data after the process. The maximum target to get a correct data migration is 750,000 for the QBDT Enterprise version 2021 and 35,000 targets for QBDT Enterprise 2020 and earlier versions.

 

Using a Condense Data utility will reduce the data, it includes archiving some transactions and turning them into Journal Entries automatically. You can migrate the data to QBO without condensing. However, it will take more time.

 

In your case, I recommend speaking to our Data Services and having a backup file before doing the process again. You can also let your client know about the conversion process. This way, you can open up about the Data services.

 

To know more details about the process, you can review this article: Use the Condense Data utility.
 

I'll be around if you have other questions or concerns about managing data. Please don't hesitate to comment below, I'm here to guide you further. Take care.

Fiat Lux - ASIA
Level 15

QB Desktop Enterprise to QBO conversion - statements not matching

@DS127 

Another option, ask your client to purchase a 3rd party conversion service. You can run the conversion in two phases where your client can still work on their book on QB Desktop during the first phase (eg 2000 - 2020). When you are satisfied with the first phase, you will give the green light for the second phase (eg 2021 - cut off date).

DS127
Level 5

QB Desktop Enterprise to QBO conversion - statements not matching

Thanks both of you for your replies.

I would have Data Services do the fixes but unfortunately they are backed up for about a week and my client can't wait that long (he thought he'd have his stuff by Tuesday and it's Thursday now.)  And he's not going to pay for a conversion service...silly us, we expected that QB would do the job (is the issue inherent to Enterprise, or what's the root problem?)

 

I always check the targets first...my understanding is that it is 350,000 limit in earlier versions (we were at 217,000) and yes it was recently upped.  We are running 2022 so this number should not have been a problem.

 

Im really frustrated with QBO and Intuit right now.

Since I don't have time to wait for Data Services to make the JE's, can someone confirm...do I book them to Opening Balance Equity to make the 15 or so category balances correction? thanks.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us