Testing a municipal recovery plan is an advisory analytical workflow that evaluates liquidity, revenue, and cost scenarios against operational cash flow limits.
Within South African local government, municipal financial sustainability requires balancing cash-backed budgets with realistic revenue collection under the Local Government: Municipal Finance Management Act 56 of 2003 (MFMA). Municipalities governed by the MFMA manage local own-revenue sources, property rates, and trading services under municipal council oversight, distinct from national and provincial entities under the Public Finance Management Act 1 of 1999 (PFMA).
To address financial distress, National Treasury’s revised strategy to address municipal performance failures (2025) outlines strategic financial recovery plans (FRPs) under Chapter 13 of the MFMA. Advisory scenario modelling serves as a decision-support tool that supplements, rather than replaces, these statutory recovery arrangements.
Statutory recovery frameworks and the role of scenario modelling
a fundamental and routine financial management function
— National Treasury, MFMA Circular 64 (20 November 2012), p. 2
Under Chapter 13 of the MFMA, when a municipality encounters serious financial problems, statutory interventions may establish a financial recovery plan. National Treasury’s strategy to address municipal performance failures—a strategic document rather than statutory legislation—outlines a phased recovery approach emphasising strategic indicators to navigate between short-term stabilisation and long-term sustainability.
Mandatory recovery plans contain binding requirements within the applicable statutory arrangements, advisory scenario modelling provides internal decision support for municipal leadership. Implementation recommendations represent editorial methodology rather than additional statutory requirements.
By testing assumptions prior to council decisions, municipal managers and chief financial officers evaluate operational trade-offs. National Treasury Circular 64 (20 November 2012) notes that revenue management is "a fundamental and routine financial management function" . Scenario testing allows finance teams to model how variances in routine billing and collection impact daily cash balances.
Core components of an annotated scenario workbook
To evaluate a recovery plan, an institution should maintain an annotated scenario workbook that models cash inflows and outflows across rolling timeframes. The workbook relies on accurate baseline data to prevent false liquidity projections. In accordance with MFMA budgeting principles, annual budgets must be funded from realistically anticipated revenues and cash-backed accumulated surpluses.
An effective scenario workbook incorporates eight essential structural fields that ensure transparency and data integrity:
- Reconciled opening cash: Verified bank balance figures from primary bank reconciliations, with restricted and unrestricted balances shown separately.
- Receipts timing: Empirical projections of payment schedules across rates and trading services rather than assumed full collection.
- Expenditure commitments: Contractual obligations, bulk resource purchases, payroll and debt-servicing schedules, distinguishing lawful timing options from overdue obligations.
- Data provenance: Documented audit trails identifying primary source systems, extract dates, and operational owners for financial inputs.
- Separate baseline, downside, and recovery assumptions: Distinct operational cases modelling expected conditions, adverse shocks, and interventions.
- Sensitivity versus prediction: Stress-testing specific variables—such as collection rate shifts—to measure cash impacts.
- Decision triggers: Defined liquidity thresholds that prompt authorised management review and a documented response.
- Version control: Formal logging of model adjustments, author identities, approval dates, and parameter changes.
Structure of the scenario workbook fields table
The table below details recommended structural fields for an advisory scenario workbook, outlining technical descriptions, primary data sources, and operational validation rules.
| Workbook field | Technical description | Primary data source | Operational validation rule |
|---|---|---|---|
| Reconciled opening cash | Reconciled total and available balances | Primary bank reconciliation statement | Separate restricted funds from cash available for general operations |
| Receipts timing | Projected cash collection schedule | Historical billing and receipting logs | Apply realistic collection velocity factors |
| Expenditure commitments | Mandatory cash outflows | Contracts register and bulk billing files | Include accrued liabilities and fixed debt services |
| Data provenance | Source data audit trail | General ledger and sub-ledger extracts | Verify extract dates and system file integrity |
| Scenario assumptions | Baseline, downside, and recovery cases | Historical variance reports and trend studies | Maintain separate parameter sets for each case |
| Sensitivity analysis | Stress-testing key variables | Cash flow sensitivity model | Test isolated collection and cost shocks |
| Decision triggers | Pre-defined liquidity thresholds | Executive cash monitoring framework | Link cash depletion levels to cost-containment |
| Version control | Audit log of model revisions | Model change management register | Record the reviewer required by the institution’s approved process |
Stress-testing revenue, expenditure and liquidity variables
Scenario testing requires municipal finance teams to model realistic variances across revenue streams, cost structures, and cash timing. Revenue projections must account for historical collection levels and local economic conditions rather than assuming full budget recovery.
Under MFMA Circular 64, property rates and trading services form the core of own-revenue, requiring regular reconciliations between billing systems, valuation rolls, and Deeds Registry records.
Expenditure modelling must evaluate fixed commitments, including bulk resource purchases for water and electricity, municipal debt obligations, and statutory cost-containment mandates. Under the Cost Containment Regulations promulgated under the MFMA, municipalities must enforce fiscal discipline regarding discretionary spending.
Aligning scenario insights with municipal governance
Scenario modelling insights should inform executive decision-making within existing municipal governance structures. Sections 62 and 71 of the MFMA address financial administration and monthly budget reporting respectively. Escalation should follow the applicable MFMA requirements, approved recovery plan and institutional delegations; a model trigger does not create a new reporting duty.
Integrating scenario analysis into monthly reporting strengthens executive oversight without promising guaranteed recovery or specific audit outcomes. National Treasury’s Local Government Database and Reporting System (LGDRS) provides system-based reporting acting as an early warning mechanism for municipal performance failures. Using scenario workbooks alongside Section 71 reporting allows municipal leadership to evaluate corrective interventions proactively, so that the funding implications of proposed adjustments are visible.
What good looks like
A well-governed municipality uses scenario workbooks to ground financial recovery efforts in empirical cash flow realities. By maintaining reconciled opening cash figures, mapping expenditure commitments, enforcing data provenance, testing sensitivity variables, and linking decision triggers to statutory reporting workflows, municipal leadership can identify liquidity exposure, support fiscal administration and improve accountability.
Sources
- MFMA 56 of 2003, Chapter 13 — Municipal Finance Management Act
- National Treasury: Strategy to Address Municipal Performance Failures (2025) — National Treasury
- National Treasury: MFMA Circular 64, Revenue Management (2012) — MFMA Circular 64
Frequently Asked Questions
How does advisory scenario modelling differ from a statutory financial recovery plan?
Chapter 13 provides different arrangements for discretionary and mandatory interventions. Mandatory recovery plans include spending limits and revenue targets; their legal effect should not be assumed for every advisory plan . Advisory scenario modelling is an internal decision-support methodology that allows municipal management to test financial assumptions and evaluate cash flow trade-offs prior to or alongside statutory recovery processes .
How should restricted cash be represented in scenario models?
Show the total bank reconciliation alongside a separate bridge to cash available for general operations. Identify funds subject to purpose restrictions and test any proposed use against the applicable grant conditions. Excluding restricted amounts from freely available cash does not remove them from the bank reconciliation.
What is the role of National Treasury Circular 64 in scenario planning?
National Treasury Circular 64 (issued 20 November 2012) provides guidance on municipal revenue management, defining routine billing and collection practices for property rates and trading services . It emphasises that municipalities must establish accurate baseline property and metering data before contemplating revenue expansion, providing operational principles needed to model realistic revenue scenarios .
How does National Treasury's updated performance failure strategy approach financial recovery?
National Treasury’s strategy to address municipal performance failures (2025) introduces a phased approach to financial recovery plans that focuses on strategic indicators . The strategy distinguishes between quick-win stabilisation measures and long-term sustainability solutions, with National Treasury’s Municipal Financial Recovery Services (MFRS) unit focusing on mandatory financial recovery plans .
Can scenario modelling guarantee a funded budget or clean audit outcome?
No, scenario modelling is an analytical management tool designed to test assumptions and support decision-making; it cannot guarantee specific financial or audit outcomes . Achieving a funded budget and positive audit outcomes depends on council adopting realistic budget assumptions, executing disciplined daily internal controls, enforcing consequence management, and adhering to statutory supply chain and financial management frameworks .
For the wider governance context, read financial sustainability warning signs for institutional boards.