Days overdue and a simple late fee for unpaid invoices
Count days past due (zero if paid or not yet due) and work out a simple monthly late fee.
The problem
An invoice is late. You want the number of days, and a late fee you can put on the reminder.
Sample data
| Invoice (A) | Due (B) | Status (C) | Amount (D) | Rate per month (E) | Days (F) |
|---|---|---|---|---|---|
| INV-1 | 46300 | Unpaid | 200 | 1.5% | |
| INV-2 | 46010 | Unpaid | 300 | 1.5% | |
| INV-3 | 46000 | Paid | 100 | ||
| INV-4 | 46400 | Unpaid | 50 | ||
| INV-5 | (blank) | Unpaid |
Checker's today: 2026-10-21 (serial 46316).
Formulas
Days overdue, in F2, fill down:
=IF(OR(B2="",C2="Paid"),0,MAX(0,TODAY()-B2))
Result: 16, 306, 0, 0, 0.
Late fee, in G2, fill down. This charges the monthly rate for every started 30 days:
=ROUND(D2*E2*ROUNDUP(F2/30,0),2)
Result: 3.00 for INV-1, 49.50 for INV-2, 0 for the rest.
Notes
This is a tracking calculation. Check your contract or local rules before you charge a fee.
Excel vs Sheets
Same formulas in both. TODAY() recalculates each day, so the numbers move.
Want it done for you?
The Cellwise freelancer invoice and finance tracker template has days-overdue and fee columns built in. (Listing link will be added when the template is live.)
Tested on sample data by the Cellwise checker (log CW-PL-20261021-55). AI-made: the text, voice and visuals are generated by AI.
Checked before publishing: a check.