Calculation guide
Charge one fixed fee on a positive opening balance, then apply the payment, capped at balance due. Exclude interest.
Closing balance = max(0, opening balance + applicable late fee − planned payment)
Inputs
Original invoice balance
Example entry 500 (in the selected currency).
Fixed fee per overdue installment period
Example entry 10 (in the selected currency).
Planned payment
Example entry 200 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Original invoice balance | 500 |
| Fixed fee per overdue installment period | 10 |
Planned installment payments
| Planned payment |
|---|
| 200 |
| 200 |
| 200 |
| Result | Value |
|---|---|
| Remaining invoice balance | 0 |
| Total fees charged | 30 |
| Total payments applied | 530 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Original invoice balance | 500 | 550 | Total payments applied | 530 | 580 |
| Fixed fee per overdue installment period | 10 | 11 | Total fees charged | 30 | 33 |
| Planned payment (row 1) | 200 | 100 | Remaining invoice balance | 0 | 30 |
