Work sample · Multi-entity operating group
Meridian Outdoor Group
July at a glance
Six measures for the group, after eliminations. Every change carries a sign and a word, so favorable and unfavorable never depend on the color.
Where the month came from
Every series here is drawn from the same numbers as the statements below.
Ask this report
Demo: preset questions. On an engagement this box answers anything, from the tied facts only.
The close package
One statement per company, the eliminations beside them, and the group column that comes out of both. Open any line to follow it down to the entries.
Consolidated balance sheet
What the eliminations remove
Budget vs actual, group
Close checklist
What if
The rental fleet is the decision on the table this year. Move the slider to see what a different utilization does to its EBITDA.
Notes
Written from the numbers on this page and stored with them, so a note cannot disagree with the schedule behind it.
Tie-out checks
Each check names both sides and shows whether they agree. The script that builds this data refuses to write a file when any of them fails.
How this was built
Source
System exports: rent roll, GL detail, trial balance, invoices. Nothing hand-keyed.
Pipeline
A script loads the exports, checks them, and computes every figure once. The same script runs every month.
Tie-out
Rent roll to revenue, subledgers to GL, entity totals to consolidated. Shown on the page, not assumed.
Presentation
An interactive page you can open on a phone, plus a PDF for the board or the lender.
Data
The data behind this page: Meridian Outdoor Group JSONmeridian-trial-balances.csvmeridian-eliminations.csv