How to: Invoice customers for outstanding interest charges.

Environment: Comsense Enterprise

In this article:

*Note: Before proceeding with this article, you must complete Administrative Set-Up for Interest Invoices.

Accessing Customer Interest

Enterprise > Receivables/Invoicing > Customer Interest

Understanding the Customer Interest Wizard

The Customer Interest Wizard creates all the transactions and journal entries required to create an invoice. In the Customer Interest Wizard, you select the options for generating the invoices, the invoicing division(s), and the customers. Below are the options fields for generating interest invoices.

*Note: If a division must process their own transactions, invoice that division individually.

Completing the Customer Interest Wizard

In the Customer Interest window:

1. Click Next

On the Options & Division page:

2. Complete the top pane using Table 1

3. Select & Remove any divisions to exclude from the interest invoices

4. Click Next

On the Options page all customers with interest rates from the selected division are in the Assigned Customer pane.

5. Select & Remove any customers you do not want to include in invoiving

6. Click Next
7. Click Finish

You now have a list of customers that owe interest.

Creating the Interest Invoices

The Customer Interest window shows you a list of customers that owe interest according to past due invoices and terms set in the Customer window. The Suggested Interest column uses Per Diem Interest Formula.

The Interest column is the interest showing on the invoice. You can update this field.

In the Customer Interest window:

1. Update the Interest column as needed

2. Update Invoice Date, Journal Date, Note, or Internal Note fields if required

If you do not want to create an invoice for a customer:

3. Uncheck the Selected checkbox

4. Click Save & Close
   • The Process Customer Interest - Work Flow window will open with all completed transactions required for an invoice

You now have interest invoices for the customers.

Viewing & Exporting the Interest Invoice Report

In the Process Customer Interest - Work Flow window:

1. Click a Complete Invoice

In the Read-Only Invoice window:

2. Click Print
3. Select the export method

You now have the interest invoice report.

Per Diem Interest Formula

Comsense calculates the values for the formula using the customer's interest options, terms, and the past due invoice. The interest formula is per diem interest.

Values

A = Total interest owing

P = Initial balance subject to interest

r = Annual interest rate

d = Time (in days) past the grace period

Formula

A = d x r x P / 365

Example

A = 45 days x .18 x 3000 / 365 = 66.57

A = 66.57

The interest owing is $66.57.