Share
ReportHi Community-members!
For our monthly-closing, we need to calculate a Doubtful Debt-provision.
We do this based on the Aging of our Customers, by making use of the Customer Aging Report with our defined Aging Period Definitions.
For our monthly-closing, we need to calculate a Doubtful Debt-provision.
We do this based on the Aging of our Customers, by making use of the Customer Aging Report with our defined Aging Period Definitions.
Example:
- 10% for Customer-balances >60days
- 25% for Customer-balances >90days
Issue
The Customer Aging Report is including the VAT/Sales Tax.
While, as per GAAP, our Doubtful Debt-provision needs to be based on Net-amounts = excluding vat.
While, as per GAAP, our Doubtful Debt-provision needs to be based on Net-amounts = excluding vat.
Question
Is there an option to generate a Customer Aging Report without VAT/Sales Tax?
The workarounds I see is: manual data extract from CustTrans and TaxTrans, and do a vlookup. Or generate a PowerBI-report.
But if a standard report is available, I prefer using that!
Thanks in advance,
Patrick
All responses (
Answers (
415
