Demo workspace · synthetic data · Foresail, FP&A that sets itself up
FY27Actuals to Jun-26Budget: FY27 budgetPrior year: FY26NWES · entity budgetGrid basis: Partner cross-sales are a memo lineGBP thousandsXero

P&L year to date

Click any figure to see the Xero accounts and source behind it · dots flag variances over 5%

GBPkActual YTDBudget YTDVarVar %FY budgetPrior YTDvs priorJun-26Jun-26 budget
Revenue
Revenue309.8297.5+12.3+4.1%1,955.1266.8+43.0151.3149.6
Revenue: Orbit Logistics0.00.00.0–0.00.00.00.00.0
Total revenue309.8297.5+12.3+4.1%1,955.1266.8+43.0151.3149.6
Revenue excl. Orbit Logistics309.8297.5+12.3+4.1%1,955.1266.8+43.0151.3149.6
Cost of sales
Direct costs−40.7−36.7−4.0−10.8%−231.8−36.2−4.5−19.9−18.5
Direct costs: Orbit Logistics0.00.00.0–0.00.00.00.00.0
Total cost of sales−40.7−36.7−4.0−10.8%−231.8−36.2−4.5−19.9−18.5
Gross margin269.0260.7+8.3+3.2%1,723.4230.6+38.5131.4131.1
Staff costs
Sales staff−101.5−117.6+16.1+13.7%−696.0−103.5+2.0−50.7−58.8
Technology staff0.00.00.0–0.00.00.00.00.0
Total staff costs−101.5−117.6+16.1+13.7%−696.0−103.5+2.0−50.7−58.8
Other operating costs
Sales & marketing−21.7−19.4−2.3−11.8%−116.3−22.1+0.5−11.5−9.7
Technology0.00.00.0–0.00.00.00.00.0
Office & general0.00.00.0–0.00.00.00.00.0
Total other operating costs−21.7−19.4−2.3−11.8%−116.3−22.1+0.5−11.5−9.7
EBITDA145.9123.7+22.2+17.9%911.1104.9+40.969.262.6
Below EBITDAC
Exceptionals0.00.00.0–0.00.00.00.00.0
Interest & depreciation0.00.00.0–0.00.00.00.00.0
Total below ebitdac0.00.00.0–0.00.00.00.00.0
Result before excluded items145.9123.7+22.2+17.9%911.1104.9+40.969.262.6
Memo: Partner cross-sales, not in revenue or EBITDA
Revenue: Partner cross-sales0.00.00.0–0.00.00.00.00.0
Direct costs: Partner cross-sales0.00.00.0–0.00.00.00.00.0

Prior YTD is May-25 to Jun-25, mapped as today. vs prior is this year less last year: positive is favourable.

Partner cross-sales aren't tagged in Xero: their revenue sits in the ordinary revenue accounts, so their own lines show no actuals. Orbit Logistics shows actuals once a Xero account is mapped to it on Data & mapping. The budget keeps Orbit Logistics's direct costs inside Direct costs; forecasts put them on their own line.

By department · May-26 to Jun-26

GBPk · lines inside EBITDA by the department they're mapped to, NWES · positive variance is favourable · click any figure

DepartmentActualBudgetVarFY latest forecastFY budgetFY var
Sales−123.2−137.0+13.8−710.1−812.2+102.1
Technology0.00.00.00.00.00.0
No department269.0260.7+8.31,778.91,723.4+55.6
All departments (EBITDA)145.9123.7+22.21,068.8911.1+157.7

FY latest forecast is the closed months' actuals and the best guess after them, as on Forecast & scenarios. Lines with no department are in their own row.

How much of the variance is currency · May-26 to Jun-26

GBPk · NWES · the year to date at the budget's exchange rates, so the variance splits into currency and the rest · positive is favourable

ActualAt budget ratesBudgetVarCurrencyUnderlying
Revenue309.8313.3297.5+12.3−3.6+15.8
Gross margin269.0272.1260.7+8.3−3.1+11.4
EBITDA145.9147.5123.7+22.2−1.7+23.8
EntityCurrencyActual rateBudget rateCurrency on revenueCurrency on EBITDA
NWESEUR0.84040.8500−3.6−1.7

Currency is the actual less the actual at the budget's rates: what exchange rates alone added or took away. Underlying is the actual at the budget's rates less the budget, so the two add up to the variance. GBP entities are the same at either rate. Actual figures use each month's average ECB rate, as synced. Budget rates are from the assumption set "FY27 budget", which made the budget on file.

In EUR · May-26 to Jun-26

EURk · NWES in its own currency, as in its Xero file · budget at the budget's exchange rates · positive variance is favourable

ActualBudgetVarVar %
Revenue368.6350.0+18.6+5.3%
Direct costs−48.4−43.2−5.2−12.1%
Gross margin320.1306.7+13.4+4.4%
Sales staff−120.8−138.4+17.6+12.7%
Sales & marketing−25.8−22.8−3.0−13.1%
EBITDA173.6145.5+28.0+19.3%
Result before excluded items173.6145.5+28.0+19.3%

The lines as mapped above, so each one ties to the same accounts in NWES's own Xero file for the same months; unmapped accounts are left out, as in the table above. Costs are negative. The budget is in GBP and is restated at the rate it was built at for each month, from the assumption set "FY27 budget". The table above is in GBP at each month's average ECB rate.

Commentary · Jun-26

What explains the lines for Jun-26, NWES. Lines with a comment show ✱ in the table above.

No comments for Jun-26 yet.