Merchant Intelligence Reports
by Moamenz
Merchant Intelligence Reports
Store Intelligence Dashboard
Executive merchant dashboard, financial formulas, decision analytics, and branch/customer/product intelligence.
Financial Rules
Total Sales = Cash Revenue + Cashback Used
Bank Commission = Cash Revenue × Rate
Net Amount = Cash Revenue - Bank Commission
VISA / MASTER = 0.02 • MADA = 0.01
Powered by Moamenz
Store Intelligence Dashboard
Interactive management dashboard with smart insights, risk signals, and downloadable XLSX workbook.
Report Preview
Ready for presentation
Dashboard View
Start with the compact merchant summary, then open the detailed analysis.
Barcode Muhamdyah is the strongest branch with 4,470.50 SAR cash/bank revenue.
Barcode Al-Khobar has the highest refund rate at 8.3%.
Peak sales hour is 12:00 with 1,165.00 SAR; use it for staffing and campaigns.
Top 10 customers contribute 56.0% of cash/bank revenue.
Detailed Merchant Dashboard
Full merchant-facing analysisFinancial Summary
Total Sales12,836.00 SAR
Cash Revenue7,927.40 SAR
Cashback Used4,908.60 SAR
Bank Commission115.57 SAR
Net Amount7,811.83 SAR
AOV26.69 SAR
Net AOV16.24 SAR
Executive Infographic
Merchant-ready visual story
Base for sales ranking and operational performance.
4908.60 SAR
115.57 SAR
Cash revenue after bank commission.
77.5%
Refund amount compared with cash revenue.
Top BranchBarcode Muhamdyah4470.50 SAR
Best Day2026-04-30743.00 SAR
Revenue Orders481orders used for revenue analysis
Financial Waterfall
Cash + cashback - commissionPerformance Gauges
Risk and efficiencyNet Margin
Cashback Dependency
Commission Load
Refund Signal
Branch Cards
Color-coded branch performanceCustomer Segmentation Matrix
CLV vs cashback dependencyCustomer Matrix
High value vs incentive-heavySmart Action Cards
What to do nextRisk & Opportunity Heatmaps
Refunds, cashback, and payment costRefund Heatmap by Hour
Refund amount / refund rateCashback Efficiency
Cash revenue generated per cashbackCommission Load by Payment
Bank commission over cash revenueProduct Bubble Intelligence
Orders / revenue / cashbackDay × Hour Heatmap
Cash revenue intensity by weekday and hourDay × Hour Heatmap
Orders count intensity by weekday and hourOrders & Highlights
Total Orders481
Revenue Orders481
Refunded Amount292.00 SAR
Refund Risk3.7%
Cashback Orders373
Cashback Usage38.0%
Top Branch by Cash RevenueBarcode Muhamdyah
Top Branch Cash Revenue4,470.50 SAR
Lowest Branch by Cash RevenueBarcode Al-Khobar
Top Branch by CashbackBarcode Muhamdyah
Lowest Branch by CashbackBarcode Al-Khobar
Best Day by Cash Revenue2026-04-30
Worst Day by Cash Revenue2026-04-02
Top Day by Cashback2026-04-30
Lowest Day by Cashback2026-04-02
Peak Hour12:00
Visual Insights
Daily Cash Revenue Trend
Full-month daily movementWeekly Cash Revenue Trend
Week over week movementWeekday Performance
Best and lowest weekdaysBranches by Cash Revenue
Top branchesBranches by Cashback
Cashback concentrationPayment Brand Mix
Share by payment brandTop Customers CLV
Customer lifetime value leadersDaily Sales
| Day | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|---|
| 2026-04-01 | 2.00 | 41.00 | 62.00 | 21.00 | 0.82 | 40.18 |
| 2026-04-02 | 2.00 | 40.00 | 60.00 | 20.00 | 0.80 | 39.20 |
| 2026-04-03 | 3.00 | 77.00 | 154.00 | 77.00 | 0.77 | 76.23 |
| 2026-04-04 | 7.00 | 156.00 | 229.00 | 73.00 | 3.12 | 152.88 |
| 2026-04-05 | 5.00 | 88.00 | 150.00 | 62.00 | 0.88 | 87.12 |
| 2026-04-06 | 5.00 | 67.00 | 120.00 | 53.00 | 1.34 | 65.66 |
| 2026-04-07 | 8.00 | 160.00 | 267.00 | 107.00 | 3.20 | 156.80 |
| 2026-04-08 | 11.00 | 151.00 | 268.00 | 117.00 | 3.02 | 147.98 |
| 2026-04-09 | 8.00 | 136.00 | 209.00 | 73.00 | 2.72 | 133.28 |
| 2026-04-10 | 7.00 | 392.00 | 449.00 | 57.00 | 3.92 | 388.08 |
| 2026-04-11 | 19.00 | 305.00 | 478.00 | 173.00 | 6.10 | 298.90 |
| 2026-04-12 | 15.00 | 241.00 | 379.00 | 138.00 | 4.82 | 236.18 |
| 2026-04-13 | 15.00 | 214.00 | 366.00 | 152.00 | 4.28 | 209.72 |
| 2026-04-14 | 10.00 | 163.00 | 197.00 | 34.00 | 3.26 | 159.74 |
| 2026-04-15 | 16.00 | 288.00 | 370.00 | 82.00 | 5.76 | 282.24 |
| 2026-04-16 | 16.00 | 189.00 | 314.00 | 125.00 | 3.78 | 185.22 |
| 2026-04-17 | 14.00 | 259.00 | 449.00 | 190.00 | 5.18 | 253.82 |
| 2026-04-18 | 21.00 | 399.00 | 507.00 | 108.00 | 3.99 | 395.01 |
| 2026-04-19 | 23.00 | 317.00 | 573.00 | 256.00 | 6.34 | 310.66 |
| 2026-04-20 | 11.00 | 242.50 | 378.00 | 135.50 | 4.85 | 237.65 |
| 2026-04-21 | 25.00 | 326.90 | 573.00 | 246.10 | 6.54 | 320.36 |
| 2026-04-22 | 37.00 | 510.10 | 917.00 | 406.90 | 10.20 | 499.90 |
| 2026-04-23 | 28.00 | 364.50 | 646.00 | 281.50 | 7.29 | 357.21 |
| 2026-04-24 | 15.00 | 270.70 | 477.00 | 206.30 | 5.41 | 265.29 |
| 2026-04-25 | 24.00 | 411.00 | 667.00 | 256.00 | 8.22 | 402.78 |
| 2026-04-26 | 15.00 | 212.50 | 391.00 | 178.50 | 4.25 | 208.25 |
| 2026-04-27 | 30.00 | 491.40 | 777.00 | 285.60 | 9.83 | 481.57 |
| 2026-04-28 | 32.00 | 335.30 | 570.00 | 234.70 | 6.71 | 328.59 |
| 2026-04-29 | 25.00 | 336.50 | 608.00 | 271.50 | 6.73 | 329.77 |
| 2026-04-30 | 32.00 | 743.00 | 1231.00 | 488.00 | 14.86 | 728.14 |
Weekly Sales
| Week | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount | AOV |
|---|---|---|---|---|---|---|---|
| 2026-03-30/2026-04-05 | 19.00 | 402.00 | 655.00 | 253.00 | 4.02 | 397.98 | 34.47 |
| 2026-04-06/2026-04-12 | 73.00 | 1452.00 | 2170.00 | 718.00 | 29.04 | 1422.96 | 29.73 |
| 2026-04-13/2026-04-19 | 115.00 | 1829.00 | 2776.00 | 947.00 | 36.58 | 1792.42 | 24.14 |
| 2026-04-20/2026-04-26 | 155.00 | 2338.20 | 4049.00 | 1710.80 | 46.76 | 2291.44 | 26.12 |
| 2026-04-27/2026-05-03 | 119.00 | 1906.20 | 3186.00 | 1279.80 | 38.12 | 1868.08 | 26.77 |
Day Part Analysis
| Day_Part | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|---|
| Morning | 167.00 | 3176.90 | 5183.00 | 2006.10 | 31.77 | 3145.13 |
| Evening | 159.00 | 2408.50 | 3994.00 | 1585.50 | 24.09 | 2384.41 |
| Afternoon | 138.00 | 2135.00 | 3311.00 | 1176.00 | 21.35 | 2113.65 |
| Night | 17.00 | 207.00 | 348.00 | 141.00 | 2.07 | 204.93 |
Weekday Analysis
| Weekday | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|---|
| Thursday | 86.00 | 1472.50 | 2460.00 | 987.50 | 14.72 | 1457.78 |
| Wednesday | 91.00 | 1326.60 | 2225.00 | 898.40 | 13.27 | 1313.33 |
| Saturday | 71.00 | 1271.00 | 1881.00 | 610.00 | 12.71 | 1258.29 |
| Monday | 61.00 | 1014.90 | 1641.00 | 626.10 | 10.15 | 1004.75 |
| Friday | 39.00 | 998.70 | 1529.00 | 530.30 | 9.99 | 988.71 |
| Tuesday | 75.00 | 985.20 | 1607.00 | 621.80 | 9.85 | 975.35 |
| Sunday | 58.00 | 858.50 | 1493.00 | 634.50 | 8.59 | 849.91 |
Top Branches by Cash Revenue
| Branch | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount | Refund Rate |
|---|---|---|---|---|---|---|---|
| Barcode Muhamdyah | 300.00 | 4470.50 | 7479.00 | 3008.50 | 44.70 | 4425.80 | 0.02 |
| Barcode Al-Salam | 169.00 | 3041.40 | 4654.00 | 1612.60 | 30.41 | 3010.99 | 0.07 |
| Barcode Al-Khobar | 12.00 | 415.50 | 703.00 | 287.50 | 8.31 | 407.19 | 0.08 |
Lowest Branches by Cash Revenue
| Branch | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount | Refund Rate |
|---|---|---|---|---|---|---|---|
| Barcode Al-Khobar | 12.00 | 415.50 | 703.00 | 287.50 | 8.31 | 407.19 | 0.08 |
| Barcode Al-Salam | 169.00 | 3041.40 | 4654.00 | 1612.60 | 30.41 | 3010.99 | 0.07 |
| Barcode Muhamdyah | 300.00 | 4470.50 | 7479.00 | 3008.50 | 44.70 | 4425.80 | 0.02 |
Top Branches by Cashback
| Branch | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Cashback Usage % | Net Amount |
|---|---|---|---|---|---|---|---|
| Barcode Muhamdyah | 300.00 | 4470.50 | 7479.00 | 3008.50 | 44.70 | 0.67 | 4425.80 |
| Barcode Al-Salam | 169.00 | 3041.40 | 4654.00 | 1612.60 | 30.41 | 0.53 | 3010.99 |
| Barcode Al-Khobar | 12.00 | 415.50 | 703.00 | 287.50 | 8.31 | 0.69 | 407.19 |
Lowest Branches by Cashback
| Branch | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Cashback Usage % | Net Amount |
|---|---|---|---|---|---|---|---|
| Barcode Al-Khobar | 12.00 | 415.50 | 703.00 | 287.50 | 8.31 | 0.69 | 407.19 |
| Barcode Al-Salam | 169.00 | 3041.40 | 4654.00 | 1612.60 | 30.41 | 0.53 | 3010.99 |
| Barcode Muhamdyah | 300.00 | 4470.50 | 7479.00 | 3008.50 | 44.70 | 0.67 | 4425.80 |
Top Days by Cashback
| Day | Orders | Cash Revenue | Total Sales | Cashback Used | Net Amount |
|---|---|---|---|---|---|
| 2026-04-30 | 32.00 | 743.00 | 1231.00 | 488.00 | 735.57 |
| 2026-04-22 | 37.00 | 510.10 | 917.00 | 406.90 | 505.00 |
| 2026-04-27 | 30.00 | 491.40 | 777.00 | 285.60 | 486.49 |
| 2026-04-23 | 28.00 | 364.50 | 646.00 | 281.50 | 360.85 |
| 2026-04-29 | 25.00 | 336.50 | 608.00 | 271.50 | 333.13 |
| 2026-04-19 | 23.00 | 317.00 | 573.00 | 256.00 | 313.83 |
| 2026-04-25 | 24.00 | 411.00 | 667.00 | 256.00 | 406.89 |
| 2026-04-21 | 25.00 | 326.90 | 573.00 | 246.10 | 323.63 |
| 2026-04-28 | 32.00 | 335.30 | 570.00 | 234.70 | 331.95 |
| 2026-04-24 | 15.00 | 270.70 | 477.00 | 206.30 | 267.99 |
| 2026-04-17 | 14.00 | 259.00 | 449.00 | 190.00 | 256.41 |
| 2026-04-26 | 15.00 | 212.50 | 391.00 | 178.50 | 210.38 |
Lowest Days by Cashback
| Day | Orders | Cash Revenue | Total Sales | Cashback Used | Net Amount |
|---|---|---|---|---|---|
| 2026-04-02 | 2.00 | 40.00 | 60.00 | 20.00 | 39.20 |
| 2026-04-01 | 2.00 | 41.00 | 62.00 | 21.00 | 40.59 |
| 2026-04-14 | 10.00 | 163.00 | 197.00 | 34.00 | 159.74 |
| 2026-04-06 | 5.00 | 67.00 | 120.00 | 53.00 | 66.33 |
| 2026-04-10 | 7.00 | 392.00 | 449.00 | 57.00 | 388.08 |
| 2026-04-05 | 5.00 | 88.00 | 150.00 | 62.00 | 86.24 |
| 2026-04-04 | 7.00 | 156.00 | 229.00 | 73.00 | 154.44 |
| 2026-04-09 | 8.00 | 136.00 | 209.00 | 73.00 | 134.64 |
| 2026-04-03 | 3.00 | 77.00 | 154.00 | 77.00 | 75.46 |
| 2026-04-15 | 16.00 | 288.00 | 370.00 | 82.00 | 282.24 |
| 2026-04-07 | 8.00 | 160.00 | 267.00 | 107.00 | 158.40 |
| 2026-04-18 | 21.00 | 399.00 | 507.00 | 108.00 | 395.01 |
Top Products by Cash Revenue
| Product | Orders | Quantity | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|---|---|
| Espresso | 86.00 | 59.07 | 749.70 | 1246.70 | 497.00 | 7.50 | 742.20 |
| V60 - Ethiopia Shakiso | Cold | 34.00 | 29.33 | 546.27 | 838.33 | 292.07 | 5.46 | 540.81 |
| Coffee of The Day | 50.00 | 35.27 | 430.78 | 667.63 | 236.85 | 4.31 | 426.47 |
| Cortado | 40.00 | 26.02 | 424.40 | 670.90 | 246.50 | 8.49 | 415.91 |
| Iced Coffee of the day | 62.00 | 53.83 | 411.08 | 706.17 | 295.08 | 4.11 | 406.97 |
| V60 - Yemeni Haraz | Cold | 26.00 | 15.67 | 403.64 | 599.38 | 195.74 | 4.04 | 399.60 |
| V60 - Marshmallow Blend | Cold | 38.00 | 33.00 | 392.58 | 688.67 | 296.08 | 3.93 | 388.65 |
| V60 - Mexico Finca | Cold | 26.00 | 23.20 | 375.70 | 549.50 | 173.80 | 3.76 | 371.94 |
| Ice Americano | 39.00 | 33.17 | 360.58 | 546.00 | 185.42 | 3.61 | 356.97 |
| Water | 39.00 | 19.55 | 277.98 | 525.02 | 247.04 | 5.56 | 272.42 |
| V60 - Yemeni Haraz | HOT | 11.00 | 8.08 | 204.71 | 271.75 | 67.04 | 2.05 | 202.66 |
| Coffee Box | 2.00 | 1.50 | 192.50 | 232.50 | 40.00 | 1.93 | 190.57 |
Low Products by Cash Revenue
| Product | Orders | Quantity | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|---|---|
| Pistachio | 1.00 | 1.00 | 7.50 | 15.00 | 7.50 | 0.07 | 7.43 |
| Granola Peanut | 1.00 | 0.20 | 7.70 | 15.40 | 7.70 | 0.08 | 7.62 |
| V60 - Mexico Finca | HOT | 1.00 | 0.20 | 7.70 | 15.40 | 7.70 | 0.08 | 7.62 |
| Pecan with Dates | 1.00 | 0.33 | 8.33 | 16.67 | 8.33 | 0.08 | 8.25 |
| Latte | 1.00 | 1.00 | 8.50 | 17.00 | 8.50 | 0.17 | 8.33 |
| Honey Cake | 1.00 | 0.25 | 9.25 | 18.50 | 9.25 | 0.18 | 9.07 |
| Ice Creamo Cake | 1.00 | 0.20 | 9.50 | 19.00 | 9.50 | 0.10 | 9.40 |
| Cappuccino | 1.00 | 0.17 | 9.92 | 19.83 | 9.92 | 0.20 | 9.72 |
| Cheesecake Madrid - Pecan | 1.00 | 0.17 | 9.92 | 19.83 | 9.92 | 0.20 | 9.72 |
| Zaatar Croissant | 1.00 | 0.25 | 10.50 | 21.00 | 10.50 | 0.21 | 10.29 |
| Affogato Ice Cream | 1.00 | 0.33 | 10.67 | 21.33 | 10.67 | 0.21 | 10.46 |
| Salted Caramel Latte | 1.00 | 0.25 | 10.75 | 21.50 | 10.75 | 0.11 | 10.64 |
Product Pairs
| Product A | Product B | Orders |
|---|---|---|
| Cortado | Water | 12.00 |
| Coffee of The Day | Espresso | 10.00 |
| Espresso | Spicy tuna | 8.00 |
| Cortado | V60 - Yemeni Haraz | Cold | 6.00 |
| Cortado | Espresso | 6.00 |
| Coffee of The Day | Water | 5.00 |
| Espresso Barcode | Water | 4.00 |
| Espresso Barcode | V60 - Yemeni Haraz | HOT | 4.00 |
| Espresso | V60 - Yemeni Haraz | Cold | 4.00 |
| Coffee of The Day | Espresso Barcode | 4.00 |
| Espresso | Water | 4.00 |
| Molted Chocolate Cup | Water | 4.00 |
Top Customers - CLV
| Customer | Orders | Net Amount | CLV | Avg Order | Segment |
|---|---|---|---|---|---|
| Mohammed Adel Almulhem | 30.00 | 1008.81 | 1472.00 | 49.07 | VIP |
| Yousef Almulhem | 19.00 | 721.87 | 1306.00 | 68.74 | VIP |
| Customer 5591 | 37.00 | 718.21 | 1048.00 | 28.32 | VIP |
| abdulrazzaq moayed | 32.00 | 383.47 | 776.00 | 24.25 | VIP |
| Adel Almulhem | 23.00 | 582.35 | 594.00 | 25.83 | VIP |
| Customer 0500 | 6.00 | 266.23 | 471.00 | 78.50 | VIP |
| Mohammed | 25.00 | 236.18 | 456.00 | 18.24 | VIP |
| Khaled 7888 | 15.00 | 218.65 | 446.00 | 29.73 | VIP |
| Customer 4569 | 14.00 | 153.45 | 310.00 | 22.14 | VIP |
| Fatimah Mohammed | 16.00 | 152.28 | 308.00 | 19.25 | VIP |
| Moamen Fawzi | 14.00 | 141.76 | 282.00 | 20.14 | VIP |
| Ibrahim Al Suwaigh | 18.00 | 150.43 | 257.00 | 14.28 | VIP |
Top Customers - Cashback
| Customer | Orders | Net Amount | CLV | Avg Order | Segment |
|---|---|---|---|---|---|
| Yousef Almulhem | 19.00 | 721.87 | 1306.00 | 68.74 | VIP |
| Mohammed Adel Almulhem | 30.00 | 1008.81 | 1472.00 | 49.07 | VIP |
| abdulrazzaq moayed | 32.00 | 383.47 | 776.00 | 24.25 | VIP |
| Customer 5591 | 37.00 | 718.21 | 1048.00 | 28.32 | VIP |
| Khaled 7888 | 15.00 | 218.65 | 446.00 | 29.73 | VIP |
| Mohammed | 25.00 | 236.18 | 456.00 | 18.24 | VIP |
| Customer 0500 | 6.00 | 266.23 | 471.00 | 78.50 | VIP |
| Customer 4569 | 14.00 | 153.45 | 310.00 | 22.14 | VIP |
| Fatimah Mohammed | 16.00 | 152.28 | 308.00 | 19.25 | VIP |
| Moamen Fawzi | 14.00 | 141.76 | 282.00 | 20.14 | VIP |
| Customer 8705 | 10.00 | 113.52 | 226.00 | 22.60 | VIP |
| Ibrahim Al Suwaigh | 18.00 | 150.43 | 257.00 | 14.28 | VIP |
Cashback By Branch
| Branch | Orders | Cash Revenue | Cashback Used | Cashback Usage % | Net Amount |
|---|---|---|---|---|---|
| Barcode Muhamdyah | 300.00 | 4470.50 | 3008.50 | 0.67 | 4425.80 |
| Barcode Al-Salam | 169.00 | 3041.40 | 1612.60 | 0.53 | 3010.99 |
| Barcode Al-Khobar | 12.00 | 415.50 | 287.50 | 0.69 | 407.19 |
Cashback By Product
| Product | Orders | Revenue | Cashback Used | Net Amount |
|---|---|---|---|---|
| Espresso | 86.00 | 1246.70 | 497.00 | 742.20 |
| V60 - Marshmallow Blend | Cold | 38.00 | 688.67 | 296.08 | 388.65 |
| Iced Coffee of the day | 62.00 | 706.17 | 295.08 | 406.97 |
| V60 - Ethiopia Shakiso | Cold | 34.00 | 838.33 | 292.07 | 540.81 |
| Water | 39.00 | 525.02 | 247.04 | 272.42 |
| Cortado | 40.00 | 670.90 | 246.50 | 415.91 |
| Coffee of The Day | 50.00 | 667.63 | 236.85 | 426.47 |
| V60 - Yemeni Haraz | Cold | 26.00 | 599.38 | 195.74 | 399.60 |
| Ice Americano | 39.00 | 546.00 | 185.42 | 356.97 |
| V60 - Mexico Finca | Cold | 26.00 | 549.50 | 173.80 | 371.94 |
| Espresso Barcode | 13.00 | 280.75 | 127.09 | 152.12 |
| Spicy tuna | 15.00 | 284.37 | 120.00 | 162.73 |
Payment Brand Analysis
| Payment Brand | Orders | Cash Revenue | Total Sales | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|---|
| MADA | 262.00 | 4303.50 | 7007.00 | 2703.50 | 86.07 | 4217.43 |
| VISA | 193.00 | 3388.90 | 5447.00 | 2058.10 | 33.89 | 3355.01 |
| MASTER | 26.00 | 235.00 | 382.00 | 147.00 | 2.35 | 232.65 |
Refund By Branch
| Branch | Refunded Orders | Refunded Amount | Cashback Used |
|---|---|---|---|
| Barcode Muhamdyah | 6.00 | 111.50 | 18.50 |
| Barcode Al-Salam | 11.00 | 91.90 | 54.10 |
| Barcode Al-Khobar | 1.00 | 8.00 | 8.00 |
Refund By Product
| Product | Refunded Orders | Refunded Amount | Cashback Used |
|---|---|---|---|
| V60 - Ethiopia Shakiso | Cold | 3.00 | 54.40 | 25.60 |
| Coffee of The Day | 2.00 | 20.00 | 0.00 |
| Ice karikade | 2.00 | 19.50 | 10.50 |
| Affogato Ice Cream (vanilla) | 1.00 | 18.00 | 0.00 |
| Cardamom latte | 1.00 | 18.00 | 0.00 |
| V60 - Marshmallow Blend | Cold | 1.00 | 18.00 | 0.00 |
| Molted Pecan Cup | 1.00 | 18.00 | 0.00 |
| Ice Americano | 2.00 | 13.50 | 12.50 |
| Crushed ice Espresso | 1.00 | 8.00 | 8.00 |
| winter sweet | 1.00 | 6.50 | 6.50 |
| Sparking Water | 1.00 | 6.50 | 6.50 |
| Iced Coffee of the day | 1.00 | 6.00 | 6.00 |
Refund By Customer
| Customer | Refunded Orders | Refunded Amount | Cashback Used |
|---|---|---|---|
| Customer 1343 | 1.00 | 72.00 | 0.00 |
| Customer 5591 | 4.00 | 67.40 | 38.60 |
| Ibrahim Al Suwaigh | 2.00 | 13.50 | 12.50 |
| Mohammed Salaheldeen Abdulmonem Ali | 1.00 | 12.00 | 3.00 |
| Customer 0289 | 1.00 | 10.00 | 0.00 |
| Customer 4464 | 1.00 | 10.00 | 0.00 |
| Customer 6532 | 1.00 | 8.00 | 8.00 |
| Customer 6556 | 1.00 | 7.50 | 7.50 |
| Ibrahim Yussef | 1.00 | 6.00 | 6.00 |
| Moamen Fawzi | 5.00 | 5.00 | 5.00 |
Refund By Hour
| Hour | Total_Orders | Refunded Orders | Refunded Amount | Refund Rate |
|---|---|---|---|---|
| 00:00 | 6.00 | 0.00 | 0.00 | 0.00 |
| 01:00 | 1.00 | 0.00 | 0.00 | 0.00 |
| 06:00 | 6.00 | 0.00 | 0.00 | 0.00 |
| 07:00 | 23.00 | 0.00 | 0.00 | 0.00 |
| 08:00 | 41.00 | 0.00 | 0.00 | 0.00 |
| 09:00 | 29.00 | 2.00 | 27.00 | 0.07 |
| 10:00 | 33.00 | 0.00 | 0.00 | 0.00 |
| 11:00 | 35.00 | 2.00 | 18.00 | 0.06 |
| 12:00 | 39.00 | 0.00 | 0.00 | 0.00 |
| 13:00 | 27.00 | 4.00 | 95.50 | 0.15 |
| 14:00 | 25.00 | 0.00 | 0.00 | 0.00 |
| 15:00 | 16.00 | 0.00 | 0.00 | 0.00 |
| 16:00 | 31.00 | 0.00 | 0.00 | 0.00 |
| 17:00 | 27.00 | 1.00 | 6.50 | 0.04 |
| 18:00 | 37.00 | 0.00 | 0.00 | 0.00 |
| 19:00 | 38.00 | 1.00 | 14.40 | 0.03 |
| 20:00 | 26.00 | 0.00 | 0.00 | 0.00 |
| 21:00 | 17.00 | 5.00 | 35.00 | 0.29 |
| 22:00 | 14.00 | 2.00 | 2.00 | 0.14 |
| 23:00 | 10.00 | 1.00 | 13.00 | 0.10 |
Financial Formula
| Metric | Formula / Arabic Definition | Notes |
|---|---|---|
| Cash Revenue | المبلغ المدفوع نقدًا/بنكيًا من العميل أو بوابة الدفع | Base financial revenue |
| Cashback Used | الكاش باك المستخدم | Incentive / behavior indicator |
| Total Sales | Cash Revenue + Cashback Used | Gross sales including cashback |
| Bank Commission | Cash Revenue × commission rate | Applied only to Cash Revenue, never to Total Sales |
| Net Amount | Cash Revenue - Bank Commission | Net financial amount after bank commission |
| Cashback Dependency | Cashback Used / Total Sales | How much sales depend on cashback |
| Commission Load | Bank Commission / Cash Revenue | Payment cost ratio |
| Net Margin | Net Amount / Cash Revenue | Net after bank commission |
Validation Checks
| Check | Expected | Actual | Difference | Status |
|---|---|---|---|---|
| Total Sales = Cash Revenue + Cashback Used | 12836.00 | 12836.00 | 0.00 | PASS |
| Net Amount = Cash Revenue - Bank Commission | 7811.83 | 7811.83 | 0.00 | PASS |
| Bank Commission = Cash Revenue × rate | 115.57 | 115.57 | 0.27 | FAIL |
| Commission base is Cash Revenue only | Cash Revenue | Cash Revenue | 0.00 | PASS |
| Bank Commission <= Cash Revenue | 1.00 | 1.00 | 0.00 | PASS |
| No duplicate display columns warning guard | 1.00 | 1.00 | 0.00 | PASS |
Customer Opportunity List
| Customer | Orders | Cash Revenue | Total Sales | Cashback Used | Net Amount | CLV | Days Since Last Order | Cashback Dependency % | Opportunity Segment |
|---|---|---|---|---|---|---|---|---|---|
| Mohammed Adel Almulhem | 30.00 | 1019.00 | 1472.00 | 453.00 | 1008.81 | 1472.00 | 0.00 | 0.31 | High CLV / Low Cashback - premium retention |
| Yousef Almulhem | 19.00 | 736.50 | 1306.00 | 569.50 | 721.87 | 1306.00 | 1.00 | 0.44 | High CLV / Low Cashback - premium retention |
| Customer 5591 | 37.00 | 727.90 | 1048.00 | 320.10 | 718.21 | 1048.00 | 0.00 | 0.31 | High CLV / Low Cashback - premium retention |
| abdulrazzaq moayed | 32.00 | 388.00 | 776.00 | 388.00 | 383.47 | 776.00 | 0.00 | 0.50 | High CLV / High Cashback - keep but control incentives |
| Adel Almulhem | 23.00 | 594.00 | 594.00 | 0.00 | 582.35 | 594.00 | 0.00 | 0.00 | High CLV / Low Cashback - premium retention |
| Customer 0500 | 6.00 | 271.00 | 471.00 | 200.00 | 266.23 | 471.00 | 0.00 | 0.42 | High CLV / Low Cashback - premium retention |
| Mohammed | 25.00 | 241.00 | 456.00 | 215.00 | 236.18 | 456.00 | 2.00 | 0.47 | High CLV / Low Cashback - premium retention |
| Khaled 7888 | 15.00 | 223.00 | 446.00 | 223.00 | 218.65 | 446.00 | 0.00 | 0.50 | High CLV / High Cashback - keep but control incentives |
| Customer 4569 | 14.00 | 155.00 | 310.00 | 155.00 | 153.45 | 310.00 | 6.00 | 0.50 | High CLV / High Cashback - keep but control incentives |
| Fatimah Mohammed | 16.00 | 154.00 | 308.00 | 154.00 | 152.28 | 308.00 | 0.00 | 0.50 | High CLV / High Cashback - keep but control incentives |
| Moamen Fawzi | 14.00 | 144.00 | 282.00 | 138.00 | 141.76 | 282.00 | 0.00 | 0.49 | High CLV / Low Cashback - premium retention |
| Ibrahim Al Suwaigh | 18.00 | 152.00 | 257.00 | 105.00 | 150.43 | 257.00 | 0.00 | 0.41 | High CLV / Low Cashback - premium retention |
| Customer 8705 | 10.00 | 115.00 | 226.00 | 111.00 | 113.52 | 226.00 | 0.00 | 0.49 | High CLV / Low Cashback - premium retention |
| Ibrahim Yussef | 12.00 | 95.00 | 185.00 | 90.00 | 93.10 | 185.00 | 1.00 | 0.49 | High CLV / Low Cashback - premium retention |
| Customer 1363 | 3.00 | 87.50 | 175.00 | 87.50 | 86.62 | 175.00 | 11.00 | 0.50 | High CLV / High Cashback - keep but control incentives |
| Tahany Alnaim | 3.00 | 98.50 | 168.00 | 69.50 | 97.52 | 168.00 | 4.00 | 0.41 | High CLV / Low Cashback - premium retention |
| Ahmed Khlifa | 4.00 | 83.50 | 167.00 | 83.50 | 82.66 | 167.00 | 2.00 | 0.50 | High CLV / High Cashback - keep but control incentives |
| Customer 0289 | 7.00 | 93.00 | 163.00 | 70.00 | 91.71 | 163.00 | 0.00 | 0.43 | High CLV / Low Cashback - premium retention |
| Fahad A. Almulhem | 8.00 | 159.00 | 159.00 | 0.00 | 156.97 | 159.00 | 0.00 | 0.00 | High CLV / Low Cashback - premium retention |
| Ibrahim Sami | 8.00 | 85.00 | 155.00 | 70.00 | 83.85 | 155.00 | 2.00 | 0.45 | High CLV / Low Cashback - premium retention |
Cashback Impact
| Segment | Orders | Customers | Cash Revenue | Cashback Used | Total Sales | AOV Cash | AOV Total | Repeat Rate | Cashback Dependency % | Cash Revenue per 1 SAR Cashback |
|---|---|---|---|---|---|---|---|---|---|---|
| Orders With Cashback | 373.00 | 76.00 | 5353.40 | 4908.60 | 10262.00 | 14.35 | 27.51 | 0.68 | 0.48 | 1.09 |
| Orders Without Cashback | 108.00 | 35.00 | 2574.00 | 0.00 | 2574.00 | 23.83 | 23.83 | 0.46 | 0.00 | 2574.00 |
Product Performance Score
| _Product | Orders | Cash Revenue | Revenue | Cashback Used | Bank Commission | Net Amount | Cashback Dependency % | Net Margin % | Refund Risk | Product Score | Product Category |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Espresso | 86.00 | 749.70 | 1246.70 | 497.00 | 7.50 | 742.20 | 0.40 | 0.99 | 0.00 | 83.82 | Strong Product |
| Iced Coffee of the day | 62.00 | 411.08 | 706.17 | 295.08 | 4.11 | 406.97 | 0.42 | 0.99 | 0.01 | 55.94 | Stable Product |
| V60 - Ethiopia Shakiso | Cold | 34.00 | 546.27 | 838.33 | 292.07 | 5.46 | 540.81 | 0.35 | 0.99 | 0.10 | 55.26 | Stable Product |
| Coffee of The Day | 50.00 | 430.78 | 667.63 | 236.85 | 4.31 | 426.47 | 0.35 | 0.99 | 0.05 | 53.94 | Stable Product |
| Cortado | 40.00 | 424.40 | 670.90 | 246.50 | 8.49 | 415.91 | 0.37 | 0.98 | 0.00 | 51.19 | Stable Product |
| V60 - Marshmallow Blend | Cold | 38.00 | 392.58 | 688.67 | 296.08 | 3.93 | 388.65 | 0.43 | 0.99 | 0.05 | 47.04 | Stable Product |
| Ice Americano | 39.00 | 360.58 | 546.00 | 185.42 | 3.61 | 356.97 | 0.34 | 0.99 | 0.04 | 46.94 | Stable Product |
| V60 - Yemeni Haraz | Cold | 26.00 | 403.64 | 599.38 | 195.74 | 4.04 | 399.60 | 0.33 | 0.99 | 0.00 | 46.69 | Stable Product |
| V60 - Mexico Finca | Cold | 26.00 | 375.70 | 549.50 | 173.80 | 3.76 | 371.94 | 0.32 | 0.99 | 0.00 | 45.16 | Stable Product |
| Water | 39.00 | 277.98 | 525.02 | 247.04 | 5.56 | 272.42 | 0.47 | 0.98 | 0.02 | 40.20 | Cashback Driven |
| V60 - Yemeni Haraz | HOT | 11.00 | 204.71 | 271.75 | 67.04 | 2.05 | 202.66 | 0.25 | 0.99 | 0.00 | 31.58 | Stable Product |
| Coffee Box | 2.00 | 192.50 | 232.50 | 40.00 | 1.93 | 190.57 | 0.17 | 0.99 | 0.00 | 29.35 | Stable Product |
| Eid chocolate box booking | 1.00 | 152.50 | 152.50 | 0.00 | 1.53 | 150.97 | 0.00 | 0.99 | 0.00 | 29.24 | Stable Product |
| Spicy tuna | 15.00 | 164.37 | 284.37 | 120.00 | 1.64 | 162.73 | 0.42 | 0.99 | 0.00 | 27.70 | Stable Product |
| Espresso Barcode | 13.00 | 153.66 | 280.75 | 127.09 | 1.54 | 152.12 | 0.45 | 0.99 | 0.00 | 26.01 | Cashback Driven |
| Turkey cheese | 12.00 | 148.00 | 257.00 | 109.00 | 1.48 | 146.52 | 0.42 | 0.99 | 0.00 | 25.81 | Stable Product |
| Freddo | 6.00 | 80.00 | 89.50 | 9.50 | 1.60 | 78.40 | 0.11 | 0.98 | 0.00 | 24.55 | Stable Product |
| Cheese | 9.00 | 109.78 | 177.03 | 67.25 | 1.10 | 108.68 | 0.38 | 0.99 | 0.00 | 23.31 | Stable Product |
| Hallom | 9.00 | 101.95 | 169.37 | 67.42 | 1.02 | 100.93 | 0.40 | 0.99 | 0.00 | 22.56 | Stable Product |
| Coffee Sachets | Mexico Finca | 2.00 | 105.50 | 150.00 | 44.50 | 1.05 | 104.45 | 0.30 | 0.99 | 0.00 | 22.26 | Stable Product |
Product Bundle Suggestions
| Product A | Product B | Orders | Bundle Suggestion | Action |
|---|---|---|---|---|
| Cortado | Water | 12.00 | Bundle Cortado + Water | Create combo offer, app placement, or cross-sell banner |
| Coffee of The Day | Espresso | 10.00 | Bundle Coffee of The Day + Espresso | Create combo offer, app placement, or cross-sell banner |
| Espresso | Spicy tuna | 8.00 | Bundle Espresso + Spicy tuna | Create combo offer, app placement, or cross-sell banner |
| Cortado | V60 - Yemeni Haraz | Cold | 6.00 | Bundle Cortado + V60 - Yemeni Haraz | Cold | Create combo offer, app placement, or cross-sell banner |
| Cortado | Espresso | 6.00 | Bundle Cortado + Espresso | Create combo offer, app placement, or cross-sell banner |
| Coffee of The Day | Water | 5.00 | Bundle Coffee of The Day + Water | Create combo offer, app placement, or cross-sell banner |
| Espresso Barcode | Water | 4.00 | Bundle Espresso Barcode + Water | Create combo offer, app placement, or cross-sell banner |
| Espresso Barcode | V60 - Yemeni Haraz | HOT | 4.00 | Bundle Espresso Barcode + V60 - Yemeni Haraz | HOT | Create combo offer, app placement, or cross-sell banner |
| Espresso | V60 - Yemeni Haraz | Cold | 4.00 | Bundle Espresso + V60 - Yemeni Haraz | Cold | Create combo offer, app placement, or cross-sell banner |
| Coffee of The Day | Espresso Barcode | 4.00 | Bundle Coffee of The Day + Espresso Barcode | Create combo offer, app placement, or cross-sell banner |
| Espresso | Water | 4.00 | Bundle Espresso + Water | Create combo offer, app placement, or cross-sell banner |
| Molted Chocolate Cup | Water | 4.00 | Bundle Molted Chocolate Cup + Water | Create combo offer, app placement, or cross-sell banner |
| Espresso | V60 - Marshmallow Blend | Cold | 4.00 | Bundle Espresso + V60 - Marshmallow Blend | Cold | Create combo offer, app placement, or cross-sell banner |
| Espresso | Sparking Water | 4.00 | Bundle Espresso + Sparking Water | Create combo offer, app placement, or cross-sell banner |
| V60 - Ethiopia Shakiso | Cold | Water | 4.00 | Bundle V60 - Ethiopia Shakiso | Cold + Water | Create combo offer, app placement, or cross-sell banner |
Payment Cost Optimization
| Payment | Orders | Cash Revenue | Bank Commission | Commission Load % | Estimated Saving if shifted to MADA 0.01 | Action |
|---|---|---|---|---|---|---|
| MADA | 262.00 | 4303.50 | 86.07 | 0.02 | 43.03 | Normal |
| VISA | 193.00 | 3388.90 | 33.89 | 0.01 | 0.00 | Normal |
| MASTER | 26.00 | 235.00 | 2.35 | 0.01 | 0.00 | Normal |
Advanced Recommendations
| Type | Target | Evidence | Recommended Action | Priority |
|---|---|---|---|---|
| Branch Action | Barcode Al-Khobar | Refund 8.3%, cashback dependency 69.2% | Review fulfilment, quality, and incentive policy for this branch. | High |
| Cashback Risk | Barcode Muhamdyah | Cashback used 3008.5 | Check whether cashback is producing enough cash revenue and repeat orders. | Medium |
| Product Action | Affogato Ice Cream (vanilla) | Refund Risk / score 1.17 | Adjust promotion, bundle, pricing, or availability for this product. | High |
| Payment Cost | MADA | Commission load 2.0% | Encourage lower-cost payment methods where possible. | Medium |
Branch Detailed Dashboards
Branch Focus
Branch dashboard
Barcode Muhamdyah
Orders300
Cash Revenue4470.50 SAR
Cashback Used3008.50 SAR
Bank Commission44.70 SAR
Net Amount4425.80 SAR
Refund Rate2.0%
Top Products
By cash revenueDaily Movement
Branch cash revenueHourly Movement
Peak hour profilePayment Mix
Brand splitTop Products by Cash Revenue
| Product | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| Espresso | 47.00 | 390.20 | 267.33 | 6.48 | 383.72 |
| V60 - Marshmallow Blend | Cold | 36.00 | 367.08 | 287.08 | 6.55 | 360.54 |
| Cortado | 37.00 | 356.00 | 222.50 | 3.56 | 352.44 |
| Iced Coffee of the day | 51.00 | 324.50 | 258.50 | 4.75 | 319.75 |
| Coffee of The Day | 38.00 | 298.75 | 204.05 | 5.08 | 293.67 |
| Ice Americano | 34.00 | 289.58 | 185.42 | 3.52 | 286.06 |
| Water | 25.00 | 221.68 | 197.34 | 2.93 | 218.75 |
| Coffee Box | 2.00 | 192.50 | 40.00 | 2.33 | 190.18 |
| V60 - Yemeni Haraz | Cold | 12.00 | 156.74 | 117.74 | 2.55 | 154.19 |
| Eid chocolate box booking | 1.00 | 152.50 | 0.00 | 1.52 | 150.97 |
Lowest Products by Cash Revenue
| Product | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| Lemon Cake | 1.00 | 5.00 | 5.00 | 0.10 | 4.90 |
| Pistachio | 1.00 | 7.50 | 7.50 | 0.15 | 7.35 |
| V60 - Mexico Finca | HOT | 1.00 | 7.70 | 7.70 | 0.15 | 7.55 |
| Granola Peanut | 1.00 | 7.70 | 7.70 | 0.15 | 7.55 |
| Blueberry | 1.00 | 9.00 | 9.00 | 0.18 | 8.82 |
| V60 - New Guinea Paraka | Cold | 1.00 | 10.00 | 10.00 | 0.10 | 9.90 |
| Affogato Ice Cream | 1.00 | 10.67 | 10.67 | 0.11 | 10.56 |
| Salted Caramel Latte | 1.00 | 10.75 | 10.75 | 0.21 | 10.54 |
| Vanilla Ice Cream | 1.00 | 11.00 | 6.00 | 0.22 | 10.78 |
| Orange cake | 2.00 | 11.50 | 13.50 | 0.15 | 11.35 |
Top Customers - CLV
| Customer | Orders | CLV | Cash Revenue | Cashback Used | Net Amount | Avg Order |
|---|---|---|---|---|---|---|
| Mohammed Adel Almulhem | 21.00 | 984.00 | 707.00 | 277.00 | 699.94 | 46.86 |
| Yousef Almulhem | 10.00 | 764.00 | 430.00 | 334.00 | 421.40 | 76.40 |
| Customer 0500 | 6.00 | 471.00 | 271.00 | 200.00 | 266.23 | 78.50 |
| Khaled 7888 | 15.00 | 446.00 | 223.00 | 223.00 | 218.65 | 29.73 |
| Mohammed | 24.00 | 444.00 | 235.00 | 209.00 | 230.30 | 18.50 |
| Customer 4569 | 14.00 | 310.00 | 155.00 | 155.00 | 153.45 | 22.14 |
| Ibrahim Al Suwaigh | 18.00 | 257.00 | 152.00 | 105.00 | 150.43 | 14.28 |
| Customer 8705 | 9.00 | 200.00 | 102.00 | 98.00 | 100.65 | 22.22 |
| Ibrahim Yussef | 12.00 | 185.00 | 95.00 | 90.00 | 93.10 | 15.42 |
| Ahmed Khlifa | 4.00 | 167.00 | 83.50 | 83.50 | 82.66 | 41.75 |
Top Customers - Cashback
| Customer | Orders | CLV | Cash Revenue | Cashback Used | Net Amount | Avg Order |
|---|---|---|---|---|---|---|
| Yousef Almulhem | 10.00 | 764.00 | 430.00 | 334.00 | 421.40 | 76.40 |
| Mohammed Adel Almulhem | 21.00 | 984.00 | 707.00 | 277.00 | 699.94 | 46.86 |
| Khaled 7888 | 15.00 | 446.00 | 223.00 | 223.00 | 218.65 | 29.73 |
| Mohammed | 24.00 | 444.00 | 235.00 | 209.00 | 230.30 | 18.50 |
| Customer 0500 | 6.00 | 471.00 | 271.00 | 200.00 | 266.23 | 78.50 |
| Customer 4569 | 14.00 | 310.00 | 155.00 | 155.00 | 153.45 | 22.14 |
| Ibrahim Al Suwaigh | 18.00 | 257.00 | 152.00 | 105.00 | 150.43 | 14.28 |
| Customer 8705 | 9.00 | 200.00 | 102.00 | 98.00 | 100.65 | 22.22 |
| Ibrahim Yussef | 12.00 | 185.00 | 95.00 | 90.00 | 93.10 | 15.42 |
| Ahmed Khlifa | 4.00 | 167.00 | 83.50 | 83.50 | 82.66 | 41.75 |
Hourly Movement
| Hour | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| 00:00 | 5.00 | 70.50 | 70.50 | 0.71 | 69.79 |
| 01:00 | 1.00 | 6.50 | 6.50 | 0.07 | 6.43 |
| 06:00 | 6.00 | 137.00 | 107.00 | 1.95 | 135.05 |
| 07:00 | 11.00 | 290.50 | 239.50 | 4.53 | 285.97 |
| 08:00 | 19.00 | 292.50 | 254.50 | 4.42 | 288.08 |
| 09:00 | 20.00 | 274.00 | 179.00 | 3.28 | 270.72 |
| 10:00 | 17.00 | 228.50 | 140.50 | 4.15 | 224.35 |
| 11:00 | 18.00 | 226.00 | 131.00 | 3.43 | 222.57 |
| 12:00 | 22.00 | 537.50 | 223.50 | 6.35 | 531.15 |
| 13:00 | 12.00 | 156.50 | 73.50 | 2.22 | 154.28 |
| 14:00 | 15.00 | 156.00 | 134.00 | 2.40 | 153.60 |
| 15:00 | 12.00 | 122.50 | 101.50 | 1.72 | 120.78 |
| 16:00 | 23.00 | 221.50 | 156.50 | 3.20 | 218.30 |
| 17:00 | 19.00 | 353.50 | 279.50 | 4.65 | 348.85 |
| 18:00 | 26.00 | 347.00 | 169.00 | 5.53 | 341.47 |
| 19:00 | 30.00 | 356.00 | 266.00 | 4.97 | 351.03 |
| 20:00 | 23.00 | 426.00 | 279.00 | 7.94 | 418.06 |
| 21:00 | 4.00 | 65.50 | 65.50 | 1.31 | 64.19 |
| 22:00 | 8.00 | 94.00 | 89.00 | 1.59 | 92.41 |
| 23:00 | 9.00 | 109.00 | 43.00 | 1.48 | 107.52 |
Payment Brand Split
| Payment | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| MADA | 148.00 | 2356.50 | 1456.50 | 23.62 | 2332.88 |
| VISA | 127.00 | 1907.00 | 1405.00 | 38.14 | 1868.86 |
| MASTER | 25.00 | 207.00 | 147.00 | 4.14 | 202.86 |
Refund Summary
| Refunded Orders | Refunded Amount | Cashback Used | Refund Rate |
|---|---|---|---|
| 6.00 | 111.50 | 18.50 | 0.02 |
Branch Focus
Branch dashboard
Barcode Al-Salam
Orders169
Cash Revenue3041.40 SAR
Cashback Used1612.60 SAR
Bank Commission30.41 SAR
Net Amount3010.99 SAR
Refund Rate6.5%
Top Products
By cash revenueDaily Movement
Branch cash revenueHourly Movement
Peak hour profilePayment Mix
Brand splitTop Products by Cash Revenue
| Product | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| V60 - Ethiopia Shakiso | Cold | 33.00 | 529.77 | 275.57 | 6.72 | 523.05 |
| Espresso | 36.00 | 313.67 | 201.33 | 4.19 | 309.48 |
| V60 - Mexico Finca | Cold | 18.00 | 265.70 | 90.30 | 3.95 | 261.75 |
| V60 - Yemeni Haraz | Cold | 10.00 | 164.40 | 54.00 | 3.11 | 161.29 |
| Spicy tuna | 14.00 | 153.87 | 109.50 | 2.37 | 151.50 |
| Coffee of The Day | 11.00 | 115.03 | 32.80 | 1.80 | 113.24 |
| V60 - Yemeni Haraz | HOT | 6.00 | 100.33 | 31.67 | 1.67 | 98.67 |
| Cheese | 7.00 | 83.08 | 51.75 | 1.19 | 81.89 |
| Iced Coffee of the day | 10.00 | 82.25 | 32.25 | 1.10 | 81.15 |
| Ice Americano | 5.00 | 71.00 | 0.00 | 0.88 | 70.12 |
Lowest Products by Cash Revenue
| Product | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| Crushed ice Espresso | 1.00 | 8.00 | 8.00 | 0.16 | 7.84 |
| Pecan with Dates | 1.00 | 8.33 | 8.33 | 0.17 | 8.17 |
| Caramelized pecan | 1.00 | 8.50 | 8.50 | 0.09 | 8.41 |
| Latte | 1.00 | 8.50 | 8.50 | 0.09 | 8.41 |
| Ice Creamo Cake | 1.00 | 9.50 | 9.50 | 0.19 | 9.31 |
| Cappuccino | 1.00 | 9.92 | 9.92 | 0.10 | 9.82 |
| Blueberry | 1.00 | 9.92 | 9.92 | 0.10 | 9.82 |
| Cheesecake Madrid - Pecan | 1.00 | 9.92 | 9.92 | 0.10 | 9.82 |
| Cold Brew Cherry | Limited | 1.00 | 10.00 | 10.00 | 0.10 | 9.90 |
| Sourdough Cheese | 1.00 | 10.50 | 10.50 | 0.21 | 10.29 |
Top Customers - CLV
| Customer | Orders | CLV | Cash Revenue | Cashback Used | Net Amount | Avg Order |
|---|---|---|---|---|---|---|
| Customer 5591 | 37.00 | 1048.00 | 727.90 | 320.10 | 718.21 | 28.32 |
| abdulrazzaq moayed | 25.00 | 656.00 | 328.00 | 328.00 | 324.07 | 26.24 |
| Yousef Almulhem | 9.00 | 542.00 | 306.50 | 235.50 | 300.47 | 60.22 |
| Adel Almulhem | 18.00 | 522.00 | 522.00 | 0.00 | 511.79 | 29.00 |
| Fatimah Mohammed | 16.00 | 308.00 | 154.00 | 154.00 | 152.28 | 19.25 |
| Moamen Fawzi | 13.00 | 190.00 | 98.00 | 92.00 | 96.22 | 14.62 |
| Customer 1111 | 6.00 | 136.00 | 136.00 | 0.00 | 133.68 | 22.67 |
| Haifa Ahmad | 1.00 | 119.00 | 59.50 | 59.50 | 58.91 | 119.00 |
| Customer 2216 | 2.00 | 116.00 | 58.00 | 58.00 | 56.84 | 58.00 |
| Mohammed Adel Almulhem | 5.00 | 115.00 | 96.50 | 18.50 | 95.53 | 23.00 |
Top Customers - Cashback
| Customer | Orders | CLV | Cash Revenue | Cashback Used | Net Amount | Avg Order |
|---|---|---|---|---|---|---|
| abdulrazzaq moayed | 25.00 | 656.00 | 328.00 | 328.00 | 324.07 | 26.24 |
| Customer 5591 | 37.00 | 1048.00 | 727.90 | 320.10 | 718.21 | 28.32 |
| Yousef Almulhem | 9.00 | 542.00 | 306.50 | 235.50 | 300.47 | 60.22 |
| Fatimah Mohammed | 16.00 | 308.00 | 154.00 | 154.00 | 152.28 | 19.25 |
| Moamen Fawzi | 13.00 | 190.00 | 98.00 | 92.00 | 96.22 | 14.62 |
| Haifa Ahmad | 1.00 | 119.00 | 59.50 | 59.50 | 58.91 | 119.00 |
| Customer 2216 | 2.00 | 116.00 | 58.00 | 58.00 | 56.84 | 58.00 |
| Fajr Ali | 1.00 | 100.00 | 50.00 | 50.00 | 49.00 | 100.00 |
| محمد العيد | 4.00 | 114.00 | 74.00 | 40.00 | 73.14 | 28.50 |
| Customer 6556 | 3.00 | 70.00 | 35.00 | 35.00 | 34.66 | 23.33 |
Hourly Movement
| Hour | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| 00:00 | 1.00 | 8.00 | 8.00 | 0.08 | 7.92 |
| 07:00 | 11.00 | 168.60 | 162.40 | 2.32 | 166.28 |
| 08:00 | 21.00 | 355.00 | 243.00 | 5.13 | 349.87 |
| 09:00 | 8.00 | 142.00 | 47.00 | 1.72 | 140.28 |
| 10:00 | 13.00 | 269.80 | 160.20 | 4.42 | 265.38 |
| 11:00 | 14.00 | 448.50 | 67.50 | 7.70 | 440.80 |
| 12:00 | 17.00 | 311.30 | 92.70 | 5.11 | 306.19 |
| 13:00 | 15.00 | 208.00 | 175.00 | 3.10 | 204.90 |
| 14:00 | 10.00 | 159.00 | 70.00 | 2.73 | 156.27 |
| 15:00 | 3.00 | 31.70 | 25.30 | 0.42 | 31.28 |
| 16:00 | 7.00 | 173.00 | 124.00 | 2.32 | 170.68 |
| 17:00 | 7.00 | 126.70 | 101.30 | 1.50 | 125.20 |
| 18:00 | 11.00 | 259.40 | 69.60 | 3.38 | 256.02 |
| 19:00 | 8.00 | 118.90 | 105.10 | 1.61 | 117.29 |
| 20:00 | 3.00 | 28.00 | 19.00 | 0.38 | 27.62 |
| 21:00 | 13.00 | 181.00 | 90.00 | 2.62 | 178.38 |
| 22:00 | 6.00 | 39.50 | 39.50 | 0.59 | 38.91 |
| 23:00 | 1.00 | 13.00 | 13.00 | 0.26 | 12.74 |
Payment Brand Split
| Payment | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| MADA | 103.00 | 1543.50 | 971.50 | 15.44 | 1528.06 |
| VISA | 65.00 | 1469.90 | 641.10 | 29.39 | 1440.51 |
| MASTER | 1.00 | 28.00 | 0.00 | 0.56 | 27.44 |
Refund Summary
| Refunded Orders | Refunded Amount | Cashback Used | Refund Rate |
|---|---|---|---|
| 11.00 | 91.90 | 54.10 | 0.07 |
Branch Focus
Branch dashboard
Barcode Al-Khobar
Orders12
Cash Revenue415.50 SAR
Cashback Used287.50 SAR
Bank Commission8.31 SAR
Net Amount407.19 SAR
Refund Rate8.3%
Top Products
By cash revenueDaily Movement
Branch cash revenueHourly Movement
Peak hour profilePayment Mix
Brand splitTop Products by Cash Revenue
| Product | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| V60 - Yemeni Haraz | Cold | 4.00 | 82.50 | 24.00 | 0.82 | 81.67 |
| Espresso | 3.00 | 45.83 | 28.33 | 0.46 | 45.38 |
| Coffee Sachets | Mexico Finca | 1.00 | 37.50 | 37.50 | 0.38 | 37.12 |
| Cold Brew | 1.00 | 24.00 | 24.00 | 0.24 | 23.76 |
| Cortado | 1.00 | 24.00 | 24.00 | 0.24 | 23.76 |
| Cold Brew Cherry | Limited | 1.00 | 24.00 | 24.00 | 0.24 | 23.76 |
| Chocobai | 1.00 | 17.50 | 0.00 | 0.17 | 17.32 |
| Turkey cheese | 1.00 | 17.50 | 0.00 | 0.17 | 17.32 |
| Coffee of The Day | 1.00 | 17.00 | 0.00 | 0.17 | 16.83 |
| Sourdough Turkey cheese | 1.00 | 12.00 | 12.00 | 0.24 | 11.76 |
Lowest Products by Cash Revenue
| Product | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| Iced Coffee of the day | 1.00 | 4.33 | 4.33 | 0.04 | 4.29 |
| Water | 1.00 | 4.33 | 4.33 | 0.04 | 4.29 |
| Crushed ice Espresso | 1.00 | 8.00 | 8.00 | 0.08 | 7.92 |
| V60 - Marshmallow Blend | Cold | 1.00 | 9.00 | 9.00 | 0.09 | 8.91 |
| Ice Latte | 1.00 | 9.00 | 9.00 | 0.09 | 8.91 |
| Blueberry | 1.00 | 9.25 | 9.25 | 0.09 | 9.16 |
| Honey Cake | 1.00 | 9.25 | 9.25 | 0.09 | 9.16 |
| Caramelized pecan | 1.00 | 9.25 | 9.25 | 0.09 | 9.16 |
| Orange cake | 1.00 | 9.25 | 9.25 | 0.09 | 9.16 |
| Hallom | 1.00 | 10.50 | 10.50 | 0.10 | 10.39 |
Top Customers - CLV
| Customer | Orders | CLV | Cash Revenue | Cashback Used | Net Amount | Avg Order |
|---|---|---|---|---|---|---|
| Mohammed Adel Almulhem | 4.00 | 373.00 | 215.50 | 157.50 | 213.34 | 93.25 |
| Customer 1363 | 2.00 | 158.00 | 79.00 | 79.00 | 78.21 | 79.00 |
| Abdullah Almulhim | 1.00 | 70.00 | 70.00 | 0.00 | 69.30 | 70.00 |
| Customer 8705 | 1.00 | 26.00 | 13.00 | 13.00 | 12.87 | 26.00 |
| Customer 2187 | 1.00 | 24.00 | 12.00 | 12.00 | 11.76 | 24.00 |
| abdulrazzaq moayed | 1.00 | 18.00 | 9.00 | 9.00 | 8.91 | 18.00 |
| Customer 0227 | 1.00 | 18.00 | 9.00 | 9.00 | 8.91 | 18.00 |
| Customer 6532 | 1.00 | 16.00 | 8.00 | 8.00 | 7.92 | 16.00 |
Top Customers - Cashback
| Customer | Orders | CLV | Cash Revenue | Cashback Used | Net Amount | Avg Order |
|---|---|---|---|---|---|---|
| Mohammed Adel Almulhem | 4.00 | 373.00 | 215.50 | 157.50 | 213.34 | 93.25 |
| Customer 1363 | 2.00 | 158.00 | 79.00 | 79.00 | 78.21 | 79.00 |
| Customer 8705 | 1.00 | 26.00 | 13.00 | 13.00 | 12.87 | 26.00 |
| Customer 2187 | 1.00 | 24.00 | 12.00 | 12.00 | 11.76 | 24.00 |
| abdulrazzaq moayed | 1.00 | 18.00 | 9.00 | 9.00 | 8.91 | 18.00 |
| Customer 0227 | 1.00 | 18.00 | 9.00 | 9.00 | 8.91 | 18.00 |
| Customer 6532 | 1.00 | 16.00 | 8.00 | 8.00 | 7.92 | 16.00 |
| Abdullah Almulhim | 1.00 | 70.00 | 70.00 | 0.00 | 69.30 | 70.00 |
Hourly Movement
| Hour | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| 07:00 | 1.00 | 12.00 | 12.00 | 0.24 | 11.76 |
| 08:00 | 1.00 | 9.00 | 9.00 | 0.09 | 8.91 |
| 09:00 | 1.00 | 120.00 | 120.00 | 1.20 | 118.80 |
| 10:00 | 3.00 | 116.50 | 116.50 | 1.17 | 115.33 |
| 11:00 | 3.00 | 87.00 | 17.00 | 0.87 | 86.13 |
| 15:00 | 1.00 | 24.00 | 0.00 | 0.24 | 23.76 |
| 16:00 | 1.00 | 34.00 | 0.00 | 0.34 | 33.66 |
| 17:00 | 1.00 | 13.00 | 13.00 | 0.13 | 12.87 |
Payment Brand Split
| Payment | Orders | Cash Revenue | Cashback Used | Bank Commission | Net Amount |
|---|---|---|---|---|---|
| MADA | 11.00 | 403.50 | 275.50 | 4.04 | 399.46 |
| VISA | 1.00 | 12.00 | 12.00 | 0.24 | 11.76 |
Refund Summary
| Refunded Orders | Refunded Amount | Cashback Used | Refund Rate |
|---|---|---|---|
| 1.00 | 8.00 | 8.00 | 0.08 |
Daily Trend
Sales movementHourly Performance
Peak hoursBranch Performance
Top revenue branchesFinancial Mix
Cash / Commission / Net / CashbackAlert System
Operational risks and warningsRefunds need review in Barcode Al-Khobar (8.3%).
Customer concentration is high: top 10 customers generate 56.0% of revenue.
Cashback is used in 78.0% of delivered orders.
Smart Insights V2
Reason, impact, and riskBarcode Muhamdyah is the strongest branch with 4,470.50 SAR cash/bank revenue.
Barcode Al-Khobar has the highest refund rate at 8.3%.
Peak sales hour is 12:00 with 1,165.00 SAR; use it for staffing and campaigns.
Top 10 customers contribute 56.0% of cash/bank revenue.
Cashback usage reached 4,908.60 SAR (38.0% of total sales); cash/card paid is 7,927.40 SAR.
Forecast & Actions
Simple next-period signalNext 7 Days Forecast4721.00 SAR
Daily Average674.43 SAR
TrendUp
ConfidenceMedium
Auto Recommendations
Operational actionsReview Barcode Al-Khobar: refund rate is 8.3%.
Use Barcode Muhamdyah as the benchmark branch for staffing, offers, and operations.
Plan staffing and inventory around peak hours: 12:00, 08:00, 10:00.
Weak products need action: Unknown Product, Iced Espresso, Pistachio.
Product Intelligence
Top and weak productsTop 5 Product Share32.3%
Top Products
| Product | Orders | Revenue |
|---|---|---|
| Espresso | 86 | 1246.70 |
| V60 - Ethiopia Shakiso | Cold | 34 | 838.33 |
| Iced Coffee of the day | 62 | 706.17 |
| V60 - Marshmallow Blend | Cold | 38 | 688.67 |
| Cortado | 40 | 670.90 |
Weak Products
| Product | Orders | Revenue |
|---|---|---|
| Unknown Product | 2 | 11.00 |
| Iced Espresso | 1 | 13.00 |
| Pistachio | 1 | 15.00 |
| Granola Peanut | 1 | 15.40 |
| V60 - Mexico Finca | HOT | 1 | 15.40 |
Branch Score
Performance ranking| Branch | Orders | Cash Revenue | Bank Commission | Net Amount | Cashback Used | Refund Rate | Score |
|---|---|---|---|---|---|---|---|
| Barcode Muhamdyah | 300 | 4470.50 | 44.70 | 4425.80 | 3008.50 | 2.0% | 94.7 |
| Barcode Al-Salam | 169 | 3041.40 | 30.41 | 3010.99 | 1612.60 | 6.5% | 61.31 |
| Barcode Al-Khobar | 12 | 415.50 | 8.31 | 407.19 | 287.50 | 8.3% | 6.53 |
Top Customers - CLV
Ranked by customer lifetime value| Customer | Orders | CLV | Net Amount | Cashback | Avg Order | Segment |
|---|---|---|---|---|---|---|
| Mohammed Adel Almulhem | 30 | 1472.00 | 1008.81 | 453.00 | 49.07 | VIP |
| Yousef Almulhem | 19 | 1306.00 | 721.87 | 569.50 | 68.74 | VIP |
| Customer 5591 | 37 | 1048.00 | 718.21 | 320.10 | 28.32 | VIP |
| abdulrazzaq moayed | 32 | 776.00 | 383.47 | 388.00 | 24.25 | VIP |
| Adel Almulhem | 23 | 594.00 | 582.35 | 0.00 | 25.83 | VIP |
| Customer 0500 | 6 | 471.00 | 266.23 | 200.00 | 78.50 | VIP |
| Mohammed | 25 | 456.00 | 236.18 | 215.00 | 18.24 | VIP |
| Khaled 7888 | 15 | 446.00 | 218.65 | 223.00 | 29.73 | VIP |
| Customer 4569 | 14 | 310.00 | 153.45 | 155.00 | 22.14 | VIP |
| Fatimah Mohammed | 16 | 308.00 | 152.28 | 154.00 | 19.25 | VIP |
Top Customers - Cashback
Ranked by cashback usage| Customer | Orders | Cashback | CLV | Net Amount | Avg Order | Segment |
|---|---|---|---|---|---|---|
| Yousef Almulhem | 19 | 569.50 | 1306.00 | 721.87 | 68.74 | VIP |
| Mohammed Adel Almulhem | 30 | 453.00 | 1472.00 | 1008.81 | 49.07 | VIP |
| abdulrazzaq moayed | 32 | 388.00 | 776.00 | 383.47 | 24.25 | VIP |
| Customer 5591 | 37 | 320.10 | 1048.00 | 718.21 | 28.32 | VIP |
| Khaled 7888 | 15 | 223.00 | 446.00 | 218.65 | 29.73 | VIP |
| Mohammed | 25 | 215.00 | 456.00 | 236.18 | 18.24 | VIP |
| Customer 0500 | 6 | 200.00 | 471.00 | 266.23 | 78.50 | VIP |
| Customer 4569 | 14 | 155.00 | 310.00 | 153.45 | 22.14 | VIP |
| Fatimah Mohammed | 16 | 154.00 | 308.00 | 152.28 | 19.25 | VIP |
| Moamen Fawzi | 14 | 138.00 | 282.00 | 141.76 | 20.14 | VIP |