Open calculator ↗

Invoice payment plan with late fees · Calculation guide

Each row is one installment period after the invoice due date.

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

InputValue
Original invoice balance500
Fixed fee per overdue installment period10

Planned installment payments

Planned payment
200
200
200
ResultValue
Remaining invoice balance0
Total fees charged30
Total payments applied530

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Original invoice balance500550Total payments applied530580
Fixed fee per overdue installment period1011Total fees charged3033
Planned payment (row 1)200100Remaining invoice balance030
Invoice payment plan with late fees →

Sources