Back to Shop
Freelance Pricing & Profitability System
Track multiple clients at once — see real profit per project, your blended hourly rate, and whether your freelance income is trending up or down.
One project at a time is a calculator. All your projects together is a business.
The free Freelance Profit Calculator evaluates a single project. But you're juggling three clients, a retainer, and a side project — and you have no idea which one is actually worth your time. This system tracks everything in one place so you can see your real numbers across all freelance work simultaneously.
What's Included
- Multi-client tracker: up to 10 active clients or projects, each with their own revenue, expenses, hours, and real hourly rate
- Monthly profit & loss dashboard: total freelance income, total expenses, net profit, and blended effective hourly rate — updated automatically as you log work
- Per-client profitability ranking: all clients ranked by net hourly rate on one page — immediately see which ones to keep, renegotiate, or drop
- Time log: simple hours tracker per project per week — no app needed, just the spreadsheet
- Rate-setting worksheet: "to net $X/year after tax and expenses, I need to charge $Y/hr and bill Z hours/month" — works backwards from your target income
- Quarterly actual vs estimated tax reconciliation: compare what you estimated vs what you actually owed — refine your estimates over time
- Annual income summary: year-end totals per client, ready to hand to your accountant or paste into your tax return
- Works in Google Sheets (free) and Excel
Who This Is For
- Freelancers juggling multiple clients who want to know which ones are actually profitable
- Anyone who used the free Freelance Profit Calculator and wants to track all projects in one system
- Solo consultants who want a simple P&L without accounting software
- Freelancers whose income fluctuates and want to see the trend over months, not just one project at a time
How It Works
- Add each active client or project to the dashboard — name, rate type (hourly/fixed/retainer), and start date
- Log hours and income weekly or monthly — takes under 5 minutes
- Enter project expenses as they come in (software, subcontractors, travel)
- The dashboard updates automatically: profit per client, blended rate, monthly P&L
- At the end of each quarter, review the profitability ranking and decide what to change