Table of Contents

Bad Debts Reserve Setup

  1. On the Bad Debts Reserve Setup page, fill in the following fields:
Field name Description
Reserves for Bad Debts Nos. Specifies the number series for unposted bad debt reserve documents.
Posted Reserves for Bad Debts Nos. Specifies the number series for posted bad debt reserve documents. This field is required to post a document.
Date Analysis Type If Posting Date Document is selected, the number of overdue days is calculated from the document posting date. If Due Date Document is selected, the number of overdue days is calculated from the document due date.
Reserve Posting Type If Revaluation of Reserves is selected, the reserve amount is posted as the difference between the previously accrued reserve and the currently calculated reserve amount. If Reversal & Accrual of Reserves is selected, the full calculated reserve amount is posted and reversed on the date calculated from the Reversal Period Formula field.
Application of Red Reversal Method Specifies whether the red reversal method is used when previously accrued reserves are decreased.
Reversal Period Formula The field is editable only if Reserve Posting Type is Reversal & Accrual of Reserves. Specifies the date on which reserve reversal entries are created. We recommend setting a date that is the first day of the month following the reserve creation month.
Post detailed operations of the Reserve If the option is not enabled, general ledger entries are created for the total reserve amount. If it is enabled, general ledger entries are created for each reserve line by customer ledger entry.
Gen. Journal Template Name Specifies the general journal template that the system uses when posting the reserve. This field is required.
Gen. Journal Batch Name Specifies the batch of the selected general journal template that the system uses when posting the reserve. This field is required.

Related number series configured on the No. Series page for the series in the Reserves for Bad Debts Nos. field are available for selection in the document.

When a new company is initialized, the system automatically creates the BDRESERVES source code and assigns it to the Bad Debt Reserve Document field on the Source Code Setup page. When a document is posted, this source code is recorded in the created general ledger entries and reserve customer ledger entries. The field must contain a value before the document can be posted; you can select a different source code when necessary.

  1. Create risk groups on the Bad Debt Risk Groups page that determine the doubtfulness coefficient. To do this, specify the Code and Name of the group.
  2. On the Bad Debt Risk Coefficient page, set up doubtfulness coefficients by group and period:
Field name Description
Bad Debt Risk Group Specifies the risk group.
Start Date Specifies the date on which the setup becomes effective.
Quantity Days Specifies the number of debt days for which the bad debt reserve coefficient is defined.
Reserve, % Specifies the bad debt reserve coefficient as a percentage. The value is displayed with zero to five decimal places, without a currency code or symbol, regardless of the Show Currency setting on the General Ledger Setup page.

Note For each combination of Bad Debt Risk Group and receivables term, the last period must not have an upper limit. For example, >90. After setting up the Bad Debt Risk Coefficient, use the Check Debt Risk Period function. It identifies overlapping periods.

  1. On the Customer Card, specify the Bad Debt Risk Group to which the customer belongs.
  2. In the Customer Posting Groups settings, specify the following accounts:
    • Reserve of Overdue Receivables Acc. — the account on which overdue receivables reserves are posted;
    • Expenses For Reserves of Overdue Receivables Acc. — the expense account used to accrue a reserve;
    • Reserve Adjustment (Decrease) Acc. — the account used when a reserve is decreased and Application of Red Reversal Method is disabled.

When document lines are calculated and before the document is posted, the system checks whether the reserve and expense accounts are specified for every customer posting group used. If Application of Red Reversal Method is disabled, the system also checks the reserve adjustment account. If a required account is blank, document lines or general ledger entries are not created.

Generating Entries When Reducing a Reserve

The Application of Red Reversal Method option determines how entries are generated when the amount of a previously accrued reserve is reduced:

  • If the option is enabled, the system generates an entry using the red reversal method between Expenses For Reserves of Overdue Receivables Acc. and Reserve of Overdue Receivables Acc..
  • If the option is disabled, the system generates an entry through Reserve Adjustment (Decrease) Acc..

When the option is disabled, the reserve reduction entry is as follows:

Operation Debit Credit
Reduction of bad debt reserve Reserve of Overdue Receivables Acc. Reserve Adjustment (Decrease) Acc.