· Orqestra Team · 8 min read
How to Track Restaurant Expenses: A Weekly Routine
How to track restaurant expenses with one weekly routine: capture each receipt the day it arrives, code it, log it, reconcile to the bank, review vs sales.
To track restaurant expenses, capture every receipt and invoice the day it arrives (a phone photo is enough), code it to a category, record the vendor, date, amount and how it was paid, reconcile the log against the bank once a week, and compare category totals to sales once a month. That is the whole system. The hard part is doing it every week, so this article turns it into a fixed routine with a log layout, a worked week, and the tools that fit each size of restaurant.
Why daily capture and weekly reconciliation
Expenses go missing in two places: the receipt that never got photographed, and the invoice that sat in a drawer until the month closed. Both lead to the same result, a P&L that understates costs and overstates profit until the bank balance says otherwise.
The IRS sets the floor for what you need to keep. Its guidance on what kind of records to keep says supporting documents should identify the payee, the amount paid, proof of payment, the date incurred, and a description of what was bought. Electronic records are fine as long as they meet the same standard. Publication 463 adds that documentary evidence is generally required, with an exception for expenses other than lodging under $75, and that a receipt is adequate when it shows the amount, date, place, and essential character of the expense. The IRS also says to keep records for at least three years in the normal case, and employment tax records for at least four. A photo of the receipt coded to a category meets all of that.
Weekly reconciliation is the check that nothing slipped. Wave's guide to receipts, categories and reconciliation recommends weekly reconciliation for high-volume businesses that take daily card payments and pay many vendor invoices, which describes every restaurant. The same guide lists the discrepancies you will find most often: timing differences, duplicate entries from a manual entry plus a bank feed import, unrecorded merchant card fees, and data entry errors.
The weekly routine in 7 steps
- Capture the same day. When a delivery invoice, a receipt, or an emailed bill arrives, photograph it or save the PDF before it goes anywhere else. If a manager pays for something, the rule is no photo, no reimbursement.
- Code it to a category. Use the same list every time: food, beverage, liquor, paper, labor, rent and CAM, utilities, repairs, supplies, marketing, software, card fees, delivery commissions, licenses, professional fees. The full list, grouped the way a P&L reads, is in restaurant expense categories.
- Log vendor, date, amount, and paid-with. Paid-with matters as much as the amount. "Company card", "bank ACH", "check 1042", "cash from drawer", "owner personal card" each reconcile to a different place.
- Mark whether the receipt is attached. A yes/no column. Anything marked no gets chased before the week closes.
- Reconcile to the bank every week. Open the bank and card statements. Every line on the statement should match a log entry, and every log entry marked paid should appear on a statement or in the cash drawer count. Work through the unmatched items: usually a card fee, a subscription renewal, or a bill paid twice.
- Chase the gaps. Unpaid invoices get a due date. Missing receipts get a reminder to whoever paid. Owner-paid items get a reimbursement entry so the expense lands in the business books.
- Review categories against sales monthly. Total each category for the month, divide by net sales, and compare to last month and to your targets. Prime cost (food plus beverage plus labor) and occupancy are the two ratios to watch first.
Steps 1 to 4 take a few minutes a day. Step 5 takes about an hour a week for a single location. Step 7 is a monthly hour that tells you whether the other steps were worth it.
A simple tracking log layout
Whatever tool you use, the log needs these columns and nothing else to start.
| Date | Vendor | Category | Amount | Paid with | Receipt? | Note |
|---|---|---|---|---|---|---|
| 2026-10-19 | Broadline distributor | Food | $4,120.00 | Bank ACH | Yes | Weekly delivery, invoice 88213 |
| 2026-10-19 | Local produce | Food | $860.00 | Company card | Yes | |
| 2026-10-20 | Beer and wine distributor | Liquor, beer, wine | $640.00 | Check 1042 | Yes | |
| 2026-10-20 | Packaging supplier | Paper and packaging | $310.00 | Company card | Yes | To-go containers |
| 2026-10-21 | Payroll service | Labor: wages | $6,300.00 | Bank ACH | Statement | Week ending 10-18 |
| 2026-10-21 | Payroll service | Labor: employer taxes | $560.00 | Bank ACH | Statement | |
| 2026-10-22 | Electric utility | Utilities | $470.00 | Autopay | Yes | |
| 2026-10-22 | Hood cleaning service | Repairs and maintenance | $350.00 | Check 1043 | Yes | Quarterly |
| 2026-10-23 | Card processor | Card processing fees | $560.00 | Bank debit | Statement | Weekly fee settlement |
| 2026-10-23 | Hardware store | Supplies | $48.00 | Owner personal card | Yes | Reimburse owner |
| 2026-10-24 | Delivery marketplace | Delivery commissions | $410.00 | Netted from payout | Statement | Weekly payout report |
| 2026-10-24 | Linen service | Linens and uniforms | $190.00 | Autopay | Yes |
Add a column for "Paid?" and "Due date" once you have vendors on terms. Resist adding more. A log with twenty columns gets filled in late or not at all.
Entries that are not a single receipt, such as the payroll run, the card processor's fee settlement, and the delivery marketplace's netted commission, are coded from the statement or payout report, with "Statement" in the receipt column so you know where the backup lives.
Worked example: one week's expenses against sales
The log above is one week at a single-location restaurant that did $21,500 in net sales that week, roughly a $93,000 month. Rent of $5,600 is paid monthly and is not in this week's log. Totals by category:
| Category | Weekly total | Percent of weekly sales |
|---|---|---|
| Food | $4,980.00 | 23.2% |
| Liquor, beer, wine | $640.00 | 3.0% |
| Paper and packaging | $310.00 | 1.4% |
| COGS total | $5,930.00 | 27.6% |
| Labor (wages and employer taxes) | $6,860.00 | 31.9% |
| Prime cost (COGS plus labor) | $12,790.00 | 59.5% |
| Utilities | $470.00 | 2.2% |
| Repairs and maintenance | $350.00 | 1.6% |
| Card processing fees | $560.00 | 2.6% |
| Supplies | $48.00 | 0.2% |
| Delivery commissions | $410.00 | 1.9% |
| Linens and uniforms | $190.00 | 0.9% |
| Total logged this week | $14,818.00 | 68.9% |
Two cautions on reading it. First, weekly food purchases are not weekly food cost. If the walk-in was stocked up on Monday for a holiday weekend, this week's purchases run high and next week's run low; true food cost needs a beginning and ending inventory count. Over a month the purchase figure is a usable proxy, over a week it is a signal. Second, monthly bills (rent, insurance, software) are missing from a weekly view. To see the full picture, add one twelfth of the annual amount or one quarter of the monthly amount as a memo line.
What the owner learns from this week: prime cost at 59.5 percent is on target, card fees at 2.6 percent of sales are worth a call to the processor, and the $48 owner-paid hardware run is small but needs a reimbursement entry or it never reaches the books. Compare the week's sales to the week's log using a daily sales report template so the sales number is the same one the POS reported.
Tools: spreadsheet, accounting software, or a restaurant tool
| Option | What it does well | Where it falls short | Fits best |
|---|---|---|---|
| Spreadsheet | Free, flexible, the log above is one sheet | Receipts live somewhere else; no bank feed, so reconciliation is manual; totals break when someone edits a formula | Under about 40 bills a month, one person doing the books |
| General accounting software | Bank feeds, reconciliation built in, tax-ready reports, accountant access | Default categories are generic until you set up a restaurant chart of accounts; receipt capture varies by product and plan | Any restaurant whose accountant works in it already |
| Restaurant-specific expense tools | Receipt photo capture, restaurant categories out of the box, vendor and bill tracking, "paid with" and reimbursement handling, usually alongside sales data from the POS | Not a general ledger; you still need accounting software or an accountant for tax filing | Owners who want the daily capture and weekly review in one place and the accountant to handle the rest |
The options are not exclusive. A common setup is a restaurant tool for daily capture and category review, feeding monthly totals to the accountant's software. The expenses and bills feature in Orqestra is an example of the third column: receipt capture with a paid-with field and reimbursements, sitting next to the POS sales data, and it does not replace your accountant's ledger.
Once the categories are consistent, the same weekly totals become the disbursement rows of a 13-week cash flow forecast, which is where expense tracking starts paying for itself.
Common mistakes
- Mixing personal and business cards. The owner's personal card pays for a produce run, the receipt is lost, and the expense never reaches the books. If it happens, log it with "Owner personal card" and record a reimbursement the same week.
- Missing reimbursements. Managers who pay out of pocket and are not paid back promptly stop asking for receipts. Pay reimbursements on a fixed day each week.
- Entering invoices when they are paid instead of when they arrive. A vendor on 14-day terms whose invoice is logged at payment shows up in the wrong month and makes the current month look better than it is.
- No "paid with" column. You cannot reconcile a log that does not say which account the money left.
- Reconciling monthly. Four weeks of unmatched card fees, duplicate entries and a bounced vendor payment take an afternoon to untangle. One week's worth takes an hour.
- Netting card fees and delivery commissions out of sales. Sales stop matching the POS and two of the fastest-growing cost lines disappear.
- Treating weekly purchases as food cost. Purchases swing with delivery timing. Count inventory at month end before you react to a high food cost week.
- Keeping paper receipts in a box. Thermal receipts fade. Photograph them the day they arrive and keep the images with the log entry for at least three years.