Restaurant Expense Tracking: The Complete Spreadsheet Setup Guide

Restaurant margins run 3-9% for full-service. That's not a lot of room for error. The difference between profitable and not often comes down to whether you actually track your expenses or just hope the bank account looks okay at the end of the month. A structured spreadsheet gives you visibility without the $200/month restaurant software bill.

The Big Three: Food, Labor, and Overhead

Food cost should run 28-35% of revenue depending on your concept. Labor is typically 25-35% including benefits and payroll taxes. Overhead (rent, utilities, insurance, supplies) takes another 20-30%. When you track these three categories separately as percentages of revenue, you can see immediately which one is out of line. Most operators who aren't tracking this way are surprised by at least one of these numbers.

Setting Up Your Food Cost Tracker

Record every vendor purchase. Categorize by food group. Track weekly against revenue. Your food cost percentage is total food purchases divided by food revenue. Simple formula, but a lot of operators don't calculate it until the accountant does it months later. A good template also accounts for inventory changes: beginning inventory plus purchases minus ending inventory gives you true cost of goods used, not just what you bought.

Menu Engineering with Data

This is where the real money is. Once you know your food cost per dish, plot each menu item by sales volume and contribution margin. High volume, high margin? That's a star. High volume, low margin? Raise the price or fix the recipe. Low volume, low margin? Cut it. This analysis alone can add thousands to your bottom line, and most independent restaurants never do it.

Labor Cost Management

Break labor down by role: front of house, back of house, management. Calculate it as a percentage of revenue each week. The number you really want is revenue per labor hour, because that tells you whether Tuesday's dinner shift needs four servers or three. Track overtime separately. By the time excessive overtime shows up on your P&L, you've already overspent.

Daily Sales and Cash Reconciliation

Reconcile every day. Gross sales, comps, discounts, tips, credit card fees, net deposit. It takes 10 minutes. A daily sales log that feeds into weekly and monthly summaries means you always know where you stand. One thing that surprises operators when they start tracking: credit card processing fees. At 2.5-3.5% of card transactions, that's real money.

Monthly P&L at a Glance

Everything rolls up into a monthly profit and loss statement. Revenue at the top (food, beverage, other). Expenses by category with dollar amounts and percentages. Net profit at the bottom. Compare month-over-month and against your budget. If your food cost jumped 3% in March, you want to know in April, not in August when the accountant calls.

Getting Restaurant-Specific Templates

Generic business spreadsheets don't have food cost formulas, tip reporting, inventory par levels, or menu engineering matrices. Ours do. The restaurant templates were built from actually running the numbers on restaurants, not from reading about it. Formulas are built in, sample data shows you how it works, and setup instructions walk you through customizing it for your operation.