Cafe & Bar Monthly P&L Tracker | Excel + Google Sheets Template

Track every dollar your cafe or bar makes — and stop losing money you didn't know you were losing.

This ready-to-use monthly P&L spreadsheet gives cafe owners, bar managers, and restaurant 

entrepreneurs a complete financial picture in minutes per day. Works in Excel and Google Sheets. 

No accounting experience needed.

━━━━━━━━━━━━━━━━━━━━━━━━

✅ WHAT'S INCLUDED

━━━━━━━━━━━━━━━━━━━━━━━━

- Excel file (.xlsx) — works in Microsoft Excel 2016+ and free Google Sheets

- Instructions sheet — color-coded guide, no confusion

- Daily Revenue Log — track food, drinks, alcohol, hookah/specials separately for all 31 days

- Monthly Costs sheet — enter rent, salaries, purchasing, utilities and more

- P&L Summary — auto-calculates total revenue, total costs, gross profit and net margin

- Key stats: average daily revenue, best performing day, number of working days

- Pre-filled with example data so you can see it working immediately

━━━━━━━━━━━━━━━━━━━━━━━━

🎯 PERFECT FOR

━━━━━━━━━━━━━━━━━━━━━━━━

- Cafe and coffee shop owners

- Bar and pub managers

- Restaurant owners tracking monthly performance

- Food & beverage entrepreneurs planning to open a venue

- Small business owners who want simple bookkeeping without expensive software

━━━━━━━━━━━━━━━━━━━━━━━━

⚙️ HOW IT WORKS

━━━━━━━━━━━━━━━━━━━━━━━━

Step 1 — Each day, enter your revenue by category in the Daily Revenue sheet (takes 2 minutes)

Step 2 — At month end, fill in your costs in the Monthly Costs sheet

Step 3 — Open P&L Summary — profit, margin and all key stats are calculated automatically

Step 4 — Save file under new name for next month and repeat

Color coding: Blue text = your inputs | Black text = formulas (don't touch) | Green = totals

━━━━━━━━━━━━━━━━━━━━━━━━

📊 WHAT YOU CAN TRACK

━━━━━━━━━━━━━━━━━━━━━━━━

REVENUE CATEGORIES:

→ Food / Kitchen sales

→ Soft drinks & non-alcoholic beverages

→ Alcohol sales

→ Hookah, specials, or any custom category

→ Other income

MONTHLY COSTS:

→ Rent

→ Staff salaries

→ Utilities

→ Food & beverage purchasing

→ Supplies & consumables

→ Marketing & advertising

→ POS / payment processing fees

→ Other costs

AUTO-CALCULATED METRICS:

→ Total monthly revenue

→ Total monthly costs

→ Gross profit

→ Profit margin %

→ Average daily revenue

→ Best performing day

→ Days with revenue (working days)

━━━━━━━━━━━━━━━━━━━━━━━━

📦 WHAT YOU GET

━━━━━━━━━━━━━━━━━━━━━━━━

- Instant download after purchase

- 1 Excel file (.xlsx)

- Works offline — no subscription, no internet required

- One-time purchase — yours forever

- Free updates if template is improved

━━━━━━━━━━━━━━━━━━━━━━━━