Skip to content
← TemplatesBookkeeping & cash

Free Debtors & Accounts-Receivable Aging Tracker (Excel)

Cash-flow problems usually aren't a sales problem — they're a collection problem. This free tracker shows you exactly who owes you and for how long: list each unpaid invoice, and it works out the balance, the days overdue and an aging bucket (Current, 1–30, 31–60, 61–90, 90+), so your follow-up list is just the red rows.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Balance, days overdue and aging bucket worked out per invoice
  • 30/60/90 aging summary with in-cell bars on the Dashboard
  • One 'As at' date re-ages the whole ledger
  • 90+ overdue flags red; paid flags green
  • Formulas locked; only the yellow cells accept typing

The tabs

  • Start Here (guide)
  • Invoices
  • Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

On the Invoices tab you enter one row per invoice — customer, invoice date, due date, amount and anything paid. The balance, days overdue and aging bucket compute themselves against the 'As at' date you set on the Dashboard, so the whole ledger re-ages the moment you change that one date.

The Dashboard totals what you've invoiced, received and are still owed, and breaks the outstanding amount into aging buckets with in-cell bars — so you can see at a glance whether your debtors are merely late or genuinely stuck. Overdue 90+ balances flag red; anything paid turns green. Only the yellow cells accept typing; the formulas are locked.

When it's time to chase, a clean tax invoice does the talking — our free invoice generator produces one in your browser, numbered and ready to resend.

Do it online instead

Raise a tax invoice online — free

Open the free tool →

Frequently asked questions

How is the aging worked out?

For each invoice with a balance, days overdue = the 'As at' date minus the due date (never below zero). The bucket is then Current (not yet due), 1–30, 31–60, 61–90 or 90+ days. Set one 'As at' date on the Dashboard and every invoice re-ages instantly.

Does it handle part-payments?

Yes. Enter what's been paid and the balance is the amount minus the payment; once the balance hits zero the invoice shows as Paid and drops out of the aging totals.

Does it work in Google Sheets?

Yes — upload the .xlsx to Google Drive and open it with Google Sheets. The formulas, colour flags and aging bars all carry over.