XLSX.text v1
artifact:ev_sha256_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6

[Sheet:Read Me]
A1:Finance Reporting Data Dictionary — Management Extension
A3:Document purpose
B3:Document the finance attributes requested for management analysis, including organisational and transaction-currency enrichment.
A4:Prepared for
B4:Data and reporting discovery workshop
A5:Business owner
B5:Reporting Transformation
A6:Planning horizon
B6:FY2026–FY2027
A8:How to use this workbook
B8:Target Fields is the authoritative register of requested data objects. The working sheets contain synthetic records and formulas that illustrate grain and intended report behaviour.
A10:Scope note
B10:All sample values are fictional and are provided for design discussion, not reconciliation or production reporting.

[Sheet:Target Fields]
A1:Object Type
B1:Entity
C1:Name
D1:Data Type
E1:Business Definition
F1:Required
G1:Business Owner
H1:Calculation
I1:Planned Source
J1:Implementation Notes
A2:column
B2:Account
C2:AccountKey
D2:Int64
E2:Stable account identifier.
F2:Yes
G2:Financial Control
I2:Chart of accounts master
A3:column
B3:Account
C3:AccountName
D3:String
E3:Finance account display name.
F3:Yes
G3:Financial Control
I3:Chart of accounts master
A4:column
B4:Account
C4:AccountType
D4:String
E4:Revenue or expense classification.
F4:Yes
G4:Financial Control
I4:Chart of accounts master
A5:column
B5:Calendar
C5:DateKey
D5:Int64
E5:Integer date key in YYYYMMDD form.
F5:Yes
G5:Enterprise Data
I5:Enterprise fiscal calendar
A6:column
B6:Calendar
C6:Date
D6:DateTime
E6:Posting calendar date.
F6:Yes
G6:Enterprise Data
I6:Enterprise fiscal calendar
A7:column
B7:Calendar
C7:FiscalMonth
D7:Int64
E7:Fiscal month number.
F7:Yes
G7:Enterprise Data
I7:Enterprise fiscal calendar
A8:column
B8:Ledger
C8:DateKey
D8:Int64
E8:Posting date foreign key.
F8:Yes
G8:Financial Control
I8:General ledger postings
A9:column
B9:Ledger
C9:AccountKey
D9:Int64
E9:Account foreign key.
F9:Yes
G9:Financial Control
I9:General ledger postings
A10:column
B10:Ledger
C10:SignedAmount
D10:Decimal
E10:Signed ledger amount in reporting currency.
F10:Yes
G10:Financial Control
I10:General ledger postings
A11:column
B11:Ledger
C11:IsAdjustment
D11:Boolean
E11:Identifies late or manual adjustments.
F11:Yes
G11:Financial Control
I11:General ledger postings
A12:column
B12:Ledger
C12:CostCentre
D12:String
E12:Management cost-centre code.
F12:Yes
G12:Financial Control
I12:Finance posting source
J12:Required for operating-area accountability.
A13:column
B13:Ledger
C13:CurrencyCode
D13:String
E13:ISO transaction currency code.
F13:Yes
G13:Financial Control
I13:Finance posting source
J13:Required for transaction-currency analysis.
A14:column
B14:Account
C14:AccountGroup
D14:String
E14:Management reporting group above account type.
F14:Yes
G14:Financial Control
I14:Account master mapping
J14:Required for management roll-ups.

[Sheet:Chart of Accounts]
A1:Chart of accounts — representative rows
A2:Synthetic records at one row per finance account
A3:AccountKey
B3:AccountName
C3:AccountType
D3:AccountGroup
B4:Cash at bank
C4:Asset
D4:Working Capital
B5:Trade receivables
C5:Asset
D5:Working Capital
B6:Prepayments
C6:Asset
D6:Working Capital
B7:Trade payables
C7:Liability
D7:Working Capital
B8:Retained earnings
C8:Equity
D8:Equity
B9:Product revenue
C9:Revenue
D9:Operating Revenue
B10:Service revenue
C10:Revenue
D10:Operating Revenue
B11:Payroll
C11:Expense
D11:People
B12:Facilities
C12:Expense
D12:Corporate Services
B13:Marketing
C13:Expense
D13:Growth

[Sheet:Fiscal Calendar]
A1:Fiscal calendar — July 2025 sample
A2:Daily grain; fiscal year starts in July
A3:DateKey
B3:Date
C3:FiscalMonth

[Sheet:Ledger Sample]
A1:General ledger postings — representative extract
A2:Synthetic posting-level data in reporting-sign convention
A3:DateKey
B3:AccountKey
C3:SignedAmount
D3:IsAdjustment
E3:CostCentre
F3:CurrencyCode
E4:CC200
F4:AUD
E5:CC100
F5:AUD
E6:CC300
F6:AUD
E7:CC200
F7:NZD
E8:CC200
F8:AUD
E9:CC200
F9:AUD
E10:CC300
F10:AUD
E11:CC100
F11:AUD
E12:CC200
F12:NZD
E13:CC300
F13:AUD
E14:CC200
F14:AUD
E15:CC300
F15:AUD

[Sheet:Management P&L]
A1:Management profit and loss — July 2025 prototype
A2:Formula-driven illustration using the representative ledger extract
A3:Metric
B3:Amount
C3:Review note
D3:Sign convention
A4:Actual Revenue
C4:Product and service accounts
D4:Positive
A5:Actual Expenses
C5:Operating expense accounts
D5:Negative
A6:Actual Net
C6:Revenue plus signed expenses
D6:Net result
A7:Budget Revenue
C7:Workshop planning assumption
D7:Positive
A8:Budget Expenses
C8:Workshop planning assumption
D8:Negative
A9:Budget Net
C9:Budget revenue plus expenses
D9:Net result
A10:Net Variance
C10:Actual net less budget net
D10:Favourable positive

[Sheet:Reference Data]
A1:CostCentre
B1:AccountGroup
C1:CurrencyCode
A2:CC100
B2:People
C2:AUD
A3:CC200
B3:Commercial
C3:AUD
A4:CC300
B4:Corporate Services
C4:NZD

[Sheet:Validation]
A1:Check
B1:Result
C1:Expected
A2:Declared field count
C2:One row per requested attribute or measure
A3:Required field count
C3:All rows in the register are required