How to Stop Doing Accruals in Spreadsheets: A Guide for In-House Finance Teams

If you're still managing accruals and prepayments in Excel, you already know the problem. The spreadsheet works until it doesn't, and when it doesn't, it's usually during month-end when you have the least time to fix it.

Helena, a Financial Controller, described where most in-house finance teams are right now: "We have something in place and it's working really well, but we're looking for automation, a click of a button or a couple of clicks and it's done, instead of spreadsheet uploads, downloads and all of that."

Anna, a Finance Manager, was even more direct about the scale of the problem her team faced: "I would be doing nothing but looking at every transaction and running huge spreadsheets. That's not something I'm going to do in the 21st century."

These aren't small businesses with simple finances. One has six Xero entities across multiple jurisdictions and another runs 150 software subscriptions a month, pushing invoices into Xero automatically. Both teams have the tools to get transactions into Xero.

The gap is everything that happens next. Getting costs into the right month, catching what's missing, and doing it without a manual process that someone has to maintain.

This post covers exactly how to close that gap.

Why Spreadsheets Keep Breaking Down At Scale

The Excel accruals schedule is a workaround that became a process. It made sense when the business had twenty suppliers and a straightforward month-end. It stops making sense when you have 150 SaaS subscriptions, six entities, multiple tracking categories, and invoices arriving in currencies other than sterling.

At that point the spreadsheet isn't a tool, it's a liability.

Helena described the accruals process at her company "Accruals take a very long time. We have somebody doing it, then somebody needs to check it." Two people, sequential, under month-end pressure. Any mistake in the schedule flows directly into the financial statements and doesn't surface until someone does the reconciliation.

Emma, a Management Accountant, described to us what she actually wants from a better process: "The easiest check would be what have you moved out of prepayments in that month versus what have you got on your balance sheet and what have you added. Just a three-way quick check, rather than adding all loads of tiny little journals together."

That's the target. A month-end where the reconciliation is a confirmation, not a reconstruction.

The SaaS Invoicing Problem

For finance teams at SaaS businesses, there's a specific version of this problem that spreadsheets handle particularly badly.

SaaS vendors bill on their own schedule, often on the invoice date, not the service period date. An annual subscription invoiced in April sits entirely in April's P&L unless someone manually identifies it, calculates the correct monthly split, and posts the journals. At low volumes that's manageable. At 100-150 invoices a month from subscription management platforms like Cledara pushing directly into Xero, it becomes impossible to do manually.

Anna described exactly this: "We have about 150 different subscriptions, different vendors set up as subscriptions, and the invoices are picked up by Cledara from our inboxes and then pushed to Xero. But it happens on the invoice date, not on the service period date. And there's been a big emphasis on doing everything on an accruals basis. So we need to find a way to book those bills based on the actual service date shown on the invoices."

The invoices are in Xero. The attachments are attached. The service dates are on the PDFs. The only missing piece is a system that reads them and posts the correct journals automatically.

The Missing Bill Problem

The accruals problem has two sides. The first is invoices that arrive in the wrong month. The second is invoices that don't arrive at all.

Every finance team has a list, mental or otherwise, of suppliers who bill inconsistently. The HR system. The utilities. The quarterly consultancy that invoices whenever it remembers. At month-end someone has to check whether these bills have arrived and accrue the cost if they haven't.

Marc Davis, a Finance Director, described the 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 is really neat."

Anna had the same reaction when she saw the recurring bills area of Spread: "Oh wow, I was thinking about exactly this table this morning. There are so many other things to do at month-end that checking manually, going through suppliers and thinking, oh did I get the invoice or not, that is not possible. With the number of suppliers we have and different services, I can't control it in my head."

How Spread Works For In-House Finance Teams

Spread connects to Xero and reads every invoice and attachment as it arrives, descriptions, PDF attachments, date ranges, line items. It detects timing differences and suggests the correct journals automatically.

For SaaS subscriptions coming through tools like Cledara: 

Even where the Xero description is just a vendor name and payment reference, Spread reads the PDF attachment and finds the service period dates. Anna confirmed this is exactly the scenario: "The invoices are always attached because Cledara picks them up from our inboxes and attaches them to the transaction. So they sit in Xero. That sounds good."

For multi-line invoices with different periods: 

A single rental invoice with different line items for different date ranges gets handled correctly at the line item level. Each line gets its own schedule.

For tracking categories: 

Spread replicates tracking categories from the source transaction onto every journal it posts. Helena asked this directly: "Will I see the same tracking categories in Spread as in Xero? Do I need to manually input them in Spread?" The answer is no, they come through automatically from the Xero transaction.

For multi-currency: 

Journals are posted in the base currency GBP, with FX rates pulled from Xero based on the invoice date. Thomas raised this specifically for their multi-entity structure and confirmed it covers their use case.

For locked periods: 

If an accrual relates to a closed period, Spread lets you choose what to do with the balance, post it in the first available open month or spread it across the remaining schedule. Helena confirmed this works for their monthly lock date process.

For missing bills: 

The Recurring Bills area lets you set up each supplier with expected billing frequency and amount. Spread tracks what's arrived and suggests the accrual when something's missing. When the invoice lands, it suggests the reversal. Everything is visible by supplier across a six-month P&L history.

The Audit Trail Question

Thomas asked the question that every finance team with auditors eventually asks: "If Spread is doing the prepayments and accruals as it goes, is there a way to see by month what entries have been made and what's outstanding at month-end?"

The answer is the balance sheet reconciliation export, a CSV with a tab for each nominal code showing every adjustment Spread has made, by supplier, invoice number, line item, tracking category, currency, and month. Opening and closing balances included. Twenty-four months of rolling history.

Helena's reaction: "We can use this just for the reconciliation, it's similar to what we've got now but without the manual maintenance."

That's the key shift. The export replaces the manual spreadsheet schedule as the month-end reconciliation tool. You're still doing the three-way check Emma described, prepayments balance, what moved out, what was added, but Spread generates the data automatically rather than you maintaining it by hand.

What Changes At Month-End

The structural change isn't just time saved. It's when the work happens and who does it.

Instead of compressing all accrual and prepayment work into the last week of the month, adjustments can be reviewed and posted as invoices arrive. By month-end, most of the work is already done.

Dom described how leading teams are starting to use it: "You could have more junior members of staff interacting with Spread throughout the month to really cut down the bottleneck at month-end. Everything comes in, once a transaction's approved in Xero it comes into Spread, and you can process it there and then."

For finance teams with multiple entities, like the one above with six Xero organisations, this is especially significant. Spread handles all of them from a single dashboard. The same process, the same rules, the same output, consistently, across every entity.

Getting Started

Spread connects to Xero in under two minutes. For finance teams with security or data governance requirements, Spread is a Xero certified app and if needed can be tested against a demo Xero organisation first, which is exactly the approach Helena chose before committing to a full implementation.

There's a free trial period — 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 finance professionals. Names have been changed to protect privacy but the substance of every comment is unchanged.