Demo workspace · synthetic data · Foresail, FP&A that sets itself up
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 variances over 10%

GBPkMay-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27YTD
Revenue
Revenue713.9710.4724.0737.9755.8783.1782.4824.9787.0807.7836.3842.22,886.3
Revenue: Orbit Logistics0.00.00.00.035.035.035.035.035.035.035.035.00.0
Total revenue713.9710.4724.0737.9790.8818.1817.4859.9822.0842.7871.3877.22,886.3
Revenue excl. Orbit Logistics713.9710.4724.0737.9755.8783.1782.4824.9787.0807.7836.3842.22,886.3
Cost of sales
Direct costs−102.1−100.9−103.1−102.0✱−94.6−95.7−96.8−97.9−99.0−100.1−101.2−102.3−408.2
Direct costs: Orbit Logistics0.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−94.6−95.7−96.8−97.9−99.0−100.1−101.2−102.3−408.2
Gross margin611.8609.5620.8635.9696.2722.4720.6762.0723.0742.6770.1774.82,478.1
Staff costs
Sales staff−218.7−220.3−220.4−222.9−240.2−240.2−240.2−240.2−247.1−247.1−238.7−238.7−882.3
Technology staff−351.9−354.8−358.8−357.1−367.1−367.1−367.1−367.1−394.8−394.8−394.8−394.8−1,422.6
Total staff costs−570.6−575.1−579.2−580.0−607.2−607.2−607.2−607.2−641.8−641.8−633.5−633.5−2,304.9
Other operating costs
Sales & marketing−68.1−60.0−66.6−61.2−66.7−66.7−69.7−69.7−69.7−69.7−69.7−69.7−256.0
Technology−50.3−49.7−49.2−49.3−47.1−47.4−47.7−48.0−50.7−51.0−51.3−51.6−198.6
Office & general−56.1−14.0−44.0−35.3−41.8−41.8−41.8−41.9−41.9−50.0−42.0−42.0−149.4
Total other operating costs−174.5−123.8−159.8−145.8−155.6−155.9−159.2−159.5−162.3−170.6−163.0−163.3−603.9
EBITDA−133.4−89.3−118.2−89.9−66.6−40.7−45.8−4.7−81.1−69.9−26.3−21.9−430.7
Below EBITDAC
Exceptionals−1.3−48.0−1.3−1.40.00.00.00.00.00.00.00.0−52.0
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
Total below ebitdac−10.3−57.0−10.3−10.4−9.0−9.0−9.0−9.0−9.0−9.0−9.0−9.0−88.0
Result before excluded items−143.6−146.3−128.5−100.3−75.6−49.7−54.8−13.7−90.1−78.9−35.3−30.9−518.8
Memo: Partner cross-sales, not in revenue or EBITDA
Revenue: Partner cross-sales0.00.00.00.032.038.044.050.056.062.068.074.00.0
Direct costs: Partner cross-sales0.00.00.00.0−3.8−4.4−5.2−5.7−6.7−7.4−7.9−8.60.0

Shaded months haven't closed: they show the budget 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