Skip to content
databoat

← All sample packs

Multi-entity consolidation

Arden Group

Three entities on three different systems — one of them a spreadsheet — consolidated monthly with intercompany stripped out.

Period
July 2026
Sources
3 files, one join
Branded for
Northstar CFO
Figures
4, all reconciled

Monthly performance pack

Arden Group

Three trading entities · UK and Netherlands

July 2026

Prepared by Northstar CFO

Reviewed & signed · 7 August 2026

Revenue

£503,000

▲ 6.2% vs June

Gross margin

70.0%

▲ 1.4 pts vs June

EBITDA

£45,600

▲ 18.4% vs June

Cash

£648,300

▲ £35,900 in month

Consolidated revenue for July was £503,000, up 6.2% on June and the first month above half a million.1 Labs drove it, adding £18,400 as two enterprise renewals landed in the same week; Studio grew 3.1% and Trading 7.6%.2 The £14,500 intercompany charge from Labs to Studio is eliminated on consolidation and appears in neither figure.

Gross margin improved 1.4 points to 70.0%, almost entirely mix — Labs carries an 83% margin and grew fastest, while Trading at 40.4% grew slower than the group.4 Below the line, payroll of £214,600 remains 42.7% of revenue, and EBITDA of £45,600 is a 9.1% margin against 8.1% in June.3

Cash closed at £648,300, up £35,900 in the month, with no drawdown on the facility. The three ledgers reconcile to the consolidated position and the intercompany entry nets to nil on both sides. Trading BV is converted at the July average rate of 1.1642 rather than at the closing rate, which is stated in the basis note below.✓

Drafted by Databoat from the computed figures, then edited and signed by Northstar CFO. Each citation links the sentence to the figure behind it.

FIG 1
Consolidated revenue, twelve months

All three entities, intercompany eliminated. Vertical axis starts at zero.

£200,000£400,000AugOctDecFebAprJun£503,000£398,000Aug 2025 — £398,000Sep 2025 — £412,500Oct 2025 — £405,800Nov 2025 — £431,200Dec 2025 — £447,900Jan 2026 — £419,600Feb 2026 — £452,300Mar 2026 — £461,800Apr 2026 — £458,200May 2026 — £470,100Jun 2026 — £473,600Jul 2026 — £503,000

Twelve months of identically computed numbers. The recipe has not changed since September, so the trend is a trend rather than three different definitions of revenue — which is also what makes July readable. Two enterprise renewals landed in the same week, so £503,000 is a good month rather than the new run rate.

FIG 2
Revenue by entity, June against July

Before intercompany elimination. Open marker June, filled marker July.

  • June
  • July
£100,000£150,000£200,000£250,000Arden Studio Ltd — £176,900 → £182,400 (+3.1%)Arden Studio LtdXero+3.1%Arden Labs Ltd — £228,400 → £246,800 (+8.1%)Arden Labs LtdQuickBooks+8.1%Arden Trading BV — £82,100 → £88,300 (+7.6%)Arden Trading BVSpreadsheet+7.6%
FIG 3
From revenue to EBITDA

Consolidated July, after intercompany elimination.

Revenue — £503,000£503,000RevenueCost of sales — £151,100−£151,100Cost of salesPayroll — £214,600−£214,600PayrollOther opex — £91,700−£91,700Other opexEBITDA — £45,600£45,600EBITDA

Payroll is shown separately from the rest of operating cost because it is 70% of it, and because headcount decisions are the ones this board actually makes.

FIG 4
Revenue mix by entity

Share of £517,500 before elimination, July.

Arden Labs — £246,800 · 48%48%Arden Studio — £182,400 · 35%35%Arden Trading — £88,300 · 17%17%
  • Arden Labs · £246,800
  • Arden Studio · £182,400
  • Arden Trading · £88,300

Trading is 17% of revenue and 10% of gross profit; Labs is 48% and 58%. Weighted by what each entity keeps rather than what it bills, this chart is a different shape — and that is the one the board should be looking at.

Entity revenues sum to consolidated revenue after elimination

£517,500 − £14,500 = £503,000

Exact

The intercompany charge nets to nil across the two ledgers

Labs +£14,500 · Studio −£14,500 = £0

Exact

Payroll register total equals the payroll line above

41 employees · £214,600 gross

Exact

Trading BV converted at the July average rate, not the closing rate

EUR 102,800 ÷ 1.1642 = £88,300

Basis

xero_studio_pl_jul26.csv

Xero profit and loss export — Arden Studio Ltd, account-level detail

Arrived 4 Aug

qbo_labs_2026-07.xlsx

QuickBooks export — Arden Labs Ltd, with a separate deferred revenue tab

Arrived 4 Aug

arden_bv_july_EUR.xlsx

Spreadsheet kept by the Dutch bookkeeper — EUR, one sheet per quarter

Arrived 6 Aug

Joined on entity code and period, with a mapping from each ledger’s own chart of accounts to a single group chart. Computed by recipe v11 — frozen 8 September 2025 — which is why the twelve-month series above is comparable end to end. The BV spreadsheet changed shape in April; the drift was flagged and the mapping extended rather than re-inferred.

EntityRevenueCost of salesGross profitMargin
Arden Studio Ltd£182,400£71,100£111,30061.0%
Arden Labs Ltd£246,800£41,900£204,90083.0%
Arden Trading BV£88,300£52,600£35,70040.4%
Intercompany elimination£-14,500£-14,500£0—
Group£503,000£151,100£351,90070.0%

Arden Group · July 2026 · prepared by Northstar CFO

Built with Databoat

The first month, Databoat proposes this pack from your files and you keep what earns its place. Every month after, it rebuilds from the new exports — computed identically, with the commentary drafted for your edit and your branding already applied.

Tell us what you rebuild

Early access

Tell us the report you rebuild

Early access opens practice by practice. Tell us the report you rebuild every month and the files behind it. If it’s close to something we already handle, we’ll ask for a sample and set you up on your real data. If not, we’ll say so plainly rather than park you on a list.

A person replies. No drip sequence, no card, nothing charged.