What does care rota-to-payroll reconciliation mean?
Reconciliation is the step where you compare what the rota says happened against what the pay run is about to pay, line by line, and fix the difference before anything reaches HMRC. In a home care agency the rota holds the truth: who visited whom, when, for how long, and how far they travelled between calls. Payroll only knows what the export handed it. When the two do not agree, carers get paid the wrong amount and no one notices until a payslip query or a compliance check.
Most agencies assume the rota system and the payroll system are joined up because a button says "export to payroll". They are joined by a file, not by a brain. That file reflects however the rota was configured months ago, and care rotas are messy: last-minute cover, doubled-up calls, cancelled visits, sleep-ins, bank holiday premiums. If the export was set up to pay contact time only, it pays contact time only, forever, silently, until someone reconciles it.
This is one of the finance jobs that decides whether a domiciliary agency runs on a real margin or a guessed one. If you want the full picture of how it fits with council invoicing, VAT and management accounts, our page for care agency accountants lays out the whole finance function in one place. This article stays on the one leak that costs the most: travel time.
Two numbers frame everything below. From 1 April 2026 the National Living Wage is £12.71 an hour for workers aged 21 and over, with the increase applying from the first pay reference period starting on or after that date. Include travel between visits in the hours tested against the applicable rate; any separate contractual travel rate must also be honoured. Get the reconciliation right and both are provable. Get it wrong and you are carrying a liability you cannot see.
How does travel between care visits affect the minimum-wage test?
Travel between care visits counts as working time when testing the applicable minimum wage over the pay reference period. This does not require a separate minimum-wage payment for every travel leg where eligible pay already covers the statutory total; the employment contract may require additional travel pay. It is written into regulation 34 of the National Minimum Wage Regulations 2015, which treats hours a worker spends travelling for the purpose of carrying out assignments at different places, where they are obliged to travel between them, as hours of time work.
There is one carve-out, and it trips people up in both directions. The same regulation excludes the journey between the worker's home and a place of work. In plain terms: the ordinary journey from home to the first service user and back from the last is generally excluded from this statutory hours calculation. Travel between service users counts, while contractual pay obligations must be checked separately. So a carer doing eight calls across a borough has seven travel legs that count, plus their contact time. Miss those seven legs and you have understated the hours you must pay minimum wage against.
Why this matters so much in home care is arithmetic. Domiciliary rounds are built from short visits with gaps between them. In an illustrative round, a 30-minute call followed by a 15-minute drive makes travel one third of the combined working time. HMRC's manual on working hours for which the minimum wage must be paid spells out the travel rule with worked examples. The care agency page again: our care agency accountants hub cross-references the same rule against council rate-setting, because the fee you negotiate has to cover travel time before it covers anything else.
Here is the part that quietly frightens agency owners once they see it: the minimum wage is tested across a pay reference period, not per visit. So a carer can be on a contractual rate well above £12.71 for contact time and still be underpaid overall, because unpaid travel time drags the average below the floor. HMRC does not look at your headline rate. The test uses pay that qualifies under the minimum-wage rules, after the relevant exclusions and reductions, divided by the hours that count. Gross payroll totals alone can give the wrong answer.
Where can rota exports lose travel time and pay elements?
The gap almost always starts in the rota system's setup, not in payroll. CarePlanner, Birdie and Access People Planner are strong scheduling tools that log visits, call monitoring, mileage and pay elements. They are systems, not accountants, so they pay out exactly what they were told to, and the pay export is only ever as good as the configuration behind it. Three things routinely fall through.
Travel time. Many rotas are set up to export contact time, the time actually spent with a service user, because that is what the council or private client is billed for. Billing and paying are two different clocks. If the export never adds the between-visit legs, the carer is paid for contact time while working contact time plus travel time. That is the classic minimum wage shortfall.
Mileage and unsocial premiums. Mileage reimbursement, night rates, weekend uplifts and bank holiday premiums are all separate pay elements that have to be switched on and mapped correctly. A cancelled visit that still incurred a travel leg, a sleep-in that turned into active hours, a double-up call where two carers attended: each is a place where the export and the reality drift apart.
Rounding and cut-offs. Rotas often round visit durations or clip travel to a cap. Small roundings across dozens of carers and hundreds of visits a week compound into a real number by month end. None of it is visible on a single payslip; all of it is visible when you reconcile the run.
The flow below is the shape of a clean pay run. The rota export comes out, the hours are mapped so travel and premiums are all present, the figures are reconciled against the pay run, and only then does the Full Payment Submission go to HMRC.
Naming the products is deliberate. CarePlanner, Birdie and Access People Planner are the systems most London agencies we speak to actually run, and none of them is the problem. The problem is treating their export as the finished payroll rather than the raw material for it.
How do you reconcile a care rota export before payroll?
The reconciliation is a weekly discipline, not a year-end scramble, and it runs in four moves. Do it every pay cycle and it takes minutes; leave it and it becomes a forensic project. Payroll for a care agency lives or dies on this rhythm, which is why we fold it into our payroll and PAYE service rather than treating it as an extra.
One, pull the raw hours, not the summary. Export the visit-level data from the rota, including start and end times, travel legs and any premium flags. The summary total is what hides the problem; the detail is where you find it.
Two, map every payable element. Contact time, travel time between visits, mileage, sleep-ins, night and weekend uplifts and bank holiday premiums each need to land in the right pay line. This is the step where a badly configured export gets caught, because a missing element shows up as a category with no hours against it.
Three, reconcile against the pay run and test the floor. For time work, exclude expense reimbursements and the premium element of overtime or unsocial-hours pay, make any other required adjustments, then divide eligible pay by the working hours that count. Compare the result with the rate for that worker and period. HMRC explains the calculation in its minimum-wage pay guidance. Any carer below the line is flagged and fixed before the run is approved, not after a query.
Four, file the FPS on time. The corrected figures go to HMRC on a Full Payment Submission. HMRC's guidance on reporting to HMRC through an FPS is blunt about timing: you send it on or before your employees' payday, every pay cycle. Reconcile after you have filed and you are correcting a submitted return, not preventing an error.
There is a record-keeping reason to work this way too, beyond getting the numbers right. HMRC's guidance on enforcing the minimum wage recommends keeping a clear breakdown of each category of working time, and it names them: contact time, time travelling between appointments, and time waiting for appointments. If your reconciliation already separates those categories every week, you are not just compliant, you can prove it in a single document if anyone ever asks.
What can missing travel time cost a London care agency?
The cost lands in two places at once: underpaid carers you owe arrears to, and a wage bill you have been quietly understating. Take a carer aged 21 or over doing time work as an illustrative worked model, with no other pay elements or deductions affecting the minimum-wage calculation. Say she does 30 contact hours in a week, the figure the rota exports and the council is billed for, plus six hours of travel between visits across the week. Her true working time is 36 hours.
If payroll pays only the 30 contact hours at £12.71, she receives £381.30 for 36 hours of work. Divide it out and her effective rate is £10.59 an hour, well under the £12.71 floor. To comply, the six travel hours have to be paid too: 36 hours at £12.71 is £457.56. The gap is £76.26 for that one carer in that one week, and it repeats every week until someone fixes the export.
Now scale the example using an explicit assumption. Suppose unreconciled travel pay equals 10 percent of an agency's £780,000 annual carer wage bill. That would be £78,000 requiring investigation. The 10 percent is an illustrative assumption, not a measured LOYALS client average. Reconcile the hours and payments before deciding whether anything is unpaid or has simply been recorded incorrectly; neither arrears nor a loss can be inferred from the assumption alone.
The downside if it is unpaid is not just the back pay. HMRC can require arrears going back up to six years, and in any dispute the burden of proving the minimum wage was paid sits with the employer, not the carer. On top of the arrears, a notice of underpayment carries a penalty of up to 200 percent of the shortfall, capped at £20,000 per worker, reduced by half if every term of the notice is met within 14 days of service. For an agency with dozens of carers, a systemic travel-time gap can create a substantial arrears and penalty bill.
Here is how the three common ways of running care payroll compare on the things that actually cause underpayments:
| What you need | Rota export straight to pay | Generic payroll bureau | LOYALS care payroll |
|---|---|---|---|
| Checks travel time between visits is paid | ✗ Only if configured | ● Check agreed scope | ✓ Every run |
| Tests each carer against the NMW floor | ✗ | ● If asked | ✓ Before the FPS |
| Maps mileage and unsocial premiums | ● If switched on | ● | ✓ Reconciled weekly |
| Keeps the working-time breakdown HMRC recommends | ✗ | ✗ | ✓ Contact, travel, waiting |
| Understands care rota systems and council rates | ● | ✗ | ✓ Care specialists |
| Open Mon to Sat for pay-run week questions | ✗ | ● Check provider hours | ✓ 10am to 7pm Mon to Sat |
This is why home care agencies that grow past 20 or 30 carers move from a raw rota export to a payroll run that is reconciled before it is filed.
What should you check before the next pay run?
Start with one carer and one week. The whole problem is visible in a single reconciled round, and once you have seen it on one carer you will want to check the rest. The steps are straightforward and most of them you can do this week.
- Pull one carer's raw visit data. Not the pay summary, the visit-level export with times and travel legs, from CarePlanner, Birdie or whichever system you run.
- Add up their real working hours. Contact time plus every travel leg between visits, excluding only home to first call and last call to home.
- Test eligible pay against the hours that count. Apply the pay-element rules above and the worker's applicable rate for the pay reference period. Investigate any shortfall and check whether the same configuration affects other staff.
- Check the export settings. Confirm travel time, mileage and premiums are switched on and mapped, and that roundings are not clipping payable time.
- Fix the last few runs, not just the next one. If the gap existed before, the arrears already exist. Correcting them yourself is far cheaper than being found.
- Make reconciliation a weekly step. Reconcile, then file the FPS. Never the other way round.
If you do find historic arrears, there is a sensible route through it. Where a self-review finds arrears, pay the correct amount and consider the HMRC voluntary declaration process. Its usual protection from naming and financial penalties depends on paid arrears being declared through that process and accepted by HMRC, with exceptional cases excluded. Self-correction alone is not an unconditional exemption.
LOYALS runs the weekly payroll, travel-time reconciliation and RTI filing for home care agencies across London and the UK, so every carer's hours are paid correctly and the whole run is provable if a check ever comes. That is the point of reconciliation: not more admin, but the confidence that the wage bill on your management accounts is the real one.
Payroll is one part of the finance function a home care agency has to run well. Council invoicing, VAT on welfare-exempt care, cashflow against slow-paying frameworks and monthly management accounts all sit alongside it. If you want the whole picture rather than this one leak, our page for care agency accountants brings it together, and the profit side of the same story is in our guide to domiciliary care agency profit margins.