P&L year to date
Click any figure to see the Xero accounts and source behind it · dots flag variances over 5%
| GBPk | Actual YTD | Budget YTD | Var | Var % | FY budget | Prior YTD | vs prior | Sep-26 | Sep-26 budget |
|---|---|---|---|---|---|---|---|---|---|
| Revenue | |||||||||
| Revenue | 792.0 | 760.9 | +31.1 | +4.1% | 1,955.1 | 679.0 | +113.0 | 157.7 | 157.7 |
| Revenue: Orbit Logistics | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Total revenue | 792.0 | 760.9 | +31.1 | +4.1% | 1,955.1 | 679.0 | +113.0 | 157.7 | 157.7 |
| Revenue excl. Orbit Logistics | 792.0 | 760.9 | +31.1 | +4.1% | 1,955.1 | 679.0 | +113.0 | 157.7 | 157.7 |
| Cost of sales | |||||||||
| Direct costs | −103.4 | −93.2 | −10.1 | −10.9% | −231.8 | −90.2 | −13.1 | −20.7 | −19.0 |
| Direct costs: Orbit Logistics | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Total cost of sales | −103.4 | −93.2 | −10.1 | −10.9% | −231.8 | −90.2 | −13.1 | −20.7 | −19.0 |
| Gross margin | 688.6 | 667.7 | +20.9 | +3.1% | 1,723.4 | 588.8 | +99.8 | 137.0 | 138.7 |
| Staff costs | |||||||||
| Sales staff | −253.8 | −294.1 | +40.4 | +13.7% | −696.0 | −257.9 | +4.2 | −50.5 | −58.8 |
| Technology staff | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Total staff costs | −253.8 | −294.1 | +40.4 | +13.7% | −696.0 | −257.9 | +4.2 | −50.5 | −58.8 |
| Other operating costs | |||||||||
| Sales & marketing | −44.1 | −48.5 | +4.4 | +9.0% | −116.3 | −52.5 | +8.4 | 0.0 | −9.7 |
| Technology | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Office & general | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Total other operating costs | −44.1 | −48.5 | +4.4 | +9.0% | −116.3 | −52.5 | +8.4 | 0.0 | −9.7 |
| EBITDA | 390.8 | 325.1 | +65.7 | +20.2% | 911.1 | 278.4 | +112.4 | 86.5 | 70.2 |
| Below EBITDAC | |||||||||
| Exceptionals | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Interest & depreciation | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Total below ebitdac | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Result before excluded items | 390.8 | 325.1 | +65.7 | +20.2% | 911.1 | 278.4 | +112.4 | 86.5 | 70.2 |
| Memo: Partner cross-sales, not in revenue or EBITDA | |||||||||
| Revenue: Partner cross-sales | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Direct costs: Partner cross-sales | 0.0 | 0.0 | 0.0 | – | 0.0 | 0.0 | 0.0 | 0.0 | 0.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, NWES · positive variance is favourable · click any figure
| Department | Actual | Budget | Var | FY latest forecast | FY budget | FY var |
|---|---|---|---|---|---|---|
| Sales | −297.8 | −342.6 | +44.7 | −710.1 | −812.2 | +102.1 |
| Technology | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| No department | 688.6 | 667.7 | +20.9 | 1,778.9 | 1,723.4 | +55.6 |
| All departments (EBITDA) | 390.8 | 325.1 | +65.7 | 1,068.8 | 911.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.
What it takes to hit budget · 7 months left
GBPk · NWES · 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 budget | Actual to date | Still needed | Needed a month | Budget a month | Run rate a month | Latest forecast a month | FY latest forecast | |
|---|---|---|---|---|---|---|---|---|
| Revenue | 1,955.1 | 792.0 | 1,163.2 | 166.2 | 170.6 | 160.7 | 178.4 | 2,040.8 |
| Gross margin | 1,723.4 | 688.6 | 1,034.8 | 147.8 | 150.8 | 139.9 | 155.8 | 1,778.9 |
| EBITDA | 911.1 | 390.8 | 520.4 | 74.3 | 83.7 | 81.6 | 96.9 | 1,068.8 |
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.
How much of the variance is currency · May-26 to Sep-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
| Actual | At budget rates | Budget | Var | Currency | Underlying | |
|---|---|---|---|---|---|---|
| Revenue | 792.0 | 800.0 | 760.9 | +31.1 | −8.0 | +39.1 |
| Gross margin | 688.6 | 695.6 | 667.7 | +20.9 | −7.0 | +27.9 |
| EBITDA | 390.8 | 394.7 | 325.1 | +65.7 | −3.9 | +69.6 |
| Entity | Currency | Actual rate | Budget rate | Currency on revenue | Currency on EBITDA |
|---|---|---|---|---|---|
| NWES | EUR | 0.8414 | 0.8500 | −8.0 | −3.9 |
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 Sep-26
EURk · NWES in its own currency, as in its Xero file · budget at the budget's exchange rates · positive variance is favourable
| Actual | Budget | Var | Var % | |
|---|---|---|---|---|
| Revenue | 941.2 | 895.2 | +46.0 | +5.1% |
| Direct costs | −122.8 | −109.7 | −13.2 | −12.0% |
| Gross margin | 818.4 | 785.5 | +32.8 | +4.2% |
| Sales staff | −301.6 | −346.0 | +44.4 | +12.8% |
| Sales & marketing | −52.4 | −57.0 | +4.6 | +8.0% |
| EBITDA | 464.4 | 382.5 | +81.9 | +21.4% |
| Result before excluded items | 464.4 | 382.5 | +81.9 | +21.4% |
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 · Sep-26
What explains the lines for Sep-26, NWES. Lines with a comment show ✱ in the table above.
No comments for Sep-26 yet.