Executive Reporting Studio
Board-ready outputs · MTD August FY25 · Sourced directly from YMC procedure & close documents
Reports Library
Consolidated MTD revenue, EBITDA, AR aging, and close metrics packaged for executive review.
Long-range financial trajectory, diversification levers, and EBITDA targets feeding the forecast.
Authoritative close calendar, recon checklist, and journal entry standards used to power the Close Hub.
Reporting hierarchy and headcount roll-up that drives Workforce & Resource utilization views.
Source document available in the YMC reference library — drives narrative and structural assertions across the hub.
Source document available in the YMC reference library — drives narrative and structural assertions across the hub.
Source document available in the YMC reference library — drives narrative and structural assertions across the hub.
Source document available in the YMC reference library — drives narrative and structural assertions across the hub.
Monthly Operating Review · Revenue & EBITDA
Expense Mix
Business Unit Performance
| Unit | Revenue | Margin | Status |
|---|---|---|---|
| Infrastructure | $28.4M | 22.4% | |
| Engineering Consulting | $19.2M | 18.1% | |
| Renewable Energy | $12.8M | 14.6% | |
| Substation Design | $9.4M | 26.3% | |
| Construction Mgmt | $7.8M | 11.2% | |
| Advisory | $4.1M | 31.8% |
A/R Aging
| Bucket | Amount | % of Total |
|---|---|---|
| Current | $4.8M | 44.2% |
| 1-30 | $2.9M | 27.0% |
| 31-60 | $1.7M | 15.4% |
| 61-90 | $920K | 8.4% |
| 90+ | $540K | 5.0% |
Close Cadence · Reporting Calendar
| Day | Task | Owner | Source | Status |
|---|---|---|---|---|
| Day +1 | Cash position snapshot | Treasury | ||
| Day +2 | AR aging refresh & collections | Controller | ||
| Day +3 | AP cut-off & accruals | AP Lead | ||
| Day +4 | Project WIP / unbilled review | Project Acctg | ||
| Day +5 | Bank reconciliations | Sr. Acctnt | ||
| Day +6 | Payroll JE & burdening | Payroll | ||
| Day +7 | Revenue recognition & POC | Controller | ||
| Day +8 | Variance analysis (Bud vs Act) | FP&A | ||
| Day +9 | Board pack assembly | CFO Office | ||
| Day +10 | Executive distribution | CFO Office |
AI Reporting Commentary
Renewable Energy margin slipped 280 bps QoQ as subcontractor costs outpaced billable utilization. Recommend tightening staffing and accelerating change-order recovery on Helios Solar Phase II.
Conversion lag concentrated in two infrastructure programs. Automating WIP-to-invoice handoff is projected to release ~$1.24M of working capital within 60 days.
Reconciliation copilot has reduced WD+5 effort by 36% MoM. Duplicate expense detection caught $48K in the last close.
Pipeline conversion is trailing forecast by 6.8%. Two enterprise utility deals are slipping into Q1; revise Q4 EBITDA guidance by ~$0.4M.
Source Documents Powering This View
| Code | Dataset | System of Record | Source Document |
|---|---|---|---|
| General Ledger | QuickBooks Online (per Aug Close Pack) | ||
| Accounts Receivable Aging | QuickBooks Online (per Aug Close Pack) | ||
| Accounts Payable Aging | QuickBooks Online (per Aug Close Pack) | ||
| Bank Statements & Recon | QuickBooks / Bank (per Aug Close Pack) | ||
| Project Cost & Margin | Deltek Vision | ||
| WIP / Unbilled A/R | Deltek Vision | ||
| Payroll Register | ADP Workforce Now | ||
| Headcount & Org Structure | ADP HRIS / Org Chart | ||
| Pipeline & Backlog | Salesforce CRM | ||
| Forecast / North Star | Finance (YMC North Star Plan) | ||
| Board Reporting Pack | Finance Reporting (Aug 2025) | ||
| Month-End Close Procedures | Finance Operations | ||
| YMC AI Copilot | AI Intelligence Layer |
Every figure on this page traces back to one of the source documents above. Hover any SRC tag on a panel or KPI to view the originating system and file. Source codes are stable and survive system migrations — only the registry mapping changes.