Restaurant Cash Flow Template

Start with the Weekly Cash Flow sheet. Download the file, open it in Excel or Google Sheets, and enter your current bank balance in the starting cash cell. Then fill in your expected cash inflows for the next 13 weeks: projected weekly sales by revenue type (dine-in, takeout, delivery, catering, alcohol), estimated catering deposits, and any other income. Use your last 4-8 weeks of POS reports as a baseline — most operators complete the inflow side in about 20 minutes. Then fill in the outflow side using your accounts payable aging and payroll schedule.

Set up the Vendor Payment Schedule with your regular supplier obligations. List each vendor, the typical invoice amount, and their payment terms. This usually takes 15-20 minutes if you have your accounts payable list handy. Once the vendor schedule is complete, the Weekly Cash Flow sheet picks up those cash-out totals automatically. Pay special attention to weeks where multiple large invoices fall due at the same time — your broadline food distributor, your beverage vendor, and your linen service may all invoice on similar cycles, creating a predictable cash crunch midmonth.

Review the cash flow projection every week. Update last week's actuals, roll the 13-week window forward, and check whether your ending cash balance stays above your minimum comfort level. For most full-service restaurants, that's at least 2-4 weeks of operating expenses. The Seasonality Planner is worth updating quarterly: as you move into a slower period, adjust your revenue assumptions downward and check whether your current cash reserve will carry you through. Operators who run this projection consistently say it takes about 15 minutes per week and eliminates most of the end-of-month financial surprises.

Restaurants fail financially not because they're unprofitable — they fail because they run out of cash. The timing mismatch is built into the industry: customers pay immediately, but food costs arrive as invoices due in 7-30 days, payroll runs weekly or bi-weekly, and rent hits on the first of the month. Add a slow week from bad weather or a road construction project cutting foot traffic, and an otherwise healthy restaurant can find itself unable to make payroll — even with a packed calendar of reservations for the following weekend.

The cash dynamics that matter most in restaurants are different from the line items on your P&L. Credit card settlements take 1-3 business days to hit your account, which means a Friday night dinner rush doesn't fund Monday's produce delivery. Food distributor invoices often cluster mid-month, creating a predictable cash trough. Seasonal revenue swings can reach 30-40% between peak and slow months for many concepts — a restaurant that's flush in December may be genuinely tight in February. A proper cash flow view surfaces all of this, while a P&L or budget spreadsheet alone cannot.

The right way to use a cash flow template is as a weekly planning tool, not an after-the-fact record. Plug in your expected sales for the next 13 weeks based on recent POS data, enter your known upcoming expenses, and look at where your ending cash balance gets thin. Then you have 3-6 weeks to act: negotiate a payment extension with a vendor, draw on your line of credit before the rate changes, push out a discretionary equipment purchase, or accelerate a catering deposit collection. Restaurants that manage cash this way don't just survive slow periods — they build the reserves to take advantage of opportunities when they come up.