Source intake
CRM, billing, contract, ERP, and forecast exports
Customer Cube
Infrastructure
CRM, billing, contract, ERP, and forecast exports
Account, product, period, cohort, segment, and geography
Customer Cube schedules and Data Pack chart pages
Definitions, caveats, exception log, and consulting escalation
Cube structure
Account, parent account, customer ID, logo, buying group, or buyer-defined customer hierarchy with explicit matching rules.
SKU, module, service line, contract line, bundle, product family, or revenue category tied to the source hierarchy where available.
Monthly, quarterly, fiscal-year, and LTM views reconciled to billing, revenue, ARR/MRR, or management reporting definitions.
Geography, vertical, cohort, segment, channel, contract type, customer tier, customer size, and renewal window.
Builder
const sourceFiles = intake.crm + intake.billing;const customerMap = reconcile(sourceFiles);return generateCube(customerMap, definitions);Monarch AI
Evidence BuilderDescribe the output, source systems, required definitions, and review constraints.Customer CubeData PackException LogInputs stay tied to customer records and source exceptions.
Cube and Data Pack patterns repeat across transactions.
Definitions, caveats, and boundaries stay visible.
Commercial interpretation is separated from standard analytics.
Workbook evidence
Output
XLSXSegmented Excel workbookCore use
M&AStandard customer deliverableAlso useful for
Pre-M&AClient-base analysisSource checks
VisibleDefinitions and exceptionsRequired source fields
Customer-level revenue history by month, quarter, or year
Customer identity fields that can support parent-child matching
Product or service-line identifiers tied to revenue where available
Contract, billing, renewal, and recurring-revenue fields if retention or ARR analysis is in scope
Management reporting definitions for revenue, ARR, MRR, bookings, churn, and expansion
Segment fields such as vertical, geography, channel, tier, size, or cohort
Account, parent account, customer ID, logo, buying group, or buyer-defined customer hierarchy with explicit matching rules.
SKU, module, service line, contract line, bundle, product family, or revenue category tied to the source hierarchy where available.
Monthly, quarterly, fiscal-year, and LTM views reconciled to billing, revenue, ARR/MRR, or management reporting definitions.
Geography, vertical, cohort, segment, channel, contract type, customer tier, customer size, and renewal window.
Diligence use
Definition governance
Parent-child account matching, legal-entity names, customer IDs, duplicate accounts, and acquired customer mappings are documented before metrics are trusted.
Revenue, ARR, MRR, bookings, billings, services, usage, refunds, credits, FX, and one-time items must be explicitly defined.
Cohorts can be based on first purchase, subscription start, contract start, first invoice, or management-defined vintage; the chosen policy is disclosed.
Calendar months, fiscal periods, LTM cuts, partial periods, renewal windows, and stub periods are aligned before trend analysis.
Unmapped customers, duplicate products, missing renewal dates, inconsistent currency, and unreconciled totals are captured for review.
Outputs are analytical support. Deal teams and their advisers should review assumptions, definitions, and exceptions before relying on the pack.