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

Owners' pack

FY27, Jul-26 closeActuals May-26 to Jul-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 Jul-26, revenue was £724.0k, £40.5k (5.3%) below budget (incl. Partner cross-sales £60.5k below, excl. Partner cross-sales and Orbit Logistics £5.5k below). Gross margin was 85.8% of revenue, 2.1 pts below budget, and EBITDA was −£118.2k, £29.1k worse than budget. Year to date, revenue is £2,148.3k, 1.9% below budget, and EBITDA is −£340.9k, £3.1k better 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 (Jul-26)Year to date (May-26 to Jul-26)Prior year to date
£kActualBudgetVar £kVar %ActualBudgetVar £kVar %Actualvs prior %
Revenue incl. Partner cross-sales724.0784.5−60.5−7.7%2,148.32,232.0−83.6−3.7%1,893.0+13.5%
Revenue excl. Partner cross-sales724.0764.5−40.5−5.3%2,148.32,190.0−41.6−1.9%1,893.0+13.5%
Revenue excl. Partner cross-sales and Orbit Logistics724.0729.5−5.5−0.8%2,148.32,155.0−6.6−0.3%1,893.0+13.5%
Orbit Logistics0.035.0−35.0−100.0%0.035.0−35.0−100.0%0.0–
Cost of sales−103.1−93.1−10.0−10.8%−306.2−273.6−32.6−11.9%−261.7−17.0%
Gross margin620.8671.4−50.5−7.5%1,842.11,916.4−74.2−3.9%1,631.3+12.9%
Opex−739.0−760.4+21.4+2.8%−2,183.0−2,260.3+77.3+3.4%−2,112.7−3.3%
EBITDA−118.2−89.1−29.1−32.7%−340.9−344.0+3.1+0.9%−481.4+29.2%

Revenue excl. Partner cross-sales £724.0k in Jul-26, −£40.5k (−5.3%) against budget. Year to date £2,148.3k, −£41.6k (−1.9%). Drivers in the month: Orbit Logistics −£35.0k and Revenue −£5.5k.

Gross margin £620.8k in Jul-26, −£50.5k (−7.5%) against budget. Year to date £1,842.1k, −£74.2k (−3.9%). Drivers in the month: Orbit Logistics −£35.0k, Direct costs −£10.0k and Revenue −£5.5k.

Opex −£739.0k in Jul-26, +£21.4k (+2.8%) against budget. Year to date −£2,183.0k, +£77.3k (+3.4%). Drivers in the month: Sales staff +£18.0k, Technology staff +£8.3k and Technology −£2.6k.

EBITDA −£118.2k in Jul-26, −£29.1k (−32.7%) against budget. Year to date −£340.9k, +£3.1k (+0.9%). Drivers in the month: Revenue excl. Partner cross-sales −£40.5k, Opex +£21.4k and Cost of sales −£10.0k.

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 Jul-26 · positive is favourable

£kJul varYTD actualYTD budgetYTD varVar %
Sales staff+18.0−659.4−695.2+35.8+5.2%
Technology staff+8.3−1,065.5−1,101.2+35.7+3.2%
Orbit Logistics−35.00.035.0−35.0−100.0%
Direct costs−10.0−306.2−273.6−32.6−11.9%
Office & general−2.3−114.1−125.0+10.9+8.7%

Balance sheet

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

£kJul-26Change on JunChange on opening (Apr-26)
Cash and bank2,974.1−133.4−335.2
Receivables and advances655.8+10.6+31.2
Other current assets42.00.00.0
Fixed and intangible assets71.1−2.3−6.8
Investments500.00.00.0
Intercompany balances1.30.00.0
Current liabilities−431.5+1.1−0.9
Funding and long-term liabilities−450.0+10.0+30.0
Net assets3,362.7−114.1−281.6

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 Jul-26 and the full year · positive variance is favourable · click any figure

DepartmentYTD actualYTD budgetYTD varFY best guessFY budgetFY var
Sales−854.2−895.3+41.1−3,554.6−3,685.9+131.3
Technology−1,214.7−1,240.0+25.3−4,987.1−5,095.9+108.7
No department1,728.01,791.4−63.37,410.08,002.3−592.3
All departments (EBITDA)−340.9−344.0+3.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 · Jul-26 and year to date · run-rate is the month × 12

EntityJunJulChangeYTDShareRun-rateYTD budgetYTD var
NWES151.3159.6+5.5%469.322%1,914.7448.7+20.6
NWHL0.00.0–0.00%0.00.00.0
NWUK559.1564.4+1.0%1,679.078%6,773.21,741.2−62.2
Group710.4724.0+1.9%2,148.3100%8,687.82,190.0−41.6

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

Customers

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

What moved revenueCustomers£k
Apr-26 to May-26142.8
New customers00.0
Higher from existing customers1+6.0
Lower from existing customers00.0
No longer invoiced00.0
Jun-26 to Jul-26148.8
Largest customers£kShare
NWUK · Orbit Logistics plc68.546.0%
NWUK · Harbour Retail Group42.028.2%
NWES · Distribuciones Sol SA25.517.1%
NWUK · Summit Care Homes12.88.6%

Net revenue retention 104.2%: what the customers invoiced in Apr-26 to May-26 brought in during Jun-26 to Jul-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 Jul-26
£2,974.1k
−£133.4k on Jun-26
Average monthly change, last 3 months
−£111.7k
Burning cash
Runway
26.6 months
Cash ÷ average burn
Funding and long-term liabilities
−£450.0k
At Jul-26, liabilities negative
£kFeb-26Mar-26Apr-26May-26Jun-26Jul-26
Cash at month end3,557.73,419.63,309.33,214.03,107.52,974.1
Change in the month−153.2−138.1−110.3−95.2−106.5−133.4

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 · Jul-26 and year to date, against the KPI budget · click a figure for its definition

JunJulChangeJul budgetYTDYTD budget
Transacting users156,840158,888+1.3%165,822156,869158,712
Users logging in252,981256,289+1.3%257,600253,869254,373
Withdrawals397,870407,844+2.5%426,3921,227,3661,223,887
Value withdrawn£23,853.3k£24,427.2k+2.4%£24,365.7k£73,569.6k£72,178.9k
Fee per withdrawal£1.62£1.61−0.2%£1.62£1.62£1.62
Revenue per withdrawal (Xero)£1.62£1.61−0.2%£1.62£1.59£1.62
Conversion: registered to transacting43.0%43.0%0.0 pts44.7%42.9%43.3%
Conversion: logging in to transacting62.0%62.0%0.0 pts64.4%61.8%62.4%
Adoption: eligible to registered37.8%38.0%+0.2 pts35.6%37.8%35.4%

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, Jul-26 close