💧 Water Supporting

Comprehensive Excel-based water consumption tracking system with vendor management, daily consumption analysis, invoice generation, attendance-based water billing, and professional dashboards for multi-company water management.

📋 What This Does

Solves the problem: How to track water consumption across multiple companies, manage water vendors and jar rates, generate invoices, monitor daily consumption trends, and link water usage to employee attendance for accurate billing.

Key Benefits:

• Daily water consumption tracking
• Multi-vendor water supply management
• Attendance-based consumption analysis
• Automatic invoice generation
• Month-wise billing calculation
• Day-wise delivery jar tracking
• Professional printable bills
• Tax calculation (CGST/SGST)
• Company-wise consumption analytics
• Vendor rate management

📸 View the File

Access Water Supporting Template

Password: 123 Note: Multiple sheets with daily, attendance, and billing data

---

📸 System Screenshots

Professional Water Consumption Dashboard

Professional dashboard for UrbanCraft Digital Brands showing vendor (Daya Enterprises), rate (₹35/jar), daily consumption tracking (28-30 jars), basis amount calculations, and monthly invoice trend chart.

Vendor Management & Billing Sheet

Vendor configuration sheet with company names, assigned vendors, contract months (Apr-24 onwards), rates (₹35-100 per jar), and tax settings (CGST 3%, SGST 3%).

Daily Water Consumption Data

Detailed daily tracking with date, company, vendor, opening jars, daily consumption, total cost, employee count, and per-employee cost for accurate billing and analysis.

---

✨ Main Features

1. Dashboard (Professional Report)

• Company Name & Vendor Details: Header with billing information
• Rate Display: Current jar rate (e.g., ₹35/jar)
• Monthly Tracking: Current month identification
• Daily Consumption Table:
  • Date & day of week
  • Opening jars from previous day
  • Daily jars delivered
  • Consumption amount
  • Total cost calculation
  • Employee count on that day
  • Per-employee cost
• Month-Wise Invoice Amount:
  • Delivery jar amount
  • Net amount calculation
  • CGST (3%)
  • SGST (3%)
  • Total invoice amount
• Charts:
  • Day-wise delivery jar chart
  • Month-wise invoice amount chart
• Basis Amount Table:
  • Monthly delivery amount
  • Monthly consumption amount
  • Basis amount comparison
• Print-Ready Format: Ctrl+P generates professional bill

2. Daily Data Sheet

• 1000+ daily consumption records
• Date & day tracking
• Company name for each entry
• Vendor assignment
• Rate per jar
• Opening jar (previous day closing)
• Daily jars delivered
• Daily consumption amount
• Employee count (attendance data)
• Cost calculation per jar

3. Attendance Data Sheet

• Daily employee attendance by company
• Attendance by date
• Employee count per day
• Company-wise attendance
• Links to water consumption
• Attendance-based billing correlation

4. IMP (Invoicing) Sheet

• Vendor management list
• Company names
• Assigned vendors
• Contract months (Apr-24 onwards)
• Jar rates (₹35-100 per jar)
• CGST percentage (3%)
• SGST percentage (3%)
• Easy rate updates
• Vendor consolidation

5. Invoice Generation

• Automatic calculation
• DL Jar amount (delivery)
• Net amount (consumption)
• Tax calculation (CGST + SGST)
• Total invoice amount
• Month-wise invoicing
• Print-ready bills

6. Company-Wise Analysis

• DirectEdge Marketing Solutions LLP (1000+ records)
• Optima Digital Ventures LLP
• Xponential Tech Innovations Pvt Ltd
• UrbanCraft Digital Brands Pvt Ltd
• And multiple other companies
• Company consumption patterns
• Company vendor assignments

7. Vendor Rate Management

• Daya Enterprises (Rate: ₹35/jar)
• NextGen Tech Systems (Rate: ₹100/jar)
• Multiple vendor support
• Rate configuration
• Easy rate updates
• Vendor-wise tracking

8. Monthly Consumption Analysis

• Month-wise consumption totals
• Month-wise delivery amounts
• Invoice generation per month
• Monthly trend analysis
• Consumption patterns
• Budget tracking

🚀 How to Use

Step 1: Open File

1. Download from link above
2. Open in Excel
3. Enable macros if prompted
4. Ready to use

Step 2: Configure Vendors & Rates

1. Go to "IMP" sheet
2. Add/update vendor information:
   • Company name
   • Assigned vendor
   • Contract month
   • Rate per jar (₹)
   • CGST %
   • SGST %
3. Save changes
4. Auto-applies to all records

Step 3: Enter Daily Consumption

1. Go to "Daily Data" sheet
2. Add new records:
   • Date & day of week
   • Company name
   • Vendor name
   • Opening jars (previous closing)
   • Daily jars delivered
   • Consumption amount
   • Employee count (from attendance)
3. Costs auto-calculate

Step 4: Record Attendance

1. Go to "Attendance Data" sheet
2. Enter daily employee count:
   • Date
   • Company name
   • Employees present
3. Links to water consumption
4. Used for per-employee cost

Step 5: View Company Dashboard

1. Go to "Dashboard" sheet
2. Select company from dropdown
3. View complete analysis:
   • Monthly consumption
   • Daily tracking
   • Cost breakdown
   • Invoice amounts
4. All charts auto-update

Step 6: Generate Bills

1. Configure dashboard for company
2. Press Ctrl+P
3. Print professional bill
4. Include with payment
5. Easy for audit department

Step 7: Analyze Trends

1. View "Pivot Chat" sheet
2. See consumption patterns
3. Monthly comparisons
4. Vendor performance
5. Identify peak usage

📊 Real-World Usage

Multi-Company Water Tracking:

DirectEdge Marketing Solutions LLP:
- 1000+ daily records tracked
- Multiple jars per day (0-1085 liters)
- Consumption varying: 58-1085 liters/day
- Rate: ₹35 per jar
- Monthly billing automatic

Attendance-Based Billing:

Day: 02-03-2026
Company: UrbanCraft Digital Brands
Attendance: 22 employees
Opening Jars: 6
Daily Delivery: 6 jars
Consumption: ₹210
Per Employee Cost: ₹9.55

Monthly Invoice Generation:

Month: Mar-26
Company: UrbanCraft Digital Brands
DL Jar Amount: ₹380
Net Amount: ₹380
CGST (3%): ₹24.50
SGST (3%): ₹24.50
Total Invoice: ₹1,023

💡 Key Benefits

✅ Multi-Company Tracking: Track 10+ companies simultaneously
✅ Attendance Integration: Link water to employee count
✅ Vendor Management: Manage multiple water vendors
✅ Auto Invoice Generation: Calculate bills automatically
✅ Professional Dashboards: Company-wise detailed analysis
✅ Tax Calculation: Auto CGST/SGST computation
✅ Printable Bills: Ctrl+P generates ready-to-print bills
✅ Daily Tracking: 1000+ daily records management
✅ Trend Analysis: Identify consumption patterns
✅ Cost Optimization: Per-employee cost visibility

🔧 Customization

Add New Company:

1. "IMP" sheet → Add company name
2. Assign vendor & rate
3. Configure CGST/SGST
4. Auto-available in daily data

Change Water Rate:

1. "IMP" sheet → Update rate
2. Auto-applies to all new records
3. Month-wise tracking maintained
4. Invoice recalculates

Modify Tax Rate:

1. "IMP" sheet → Update CGST/SGST
2. Applies to new invoices
3. Historical data preserved
4. Easy audit trail

Add New Vendor:

1. "IMP" sheet → Add vendor name
2. Assign to companies
3. Set rate & terms
4. Start tracking

📞 Contact

• 🐙 GitHub
• 💼 LinkedIn

📄 License

MIT License - Free to use and modify

---

🌟 Project Stats

---

💧 Track Water Consumption - Manage Vendors - Generate Invoices - Optimize Costs

⭐ If this helps manage your water resources, please star this repository!

Password: 123 | Multi-Company | Invoice Ready