GS Water Tracker

GS Live Operations, 70-Can Fleet & Wholesale Center

70-Can Demo Data Loaded

Tracks 70 Master Fleet Cans, Partial Empty Returns (+₹170 Deposit), Wholesale Own-Can Refills (@ ₹20), and Net Profit.

Live Can Equation

Master 20L Can Fleet & Availability Breakdown

Formula: Active Shop Cans = Master Fleet − Customer Deposit Cans | Empty Cans = Active Shop Cans − Full Cans

1. Master Fleet

Owned business cans

Damaged/Sold: 0 Cans

2. Held by Customers

20 Cans Deficit

Given on ₹170 deposit (no empty returned)

Refundable Held: ₹3,400

3. Active In-Hand

50 Available

In your shop & EV circulation

Formula: 70 Total − 20 Dep

4. Full Cans Ready

20 Full (20L)

70 Filled − 50 Delivered

Pending Call Queue: 0 Cans

5. Empty Cans (MT)

30 Empty Cans

Waiting in shop for plant refill

Tap to Refill @ ₹9: Est. ₹370

Full Ready (20) Empty in Shop (30) With Customers on ₹170 Deposit (20)

Wholesale Own-Can Custody Tally (@ ₹20) All Tallied

Tracks shop-owned cans collected for refilling vs. handed back so your 70-Can Fleet & Plant Refills never mix up.

In Queue (Collected) 12 Cans

Lifetime Collected / Returned 0 In / 0 Out

Pending Handover 0 Cans

Profitability, Collections & Expense Summary

Compares Customer Water Revenue against Plant Filling Cost (@ ₹9/can) + EV Trip Cost (₹100/trip).

Water Revenue (Sales)

₹0

0 Cans delivered in period

+ Deposit Collected: ₹0

Plant + EV Expenses

₹0

0 Plant trips (0 cans filled)

Water: ₹0 | EV: ₹0

Net Water Profit

₹0

Water Sales minus (Plant + EV)

Forfeited Can Income: ₹0

Collections & Unpaid Dues

Collected: ₹0

Unpaid (Not Paid): ₹0

Cash: ₹0 GPay/UPI: ₹0

Pending Call Queue (To Deliver)

Pending Customer Dues (Not Paid)

Sales by Price Tier & Wholesale

₹20 / ₹30 / ₹35 / ₹40

Area-Wise Demand

Wholesale ₹20 • Shop ₹30 • Ground ₹35 • Upper ₹40

Phone Call / Walk-In / Wholesale

Book Customer Order or Direct Sale

1. Search Customer (Name, Phone, or Area) *

2. Full Cans Given (20L) *

3. Delivery / Wholesale Tier

₹

4. Promised Delivery Time (For Call Queue)

5. Empty Cans Returned vs. +₹170 Deposit +₹170 / extra can

Full Given 1 Cans Out

Empty Returned

Collected Back

+₹170 Deposit ₹0 Extra

Delivering 1 Full Can & collecting 1 Empty Can back. No Deposit

Payment Status (If Direct Sale)

Payment Mode

Water: ₹35 + Deposit: ₹0

Total Bill Amount

₹35

Zero-Lapse Dispatch Tracker 0 Orders | 0 Cans

Confirmed Phone Orders Waiting for Delivery

Tap "Deliver Now" when you hand over the cans at the customer's door.

Daily Delivery Ledger & Unpaid Dues ("Not Paid")

Filter by Customer, Area, Tier, or Payment Status. Flip any Not Paid delivery to Paid (Cash / GPay) in one tap.

Total Unpaid in Market: ₹0

Date	Customer & Area	Qty & Rate	Water (₹)	+Deposit (₹170)	Total Bill	Status & Mode	Quick Action

Customer Master, Lifetime Business & ₹170 Can Deposit Tracker

Maintains Name, Phone, Area, Address, Default Tier, Total Business Given, Pending Balance, and Deposit Cans Held.

Customer Name & Phone	Area & Address	Default Rate	Total Cans Bought	Water Business (₹)	Unpaid Balance	Deposit / Wholesale Tally	Manage / Refund Deposit

Water Manufacturing Plant

Log Plant Refill & EV Trip Expense

Converts Empty Cans into Full Cans in your live stock and logs ₹9/can + ₹100 EV trip cost.

Empty Cans Currently in Shop Available to take to plant right now

Refill Date *

Plant Name

Total Cans Filled (20L) *

Plant Rate / Can (₹)

Includes Wholesale Customer Own-Cans?

Wholesale Own-Cans Filled:

Added to Your 70-Can Fleet: +30 Full Cans

Plant charges ₹9 for all cans, but only Your Fleet Cans increase your 70-Can Shop Full Stock.

Standard EV Trip Cost (₹)

Payment Mode to Plant

Water Cost: ₹270 + EV Trip: ₹100

Total Trip Outflow

₹370

Plant Filling & EV Trip Ledger

Complete log of all trips to the water manufacturing plant.

Total Filled: 70 Cans | Total Spent: ₹830

Date & Plant	Cans Filled	Water Cost (@₹9)	EV Trip Cost	Total Cost	Mode	Action

Master Fleet, Pricing Tiers & Plant Defaults

Edit your 70-can fleet size, ₹20/₹30/₹35/₹40 water rates, ₹170 deposit, ₹9 plant cost, or ₹100 EV trip cost anytime.

Master Total Cans Owned Your total fleet (e.g., 70)

Initial Full Cans Opening full stock before logs

New Can Deposit (₹) Default ₹170 when no empty given

Wholesale Own-Can (₹) Shop's cans filled & returned

Tier 1: Shop Pickup (₹) Customer collects at shop

Tier 2: Ground Floor (₹) Ground floor house delivery

Tier 3: Upper / Lift (₹) 1st Flr No-Lift / Any Floor w/ Lift

Default Plant Refill Rate / Can (₹)

Default EV Trip Charge (₹)

Service Areas / Streets (Comma-separated)

Payment Modes (Comma-separated)

Data Backup, Restore & Fresh Start

Restore JSON Backup

Hostinger Deployment Ready

Host on water.geethashopping.com with Auto-Sync

Just like moneydata.geethashopping.com, drop this index.html + api.php into your subdomain folder for automatic phone-to-desktop cloud sync.

Live Server Sync Status (api.php) Local Browser Mode

The app automatically checks for ./api.php in the same folder. When hosted on your Hostinger subdomain with api.php, every order booked on your mobile phone is saved directly to water_data.json on your server so your desktop sees it immediately!

3-Step Upload Guide for Hostinger hPanel:

Step 1: In Hostinger hPanel → Domains → Subdomains, create water.geethashopping.com.

Step 2: Open Files → File Manager → public_html/water and upload this file as index.html.

Step 3: Click "Download Hostinger api.php Sync Script" above and upload api.php into the exact same folder. Done!

GS Live Operations, 70-Can Fleet & Wholesale Center

Plant Refill Trip Required!

Master 20L Can Fleet & Availability Breakdown

Profitability, Collections & Expense Summary

Pending Call Queue (To Deliver)

Pending Customer Dues (Not Paid)

Sales by Price Tier & Wholesale

Area-Wise Demand

Book Customer Order or Direct Sale

Confirmed Phone Orders Waiting for Delivery

Daily Delivery Ledger & Unpaid Dues ("Not Paid")

Customer Master, Lifetime Business & ₹170 Can Deposit Tracker

Log Plant Refill & EV Trip Expense

Plant Filling & EV Trip Ledger

Master Fleet, Pricing Tiers & Plant Defaults

Data Backup, Restore & Fresh Start

Host on water.geethashopping.com with Auto-Sync

3-Step Upload Guide for Hostinger hPanel:

Complete Delivery

Add New Customer

Customer Name

Wholesale Shop Own-Can Custody Tally

₹170 Deposit Can Return / Resolution

Complete Date-Wise Purchase History

Live Inventory & Profit Calculation Audit

Start Fresh with Empty Ledger?

Enter 4-Digit Security PIN