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. A flagged difference is a potential discrepancy, not recovered revenue. Any recovery depends on contractual entitlement, delivery evidence and payer approval.
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.
- Automated matching can review imported records without sampling; coverage depends on complete, valid source data.
- 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: in a fictional example, 3,000 visits a week over 52 weeks gives 156,000 visits. An assumed 1% error rate would flag 1,560 visits for review, not 1,560 confirmed recoveries.
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
Illustrative example using fictional amounts: a £480 underpayment on one package offsets a £470 overpayment on another, leaving a £10 net difference. Summary checks can hide the two issues; line-level matching provides evidence for review, not a guarantee of recovery.
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: valid imported lines can be compared each cycle, exceptions can be prioritised for review, and the finance team spends its time on the challenge letters rather than the spreadsheet joins.
CareLedger AI matches roster, call-log and remittance data, categorises potential discrepancies and produces evidence for review. A discrepancy score is not confirmation that money can be recovered.
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?
There is no verified typical loss or recovery percentage provided here. Review complete payment cycles against contractual rates and delivery evidence to identify potential discrepancies; do not extrapolate the fictional examples as customer results.
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.