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

Budget vs actual

GroupNWESNWHLNWUK
YTD & full yearMonthlyBy quarterBy entityLast 12 monthsAccountsReview
⤓ Export (.xlsx)
FY27Actuals to Sep-26Budget: FY27 budgetPrior year: FY26NWHL · 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 priorSep-26Sep-26 budget
Revenue
Revenue0.00.00.0–0.00.00.00.00.0
Revenue: Orbit Logistics0.00.00.0–0.00.00.00.00.0
Total revenue0.00.00.0–0.00.00.00.00.0
Revenue excl. Orbit Logistics0.00.00.0–0.00.00.00.00.0
Cost of sales
Direct costs0.00.00.0–0.00.00.00.00.0
Direct costs: Orbit Logistics0.00.00.0–0.00.00.00.00.0
Total cost of sales0.00.00.0–0.00.00.00.00.0
Gross margin0.00.00.0–0.00.00.00.00.0
Staff costs
Sales staff0.00.00.0–0.00.00.00.00.0
Technology staff0.00.00.0–0.00.00.00.00.0
Total staff costs0.00.00.0–0.00.00.00.00.0
Other operating costs
Sales & marketing0.00.00.0–0.00.00.00.00.0
Technology0.00.00.0–0.00.00.00.00.0
Office & general−30.2−31.5+1.3+4.3%−83.6−29.2−0.9−5.8−6.3
Total other operating costs−30.2−31.5+1.3+4.3%−83.6−29.2−0.9−5.8−6.3
EBITDA−30.2−31.5+1.3+4.3%−83.6−29.2−0.9−5.8−6.3
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 items−30.2−31.5+1.3+4.3%−83.6−29.2−0.9−5.8−6.3
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 Sep-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 Sep-26

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

DepartmentActualBudgetVarFY latest forecastFY budgetFY var
Sales0.00.00.00.00.00.0
Technology0.00.00.00.00.00.0
No department−30.2−31.5+1.3−72.2−83.6+11.4
All departments (EBITDA)−30.2−31.5+1.3−72.2−83.6+11.4

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.

What it takes to hit budget · 7 months left

GBPk · NWHL · what is still needed after Sep-26 to reach the full-year budget, a month, against the budget, the last 3 months and the latest forecast · click a figure for its accounts

FY budgetActual to dateStill neededNeeded a monthBudget a monthRun rate a monthLatest forecast a monthFY latest forecast
Revenue0.00.00.00.00.00.00.00.0
Gross margin0.00.00.00.00.00.00.00.0
EBITDA−83.6−30.2−53.4−7.6−7.4−6.0−6.0−72.2

Still needed is the full-year budget less the actual to date; needed a month spreads it evenly over the months left. A run rate or forecast in green reaches it, in red falls short. The run rate is the average of the last 3 months to Sep-26. A negative figure needed means the budget is already beaten or, for EBITDA, a loss it can still afford. The latest forecast is the best guess after the closed months, as on Forecast & scenarios.

Commentary · Sep-26

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

No comments for Sep-26 yet.