Consulting P&L Template

Enter your monthly revenue and expense figures from your accounting system or bank statements. For the Project Profitability sheet, enter each active engagement with its contracted value, billing type, and direct costs. You don't need to be exhaustive on day one — start with your three to five largest engagements and add smaller ones as you build the habit. The effective hourly rate calculation on that sheet is worth reviewing early: it often reveals that hourly engagements are actually billing at a lower effective rate than fixed-fee work once subcontractor time is backed out.

A consulting P&L needs to distinguish between revenue types and separate direct costs from overhead. Retainer revenue, hourly billing, and fixed-fee project work all behave differently: retainers are predictable but capped, hourly work scales with utilization, and fixed-fee projects require scope discipline to stay profitable. On the cost side, subcontractor fees are a direct cost tied to specific engagements — not an overhead expense — and treating them correctly gives you a true gross margin figure. Key metrics like billable utilization rate (the percentage of available hours actually billed to clients) and effective hourly rate (total revenue divided by total hours worked) tell you more about business health than top-line revenue alone.