Invoice - Finance Charges
Below are some examples of different types of Finance Charges. Whether you want to retroactively apply charges, initially set up new ones, or manually remove a finance charge that's already been applied.
CHAPTERS
Finance Charge Calculation Examples
Example 1: Finance charges set up at the beginning; no retroactive charges
Example 2: Finance charges set up at the beginning; retroactive charges apply
Example 3: Intermittent finance charges; retroactive charges apply
Example 4: Finance charges set up at the beginning; corrections made; no retroactive charges
Example 5: Finance charges set up at the beginning; corrections made; retroactive charges apply
Example 6: Finance charges with a gap; payment made; corrections made; retroactive charges apply
Manually Removing a Finance Charge from an Invoice
Finance Charge Calculation Examples
To help explain how finance charges are calculated by Avionté, several examples are provided below. These examples apply to version 13.2 and beyond.
Note: Finance charges will only show on the Statement Letter and AR Aging Report. Finance charges are NOT shown on an invoice.
Example 1: Finance charges set up at the beginning; no retroactive charges
Preconditions
Customer with invoices overdue.
Table 1. No Retroactive Charges
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $100.00 | 0 | 0 | 0 |
| 102 | 2/1/2013 | $100.00 | $110.00 | $50.00 | 0 | $10.00 | 0 |
| 103 | 3/1/2013 | $110.00 | $105.00 | $110.00 | 10% | $5.00 | 0 |
Setup
In Customer > Back Office Setup > Billing Setup, the options are set as follows:
- Include Finance Charges is checked.
- Finance charges are not assessed retroactively (answer No on prompt).
- Increase Balance Amount Due is checked.
- Invoice balance is not increased retroactively (answer No on prompt).
Results
The automatic overnight finance charge processing will run, with calculated results as follows. This calculates the charges for the previous day.
Table 2. Finance charges assessed
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type |
|---|---|---|---|---|---|---|
| 101 | 1 | 4/2/2013 | $100.00 | $2.00 | $102.00 | Regular |
| 102 | 1 | 4/2/2013 | $60.00 | $1.20 | $61.20 | Regular |
| 103 | 1 | 4/2/2013 | $105.00 | $2.10 | $106.10 | Regular |
Table 3. Invoice updates
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $102.00 | 0 | 0 | $2.00 |
| 102 | 2/1/2013 | $100.00 | $110.00 | $51.20 | 0 | $10.00 | $1.20 |
| 103 | 3/1/2013 | $110.00 | $105.00 | $112.10 | 10% | $5.00 | $2.10 |
Example 2: Finance charges set up at the beginning; retroactive charges apply
Preconditions
Customer with invoices overdue.
Table 4. Retroactive Charges
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $100.00 | 0 | 0 | 0 |
| 102 | 2/1/2013 | $100.00 | $110.00 | $50.00 | 0 | $10.00 | 0 |
| 103 | 3/1/2013 | $110.00 | $105.00 | $110.00 | 10% | $5.00 | 0 |
Setup
In Customer > Back Office Setup > Billing Setup, the options are set as follows:
- Include Finance Charges is checked.
- Finance charges are assessed retroactively (answer Yes on prompt).
- Increase Balance Amount Due is checked.
- Invoice balance is increased retroactively (answer Yes on prompt).
Results
The automatic overnight finance charge processing will run, with calculated results as follows. This calculates the charges for the previous day.
Table 5. Finance charges assessed
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type |
|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Retroactive |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Retroactive |
| 101 | 3 | 3/2/2013 | $104.40 | $2.08 | $106.12 | Retroactive |
| 102 | 1 | 2/2/2013 | $60.00 | $1.20 | $61.20 | Retroactive |
| 102 | 2 | 3/2/2013 | $61.20 | $1.22 | $62.42 | Retroactive |
| 103 | 1 | 3/2/2013 | $105.00 | $2.10 | $106.10 | Retroactive |
Table 6. Invoice updates
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $106.12 | 0 | 0 | $6.12 |
| 102 | 2/1/2013 | $100.00 | $110.00 | $52.42 | 0 | $10.00 | $2.42 |
| 103 | 3/1/2013 | $110.00 | $105.00 | $112.10 | 10% | $5.00 | $2.10 |
Example 3: Intermittent finance charges; retroactive charges apply
Preconditions
Customer with invoices overdue.
Table 7. Retroactive Charges Apply
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $100.00 | 0 | 0 | 0 |
| 102 | 2/1/2013 | $100.00 | $110.00 | $50.00 | 0 | $10.00 | 0 |
| 103 | 3/1/2013 | $110.00 | $105.00 | $110.00 | 10% | $5.00 | 0 |
Setup
Table 8. Finance charges assessed
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type |
|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Regular |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Regular |
| 101 | 3 | 3/2/2013 | $104.40 | $2.08 | $106.12 | Regular |
| 102 | 1 | 2/2/2013 | $60.00 | $1.20 | $61.20 | Regular |
| 102 | 2 | 3/2/2013 | $61.20 | $1.22 | $62.42 | Regular |
| 103 | 1 | 3/2/2013 | $105.00 | $2.10 | $106.10 | Regular |
Results
Table 9. Finance charges assessed
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type |
|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Regular |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Regular |
| 101 | 3 | 3/2/2013 | $104.40 | $2.08 | $106.12 | Regular |
| 101 | 4 | 4/2/2013 | $106.12 | $2.12 | $108.24 | Retroactive |
| 101 | 5 | 5/2/2013 | $108.24 | $2.16 | $110.40 | Retroactive |
| 101 | 6 | 6/2/2013 | $110.40 | $2.20 | $112.60 | Retroactive |
| 101 | 7 | 7/2/2013 | $112.60 | $2.25 | $114.85 | Retroactive |
| 102 | 1 | 2/2/2013 | $60.00 | $1.20 | $61.20 | Regular |
| 102 | 2 | 3/2/2013 | $61.20 | $1.22 | $62.42 | Regular |
| 102 | 3 | 4/2/2013 | $62.42 | $1.24 | $63.66 | Retroactive |
| 102 | 4 | 5/2/2013 | $63.66 | $1.27 | $64.93 | Retroactive |
| 102 | 5 | 6/2/2013 | $64.93 | $1.30 | $66.23 | Retroactive |
| 102 | 6 | 7/2/2013 | $66.23 | $1.32 | $67.55 | Retroactive |
| 103 | 1 | 3/2/2013 | $105.00 | $2.10 | $106.10 | Regular |
| 103 | 2 | 4/2/2013 | $106.10 | $2.12 | $108.22 | Retroactive |
| 103 | 3 | 5/2/2013 | $108.22 | $2.16 | $110.38 | Retroactive |
| 103 | 4 | 6/2/2013 | $110.38 | $2.20 | $112.58 | Retroactive |
| 103 | 5 | 7/2/2013 | $112.58 | $2.25 | $114.83 | Retroactive |
Table 10. Invoices updated as follows
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $114.85 | 0 | 0 | $14.85 |
| 102 | 2/1/2013 | $100.00 | $110.00 | $56.23 | 0 | $10.00 | $6.23 |
| 103 | 3/1/2013 | $110.00 | $105.00 | $119.83 | 10% | $5.00 | $9.83 |
Example 4: Finance charges set up at the beginning; corrections made; no retroactive charges
Preconditions
Customer with invoices overdue.
Table 11. No Retroactive Charges
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $90.00 | 0 | 0 | 0 |
| 101-R1 | 1/1/2013 | $60.00 | $60.00 | $60.00 | 0 | 0 | 0 |
| 101-R2 | 1/1/2013 | - $10.00 | - $10.00 | $0.00 | 0 | 0 | 0 |
Table 12. Finance charges
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type | Finance charge removed? |
|---|---|---|---|---|---|---|---|
| 101 | 1 | 4/2/2013 | $100.00 | $2.00 | $102.00 | Regular | No |
Results
The automatic finance charge processing runs overnight, then the finance charges are assessed as displayed in the table below for the first invoice correction.
Table 13. Finance charges assessed after first invoice correction
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type | Finance charge removed? |
|---|---|---|---|---|---|---|---|
| 101 | 1 | 4/2/2013 | $100.00 | $2.00 | $102.00 | Regular | Yes |
| 101 | 1 | 4/2/2013 | $100.00 | - $2.00 | Removal | No | |
| 101 | 1 | 4/2/2013 | $160.00 | $3.20 | $163.00 | Correction | No |
Note: The finance charges are then assessed as follows after the second invoice correction.
Table 14. Finance charges assessed after second invoice correction
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type | Finance charge removed? |
|---|---|---|---|---|---|---|---|
| 101 | 1 | 4/2/2013 | $100.00 | $2.00 | $102.00 | Regular | Yes |
| 101 | 1 | 4/2/2013 | $100.00 | - $2.00 | Removal | No | |
| 101 | 1 | 4/2/2013 | $160.00 | $3.20 | $163.00 | Correction | Yes |
| 101 | 1 | 4/2/2013 | $160.00 | - $3.20 | $163.00 | Removal | No |
| 101 | 1 | 4/2/2013 | $150.00 | $3.00 | $153.00 | Correction | No |
Table 15. Invoices updated as follows
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $93.00 | 0 | 0 | $3.00 |
| 101-R1 | 1/1/2013 | $60.00 | $60.00 | $60.00 | 0 | 0 | 0 |
| 101-R2 | 1/1/2013 | - $10.00 | - $10.00 | $0.00 | 0 | 0 | 0 |
Example 5: Finance charges set up at the beginning; corrections made; retroactive charges apply
Preconditions
Customer with invoices overdue.
Table 16. Retroactive Charges Apply
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $96.12 | 0 | 0 | $6.12 |
| 101-R1 | 1/1/2013 | $60.00 | $60.00 | $60.00 | 0 | 0 | 0 |
| 101-R2 | 1/1/2013 | - $10.00 | - $10.00 | $0.00 | 0 | 0 | 0 |
Table 17. Finance charges
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type |
|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Retroactive |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Retroactive |
| 101 | 3 | 3/2/2013 | $104.04 | $2.08 | $106.12 | Retroactive |
Results
Table 18. Finance charges assessed after first invoice correction
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type | Finance charge removed? |
|---|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Retroactive | Yes |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Retroactive | Yes |
| 101 | 3 | 3/2/2013 | $104.40 | $2.08 | $106.12 | Retroactive | Yes |
| 101 | 1 | 1/2/2013 | $100.00 | - $2.00 | $102.00 | Removal | No |
| 101 | 2 | 2/2/2013 | $102.00 | - $2.04 | $104.04 | Removal | No |
| 101 | 3 | 3/2/2013 | $104.04 | - $2.08 | $106.12 | Removal | No |
| 101 | 1 | 1/2/2013 | $160.00 | $3.20 | $163.20 | Correction | No |
| 101 | 2 | 2/2/2013 | $163.20 | $3.26 | $166.46 | Correction | No |
| 101 | 3 | 3/2/2013 | $166.46 | $3.33 | $169.79 | Correction | No |
Table 19. Finance charges assessed after the second invoice correction
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type | Finance charge removed? |
|---|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Retroactive | Yes |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Retroactive | Yes |
| 101 | 3 | 3/2/2013 | $104.04 | $2.08 | $106.12 | Retroactive | Yes |
| 101 | 1 | 1/2/2013 | $100.00 | - $2.00 | $102.00 | Removal | No |
| 101 | 2 | 2/2/2013 | $102.00 | - $2.04 | $104.04 | Removal | No |
| 101 | 3 | 3/2/2013 | $104.04 | - $2.08 | $106.12 | Removal | No |
| 101 | 1 | 1/2/2013 | $160.00 | $3.20 | $163.20 | Correction | Yes |
| 101 | 2 | 2/2/2013 | $163.20 | $3.26 | $166.46 | Correction | Yes |
| 101 | 3 | 3/2/2013 | $166.46 | $3.33 | $169.79 | Correction | Yes |
| 101 | 1 | 1/2/2013 | $160.00 | - $3.20 | $163.20 | Removal | No |
| 101 | 2 | 2/2/2013 | $163.20 | - $3.26 | $166.46 | Removal | No |
| 101 | 3 | 3/2/2013 | $166.46 | - $3.33 | $169.79 | Removal | No |
| 101 | 1 | 1/2/2013 | $150.00 | $3.00 | $153.00 | Correction | No |
| 101 | 2 | 2/2/2013 | $153.00 | $3.06 | $156.06 | Correction | No |
| 101 | 3 | 3/2/2013 | $156.06 | $3.12 | $159.18 | Correction | No |
Table 20. Invoices updated as follows
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $99.18 | 0 | 0 | $9.18 |
| 101-R1 | 1/1/2013 | $60.00 | $60.00 | $60.00 | 0 | 0 | 0 |
| 101-R2 | 1/1/2013 | - $10.00 | - $10.00 | $0.00 | 0 | 0 | 0 |
Example 6: Finance charges with a gap; payment made; corrections made; retroactive charges apply
Preconditions
Customer with an overdue invoice, with a payment made of $50.00.
Table 21. Invoices updated as follows
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $96.12 | 0 | 0 | $6.12 |
| 101-R1 | 1/1/2013 | $25.00 | $25.00 | $25.00 | 0 | 0 | 0 |
Table 22. Finance charges
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type |
|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Regular |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Regular |
| 101 | 3 | 3/2/2013 | $104.04 | $2.08 | $106.12 | Regular |
| 101 | 4 | 5/2/2013 | $56.12 | $1.12 | $57.24 | Regular |
| 101 | 5 | 6/2/2013 | $57.24 | $1.14 | $58.38 | Regular |
Results
Table 23. Finance charges assessed after the second invoice correction
| Invoice number | Month ID | Finance charge date | Chargeable amount | Finance charge amount | Total chargeable amount due | Charge type | Finance charge removed? |
|---|---|---|---|---|---|---|---|
| 101 | 1 | 1/2/2013 | $100.00 | $2.00 | $102.00 | Regular | Yes |
| 101 | 2 | 2/2/2013 | $102.00 | $2.04 | $104.04 | Regular | Yes |
| 101 | 3 | 3/2/2013 | $104.04 | $2.08 | $106.12 | Regular | Yes |
| 101 | 4 | 5/2/2013 | $56.12 | $1.12 | $57.24 | Regular | Yes |
| 101 | 5 | 6/2/2013 | $57.24 | $1.14 | $58.38 | Regular | Yes |
| 101 | 6 | 7/2/2013 | $58.38 | $1.17 | $59.55 | Retroactive | Yes |
| 101 | 7 | 8/2/2013 | $59.55 | $1.19 | $60.74 | Retroactive | Yes |
| 101 | 1 | 1/2/2013 | $100.00 | - $2.00 | $102.00 | Removal | No |
| 101 | 2 | 2/2/2013 | $102.00 | - $2.04 | $104.04 | Removal | No |
| 101 | 3 | 3/2/2013 | $104.04 | - $2.08 | $106.12 | Removal | No |
| 101 | 4 | 5/2/2013 | $56.12 | - $1.12 | $57.24 | Removal | No |
| 101 | 5 | 6/2/2013 | $57.24 | - $1.14 | $58.38 | Removal | No |
| 101 | 6 | 7/2/2013 | $58.38 | - $1.17 | $59.55 | Removal | No |
| 101 | 7 | 8/2/2013 | $59.55 | - $1.19 | $60.74 | Removal | No |
| 101 | 1 | 1/2/2013 | $125.00 | $2.50 | $$127.50 | Correction | No |
| 101 | 2 | 2/2/2013 | $127.50 | $2.55 | $130.05 | Correction | No |
| 101 | 3 | 3/2/2013 | $130.05 | $2.60 | $132.65 | Correction | No |
| 101 | 4 | 5/2/2013 | $82.65 | $1.65 | $84.30 | Correction | No |
| 101 | 5 | 6/2/2013 | $84.30 | $1.68 | $85.98 | Correction | No |
| 101 | 6 | 7/2/2013 | $85.98 | $1.72 | $87.70 | Correction | No |
| 101 | 7 | 8/2/2013 | $87.70 | $1.75 | $89.45 | Correction | No |
Table 24. Invoices updated as follows
| Invoice number | Due date | Invoice amount | Bill amount | Balance amount | Sales tax | Discount amount | Total finance charges |
|---|---|---|---|---|---|---|---|
| 101 | 1/1/2013 | $100.00 | $100.00 | $64.45 | 0 | 0 | $14.45 |
| 101-R1 | 1/1/2013 | $25.00 | $25.00 | $25.00 | 0 | 0 | 0 |
Manually Removing a Finance Charge from an Invoice
Removing a finance charge from an invoice is a manual, user-initiated action, separate from the automatic calculation and recalculation behavior described in the examples above. Use it when a finance charge needs to be taken off a specific invoice rather than recalculated.
Enabling the Remove Permission
The AllowRemoveFinanceCharge config option controls whether a user has permission to manually remove a finance charge from an invoice. To enable it:
- Navigate to Admin Tools > System > Config Option > Config Option By FKName.
- Search for and select the property AllowRemoveFinanceCharge.
- Click the User radio button (Apply To), then find and select your username.
- Change the ConfigOptionValue to True, then press Tab a few times on your keyboard to save.
- Restart Back Office to apply the updated permission.
Note: If the permission doesn't appear to take effect after restarting Back Office, contact Avionté Support to confirm the setting has been applied.
Removing the Charge
- Go to the Invoice section of Back Office.
- Locate the invoice you want to remove the finance charge from.
- Open the invoice, go to Actions, and select Remove Finance Charge.
- The finance charge is removed and displayed balances update accordingly.
Comments
0 commentsPlease sign in to leave a comment.