Month-End Accounting for Care Homes: Automate Accruals, Prepayments and Deferred Income in Xero
- Simon Hancott
- May 17
- 5 min read
Care home finance is not complicated accounting. But it is a specific accounting problem, and one that most general-purpose tools handle badly.
Residents are billed in advance. That creates deferred income. Invoices cover two months at once when someone moves in mid-period. Insurance, maintenance contracts, rates and utility bills all need prepayment treatment. Costs arrive after the period closes. And most care groups are running the same processes across multiple entities. Six, eight, twelve care homes, each with its own Xero organisation.
Most care home FDs are managing this with spreadsheets. One per entity, updated manually every month-end, understood properly by one or two people in the team.
It works. Until it doesn't.
The specific month-end challenge for care homes
An FD at a care home group running nine operational entities, described the situation clearly when he first spoke to us: "We've got a fair amount of prepayments, which we're tracking on spreadsheets and then splitting with upload journals."
She also described the resident billing challenge: "We might bill the rest of a month and the next month together, that's all being split manually at the moment."
This is the care home accounting problem in two sentences. Two distinct adjustment workflows. Both manual. Both spreadsheet-dependent. Both multiplied across every entity in the group.
The three specific areas where care home finance teams consistently lose time at month-end are:
When a resident moves in part-way through a month, the invoice typically covers the remainder of that month and the following month in a single billing. That income needs deferring, the current month's portion recognised now, next month's portion held on the balance sheet.
Most care home finance teams are doing this in a spreadsheet. Each resident invoice is manually identified, split, and the deferred portion tracked until the following month.
Care homes carry significant prepayments, rates paid in advance, annual insurance premiums, maintenance contracts, software subscriptions, cleaning and laundry service contracts. Each one arrives as a single invoice that needs splitting across the months it covers.
For a care group with nine entities, each carrying twenty or thirty prepayment lines, that's a substantial monthly task. And it scales linearly with the number of homes.
Utility bills are the most common example, electricity and gas invoices that consistently arrive three to four weeks after the period they relate to. If the invoice hasn't arrived by month-end, the cost still needs to be in the accounts. Someone has to estimate the amount, post the accrual, and reverse it when the bill eventually lands.
Why multiple entities compound the problem
A single care home running this process manually is manageable, if time-consuming. A care group running the same process across six, eight or twelve entities faces a different problem entirely.
Each entity has its own Xero organisation. Each one has its own prepayment schedule, its own deferred income position, its own accruals for missing costs. The work doesn't get easier with scale, it multiplies.
They described the pricing concern that comes with that: "What kind of puts us off some of the Xero add-ins is the cost per entity, some of them are worth doing because they've got a lot of prepayments, but the property companies have probably got one prepayment. So it's like, well, there's no point in paying the full price for that."
This is a legitimate concern for any multi-entity care group, the economics of automation need to work across entities with very different transaction volumes.
Spread's pricing is designed for this structure: a base subscription for the first entity and a lower per-organisation rate for each additional one, which means you can connect the high-volume operational homes at full value and make a considered decision about the lighter property entities.
How Spread handles the care home adjustment workflow
Spread connects to Xero and reads every invoice, line description and attachment as it arrives throughout the month. For care home finance, this handles all three of the adjustment workflows described above.
Deferred resident income — the Sales Inbox
When a resident invoice arrives in Xero covering, say, the last ten days of May and all of June in a single billing, Spread reads the date range from the line item description or the invoice attachment and suggests the correct split automatically. May's portion is recognised as income. June's portion is held in deferred income on the balance sheet. When June arrives, Spread releases it to the P&L automatically.
The key is the description in Xero. If the invoicing system, whether that's a care management system like CareHQ or direct billing, includes the service period in the description, Spread picks it up immediately and suggests the correct treatment with high confidence. This is worth checking in your current process, a small change to how descriptions are populated upstream can make the entire recognition workflow automatic.
Prepayments — the Cost Inbox
Every supplier invoice posted to Xero flows into Spread's Cost Inbox. Spread reads both the line item description and the PDF attachment to detect whether the invoice covers multiple periods. An annual insurance premium, a rates payment covering the full year, a quarterly maintenance contract, all detected and split across the correct months automatically.
For a care group, this means the prepayment schedules that currently live in entity-by-entity spreadsheets can be replaced by a single system that handles all of them, across all entities, from one dashboard.
Missing bill accruals — Recurring Bills
The Recurring Bills area is where care homes with consistently late utility bills will find the most immediate relief. You configure the suppliers you expect to be billed by and at what frequency. Spread tracks what's arrived in Xero. When month-end comes and the electricity bill hasn't landed, Spread suggests the accrual automatically, at the right amount, linked to that supplier. When the invoice eventually arrives, Spread suggests the reversal. One click.
The multi-entity dashboard
For a care group running multiple Xero organisations, Spread provides a single dashboard showing the status across all connected entities simultaneously. You can see which inboxes have items pending review, which entities are fully processed, and which still have outstanding adjustments, without logging in and out of each Xero organisation separately.
This is particularly useful for the review and sign-off workflow in a finance team structure where responsibility for different entities is split between the FD and a finance manager, because the FD can see the overall position across the group without having to chase individual spreadsheets.
Getting started
Spread connects to Xero in under two minutes. The recommended approach for a care group is to start with one operational entity, the one with the highest volume of prepayments and adjustments, run it for a month alongside your existing process, and compare the output. Once you're confident in the results, rolling it out across the other entities is straightforward.
For entities with lighter transaction volumes, property companies with a handful of prepayments, for example, the economics and effort of implementation are easy to assess once you've seen it working on the main entities.
There's a free trial and no ongoing commitment. No spreadsheets, no manual journals.
Start your free trial at spread.finance
Further reading:
A note on this post: This post draws on a real conversation with a finance director at a UK care home group. Details have been changed to protect privacy but the accounting challenges described are exactly as discussed.
Comments