Skip to content

Controlling — Management Reporting COA Overlay

Management reporting often needs a different grouping than statutory COA. Store the mapping as versioned, approved data.

Why this is needed

  • EBITDA differs across teams because mappings live in Excel.
  • Restatements need an explicit mapping version.
  • Controlling owns the overlay; ERP owns statutory COA.

Proposed entities in EntiHub

Governance settings

Setting Recommended value Why
approvalRequired true Mapping changes change management P&L.
historyEnabled true Time-travel / history for restatements.
allowSameAuthorApproval false Maker/checker separation for sensitive changes.
deletedRetentionDays 90 (or higher) Soft-delete retention for auditability.

Entity definition (YAML sketch)

name: mgmt_account_map
displayName: Management account map
domain: Finance
description: Management account map
version: "1.0.0"
approvalRequired: true
historyEnabled: true
deletedRetentionDays: 90
displayRefColumn: map_code
uniqueConstraints:
  - name: uq_mgmt_account_map_0
    columns: [version_label, statutory_account]
columns:
  - name: map_code
    dataType: string
    nullable: false
    maxLength: 64
  - name: version_label
    dataType: string
    nullable: false
    maxLength: 32
  - name: statutory_account
    dataType: string
    nullable: false
    maxLength: 32
  - name: mgmt_account
    dataType: string
    nullable: false
    maxLength: 64
  - name: mgmt_hierarchy_node
    dataType: string
    nullable: false
    maxLength: 128
  - name: status
    dataType: string
    nullable: false
    maxLength: 16

YAML sketches

Sketches highlight the important fields and governance flags. Trim or extend columns to match your domain. See Setup Entity for the full YAML reference.

Sample data

map_code version_label statutory_account mgmt_account mgmt_hierarchy_node status
MAM-100 2026-V1 400000 NET_SALES P&L / Revenue approved
MAM-101 2026-V1 500000 COGS P&L / Costs approved

Benefits for the company

  • One mapping version for all management reports.
  • Restatement narrative becomes data-backed.
  • Separates statutory COA from management view.