Farm plots separated by a dirt road in Krakeel River, South Africa.
Back to insights

mSCOA data-quality checks and reconciliation responsibilities

Review mSCOA data quality with an annotated reconciliation map, clear evidence owners and careful distinctions between portal checks and accounting accuracy.

By Justin Kettle · Founder & Managing Director

Published · Updated

Illustrative photograph: Charl Durand · Photo source

An mSCOA data-quality check is an advisory review workflow that reconciles transaction source data against multi-dimensional ledger accounts and portal data strings.

Within South African local government, municipal financial administration operates under the Municipal Regulations on Standard Chart of Accounts (mSCOA). Promulgated under the Local Government: Municipal Finance Management Act 56 of 2003 (MFMA), mSCOA regulations apply specifically to municipalities and municipal entities. Under Regulation 13, the municipal accounting officer holds statutory responsibility for system compliance, whereas advisory support provides review frameworks.

Distinguishing technical system validation from substantive accounting accuracy

must accurately record all financial transactions and data in the applicable segment

— mSCOA Regulations (2014), regulation 5(1)(b)

A foundational principle of mSCOA data governance is separating technical data-string validation from substantive accounting accuracy. As outlined in National Treasury MFMA Circular No. 134 (issued on 20 March 2026), the validation discussion identifies structural and balancing checks for data strings submitted through GoMuni, including further rules planned for chart version 7.2. However, a successful data string upload or automated portal acceptance does not prove that underlying transaction data is substantively accurate.

Regulation 5(1)(b) requires accuracy in transaction recording; regulation 5(1)(c) restricts mapped or extrapolated data. The circular describes regional and functional mini trial balance expectations. Verifying substantive accuracy also requires reconciling primary transaction source documents—such as invoices, billing registers, and bank feeds—against general ledger posting accounts. Technical portal validation tests file structure, whereas substantive data quality requires management verification.

Reconciling source transactions across multi-dimensional chart segments

Achieving mSCOA data quality requires systematic reconciliation across all seven regulated chart segments: Funding, Function, Municipal Standard Classification, Project, Regional Indicator, Item, and Costing. Discrepancies between operational sub-ledgers and general ledger accounts frequently distort financial reporting. For example, MFMA Circular No. 134 highlights common reporting errors in submitted data strings, including unbundled salary clearing accounts, incorrect funding segment links, and un-rolled opening balances.

To maintain data alignment, municipal finance teams should reconcile sub-ledgers and the general ledger as part of preparing management and statutory reports. Finance teams should establish continuous data-quality checks across core transaction streams to verify chart alignment:

  • Reconciling payroll sub-ledgers to ensure salary clearing and control accounts are fully unbundled into prescribed chart accounts.
  • Cross-referencing grant receipts and operational funding sources against approved funding segment linkages.
  • Matching customer billing registers and utility sub-ledgers against general ledger revenue item segments.
  • Comparing supplier and retention records with supported liability balances, with technical accounting and tax questions referred to qualified owners.
  • Testing opening balance rollovers between financial years to ensure pre-audited and audited adjustments balance to zero.

Applying regional indicator guidance without prescribing uniform allocations

Classifying municipal transactions within the Regional Indicator segment requires applying National Treasury's Project Detail Document guidance (Version 7.1, January 2026) while respecting municipal operational differences. The Regional segment records spending, revenue, assets, and liabilities at the lowest relevant geographical level, enabling performance measurement on a ward or regional basis in the Service Delivery and Budget Implementation Plan (SDBIP). The Regional Identifier structure distinguishes between National, Provincial, and Local Government functions, while the guide identifies the applicable classification structure.

National Treasury regional guidance establishes that transactions should be allocated where intended beneficiaries normally reside, rather than the physical location of the service provider or facility. However, regional allocation principles do not prescribe rigid, uniform allocation percentages for all institutions. National Treasury guidance explicitly allows flexibility based on municipal size, system sophistication, and logistical arrangements. Municipalities may allocate shared costs equally, by fixed population percentages, or via management discretion based on direct service benefit.

Annotated mSCOA reconciliation responsibility map

To establish clear operational accountability, municipal finance departments should deploy an annotated reconciliation map. The table below outlines an advisory design framework—explicitly distinguished from a statutory form—that details transaction sources, ledger accounts, classification rules, reporting differences, primary evidence, and exception ownership.

Transaction source streamGeneral ledger accountmSCOA segment classificationReporting difference focusPrimary verification evidenceException ownership role
Payroll sub-ledgerSalary clearing & control accountsItem & Function segmentsUnbundled clearing balanceBank payout register & journal voucherPayroll Manager
Conditional grant receiptGrant liability & revenue accountsFunding & Project segmentsUnlinked grant transfersGazette allocation & bank deposit slipTreasury Supervisor
Supplier invoice registerSupplier control accountItem & Project segmentsUnmatched invoice or receiptInvoice, order & receiving recordExpenditure Manager
Property billing registerConsumer debtors & rates revenueItem & Region segmentsUnmapped ward locationValuation roll & cadastral plot fileRevenue Manager
Infrastructure maintenanceRepairs & maintenance projectProject, Function & RegionUnmatched project codingMaintenance job card & order voucherAsset Manager
Bank electronic feedMain bank account & cash bookItem & Funding segmentsUn-reconciled bank depositSigned monthly bank reconciliation fileChief Financial Officer

Governing exception resolution and management oversight

Maintaining mSCOA data quality requires structured exception management and executive oversight. As a proposed control, teams should record classification errors, unreconciled balances and allocation gaps in an exception register. Operational owners should investigate root causes and distinguish a transaction correction from a change to an approved budget. Any budget change needs the applicable approval route; an accounting correction is not automatically a virement.

Under Regulation 13 of the mSCOA Regulations, the municipal manager as accounting officer holds final accountability for internal controls and system compliance. Advisory reviews can identify data discrepancies and support corrections. Regulation 13 expressly provides for delegating necessary powers and duties to appropriate officials; external support does not displace the accounting officer’s implementation responsibilities. Exception governance helps management substantiate financial records; it does not guarantee their accuracy.

What good looks like

A well-governed municipality demonstrates mSCOA data maturity by combining automated system validations with rigorous substantive reconciliations. By enforcing sub-ledger control, applying regional allocation principles flexibly, maintaining an annotated reconciliation map, and upholding accounting officer oversight, municipal leadership has a stronger basis for reviewing financial reporting and resolving data weaknesses.

Sources

Frequently Asked Questions

Who falls within the scope of the mSCOA Regulations?

The 2014 Regulations apply to municipalities and municipal entities. This reconciliation map is therefore framed for local government rather than presented as a standard form for every public institution.

Does a successful data string upload to the GoMuni portal guarantee accurate accounting data?

No. Technical validation concerns structural and balancing checks; Circular 134 also discusses additional rules planned for version 7.2 . Portal acceptance does not guarantee that underlying transactions are substantively correct or properly supported by primary source evidence .

What is the role of the municipal accounting officer in mSCOA data governance?

Under Regulation 13 of the mSCOA Regulations, the accounting officer bears statutory responsibility for delegating duties, ensuring staff capacity, and maintaining compliant financial systems . External advisory support provides analytical methodology but cannot assume statutory management accountability .

How should head office and administrative expenses be allocated in the Regional segment?

Under mSCOA Version 7.1 regional guidance, administrative or head office expenses that support general municipal operations are allocated to the Administrative or Head Office indicator rather than split arbitrarily across wards . Expenses benefiting specific communities are allocated to the relevant ward or region .

What are the main mSCOA data errors identified in National Treasury MFMA Circular No. 134?

MFMA Circular No. 134 (March 2026) highlights common data string errors, including incorrectly unbundled salary clearing accounts, incorrect funding segment usage, incomplete cash flow tables (A7/SA30), incorrect opening balance rollovers, and regional segment imbalances .

For the wider context, read mSCOA as a municipal finance and data governance challenge.

Discuss your organisation’s priorities

Contact Kettle Consulting