cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
tanghorty
Level 1

Why AR Aging summary not match with Customer balance summary in Quickbooks Desktop? Pls help to share us. Thank in advance.

 
3 Comments 3
RCV
QuickBooks Team
QuickBooks Team

Why AR Aging summary not match with Customer balance summary in Quickbooks Desktop? Pls help to share us. Thank in advance.

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.

DtIma
Level 1

Why AR Aging summary not match with Customer balance summary in Quickbooks Desktop? Pls help to share us. Thank in advance.

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.

RCV
QuickBooks Team
QuickBooks Team

Why AR Aging summary not match with Customer balance summary in Quickbooks Desktop? Pls help to share us. Thank in advance.

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: 

  1. Try signing in to your QBO using a private or incognito window. (Ctrl + Shift + N for Google Chrome browser, Ctrl + Shift + P for Mozilla Firefox browser, Command + Option + P for Safari browser). 
  2. If it works, go back to your regular browser and clear the cache to delete those temporarily stored files and browsing history. The overtime collection of data can create corruption, however, removing this should fix the issue.
  3. You can also use supported, up-to-date browsers to roll out the possibility of a browser-related issue. 

 

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:

  1. Go to the Help menu at the upper right.
  2. Select Contact Us.
  3. Enter your concern.
  4. Click Let’s talk.
  5. Choose Start a chat. and type in your contact info.

 

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.