By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Updated November 2026.
Most restaurant owners see their numbers three weeks after the month ends, when it is too late to fix anything. Good bookkeeping is not about tax season. It is a short routine, done daily, weekly and monthly, that tells you what you sold, what it cost and where the cash went while you can still act on it. This guide lays out that routine for an independent restaurant or bar, with a chart of accounts, a free daily reconciliation calculator and a month end checklist. It is operating guidance, not tax advice, so confirm tax questions with your accountant.
Why restaurant books are different
- Hundreds of small transactions a day. Sales arrive as cards, cash, gift cards, delivery apps and house accounts, and each one settles on a different day.
- Inventory turns in days. Food bought on Tuesday is sold by Friday, so cost of goods has to be measured with counts, not just invoices.
- Tips pass through. A large share of the money in the drawer and in the card batch belongs to employees, not to the business.
- Sales tax passes through too. It is collected every day and owed every month or quarter.
- Margins are thin. A two point miss on food or labor is the whole profit, which is why the numbers are needed weekly.
Set up: method, periods and bank accounts
- Cash or accrual. Cash basis records money when it moves. Accrual records sales when earned and costs when incurred. Whatever you file taxes on, run your management numbers on an accrual footing: count the invoice in the week the food arrived and the payroll in the week it was worked. Otherwise a week with two food payments looks like a disaster and the next looks like a triumph.
- Weekly periods. Restaurants live by the week. Many use thirteen four week periods a year, or a 4-4-5 calendar, so every period has the same number of Fridays and Saturdays. A calendar month works too, as long as you also look at weekly prime cost.
- Separate bank accounts. One operating account, one payroll account if your processor allows it, and one savings account for sales tax. Never mix personal spending into the business account.
- One place for documents. A folder for each week holding the daily reports, batch slips, deposit slips and invoices. Paper or scanned, the rule is the same.
A restaurant chart of accounts
The chart of accounts is the list of categories every transaction goes into. Set it up to match how a restaurant P&L is read, with sales and cost of goods split the same way, so each cost can be compared with the sales it supports.
| Group | Accounts | Why it is split this way |
| Sales | Food, liquor, beer, wine, non alcoholic beverages, catering and events, merchandise | So food cost is measured against food sales and pour cost against bar sales. |
| Not sales | Sales tax collected, tips collected, gift cards sold, deposits taken | These are liabilities. Money you hold for someone else. |
| Cost of goods sold | Food, liquor, beer, wine, non alcoholic beverages, paper and packaging | Mirrors the sales lines. |
| Labor | Management salaries, hourly front of house, hourly kitchen, payroll taxes, benefits and workers' compensation | So total labor includes taxes and benefits, not just wages. |
| Controllable expenses | Direct operating supplies, repairs and maintenance, utilities, marketing, music and entertainment, card processing fees, general and administrative | The costs a manager can move. |
| Occupancy and other | Rent, common area charges, property tax, insurance, depreciation, interest | Fixed costs, kept below the line a manager is judged on. |
Cost of goods sold plus total labor is prime cost, the number that matters most week to week. The prime cost guide explains the targets and the restaurant P&L guide walks through each line.
Daily: the sales report and the cash count
The daily sales report is the foundation of the books. It takes ten minutes at close and answers one question: does the money we can prove we received match what the POS says we sold?
- Print the POS end of day report: net sales by category, tax, comps, voids, discounts, tips and payments by type.
- Settle the card batch and attach the slip.
- Count each drawer down to its starting bank, with two people present.
- List paid outs with a receipt for each one.
- Work out the expected cash and compare it with the count.
- Record the over or short, sign it and drop the deposit.
- Enter the day in the books: sales by category, tax, tips, gift cards and each payment type.
Expected cash = net sales + sales tax + gift cards sold, less card sales, gift cards redeemed, paid outs and tips paid out in cash
Free calculator
Daily sales reconciliation calculator
Enter the numbers from tonight's POS report and the cash count. An example day is loaded. If card tips go on payroll instead of being paid in cash at close, enter 0 for tips paid out.
Total to account for-
Cash sales-
Expected cash deposit-
Over or short-
A simple model for one day. House accounts, delivery app sales and deposits applied work the same way: subtract anything that was not paid in cash.
Small overs and shorts are normal. A pattern is not. Track the over or short by drawer and by person, and look into any drawer that is short several times in a month. Write unusual days in the manager log.
Keep the books in one workbook
The Restaurant Bookkeeping Spreadsheet logs income and expenses as they happen and builds a monthly summary, a dashboard and an annual view for your accountant, with a sales tax and reconciliation tracker. The Daily Sales Report handles the nightly cash count. Excel and Google Sheets, one time purchase.
See the Bookkeeping SpreadsheetDaily Sales Report
Weekly: invoices, payroll and prime cost
- Enter every invoice. Code each one to the right cost line: food, liquor, beer, wine, paper, supplies or repairs. One invoice from a broadline distributor often belongs in three accounts.
- Chase credits. Shorts, returns and price errors noted at receiving should come back as credit memos. Keep a list and check it off. The Invoice and Vendor Credit Tracker does this.
- Match statements. Compare each vendor statement with the invoices you hold before you pay it.
- Record payroll in full. Gross wages by department, plus employer payroll taxes and benefits. Net pay alone understates labor.
- Count inventory. A weekly count of food and bar stock turns purchases into a true cost of goods. The restaurant inventory guide shows the method.
- Calculate prime cost. Cost of goods sold plus total labor, divided by sales, every week. The prime cost calculator does the math.
Cost of goods sold = beginning inventory + purchases, less ending inventory
Monthly: the close
Aim to close the month within ten days. A P&L that arrives on the 25th describes a restaurant that no longer exists.
- Reconcile every bank accountMatch each deposit to a daily report and each payment to an invoice or payroll run. Unexplained items are where theft and errors hide.
- Reconcile card deposits and delivery appsCard batches should equal bank deposits after fees. Delivery app payouts should equal reported sales less commissions, which go to their own expense line.
- Post the inventory adjustmentUse the month end count so cost of goods reflects what was used, not what was bought.
- Accrue what is owedInvoices received but not paid, payroll worked but not yet paid, and utilities for the month.
- Check the liabilitiesSales tax payable, tips payable, gift cards outstanding and event deposits should each tie to a report.
- Read the P&L against budgetCompare each line with the budget and with last year, as a percent of sales. Write down the three biggest gaps and the action for each.
The restaurant budget guide covers building the budget you compare against, and the year end inventory guide covers the count that matters most for taxes.
Tips and service charges
Tips are the part of restaurant bookkeeping most likely to cause trouble, because the money is not yours and the rules are specific.
- Tips are not sales. Card tips come in with the batch and go out to employees. Record them as a liability until they are paid, never as income.
- Employees report tips to you. Under IRS rules, an employee who receives $20 or more in tips in a month must report them to the employer, and the employer withholds and pays payroll taxes on them (IRS). Most POS and payroll systems capture this at clock out.
- Larger operations file Form 8027. An employer that runs a large food or beverage establishment, meaning tipping is customary and it normally had more than 10 employees on a typical business day in the prior year, files Form 8027 each year to report receipts and tips (IRS Form 8027 instructions).
- Service charges are not tips. An automatic gratuity or service charge added by the house is revenue to the business, and what you pay staff from it is wages. Keep it on its own sales line.
- Ask about the tip credit. Employers may qualify for a federal tax credit for Social Security and Medicare taxes paid on certain employee tips, claimed on Form 8846. Ask your accountant whether it applies to you.
For who can share in a tip pool and how to run one, see the tip pooling and labor law guide and the free tip pool calculator.
Sales tax
Sales tax is collected from guests on behalf of the state, and in most states the owner is personally responsible for it. Treat it as money that was never yours.
- Record it separately from sales every day, straight from the POS report.
- Move it to a separate savings account weekly, so the cash is there when the return is due.
- Know what is taxable where you are. Rules for alcohol, takeout, delivery fees, service charges and catering differ by state and sometimes by city.
- File on time even in a bad month. Penalties on sales tax are steep, and falling behind on it closes restaurants.
What to keep and for how long
The IRS does not require a particular bookkeeping system, only one that clearly shows income and expenses, and says to keep records as long as they are needed to support a tax return. It says to keep employment tax records for at least four years (IRS recordkeeping). States can require longer, so ask your accountant for one retention rule that covers federal and state together.
| Record | What to keep |
| Sales | Daily POS reports, batch slips, deposit slips, over and short log |
| Purchases | Invoices, credit memos, vendor statements, receipts for paid outs |
| Payroll and tips | Time records, pay registers, tip reports, tip pool sheets, tax filings |
| Banking | Statements and reconciliations for every account |
| Inventory | Count sheets with dates, prices and who counted |
| Assets and contracts | Equipment purchases, leases, loan documents, licenses and insurance policies |
Spreadsheet, software or a bookkeeper
- A spreadsheet is enough for a single small restaurant, cafe, food truck or bar with simple payroll, as long as someone enters it every day.
- Accounting software earns its cost when you have many vendors, more than one location or a lender who wants formal statements. Our comparison of a P&L spreadsheet and accounting software has current prices.
- A bookkeeper or accountant who knows restaurants is worth paying for the monthly close and for taxes. You still own the daily report and the weekly prime cost. Those cannot be outsourced, because they are how you run the place.
Mistakes that wreck restaurant books
- Booking the bank deposit as sales. Deposits are net of card fees and include tips and tax. Sales come from the POS report.
- Counting tips or sales tax as income. It inflates sales and hides what you owe.
- One line for all cost of goods. You cannot fix food cost if it is blended with liquor.
- No inventory count. Without one, cost of goods is just purchases, and it swings with the delivery schedule.
- Paid outs with no receipt. Cash from the drawer with no paper is the easiest money to lose.
- Recording net payroll. Labor is gross wages plus employer taxes and benefits.
- Gift cards booked as sales when sold. They are a liability until redeemed.
- Closing late. Numbers a month old change nothing.
Sources and further reading: IRS recordkeeping for small businesses; IRS tip recordkeeping and reporting; IRS instructions for Form 8027. This guide is general information, not tax or legal advice. Sales tax and payroll rules vary by state.
FAQ
How do you do bookkeeping for a restaurant?
Run three routines. Daily, reconcile the POS report to the card batch and the cash count and record sales by category. Weekly, enter and code invoices, record payroll, count inventory and calculate prime cost. Monthly, reconcile the bank accounts, post the inventory adjustment and read the P&L against budget.
What is a daily sales report?
A one page record of each day: net sales by category, sales tax, tips, comps and voids, each payment type, paid outs, the cash count and the over or short. It ties what the POS says was sold to the money actually received.
Should a restaurant use cash or accrual accounting?
For managing the business, use an accrual footing, so costs land in the week they were incurred and each week can be compared with the last. Which method you use for taxes is a separate question for your accountant.
Are tips counted as restaurant revenue?
No. Tips belong to employees. Card tips are a liability until paid out. A service charge the house adds automatically is different: it is revenue to the business, and what staff receive from it is wages.
How long should a restaurant keep its records?
The IRS says to keep records as long as needed to support a tax return, and to keep employment tax records for at least four years. State rules can be longer, so set one retention period with your accountant that covers both.
Can I do restaurant bookkeeping in Excel?
Yes, for a single small operation with simple payroll, if it is updated daily. Many owners keep the daily and weekly numbers in a spreadsheet and have an accountant handle the monthly close and taxes.
Keep reading