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

How do i create a 30,60,90 day collections report without the same customers showing up on each of the reports?

I created a 90 days collections report, then a 60 days collections report and the same customer comes out on the two reports. Is there a way to create only the 30, 60, and 90 days collections report without the same customers coming out on each report?

Solved
Best answer 12-10-2018

Best Answers
Highlighted
ProAdvisor

How do i create a 30,60,90 day collections report without the same customers showing up on each of the reports?

Yes, only if you customize the report & manually select the customer(s) you want on the report. To do that click on customize or modify, the filters then names & multiple names & check off the names.

View solution in original post

4 Comments
Highlighted
ProAdvisor

How do i create a 30,60,90 day collections report without the same customers showing up on each of the reports?

Yes, only if you customize the report & manually select the customer(s) you want on the report. To do that click on customize or modify, the filters then names & multiple names & check off the names.

View solution in original post

Highlighted
ProAdvisor

How do i create a 30,60,90 day collections report without the same customers showing up on each of the reports?

Yes but you can choose which customer you want on the report. If they are on the 60 day report, by not selecting their name you can eliminate them from the 90 report.

Just teaching how they can eliminate name from the reports.
Highlighted
Level 15

How do i create a 30,60,90 day collections report without the same customers showing up on each of the reports?

"without the same customers coming out on each report?"

"only if you customize the report & manually select the customer(s) you want on the report."

Here is the issue:

The Collections report is showing things Over 60 or Over 90. If something is Over 90, they also are Over 60 and Over 30. Of course, the same customer with a balance over 90 is going to show on all all three reports.

That is the point of the Aging Reports = put the balances in the proper places.



Highlighted
Level 15

How do i create a 30,60,90 day collections report without the same customers showing up on each of the reports?

You already have AR Aging Summary with these columns. Reports menu > Customers & Receivables.

Need to get in touch?

Contact us