Demo workspace · synthetic data · Foresail, FP&A that sets itself up

Owners' pack

FY27, May-26 closeActuals May-26 to May-26 from XeroBudget: FY27 budgetGroup (simple sum of entities)Grid basis: Partner cross-sales are outside revenue and EBITDAGBP thousandsXero

Click any figure to drill down to the accounts and months behind it.

Headline

✦ Draft commentary · Xero actuals vs FY27 budget

In May-26, revenue was £713.9k, £6.7k (0.9%) above budget (incl. Partner cross-sales £1.3k below, excl. Partner cross-sales and Orbit Logistics £6.7k above). Gross margin was 85.7% of revenue, 1.6 pts below budget, and EBITDA was −£133.4k, £1.1k worse than budget. Year to date, revenue is £713.9k, 0.9% above budget, and EBITDA is −£133.4k, £1.1k worse than budget.

Results vs budget

Group · £k · positive variance is favourable on every line · prior year is the same months last year, mapped as today · click any figure

Month (May-26)Year to date (May-26 to May-26)Prior year to date
£kActualBudgetVar £kVar %ActualBudgetVar £kVar %Actualvs prior %
Revenue incl. Partner cross-sales713.9715.2−1.3−0.2%713.9715.2−1.3−0.2%626.9+13.9%
Revenue excl. Partner cross-sales713.9707.2+6.7+0.9%713.9707.2+6.7+0.9%626.9+13.9%
Revenue excl. Partner cross-sales and Orbit Logistics713.9707.2+6.7+0.9%713.9707.2+6.7+0.9%626.9+13.9%
Orbit Logistics0.00.00.0–0.00.00.0–0.0–
Cost of sales−102.1−89.7−12.4−13.9%−102.1−89.7−12.4−13.9%−85.5−19.5%
Gross margin611.8617.5−5.7−0.9%611.8617.5−5.7−0.9%541.4+13.0%
Opex−745.2−749.8+4.6+0.6%−745.2−749.8+4.6+0.6%−710.9−4.8%
EBITDA−133.4−132.3−1.1−0.8%−133.4−132.3−1.1−0.8%−169.5+21.3%

Revenue excl. Partner cross-sales £713.9k in May-26, +£6.7k (+0.9%) against budget. Year to date £713.9k, +£6.7k (+0.9%). Drivers in the month: Revenue +£6.7k.

Gross margin £611.8k in May-26, −£5.7k (−0.9%) against budget. Year to date £611.8k, −£5.7k (−0.9%). Drivers in the month: Direct costs −£12.4k and Revenue +£6.7k.

Opex −£745.2k in May-26, +£4.6k (+0.6%) against budget. Year to date −£745.2k, +£4.6k (+0.6%). Drivers in the month: Technology staff +£15.2k, Office & general −£14.4k and Sales staff +£9.7k.

EBITDA −£133.4k in May-26, −£1.1k (−0.8%) against budget. Year to date −£133.4k, −£1.1k (−0.8%). Drivers in the month: Cost of sales −£12.4k, Revenue excl. Partner cross-sales +£6.7k and Opex +£4.6k.

Gross margin is revenue less cost of sales. Opex is staff costs plus other operating costs. EBITDA is gross margin less opex, before exceptionals, interest, depreciation and excluded items. Partner cross-sales: outside revenue, gross margin and EBITDA on the grid basis. They aren't tagged in Xero, so their actuals show as zero. Orbit Logistics is shown on its own line and sits inside revenue.

Full-year outlook

FY27 · £k · best guess: actuals to Sep-26, forecast after · as at the Sep-26 close

£kBudgetBest guessVar £kVar %
Revenue incl. Partner cross-sales10,158.99,528.1−630.8−6.2%
Revenue excl. Partner cross-sales9,666.99,435.3−231.6−2.4%
Revenue excl. Partner cross-sales and Orbit Logistics9,316.99,315.3−1.60.0%
Orbit Logistics350.0120.0−230.0−65.7%
Gross margin8,512.38,175.2−337.2−4.0%
EBITDA−779.5−1,131.7−352.3−45.2%
Year-end cash (indicative)2,389.72,108.1−281.6−11.8%

Upside not in the best guess, and a risk to FP&A's forecast: the Partner cross-sales ramp FP&A assume for Oct-26 to Nov-26, +£21.2k of revenue and +£15.9k of EBITDA once Partner cross-sales are included. The best guess follows the partner's dated go-lives, so it counts only if they come in.

Year-end cash is indicative: cash at the Sep-26 month end plus EBITDA for the open months on each basis. It ignores working capital, capex and funding. Cash and funding has the cash forecast to Apr-27, which adds working capital and capex.

Budget to best guess

FY27 EBITDA, May-26 to Apr-27 · click a bar

TotalFavourableAdverse

What moved the forecast

FY27 full year · best guess now against the forecast taken after the Aug-26 close (saved with an FP&A import, 8 Sept 2026) · £k · click a change for its lines

LineThenNowChange
Revenue9,443.29,435.3−7.8
EBITDA−1,122.2−1,131.7−9.5
Revenue9,323.29,315.3−7.8
Technology staff−4,390.0−4,390.7−0.7
Sales staff−2,683.7−2,684.2−0.4
Direct costs−1,244.5−1,244.7−0.2
Office & general−765.0−765.2−0.1

Under the two headline rows, the 5 lines inside EBITDA that moved most. Positive is better: more revenue or lower costs. Closed months count as actuals in both, so a month that closed since then moves by its actual against what was forecast. The earlier forecast didn't cover Oct-26 to Apr-27, so those months count as unchanged.

Forecast track record

How close the forecast made after each month-end came to the actuals · £k

For Sep-26, the forecast taken after the Aug-26 close said EBITDA −£119.5k; actual −£128.9k (7.4% off).

MonthForecast takenRevenueTotal costsEBITDA
Sep-26After the Aug-26 close, 8 Sept 2026−7.8
1.1%
−1.7
0.2%
−9.5
7.4%
Aug-26After the Jul-26 close, 4 Aug 2026−16.8
2.3%
−24.0
2.9%
−40.8
45.4%
Jul-26After the Jun-26 close, 2 Jul 2026−2.6
0.4%
+9.5
1.1%
+7.0
5.9%
Jun-26After the May-26 close, 3 Jun 2026+13.4
1.9%
+20.9
2.6%
+34.3
38.4%
May-26After the Apr-26 close, 4 May 2026+17.1
2.4%
−15.3
1.8%
+1.8
1.4%
Apr-26After the Mar-26 close, 2 Apr 2026+4.8
0.7%
−17.6
2.1%
−12.7
10.1%

Actual less forecast in £k, with how far off as a share of the actual. Positive is better than forecast: more revenue, lower costs. Each month is scored against the latest forecast taken after the previous month's close; click a month for every line. Over these 6 months the forecast was on average 1.4% off on revenue and 18.1% off on EBITDA.

Largest variances

Group · £k · P&L lines with the biggest variance against budget, year to date to May-26 · positive is favourable

£kMay varYTD actualYTD budgetYTD varVar %
Technology staff+15.2−351.9−367.1+15.2+4.1%
Office & general−14.4−56.1−41.6−14.4−34.6%
Direct costs−12.4−102.1−89.7−12.4−13.9%
Sales staff+9.7−218.7−228.4+9.7+4.2%
Revenue+6.7713.9707.2+6.7+0.9%

Balance sheet

Group (simple sum) · £k · month-end trial balances · assets positive, liabilities negative

£kMay-26Change on AprChange on opening (Apr-26)
Cash and bank3,214.0−95.2−95.2
Receivables and advances634.8+10.2+10.2
Other current assets42.00.00.0
Fixed and intangible assets75.6−2.2−2.2
Investments500.00.00.0
Intercompany balances1.30.00.0
Current liabilities−433.2−2.6−2.6
Funding and long-term liabilities−470.0+10.0+10.0
Net assets3,564.5−79.9−79.9

Intercompany is left in so any mismatch shows, and investments in subsidiaries aren't eliminated. A dash means that month's trial balance isn't synced.

By department

Group · £k · lines inside EBITDA by the department they're mapped to · year to date to May-26 and the full year · positive variance is favourable · click any figure

DepartmentYTD actualYTD budgetYTD varFY best guessFY budgetFY var
Sales−286.9−295.1+8.2−3,554.6−3,685.9+131.3
Technology−402.2−413.1+10.8−4,987.1−5,095.9+108.7
No department555.7575.9−20.27,410.08,002.3−592.3
All departments (EBITDA)−133.4−132.3−1.1−1,131.7−779.5−352.3

FY best guess is the closed months' actuals and the best guess after them, as on Forecast & scenarios. Lines with no department are in their own row. Open Budget vs actual for any entity.

By quarter

Group · £k · latest forecast: actuals for closed months and the best guess after them, as on Forecast & scenarios · variance is latest less budget, positive is favourable · as at the Sep-26 close · click a figure in a closed quarter to see its accounts

Q1 · May-26 to Jul-26
Actual
Q2 · Aug-26 to Oct-26
2 of 3 months actual
Q3 · Nov-26 to Jan-27
Forecast
Q4 · Feb-27 to Apr-27
Forecast
Full year
Latest forecast
£kLatestBudgetVarLatestBudgetVarLatestBudgetVarLatestBudgetVarLatestBudgetVar
Revenue incl. Partner cross-sales2,148.32,232.0−83.62,249.52,482.5−233.02,503.22,649.3−146.12,627.22,795.2−168.09,528.110,158.9−630.8
Revenue excl. Partner cross-sales2,148.32,190.0−41.62,243.92,386.5−142.62,467.62,499.3−31.72,575.62,591.2−15.69,435.39,666.9−231.6
Revenue excl. Partner cross-sales and Orbit Logistics2,148.32,155.0−6.62,243.92,281.5−37.62,407.62,394.3+13.32,515.62,486.2+29.49,315.39,316.9−1.6
Orbit Logistics0.035.0−35.00.0105.0−105.060.0105.0−45.060.0105.0−45.0120.0350.0−230.0
Cost of sales−306.2−273.6−32.6−302.3−283.8−18.5−318.9−293.6−25.3−332.8−303.6−29.2−1,260.2−1,154.6−105.6
Gross margin1,842.11,916.4−74.21,941.62,102.7−161.12,148.72,205.7−57.02,242.82,287.6−44.88,175.28,512.3−337.2
Opex−2,183.0−2,260.3+77.3−2,284.6−2,288.5+3.9−2,419.6−2,337.3−82.3−2,419.6−2,405.6−14.0−9,306.9−9,291.8−15.1
EBITDA−340.9−344.0+3.1−343.0−185.7−157.2−271.0−131.7−139.3−176.9−118.1−58.8−1,131.7−779.5−352.3

Quarters follow the fiscal year from May-26. Shaded figures include forecast months; the full year opens the best guess by line. Open By quarter on Budget vs actual for any entity.

Revenue by month

Group · Xero actuals May-26 to Sep-26, best-guess forecast Oct-26 to Apr-27 · click a bar or point

Actual (Xero)Best-guess forecastFY27 budget

Revenue by entity

£k · May-26 and year to date · run-rate is the month × 12

EntityAprMayChangeYTDShareRun-rateYTD budgetYTD var
NWES151.6158.5+4.6%158.522%1,901.7147.9+10.6
NWHL0.00.0–0.00%0.00.00.0
NWUK541.8555.5+2.5%555.578%6,665.6559.4−3.9
Group693.4713.9+3.0%713.9100%8,567.3707.2+6.7

Change is May-26 against Apr-26. Run-rate is May-26 × 12: a run-rate, not a forecast. YTD budget is each entity's own revenue budget.

Customers

Group · £k · invoiced in May-26 against Apr-26, net of VAT and credit notes

What moved revenueCustomers£k
Apr-2670.7
New customers00.0
Higher from existing customers1+1.5
Lower from existing customers00.0
No longer invoiced00.0
May-2672.2
Largest customers£kShare
NWUK · Orbit Logistics plc32.044.4%
NWUK · Harbour Retail Group21.029.1%
NWES · Distribuciones Sol SA12.817.7%
NWUK · Summit Care Homes6.48.9%

Net revenue retention 102.1%: what the customers invoiced in Apr-26 brought in during May-26, new customers left out. Sales invoices from Xero, not the P&L: revenue posted by journal isn't an invoice. Open Customer revenue for each customer and month.

Cash and funding

Group · month-end balances from Xero trial balances · £k

Cash at May-26
£3,214.0k
−£95.2k on Apr-26
Average monthly change, last 3 months
−£114.6k
Burning cash
Runway
28.1 months
Cash ÷ average burn
Funding and long-term liabilities
−£470.0k
At May-26, liabilities negative
£kDec-25Jan-26Feb-26Mar-26Apr-26May-26
Cash at month end3,852.83,710.93,557.73,419.63,309.33,214.0
Change in the month−114.4−141.8−153.2−138.1−110.3−95.2

Next 13 weeks

Group · indicative, from the Sep-26 month end · £k

Opening cashLowest pointCash at week 13
2,680.22,322.5 (week 4, from 22 Oct)2,352.6

Receipts, supplier payments, payroll and PAYE on the last 3 closed months' run-rate. It leaves out VAT, capex and funding. Open Balance sheet & cash for each week and how it is built.

To the year end

Group · indicative, on the best guess from the Sep-26 month end · £k

Opening cashLowest month endCash at Apr-27
2,680.21,979.0 (Apr-27)1,979.0

Each open month's best-guess result, depreciation added back, receivables and payables at the current debtor and creditor days, and capex at the recent pace. It leaves out funding, intercompany, VAT timing and FX. Open Balance sheet & cash for each month.

Usage

Group, whole business · from the KPIs · May-26 and year to date, against the KPI budget · click a figure for its definition

AprMayChangeMay budgetYTDYTD budget
Transacting users153,000154,880+1.2%155,326154,880155,326
Users logging in249,273252,338+1.2%253,043252,338253,043
Withdrawals391,294421,652+7.8%399,165421,652399,165
Value withdrawn£23,444.1k£25,289.1k+7.9%£23,928.8k£25,289.1k£23,928.8k
Fee per withdrawal£1.62£1.62+0.2%£1.62£1.62£1.62
Revenue per withdrawal (Xero)–£1.55–£1.62£1.55£1.62
Conversion: registered to transacting42.6%42.6%0.0 pts42.6%42.6%42.6%
Conversion: logging in to transacting61.4%61.4%0.0 pts61.4%61.4%61.4%
Adoption: eligible to registered37.4%37.6%+0.2 pts35.2%37.6%35.2%

Transacting users made a withdrawal in the month. Counts add up across entities; the group uses GROUP figures only where no entity has one. Where a funnel figure (eligible, registered, logging in) has no actual yet, FP&A's estimate is used.

Ledger health

View all checks →

Open checks on the latest Xero data, as at Sep-26

1 critical and 6 warnings open.

⛔ Critical
NWES Software: net book value negative
−£17k
⚠ Warning
1 accounts with postings aren't mapped
−£12k
⚠ Warning
Doubtful debt provision swings EBITDA
£42k
⚠ Warning
Intercompany NWUK ↔ NWHL doesn't net to zero
£1,250
⚠ Warning
1 regular supplier has no bill in Sep-26
£2.9k

2 more on Health checks.

Not in Foresail yet

The monthly review also shows these. Foresail doesn't hold the data yet.

  • Revenue by stream (employee-paid, employer-paid and platform fees)
  • Employees live against budget for partner cross-sales clients
  • Sales pipeline by stage, and the weighted revenue forecast built on it
  • Security score against the shareholders' minimum

Usage now comes from the KPIs. Follow progress on What's new.

Foresail · Owners' pack · Northwind Group · FY27, May-26 close