Invoice Late Fee Calculator
Calculate invoice late fees from due dates, grace periods, rates, caps, credits, and rounding, with clause math and AR note output.{{ summaryTitle }}
| Step | Value | Copy |
|---|---|---|
| {{ row.label }} | {{ row.value }} |
| Milestone | Date | Fee days | Late fee | Total due | Copy |
|---|---|---|---|---|---|
| {{ row.milestone }} | {{ row.date }} | {{ row.feeDays }} | {{ row.fee }} | {{ row.total }} |
| Method | Assumption | Fee | Total due | Copy |
|---|---|---|---|---|
| {{ row.method }} | {{ row.assumption }} | {{ row.fee }} | {{ row.total }} |
{{ arNote }}
Invoice late fees turn an overdue payment into a stated charge, so the calculation needs to be both numerically clear and commercially defensible. The amount may appear on a reminder, statement, collection note, or accounts receivable record. A small change in the due date, grace period, balance, rate, cap, or rounding rule can change the number that is sent to the customer.
The due date only tells when the invoice first became late. The first chargeable day may come later when the terms include a grace period. Payments, credits, write-offs, or billing adjustments can reduce the balance exposed to the fee. Those facts matter before the rate is even considered because the same 5% clause produces different results on a 1,000 unpaid invoice and an 800 remaining balance.
| Clause shape | What drives the amount | Common caution |
|---|---|---|
| Fixed fee | Whether at least one fee day exists after the grace period. | A fixed charge can look large when the unpaid balance is small. |
| Percent of invoice | The balance subject to fee and the stated percentage. | The fee base should match the clause and accounting treatment for credits. |
| Per-day fee | Fee days multiplied by a daily amount. | One extra day changes the charge. |
| Monthly interest | Monthly rate and the way partial months are handled. | Prorated 30-day math and started 30-day blocks can diverge sharply. |
| Annual interest | Annual rate, fee days, and day-count basis. | A 360, 365, or 366 day basis changes a prorated result. |
Late fees are not just arithmetic. Commercial contracts, public-sector payment rules, consumer accounts, regulated finance products, and cross-border transactions may set different limits on when interest starts, what rate may be used, and whether a penalty is enforceable. A clause that is routine in one business relationship may need review in another.
A calculated fee is best treated as an audit trail for terms that have already been chosen, not as a decision that a fee is allowed. The useful record names the invoice amount, credits, due date, calculation date, grace period, method, rate, fee days, and any adjustment that changed the raw number. That record is easier to defend than a bare total.
How to Use This Tool:
Start with the invoice facts, then match the fee method to the exact wording in the invoice, contract, purchase order, or account terms.
- Enter Invoice amount, Due date, and Payment or calculation date. Use the payment date for a paid invoice, or the reminder date when the invoice is still open.
- Set Grace period in whole calendar days. If the invoice is past due but still inside that grace period, Fee days remains zero and no fee is applied.
- Choose Late fee method to match the clause: fixed fee, percent of invoice, per-day fee, monthly interest, or annual interest.
- Enter the Fee amount or rate. Annual interest also needs the Annual day-count basis, while monthly interest needs a choice between prorated 30-day math and charging each started 30-day block.
- Add a Fee cap when the terms limit the maximum charge. Open Advanced for payments or credits, a one-time flat add-on, a minimum fee, rounding mode, invoice label, and note recipient.
- Read any warning before using the amount. Warnings flag invalid entries, zero subject balance, grace-period absorption, ambiguous monthly-interest wording, add-ons, minimums, caps, and effective rates over 10%.
- Use Clause Math for the calculation audit, Aging Trail for date milestones, Method Check for comparing methods, Late Fee Timeline for fee growth, and AR Note for an accounts receivable draft.
Interpreting Results:
Rounded late fee is the final charge after the selected method, one-time add-on, minimum fee, cap, and rounding mode. Method fee is the raw method result before those later adjustments, so compare the two when a warning says a cap, minimum, or add-on changed the amount.
Fee days is the key date result. It equals calendar days past due minus the grace period, floored at zero. A technically overdue invoice can still have zero fee days when the grace period absorbs the lateness.
Effective fee rate divides the final late fee by the balance subject to fee. A rate above 10% triggers a warning because a flat charge, minimum fee, or started-month rule can produce a high percentage on a small or recently credited invoice.
- Total due adds the rounded late fee to the balance subject to fee. It does not include unrelated charges that were not entered.
- Method Check uses the same entered amount or rate across methods, so it is a reasonableness comparison, not permission to apply a different clause.
- AR Note is a draft summary. Review the date, method, fee days, warnings, and customer context before sending it.
Technical Details:
Late-fee math begins with a nonnegative subject balance and a nonnegative fee-day count. The subject balance is the invoice amount after entered payments or credits. Calendar days past due are counted from the due date to the payment or calculation date, and the grace period is subtracted afterward. Early, same-day, and grace-covered payments therefore produce zero fee days.
The raw method fee is only the middle of the calculation. Once the raw fee is known, a one-time add-on can be included when fee days are positive, a minimum can raise the amount, a cap can reduce it, and rounding is applied at the end. That order matters whenever a raw value sits just below a minimum, just above a cap, or between cents.
Formula Core:
B is the balance subject to fee and L is fee days. A cap value of zero means no cap. The final rounding mode can round to nearest cent, round up to cent, round down to cent, or round to the nearest whole currency unit.
| Method | Raw fee rule | Boundary behavior |
|---|---|---|
| Fixed fee | Entered amount once L > 0 | No fee is charged when fee days are zero. |
| Percent of invoice | B x rate / 100 | The percentage applies to the subject balance after entered credits. |
| Per-day fee | daily amount x L | Each additional fee day adds one daily amount. |
| Monthly interest | B x monthly rate / 100 x month units | Month units are either L / 30 or ceil(L / 30). |
| Annual interest | B x annual rate / 100 x L / basis | The basis is 365, 360, or 366 days. |
| Condition | How to read it |
|---|---|
| Subject balance is zero | Entered payments or credits cover the invoice amount, so the calculated fee should not be used without rechecking the balance. |
| Calendar days past due equals zero | The payment or calculation date is on or before the due date. |
| Fee days equals zero | The invoice is past due, but the grace period absorbs the lateness. |
| Minimum or cap applied | The final amount no longer equals the raw method fee. |
| Effective fee rate is greater than 10% | The charge may need contract, accounting, or legal review before it is sent. |
For a substitution check, take a 1,000 invoice with 200 in credits, an 18% annual rate, 35 calendar days past due, and a 5 day grace period. The subject balance is 800 and fee days equal 30. On a 365 day basis, the raw fee is 800 x 0.18 x 30 / 365, which rounds to 11.84 before any cap, minimum, or add-on changes it.
Responsible Use Note:
This is a finance and collections estimate. It applies the terms entered in the form and cannot decide whether a late fee is allowed, properly disclosed, reasonable, enforceable, or collectible.
- Check the signed agreement, invoice terms, purchase order, or customer account terms before sending a fee notice.
- Consumer accounts, regulated finance products, public-sector invoices, utilities, and cross-border commercial debts may follow special rules.
- Ask for accounting or legal review when a fee is large, disputed, outside normal business terms, or likely to affect a customer relationship.
- The calculation runs in your browser from the entered fields and does not require a server lookup.
Worked Examples:
Percentage fee after grace. A 1,000 invoice due 35 days ago with a 5 day grace period has 30 Fee days. With Late fee method set to Percent of invoice and Fee amount or rate set to 5%, Rounded late fee is 50.00 and Total due is 1,050.00 before any cap, minimum, or add-on changes it.
Annual interest on a credited balance. A 1,000 invoice with 200 in Payments or credits has an 800 Balance subject to fee. At 18% annual interest, 30 fee days, and a 365 day basis, Rounded late fee is 11.84. If a 10.00 Fee cap is entered, the cap warning appears and the final fee becomes 10.00.
Monthly wording at a 30-day boundary. On a 1,000 balance at 1.5% monthly, 31 fee days produces 15.50 with prorated 30-day math. The same inputs produce 30.00 with started-month treatment because 31 fee days starts a second 30-day block.
Troubleshooting a zero fee. If Calendar days past due is 4 and Grace period is 5, Fee days is 0 and Rounded late fee stays 0. Shorten the grace period only when the invoice terms actually start fees earlier.
FAQ:
Does the calculator decide whether I can charge the fee?
No. It applies the entered invoice terms. It does not decide enforceability, disclosure, customer-specific restrictions, or whether the charge is reasonable.
Why is the fee zero when the invoice is overdue?
Check Fee days. If the overdue days are still inside the entered Grace period, the calculated fee remains zero.
Should payments and credits reduce the fee base?
For balance-based methods, the calculator uses Balance subject to fee, which equals Invoice amount minus Payments or credits. Use that field only when the terms and accounting treatment support reducing the base first.
Why does monthly interest have two treatments?
Some clauses expect a prorated 30-day month, while others charge each started 30-day block. The difference is most visible just after 30, 60, or 90 fee days.
What should I check before using the AR note?
Confirm the Due date, Grace period, Late fee method, Rounded late fee, and any warning about caps, minimums, add-ons, or high effective rate.
Glossary:
- Subject balance
- The invoice amount remaining after entered payments or credits.
- Grace period
- Calendar days after the due date before fee days start.
- Fee days
- Calendar days past due minus the grace period, floored at zero.
- Method fee
- The raw fee produced by the selected clause method before add-ons, minimums, caps, and rounding.
- Effective fee rate
- The final late fee divided by the subject balance.
- Day-count basis
- The denominator used to prorate annual interest, such as 365, 360, or 366.
References:
- U.C.C. Section 2-718, Liquidation or Limitation of Damages; Deposits, Legal Information Institute.
- Prompt Payment, Bureau of the Fiscal Service.
- Late commercial payments: charging interest and debt recovery, GOV.UK.
- B2B late payments: interest, penalties and compensation, Your Europe.
- Credit card penalty fees, Consumer Financial Protection Bureau.