Doubtful debts are those debts which the company is unlikely to be able to collect. Moreover a doubtful debt becomes a bad debt when there is no longer any doubt that the debt is noncollectable, therefore:
- Doubtful Debt: receivable that might become a bad debt at some point in the future.
- Bad debt: receivable that has been clearly identified as not being collectible.
Doubtful debts are useful in order to make provisions for possible looses beforehand.
The following example illustrates how Openbravo manages Doubtful Debts posting to the ledger.
The Client Healthy Food Supermarkets, Co. whom owes the company 1,000 EUR is going through a difficult situation, hence it's debt is considered doubtful.
|Doubtful Debt Account||1000|
|Bad Debt Expense Account||1000|
|Allowance For Doubtful Debt Account||1000|
The Client Healthy Food Supermarkets, Co. makes a Payment of 350 EUR:
|In Transint Payment IN Account||350|
|Doubtful Debt Account||350|
|Allowance For Doubtful Debt Account||350|
|Bad Debt Revenue Account||350|
Later, the client becomes bankrupt, so it's debt is considered bad:
|Doubtful Debt Account||650|
|Allowance For Doubtful Debt Account||650|
|Bad Debt Revenue Account||650|
Before start working with Doubtful Debt some previous configuration steps are required:
- To configure Accounting for Doubtful Debts. The accounts that need to be configured are:
- Doubtful Debt Account
- Bad Debt Expense Account
- Bad Debt Revenue Account
- and Allowance for Bad Debts Account.
- To create a Preference in order to be able to see the amount of a debt that has been classified as doubtful when receiving a Payment.
This preference must be defined for the Client and the Organization that needs to see it.
This preference is an Attribute 'Doubtful_Debt_Visibility' which Value needs to be 'Y'
- To create a Document Type for Doubtful Debts.
This step is not a must, since there is already a Standard Document Type defined for Doubtful Debts.
This example is based on the previous User Story, using the demo data provided by Openbravo.
The Customer Healthy Food Supermarkets, Co. has an Invoice of 1.000,00 USD pending to be collected, and this is it's Journal Entry, created when Posting the Invoice
After three months without collecting the pending debts from this Customer, the debt from the previous Invoice is considered Doubtful, henceforth a Doubtful Debt Run needs to be created and processed.
As shown in the image below, the "Run Date" and the "Accounting Date" are the same, that is 90 days after the Invoice Date, as well as the Days Overdue.
Back to the Doubtful Debt Window, the doubtful debt created and processed in the Doubtful Debt Run can be posted. Two entries are generated in the Journal.
One to reclassify the debt from Accounts Receivable to Doubtful Debt and the other one to represent the provision for the Doubtful Debt.
A couple of days after, the Customer makes a Payment of 350,00 USD against the previous Invoice, and the Posting of the Payment creates this entries in the Journal.
One entry that balances the Doubtful Debt and the Checking In-Transfer Account, and the other entry that decreases the Doubtful Debt provision generated previously.
Three months later the Customer becomes bankrupt, therefore it won't be possible to recover it's debt any longer. A Payment is made to write off the amount remaining.
That action creates another two entries in the Journal.