Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
zjohanson
Level 1

QuickBooks Online Data Corruption After Desktop Migration (Invoices & Payments)

After we migrated from QuickBooks Desktop to QuickBooks Online back in August I found some customer invoices & journal entries that were used to apply payment, were listed as open on my open invoice report, but with a zero balance. I thought they just needed to be linked again, which I did. A few months later I found our balance sheet in cash basis was out of balance. It was due to these customer payments, some going back to 2004. As per Intuit-QuickBooks troubleshooting info on how to Fix a Balance Sheet that's out of balance, I changed entry dates to the future, then changed them back. I even deleted some entries & re-entered them. The balance sheet is now accurate, but now those same customer invoices & journal entries are showing open again on my customer open invoice report. Also, some of them are now showing a balance due, instead of a zero dollar balance. The report will show an entry with one amount, but when you click into that entry, the amount is different. One good example, I have a few invoices that all had 2 line items, one in the amount of $2362.50 & one in the amount of $65.00, totaling each invoice at $2427.50. If you open the invoice it shows at the bottom a payment in the amount of $2427.50 was made, but at the top of the invoice page it shows only $65.00 was paid, with an open balance due of $2362.50. There has to be some kind of data damage, but I don't know where to begin. Some searches mention migrating our data over again, but would that do anything to our current books after 5 months now?
1 Comment 1
AljhonC
QuickBooks Team

QuickBooks Online Data Corruption After Desktop Migration (Invoices & Payments)

Hi, I have some tips to fix the issue further. @zjohanson.

 

To confirm that the amounts in your invoices and payments are correct and to further track the changes made when editing some of them, click More and then Audit history or Transaction Journal to verify the debits and credits of the invoice and the changes that have been made to it so far.

 

The reason for this could be that the invoice payment discrepancy might just need a page refresh. While the payment amounts on the invoice may not align perfectly, the crucial point is that the figures in our records are accurate.

 

Migrating data again isn't possible, as QuickBooks Online provides a 90-day window from account creation to transfer or import data. After this period, migration options become unavailable within the existing account.

 

This is a complex post-migration data integrity concern involving invoice/payment linking and balance sheet discrepancies, and our live support team can help.

 

Here's how to get in touch with them:

 

1. Click the Help menu or the (?) icon in the upper-right corner of QBO.

2. Go to the Search tab.

3. Type contact us in the search box

4. Click Contact Us below.

5. Choose your preferred method of communication: Chat or Callback.

 

If you have any additional questions or concerns about QuickBooks, please click the Reply button to let me know.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us