A/R Summary has 1200 zero balance customers after migration from Desktop

It's probably because either payments or credits were not applied to invoices. Both are open, for a net balance of 0.00.

Personally I'd run, run away from QB Online and stay with desktop for the next three years or so. You can still buy QB 2024, which will be supported for three years, but calling Intuit sales.

There is no way payments and/or credits were not posted to invoices for the last 20+ years; even my very experienced bookkeeper is perplexed by this report. We were able to customize & save the A/R Summary report to except zero amounts and show non-zero rows & columns, which somewhat got us a usable report. There were still odd receivables showing up from 2010, 2011. Go figure. Plus my sales tax payable report is screwed up for reasons we cannot figure out. This migration nightmare has been SO time consuming. 

I liken using QuickBooks Online to banging my head against the wall… because it will feel so good when I stop!

Thank you for raising your migration concerns here in the Community, KerryFitz.

I acknowledge the challenges you're facing transitioning from the desktop program to the online platform. Let me help you navigate how to resolve the issue of customers showing in your A/R Aging Summary report with zero balances.

 QuickBooks Desktop (QBDT) and QuickBooks Online (QBO) are built on different platforms, which is why there are differences in how your books look. This is due to export limitations and unsupported versions of Internet Explorer.

 After exporting your company, it is crucial to compare your financial reports to guarantee the accuracy of your data. Begin by running the A/R Aging Summary report in QBDT and QBO. Double-check that the reporting period is set to All Dates and choose Accrual as the accounting method.

In case you keep seeing the 1200 customers with zero balances in both reports, I suggest reaching out to your accountant for further assistance. They can guide you on how to address the discrepancies in your A/R Aging Summary statement, including your sales tax payable report. Contacting them will ensure the accuracy of your records, particularly in QBO.

These resources outline a complete set of tasks that you'll need to accomplish after migrating from both platforms, along with instructions on getting used to the online program. Take a look at each link provided for specific guidance: 

• Learn what to do after you move from QuickBooks Desktop to QuickBooks Online
• Get started with QuickBooks Online
  
  

Don't hesitate to loop us in whenever you need assistance navigating around QBO. We're always here to provide further support and guidance when you need it, KerryFitz.