Home / Guides / Client rate calculator
Guide · Pricing · Invoicing
Client rate calculator in Excel
Guessing a rate on a sales call is expensive. A one-page Excel calculator turns target take-home, non-billable weeks, and taxes into an hourly, day, or project number you can put on an invoice — and a free Yellowcell download gets you there without another pricing SaaS.
May earn commissions. SoloDesk may earn a commission if you buy through affiliate links on this page. Recommendations are based on what we think fits the use case. See our affiliate disclosure.
Free client rate calculator (Yellowcell)
One sheet: yellow inputs for take-home, tax cushion, and billable time; gray formulas for hourly floor, day / half-day rate, and project fee. No macros. Soft path into the invoice kit when you are ready to bill.
Free client rate calculator Gumroad free download All free Yellowcell downloads
What the calculator should answer
- What hourly rate covers your target income after taxes and unpaid admin time?
- What day rate (or half-day) matches that hourly math for on-site / intensive work?
- How should a fixed project fee relate to estimated hours × rate (plus buffer)?
- Can you show the client a clear amount due once the scope is set?
Simple Excel layout (one sheet)
| Input (yellow) | Why it matters |
|---|---|
| Target annual take-home | The number you actually want after business costs |
| Estimated tax / SE tax cushion % | Rough buffer — confirm with a preparer; not tax advice |
| Billable weeks per year | Vacations, sick days, slow seasons |
| Billable hours per week | Admin, sales, and learning are not billable |
| Project hour estimate + contingency % | Turns hourly math into a fixed fee with slack |
Gray cells compute: required revenue → hourly floor → day rate (hours × day length) → project fee (hours × rate × (1 + contingency)). Keep formulas visible so you can trust the number before you quote.
Hourly vs day vs project — same sheet
- Hourly: Best when scope drifts. Invoice line items should still show a clear total due.
- Day / half-day: Useful for workshops, shoots, or travel days — set the day length in the sheet (e.g. 6 or 8 billable hours).
- Project fee: Quote a fixed amount derived from estimated hours, then invoice that fixed fee — do not leave “TBD” on the PDF.
Common mistakes
- Using 40 × 52 as billable hours (most freelancers are closer to 20–25 × 45)
- Forgetting unpaid sales time and invoice chasing
- Pricing the project off “what the client might pay” with no link back to your floor rate
- Calculating a rate in one app and invoicing from another with mismatched totals
From calculator to invoice
The calculator is for you. The client sees an invoice: deliverables, quantity, rate or fixed fee, tax if any, amount due, due date. Once you lock a number, copy it into your invoice workbook so the quote and the bill match.
Related SoloDesk guides
- Name-your-price invoicing in Excel
- Freelance invoice tools compared
- Wave vs Excel invoice
- QuickBooks Online vs Excel invoice
Free client rate calculator + invoice kit
Start with Yellowcell’s free one-sheet rate calculator (hourly, day, project). When the quote is locked, Sole Ledger puts a matching amount due on the invoice — expense log and 2026 mileage included, yellow inputs, no macros.
Free client rate calculator Gumroad free download Payhip (free) Buy invoice kit