{ "acceptance_rule": { "basis_values": { "consultant_decision": "A named consultant recorded an explicit disposition against this item.", "model_unreviewed": "No consultant decision exists. The model's finding stands as the working position." }, "statement": "Where the consultant recorded a decision, that decision governs the item. Where no decision was recorded, the model's finding is carried forward unchanged and the item is marked as assumed.", "why": "The engagement can be reported and scoped before every finding has been individually reviewed, provided the reader can always tell the two apart." }, "boundary": [ "Comparison is against the current gold wiki, which is bounded by what the Power BI audit could access. Not found in that boundary is not proof of absence from the client's estate.", "Workbook evidence is literal text, structure, formulas and declared metadata. Ordinary numeric, date and Boolean cell values were deliberately excluded, so no claim here rests on the value in a cell.", "A formula is evidence of stored logic, not proof that it recalculates or that its cached result is current.", "This is decision support and scope definition. Nothing here asserts that the target has been built, deployed or adopted." ], "consultant_additions": { "gold_evidence": [ { "added_at": "2026-07-30T12:39:29.939Z", "contributor": "Synthetic Consultant", "original_name": "consultant-synthetic-journal-control-attributes.md", "source_kind": "consultant_evidence", "title": "Synthetic journal control attributes" } ], "requirements": [ { "contributor": "Synthetic Consultant", "created_at": "2026-07-30T12:49:57.470Z", "description": "# Month-end close adjustment controls\n\nFinance needs a monthly close-control view that identifies unapproved manual\nadjustments before the reporting pack is signed off.\n\nThe target should expose `Ledger.JournalSource`,\n`Ledger.ApprovalStatus`, and `Metrics.Unapproved Adjustment Value`.\nJournal attributes must remain at ledger-entry grain. The measure should sum\nthe absolute value of adjustment entries whose approval status is not\napproved, while retaining drill-through to the original ledger entry.\n\nAcceptance requires reconciliation to the governed ledger export for a closed\nmonth, an explicit definition of late approvals, and consultant confirmation\nthat approved adjustments are excluded from the exception value.\n", "title": "Month-end close adjustment controls" } ], "steering": [] }, "context_only": [ { "basis": "context_only", "cited_gold_pages": [ "fde-finance.current-model" ], "disposition": null, "input": "TargetArchitecture_Partial.xlsx", "item_id": "CTX-01", "label": "Management P&L metric prototype", "model_confidence": 0.88, "model_questions": [ "Are Actual Expenses, Budget Revenue and Budget Expenses required as production measures even though they are absent from the authoritative register?", "What are the approved DAX definitions and source for budget values?", "Should revenue/expense classification use account-number ranges as in the prototype formulas, or governed AccountType/AccountGroup mappings?" ], "model_rationale": "This sheet is explicitly a formula-driven illustration rather than part of the authoritative Target Fields register. Current gold observes exact-name measures for Actual Revenue, Actual Net, Budget Net and Net Variance, but not separate measures for Actual Expenses, Budget Revenue or Budget Expenses. Exact DAX for observed measures was unavailable, so semantic equivalence cannot be confirmed.", "model_status": "context_only", "note": "Contextual observation. Carries no scope obligation and is excluded from every readiness and acceptance count.", "workbook_evidence": [ "Management P&L!A1:D10", "Management P&L!B4:B6", "Management P&L!B9:B10" ] } ], "engagement": { "current_gold": { "build_id": "wiki_7c268dbf7f8b78844080cae53f6f0a0e", "build_profile": "consultant", "page_count": 11, "promoted_at": "2026-07-30T12:48:08.601Z", "state": "promoted" }, "data_profile": "synthetic", "redaction_mode": "off" }, "inputs": [ { "answers_stranded_by_rerun": 0, "band": { "key": "largely_ready", "label": "Largely ready", "meaning": "Most requirements were found; a minority need work or validation." }, "comparison_state": "complete", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": { "context_only": 1, "direct": 10, "not_found": 3 }, "extraction": { "categories": [ { "items": 6, "label": "Workbook metadata", "limitations": [], "omitted": 0, "status": "found", "summary": "6 items extracted and included." }, { "items": 249, "label": "Literal text cells", "limitations": [], "omitted": 0, "status": "found", "summary": "249 items extracted and included." }, { "items": 37, "label": "Workbook and sheet structure", "limitations": [], "omitted": 0, "status": "found", "summary": "37 items extracted and included." }, { "items": 4, "label": "Tables and defined names", "limitations": [], "omitted": 0, "status": "found", "summary": "4 items extracted and included." }, { "items": 38, "label": "Formulas and external formula references", "limitations": [], "omitted": 0, "status": "found", "summary": "38 items extracted and included." }, { "items": 0, "label": "Comments, notes and hyperlinks", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No comments, notes and hyperlinks were found." }, { "items": 0, "label": "Validation and conditional formatting", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No validation and conditional formatting were found." }, { "items": 0, "label": "Connections, queries and external links", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No connections, queries and external links were found." }, { "items": 0, "label": "Power Query and DataMashup", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No power query and datamashup were found." }, { "items": 0, "label": "Pivots, caches, slicers and charts", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No pivots, caches, slicers and charts were found." }, { "items": 0, "label": "Power Pivot and embedded data model", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No power pivot and embedded data model were found." }, { "items": 13, "label": "Package, macros, embedded objects and security", "limitations": [], "omitted": 0, "status": "found", "summary": "13 items extracted and included." } ], "version": "xlsx-evidence-v2" }, "file_name": "TargetArchitecture_Partial.xlsx", "gold_build_id": "wiki_7c268dbf7f8b78844080cae53f6f0a0e", "guidance": [], "inspected_at": "2026-07-30T13:16:59.874Z", "kind": "xlsx", "model": "codex", "name": "TargetArchitecture_Partial.xlsx", "origin": "Client-supplied spreadsheet", "scope_bearing_count": 13, "sheet_count": 8, "sheets": [ { "columns": 6, "findings": {}, "formulas": 0, "hidden": false, "rows": 10, "title": "Read Me" }, { "columns": 10, "findings": { "direct": 10, "not_found": 3 }, "formulas": 0, "hidden": false, "rows": 14, "title": "Target Fields" }, { "columns": 4, "findings": { "direct": 1, "not_found": 1 }, "formulas": 0, "hidden": false, "rows": 13, "title": "Chart of Accounts" }, { "columns": 3, "findings": { "direct": 1 }, "formulas": 31, "hidden": false, "rows": 34, "title": "Fiscal Calendar" }, { "columns": 6, "findings": { "direct": 1, "not_found": 2 }, "formulas": 0, "hidden": false, "rows": 15, "title": "Ledger Sample" }, { "columns": 4, "findings": { "context_only": 1 }, "formulas": 5, "hidden": false, "rows": 10, "title": "Management P&L" }, { "columns": 3, "findings": { "not_found": 3 }, "formulas": 0, "hidden": true, "rows": 4, "title": "Reference Data" }, { "columns": 3, "findings": {}, "formulas": 2, "hidden": false, "rows": 3, "title": "Validation" } ], "verdict": { "detail": "10 requirements matched inside the current gold boundary and 3 were not found there. Absence from this boundary is not proof of absence from the estate.", "label": "3 gaps", "tone": "signal" } }, { "answers_stranded_by_rerun": 1, "band": { "key": "ready", "label": "Ready", "meaning": "Every declared requirement was found in the discovered estate." }, "comparison_state": "complete", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": { "direct": 14 }, "extraction": { "categories": [ { "items": 6, "label": "Workbook metadata", "limitations": [], "omitted": 0, "status": "found", "summary": "6 items extracted and included." }, { "items": 217, "label": "Literal text cells", "limitations": [], "omitted": 0, "status": "found", "summary": "217 items extracted and included." }, { "items": 37, "label": "Workbook and sheet structure", "limitations": [], "omitted": 0, "status": "found", "summary": "37 items extracted and included." }, { "items": 4, "label": "Tables and defined names", "limitations": [], "omitted": 0, "status": "found", "summary": "4 items extracted and included." }, { "items": 38, "label": "Formulas and external formula references", "limitations": [], "omitted": 0, "status": "found", "summary": "38 items extracted and included." }, { "items": 0, "label": "Comments, notes and hyperlinks", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No comments, notes and hyperlinks were found." }, { "items": 0, "label": "Validation and conditional formatting", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No validation and conditional formatting were found." }, { "items": 0, "label": "Connections, queries and external links", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No connections, queries and external links were found." }, { "items": 0, "label": "Power Query and DataMashup", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No power query and datamashup were found." }, { "items": 0, "label": "Pivots, caches, slicers and charts", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No pivots, caches, slicers and charts were found." }, { "items": 0, "label": "Power Pivot and embedded data model", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No power pivot and embedded data model were found." }, { "items": 13, "label": "Package, macros, embedded objects and security", "limitations": [], "omitted": 0, "status": "found", "summary": "13 items extracted and included." } ], "version": "xlsx-evidence-v2" }, "file_name": "TargetArchitecture_Match.xlsx", "gold_build_id": "wiki_7c268dbf7f8b78844080cae53f6f0a0e", "guidance": [], "inspected_at": "2026-07-30T13:16:59.334Z", "kind": "xlsx", "model": "codex", "name": "TargetArchitecture_Match.xlsx", "origin": "Client-supplied spreadsheet", "scope_bearing_count": 14, "sheet_count": 8, "sheets": [ { "columns": 6, "findings": {}, "formulas": 0, "hidden": false, "rows": 10, "title": "Read Me" }, { "columns": 10, "findings": { "direct": 14 }, "formulas": 0, "hidden": false, "rows": 15, "title": "Target Fields" }, { "columns": 3, "findings": { "direct": 1 }, "formulas": 0, "hidden": false, "rows": 13, "title": "Chart of Accounts" }, { "columns": 3, "findings": { "direct": 1 }, "formulas": 31, "hidden": false, "rows": 34, "title": "Fiscal Calendar" }, { "columns": 4, "findings": { "direct": 1 }, "formulas": 0, "hidden": false, "rows": 15, "title": "Ledger Sample" }, { "columns": 4, "findings": { "direct": 5 }, "formulas": 5, "hidden": false, "rows": 10, "title": "Management P&L" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": true, "rows": 4, "title": "Reference Data" }, { "columns": 3, "findings": {}, "formulas": 2, "hidden": false, "rows": 3, "title": "Validation" } ], "verdict": { "detail": "All 14 requirements map directly to objects in current gold. Any retained questions are validation checks, not identified implementation gaps.", "label": "full match", "tone": "pine" } }, { "answers_stranded_by_rerun": 0, "band": { "key": "material_gaps", "label": "Material gaps", "meaning": "Most or all declared requirements were not found in the estate." }, "comparison_state": "complete", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": { "not_found": 8 }, "extraction": { "categories": [ { "items": 6, "label": "Workbook metadata", "limitations": [], "omitted": 0, "status": "found", "summary": "6 items extracted and included." }, { "items": 197, "label": "Literal text cells", "limitations": [], "omitted": 0, "status": "found", "summary": "197 items extracted and included." }, { "items": 32, "label": "Workbook and sheet structure", "limitations": [], "omitted": 0, "status": "found", "summary": "32 items extracted and included." }, { "items": 3, "label": "Tables and defined names", "limitations": [], "omitted": 0, "status": "found", "summary": "3 items extracted and included." }, { "items": 4, "label": "Formulas and external formula references", "limitations": [], "omitted": 0, "status": "found", "summary": "4 items extracted and included." }, { "items": 0, "label": "Comments, notes and hyperlinks", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No comments, notes and hyperlinks were found." }, { "items": 0, "label": "Validation and conditional formatting", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No validation and conditional formatting were found." }, { "items": 0, "label": "Connections, queries and external links", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No connections, queries and external links were found." }, { "items": 0, "label": "Power Query and DataMashup", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No power query and datamashup were found." }, { "items": 0, "label": "Pivots, caches, slicers and charts", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No pivots, caches, slicers and charts were found." }, { "items": 0, "label": "Power Pivot and embedded data model", "limitations": [], "omitted": 0, "status": "not_found", "summary": "No power pivot and embedded data model were found." }, { "items": 12, "label": "Package, macros, embedded objects and security", "limitations": [], "omitted": 0, "status": "found", "summary": "12 items extracted and included." } ], "version": "xlsx-evidence-v2" }, "file_name": "TargetArchitecture_CompleteMiss.xlsx", "gold_build_id": "wiki_7c268dbf7f8b78844080cae53f6f0a0e", "guidance": [], "inspected_at": "2026-07-30T13:16:58.793Z", "kind": "xlsx", "model": "codex", "name": "TargetArchitecture_CompleteMiss.xlsx", "origin": "Client-supplied spreadsheet", "scope_bearing_count": 8, "sheet_count": 7, "sheets": [ { "columns": 6, "findings": {}, "formulas": 0, "hidden": false, "rows": 10, "title": "Read Me" }, { "columns": 10, "findings": { "not_found": 8 }, "formulas": 0, "hidden": false, "rows": 9, "title": "Target Fields" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": false, "rows": 11, "title": "Customer Sample" }, { "columns": 4, "findings": { "not_found": 1 }, "formulas": 0, "hidden": false, "rows": 15, "title": "Sales Orders" }, { "columns": 3, "findings": { "not_found": 2 }, "formulas": 2, "hidden": false, "rows": 5, "title": "Sales KPI Prototype" }, { "columns": 3, "findings": { "not_found": 2 }, "formulas": 0, "hidden": true, "rows": 7, "title": "Reference Data" }, { "columns": 3, "findings": {}, "formulas": 2, "hidden": false, "rows": 3, "title": "Validation" } ], "verdict": { "detail": "None of the 8 requirements were found inside the current gold boundary. That is not proof they are absent from the estate.", "label": "nothing matched", "tone": "fault" } }, { "answers_stranded_by_rerun": 0, "band": { "key": "material_gaps", "label": "Material gaps", "meaning": "Most or all declared requirements were not found in the estate." }, "comparison_state": "complete", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": { "not_found": 4, "partial": 4, "possible": 2 }, "extraction": { "categories": [], "version": "xlsx-text-v1" }, "file_name": "consultant-requirement-month-end-close-adjustment-controls.json", "gold_build_id": "wiki_7c268dbf7f8b78844080cae53f6f0a0e", "guidance": [], "inspected_at": "2026-07-30T12:49:57.470Z", "kind": "consultant_requirement", "model": "codex", "name": "Month-end close adjustment controls", "origin": "Consultant-authored requirement, held as a virtual workbook", "scope_bearing_count": 10, "sheet_count": 1, "sheets": [ { "columns": 1, "findings": { "not_found": 4, "partial": 4, "possible": 2 }, "formulas": 0, "hidden": false, "rows": 8, "title": "Consultant Requirement" } ], "verdict": { "detail": "6 requirements matched inside the current gold boundary and 4 were not found there. Absence from this boundary is not proof of absence from the estate.", "label": "4 gaps", "tone": "signal" } }, { "answers_stranded_by_rerun": 0, "band": { "key": "not_compared", "label": "Not compared", "meaning": "This input has not been compared with current gold." }, "comparison_state": "not compared", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": {}, "extraction": { "categories": [], "version": null }, "file_name": "TargetArchitecture_Partial.xlsx", "gold_build_id": null, "guidance": [], "inspected_at": "2026-07-29T16:30:24.714Z", "kind": "xlsx", "model": null, "name": "TargetArchitecture_Partial.xlsx", "origin": "Client-supplied spreadsheet", "scope_bearing_count": 0, "sheet_count": 5, "sheets": [ { "columns": 2, "findings": {}, "formulas": 0, "hidden": false, "rows": 5, "title": "Instructions" }, { "columns": 10, "findings": {}, "formulas": 0, "hidden": false, "rows": 14, "title": "Target Fields" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": false, "rows": 5, "title": "Mapping Rules" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": true, "rows": 4, "title": "Reference Data" }, { "columns": 3, "findings": {}, "formulas": 2, "hidden": false, "rows": 3, "title": "Validation" } ], "verdict": null }, { "answers_stranded_by_rerun": 0, "band": { "key": "not_compared", "label": "Not compared", "meaning": "This input has not been compared with current gold." }, "comparison_state": "not compared", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": {}, "extraction": { "categories": [], "version": null }, "file_name": "TargetArchitecture_Match.xlsx", "gold_build_id": null, "guidance": [], "inspected_at": "2026-07-29T16:30:23.991Z", "kind": "xlsx", "model": null, "name": "TargetArchitecture_Match.xlsx", "origin": "Client-supplied spreadsheet", "scope_bearing_count": 0, "sheet_count": 5, "sheets": [ { "columns": 2, "findings": {}, "formulas": 0, "hidden": false, "rows": 5, "title": "Instructions" }, { "columns": 10, "findings": {}, "formulas": 0, "hidden": false, "rows": 15, "title": "Target Fields" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": false, "rows": 5, "title": "Mapping Rules" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": true, "rows": 4, "title": "Reference Data" }, { "columns": 3, "findings": {}, "formulas": 2, "hidden": false, "rows": 3, "title": "Validation" } ], "verdict": null }, { "answers_stranded_by_rerun": 0, "band": { "key": "not_compared", "label": "Not compared", "meaning": "This input has not been compared with current gold." }, "comparison_state": "not compared", "consultant_decided_count": 0, "consultant_overall": { "sheets": [], "workbook": null }, "coverage": {}, "extraction": { "categories": [], "version": null }, "file_name": "TargetArchitecture_CompleteMiss.xlsx", "gold_build_id": null, "guidance": [], "inspected_at": "2026-07-29T16:30:23.211Z", "kind": "xlsx", "model": null, "name": "TargetArchitecture_CompleteMiss.xlsx", "origin": "Client-supplied spreadsheet", "scope_bearing_count": 0, "sheet_count": 6, "sheets": [ { "columns": 2, "findings": {}, "formulas": 0, "hidden": false, "rows": 5, "title": "Instructions" }, { "columns": 10, "findings": {}, "formulas": 0, "hidden": false, "rows": 9, "title": "Target Fields" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": false, "rows": 5, "title": "Mapping Rules" }, { "columns": 3, "findings": {}, "formulas": 0, "hidden": true, "rows": 4, "title": "Reference Data" }, { "columns": 4, "findings": {}, "formulas": 0, "hidden": false, "rows": 3, "title": "Sample Input Data" }, { "columns": 3, "findings": {}, "formulas": 2, "hidden": false, "rows": 3, "title": "Validation" } ], "verdict": null } ], "items": [ { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-01", "label": "Account.AccountKey column", "model_confidence": 0.99, "model_questions": [], "model_rationale": "The authoritative register requires an Int64 Account.AccountKey stable identifier. Current gold observes the exact table, column name and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A2:J2" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-02", "label": "Account.AccountName column", "model_confidence": 0.99, "model_questions": [], "model_rationale": "The authoritative register requires a String Account.AccountName. Current gold observes the exact table, column name and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A3:J3" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-03", "label": "Account.AccountType column", "model_confidence": 0.98, "model_questions": [ "Should AccountType cover the full balance-sheet and P&L domain (Asset, Liability, Equity, Revenue, Expense), rather than only the register's stated revenue-or-expense classification?" ], "model_rationale": "Current gold observes the exact String Account.AccountType column. Structural coverage is direct, although the register definition mentions revenue/expense while the fictional examples also include asset, liability and equity values.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A4:J4", "Chart of Accounts!C3:C13" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-04", "label": "Calendar.DateKey column", "model_confidence": 0.97, "model_questions": [ "Should the YYYYMMDD encoding and uniqueness of Calendar.DateKey be tested against source/model data during implementation validation?" ], "model_rationale": "The authoritative register requires an Int64 Calendar.DateKey in YYYYMMDD form. Current gold observes the exact table, column name and data type; actual value encoding was not available for verification.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A5:J5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-05", "label": "Calendar.Date column", "model_confidence": 0.99, "model_questions": [], "model_rationale": "The authoritative register requires a DateTime Calendar.Date. Current gold observes the exact table, column name and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A6:J6" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-06", "label": "Calendar.FiscalMonth column", "model_confidence": 0.95, "model_questions": [ "Does the current Calendar.FiscalMonth use the required July-start numbering shown by the workbook formula?", "Should Calendar.FiscalMonth be changed from Summarise by Sum to Summarise by None?" ], "model_rationale": "Current gold observes the exact Int64 Calendar.FiscalMonth column. Workbook context indicates a July fiscal-year start and supplies a formula for month numbering. Gold does not establish that the current model uses that exact derivation and notes that the column is summarised by Sum.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A7:J7", "Fiscal Calendar!A2:C3", "Fiscal Calendar!C4:C34" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-07", "label": "Ledger.DateKey column and calendar linkage", "model_confidence": 0.99, "model_questions": [], "model_rationale": "The authoritative register requires an Int64 Ledger.DateKey posting-date foreign key. Current gold observes the exact column and an active many-to-one Ledger.DateKey to Calendar.DateKey relationship.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A8:J8" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-08", "label": "Ledger.AccountKey column and account linkage", "model_confidence": 0.99, "model_questions": [], "model_rationale": "The authoritative register requires an Int64 Ledger.AccountKey account foreign key. Current gold observes the exact column and an active many-to-one Ledger.AccountKey to Account.AccountKey relationship.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A9:J9" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-09", "label": "Ledger.SignedAmount column", "model_confidence": 0.97, "model_questions": [ "Is SignedAmount already converted into a single reporting currency, and what conversion-rate/date rules are intended when CurrencyCode is added?", "Is the workbook's positive-revenue/negative-expense sign convention the required production convention?" ], "model_rationale": "The authoritative register requires a Decimal Ledger.SignedAmount in reporting-sign convention. Current gold observes the exact Decimal column. The audit confirms structure and formatting, but not source currency conversion logic or detailed sign semantics.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A10:J10", "Ledger Sample!A2:C3" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": false, "item_id": "TF-10", "label": "Ledger.IsAdjustment column", "model_confidence": 0.99, "model_questions": [ "What business rule distinguishes late or manual adjustments, and is the current field populated consistently with that rule?" ], "model_rationale": "The authoritative register requires a Boolean Ledger.IsAdjustment. Current gold observes the exact table, column name and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A11:J11" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": true, "item_id": "TF-11", "label": "Ledger.CostCentre column", "model_confidence": 0.99, "model_questions": [ "Is CostCentre available in the finance posting source at the same posting grain as Ledger?", "Is a separate Cost Centre dimension required, or is a code column on Ledger sufficient?", "Who owns the authoritative cost-centre hierarchy and effective-dating rules?" ], "model_rationale": "The authoritative register requires Ledger.CostCentre for operating-area accountability, and working sheets illustrate cost-centre codes. The audited Ledger inventory contains only DateKey, AccountKey, SignedAmount and IsAdjustment; no CostCentre object is present in available current gold.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A12:J12", "Ledger Sample!E3:E15", "Reference Data!A1:A4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": true, "item_id": "TF-12", "label": "Ledger.CurrencyCode column", "model_confidence": 0.99, "model_questions": [ "Is transaction currency available on every posting in the finance source?", "Are transaction amount, reporting amount and exchange-rate fields also needed to make transaction-currency analysis meaningful?", "Should CurrencyCode link to a governed currency dimension?" ], "model_rationale": "The authoritative register requires an ISO transaction CurrencyCode for transaction-currency analysis, and working sheets illustrate AUD/NZD codes. No CurrencyCode object is present in the audited Ledger inventory in available current gold.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A13:J13", "Ledger Sample!F3:F15", "Reference Data!C1:C4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_Partial.xlsx", "is_proposed_work": true, "item_id": "TF-13", "label": "Account.AccountGroup column", "model_confidence": 0.99, "model_questions": [ "What is the authoritative source and owner for AccountGroup mappings?", "Can an account belong to more than one management group, and are mappings effective-dated?", "The reference examples differ in grouping vocabulary from some chart-of-accounts examples; what controlled hierarchy is intended?" ], "model_rationale": "The authoritative register requires an Account.AccountGroup management roll-up. The audited Account inventory contains AccountKey, AccountName and AccountType only; no AccountGroup object is present in available current gold.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A14:J14", "Chart of Accounts!D3:D13", "Reference Data!B1:B4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-01", "label": "Account.AccountKey column (Int64)", "model_confidence": 0.99, "model_questions": [], "model_rationale": "Current gold observes the qualified column `Account.AccountKey` as Int64, matching the requested column kind and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A2:J2" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-02", "label": "Account.AccountName column (String)", "model_confidence": 0.99, "model_questions": [], "model_rationale": "Current gold observes the qualified column `Account.AccountName` as String, matching the requested column kind and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A3:J3" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-03", "label": "Account.AccountType column (String)", "model_confidence": 0.98, "model_questions": [ "Should the AccountType business definition and permitted domain explicitly include Asset, Liability and Equity as shown by the representative chart of accounts?" ], "model_rationale": "Current gold observes the qualified column `Account.AccountType` as String. The object is directly covered, although the authoritative wording limits the definition to revenue/expense while representative rows also show Asset, Liability and Equity values.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A4:J4", "Chart of Accounts!B4:C13" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-04", "label": "Calendar.DateKey column (Int64)", "model_confidence": 0.99, "model_questions": [ "Confirm that current DateKey values follow the requested YYYYMMDD encoding; current gold establishes the object and type but not value-level conformance." ], "model_rationale": "Current gold observes the qualified column `Calendar.DateKey` as Int64, matching the requested column kind and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A5:J5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-05", "label": "Calendar.Date column (DateTime)", "model_confidence": 0.99, "model_questions": [], "model_rationale": "Current gold observes the qualified column `Calendar.Date` as DateTime, matching the requested column kind and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A6:J6" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-06", "label": "Calendar.FiscalMonth column (Int64)", "model_confidence": 0.98, "model_questions": [ "Should `Calendar.FiscalMonth` be changed from Summarise by Sum to Summarise by None?", "Confirm that the current model uses July as fiscal month 1, as illustrated by the workbook formulas." ], "model_rationale": "Current gold observes the qualified column `Calendar.FiscalMonth` as Int64. The July-start prototype supports intended semantics. Current gold reports that the column summarises by Sum, which is a configuration review item rather than an absent-object gap.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A7:J7", "Fiscal Calendar!A2", "Fiscal Calendar!C4:C34" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-07", "label": "Ledger.DateKey column (Int64)", "model_confidence": 0.99, "model_questions": [], "model_rationale": "Current gold observes `Ledger.DateKey` as Int64 and an active many-to-one relationship to `Calendar.DateKey`, consistent with the requested posting-date foreign key.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A8:J8" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-08", "label": "Ledger.AccountKey column (Int64)", "model_confidence": 0.99, "model_questions": [], "model_rationale": "Current gold observes `Ledger.AccountKey` as Int64 and an active many-to-one relationship to `Account.AccountKey`, consistent with the requested account foreign key.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A9:J9" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-09", "label": "Ledger.SignedAmount column (Decimal)", "model_confidence": 0.98, "model_questions": [ "Confirm that the current column is consistently expressed in the required reporting currency and reporting-sign convention." ], "model_rationale": "Current gold observes the qualified column `Ledger.SignedAmount` as Decimal. The prototype provides reporting-sign context, but value-level currency and sign conformance were not established by the bounded evidence.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A10:J10", "Ledger Sample!A2:D3", "Management P&L!C4:D10" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-10", "label": "Ledger.IsAdjustment column (Boolean)", "model_confidence": 0.99, "model_questions": [ "Confirm the operational rule used to classify late or manual postings as adjustments; the object and type are observed but value-level business logic is not." ], "model_rationale": "Current gold observes the qualified column `Ledger.IsAdjustment` as Boolean, matching the requested column kind and data type.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A11:J11" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-11", "label": "Metrics.Actual Net measure (Decimal)", "model_confidence": 0.96, "model_questions": [ "Does the production DAX implement Actual Revenue plus signed expense balances with the intended account classification and filter context?" ], "model_rationale": "Current gold observes the qualified measure `Metrics.Actual Net` with currency formatting, satisfying the declared measure object. Exact DAX was not returned, so equivalence to the stated revenue-plus-signed-expenses logic remains a validation question.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A12:J12", "Management P&L!A4:D6", "Management P&L!B6" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-12", "label": "Metrics.Actual Revenue measure (Decimal)", "model_confidence": 0.96, "model_questions": [ "What production account-classification rule should Actual Revenue use, and does the current DAX implement it?" ], "model_rationale": "Current gold observes the qualified measure `Metrics.Actual Revenue` with currency formatting. The workbook prototype illustrates revenue selection, but exact production DAX and business semantics were not available in current gold.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A13:J13", "Management P&L!A4:D4", "Management P&L!B4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-13", "label": "Metrics.Budget Net measure (Decimal)", "model_confidence": 0.95, "model_questions": [ "What is the production budget source and grain, and does the current Budget Net DAX implement the intended budget revenue-plus-expenses logic?" ], "model_rationale": "Current gold observes the qualified measure `Metrics.Budget Net` with currency formatting. The workbook does not declare authoritative budget fact objects or a detailed budget calculation, and current gold did not expose the exact measure DAX.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A14:J14", "Management P&L!A7:D9", "Management P&L!B9" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_match", "input": "TargetArchitecture_Match.xlsx", "is_proposed_work": false, "item_id": "TF-14", "label": "Metrics.Net Variance measure (Decimal)", "model_confidence": 0.96, "model_questions": [ "Confirm that current DAX is `Actual Net - Budget Net` and that favourable-positive sign behaviour is preserved across report contexts." ], "model_rationale": "Current gold observes the qualified measure `Metrics.Net Variance` with currency formatting. The declared logic is Actual Net minus Budget Net, but exact DAX was not returned for equivalence checking.", "model_status": "direct", "weak_signal": false, "workbook_evidence": [ "Target Fields!A15:J15", "Management P&L!A10:D10", "Management P&L!B10" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-01", "label": "Customer.CustomerIdentifier column", "model_confidence": 0.99, "model_questions": [ "What is the governed customer key, and is it stable and unique across all CRM records?", "Must source-system identifiers be retained alongside an enterprise customer identifier?" ], "model_rationale": "The authoritative register requires a String customer identity sourced from the CRM customer master. The current-gold model has no Customer table or customer identifier. AccountKey is an accounting key and is not evidence of enterprise customer identity.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A2:J2" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-02", "label": "Customer.CustomerSegment column", "model_confidence": 0.99, "model_questions": [ "Are Enterprise, Mid-market and Small business the complete governed segment domain?", "Is segmentation current-state only, or must historical segment changes be analysed?" ], "model_rationale": "The required commercial segment and its illustrative ENT/MID/SMB domain are not present in the observed finance-ledger model. AccountType is not a supported equivalent because it describes accounting accounts rather than customers.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A3:J3", "Reference Data!A2:C4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-03", "label": "Customer.RelationshipOwner column", "model_confidence": 0.99, "model_questions": [ "Should the model retain owner identifiers as well as display names?", "How should reassignment history, vacancies and shared ownership be represented?" ], "model_rationale": "No customer entity or accountable relationship-owner attribute was observed in current gold.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A4:J4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-04", "label": "SalesOrder.OrderIdentifier column", "model_confidence": 0.99, "model_questions": [ "What defines a unique order across order-management systems or legal entities?", "Are revisions, split orders and cancelled orders represented by the same identifier or separate records?" ], "model_rationale": "No SalesOrder table or customer-order identifier was observed in the current model. Ledger keys and finance entries do not establish order identity.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A5:J5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-05", "label": "SalesOrder.OrderGrossValue column", "model_confidence": 0.99, "model_questions": [ "Does gross value include tax, freight or other charges?", "Which currency fields and conversion rules are required?", "How are cancellations, returns and subsequent order amendments reflected?" ], "model_rationale": "The workbook requires gross order value before discounts at order grain. Current gold contains Ledger.SignedAmount at finance-ledger grain, which is not a semantic or structural match to gross booked order value.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A6:J6", "Sales Orders!A1:D3" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-06", "label": "SalesOrder.SalesChannel column", "model_confidence": 0.99, "model_questions": [ "Are Direct, Partner and Online exhaustive governed channels?", "Can an order have multiple contributing channels, and if so what attribution rule applies?" ], "model_rationale": "No sales-order acquisition-channel attribute was observed. The workbook's Direct, Partner and Online values are illustrative reference data, not a current-gold implementation.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A7:J7", "Reference Data!A5:C7" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-07", "label": "SalesMetrics.Customer Lifetime Value measure", "model_confidence": 0.99, "model_questions": [ "What forecast horizon and expected-order-frequency method should production CLV use?", "Should CLV use gross order value, net revenue, gross margin or contribution margin?", "How should churn, returns, discounts and customer tenure affect the calculation?" ], "model_rationale": "No Customer Lifetime Value measure or supporting customer/order structure was observed. The current model's four finance measures are differently named and have unknown exact DAX. The workbook prototype's 3.2 frequency multiplier is illustrative and does not establish a production definition.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A8:J8", "Sales KPI Prototype!A5:C5", "Sales KPI Prototype!B5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "TargetArchitecture_CompleteMiss.xlsx", "is_proposed_work": true, "item_id": "TF-08", "label": "SalesMetrics.Gross Order Intake measure", "model_confidence": 0.99, "model_questions": [ "What event makes an order count as booked intake, and which date drives reporting?", "Should cancelled or amended orders restate prior periods?", "Are intake values reported before discounts, tax and currency conversion in all views?" ], "model_rationale": "The required sum of OrderGrossValue and its prototype formula have no observed counterpart in current gold. Actual Revenue cannot be assumed equivalent to gross booked order value, particularly because exact DAX and production semantics for current measures were not returned.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Target Fields!A9:J9", "Sales KPI Prototype!A4:C4", "Sales KPI Prototype!B4" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_partial", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R1", "label": "Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off", "model_confidence": 0.93, "model_questions": [ "Which report page or audience should own the control view?", "What exact event and timestamp define reporting-pack sign-off?", "How is a manual adjustment identified: JournalSource, IsAdjustment, or a combination?" ], "model_rationale": "The observed model has Ledger.SignedAmount, Ledger.IsAdjustment, Calendar support, and a Metrics table. Consultant evidence supports upstream JournalSource and ApprovalStatus. However, ApprovalStatus is not in the audited model and no delivered close-control view or sign-off workflow is evidenced.", "model_status": "partial", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R10", "label": "Obtain consultant confirmation that approved adjustments are excluded from the exception value", "model_confidence": 0.98, "model_questions": [ "Who is authorised to provide consultant confirmation?", "What test cases will demonstrate exclusion of approved adjustments?", "Must confirmation be recorded in a test script, deployment approval, or governance register?" ], "model_rationale": "No Unapproved Adjustment Value implementation or consultant acceptance record is present in current gold. Although the requirement clearly states the intended exclusion, no evidence confirms that a delivered calculation enforces it.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_partial", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R2", "label": "Expose Ledger.JournalSource", "model_confidence": 0.99, "model_questions": [ "Is JournalSource approved for addition to the target semantic model?", "What source values constitute manual journals?", "Who owns value-domain governance and mapping changes?" ], "model_rationale": "A consultant evidence page states that Ledger.JournalSource is available in the governed ledger export at entry grain, but the audited Ledger table has only DateKey, AccountKey, SignedAmount, and IsAdjustment. Thus source support exists while current-model implementation was not observed.", "model_status": "partial", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_partial", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R3", "label": "Expose Ledger.ApprovalStatus", "model_confidence": 0.99, "model_questions": [ "Is ApprovalStatus approved for addition to the semantic model?", "What is the authoritative status domain and case handling?", "Is status captured as current state or as-of close cut-off?" ], "model_rationale": "A consultant evidence page states that Ledger.ApprovalStatus is available in the governed ledger export at entry grain, but it was not observed in the audited Ledger table. Source feasibility is supported; implementation in the current model is not.", "model_status": "partial", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R4", "label": "Expose Metrics.Unapproved Adjustment Value", "model_confidence": 0.99, "model_questions": [ "Should this be a new explicit DAX measure in Metrics?", "What currency and formatting rules apply?", "Must the measure respond to all account and calendar filters?" ], "model_rationale": "The requested measure is not one of the four observed Metrics measures. Current gold contains no supporting object with this qualified name. This means not found within the available discovered landscape, not proof of enterprise-wide absence.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_partial", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R5", "label": "Preserve JournalSource and ApprovalStatus at ledger-entry grain", "model_confidence": 0.87, "model_questions": [ "What column or composite key uniquely identifies a ledger entry?", "Can one ledger entry have multiple approval history rows?", "Will ingestion deduplicate, aggregate, or otherwise change source grain?" ], "model_rationale": "Consultant evidence describes both upstream attributes as ledger-entry-grain fields and recommends preserving that grain. The audited model does not contain the attributes, and current gold does not establish a unique ledger-entry key or confirm the implemented Ledger table grain, so feasibility is supported but conformity is unverified.", "model_status": "possible", "weak_signal": true, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_partial", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R6", "label": "Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved", "model_confidence": 0.95, "model_questions": [ "Does 'sum the absolute value' mean SUMX over ABS(SignedAmount) per qualifying entry?", "Does 'not approved' include blank, pending, rejected, cancelled, or unknown statuses?", "Should reversals and duplicate adjustment entries be handled specially?" ], "model_rationale": "The model contains SignedAmount and IsAdjustment, while ApprovalStatus is supported upstream. No exact DAX was available and the requested measure was not observed. The component concepts partially map, but the calculation and treatment of status values remain unimplemented or unverified.", "model_status": "partial", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.current-model", "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R7", "label": "Retain drill-through to the original ledger entry", "model_confidence": 0.95, "model_questions": [ "What is the authoritative ledger-entry identifier?", "Should drill-through remain inside Power BI or deep-link to the finance system?", "Which entry attributes may be displayed, considering access and sensitivity?" ], "model_rationale": "Current gold does not identify a ledger-entry key, original-entry URL/reference, drill-through report page, or interaction. Existing Ledger columns are insufficient to establish traceability to an individual original entry.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_partial", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R8", "label": "Reconcile acceptance to the governed ledger export for a closed month", "model_confidence": 0.91, "model_questions": [ "Which export, version, and owner are authoritative?", "Which closed month will be used for acceptance?", "Must reconciliation cover row counts, qualifying entry IDs, values, or all three?", "What tolerance and sign-off evidence are required?" ], "model_rationale": "The evidence page supports the existence of a governed finance ledger export and recommends reconciliation, but no completed closed-month reconciliation, tolerance, results, or acceptance sign-off is recorded. The control is plausible but not established.", "model_status": "possible", "weak_signal": true, "workbook_evidence": [ "Consultant Requirement!A5" ] }, { "basis": "model_unreviewed", "cited_gold_pages": [ "fde-finance.journal-controls" ], "consultant_comment": null, "disposition": "confirmed_gap", "input": "Month-end close adjustment controls", "is_proposed_work": true, "item_id": "R9", "label": "Create an explicit definition of late approvals", "model_confidence": 0.98, "model_questions": [ "Is an approval late when it occurs after month end, close lock, export extraction, refresh, or pack sign-off?", "Should late approvals restate the closed-month result or remain visible as subsequent changes?", "Which timestamp and time zone are authoritative?" ], "model_rationale": "Current gold notes that late approval changes and refresh behaviour need documentation, but it provides no explicit definition of late approval. The required definition is therefore not found in the available discovered landscape.", "model_status": "not_found", "weak_signal": false, "workbook_evidence": [ "Consultant Requirement!A5" ] } ], "limitations": [ { "input": "TargetArchitecture_Partial.xlsx", "limitation": "The workbook identifies its working records as synthetic and fictional (`Read Me!B8,B10`); they illustrate design intent but do not prove source-system values, reconciliation or production readiness." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "The evidence rendering deliberately excludes ordinary numeric, date and Boolean cell values. Consequently, sample key values, dates, amounts, adjustment flags, budgets and formula results cannot be inspected or reconciled." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "Stored formulas were extracted, but formula text is not proof that recalculation succeeds or that cached results are current. The workbook calculation mode is auto, but no recalculation outcome is evidenced." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "No workbook connections, queries, external links, Power Query/DataMashup, pivots/charts or embedded data model were found. The XLSX therefore documents/prototypes requirements but does not evidence an implemented refresh path or embedded semantic model." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "Comments, notes, hyperlinks, validation rules and conditional formatting were inspected and not found; there is no additional evidence from those categories." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "Current gold is bounded to discovered current-state/evidence pages. Objects classified not_found were not found within that boundary and may still exist upstream or elsewhere in the client's estate." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "The current-gold page does not provide exact DAX expressions for the four observed measures, so matching measure names cannot prove calculation equivalence or production status." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "The current audit observed two hidden automatic date tables alongside the explicit Calendar table; the intended production date strategy is unresolved." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "The workbook has no VBA project, embedded objects, digital signatures or workbook/sheet protection. This says nothing about security or governance in downstream Power BI deployments." }, { "input": "TargetArchitecture_Partial.xlsx", "limitation": "No consultant comments were supplied in consultant_guidance, so there was no additional trusted steering to apply." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "The XLSX extraction intentionally excludes ordinary numeric, date and Boolean cell values. Representative sample values therefore cannot be used for reconciliation, completeness testing or value-level conformance, consistent with `Read Me!B10`." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "Workbook formulas were extracted, but formula text is evidence only of stored prototype logic; successful recalculation and current cached results were not established." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "Current gold identifies all four requested measures but did not return their exact DAX expressions. Measure existence is direct coverage; production calculation equivalence remains to be validated." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "Permitted-value domains and row-level business-rule outcomes were not available in current gold, including AccountType classifications, DateKey encoding and IsAdjustment classification." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "No workbook connections, external links, Power Query, embedded model, pivots, charts, comments, hyperlinks, validation rules or conditional formatting were found by the extractor. The workbook therefore does not establish production source connectivity or implementation status." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "No workbook or sheet protection, VBA project, embedded objects or digital signatures were found. These findings do not establish security requirements for the target Power BI solution." }, { "input": "TargetArchitecture_Match.xlsx", "limitation": "The current-gold boundary is a bounded audit snapshot. Findings describe the available discovered landscape and do not prove wider estate-wide presence or absence." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "The current-gold boundary contains only the selected finance current-state page and a journal-controls evidence page. Absence from these pages is not proof of enterprise-wide absence." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "The workbook states that all sample values are fictional and intended for design discussion, not reconciliation or production reporting (`Read Me`!B10). Ordinary numeric values were deliberately excluded from the evidence rendering, so prototype inputs and calculated outputs cannot be inspected or reconciled." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "Formula text was extracted, but stored formulas do not prove successful recalculation, current cached values or production correctness." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "No workbook connections, queries, external links, Power Query/DataMashup, pivots, charts, slicers or embedded Power Pivot model were found. Therefore, the workbook evidences requirements and prototypes, not implemented data integration or a semantic model." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "No comments, notes, hyperlinks, validation rules or conditional-formatting rules were found. The reference lists therefore do not demonstrate enforced data validation." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "The workbook extraction was included without reported truncation or omitted items, but opaque binary payloads are indicator-only by profile and ordinary non-text data values are outside scope." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "Exact DAX definitions for the four current-gold finance measures were not available, so their detailed semantics cannot be independently compared. Their observed names and the model structure nevertheless provide no supporting object for either requested sales measure." }, { "input": "TargetArchitecture_CompleteMiss.xlsx", "limitation": "The authoritative register does not explicitly declare `SalesOrder.CustomerIdentifier` or a relationship, although the synthetic order sheet implies that linkage. This is a requirements completeness issue rather than current implementation evidence." }, { "input": "Month-end close adjustment controls", "limitation": "The source is a six-text-cell virtual workbook; numeric values, formulas, formatting, and non-text workbook content were intentionally excluded." }, { "input": "Month-end close adjustment controls", "limitation": "All substantive requirements are contained in a single text cell, Consultant Requirement!A5; decomposition into ten requirements is interpretive but preserves exact source citation." }, { "input": "Month-end close adjustment controls", "limitation": "Current gold is bounded to two allowed pages in the selected build. Not-found results do not prove absence elsewhere in the client estate." }, { "input": "Month-end close adjustment controls", "limitation": "The audited semantic-model page did not provide exact DAX for observed measures, so no existing measure can be semantically repurposed by assumption." }, { "input": "Month-end close adjustment controls", "limitation": "The consultant evidence page supports upstream attribute availability but explicitly does not establish Power BI implementation." }, { "input": "Month-end close adjustment controls", "limitation": "No report-page inventory, visual metadata, refresh configuration, row-level source samples, ledger-entry key, or acceptance-test artefacts were available." }, { "input": "Month-end close adjustment controls", "limitation": "No substantive consultant-guidance comments were supplied beyond the trusted steering wrapper, so there was no additional guidance to apply." } ], "open_questions": [ { "about": "Management P&L metric prototype", "input": "TargetArchitecture_Partial.xlsx", "question": "Are Actual Expenses, Budget Revenue and Budget Expenses required as production measures even though they are absent from the authoritative register?" }, { "about": "Management P&L metric prototype", "input": "TargetArchitecture_Partial.xlsx", "question": "What are the approved DAX definitions and source for budget values?" }, { "about": "Management P&L metric prototype", "input": "TargetArchitecture_Partial.xlsx", "question": "Should revenue/expense classification use account-number ranges as in the prototype formulas, or governed AccountType/AccountGroup mappings?" }, { "about": "Account.AccountType column", "input": "TargetArchitecture_Partial.xlsx", "question": "Should AccountType cover the full balance-sheet and P&L domain (Asset, Liability, Equity, Revenue, Expense), rather than only the register's stated revenue-or-expense classification?" }, { "about": "Calendar.DateKey column", "input": "TargetArchitecture_Partial.xlsx", "question": "Should the YYYYMMDD encoding and uniqueness of Calendar.DateKey be tested against source/model data during implementation validation?" }, { "about": "Calendar.FiscalMonth column", "input": "TargetArchitecture_Partial.xlsx", "question": "Does the current Calendar.FiscalMonth use the required July-start numbering shown by the workbook formula?" }, { "about": "Calendar.FiscalMonth column", "input": "TargetArchitecture_Partial.xlsx", "question": "Should Calendar.FiscalMonth be changed from Summarise by Sum to Summarise by None?" }, { "about": "Ledger.SignedAmount column", "input": "TargetArchitecture_Partial.xlsx", "question": "Is SignedAmount already converted into a single reporting currency, and what conversion-rate/date rules are intended when CurrencyCode is added?" }, { "about": "Ledger.SignedAmount column", "input": "TargetArchitecture_Partial.xlsx", "question": "Is the workbook's positive-revenue/negative-expense sign convention the required production convention?" }, { "about": "Ledger.IsAdjustment column", "input": "TargetArchitecture_Partial.xlsx", "question": "What business rule distinguishes late or manual adjustments, and is the current field populated consistently with that rule?" }, { "about": "Ledger.CostCentre column", "input": "TargetArchitecture_Partial.xlsx", "question": "Is CostCentre available in the finance posting source at the same posting grain as Ledger?" }, { "about": "Ledger.CostCentre column", "input": "TargetArchitecture_Partial.xlsx", "question": "Is a separate Cost Centre dimension required, or is a code column on Ledger sufficient?" }, { "about": "Ledger.CostCentre column", "input": "TargetArchitecture_Partial.xlsx", "question": "Who owns the authoritative cost-centre hierarchy and effective-dating rules?" }, { "about": "Ledger.CurrencyCode column", "input": "TargetArchitecture_Partial.xlsx", "question": "Is transaction currency available on every posting in the finance source?" }, { "about": "Ledger.CurrencyCode column", "input": "TargetArchitecture_Partial.xlsx", "question": "Are transaction amount, reporting amount and exchange-rate fields also needed to make transaction-currency analysis meaningful?" }, { "about": "Ledger.CurrencyCode column", "input": "TargetArchitecture_Partial.xlsx", "question": "Should CurrencyCode link to a governed currency dimension?" }, { "about": "Account.AccountGroup column", "input": "TargetArchitecture_Partial.xlsx", "question": "What is the authoritative source and owner for AccountGroup mappings?" }, { "about": "Account.AccountGroup column", "input": "TargetArchitecture_Partial.xlsx", "question": "Can an account belong to more than one management group, and are mappings effective-dated?" }, { "about": "Account.AccountGroup column", "input": "TargetArchitecture_Partial.xlsx", "question": "The reference examples differ in grouping vocabulary from some chart-of-accounts examples; what controlled hierarchy is intended?" }, { "about": "Account.AccountType column (String)", "input": "TargetArchitecture_Match.xlsx", "question": "Should the AccountType business definition and permitted domain explicitly include Asset, Liability and Equity as shown by the representative chart of accounts?" }, { "about": "Calendar.DateKey column (Int64)", "input": "TargetArchitecture_Match.xlsx", "question": "Confirm that current DateKey values follow the requested YYYYMMDD encoding; current gold establishes the object and type but not value-level conformance." }, { "about": "Calendar.FiscalMonth column (Int64)", "input": "TargetArchitecture_Match.xlsx", "question": "Should `Calendar.FiscalMonth` be changed from Summarise by Sum to Summarise by None?" }, { "about": "Calendar.FiscalMonth column (Int64)", "input": "TargetArchitecture_Match.xlsx", "question": "Confirm that the current model uses July as fiscal month 1, as illustrated by the workbook formulas." }, { "about": "Ledger.SignedAmount column (Decimal)", "input": "TargetArchitecture_Match.xlsx", "question": "Confirm that the current column is consistently expressed in the required reporting currency and reporting-sign convention." }, { "about": "Ledger.IsAdjustment column (Boolean)", "input": "TargetArchitecture_Match.xlsx", "question": "Confirm the operational rule used to classify late or manual postings as adjustments; the object and type are observed but value-level business logic is not." }, { "about": "Metrics.Actual Net measure (Decimal)", "input": "TargetArchitecture_Match.xlsx", "question": "Does the production DAX implement Actual Revenue plus signed expense balances with the intended account classification and filter context?" }, { "about": "Metrics.Actual Revenue measure (Decimal)", "input": "TargetArchitecture_Match.xlsx", "question": "What production account-classification rule should Actual Revenue use, and does the current DAX implement it?" }, { "about": "Metrics.Budget Net measure (Decimal)", "input": "TargetArchitecture_Match.xlsx", "question": "What is the production budget source and grain, and does the current Budget Net DAX implement the intended budget revenue-plus-expenses logic?" }, { "about": "Metrics.Net Variance measure (Decimal)", "input": "TargetArchitecture_Match.xlsx", "question": "Confirm that current DAX is `Actual Net - Budget Net` and that favourable-positive sign behaviour is preserved across report contexts." }, { "about": "Customer.CustomerIdentifier column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "What is the governed customer key, and is it stable and unique across all CRM records?" }, { "about": "Customer.CustomerIdentifier column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Must source-system identifiers be retained alongside an enterprise customer identifier?" }, { "about": "Customer.CustomerSegment column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Are Enterprise, Mid-market and Small business the complete governed segment domain?" }, { "about": "Customer.CustomerSegment column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Is segmentation current-state only, or must historical segment changes be analysed?" }, { "about": "Customer.RelationshipOwner column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Should the model retain owner identifiers as well as display names?" }, { "about": "Customer.RelationshipOwner column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "How should reassignment history, vacancies and shared ownership be represented?" }, { "about": "SalesOrder.OrderIdentifier column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "What defines a unique order across order-management systems or legal entities?" }, { "about": "SalesOrder.OrderIdentifier column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Are revisions, split orders and cancelled orders represented by the same identifier or separate records?" }, { "about": "SalesOrder.OrderGrossValue column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Does gross value include tax, freight or other charges?" }, { "about": "SalesOrder.OrderGrossValue column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Which currency fields and conversion rules are required?" }, { "about": "SalesOrder.OrderGrossValue column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "How are cancellations, returns and subsequent order amendments reflected?" }, { "about": "SalesOrder.SalesChannel column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Are Direct, Partner and Online exhaustive governed channels?" }, { "about": "SalesOrder.SalesChannel column", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Can an order have multiple contributing channels, and if so what attribution rule applies?" }, { "about": "SalesMetrics.Customer Lifetime Value measure", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "What forecast horizon and expected-order-frequency method should production CLV use?" }, { "about": "SalesMetrics.Customer Lifetime Value measure", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Should CLV use gross order value, net revenue, gross margin or contribution margin?" }, { "about": "SalesMetrics.Customer Lifetime Value measure", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "How should churn, returns, discounts and customer tenure affect the calculation?" }, { "about": "SalesMetrics.Gross Order Intake measure", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "What event makes an order count as booked intake, and which date drives reporting?" }, { "about": "SalesMetrics.Gross Order Intake measure", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Should cancelled or amended orders restate prior periods?" }, { "about": "SalesMetrics.Gross Order Intake measure", "input": "TargetArchitecture_CompleteMiss.xlsx", "question": "Are intake values reported before discounts, tax and currency conversion in all views?" }, { "about": "Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off", "input": "Month-end close adjustment controls", "question": "Which report page or audience should own the control view?" }, { "about": "Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off", "input": "Month-end close adjustment controls", "question": "What exact event and timestamp define reporting-pack sign-off?" }, { "about": "Provide a monthly close-control view identifying unapproved manual adjustments before reporting-pack sign-off", "input": "Month-end close adjustment controls", "question": "How is a manual adjustment identified: JournalSource, IsAdjustment, or a combination?" }, { "about": "Obtain consultant confirmation that approved adjustments are excluded from the exception value", "input": "Month-end close adjustment controls", "question": "Who is authorised to provide consultant confirmation?" }, { "about": "Obtain consultant confirmation that approved adjustments are excluded from the exception value", "input": "Month-end close adjustment controls", "question": "What test cases will demonstrate exclusion of approved adjustments?" }, { "about": "Obtain consultant confirmation that approved adjustments are excluded from the exception value", "input": "Month-end close adjustment controls", "question": "Must confirmation be recorded in a test script, deployment approval, or governance register?" }, { "about": "Expose Ledger.JournalSource", "input": "Month-end close adjustment controls", "question": "Is JournalSource approved for addition to the target semantic model?" }, { "about": "Expose Ledger.JournalSource", "input": "Month-end close adjustment controls", "question": "What source values constitute manual journals?" }, { "about": "Expose Ledger.JournalSource", "input": "Month-end close adjustment controls", "question": "Who owns value-domain governance and mapping changes?" }, { "about": "Expose Ledger.ApprovalStatus", "input": "Month-end close adjustment controls", "question": "Is ApprovalStatus approved for addition to the semantic model?" }, { "about": "Expose Ledger.ApprovalStatus", "input": "Month-end close adjustment controls", "question": "What is the authoritative status domain and case handling?" }, { "about": "Expose Ledger.ApprovalStatus", "input": "Month-end close adjustment controls", "question": "Is status captured as current state or as-of close cut-off?" }, { "about": "Expose Metrics.Unapproved Adjustment Value", "input": "Month-end close adjustment controls", "question": "Should this be a new explicit DAX measure in Metrics?" }, { "about": "Expose Metrics.Unapproved Adjustment Value", "input": "Month-end close adjustment controls", "question": "What currency and formatting rules apply?" }, { "about": "Expose Metrics.Unapproved Adjustment Value", "input": "Month-end close adjustment controls", "question": "Must the measure respond to all account and calendar filters?" }, { "about": "Preserve JournalSource and ApprovalStatus at ledger-entry grain", "input": "Month-end close adjustment controls", "question": "What column or composite key uniquely identifies a ledger entry?" }, { "about": "Preserve JournalSource and ApprovalStatus at ledger-entry grain", "input": "Month-end close adjustment controls", "question": "Can one ledger entry have multiple approval history rows?" }, { "about": "Preserve JournalSource and ApprovalStatus at ledger-entry grain", "input": "Month-end close adjustment controls", "question": "Will ingestion deduplicate, aggregate, or otherwise change source grain?" }, { "about": "Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved", "input": "Month-end close adjustment controls", "question": "Does 'sum the absolute value' mean SUMX over ABS(SignedAmount) per qualifying entry?" }, { "about": "Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved", "input": "Month-end close adjustment controls", "question": "Does 'not approved' include blank, pending, rejected, cancelled, or unknown statuses?" }, { "about": "Calculate the exception measure as the sum of absolute adjustment-entry values where approval status is not approved", "input": "Month-end close adjustment controls", "question": "Should reversals and duplicate adjustment entries be handled specially?" }, { "about": "Retain drill-through to the original ledger entry", "input": "Month-end close adjustment controls", "question": "What is the authoritative ledger-entry identifier?" }, { "about": "Retain drill-through to the original ledger entry", "input": "Month-end close adjustment controls", "question": "Should drill-through remain inside Power BI or deep-link to the finance system?" }, { "about": "Retain drill-through to the original ledger entry", "input": "Month-end close adjustment controls", "question": "Which entry attributes may be displayed, considering access and sensitivity?" }, { "about": "Reconcile acceptance to the governed ledger export for a closed month", "input": "Month-end close adjustment controls", "question": "Which export, version, and owner are authoritative?" }, { "about": "Reconcile acceptance to the governed ledger export for a closed month", "input": "Month-end close adjustment controls", "question": "Which closed month will be used for acceptance?" }, { "about": "Reconcile acceptance to the governed ledger export for a closed month", "input": "Month-end close adjustment controls", "question": "Must reconciliation cover row counts, qualifying entry IDs, values, or all three?" }, { "about": "Reconcile acceptance to the governed ledger export for a closed month", "input": "Month-end close adjustment controls", "question": "What tolerance and sign-off evidence are required?" }, { "about": "Create an explicit definition of late approvals", "input": "Month-end close adjustment controls", "question": "Is an approval late when it occurs after month end, close lock, export extraction, refresh, or pack sign-off?" }, { "about": "Create an explicit definition of late approvals", "input": "Month-end close adjustment controls", "question": "Should late approvals restate the closed-month result or remain visible as subsequent changes?" }, { "about": "Create an explicit definition of late approvals", "input": "Month-end close adjustment controls", "question": "Which timestamp and time zone are authoritative?" } ], "totals": { "bands": { "largely_ready": 1, "material_gaps": 2, "not_compared": 3, "ready": 1 }, "carried_on_model": 45, "client_spreadsheets": 6, "compared": 4, "consultant_decided": 0, "consultant_requirements": 1, "effective_dispositions": { "confirmed_gap": 15, "confirmed_match": 24, "confirmed_partial": 6 }, "failed_comparisons": 0, "inputs": 7, "model_findings": { "context_only": 1, "direct": 24, "not_found": 15, "partial": 4, "possible": 2 }, "not_compared": 3, "proposed_work_items": 21, "scope_bearing_items": 45, "sheets": 40, "weak_signal_assumptions": 2 } }