Coffee Shop Business Spreadsheet

One finished workbook that runs the money side of your cafe: daily till sales, menu prices, bean stock, staff costs and profit, all adding themselves up across 7 tabs. The Dashboard shows any month on one screen — sales, card and cash, drinks and food, labor, expenses and net profit. Daily Sales logs every day's till with transactions and average sale. Menu & Prices holds your menu with price, cost and margin per item. Inventory tracks beans, milk and perishables with a REORDER flag when something runs low. Staff Schedule & Costs figures shift costs and the monthly labor total from hours and rates; Expenses logs rent, supplies and utilities by month. Start typing, and totals figure themselves out.

The workbook arrives loaded with one fictional sample month: 30 trading days, $19,915.00 total sales ($14,587.00 drinks, $5,328.00 food), $9,835.00 labor, $8,460.25 expenses, net profit +$1,619.75 — watch the formulas work, then delete the sample rows; the formulas stay.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and the sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.