Accounting Firm Pro Forma Template

Start with the Assumptions sheet — it's the foundation the entire model builds on. Enter your current staffing mix (number of partners, managers, seniors, and staff accountants), the standard billing rates for each level, and your target utilization and realization rates. If you're projecting a new practice or expansion, enter your expected headcount for each year. Most firms use historical utilization and realization as a starting point — if you don't have those numbers, the sheet includes industry benchmarks you can use until you gather your own.

Once assumptions are set, move to Revenue Projections and review the output by service line. Check that the mix between tax, audit, CAS, advisory, and payroll reflects how your firm actually earns revenue — and adjust the growth rates for each line based on your business development pipeline and strategic plan. If you're planning to launch a new service like fractional CFO work, set the year-one revenue conservatively (80% of capacity) to account for ramp-up time. The staffing capacity check on the Staffing sheet will tell you if your projected revenue targets are achievable given your current team.

Use the Pro Forma P&L and KPI Dashboard to pressure-test the projection. Compare your projected gross margin against the 50–65% range typical for accounting firms and your projected net margin against the 20–35% range. If the numbers look too good — say, 40% net margin in year one — check your expense assumptions, especially whether owner compensation is fully reflected. The real value of the pro forma isn't the final number; it's running scenarios. Change the utilization rate by 5 points, add a hire in year two, or model a 10% rate increase, and see what moves the margin most.

Accounting firms have a fundamentally different financial structure than most businesses. Revenue is bounded by the number of hours a team can bill, not by inventory, production capacity, or marketing spend. That makes headcount planning and utilization the central drivers of the financial model — and it's why generic pro forma templates don't work well for CPA firms. A model built for a restaurant or retail business doesn't account for billable capacity ceilings, realization haircuts, or the practice-specific relationship between staff level and rate.

The metrics that determine a firm's profitability are layered. First, how many available hours does your team have? That depends on headcount and the typical number of working hours (firms commonly assume 1,800–2,000 available hours per year per person). Second, what percentage of those hours are billable — your utilization rate? Well-run firms target 60–75% for most staff levels; partners typically run lower due to business development and management time. Third, how much of the standard rate value actually gets billed? Realization rates at healthy firms run 85–95%. Finally, how much of what's billed actually gets collected? Collection rates below 95% indicate write-off problems that compound over time. The pro forma models all four layers simultaneously.

Firms typically need a pro forma in three situations: planning a new service line or office location, evaluating the economics of a merger or lateral hire, or seeking a bank line of credit. In each case, the lender, partner, or counterparty wants to see the same things — that the revenue projections are grounded in real capacity, that expenses are realistic and fully loaded, and that the firm can sustain its obligations even in a downside scenario. Running the model with a 10–15% utilization haircut (a stress test) and showing it still covers debt service and owner draws gives any outside party confidence that the projection is serious, not aspirational.