Blog · Finance metrics and formulas · Finance and FP&A teams
Profit per employee divides a defined profit measure by average staffing. Work through gross and net profit per FTE, reconcile the company total and separate staffing changes from margin changes.
Profit per employee is a defined profit amount divided by average employee staffing over the same period. Use average full-time equivalents, or FTE, when part-time staffing matters, and label the measure accordingly. Gross profit per FTE and net profit per FTE describe different levels of performance.
Gross profit per average FTE = Gross profit / Average FTE
Net profit per average FTE = Net profit / Average FTE
Gross profit = Net revenue - Cost of goods sold
For net profit, deduct the remaining expenses, interest and taxes included in the chosen reporting scope. The IRS's business-income guidance distinguishes the steps for figuring gross profit from those for figuring net profit or loss. The management comparison here uses an illustrative company P&L, not a tax-return calculation.
State the numerator on every table. A unit with gross profit as its numerator cannot be compared directly with one using net profit. The net profit margin guide covers the final P&L margin; this page focuses on the staffing denominator.
Use profit earned during the reporting period. A quarterly profit divided by average quarterly staffing produces dollars per FTE for that quarter. Label the period instead of presenting it as an annual productivity measure.
The finance file needs period, business unit, net revenue, cost of goods sold, operating expenses, interest and taxes. Include posted allocation lines if the unit's net profit includes shared costs. Make the mapping consistent between units and exclude internal transfers from the consolidated view where required.
The staffing file needs period, employee or assignment ID, unit, employment status and the inputs used for FTE. Use a documented management-reporting definition of FTE and retain its calculation. Do not assume a payroll or benefits eligibility definition automatically serves the same purpose.
Join the files by unit and reporting period. Do not join every employee row to every expense row and then sum profit: that duplicates the numerator. Aggregate each file to the reporting grain before combining the totals.
Keep this distinct from revenue per employee, which owns the sales-productivity comparison. Profit adds the effects of costs and margins.
An illustrative US company has the following P&L for one quarter. All shared expenses included in the comparison have already been allocated consistently. There are no unallocated central balances or consolidation adjustments in this example.
| P&L step | East (USD) | West (USD) | Company (USD) |
|---|---|---|---|
| Net revenue | 1,800,000 | 1,200,000 | 3,000,000 |
| Less: cost of goods sold | 1,080,000 | 660,000 | 1,740,000 |
| Gross profit | 720,000 | 540,000 | 1,260,000 |
| Less: operating expenses | 420,000 | 330,000 | 750,000 |
| Less: interest and income tax | 60,000 | 30,000 | 90,000 |
| Net profit | 240,000 | 180,000 | 420,000 |
For staffing, this company defines its quarterly denominator as the equal-weighted mean of three monthly average FTE figures. The monthly inputs already reflect joiners, leavers and part-time assignments within each month.
| Staffing step | East FTE | West FTE | Company FTE |
|---|---|---|---|
| First monthly average | 10 | 7 | 17 |
| Second monthly average | 12 | 8 | 20 |
| Third monthly average | 14 | 9 | 23 |
| Quarterly reporting average | 12 | 8 | 20 |
If staffing changes sharply within a period, a daily weighted average can be more informative. Pick the averaging convention before comparing performance and keep it consistent; do not silently switch between a period-end snapshot and an average.
Now divide each profit subtotal by its own average FTE:
| Measure for the quarter | East | West | Company |
|---|---|---|---|
| Gross profit per average FTE (USD) | 60,000 | 67,500 | 63,000 |
| Net profit per average FTE (USD) | 20,000 | 22,500 | 21,000 |
| Revenue per average FTE (USD) | 150,000 | 150,000 | 150,000 |
| Net profit margin | 13.33% | 15.00% | 14.00% |
Dollar results in this table are exact whole dollars; percentages round to two decimals. West has higher profit per FTE despite identical revenue per FTE. Its higher net margin explains the difference, so the staffing ratio alone does not establish a labor-efficiency gap.
The company's net profit per FTE is $420,000 divided by 20, or $21,000. Check the reverse calculation: $21,000 multiplied by 20 equals the $420,000 P&L profit.
It must also equal the FTE-weighted unit result:
Company net profit per FTE = (20,000 × 12 + 22,500 × 8) / 20 = 21,000
Do not take an unweighted average of the unit ratios. East and West have different staffing weights. Sum the profit numerators and staffing denominators, then divide.
For a spreadsheet check, place East and West net profit in B2:B3 and average FTE in C2:C3. In Excel, enter the first two formulas in D2 and D3, respectively; the third gives the company ratio:
=B2/C2
=B3/C3
=SUM(B2:B3)/SUM(C2:C3)
Microsoft documents SUM as adding the values in a range. Covirage is not affiliated with Microsoft.
If staffing is zero or missing, leave the ratio undefined and resolve the record. A unit can have allocated profit but no employees; assigning it a zero ratio would hide a scope problem.
For a narrower numerator that excludes interest and taxes, see operating income per employee. Keep that separate from net profit per FTE.
The same net profit can support a lower ratio when a company hires ahead of growth. Change only average staffing from the worked example:
| Scenario | Net profit (USD) | Average FTE | Net profit per FTE (USD) |
|---|---|---|---|
| Original quarter | 420,000 | 20 | 21,000 |
| More staffing, unchanged profit | 420,000 | 24 | 17,500 |
Average staffing increases 20.00%, while profit per FTE decreases 16.67%. This arithmetic does not show whether the additional hires were a sound investment. Review their start dates, ramp-up period and the revenue they are expected to support before drawing a conclusion.
Bring a sample of your own P&L and staffing files to Covirage: it maps the columns, and its tools compute and check gross and net profit per average FTE. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.
See Covirage for finance teams for the broader reporting context.
No. Revenue per employee measures sales relative to staffing. Profit per employee also reflects the costs deducted from sales. Two units can have identical revenue per employee and different profit per employee because their product costs or operating expenses differ.
Use the basis that fits the comparison and label it explicitly. Headcount treats each employee as one person. A documented FTE method accounts for part-time staffing. Keep the same method across units and use an average aligned with the profit period.
Yes. If the chosen profit measure is a loss and average staffing is positive, the ratio is negative. Keep the loss visible rather than converting it to zero. Then separate operating performance from unusual costs and changes in the staffing denominator.
For an employee-only measure, keep contractors outside employee staffing and disclose the limitation. For a broader workforce comparison, define a consistent contractor-equivalent denominator and use it across periods. Do not add contractor hours to only one unit's denominator without relabeling the comparison.