Accounting Firm Income Statement Template

Getting started takes about 15 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Monthly Income Statement sheet and review the pre-loaded revenue and expense line items. Most accounting firms keep the core service line structure and adjust a few categories to match their specific practice mix — for instance, splitting tax revenue between individual and business returns, adding a line for state and local tax consulting, or breaking out CAS clients by tier.

Once the categories match your practice, enter revenue and expenses for the current month. If you track time in a practice management system, pull your billed revenue report by service line and your WIP report for unbilled work. Enter staff and subcontractor costs from your payroll records, and operating expenses from your bank and credit card statements. The Service Line Profitability sheet is where you'll spend the most initial setup time — enter each service line's billed revenue and allocated hours so the realization rate and effective hourly rate calculations give you meaningful data from month one.

The income statement becomes most useful when you check it at the end of each month and after each major filing deadline. Coming back in May — after the April 15 crunch — to compare busy-season revenue and margin against your plan will tell you quickly whether your billing rates held, whether overtime and subcontractor costs compressed profitability, and whether CAS and advisory revenue is growing to offset the inherent lumpiness of tax season. Firms that track income statements consistently year over year are far better positioned to make confident decisions about hiring, partner compensation, and which service lines to invest in next.

Accounting firm income statements are more nuanced than they appear because revenue doesn't move in a straight line. Tax season concentrates a large share of annual revenue into four months, while audit and advisory engagements spread more evenly across the calendar. CAS clients generate predictable monthly recurring revenue, but at lower billing rates than compliance work. Without a proper income statement that separates these revenue streams, it's easy to confuse a strong April with a strong business — and to miss the fact that net margin is quietly compressing as staff salaries and technology costs grow faster than average billing rates.

The two numbers that matter most in an accounting firm income statement are gross margin and realization rate. Gross margin — revenue minus direct cost of services including professional staff time, subcontractors, and direct client costs — typically falls between 50% and 65% for established CPA practices. Realization rate measures how much of your standard billing rate you actually collect: if your staff bills 100 hours at $200/hour but you invoice only $18,000, your realization rate is 90%. Most healthy firms target realization rates above 85%; rates consistently below 75% usually signal that fixed-fee engagements are being underpriced or that write-downs are masking scope creep. Net margins of 20–35% are typical, with boutique tax practices often running higher and audit-heavy firms running lower due to compliance overhead.

The service line profitability sheet is where the income statement becomes a strategic tool rather than just a financial record. Firm-level gross margin tells you the average, but it hides the fact that your CAS practice might run 60% gross margins while a time-consuming audit engagement barely clears 30% after partner time and administrative overhead. Tracking profitability by service line each year lets you price engagements more accurately, identify which services deserve a rate increase, and have a data-backed answer to the question partners ask every year: should we grow the tax practice, expand advisory, or push harder into CAS? The firms that answer that question with income statement data make better decisions than those that answer it with intuition.