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 Jul-26Budget: FY27 budgetPrior year: FY26Group (simple sum of entities)Grid basis: Partner cross-sales are a memo lineGBP thousandsXero

P&L by month

Click any figure to see the Xero accounts and source behind it · dots flag changes on last year over 10%

GBPkMay-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27YTDPrior YTD
Revenue
Revenue713.9710.4724.0656.0638.4636.6664.4660.6674.7675.2700.5693.42,148.31,893.0
Revenue: Orbit Logistics0.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Total revenue713.9710.4724.0656.0638.4636.6664.4660.6674.7675.2700.5693.42,148.31,893.0
Revenue excl. Orbit Logistics713.9710.4724.0656.0638.4636.6664.4660.6674.7675.2700.5693.42,148.31,893.0
Cost of sales
Direct costs−102.1−100.9−103.1−89.2−93.8−95.1−91.0−94.8−96.6−96.6−99.1−97.4−306.2−261.7
Direct costs: Orbit Logistics0.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Total cost of sales−102.1−100.9−103.1−89.2−93.8−95.1−91.0−94.8−96.6−96.6−99.1−97.4−306.2−261.7
Gross margin611.8609.5620.8566.8544.6541.5573.5565.7578.1578.6601.4596.01,842.11,631.3
Staff costs
Sales staff−218.7−220.3−220.4−215.3−215.1−216.8−217.0−217.2−218.3−217.6−217.6−218.6−659.4−637.5
Technology staff−351.9−354.8−358.8−337.6−338.3−336.9−341.5−343.1−348.2−345.8−351.9−349.2−1,065.5−1,001.5
Total staff costs−570.6−575.1−579.2−552.9−553.4−553.7−558.4−560.2−566.5−563.4−569.5−567.7−1,724.9−1,639.1
Other operating costs
Sales & marketing−68.1−60.0−66.6−76.2−65.9−71.4−79.8−62.6−62.4−63.4−76.7−67.5−194.8−221.4
Technology−50.3−49.7−49.2−46.5−47.4−46.9−47.5−49.3−48.0−51.0−48.3−51.1−149.3−138.8
Office & general−56.1−14.0−44.0−35.0−46.8−36.2−56.2−14.1−44.1−35.0−46.9−36.0−114.1−113.4
Total other operating costs−174.5−123.8−159.8−157.7−160.0−154.6−183.5−126.1−154.4−149.4−171.8−154.6−458.1−473.6
EBITDA−133.4−89.3−118.2−143.8−168.9−166.7−168.5−120.5−142.9−134.3−139.9−126.4−340.9−481.4
Below EBITDAC
Exceptionals−1.3−48.0−1.3−1.3−1.4−1.8−1.3−1.8−1.4−1.9−1.7−1.9−50.6−5.4
Interest & depreciation−9.0−9.0−9.0−9.0−9.0−9.0−9.0−9.0−9.0−9.0−9.0−9.0−27.0−27.0
Total below ebitdac−10.3−57.0−10.3−10.3−10.4−10.8−10.3−10.8−10.4−10.9−10.7−10.9−77.6−32.4
Result before excluded items−143.6−146.3−128.5−154.2−179.3−177.5−178.8−131.3−153.2−145.2−150.6−137.3−418.5−513.8
Memo: Partner cross-sales, not in revenue or EBITDA
Revenue: Partner cross-sales0.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Direct costs: Partner cross-sales0.00.00.00.00.00.00.00.00.00.00.00.00.00.0

Each month is set against the same month last year, mapped as today: hover a figure for last year's, and dots flag a change of more than 10%. Prior YTD is May-25 to Jul-25.

Shaded months haven't closed: they show last year's figure in grey.

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.

Commentary · Jul-26

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

No comments for Jul-26 yet.