You can assess late charges against past due debit items for each customer, account, or site. See: Calculating Late Charges.
The calculation of late charges is determined by your late charge policy. You can set up your policy to control various decisions, such as whether you assess late charges, and how those late charges are calculated.
To set up your organization to assess late charges, complete these steps:
Define your organization's late charge policy.
Set up your late charge documents.
Optionally define tiered interest rates.
Define your late charge policies for your various customers.
Further customize how Receivables calculates late charges for individual customers or transactions.
See: Step 5. Review Late Charge Policies at the Customer or Transaction Levels.
To indicate whether your organization assesses late charges on overdue transactions, you must select the Assess Late Charges box in the System Options window. Receivables reviews this option first, before reviewing the various aspects of your late charge policy.
In the System Options window, you also provide information to process the late charge documents you send to customers, as well as possible interest calculation alternatives for balance forward billing.
See: Transactions and Customers System Options.
You can record late charges as one of three document types:
Adjustments
Debit Memos
Interest Invoices
Follow the setup steps below to indicate how Receivables should record late charges and present them to customers. Complete this step for each organization in which you assess late charges.
If you record late charges as adjustments, then Receivables combines all interest charges relating to an overdue transaction, and creates a single late charge adjustment against that transaction.
To use this document type, complete these steps:
Define a late charge receivable activity and specify the activity's GL account.
See: Receivables Activities.
Optionally create a separate receivables activity for penalties.
Receivables creates penalties as a separate adjustment against the overdue transaction.
Select these activities during your system options setup.
If you record late charges as debit memos, then Receivables creates one debit memo per overdue transaction.
If you record late charges as interest invoices, then Receivables creates a single interest invoice per customer site and currency. The interest invoice consolidates and itemizes charges for a period, and includes details about charges for each overdue transaction.
To use either document type, complete these steps:
Define a late charge batch source with a type of Imported.
Receivables creates a debit memo or interest invoice batch using the Invoice API.
For debit memos, define a transaction type with a class of Debit Memo.
For interest invoices, define a transaction type with a class of Invoice.
Specify the Receivable and Revenue accounts. Receivables uses these accounts instead of AutoAccounting when generating late charges.
Suggestion: Use a name and description to clearly indicate that this transaction type is used only for late charges.
Select the interest invoice transaction type or debit memo charge transaction type (depending on which document you want to use), and late charge batch source during your system options setup.
Note: Receivables treats interest invoices and debit memos as regular transactions, so tax may be calculated.
You can customize late charges for both interest and penalties by creating interest tiers and tying those tiers to a charge schedule:
Use the Aging Buckets and Interest Tiers window to define a set of interest tiers based on ranges of late days.
Assign amounts or percentages to interest tiers in the Charge Schedules window.
See: Charge Schedules.
You control how late charges are calculated by defining late charge policies in the Customer Profile Classes window. You can define a different late charge policy per customer profile class.
When you assign a customer profile class to a customer, the late charge policy is defaulted to the customer account, but you can change those values. You can also define a late charge policy at the site level.
To define a late charge policy, navigate to the Customer Profile Classes window, query or enter a new customer profile class, and set the options described below. Use both the Late Charge Profile and Profile Class Amounts tab to define a late charge policy:
On the Late Charge Profile tab, enable the assessment of late charges by selecting the Enable Late Charges box.
To assess late charges, you must select both the Assess Late Charges system option and this Enable Late Charges box.
Decide how Receivables should calculate late charges. Select one of three methods:
Average Daily Balance
Calculate late charges based on the average daily balance of overdue invoices.
Use this calculation method if you are sending balance forward bills to your customers. See: Balance Forward Billing.
Late Payments Only
Calculate late charges based on the number of days between the payment due date and the actual payment date. Receivables uses the paid amount as the overdue invoice amount when calculating the late charge.
Overdue Transactions Only
Calculate late charges for transactions, based on the number of days a payment is late when you submit the Generate Late Charges program.
Overdue Transactions and Late Payments
Calculate late charges on both overdue transactions and late payments. This option levies the largest late charge amount on a customer.
For example, your organization calculates late charges on the 15th and 30th of each month. Your customer has an overdue invoice of $100 that falls due on November 16:
On November 30, you run the Generate Late Charges program.
Receivables calculates late charges for this overdue invoice.
On December 10, your customer pays the invoice.
On December 15, you run the Generate Late Charges program again.
Receivables assesses further charges for the additional 10 days that the payment was overdue.
Decide how Receivables should handle credit items and disputed transactions when calculating late charges:
Select the Credit Items box to have credit items, such as unapplied or on-account receipts, or on-account credits, reduce the total overdue amount. Selecting this option reduces the late charge.
Select the Disputed Transactions box to include disputed transactions in the total overdue amount. Selecting this option increases the late charge.
Indicate how you would like to present late charges to customers assigned with this customer profile class. You can record late charges as one of three document types:
Adjustment
Receivables calculates late charges as an adjustment against the overdue transaction.
If you levy penalty charges, then Receivables creates two adjustments.
If you selected the Credit Items box in the previous step, then credit items reduce the outstanding overdue amount during late charge calculations.
Debit Memo
Receivables creates one debit memo per overdue transaction.
If you levy penalty charges, then Receivables includes a separate line for penalty charges.
If you selected the Credit Items box in the previous step, then credit items reduce the outstanding overdue amount during late charge calculations.
Interest Invoice
Receivables creates a single interest invoice per customer site and currency. The interest invoice consolidates and itemizes charges for a period, and includes details about charges for each overdue transaction.
If you levy penalty charges, then Receivables includes a separate line for penalty charges.
If you selected the Credit Items box in the previous step, then Receivables calculates negative charges on existing credit items, and includes those negative charges as lines on the interest invoice.
If you record late charges as debit memos or interest invoices, then select a payment term to indicate the debit memo or interest invoice's due date.
Note: If balance forward billing is enabled, then this value defaults from the payment term on the balance forward bill.
Select message text to print comments on the debit memo or interest invoice.
See: Standard Messages.
Select the interest calculation formula:
Flat Rate
Use a flat rate to calculate the late charge amount. Receivables ignores the number of days that a payment is overdue. The formula is:
Amount Overdue * (Interest Rate/100)
Simple
Calculate late charges on overdue transactions only. The formula is:
Amount Overdue * (Interest Rate/100) * (Number of Days Late/Number of Days in Period)
Compound
Calculate late charges on the sum of overdue transactions and prior late charges. The formula is:
(Amount Overdue + Prior Late Charges) * (Interest Rate/100) * (Number of Days Late/Number of Days in Period)
Select the interest calculation period:
Daily
Receivables determines the number of days that a payment is overdue to the exact day. For example, if a transaction is 45 days past due, then Receivables calculates late charges based on 45 days.
Monthly
Receivables determines the number of days that a payment is overdue by rounding up to the nearest month. For example, if a transaction is 45 days past due, then Receivables calculates late charges based on 60 days.
Enter the number of days in the interest period. Receivables uses this number when calculating late charges.
Typical values are either 30 or 365 (to represent either a monthly or an annual interest period), but you can enter any value.
Enter the number of receipt grace days after a transaction's due date before late charges will be calculated.
However, after the grace days expire, Receivables calculates the number of days overdue using the original due date.
Indicate if you want transactions that were assessed late charges to be put on hold from future late charge calculations:
Yes
After Receivables assesses late charges on a transaction, that transaction is exempt from future late charge calculations.
No
An overdue transaction will be subject to late charges as long as the transaction remains unpaid.
This option applies only when charges are calculated using the Overdue Transactions Only or Overdue Transactions and Late Payments calculation method.
Optionally enter a charge beginning date, which indicates when to start assessing late charges on customers assigned to this customer profile class.
Use the Use Multiple Interest Rates box to indicate which interest rates Receivables will use when calculating late charges for interest invoices. Use this check box if the late charge period spans multiple periods as defined in the charge schedule:
Select this box to calculate late charges by first multiplying the number of days each rate was effective by the effective interest rate, and then adding all results.
To use only the interest rate that was effective on the invoice due date, leave this box unchecked.
You define interest tiers and related charge schedules, so that Receivables can use different interest rates depending on how late an overdue transaction is. See: Step 3. Define Interest Tiers and Charge Schedules.
Define profile class amounts per currency.
Attention: If you do not assign an interest rate to a currency, Receivables does not calculate late charges for past due items in that currency. See: Currencies Without Rates.
On the Profile Class Amounts tab, use the Minimum Customer Balance and Minimum Invoice Balance fields to indicate whether late charges (not penalties) should be assessed against a customer account or invoice. Receivables assesses late charges if the minimum customer and invoice balances are exceeded.
Define these values as either an amount or percentage of the total overdue amount.
Use the Minimum Charge Per Invoice and Maximum Charge Per Invoice fields to establish limits on whether Receivables will record late charges for an invoice. Receivables assesses late charges provided that the total late charge amount falls within this range.
These values are per calculation period, and ignore any penalties that may already be levied on a customer.
Use the Interest Charge Type, Value, and Charge Schedule fields to indicate how Receivables calculates late charges on overdue transactions. For the charge type, select:
Fixed Amount
Receivables uses the value you specify in the Value field during late charge calculations. This amount does not change as the overdue transaction ages.
Fixed Rate
Receivables uses the interest rate you specify in the Value field during late charge calculations. This rate does not change as the overdue transaction ages.
Charge Schedule Per Invoice
Receivables uses a charge (amount or percentage) for each invoice based on the schedule you specify in the Charge Schedule field. The application applies the charge assigned to each tier to all the invoices in that tier to calculate the total charge amount. For example, if there are two invoices, INVOICE01 and INVOICE02, in a tier and the charge specified for the tier in the charge schedule is an amount of $10, then Receivables calculates the total charge amount as dollar 20.
Charge Schedule Per Tier
Receivables uses a fixed charge (amount) for all the invoices in a tier based on the schedule you specify in the Charge Schedule field. The fixed charge is prorated between the invoices based on the amount due.
Use the Penalty Charge Type, Value, and Charge Schedule fields to indicate how Receivables calculates penalties. Penalties are optional and are calculated separately from late charges. For the charge type, select:
Fixed Amount
Receivables applies the flat fee that you specify in the Value field, in addition to late charges.
Fixed Rate
Receivables calculates the penalty as a fixed percentage of late charges.
Charge Schedule Per Invoice
Receivables uses a penalty charge (amount or percentage) based on the schedule you specify in the Charge Schedule field.
Charge Schedule Per Tier
Receivables uses a fixed penalty charge (amount) for all the invoices in a tier based on the schedule you specify in the Charge Schedule field. The fixed charge is prorated between the invoices based on the amount due. For example, if there are two invoices INVOICE01 and INVOICE02 each with an amount due of $ 100 in a tier, and the fixed charge specified for the tier in the charge schedule is an amount of $10, then Receivables calculates the total charge amount as $10. The application then prorates the total charge between the two invoices as $5 each.
Use the Late Charges tab at the customer account or site levels to review late charge setup details defaulted from the customer profile class. You can change any setup option at either the account or site level.
See: Adding and Updating Account Late Charges and Adding and Updating Account Site Late Charges.
Optionally set the AR: Use Statement, Dunning, and Late Charges Site Profiles profile option to control which account site's late charge setup is used by the Generate Late Charges program. See: Adding and Updating Account Site Late Charges.
If you normally charge late charges for your customers' past due debit items, but you want to exclude a specific debit item from late charge calculations, select the Exempt from Late Charges box in the Transactions window for that item.
Or, exclude a whole class of transactions by selecting the Exclude from Late Charges Calculation box on the transaction type. See: Transaction Types.