How Fractional FDs Manage Accruals, Prepayments and Deferred Revenue Across Multiple Clients in Xero
- Simon Hancott

- Jul 1
- 8 min read

The fractional FD model has a specific month-end problem that nobody talks about directly. It is not that the work is technically difficult. It is that the same technically straightforward work, accruals, prepayments, revenue recognition adjustments that has to be done again for every client, in a slightly different way, against a slightly different spreadsheet, with a slightly different bookkeeping setup behind it.
At one client it is a marketing agency with a stack of annual software subscriptions and advertising prepayments. At another it is a media startup where the bank reconciliation is basically the whole job. At a third it is a multi-site operation with 12 clinics, 800 rows of prepayments, and tracking categories to replicate across every journal.
Each one is manageable in isolation. Combined, across a working month, they become the constraint on how many clients you can actually serve well, and how much of your time goes on mechanical adjustment work versus the strategic advice you are supposed to be delivering.
The Problem With The Spreadsheet Approach At Scale
Marc, a fractional FD working with an agency and a media startup, described the situation plainly: "That's another piece that's all done manually in Excel, and it's wrong half the time, to be honest."
That phrase, wrong half the time, is more common than people admit. Not catastrophically wrong. Not audit-failing wrong. Just quietly, persistently inaccurate in ways that compound over time: an insurance prepayment released a month early, a software subscription that nobody accrued for because the invoice arrived after the management accounts were sent, a deferred income balance that doesn't reconcile cleanly because someone changed the invoice description mid-year.
The spreadsheet works when you are doing it yourself for one client you know well. It starts to break when you are context-switching between five or six clients, each with their own chart of accounts, their own supplier relationships, and their own bookkeeper who may or may not be following the same conventions as last month.
Andy, a fractional CFO working with founder-led businesses, framed it as a quality problem as much as a time problem: "This isn't work that I want to be doing, but garbage in, garbage out, I have to make sure the true picture is being provided to me so I can start to provide some insight."
The adjustment work is the foundation. If it is wrong, everything built on top of it is wrong. The strategic advice, the variance analysis, the board pack, all of it depends on P&L and balance sheet numbers that actually reflect reality rather than when invoices happened to land.
What The Adjustment Layer Looks Like Across A Typical Fractional FD Portfolio
The volume varies significantly by client type. But across a typical fractional FD portfolio, the month-end adjustment workload usually falls into three categories.
Prepayments are the most consistent source of volume. Annual insurance premiums, software licences, quarterly rent invoices, maintenance contracts, and any cost paid upfront that covers multiple future periods. For an agency client with a heavy technology stack and a mix of annual and quarterly contracts, this alone can run to 30 or 40 invoices per month that need splitting across the correct periods.
Accruals for missing bills are the most error-prone. These are the costs that belong in the period but the invoice has not yet arrived. Utility bills, professional fees, contractor costs, the ones where, as Marc put it, "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." Without a systematic approach, accruals for missing invoices tend to be inconsistent: some clients accrue them carefully, others post them to budget and hope for the best, and the reversal process when the invoice eventually lands is often missed entirely.
Deferred revenue is the adjustment that founder-led businesses most commonly skip altogether. Andy described a sports coaching client booking income at the point of payment for activities delivered in future periods: "They don't defer the income from January and roll it through February. And because that's worked for them for 15 years, they're kind of happy." As a fractional FD trying to provide meaningful trend analysis, that missing deferral makes month-on-month comparisons unreliable, and explaining why to a founder who has run the business successfully for 15 years without ever doing it is a harder conversation than just fixing it.
The Multi-Client Context-Switching Problem
The challenge for fractional FDs is not any single one of these tasks. It is that they all happen simultaneously, across different clients, with different bookkeeping setups and different levels of process maturity behind them.
Ryan, a fractional CFO working with a multi-entity hospitality group, described the volume directly: his month-end adjustment process was taking the equivalent of a couple of days per month across the group. Not because each individual adjustment was complex. Because there were a lot of them, spread across multiple entities, with tracking categories to maintain across every journal entry.
The multi-entity dimension adds another layer of complexity that does not exist for in-house finance teams. Each client organisation is a separate Xero account. Adjustments posted in one have no visibility in another. If you are reconciling four entities that form a group, you need a process that works consistently across all four, not four slightly different versions of the same spreadsheet.
Tracking categories compound this further. If a client uses Xero tracking categories for department, site, or project reporting, every adjustment journal needs to replicate the correct tracking from the source invoice. Getting this wrong at the journal level creates reconciliation problems at the management accounts level, and tracing them back after the fact is significantly more time-consuming than getting them right first time.
How Spread Works For Fractional FDs Managing Multiple Xero Clients
Spread connects to Xero and reads every invoice and bill as it is posted, both the line item descriptions and the PDF attachments. It detects timing differences, builds the adjustment schedule, and suggests or automatically posts the journals. For fractional FDs managing multiple clients, the key features are the ones that remove the need to think about each client individually every month.
One dashboard, multiple organisations.
Every connected Xero organisation appears in a single Spread account. You can see the status of every client's month-end adjustments without logging into each Xero account separately. Anything flagged as Ready has been detected with high confidence and can be posted in bulk or automated entirely. Anything marked To Review needs a quick check before posting.
Automation that matches your bookkeeping quality.
The more consistently the description lines in Xero contain the service period, and tools like Apron or Dext help significantly with this, the higher the proportion of adjustments that can run on full automation. For a client where the bookkeeping is clean and descriptions are standardised, month-end accruals and prepayments can be close to fully automated, with a 30-minute balance sheet review at the end. For a client where the bookkeeping is less consistent, Spread's OCR reads the invoice attachments and catches roughly 80% of adjustments that would otherwise require manual review.
Tracking category replication.
Every journal Spread posts carries the same tracking categories as the source transaction in Xero. If a quarterly rent invoice is coded to a specific site or department in Xero, the prepayment journals replicate that coding automatically. This is the detail that matters for multi-site clients and group reporting and it is the detail that manual journals most commonly get wrong when someone is working quickly at month-end.
Missing bills management. The Recurring Bills feature allows you to configure which suppliers you expect to be billed by and at what frequency for each client. When month-end arrives and an expected invoice has not landed, Spread suggests the accrual automatically. When the invoice eventually arrives, it cross-references the journal naming conventions from the original accrual and suggests the correct reversal. For clients with regular supplier relationships and consistent billing cycles, this replaces the process of going through every supplier manually and asking whether something should have arrived.
Balance sheet reconciliation by client.
At month-end, Spread produces a reconciliation export for each organisation showing every adjustment posted, by invoice number, supplier, service period, and balance sheet movement. The closing balance on each line ties directly to the relevant account in Xero. For a fractional FD reviewing four or five client month-ends in a compressed window, this replaces the process of cross-referencing spreadsheet schedules against Xero balance sheet accounts line by line.
The Practical Question of How To Set It Up For Clients
Andy raised the question that most fractional FDs consider when they first look at Spread: who subscribes and who controls the account?
The practical answer depends on the nature of the engagement. For clients where the fractional FD is the primary finance function, it often makes sense for the FD to manage the Spread subscription and give the client's bookkeeper or finance administrator access to their organisation only. They see their own data, the FD has visibility across all clients, and the subscription sits in one place.
For clients with an existing in-house finance team, the client typically manages the subscription themselves, and the fractional FD uses Spread as part of the review and sign-off process rather than as the primary operator.
Either model works. The key requirement is that the bookkeeping upstream, specifically the description lines on invoices in Xero, is consistent enough for Spread to detect timing differences reliably. For most fractional FDs, this means a short conversation with whoever processes the invoices about how descriptions should be formatted. Once that is in place, the automation runs without further intervention.
What Changes When The Adjustment Layer Is Automated
The obvious change is time. Fewer hours per month on mechanical journal work means more hours available for the advisory work that justifies the fractional FD fee in the first place.
The less obvious change is consistency. When accruals and prepayments run through the same automated process across every client, every month, the output is more consistent than when they are done manually by different people in different ways. Journals are named consistently, tracking categories are applied consistently, balance sheet reconciliations follow the same format. For a fractional FD who may eventually hand a client over to an in-house finance team or a different provider, that consistency is worth something beyond the time saving.
Marc put the underlying point clearly: "I'd rather spend my time seeing what's going on in the business than having to post journals and adjustments and things."
That is what the fractional FD model is supposed to be. The adjustment work is necessary. It does not have to be the thing that fills the available time.
Getting Started
Spread connects to Xero in under two minutes per organisation. The recommended starting point for a new client is the beginning of a management period, everything processed in Xero from that point flows through Spread, while historical entries stay in the existing process.
Most fractional FDs start with manual review for the first month-end: checking what Spread suggests, comparing against source invoices, building confidence in the output. Once the first month-end reconciliation ties cleanly, automation can be enabled for high-confidence transactions and the process becomes largely self-managing.
There is a free trial. Connect a single client organisation first, one month-end is enough to know whether it works for your practice.
Every quote in this post is drawn from real conversations with fractional FDs and fractional CFOs. Names have been changed to protect client confidentiality but the substance of every comment is unchanged.




Comments