top of page
Search

How Do I Automate Accruals in Xero?

  • Writer: Simon Hancott
    Simon Hancott
  • May 4
  • 6 min read
month end close

Updated May 2026 — revised to reflect current Spread functionality and customer feedback.


Every month-end, the same problem.


A utility bill hasn't arrived. A consultancy invoice is sitting in someone's email. A quarterly rent invoice landed in the wrong month. You know the costs are there, you just can't prove it yet without opening a spreadsheet, estimating the figures manually, posting the journal, and setting a reminder to reverse it next month.


As one fractional FD put it on a call with us: "It's all done manually in Excel, and it's wrong half the time, to be honest."


This is the reality for most Xero users doing management accounts. Not because they lack skill, but because Xero was never built to handle the timing differences that require accrual accounting. That job still falls to spreadsheets, manual journals, and the accountant who happens to remember.


This article explains exactly why Xero can't automate accruals natively, what the manual process actually looks like, and what's now possible with Spread, a Xero-connected tool built inside an accounting practice specifically to solve this problem.


What is an accrual in Xero, and why does it need a journal?


An accrual is a cost you've incurred but haven't yet been invoiced for. Under accruals-basis accounting, which applies to any business producing management accounts, costs need to be recognised in the period they relate to, not the period the invoice arrives.


In Xero, this means posting a manual journal at month-end:


  • Debit the relevant expense account (e.g. Utilities)

  • Credit an accruals liability account on the balance sheet


Then reversing it the following month when the actual invoice arrives.

Simple in principle. The problem is doing it correctly, consistently, across every supplier, every month, without missing anything.


Why Xero can't automate accruals on its own


Xero is excellent at what it does: bank reconciliation, invoice tracking, real-time reporting. But it doesn't automatically identify which supplier invoices are missing, calculate what should be accrued, or post and reverse the journals when the bill eventually arrives.


What Xero can do:

  • Track bills and expenses once they're entered

  • Create manual journals for accruals, but you still calculate them yourself

  • Set up repeating journals for fixed monthly costs


What Xero can't do:


  • Identify that a quarterly utility bill hasn't arrived and accrue the monthly cost

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

  • Automatically reverse an accrual when the actual bill lands

  • Track which suppliers are consistently late and flag the missing costs


The result is that month-end accruals remain one of the most manual, time-consuming parts of closing the books. As one accounting firm owner told us: "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."


What the manual accruals process actually looks like


For most Xero practices and finance teams, the current process goes like this:


Step 1 — At month-end, open the accruals spreadsheet. This is maintained outside Xero, updated monthly, and typically understood by one person.


Step 2 — Work through each supplier line by line. Has the invoice arrived? If not, estimate the cost based on last month or the previous quarter.


Step 3 — Post a manual journal in Xero for each accrual. Debit the expense, credit the accruals balance sheet code.


Step 4 — Set a reminder to reverse it next month. Hope the actual invoice arrives before someone asks about the balance sheet.


Step 5 — When the invoice eventually arrives, check it against the accrual. Post the reversal. Investigate any variance.


This works at low volume. At 20-30 clients, or 150 supplier invoices a month, it stops working. Marc Davis, a fractional FD, described his team's current approach: "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 actually is really neat."


How Spread automates accruals in Xero


Spread was built inside Profit Cash Growth, an accounting firm that produces management accounts for clients between £1 million and £20 million in revenue. Before Spread, the team was maintaining parallel spreadsheets outside Xero, making the work hard to delegate and inconsistent across team members. Spread was created to fix that and is now available to any Xero practice or finance team.


Step 1: Spread reads your invoices and attachments

When a bill arrives in Xero, Spread reads both the line item descriptions and the PDF attachments. If a quarterly rent invoice says "January to March" in the attachment — even if the Xero description is blank, Spread detects the date range and flags it for adjustment. No manual reading required.


Step 2: Spread suggests the correct journals

Spread proposes the accruals and prepayments automatically. A quarterly invoice posted in March gets backed out of March and spread correctly across January, February and March. Multi-line invoices, multi-currency transactions, and invoices with different tracking categories are all handled at line-item level.


A seven-day snapping rule handles borderline dates consistently, if a cost falls within seven days of month-end, Spread treats it as the following month. This removes individual discretion from the process and creates consistency across the whole team.


Step 3: You review and approve, or automate entirely

Spread uses a confidence system. High-confidence transactions are marked as Ready and can be posted automatically. Lower-confidence ones are flagged for review. Most practices start with full manual review, then turn on automation as they build confidence in how Spread handles their specific clients.


As one firm put it: "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 done by a bookkeeper, because it's essentially suggesting everything to you. You're just reviewing it."


Step 4: Spread catches missing bills at month-end

The Recurring Bills area handles the accruals you can't see coming. You configure which suppliers bill you regularly and at what frequency. If a quarterly electricity bill hasn't arrived by month-end, Spread suggests the monthly accrual automatically, by supplier, at the right amount. When the invoice eventually lands, Spread suggests the reversal. One click.


Frequently asked questions about automating accruals in Xero


Can Xero do accruals automatically? No. Xero allows you to create manual journals for accruals and set up repeating journals for fixed costs, but it has no mechanism to identify missing invoices, read PDF attachments to detect service periods, or suggest reversals automatically. A separate tool like Spread is required for full accruals automation in Xero.


What is the journal entry for an accrual in Xero? The standard accrual journal in Xero debits the relevant expense account and credits an accruals liability account on the balance sheet. At the start of the following month, a reversal journal does the opposite, debiting the accruals account and crediting the expense, to clear the balance when the actual invoice arrives.


How do you handle missing invoices in Xero at month-end? Most practices either accrue to budget (estimating based on prior periods) or track missing invoices manually in a spreadsheet. Spread's Recurring Bills area automates this, tracking expected invoices by supplier and suggesting the accrual automatically if one hasn't arrived by month-end.


Does Spread work with Xero tracking categories? Yes. Spread replicates tracking categories from the source transaction onto every journal it posts, so management accounts remain consistent without any additional manual input.


Can you automate accruals for multiple Xero organisations? Yes. Spread connects to multiple Xero organisations from a single dashboard, applying the same rules and confidence system across all of them. This is particularly useful for accounting firms managing multiple clients or finance teams with multiple entities.


How long does it take to set up Spread with Xero? Spread connects to Xero in under two minutes via OAuth. Most practices connect a single client first to validate the output, then roll it out across their portfolio from there.


What changes when accruals are automated


The practical impact isn't just time saved; it's how the month-end process changes in character.


Instead of a stressful seven-day window at month-end, adjustments are reviewed throughout the month as invoices arrive. By month-end, most of the work is already done. Katherine Johnson, who does 30 to 40 management account jobs a month, described the goal: "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 what Spread is designed to enable.


Marc Davis put it simply: "I'd rather spend my time seeing what's going on in the business than having to post journals and adjustments."


Getting started


Spread connects to Xero in under a minute. Once connected, it begins reading your invoices and attachments immediately. There's a free trial and onboarding support, no spreadsheets, no manual journals.




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.

 
 
 

Comments


bottom of page