Managing Allowance for Doubtful Debts

Outcome

An allowance for selected doubtful debts is recorded. A detailed allowance statement and an accounting journal with the totaled allowance amounts are printed. The statement contains the following information:

Customer number, invoice number, invoice date, due date, invoiced amount, VAT, outstanding recorded amount, depreciation percentage, depreciation amount, previous depreciated amount, and difference amount.

Customer invoices for which allowances have been made are still open for payment in accounts receivable.

The allowances can be viewed per customer in 'Accounts Receivable, Display Balances' (ARS225), using a column template containing value type 8.

Record the allowance for audit purposes and to make it possible to estimate potential customer losses. However, the allowance recorded does not affect the cash flow plans created in the Cash Flow Management component group.

The allowance proposal is saved in files FARDDP (name and selection criteria) and FARDDT (selected transactions).

The general ledger is updated. The basic account entries created in the balance file for accounts receivable (FSLBAL) are:

Before you start

• The starting conditions listed in Managing customer debts must be met.
• FAM function AR70 must be defined for allowance for doubtful debts in 'FAM Function. Open' (CRS405).
• The following accounting types must be defined under accounting event AR70 in 'Accounting Rule. Set' (CRS395).:

• 360: Allowance for doubtful debts (balance account)
• 361: Allowance for doubtful debts (P&L account)
• 362: Reverted allowance for doubtful debts

• Age ranges determining which invoices to include in this process must be defined in 'Doubtful Account. Define Age Range' (ARS060).
• Percentages for the write-off must be defined for the age ranges in 'Doubtful Account. Define Depreciation Percentage' (ARS065).
• In order for the allowance proposal to update the general ledger, the parameter Update general ledger must be activated in 'Settings – General Ledger' (CRS750/F).
• It must be defined whether gross or net amount should be used as basis for the allowance in the Base amount field in (CRS750/F).
• There must be at least one past due customer invoice within the age ranges defined in (ARS060).

Follow These Steps

1. Define Selection Criteria and Creating Allowance Proposal

   Define the selection criteria separately in 'Doubtful Account. Create Allowance' (ARS130). By using customer groups for the selection, for example, you can treat foreign and domestic customers separately. The proposal is then printed based on the criteria in the same program.

   Note: Invoices blocked from payment processing in 'Accounts Receivable. Display' (ARS200) are also included when creating the proposal.

2. Adjust Allowance Proposal

   Change the selection criteria in (ARS130), if necessary. You can also prevent invoices from being included in the proposal by assigning them a revised due date outside the age range in 'Customer Invoice. Change' (ARS201).

   In both cases, you must create a new proposal.

3. Create Final Allowance for Doubtful Debts

   When you specify in (ARS130) that the proposal should update the general ledger, the final allowance is recorded.

   Payment made on invoice for which an allowance is created is credited to the next period when running the program the next time.

   When it is evident that an invoice will not be paid, due to the customer going bankrupt, you manually write off the invoices in question in 'Customer Receipt. Record' (ARS110) by using a user-defined accounting option for that purpose. The account should be the same as used for the reverted allowances above.