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.

Who This Applies To

The month-end problem looks different depending on where you sit.

For accounting practices managing management accounts across a portfolio of Xero clients, the constraint is throughput. Katherine Johnson, who handles between 30 and 40 management account jobs a month, framed it clearly: the goal is getting accounts out by the 7th. The reality is the 14th. Every day saved per client multiplies across the portfolio.

For in-house finance teams, typically at businesses between £5 million and £100 million in revenue, the constraint is accuracy and audit-readiness. A finance team of two managing 800 rows of prepayments across 12 sites isn't slow because they're inefficient. They're slow because the process was designed for three sites and has never been rebuilt for twelve.

For fractional FDs managing multiple client organisations simultaneously, the constraint is context-switching. Every client has different suppliers, different contract terms, different billing cycles. A tool that standardises the adjustment layer across all of them, without requiring a different spreadsheet for each, changes what's possible in a working week.

The automation described in this post applies to all three. The starting point and the scale differ. The underlying problem, timing adjustments that fall to manual journals and spreadsheets, is the same.

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 line 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 To Accrue — 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 Xero Handles Natively vs What Requires A Connected App

The distinction matters because most guides on this topic conflate what Xero does well with what it cannot do at all. Here is the honest picture.

Task	Xero natively	With Spread
Bank reconciliation	✓ Fully automated	—
Repeating journals for fixed monthly costs	✓ Works well	—
Invoice capture and coding	✓ With Dext/Hubdoc/Apron	—
Detecting service periods from invoice descriptions	✗ Not possible	✓ Automatic
Reading PDF attachments to detect date ranges	✗ Not possible	✓ Automatic
Apportioning quarterly bills across correct months	✗ Manual only	✓ Automatic
Identifying missing supplier invoices	✗ Not possible	✓ Suggested
Posting accrual journals for missing bills	✗ Manual only	✓ One click
Reversing accruals when invoices arrive	✗ Manual only	✓ Automatic
Deferred revenue recognition schedules	✗ Manual only	✓ Automatic
Balance sheet reconciliation export by line item	✗ Not built in	✓ Included
Multi-entity tracking category replication	✗ Manual	✓ Automatic

The pattern is consistent. Xero handles the transactional layer well. Everything that requires reading the meaning of a transaction, what period it covers, whether it's arrived yet, how it should be split, falls outside what Xero does natively.

This is not a gap in Xero's design. Xero is a bookkeeping and accounting platform, not a close management tool. The two serve different functions and work best together.

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 via OAuth2, no credentials shared, no IT involvement required. The connection is the same secure method Xero uses for all its certified app partners.

The recommended approach for a new client or organisation is to start at the beginning of a new management period. Everything processed in Xero from that point flows through Spread. Anything posted before the start date sits in your existing process and is unaffected.

Week One — Connect and Review

Connect your Xero organisation. Spread syncs your chart of accounts, nominal codes, and historical transactions. You specify which nominal codes to monitor, or simply turn on all overhead and expense codes and exclude anything irrelevant.

Within hours of connecting, your Cost Inbox will populate with suggestions. For most organisations with reasonable bookkeeping, a significant proportion of transactions will come through as Ready, high confidence that the date range has been detected correctly and the journal is right.

Start in manual review mode. Check what Spread is suggesting. Compare a handful of suggestions against the original invoices in Xero. For most people this takes 30 to 45 minutes in the first week and builds confidence quickly.

Month One — First Month-End

By the time your first month-end arrives, most of the routine adjustments will already be staged. Review the balance sheet reconciliation export, every prepayment, accrual and deferred revenue entry listed by line item, tied to its source invoice. Check the closing balances match what's sitting on the Xero balance sheet.

For anything in To Review status, open the transaction, check the suggested date range, adjust if needed, and post. This is where the seven-day scramble becomes a 45-minute review.

Month Two Onwards — Automation

Once you're comfortable with the output, turn on automation for Ready transactions. From this point, high-confidence journals post automatically as invoices arrive throughout the month. By the time month-end comes, the adjustment layer is largely done.

The firms that have moved furthest with this describe a shift in what junior staff can handle. As one Financial Controller put it: "Something their senior person might have done previously is now being done by a junior bookkeeper, because Spread is essentially suggesting everything. They're just reviewing it."

There's a free trial. No spreadsheets, no manual journals. Connect a single organisation first, one month-end is enough to know whether it's working.

Start your free trial at spread.finance

Read about Month End Automation Here

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.