Incorrect Trial balance after import of data

MB28 · ‎March 01, 2020

I've just purchased QB online, and bought my data across from QB Desktop, but there are big differences between the TB of the two files. I've checked and QB Desktop had about 60000 items, so shouldn't be too large. Is there a simple way of checking file validity, or do I need to delete my online data and start again?

MaryLandT · ‎March 01, 2020

Hi there, MB28,

Let me clear things out about bringing your QuickBooks Desktop (QBDT) data to Online.

QuickBooks Online (QBO) doesn't have the same reports as QBDT. Accrual basis reports will match your reports while cash basis reports may not. This could be the reason why the trial balance is not showing a correct balance.

Find out that data doesn't convert through this article: What to expect when you switch from QuickBooks Desktop to QuickBooks Online. This article is intended for QBO US users but also works in your region.

When running reports in QBO, make sure:

The date is set to "All Dates" in both products.
Your accounting method is set to accrual.

You can also refer to the What to do after converting from QuickBooks Desktop for Windows or Mac to QuickBooks Online page to learn things you should perform once done transferring your data.

On the other hand, importing data is irreversible. Thus, you can delete them and start over. Before proceeding, you'll need to on how long you've been using QBO. You can only reset your account within 90 days of signup. Otherwise, you'd need to cancel and sign up for a new account.

Reset your account within 90 days of signup

This is for QuickBooks Online Plus or Essentials users only. You need to cancel the current account and start a new one if you're using Simple Start. Also, this process will delete all data in the company file. Once deleted, you're unable to restore them.

Sign in to your QuickBooks Online Company.
Change the URL to include /purgecompany. Example: Change https://sg.qbo.intuit.com/app/homepage to https://sg.qbo.intuit.com/app/purgecompany.
The next screen will provide a summary of the items to delete.
Type YES to delete the data, then click OK.

Things to know you need to know after purging your account:

If the industry you want to use is different than the one showing, feel free to change it.
Mark whether you would like the system to create accounts based on your industry or start with an empty chart of accounts.
Once your selections are complete, select Wipe Data. When the deletion is complete, you will be rerouted to your homepage.

Reset your account that is more than 90 days old

Sign in to your QuickBooks Online account.
Go to Settings ⚙, then hit Account and Settings.
Select Billing and Subscription, then click Cancel Subscription.
Follow the on-screen prompts to complete the process.

You can also save time by reusing the lists from the old company. Check out the Move your lists page to learn how to import data to QBO.

Let me know if you have follow-up questions, and I'm always around to help you out.

View solution in original post

MaryLandT · ‎March 01, 2020

Hi there, MB28,

Let me clear things out about bringing your QuickBooks Desktop (QBDT) data to Online.

QuickBooks Online (QBO) doesn't have the same reports as QBDT. Accrual basis reports will match your reports while cash basis reports may not. This could be the reason why the trial balance is not showing a correct balance.

Find out that data doesn't convert through this article: What to expect when you switch from QuickBooks Desktop to QuickBooks Online. This article is intended for QBO US users but also works in your region.

When running reports in QBO, make sure:

The date is set to "All Dates" in both products.
Your accounting method is set to accrual.

You can also refer to the What to do after converting from QuickBooks Desktop for Windows or Mac to QuickBooks Online page to learn things you should perform once done transferring your data.

On the other hand, importing data is irreversible. Thus, you can delete them and start over. Before proceeding, you'll need to on how long you've been using QBO. You can only reset your account within 90 days of signup. Otherwise, you'd need to cancel and sign up for a new account.

Reset your account within 90 days of signup

This is for QuickBooks Online Plus or Essentials users only. You need to cancel the current account and start a new one if you're using Simple Start. Also, this process will delete all data in the company file. Once deleted, you're unable to restore them.

Sign in to your QuickBooks Online Company.
Change the URL to include /purgecompany. Example: Change https://sg.qbo.intuit.com/app/homepage to https://sg.qbo.intuit.com/app/purgecompany.
The next screen will provide a summary of the items to delete.
Type YES to delete the data, then click OK.

Things to know you need to know after purging your account:

If the industry you want to use is different than the one showing, feel free to change it.
Mark whether you would like the system to create accounts based on your industry or start with an empty chart of accounts.
Once your selections are complete, select Wipe Data. When the deletion is complete, you will be rerouted to your homepage.

Reset your account that is more than 90 days old

Sign in to your QuickBooks Online account.
Go to Settings ⚙, then hit Account and Settings.
Select Billing and Subscription, then click Cancel Subscription.
Follow the on-screen prompts to complete the process.

You can also save time by reusing the lists from the old company. Check out the Move your lists page to learn how to import data to QBO.

Let me know if you have follow-up questions, and I'm always around to help you out.

MB28 · ‎March 01, 2020

Thanks, will check this out. I think reports were all dates, accruals, but can purge data OK

sld2012 · ‎April 13, 2020

@MB28 wrote:
Thanks, will check this out. I think reports were all dates, accruals, but can purge data OK

Hi,

Have you managed to figure out a solution to your problem?

I have had the same issue after migrating from QB Desktop to Online. Alot of the figures from both the Balance Sheet and Trial Balance do not match up although the Profit and loss match. I have already purged my company once after initial migration but thet doesn't seem to have sorted my balances. Even my current bank account balance does not match (online version shows about £2k more (eventhough my bank account is not connected to QB Online). Saying that i have migrated another company that that has worked perfectly, even the payroll was migrated without having to import the payroll XML file (as per QB instructions).

If you have managed to work out a way to balance the amounts, would be grateful if you could share how you managed ot do it.

Kristine Mae · ‎April 14, 2020

I want to ensure you'll get the best help with your concern, Sld2012.

I'd suggest reaching out to our customer care support. They have more tools to check and help you with managing the balances. Here's how:

Click Help inside QuickBooks Online.
Select Contact Us.
Enter "Amounts not balancing after the conversion" in the description field, then click Let's talk.
Select either Start messaging or Get a callback.

Once done, you can pull up both Profit and Loss and Balance Sheet reports and check if it's already balanced.

If you have additional questions, please feel free to swing by.

Topics

Training

Community

Resources

Incorrect Trial balance after import of data