Connect with and learn from others in the QuickBooks Community.
Join nowI 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! Go to Solution.
"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.
"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.
You already have AR Aging Summary with these columns. Reports menu > Customers & Receivables.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.