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 Jun-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.4637.4656.0638.4636.6664.4660.6674.7675.2700.5693.41,424.31,255.6
Revenue: Orbit Logistics0.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Total revenue713.9710.4637.4656.0638.4636.6664.4660.6674.7675.2700.5693.41,424.31,255.6
Revenue excl. Orbit Logistics713.9710.4637.4656.0638.4636.6664.4660.6674.7675.2700.5693.41,424.31,255.6
Cost of sales
Direct costs−102.1−100.9−86.7−89.2−93.8−95.1−91.0−94.8−96.6−96.6−99.1−97.4−203.0−175.0
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−86.7−89.2−93.8−95.1−91.0−94.8−96.6−96.6−99.1−97.4−203.0−175.0
Gross margin611.8609.5550.6566.8544.6541.5573.5565.7578.1578.6601.4596.01,221.31,080.6
Staff costs
Sales staff−218.7−220.3−212.7−215.3−215.1−216.8−217.0−217.2−218.3−217.6−217.6−218.6−439.0−424.9
Technology staff−351.9−354.8−337.1−337.6−338.3−336.9−341.5−343.1−348.2−345.8−351.9−349.2−706.7−664.5
Total staff costs−570.6−575.1−549.7−552.9−553.4−553.7−558.4−560.2−566.5−563.4−569.5−567.7−1,145.7−1,089.3
Other operating costs
Sales & marketing−68.1−60.0−81.4−76.2−65.9−71.4−79.8−62.6−62.4−63.4−76.7−67.5−128.1−140.0
Technology−50.3−49.7−46.8−46.5−47.4−46.9−47.5−49.3−48.0−51.0−48.3−51.1−100.1−92.0
Office & general−56.1−14.0−43.8−35.0−46.8−36.2−56.2−14.1−44.1−35.0−46.9−36.0−70.1−69.6
Total other operating costs−174.5−123.8−171.9−157.7−160.0−154.6−183.5−126.1−154.4−149.4−171.8−154.6−298.3−301.7
EBITDA−133.4−89.3−171.0−143.8−168.9−166.7−168.5−120.5−142.9−134.3−139.9−126.4−222.7−310.4
Below EBITDAC
Exceptionals−1.3−48.0−1.9−1.3−1.4−1.8−1.3−1.8−1.4−1.9−1.7−1.9−49.3−3.5
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−18.0−18.0
Total below ebitdac−10.3−57.0−10.9−10.3−10.4−10.8−10.3−10.8−10.4−10.9−10.7−10.9−67.3−21.5
Result before excluded items−143.6−146.3−181.9−154.2−179.3−177.5−178.8−131.3−153.2−145.2−150.6−137.3−290.0−331.9
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 Jun-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 · 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.