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

Workbook evidence

TargetArchitecture_Partial.xlsx

5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6

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
10109

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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
category:workbook_metadata
label:Workbook metadata
status:found
inclusion:included
sensitivity:metadata
item-count:6
character-count:278
omitted-item-count:0

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

Literal text cells

found

249 items extracted and included.

Items
249
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
category:text_cells
label:Literal text cells
status:found
inclusion:included
sensitivity:source_content
item-count:249
character-count:4826
omitted-item-count:0

[Sheet:Read Me]
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: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: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:Chart of Accounts]
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: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
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: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: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: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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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:J14
freeze-panes:A2
auto-filter:A1:J14

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

[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:F15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:F1

[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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
category:tables_names
label:Tables and defined names
status:found
inclusion:included
sensitivity:semantic_metadata
item-count:4
character-count:433
omitted-item-count:0

[Sheet:Target Fields]
table:TargetFields;range=A1:J14;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:D13;columns=AccountKey,AccountName,AccountType,AccountGroup

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

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

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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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_5131af78af6c59c9481fe2df0cf800f9bcddbb54d9b29b1d18fbf25a0ee2a6b6
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 — Management ExtensionFinance Reporting Data Dictionary — Management ExtensionGeneral
A3Document purposeDocument purposeGeneral
B3Document the finance attributes requested for management analysis, including organisational and transaction-currency enrichment.Document the finance attributes requested for management analysis, including organisational and transaction-currency enrichment.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 — 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

14 × 10 · 0 formulas · visible

Inspect retained cell ledger+
TargetFields A1:J14
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
A12columncolumnGeneral
B12LedgerLedgerGeneral
C12CostCentreCostCentreGeneral
D12StringStringGeneral
E12Management cost-centre code.Management cost-centre code.General
F12YesYesGeneral
G12Financial ControlFinancial ControlGeneral
I12Finance posting sourceFinance posting sourceGeneral
J12Required for operating-area accountability.Required for operating-area accountability.General
A13columncolumnGeneral
B13LedgerLedgerGeneral
C13CurrencyCodeCurrencyCodeGeneral
D13StringStringGeneral
E13ISO transaction currency code.ISO transaction currency code.General
F13YesYesGeneral
G13Financial ControlFinancial ControlGeneral
I13Finance posting sourceFinance posting sourceGeneral
J13Required for transaction-currency analysis.Required for transaction-currency analysis.General
A14columncolumnGeneral
B14AccountAccountGeneral
C14AccountGroupAccountGroupGeneral
D14StringStringGeneral
E14Management reporting group above account type.Management reporting group above account type.General
F14YesYesGeneral
G14Financial ControlFinancial ControlGeneral
I14Account master mappingAccount master mappingGeneral
J14Required for management roll-ups.Required for management roll-ups.General

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: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

13 × 4 · 0 formulas · visible

Inspect retained cell ledger+
ChartOfAccounts A3:D13merged A1:D1
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
D3AccountGroupAccountGroupGeneral
A410001000General
B4Cash at bankCash at bankGeneral
C4AssetAssetGeneral
D4Working CapitalWorking CapitalGeneral
A511001100General
B5Trade receivablesTrade receivablesGeneral
C5AssetAssetGeneral
D5Working CapitalWorking CapitalGeneral
A612001200General
B6PrepaymentsPrepaymentsGeneral
C6AssetAssetGeneral
D6Working CapitalWorking CapitalGeneral
A720002000General
B7Trade payablesTrade payablesGeneral
C7LiabilityLiabilityGeneral
D7Working CapitalWorking CapitalGeneral
A830003000General
B8Retained earningsRetained earningsGeneral
C8EquityEquityGeneral
D8EquityEquityGeneral
A940004000General
B9Product revenueProduct revenueGeneral
C9RevenueRevenueGeneral
D9Operating RevenueOperating RevenueGeneral
A1041004100General
B10Service revenueService revenueGeneral
C10RevenueRevenueGeneral
D10Operating RevenueOperating RevenueGeneral
A1150005000General
B11PayrollPayrollGeneral
C11ExpenseExpenseGeneral
D11PeoplePeopleGeneral
A1251005100General
B12FacilitiesFacilitiesGeneral
C12ExpenseExpenseGeneral
D12Corporate ServicesCorporate ServicesGeneral
A1352005200General
B13MarketingMarketingGeneral
C13ExpenseExpenseGeneral
D13GrowthGrowthGeneral

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
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

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 × 6 · 0 formulas · visible

Inspect retained cell ledger+
LedgerSample A3:F15merged A1:F1
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
E3CostCentreCostCentreGeneral
F3CurrencyCodeCurrencyCodeGeneral
A42025070120250701General
B440004000General
C44250042500#,##0.00;[Red]-#,##0.00
D4FalseFalseGeneral
E4CC200CC200General
F4AUDAUDGeneral
A52025070220250702General
B550005000General
C5-18200-18200#,##0.00;[Red]-#,##0.00
D5FalseFalseGeneral
E5CC100CC100General
F5AUDAUDGeneral
A62025070320250703General
B651005100General
C6-4200-4200#,##0.00;[Red]-#,##0.00
D6FalseFalseGeneral
E6CC300CC300General
F6AUDAUDGeneral
A72025070520250705General
B741004100General
C71385013850#,##0.00;[Red]-#,##0.00
D7FalseFalseGeneral
E7CC200CC200General
F7NZDNZDGeneral
A82025070720250707General
B852005200General
C8-3600-3600#,##0.00;[Red]-#,##0.00
D8FalseFalseGeneral
E8CC200CC200General
F8AUDAUDGeneral
A92025071020250710General
B940004000General
C92675026750#,##0.00;[Red]-#,##0.00
D9FalseFalseGeneral
E9CC200CC200General
F9AUDAUDGeneral
A102025071220250712General
B1011001100General
C10-9500-9500#,##0.00;[Red]-#,##0.00
D10FalseFalseGeneral
E10CC300CC300General
F10AUDAUDGeneral
A112025071520250715General
B1150005000General
C11-18150-18150#,##0.00;[Red]-#,##0.00
D11FalseFalseGeneral
E11CC100CC100General
F11AUDAUDGeneral
A122025072020250720General
B1241004100General
C1292009200#,##0.00;[Red]-#,##0.00
D12FalseFalseGeneral
E12CC200CC200General
F12NZDNZDGeneral
A132025072520250725General
B1351005100General
C13-4200-4200#,##0.00;[Red]-#,##0.00
D13FalseFalseGeneral
E13CC300CC300General
F13AUDAUDGeneral
A142025072820250728General
B1452005200General
C14-3150-3150#,##0.00;[Red]-#,##0.00
D14TrueTrueGeneral
E14CC200CC200General
F14AUDAUDGeneral
A152025073120250731General
B1510001000General
C153170031700#,##0.00;[Red]-#,##0.00
D15TrueTrueGeneral
E15CC300CC300General
F15AUDAUDGeneral

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
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

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
A1CostCentreCostCentreGeneral
B1AccountGroupAccountGroupGeneral
C1CurrencyCodeCurrencyCodeGeneral
A2CC100CC100General
B2PeoplePeopleGeneral
C2AUDAUDGeneral
A3CC200CC200General
B3CommercialCommercialGeneral
C3AUDAUDGeneral
A4CC300CC300General
B4Corporate ServicesCorporate ServicesGeneral
C4NZDNZDGeneral

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: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

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_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