XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:text_cells
label:Literal text cells
status:found
inclusion:included
sensitivity:source_content
item-count:217
character-count:4445
omitted-item-count:0

[Sheet:Read Me]
A1:Finance Reporting Data Dictionary — Core Model
A3:Document purpose
B3:Document the core finance dimensions, posting facts, and management measures requested for the reporting model.
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:measure
B12:Metrics
C12:Actual Net
D12:Decimal
E12:Net actual result.
F12:Yes
G12:FP&A
H12:Actual Revenue plus signed expense balances
I12:Finance semantic calculation layer
A13:measure
B13:Metrics
C13:Actual Revenue
D13:Decimal
E13:Total actual revenue.
F13:Yes
G13:FP&A
I13:Finance semantic calculation layer
A14:measure
B14:Metrics
C14:Budget Net
D14:Decimal
E14:Budget net result.
F14:Yes
G14:FP&A
I14:Finance semantic calculation layer
A15:measure
B15:Metrics
C15:Net Variance
D15:Decimal
E15:Actual net less budget net.
F15:Yes
G15:FP&A
H15:Actual Net minus Budget Net
I15:Finance semantic calculation layer

[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
B4:Cash at bank
C4:Asset
B5:Trade receivables
C5:Asset
B6:Prepayments
C6:Asset
B7:Trade payables
C7:Liability
B8:Retained earnings
C8:Equity
B9:Product revenue
C9:Revenue
B10:Service revenue
C10:Revenue
B11:Payroll
C11:Expense
B12:Facilities
C12:Expense
B13:Marketing
C13:Expense

[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

[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:Parameter
B1:Value
C1:Purpose
A2:ReportingCurrency
B2:AUD
C2:Management reporting
A3:FiscalYearStartMonth
C3:July
A4:MaterialityThreshold
C4:Prototype validation

[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

Download the immutable receipt