Restaurant bookkeeping is three routines. Every day: write down what the till says was sold, split out the sales tax and the tips that passed through it, and check the cash in the drawer against what should be there. Every week: count the stock, add up what was bought and what the hours cost, and work out what the food and the labor took out of each dollar of sales. Every month: match the bank statement to the daily sheets and hand the lot to whoever does the accounts. None of it is accounting. It's the record an accountant, a lender or a tax office will ask for, kept while the day is still fresh. Below is a week for a made-up 40-seat restaurant, each routine, and the file. What you owe in sales tax and on tips, and when, is for your State's rules and your accountant.
The short version
- A row for each day open, from the till's end-of-day report.
- Food and drink are sales. Sales tax and tips are not.
- Cash to deposit = total taken − card payments − tips paid out.
- Write every over and short, with a reason if you find one.
- Count stock on the same night each week.
- Cost of goods used = opening stock + purchases − closing stock.
- TaroStack keeps the stock side: counts, receiving at cost, stock value. More below.
The daily sheet
| Date | Food | Drink | Sales tax | Tips on cards | Total taken | Card payments | Cash expected | Tips paid out | Cash to deposit | Cash counted | Over or short |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Nov 10 | $1,850.00 | $620.00 | $197.60 | $310.00 | $2,977.60 | $2,540.00 | $437.60 | $310.00 | $127.60 | $127.60 | $0.00 |
| Nov 11 | $2,100.00 | $700.00 | $224.00 | $365.00 | $3,389.00 | $2,905.00 | $484.00 | $365.00 | $119.00 | $114.00 | −$5.00 |
| Nov 12 | $2,400.00 | $860.00 | $260.80 | $430.00 | $3,950.80 | $3,410.00 | $540.80 | $430.00 | $110.80 | $110.80 | $0.00 |
| Nov 13 | $3,900.00 | $1,650.00 | $444.00 | $760.00 | $6,754.00 | $5,930.00 | $824.00 | $760.00 | $64.00 | $84.00 | $20.00 |
| Nov 14 | $4,300.00 | $1,900.00 | $496.00 | $850.00 | $7,546.00 | $6,480.00 | $1,066.00 | $850.00 | $216.00 | $216.00 | $0.00 |
| Nov 15 | $2,650.00 | $780.00 | $274.40 | $420.00 | $4,124.40 | $3,560.00 | $564.40 | $420.00 | $144.40 | $144.40 | $0.00 |
This restaurant is closed on Mondays and pays its servers their card tips in cash each night. Its sales tax rate in the example is 8%.
Two columns aren't yours. The till took $28,741.80 in the week. $1,896.80 of it is sales tax, held for the State. $3,135.00 is tips, which belong to the staff. The restaurant's sales are the food and the drink: $23,710.00. A restaurant that thinks it sold $28,741.80 has spent money that was never its own.
Cash. Total taken, less what came in on cards, is the cash that should be in the drawer. Less the tips paid out, it's the cash to deposit. On Friday the count was $20.00 over, and the note says why: a gift card sold for cash and not rung up. On Wednesday it was $5.00 short, with no reason found. Both are written down. A drawer that's short by a little every Wednesday is a pattern only the sheet can show.
A fuller version of the day's row, with refunds and a count of sales, is in daily sales report template.
The week
| Week ending | Sales, food and drink | Opening stock | Purchases | Closing stock | Cost of goods used | Labor, with payroll taxes | Prime cost | Of sales |
|---|---|---|---|---|---|---|---|---|
| Nov 15 | $23,710.00 | $6,200.00 | $7,450.00 | $6,050.00 | $7,600.00 | $7,350.00 | $14,950.00 | 63.1% |
Cost of goods used is the stock you started with, plus what you bought, less what's left: $6,200.00 + $7,450.00 − $6,050.00 = $7,600.00. That's 32.1% of sales. It needs a count, on the same night each week, at what things cost. Purchases alone would say $7,450.00, and they'd be wrong by whatever the stock rose or fell.
Labor is wages with payroll taxes: $7,350.00, 31.0%.
Prime cost is the two together: $14,950.00, 63.1% of sales. That leaves $8,760.00 of the week for rent, power, card fees, repairs and the owner. The formula and what moves it are in prime cost formula. What a food cost percentage should be for a given kitchen is in what is a good food cost percentage.
The month
- Match the bank. Each day's card payments and each deposit should appear on the statement. Tick them off. What's left unticked on either side is a question.
- File the sales tax from the daily sheets' tax column, on the schedule your State sets.
- Close the stock. The month's opening and closing counts give the month's cost of goods used.
- Read the profit and loss. See restaurant profit and loss template.
What to hand the accountant
The daily sheets. The bank and card processor statements. Every supplier invoice, in date order. The payroll reports. The stock counts, with values. With those five, the year's accounts are assembly. Without the daily sheets, they're archaeology.
Get the sheet
Download the restaurant bookkeeping sheet. Two sheets and a read-me: a daily sheet that works out the total taken, the cash expected, the cash to deposit and the over or short, and a weekly page for sales, stock, purchases, labor and prime cost. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The daily sheet takes five minutes, and it gets done. The weekly page depends on a stock count valued at cost, and that's an hour with a clipboard followed by an evening of looking up prices on old invoices. So the count slips to monthly, then to whenever the accountant asks. Without it the food cost is a guess built on purchases, and a walk-in that's slowly filling up, or emptying faster than sales explain, goes unseen.
How TaroStack does it
TaroStack keeps the stock half of the books.
Counting works on a phone with no signal, in the walk-in. A count shows what each difference is worth before you post it.
Receiving records what arrived and what it cost, so every item's value comes from what you paid.
Stock value by month, for the opening and closing figures.
Every adjustment carries a reason: spoiled, dropped, staff meal. Waste adds up to a number.
A price-creep report by supplier shows which costs went up.
| The weekly job | Clipboard | In TaroStack |
|---|---|---|
| Count the walk-in | Paper, then typing | On a phone |
| Value the count | Look up invoices | From what you paid |
| Opening and closing stock | Last week's page | Stock value by month |
| What was thrown away | Not recorded | Adjustments by reason |
TaroStack isn't a bookkeeping system: it doesn't record sales tax, tips or payroll, or reconcile a bank account. Every list exports to CSV for whoever keeps the books. Stock, counts and receiving are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
