Client Profitability Workbook

Revenue tells you which client pays you the most. It does not tell you which one is worth keeping.

This workbook ranks every client by what you actually keep per hour, including the hours you never billed for.

Time Log. Every hour, billable or not. The unbillable ones are the whole point — the rework, the scope discussions, the revision round you didn't charge for. They are what turns a good rate into a bad one.

Revenue and Direct Costs. Money in by client, and the costs you would not have had without that client: subcontractors, stock, print runs, travel.

Profitability. Every client in one table — revenue, direct costs, gross profit, margin, total hours, billable hours, effective dollars per hour, share of revenue, overhead allocated to them, and net profit. Ranked. Nothing here needs typing.

Setup. Enter your target hourly rate and your monthly overhead once. Overhead is then spread across clients so the net profit figure is a real one rather than gross margin wearing a disguise.

Health Check. Unassigned hours, revenue with no client attached, direct costs with no client attached, and clients with revenue but no time logged — the four ways this ranking can quietly lie to you, counted before you act on it.

Works in Excel and Google Sheets. $39 once — not a subscription. 14-day refund, no questions asked.