Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Ivan_G
Moderator

Reply to message

I appreciate you for adding your concern to this thread. I'm here to assist you in removing customer data from your A/R Aging Summary report.

 

Regardless of when a customer is made inactive, they'll still reflect on the A/R Aging Summary report if they have unapplied payments or credits in the system. To remove them from the data, we have two options that we can take depending on which suits you best.

 

The first option is to make a customer active momentarily, then apply the unapplied payment or credit to that individual.

 

  1. Go to the Customers menu and select Customers Center.
  2. Navigate to the Customers & Jobs tab. Then, from the Active Customers dropdown, choose All Customers.
    C&J All customers.png
  3. Double-click the inactive customer and uncheck the Customer is inactive checkbox.
  4. Hit OK. Then, go back to the Customers menu and select Receive Payments.
  5. Pick your customer from the Receive From dropdown.
  6. Tick the checkbox for the open invoice and existing credits by clicking Apply Credits if there are any.
  7. Once you select Apply Credits, the Discount and Credits page will appear. Tick the Check column to apply all the Available Credits.
  8. After that, hit Done and then Save & Close.
    Receive payments apply credits.png

Following that procedure, you can make that individual inactive again from the Customers Center.

 

The second option is to customize the report by selecting only the active customers. This way, only their data will be visible.

 

  1. Access the A/R Aging Summary report and click the Customize Report button.
  2. Go to the Filters tab and select Name from the Filter list.
  3. From the All customers/jobs dropdown, choose Multiple Names.
  4. Tick all your active customers (this action will put a checkmark on the customers/jobs). Then, leave the inactive customer unchecked.
  5. Once done, click OK and then OK again to save the changes.
    Customize report multiple names.png

 

You may also check this link if you need help managing your reporting works in QuickBooks: Understand reports.

 

I've also included this article, which will be handy once you have to handle and classify customer payments from your bank feeds: Add and match Bank Feed transactions in QuickBooks Desktop.

 

I'm still available if you have more questions about your reports, data, and transactions in QuickBooks. Just comment on this thread so I can get back to you promptly.

Need to get in touch?

Contact us