Invoice aging for freelancers: how to read 1–30, 31–60, 61–90 and 90+ days (with a real example)

When you invoice several clients, "who owes me what?" gets hard to answer from memory. An aging report answers it: every unpaid balance, sorted by how many days it is past due. Here's one from a tested invoice tracker (24 invoices, 5 clients).

The example

The buckets add up to the overdue total. That check is worth building into any aging report, because a single invoice with a wrong status breaks it.

How it's calculated

balance      = invoice amount − payments received against it
status       = Paid if balance ≤ 0, Overdue if unpaid and past the due date, else Part paid / Open
days overdue = today − due date          (only for Overdue invoices)
bucket       = 1–30 · 31–60 · 61–90 · 90+ (day 30 is in 1–30, day 31 in 31–60)

Log each payment separately, rather than overwriting a "paid" cell. Then partial payments reduce the balance properly, and you keep a record of when the money actually came in.

Reading it

• 1–30 days: usually an oversight. A friendly reminder with the invoice attached is enough.
• 31–60 days: follow up directly with the person who approves payment, not just the inbox that received the invoice.
• 61–90 days: pause new work for that client until they're current.
• 90+ days: the money is at real risk. In the example it's the largest bucket, $9,640.01, which is common when nobody tracks aging.

Two more numbers worth tracking

• Average days to get paid (from issue date to the last payment): 33.9 days across the paid invoices in the example. If it keeps rising, shorten your terms or ask for deposits.
• Unpaid by client: one client often accounts for most of the risk. In the example, one client owes $9,592.41, $8,399.87 of it overdue.