How do I track food costs and inventory for my restaurant?
Food cost tracking starts with consistent inventory counts. Most restaurants do this weekly, counting everything in the walk-in, freezer, dry storage, and bar. The count gives you your ending inventory value, which you need to calculate actual food costs for the period.
The basic formula is beginning inventory plus purchases minus ending inventory equals cost of goods sold. Divide that by your food sales and you get your food cost percentage. For most restaurants, this should land between 28% and 35% depending on your concept and pricing. If you’re outside that range, something needs attention.
Purchases need to be tracked by category. Separate food from beverages from paper goods and cleaning supplies. Your POS system should track sales by similar categories so you can compare costs to revenue in each area. If your bar shows a 35% pour cost when it should be 20%, you know where to look for problems.
Physical counts need to connect to your accounting records. Weekly counts inform operations, but monthly counts tie out to your books. The ending inventory value on your balance sheet should match what you actually counted, valued at cost. If those numbers don’t match, something is wrong with either the count or the accounting. Working with restaurant accounting professionals helps ensure the operations side and financial side stay aligned.
Variance analysis catches problems early. If your theoretical food cost based on recipes and sales mix says you should be at 30% but actual costs are running 36%, that 6% gap is real money. It could be waste, theft, over-portioning, pricing errors, or invoicing mistakes. You can’t fix what you don’t measure.
For the tracking itself, some restaurants use spreadsheets while others use dedicated inventory software like MarketMan or BlueCart that integrate with accounting systems. The tool matters less than the consistency. A simple spreadsheet updated weekly beats sophisticated software used sporadically.
The setup matters as much as the ongoing tracking. Your chart of accounts should have proper categories for food costs, your POS and purchasing data should flow into your books cleanly, and your inventory valuations need to reconcile each month. Greater Boston bookkeepers who understand restaurant operations can help you build these systems so you get reports that actually tell you where you’re making or losing money.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What are the economic nexus thresholds by state?
Most states set the threshold at $100,000 in sales or 200 transactions per year. Once you exceed either number in a state, you're required to register, collect sales tax, and remit it regardless of whether you have a physical presence there.
Read answerShould I start over with new books or fix my existing records?
In most cases, fixing your existing records is the better choice. Starting over sounds appealing but doesn't erase tax obligations or the need for historical documentation. The right answer depends on how far behind you are and what's actually wrong.
Read answerWhat financial reports do investors want to see from startups?
Investors expect to see your income statement, balance sheet, and cash flow statement along with burn rate and runway calculations. They also want key metrics specific to your business model and projections showing how you'll use their capital.
Read answerWhat is a fractional CFO and does my business need one?
A fractional CFO is a part-time Chief Financial Officer who provides strategic financial leadership without the full-time salary. You might need one if your business is growing but you lack clarity on profitability or cash flow.
Read answerWhat tax deductions are available for healthcare practices?
Healthcare practices can deduct most operating expenses including medical equipment, clinical supplies, staff wages, rent, insurance, and professional services. The key is tracking everything properly and knowing which industry-specific deductions apply to your practice type.
Read answerShould I migrate from QuickBooks Desktop to QuickBooks Online?
It depends on how you work and what features you rely on. QuickBooks Online offers cloud access and easier collaboration, while Desktop provides more robust tools for inventory and job costing.
Read answer

