Thank you for joining the thread, @jdemo.

When migrating data from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO), be aware of limitations in data capacity. QBO can only handle up to 1.2 million data targets. Possibly, as a result, not all of your transactions may have been transferred to QuickBooks Online. This could be one of the reasons about the inaccuracies in your Accounts Receivable report balance in QBO.

For more detailed information regarding limitation during migration, you can refer to this article and look for Step 2 number 4: Move your QuickBooks Desktop file to QuickBooks Online.

Also, when running Accounts Receivable report, please ensure that the report period in QuickBooks Online matches the ones in QuickBooks Desktop.

To review your Accounts Receivable balance report, here's how:

1. Log in to your QuickBooks Online accounts.
2. Go to the Reports menu.
3. In the Type report name here drop-down menu, choose the Account Receivable report.
4. Make sure that the Report period is set to All Dates or Custom.
5. Click the Customize tab and ensure that the filters are the same in your QuickBooks Desktop.

If you discover any transactions are missing, you have the option to manually create transactions into QuickBooks Online.

Additionally, you can learn how features and data move from QuickBooks Desktop to QuickBooks Online to understand the differences between the two.

Furthermore, you can utilize these useful articles for future guidance regarding your transaction:

• Customize invoices, estimates, and sales receipts in QuickBooks Online.
• Save a customized report in QuickBooks Online.

If you still have questions regarding your Account Receivable balance, feel free to reply to this thread. We're here to assist you! 

Its not an issue of targets as we are at 500K targets which is even under the 750K limit the migration team was telling us about. It is not an issue with the dates. If we look at the balance sheet and look at the 1030 account receivable line with Accrual basis checked the numbers match perfectly. But if we do the same with Cash basis the numbers are off by a huge amount. 

@jdemo 

"If we look at the balance sheet and look at the 1030 account receivable line with Accrual basis checked the numbers match perfectly. But if we do the same with Cash basis the numbers are off by a huge amount."

What else is off on your cash basis balance sheet?  If A/R is off by a huge amount, another account(s) must be off by the same amount if the balance sheet balances.  Is it inventory?    

That is the only item that we noticed is off as of now. We aren't necessarily dealing with inventory. We are a law firm and deal with retainers which I guess act as credits so we do necessarily receive the payment up front or right away but as they use their retainer. So it is normal on our desktop version of QuickBooks to show many hundreds of thousands negative cash basis AR at a given time.