Budgeting tools
Household budget worksheet
By Lerato Molefe · 5 min read · Updated 24 June 2026
A household budget worksheet is a complete monthly record of your money: every source of income and every category of spending, from the bond down to airtime and subscriptions, and filling it in honestly shows where your money actually goes, where it leaks, and how much room you really have to save or pay down debt. This worksheet gives you the full set of categories to copy and complete.
The difference between this and a quick budget is detail. A household worksheet captures the smaller, easy-to-forget items - bank charges, subscriptions, occasional costs - that quietly add up and explain why the money never seems to last the month.
Use your bank and card statements to fill it in, not your memory. Once it is complete, you will be able to spot the categories worth cutting and see clearly whether you can manage your debts yourself or need to look at debt review.
The copy-paste worksheet
Copy this into a spreadsheet or print it. Enter monthly amounts; for things you pay yearly, divide by twelve.
HOUSEHOLD BUDGET WORKSHEET
INCOME
Net salary 1 R[________]
Net salary 2 R[________]
Side income / freelance R[________]
Grants / maintenance R[________]
Other R[________]
TOTAL INCOME R[________]
HOME
Rent / bond R[________]
Rates / levies R[________]
Water and electricity R[________]
Home insurance R[________]
Maintenance / repairs R[________]
FOOD AND HOUSEHOLD
Groceries R[________]
Toiletries / cleaning R[________]
Takeaways / eating out R[________]
TRANSPORT
Fuel / taxi / bus R[________]
Car instalment R[________]
Car insurance R[________]
Licence / maintenance R[________]
PEOPLE
School / creche fees R[________]
Childcare R[________]
Medical aid R[________]
Medicine / doctor R[________]
COMMUNICATION AND SUBSCRIPTIONS
Phone / data R[________]
Internet / wifi R[________]
Streaming / subscriptions R[________]
MONEY AND DEBT
Bank charges R[________]
Loan repayments R[________]
Credit card / store accounts R[________]
Funeral / life policies R[________]
SAVINGS AND OTHER
Savings / emergency fund R[________]
Clothing R[________]
Entertainment R[________]
Other R[________]
TOTALS
TOTAL INCOME R[________]
TOTAL EXPENSES R[________]
DIFFERENCE (income - expenses) R[________]
Fill it in from your statements
The single best way to complete this worksheet accurately is to sit with your bank and credit card statements for the past two or three months and assign every transaction to a category. People almost always underestimate groceries, takeaways, transport and small impulse buys, so memory-based budgets tend to look healthier than reality.
For irregular costs - school stationery, car services, annual insurance - take the yearly amount and divide by twelve so they appear as a smooth monthly figure. That stops a big once-a-year bill from blowing a hole in a single month and gives you a truer picture of your average spending.
Find the leaks
Once the worksheet is filled in, look for the categories that are bigger than you expected. The usual culprits are takeaways and eating out, multiple streaming and app subscriptions, bank charges, data top-ups, and impulse clothing. These rarely feel significant on the day, but added across a month they often free up real money.
Work through them and decide what to cut, pause or downgrade. Cancelling two unused subscriptions, switching to a cheaper bank account, and trimming takeaways can quietly recover several hundred rand a month. That recovered money is exactly what you redirect into savings or, if you are tackling debt, into your repayment plan.
Using the worksheet for debt and decisions
If your difference at the bottom is positive, you have surplus to direct toward an emergency fund and your debts. If it is negative, your household is spending more than it earns, and the gap is being bridged by credit or arrears - a sign you need to act rather than wait.
A negative difference, even after cutting the leaks, points toward formal help. A debt counsellor uses essentially this kind of affordability picture to assess you for debt review, which can fold unaffordable debts into one reduced monthly payment. Whether you are managing on your own or considering debt review, an honest household worksheet is the foundation for every other decision you make about your money.
Frequently asked questions
What is a household budget worksheet?
It is a detailed monthly record of all your household income and spending, broken into categories from rent and groceries to subscriptions and bank charges. Completing it shows where your money goes and how much room you have to save or repay debt.
How is it different from a basic budget?
A household worksheet captures more detail, including the small, easy-to-forget items like subscriptions, bank charges and occasional costs. That detail explains why money runs short and reveals leaks a quick budget misses.
How do I fill in irregular expenses?
Take the annual cost of irregular items like car services or yearly insurance and divide by twelve, so they appear as a steady monthly amount. This avoids a big once-a-year bill distorting a single month's budget.
How often should I update my budget worksheet?
Review it monthly at first so you build the habit and catch changes, then at least every few months and whenever your income or major expenses change. Keeping it current is what makes it useful.
What if my expenses are higher than my income?
A negative difference means you are spending more than you earn and bridging the gap with credit or arrears. Cut the leaks first, and if it still does not balance, speak to a debt counsellor about debt review.
Where can I find money to save?
Look at takeaways and eating out, multiple subscriptions, bank charges, data top-ups and impulse clothing. Trimming or cancelling a few of these often recovers several hundred rand a month to redirect to savings or debt.
Do I need software to use this worksheet?
No. You can complete it on paper, in a notebook, or in any free spreadsheet. The value is in filling it in honestly from your statements, not in any particular app.
