Law 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: review the pre-loaded revenue and expense categories and adjust them to match your firm's billing structure and chart of accounts. Most firms keep the standard categories and add a few practice-area-specific line items. If your firm uses a different billing mix — for example, all flat fees with no contingency work — simply delete the rows that don't apply.

Once the structure looks right, enter your revenue and expense figures for the current month. If you track billing in practice management software like Clio, MyCase, or PracticePanther, export a monthly summary and use it as your source. For the Realization and Collection sheet, you'll need your billed amounts and collected amounts by attorney — most billing systems can generate this report. The Practice Area P&L works best once you have a few months of data, so it can show you meaningful margin differences across your practice groups.

The income statement becomes a real management tool when you run it monthly and compare results over time. Managing partners who review it quarterly tend to spot problems — a practice area running thin margins, attorney utilization declining, or overhead creeping up — early enough to act. Many firms also use the Dashboard sheet in partner meetings to walk through firm health without getting into row-by-row detail. Once the template is set up for your firm's structure, the monthly update typically takes under 30 minutes.

Law firms generate revenue in ways most income statement templates don't anticipate. Hourly billing, flat fees, monthly retainers, and contingency recoveries each have different timing, predictability, and margin profiles. A generic income statement lumps all of this into a single revenue line, which makes it impossible to see which billing model is actually driving profitability. For most small and mid-size firms, retainer revenue is the most stable, flat fee matters vary widely by complexity, and contingency fees are lumpy — large when they hit, absent in slow litigation years. Breaking these out separately gives you a more accurate picture of where income is coming from and how predictable next quarter looks.

On the cost side, law firms operate with a two-tier structure that matters for income statement analysis. Direct costs — attorney time and paralegal work attributable to client matters — scale with revenue and show up in gross profit. Operating expenses — malpractice insurance, Westlaw and LexisNexis subscriptions, office rent, bar dues, CLE, and administrative staff — are relatively fixed and compress net margins when revenue dips. Well-run firms target gross margins of 40–60% and net margins of 15–35%, but those numbers vary significantly by firm size, practice area mix, and whether partners draw salary or distributions. Tracking both gross and net margin separately is the only way to see which cost tier is causing margin pressure.

The most important financial insight law firms miss without a structured income statement is the difference between billed revenue and collected revenue. Attorneys can bill productively all month, but if realization rates are low (partners discounting bills) or collection rates lag (clients slow to pay), the income statement tells a different story than the billing reports. This template is designed to surface both numbers — what you earned and what you collected — so managing partners can identify whether a profitability problem is a billing problem, a collections problem, or a cost problem. That distinction changes the management response entirely.