BUSINESS SPREADSHEETS
Unpaid-invoice tracker template.
Track invoice totals, payments, credits, outstanding amounts and days overdue in a spreadsheet with an editable as-of date and working formulas.
See the completed example ↓WHEN TO USE IT
A clearer next step.
Use this for invoice-level follow-up. Record the cumulative payments and credits against each invoice so the remaining amount is clear. Keep different currencies in separate workbooks.
SEE IT IN CONTEXT
A completed example.
AS OF 30 SEPTEMBER 2026 · USD
| Invoice | Client | Issued | Due | Total | Payments | Credits | Outstanding | Days overdue | Status |
|---|---|---|---|---|---|---|---|---|---|
| INV-101 | Example Company | 2026-08-15 | 2026-09-14 | 1200 | 400 | 100 | 700 | 16 | Overdue |
| INV-102 | Sample Studio | 2026-09-10 | 2026-10-10 | 800 | 0 | 0 | 800 | 0 | Open |
| INV-103 | Example Retail | 2026-08-01 | 2026-08-31 | 500 | 500 | 0 | 0 | Settled | |
| INV-104 | Sample Agency | 2026-08-01 | 2026-08-31 | 200 | 250 | 0 | -50 | Overapplied |
The download includes Instructions, Summary and Entries sheets, with 200 prepared rows. Green cells contain formulas; blue cells are for your entries.
Invoice records
Invoice reference, client, issue date, due date, total, payments received and credits.
Outstanding and overdue
Outstanding is invoice total minus payments and credits. Days overdue compare the due date to the as-of date only when an amount remains outstanding.
Review flags
The status column distinguishes open, overdue, settled and overapplied records. A negative outstanding amount is retained and flagged for review rather than silently capped at zero.
KEEP YOUR WORK MOVING
The next step, in your browser.
Use the invoice aging calculator alongside this template to prepare your next document or work through the numbers.
GOOD TO KNOW
A few useful answers.
How do I use this template?
Download the workbook and open Instructions first. Set the currency label on Summary, then enter records in the blue cells on Entries. The green formula cells calculate the results. The completed workbook demonstrates the formulas with fictional data.
Can I edit and reuse it?
Yes. Adapt it for your own work and keep a copy for future use. The workbook has 200 prepared entry rows; extend the formulas and summary ranges if you need more.
Are the completed example details real?
No. Names, dates, amounts and scenarios in the completed example are illustrative. They show how to organize the document; they are not recommended fees, actual payment instructions or records of a real transaction.
Keep a good thing going.
All business spreadsheets ↗Business expense tracker template
Download an expense tracker spreadsheet with dates, merchants, categories, receipt references and totals for personal and company-paid expenses.
View template & exampleProject budget template
An editable project budget spreadsheet with cost categories, planned and actual costs, variance formulas and an optional contingency calculation.
View template & example