How to Automate Month-End Close in Xero: Accruals, Prepayments & Deferred Revenue

Month-end close in Xero doesn't have to be a seven-day scramble. But for most practices doing management accounts, that's exactly what it is.

Dom described the problem that led to Spread being built: "They have to produce all these management accounts within a seven-day window at the end of the month. How do we make that as easy as possible?"

The answer wasn't working faster. It was changing when the work happens.

This post explains exactly how to automate accruals, prepayments and revenue recognition in Xero — what's possible natively, where Xero falls short, and how Spread fills the gap.

What Xero handles natively

Xero does a lot well. Bank reconciliation, invoice tracking, real-time reporting — the foundations are solid. And for simple, consistent monthly costs, Xero's repeating journals work fine.

But Xero has no way to:

• Read an invoice attachment and detect that a cost spans multiple months

• Identify that a quarterly bill covers April to June and apportion it correctly

• Spot that a recurring supplier invoice hasn't arrived and suggest an accrual

• Automatically reverse that accrual when the bill eventually lands

  
  

These are the tasks that still fall to spreadsheets, manual journals, and whoever happens to remember. As Marc Davis, a fractional FD, put it: "That's another piece that's all done manually in Excel, and it's wrong half the time, to be honest."

How Spread automates month-end close in Xero

Spread connects to Xero and reads every transaction as it arrives — both the line item descriptions and the PDF attachments. It then identifies timing differences and suggests the correct journals automatically.

Here's how each part works.

Accruals and prepayments — the Cost Inbox

When a quarterly rent invoice arrives in Xero, Spread reads the date range — either from the Xero description or directly from the attachment — and suggests the correct monthly split.

As Dom explained on a call: "Even if the descriptions are blank in Xero, it's going to read the document and make suggestions based on that."

Multi-line invoices, invoices covering different periods, multi-currency transactions — all handled. There's also a seven-day snapping rule built in: if a cost falls within seven days of month-end, Spread recognises it belongs to the following month. This creates consistency across the whole team — no more individual discretion on borderline dates.

Each transaction is given a confidence status. Anything marked Ready can be fully automated. Anything marked To Review is flagged for a quick check before posting. The goal, as Dom put it, is that "80% of those adjustments at month-end are just completely done for you."

Revenue recognition — the Sales Inbox

The Sales Inbox works identically — but for deferred revenue. An annual subscription invoiced upfront in March gets backed out of March and spread across 12 months automatically. A quarterly invoice marked "April to June" in the description gets recognised correctly across those three months.

Marc spotted the implication immediately: "So that solves the revenue side of things. That's pretty cool — it'll be linked to the invoice, because you've got the invoice number there from Xero."

For membership businesses, golf clubs, football season tickets and similar — there's a bulk date apply feature that lets you select all transactions for a nominal code and apply a single end date in one click.

Missing bills — Recurring Bills

This is where Spread handles the accruals you can't see coming. You tell Spread which suppliers you expect to be billed by regularly and at what frequency. If a quarterly electricity bill hasn't arrived by month-end, Spread suggests the monthly accrual automatically.

Marc described exactly this problem: "At the moment our accountant just goes, 'I'm just going to accrue to budget.' I'm like, well, what's that? I don't know what I'm missing. So to have it by vendor is really neat."

When the invoice eventually lands, Spread suggests the reversal — automatically — because it cross-references the journal naming conventions it posted when it did the original accrual. As Dom described it: "When the bill lands, it's going to suggest to reverse the original accrual I posted. And again, it's just one click, and then that's done."

What changes when you automate

The most obvious change is time. Chris Bennett at Thomas Emlyn framed it as a capacity question: "If you've got someone doing 20 sets of management accounts a month, if they can automate enough so they can do 25, then we don't have to get another person in."

But the more significant change is when the work happens. Instead of a compressed seven-day close at month-end, adjustments can be reviewed and posted throughout the month as invoices arrive. Dom described the shift: "Rather than wait until the end of the month and have that seven-day stressful push to get all the management accounts done, you can get a lot of these adjustments done throughout the month. By month-end, there's basically nothing to review for accruals and prepayments."

There's also a team benefit. "Some people have been able to get a fairly junior member of staff using Spread — something their senior accountant might have done previously is now being able to be done by a bookkeeper, because it's essentially suggesting everything to you. You're just reviewing it."

Katherine Johnson, who does between 30 and 40 management account jobs a month, described her goal clearly: "Anything to try and help us get the management accounts out by the 7th of the month. At the moment we're looking at the 14th." That's exactly the shift Spread is designed to enable.

How to get started

Spread connects to Xero in under two minutes. The recommended approach is to connect a single client at the start of a new management period — everything processed in Xero from that point is handled by Spread, while anything before sits in your existing process.

Most firms start with manual review — checking what Spread suggests before posting — then turn on automation for high-confidence transactions once they're comfortable with how it works.

There's a 14-day free trial. No spreadsheets, no manual journals.

Start your free trial at spread.finance

A note on this post: Every quote is drawn from real conversations with accountants and finance professionals. Names have been changed to protect privacy but the substance of every comment is unchanged.