Google Sheets for Consultants: The Replace-Your-SaaS Stack
Replace $300-600/month of consulting SaaS with a five-sheet stack: utilization tracker, client profitability dashboard, expense reimbursement log, pipeline tracker, and retainer-vs-T&E calculator.
Independent consultants face the same problem as freelancers but at higher complexity: each engagement has a different rate structure (hourly, project, retainer, sometimes equity), and the profitability math has to account for utilization rate, unpaid scope creep, and overhead. PSA tools like Mavenlink, Kantata, and Replicon solve this but cost $30-100/user/month. For solo consultants and 2-5 person boutiques, a sheet-based stack delivers 80% of the value at zero cost. The five sheets: utilization tracker (billable vs non-billable hours), client profitability dashboard (revenue minus allocated time and expenses per client), expense reimbursement log (with status column), pipeline tracker (deal value × probability), and retainer-vs-T&E calculator that compares revenue models on each new opportunity.
What this stack actually solves
- Utilization rate is invisible — you bill 30 hours/week and assume you're at 75% but actually you're at 55% because of scope creep and admin overhead
- Client profitability looks fine on a per-engagement basis but the breakdown by client across the year shows that 2 of 6 clients account for 90% of profit
- Expense reimbursements get lost — you eat $2k/year of client expenses you forgot to invoice
- Pipeline is a guess because deal-stage updates live in your inbox, not in a structured tracker
- Retainer vs T&E decisions are made by gut feel instead of running the math on each opportunity
What this replaces, in dollars
| Tool | $/mo | Replaced by |
|---|---|---|
| Mavenlink / Kantata Essentials | $30 | Utilization tracker + client profitability dashboard |
| Replicon TimeBill | $25 | Time log + invoice generator sheets |
| Bonsai or HoneyBook Pro | $39 | Pipeline + contract tracker |
| Expensify Submitter | $5 | Expense reimbursement log |
| Notion Plus (used for client docs) | $10 | Google Docs + Sheets |
| QuickBooks Self-Employed | $30 | Income/expense ledger |
| Total | $139/mo | ~$1,668/year |
Realistic — not every consultants pays for every tool on this list. Pick the rows that match what you actually pay for.
Templates for consultants
Freelancer Financial Hub
All-in-one financial management for freelancers, income tracking, expense categorization, quarterly tax estimates, and client profitability.
12-Week Year Planner
Compress annual goals into 12-week sprints with weekly scorecards, progress dashboards, and end-of-cycle reviews.
Marketing Campaign Dashboard
Track multi-channel marketing campaigns, Google Ads, Meta Ads, email, and organic, with ROAS, CPA, and A/B test logging.
Functions you will use weekly
Comparisons for consultants
Google Sheets vs Excel
Pick Google Sheets if you collaborate with anyone (live multiplayer is unmatched) or you want free with no install. Pick Excel if you work w...
Google Sheets vs Airtable
Pick Google Sheets for calculations, free unlimited use, and powerful formulas. Pick Airtable when your data is relational (records that lin...
Frequently Asked Questions
What utilization rate should I target as a solo consultant?
Industry benchmarks: 65-75% billable utilization is healthy for a solo consultant. Below 50% means you're underselling or under-marketing; above 80% sustained means you have no time for business development and revenue will plateau. The utilization sheet should compute weekly utilization automatically from a time log.
How do I track client profitability accurately?
Revenue minus the fully-loaded cost of serving that client (your billable hours × your target rate as a proxy for true cost, plus reimbursable expenses minus invoiced reimbursements, plus an allocation of unbilled BD time spent on that account). Most consultants discover that 1-2 'small' clients are unprofitable when this is computed honestly.
Retainer or T&E — how do I decide?
Run both models on the engagement's expected scope. Retainer is better when work is predictable and steady (the consultant absorbs scope-creep risk, the client gets a known cost). T&E is better when work is unpredictable or front-loaded (the consultant captures upside, the client pays for what they use). The retainer-vs-T&E sheet should let you toggle assumed monthly hours and compare side-by-side revenue.
Do I need a real PSA tool?
If you're solo and have under 10 clients, no. If you're 5-20 people with multi-month projects spanning multiple resources and clients, the coordination overhead of spreadsheets starts to exceed the cost of a real PSA. The breakpoint is usually around 8-10 active engagements simultaneously.