Freelancers

Invoice and Late Payment Tracker

See which invoices were late, what the delay cost in financing and in your own chasing time, and which clients the cost comes from.

Delivery: Instant download
Purchase: One-time payment
Format: Google Sheets
Excel
Updated: August 2026

$5.90

What this spreadsheet does

Late payment feels annoying rather than expensive because the chasing time is never counted. On the sample data it is 85% of the total cost.

What you can do with it

See what a habitually late client costs you across a year
Decide whether to ask for deposits or shorten terms
Know how much of your admin time goes to chasing money

What's included

Sheet tabs

Instructions
Invoices
Client Summary

Features

Due date calculated from issue date and terms
Days late that never go negative, so paying early is not counted as a credit
Financing cost of the delay at a rate you set
Chasing hours costed at your own hourly rate, which is the larger half
Unpaid invoices shown as outstanding rather than as zero days late
Per-client summary naming which client the cost actually comes from

How it works

1Enter each invoice with the date issued and your terms in days
2Enter the date paid when it arrives, and leave it blank while outstanding
3Enter the hours you spent chasing, which is the number people leave at zero

Who it's for

Freelancers and small suppliers invoicing on terms.

Sample invoices are illustrative. The financing rate should be your own cost of carrying the delay.

Frequently asked questions

Is the financing rate a late payment interest charge?

No. It is what carrying the delay costs you, so use your own borrowing cost or what the money would have earned. Statutory late payment interest is separate and set by your contract and local law.

Why count chasing hours?

Because they are the larger cost. On the sample data financing is $185 across a year and chasing is $1,067, and only one of those ever gets noticed.

What do I do with the client summary?

Usually one client is most of the problem. Once you can see that, the decision is a deposit, shorter terms, or a price that reflects the delay, rather than a general resolution to chase harder.