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 Aug-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.0737.9638.4636.6664.4660.6674.7675.2700.5693.42,886.32,548.9
Revenue: Orbit Logistics0.00.00.00.00.00.00.00.00.00.00.00.00.00.0
Total revenue713.9710.4724.0737.9638.4636.6664.4660.6674.7675.2700.5693.42,886.32,548.9
Revenue excl. Orbit Logistics713.9710.4724.0737.9638.4636.6664.4660.6674.7675.2700.5693.42,886.32,548.9
Cost of sales
Direct costs−102.1−100.9−103.1−102.0✱−93.8−95.1−91.0−94.8−96.6−96.6−99.1−97.4−408.2−350.9
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−102.0−93.8−95.1−91.0−94.8−96.6−96.6−99.1−97.4−408.2−350.9
Gross margin611.8609.5620.8635.9544.6541.5573.5565.7578.1578.6601.4596.02,478.12,198.0
Staff costs
Sales staff−218.7−220.3−220.4−222.9−215.1−216.8−217.0−217.2−218.3−217.6−217.6−218.6−882.3−852.8
Technology staff−351.9−354.8−358.8−357.1−338.3−336.9−341.5−343.1−348.2−345.8−351.9−349.2−1,422.6−1,339.1
Total staff costs−570.6−575.1−579.2−580.0−553.4−553.7−558.4−560.2−566.5−563.4−569.5−567.7−2,304.9−2,191.9
Other operating costs
Sales & marketing−68.1−60.0−66.6−61.2−65.9−71.4−79.8−62.6−62.4−63.4−76.7−67.5−256.0−297.6
Technology−50.3−49.7−49.2−49.3−47.4−46.9−47.5−49.3−48.0−51.0−48.3−51.1−198.6−185.2
Office & general−56.1−14.0−44.0−35.3−46.8−36.2−56.2−14.1−44.1−35.0−46.9−36.0−149.4−148.5
Total other operating costs−174.5−123.8−159.8−145.8−160.0−154.6−183.5−126.1−154.4−149.4−171.8−154.6−603.9−631.3
EBITDA−133.4−89.3−118.2−89.9−168.9−166.7−168.5−120.5−142.9−134.3−139.9−126.4−430.7−625.2
Below EBITDAC
Exceptionals−1.3−48.0−1.3−1.4−1.4−1.8−1.3−1.8−1.4−1.9−1.7−1.9−52.0−6.7
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−36.0−36.0
Total below ebitdac−10.3−57.0−10.3−10.4−10.4−10.8−10.3−10.8−10.4−10.9−10.7−10.9−88.0−42.7
Result before excluded items−143.6−146.3−128.5−100.3−179.3−177.5−178.8−131.3−153.2−145.2−150.6−137.3−518.8−668.0
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 Aug-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 · Aug-26

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

LineCommentBy
Direct costsCard processing fees went up with the new price list.finance@example.com