How many products can this school canteen price list hold?

The Price List is set up from row 2 to row 101, providing 100 operational product rows. The table includes formulas and formatting across those rows, but unused rows remain available for your own menu items.

Does the spreadsheet calculate GST automatically?

Yes. Select 0% or 10% in the GST Rate column and the GST Amount formula calculates the result from Cost ex GST. Check each product's Australian GST treatment before using the figures for BAS records.

What does gross profit mean in this template?

Gross Profit is Sell Price inc GST less Cost ex GST and the calculated GST Amount. For example, $7.00 less $3.10 and $0.00 GST gives $3.90. Gross Margin % divides that profit by the selling price.

Can I mark a canteen item as temporarily unavailable?

Yes. Choose No in the Available column rather than deleting the item. This preserves the product record while the Dashboard counts only the rows marked Yes as available items.

How are school canteen price review dates calculated?

Enter an Effective Date and the Review Date formula adds 6 months. For example, an effective date of 15/01/2026 produces a review date of 15/07/2026. The Instructions sheet recommends reviewing prices every six months.

Does the workbook check allergens or nutrition compliance?

No. The Notes column gives you a place to record supplier and allergy information, but the workbook does not verify it. Check allergen declarations, food handling requirements and the school's nutrition policy before selling an item.

Sales & Customers

School Canteen Price List Excel - Free Template

School canteen Excel price list with GST, margins, suppliers, availability, healthy choices, review dates and dashboard summaries for Australian schools.

2026-09-07

462 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Price List tab - Excel template school canteen price list excel spreadsheet australia

This school canteen price list Excel spreadsheet records menu items, suppliers, pack sizes, costs, GST rates, selling prices, gross profit, margins, healthy choices, availability and review dates. It includes a 100-row Price List, a Dashboard with category summaries and charts, and an Instructions sheet.

Use it to keep the canteen menu accurate when supplier costs change, products go temporarily unavailable or prices are reviewed every six months. The workbook is set up for Australian dollars, with dropdowns for categories, GST treatment, healthy choice status and availability.

The key benefits of this Excel template

Keep up to 100 menu items in one structured Price List table, from sandwiches and wraps to drinks and frozen treats.
Calculate GST amount, gross profit and gross margin automatically from the cost and selling price fields.
See total items, available items, healthy choice items, average sell price, average gross margin and GST-applicable items on the Dashboard.
Compare average price, margin and healthy choice counts across eight canteen categories.
Record supplier names, pack or serve sizes and allergy information in the Notes column.
Use six-month review dates calculated from each product's effective date.
Find an item by Item ID in the Dashboard lookup panel without searching through the full list.

Step-by-step guide

Open the Instructions sheet first and check the colour key, GST guidance, price-review note and food-safety reminders.
Go to Price List and enter or update products in the pale yellow input cells. Add an Item ID, item name, category, supplier and pack or serve size.
Enter the cost excluding GST, choose 0% or 10% GST, and enter the selling price including GST. The GST Amount, Gross Profit and Gross Margin % columns calculate automatically.
Choose Yes or No for Healthy Choice and Available. Use Available = No when an item is temporarily unavailable rather than deleting its record.
Enter the Effective Date and add supplier, allergen, pack-size or preparation details in Notes. The Review Date is calculated six months later.
Open Dashboard to review the headline figures, category summary, healthy choice summary and three charts. Select an Item ID in the lookup panel to display that product's details.
Before publishing prices, check GST treatment, allergen declarations, food handling requirements and the school's nutrition policy against the current product information.

Screenshot 2: Dashboard tab - Excel template school canteen price list excel spreadsheet australia — Figure 2: Worksheet "Dashboard"

What is included

Price List sheet with columns for Item ID, Item Name, Category, Supplier, Pack/Serve Size, Cost ex GST, GST Rate, GST Amount, Sell Price inc GST, Gross Profit, Gross Margin %, Healthy Choice, Available, Effective Date, Review Date and Notes.

Prepared operational rows from row 2 to row 101, with formulas in GST Amount, Gross Profit, Gross Margin % and Review Date.

Dropdown validation for eight categories, 0% or 10% GST, Yes or No healthy choice and Yes or No availability.

Decimal validation for cost and selling price fields, plus Australian dollar, percentage and DD/MM/YYYY formatting.

Dashboard with total menu items, available items, healthy choice items, average sell price, average gross margin, GST-applicable items and total gross profit.

Category Summary and Healthy Choice Summary tables, with charts for average category sell price, healthy choice counts and item gross margins.

Selected Item Lookup using an Item ID list, plus an Instructions sheet explaining input cells, GST, price reviews, allergens, food safety and temporary stock issues.

Who uses a school canteen price list Excel spreadsheet

The canteen coordinator's weekly check

A volunteer canteen coordinator, school business manager or P&C committee can use this spreadsheet when the weekly menu is planned. The Price List has 16 fields, so the team can see more than a shelf price: it can record the supplier, serve size, cost ex GST, GST rate, healthy choice status and whether the item is available.

For example, a ham and cheese sandwich might cost $2.40 ex GST and sell for $6.00 including GST. With a 0% GST selection, the calculated gross profit is $3.60 and the gross margin is 60.00%. That is a much more useful decision than simply saying the sandwich makes $3.60.

When suppliers or menus change

The office manager can update a supplier, pack size or ingredient note when a delivery arrangement changes. A Brisbane bakery item can remain in the list while its Notes field records that it is baked daily and contains gluten; the item does not need to be deleted just because it is temporarily unavailable.

At the start of a school term, the treasurer can check the Dashboard rather than manually counting products. The workbook counts menu items, available items and healthy choice items, then summarises the eight listed categories: Sandwiches, Wraps, Bakery, Healthy Snacks, Cold Snacks, Snacks, Drinks and Frozen Treats.

Useful for committee pricing decisions

A P&C committee reviewing prices can compare average sell price and average gross margin by category. If 20 drinks average $2.80 but 15 wraps average $7.00, the committee can discuss affordability and contribution to canteen operating costs using the same figures each meeting.

Image 1 shows the Price List sheet with its frozen top row, table layout and 100 prepared product rows. Image 2 shows the Dashboard with summary cards, category tables, lookup panel and three charts. Image 3 shows the Instructions sheet, including the pale yellow, green and red colour key.

Screenshot 3: Instructions tab - Excel template school canteen price list excel spreadsheet australia — Figure 3: Worksheet "Instructions"

GST and food records for an Australian school canteen

Check the GST treatment item by item

Australian GST is generally 10%, but food treatment is not determined simply by whether something is sold at a canteen. Basic food can be GST-free while prepared or certain heated food may be taxable. The workbook therefore lets you select 0% or 10% for each product; it does not decide the treatment for you.

For example, a taxable item costing $3.00 ex GST has a GST amount of $0.30 when 10% is selected. If the sell price is $7.00 including GST, the workbook calculates gross profit as $3.70, not $4.00. Confirm the product's treatment with the school's BAS adviser before relying on the figures for a BAS.

Records supporting the price

A school operating a canteen should retain supplier invoices, product descriptions and pricing decisions with its bookkeeping records. The ATO expects business records to be kept for 5 years. The spreadsheet is a menu and pricing register, not a replacement for supplier tax invoices, payment records or the school's accounting system.

If the canteen is registered for GST, its ABN and tax-invoice records still need to be handled correctly. A tax invoice generally includes the supplier identity and ABN, the words Tax Invoice, invoice date, description and GST shown separately where required; the $82.50 threshold is relevant to simplified tax-invoice requirements.

Food safety and school policy remain separate checks

The Notes field can record allergens such as gluten, dairy or egg, but it does not certify an item's safety. Before sale, check allergen declarations, food handling requirements, state or territory requirements and the school's nutrition policy. The Instructions sheet specifically tells users to complete those checks.

A canteen that sells 300 items in a month might collect $1,500 from a taxable product line at $5.00 each, including about $136.36 GST if every sale is taxable. That calculation is only an illustration: the actual GST result depends on the product mix and the canteen's accounting treatment.

Where school canteen pricing goes wrong

Using the wrong cost basis

The most common pricing problem I see is comparing a sell price with a supplier cost that has been entered on a different basis. If a pack of 10 snacks costs $12.00 but the canteen enters $12.00 against a single serve selling for $2.00, the apparent gross profit is negative even though the per-serve cost is $1.20.

That is why the Pack/Serve Size column matters. Entering 10 pack, 1 serve or another clear description does not perform a pack conversion, so you must enter the correct per-item cost yourself. The spreadsheet calculates from the number in Cost ex GST; it cannot infer quantities from text.

Overlooking GST and margin effects

Selecting 10% for every food item can overstate GST and reduce the reported margin. Selecting 0% for every item can understate the amount to account for. A $4.00 cost, $8.00 sell price and 10% GST produces $0.40 GST and $3.60 gross profit, a 45.00% margin; selecting 0% instead shows $4.00 and 50.00%.

Another trap is reading gross margin as a markup. A $2.00 profit on a $6.00 selling price is a 33.33% margin, but it is a 50.00% markup on cost. The Dashboard uses gross margin, so the committee should use that term consistently when comparing categories.

Deleting records and losing context

When a supplier stops delivering a product, deleting the row removes the history and can make old committee decisions difficult to explain. Set Available to No and leave the product record in place. Add the change, allergy detail or replacement information in Notes.

Finally, do not rely on the Dashboard if the input rows are incomplete. Blank costs or selling prices leave calculated fields blank, and an item with no Effective Date will not receive a Review Date. A missing date can mean a review was forgotten, not that the price is current.

Making the canteen price list part of a regular routine

Attach updates to an existing task

Choose one person to update the Price List whenever a supplier invoice, menu decision or product change is approved. A practical routine is a 15-minute check after the weekly stock order, followed by a Dashboard review at the monthly P&C or canteen meeting.

For a menu of 60 items, checking six supplier changes each week is easier than rebuilding the list at the end of term. Enter the new effective date immediately, then use the calculated Review Date to schedule the next six-month price check.

Keep entries consistent

Use the existing category dropdowns instead of inventing variations such as Drinks and Beverages.
Enter costs and selling prices as numbers, not text containing dollar signs or comments.
Use Notes for supplier, allergy and pack information, while keeping the main price fields concise.
Set Available to No for temporary shortages so the product remains available for later review.

Image 3 explains that pale yellow cells are for input, while formula cells calculate GST, gross profit, gross margin and review dates. That separation is useful: update the yellow cells and leave the calculation cells alone.

Know when the spreadsheet is no longer enough

This workbook suits a school canteen maintaining a menu register and reviewing prices. Move to software such as Xero or MYOB when you need integrated supplier bills, sales transactions, bank reconciliation, stock movements, user permissions or audit history across multiple locations.

Keep the spreadsheet as a controlled reference only if the accounting system becomes the source of truth. Do not use its Dashboard total gross profit as a full profit figure: it excludes wages, packaging, payment fees, wastage and other canteen expenses.

Frequently asked questions about this template

The Price List is set up from row 2 to row 101, providing 100 operational product rows. The table includes formulas and formatting across those rows, but unused rows remain available for your own menu items.
Yes. Select 0% or 10% in the GST Rate column and the GST Amount formula calculates the result from Cost ex GST. Check each product's Australian GST treatment before using the figures for BAS records.
Gross Profit is Sell Price inc GST less Cost ex GST and the calculated GST Amount. For example, $7.00 less $3.10 and $0.00 GST gives $3.90. Gross Margin % divides that profit by the selling price.
Yes. Choose No in the Available column rather than deleting the item. This preserves the product record while the Dashboard counts only the rows marked Yes as available items.
Enter an Effective Date and the Review Date formula adds 6 months. For example, an effective date of 15/01/2026 produces a review date of 15/07/2026. The Instructions sheet recommends reviewing prices every six months.
No. The Notes column gives you a place to record supplier and allergy information, but the workbook does not verify it. Check allergen declarations, food handling requirements and the school's nutrition policy before selling an item.