Service-Line Gross Margin: Reconcile the Classification First

To compare service-line gross margins, reconcile each line's revenue and delivery costs to the same closed general ledger. Split mixed invoices, trace shared delivery labor, and display unassigned costs before ranking the services. A tidy percentage can conceal missing classifications even when the company-wide books balance.

This is a management worksheet for an established service business, not a universal GAAP presentation or tax accounting policy. Agree on the cost-of-services definition with your accountant. Our profit-margin formula guide explains the broader measures; this review establishes whether the service-level inputs deserve comparison.

Define the service before sorting transactions

Write a short mapping rule for each service line, with examples and exceptions. Use the work delivered rather than the customer's name: one customer can buy installation and recurring maintenance on the same invoice. Keep invoice number, line number, job reference, service code, net amount, and posting period in the export.

Split mixed invoices using supported line detail. If a bundle lacks separate prices, document a reasonable management allocation supported by the agreement or delivery records, flag the estimate, and have the accountant review any revenue-recognition implications separately. Do not force an unsupported split merely to finish the report.

Use the posted revenue basis consistently, including credits and adjustments. A deposit, invoice, completed job, and receipt need not belong to the same reporting period. Reconcile the worksheet to recognized revenue in the selected ledger report; a classification exercise does not authorize changing recognition timing.

Keep the cost pool complete

The SEC's financial-statement guide describes gross profit as net revenue less cost of sales, before remaining operating expenses. For this worksheet, name the specific accounts included in cost of services and preserve that definition across both lines and comparison periods.

Trace materials, subcontractors, and delivery payroll to jobs where records support it. Include the employer costs specified in the policy, such as related payroll taxes and benefits. Keep general administration outside this defined pool and reconcile it separately. These choices need professional review for the business's reporting requirements.

For shared technicians, reconcile paid time and payroll cost before allocating the delivery portion. Record service time, travel, training, leave, and other time separately under the agreed policy. Allocate shared delivery costs using supported hours or another documented driver; revenue share can distort a labor-heavy service. A standard hourly cost requires a separate reconciliation for payroll differences and unapplied cost.

Original hypothetical: two services, one ledger

All figures are invented, not client results or industry benchmarks. Assume a closed accrual month for an established equipment-service business. Its ledger contains $120,000 net service revenue, $72,000 cost of services, and $30,000 other operating expenses, including depreciation. Interest, income taxes, and other nonoperating items are excluded from this operating-profit illustration.

The $120,000 includes a $10,000 mixed invoice, supported as $7,000 installation and $3,000 maintenance. The first export assigned all $10,000 to installation, producing revenue columns of $75,000 and $45,000. Moving $3,000 to maintenance corrects them to $72,000 and $48,000; total revenue remains $120,000.

Within cost of services, $54,000 is already traced: $34,000 installation and $20,000 maintenance. A separate $16,000 shared delivery-payroll pool includes all related employer costs assumed here. Reviewed records support 240 installation hours and 160 maintenance hours from that pool. At the assumed equal loaded cost of $40 per hour, allocations are $9,600 and $6,400. Actual employees with different costs would require their own supported calculation.

Reconciled monthly management worksheet

Measure	Installation	Maintenance	Unassigned	Total
Net revenue	$72,000	$48,000	$0	$120,000
Previously traced costs	$34,000	$20,000	$0	$54,000
Shared delivery payroll	$9,600	$6,400	$0	$16,000
Unresolved delivery costs	$0	$0	$2,000	$2,000
Revenue less listed costs	$28,400	$21,600	($2,000)	$48,000

The two assigned columns show 39.44% and 45.00% before unresolved costs. Label them provisional. Adding $28,400 and $21,600 alone overstates gross profit by $2,000. The complete bridge is $120,000 − $54,000 − $16,000 − $2,000 = $48,000 gross profit, or 40%. Less $30,000 other operating expenses leaves $18,000 operating profit.

Resolve unknowns without inventing improvement

The $2,000 remains visible because its service assignment lacks support; it is already recorded as delivery cost. Assign an evidence owner and review date. If records later trace all of it to installation, that line's gross profit becomes $26,400 and margin 36.67%. Maintenance stays at $21,600 and 45%. Total gross profit remains $48,000.

Moving that same $2,000 from cost of services into operating expenses instead would display $50,000 gross profit and $32,000 operating expenses, still leaving $18,000 operating profit. That is a presentation change, not improved economics. Retain an approved mapping bridge and a comparable prior-period view when classifications change.

Unassigned does not mean immaterial. If evidence could materially reverse a service decision, defer the ranking or show a range. Do not distribute every unknown by sales just to make both columns appear complete.

Turn the reconciliation into a monthly control

Save the ledger version, classification rules, mixed-invoice splits, labor support, unresolved list, and reviewer signoff. Recalculate totals after corrections and check that each transaction appears once. The IRS supporting-records guidance identifies invoices, paid bills, receipts, and payroll documents as support for book entries; it does not prescribe this service allocation method.

Then investigate service mix, rework, or delivery efficiency using comparable records. Before changing prices, use our price-and-retained-volume test: allocated delivery costs are not automatically avoidable costs. TaxBowl's bookkeeping services can help connect the transaction trail to a repeatable service-line review.

The accompanying Accounting Stuff tutorial explains the gross-profit-margin formula and general financial-statement comparisons. It does not prescribe service-line allocations or cost classifications. A move from 45% to 50% is five percentage points; compare consistent accounting policies before interpreting a change.