Coffee Shop Financial Model (Spreadsheet)

Know whether your cafe survives month eight before you sign the lease.

Who this is for: people planning to open a cafe in the next 18 months, and owners running one without a real cash model. Who it is not for: shops that already have an accountant-built model; this will not tell you anything yours does not.

What is in the file:

• 12-month financial model as a CSV that imports into Google Sheets or Excel in one click
• Drinks-per-day growth curve you can set to your own assumptions
• Pre-built revenue, cost, and cash sections with the 30% COGS and 35% labor targets
• Maintenance reserve line, because espresso machines break on schedule
• The cumulative cash row, the only number that matters

The math: a bookkeeper typically bills more than $29 for a single hour, and building this from scratch takes several. Structured by people who have watched cafes die of optimism. Pairs with the Coffee Shop Startup Workbook.

If it is not useful, reply to your receipt and we refund it, no forms.

Or get everything: this is one of the 21 products included in Barista Life Pro (Annual), all 21 digital products plus a year of new releases, $49 per year.

Goes well with: the Coffee Cost Calculator and the Cafe Health Check. Related reading: Coffee Shop Profit Margin Guide.

Frequently asked questions

What format is the model in?
A 12-month financial model delivered as a CSV that imports into Google Sheets or Excel in one click.

What is built into it?
A drinks-per-day growth curve you set to your own assumptions, pre-built revenue, cost, and cash sections with the 30 percent COGS and 35 percent labor targets, a maintenance reserve line, and the cumulative cash row, which the page calls the only number that matters.

Who should skip it?
Shops that already have an accountant-built model; the page says it will not tell you anything yours does not. If it is not useful, reply to your receipt for a refund, no forms.