Collect Outstanding Balances

Collect Outstanding Balances

Managing receivables includes checking whether amounts due are paid on time. If customers have overdue payments, you can begin by sending the Customer Statement report as a reminder. Alternatively, you can issue reminders.

You can use reminders to remind customers about overdue amounts. You can also use reminders to calculate finance charges, such as interest or fees and include them on the reminder. Use finance charge memos if you want to debit customers for interest or fees without reminding them of overdue amounts.

Statements

From the customer card, you can create a statement with that customer's transactions with you. Then, you send the customer the generated PDF file. Alternatively, use the Customer Statement report to send your customers an overview of their business with you. The customer statement can be sent to Excel for further processing.


To send the Customer Statement report

  1. Choose the Lightbulb that opens the Tell Me feature 10. icon, enter Customer Statement, and then choose the related link.
  2. Fill in the fields as necessary. Hover over a field to read a short description.
  3. Under Output Options, select how to send the report to the customer.

 Note

If you are using multiple currencies, the Customer Statement report is always printed in the customer's currency. The last date in a statement period is also used as the statement date and the aging date, if aging is included.

Reminders

You can use reminders to remind customers about overdue amounts. You can also use reminders to calculate finance charges such as interest or fees and include them on the reminder.

Before you can create reminders, you must set up reminder terms and assign them to your customers. For more information, see Set Up Reminder Terms and Levels. You can set up an unlimited number of reminder terms. Each set of terms is identified by a code. Each reminder term has predefined reminder levels. Each reminder level includes rules about when the reminder will be issued, for example, how many days after the invoice due date or the date of the previous reminder. The contents of the Finance Charge Terms page determines whether interest is calculated on the reminder.

You can periodically run the Create Reminders batch job to create reminders for all customers with overdue balances, or you can manually create a reminder for a specific customer and have the lines calculated and filled in automatically.

After you create the reminders, you can modify them. The text that appears at the beginning and end of a reminder is determined by the reminder level terms, and can be seen in the Description column. If a calculated amount has been inserted automatically in the beginning or ending text, the text will not be adjusted if you delete lines. Then you must use the Update Reminder Text function.

A customer ledger entry with the On Hold field filled in will not prompt the creation of a reminder. However, if a reminder is created on the basis of another entry, an overdue entry marked on hold will also be included on the reminder. Interest is not calculated on lines with these entries.

After you have created reminders and made any needed modifications, you can either print test reports or issue the reminders, typically as email.

To create a reminder automatically

A reminder is similar to an invoice. When you create a reminder, a reminder header as well as one or more reminder lines must be filled in. You can use a function to create reminders for all customers automatically.

  1. Choose the Lightbulb that opens the Tell Me feature 0. icon, enter Reminders, and then choose the related link.
  2. On the Reminder page, choose the Create Reminders action.
  3. On the Create Reminders page, fill in the fields to define how and to whom the reminders are created.
  4. Choose the OK button.

To create a reminder manually

On the Reminder page, you can fill in the General FastTab manually and then have the lines filled in automatically.

  1. Choose the Lightbulb that opens the Tell Me feature again 2. icon, enter Reminders, and then choose the related link.

  2. Choose the New action.

  3. On the General FastTab, fill in the fields as necessary.

  4. Choose the Suggest Reminder Lines action.

  5. In the Suggest Reminder Lines batch job, fill in the fields to define how and to whom the reminders are created.

  6. Select the Include Entries On Hold check box if you want the reminders to contain overdue open entries that are on hold.

  7. Select the Only Entries with Overdue Amounts check box if you want the reminders to contain only overdue open entries. Only invoices and payments will be shown as these are the entries for which your customers' payments may be overdue.

     Important

    Open entries that are on hold will be inserted, irrespective of the setting in the Only Entries with Overdue Amounts check box.

  8. Choose the OK button.

To replace reminder texts

There are several ways you can determine the text that appears on the printed reminder. In some cases, you may want to replace the beginning and ending texts that have been defined for the current level with those from a different level.

  1. Choose the Lightbulb that opens the Tell Me feature yet again 3. icon, enter Reminders, and then choose the related link.
  2. Open the relevant reminder, and then choose the Update Reminder Text action.
  3. On the Update Reminder Text page, enter the required level in the Reminder Level field.
  4. Choose the OK button to update the beginning and ending texts.

To issue a reminder

After you have created reminders and made any needed modifications, you can either print test reports or issue the reminders.

When you issue a reminder, the data is transferred to a separate page for issued reminders. At the same time, reminder entries are posted. If interest or an additional fee has been calculated, entries are posted to the customer ledger and the general ledger.

When a reminder is issued, the entries are posted according to your specifications on the Reminder Terms page. This specification determines whether interest and/or additional fees are posted to the customer's account and the general ledger. Setup on the Customer Posting Groups page determines which accounts are posted to.

For each customer ledger entry on the finance charge memo, an entry is created on the Reminder/Fin. Charge Entries page.

If the Post Interest or the Post Additional Fee check boxes are selected on the Reminder Terms page, then the following entries are also created:

  • One entry on the Customer Ledger Entries page
  • One receivables entry in the relevant G/L account
  • One interest and/or one additional fee entry in the relevant G/L account

In addition, issuing the reminder may result in VAT entries.

  1. Choose the Lightbulb that opens the Tell Me feature also here 4. icon, enter Reminders, and then choose the related link.
  2. Select the relevant reminder, and then choose the Issue action.
  3. On the Issue Reminders page, fill in the fields as necessary.
  4. Choose the OK button

The reminder is either printed for sent to an specified email as a PDF attachment.

To cancel an issued reminder

If reminders were issued in error, you can cancel them before they are sent out. You can do this either one by one or as a batch.

  1. On the Issued Reminders page, select one or more lines for issued reminders that you want to cancel, and then choose the Cancel action.
  2. On the Cancel Issued Reminders page, fill in the fields as necessary, and then choose the OK button.

Finance Charges

When a customer does not pay by the due date, you can have finance charges calculated automatically and add them to the overdue amounts on the customer's account. You can inform customers of the added charges by sending finance charge memos.

 Note

You use finance charge memos to calculate interest and finance charges and to inform your customers about interest and finance charges without reminding them of overdue payments. Alternatively, you can calculate interest on overdue payments when you create reminders.

Before you can create finance charge memos, you must set up terms. For more information, see Set Up Finance Charge Terms.

You can manually create a finance charge memo for an individual customer, and fill in the lines automatically. Alternatively, you can use the Create Finance Charge Memos function job to create finance charge memos for all or selected customers with overdue balances.

After you create the finance charge memos, you can modify them. The text that appears at the beginning and end of the finance charge memo is determined by the finance charge terms, and can be seen in the Description column on the lines. If a calculated amount has been inserted automatically in the beginning or ending text, the text will not be adjusted if you delete lines. Then you must use the Update Finance Charge Text function.

After you have created finance charge memos and made any needed modifications, you can either print test reports or issue the finance charge memos, typically as email.

To create a finance charge memo manually

A finance charge memo is similar to an invoice. You can fill in a header manually and have the lines filled in for you, or you can create finance charge memos for all customers automatically.

  1. Choose the Lightbulb that opens the Tell Me feature 2. icon, enter Finance Charge Memos, and then choose the related link.

  2. Choose the New action, and then fill in the fields as necessary.

  3. Choose Suggest Fin. Charge Memo Lines action.

  4. On the Suggest Finance Charge Memo Lines page, set a filter on the Cust. Ledger Entry FastTab if you want to create finance charge memos only for specific entries.

     Note

    Although they are listed, selecting Payment and Credit Memo as Document Type filters will not have any effect because the Suggest Finance Charge Memo Lines function only handles positive amounts.

  5. Choose the OK button to start the batch job.

To update finance charge memo texts

In some cases, you may want to modify the beginning and ending text that you have set up for the finance charge terms. If you do this at a time when you have created, but not yet issued, finance charge memos, you can update the memos with the modified text.

  1. Choose the Lightbulb that opens the Tell Me feature 3. icon, enter Finance Charge Memo, and then choose the related link.
  2. open the finance charge memo that you want to change text for, and then choose the Update Finance Charge Text action.
  3. On the Update Finance Charge Text page, you can set a filter if you want to update several memos.
  4. Choose the OK button to update the beginning and ending texts.

To issue finance charge memos

After you have created finance charge memos and made any needed modifications, you can either print test reports or issue the finance charge memos.

When a reminder is issued, the entries are posted according to your specifications on the Finance Charge Terms page. This specification determines whether interest and/or additional fees are posted to the customer's account and the general ledger. Setup on the Customer Posting Groups page determines which accounts are posted to.

For each customer ledger entry on the finance charge memo, an entry is created on the Reminder/Fin. Charge Entries page.

If the Post Interest or the Post Additional Fee check boxes are selected on the Finance Charge Terms page, then the following entries are also created:

  • One entry on the Cust. Ledger Entries page
  • One receivables entry in the relevant G/L account
  • One interest and/or one additional fee entry in the relevant G/L account

In addition, issuing the finance charge memo may result in VAT entries.

  1. Choose the Lightbulb that opens the Tell Me feature 4. icon, enter Finance Charge Memos, and then choose the related link.
  2. Select the relevant memo, and then choose the Issue action.
  3. On the Issue Finance Charge Memos page, fill in the fields as necessary.
  4. Choose the OK button

The finance charge memo is either printed for sent to an specified email as a PDF attachment.

To cancel an issued finance charge memo

If finance charge memos were issued in error, you can cancel them before they are sent out. You can do this either one by one or as a batch.

  1. On the Issued Finance Charge Memos page, select one or more lines for issued finance charge memos that you want to cancel, and then choose the Cancel action.
  2. On the Cancel Issued Fin. Charge Memos page, fill in the fields as necessary, and then choose the OK button.

To view reminder and finance charge entries

When you issue a reminder, a reminder entry is created on the Reminder/Fin. Charge Entries page for each reminder line that contains a customer ledger entry. You can then get an overview of the created reminder entries for a specific customer.

  1. Choose the Lightbulb that opens the Tell Me feature 5. icon, enter Customers, and then choose the related link.
  2. Open the relevant customer card, and then choose the Ledger Entries action.
  3. On the Customer Ledger Entries page, select the line with the ledger entry you want to see the reminder entries for, and then choose the Reminder/Fin. Charge Entries action.

Multiple Interest rates

For each finance charge term code, you can specify multiple interest rates so that you can calculate finance charges with multiple interest rates for a specific period. This is helpful if you charge different interest on payments that are late. The interest calculation is the same for each financial charge, with variation only in the rate of interest for a specific period. If multiple interest rates are not set up, then the interest rate and period that is defined in the Finance Charge Terms and Reminder Terms pages for the whole period of calculation will be used. For more information, see Set Up Multiple Interest Rates.

See Also

Set Up Reminder Terms and Levels
Set Up Finance Charge Terms
Managing Receivables
Sales


    • Related Articles

    • Managing Receivables

      In this article See Also Start a free trial! A regular step in any financial rhythm is to reconcile bank accounts, which requires that you apply incoming payments to customer or vendor ledger entries to close sales invoices and purchase credit memos ...
    • Send Reminders of Outstanding Balances

      You can use reminders to remind customers about overdue amounts. You can also use reminders to calculate finance charges such as interest or fees and include them on the reminder. Before you can create reminders, you must set up reminder terms and ...
    • Reconcile Customer Payments with the Cash Receipt Journal or from Customer Ledger Entries

      In this article To fill and post a cash receipt journal To apply a payment to a single customer ledger entry To apply a payment to multiple customer ledger entries To apply a credit memo to a single customer ledger entryShow 5 more When you receive a ...
    • Block Customers

      In this article To block a customer See Also You can block a customer, for example because of insolvency, so that the customer cannot be added to sales documents or so that no transactions can be posted for the customer. In addition to blocking a ...
    • Reconcile Customer Payments from a List of Unpaid Sales Documents

      In this article To set up the payment registration journal To register customer payments individually To reconcile lump-sum payments To process customer payments with discounts manuallyShow 3 more After customers make electronic payments to your bank ...