Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
mneely
November 28, 2018
Solved

A/R Aging Summary

  • November 28, 2018
  • 2 replies
  • 25 views

How do I remove a customer who balance is zero in A/R aging summary and who was not set up as an invoice?  It was entered via general journal.

 

Thanks!

Best answer by qbteachmt

In the AR Aging Summary report, when a name shows 0 under Total, you know that name should not show at all. Their Math is 0, but you have unapplied transactions. You double-click their total of 0, to see what is Unapplied against each other.

 

Go to Receive Payment for that name. Leave the Amount as 0. Here you can select anything that is an open charge balance, and here you see the Icon in the ribbon at the top to Apply available credits, as shown in the middle bottom part as value still available. Do this until everything is Applied to something else. Always leave the Amount in the Receive Payment screen as 0; you are not Receiving any new funds.

2 replies

K
KhimG
Level 7
November 28, 2018

Good day, @mneely.


Thanks for reaching out to the Community space. Let me help you remove the customer whose balance is zero in your A/R Aging Summary Report.


With QuickBooks Desktop, you can customize the data, add or delete columns, add or remove information, and even personalize any report that you generate. Allow me to walk you through the steps in removing the customer whose name you don’t want to show on the report. 
1.    Log into QuickBooks.
2.    Click Reports from the top menu and select Customers & Receivables.
3.    Run the A/R Aging Summary Report.
4.    On the Report window, click the Customize Report button.
5.    On the Modify Report window, go to the Filters tab and search for Name as the filter.
6.    Under the Name box drop-down, select Multiple names.
7.    Select all the customers you want to show on the report. 
8.    Click OK from that screen and then another OK on the Modify Report window.


Once done, the report you generate will only display the names you selected. For more information on customizing report, check out this article: Customize reports in QuickBooks Desktop.


Let me know if you have questions. I’ll be here to help. Enjoy your day!
 

T
Tom99
June 1, 2020

how do i know which ones are non zero and select only those?

 

thank you

C
Catherine_B
Level 9
June 1, 2020

Hello there, Tom99. 

 

We can decrease the number of interval days and then export the A/R Aging Summary report to remove zero data. I'll show you how: 

  1. Go to Reports and choose Customers & Receivables > A/R Aging Summary. 
  2. Click Customize report at the upper-right. 
  3. Decrease the number in the Days per aging period field. This is to drill-down most of the aging transactions. 
  4. Click OK to refresh. 
  5. Select Excel from the menu to export the report and manage it from there. 

On the other hand, we can also use the Customer Balance Detail report and add an Aging column. Here's how: 

  1. Still from Reports > Customer & Receivables > Customer Balance Detail.
  2. Click Customize Report and select the Filter tab.
  3. Locate and click Aging and select a condition.
  4. Click OK. 

You can also use these reference in customizing your customer and sales reports.

 

I'll be here if there's anything you need help with. Take care always and have a great day!

qbteachmt
qbteachmtAnswer
Level 11
November 28, 2018

In the AR Aging Summary report, when a name shows 0 under Total, you know that name should not show at all. Their Math is 0, but you have unapplied transactions. You double-click their total of 0, to see what is Unapplied against each other.

 

Go to Receive Payment for that name. Leave the Amount as 0. Here you can select anything that is an open charge balance, and here you see the Icon in the ribbon at the top to Apply available credits, as shown in the middle bottom part as value still available. Do this until everything is Applied to something else. Always leave the Amount in the Receive Payment screen as 0; you are not Receiving any new funds.

qbteachmt
qbteachmt
Level 11
November 28, 2018

Oh; please note that JE bypassed Sales, bypassed cash vs accrual basis, etc. Unless this is historic data, the better option is to Replace the JE with the proper entry. AR = invoices, credit memo and Receive Payment. Not JE.

M
mneelyAuthor
November 29, 2018

I am aware.  This was something posted prior to me joining the team.  Thanks, again!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement