Freelance Late Payment Calculator

Calculator Inputs

Invoice Number

Client Name

Project Name

Currency

Invoice Amount

Retainer Paid

Credit / Waiver Amount

Subtracts a fixed credit from the penalty amount.

Annual Interest Rate (%)

Interest Method

Day-Count Basis

Flat Late Fee

Daily Admin Fee

Penalty Cap (%)

Set 0 for no penalty cap.

Tax on Penalty (%)

Grace Days

Issue Date

Due Date

Payment / Evaluation Date

Notes

Example Data Table

Invoice	Client	Outstanding	Due Date	Evaluation Date	Chargeable Days	Interest Method	Total Due
INV-1001	Acme Creative Studio	$2,000.00	2026-02-18	2026-03-20	25	Simple interest	$2,112.44
INV-2044	Northwind Labs	$3,400.00	2026-01-30	2026-03-20	45	Daily compounding	$3,715.96
INV-3108	Blue Harbor Media	$1,250.00	2026-03-01	2026-03-20	14	Monthly compounding	$1,321.87

Formula Used

1) Outstanding principal
Outstanding = Invoice Amount − Retainer Paid

2) Raw late days
Raw Late Days = max(0, Payment Date − Due Date)

3) Chargeable days
Chargeable Days = max(0, Raw Late Days − Grace Days)

4) Interest charge
Simple: Interest = Outstanding × (Annual Rate / Day Basis) × Chargeable Days
Daily: Interest = Outstanding × ((1 + Annual Rate / Day Basis) ^ Days − 1)
Monthly: Interest = Outstanding × ((1 + Annual Rate / 12) ^ (Days / 30) − 1)

5) Gross penalty
Gross Penalty = Interest + Flat Late Fee + (Daily Admin Fee × Chargeable Days)

6) Net penalty before cap
Net Penalty Before Cap = max(0, Gross Penalty − Credit / Waiver)

7) Capped penalty
Cap Amount = Outstanding × Penalty Cap %
Capped Penalty = min(Net Penalty Before Cap, Cap Amount)

8) Grand total due
Penalty Tax = Capped Penalty × Tax Rate
Grand Total Due = Outstanding + Capped Penalty + Penalty Tax

How to Use This Calculator

Enter invoice details, including invoice number, client, and project name.
Set the currency and original invoice amount.
Subtract any retainer already received from the client.
Add a credit or waiver if you plan to reduce charges.
Choose the annual rate, compounding rule, and day-count basis.
Enter any flat late fee, daily admin fee, and penalty tax.
Set a grace period and optional penalty cap percentage.
Provide issue date, due date, and payment or evaluation date.
Click Calculate Late Payment to show the result above the form.
Use the CSV and PDF buttons to keep records or share the calculation.

Frequently Asked Questions

1) When does an invoice count as late?

An invoice becomes late after the due date passes and the grace period ends. Only then do chargeable late days begin in this calculator.

2) Can I use this for unpaid invoices?

Yes. Enter today or any review date as the payment or evaluation date. The calculator will estimate what the outstanding invoice costs by that date.

3) What is the difference between simple and compounding interest?

Simple interest grows linearly from the outstanding balance. Daily and monthly compounding add previously accrued interest back into the base before calculating later charges.

4) Why would I add a penalty cap?

A cap limits the maximum penalty relative to the outstanding amount. It helps mirror contracts that restrict late charges beyond a certain percentage.

5) Should retainers reduce late-payment interest?

Usually yes, because the retainer already paid lowers the outstanding principal. This calculator charges interest and fees only on the remaining unpaid balance.

6) What does the credit or waiver field do?

It subtracts a fixed amount from the penalty before the cap applies. It cannot make the penalty negative, so the result bottoms out at zero.

7) Is this calculator legal advice?

No. It is a planning and documentation tool. Contract terms, local rules, and enforceability vary, so confirm details with your agreement or adviser.

8) Why export the result to CSV or PDF?

Exports help with bookkeeping, client follow-up, dispute evidence, and collection notes. They also make it easier to compare scenarios without recalculating manually.