Free Invoice Tracker Spreadsheet (Excel)

What's in the invoice tracker spreadsheet

The workbook has one working tab, Invoice Tracker, with 200 rows: invoice #, client, amount, invoice date, due date and status (Paid or Unpaid).

Days overdue and aging bucket calculate automatically for every row - a Paid invoice always reads 0 days and 'Paid', while an Unpaid invoice compares its due date to today and buckets it as 0-30, 31-60 or 61+ days late.

The summary below the table totals every invoice issued, total still outstanding, how many invoices fall in each aging bucket, and the dollar amount specifically in the 61+ (most overdue) bucket.

A tracker, not an invoice generator

This is deliberately different from an invoice template: it's a single-tab log of invoices you've already sent, built to answer 'who owes me what, and how late is it' at a glance - not to design or print an individual bill.

If you need to create the invoice itself, this site has dozens of niche invoice templates (contractor, hourly, catering and more) - use one of those to bill the client, then log the result here to track payment.

Auto-flagging overdue invoices and aging buckets

Xappex and template.net both offer static single-tab trackers with basic columns and no automated aging logic - you'd calculate days overdue and buckets by hand, every time you open the file.

This tracker updates automatically using today's date: mark an invoice Paid and its overdue flag resets to zero instantly, and the aging-bucket rollup in the summary always reflects the current day, no manual recalculation.

Who this template is for

Freelancers, small agencies and contractors who send more than a handful of invoices a month and need one place to see which are overdue and by how much, without opening every invoice individually.

It complements, rather than replaces, whatever tool you actually create your invoices in - a document editor, this site's invoice templates, or your accounting software.