Freelance client tracker spreadsheet: leads, hours, invoices
The tabs and columns a freelance client tracker needs to follow up leads, log hours and chase overdue invoices.
Freelancers lose money in the gaps: a lead nobody followed up, hours nobody logged, an invoice nobody chased. A single client tracker closes those gaps. This guide lays out the tabs and columns that matter, so you can build one in Google Sheets or Excel.
1. Leads tab: who might hire you
| Column | Why |
|---|---|
| Name / company | Who it is. |
| Source | Referral, website, marketplace. Tells you where good work comes from. |
| Stage | New, contacted, proposal sent, won, lost (a dropdown keeps it tidy). |
| Next follow-up date | The most important column. Sort by it every morning. |
| Estimated value | Rough project size, so you know which leads deserve time. |
2. Clients tab: who has hired you
Contact details, rate or package agreed, payment terms, and a link to the contract or proposal. One row per client.
3. Time log: what you worked on
Date, client, task, hours, billable yes/no. Log it daily; reconstructing a week from memory always comes out short.
4. Invoices: what you are owed
Invoice number, client, date sent, amount, due date, date paid. A status column can work itself out:
5. A weekly review
Once a week: sort leads by follow-up date, check unbilled hours, filter overdue invoices. Fifteen minutes, and nothing falls through.
Do it in a spreadsheet
The Spreadoodle Freelance CRM with Time & Invoice tabs has these tabs connected, and the Client Onboarding System covers what happens after a lead says yes. Not sure what to charge yet? Start with the freelance rate calculator guide.
This guide is general information, not tax, legal or accounting advice.