Restaurant Cash Flow Template
Cash flow template for restaurants with food cost, labor, and seasonal adjustments.
What's Included:
- Food cost percentage tracker with daily and weekly COGS calculations
- Labor cost modeling with tip credit and overtime adjustments
- Seasonal adjustment factors for holidays and slow-season months
- Daily sales and cash deposit reconciliation section
Available Formats:
Download Free Template
Enter your email to download this template instantly. We'll also send you tips on financial management.
Restaurant cash flow management is uniquely challenging because of perishable inventory, daily cash handling, and wide seasonal swings. This template addresses all three with built-in food cost tracking, daily deposit reconciliation, and seasonal adjustment factors. It is designed for independent restaurant owners who need a simple tool to stay on top of their numbers without a full accounting system.
The most impactful metric to monitor is your prime cost—food plus labor as a percentage of revenue. This template calculates it automatically each week. If your prime cost creeps above 65%, the template flags it in red so you can adjust menu pricing, reduce waste, or tighten your labor schedule before margins erode further.
How to Use This Template
Enter Your Menu Mix and Food Costs
Input your average food cost percentage and weekly inventory purchases. The template calculates COGS automatically based on your sales data.
Log Daily Sales and Deposits
At the end of each shift, enter total sales by payment type (cash, card, delivery apps) and record your bank deposit amount.
Review Weekly Profitability
Check the weekly summary to see if food cost and labor percentages are within your target ranges, and adjust staffing or menu pricing accordingly.
Frequently Asked Questions
What is a healthy food cost percentage for a restaurant?
Most restaurants target food costs between 28% and 35% of revenue, depending on the concept. Fast casual tends to be lower (25-30%), while fine dining runs higher (33-38%). This template tracks your actual food cost weekly so you can benchmark against your target.
How do I account for seasonal slowdowns in my restaurant cash flow?
Use the seasonal adjustment column to reduce your projected revenue during historically slow months. Review last year's sales data to set realistic adjustment factors—typically 10-20% below average during your slowest period.
Related Financial Resources
Tired of manual spreadsheets?
FiscalInsights automates everything this template does—plus cash flow forecasting, expense categorization, and real-time insights.
Try FiscalInsights Free