Even WageHow to track outstanding invoices as a freelancer
Ask most freelancers "how much are you currently owed?" and you'll get a shrug, a guess, or a scroll through email. Ask "how much of that is overdue?" and the answer gets even fuzzier. That's not a bookkeeping nitpick — it's the difference between planning your month around real cash and planning it around money that may not show up on time.
This isn't about how to write an invoice (see the invoice template guide for that). It's about what happens after you hit send: tracking what's still outstanding, until it's paid.
Why "I'll remember" doesn't work past 3–4 clients
With one or two clients, outstanding invoices live in your head fine. Past three or four active clients — especially with staggered due dates — the mental model breaks down fast. You stop being able to answer, off the top of your head:
- Exactly how much is currently outstanding across every client
- Which specific invoice is overdue, and by how many days
- Whether your overdue total is trending up (a real problem) or is just noise from one slow-paying client
Without those answers, "the money's coming" is a feeling, not a fact — and it's the feeling that leads freelancers to overspend against income that hasn't actually landed.
The system: one row per invoice, one Status formula
You don't need invoicing software to track this. A single spreadsheet tab with five inputs and one calculated column does it:
From that single table, three summary numbers roll up automatically: sum of amounts where Paid = "N" (your outstanding total), sum of amounts where Paid = "N" and due date has passed (your overdue total), and a count of how many of those there are. No manual recalculation, no separate spreadsheet — just three cells that update the moment you change a status.
What the numbers tell you
| Signal | What it usually means |
|---|---|
| Outstanding total is high but overdue total is $0 | Normal — you're just mid-cycle on a lot of invoices. Not a problem by itself. |
| Overdue total is small but overdue count is climbing | Several clients slipping slightly — often a sign your payment terms or reminders need tightening, not a crisis. |
| Overdue total is a large % of your outstanding total | Real cash-flow risk. This is the number to watch against your buffer/runway, not your total invoiced. |
| Same client shows up overdue repeatedly | A terms problem specific to that client — shorten their payment window or require a deposit going forward. |
How often to check it
Once a week is enough for most solo freelancers — daily is overkill unless you're actively chasing a specific late payment. The habit that matters isn't frequency, it's consistency: same day each week, glance at the three numbers, update anything that got paid. It takes under two minutes once the tracker exists.
If overdue total or count jumps between checks, that's your cue to start the follow-up sequence (friendly reminder → firmer note → pause work) before it compounds into a real gap.
Even Wage now tracks this automatically
The Invoice Tracker tab logs client, amount, sent date, due date and paid status — and calculates your outstanding total, overdue total and overdue count for you, with overdue rows flagged in red. It plugs straight into the same buffer and runway math as the rest of the workbook.
Get Even Wage — $19Quick-start checklist
- Log every invoice the day you send it — amount, sent date, due date
- Mark "Paid" the day money actually lands, not the day the client says it's coming
- Check outstanding / overdue total + count once a week, same day every week
- Treat a rising overdue total as a budget signal, not just an admin annoyance
- If one client repeatedly shows up overdue, fix their terms — not your tracking
Even Wage is an educational budgeting template, not legal, tax, or collections advice. Payment terms and enforceability vary by jurisdiction and contract.