XLSX.evidence v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
profile:metadata-all
source-kind:xlsx
cell-values:literal-text-only
formulas:included
binary-payloads:indicator-only

[Workbook]
::workbook_metadata [status=found; inclusion=included; sensitivity=metadata; items=6; omitted=0]
calculation-mode:auto
property.title:Finance Reporting Data Dictionary — Core Model
property.subject:Synthetic target metadata and report prototype
property.creator:FDE BI web-app test harness
property.created:2026-01-01 00:00:00
property.modified:2026-01-01 00:00:00
::text_cells [status=found; inclusion=included; sensitivity=source_content; items=217; omitted=0]
sheet-items:217
::sheet_structure [status=found; inclusion=included; sensitivity=metadata; items=37; omitted=0]
sheet-items:37
::tables_names [status=found; inclusion=included; sensitivity=semantic_metadata; items=4; omitted=0]
sheet-items:4
::formulas [status=found; inclusion=included; sensitivity=business_logic; items=38; omitted=0]
sheet-items:38
::annotations_links [status=not_found; inclusion=included; sensitivity=source_content; items=0; omitted=0]
not-found
::validation_formatting [status=not_found; inclusion=included; sensitivity=business_logic; items=0; omitted=0]
not-found
::connectivity [status=not_found; inclusion=included; sensitivity=connection_metadata; items=0; omitted=0]
not-found
::power_query [status=not_found; inclusion=included; sensitivity=connection_logic; items=0; omitted=0]
not-found
::analytical_objects [status=not_found; inclusion=included; sensitivity=potential_data; items=0; omitted=0]
not-found
::embedded_model [status=not_found; inclusion=included; sensitivity=potential_data; items=0; omitted=0]
not-found
::package_security [status=found; inclusion=included; sensitivity=executable_or_security; items=13; omitted=0]
workbook-protection:not-found
ooxml-part-count:24
vba-project:not-found
embedded-objects:0
digital-signatures:0

[Sheet:Read Me]
::text_cells
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_structure
state:visible
used-range:A1:F10
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:F1
::package_security
sheet-protection:not-found

[Sheet:Target Fields]
::text_cells
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_structure
state:visible
used-range:A1:J15
freeze-panes:A2
auto-filter:A1:J15
::tables_names
table:TargetFields;range=A1:J15;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Business Owner,Calculation,Planned Source,Implementation Notes
::package_security
sheet-protection:not-found

[Sheet:Chart of Accounts]
::text_cells
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_structure
state:visible
used-range:A1:C13
freeze-panes:A4
auto-filter:not-found
merged-range:A1:C1
::tables_names
table:ChartOfAccounts;range=A3:C13;columns=AccountKey,AccountName,AccountType
::package_security
sheet-protection:not-found

[Sheet:Fiscal Calendar]
::text_cells
A1:Fiscal calendar — July 2025 sample
A2:Daily grain; fiscal year starts in July
A3:DateKey
B3:Date
C3:FiscalMonth
::sheet_structure
state:visible
used-range:A1:C34
freeze-panes:A4
auto-filter:not-found
merged-range:A1:C1
::tables_names
table:FiscalCalendar;range=A3:C34;columns=DateKey,Date,FiscalMonth
::formulas
C4:=MOD(MONTH(B4)-7,12)+1
C5:=MOD(MONTH(B5)-7,12)+1
C6:=MOD(MONTH(B6)-7,12)+1
C7:=MOD(MONTH(B7)-7,12)+1
C8:=MOD(MONTH(B8)-7,12)+1
C9:=MOD(MONTH(B9)-7,12)+1
C10:=MOD(MONTH(B10)-7,12)+1
C11:=MOD(MONTH(B11)-7,12)+1
C12:=MOD(MONTH(B12)-7,12)+1
C13:=MOD(MONTH(B13)-7,12)+1
C14:=MOD(MONTH(B14)-7,12)+1
C15:=MOD(MONTH(B15)-7,12)+1
C16:=MOD(MONTH(B16)-7,12)+1
C17:=MOD(MONTH(B17)-7,12)+1
C18:=MOD(MONTH(B18)-7,12)+1
C19:=MOD(MONTH(B19)-7,12)+1
C20:=MOD(MONTH(B20)-7,12)+1
C21:=MOD(MONTH(B21)-7,12)+1
C22:=MOD(MONTH(B22)-7,12)+1
C23:=MOD(MONTH(B23)-7,12)+1
C24:=MOD(MONTH(B24)-7,12)+1
C25:=MOD(MONTH(B25)-7,12)+1
C26:=MOD(MONTH(B26)-7,12)+1
C27:=MOD(MONTH(B27)-7,12)+1
C28:=MOD(MONTH(B28)-7,12)+1
C29:=MOD(MONTH(B29)-7,12)+1
C30:=MOD(MONTH(B30)-7,12)+1
C31:=MOD(MONTH(B31)-7,12)+1
C32:=MOD(MONTH(B32)-7,12)+1
C33:=MOD(MONTH(B33)-7,12)+1
C34:=MOD(MONTH(B34)-7,12)+1
::package_security
sheet-protection:not-found

[Sheet:Ledger Sample]
::text_cells
A1:General ledger postings — representative extract
A2:Synthetic posting-level data in reporting-sign convention
A3:DateKey
B3:AccountKey
C3:SignedAmount
D3:IsAdjustment
::sheet_structure
state:visible
used-range:A1:D15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:D1
::tables_names
table:LedgerSample;range=A3:D15;columns=DateKey,AccountKey,SignedAmount,IsAdjustment
::package_security
sheet-protection:not-found

[Sheet:Management P&L]
::text_cells
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_structure
state:visible
used-range:A1:D10
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:D1
::formulas
B4:=SUMIFS('Ledger Sample'!C:C,'Ledger Sample'!B:B,">=4000",'Ledger Sample'!B:B,"<5000") | format=#,##0.00;[Red]-#,##0.00
B5:=SUMIFS('Ledger Sample'!C:C,'Ledger Sample'!B:B,">=5000",'Ledger Sample'!B:B,"<6000") | format=#,##0.00;[Red]-#,##0.00
B6:=B4+B5 | format=#,##0.00;[Red]-#,##0.00
B9:=B7+B8 | format=#,##0.00;[Red]-#,##0.00
B10:=B6-B9 | format=#,##0.00;[Red]-#,##0.00
::package_security
sheet-protection:not-found

[Sheet:Reference Data]
::text_cells
A1:Parameter
B1:Value
C1:Purpose
A2:ReportingCurrency
B2:AUD
C2:Management reporting
A3:FiscalYearStartMonth
C3:July
A4:MaterialityThreshold
C4:Prototype validation
::sheet_structure
state:hidden
used-range:A1:C4
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

[Sheet:Validation]
::text_cells
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
::sheet_structure
state:visible
used-range:A1:C3
freeze-panes:not-found
auto-filter:not-found
::formulas
B2:=COUNTA('Target Fields'!C:C)-1
B3:=COUNTIF('Target Fields'!F:F,"Yes")
::package_security
sheet-protection:not-found