Budget Spreadsheet NZ: Build a Practical Excel Plan

How-to basics · Updated November 21, 2026

A useful budget spreadsheet for New Zealand is a simple Excel sheet that compares planned income and spending with what actually comes in and goes out. In Microsoft Excel for Microsoft 365 on Windows, set up columns for Item, Budget and Actual, enter amounts in NZ dollars for your chosen pay period, then use SUM formulas to total income and expenses and calculate what remains.

What a New Zealand budget spreadsheet should show

A budget spreadsheet is a planning tool, not a forecast that every bill will be identical each month. Its main job is to help you see whether expected take-home income can cover regular costs, less frequent bills, savings goals and flexible spending. Comparing the plan with actual transactions helps show where the difference came from.

For a household budget, a practical starting layout is:

  • Income: wages or salary received, benefits or other regular income, and any variable income you want to include.
  • Fixed costs: expenses that are usually predictable, such as rent, a mortgage payment, insurance premiums or a phone plan.
  • Variable essentials: groceries, power, transport and other costs that change from period to period.
  • Irregular costs and goals: annual or occasional bills, planned purchases, debt repayments and savings contributions.
  • Actual spending: the amounts that really arrived in your account or were paid during the period.

Use take-home pay as the income figure if you are building a day-to-day spending plan. For many employees, PAYE income tax and any student loan deductions are already withheld before salary reaches their bank account. Check your payslip so you do not deduct the same amount again. KiwiSaver contributions made through payroll may also already be reflected in take-home pay; include a separate contribution only if it is paid separately or you specifically want to track it.

Choose a pay period that fits your income

There is no single best budget period. A monthly sheet can suit monthly rent and bills, while a weekly or fortnightly budget may be easier to follow if that is how income arrives. The important point is to compare like with like: do not put one week of income beside a full month of expenses without converting one side.

If you are paid fortnightly but pay some bills monthly, you can still keep a fortnightly budget. One approach is to set aside part of each pay for those bills in a separate bills category. Alternatively, use a monthly budget and record pay on the dates it arrives. Be consistent about the period used for every planned and actual amount.

For example, suppose take-home pay is $2,400 each fortnight and rent is $1,800 per month. A monthly sheet should use monthly income and monthly costs, rather than treating $2,400 as monthly income. Fortnightly pay does not divide neatly into two paydays every month across a full year, so use the dates and amounts that apply to your actual pay schedule when planning cash flow. The example is illustrative, not a recommendation about how to allocate money.

Build a basic budget in Excel

In a blank workbook, enter Item in A1, Budget in B1 and Actual in C1. Use rows 2 and 3 for income, row 4 for total income, rows 6 to 13 for spending categories, row 14 for total spending and row 16 for money left after spending. Leave row 5 and row 15 blank to make the sections easier to scan.

Here is one illustrative monthly plan in NZ dollars. The figures are examples only; use your own income and costs.

  • Row 2, wages after deductions: Budget $5,200; Actual $5,200.
  • Row 3, other income: Budget $150; Actual $150.
  • Rows 6 to 13: rent $1,900; utilities $250 planned and $280 actual; groceries $850 planned and $920 actual; transport $420 planned and $390 actual; insurance $180; phone and internet $130; savings $500; and flexible spending $600 planned and $650 actual.

With planned income in B2:B3, enter this in B4 to total the budgeted income. The example returns $5,350.

=SUM(B2:B3)

With actual income in C2:C3, enter this in C4. The example also returns $5,350.

=SUM(C2:C3)

With planned spending categories in B6:B13, enter this in B14. The example returns $4,830.

=SUM(B6:B13)

With actual spending categories in C6:C13, enter this in C14. The example returns $4,950.

=SUM(C6:C13)

With planned total income in B4 and planned spending in B14, enter this in B16 to calculate the planned remainder. The example returns $520.

=B4-B14

With actual total income in C4 and actual spending in C14, enter this in C16. The example returns $400.

=C4-C14

These figures show why actuals matter: in the example, spending is $120 higher than planned, so the remaining amount is $120 lower than the plan. A positive remainder is not automatically spare cash; upcoming bills, debts or other commitments may still need to be accounted for.

Include costs that do not arrive every month

Irregular costs are a common reason a budget looks balanced on paper but feels tight in practice. In New Zealand, possible examples include vehicle licensing, Warrant of Fitness checks, car repairs, annual insurance premiums, school costs, medical or dental bills, and seasonal power use. The timing and amount will depend on the person, household and service provider.

There are two straightforward ways to handle these expenses:

  • List the bill in the month it is due. This makes the timing visible, but can make that month look unusually expensive.
  • Set aside a regular amount in a sinking-fund category. For example, if an illustrative annual bill is $600, dividing it by 12 gives $50 per month to plan for it. The actual bill and due date should be checked against the provider’s information.

Keep the sinking-fund contribution separate from the bill itself if you want to see both the ongoing set-aside and the eventual payment. Otherwise, recording both as spending in the same period can make the total misleading. A notes column can record a due month or explain a one-off entry.

Make the sheet readable and easy to maintain

In Excel for Microsoft 365 on Windows, select the amount cells and use Home > Number to apply a currency or number format. For a household budget, show two decimal places only if they are useful; whole-dollar figures may be easier to scan. Label the currency as NZD or state clearly that all amounts are in New Zealand dollars, particularly if you share the file with someone who may use another currency.

Use clear category names and keep them stable from one period to the next. If you rename “Flexible spending” every month, comparisons become harder. You can add a fourth column for Notes, or a separate date column if you are entering transactions rather than just period totals. Avoid merging cells in the data area because it can make sorting and editing awkward.

To flag overspending, select the actual-spending cells, then choose Home > Conditional Formatting > Highlight Cells Rules > Greater Than. Set the comparison amount to the matching budget cell only if you have arranged a reliable rule for each row; a single fixed threshold will not compare every row with its own budget. For a beginner, simply compare the Budget and Actual columns or add a Difference column and review it manually. Check that formulas still include all categories when you insert or move rows.

Update the sheet on a regular schedule, such as once a week or after each pay. Entering transactions from bank statements can improve accuracy, but check that each transaction is counted once and that transfers between your own accounts are not mistakenly treated as spending. Keep a backup copy somewhere secure, especially if the workbook is important to household planning.

New Zealand details to account for

Use the amount that actually applies to you rather than assuming every household has the same deductions or prices. If you are self-employed, receive irregular income, have income from overseas or need to plan for tax obligations, a simple household budget may not capture everything. Do not treat a spreadsheet estimate as a tax calculation. Check current requirements with Inland Revenue or a qualified tax professional where relevant.

Consumer prices displayed in New Zealand generally include GST, so a personal spending budget usually records the amount paid rather than adding GST again. Business bookkeeping can require different treatment; this household-budget example is not a GST return or accounting system. Likewise, use the real repayment amount and terms for any loan rather than an assumed interest rate. A budget can help organise figures, but it does not determine whether a loan, insurance policy or financial product is suitable.

New Zealand households may also face changes in rent, mortgage costs, insurance premiums and utility prices. Review the budget when a contract, rate or regular bill changes instead of relying indefinitely on last year’s amount. For variable income, consider recording expected and received income separately and avoid treating an uncertain payment as money already available.

Spreadsheet versus budgeting app or template

A spreadsheet is flexible: you choose categories, periods and calculations, and can keep the file on your own device. That flexibility also means you are responsible for entering data correctly, protecting the workbook and checking formulas. A pre-made Excel template can save setup time, but inspect its categories, formulas, currency formatting and assumptions before entering personal information.

A budgeting app may import transactions or provide automatic categorisation, depending on the product and its connection options. That can reduce manual entry, but check its fees, privacy terms, data-sharing arrangements and whether it supports the New Zealand accounts you use. A bank’s transaction list or a paper budget can also be enough for someone who prefers not to maintain a workbook. The useful option is the one you can keep accurate and review consistently.

Do not assume an online spreadsheet or template is safe just because it is labelled “NZ budget”. Avoid uploading bank passwords or sensitive account credentials into a workbook. If sharing a file, give access only to people who need it and review cloud-sharing settings. A spreadsheet is not a secure place to store full card numbers, internet banking logins or identity documents.

Common budgeting spreadsheet problems

  • Mixing time periods: monthly costs and fortnightly income need a consistent comparison period or a clear cash-flow schedule.
  • Using gross pay: a household spending plan based on take-home money should not count deductions twice.
  • Forgetting irregular bills: add an occasional-cost category or plan for the bill in its due period.
  • Double-counting transfers: moving money between your own accounts is not necessarily a new expense.
  • Leaving actuals blank: an empty cell does not confirm that spending was zero; enter or verify transactions before drawing conclusions.
  • Overcomplicating categories: too many tiny categories can make regular updates tiring. Start broad and split a category only when the detail helps you make a decision.

When a total looks wrong, inspect the cells included in the SUM range, check for amounts stored as text, and confirm that the figures use the same period and currency. Keep a copy before making major changes to a template. If a formula has been overwritten, restore it from a known-good copy or re-enter it after checking the intended cell references.

Frequently Asked Questions

Is there a free NZ budget spreadsheet?
A basic budget can be made in Excel without buying a specialist template. Some organisations and providers publish free resources, but check who created a file, whether it is current, what currency it uses and whether its formulas match your needs before relying on it.

Should I budget weekly, fortnightly or monthly?
Choose a period that matches how you receive income and manage bills, then convert amounts consistently. A monthly budget can suit monthly expenses; a weekly or fortnightly view may make day-to-day cash flow easier to follow.

Should I use gross or net income?
For a personal spending plan, take-home income is usually the clearest starting point because it is the money available in your account. If you have tax or other obligations not already withheld, track those separately and check the actual requirements that apply to you.

How do I account for an annual bill?
Record it in the month it is due or divide an estimated annual amount across the periods before it is due and track that set-aside separately. Confirm the actual cost and timing with the organisation that bills you.

Can Excel calculate whether I can afford a loan?
Excel can total income, expenses and repayments that you enter, but a simple budget cannot establish eligibility, suitability or the full cost of borrowing. Use the lender’s actual repayment terms and check them with the lender or a qualified professional; this article is not financial, tax or legal advice.

Related

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.