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.
protek800
Level 1

Migrating from QBD to QBO

I just migrated from Quickbooks Desktop 2022 to Quickbooks Online Essentials. After importing my company file, I checked my Profit and Loss for 2022. In quickbooks online when running it in cash basis it shows about $900 more (net income) than my desktop version does. When I switch to accrual it lines up which is fine. But when I try to figure out what the discrepancy is on the cash basis PandL, I notice that almost all sub-income accounts have discrepancies. The Total Exepense number lines up but the Total (gross) income is not the same as QBD. Most of the income sub accounts are off by a few hundred to a few thousand (e.g., in QBO one income account says $552.32, in QBD it says $498.2 - or it could be reversed, where in QBD it shows MORE then what's in QBO.) At the end of the day I have a $900 difference and I am wary that the discrepancies in the Income subaccounts are indicative of something more wrong. I was on the phone with quickbooks support for almost two hours and spoke to four different people and absolutely no one could help me it took me an hour just to get someone on the phone who could even understand my question. Then I got someone who told me that "QB Online rounds off numbers automatically" (WHAT IN THE WORLD?!). Can someone out there advise? FYI the balance sheet is off by a few thousand, pandl is off by 900... and quickbooks support apparently can't help. 

5 Comments 5
Fiat Lux - ASIA
Level 15

Migrating from QBD to QBO

It takes patience and persistence to spot the difference, and I'm not surprised the Support team isn't up for this problem. You will have to request a CPA or purchase a third party service to convert your data.

 

JessT
Moderator

Migrating from QBD to QBO

Hi protek800,

 

Converted data from QBDT may have a difference on the reports on a cash basis. This is because some transaction types are presented differently in QBO. You can refer to the article about how features and data move from QuickBooks Desktop to QuickBooks Online. You'll want to expand the transaction section.

 

I wish I could check your entries further. However, we don't have the option to do that in the Community, only our Phone and Chat teams.

 

On the other hand, you can also consider Fiat Lux - ASIA's suggestion about using a third-party app to convert your file.

 

If you need references for QBO, just click the Training menu above and select Video tutorials.

 

Let me know if you have other questions in mind.

protek800
Level 1

Migrating from QBD to QBO

Thanks. I wish that there was some clear answer though as to HOW QuickBooks online presents transactions differently than QBD. I heard that from support, but no one could explain what that difference actually is. 

 

I've tried looking into individual transactions, but it just goes in a circle - even if I find a difference, there's no logic explanation about WHY it's different and how to fix it. For example I found one transaction that was different in QuickBooks online by a few cents in the PandL - (payment on an invoice, income) - but when you look at the actual payment itself, it's correct in both locations. It like the online PandL just somehow shows different numbers for no logical reason. 

 

It wouldn't matter to me so much accept that this makes it near impossible for me to trace what that $900 difference is, can't reconcile the accounts until I do. 

 

Can no one at QuickBooks explain what the actual technical difference is between the PandL reports for QBD and QBO??

djustd
Level 1

Migrating from QBD to QBO

Did you ever find a solution to this? I just migrated my data over and my payroll liabilities are over what's reported by QBD, but I found that the same total that I'm under in the liabilities, I'm OVER in retained earnings, so the end total is correct for both reports. Each category for the liabilities is off by just a bit. It's odd. It says to reach out to support, but a quick browse through these forums doesn't instill confidence that they're going to find the solution.

ZackE
Moderator

Migrating from QBD to QBO

Thanks for joining the Community and getting involved with this thread, djustd.
 

As mentioned in JessT's post, when you migrate data from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO), reports can look different depending on which accounting method you're running them in. Accrual basis reports in QBO will match your QBDT reports, however, cash basis reports may not match.
 

You can learn more about the limitations of migrating data from QBDT to QBO in our Learn how features and data move article.
 

At the same time, since you suspect there was an issue with your data migration which caused this, and you're seeing an in-product message advising you to reach out to support, I'd recommend getting in touch with our Customer Care team. They'll be able to pull up the account in a secure environment, conduct further research with you, and create an investigation ticket if necessary.
 

They can be reached while signed in.
 

Here's how:

 

  1. Use the Help (?) icon.


     
  2. Click Contact Us.


     
  3. Enter a description of your situation in the What can we help you with? field, then hit Let's talk.


     
  4. Select Start messaging or Get a call.

 

Be sure to review their support hours so you'll know when agents are available.

 

I've also included a detailed resource about migrating data from QBDT to QBO which may come in handy moving forward: Learn about converting from QuickBooks Desktop to QuickBooks Online

 

If there's any additional questions, I'm just a post away. Have a lovely day!

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

Need to get in touch?

Contact us