Everything the model was given

Exact model input

Everything the model was given

Literal labels, structure, formulas and supported metadata. Ordinary numeric, date and Boolean values are excluded, and opaque binary payloads are never placed in the prompt.

Complete packet

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

Read Me

[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

Target Fields

[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

Chart of Accounts

[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

Fiscal Calendar

[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

Ledger Sample

[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

Management P&L

[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

Reference Data

[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

Validation

[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

Download the immutable receipt