Home / Invoice spreadsheet

Freelance invoice tracker & aging spreadsheet

Columns that matter · aging buckets · cash clarity · updated 2026

A freelance invoice spreadsheet is not a tax filing. It is a living list of what you billed, what is open, and what is late — so you can answer “what hits my account this week?” without opening seventeen email threads.

You can build one from scratch in any sheet app. Or you can use a ready workbook like Ops ($12) that also holds client context. Either way, the structure below is what stops aging from becoming a surprise.

Minimum columns (do not skip these)

Column	Why it exists
Invoice ID	Unique reference for email and bank notes.
Client	Who owes you — filter and sort by relationship.
Issue date	When you sent it; baseline for aging.
Due date	Contractual deadline — aging starts here.
Amount / currency	Exact number; avoid mixing currencies in one total.
Status	Draft / Sent / Partial / Paid / Written off.
Paid date	Closes the loop; feeds cash timing.
Days overdue	Formula: today − due date (if unpaid).

Optional but useful: project name, payment method, PO number, late-fee flag, and a “last chased” date so you know when you last sent a reminder.

Aging buckets freelancers actually use

Accounting packages use 30/60/90. Solo freelancers often need tighter buckets because cash runs out faster than corporate AP cycles:

• Current — not yet due
• 1–7 days — first reminder window
• 8–14 days — second nudge
• 15–30 days — final notice / pause work
• 30+ — escalate or write-off decision

Sum open amounts by bucket on a dashboard row. That single view is cash clarity: not “I think they will pay,” but “$X is 15+ days late.”

Cash view vs invoice list

An invoice list answers “what is unpaid?” A cash view answers “what is likely to arrive, and when?” You get there by combining:

1. Open invoices sorted by due date
2. Expected pay week (or “unknown”)
3. Known client behavior (always 10 days late vs usually on time)

Client behavior belongs next to the money — not in a separate notebook you never open. That is why Ops pairs a money sheet with a client sheet instead of leaving notes buried in chat.

DIY checklist (one evening)

1. Create one “Invoices” tab with the columns above.
2. Add a “Status” dropdown so filters stay clean.
3. Add Days overdue as a formula, not a manual number.
4. Add a summary block: total open, total 15+, total paid this month.
5. Create a “Clients” tab: rate, terms (net-15/30), preferred payment link, notes.
6. Every Friday: filter unpaid, send reminders, update “last chased.”

For reminder wording, see late payment email templates for freelancers or free Nudge (8-page PDF + subject swipe file). After payment, Slip helps you leave a clean receipt trail — print polish and due date / pay-by notes included.

When a ready workbook is worth $12

Build your own if you enjoy sheet design and will maintain it. Buy a workbook if you have already lost a weekend to formatting and still do not trust the totals. Ops is a one-time download — freelance money & client workbook — aimed at solo operators who want aging and client context without SaaS lock-in. Same $12 SKU: the ZIP now also includes an overdue lite HTML tool with CSV import and Print for quick chase lists.

Related

• Late payment email templates for freelancers
• Nydaymuse — Nudge, Slip, Ops
• Free Nudge templates
• Free Slip