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:
- The open invoices have another associated A/R account.
- The open invoices might be in a job beneath the selected customer.
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.
