Invoice aging calculator: who owes what, and how late

List your unpaid invoices with their due date, amount and what's been paid. See what's outstanding, what's overdue, the aging buckets (1-30, 31-60, 61-90 and 90+ days late) and the total by client, as of any date.

✓ TestedSame calculation as the tested spreadsheet

Overdue–

Outstanding (all unpaid)
Not yet due
1-30 days late
31-60 days late
61-90 days late
Over 90 days late

Client	Unpaid	Overdue

Invoice	Balance	Status

Balance = amount − paid. An invoice is overdue from the day after its due date; days late = the as-of date − the due date. The spreadsheet adds a payments log, days-to-get-paid per client and 500 invoices.

How it works

Each invoice's balance is its amount minus what has been paid. A balance of zero or less is paid. Otherwise it is overdue once the as-of date is past the due date, and its days late are the days between the two; it then falls into one of four aging buckets: 1-30, 31-60, 61-90 or over 90 days. Unpaid invoices that aren't due yet count as outstanding but not overdue. The client table adds up each client's unpaid and overdue balances, so you can see who to chase first. More in the invoice aging guide.