Care Invoice Reconciliation: A Complete Guide for UK Providers
In short
Care invoice reconciliation is the process of matching three independent records — rostered hours, delivered (call-logged) hours, and invoiced hours — against the remittance advice actually paid by a local authority, ICB or private payer. Every line where those four numbers disagree is either unbilled care, an underpayment, a rate error, or a duplicate. Providers who reconcile line-by-line each cycle typically recover between 2% and 7% of annual revenue that would otherwise be written off.
Key takeaways
- Reconciliation compares four data sets: roster, electronic call monitoring (ECM) logs, sales invoices, and remittance advice.
- Most leakage sits in the gap between delivered hours and invoiced hours, not in the payment itself.
- Local authority remittances are frequently paid net of unexplained deductions with no line-level narrative.
- Manual spreadsheet reconciliation typically samples; algorithmic reconciliation covers 100% of lines.
- Every adjustment needs an audit trail if it is to survive a CQC or funder review.
What care invoice reconciliation actually involves
In UK social care, a single care package can be recorded four separate times before any cash arrives. The roster records what was planned. The electronic call monitoring system records what was actually delivered, usually to the minute. The finance system records what was invoiced. The payer's remittance advice records what was paid.
Reconciliation is the discipline of forcing those four records to agree, service user by service user, week by week. When they disagree, the difference is not an accounting curiosity — it is either care given away for free, or an overpayment that will eventually be clawed back.
- •Roster vs delivered: missed, shortened or extended visits.
- •Delivered vs invoiced: care delivered but never billed.
- •Invoiced vs paid: rate mismatches, funding-band errors, silent deductions.
- •Paid vs contracted: uplifts applied late, or not at all.
Why the gaps appear
Funding bands change mid-package. Service users move between local authority, ICB continuing healthcare and private funding, sometimes retrospectively. Bank holiday and enhanced rates are applied inconsistently. Double-up (two-carer) calls are billed as single visits. A brokerage change arrives by email and never reaches the finance system.
None of these is a scandal. Each is a small, ordinary operational fact. The problem is volume: a provider running 3,000 visits a week generates roughly 156,000 billable events a year, and a 1% error rate on that volume is thousands of unrecovered lines.
A reconciliation process that holds up under audit
A defensible monthly cycle has five steps, and each step should produce an artefact you can hand to an auditor without further explanation.
- •1. Ingest — pull roster, ECM export, invoice ledger and remittance advice for the same period, unmodified.
- •2. Normalise — align service user identifiers, funding bands, rate cards and date boundaries.
- •3. Match — join on service user and visit window, not on totals. Totals hide offsetting errors.
- •4. Classify — label every exception: unbilled, underpaid, overpaid, duplicate, rate variance, out of contract.
- •5. Evidence — attach the source rows to each exception so the challenge letter writes itself.
Why totals-based checks fail
The most common failure we see is reconciling at summary level: invoice total against remittance total. If a £480 underpayment on one package is offset by a £470 overpayment on another, the summary looks nearly clean and both errors survive. Only line-level matching surfaces them, and only line-level evidence recovers them.
How automation changes the economics
Manual reconciliation is bounded by finance-team hours, so teams sample. Sampling means known-unknown losses are accepted as a cost of doing business. Automated matching removes the sampling constraint: 100% of lines are compared every cycle, exceptions are ranked by recoverable value, and the finance team spends its time on the challenge letters rather than the spreadsheet joins.
CareLedger AI performs this matching against roster, call-log and remittance data, categorises each exception, scores its recoverability, and produces an evidence pack per disputed line.
Frequently asked questions
How often should a care provider reconcile invoices?
Every payment cycle, in line with your invoicing frequency — usually every four weeks or monthly. Reconciling quarterly makes challenges harder because most local authorities apply a dispute window of 60 to 90 days from invoice date.
What is the difference between reconciliation and an audit?
Reconciliation is a routine operational control that matches records each cycle. An audit is a periodic independent examination. Good reconciliation produces the evidence an audit needs, which is why the audit trail matters as much as the match itself.
How much revenue do UK care providers typically lose to reconciliation gaps?
Industry benchmarks and provider-side reviews commonly place unrecovered billing between 2% and 7% of annual revenue, concentrated in unbilled delivered care, double-up visits billed as single, and unapplied contractual uplifts.
Can reconciliation be done in a spreadsheet?
It can, at low volume. Beyond a few hundred visits a week the join complexity — overlapping funding bands, part-period rate changes, retrospective package edits — makes spreadsheets both slow and unauditable, because the formulas cannot show why a line was matched.