School Budget Excel - Free Template

1. Open Instructions first. Read the guidance on GST treatment, funding controls, record retention and the school's 31 March reporting cycle.
2. Review the sample rows. Decide which examples should be replaced, then keep each Budget ID unique, such as 2026-B01.
3. Complete Budget Detail. Enter the budget area, cost centre, description, supplier or payee, funding source, budget owner and planned date in the editable cells.
4. Enter amounts excluding GST. Add the approved amount in Budget Excl GST and the actual amount in Actual Excl GST. Select the applicable GST rate between 0 and 100%; use 15% for a standard taxable purchase.
5. Update actuals after invoices are checked. Match the actual amount to supporting records and add context in Notes, particularly where a project changes scope or timing.
6. Read the calculated columns. Budget GST, Budget Incl GST, Actual GST, Actual Incl GST, Variance, Variance % and Status are formula outputs and should not be overwritten.
7. Prepare for the board meeting. Review Budget Dashboard, select a funding source in B16, investigate Over budget lines and record the board's action in the relevant Notes cell.

A school board chair, principal, finance committee or office administrator can use this workbook when the annual operating budget is approved and throughout the year. It gives the people making decisions one shared register instead of separate lists for curriculum resources, property work, ICT purchases and activities.

Useful at budget approval time

At a school with 4 staff in the administration and finance function, the principal might enter a $32,000 property maintenance allowance, a $18,500 ICT programme and a $9,600 teaching-resource plan. The Budget Detail sheet records the owner and funding source alongside each amount, so a trustee can see not just the total but who is responsible and where the money comes from.

Use the planned date to spread decisions across the school year. A roof repair planned for 18/02/2026 should not be confused with a device refresh planned for 10/03/2026, even if both are approved before the first board meeting.

Useful during monthly monitoring

The office manager can add actual expenditure when invoices have been checked, while the board reviews the dashboard at each meeting. For example, a $32,000 budget excluding GST becomes $36,800 including GST at 15%. If the actual excluding GST is $34,500, the actual inclusive total is $39,675 and the calculated variance is negative $2,875, so the line is Over budget.

The funding source enquiry is handy when trustees want a narrower answer. Select Operational funding, Curriculum funding, Property funding, Ministry funding, Fundraising, Donations or Trips and activities in B16 to see approved expenditure, actual expenditure and line count for that source.

The workbook is designed around New Zealand figures but it is a management tool, not a GST return or statutory report. The standard GST rate is 15%. For a taxable purchase of $1,000 excluding GST, the GST is $150 and the GST-inclusive cost is $1,150; the template calculates those two outputs from the amount and GST Rate fields.

Check the school's GST treatment

A school or board must apply the correct treatment to each transaction. Some supplies can be exempt or otherwise treated differently, so do not blindly leave every line at 15%. The Instructions sheet specifically says to confirm unusual treatment with the school's accountant, auditor or finance adviser.

GST registration is compulsory once taxable turnover exceeds $60,000 in any 12-month period. Registered organisations generally file monthly, 2-monthly or 6-monthly returns according to their filing arrangement. This workbook does not prepare those returns, calculate adjustments or replace taxable supply information records.

Keep evidence with the spreadsheet

Inland Revenue requires business financial records to be retained for 7 years. Keep invoices, approvals, funding correspondence and payment evidence with the workbook under the school's recordkeeping procedures. The Notes field can explain a variance, but it is not a substitute for the original invoice or approval.

The standard New Zealand financial year ends on 31 March. Align the planned dates and board reporting with that balance date, and separately follow Ministry of Education funding conditions, delegated authorities and school procurement policies. A $40,000 property commitment should be supported by the required approvals even if the spreadsheet itself accepts the number.

Use the school's IRD number and accounting records when completing actual tax or GST reporting. Do not treat the dashboard's totals as an IR3, IR4 or GST return figure without reconciling them to the underlying records.

The most expensive problems I see are not usually caused by Excel formulas. They come from entering an amount in the wrong GST basis, treating an estimate as an actual, or approving a purchase without linking it to the right funding source. Once several invoices have been entered, correcting the trail takes much longer than getting the first row right.

Mixing GST-inclusive and exclusive amounts

Suppose a supplier quotes $11,500 including GST but the user enters $11,500 in Budget Excl GST. The workbook calculates $1,725 GST and $13,225 inclusive, overstating the planned cost by $1,725. That error can make a funding request appear short and distort every variance comparison.

The opposite mistake is just as awkward. Entering $9,600 including GST as an exclusive amount turns it into $11,040 in the dashboard. Write the basis in the supporting paperwork before entering the row, rather than guessing from a rounded supplier quote.

Leaving the actual blank or entering a commitment too early

A blank Actual Excl GST is treated as not started in the Status formula. Entering a purchase order as if it were an invoice can show expenditure before cash has been spent or the goods have been received. For a $25,000 building project, that timing error can make the board think the annual budget is nearly used when the cost belongs in a later reporting period.

Misreading a negative variance

Variance is budget inclusive less actual inclusive. A positive $2,000 means room remains; negative $2,000 means actual spending is above budget. If a $20,000 inclusive budget has $22,400 of actuals, the result is negative $2,400 and the status is Over budget, not Under budget.

Another common failure is reusing a Budget ID for two unrelated purchases. That makes follow-up with the supplier and board minutes unnecessarily difficult. Keep the ID unique and use Notes for the reason, decision and next action.

A budget file only helps when updating it is attached to a job someone already does. The simplest approach is to make one person responsible for the weekly invoice check and one standing agenda item responsible for board review. Do not wait until the end of the term and then try to remember why a variance occurred.

Use a short fixed cycle

• After each payment run, enter checked actuals and add a short Notes explanation for unusual movements.
• Before the board meeting, filter Budget Detail to Over budget and read the supplier, owner, planned date and notes together.
• At month-end, select each relevant funding source in B16 and save the board pack or record the figures in the minutes.
• Before 31 March, reconcile the final actuals to the school's accounting system and supporting invoices.

Keep entry consistent

Use the existing funding-source dropdown rather than typing similar labels such as Ministry grant or ministry funding. The dashboard's SUMIF, COUNTIF and VLOOKUP formulas depend on matching those seven source names exactly.

Do not type over calculated columns K, L, N, O, P, Q or R. If you need to change a GST treatment, update the input amount or GST Rate cell. Pale-yellow cells are the intended inputs, while the conditional formatting highlights available budget and items needing attention.

Know when to move on

This workbook has 100 prepared detail rows and no chart on the detail sheet, although the dashboard includes two charts. If the school is processing hundreds of invoices each month, needs purchase-order approval, bank reconciliation, audit logs or multiple users editing at once, move the source records into Xero or MYOB and retain this type of spreadsheet for board analysis only.