Consulting 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 categories. Most consulting firms keep the core structure and adjust a handful of line items to match their specific billing model — for instance, splitting retainer revenue by client tier, adding a line for training or workshop revenue, or breaking out subcontractor costs by project type.

Once the categories match your business, enter revenue and expenses for the current month. If you don't track project costs in real time, pull your bank statements, contractor invoices, and billing records and work through each category. The Project Profitability sheet is where you'll spend the most setup time — enter each active engagement, its billed revenue, and direct costs. Everything rolls up to gross profit and net income in the main monthly sheet automatically. Copy the monthly structure forward and fill it in as the year progresses.

The income statement becomes most useful when you check it consistently. Come back at month-end, enter your actuals, and verify that your gross margin is holding in your target range. Every quarter, review the Project Profitability sheet to see which clients and engagement types are generating the strongest returns. Consulting firms that track income statements over time are far better positioned to spot the moment subcontractor costs start compressing margins — or to identify which billing model (hourly vs. fixed-fee vs. retainer) is actually most profitable for their specific practice.

Consulting income statements look deceptively simple on the surface — you bill clients, pay contractors, and keep the rest — but the structure that actually drives profitability is more nuanced than that. Consulting revenue is lumpy and delayed: projects close in Q4, work starts in Q1, and invoices go out 30–60 days later. Retainer clients provide predictable monthly cash flow, but fixed-fee projects introduce risk if scope expands without a corresponding fee adjustment. Without a proper income statement that separates these revenue streams, it's very easy to confuse revenue growth with margin improvement — and to miss the moment when subcontractor costs or business development spending starts quietly compressing net income.

The two numbers that matter most in a consulting income statement are gross margin and net margin. Gross margin — revenue minus direct cost of services like subcontractor fees, direct project expenses, and billable travel — should typically fall between 50% and 80% depending on how much of the work you deliver yourself versus sub out. Solo consultants who do all their own work often run gross margins above 80%; firms that rely heavily on subcontractors or junior staff will run lower, typically 50–65%. Net margin, after all operating expenses, typically lands between 20% and 40% for a well-run firm. If your net margin is consistently below 15%, it usually means either that your billing rates are too low or that overhead — software, marketing, and administrative costs — has scaled faster than revenue.

The project profitability sheet is where the income statement becomes an operational tool rather than just a financial record. Firm-level gross margin tells you the average, but it hides the spread — a few highly profitable retainer clients often subsidize several break-even project engagements. Tracking gross margin by project lets you see which client relationships and engagement types are actually worth growing, which need repricing, and which to walk away from the next time they come up for renewal. Consulting firms that review project-level profitability quarterly make systematically better decisions about where to invest their business development time and which services to productize or promote.