A new lead messages you: "Can you start Tuesday?" You say yes. It feels fine — you're not that busy. Three weeks later you're writing an awkward email to an existing client explaining why their deadline slipped, because nobody, including you, noticed that Tuesday didn't actually have room.
This is the single most common way freelancers and solo consultants get overbooked: not through bad planning, but through no planning — no number to check before saying yes. A calendar shows you what's scheduled. It doesn't tell you what's left.
The fix isn't more discipline. It's a number.
I built a workbook that replaces the guess with a number. You log the hours you've booked per client, per week, and nine linked tabs do the rest:
- Setup — your real weekly available hours, target utilization %, and buffer time, set once
- Clients & Rates — every active and pipeline client in one color-coded table
- Weekly Capacity Log — 16 weeks pre-built, auto-summing booked hours per client
- Capacity Dashboard — this week's snapshot plus an 8-week "overbooking radar" that flags a red week while you can still renegotiate it, not after you've already missed it
- Client Deadline Tracker — days-remaining formulas that turn red under 3 days
- Rate Reality Check — your true effective hourly rate after unbilled admin time, versus what you quote
No formulas to build. You type hours into the yellow input cells; everything else — the utilization percentage, the overbooking flags, the revenue-at-risk estimate — calculates itself.
Why this matters more than another to-do app
Task managers tell you what to do. They don't tell you whether you have the hours to do it. The gap between those two things is exactly where overcommitment lives, and it's invisible until the week you're already in it.
The workbook also comes with a 9-page companion PDF guide, including three ready-to-send scripts for the exact moments this is built for: a new lead wants to start now, an existing client adds scope mid-project, and the week you realize you're already overbooked.
Who this is for
Freelance consultants, designers, developers, and writers juggling three or more active clients — anyone who has said yes to a project and then spent the next hour doing capacity math in their head instead of in a tool built for it.
It works in Excel natively, and imports cleanly into Google Sheets (File > Import) with every formula and conditional-format rule intact.
If you've ever found out you were overbooked the same week it happened, this is built to make sure that doesn't happen again.
Get it here:
- Gumroad ($39): https://logi2.gumroad.com/l/cvgbq
- Etsy ($27): https://www.etsy.com/listing/4583655465/freelancer-capacity-planner-spreadsheet
Top comments (1)
Some comments may only be visible to logged-in visitors. Sign in to view all comments.