Accruals and Prepayments: Why They're Killing Your Productivity

Every month-end, the same conversation.

A rent invoice covers three months but landed in one. An insurance payment needs splitting across twelve. A utility bill hasn't arrived yet but the cost is real. And somewhere in a spreadsheet that only one person really understands, someone is manually calculating what needs to go where — hoping they haven't missed anything.

Marc Davis, a fractional FD, described it plainly: "That's another piece that's all done manually in Excel, and it's wrong half the time, to be honest."

He's not alone. Across accounting firms and finance teams, accruals and prepayments remain one of the most time-consuming, error-prone parts of the month-end close. Not because the concept is difficult — every accountant understands the principle. But because doing it correctly, at volume, every month, without a dedicated system is genuinely hard.

This post explains exactly why manual accruals and prepayments slow teams down, what the real cost looks like in practice, and how automation changes the picture.

Why accruals and prepayments eat so much time

The problem isn't any single transaction. It's the combination of volume, variability, and timing pressure that makes this process so difficult to manage manually.

A quarterly rent invoice. An annual software licence. An insurance renewal that spans two financial years. A utility bill that consistently arrives three weeks after month-end. Each one requires a judgment call about which costs belong to which period, manual journal entries to post the adjustment, and a reminder to reverse or continue it next month.

Kieren Walsh at a large accounting practice described the practical reality: "We're basically bending over backwards to try and get these reports done quickly." His team was spending an average of two to five hours per client per month on accrual adjustments alone.

Multiply that across a client portfolio and the numbers become significant. For a firm doing management accounts for twenty clients, that's forty to one hundred hours a month — just on accruals and prepayments.

Chris Bennett at Thomas Emlyn framed the downstream implication directly: "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."

The spreadsheet problem

The standard workaround is a spreadsheet. One per client, maintained monthly, tracking what's been accrued, what needs reversing, and what's been missed.

The approach works up to a point. But spreadsheets maintained outside Xero introduce a category of risk that compounds over time.

When the person who built the spreadsheet leaves, their replacement spends days reconstructing the logic. When a formula breaks, it produces incorrect release amounts for months before anyone notices. When a new team member takes over a client mid-year, the handover is a pile of files rather than a system.

Trudie Clarke, a bookkeeper building out an advisory package, described the broader shift happening in the industry: "We're looking at offering more of an advisory package, and obviously the accruals and the prepayments all need to be done on a monthly basis for the management accounts to be right."

The spreadsheet approach doesn't scale to advisory. If the goal is to deliver management accounts that clients can act on — and deliver them quickly — the manual process becomes the bottleneck.

What manual accruals actually cost

The time cost is the obvious one. But there are two less visible costs that matter just as much.

Accuracy. Manual calculations made under month-end pressure are prone to errors — wrong amounts, wrong periods, missed reversals. Marc Davis put it directly: "It's wrong half the time, to be honest." When accruals are inaccurate, the P&L is inaccurate. When the P&L is inaccurate, every conversation built on those figures is built on uncertain ground.

Senior time. The people doing this work manually are typically the most experienced people in the team — the ones whose time is worth most. Marc described what he'd rather be doing: "I'd rather spend my time seeing what's going on in the business than having to post journals and adjustments." Every hour a senior accountant spends on accrual journals is an hour not spent on analysis, advisory, or client relationships.

How Spread changes the process

S

pread connects to Xero and reads every invoice and attachment as it arrives throughout the month. When it detects a timing difference — a quarterly invoice posted in the wrong month, an annual subscription that should be spread across twelve months, a cost that covers multiple periods — it suggests the correct journal entries automatically.

The seven-day snapping logic handles the borderline cases that cause inconsistency in manual processes. Dom at Spread explained how it works: "If it's within seven days of the end of the month, we don't recognise that as a month — we treat it as the next month. So there's a seven-day tolerance built in, and it creates consistency because there's no discretion." Every team member applies the same rule, automatically.

For missing bills — the costs you know are coming but haven't arrived yet — the Recurring Bills area handles accruals supplier by supplier. Marc had been dealing with this manually: "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."

When the invoice eventually arrives, Spread suggests the reversal automatically, cross-referencing the journal naming conventions it used when it posted the original accrual.

What changes when accruals are automated

The most immediate change is where the work happens. Instead of a compressed seven-day close, adjustments are 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, 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."

The second change is who does the work. Chris Bennett noted the team implications after using Spread: "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. And it's actually quite good for training junior members of staff because it's very consistent — there's no discretion where they think, does this relate to January and February? The rules tell them."

Senior accountants spend their time on what changes the numbers — not on the mechanics of getting them into the right month.

Getting started

Spread connects to Xero in under two minutes. The recommended approach is to connect one client at the start of a new management period and use it alongside your existing process for a month to build confidence. Most teams start with manual review, then turn on automation for high-confidence transactions as familiarity grows.

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.