Demo workspace · synthetic data · Foresail, FP&A that sets itself up
FY27Actuals to Sep-26Budget: FY27 budgetPrior year: FY26Group (simple sum of entities)Grid 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
Revenue3,628.13,653.4−25.3−0.7%9,316.93,187.3+440.8741.9755.8
Revenue: Orbit Logistics0.0105.0−105.0−100.0%350.00.00.00.035.0
Total revenue3,628.13,758.4−130.3−3.5%9,666.93,187.3+440.8741.9790.8
Revenue excl. Orbit Logistics3,628.13,653.4−25.3−0.7%9,316.93,187.3+440.8741.9755.8
Cost of sales
Direct costs−507.8−461.7−46.2−10.0%−1,154.6−444.7−63.1−99.6−94.6
Direct costs: Orbit Logistics0.00.00.0–0.00.00.00.00.0
Total cost of sales−507.8−461.7−46.2−10.0%−1,154.6−444.7−63.1−99.6−94.6
Gross margin3,120.33,296.7−176.4−5.4%8,512.32,742.6+377.7642.2696.2
Staff costs
Sales staff−1,104.0−1,175.6+71.6+6.1%−2,867.6−1,068.0−36.0−221.6−240.2
Technology staff−1,781.7−1,835.3+53.6+2.9%−4,515.6−1,677.4−104.4−359.2−367.1
Total staff costs−2,885.7−3,010.9+125.2+4.2%−7,383.2−2,745.3−140.4−580.8−607.2
Other operating costs
Sales & marketing−325.1−333.5+8.3+2.5%−818.3−363.5+38.4−69.1−66.7
Technology−249.0−232.8−16.2−7.0%−580.3−232.7−16.3−50.4−47.1
Office & general−220.2−208.5−11.6−5.6%−510.0−195.2−24.9−70.8✱−41.8
Total other operating costs−794.2−774.8−19.5−2.5%−1,908.6−791.4−2.9−190.4−155.6
EBITDA−559.7−489.0−70.7−14.5%−779.5−794.1+234.4−128.9−66.6
Below EBITDAC
Exceptionals−53.90.0−53.9–0.0−8.2−45.7−1.80.0
Interest & depreciation−45.0−45.00.00.0%−108.0−45.00.0−9.0−9.0
Total below ebitdac−98.9−45.0−53.9−119.7%−108.0−53.2−45.7−10.8−9.0
Result before excluded items−658.5−534.0−124.6−23.3%−887.5−847.3+188.8−139.8−75.6
Memo: Partner cross-sales, not in revenue or EBITDA
Revenue: Partner cross-sales0.0100.0−100.0−100.0%492.00.00.00.032.0
Direct costs: Partner cross-sales0.0−12.2+12.2+100.0%−58.20.00.00.0−3.8
Unmapped accounts−12.3

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, group view · positive variance is favourable · click any figure

DepartmentActualBudgetVarFY latest forecastFY budgetFY var
Sales−1,429.1−1,509.0+79.9−3,554.6−3,685.9+131.3
Technology−2,030.7−2,068.1+37.4−4,987.1−5,095.9+108.7
No department2,900.13,088.1−188.07,410.08,002.3−592.3
All departments (EBITDA)−559.7−489.0−70.7−1,131.7−779.5−352.3

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 · group view · 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
Revenue9,666.93,628.16,038.8862.7844.1734.6829.69,435.3
Gross margin8,512.33,120.35,392.1770.3745.1633.0722.18,175.2
EBITDA−779.5−559.7−219.8−31.4−41.5−112.3−81.7−1,131.7

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 · group view · the year to date at the budget's exchange rates, so the variance splits into currency and the rest · positive is favourable

ActualAt budget ratesBudgetVarCurrencyUnderlying
Revenue3,628.13,636.13,758.4−130.3−8.0−122.2
Gross margin3,120.33,127.33,296.7−176.4−7.0−169.4
EBITDA−559.7−555.7−489.0−70.7−3.9−66.8
EntityCurrencyActual rateBudget rateCurrency on revenueCurrency on EBITDA
NWESEUR0.84140.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.

Commentary · Sep-26

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

LineCommentBy
Office & generalOne-off office move costs this month.finance@example.com