Report templates

Maintenance contract profitability, contract by contract

A portfolio margin that looks fine can hide maintenance contracts that lose money every month. This template sets each contract's earned revenue against its own labour, materials, travel and subcontract cost, so you can see which agreements pay for themselves, which don't, and why, before the renewal date.

By Simon DuttonLast reviewed

Why a healthy portfolio can hide losing contracts

Most maintenance contractors know their overall gross margin. Far fewer can say, contract by contract, which agreements paid for themselves last year. The annual figure blends everything together, so one contract that loses £6,000 sits quietly inside twenty that each make a little, and nobody notices until a site manager complains that "Ardley always runs us ragged".

The losses are rarely dramatic. They build up in three places that a fixed annual fee does not watch:

  • Reactive work absorbed in the fee. Comprehensive cover promises call-outs at no extra charge. If the customer's equipment is old, those call-outs can outnumber the planned visits.
  • Travel. A contract priced per visit for sites that turn out to be an hour apart pays for engineer time on the road that never appears on a job sheet as work.
  • Renewal uplifts set by habit. A flat 2% or 3% rise each year looks reasonable until a subcontractor or a parts supplier puts their prices up by much more.

A contract profitability report sets each contract's earned revenue against its own direct costs, ranks them, and says why the bottom of the list is at the bottom. It is a decision tool for renewals: reprice, change the scope, or walk away.

What the report has to pull together

No single system holds the answer. The contract value usually lives in a CRM or contract register, the labour and visits in the job management system, and the materials, subcontract bills and sales invoices in the accounts.

Fields by source

Source Record Fields used
CRM or contract register Contract contract ref, customer, sites covered, cover type (PPM only, capped reactive, comprehensive), annual fee, start date, renewal date, last uplift %
Job system Job or visit job ref, contract ref, site, job type (planned, reactive in scope, reactive chargeable), completed date
Job system or timesheets Time entry engineer, job ref, hours on site, travel hours, mileage
Accounts Supplier bill line supplier, amount, PO or job ref, contract code
Accounts Sales invoice line contract ref, amount, period covered (fee) or job ref (chargeable extra)
Payroll or finance Cost rate loaded hourly cost per engineer grade, cost per mile

The field that does most of the work is the contract ref on every job. If reactive call-outs are logged without it, they float free of any contract and the contract that caused them looks cheaper than it is.

The joins

From To Key Notes
Job Contract contract ref Fall back to site → contract only when a site sits under one contract
Time entry Job job ref Travel on a multi-site run is split across the jobs on that run
Supplier bill line Job or contract PO number or job ref Bills with neither go to an "unassigned" bucket for a person to code
Sales invoice line Contract contract ref Extras matched by job ref; the fee by period covered

In Xero, a bill or invoice line can carry tracking categories; the Accounting API's LineItem object allows at most two Tracking elements per line (Xero OpenAPI specification). Some contractors use one category for the contract, which makes the bill-to-contract join much cleaner than reading references out of free text. Don't assume an invoice number in the job system matches the one in the accounts; join on contract and job references instead.

The formulas

Measure Formula
Earned revenue annual fee × (days of contract in the period ÷ 365) + chargeable extras invoiced
Labour (planned hours + in-scope reactive hours) × loaded hourly cost
Travel travel hours × loaded hourly cost + miles × cost per mile
Direct cost labour + materials + travel + subcontract
Direct margin earned revenue − direct cost
Margin % direct margin ÷ earned revenue
Reactive share in-scope reactive hours ÷ (planned + in-scope reactive hours)
Uplift gap cost growth % − fee uplift % at last renewal
Renewal fee at target direct cost ÷ (1 − target margin) − expected extras

Two choices here matter more than any formula. First, use earned revenue, not invoiced revenue: a contract billed annually in advance would otherwise look wildly profitable in the month it is invoiced and loss-making for the other eleven. Second, keep overheads out. Spreading office and management cost across contracts by revenue makes every contract look worse in the same proportion and hides the ones that differ. Compare direct margin first; argue about overhead recovery afterwards.

The report

IVP.ai / Deskless

12 months to 31 October 2026

Contract profitability · Dunmarrow Building Services (fictional)

3 of 12 maintenance contracts
lost money this year.

Each contract’s fee and billed extras set against its own labour, materials, travel and subcontract cost. Overheads are not allocated.

Contract revenue
£584,470
12 contracts, fees + extras
Direct margin
16.7%
£97,880 after direct cost
Lost on 3 contracts
−£12,481
On £152,360 of revenue
Margin on the other 9
25.5%
What the losses are hiding

Margin by contract

Direct margin percentage by contractC-1142 Ardley Vale Homes: -13.5%; C-1167 Quillan Retail Parks: -7.7%; C-1188 Sablewood Care Group: -4.8%; C-1109 Tyneholt Leisure: 15.0%; C-1100 Corrin Mill Offices: 19.6%; C-1163 Pellingford Hotels: 22.8%; C-1138 Halstow Dental Group: 24.3%; C-1127 Merewick Logistics: 28.5%; C-1156 Oakhatch Business Park: 29.9%; C-1121 Brackenfold Schools Trust: 32.4%; C-1175 Wrayside Distribution: 32.9%; C-1148 Fenmoor Self Storage: 33.7%C-1142−13.5%C-1167−7.7%C-1188−4.8%C-110915.0%C-110019.6%C-116322.8%C-113824.3%C-112728.5%C-115629.9%C-112132.4%C-117532.9%C-114833.7%0%20% target

Below zero: losing money. Grey: profitable but under the 20% target.

Contract by contract, worst margin first

Revenue, direct cost lines and margin for each maintenance contract over 12 months
ContractRevenueLabourMaterialsTravelSubcon.Margin
C-1142Ardley Vale Homes · Comprehensive48.038.96.96.32.4−6.5−13.5%
C-1167Quillan Retail Parks · PPM only34.717.62.115.91.8−2.7−7.7%
C-1188Sablewood Care Group · PPM + capped reactive69.731.55.26.529.8−3.3−4.8%
C-1109Tyneholt Leisure · PPM only62.932.35.64.311.39.415.0%
C-1100Corrin Mill Offices · PPM only66.330.15.25.312.713.019.6%
C-1163Pellingford Hotels · PPM + capped reactive39.318.43.72.26.19.022.8%
C-1138Halstow Dental Group · Comprehensive68.531.45.54.110.816.724.3%
C-1127Merewick Logistics · PPM + capped reactive26.912.62.32.02.47.728.5%
C-1156Oakhatch Business Park · PPM only22.310.11.71.22.76.729.9%
C-1121Brackenfold Schools Trust · PPM + capped reactive53.720.63.43.68.717.432.4%
C-1175Wrayside Distribution · PPM + capped reactive69.828.14.33.910.423.032.9%
C-1148Fenmoor Self Storage · PPM only22.58.81.51.33.37.633.7%

£ thousands. Labour and travel time at a loaded £36 an hour; mileage at £0.55 a mile.

Why the three are losing money

  • C-1142 · Ardley Vale Homes

    Reactive work absorbed in the fixed fee

    131 reactive call-outs took 560 hours, 51.9% of all labour, and none of it was chargeable under comprehensive cover.

    Draft renewal fee at 20% margin: £68,100 (+41.9%). For review

  • C-1167 · Quillan Retail Parks

    Travel cost out of line with contract value

    9 sites spread across the region: 252 hours and 12,400 miles on the road cost £15,892, 45.8% of the contract’s revenue.

    Draft renewal fee at 20% margin: £43,500 (+38.1%). For review

  • C-1188 · Sablewood Care Group

    Renewal uplift below cost growth

    The fee rose 2.0% at renewal while direct cost rose 19.3%, mostly specialist subcontract, up from £19,400 to £29,800.

    Draft renewal fee at 20% margin: £85,850 (+33.6%). For review

Deskless monthly run · log

CRM + job system + accounts

  1. 05:40Read contracts, fees and renewal dates (CRM)12 live contractsSynced
  2. 05:41Read visits, timesheets and mileage (job system)7,784 labour hoursSynced
  3. 05:42Read bills, POs and sales invoices (accounts)Coded to contract refSynced
  4. 05:43Cost each contract and rank by margin3 below zeroDone
  5. 05:43Draft renewal price at target margin3 draftsFor review
  6. 05:44Send pack to contracts manager and FD1 emailDelivered
  7. 05:44Change any contract priceOff: a person approvesSkipped

Direct margin = (fee + billed extras) − (labour + materials + travel + subcontract)

Illustrative data

Illustrative, fictional data. Company, customers, contracts and costs are invented; not customer results or a live product screenshot.

Read the chart from the bottom of the ranking up. Anything below zero lost money before a pound of overhead was charged to it. Anything between zero and your target margin is worth a look at renewal, but it is not the emergency.

Worked example (illustrative, fictional)

Dunmarrow Building Services is an invented contractor with 12 maintenance contracts. The figures cover the 12 months to 31 October 2026. Labour and travel time are costed at a loaded £36 an hour and mileage at £0.55 a mile; both are assumptions for the example, not benchmarks.

Across the portfolio, earned revenue is £584,470 and direct cost £486,590, a direct margin of £97,880 or 16.7%. That looks acceptable. Three contracts tell a different story:

Contract Cover Revenue Labour Materials Travel Subcontract Direct cost Margin
C-1142 Ardley Vale Homes Comprehensive £48,000 £38,880 £6,900 £6,300 £2,400 £54,480 −£6,480 (−13.5%)
C-1167 Quillan Retail Parks PPM only £34,700 £17,568 £2,100 £15,892 £1,800 £37,360 −£2,660 (−7.7%)
C-1188 Sablewood Care Group PPM + capped reactive £69,660 £31,536 £5,200 £6,465 £29,800 £73,001 −£3,341 (−4.8%)

Together they lost £12,481 on £152,360 of revenue. The other nine contracts made £110,361 on £432,110, a 25.5% direct margin. The losses pull the portfolio figure down by almost nine points.

C-1142: call-outs inside a fixed fee

Ardley Vale Homes pays £48,000 a year for comprehensive cover across 14 sites. Planned maintenance took 520 hours. In-scope reactive work took another 560 hours over 131 call-outs, so reactive work was 51.9% of all labour on the contract.

  • Labour: (520 + 560) × £36 = £38,880
  • Travel: 120 × £36 + 3,600 × £0.55 = £4,320 + £1,980 = £6,300
  • Direct cost: £38,880 + £6,900 + £6,300 + £2,400 = £54,480
  • Margin: £48,000 − £54,480 = −£6,480, or −13.5%

Take the reactive labour out (560 × £36 = £20,160) and the same contract would have cost £34,320 and made £13,680, a 28.5% margin. The planned work is priced well; the cover is not. Each call-out cost about £154 in labour alone. Holding a 20% margin on this year's cost would need a fee of £54,480 ÷ 0.8 = £68,100, a 41.9% rise, which is why the realistic options are moving to capped reactive cover or charging call-outs over an agreed number.

C-1167: the road between the sites

Quillan Retail Parks is a PPM-only contract across nine sites. The work on site is ordinary: 488 hours. The travel is not: 252 hours on the road (£9,072) and 12,400 miles (£6,820), so £15,892 of travel against £34,700 of revenue, 45.8%. For every hour on site an engineer spent more than half an hour driving. The fix is routing (visit neighbouring sites on the same day) or a fee that prices distance; a 20% margin at this year's cost means £43,500, up 38.1%.

C-1188: a 2% uplift on a 19% cost rise

Sablewood Care Group renewed with a 2.0% uplift, from £63,000 to £64,260. Direct cost rose from £61,200 to £73,001, 19.3%. Almost all of that is specialist subcontract, up from £19,400 to £29,800. Every other cost line together rose by 3.4%. Had the fee risen in line with cost, it would be about £75,150. Nothing here was visible on the job sheets: the visits were done, on time, by the right people. Only the bills showed it.

Running it monthly, deciding at renewal

A once-a-year exercise finds the problem after the renewal letter has gone out. Run monthly on a rolling 12 months, the report gives the contracts team three months' warning before each renewal date, and the reactive and travel trends show up while there is still time to talk to the customer.

Keep the decisions with people. A contract that loses money might still be worth keeping: it may be the foothold on a large estate, or the loss may come from a one-off fault that has now been fixed. The report should say how much a contract lost and why. A person decides what to do about it. The same report also feeds the field service KPIs pack and sits alongside engineer utilisation, which explains where labour hours went, and the PPM compliance report, which checks that planned visits were done. If your visit frequencies come from SFG20, the maintenance standard developed by BESA and published by SFG20 Ltd (sfg20.co.uk), the planned hours on each contract should trace back to that schedule. For margin at the level of individual jobs in Simpro, see the Simpro integration page.

How to automate it with IVP.ai and Deskless

The IVP.ai Data Layer brings contracts from your CRM, jobs and time from your job system, and bills and invoices from your accounts into one governed model. It keeps the contract ref attached to every job, time entry and bill line, and sends anything it can't assign to an "unassigned" list for a person to code rather than guessing.

A Deskless by IVP.ai agent then runs the report each month, ranks every contract by direct margin, and flags the ones with high reactive share, high travel or an uplift gap. For contracts coming up for renewal it drafts a fee at your target margin and sends it to the contracts manager and finance director for review. By default it does not change a price. A national fire safety and security company used renewal agents in the same way: they priced and reported on 100+ contracts in the first live run and sent 90+ renewal invoices in one dispatch, with no price changed without a person approving it (agents that know when to stop). The other templates are on the field service reporting hub.

To see this report on your own contracts, start with the free 48-hour pilot. We connect up to three sources, typically your CRM, job system and accounts, clean the data and set one report or agent running on real data within 48 hours of read-only access. You then have 14 days of access to choose a plan or walk away.

Questions

Frequently asked questions

How do you calculate the profitability of a maintenance contract?

Take the revenue the contract earned in the period, which is the fee pro-rated for the days covered plus any chargeable extras invoiced. Subtract its direct costs: labour hours at a loaded hourly cost, materials, travel time and mileage, and subcontract bills coded to it. The result is direct margin. Divide by earned revenue for margin %, then rank contracts from worst to best.

Should overheads be allocated to each contract?

Not at first. Spreading office and management cost across contracts by revenue lowers every margin by a similar proportion, which hides the contracts that are genuinely different. Compare direct margin to find the loss-makers, then decide separately what margin each contract needs to recover overhead. Many contractors set a target direct margin that already allows for overheads.

Why do comprehensive maintenance contracts often lose money?

Because the fee is fixed but the reactive workload is not. If the customer's equipment is ageing or misused, in-scope call-outs can take as many hours as the planned visits, and none of them are chargeable. Track reactive hours as a share of all labour on each contract; when it climbs, consider capped cover or charging call-outs above an agreed number at renewal.

What renewal uplift should we apply to a maintenance contract?

Base it on the contract's own costs rather than a flat percentage. Compare how much its direct cost rose over the year with the uplift applied at the last renewal; a large gap usually comes from subcontract or parts prices. Then work out the fee needed to hit your target margin on current cost, and let a person decide how much of that the customer relationship can carry.

About the author

Simon Dutton

Simon has more than 10 years of experience as a data scientist, working with start-ups, SMEs, Google and the CMA.

Last reviewed 6 November 2026.

Your first report or agent in 48 hours.

Tell us which systems feed it. We connect them, clean the data and set the report running automatically. If it isn’t useful, walk away.