The shape of the money

There is a conversation that happens in a lot of South African homes around the twenty-second of the month. Someone looks at a balance and asks where it all went. Nobody knows, because nobody could have known. The money did not leave in one moment. It left in eighty small pieces, from four accounts, on days when nobody was looking.

That is not a discipline problem. It is a visibility problem, and the two need different fixes. Discipline needs willpower. Visibility needs light.

A real slice of it leaves before anyone in the house is awake. The Reserve Bank’s Quarterly Bulletin published in June 2026 put the cost of servicing household debt at 8,4% of disposable income for the first quarter of 2026, with household debt at 62,2% of what households take home. Those are national averages, not a verdict on your house — but they describe what you feel on the twenty-second.

You cannot budget your way out of something you cannot see. The first job is not discipline. It is light.

So we build one thing: a plain spreadsheet that shows the shape of a month. An evening to build, twenty minutes a month to keep. By the third month it will have told you something you did not know.

Getting your transactions out of a South African bank

Better to hear this now than after an hour of hunting. For an ordinary personal account in South Africa, the reliable way to get transactions into a spreadsheet is to download them yourself, once a month. Nothing quietly updates a household sheet in the background. Manual export is the route, not the fallback, and it takes five minutes once you have done it twice.

Where the export lives

Log in on a computer rather than the phone app. Apps are built for looking; desktop internet banking is where the file formats live. Find your transaction history, set a date range covering the last full month, and look for Download, Export or Statement. What you want is CSV.

Banks redesign these screens often, so we will not tell you which menu yours uses today. Two things we can, because the banks publish them. FNB puts public file specifications online for the statement exports in its Online Banking Enterprise product, listing CSV, OFX, QIF and PDF. Nedbank runs a direct feed into the accounting tool Xero where you log in on Nedbank’s own site with your Nedbank ID, so your password is never typed into Xero. Both matter later.

If a PDF is all you can get

Store cards and older accounts often give you nothing else. Retyping is the safe option: lump the grocery and fuel lines together and most households have under forty rows a month worth typing. If you use a converter, remember that uploading a statement hands a stranger your name, account number, balance and everywhere you shop. Prefer one that runs on your own machine, and never one that also wants your banking login.

How many accounts, and how often

Start with two: the account the salary lands in, and the card the household spends from. Not all eleven. Two accounts kept current beat a perfect set that dies quietly in October. Pick a fixed date — the first Sunday works, because the debit order run has cleared by then.

The apps that ask for your bank password

Someone will tell you about an app that shows every account on one screen, automatically. They exist here and have for years, and how they work is the whole story. Vault22, formerly 22seven, is the best known local one. Its own help centre puts it plainly: “By entering the login details for your bank accounts, you enable Vault22 to collect the information from those accounts on your behalf.” The app logs in as you and reads what it finds.

Hold that next to SABRIC, the body South Africa’s banking industry funds to fight financial crime, whose public guidance says: “Never provide your online ID, password or PIN to anyone.” Its ATM advice makes the same point about your card PIN: never share it, “not even with a bank official”. You cannot follow both. That is not an accusation against any company — it is a gap in the plumbing, and the regulator has said so.

The Financial Sector Conduct Authority’s March 2024 position paper on open finance found “no tailored regulatory framework” for the institutions already sharing data here, meaning “risks deriving from data-sharing and data-use are not being specifically addressed”, and that customers “have limited control over how third parties share, use, or handle their credentials and data”. Work is under way — National Treasury’s 2026 Budget Review records a cost-benefit analysis completed in 2025 by the Intergovernmental Fintech Working Group, with the framework still in development. It is not here yet.

You can see its shape in business already: a Nedbank client connecting to Xero is sent to Nedbank’s own site and logs in there, so the password is never typed into Xero. That is what consent looks like. The day your bank offers it on a personal account, take it.

A word on POPIA, because this is family data

Your household’s transactions are personal information about several people, children included. POPIA does not police what you do with your own family’s data at home — section 6 excludes processing “in the course of a purely personal or household activity”. Once that data reaches a company, that company is bound by the Act, which is useful but is a remedy after the fact rather than a wall. Hence the boring route: a file you exported, on a device you control, shared with nobody. If a small business runs through the same account, keep its books separate — see getting paid faster.

Building the dashboard in an evening

The columns

Open one file with a dull, permanent name: Household money 2026. Make a tab called Transactions and one called Rules. That is the whole architecture, and it does not grow.

Import your first CSV into Transactions, delete every column except these, then add the two the bank did not give you: Account and Month.

Date        Description               Amount   Category
2026-07-01  BOND REPAYMENT          -12450.00  Home
2026-07-01  MEDICAL AID DEBIT        -4120.00  Health
2026-07-03  CHECKERS HYPER           -1876.40  Food
2026-07-04  PREPAID ELEC PURCHASE     -600.00  Power
2026-07-05  SALARY                   38500.00  Income

Four rules, each of which saves you an evening later:

1. One signed amount column. Out negative, in positive. If your bank splits debit and credit, build one column that subtracts the one from the other.
2. Delete the running balance. It stops meaning anything once a second account sits below the first.
3. Type the account name once and fill it down the block you pasted, so every account can live in one list.
4. Add a month column for the pivot to group by: =TEXT(A2,"yyyy-mm").

From then on, paste new rows at the bottom of the same list. Never a fresh tab per month — one long list is what makes the rest work.

Categorising without going mad

Month one leaves several hundred rows with no category. Do not work down them one at a time; you will stop at row ninety and never return. Sort by Description instead: every purchase from the same shop lands in one block, and forty rows get categorised in one gesture.

For the repeats, keep a Rules tab: text that appears in the description, and the category it belongs to.

Contains             ->  Category
CHECKERS                 Food
ENGEN                    Transport
PREPAID ELEC             Power
DISCOVERY HEALTH         Health

Wire it into a lookup formula if you like formulas. Reading it by eye while you block-fill works fine too. Either way, the list is what you hand your partner when it is their turn.

The one pivot table

Select the Transactions tab and insert a pivot table. Rows: Category. Columns: Month. Values: sum of Amount. Then stop. That grid is the dashboard — ten or so rows, one column per month, and the ability to see at a glance that school fees rose in January and never came back down.

The categories that tell you something

The fastest way to abandon a money sheet is to build forty categories. Around ten survives contact with a real household. Here is a set shaped for South African households.

Money sent to family is a real line. Supporting parents, a sibling, a cousin at university is among the largest monthly outflows in many South African households, and among the least often written down. Naming it is not a step towards cutting it. It is a step towards being able to plan for it.

Cash is one line and you leave it alone. The R600 drawn at an ATM becomes a row called Cash. And do not split what you cannot act on: toiletries separated from groceries gives you a number you can do nothing about. The test for every category is whether a decision could change the line.

Three numbers, and nothing else

The pivot will hand you forty figures. Three are worth carrying in your head.

1. What landed

Total money in, last month. Not your salary — what actually arrived, across every account, after tax and deductions, including side income and the money your mother sent for school shoes. Most people are mildly wrong here, usually quoting a payslip from two increases ago.

2. What left before anyone decided

Bond or rent, instalments, insurance and medical aid, school fees, subscriptions. Everything that leaves on a schedule without a human choosing. This is the committed number and the most useful figure in the dashboard, because it is money already spent by the time you wake up on the first.

3. What was left to decide about

Number one minus number two. The textbooks say discretionary income; call it the deciding money. If it is small, no amount of discipline about takeaway coffee will fix it — a small deciding number is a signal about the other two, and those are the levers.

Watch their direction across three months, not the level in one. One month is noise: a car service, a school outing, a wedding in Polokwane. Three months is a shape.

Debit orders, and the ones that renew in the dark

Sort Transactions by Description and look for anything appearing every month at the same or nearly the same amount. That list is your committed spending, and where the surprises live. Almost everyone who does this finds something they had forgotten they were paying for.

They hide for a structural reason, not because you were careless. They arrive in a block on the first and second, when the account is fullest and nobody is reading. Annual renewals come once a year, not often enough to form a pattern, and the amount creeps up at renewal by a margin too small to notice.

Which kind it is, and why that matters

The industry rules — administered by the Payments Association of South Africa until its functions moved to the Reserve Bank on 11 August 2026 and to PayInc on 2 September 2026 — recognise three kinds: DebiCheck, Registered Mandate and EFT debit orders. The difference is where the permission lives. A DebiCheck order is approved by you, with your bank, at the start of a contract, and your bank then checks each collection against what you approved. The older EFT type is approved with the company collecting, not with your bank. The Reserve Bank brought DebiCheck in from May 2021 to reduce what it described as abuse in the early debit order system.

Cancelling one properly

The consumer guidance PASA published runs in five steps: read your statement, confirm whether you authorised the company, query anything you do not recognise with your bank, contact the company to establish what the authorisation was, then dispute and report it if it was never authorised.

You have 60 days, not a year. Since 13 April 2026 the window to dispute a debit order with your bank is 60 calendar days from the day it came off, across all three kinds — EFT debit, DebiCheck and Registered Mandate. It used to be 365. Past 60 days the banks no longer process the dispute for you as a matter of course, and getting your money back becomes something you take up with the company yourself. This is exactly why the ritual in the next section is monthly: a first-Sunday look at last month’s statement finds the strange ones while they are still well inside the window, and a sheet you open twice a year does not.

One detail first. Your bank can suspend a DebiCheck debit order and it will stop coming off — but that does not cancel the contract behind it. The agreement stands and the company can still pursue it. Cancel with the company too, in writing, and keep the reference number.

Subject: Cancellation - account 4471902

Good morning,

Please cancel my subscription, account 4471902, with
effect from 30 September 2026, and cancel the debit
order attached to it.

Please confirm in writing and send me a reference
number.

Thank you,
Nomsa

Email it where you can, so a record exists, then diarise a check of next month’s statement. Sometimes it does not stop. And said kindly: disputing a debit order you agreed to is not a way out of a contract. If a payment has become unaffordable, phone the company and ask to restructure.

Twenty minutes a month, and the conversation

Household spreadsheets almost never die because of the spreadsheet. They die because nobody decided when it happens. Put it in the calendar, and keep it short enough that a tired person will still do it.

1. Five minutes. Download last month’s CSV from each account and paste the rows at the bottom of Transactions.
2. Five minutes. Sort by Category, clear the block of blanks at the top, add a rule or two.
3. Five minutes. Read the three numbers and type one sentence at the top of the sheet: “July — food up R1 400, school fees started again, deciding money down to R3 100.”
4. Five minutes. Choose one thing to change. One. Write it next to the sentence.

The one-decision rule matters most. A month in which you change one thing is a month you will repeat. A month in which you resolve to change nine things is the last month anybody opens the file.

Doing this with a partner

No software helps here, and the tone matters more than the tool. Do not open with the pivot table. Share the sheet a day beforehand, so nobody sees their own spending for the first time in front of another adult — that is the moment defensiveness gets built, and it is hard to take back. Fifteen minutes is enough, with one question each: what surprised you? and what do we change first?

Three rules hold up. Nobody defends a category. Numbers get read out, not interpreted. And the questions point at next month rather than last. One of you will have spent more, usually whoever does the grocery run — numbers without context are unkind, and a household is not an audit. If those fifteen minutes turn heated every month, take that seriously on its own terms. Money arguments are seldom about money, and a counsellor is a legitimate call.

When the numbers are worse than you thought

They usually are, the first time. That is not what a bad month looks like — it is what a first honest month looks like. You have not become worse at money. You have added it up, possibly for the first time, and the total was always there.

Sit with month one rather than acting on it, and wait for three before rearranging anything. One exception, said plainly: if what leaves on a schedule is larger than what lands, a dashboard does not fix that and waiting makes it worse. Phone the institutions you owe before you miss a payment, because most have a restructuring process and most respond better to an early call. A debt counsellor registered with the National Credit Regulator can negotiate on your behalf under the National Credit Act, and the National Financial Ombud Scheme is free to you if a bank or insurer is treating you unfairly.