Fee Versus · workbook
Fee vs Hours
Project profitability for solo consultants — the fee you agreed versus the hours you actually worked, against a target rate, while the project is still open.
USD 24 · Excel workbook (opens in Google Sheets) + optional Notion CSV pack · instant digital download · no macros · single-user licence
Opens the Gumroad checkout for Fee vs Hours. USD 24.
The problem
You agreed a fixed fee, or a monthly retainer, and the work felt fine at the time. A few extra calls, a third revision, a subcontractor you absorbed. When you finally divide the fee by the hours, the rate is not the one you meant to earn — and you only see that after the invoice has gone.
What the file tells you on Friday
- The effective rate of every project: (agreed fee − costs you absorb) ÷ all hours logged.
- Whether that rate is above or below the target you set once in Settings.
- A health flag that does not flatter work-in-progress: Underwater, Below target rate, Over hours, Hours running tight, or On track.
- If you type % complete, expected hours and expected effective rate at completion. If you leave it blank, the file will not invent a percentage.
- A Dashboard list of the projects that need a look — not a wall of charts.
What’s inside
- Start here — definitions, a 10-minute setup, and what this is not.
- Settings — practice name, currency label, target effective rate, hours-tight warning.
- Rate card — you (and an optional associate), with a bill rate and an optional cost rate.
- Projects — gold input columns, grey formulas, dropdowns for type and status.
- Time log and Expenses — including reimbursable versus absorbed costs. Reimbursable amounts do not reduce the effective rate.
- Dashboard — tiles, a Friday list, and an effective-rate chart versus target.
- Sample data for a fictional practice, North & Tide Advisory, so the flags light up before you type a thing.
- A Google Sheets opening guide, and a Notion CSV pack with a manual import guide. Notion relations are not automatic; the workbook is the source of truth for the arithmetic.
Who it is for
Independent consultants, specialists, and freelancers who sell fixed-fee, retainer, or hourly / day-rate work and will log hours once a week.
Who it is not for
- Anyone looking for a full CRM, proposal studio, or accounting system.
- Teams that need utilisation across a large bench (a second person fits; a department does not).
- People who want a legally binding invoice or a tax return. This is not that.
How you use it
- Set your target effective rate.
- Add a project and its agreed fee and budget hours.
- Log time and expenses against the Project ID.
- On Friday, open the Dashboard. If a live project is below target or over hours, raise a change order, stop unpaid extras, or accept the lower rate with your eyes open.
What’s not in version 1 (on purpose)
Invoice layouts and aging, a quoting calculator, a lead pipeline, a retainer hours bank, and a change-order log. This file stays on fee versus hours so the arithmetic stays honest and the setup stays short.
Licence and disclaimer
Single practitioner. You may copy the file for your own backup and for use in Excel or Google Sheets. You may not resell, republish, or share the file as a template.
Fee vs Hours is an organising and arithmetic tool. It is not tax, legal, accounting, or financial advice, and it is not a substitute for a bookkeeper, accountant, or lawyer. Check every figure before you quote, invoice, or file anything. Currency is a label only.
Opens the Gumroad checkout for Fee vs Hours. USD 24.