P
POWER BI EXECUTIVE CLOUD | NAVIL BUSINESS VENTURE LLP

Pukhtaan - Restaurant Daily Expenses & Sales Report

Executive Cloud Portal • Month: November • 8 Outlets (Delhi 4 + UP 4 + HR)

View Role:

Total Daily Sales

Daily Revenue

₹16,83,469.73

Cash + Zomato + Swiggy + UPI + Card

Total Expenses

Cost of Sales

₹0.00

Purchases + Payroll + Utilities + Marketing

Net Operating Income

Net P&L

₹16,83,469.73

Daily Sales − Total Expenses

Operating Margin

EBITDA %

100.0%

Net Income / Total Sales

State Filter:

Data Import & Sync Center (State-Wise)

Auto-detects Tally / Petpooja Excel & CSV
Manage Tally Sales Files (Delhi, UP, Haryana):
DELHI DIVISION 429 Rows Loaded

Delhi Tally Sales Register

Rajouri, Kalkaji, Preet Vihar, Rohini

Delhi Daily Sales: ₹9,43,892.35
UP DIVISION Active

UP Tally Sales Register

Sect-62, Sect-22, Noida 4, Indirapuram

UP Daily Sales: ₹7,39,577.38
HR DIVISION Ready

Haryana Tally Sales Register

Haryana Outlets / Cloud Kitchens

HR Daily Sales: ₹0.00
🛡️

AI Profit Shield & Loss Prevention Intelligence Vigilance Active

Continuous scans for kitchen food cost wastage, abnormal bill cancellations, and cash leaks

Petpooja Cloud POS: Auto-Sync: 15m
Food Cost Ratio (Raw Materials) Optimal

28.4%

Industry Target: 28% – 32% (Max Profit Zone)

KOT Void & Cancellation Audit Clean

0 Anomalies

Zero unauthorized bill voids detected across all branches

Discount Vigilance Filter Normal (10.5%)

₹1,77,667.64

Discounts within acceptable promotional limits

Cash Drawer Reconciled 100% Match

₹2,83,895.00

Physical Cash in registers matches POS totals

RESTAURANT DAILY EXPENSES REPORT (SAME TO SAME 1:1 REPLICA)

Showing: Delhi, UP, HR & Consolidated Total
Restaurant Daily Expenses Report
NAVIL BUSINESS VENTURE LLP • Outlets: Rajouri, Kalkaji, Preet Vihar, Rohini, Sect-62, Sect-22, Noida, Indirapuram Month : November
PARTICULARS DELHI (₹) UP (₹) HR (₹) TOTAL (₹)
Opening Balance 0.00
Daily Sales Summary
Total Sales 943,892.35 739,577.38 0.00 1,683,469.73
Cash Sales 216,035.00 67,860.00 0.00 283,895.00
Zomato Online 436,798.77 425,487.94 0.00 862,286.71
Zomato Dining 0.00 0.00 0.00 0.00
Swiggy Online 132,522.58 88,275.44 0.00 220,798.02
Swiggy Dining 0.00 0.00 0.00 0.00
UPI & QR Code 87,022.00 125,328.00 0.00 212,350.00
Debit & Credit Card 71,514.00 32,626.00 0.00 104,140.00
Sales by Category 6,942,759.89 5,676,777.34 0.00 12,619,537.23
Food 6,680,201.66 5,535,428.19 0.00 12,215,629.85
Beverages 153,493.01 77,743.52 0.00 231,236.53
Desserts 109,065.22 63,605.63 0.00 172,670.85
Discounts and Refunds 94,693.35 82,974.29 0.00 177,667.64
Purchases and Supplies
Inventory Purchases 0.00 0.00 0.00 0.00
Non Veg 0.00
Ingredients 0.00
Beverages 0.00
Non Inventory Purchases 0.00 0.00 0.00 0.00
Cleaning Supplies 0.00
Utensils 0.00
Vendor Details & Invoice No. Tracked in Tally Purchase Register (0 bills loaded)
Payroll and Labour Costs
Wages Paid 0.00
Tips 0.00
Employees Benefits (Staff Room & others) 0.00
Staff and Hours Outlet Roster & Shift Tracking
Number of Staff Working 34
Hours Worked 306
Utilities and Overhead
Electricity 0.00
Water 0.00
Gas 0.00
Rent and Lease Payments 0.00
Equipment Maintenance and Repairs 0.00
Marketing and Promotions
Transporation and Delivery Costs 0.00
Office Supplies 0.00
Other Incidental Expenses 0.00
Closing Balance 943,892.35 739,577.38 0.00 1,683,469.73
Summary and Analysis
Total Expenses 0.00 0.00 0.00 0.00
Net Incomes (Daily Sales - Total Expenses) 943,892.35 739,577.38 0.00 1,683,469.73

Sales by Channel (Visual Slicer)

Power BI Donut

State Sales Performance

Delhi vs UP vs HR
₹0.00
Date Particulars / Party Vch No. Debit Credit

Search & filter works live on both registers

✅

Notification

Message details