🍦 BSC Cafe Automation
Complete Feature Guide — Telegram Commands • Dashboards • Data Import
📱 Telegram Commands
Bot: @bsc_cafe_manager_bot | Chat ID: 515510458
💰 Financial & Accounting
Log expense — AI automatically categorizes
POS sales, Paytm QR, expenses, purchases, bank match status
Show unmatched bank transactions count (Paytm/Zomato/Cash)
Run auto-match engine for all 6 match types
Guided manual purchase entry
Show unpaid vendor invoices
📋 Report Tracking
Check Petpooja reports status (daily/weekly/monthly)
Mark report as not available for period
Trigger after uploading Axis Bank XLSX file
🍜 Menu & Costing
Recipe cost breakdown + margin for one menu item
Menu items with gross margin < 50%
Active/draft/no-recipe counts + coverage %
📦 Stock & Variance
Ingredients below reorder level or zero stock
Log physical closing stock count
Top 5 worst variance ingredients this month
Last 4 weeks weekly breakdown for one ingredient
🍕 Zomato Analytics
Last 7 days Zomato for both brands: orders, revenue, cancel rate
Top 3 peak hours — Zomato + Dine-In with medals (🥇🥈🥉)
👥 Customers
Top 10 VIP customers (all-time) with spend + last visit + segment
At-risk customers (30–60 days no visit) with phone + days
Lost customers (60+ days) with phone + total spend
⚙️ Operations & Checklists
Opening checklist (14 items, toggle + submit)
Closing checklist (14 items, warns if opening missing)
Log cleaning for a zone (fuzzy name match)
Today's cleaning status for all zones
Last 7 cleaning entries for a zone
🔧 Maintenance
Report maintenance issue with severity
Close issue + optional expense link
All open issues grouped by severity
All equipment — operational/needs_attention/under_repair count
📦 Ordering & Vendors
Auto-create draft POs for all low-stock items
Create draft PO for specific vendor
Confirm PO + get WhatsApp-ready message
All open POs — draft/sent/confirmed
Mark PO as received + prompt bill upload
Ingredients with reorder levels — current stock vs threshold
📤 File Uploads (Auto-Detect)
Auto-detects: Petpooja reports / Axis Bank statement / Zomato Settlement
Auto-detects: Zomato Business Report
Auto-detects vendor bills: Vaani Ventures / HyperPure / Blinkit
Auto-detects: Vendor bill / Paytm receipt / Daily register book (NO caption needed)
📊 Web Dashboards
Access at: http://localhost:8000/dashboard (or your production URL)
Report Tracker
Petpooja report status (daily/weekly/monthly) — pending/received/skipped
Profit & Loss
Revenue vs expenses, brand breakdown, margin %, revenue sources per channel
Bank Reconciliation
Auto-match: vendor payments, rent, Paytm QR, Zomato payouts, cash deposits
Recipe & Menu Costing
Recipe costs, ingredient unit costs, menu margin %, coverage %, no-recipe items
Stock Variance
Theoretical vs actual consumption — waste detection, 30-day trends per ingredient
Zomato Analytics
Peak hours, day-of-week, funnel (impressions→clicks→orders), ads, cancellation trend
Customer Segments
VIP, regular, occasional, one-time — at-risk & lost customers, live search
Maintenance Tracker
Equipment status grid, open issues, repair cost chart, warranty expiry
Ordering & Restock
Low stock table, open POs, vendor spend chart, reorder status
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
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)
📚 For detailed technical context, see CLAUDE.md & BUILD_LOG.md in project root