SpreadsheetFormulas

Invoice Tracker

Log invoices with automatic due dates from payment terms, days-overdue tracking, and an outstanding-balance summary.

Made for: Freelancers and small businesses keeping on top of who owes what.

Download for Excel (.xlsx)

Free, no sign-up. For Google Sheets: upload via File → Import — all formulas carry over.

What's inside (sample rows)
1Invoice #ClientDue DateStatusDays Overdue
2INV-001Acme Co2026-07-01Paid0
3INV-002Borealis LLC2026-07-10Sent0
4INV-003Cobalt Studio2026-07-08Sent0

Formulas built in

=C2+D2
Due date from issue date + terms
=IF(G2="Paid",0,MAX(0,TODAY()-E2))
Days overdue, zero once paid
=SUMIFS(F2:F5,G2:G5,"<>Paid")
Total outstanding