Provision for Bad Debts in the books (not Write- Off of Bad Debts)
We have the below requirement for Provisioning the bad debts of Receivables
1. Bad Debts aged 60 Days - 25% provisioning entry has to be maintained
2. Bad Debts aged 120days - 50% provisioning entry has to be maintained
3. Bad Debts aged 180days - 100% provisioning entry has to be maintained
Is there anything out of the box functionality that would do that and flag those invoices with the bad debts provision.
We do not writeoff the bad debts untill 3 years when the debt become time barred or uncollectable, before 3 years all the outstanding amounts from the customer will show as follows
Ex: Receivables Rs.1000