👥
0
Active Customers
—
🥛
0 L
Today's Delivery
—
📅
0 L
This Month
—
₹
₹0
Monthly Revenue
—
⚠️
₹0
Total Dues
—
💳
₹0
Collected (Month)
—
📈 Monthly Delivery Trend
Litres delivered per day this month
🥛 Milk Type Distribution
Customer count by milk type
💰 Revenue vs Collections
Last 6 months billed vs collected
🏆 Top Customers by Volume
| Customer | Route | Daily (L) | Rate ₹/L | Monthly Bill | Balance | Status |
|---|---|---|---|---|---|---|
| No customers yet | ||||||
All Customers
0 customers
| # | Name | Mobile | Area / Route | Milk Type | Daily Qty | Rate ₹/L | Balance | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| No customers yet | |||||||||
Rates & Pricing Plans
Set different rates per milk type & customer
| Milk Type | Rate (₹/Litre) | Effective From | Notes | Customers Using | Actions |
|---|---|---|---|---|---|
| No rate plans yet. Add one to get started. | |||||
💡
You can override individual customer rates in the customer profile. Rate plans are just default templates.
📋 Today's Delivery Sheet
—
0
Total Customers
0
Delivered
0
Pending
0 L
Total Quantity
| # | Customer | Area | Milk Type | Qty (L) | Rate | Amount | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| No active customers | ||||||||
Delivery History
—
| Date | Customer | Milk Type | Qty (L) | Rate | Amount | Status | Remarks | Actions |
|---|---|---|---|---|---|---|---|---|
| No delivery records | ||||||||
Monthly Bills
—
0
Bills Generated
₹0
Total Billed
₹0
Pending Collection
| Customer | Deliveries | Total Qty (L) | Bill Amt | Paid | Balance | Status | Actions | |
|---|---|---|---|---|---|---|---|---|
| Select a month and click Generate Bills | ||||||||
Payment Records
| Date | Customer | Amount | Mode | Month For | Remarks | Actions |
|---|---|---|---|---|---|---|
| No payments recorded | ||||||
⚠️ Dues & Overdue Alerts
⏳
Loading dues...
📤 Import Data
Upload Excel or CSV files to bulk-add customers or delivery entries
📋 Step 1 — Download Template
Use this exact format for uploading customers
Required columns:
Name, Mobile, Address, Route, MilkType, DailyQty, Rate, Slot, StartDate, Status
• MilkType: Full Cream / Toned / Double Toned / Skimmed / Buffalo
• Slot: Morning / Evening / Both
• Status: Active / Paused / Closed
• StartDate: YYYY-MM-DD format
• Slot: Morning / Evening / Both
• Status: Active / Paused / Closed
• StartDate: YYYY-MM-DD format
📤 Step 2 — Upload File
Supports .xlsx, .xls, .csv files
Click or drag & drop your file
.xlsx / .xls / .csv supported
⚙️ Business Settings
Customize your business info shown on invoices & reports
🏢 Business Identity
This appears on your invoices and bills
🥛
Click to change logo
📞 Contact Information
Shown on invoices for customer reference
📍 Address & Payment
Address and payment details for invoices
🧾 Invoice Settings
Customize how invoices look
📲 Payment QR Code
Upload your UPI/PayTM QR — shown on every invoice
📲
Click to upload QR
Upload a screenshot of your PhonePe / Google Pay / PayTM QR code. It will appear on every invoice automatically.
👁 Invoice Preview
How your invoice header will look
🥛
DudhWala
Milk Delivery
📞 —
📍 —
💳 UPI: —
🔗
Google Sheets Sync
Access your data on any device — phone, tablet, laptop
⬤ Not Connected
📋 Setup Instructions (one time, ~5 minutes)
1Go to sheets.google.com → Create new sheet → Name it "DudhWala Data"
2Click Extensions → Apps Script → Delete all code → Paste the script (see button below) → Click 💾 Save
3Click Deploy → New deployment → Web app → Set "Who has access" to "Anyone" → Click Deploy
4Copy the Web App URL → Paste below