When should I follow up with past clients?

A good default is six months after the project ends — long enough for new needs to appear, short enough that you're well remembered. For clients on annual budgets, add a touch in October or November when next year gets planned. The perfect timing matters less than having any date in the sheet at all.

How do I ask for a testimonial without seeming pushy?

Shortly after delivery, specifically, and with minimal effort required from them: "I loved working on this — could I quote two sentences from you on what improved? Happy to send a draft you can edit." The offered draft is the key: most clients gladly say yes when they don't have to compose anything themselves.

Isn't my invoicing tool already a client list?

It knows your clients, not your relationships. Invoicing tools store amounts and addresses — not who referred you, when you meant to circle back, or whether the testimonial is still outstanding. That's the exact gap this tracker fills. Together they give the full picture: the tool for the money, the sheet for the people behind it.

What goes into a good win-back message?

Three ingredients: a concrete reference to the shared project ("is the relaunch still running smoothly?"), a piece of genuine interest with no sales tone, and at most a quiet mention of your availability. No price list, no newsletter voice. The goal is a conversation, not a close — the engagement follows on its own when the need exists.

Free template

Freelance Client Tracker

Freelancing runs on repeat clients and referrals — and those are exactly what slip through the cracks. The project ends, the invoice goes out, and six months later you've forgotten that this client loved your work, that you never asked for a testimonial, and who referred you in the first place. This template captures what matters between projects: where each engagement came from, when it ended, when you plan to circle back, and whether the testimonial question has been asked. It replaces neither your invoicing tool nor your project board — it's the relationship layer both of them lack. Import the CSV into Endearist if you want reminders attached; a plain spreadsheet works fine too.

Download CSV

Opens in Excel, Google Sheets, Numbers — or imports straight into Endearist.

See all templates →

What each column means

Column	How to use it	Example
Client	Company plus your actual contact person — people change jobs and take you with them.	Birchline Media — Sarah Quinn
Project	What you delivered, in one line — precise enough for your portfolio list.	Website relaunch + brand styleguide
Day rate note	What you last charged this client, with context — so the follow-on quote never undercuts you.	$850 (2025 rate — quote $950 next time)
Source / referrer	How the work found you: referral (from whom?), platform, returning client. Your single best marketing metric.	Referred by Maya Castillo
Project end date	The day of final delivery — the anchor for the testimonial ask and the win-back math.	2026-05-29
Win-back date	Project end plus roughly six months: your date for a friendly "how's the … holding up?".	2026-11-30
Testimonial asked?	Yes / no / received. The cheapest marketing asset there is — and the most commonly forgotten.	Asked 2026-06-05 — promised
Notes	Personal and business context that makes re-entry easy: budget cycles, plans, quirks.	Planning a shop launch in 2027 — revisit in Q4

How to use this template

Set the win-back date the day you send the final invoice
Make it a ritual: final invoice out, update the row, set the win-back date six months ahead. In that moment you still know everything — project details, unfinished wishes, budget situation. Six months later you'll know nothing. The ritual takes two minutes and is the difference between accidental clients and repeat clients.
Ask for the testimonial within two weeks of delivery
Right after delivery, satisfaction is at its peak and memory at its sharpest — three months later both are gone. Make the ask specific ("two sentences on what changed since the relaunch?") and tick the column. Offering a draft they can approve or edit lowers the bar enormously.
Once a month, sort by win-back date
Block a fixed slot — say the first Monday of the month — and sort the sheet by win_back_date. Everything due gets a short, honest message with zero sales pressure: a reference to the old project, one concrete question, done. Three of those emails a month keep your pipeline fuller than any gig platform.
Thank every referral source
The source column isn't a statistic — it's a to-do list: whoever referred you should hear from you that it turned into a project, with a genuine thank-you, not a commission. People refer again when they see their referral landed well. Silence quietly trains them to stop.

Mistakes to avoid

Only marketing when the pipeline runs dry
The feast-famine pattern: no time for outreach during a project, panic-prospecting strangers after it ends. Yet your next engagement is almost always sitting in the old rows of this sheet — past clients book faster, pay better, and haggle less. The monthly routine above costs one hour and flattens the curve.
Putting off the testimonial ask forever
"I'll ask later" means "I'll never ask" in practice — and after a year it gets weird. Without the testimonial_asked column you don't even notice how many delighted clients walk away unquoted. Every missing testimonial is proof of your work that the next prospect will never get to see.
Confusing the company with the person
Your contract was with the company; your relationship is with Sarah. When she changes employers, that's not a lost contact — it's a new client, if you notice it happening. Always track the person alongside the firm and log moves immediately. Many freelance careers consist of three people carrying you across five companies.
Forgetting your old rate and undercutting yourself
Without the note, you'll quote the follow-on project from your gut — and in negotiations the gut is a coward. Seeing your last rate in writing, including the note "quote $950 next time", gives you an anchor. Day rates don't rise on their own; they rise because the row reminds you they're supposed to.

Frequently asked questions

When should I follow up with past clients?: A good default is six months after the project ends — long enough for new needs to appear, short enough that you're well remembered. For clients on annual budgets, add a touch in October or November when next year gets planned. The perfect timing matters less than having any date in the sheet at all.
How do I ask for a testimonial without seeming pushy?: Shortly after delivery, specifically, and with minimal effort required from them: "I loved working on this — could I quote two sentences from you on what improved? Happy to send a draft you can edit." The offered draft is the key: most clients gladly say yes when they don't have to compose anything themselves.
Isn't my invoicing tool already a client list?: It knows your clients, not your relationships. Invoicing tools store amounts and addresses — not who referred you, when you meant to circle back, or whether the testimonial is still outstanding. That's the exact gap this tracker fills. Together they give the full picture: the tool for the money, the sheet for the people behind it.
What goes into a good win-back message?: Three ingredients: a concrete reference to the shared project ("is the relaunch still running smoothly?"), a piece of genuine interest with no sales tone, and at most a quiet mention of your availability. No price list, no newsletter voice. The goal is a conversation, not a close — the engagement follows on its own when the need exists.

Last updated: 2026-06-10

When the spreadsheet gets too small.

Endearist imports this CSV directly — and reminds you before contacts go quiet. Free up to 25 contacts.

Start free