intent page use-case cite-ready Query: overdue freelance invoices · spreadsheet · One page for one decision · Updated 2026-10-28
How to track overdue freelance invoices in a spreadsheet
If you freelance, you usually know roughly who owes you — not how late each balance is. Invoice aging fixes that in under 10 minutes a week: group unpaid amounts into four buckets, then chase the oldest meaningful balances first.
This page is the complete Friday method. At the end you can download a free working .xlsx sample (EXAMPLE unpaid $1,620). Not accounting software. Not tax advice.
Download free Aging .xlsx ($0) Open sample repo
What “aging” means for a solo freelancer
Answer: Aging groups open invoice balances by days past the due date so you chase late cash in order, not by vibe.
Aging groups open balances by days past the due date. Use these four buckets (they match the free sample):
| Bucket | Meaning | Friday action |
|---|---|---|
| Current | Not past due | No chase; optional pre-due note on large AP |
| 1–30 | Recently late | Polite reminder + payment details |
| 31–60 | Seriously late | Ask what is blocking payment; firmer tone |
| 60+ | At risk | Final written chase; pause new work if that is your policy |
Start with the oldest meaningful unpaid balances, not only the largest client. A $400 invoice at 45 days often beats an $8k invoice at 5 days when cash is tight.
Minimum columns (do not skip)
Answer: You need Invoice ID, Client, Issue/Due dates, Amount/Payments/Open balance, Status, Days overdue/Bucket, and Last/Next chase — age the open balance after partials.
| Column | Why |
|---|---|
| Invoice ID | Reference in email and bank notes |
| Client | Filter / sort by relationship |
| Issue date · Due date | Aging starts at due date, not issue date |
| Amount · Payments · Open balance | Age the open balance after partials |
| Status | Draft / Sent / Partial / Paid / Written off |
| Days overdue · Bucket | Only unpaid, past-due rows count up |
| Last chase · Next chase | Your Friday sorted list |
Friday 10-minute ritual
Answer: Once a week: confirm payments, filter unpaid, sort by days overdue, send one chase per row due today, log outcome, glance at bucket totals.
- Open the sheet. Confirm every payment that landed this week (same day you see the bank hit).
- Filter Status ≠ Paid. Sort by days overdue descending, then amount.
- Send one chase per overdue row that is due today on Next chase — not a batch of guilt emails.
- Log channel + outcome; set the next chase date (due / +7 / +14 / +21–30).
- Glance at bucket totals: where is cash stuck this week?
Worked EXAMPLE (fake data — from the free sample)
On the free sample’s Aging check, EXAMPLE unpaid total is $1,620 across Current / 1–30 / 31–60 / 60+ buckets. Personas are fictional; the formulas and Friday sort are real.
Open the file → read Start Here → look at Aging Sample → sort overdue for chase.
Free vs paid (honest seam)
| Free sample ($0) | Full Invoice Tracker ($6 · live) |
|---|---|
| Aging Sample sheet + Start Here + Full Tracker map | Invoice Log · Clients · PDF invoice path · Dashboard |
| Proves quality + Friday sort | Breadth: full AR system, not unlocked cells on the sample |
If the free sample is missing what you need, open a GitHub issue with one word: CLIENTS · PDF · DASHBOARD. Silent downloads do not tell us what to build next.
Download
Get free Aging .xlsx ($0) Get Invoice Tracker ($6) Bundle ($12) Trust hub / all free samples Repo
FAQ
- Do I need QuickBooks to track overdue freelance invoices?
- No. A spreadsheet with aging buckets and a Friday chase list is enough for a solo freelancer with a handful of open invoices. Move to accounting software when you need tax-ready books or multi-user AR — not to start seeing who is late.
- How often should freelancers chase overdue invoices?
- Run one 10-minute ritual every Friday: confirm bank hits, sort unpaid by days overdue, send one chase per row whose Next chase is today, then set the next date (+7 / +14 / +21–30). Daily guilt batches burn relationship capital.
- What aging buckets should a solo freelancer use?
- Four buckets: Current (not past due), 1–30, 31–60, and 60+ days past the due date. Chase oldest meaningful balances first when cash is tight — a $400 at 45 days often beats an $8k at 5 days.
- Where is the free invoice aging spreadsheet?
- Download Freelancer-Invoice-Aging-Sample.xlsx from the SirMem/freelancer-invoice-aging-sample GitHub repo ($0). EXAMPLE unpaid total on the Aging check is $1,620. Not accounting or tax advice.
Disclosure
Built by Kevin with an AI assistant for packaging. Spreadsheet guidance only — not accounting, tax, or legal advice. No earnings claims. AI-assisted build disclosed. Public ledger: freelancer-money-sheets.