Coffee Shop Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets — no plugins required. Start with the 13-Week Cash Flow sheet. The inflow categories are pre-loaded: espresso and specialty drinks, drip coffee, food and pastry, wholesale, and catering. Review the outflow categories — bean orders, dairy, labor, rent — and adjust any that don't match your shop's structure. If you buy beans weekly from a local roaster and pay rent on the 1st, log those in the correct week columns. The first pass takes about 20 minutes once you have your last bank statement open.

Once the categories are set, enter your projected cash inflows and outflows for the next 13 weeks. Don't worry about exact precision on the first pass — use your average daily sales from your POS and your known payment dates for suppliers and payroll. The ending balance row will show you when your cash position gets tight. If a week shows a near-zero or negative balance, you can plan around it: hold off on a large bean order, draw on your line of credit, or push a supplier payment by a few days.

Come back each week and update the Variance Tracker with your actual numbers. This is where the template earns its keep — if your beverage COGS are higher than expected because you switched to oat milk for most drinks, you'll see it immediately in the variance column. Most café operators who build this habit say the weekly check-in takes under 10 minutes and gives them confidence to make purchasing and staffing decisions without guessing at their cash position.

Coffee shops run on thin margins and uneven cash timing. A shop doing $500,000 in annual revenue might net 5–10% after all costs — but the much bigger problem is that bean invoices, payroll, and rent all hit at different times, and a slow Monday followed by a machine repair can leave you scrambling by Friday. Most café owners focus on sales per day and beverage cost percentage, but those numbers don't tell you whether you have enough cash to cover payroll next week. Cash flow does.

The specific cash flow patterns of a coffee shop are different from most retail businesses. On the inflow side, nearly all revenue is daily and POS-based — no invoices, no accounts receivable. Wholesale accounts are the exception: if you supply offices or restaurants with beans, you're extending net-30 terms and creating a timing gap between roasting costs and payment. On the outflow side, bean orders are frequent and variable (prices shift, and you adjust order volume based on the week's forecast), dairy is ordered 2–3 times per week, and payroll is the largest single outflow. Equipment repairs are lumpy and often unbudgeted — an espresso machine rebuild can run $800–$2,000 and hit with no warning.

A 13-week cash flow gives café operators the planning horizon they actually need. It's short enough that the numbers are reliable but long enough to see a slow summer month coming, plan for a holiday inventory build, or model what happens to cash if you add a barista. The workflow is simple: update actuals weekly, look at the ending balance two to four weeks out, and make one or two decisions — order more beans, delay a non-urgent expense, or draw on a line of credit — before cash gets tight. The operators who do this consistently say they sleep better than they did when they were flying blind on the POS daily sales report alone.