Home / Guides / Invoice late fees

Guide · Invoicing · Late fees

How to add late fees on Excel invoices

A late fee on a freelance Excel invoice is not a collections product. It is a clear due date, a grace rule, a fee formula you can toggle, and short wording the client sees before they pay — so overdue balances do not sit forever with no next step.

May earn commissions. SoloDesk may earn a commission if you buy through affiliate links on this page. Recommendations are based on what we think fits the use case. See our affiliate disclosure.

What belongs on every late-fee-ready invoice

• Invoice number + issue date + due date — not only “Net 15” buried in fine print
• Line items — quantities, rates, and a clear subtotal
• Tax (if any) + amount due — gray formulas; yellow only for inputs
• Payment terms — grace days (e.g. 5) and late fee (flat $ or % of unpaid balance)
• Optional “late fee applied” line — stays $0 until you flip apply-fee to yes (or past a trigger date)

Flat fee vs percent — pick one rule

	Flat late fee	% of unpaid balance
Example	$25 after grace	1.5% per month on unpaid balance
Best when	Small invoices; simple client conversations	Larger jobs where $25 is noise
Excel pattern	Yellow flat amount × apply yes/no	Yellow rate × unpaid balance × apply yes/no

Keep fee inputs yellow (rate or flat amount, grace days, “apply fee?”). Gray cells compute the fee so the PDF still looks clean when the fee is zero. Put the fee on its own line under the original amount due — do not silently inflate the project line.

Client-facing wording (keep short)

Example terms line: “Payment due by the date shown. After a 5-day grace period, a late fee of $25 (or 1.5% of the unpaid balance) may be added.” Match your contract. If the agreement is silent, update the agreement first — an invoice alone is a weak place to invent new penalties. This is template and bookkeeping guidance, not legal advice on what you may charge in your state.

Excel workflow that stays honest

1. Send with fee = 0 — terms visible; client knows the rule before anything is overdue.
2. On overdue + past grace — flip “apply fee?” (or enter applied date); gray fee line fills in; issue a revised invoice number or a short addendum invoice — do not silently edit the paid PDF history.
3. Log cash separately — amount billed vs amount received matters for quarterly estimates.
4. Same rule every client — mixing flat and % randomly looks arbitrary and invites pushback.

Common late-fee traps

• No due date on the PDF — only “please pay soon”
• Inventing a fee that the signed SOW never mentioned
• Hiding the fee inside a renamed line item instead of labeling “Late fee”
• Applying the fee before the grace period ends
• Chasing with chat while the workbook still shows $0 fee and no revised invoice

Free sample vs invoice kit

Yellowcell’s free invoice sample is enough to practice due dates, terms text, and an amount-due layout. Sole Ledger (the invoice kit) adds a repeating client workflow plus Schedule C–style expenses and a 2026 mileage sheet — useful when overdue invoices and write-offs live in the same file.

Related SoloDesk guides

• Client retainer invoices in Excel
• Name-your-price invoicing in Excel
• Freelance invoice tools compared
• Wave vs Excel invoice
• FreshBooks vs Excel invoice