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

marya · ‎12-10-2018

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?

Raywhite28 · ‎12-10-2018

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.

Raywhite28 · ‎12-10-2018

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.

Raywhite28 · ‎12-10-2018

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.

qbteachmt · ‎12-10-2018

"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.

qbteachmt · ‎12-10-2018

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

Browse by Topic

Training

Community

Resources

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 t...

Yes, only if you customize the report & manually select t...

Yes but you can choose which customer you want on the rep...

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

You already have AR Aging Summary with these columns. Rep...

How do I clear out the negative amount on the A/R ...

What is the proper way invoice for non inventory i...

How do I create a report showing PTO activity and ...

How do I account for labor and costs on an invoice...

Custom Field Reporting on Customer Job Set Up

Need to get in touch?