cancel
Showing results for 
Search instead for 
Did you mean: 
mneely
Level 1

A/R Aging Summary

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!

Solved
Best answer November 28, 2018

Best Answers
qbteachmt
Level 15

A/R Aging Summary

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.

View solution in original post

13 Comments 13
KhimG
QuickBooks Team

A/R Aging Summary

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!
 

qbteachmt
Level 15

A/R Aging Summary

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
Level 15

A/R Aging Summary

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.

mneely
Level 1

A/R Aging Summary

Thanks!

mneely
Level 1

A/R Aging Summary

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

Tom99
Level 1

A/R Aging Summary

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

 

thank you

Catherine_B
QuickBooks Team

A/R Aging Summary

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!

Chuchz
Level 1

A/R Aging Summary

How about the ones that have 0.01 cents balance? How do we determine which invoice would be related and how do we fix it?

Maybelle_S
QuickBooks Team

A/R Aging Summary

 

Hello there, @Chuchz.

 

I'm here to help you in fixing it.

 

After pulling up the A/R Aging Summary report, we'll have to click the amount in the Open Balance column to view the invoice affecting this balance. From there we'll have to manually edit the amount of the invoice to zero out the balance.

 

Here's how:

  1. Go to the Reports menu.
  2. Hover over Customers & Receivables, then click A/R Aging Summary.
  3. Look at the amount balance from the report and then click on it.
  4. Find the transaction cause the balance.
  5. Select the invoice amount.
  6. From the invoice window, edit the amount.
  7. Once done, click Save & Close.

 

Feel free to browse this link about customizing reports in QuickBooks Desktop: Customize reports.

 

Let me know if you have other questions about QuickBooks. I'll be right here to help you out. Have a great day!

Jean3
Level 1

A/R Aging Summary

I have the same problem Someone before me posted a JE with an A/R account. This is old data but it shows up on our A/R reports. Is there a way to fix it without changing accounts in JE?

ZackE
Moderator

A/R Aging Summary

Thanks for joining this thread, Jean3.
 

To confirm what you'll need to do for your journal entry to display correctly, I'd recommend working with an accounting professional.
 

If you're in need of one, there's an awesome tool on our website called Find an Accountant. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.
 

Here's how it's used:

  1. Go to our Find an Accountant page.
  2. In your Find an expert in section, choose what you're looking for, then use the search field to enter a City or ZIP code.
  3. Hit Search.
  4. Browse through the results and find one that works best for your business. You can click on each ProAdvisor's profile to learn more information about them.

 

Once you've found an accounting professional, they can be contacted through their Send a message form:

  1. Use the available text box to introduce yourself. Be sure to include details about the services you're looking for.
  2. Enter your appropriate info in the Your nameYour email, and Your phone number (optional) fields.
  3. Click Send message.


You'll also be able to find many useful resources about working with QuickBooks in our help article archives.
 

If there's any questions, I'm just a post away. Have an awesome day!

stilllearning1111
Level 1

A/R Aging Summary

I have 2 accounts that both have a zero balances but the amount is still showing in the A/R Aging summary. I have applied the credits but it still shows an amount owed. How do I zero out the amounts to show the zero balance? 

Giovann_G
Moderator

A/R Aging Summary

Thanks for joining the thread, stilllearning1111.

 

I'll share some information why the amount on the A/R aging summary report is still listed as owned. You might have applied the credit to an invoice with a future due date. As a result, it will not capture the upcoming invoice if you pull up the report dated for today.

 

Let's click the amount on the report to open the unapplied payment or credit. This way, you can choose the appropriate date to get the actual outstanding balance.

 

  1. Pull up the A/R Aging Summary report from the Reports menu.
  2. Click the amount on to open the balance.
  3. Double-click the amount to open the Receive payment window.
  4. Review the date of the invoice where the credit is applied.
  5. If it's dated in the future, you can adjust the reporting date of your report.

 

If it's within the reporting date, you can run the verify and rebuilt data to ensure your company file is free from any issue.

 

Once done, you might want to read through these articles to learn how to effectively manage your reports. These provide information on how to access and change them outside of QBDT:

 

 

I'll be around if you need further assistance running reports in QuickBooks. Keep safe and have a good one.

Need to get in touch?

Contact us