To calculate operating profit margin, divide your operating profit by your total revenue and multiply by 100. Operating profit is what your business earns from its core operations before interest and tax are deducted. For a service business, the formula is straightforward. The hard part is making sure the numbers going into it are classified correctly before you run the calculation.
Most guides stop at the formula. The problem is that service business owners often mix up delivery costs, general overheads, owner drawings, tax, and loan repayments when they pull figures from their profit and loss statement. That produces a margin figure that looks clean but is quietly misleading. You end up making pricing, hiring, and investment decisions on a number that does not reflect reality.
This guide covers:
What to include in your revenue figure
How to separate direct delivery costs from operating expenses
Which items to exclude entirely from the calculation
A worked example for a small UK service business
How to set up the calculation in Excel
The most common classification mistakes to avoid
What You Will Need Before You Start
Before you run any calculation, pull together the right source material. Using rough figures or mixing periods will undermine the result before you even reach the formula.
| What you need | Why it matters |
|---|---|
| Profit and loss statement (P&L) | The primary source for all line items in the calculation |
| Total revenue for the period | The denominator in the formula – must be net of VAT if accounts are VAT-registered |
| Direct delivery costs broken out | Needed to calculate gross profit before operating expenses |
| Operating expenses listed separately | Allows you to isolate costs tied to running the business, not delivering it |
| One consistent time period | Month, quarter, or year – mixing periods distorts the margin |
A few things to check before you start:
Make sure your bookkeeping categories are clean. If costs are lumped together under vague headings, separate them before calculating.
Use the same period for revenue and costs. Cash-basis and accrual-basis accounts can produce different figures for the same month.
If your accounts are prepared by a bookkeeper or accountant, ask for a management accounts export rather than a summary report. The line-item detail matters.
Ignore any figures from outside the chosen period, including late invoices or prepaid expenses that belong to a different month.
Step 1: Identify Your Revenue for the Period
Your revenue figure is the starting point for the entire calculation. For a service business, this means the total fees earned from delivering your core service during the chosen period, not cash received, not invoices raised for future work, and not any non-trading income that happened to land in your bank account.
Use the right revenue number. If your accounts are VAT-registered and prepared net of VAT, use the net figure. Mixing VAT-inclusive and VAT-exclusive numbers is a common bookkeeping error that inflates revenue and flatters the margin.
What to include in your revenue figure:
Fees invoiced and recognised for services delivered in the period
Retainer income earned during the period, even if invoiced monthly in advance
Project milestone payments where the work has been completed
What to exclude from your revenue figure:
VAT collected on behalf of HMRC
Deposits or advance payments for work not yet delivered
Interest received on business savings
One-off asset sales, grants, or any non-trading receipts
Revenue from a different period that has been invoiced late
If you run your accounts on an accrual basis, which most limited companies do, recognised revenue means income earned in the period regardless of when the client paid. HMRC guidance on accrual accounting is worth reviewing if you are unsure which basis applies to your business.
Step 2: Work Out Gross Profit by Separating Direct Delivery Costs
Gross profit is revenue minus the direct costs of delivering your service. This is the step where most service business owners introduce errors that carry all the way through to the final margin figure.
In a product business, direct costs are obvious: raw materials, components, manufacturing labour. In a service business, the line is blurrier, and that ambiguity is where margin reporting tends to break down.
The test to apply: a cost is a direct delivery cost if it would not exist without that specific client work or service being delivered. If the cost continues whether or not you win the project, it is more likely an operating expense.
| Usually a direct delivery cost | Usually NOT a direct delivery cost |
|---|---|
| Subcontractor fees for a specific project | Your own general admin salary |
| Freelancer costs tied to client work | Office rent and utilities |
| Delivery software licensed per client or project | General marketing spend |
| Travel costs directly attributable to a client | Accountancy and legal fees |
| Billable staff time where salaries are project-allocated | Software subscriptions for running the business |
A note on salaries in service businesses
Staff salaries are the trickiest line item. If you employ people whose time is directly and measurably allocated to client delivery, such as a fee earner at a law firm, a developer at an agency, or an adviser at a mortgage brokerage, a proportion of their salary is a direct delivery cost. If they perform general management or administrative functions, their salary belongs in operating expenses.
Getting this split right matters. Treating all payroll as overhead overstates gross profit, which makes the business look more efficient at the delivery level than it actually is. Treating all payroll as direct cost understates gross profit and may make pricing decisions harder to interpret.
Step 3: Subtract Operating Expenses to Calculate Operating Profit
Once you have gross profit, subtract your operating expenses to arrive at operating profit. Operating expenses are the costs of running the business itself, independent of any individual client or project. They are the fixed and semi-fixed costs that exist whether you are busy or quiet.
Operating profit is also referred to as EBIT, earnings before interest and taxes. It measures the profitability of your core business operations before financing costs and tax obligations are considered. This is the figure you divide by revenue to get your operating profit margin.
Common operating expenses for a UK service business include:
Rent, rates, and property-related costs
Administrative and management salaries (not allocated to delivery)
General software subscriptions such as your CRM, email platform, or project management tool
Marketing, advertising, and website costs
Insurance premiums
Utilities
Accountancy, bookkeeping, and legal fees for general business matters
Depreciation on business assets such as equipment, vehicles, or leasehold improvements
Depreciation: include it or not?
Yes, include depreciation in operating expenses. Depreciation reflects the cost of using a business asset over its useful life and is a real operating cost even though no cash leaves the business in that period. Excluding it overstates operating profit. If you are working from a management accounts export, depreciation should already appear as a line item. If it is missing, check with your accountant.
Consistency is more important than perfection. The goal is to apply the same classification rules every month so that your margin is comparable over time. A margin calculated consistently on slightly imperfect categories is far more useful as a management tool than a margin recalculated from scratch each month with different rules.
Step 4: Exclude Items That Do Not Belong in Operating Profit Margin
This step catches the items that are most frequently misplaced in a service business P&L. Including any of these in your operating profit calculation will produce a figure that is either flattering or unfairly depressed, depending on the error.
Include in operating profit:
All direct delivery costs identified in Step 2
All operating expenses identified in Step 3
Depreciation on business assets
Exclude from operating profit:
Loan interest and bank charges on business borrowing – these reflect financing decisions, not operational performance
Corporation tax or income tax – tax sits below operating profit on the income statement and is not part of core operations
Dividend payments – these are distributions of profit, not operating costs
Owner drawings in a sole trader or partnership structure – drawings are not a business expense in the same way as a salary processed through payroll
One-off exceptional items such as redundancy costs, legal settlements, or asset disposal losses, where these would distort the trend
Owner pay: the most common trap for owner-managers
If you are a director drawing a salary through PAYE, that salary is a legitimate operating expense and should be included. If you are taking money out as dividends or drawings rather than salary, those amounts do not belong in operating expenses and should not reduce your operating profit. Mixing the two is one of the most common reasons owner-managed service businesses report a margin that bears no relationship to the actual profitability of the business.
Step 5: Apply the Operating Profit Margin Formula
Once your costs are correctly classified, the calculation itself is simple.
Operating Profit Margin = (Operating Profit / Revenue) x 100
The result tells you how many pence of operating profit the business generates for every pound of revenue. A margin of 20%, for example, means the business keeps 20p of operating profit from every £1 of service fees before interest and tax.
A few things to bear in mind when interpreting the result:
A higher margin means more room to absorb financing costs, tax, reinvestment, and owner profit
A lower margin does not automatically mean the business is in trouble, but it does mean there is less buffer if costs rise or revenue dips
Operating profit margin sits between gross profit margin (which measures delivery efficiency) and net profit margin (which measures what is left after interest and tax). Each tells you something different, and they should not be conflated.
Do not chase a benchmark. Service business models vary enormously. A coaching practice with no staff and minimal overheads will naturally run at a very different margin to a solicitors firm with employed fee earners and regulatory compliance costs. The number that matters most is your own trend over time, not a comparison to a sector average you found online.
Worked Example: A Small UK Web Development Agency
Here is how the calculation works in practice for a small web development agency with three employees, a mix of project and retainer work, and one part-time subcontractor used on larger builds.
| Line item | Amount |
|---|---|
| Revenue (net of VAT) | £18,500 |
| Subcontractor fees (project-specific) | £2,200 |
| Developer salary (70% allocated to client delivery) | £2,450 |
| Gross profit | £13,850 |
| Director salary (PAYE, management role) | £3,000 |
| Office rent and utilities | £800 |
| Software subscriptions (CRM, project management) | £180 |
| Marketing and website costs | £300 |
| Accountancy fees | £250 |
| Depreciation on equipment | £120 |
| Total operating expenses | £4,650 |
| Operating profit | £9,200 |
| Operating profit margin | 49.7% |
Now consider what happens if the developer’s salary is moved entirely into operating expenses rather than being split. Gross profit rises to £16,300, operating expenses rise to £7,100, and operating profit stays at £9,200. The margin is unchanged because the total costs are the same. But gross profit margin is now overstated, which would make the delivery model look more efficient than it is and could lead to underpricing on future projects.
This is why classification matters: it does not just affect the operating margin figure. It shapes every management decision you make from the numbers.
How to Calculate Operating Profit Margin in Excel
You do not need accounting software to track this monthly. A simple spreadsheet works well, provided you keep the structure consistent.
Set up your columns as follows:
| Row | Label | Formula |
|---|---|---|
| 1 | Revenue | Enter manually from P&L |
| 2 | Direct delivery costs | Enter manually from P&L |
| 3 | Gross profit | =B1-B2 |
| 4 | Operating expenses | Enter manually from P&L |
| 5 | Operating profit | =B3-B4 |
| 6 | Operating profit margin | =B5/B1*100 |
Format row 6 as a percentage or add a % label to the adjacent cell. If you want to track multiple months, extend the columns across the sheet with one column per period, and keep row labels fixed.
A few practical tips for the Excel version:
Lock your category definitions in a notes tab so you apply the same rules each month
Add a separate tab for the direct cost versus operating expense split if salaries are partially allocated to delivery
Most accounting software, including Xero and QuickBooks, can export a P&L in spreadsheet format, which you can then map directly to this layout
The same logic applies whether you are working in Excel, Google Sheets, or a management accounts template. The tool is secondary. Consistent classification is what makes the output reliable.
Common Mistakes to Avoid
These are the errors that appear most often when service business owners calculate operating profit margin without a clear classification framework.
Confusing gross profit margin, operating profit margin, and net profit margin. They measure different things. Gross margin measures delivery efficiency. Operating margin measures overall business profitability from core operations. Net margin measures what is left after financing costs and tax. Using the wrong one for the wrong decision leads to bad conclusions.
Treating all payroll as overhead. If some staff time is directly tied to client delivery, that proportion belongs in direct costs, not operating expenses. Misclassifying it overstates gross profit and makes delivery look more profitable than it is.
Including loan interest or bank charges in operating expenses. Interest is a financing cost, not an operating one. It belongs below operating profit on the income statement.
Including tax payments as an operating cost. Corporation tax and income tax are not operating expenses. They sit below operating profit.
Mixing owner drawings with operating expenses. If you are taking drawings rather than a PAYE salary, those withdrawals are not business costs and should not reduce your operating profit.
Changing classification rules month to month. If you move a cost from direct to overhead because one month was expensive, you lose the ability to compare margins meaningfully over time.
Using cash received rather than earned revenue. A large deposit received in January for work delivered in March will inflate January’s margin and deflate March’s. Use earned revenue for the period.
Why Operating Profit Margin Matters for a Service Business
Once you have a reliable operating profit margin, it becomes one of the most useful numbers you can track monthly. Here is what it actually tells you.
Pricing health. If your margin is thinning over time without revenue falling, your costs are growing faster than your fees. That is a pricing conversation waiting to happen.
Overhead creep. A rising cost base that is not matched by rising revenue shows up quickly in the margin trend. Catching it early is far easier than managing it after the fact.
Hiring decisions. Before adding a member of staff, you can model the impact on operating profit and check whether current revenue supports the additional cost.
Subcontractor versus employee decisions. The margin helps you see the true cost of delivery and whether your current model scales profitably.
The operating profit margin is also the figure that gives context to your cash flow. A business can show strong cash flow while operating at a thin or negative margin if clients are paying in advance or if the owner is deferring drawings. The margin cuts through that and shows what the business actually earns from its operations.
Track it monthly, not annually. Annual accounts arrive too late to act on. A monthly margin calculated from your management accounts, even if approximate, gives you a live view of business performance that annual figures simply cannot provide. If you use accounting software, most platforms can generate a P&L by month with a few clicks. The Start Up Loans guide to profit margins is a useful reference point for understanding how the different margin measures relate to each other as your business grows.
Summary Checklist
Use this as a quick reference each time you run the calculation.
Pull your P&L for a single, consistent period
Identify total revenue net of VAT, using earned income rather than cash received
Separate direct delivery costs from operating expenses using the “would this cost exist without this client work?” test
Allocate any staff salaries that are directly tied to delivery into direct costs, not overhead
Subtract direct delivery costs from revenue to get gross profit
Subtract operating expenses (including depreciation) from gross profit to get operating profit
Exclude loan interest, tax payments, dividends, and owner drawings from the calculation
Apply the formula: operating profit / revenue x 100
Record the result and compare it to the previous period
Review any cost lines that have moved significantly before drawing conclusions
Your next step: open your most recent P&L and calculate your operating profit margin using the steps above. If the result surprises you, work back through the cost classification before adjusting your pricing or spending plans. Then set a reminder to run the same calculation next month, using the same categories, so the number starts to tell you something useful over time.
