Business Maverick


Local government graft: Blame it on the Excel spreadsheets

Local government graft: Blame it on the Excel spreadsheets
(Photo: Adobe Stock)

What happens when you mix ANC cadre deployment with Excel spreadsheets? Looks like corruption and wasteful spending.

Local government in South Africa has become a joke and one that would be funny if the consequences were not so dire. The phrase “service delivery protest” is a South Africanism that speaks to this problem and its scale. Even if you are young, unemployed and bored, some motivation is needed to throw a brick or burn tyres on the road. Whether it is raw sewage befouling the Vaal or potholes that could swallow a buffalo, or monstrous arrears to Eskom, the stench will lead to the local government offices, some of which are quite plush.

In a statement on Wednesday, the National Treasury traced the scent to Excel spreadsheets.

“A large number of municipalities are not budgeting, transacting and reporting directly in or from their core financial systems. Instead, they prepare their budgets and reports on Excel spreadsheet and then import the Excel spreadsheets into the system,” it said.

“Often this manipulation of data leads to unauthorised, irregular, fruitful and wasteful (UIFW) expenditure and fraud and corruption as the controls that are built into the core financial systems are not triggered and transactions go through that should not.”

Spreadsheets are the elixir of the accounting world, and one would have thought they would boost transparency. Then again, auditors also have had a rough go of it of late. Many spreadsheets must have been used to cook the Steinhoff books.

Another problem is that municipalities are not “locking in” their budgets at the end of the month as required. Officials are adept at spreadsheets it seems, but not time management. 

“Municipalities are not locking their adopted budgets or their financial systems at month-end to ensure prudent financial management. To enforce municipalities to lock their budgets and close their financial system at month-end in 2020/21, the Local Government Portal will be locked at the end of each quarter. System vendors were also requested to build this functionality into their municipal financial systems,” the National Treasury said.

It remains to be seen if this will help address the issue. But getting municipalities to follow the basic rules of governance seems as good a place to start as any. The National Treasury itself has quite a solid reputation on the governance front. A top-down approach seems to be the order of the day. DM/BM


Comments - Please in order to comment.

  • Coen Gous says:

    Apart from some well-run municipalities in the Western Cape, all non-ANC run, the ANC is slowly but surely running municipalities to the ground, which of course has a devastating impact on service delivery. And still the masses support them. Toy, toying has simply no impact anymore.

  • Demetri Qually says:

    Why was corrective action not taken years ago to resolve this problem?

  • Bruce Kokkinn says:

    A token gesture – like urinating into the wind!

Please peer review 3 community comments before your comment can be posted


This article is free to read.

Sign up for free or sign in to continue reading.

Unlike our competitors, we don’t force you to pay to read the news but we do need your email address to make your experience better.

Nearly there! Create a password to finish signing up with us:

Please enter your password or get a sign in link if you’ve forgotten

Open Sesame! Thanks for signing up.

We would like our readers to start paying for Daily Maverick...

…but we are not going to force you to. Over 10 million users come to us each month for the news. We have not put it behind a paywall because the truth should not be a luxury.

Instead we ask our readers who can afford to contribute, even a small amount each month, to do so.

If you appreciate it and want to see us keep going then please consider contributing whatever you can.

Support Daily Maverick→
Payment options

Daily Maverick Elections Toolbox

Feeling powerless in politics?

Equip yourself with the tools you need for an informed decision this election. Get the Elections Toolbox with shareable party manifesto guide.