Skip to product information
1 of 9

InkSheet Studio

Coffee Shop Business Spreadsheet: Daily Sales, Menu Prices, Bean Inventory, Staff Costs and Profit Tracker, Google Sheets and Excel

Coffee Shop Business Spreadsheet: Daily Sales, Menu Prices, Bean Inventory, Staff Costs and Profit Tracker, Google Sheets and Excel

Regular price $2.69 USD
Regular price $9.99 USD Sale price $2.69 USD
Sale Sold out
Quantity

INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the sheet PDFs at home or at a local print shop.

Coffee Shop Business Spreadsheet - one finished workbook that runs the money side of your cafe: daily till sales, menu prices, beans and supply stock, staff scheduling costs and profit, all adding themselves up.

WHAT'S INSIDE - 7 TABS
- Start Here: plain-language guide to the whole system
- Dashboard: pick a month and see sales, card and cash, drinks and food, labor, expenses and net profit on one screen
- Daily Sales: every day's till with card and cash sales, a drinks and food split, transactions and average sale
- Menu & Prices: your full menu with the price, cost to make and margin for every item
- Inventory: beans, milk and perishables with stock value and a REORDER flag when an item runs low
- Staff Schedule & Costs: every shift with hours and hourly rate - the shift cost and monthly labor cost figure themselves out
- Expenses: rent, supplies, utilities and more, logged by month

HOW IT WORKS
Delivery is a start-here PDF (delivery.pdf) with your Google Sheets copy link, plus the same workbook as an Excel file (.xlsx) - both are included in your download. Open the Sheets link, make a copy, and start typing: totals, balances and the dashboard figure themselves out. Every formula is already in place. Prefer Excel? The .xlsx file works the same way.

ABOUT THE SAMPLE DATA
The workbook arrives loaded with one fictional sample month so you can watch every formula work before you trust it with real numbers - the photos in this listing show that real sample data, not mock-ups. Delete the sample rows whenever you are ready; the formulas stay in place.

Sample month (fictional): 30 trading days, $19,915.00 total sales, $14,587.00 drinks revenue, $5,328.00 food revenue, $9,835.00 labor cost, $8,460.25 expenses, net profit +$1,619.75 - every figure recomputed and verified against the workbook's own formulas.

This is a digital product - no physical item will be shipped. You receive finished files to download and keep. If a file ever arrives damaged or something will not open, message the shop and a fixed copy will be sent - error fixes are always free.

Transparency: this product was created with AI assistance (AI-assisted) and then finished, checked and organized by hand.

View full details