A client tracking spreadsheet answers one question each morning: who is waiting on me, and what do I do next. This free freelance client tracker page gives you the printable table first, 10 rows covering client, service, rate, status, last contact, and next action, then a five-line legend for the N/C/P/W/L stages, a four-line follow-up cadence, a three-question win/loss review box, and one paragraph of pipeline math. The full 6-tab hub is linked at the bottom.
How to use this page: print one copy, or copy the table into any spreadsheet app and keep it open all day. One row per client or lead. Write the status letter, the date you last contacted them, and the one next action with a date on it. "Send revised quote" is an action. "Follow up" is not. The two Example rows show the fill pattern; overwrite them.
Generic template, your numbers. Your rates, statuses, and cadence are yours to set per client and per agreement. This page is record keeping, not legal, tax, or accounting advice.
Six columns, 10 rows, two worked examples. Client and Service say who the row is about. Rate is your current price for them, blank until agreed. Status uses the letters from the legend below, one keystroke per update. Last contact and Next action are the two columns that make the tracker worth keeping: sorted by last contact, the oldest date is your next phone call.
Printed copies run out of rows faster than you expect, and that is fine. A full page means you know more than 10 clients at once, which is the point where a spreadsheet with one row per client and room for years of history starts to pay for the ten minutes it takes to set up. Until then, the paper version and the spreadsheet version hold the same six columns, so nothing needs reformatting when you switch.
| Client | Service | Rate | Status | Last contact | Next action |
|---|---|---|---|---|---|
| Example: Harbor Web Co | Web design | 1,200 USD | P | Sep 4 | Send quote v2 by Sep 9 |
| Example: Nora Reyes | Blog package | 450 USD | W | Sep 1 | Kickoff call Sep 12 |
These five letters are the pipeline stages from the full hub, shrunk to single characters you can write by hand. One row sits in exactly one stage, and the letter changes only when something happens, not when you hope it will.
| Letter | Stage | What it means |
|---|---|---|
| N | New | A lead you found but have not contacted. They are on the list because you intend to reach out, and the Next action column carries the date you will. |
| C | Contacted | A first conversation has happened and they know who you are. Most rows die here, and that is normal. If there is no reply, the row either moves forward after a follow-up or moves to L. |
| P | Proposal | A scope and a price are in their hands. Every P row should have a Next action with a calendar date, because proposals without a follow-up date quietly expire. |
| W | Won | An agreement exists. The row stops being a prospect and becomes a client: the tracker now records the service, the rate, and the next deliverable instead of a sale. |
| L | Lost | They said no, went silent after a proposal, or the budget vanished. Keep the row. Lost rows are the raw material for the win/loss review below, and past clients come back. |
Four habits we would keep if we only kept four. They are opinions from running a table like this, not research findings.
Once a month, answer three questions in writing, for one W row and one L row:
1. Where did the decision actually happen? (First call, proposal, price email, or elsewhere.)
2. What did the client compare you against, and what did they pick or nearly pick?
3. What one sentence would have moved this row faster, and can you say it first next time?
Twelve answers a year, six sentences a month. The material is rows you already wrote, and the questions take ten minutes.
The reason a client tracker earns its keep is that stages turn a vague year into countable rows. When you log ten prospects, you can watch how many move to Contacted, how many reach Proposal, and how many end in W, and after a few months those counts tell you what a pipeline needs to look like to keep you busy. No template can tell you in advance what your conversion rate will be; it depends on your niche, your pricing, and how warm the leads are. What the tracker does promise is a smaller thing: you will know your own numbers from your own rows instead of guessing. "I need more leads" becomes the more useful sentence "I have 4 proposals out and I usually land about 1 in 3, so I need 3 more proposals to keep the month full," whatever your actual numbers turn out to be.
The printed tracker above holds ten clients and lives on a desk. The Freelance Client Hub keeps the same shape and adds the math: status counts, win rate, outstanding invoices, and monthly income and expenses, all calculated. What is inside:
one-time · XLSX + CSV · instant download · spreadsheet only, not accounting, tax, or legal advice