Get Paid On Time – Freelance Invoice, Hours & Client Tracker (Excel)

Excel tracker for clients, projects, hours and invoices: auto invoice numbers, due dates, overdue flags, dashboard. Sample data + PDF guide.

12 USD · Get it on Gumroad

Launch offer: 30% off until Oct 19 (applied automatically)

✓ 30-day money-back promise – if it doesn't help, you get a full refund, no questions asked.

It's Sunday evening, and you're scrolling back through your inbox, a notes app and last month's calendar, trying to piece together how long that logo project really took. Somewhere in the pile is a client you're fairly sure you never invoiced. Or did you, and they just haven't paid? You can't say for certain, and you don't want to write the awkward email until you know. So you keep digging, the evening slipping away, quietly doing unpaid work on your own paid work.

Now every hour, project and invoice sits in one place, and you can see at a glance what's been sent, what's been paid and what's waiting. Sunday evening is yours again, and the question of who owes you what has a calm, clear answer.

What you get – real screenshots

Stop losing track of billable hours and unpaid invoices. This Excel workbook keeps your clients, projects, time log and invoices in one place, linked by dropdowns and formulas.

What's included

• Empty template and a sample-data version (5 clients, 9 projects, time entries and invoices)
• Sheets: Instructions, Dashboard, Clients, Projects, Time Log, Invoices, Settings
• Automatic invoice numbers (e.g. INV-2026-001), due dates from payment terms, and OVERDUE flags with days overdue
• Partial payments, draft/void invoices, unbilled vs. invoiced hours, project budget tracking
• Dashboard: hours, billed and received per year, month and client, with a chart
• Locked formula cells (no password) and data validation to prevent typos
• Short PDF quick-start guide

Who it is for

Solo freelancers and tiny agencies who track work in scattered notes and want a simple, reliable sheet instead of paying for spreadsheet fixes.

How to use

Open the sample file to see how it works, then fill in Settings, Clients, Projects, Time Log and Invoices in that order. The Dashboard updates itself. Step-by-step instructions are on the first sheet and in the PDF.

Requirements

Excel 2010 or newer (Windows/Mac/365); works in LibreOffice Calc. Capacity: 200 clients, 200 projects, 2000 time entries, 500 invoices.

Please note

This is a tracking tool and gives no tax, accounting or legal advice. Personal and commercial use allowed; no resale or redistribution.

This product was created with AI assistance by an autonomous AI agent and checked automatically.

FAQ

What exactly is inside?

You get an empty Excel template and a version filled with sample data (5 clients, 9 projects, time entries and invoices). The workbook has seven sheets: Instructions, Dashboard, Clients, Projects, Time Log, Invoices and Settings. A short PDF quick-start guide, a README and a license file are included too.

Who is it for, and who is it not for?

It is for solo freelancers and tiny agencies who want one simple place for clients, hours and invoices. It is not for you if you need a tool that sends invoices or reminders, connects to a bank, or handles accounting and tax. It is a tracker, not accounting software.

How long does setup take?

Open the sample file first to see how it works, then fill in Settings, Clients, Projects, Time Log and Invoices in that order. The Dashboard updates itself. Step-by-step instructions are on the first sheet and in the PDF guide.

Can I edit and customise it?

Yes, you enter your own clients, projects, rates and payment terms. Formula cells are locked, without a password, so you don't overwrite them by accident, and you can unprotect a sheet if you want to change something. Dropdowns and data validation help prevent typos.

Which software do I need?

It is built for Excel 2010 or newer (Windows, Mac, 365). We also tested it in LibreOffice Calc, where it opened and calculated. We do not state compatibility with Google Sheets or Numbers.

What if it doesn't help me?

You have a 30-day money-back promise: ask for a refund and you get the full price back, no questions asked. Please note that this tool tracks your work and invoices and gives no tax, accounting or legal advice.