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
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
Below zero: losing money. Grey: profitable but under the 20% target.
Contract by contract, worst margin first
| Contract | Revenue | Labour | Materials | Travel | Subcon. | Margin |
|---|---|---|---|---|---|---|
| C-1142Ardley Vale Homes · Comprehensive | 48.0 | 38.9 | 6.9 | 6.3 | 2.4 | −6.5−13.5% |
| C-1167Quillan Retail Parks · PPM only | 34.7 | 17.6 | 2.1 | 15.9 | 1.8 | −2.7−7.7% |
| C-1188Sablewood Care Group · PPM + capped reactive | 69.7 | 31.5 | 5.2 | 6.5 | 29.8 | −3.3−4.8% |
| C-1109Tyneholt Leisure · PPM only | 62.9 | 32.3 | 5.6 | 4.3 | 11.3 | 9.415.0% |
| C-1100Corrin Mill Offices · PPM only | 66.3 | 30.1 | 5.2 | 5.3 | 12.7 | 13.019.6% |
| C-1163Pellingford Hotels · PPM + capped reactive | 39.3 | 18.4 | 3.7 | 2.2 | 6.1 | 9.022.8% |
| C-1138Halstow Dental Group · Comprehensive | 68.5 | 31.4 | 5.5 | 4.1 | 10.8 | 16.724.3% |
| C-1127Merewick Logistics · PPM + capped reactive | 26.9 | 12.6 | 2.3 | 2.0 | 2.4 | 7.728.5% |
| C-1156Oakhatch Business Park · PPM only | 22.3 | 10.1 | 1.7 | 1.2 | 2.7 | 6.729.9% |
| C-1121Brackenfold Schools Trust · PPM + capped reactive | 53.7 | 20.6 | 3.4 | 3.6 | 8.7 | 17.432.4% |
| C-1175Wrayside Distribution · PPM + capped reactive | 69.8 | 28.1 | 4.3 | 3.9 | 10.4 | 23.032.9% |
| C-1148Fenmoor Self Storage · PPM only | 22.5 | 8.8 | 1.5 | 1.3 | 3.3 | 7.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
- 05:40Read contracts, fees and renewal dates (CRM)12 live contractsSynced
- 05:41Read visits, timesheets and mileage (job system)7,784 labour hoursSynced
- 05:42Read bills, POs and sales invoices (accounts)Coded to contract refSynced
- 05:43Cost each contract and rank by margin3 below zeroDone
- 05:43Draft renewal price at target margin3 draftsFor review
- 05:44Send pack to contracts manager and FD1 emailDelivered
- 05:44Change any contract priceOff: a person approvesSkipped
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.