✏️ Edit Payment Entry — Admin
🔐 Admin PIN required to edit:
✏️ Edit Finance Entry
✏️ Edit Invoice
💡 Edit Taxable + GST → Total auto-updates, or edit Total → Taxable/GST auto-split at 5%
AWG Ops Platform BUILD 2026-08-01-A
● LIVE
--:--:--
Secure Access
K2 Global
AWG Operations Platform
👁
❌ Invalid credentials — please try again
K2 Global · AWG Water Operations · Secure Platform
🔐 K2 Global Login
➕ Register New AWG Plant
✏️ Edit Plant Details — Le Meridien New Delhi
💰 Add Payment Receipt
K2 Global
|
Admin Panel
📊 Overview
👤 Create User
📋 All Users
🔐 Permissions
🔑 Change Password
💾 Backup & Restore
Dashboard Overview
User accounts and access summary
—
Total Users
—
Admins
—
Ops / QC / Fin
1
Active Plants
All User Accounts
NameUser IDRolePagesPlantActions
Create New User
Add a new user account with role and page permissions
Account Details
👁
Page Access Permissions
⚙ Operations
Daily data entry, flow meters, OEE
🔬 Quality Control
pH, TDS, turbidity readings
📄 Revenue & Invoices
Invoice register and revenue totals — no expenses
₹ Full Financials
P&L, expenses, CAPEX, margins — restricted
📦 Consumables
Inventory and stock management
🧫 Lab Observations
Lab reports and taste & odour log
📈 Sales Pipeline
Premium bottle leads — HoReCa kanban
All Users
Manage existing accounts — click a row to edit inline
NameUser IDPasswordRolePagesPlantActions
Permissions Matrix
Toggle which sections each user can access — unsaved changes are highlighted in blue
Loading users…
City Allocation — Sales Pipeline
Sub-folders per city, shown as filter pills on the Sales Pipeline board. Allocating a city to a rep just sets their default view — everyone can still see every city.
Loading users…
Change Password
Update password for any user account
👁
👁
💾 Backup & Restore
Finance, QC, Ops, Lab, Consumables, Invoices — all data
⚠️ First-Time Setup — Each Device Pushes Once
Every device (Admin laptop, Finance laptop, etc.) needs to push its local data to the server once. After all devices have pushed, the server has the complete merged dataset and all users stay in sync automatically.
Automatic backups run every 2 hours. Last 24 snapshots (48 hrs) kept on Hostinger.
Click "Refresh List" to see available backups.
K2 Global / Fleet Overview
Live
Revenue YTD − Operational Expenses YTD (Sep–Feb)
Loading...
Sep 2025 – Feb 2026 · Le Meridien New Delhi · All data from Excel
Revenue YTD
₹—
Op.Expenses (Sep–Feb)
₹—
Total All Expenses
₹88.1L
Total Deployed (CAPEX+All)
₹1.26Cr
Fleet KPIs — FY 2025–26
📦 Bottles YTD ↗
4,79,352
Sep'25–Feb'26
💰 Revenue YTD ↗
₹54.4L
₹54,40,509 (Sep–Feb)
📊 Total Expenses ↗
₹88.1L
Per Excel summary
Active Plants
1
1 registered
📅 Latest Month ↗
₹8.71L
₹8,70,975 (Feb'26)
Plants — Click to open dashboard
Le Meridien New Delhi
📍 Windsor Place, New Delhi 110001
● ACTIVE
7.4
pH
42
TDS ppm
3,240
Btl/day
Tank Alpha72%
Tank Beta55%
Watergen GEN-150 · 2 Units · 2×2,000L→
+
ADD NEW PLANT
Register AWG facility
Monthly Performance
Monthly Bottles
Revenue vs Op.Expenses
Revenue
Op.Expenses
Le Meridien New Delhi
Windsor Place, New Delhi 110001 · Plant ID: AWG-LM-DEL-001 · Est. Sep 2025
Watergen GEN-150 · 2 Units AWG Cap: 1,200 L/day Bottle Cap: 6,000/day 2 × 2,000L SS Tanks
🧫 Lab Obs
Live Sensor Readings
Live
pH Level
🧪
7.4
✓ Optimal · Range 6.5–8.5
TDS Level
💧
42ppm
✓ Below 100 ppm
Bottles Today ↗
🍶
3,240
▲ +4% vs yesterday · Click for hourly
AWG Output
🌊
847L
Target 1200L · 71%
Storage Tanks
2×2,000L SS
Tank Alpha
2000L1000L0L
1,440 L
72%
Tank Beta
2000L1000L0L
1,100 L
55%
Tank Alpha72%
Tank Beta55%
Daily Goal71%
Bottling Line A88%
Live Trend (3s)
pH×10
TDS ppm
Btl÷20
AWG L/hr÷10
System Status
8 sensors
AWG Unit 1 (GEN-150)
28.4°C · 75% RH
RUNNING
AWG Unit 2 (GEN-150)
28.1°C · 74% RH
RUNNING
RO Membrane
1.2 bar
NORMAL
Carbon Filter B (20" BigBlue)
Maintenance
DUE
UV Sterilizer 254nm
30mJ/cm²
ACTIVE
Bottling Line (Shree Bhagwati)
88% cap
RUNNING
125 KVA Servo Stabilizer
230V · 50Hz
ONLINE
Air Compressor
6.0 bar
RUNNING
AWG Hourly Generation — Data Entry (Plant Team)
Enter Actual AWG Generation per Hour
Enter hourly L/hr readings
Hours Entered
0 / 24
Total Generated Today
0.0 L
GEN-L Model Expected
— L
Quick fill: Operator ID:
AWG Generation vs Weather — Date & Hour Wise Correlation
ℹ️ Weather data from Open-Meteo API for Windsor Place, New Delhi (28.6139°N, 77.2090°E). Hourly AWG generation from Cost Sheet 2 flow meter data (93 days: Nov'25–Jan'26). Actual vs GEN-L model output shown per hour. Select date to view correlation.
Select Date for Hourly Analysis
Loading...
Avg Temp
—
Avg Humidity
—
Actual AWG Total
—
Model AWG Total
—
Actual AWG L/hr (Flow Meter)
GEN-L Model Output (Temp+Humidity)
Humidity % / 1.5
Hourly Correlation Table
—
HourTemp (°C)Humidity (%)Wind (km/h)GEN-L Model (L/hr)Actual AWG (L/hr)VarianceMatch %
Select a date above to load data
Today Hourly Bottles
AWG Daily Generation History
Last 30 days
Actual (L)
Projected (L)
📊 Actual vs Projected Generation — Flow Meter Analysis
Actual AWG (L/day)
Projected (GEN-L model, L/day)
% Achieved
pH Level
7.4
Optimal: 6.5 – 8.5
TDS Level
42 ppm
Max 100 ppm (BIS)
QC Pass Rate
98.7%
Target ≥ 98%
QC Log Entry — Staff enter details below with their login ID
New QC Check Entry
Purification Stage — Date-wise QC Summary
Stage × Date Matrix
—
Real-time
No entries yet.
OK / Pass / Cleaned Attention Fail Replaced Test / Lab
✏️ Edit QC Entry
🧑‍💼 Logged by: —
➕ Log QC Entry
Stage
—
Date
—
Time recorded automatically at save
24h pH Log
Within Range
24h TDS Log
Below Limit
Revenue YTD − Expenses YTD (Le Meridien)
Loading...
Sep 2025 – Feb 2026
Revenue YTD
₹54,40,509
Op. Expenses YTD
₹37,52,696
CAPEX
₹37,60,874
ℹ️ About the ₹88.1L figure: The Excel Summary Sheet shows Total Expenses = ₹88,11,425. This includes: Pre-operation expenses Apr–Aug'25 (₹49.4L: setup, rent, salaries, equipment before revenue started) + Operational expenses Sep'25–Feb'26 (₹38.7L). The ₹76.3L shown previously was CAPEX ₹37.6L + OpEx ₹38.7L (Sep-Feb only). Full picture below includes all three components.
ROI — Full Investment Recovery Analysis
Revenue YTD (Sep'25–Feb'26)
₹54.4L
4,79,352 bottles invoiced
CAPEX (Equipment / Machinery)
₹37.6L
Machinery, tanks, bottling line
Pre-Op Expenses (Apr–Aug'25)
₹49.4L
Setup period before revenue
Operational Expenses (Sep–Feb)
₹38.7L
Salary, elec, consumables, water
Total Investment (All-In)
₹88.1L
Pre-Op + Sep-Feb OpEx
Net P&L vs OpEx Only
Calculating…
Revenue − OpEx only: —
Revenue vs Total All-In Investment (Pre-Op + OpEx = ₹88.1L)
—
Total Deployed: ₹88,15,791 Est. break-even: ~4 months Revenue So Far: ₹54,40,509
Month-on-Month Summary — Income & Expenditure
MoM P&L Table
Sep'25–Feb'26
MonthBottlesJarsRevenue (₹)Op.Expenses (₹)Monthly P&L (₹)Cumulative Rev (₹)Cumul. P&L (₹)Payment
Add Invoice / Transaction
New Entry
🧾 Create GST Tax Invoice Generates a printable tax invoice and auto-adds it to revenue
SR
PRODUCT
DESCRIPTION
HSN CODE
QTY
RATE
AMOUNT
Taxable Amount₹0.00
CGST₹0.00
SGST₹0.00
IGST₹0.00
TOTAL₹0
Income & Expenditure
Payment Tracker
Short/Excess
DATEINVOICE (Billing Period)DESCRIPTIONBILLED (₹)(-) ELECTRICITY (₹)(-) WATER (₹)NET RECEIVABLE (₹)RECEIVED (₹)SHORT / EXCESSSTATUS
Total Billed (Gross):₹0
(-) Electricity Debits:₹0
Total Net Receivable:₹0
(-) Water Charges:₹0
Total Received:₹0
Outstanding (Net):₹0
Monthly Rev vs Exp
Revenue
Op.Expenses
Manually Added Entries
DateInvoiceBottlesTypeCategoryDescriptionAmount (₹)Actions
No manual entries yet. Use form above.
Invoice Register — Complete (144 invoices Sep'25–Feb'26 · Direct from SALE INV sheet)
All Sale Invoices
DateInvoice No.BottlesJarsTaxable (₹)GST (₹)Total (₹)Actions
CAPEX Register
DateDescriptionSupplierAmount (₹)
Monthly Expense Register — All Months Editable
Monthly Expenses · Sep'25–present
Month Bottles Revenue (₹) Salary (₹) Electricity (₹) Water (₹) Purchase (₹) Travel (₹) Transport (₹) Misc (₹) Total OpEx (₹) P&L (₹) Actions
✏️ Edit Monthly Expenses
Expense Breakdown
P&L preview will show here
📄 Revenue & Invoices — Le Meridien Invoice register and monthly revenue — no expense visibility
Total Invoiced
—
Invoice Count
—
Total Bottles
—
Avg per Invoice
—
Invoice Register
DateInvoice No. BottlesJarsTaxable (₹) GST (₹)Total (₹)
Consumables Register — All Items Editable
#Item NameCategoryUnitIn StockMin StockSupplierUnit Cost (₹)Status / Actions
Receive Stock
Stock Receipt
Stock Movement Log
DateItemTypeQtyCostSupplierBy
No stock movements yet.
Filter Cleaning Timeline
Sales Pipeline
Premium bottle leads — restaurants & cafes · HoReCa channel
➕ Add Lead
Decides which plant's invoicing this client can be billed from — connects the client (under its Legal Company Name, if set) to that plant\'s Buyer list immediately, whether or not this lead has been marked Won yet.
⬆ Import Leads (CSV)
Name (required) · Category (Restaurant/Hotel) · Segment · Source · City · Area · Address · Contact · Phone · Email · Interest (hot/medium/low) · AssignedTo (rep name) · FollowUp (YYYY-MM-DD) · Notes
Column order doesn't matter, and unrecognized columns are ignored. Download a blank template →
⚙ Manage Clients
Tick clients to delete, or tick exactly one and set it as default (⭐ pre-fills the Client field on new invoices). Click a client's name to edit its address/GST/PAN. Which plant supplies a client is set from Sales Pipeline → Edit Lead → Supplying Plant, not here.
🔧 Repair Revenue Entries
These invoices exist but are missing from Revenue & Invoices / monthly totals. Tick the ones you actually want reinstated — a trial or test invoice you don't need can instead be deleted outright, freeing up its number.
⚙ Products & Pricing
Base rate escalates automatically on the existing schedule from whatever starting point you set here. Change a price, then Save.
📊 Bottle Projections — Won Leads
Daily volume is set (or updated) when a lead moves to Won — open any Won lead and edit "Daily Bottle Projection" to change it anytime. Weekly = daily × 7, Monthly = daily × 30. Grouped city by city with a subtotal each, combining both Restaurants/Cafes 🍽 and Hotels 🏨, plus a grand total at the bottom.

Imports & Inventory

330 ml canned water — Still & Sparkling · imported from Abu Dhabi · sold by Rashi Renewable Energy Pvt Ltd
Purchase Orders to the Abu Dhabi supplier (in AED) — release, track and fulfil.
Coming in the next phase.
Log each import against a PO — shipment / BL details and landed-cost build-up (goods + freight + insurance + duty) at the AED→INR rate.
Coming in the next phase.
Supply stock to hotels & restaurants — a delivery note that draws down inventory (FIFO) and feeds the sale invoice.
Coming in the next phase.
Raise GST sale invoices to cafes & restaurants — reusing your existing invoice engine and client master.
Coming in the next phase.
Record payments against sale invoices and track outstanding receivables.
Coming in the next phase.
📦
Bottles Produced
Le Meridien, New Delhi · Sep 2025 – Feb 2026
📝
Financial Data Entry
Admin · Accounts · Corrections & Future Entries
USER ID PIN
🔒 Please login to access data entry
📦
Plant-Wise Drill-Down
Le Meridien, New Delhi · Sep 2025 – Feb 2026
📝
Financial Data Entry
Admin · Accounts · Corrections & Future Entries
USER PIN
🔒 Please login with your User ID and PIN to access data entry
K2 Global — Admin
Sign in with your admin credentials