A single source of truth (SSOT) is the organisational principle — and its technical implementation — that each financial metric, each entity record, and each reporting definition has one authoritative location from which all reports, dashboards, and analyses are produced. The concrete detail the headline omits: SSOT is not achieved by installing a BI tool. It is achieved when the governance question — whose number is right when two reports disagree — has a definitive, pre-agreed answer before the disagreement occurs. A BI environment where the finance team maintains a spreadsheet that “corrects” the BI report’s numbers, where the CFO’s dashboard shows a different revenue figure from the board pack prepared by FP&A, or where two business units calculate the same KPI differently is not a single source of truth environment regardless of the sophistication of the technology in use.
Why This Matters for Finance Leaders in Egypt and the GCC
The version conflict problem is particularly acute in GCC enterprise environments where management reporting is assembled from multiple sources — ERP exports to Excel, EPM-generated reports, BI dashboards, and manually maintained management account models. When the CFO’s monthly performance review is prepared from four different data sources with different extraction timings, different currency conversion approaches, and different account mapping conventions, the result is a management pack that cannot be reconciled internally. Finance teams spend the days before each board meeting resolving number discrepancies rather than preparing analysis, and the board receives a pack where the same entity’s revenue appears differently in two sections.
IFRS 18’s management performance measures (MPM) requirement — effective for annual periods beginning on or after 1 January 2027 — adds a regulatory dimension to SSOT for GCC listed companies. IFRS 18 requires that non-IFRS metrics disclosed in public communications (adjusted EBITDA, underlying revenue, operating profit before specific items) be reconciled to the statutory financial statements in the notes. A company that produces these metrics from a management reporting model that is not aligned to its statutory reporting SSOT faces a reconciliation challenge at every reporting period — the MPM cannot be traced to the statutory statements because the two originate from different data sources with different calculation logic.
What Good Looks Like
A genuine SSOT environment has two characteristics that are visible to a finance leader. First, the number in the management dashboard, the board pack, and the statutory disclosure is the same number — not “substantially the same with minor timing differences,” but precisely the same, because all three are produced from the same governed data source with the same calculation logic. Second, when someone questions a number, the response is “here is the data source, here is the calculation, here is the audit trail from source transaction to the reported figure” — not a multi-day investigation into which spreadsheet version is correct.
What Buyers Get Wrong
The specific failure that prevents SSOT from being achieved even after a BI investment is the persistence of departmental Excel models that are maintained alongside the BI tool rather than replaced by it. Finance teams maintain their Excel models “as a backup” or “because the BI tool doesn’t do everything we need yet” — and they trust the Excel model over the BI report when the two differ, even after the BI tool is officially the SSOT. The Excel model is not discontinued because no one has made a governance decision to discontinue it. The governance decision — the Excel model is decommissioned on a specific date, after which the BI tool is the only approved source for the relevant metrics — is what creates SSOT, not the existence of the BI tool.
How Loop Wise Solutions Approaches This
In BI programme advisory, we include an explicit SSOT governance decision as a programme milestone: a documented agreement, signed by the finance leadership, specifying which sources are authoritative for which metrics and the decommission date for parallel sources. Without this decision, the BI tool coexists with the spreadsheets indefinitely, and the organisation has invested in a BI tool that supplements rather than replaces the data fragmentation problem it was intended to solve.
