BSC Cafe Automation — Complete Feature Guide

📱 Telegram Commands

Bot: @bsc_cafe_manager_bot | Chat ID: 515510458

💰 Financial & Accounting

/expense <amount> <desc>

Log expense — AI automatically categorizes

/daily_summary [YYYY-MM-DD]

POS sales, Paytm QR, expenses, purchases, bank match status

/reconcile

Show unmatched bank transactions count (Paytm/Zomato/Cash)

/reconcile_run

Run auto-match engine for all 6 match types

/purchase

Guided manual purchase entry

/pending_payments

Show unpaid vendor invoices

📋 Report Tracking

/pending

Check Petpooja reports status (daily/weekly/monthly)

/skip <report_key>

Mark report as not available for period

/bankstatement

Trigger after uploading Axis Bank XLSX file

🍜 Menu & Costing

/cost <item>

Recipe cost breakdown + margin for one menu item

/low_margin

Menu items with gross margin < 50%

/recipe_coverage

Active/draft/no-recipe counts + coverage %

📦 Stock & Variance

/stock_low

Ingredients below reorder level or zero stock

/stock_count <ing> <qty>

Log physical closing stock count

/variance

Top 5 worst variance ingredients this month

/variance <ingredient>

Last 4 weeks weekly breakdown for one ingredient

🍕 Zomato Analytics

/zomato_summary

Last 7 days Zomato for both brands: orders, revenue, cancel rate

/peak_hours

Top 3 peak hours — Zomato + Dine-In with medals (🥇🥈🥉)

👥 Customers

/top_customers

Top 10 VIP customers (all-time) with spend + last visit + segment

/at_risk

At-risk customers (30–60 days no visit) with phone + days

/lost_customers

Lost customers (60+ days) with phone + total spend

⚙️ Operations & Checklists

/opening

Opening checklist (14 items, toggle + submit)

/closing

Closing checklist (14 items, warns if opening missing)

/clean <zone>

Log cleaning for a zone (fuzzy name match)

/cleaning_status

Today's cleaning status for all zones

/cleaning_history <zone>

Last 7 cleaning entries for a zone

🔧 Maintenance

/issue <equipment> <desc>

Report maintenance issue with severity

/issue_close <id> [cost] [notes]

Close issue + optional expense link

/maintenance

All open issues grouped by severity

/equipment_status

All equipment — operational/needs_attention/under_repair count

📦 Ordering & Vendors

/order

Auto-create draft POs for all low-stock items

/order <vendor>

Create draft PO for specific vendor

/order_confirm <po_number>

Confirm PO + get WhatsApp-ready message

/orders

All open POs — draft/sent/confirmed

/order_received <po_number>

Mark PO as received + prompt bill upload

/reorder_status

Ingredients with reorder levels — current stock vs threshold

📤 File Uploads (Auto-Detect)

📊 XLSX Files

Auto-detects: Petpooja reports / Axis Bank statement / Zomato Settlement

📄 CSV Files

Auto-detects: Zomato Business Report

📕 PDF Files

Auto-detects vendor bills: Vaani Ventures / HyperPure / Blinkit

📸 Photos

Auto-detects: Vendor bill / Paytm receipt / Daily register book (NO caption needed)

📊 Web Dashboards

Access at: http://localhost:8000/dashboard (or your production URL)

/dashboard

Main overview

KPIs, sales charts, top 10 customers with segment badges

/dashboard/pending

Report Tracker

Petpooja report status (daily/weekly/monthly) — pending/received/skipped

/dashboard/pl

Profit & Loss

Revenue vs expenses, brand breakdown, margin %, revenue sources per channel

/dashboard/reconcile

Bank Reconciliation

Auto-match: vendor payments, rent, Paytm QR, Zomato payouts, cash deposits

/dashboard/menu-costing

Recipe & Menu Costing

Recipe costs, ingredient unit costs, menu margin %, coverage %, no-recipe items

/dashboard/variance

Stock Variance

Theoretical vs actual consumption — waste detection, 30-day trends per ingredient

/dashboard/zomato

Zomato Analytics

Peak hours, day-of-week, funnel (impressions→clicks→orders), ads, cancellation trend

/dashboard/customers

Customer Segments

VIP, regular, occasional, one-time — at-risk & lost customers, live search

/dashboard/cleaning

Cleaning Status

Today's cleaning by zone + last 7 days log

/dashboard/maintenance

Maintenance Tracker

Equipment status grid, open issues, repair cost chart, warranty expiry

/dashboard/ordering

Ordering & Restock

Low stock table, open POs, vendor spend chart, reorder status

/admin

Filament Admin Panel

CRUD for Staff, Checklists, Expenses, Recipes, Equipment, POs, etc.

Email: mwctechnologies2023@gmail.com

📥 Data Import Formats

POS — Petpooja (5 Daily/Weekly/Monthly Reports)

Upload XLSX file → Auto-detects report type from Row 2 (NOT filename)

✅ Item Report With Customer/Order Details — DAILY → pos_line_items
✅ Order Report: After Print Modification — MONTHLY → pos_bill_modifications
✅ KOT Report: Modifications Of Item — DAILY → pos_kot_modifications
✅ Total Customer Spend Report — WEEKLY → pos_customer_spend
✅ Tax Bifurcation: Group Wise — MONTHLY → pos_tax_group_summary

Idempotency: Replace-by-date-range (delete + reinsert same period)

Bank Statements — Axis Bank (XLSX)

Upload "Smart Statement Report" XLSX → Auto-categorizes each transaction

Header: Row 15 | Data starts: Row 16
Amount format: "INR 1,230.00" (includes comma)
Date format: DD/MM/YYYY

Auto-category rules: POS Settlement, Vendor Payment, TDS, Rent, Bank Charges, Owner Withdrawal, etc.

Zomato Settlement (XLSX Multi-Sheet)

Upload settlement report → Detects key sheets automatically

📊 Order Level sheet (data row 9+) → zomato_orders, zomato_settlements
📋 HSummary sheet (row 2) → metadata
💰 Addition Deductions Details → ads

Both brands tracked: BSC Zomato (21896844) + Korean Kick Zomato (22485506)

Zomato Business Report (CSV)

Daily CSV report → zomato_daily_metrics

Vendor Bills (Auto-Detection)

📕 PDF Bills

Vaani Ventures, HyperPure, Blinkit — parsed & saved to purchases

📸 Photo Bills

Kunal (Syrups), DMart — Gemini OCR → analyzeVendorBill()

Daily Register Book (Photo)

📸 Upload photo → Auto-detects register vs Paytm receipt

Register format:
Cash Balance → Cash Sale → subtotal → Exp → Owner Taken → Shortage → Petty Cash closing

No caption needed! Auto re-runs Paytm OCR if paytm_total detected

Paytm EDC Receipt (Photo)

📸 QR code machine thermal printout → paytm_edc_daily

Auto-matched against Petpooja UPI orders: ±₹1 amount + ±15 min time

⚙️ Local Development Setup

📁 Project Location

/Users/vivek/Documents/Claude/Projects/BSC Cafe Automation Project/bsc

🚀 Start Laravel Server

cd bsc && php artisan serve

Port: 8000 (or 8001/8002 if busy)

📦 Queue Worker

php artisan queue:work

Run in separate terminal

🔗 Ngrok Tunnel

ngrok http 8000

For Telegram webhook

🗄️ Database

Local: bsc_local (XAMPP MariaDB)

User: bsc_user

phpMyAdmin: http://localhost/phpmyadmin

🔑 Key URLs

Dashboard: http://localhost:8000/dashboard

Admin: http://localhost:8000/admin

Filament Email: mwctechnologies2023@gmail.com

💻 Key Code Locations

Developer reference — where things are built

🤖 Core Systems

app/Http/Controllers/Api/TelegramWebhookController.php

Telegram command routing & webhooks

routes/console.php

All scheduled tasks (04:00 IST → 23:30 IST)

routes/web.php

Dashboard & admin panel routes

📥 Data Importers

app/Services/Importers/

• AxisBankImporter.php
• ZomatoSettlementImporter.php
• ZomatoBusinessReportImporter.php
• PurchaseImporter.php

app/Services/Parsers/

Vendor bill PDF/photo parsers (Vaani, HyperPure, Blinkit, etc.)

🧠 Business Logic

app/Services/Ocr/

• GeminiOcrService.php (OCR engine)
• RegisterPhotoProcessor.php (Register book parsing)
• VendorBillPhotoProcessor.php (Vendor bill saving)

app/Services/Recipes/

• RecipeImporter.php
• RecipeCostCalculator.php
• UnitConverter.php

app/Services/Stock/

• IngredientCostUpdater.php
• VarianceReportService.php

app/Services/Reconciliation/

• PaytmBankMatcher.php
• ZomatoBankMatcher.php
• CashDepositMatcher.php

📊 Dashboards & Views

resources/views/dashboard/

• index.blade.php (Main overview)
• pl.blade.php (P&L)
• reconcile.blade.php (Bank reconciliation)
• menu-costing.blade.php (Recipe costs)
• variance.blade.php (Stock variance)
• zomato.blade.php (Zomato analytics)
• customers.blade.php (Customer segments)
• cleaning.blade.php (Cleaning tracker)
• maintenance.blade.php (Equipment)
• ordering.blade.php (PO & stock)

⚙️ Filament Admin Resources

app/Filament/Resources/

• StaffResource.php
• IngredientResource.php
• MenuItemResource.php
• RecipeResource.php
• ExpenseResource.php
• ExpenseCategoryResource.php
• PurchaseOrderResource.php
• EquipmentResource.php
• ChecklistTemplateResource.php

📦 Artisan Commands

app/Console/Commands/

All scheduled commands + manual commands (recipe import, bank recategorize, etc.)

📌 Quick Reference

📞 Telegram Bot

@bsc_cafe_manager_bot

Chat ID: 515510458

🏪 Two Brands, One Kitchen

BSC (Dine-in + Zomato) | Korean Kick (Zomato only)

💾 Database

MySQL (XAMPP Local) | cPanel Prod

🤖 OCR Engine

Gemini 2.5 Flash (Active)

🍦 BSC Cafe Automation