cancel
Showing results for 
Search instead for 
Did you mean: 
rjquinto
Level 1

Migrating from Quickbooks Desktop to Quickbooks Online

Hi,

I'm exporting my customer list from Quickbooks Desktop to QUickbooks online. I started importing first the list of customers, then after, entered their opening balances as of March 31. What happened is that in our profit and loss report, the opening balances were reflected as sales income for the year, but in fact they are the past receivables, mostly from 2019 and earlier.
How should we have done the importation and transfer of the customer lists and their unpaid balances?
Thank you
2 Comments 2
Fiat Lux - ASIA
Level 15

Migrating from Quickbooks Desktop to Quickbooks Online

Just to clarify, how did you migrate data from QBD to QBO? 

Rasa-LilaM
QuickBooks Team

Migrating from Quickbooks Desktop to Quickbooks Online

Thanks for visiting the Community, rjquinto.

 

There are things you’ll have to check before importing your customer lists into QBO. The suggestions listed below ensure your customer lists are transferred correctly.

 

  • The information in the Name field must be unique. A vendor, customer, or employee can't have the same name as one another.
  • The import process only supports one email address. However, you can manually add another one in QBO.
  • Subaccounts can't be imported.
  • Spreadsheet doesn't contain any formulas, charts, or blank rows.

Let me share the following guide to view the complete list of information to check when importing customer contacts: Import customer or vendor contacts from Outlook, Excel or Gmail.

 

Also, pending transactions from the desktop version will not convert to QBO. You'll have to manually enter them and record the payments.

 

To correct the information on the Profit and Loss Report, I recommend you get in touch with our QBO Care Team for further assistance. They have tools to review the data in a secure space and fix the issue from there.

 

  1. Tap the Help icon at the top to open the QB Assistant window.
  2. Select how you want to reach out to our support team: Ask a question or Talk to a human.
  3. Follow the on-screen instructions to continue.qbo contact general.png

Check out this article to learn more about our support hours and call me back features to fit your time: Support hours and types.


For additional resources, here’s an article that covers all the data that doesn’t come over when converting from QBDT to QBO: What to expect when you switch from QuickBooks Desktop to QuickBooks Online.


Stay in touch if you need some help when working in QBO. I’ll be right here to help and make sure you’re taken care of. Have a great day ahead.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us