Demo workspace · synthetic data · Foresail, FP&A that sets itself up
FY27Actuals to Jun-26Budget: FY27 budgetPrior year: FY26Group (simple sum of entities)Grid 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
Revenue1,424.31,425.5−1.1−0.1%9,316.91,255.6+168.7710.4718.2
Revenue: Orbit Logistics0.00.00.0–350.00.00.00.00.0
Total revenue1,424.31,425.5−1.1−0.1%9,666.91,255.6+168.7710.4718.2
Revenue excl. Orbit Logistics1,424.31,425.5−1.1−0.1%9,316.91,255.6+168.7710.4718.2
Cost of sales
Direct costs−203.0−180.5−22.6−12.5%−1,154.6−175.0−28.0−100.9−90.7
Direct costs: Orbit Logistics0.00.00.0–0.00.00.00.00.0
Total cost of sales−203.0−180.5−22.6−12.5%−1,154.6−175.0−28.0−100.9−90.7
Gross margin1,221.31,245.0−23.7−1.9%8,512.31,080.6+140.7609.5627.5
Staff costs
Sales staff−439.0−456.8+17.8+3.9%−2,867.6−424.9−14.1−220.3−228.4
Technology staff−706.7−734.1+27.5+3.7%−4,515.6−664.5−42.2−354.8−367.1
Total staff costs−1,145.7−1,190.9+45.3+3.8%−7,383.2−1,089.3−56.4−575.1−595.5
Other operating costs
Sales & marketing−128.1−133.4+5.3+3.9%−818.3−140.0+11.9−60.0−66.7
Technology−100.1−92.3−7.8−8.5%−580.3−92.0−8.1−49.7−46.3
Office & general−70.1−83.3+13.2+15.8%−510.0−69.6−0.5−14.0−41.7
Total other operating costs−298.3−309.0+10.7+3.4%−1,908.6−301.7+3.4−123.8−154.6
EBITDA−222.7−254.9+32.2+12.6%−779.5−310.4+87.7−89.3−122.6
Below EBITDAC
Exceptionals−49.30.0−49.3–0.0−3.5−45.7−48.00.0
Interest & depreciation−18.0−18.00.00.0%−108.0−18.00.0−9.0−9.0
Total below ebitdac−67.3−18.0−49.3−273.6%−108.0−21.5−45.7−57.0−9.0
Result before excluded items−290.0−272.9−17.0−6.2%−887.5−331.9+42.0−146.3−131.6
Memo: Partner cross-sales, not in revenue or EBITDA
Revenue: Partner cross-sales0.022.0−22.0−100.0%492.00.00.00.014.0
Direct costs: Partner cross-sales0.0−2.8+2.8+100.0%−58.20.00.00.0−1.8
Unmapped accounts−5.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, group view · positive variance is favourable · click any figure

DepartmentActualBudgetVarFY latest forecastFY budgetFY var
Sales−567.1−590.2+23.1−3,554.6−3,685.9+131.3
Technology−806.8−826.4+19.7−4,987.1−5,095.9+108.7
No department1,151.21,161.7−10.57,410.08,002.3−592.3
All departments (EBITDA)−222.7−254.9+32.2−1,131.7−779.5−352.3

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 · group view · 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
Revenue1,424.31,427.91,425.5−1.1−3.6+2.4
Gross margin1,221.31,224.41,245.0−23.7−3.1−20.6
EBITDA−222.7−221.0−254.9+32.2−1.7+33.9
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.

Commentary · Jun-26

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

No comments for Jun-26 yet.