Let me provide some information on possible reasons why the Account Receivable Aging Summary report not matching with the Customer Balance Summary report, tanghorty.
The Account Receivable Aging Summary report displays the number of unpaid invoices and how many days they have been outstanding. This report depends on the due of the invoices. This means even if the invoices are already paid if the payment doesn't the same as the due date or the date is before, the report still shows negative. However, if you click the transactions from the A/R Aging Summary report, the invoices will show as paid.
On the other hand, the Customer Balance Summary Report tells you how much each owes you or the total balance of the customer. This report depends on the specific due date of the invoices. In this case, there are two possible reasons why both reports are not matching with each other. Among these are:
To get this fixed, you'll have to view the account of the open invoices, then select the appropriate account from the A/R Account drop-down. If there's a job under the selected customer, you'll have the select that specific job or customer in the Received From drop-down. You can read the Record an invoice payment article for more details.
To learn more about how QuickBooks generates reports, see the Understand reports article. As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.
I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you. Take care always.
We can perform some troubleshooting steps to show the invoices in the Aging report, DtIma.
If you are trying to run the A/R Aging Detail Report, let's make sure we choose the correct date period on the report. you can also toggle it to the Current or Report date option. Then, tap, Run report. If the same thing happens, let's perform some steps to confirm browser-related issues. There are times when a browser's cache data becomes full of frequent access to web pages or damaged. This causes odd behavior in QuickBooks Online (QBO). Here's how:
If the problem perists, I'd suggest contacting our Customer Support Team. They'll pull up your account in a secure environment and investigate what's causing this issue. Here's how:
Feel free to visit our Reports page to learn more about running and managing your financial reports in your account.
I'd like to know how you get on after performing the steps or after reaching out to our support, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.