Shop / Guides / Freelance invoice aging Excel
Guide · Collections
Freelance invoice aging in Excel
An invoice aging report is a simple Excel view of unpaid invoices sorted by how overdue they are — current, 30, 60, and 90+ days — so you stop guessing who still owes you. Yellowcell’s free invoice sample gives you a clean sendable invoice; the paid invoice kit adds expense and mileage companions when you want the full set.
What an aging log should capture
- Invoice # — unique id you can quote in a reminder
- Client — who pays (one row per open invoice)
- Invoice date — the day you sent it
- Due date — Net 15 / Net 30 / custom
- Amount due — remaining balance (not original total if partially paid)
- Status — open, partial, paid, written off
- Last touch — date of last reminder or reply
If a row cannot answer “how late is this, and what do I say next?”, it is not an aging row yet.
Simple Excel layout (yellow in, gray helpers)
| Column | Example |
|---|---|
| Yellow — invoice # | YC-1042 |
| Yellow — client | Acme Studio |
| Yellow — invoice date | 2026-07-15 |
| Yellow — due date | 2026-08-14 |
| Yellow — amount due | 1850 |
| Yellow — status | Open |
| Gray — days past due | =TODAY()-due date (when open) |
| Gray — bucket | Current / 30 / 60 / 90+ |
| Yellow — last touch | 2026-09-01 reminder sent |
Keep paid invoices on a separate sheet or filter them out so the aging view stays short enough to act on weekly.
Aging buckets that freelancers actually use
- Current — not yet due (or due today)
- 1–30 — polite reminder + re-attach PDF
- 31–60 — firmer note; confirm AP contact and PO
- 61–90 — escalate; pause new work if the contract allows
- 90+ — decide: payment plan, collection path, or write-off
Use a helper IFS or nested IF on days past due so the bucket updates when you refresh the sheet — do not type the label by hand every week.
Weekly 15-minute collections ritual
- Filter Open and sort by bucket (worst first)
- Send one reminder per overdue client (not five to the same inbox)
- Log Last touch the same day so you do not double-nudge
- When payment clears, flip status to Paid and archive
Common mistakes
- Aging the original invoice total after a partial payment — age the remaining balance
- Mixing Net 15 and Net 30 without a due-date column
- Leaving paid rows in the open view until the sheet feels noisy
- Reminder emails with no invoice #, amount, or due date
Pair with billing tools
- Free billable hours tracker — prove the hours before you chase the invoice
- Late-fee / progress billing guides — structure the next send so aging stays rare
- Money Kit ($29) — invoice, budget, and debt sheets when you want the paid set
Educational templates for record-keeping only — not tax, legal, or accounting advice.