South Africa Municipal Finance Data - Budgets, Audits, Grants avatar

South Africa Municipal Finance Data - Budgets, Audits, Grants

Pricing

Pay per usage

Go to Apify Store
South Africa Municipal Finance Data - Budgets, Audits, Grants

South Africa Municipal Finance Data - Budgets, Audits, Grants

Official National Treasury Municipal Money data for all 257 South African municipalities: budgets, spending, grants, debtors, irregular expenditure and audit opinions. By Musa AI Tools.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Musa AI Tools

Musa AI Tools

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

10 days ago

Last modified

Security

Limited permissions

Share

South Africa Municipal Finance Data – Budgets, Spending, Audit Opinions & Grants API

Get official financial data for all 257 South African municipalities in one click. This Actor extracts National Treasury Municipal Money data covering metros, district and local municipalities: income & expenditure, budgets vs actuals, balance sheets, cash flow, capital spending, grants, repairs & maintenance, debtors, creditors, irregular / fruitless & wasteful expenditure and Auditor-General audit opinions. You get clean, flat records as JSON, CSV, Excel or via API, ready for spreadsheets, BI dashboards, research and AI agents.

🔎 What does SA Municipal Finance Data do?

  • Pulls from the official National Treasury Municipal Money API (municipaldata.treasury.gov.za), with data from 2003/04 to the latest quarter
  • Covers 20 datasets, including Income & Expenditure, Financial Position, Cash Flow, Capital Acquisition, Grants, Aged Debtors/Creditors, UIFW expenditure, Audit Opinions and the municipality directory
  • Filters by municipality code (CPT, JHB, TSH, ETH, EKU, NMA, BUF, MAN…), province, financial year and amount type (audited actual, original budget, adjusted budget…)
  • Returns flat, consistent fields (municipalityCode, financialYear, itemLabel, amountType, amount…) plus every original field
  • Built to be reliable: automatic retries with exponential backoff, 45 s timeouts and graceful handling of API outages
  • Each record carries a source attribution line, as the data's terms of use require

👥 Who is it for?

  • Investors and credit analysts assessing municipal bonds, creditworthiness and service-delivery risk
  • Suppliers and contractors checking whether a municipality pays creditors on time before bidding
  • Journalists, civic-tech groups and NGOs tracking irregular expenditure and audit outcomes
  • Researchers, consultants and economists building time series across municipalities
  • Property developers and businesses comparing metros for capital investment and infrastructure spending

📦 Output data

FieldExample
datasetaudit_opinions
municipalityCode / municipalityNameCPT / Cape Town
financialYear2024 (year ending June 2024)
itemLabelSale of Goods and Rendering of Services
amountTypeAudited Actual
amount7808 (Rand)
period2024 (year)
opinion / reportUrlUnqualified - No findings / link to the AG audit report PDF
…all original fieldse.g. functionCategoryLabel, itemCode, grantLabel
sourceAttribution, retrievedAtSource: National Treasury, Municipal Money…

Sample item:

{
"dataset": "audit_opinions",
"municipalityCode": "CPT",
"municipalityName": "Cape Town",
"financialYear": 2024,
"opinion": "Unqualified - No findings",
"reportUrl": "https://lg.treasury.gov.za/supportingdocs/CPT/...Audit Report_2024....pdf",
"sourceAttribution": "Source: National Treasury, Municipal Money (municipaldata.treasury.gov.za), dataset \"audit_opinions\", retrieved 2026-10-20."
}

⚙️ Input

FieldDescription
datasetWhich dataset to extract (default: Audit Opinions)
municipalitiesDemarcation codes, e.g. CPT, JHB, WC011. Leave empty for all
provinceEC, FS, GT, KZN, LIM, MP, NC, NW, WC
financialYearse.g. 2024, 2023. Leave empty for all years
amountTypese.g. AUDA (audited actual), ORGB (original budget), ADJB (adjusted budget)
annualOnlyKeep only full-year figures (default on)
maxItemsMaximum number of records (default 1000)

🚀 How to use it

  1. Pick a dataset, add municipality codes and/or a province and a year, then press Start.
  2. Download as JSON, CSV or Excel, or call the Apify API from Python, Node.js, Make, Zapier or n8n.
  3. Schedule monthly or quarterly runs to keep a dashboard or Google Sheet up to date when Treasury publishes new figures.

Examples

  • Audit opinions for every Gauteng municipality in 2024: dataset=audit_opinions, province=GT, financialYears=["2024"]
  • Johannesburg's budget vs actual spending: dataset=incexp_v2, municipalities=["JHB"], amountTypes=["ORGB","AUDA"]
  • Irregular expenditure across all metros: dataset=uifwexp, municipalities=["CPT","JHB","TSH","ETH","EKU","NMA","BUF","MAN"]

💰 Cost

This Actor is lightweight: it calls the API directly, with no browser. Typical runs finish in seconds and cost fractions of a cent.

❓ FAQ

Is this data free to reuse? Yes. National Treasury's Municipal Money terms of use allow you to download, copy, publish and use the data commercially and non-commercially, provided you acknowledge National Treasury as the source and the publication date, don't use it to mislead, and don't imply Treasury endorses you. Every record includes a sourceAttribution field to make that easy. This Actor is not affiliated with or endorsed by National Treasury.

Is personal data included? No. The "Municipal Officials" dataset is deliberately not supported.

What do the amount types mean? AUDA = audited actual, ORGB = original budget, ADJB = adjusted budget, PAUD = pre-audit, ACT = in-year actual, IBY1/IBY2 = budget-year forecasts.

How fresh is the data? It is live from the API: Treasury updates it quarterly as municipalities submit their returns.

Need something else? Open an issue on the Actor's Issues tab.


Keywords: South Africa municipal data, Municipal Money API, National Treasury data, municipal budgets South Africa, municipal finance API, audit opinions Auditor-General, irregular expenditure, fruitless and wasteful expenditure, metro budgets, Cape Town Johannesburg Tshwane eThekwini finances, local government data South Africa, MFMA data.