Restaurant accounts in Excel: the sheet that works, and the month it stops working
How to set up restaurant or café accounts in Excel: a daily sales tab, an expenses tab, opening and closing stock, and a monthly summary that works out food cost and net profit with ready formulas — plus six signs the spreadsheet has become smaller than your restaurant.
Most small restaurants and cafés keep their first accounts in a notebook, then in a spreadsheet. Nothing wrong with that: Excel is cheap, everyone can use it, and built properly it will tell you whether the business makes money.
The mistake is staying on it after it stops being enough. Here is how to build the sheet properly, and the signs that it has run its course.
The sheet, in four tabs
1. Daily sales
One row per day:
| Date | Cash | Card | Mobile wallets | Delivery apps | Total | Bills | Average ticket |
|---|---|---|---|---|---|---|---|
| 2026-10-01 |
- Total:
=SUM(B2:E2) - Average ticket:
=F2/G2
Splitting sales by payment method is not a luxury. Cash has to match the drawer, card has to match the bank statement, wallets have to match their balance. Put them in one number and you can check none of them.
Enter delivery app sales at their gross value and record the commission as its own line in the expenses tab. That way you see exactly how much commission costs you each month, instead of letting it vanish inside a net figure.
2. Expenses
One row per expense:
| Date | Category | Supplier or payee | Amount | Paid by | Invoice no. |
|---|---|---|---|---|---|
| 2026-10-02 | Ingredients | Poultry supplier | Cash |
Category comes from a fixed list, never typed by hand. Use Data Validation to create one: ingredients, wages, rent, utilities, maintenance, marketing, delivery commission, other. If one row says “veg” and another “vegetables”, your formulas will never add them together.
3. Stock
The value of ingredients on hand at the start and the end of the month — from an actual count, not a guess. If you don’t count yet, see how to do a restaurant stocktake. Without this tab every figure that follows is wrong, for the reason explained next.
4. Monthly summary
Everything here is a formula pulling from the other tabs:
| Line | How it is calculated |
|---|---|
| Sales | Sum of daily totals for the month |
| Food cost | Opening stock + ingredient purchases − closing stock |
| Wages | Sum of the wages category |
| Rent and utilities | Sum of those categories |
| Other expenses | Maintenance, marketing, commissions and the rest |
| Net profit | Sales − everything above |
To total one category in one month, use SUMIFS. Ingredient purchases in October, for example:
=SUMIFS(Expenses!D:D, Expenses!B:B, "Ingredients", Expenses!A:A, ">="&DATE(2026,10,1), Expenses!A:A, "<"&DATE(2026,11,1))
Why isn’t food cost just purchases? Because you can buy a large order at the end of one month and use it during the next. Count purchases alone and this month looks like a loss while next month looks like a windfall, when in truth they were the same. Opening stock + purchases − closing stock measures what was actually used.
Add three ratios under the summary:
- Food cost percentage = food cost ÷ sales. See food cost percentage.
- Labour percentage = wages ÷ sales.
- Prime cost = (food cost + wages) ÷ sales — the most important number in the business. More in prime cost.
To know how much you need to sell just to stop losing money, continue with your break-even point.
Five rules that keep the sheet honest
- Fill it in daily, not at month end. A sheet filled in from memory produces numbers from memory.
- A piece of paper for every expense. An invoice, a receipt, or at least a note with the amount and the reason. Expenses without paper get forgotten.
- Close the drawer every shift, and record the cash that was counted, not the cash that should have been there. See cashier shifts and the day-end count.
- The restaurant’s money is not your money. What you take from the drawer for yourself is not an expense; it is an owner’s drawing, on its own line. Mix them and net profit looks lower than it is, with no way to tell why.
- One copy. One file, in one place, owned by one person. “Accounts FINAL v2 (edited).xlsx” is the beginning of a problem.
What the sheet cannot tell you
Even built properly, a spreadsheet will never know:
- What each dish earns. That needs a recipe for every item and a price for every ingredient.
- Whether every order was rung up. The sheet holds the number someone reported, not the orders that happened.
- What stock you should have right now, without counting it.
- Each site’s own profit, when branches buy from the same supplier and pay from the same cash.
When Excel becomes a risk
If two of these are true, the spreadsheet has become smaller than your restaurant:
- More than one person edits the file, and there is now more than one version of it.
- You have opened, or are planning, a second site.
- Sales figures are copied from the till’s paper report after closing — with no way to know if a bill disappeared before it was copied.
- You spend more than two hours a week moving numbers from one place to another.
- You need correct tax invoices on every order. See tax and service charge on a restaurant bill.
- You cannot answer “how much does this dish make me?” or “where did the missing money go?”
The difference between a sheet and a system
It is not the look or the charts. A spreadsheet records what someone said happened; a system records what happened, when it happened. The sale is recorded by the till the moment it is made, with its payment method, the ingredients are deducted from the recipe, and nobody copies a number from paper to a sheet.
Moving to GoSufra without throwing the sheet away on day one
You don’t have to move everything at once:
- Start the 7-day free trial on Starter. It includes the POS, inventory, recipes and suppliers for one site. Sales are recorded automatically by payment method, and food cost comes from recipes and stock — so the daily sales tab is no longer needed.
- Keep fixed costs in the sheet — rent, utilities, wages — until you need full accounts.
- When you grow, restaurant accounting on the paid plans writes the entries for you: every sale, refund, purchase, wage and expense posts its own journal entry as it happens, with a chart of accounts, a trial balance and a profit and loss report. See books that post themselves, and current prices on the pricing page.
The short version
If your restaurant is small and on one site, build these four tabs and fill them in every day; they will tell you the truth about your profit. When you find yourself spending more time copying numbers than reading them, or you are opening a second site, it is time for a system to do the recording for you.
Run all of this from one system
POS, kitchen, inventory, recipe costing, staff and accounting — connected, and free to start.
Create your free account