Freelancer Invoice Tracker

Freelancer Invoice Tracker — Know Who Owes You What

Every invoice in one place, with its status worked out for you. Send an invoice, mark it paid when the money lands, and the tracker tells you what is still outstanding, what is overdue, and who owes you the most — before a client quietly forgets.

Chasing payments is the worst part of freelancing. This tracker does the nagging for you: enter an invoice once, and it watches the due date, flags anything overdue, counts the days, and adds it all up per client — so your next follow-up email takes thirty seconds instead of an afternoon of digging through old messages.

What you get:

• Invoices — every invoice with client, project, issue date, due date, amount and paid date; status and days overdue worked out automatically
• Summary — total billed, total paid, outstanding, overdue, counts by status, and your oldest overdue invoice
• Clients — per-client totals: billed, paid, outstanding and invoice count, so you can see at a glance who your est payers are
• Aging — overdue money split into 1–30, 31–60, 61–90 and 90+ day buckets
• README sheet — 5-minute setup guide, no macros, no add-ins

How it works:

Yellow cells are the only ones you type in. Status is automatic: Paid when you enter a paid date, Draft when no issue date is set yet, Overdue when today is past the due date, otherwise Sent. Everything else is a formula. Works in Microsoft Excel 2016 and newer, and in Google Sheets (File > Import > Upload). No sign-in, no subscription, no macros.

Who it is for:

Freelancers and small service businesses who send invoices and want to stop losing track of them — designers, writers, developers, consultants, coaches, and anyone whose clients sometimes pay late.

You get: 1 Excel file (.xlsx), 5 sheets, instant download. For personal use only.