Master Dashboard
Morbi HQ · Live · Real-time data
Today's Revenue
₹8,47,250
↑ 12.4% vs yesterday
Monthly Revenue
₹1.34Cr
↑ 18.2% vs last month
Pending Orders
34
↑ 5 new today
Outstanding
₹23.4L
↑ ₹1.2L overdue
Stock (Boxes)
18,420
⚠ 3 sizes low
Dispatches Today
12
8 delivered
Production Today
1,340
boxes
Active Dealers
148
+3 this month
GST Invoices
28
today
Rejection Rate
2.4%
target <2%
Revenue Trend — FY 2025-26
Monthly actual vs target
Sales by Tile Category
Current month
Branch Performance
₹ Lakhs
Stock by Size
Available / Reserved / Damaged
🤖
LIVE
AI Business Insights
Powered by TilesERP Intelligence
🔔 Live Alerts
7 New
Low stock: 600×1200 Polished White — only 420 boxes left
2 min ago
Kiln #2 temperature deviation: 1,140°C (target 1,180°C)
15 min ago
New order from Patel Tiles Surat — ₹2.4L awaiting approval
28 min ago
Dispatch #DSP-2847 delivered — POD received from driver
1 hr ago
Payment overdue: Shree Tiles ₹1.8L — 72 days pending
2 hr ago
Recent Sales Orders
| Order # | Customer | Tile | Qty (Boxes) | Amount | GST | Total | Status | Action |
|---|---|---|---|---|---|---|---|---|
| SO-25062 | Patel Tiles, Surat | 600×1200 Polished | 200 | ₹1,80,000 | ₹32,400 | ₹2,12,400 | Delivered | |
| SO-25061 | Shree Tiles, Ahmedabad | 800×800 Vitrified | 150 | ₹1,35,000 | ₹24,300 | ₹1,59,300 | In Transit | |
| SO-25060 | Modern Interiors, Mumbai | 300×600 Matt | 400 | ₹2,00,000 | ₹36,000 | ₹2,36,000 | Processing | |
| SO-25059 | Raj Constructions, Jaipur | 600×600 GVT | 300 | ₹2,10,000 | ₹37,800 | ₹2,47,800 | Pending | |
| SO-25058 | Buildmart, Bangalore | 400×800 Elevation | 180 | ₹1,44,000 | ₹25,920 | ₹1,69,920 | Delivered |
🔥 Fast-Moving Tiles (This Month)
⬜
600×1200 Polished White
TL-001-PW
🟫
800×800 Vitrified Brown
TL-002-VB
🟩
300×600 Matt Green
TL-003-MG
▦
600×600 GVT Bianco
TL-004-GB
⬛
400×800 Elevation Dark
TL-005-ED
Customer CRM
Leads · Dealers · Architects · Builders
Total Leads
284
↑ 18 this week
Active Dealers
148
↑ 3 new
Follow-ups Due
23
⚠ Today
Pipeline Value
₹48L
↑ 12%
Leads (284)
Dealers (148)
Architects (62)
Builders (38)
Sales Pipeline
| Name | Company | Phone | Source | Category | Value | Status | Next Follow-up | Actions |
|---|---|---|---|---|---|---|---|---|
| Mahesh Patel | Patel Constructions | +91 98240 12345 | Builder | ₹12L | Interested | Today 3PM | ||
| Priya Shah | Interior Design Studio | +91 90990 54321 | Architect | ₹4.5L | Converted | Done | ||
| Ramesh Gujarati | Gujarati Tiles Hub | +91 97140 67890 | Referral | Dealer | ₹8L | Contacted | Tomorrow | |
| Sunita Joshi | Joshi Builders | +91 88880 11111 | Website | Builder | ₹22L | Negotiating | 19 May | |
| Ankit Mehta | Mehta Tiles | +91 77770 99999 | Exhibition | Dealer | ₹3L | New | 20 May |
| Dealer Name | City | GSTIN | Credit Limit | Outstanding | Last Order | This Month | Rating | Status |
|---|---|---|---|---|---|---|---|---|
| Shree Tiles Ahmedabad | Ahmedabad | 24ABCDE1234F1Z5 | ₹25L | ₹4.2L | 17 May | ₹12.4L | ⭐⭐⭐⭐⭐ | Active |
| Patel Tiles Surat | Surat | 24FGHIJ5678K2L6 | ₹20L | ₹8.8L | 15 May | ₹9.8L | ⭐⭐⭐⭐ | Credit Hold |
| Modern Tiles Mumbai | Mumbai | 27MNOPQ9012R3S7 | ₹30L | ₹1.2L | 18 May | ₹8.2L | ⭐⭐⭐⭐⭐ | Active |
62 architects registered. Top referrer: AR. Sneha Kapoor (Mumbai) — ₹18L in projects this year.
38 builders in database. 8 active tenders currently tracked.
New (48)
Patel Constructions
₹12L · Builder
Mehta Tiles Hub
₹3L · Dealer
Contacted (36)
Joshi Builders
₹22L · Builder
Negotiating (18)
Shah Interior Studio
₹8L · Architect
Converted (12)
Modern Interiors
₹4.5L · Closed ✓
Tile Inventory
18,420 boxes · 6 warehouses · Real-time tracking
Total Stock
18,420
boxes / 2.21L sq.ft
Low Stock Items
3
Reorder needed
Reserved Stock
4,180
boxes (22.7%)
Damaged Stock
620
needs write-off
Stock Master — All Sizes
| Tile Code | Size | Design | Finish | Color | Available | Reserved | Damaged | Sq.Ft/Box | Reorder Lvl | Location | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| TL-001-PW | 600×1200 | Plain | Polished | White | 420 | 80 | 12 | 8.64 | 500 | W-A R3 | Low Stock |
| TL-002-VB | 800×800 | Stone | Vitrified | Brown | 1,240 | 320 | 28 | 7.74 | 300 | W-A R5 | In Stock |
| TL-003-MG | 300×600 | Marble | Matt | Green | 860 | 200 | 45 | 2.16 | 200 | W-B R1 | In Stock |
| TL-004-GB | 600×600 | Bianco | GVT | White | 340 | 180 | 8 | 4.30 | 400 | W-B R4 | Low Stock |
| TL-005-ED | 400×800 | Elevation | Matt | Dark Grey | 580 | 120 | 18 | 3.87 | 200 | W-A R7 | In Stock |
| TL-006-PR | 300×300 | Anti-Skid | Matt | Red | 180 | 60 | 22 | 1.08 | 300 | W-C R2 | Low Stock |
Warehouse Summary
Warehouse A6,840 boxes
Warehouse B5,200 boxes
Dispatch Bay2,840 boxes
Warehouse C3,540 boxes
📋 Pending Reorders
TL-001-PW needs 1,000 boxes
Auto-PO suggestion ready
TL-004-GB needs 600 boxes
Auto-PO suggestion ready
TL-006-PR needs 400 boxes
Review before ordering
🔀 Branch Transfer
Sales & Billing
GST Invoices · Quotations · Sales Orders
Today's Invoices
28
↑ 4 vs yesterday
Today's Billing
₹18.4L
↑ 8%
GST Collected
₹3.31L
18% rate
Pending Collection
₹12.8L
8 invoices
Recent Invoices
| Invoice # | Date | Customer | GSTIN | Taxable | GST | Total | Transport | Due Date | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|
| INV-2526-1284 | 19 May | Shree Tiles | 24ABCDE1234F1Z5 | ₹1,80,000 | ₹32,400 | ₹2,12,400 | ₹2,500 | 25 May | Pending | |
| INV-2526-1283 | 18 May | Patel Tiles | 24FGHIJ5678K2L6 | ₹2,00,000 | ₹36,000 | ₹2,36,000 | ₹3,200 | 24 May | Paid | |
| INV-2526-1282 | 17 May | Modern Interiors | 27MNOPQ9012R3S7 | ₹1,44,000 | ₹25,920 | ₹1,69,920 | ₹1,800 | 17 Jun | Overdue |
Production Management
Kilns · Shifts · Quality · Raw Materials
Today's Output
1,340
boxes produced
Rejection Rate
2.4%
target: <2%
Kilns Active
3 / 4
Kiln #3 in maintenance
Efficiency
87%
target: 92%
🔥 Kiln Temperature Monitor — Live
Kiln #1
1,182°C
OptimalKiln #2
1,142°C
LowKiln #3
OFF
MaintenanceKiln #4
1,178°C
OptimalWeekly Production vs Rejection
📦 Raw Material Stock
Clay (Body)48 MT
Feldspar12 MT
Glaze Chemical8.4 MT
Colorant1.2 MT
Fuel (Gas MT)32 MT
👷 Shift Management
| Shift | Time | Supervisor | Workers | Output |
|---|---|---|---|---|
| A | 06:00–14:00 | Ramesh P. | 42 | 480 boxes |
| B | 14:00–22:00 | Suresh K. | 38 | 510 boxes |
| C | 22:00–06:00 | Dinesh M. | 32 | 350 boxes |
✅ Quality Checks Today
✅
Batch B-2847 — Grade A (98.2%)
⚠️
Batch B-2846 — Grade B (94.8%)
Warping issue in 48 tiles
❌
Batch B-2845 — Rejected (68%)
Color mismatch — write-off
Total rejection today: 32 boxes (2.4%)
Dispatch & Logistics
Trucks · Routes · GPS · POD
Today's Dispatches
12
Delivered
8
In Transit
4
Delayed
1
Active Dispatches
| Dispatch # | SO # | Customer | Truck | Driver | Route | Boxes | Departed | ETA | Status | POD |
|---|---|---|---|---|---|---|---|---|---|---|
| DSP-2854 | SO-25064 | Shree Tiles, Ahm | GJ-04-AB-1234 | Ramu Bhai | Morbi→Ahm | 200 | 07:00 | 14:00 | In Transit | — |
| DSP-2853 | SO-25063 | Patel Tiles, Surat | GJ-05-CD-5678 | Vikram Singh | Morbi→Surat | 350 | 05:30 | 13:00 | In Transit | — |
| DSP-2852 | SO-25062 | Modern Interiors, Mumbai | MH-04-EF-9012 | Anil Yadav | Morbi→Mumbai | 400 | Yesterday 20:00 | 10:00 | Delivered |
Purchase Management
Vendors · POs · GRN · Approvals
Open POs
14
Pending GRN
6
This Month
₹42L
Overdue Payments
₹8.4L
Purchase Orders
| PO # | Vendor | Material | Qty | Rate | Value | Expected | Status |
|---|---|---|---|---|---|---|---|
| PO-2526-084 | Gujarat Clay Suppliers | Body Clay | 50 MT | ₹4,200/MT | ₹2,10,000 | 22 May | Approved |
| PO-2526-083 | Morbi Chemical Works | Glaze Chemical | 10 MT | ₹18,500/MT | ₹1,85,000 | 20 May | In Transit |
| PO-2526-082 | Rajasthan Feldspar Co. | Feldspar | 25 MT | ₹3,800/MT | ₹95,000 | 25 May | Pending Approval |
Accounting & Finance
P&L · Balance Sheet · GST · Cash Flow
Monthly Revenue
₹1.34Cr
↑ 18.2%
Monthly Expenses
₹96L
71.6% of revenue
Net Profit
₹38L
28.4% margin
GST Payable
₹4.2L
Due 20 June
Cash Flow — 6 Months
📋 Outstanding Receivables
| Party | Amount | Aging | Status |
|---|---|---|---|
| Patel Tiles, Surat | ₹8.8L | 90+ days | |
| Raj Constructions | ₹4.2L | 45–60 days | |
| Buildmart Bangalore | ₹2.8L | 30–45 days | |
| Modern Interiors | ₹1.2L | 0–30 days | Current |
HR & Payroll
Attendance · Payroll · Leave · Performance
Total Employees
248
Present Today
232
93.5% attendance
Monthly Payroll
₹28.4L
Leave Requests
12
pending approval
Department Attendance
Production142/152 (93%)
Sales28/30 (93%)
Dispatch38/42 (90%)
Admin / Accounts24/24 (100%)
Top Performers — May
| Employee | Dept | KPI Score | Incentive |
|---|---|---|---|
| Suresh Patel | Sales | 98% | ₹12,000 |
| Ramesh Kumar | Production | 96% | ₹8,000 |
| Anjali Shah | Accounts | 94% | ₹6,000 |
| Dinesh Bhai | Dispatch | 91% | ₹4,500 |
AI Insights Engine
Predictions · Forecasts · Smart Automation
AI Predictions
24
active models
Accuracy Rate
94.2%
↑ 2.1% this month
Cost Saved (AI)
₹2.8L
this month via automation
🤖LIVE
Real-Time AI Insights
📊 Demand Forecast — Next 30 Days
600×1200 Polished
Predicted demand
2,400 boxes
High Demand800×800 Vitrified
Predicted demand
1,800 boxes
Moderate300×300 Parking
Predicted demand
600 boxes
Low Demand🤖 AI Chat Assistant
Ask about inventory, sales, production, forecasts...
👋 Hello! I'm your TilesERP AI Assistant. Ask me about stock levels, sales forecasts, production status, or dealer analysis.
WhatsApp Automation
Invoices · Reminders · Catalogs · AI Replies
Messages Today
284
Invoices Sent
28
Reminders Sent
12
AI Auto-Replies
48
📤 Quick Send
⚡ Automation Rules
Invoice Auto-Send
On invoice create → WhatsApp PDF
Payment Reminder
3 days before due + day of due
Dispatch Notification
On truck departure → live tracking link
AI Auto-Reply
Outside office hours chatbot
Reports & Analytics
Sales · Profit · Region · Trends · AI Insights
Region-wise Sales (₹ Lakhs)
Margin Trend (%)
Top 10 Tiles by Revenue — This Month
| # | Tile Code | Description | Boxes Sold | Sq.Ft | Revenue | Margin % | vs Last Month |
|---|---|---|---|---|---|---|---|
| 1 | TL-001-PW | 600×1200 Polished White | 1,840 | 15,898 | ₹28.4L | 38% | ↑ 22% |
| 2 | TL-002-VB | 800×800 Vitrified Brown | 1,420 | 10,985 | ₹19.2L | 34% | ↑ 8% |
| 3 | TL-003-MG | 300×600 Matt Green | 2,200 | 4,752 | ₹14.8L | 28% | ↓ 4% |
| 4 | TL-004-GB | 600×600 GVT Bianco | 980 | 4,214 | ₹12.1L | 31% | ↑ 15% |
| 5 | TL-005-ED | 400×800 Elevation Dark | 760 | 2,941 | ₹9.8L | 36% | ↑ 18% |
Settings
Company · Users · Roles · Integrations
🏢 Company Profile
👤 User Roles
| Role | Users | Access Level |
|---|---|---|
| Super Admin | 2 | Full Access |
| Branch Manager | 5 | Branch Level |
| Sales Executive | 18 | Sales Only |
| Production Mgr | 4 | Production Only |
| Accountant | 3 | Finance Only |
| View Only | 12 | Read Only |