Why is my AR aging summary report not the same online vs the desktop file we imported?
Congratulations on successfully moving your data to QuickBooks Online, localflavorfilms. I know it's rough when you encounter discrepancies when comparing the reports. I'm here to assist you with that.
It may be that duplicate transactions occurred during the import process. I'd recommend comparing the balance using the Accounts Receivable Aging Summary report on both programs. Then, let's delete the transactions in QuickBooks Online that aren't supposed to be included on the file.
Before proceeding, please make sure the reporting period is set to All Dates and the accounting method is Accrual. QuickBooks Desktop and QuickBooks Online don't track transactions as paid the same way. Reports may not match using cash basis.
Once you've determined the transactions that cause the discrepancies, we can now delete them in QuickBooks Online. I'll show you how:
Go to the Accounting menu.
Select Chart of Accounts.
Locate the Accounts Receivable account.
Click View Register.
Locate the transaction, then click it.
Click the More tab, then select Delete.
Click Yes on the prompt message.
If you have the new interface, you can locate the Chart of Accounts by going to the Bookkeeping menu. Then, follow the rest of the steps above.
To learn more about the steps you should take after moving to QuickBooks Online, please see these resources: