The decision in front of you
Somewhere around 40 or 50 engineers, the reporting stops fitting into the gaps. The operations manager spends Monday mornings rebuilding the utilisation sheet. The finance director exports invoices on the last working day of the month and pastes them next to job lists. Client KPI packs get done late, by whoever has a spare afternoon. Sooner or later somebody proposes the obvious fix: hire a reporting analyst.
That may be the right answer. But a hire is a fixed cost that keeps running for years, and much of what lands on an analyst's desk in a business like this is repeat work: the same reports, from the same systems, every week or month. Before you advertise the role, it is worth pricing both routes on the same basis. This page does that, using published UK salary data and the statutory on-costs, and shows the point at which automating the repeat work costs less than the hours it removes.
What a reporting analyst costs in the UK
Salary
The most robust UK figure is the Office for National Statistics' Annual Survey of Hours and Earnings. ASHE Table 14 breaks pay down by occupation. In the 2026 provisional edition (Table 14.7a, annual gross pay, full-time employees, UK), the occupation "Data analysts" (SOC 2020 code 3544) has:
| Measure | Annual gross pay |
|---|---|
| 25th percentile | £34,079 |
| Median | £41,247 |
| 75th percentile | £50,448 |
ASHE measures what employees are actually paid, not what job adverts offer, which makes it a fairer anchor than a job board average. There is no separate code for "reporting analyst"; data analysts is the closest occupation. A junior hire to run spreadsheets will sit nearer the 25th percentile, and someone who can also build a data model and talk to the board nearer the 75th. Location matters too, so treat the median as a starting point and type in your own figure.
On-costs
| Cost | Rule for 2026 to 2027 | Source |
|---|---|---|
| Employer National Insurance | 15% on earnings above the £5,000 a year secondary threshold | HMRC rates and thresholds |
| Employer pension | At least 3% of qualifying earnings, between £6,240 and £50,270 a year | GOV.UK workplace pensions |
| Recruitment | Median £1,500 per hire for employees below senior manager level (2022) | CIPD Resourcing and talent planning 2022 |
| Reporting tool | Power BI Pro, £10.80 per user per month, paid yearly, ex VAT | Microsoft UK pricing |
| Productive hours | 28 days' statutory leave on a 5-day week | GOV.UK holiday entitlement |
Three caveats. The Employment Allowance (£10,500 for 2026 to 2027) reduces a business's total employer NI bill, but a payroll of 50 engineers uses it up long before a new hire is added, so the analyst's NI is a real extra cost. Many employers pay pension on full salary rather than the qualifying band, which costs more than the minimum shown. And the CIPD figure is a small-sample median that the report itself says varies widely; if you recruit through an agency, its terms may look quite different, so enter your own figure.
Desk, laptop, training and management time are left out because they vary too much to estimate honestly. Add them if you know them.
The cost model
Fields
| Field | Where it comes from | Example value |
|---|---|---|
| Salary | ONS ASHE or your offer | £41,247 |
| NI threshold, NI rate | HMRC | £5,000, 15% |
| Pension band, pension rate | GOV.UK | £6,240 to £50,270, 3% |
| Licence per month | Vendor price list | £10.80 |
| Recruitment | Your agency terms or CIPD | £1,500 |
| Hours a week, leave days | Contract; statutory minimum | 37.5 (assumed), 28 |
| Report, source systems, frequency, hours per run | Your own inventory of reports | See the calculator |
| Recurring or judgement | Your call, report by report | See the calculator |
The last two rows are the inventory. Ask whoever builds each report to time one run honestly, from opening the first export to sending the file. Then mark each one: recurring (same shape every time, rules can be written down) or judgement (commentary, one-off questions, anything that needs a person to decide what matters).
The joins inside the reports
Most of the analyst's time goes on stitching systems together, so the inventory should record which joins each report relies on.
| Report needs | From | To | Join on |
|---|---|---|---|
| Revenue by contract or site | Job system | Accounts | Customer and site, plus job reference if your team types it on the invoice. Don't assume the job system's invoice number matches the one in the accounts. |
| Renewals and contract value | CRM | Job system | Customer and contract reference |
| Utilisation | Job system | Timesheets or HR list | Engineer ID |
| Debt by customer | Accounts | CRM | Customer account code |
If those keys aren't consistent across systems, an analyst spends hours each month matching them by hand, and an automated report needs the same mapping fixed once in a governed model.
Formulas
| Measure | Formula |
|---|---|
| Employer NI | 15% × (salary − £5,000) |
| Employer pension | 3% × (min(salary, £50,270) − £6,240) |
| Ongoing cost a year | salary + NI + pension + licence × 12 |
| First-year cost | ongoing cost + recruitment |
| Productive hours | (260 − 28 leave days) × 7.5 |
| Cost per hour | ongoing cost ÷ productive hours |
| Value of recurring work | recurring hours a year × cost per hour |
| Break-even hours for a plan | annual plan price ÷ cost per hour |
The calculator below runs these with current IVP.ai list prices, so you can change the salary, the recruitment cost and your weekly hours and read off the break-even for each plan.
Tolwick Fire & Electrical · 50 engineers
Reporting analyst or automation
A reporting analyst costs £47,864 a year.
Recurring reports take 668 hours of it.
ONS ASHE 2026 (provisional), data analysts, full-time.
Default is CIPD’s 2022 median for non-senior hires. Using an agency? Enter its fee.
Default is the workload below that a system could produce. 668 hours a year.
What one analyst costs
| SalaryGross, full-time | £41,247 |
|---|---|
| Employer NI15% above £5,000 | £5,437 |
| Pension, employer minimum3% of qualifying earnings | £1,050 |
| Reporting tool licencePower BI Pro, 12 months | £130 |
| Ongoing cost a year | £47,864 |
| RecruitmentOne-off | £1,500 |
| First-year cost | £49,364 |
Cost per productive hour: £27.51 (1,740 hours: 37.5-hour week, 28 days’ leave).
Break-even against IVP.ai plans
Hours of recurring reporting a plan must remove to pay for itself: annual plan price ÷ £27.51.
| Plan | A year | Break-even h/yr | h/week | Against your hours |
|---|---|---|---|---|
| Basic | £1,800 | 65 | 1.3 | Covered 10.2× |
| Team | £3,600 | 131 | 2.5 | Covered 5.1× |
| Pro | £12,000 | 436 | 8.4 | Covered 1.5× |
| Max | £24,000 | 872 | 16.8 | Below break-even |
Grey: analyst, ongoing. Gold: the recurring reporting hours at the analyst’s hourly cost. Green: plans billed annually, ex VAT.
Reporting workload today
668 h recurring · 206 h judgement
| Report | Sources | Every | h/run | h/year | Type |
|---|---|---|---|---|---|
| Engineer utilisation pack | Job system + timesheets | Weekly | 1.5 | 78 | Recurring |
| Open jobs and SLA breaches | Job system | Weekly | 2 | 104 | Recurring |
| Unbilled and part-billed jobs | Job system + accounts | Weekly | 2.5 | 130 | Recurring |
| Aged debt by customer | Accounts | Weekly | 0.5 | 26 | Recurring |
| Contract KPI packs (8 clients) | Job system + CRM | Monthly | 10.5 | 126 | Recurring |
| Management accounts reconciliation | Accounts + job system | Monthly | 8 | 96 | Recurring |
| Renewals due in 90 days | CRM + job system | Monthly | 3 | 36 | Recurring |
| Board pack | All systems | Monthly | 6 | 72 | Recurring |
| Board commentary and variance notes | People | Monthly | 5.5 | 66 | Judgement |
| Ad hoc questions from directors | Any | Weekly | 2 | 104 | Judgement |
| Tender and retender analysis | Job system + accounts | Quarterly | 9 | 36 | Judgement |
Worked example: Tolwick Fire & Electrical (illustrative, fictional)
Tolwick is an invented fire and electrical contractor with 50 engineers. Its directors are weighing up an analyst at the ONS median salary.
Cost of the hire
- Salary: £41,247.
- Employer NI: 15% × (£41,247 − £5,000) = 15% × £36,247 = £5,437.05.
- Pension: 3% × (£41,247 − £6,240) = 3% × £35,007 = £1,050.21.
- Power BI Pro: £10.80 × 12 = £129.60.
- Ongoing cost: £41,247 + £5,437.05 + £1,050.21 + £129.60 = £47,863.86 a year.
- First year, with £1,500 recruitment: £49,363.86.
- Productive hours: (260 − 28) × 7.5 = 1,740. Cost per hour: £47,863.86 ÷ 1,740 = £27.51.
What the analyst would actually do
Tolwick's inventory lists eleven reports. Eight are recurring: utilisation, open jobs and SLA breaches, unbilled jobs and aged debt every week; contract KPI packs for eight clients, a management accounts reconciliation, a renewals list and the board pack every month. Timed honestly, they take 668 hours a year, about 12.8 hours a week. The other three are judgement work: board commentary, ad hoc questions from directors and quarterly tender analysis, 206 hours a year.
- Total reporting workload: 668 + 206 = 874 hours, or 874 ÷ 1,740 = 50% of one analyst's year.
- Recurring share: 668 ÷ 1,740 = 38% of an analyst's year.
- Value of the recurring hours at the analyst's cost: 668 × £27.508 = £18,375 a year (the hourly cost is unrounded here, as in the calculator).
- Value of the judgement hours: 206 × £27.508 = £5,667 a year.
So Tolwick would be paying £47,864 a year for a role with roughly half a year of reporting work in it, most of it the repeat kind. To break even on automating that recurring work, a plan's annual price divided by £27.51 has to come to fewer than 668 hours. The calculator does that division for each current plan.
The judgement work doesn't go away. 206 hours a year is about five and a half weeks of a person's time, which is usually absorbed by the finance director or operations director who wants the answers in the first place. With the recurring reports produced automatically, that person starts from a correct table rather than a set of exports.
What automation replaces, and what it doesn't
Automation replaces the assembly: pulling the exports, matching customers and sites across systems, rebuilding the same pivot tables and sending the file. It doesn't replace someone deciding why utilisation dropped in one region, what to tell a client whose SLA slipped, or whether to bid for a retender. A good analyst spends most of their time on the second kind of work. A badly used one spends most of it on the first.
That's the useful test for your own inventory. If most of the hours are recurring, an analyst would spend the bulk of the role on work a system can do. If most are judgement, the hire is probably right, and the analyst will be far more productive starting from a clean, governed set of tables than from spreadsheets.
When hiring is still the right call
- Your directors want more analysis than they get now, not the same reports faster.
- The questions change every month, and there is no stable set of reports to automate.
- You need someone to own data quality in the source systems and train staff to enter it properly.
- Your judgement hours alone come to most of a working year.
In those cases, automate the recurring reports anyway and let the analyst work on the rest. You also avoid paying analyst rates for exports.
Automating the recurring reports with IVP.ai
The IVP.ai Data Layer connects to your job system, accounts, CRM and spreadsheets, holds the customer, site, contract and engineer mappings in one governed model, and refreshes on a schedule. If you use Uptick, the Uptick integration explains how it connects, and why Uptick's own reports run out covers the gaps people usually hit. Simpro users can read the Simpro integration page. If you are comparing a self-built Power BI estate, Power BI for field service reporting prices that route.
On top of the model, Deskless by IVP.ai runs each recurring report or agent and sends it to the people who need it. By default Deskless flags issues, drafts the output and waits for a person; it takes actions such as sending chasers only if you configure it to. A franchise using IVP.ai removed two days a week of manual reporting, and a national fire safety and security company saved 10+ hours a week by unifying HubSpot, Uptick and finance spreadsheets. More report templates are on the field service reporting hub.
To test the numbers on your own data before deciding on a hire, start with the free 48-hour pilot. We connect up to three sources, 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 see whether it removes the hours you timed, and can choose a plan or walk away.