Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
Hi I have the same problem but when I go into the client statement it is correct the payment reflects as well as the invoice however in the ageing report only the payments reflect.
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.
A/R aging wont include future dated invoices (hasn't reached 0 day yet) , customer balance will include this.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here