Free Excel template · Excel for freelancers

Free freelance invoice tracker template

Q: Can I make the as-of date update itself?

Yes. Type =TODAY() in L1 and the statuses and days overdue update each time the file recalculates. Keep a typed date if you want a fixed snapshot, such as month-end.

For freelancers and consultants who need to know, at a glance, who owes what and for how long. Log each invoice with its date, amount and terms. The tracker works out the due date, marks it Paid, Open or Overdue, counts the days late, groups what is outstanding by age, and names the invoice to chase first.

cellwise-freelance-invoice-tracker.xlsxExcel workbook · 4.9 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I	K	L
1	Invoice #	Client	Invoice date	Amount	Terms (days)	Due date	Paid date	Status	Days overdue	As of date	Nov 1, 2026
2	INV-2041	Alder Coffee	Aug 28, 2026	585	30	46292		Overdue	35
3	INV-2042	Fernway Trust	Sep 5, 2026	3600	30	46300		Overdue	27	Outstanding (not paid)	9795
4	INV-2043	Alder Coffee	Sep 12, 2026	3200	14	46291	Sep 30, 2026	Paid	0	Not yet due	5610
5	INV-2044	Brightline Dental	Sep 20, 2026	1572.5	30	46315	Oct 14, 2026	Paid	0	1-30 days overdue	3600
6	INV-2045	Kestrel Labs	Oct 1, 2026	1800	7	46303	Oct 9, 2026	Paid	0	31-60 days overdue	585
7	INV-2046	Northpine Outdoor	Oct 3, 2026	2790	30	46328		Open	0	Over 60 days overdue	0
8	INV-2047	Tallow and Co	Oct 10, 2026	2400	14	46319	Oct 28, 2026	Paid	0
9	INV-2048	Brightline Dental	Oct 17, 2026	1020	30	46342		Open	0	Paid so far	8972.5
10	INV-2049	Kestrel Labs	Nov 1, 2026	1800	7	46334		Open	0	Average days to get paid	17
11									0	Chase first	Alder Coffee (INV-2041)
12									0
13									0
14									0
15									0
16									0

How the formulas work

Due date from your terms

F2=IF(C2="","",C2+E2)

Invoice date plus the payment terms in days. Use different terms per client (7, 14, 30) and each due date follows. Empty rows stay blank so the sheet is ready for new invoices.

Paid, Open or Overdue

H2=IF(A2="","",IF(G2<>"","Paid",IF($L$1-F2>0,"Overdue","Open")))

A paid date always wins. Otherwise the invoice is Overdue once the as-of date in L1 is past the due date, and Open before that. Type the date you review into L1 (or replace it with =TODAY() in your own copy to keep it current).

Days overdue

I2=IF(H2="Overdue",$L$1-F2,0)

How many days past the due date an overdue invoice is. Everything else shows 0, so the aging buckets and the "chase first" lookup only see late invoices.

Aging buckets

L6=SUMIFS(D2:D16,I2:I16,">30",I2:I16,"<=60")

SUMIFS adds the amounts whose days overdue fall in a range, here 31 to 60. The rows above and below use the same idea for 1 to 30 and over 60. The older a debt gets, the harder it is to collect, so watch the bottom bucket.

Who to chase first

L11

=IF(MAX(I2:I16)=0,"Nothing overdue",INDEX(B2:B16,MATCH(MAX(I2:I16),I2:I16,0))&" ("&INDEX(A2:A16,MATCH(MAX(I2:I16),I2:I16,0))&")")

MAX finds the most days overdue, MATCH finds its row, and INDEX returns the client and invoice number. The IF in front shows Nothing overdue when every invoice is on time, instead of naming a random row.

Make it yours

Send a friendly reminder on the due date, not weeks later. Sort by Due date (Data > Sort) to see what is coming up this week.
For partial payments, add a Paid amount column and compare it with Amount instead of a single paid date.
Rows 2 to 16 already hold the formulas. To add more, select row 16 and drag the fill handle down.
Use the Average days to get paid figure when you plan cash: if it is 25 days, money you invoice today arrives near the end of the month.

FAQ

How do I track unpaid invoices in Excel?

Give each invoice a row with its date, amount, terms and a Paid date column left empty until the money arrives. Then =SUMIF over the status, or SUMPRODUCT with (paid_date="") as a condition, totals what is still owed.

What is invoice aging?

Grouping unpaid invoices by how late they are, usually 1 to 30, 31 to 60, 61 to 90 and over 90 days. It shows how much of what you are owed is at risk and who needs a follow-up.

Can I make the as-of date update itself?

Yes. Type =TODAY() in L1 and the statuses and days overdue update each time the file recalculates. Keep a typed date if you want a fixed snapshot, such as month-end.

Functions used

Related guides

More free templates

Updated November 2, 2026