# Canteen management Excel sheet (free) for schools

> Free canteen sheet: daily sales by item, prepaid student and employee accounts, cash close, stock and waste, profit by item and the rent due to the school.

Source: https://softwiro.com/blog/canteen-management-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Canteen management sheet in Excel (free): sales, stock and prepaid balances

Know each day's profit, whether the drawer matches, who is low on prepaid balance, what to reorder and what rent you owe the school.

15 November 2026 5 min read

## In short

- Type each day's quantity per item in one row and the sheet works out sales, cost and gross profit from the item prices.
- Prepaid accounts: balance = opening + top-ups − purchases, and a low-balance list sorts the accounts under your limit with phone numbers.
- The expected drawer = sales − account sales + cash top-ups; type the actual cash to see a shortage, match or surplus.
- Waste and stock count reduce and check the balance, and rent is a percentage of sales or a fixed monthly amount.

You run a school or company canteen, and at the end of each day you want to know how much you sold and earned, whether the cash drawer matches, which students' or employees' prepaid balance is about to run out, what you are short of, and how much you will pay the school this month. The free [canteen management sheet](https://softwiro.com/templates/canteen-management) (the page is in Arabic) answers all of this in one file.

## The problem it solves

A canteen moves fast: dozens of cheap items, students buying on prepaid balance rather than cash, sandwiches that spoil after two days, and a drawer closed in the middle of the break rush. So a shortage appears and nobody knows why, a balance goes negative unnoticed, and the school's rent is worked out by guess. The sheet ties it all to one record.

## How the sheet works, step by step

1. Items: list each item with its purchase price, selling price, category, whether it spoils quickly, opening quantity and minimum. The order here is the order of the daily sales columns.
2. Purchases: log each delivery with its date, quantity and unit price.
3. Daily sales: in the day's row type how many of each item sold; total sales, cost and profit appear.
4. Accounts and account log: open an account for each student or employee, and log every top-up and every purchase on account. The balance and its status appear.
5. Daily close: type the actual cash in the drawer and the difference from the expected shows.
6. Waste, stock count, profitability, rent and summary: log what spoiled, enter the real count at stock-take, then read each item's and category's profit, the rent and net profit.

## What is in each sheet

- Items: the basics, unit profit, balance and its value, status and the suggested reorder quantity.
- Daily sales: a day × item grid, with each day's sales, cost and profit.
- Prepaid accounts and account log: top-ups, purchases and the balance for each account holder.
- Low balance: whose parents or which employees to alert, with the phone.
- Daily close: expected, actual and the difference for each day.
- Waste and stock count: what spoiled and what is short against the book, with its value.
- Profitability, rent and summary: profit by item and category, what the school is owed, numbers and charts.

## Walk-through on the sample numbers

These numbers are sample data inside the sheet, not a real canteen: 14 items, 19 selling days in October 2026 and rent at 7% of sales.

- October sales: 46,924, cost of what was sold 31,163, so gross profit is 15,761, or 33.6%. Sandwiches alone are 17,856, about 38% of sales.
- Item profit: the cheese sandwich costs 6 and sells for 10, so unit profit is 4 and margin 40%. It sold 566 in October: sales 5,660 and gross profit 2,264. The top seller by quantity is the foul sandwich (856 pieces).
- Waste and rent: waste in October is 209 and rent is 46,924 × 7% = 3,284.68, so net profit is 15,761 − 209 − 3,284.68 = 12,267.32 before staff wages.
- Drawer: on 4 October sales were 2,446, of which 30 on account, so cash sales are 2,416, plus 780 in cash top-ups, so the drawer should hold 3,196, and it did. On three October days a difference appeared (−15, +5 and −25), netting −35.
- Prepaid balance: 12 accounts with balances totalling 792. Mariam has 40 + 50 − 82 = 8, so "low balance" (limit 20), and Karim is at −6, "negative balance". Four accounts appear on the low-balance list.
- Stock: the pastrami sandwich is "out", so the reorder quantity is 20; the egg sandwich has 6, under its minimum of 15, so 24 are suggested. The 12 November stock count shows a shortage worth 27.5.
- Rent: November sales to the 12th are 24,727, so rent due is 1,730.89 and shows "due" until you pay it.

## Common mistakes

- Selling on account without logging it in "Account log", which shows a shortage in the drawer.
- Logging a top-up on the account without putting the money in the drawer, which shows a shortage of that amount.
- Reordering the items after sales are logged, because the sales columns follow the item order.
- Changing an item's price retroactively, which changes the past days' numbers.
- Forgetting to log waste, so the stock count shows a shortage instead of waste.

## When to move to a system

Move when volume grows and typing quantities at day end gets slow, or when you want online top-ups, automatic messages to parents and a point of sale on the cashier's screen. For a restaurant or café with its own stock and waste see the [restaurant inventory and waste sheet](https://softwiro.com/templates/restaurant-inventory-waste).

## Start now

Open the [sheet page](https://softwiro.com/templates/canteen-management), download it, type your items with purchase and selling prices, then enter today's sales and close the drawer. After a week you will know each item's profit, which accounts need a top-up and where the difference goes.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: canteen management (1/3)](https://softwiro.com/uploads/cheatsheets/canteen-management/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/canteen-management/en-1.jpg)[![Cheat sheet: canteen management (2/3)](https://softwiro.com/uploads/cheatsheets/canteen-management/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/canteen-management/en-2.jpg)[![Cheat sheet: canteen management (3/3)](https://softwiro.com/uploads/cheatsheets/canteen-management/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/canteen-management/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I track students' prepaid balance in a school canteen?

Open an account per student in Prepaid accounts and log each top-up and each purchase on account in the Account log. Balance = opening + top-ups − purchases, and low or negative balances appear in the Low balance sheet with phone numbers.

### How do I find the drawer difference at day end?

Type the day's quantities in Daily sales, then the actual cash in Daily close. Expected = sales − account sales + cash top-ups, and difference = actual − expected, shown as short, over or match.

### How do I work out the rent or commission owed to the school?

In Settings choose the rent type: a percentage of sales (rent = sales × percentage) or a fixed amount for any month that has sales. Type what you paid in Rent and commission to see the balance.

### How do I get each item's profit?

Type purchase and selling prices in Items to get unit profit and margin. Profitability then shows each item's and category's monthly gross profit = sales − cost of what sold, and the profit after waste.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
