Municipal Money is a web-based tool designed to inform citizens on their local authority’s financial performance and allows comparisons between municipalities.
The website is designed to present key municipal financial information to a general audience, who do not necessarily have any financial background or knowledge.
Municipal Money contains user–friendly, reliable and comparable financial information for every single municipality in South Africa.
The Municipal Money API contains the raw data used in the Municipal Money website application, and much more. All municipalities are required to regularly submit their financial information to National Treasury, who in partnership with Code for South Africa is making it available to the public through the API, in a machine-friendly format.
Municipal Money is brought to you by the National Treasury, which has collected extensive municipal financial data over several years and would like to share this information with the public in order to increase transparency, strengthen civic oversight and promote accountability.
A financial year is an organisation’s accounting period of 12 consecutive months, at the end of which the accounting books or records for that period are closed. The financial year is used as a basis for planning, budgeting, measuring financial performance and financial reporting.
The financial year for South African municipalities runs from 1 July of each year to 30 June of the following year. Budgets need to be prepared and approved for each financial year. At the close of the financial year, reporting against the approved or adjusted (if any) budget is required in the form of Annual Financial Statements and an Annual report.
A "quarter" is a 3-month period in a financial year and is often expressed as q1, q2, q3 or q4. A quarter is usually accompanied by the year it relates to. For example, "2016 q1" refers to the first quarter of the 2016 financial year (2015-2016). Since the municipal financial year begins in July of one year and ends in June of the following year, the period being referred to here is July-Sep 2015.
While most of the financial data provided to National Treasury by the municipalities is submitted annually, some data is refreshed and submitted on a quarterly basis. Quarterly updates are important for planning and monitoring purposes and acts as an early warning system. For example, quarterly figures could show that the municipality was not collecting nearly enough of the money owed to it in order to cover its debts. Rather than waiting for annual financial figures to reveal this, the quarterly information allows the municipality to identify a problem and take corrective action sooner.
You may use the data freely and flexibly for both commercial and non-commercial purposes.
You may download, copy, publish, distribute and transmit the data. You may also adapt and extract the data.
The data is provided at regular intervals by all the individual municipalities in South Africa to National Treasury and housed on their Local Government Database and Reporting System (LGDRS).
The data on the API is available in an open format, is machine-readable, available in bulk and unprocessed. You may download the data in either Excel or CSV format.
When something is listed as ‘Not Available’, one or more of the things needed to show the indicator for that date was missing from National Treasury's local government database. This usually happens when the relevant municipality has not submitted the data to the National Treasury in an acceptable form in time. It might have been submitted late and will be available in the next quarter. It might also be available directly from the municipality but without the vetting done by National Treasury before inclusion in their local government database.
There are three categories of municipalities in South Africa:
Within these categories, there may be significantly different circumstances between municipalities across the country. Hence, a further set of subcategories have been developed for analytical and statistical purposes. These subcategories have been widely-used in assessments and previous policy initiatives by the Department of Cooperative Governance (DCOG), National Treasury, the Municipal Demarcation Board and others.
For examples of how the subcategories are used, please see:
When referring to similar municipalities, we are then referring to municipalities in the same subcategory as per the table below.
When we calculate an indicator comparison for similar municipalities, we use the median value of the municipalities in the same subcategory.
|A||Metropolitan municipalities (metros)|
|B1||Secondary cities, local municipalities with the largest budgets|
|B2||Local municipalities with a large town as core|
|B3||Local municipalities with small towns, with relatively small population and significant proportion of urban population but with no large town as core|
|B4||Local municipalities which are mainly rural with communal tenure and with, at most, one or two small towns in their area|
|C1||District municipalities which are not water services authorities|
|C2||District municipalities which are water services authorities|
The prescribed Municipal Budget and Reporting Regulations promulgated on 17 April 2009, includes supporting table SA14 which requires that each municipality supply data on household bills based on some generalised statistical parameters. The statistical standards wherein the municipalities must present the application of their tariffs are shown in the following table:
|Standard household name||Assumed property value (Rands)||Assumed water consumption (kl per month)||Assumed electricity consumption (kWh per month)|
|Middle income||700 000||30||1000|
The bills considered are property rates, basic electricity levy, electricity consumption charge, basic water levy, water consumption charge, sanitation, refuse removal and ‘other’.
In these circumstances, specifying ‘standard’ households is a pragmatic approach. It is fine when comparing the bill in a municipality over time. Be careful when comparing these bills between municipalities. The property values, water consumption and electricity consumption of a household in an income category may differ from municipality to municipality. The representative bills shown are useful for tracking the size the household bill in a municipality over time but less useful for comparing the bills between municipalities. The increase is a function of the composition of the bill and the increases in the different elements of the bill.
Users should be aware that the data is submitted to National Treasury directly from the individual municipalities and while National Treasury endeavours to ensure that the datasets are complete and validated regularly, ultimately the quality of the data is primarily assured by the Chief Accounting Officer of the municipality.
National Treasury has developed standard indicators and norms based on the Section 71 submissions of municipalities, and these indicators and norms have been used as a basis to compare the financial performance of different municipalities on the Municipal Money website. However, there are occasions when municipal financial performance cannot clearly be classified within these accepted norms and where deviations from the norms are not necessarily a negative reflection on the municipality’s financial performance.
For example, some metropolitan municipalities, with their large populations and substantive budgets, may opt to adopt different strategies of service delivery as compared with their counterparts. This in turn, may involve more outsourcing, less capital expenditure and lower staff costs - all of which, may then fall outside of the generally accepted norms and standards identified by National Treasury.
While we acknowledge these limitations, National Treasury believes that these comparisons are still useful and appropriate as they allow users to identify and explore the differences between municipalities – bringing them closer to understanding the sometimes subtle nuances between municipalities and between categories of municipalities.
To assist users in querying the results of a municipality’s financial indicators, Municipal Money provides a direct email link to the municipal management, where the Municipal Manager and Mayor may respond directly and provide clarification to users.
This level of interest and understanding will no doubt contribute to enhanced civic oversight, greater transparency and increased accountability.
No. The data will not identify or provide ways to identify individuals, unless that information is already published (for example, the names of municipal managers and mayors).
You may use the data for commercial purposes, however you may not claim or imply that NT endorses your product, services, analysis or interpretation of the data. NT will not make claims to any intellectual property arising from applications or analysis of the data.
A mashup is a web page or application created by combining data or functionality from different sources to create a single new service. This new service or functionality usually falls outside of envisaged use of the original applications. Mashups also typically utilize visualisations – pictures that show the data in clear, imaginative ways and tell a story about the underlying information.
For example, a mashup combining data sources such as electoral lists and a mapping tool could show where votes are being cast and for which political parties. This would be of interest to voters and political representatives.
We hope that the data from the Municipal Money API will be used in mashups with other data sources to create innovative, new, interesting and valuable applications for municipal financial data.
You may suggest additional data sets to be uploaded provided it is in the legislative framework in which the National Treasury operates. To do so, please send a request to email@example.com.
We realise that you may want to ask us and each other questions and we’ll try and help as best we can. We will be using our Facebook account as a point for discussion.
Should you come across any inconsistencies in the data or any problematic data that may need to be corrected, please do contact us at firstname.lastname@example.org.
Should you come across any inconsistencies in the data or any problematic data on this website that may need to be corrected, please do let us know by contacting us at email@example.com.
If you would like to provide feedback on your experience of using this website and the data contained therein, or if you would like to share with us how you have used the data - please contact us at: firstname.lastname@example.org.
We will endeavour to respond to all queries and comments as soon as possible.