A New Zealand budget template in Excel can be a simple table of monthly income, planned spending and actual spending, with formulas to show what remains. In Microsoft Excel for Microsoft 365 on Windows, create columns for those figures, enter categories that fit your household, and use =SUM(B5:B8) to total a block of planned income; the example assumes income is listed in B5:B8 and returns their sum.
What a New Zealand Excel budget should include
A useful budget is a forward-looking plan, not just a record of past transactions. It gives you a place to estimate money coming in, assign money to regular and occasional costs, and compare the plan with what actually happened. A workbook can be as small as one worksheet or have separate sheets for the monthly plan, transactions and annual bills.
Use New Zealand dollars and categories that match how you receive and spend money. For household income, that may mean wages after deductions, self-employment income, or other regular payments. For expenses, locally familiar examples include rent or a mortgage, power, internet, rates, public transport, petrol, vehicle registration (rego), a Warrant of Fitness (WoF), and groceries. These are categories, not a claim that every household has the same costs.
For a first version, set up four columns:
- Category: the income or expense name.
- Planned: the amount you expect for the period.
- Actual: the amount received or spent.
- Difference: the gap between plan and actual.
Put income in one section and expenses in another. Keep the period consistent: if the sheet is a monthly budget, enter monthly amounts throughout. Mixing weekly rent, monthly pay and annual insurance in one total without converting them makes the result misleading.
Set up the workbook and categories
In Excel for Microsoft 365 on Windows, open a blank workbook and enter the headings in row 4: Category in A4, Planned in B4, Actual in C4 and Difference in D4. Use rows 5–8 for income categories, row 9 for total income, rows 12–20 for expenses, row 21 for total expenses, and row 23 for the amount left after actual expenses. Leave the intervening rows blank or use them for headings. This layout makes the formulas below easy to follow; a different layout needs different cell references.
Categories should be detailed enough to help you make decisions but not so numerous that keeping the file current becomes a chore. For instance, split housing, utilities and transport if you want to see which is changing, but avoid creating separate categories for every small grocery purchase unless that detail is useful to you. A sample list could include:
- Income: main pay, second income, and other regular income.
- Home: rent or mortgage, rates, power, water where billed separately, and internet.
- Everyday spending: groceries, transport, health and personal spending.
- Irregular costs: insurance, car maintenance, gifts, subscriptions paid annually, and school or activity costs.
- Goals and buffers: savings goals or a planned reserve for less predictable bills.
Households differ, so treat these as prompts rather than a prescribed budget. If income changes from week to week, you can plan around a conservative estimate and record actual income as it arrives. Avoid treating credit limits or borrowed money as income: doing so can make a plan appear healthier than the cash available to meet bills.
Use formulas to total and compare amounts
With planned income in B5:B8, enter =SUM(B5:B8) in B9. This adds the planned income rows. If the four entries are $1,200, $800, $0 and $0, the result is $2,000. With actual income in C5:C8, enter =SUM(C5:C8) in C9; if the actual figures total $1,950, the displayed total is $1,950.
With planned expenses in B12:B20, enter =SUM(B12:B20) in B21. If those expense plans add to $1,700, B21 returns $1,700. With actual expenses in C12:C20, enter =SUM(C12:C20) in C21; actual spending of $1,740 returns $1,740.
With total actual income in C9 and total actual expenses in C21, enter =C9-C21 in C23. Using the example totals above, the result is $210 ($1,950 minus $1,740). This is the amount remaining from the income and expenses entered in the sheet, not a forecast of bank balance: pending payments, debt repayments omitted from the categories, or other accounts can change the real position.
For a difference column, decide what a positive number should mean. For an expense row, with the planned amount in B12 and actual amount in C12, enter =B12-C12 in D12. If groceries were planned at $800 and actual spending was $765, D12 returns $35 under budget. For an income row, with planned income in B5 and actual income in C5, enter =C5-B5 in D5. A positive result then means income was higher than planned. The two signs differ intentionally, so label the column clearly or use separate headings for income and expense variances.
Convert weekly and annual bills carefully
Many New Zealand expenses are quoted weekly, while a household budget is often reviewed monthly. Multiplying a weekly amount by four undercounts a typical year because there are 52 weeks, not 48. For an average monthly equivalent, multiply by 52 and divide by 12. It is an average, not a claim that every calendar month has the same number of weekly payment dates.
With a weekly amount in B25, enter =B25*52/12 in B26. If B25 contains $180, B26 returns $780. That conversion can help compare a weekly cost with monthly income, but the actual cash-flow calendar still matters: a four-payday month and a five-payday month may feel different. For an annual bill, divide by 12 to estimate a monthly provision. With an annual bill in B27, enter =B27/12 in B28; an annual $1,200 bill gives $100 per month. Check whether the bill is truly annual and whether its amount or due date changes.
You can keep the original frequency in a separate column, such as Frequency, and put the converted monthly estimate in another. This makes the calculation auditable later. If you change a source figure, the estimate updates automatically, rather than leaving a copied number that no longer matches.
Format and review the sheet in Excel
Format money as currency or number with two decimal places so that figures are easy to scan. Select the relevant cells and open Format Cells with Ctrl+1 on Windows; choose the Number or Currency category and select an appropriate symbol and decimal setting. On Mac, use Command+1 to open Format Cells. The exact currency symbol shown depends on the selected format and the Excel installation, so check that the workbook clearly identifies its amounts as NZD, particularly if it will be shared.
Use bold text for section totals and consider a border above each total. You can freeze the heading row using View > Freeze Panes if the list becomes long. To make category entry consistent, select the category cells and use Data > Data Validation to create a list of allowed entries; this is optional and may be unnecessary for a short personal sheet. Conditional formatting can highlight negative balances or overspending, but use clear labels and do not rely on colour alone to communicate meaning.
When the layout is working, save a clean copy for future months and duplicate the sheet for a new period. Give each sheet a clear name, such as Nov 2026, and check formula references after copying or changing rows. If you turn the transaction list into an Excel table with Ctrl+T on Windows, Excel can extend formatting and formulas as rows are added. On Mac, Command+T opens the table dialog in many Excel configurations; if that shortcut is intercepted, use Insert > Table.
Choose a template or build your own
A blank workbook offers control: you choose categories, pay periods and calculations, and you can remove sections that do not apply. Its trade-off is that you must create and check the formulas yourself. A downloaded template may save setup time, but inspect its formulas, hidden sheets, assumptions and currency before entering personal information. A template labelled “budget” may be designed for a business, a US household or a different period, so the label alone does not make it suitable for New Zealand use.
Before adopting any workbook, ask:
- Can you identify how totals and balances are calculated?
- Does it distinguish planned amounts from actual transactions?
- Can you change the currency and payment frequency?
- Does it include categories you understand, without requiring unnecessary personal details?
- Can you use it offline, and are you comfortable with where any uploaded data is stored?
Excel templates can be found through Excel’s template options and other providers, but availability and design change. Review the source and file contents rather than assuming that a template is official, current or secure. If a downloaded workbook asks you to enable macros, do not enable them unless you understand why they are needed and trust the source. A basic household budget should not normally need a macro.
Common budgeting mistakes and how to avoid them
One frequent problem is recording only fixed bills and forgetting irregular costs. A car repair, annual insurance payment or birthday expense may not occur every month, but it still affects the year. List known periodic costs and set aside a monthly estimate, while remembering that estimates can differ from the eventual bill. Another common error is counting a credit-card purchase as spending when it is made and then counting the card repayment as a second expense. Record the purchase in its spending category; treat the repayment as settling the card balance, not as a second purchase.
Other issues are practical rather than mathematical. A budget can become stale if actual figures are not entered, or discouraging if every category is set unrealistically low. Compare the plan with bank transactions regularly, but take care when importing statements: dates, refunds, transfers between your own accounts and card payments can need classification. A transfer is not necessarily new income or spending. Keep private account details out of a workbook you do not trust, and protect or store the file appropriately if it contains sensitive information.
Finally, do not interpret an under-budget figure as proof that a purchase is affordable. The sheet reflects only the amounts and timing entered. It cannot automatically know about future obligations, changes in income, interest, fees or an emergency. Use it as an organising tool, and check actual account balances and payment due dates separately.
Frequently Asked Questions
Where can I get a free NZ budget template for Excel?
Excel offers templates through its template selection screen, and other organisations may publish downloadable workbooks. Availability changes, so check that the file is suitable for household use, works in your version of Excel, uses appropriate currency and has formulas you can inspect. Do not enter sensitive information into an unfamiliar file or service.
How do I make a budget in Excel for New Zealand?
Create sections for income and expenses, add planned and actual columns, and total each section with SUM formulas. Enter all amounts on a consistent period, such as monthly, and use NZD labels. Include irregular bills as well as weekly costs converted to a monthly average where useful.
Should I use gross pay or take-home pay?
For a household cash-flow plan, use the money that actually reaches your account as income, then list expenses paid from that money. Gross pay is before deductions and may not be available for spending. Individual circumstances vary, so check payslips and relevant official information for the amounts that apply to you.
Is multiplying a weekly expense by four accurate?
No, it is a rough four-week estimate and understates an annualised monthly average. The calculation 52 divided by 12 gives about 4.33 weeks per average month. Use weekly cash-flow dates as well if the timing of paydays and bills matters.
Can I use the same budget in Excel for Mac or Excel for the web?
The basic cells and SUM formulas work across current Excel platforms, but some ribbon layouts and keyboard shortcuts differ. The steps here target Excel for Microsoft 365 on Windows; on Mac, Command+1 opens Format Cells, while Excel for the web uses its browser ribbon and may not support every desktop feature or shortcut in the same way.
Using the numbers responsibly
A spreadsheet can organise income, spending and bill timing, but it is not financial, tax or legal advice and does not establish what any particular person should spend or save. The figures in this guide are illustrative, not current price estimates or recommendations. Check actual account records, invoices and payment terms; for questions about lending, tax or a financial decision, confirm the relevant terms with the lender or a qualified professional. A clear, regularly updated workbook is most useful when its assumptions are visible and its limits are understood.
Related
- Amortization Schedule Excel: Build One Step by Step
- Add Percentages to an Excel PivotTable
- Accounting Year-End Checklist Template for Excel Users
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Shuffle Names in Excel? Methods and ExamplesYes. In Excel for Microsoft 365 on Windows, add a random number beside each name and sort the…
- Excel Arrow Keys Not Moving Between Cells? Quick FixesIf the arrow keys scroll the worksheet instead of selecting a different cell, turn off Scroll Lock; in…
- Excel Conditional Formatting for an Entire Row EasilyYes. In Excel for Microsoft 365, select the cells in each record that should change color, then create…
- How to Insert a Continuous Horizontal Line in WordTo insert a continuous horizontal line in Word, place the cursor in a blank paragraph and type three…
- Data Validation and Quality Assurance in ExcelIn Excel, data validation limits what people can enter in a cell, while quality assurance (QA) is the…
- Percentile Rank in Excel: Find and Format ItTo find a value’s percentile rank in Excel, use =PERCENTRANK.INC($A$2:$A$6,B2), replacing the range with your comparison data and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.