How can Aged Debtors report show a different total to our 2 Debtors accounts added together in our Trial Balance

Hi, Margaret.

We can run the A/R Aeging Summary report and customize it to show the different total for your 2 Debtors' accounts in QuickBooks Online (QBO). I'll guide you through the process:

1. Open your QuickBooks Online account.
2. Go to the Reports menu.
3. From the search field, enter Accounts Receivable aeging summary and click on it.
4. Click the Customise button and scroll down to the Ageing section.
5. Change the aging method on the A/R Aging report to Report Date.
   
   
    
6. Once done, click Run report.

Compare it to the Open Balance to your Trial Balance amount for Accounts Receivable. Make sure the date range on the reports matches and that you're comparing the correct numbers. See the screenshot below for visual reference.
 

To learn more about personalising reports, check out this link: Customise reports in QuickBooks Online

Furthermore, you can export your report to Excel if you want to include details that aren't available in QuickBooks. This way, you can personalise your data further manually. 

Feel free to leave a reply if you have more questions about the process. The Community team is always here to guide you.