Monthly Budget Template Excel South Africa: Setup Guide

To make a monthly budget template in Excel for South Africa, create columns for income, planned expenses and actual expenses, format money as rand, and use SUM formulas to compare your plan with what you spend. A simple workbook can track take-home income, debit orders, household bills, day-to-day costs and the amount left at month-end.

What a South African monthly budget should include

A useful budget is a plan for cash coming in and going out over a particular month. Start with income you expect to receive, then list costs by category and compare the budgeted amounts with transactions as they happen. Use take-home pay—the amount that reaches your account—rather than gross salary, so deductions already taken from pay are not counted as money available to spend.

South African household expenses vary, so treat these as prompts rather than a universal checklist. Include the categories that apply to your household:

Income: salary after deductions, freelance or commission income, pension income, or other regular contributions to shared household costs.
Housing and utilities: rent or bond instalment, rates or levies where applicable, electricity, water, refuse and home internet.
Transport: public transport, fuel, vehicle instalments, insurance, parking and maintenance.
Food and household: groceries, cleaning supplies, meals away from home and personal-care items.
Financial commitments: insurance, medical aid, debt repayments, savings transfers and any regular family support or stokvel contributions.
Irregular costs: school expenses, annual renewals, vehicle licences, gifts, repairs and medical costs not covered by a regular payment.

Not every item is a monthly bill. For an annual cost, estimate the amount and set aside one-twelfth each month. For example, if an annual renewal is R1,200, budgeting R100 per month makes the future payment easier to plan for. This is a budgeting illustration, not a prediction of any particular fee.

A practical worksheet layout

Create a worksheet named Monthly Budget. Use this layout so that income and expenses are separate and their totals can be compared. Enter category names in column A, the planned amounts in column B, and what actually arrived or was spent in column C.

Rows	Column A	Column B	Column C	Column D
1	Income source	Planned	Actual
2–6	Income categories	Expected income	Income received
7	Total income	Sum	Sum
10	Expense category	Planned	Actual	Left / (over)
11–25	Expense categories	Budget amount	Amount spent	Difference
26	Total expenses	Sum	Sum	Difference
28	Income after expenses	Planned balance	Actual balance

Use the unused rows for headings or notes. For instance, rows 2–6 could be salary, side work and other household income; rows 11–25 might include housing, utilities, transport, groceries, insurance, debt payments, savings and irregular costs. Add or remove categories to fit your situation, but keep the total formulas aligned with the rows you use. A single row for a category is often easier to maintain than a long list of individual purchases.

Set up the workbook and rand amounts

Open Excel for Microsoft 365 on Windows and choose Blank workbook. Rename the first sheet Monthly Budget by double-clicking its sheet tab and typing the name.
Type the headings and categories into the cells shown above. Leave the total rows available for formulas rather than entering totals by hand.
Enter money as numbers, not as text with a typed R in front. For example, enter 9500 and format the cell to display as rand. This keeps the values usable in calculations.
Select the amount cells, then use Home > Number to choose a suitable currency or accounting format. If the symbol list offers South African rand, select it; otherwise use a number format with two decimal places and label the headings clearly as R. The exact symbols available can depend on regional settings.
Make the headings bold and widen columns so category names are readable. You can use Home > Conditional Formatting > Highlight Cells Rules > Less Than to flag negative expense balances in column D, using 0 as the threshold.

Excel for the web has similar number-formatting and conditional-formatting controls, though the ribbon may be arranged differently. In Excel for Mac, the same basic worksheet layout and formulas work; the ribbon and keyboard shortcuts can differ. If your workbook uses a comma as the decimal separator because of regional settings, Excel may display amounts differently, but the formulas below use standard Excel argument separators.

Formulas for totals and balances

With planned income in B2:B6 and actual income in C2:C6, enter =SUM(B2:B6) in B7 to total the planned income. If those planned income cells contain R28,000 in total, the formula returns 28000, which you can format to display as R28,000.00. In C7, use the same pattern for actual income: =SUM(C2:C6).

With planned expenses in B11:B25 and actual expenses in C11:C25, put =SUM(B11:B25) in B26. It returns R27,000 when the planned expense amounts in that range add to R27,000. In C26, enter =SUM(C11:C25) to total actual spending; for an illustrative actual total of R26,100, the result is 26100.

With a planned expense in B11 and its actual amount in C11, put =B11-C11 in D11 and copy it down through D25. If row 11 is rent budgeted at R9,000 and the actual payment is R9,200, the result is -200: the category is R200 over budget. A positive result means some of that category’s plan remains. With totals in row 26, put =B26-C26 in D26 to show the overall planned-versus-actual expense difference.

With total planned income in B7 and total planned expenses in B26, enter =B7-B26 in B28 to show the planned balance. With actual income in C7 and actual expenses in C26, enter =C7-C26 in C28. For example, actual income of R27,500 and actual expenses of R26,100 produce R1,400 remaining. This figure is a simple cash-flow comparison; it does not automatically account for account balances, timing differences or transactions omitted from the sheet.

In Microsoft 365 for Windows, press Enter after typing a formula. To fill D11 down, select D11, copy it, select D12:D25 and paste; Excel adjusts the row references. On Mac, the same formulas work, but the copy and paste shortcuts may differ from Windows. You can also use the Home ribbon’s Copy and Paste controls. Avoid typing a total into a formula cell, because doing so replaces the calculation.

Make the monthly plan realistic

Use statements, payslips and receipts to estimate recurring amounts instead of relying on memory. Bills can change, and some costs vary by season or use. If electricity, groceries or transport fluctuate, review several recent months and choose a planned figure that reflects your usual pattern. Where a bill is shared, decide whether the worksheet records the full household amount or only your share, and apply that choice consistently.

For variable income, budget from a cautious estimate rather than assuming every month will match the best month. Keep essential commitments distinct from optional or flexible spending, and update the actual column when income is received or a payment is made. If income arrives on different dates, a monthly total alone may hide a timing problem; add a separate notes column or a second cash-flow sheet that records due dates and expected pay dates.

Separate savings from leftover money if you have a specific savings target. You can add a planned savings contribution among the expense categories so the plan assigns it a place before optional spending. The spreadsheet cannot determine what level of saving or debt repayment is right for you; it simply records the amounts you choose. For decisions about financial products, tax or debt terms, check the relevant documents or speak to a qualified professional.

Review the budget and handle common problems

At month-end, compare the actual column with the plan and ask what caused the largest differences. A one-off repair is different from a recurring overspend on food or transport. Adjust next month’s estimates when the pattern has genuinely changed, rather than changing past figures to make the sheet look balanced. Keeping a short note beside unusual transactions can make the next review more useful.

A total is too small: check that the SUM range includes every category row and that amounts were entered as numbers rather than text.
A formula shows an error or does not calculate: confirm that the cell begins with an equals sign and that the referenced cells are correct. Check that calculation is not being blocked by text or an accidental apostrophe before the formula.
The balance is negative: verify that actual income and expenses are entered in the intended columns. A negative actual balance means recorded expenses exceed recorded income for the month; it does not by itself explain why.
A debit order appears twice: check whether you recorded both the scheduled payment and the bank transaction. Record the expense once, using a consistent method.
The rand symbol or decimals look wrong: review the cell’s number format and the workbook’s regional settings. A display issue does not necessarily mean the underlying amount changed.

Keep a clean copy of the workbook before making major structural changes, and save a new copy for each month or duplicate the worksheet and update its name. If you duplicate sheets, check that formulas still point to the intended month. A summary sheet can later compare monthly totals, but make sure it does not count the same transactions twice.

Choosing between Excel and other budgeting methods

Excel is useful when you want to control categories, formulas and layout, and when you are comfortable entering figures yourself. It can work offline in the desktop application and does not require connecting a bank account. The trade-off is manual upkeep: missed transactions make the comparison less reliable, and a workbook is only as current as its entries.

A paper budget or a notes app may be simpler for a small number of transactions, while a dedicated budgeting service may offer features such as transaction imports. Features, fees, data handling and bank support vary by provider, so check current terms and privacy information before sharing financial details. A spreadsheet avoids automatic bank access, but it still contains sensitive information: use a device you control, protect access to the file, and avoid sending an unprotected copy casually.

Frequently Asked Questions

Can I use this monthly budget template in Excel for free?
Excel itself may require a Microsoft 365 subscription or another licence, depending on how you access it. The layout and formulas described here do not require paid add-ins. Excel for the web may be available through a Microsoft account, subject to Microsoft’s current access terms.

How do I make Excel show South African rand?
Select the amount cells and choose a currency-style number format from Home > Number. Pick the South African rand symbol if it appears in the available symbols. If it does not, use a clear R label in the column heading and a numeric format so the cells remain calculable.

Should I enter my salary before or after deductions?
For a household spending plan, enter the take-home amount deposited into your account. If you want to analyse gross pay and deductions as well, track them separately and do not subtract the same deductions twice.

How do I budget for a bill that is paid once a year?
Estimate the annual amount, divide it by 12 and include that monthly set-aside in the plan. When the bill is paid, record the actual payment in the month it leaves your account, or use a separate sinking-fund tracker to avoid confusing monthly saving with the eventual payment.

Can I use the same template for a couple or family?
Yes. Agree whether income and shared expenses are recorded as household totals or as each person’s contribution. You can add columns for the payer or household member, but keep shared costs consistent so a payment is not counted once as a household expense and again as an individual expense.

Keep the template simple enough to maintain

A budget is most useful when it is easy to update. Begin with the categories that matter, enter planned amounts before the month starts, and record actual activity regularly. Review the totals at month-end, revise estimates where evidence supports a change, and preserve the earlier month for comparison. The spreadsheet provides structure and arithmetic; your records and review determine whether it reflects your real household cash flow.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.