Skip to content
FDE BI Evidence Workbenchobserved → compared → decided → scoped
← All workbooks

Workbook evidence

TargetArchitecture_Match.xlsx

740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f

Packet receipt Source evidence

Extraction review

What the LLM can actually inspect

Every supported workbook evidence class is accounted for. Amber means content was detected but not fully decoded; red means packet bounds omitted detail. Ordinary numeric/date/Boolean cell values and opaque binary bodies are not sent.

Packet
xlsx-evidence-v2
Components
12
Characters
9681

workbook metadata

Workbook metadata

found

6 items extracted and included.

Items
6
LLM use
included
Sensitivity
metadata
Receipt

Exact extraction component

Workbook metadata

found · included · metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:workbook_metadata
label:Workbook metadata
status:found
inclusion:included
sensitivity:metadata
item-count:6
character-count:268
omitted-item-count:0

[Workbook]
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

Literal text cells

found

217 items extracted and included.

Items
217
LLM use
included
Sensitivity
source content
Receipt

Exact extraction component

Literal text cells

found · included · source content

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

sheet structure

Workbook and sheet structure

found

37 items extracted and included.

Items
37
LLM use
included
Sensitivity
metadata
Receipt

Exact extraction component

Workbook and sheet structure

found · included · metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:sheet_structure
label:Workbook and sheet structure
status:found
inclusion:included
sensitivity:metadata
item-count:37
character-count:677
omitted-item-count:0

[Sheet:Read Me]
state:visible
used-range:A1:F10
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:F1

[Sheet:Target Fields]
state:visible
used-range:A1:J15
freeze-panes:A2
auto-filter:A1:J15

[Sheet:Chart of Accounts]
state:visible
used-range:A1:C13
freeze-panes:A4
auto-filter:not-found
merged-range:A1:C1

[Sheet:Fiscal Calendar]
state:visible
used-range:A1:C34
freeze-panes:A4
auto-filter:not-found
merged-range:A1:C1

[Sheet:Ledger Sample]
state:visible
used-range:A1:D15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:D1

[Sheet:Management P&L]
state:visible
used-range:A1:D10
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:D1

[Sheet:Reference Data]
state:hidden
used-range:A1:C4
freeze-panes:not-found
auto-filter:not-found

[Sheet:Validation]
state:visible
used-range:A1:C3
freeze-panes:not-found
auto-filter:not-found

tables names

Tables and defined names

found

4 items extracted and included.

Items
4
LLM use
included
Sensitivity
semantic metadata
Receipt

Exact extraction component

Tables and defined names

found · included · semantic metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:tables_names
label:Tables and defined names
status:found
inclusion:included
sensitivity:semantic_metadata
item-count:4
character-count:396
omitted-item-count:0

[Sheet:Target Fields]
table:TargetFields;range=A1:J15;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Business Owner,Calculation,Planned Source,Implementation Notes

[Sheet:Chart of Accounts]
table:ChartOfAccounts;range=A3:C13;columns=AccountKey,AccountName,AccountType

[Sheet:Fiscal Calendar]
table:FiscalCalendar;range=A3:C34;columns=DateKey,Date,FiscalMonth

[Sheet:Ledger Sample]
table:LedgerSample;range=A3:D15;columns=DateKey,AccountKey,SignedAmount,IsAdjustment

formulas

Formulas and external formula references

found

38 items extracted and included.

Items
38
LLM use
included
Sensitivity
business logic
Receipt

Exact extraction component

Formulas and external formula references

found · included · business logic

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:formulas
label:Formulas and external formula references
status:found
inclusion:included
sensitivity:business_logic
item-count:38
character-count:1303
omitted-item-count:0

[Sheet:Fiscal Calendar]
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

[Sheet:Management P&L]
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

[Sheet:Validation]
B2:=COUNTA('Target Fields'!C:C)-1
B3:=COUNTIF('Target Fields'!F:F,"Yes")

annotations links

Comments, notes and hyperlinks

not found

No comments, notes and hyperlinks were found.

Items
0
LLM use
included
Sensitivity
source content
Receipt

Exact extraction component

Comments, notes and hyperlinks

not found · included · source content

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:annotations_links
label:Comments, notes and hyperlinks
status:not_found
inclusion:included
sensitivity:source_content
item-count:0
character-count:0
omitted-item-count:0

validation formatting

Validation and conditional formatting

not found

No validation and conditional formatting were found.

Items
0
LLM use
included
Sensitivity
business logic
Receipt

Exact extraction component

Validation and conditional formatting

not found · included · business logic

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:validation_formatting
label:Validation and conditional formatting
status:not_found
inclusion:included
sensitivity:business_logic
item-count:0
character-count:0
omitted-item-count:0

connectivity

Connections, queries and external links

not found

No connections, queries and external links were found.

Items
0
LLM use
included
Sensitivity
connection metadata
Receipt

Exact extraction component

Connections, queries and external links

not found · included · connection metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:connectivity
label:Connections, queries and external links
status:not_found
inclusion:included
sensitivity:connection_metadata
item-count:0
character-count:0
omitted-item-count:0

power query

Power Query and DataMashup

not found

No power query and datamashup were found.

Items
0
LLM use
included
Sensitivity
connection logic
Receipt

Exact extraction component

Power Query and DataMashup

not found · included · connection logic

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:power_query
label:Power Query and DataMashup
status:not_found
inclusion:included
sensitivity:connection_logic
item-count:0
character-count:0
omitted-item-count:0

analytical objects

Pivots, caches, slicers and charts

not found

No pivots, caches, slicers and charts were found.

Items
0
LLM use
included
Sensitivity
potential data
Receipt

Exact extraction component

Pivots, caches, slicers and charts

not found · included · potential data

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:analytical_objects
label:Pivots, caches, slicers and charts
status:not_found
inclusion:included
sensitivity:potential_data
item-count:0
character-count:0
omitted-item-count:0

embedded model

Power Pivot and embedded data model

not found

No power pivot and embedded data model were found.

Items
0
LLM use
included
Sensitivity
potential data
Receipt

Exact extraction component

Power Pivot and embedded data model

not found · included · potential data

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:embedded_model
label:Power Pivot and embedded data model
status:not_found
inclusion:included
sensitivity:potential_data
item-count:0
character-count:0
omitted-item-count:0

package security

Package, macros, embedded objects and security

found

13 items extracted and included.

Items
13
LLM use
included
Sensitivity
executable or security
Receipt

Exact extraction component

Package, macros, embedded objects and security

found · included · executable or security

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_740658abb568de818d1581244638bb969497164fbd0775f0fed2d4998cf9479f
category:package_security
label:Package, macros, embedded objects and security
status:found
inclusion:included
sensitivity:executable_or_security
item-count:13
character-count:328
omitted-item-count:0

[Workbook]
workbook-protection:not-found
ooxml-part-count:24
vba-project:not-found
embedded-objects:0
digital-signatures:0

[Sheet:Read Me]
sheet-protection:not-found

[Sheet:Target Fields]
sheet-protection:not-found

[Sheet:Chart of Accounts]
sheet-protection:not-found

[Sheet:Fiscal Calendar]
sheet-protection:not-found

[Sheet:Ledger Sample]
sheet-protection:not-found

[Sheet:Management P&L]
sheet-protection:not-found

[Sheet:Reference Data]
sheet-protection:not-found

[Sheet:Validation]
sheet-protection:not-found
Interpretation boundary: “not found” is an inspected absence in this workbook package. “Indicator only” means the content exists but needs a specialist adapter—normally Excel/Analysis Services inside the Windows VM—for full query or semantic-model extraction.

Read Me

10 × 6 · 0 formulas · visible

Inspect retained cell ledger+
merged A1:F1
CellObserved value/formulaCached valueFormat
A1Finance Reporting Data Dictionary — Core ModelFinance Reporting Data Dictionary — Core ModelGeneral
A3Document purposeDocument purposeGeneral
B3Document the core finance dimensions, posting facts, and management measures requested for the reporting model.Document the core finance dimensions, posting facts, and management measures requested for the reporting model.General
A4Prepared forPrepared forGeneral
B4Data and reporting discovery workshopData and reporting discovery workshopGeneral
A5Business ownerBusiness ownerGeneral
B5Reporting TransformationReporting TransformationGeneral
A6Planning horizonPlanning horizonGeneral
B6FY2026–FY2027FY2026–FY2027General
A8How to use this workbookHow to use this workbookGeneral
B8Target Fields is the authoritative register of requested data objects. The working sheets contain synthetic records and formulas that illustrate grain and intended report behaviour.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.General
A10Scope noteScope noteGeneral
B10All sample values are fictional and are provided for design discussion, not reconciliation or production reporting.All sample values are fictional and are provided for design discussion, not reconciliation or production reporting.General

Workbook visual aid

Read Me

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Read Me

Exact LLM input slice

Read Me

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

15 × 10 · 0 formulas · visible

Inspect retained cell ledger+
TargetFields A1:J15
CellObserved value/formulaCached valueFormat
A1Object TypeObject TypeGeneral
B1EntityEntityGeneral
C1NameNameGeneral
D1Data TypeData TypeGeneral
E1Business DefinitionBusiness DefinitionGeneral
F1RequiredRequiredGeneral
G1Business OwnerBusiness OwnerGeneral
H1CalculationCalculationGeneral
I1Planned SourcePlanned SourceGeneral
J1Implementation NotesImplementation NotesGeneral
A2columncolumnGeneral
B2AccountAccountGeneral
C2AccountKeyAccountKeyGeneral
D2Int64Int64General
E2Stable account identifier.Stable account identifier.General
F2YesYesGeneral
G2Financial ControlFinancial ControlGeneral
I2Chart of accounts masterChart of accounts masterGeneral
A3columncolumnGeneral
B3AccountAccountGeneral
C3AccountNameAccountNameGeneral
D3StringStringGeneral
E3Finance account display name.Finance account display name.General
F3YesYesGeneral
G3Financial ControlFinancial ControlGeneral
I3Chart of accounts masterChart of accounts masterGeneral
A4columncolumnGeneral
B4AccountAccountGeneral
C4AccountTypeAccountTypeGeneral
D4StringStringGeneral
E4Revenue or expense classification.Revenue or expense classification.General
F4YesYesGeneral
G4Financial ControlFinancial ControlGeneral
I4Chart of accounts masterChart of accounts masterGeneral
A5columncolumnGeneral
B5CalendarCalendarGeneral
C5DateKeyDateKeyGeneral
D5Int64Int64General
E5Integer date key in YYYYMMDD form.Integer date key in YYYYMMDD form.General
F5YesYesGeneral
G5Enterprise DataEnterprise DataGeneral
I5Enterprise fiscal calendarEnterprise fiscal calendarGeneral
A6columncolumnGeneral
B6CalendarCalendarGeneral
C6DateDateGeneral
D6DateTimeDateTimeGeneral
E6Posting calendar date.Posting calendar date.General
F6YesYesGeneral
G6Enterprise DataEnterprise DataGeneral
I6Enterprise fiscal calendarEnterprise fiscal calendarGeneral
A7columncolumnGeneral
B7CalendarCalendarGeneral
C7FiscalMonthFiscalMonthGeneral
D7Int64Int64General
E7Fiscal month number.Fiscal month number.General
F7YesYesGeneral
G7Enterprise DataEnterprise DataGeneral
I7Enterprise fiscal calendarEnterprise fiscal calendarGeneral
A8columncolumnGeneral
B8LedgerLedgerGeneral
C8DateKeyDateKeyGeneral
D8Int64Int64General
E8Posting date foreign key.Posting date foreign key.General
F8YesYesGeneral
G8Financial ControlFinancial ControlGeneral
I8General ledger postingsGeneral ledger postingsGeneral
A9columncolumnGeneral
B9LedgerLedgerGeneral
C9AccountKeyAccountKeyGeneral
D9Int64Int64General
E9Account foreign key.Account foreign key.General
F9YesYesGeneral
G9Financial ControlFinancial ControlGeneral
I9General ledger postingsGeneral ledger postingsGeneral
A10columncolumnGeneral
B10LedgerLedgerGeneral
C10SignedAmountSignedAmountGeneral
D10DecimalDecimalGeneral
E10Signed ledger amount in reporting currency.Signed ledger amount in reporting currency.General
F10YesYesGeneral
G10Financial ControlFinancial ControlGeneral
I10General ledger postingsGeneral ledger postingsGeneral
A11columncolumnGeneral
B11LedgerLedgerGeneral
C11IsAdjustmentIsAdjustmentGeneral
D11BooleanBooleanGeneral
E11Identifies late or manual adjustments.Identifies late or manual adjustments.General
F11YesYesGeneral
G11Financial ControlFinancial ControlGeneral
I11General ledger postingsGeneral ledger postingsGeneral
A12measuremeasureGeneral
B12MetricsMetricsGeneral
C12Actual NetActual NetGeneral
D12DecimalDecimalGeneral
E12Net actual result.Net actual result.General
F12YesYesGeneral
G12FP&AFP&AGeneral
H12Actual Revenue plus signed expense balancesActual Revenue plus signed expense balancesGeneral
I12Finance semantic calculation layerFinance semantic calculation layerGeneral
A13measuremeasureGeneral
B13MetricsMetricsGeneral
C13Actual RevenueActual RevenueGeneral
D13DecimalDecimalGeneral
E13Total actual revenue.Total actual revenue.General
F13YesYesGeneral
G13FP&AFP&AGeneral
I13Finance semantic calculation layerFinance semantic calculation layerGeneral
A14measuremeasureGeneral
B14MetricsMetricsGeneral
C14Budget NetBudget NetGeneral
D14DecimalDecimalGeneral
E14Budget net result.Budget net result.General
F14YesYesGeneral
G14FP&AFP&AGeneral
I14Finance semantic calculation layerFinance semantic calculation layerGeneral
A15measuremeasureGeneral
B15MetricsMetricsGeneral
C15Net VarianceNet VarianceGeneral
D15DecimalDecimalGeneral
E15Actual net less budget net.Actual net less budget net.General
F15YesYesGeneral
G15FP&AFP&AGeneral
H15Actual Net minus Budget NetActual Net minus Budget NetGeneral
I15Finance semantic calculation layerFinance semantic calculation layerGeneral

Workbook visual aid

Target Fields

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Target Fields

Exact LLM input slice

Target Fields

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

13 × 3 · 0 formulas · visible

Inspect retained cell ledger+
ChartOfAccounts A3:C13merged A1:C1
CellObserved value/formulaCached valueFormat
A1Chart of accounts — representative rowsChart of accounts — representative rowsGeneral
A2Synthetic records at one row per finance accountSynthetic records at one row per finance accountGeneral
A3AccountKeyAccountKeyGeneral
B3AccountNameAccountNameGeneral
C3AccountTypeAccountTypeGeneral
A410001000General
B4Cash at bankCash at bankGeneral
C4AssetAssetGeneral
A511001100General
B5Trade receivablesTrade receivablesGeneral
C5AssetAssetGeneral
A612001200General
B6PrepaymentsPrepaymentsGeneral
C6AssetAssetGeneral
A720002000General
B7Trade payablesTrade payablesGeneral
C7LiabilityLiabilityGeneral
A830003000General
B8Retained earningsRetained earningsGeneral
C8EquityEquityGeneral
A940004000General
B9Product revenueProduct revenueGeneral
C9RevenueRevenueGeneral
A1041004100General
B10Service revenueService revenueGeneral
C10RevenueRevenueGeneral
A1150005000General
B11PayrollPayrollGeneral
C11ExpenseExpenseGeneral
A1251005100General
B12FacilitiesFacilitiesGeneral
C12ExpenseExpenseGeneral
A1352005200General
B13MarketingMarketingGeneral
C13ExpenseExpenseGeneral

Workbook visual aid

Chart of Accounts

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Chart of Accounts

Exact LLM input slice

Chart of Accounts

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

34 × 3 · 31 formulas · visible

Inspect retained cell ledger+
FiscalCalendar A3:C34merged A1:C1
CellObserved value/formulaCached valueFormat
A1Fiscal calendar — July 2025 sampleFiscal calendar — July 2025 sampleGeneral
A2Daily grain; fiscal year starts in JulyDaily grain; fiscal year starts in JulyGeneral
A3DateKeyDateKeyGeneral
B3DateDateGeneral
C3FiscalMonthFiscalMonthGeneral
A42025070120250701General
B42025-07-01 00:00:002025-07-01 00:00:00dd-mmm-yyyy
C4=MOD(MONTH(B4)-7,12)+1NoneGeneral
A52025070220250702General
B52025-07-02 00:00:002025-07-02 00:00:00dd-mmm-yyyy
C5=MOD(MONTH(B5)-7,12)+1NoneGeneral
A62025070320250703General
B62025-07-03 00:00:002025-07-03 00:00:00dd-mmm-yyyy
C6=MOD(MONTH(B6)-7,12)+1NoneGeneral
A72025070420250704General
B72025-07-04 00:00:002025-07-04 00:00:00dd-mmm-yyyy
C7=MOD(MONTH(B7)-7,12)+1NoneGeneral
A82025070520250705General
B82025-07-05 00:00:002025-07-05 00:00:00dd-mmm-yyyy
C8=MOD(MONTH(B8)-7,12)+1NoneGeneral
A92025070620250706General
B92025-07-06 00:00:002025-07-06 00:00:00dd-mmm-yyyy
C9=MOD(MONTH(B9)-7,12)+1NoneGeneral
A102025070720250707General
B102025-07-07 00:00:002025-07-07 00:00:00dd-mmm-yyyy
C10=MOD(MONTH(B10)-7,12)+1NoneGeneral
A112025070820250708General
B112025-07-08 00:00:002025-07-08 00:00:00dd-mmm-yyyy
C11=MOD(MONTH(B11)-7,12)+1NoneGeneral
A122025070920250709General
B122025-07-09 00:00:002025-07-09 00:00:00dd-mmm-yyyy
C12=MOD(MONTH(B12)-7,12)+1NoneGeneral
A132025071020250710General
B132025-07-10 00:00:002025-07-10 00:00:00dd-mmm-yyyy
C13=MOD(MONTH(B13)-7,12)+1NoneGeneral
A142025071120250711General
B142025-07-11 00:00:002025-07-11 00:00:00dd-mmm-yyyy
C14=MOD(MONTH(B14)-7,12)+1NoneGeneral
A152025071220250712General
B152025-07-12 00:00:002025-07-12 00:00:00dd-mmm-yyyy
C15=MOD(MONTH(B15)-7,12)+1NoneGeneral
A162025071320250713General
B162025-07-13 00:00:002025-07-13 00:00:00dd-mmm-yyyy
C16=MOD(MONTH(B16)-7,12)+1NoneGeneral
A172025071420250714General
B172025-07-14 00:00:002025-07-14 00:00:00dd-mmm-yyyy
C17=MOD(MONTH(B17)-7,12)+1NoneGeneral
A182025071520250715General
B182025-07-15 00:00:002025-07-15 00:00:00dd-mmm-yyyy
C18=MOD(MONTH(B18)-7,12)+1NoneGeneral
A192025071620250716General
B192025-07-16 00:00:002025-07-16 00:00:00dd-mmm-yyyy
C19=MOD(MONTH(B19)-7,12)+1NoneGeneral
A202025071720250717General
B202025-07-17 00:00:002025-07-17 00:00:00dd-mmm-yyyy
C20=MOD(MONTH(B20)-7,12)+1NoneGeneral
A212025071820250718General
B212025-07-18 00:00:002025-07-18 00:00:00dd-mmm-yyyy
C21=MOD(MONTH(B21)-7,12)+1NoneGeneral
A222025071920250719General
B222025-07-19 00:00:002025-07-19 00:00:00dd-mmm-yyyy
C22=MOD(MONTH(B22)-7,12)+1NoneGeneral
A232025072020250720General
B232025-07-20 00:00:002025-07-20 00:00:00dd-mmm-yyyy
C23=MOD(MONTH(B23)-7,12)+1NoneGeneral
A242025072120250721General
B242025-07-21 00:00:002025-07-21 00:00:00dd-mmm-yyyy
C24=MOD(MONTH(B24)-7,12)+1NoneGeneral
A252025072220250722General
B252025-07-22 00:00:002025-07-22 00:00:00dd-mmm-yyyy
C25=MOD(MONTH(B25)-7,12)+1NoneGeneral
A262025072320250723General
B262025-07-23 00:00:002025-07-23 00:00:00dd-mmm-yyyy
C26=MOD(MONTH(B26)-7,12)+1NoneGeneral
A272025072420250724General
B272025-07-24 00:00:002025-07-24 00:00:00dd-mmm-yyyy
C27=MOD(MONTH(B27)-7,12)+1NoneGeneral
A282025072520250725General
B282025-07-25 00:00:002025-07-25 00:00:00dd-mmm-yyyy
C28=MOD(MONTH(B28)-7,12)+1NoneGeneral
A292025072620250726General
B292025-07-26 00:00:002025-07-26 00:00:00dd-mmm-yyyy
C29=MOD(MONTH(B29)-7,12)+1NoneGeneral
A302025072720250727General
B302025-07-27 00:00:002025-07-27 00:00:00dd-mmm-yyyy
C30=MOD(MONTH(B30)-7,12)+1NoneGeneral
A312025072820250728General
B312025-07-28 00:00:002025-07-28 00:00:00dd-mmm-yyyy
C31=MOD(MONTH(B31)-7,12)+1NoneGeneral
A322025072920250729General
B322025-07-29 00:00:002025-07-29 00:00:00dd-mmm-yyyy
C32=MOD(MONTH(B32)-7,12)+1NoneGeneral
A332025073020250730General
B332025-07-30 00:00:002025-07-30 00:00:00dd-mmm-yyyy
C33=MOD(MONTH(B33)-7,12)+1NoneGeneral
A342025073120250731General
B342025-07-31 00:00:002025-07-31 00:00:00dd-mmm-yyyy
C34=MOD(MONTH(B34)-7,12)+1NoneGeneral

Workbook visual aid

Fiscal Calendar

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Fiscal Calendar

Exact LLM input slice

Fiscal Calendar

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

15 × 4 · 0 formulas · visible

Inspect retained cell ledger+
LedgerSample A3:D15merged A1:D1
CellObserved value/formulaCached valueFormat
A1General ledger postings — representative extractGeneral ledger postings — representative extractGeneral
A2Synthetic posting-level data in reporting-sign conventionSynthetic posting-level data in reporting-sign conventionGeneral
A3DateKeyDateKeyGeneral
B3AccountKeyAccountKeyGeneral
C3SignedAmountSignedAmountGeneral
D3IsAdjustmentIsAdjustmentGeneral
A42025070120250701General
B440004000General
C44250042500#,##0.00;[Red]-#,##0.00
D4FalseFalseGeneral
A52025070220250702General
B550005000General
C5-18200-18200#,##0.00;[Red]-#,##0.00
D5FalseFalseGeneral
A62025070320250703General
B651005100General
C6-4200-4200#,##0.00;[Red]-#,##0.00
D6FalseFalseGeneral
A72025070520250705General
B741004100General
C71385013850#,##0.00;[Red]-#,##0.00
D7FalseFalseGeneral
A82025070720250707General
B852005200General
C8-3600-3600#,##0.00;[Red]-#,##0.00
D8FalseFalseGeneral
A92025071020250710General
B940004000General
C92675026750#,##0.00;[Red]-#,##0.00
D9FalseFalseGeneral
A102025071220250712General
B1011001100General
C10-9500-9500#,##0.00;[Red]-#,##0.00
D10FalseFalseGeneral
A112025071520250715General
B1150005000General
C11-18150-18150#,##0.00;[Red]-#,##0.00
D11FalseFalseGeneral
A122025072020250720General
B1241004100General
C1292009200#,##0.00;[Red]-#,##0.00
D12FalseFalseGeneral
A132025072520250725General
B1351005100General
C13-4200-4200#,##0.00;[Red]-#,##0.00
D13FalseFalseGeneral
A142025072820250728General
B1452005200General
C14-3150-3150#,##0.00;[Red]-#,##0.00
D14TrueTrueGeneral
A152025073120250731General
B1510001000General
C153170031700#,##0.00;[Red]-#,##0.00
D15TrueTrueGeneral

Workbook visual aid

Ledger Sample

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Ledger Sample

Exact LLM input slice

Ledger Sample

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

10 × 4 · 5 formulas · visible

Inspect retained cell ledger+
merged A1:D1
CellObserved value/formulaCached valueFormat
A1Management profit and loss — July 2025 prototypeManagement profit and loss — July 2025 prototypeGeneral
A2Formula-driven illustration using the representative ledger extractFormula-driven illustration using the representative ledger extractGeneral
A3MetricMetricGeneral
B3AmountAmountGeneral
C3Review noteReview noteGeneral
D3Sign conventionSign conventionGeneral
A4Actual RevenueActual RevenueGeneral
B4=SUMIFS('Ledger Sample'!C:C,'Ledger Sample'!B:B,">=4000",'Ledger Sample'!B:B,"<5000")None#,##0.00;[Red]-#,##0.00
C4Product and service accountsProduct and service accountsGeneral
D4PositivePositiveGeneral
A5Actual ExpensesActual ExpensesGeneral
B5=SUMIFS('Ledger Sample'!C:C,'Ledger Sample'!B:B,">=5000",'Ledger Sample'!B:B,"<6000")None#,##0.00;[Red]-#,##0.00
C5Operating expense accountsOperating expense accountsGeneral
D5NegativeNegativeGeneral
A6Actual NetActual NetGeneral
B6=B4+B5None#,##0.00;[Red]-#,##0.00
C6Revenue plus signed expensesRevenue plus signed expensesGeneral
D6Net resultNet resultGeneral
A7Budget RevenueBudget RevenueGeneral
B79400094000#,##0.00;[Red]-#,##0.00
C7Workshop planning assumptionWorkshop planning assumptionGeneral
D7PositivePositiveGeneral
A8Budget ExpensesBudget ExpensesGeneral
B8-56000-56000#,##0.00;[Red]-#,##0.00
C8Workshop planning assumptionWorkshop planning assumptionGeneral
D8NegativeNegativeGeneral
A9Budget NetBudget NetGeneral
B9=B7+B8None#,##0.00;[Red]-#,##0.00
C9Budget revenue plus expensesBudget revenue plus expensesGeneral
D9Net resultNet resultGeneral
A10Net VarianceNet VarianceGeneral
B10=B6-B9None#,##0.00;[Red]-#,##0.00
C10Actual net less budget netActual net less budget netGeneral
D10Favourable positiveFavourable positiveGeneral

Workbook visual aid

Management P&L

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Management P&L

Exact LLM input slice

Management P&L

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

4 × 3 · 0 formulas · hidden

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1ParameterParameterGeneral
B1ValueValueGeneral
C1PurposePurposeGeneral
A2ReportingCurrencyReportingCurrencyGeneral
B2AUDAUDGeneral
C2Management reportingManagement reportingGeneral
A3FiscalYearStartMonthFiscalYearStartMonthGeneral
B377General
C3JulyJulyGeneral
A4MaterialityThresholdMaterialityThresholdGeneral
B450005000General
C4Prototype validationPrototype validationGeneral

Workbook visual aid

Reference Data

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Reference Data

Exact LLM input slice

Reference Data

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

3 × 3 · 2 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1CheckCheckGeneral
B1ResultResultGeneral
C1ExpectedExpectedGeneral
A2Declared field countDeclared field countGeneral
B2=COUNTA('Target Fields'!C:C)-1NoneGeneral
C2One row per requested attribute or measureOne row per requested attribute or measureGeneral
A3Required field countRequired field countGeneral
B3=COUNTIF('Target Fields'!F:F,"Yes")NoneGeneral
C3All rows in the register are requiredAll rows in the register are requiredGeneral

Workbook visual aid

Validation

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Validation

Exact LLM input slice

Validation

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[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

Exact comparison payload

Complete workbook LLM evidence

This layered, capability-labelled packet is what the comparison model receives.

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