What Your Margins Are Hiding

Professional services firms track project margins by dividing project revenue by fully-loaded labor cost at the project level — hours billed multiplied by fully-burdened employee cost rates. QuickBooks Online and Xero do not produce this number natively. Those systems report profit and loss by income category, not by project, client, or employee. The result is a reporting gap: the P&L tells you the firm made money, but cannot tell you which engagements drove it. Closing that gap requires connecting timesheet data (hours per project per employee) to payroll data (burdened cost per hour) and billing data (invoiced revenue per project). For 15–100 person services firms without a Controller or PSA platform, the most practical approach is a weekly operations report that aggregates these three data sources and outputs five metrics: billable utilization rate, project gross margin, client revenue concentration, employee margin variance, and effective billing rate.

Your P&L tells you the score. Not the game.

Most services firm owners close the month, look at the P&L, see a number, and move on. The business is up or down from last month. Gross profit looks reasonable. Expenses are roughly where they should be.

None of that tells you which clients are profitable. None of it tells you which projects are bleeding margin. None of it tells you whether the team is 60% utilized or 85% utilized this week — or whether the gap between those numbers is $400,000 in annual revenue you left on the table.

"The owner can't answer 'which projects make money?' without a two-hour spreadsheet exercise that's already two weeks out of date by the time it's done."

The problem isn't laziness. It's tooling. QuickBooks was built for tax compliance and cash management. Excel timesheets weren't built to connect to cost data. Payroll systems don't know what project each hour belonged to. These three data sources sit in three different places, and without something to bridge them, project-level margin is invisible.

QuickBooks / Xero

P&L by income category

Shows total revenue and gross profit. No project attribution. No client-level margin. No labor cost per engagement.

Can't answer: which projects made money?
Excel Timesheets

Hours logged, not connected

Records who worked what hours. Not connected to cost rates. Not connected to project revenue. A spreadsheet, not a system.

Can't answer: what did those hours cost?
Payroll / Gusto / ADP

Labor cost without context

Has total payroll cost. No project dimension. No utilization calculation. Doesn't know whether those hours were billable.

Can't answer: which hours drove gross margin?

What margin visibility actually looks like

Margin visibility isn't a dashboard. It isn't a new accounting system. It's a structured weekly report that connects your three existing data sources and surfaces the numbers your current tools can't show you.

The Weekly ProServ Operations Report is organized into six sections. Each section answers one question the P&L cannot answer. The report drops every Monday and covers the prior week, with a 13-week rolling trend so you can see whether performance is improving or deteriorating — not just what happened this week.

Weekly ProServ Operations Report Structure Overview
01
Executive Pulse

One-paragraph summary of the week's key movements. Utilization delta, margin shifts, alerts that need attention. No charts — just the three things you actually need to act on.

02
Project Gross Margin Table

Margin by project, sorted by revenue. Shows billed revenue, fully-loaded labor cost, and gross margin percentage for every active engagement. Flagged in red where margin falls below threshold.

03
Utilization & Capacity

Team-level and individual utilization rates for the week. Billable vs. non-billable breakdown. Bench hours by person. Rolling 13-week utilization trend.

04
Client Concentration Analysis

Revenue distribution across your client book. Flags any client above a concentration threshold. Trend showing whether concentration is increasing or decreasing.

05
Employee Margin Variance

Effective billing rate and margin contribution by employee. Shows who delivers above-average margin work and where performance diverges from expectations.

06
Alerts & Recommended Actions

Specific, prioritized actions based on the week's data. Not generic advice — based on your firm's actual numbers and how they compare to the prior 13 weeks.

The report requires no migration, no new accounting system, and no Controller. It reads from your existing QuickBooks or Xero export, your timesheet data, and your payroll burden rates. Setup takes one session. The first report arrives the following Monday.

The five numbers that tell you how your firm is actually performing

Not every metric matters equally. These five are the ones that, together, give you a complete operational picture of a professional services firm. If you can see all five, you can run the business. If you can only see your P&L, you're managing with half the data.

Billable Utilization Rate 01

Billable utilization is the percentage of available employee hours that were spent on billable client work in a given period. A 65% utilization rate means 35% of your paid capacity produced no revenue. For a 30-person firm, that's roughly 18 people's worth of hours per year sitting on the bench, in internal meetings, or on non-billable work. The industry benchmark for healthy services firms is 70–80%. Below 65%, you're paying for capacity you're not converting. Above 85%, you're at burnout risk and cannot absorb new work without hiring. Utilization is the single fastest lever on firm profitability because it requires no new clients, no price increases, and no new headcount — just better scheduling of the capacity you already have.

Industry benchmark: 70–80% for healthy services firms
Project Gross Margin 02

Project gross margin is revenue minus fully-loaded labor cost for a specific engagement, expressed as a percentage of revenue. "Fully loaded" means salary plus benefits plus payroll taxes plus any direct project expenses — not just base salary. Firms that calculate margin on base salary only overstate it by 20–35%. The reason this metric matters is that total gross margin on the P&L is an average across all projects, and averages conceal distribution. A firm with 45% gross margin might have three projects at 60% margin and two at 10% — the P&L looks fine, but two engagements are destroying value while three subsidize them. Project-level margin tells you which clients to grow, which to reprice, and which to exit.

Target range: 40–55% for project-based services firms
Client Concentration 03

Client concentration measures the percentage of total revenue attributable to each client in your book. The standard risk threshold is 15%: when a single client exceeds 15% of revenue, that client's departure or budget reduction creates a material business disruption. Above 25%, you have a single point of failure. Most owners know intuitively that they're concentrated, but don't have the number in front of them every week. Concentration compounds over time — your best client grows, you staff for their work, and gradually you become operationally dependent on one relationship. Tracking it weekly means you see the trend before it becomes a structural problem, and you have the data to make a deliberate decision about whether to accept the concentration risk or diversify.

Risk threshold: any single client above 15% of revenue
Employee Margin Variance 04

Employee margin variance measures the spread in margin contribution across your team — specifically, how much each employee's billed work contributes to gross margin relative to their fully-loaded cost. High-variance teams have some employees consistently generating 55% margin and others generating 20%, often without management awareness. The sources of variance are: billing rate misalignment (employees billed at rates below their cost structure), over-servicing (more hours delivered than contracted), and project fit (senior staff doing work that should be junior). Employee variance is the metric most likely to reveal structural pricing problems or scope creep that the firm has been absorbing invisibly. It is also the metric most likely to surface before it shows up in overall project margin.

Healthy range: less than ±15% variance across team
Effective Billing Rate 05

Effective billing rate is the actual revenue per hour billed, calculated by dividing total project revenue by total hours worked for that engagement. It differs from your stated billing rate because it accounts for scope creep, discounts, write-offs, and fixed-fee engagements where hours ran over. A firm with a stated rate of $200/hour might have an effective rate of $155/hour once all over-servicing is factored in. That $45 gap, multiplied by 50,000 billed hours per year, is $2.25 million in revenue delivered but not captured. Effective billing rate by project tells you where your pricing model is working and where it's eroding. It is the clearest diagnostic for whether to reprice, restructure scope language, or exit certain types of engagements entirely.

Key signal: effective rate vs. stated rate gap above 15%

Who this is built for

ERPAIStack's Weekly ProServ Operations Report is built for one type of firm: project-based professional services businesses with 15–100 employees, generating between $1M and $100M in annual revenue, running on QuickBooks Online or Xero, billing clients by project or retainer, and operating without a full-time Controller or CFO on staff.

If that's your firm, the five metrics above are likely invisible to you right now — not because the data doesn't exist, but because nothing has connected it into a weekly view. If it isn't your firm, there are better-fit tools for your situation.

Strong Fit
15–100 employees, project-based work
Running QuickBooks Online or Xero
Billing by project, retainer, or time-and-materials
No Controller or PSA platform in place
Owner managing from P&L + gut instinct
$1M–$100M revenue, services-first model
Poor Fit
Product companies with service wrap
Firms already running NetSuite, Sage Intacct, or a PSA
Sub-10 employee firms (spreadsheets still work)
Firms without project-level timesheet data
Firms billing purely on outcome, not hours
Free

See how your firm scores on operational visibility

Eight questions. Scored across four dimensions. Benchmarked against firms your size. Takes four minutes.

Start the Free Assessment
$149

Get Your Margin Diagnostic

Upload 13 weeks of timesheet data. AI analyzes your actual project margins, utilization trends, and client concentration risk.

Upload Your Data →
Keep Reading

Related Reading