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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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 — Management Extension
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=249; omitted=0]
sheet-items:249
::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 — 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_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: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_structure
state:visible
used-range:A1:J14
freeze-panes:A2
auto-filter:A1:J14
::tables_names
table:TargetFields;range=A1:J14;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
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_structure
state:visible
used-range:A1:D13
freeze-panes:A4
auto-filter:not-found
merged-range:A1:D1
::tables_names
table:ChartOfAccounts;range=A3:D13;columns=AccountKey,AccountName,AccountType,AccountGroup
::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
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_structure
state:visible
used-range:A1:F15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:F1
::tables_names
table:LedgerSample;range=A3:F15;columns=DateKey,AccountKey,SignedAmount,IsAdjustment,CostCentre,CurrencyCode
::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: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_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 — 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_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: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_structure
state:visible
used-range:A1:J14
freeze-panes:A2
auto-filter:A1:J14
::tables_names
table:TargetFields;range=A1:J14;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
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_structure
state:visible
used-range:A1:D13
freeze-panes:A4
auto-filter:not-found
merged-range:A1:D1
::tables_names
table:ChartOfAccounts;range=A3:D13;columns=AccountKey,AccountName,AccountType,AccountGroup
::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
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_structure
state:visible
used-range:A1:F15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:F1
::tables_names
table:LedgerSample;range=A3:F15;columns=DateKey,AccountKey,SignedAmount,IsAdjustment,CostCentre,CurrencyCode
::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: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_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