A comprehensive Excel-based monthly consumption tracking system for corporate offices managing multiple utilities, supplies, and manpower with automated calculations and summary dashboards.
Solves the problem: How to track and manage all office consumptions (electricity, water, stationery, food, tea/coffee, medical items, security guards) in one place with automatic calculations and monthly summary reports.
Key Benefits:
- Track all office consumptions in one template
- Automatic calculations (no manual math needed)
- Monthly summary dashboard view
- Multi-meter tracking (inside & outside)
- Vendor consumption tracking
- Attendance management for security & housekeeping
- Easy monthly reporting
- Password protected for data security
Access SOC Monthly Consumption Report
Password:
123Template Format: Change date & company name each month Multi-Company Ready: Duplicate for each company/location
Complete monthly summary dashboard showing all consumption categories, electricity/DG readings from multiple meters, vendor-wise consumption, and automatic calculations for closing stock and order amounts.
- One-page overview of all monthly consumption
- Date & Company fields (change monthly)
- Electricity & DG readings from inside and outside meters
- All consumption items summarized with costs
- Automatic calculations for closing stock and orders
Inside Meter:
- ELC Reading UPS Room (Electricity)
- Reading AHU Room Water Chiller (HVAC)
- BTU Reading tracking
- Daily opening & closing readings
- Automatic consumption calculation
Outside Meter (MSEB):
- Mantri Office Utility MSEB & DG Meter
- Utility EB (KWH) & KVAH
- Utility DG (KWH) & KVAH
- Mantri Building Meter readings
- A-Wing Chiller Panel tracking
Bisleri Water Consumption:
- Order tracking
- Total stock management
- Daily usage
- Closing stock calculation
- Auto-calculates order amounts
Multiple Tea/Coffee Machines:
- Veebha Tea & Coffee
- Sumant Tea & Coffee
- Individual vendor tracking
- Daily consumption records
- Automatic cost calculation
Stationery:
- 100+ item types
- Spring files, envelopes, folders, pens, tape, etc.
- Opening stock & orders
- Daily consumption
- Automatic closing stock
Toner Consumption:
- Multiple printer toner types
- Compatible cartridges
- Laser toners
- Epson ink cartridges
- Per-item tracking
Housekeeping Material:
- Handwash, dish wash, cleaning products
- Garbage bags, dusters, scrub pads
- Opening stock tracking
- Daily consumption
- Automatic order calculation
Medical Items:
- First aid supplies
- Volini sprays, creams, powders
- ORS packets, cotton, bandages
- Usage tracking
Food Consumption:
- Daily lunch & dinner orders
- Multiple caterer support
- Order & count tracking
- Automatic calculations based on weekends
Water Service:
- Daily delivery tracking
- Jar management
- Daily usage calculation
- Rate-based costing
Security Guard Attendance:
- Gallant PVT LTD guards
- OOPL guards
- Daily P/A/WO/HD marking
- Automatic salary calculations
- Monthly totals
Housekeeping Attendance:
- Imperial HK staff
- Multiple designations (Pantry Boy, HK Boy, Cleaning Manager)
- Daily attendance tracking
- Per-day salary calculation
- Monthly reporting
- Additional charges (not regular consumption)
- Company, expense type, vendor details
- Bill date and amount tracking
- Complete audit trail
Step 1: Download & Open
- Download file from link above
- Open in Microsoft Excel
- File is password protected (Password: 123)
Step 2: Set Monthly Details
- Go to "Summary" sheet
- Change Date (cell in SheetTool)
- Change Company Name (cell in SheetTool)
- All sheets automatically update with new date/company
Step 3: Enter Daily Data
-
Open each consumption sheet:
- Inside Meter (daily readings)
- OutSide Meter (daily readings)
- Bisleri_Consu (daily units)
- Medical_Items (daily usage)
- Stationery (daily usage)
- HK Material (daily usage)
- Food Consu (daily orders/count)
- Veebha Tea&Coffee (daily consumption)
- Sumant Tea&Coffee (daily consumption)
- Toner Consu (daily usage)
- Water (daily delivery/usage)
- Gallant SG (daily attendance)
- OOPL SG (daily attendance)
- Imperial HK (daily attendance)
-
Enter readings/usage in yellow cells only
-
All calculations are automatic
Step 4: View Summary
- Go to "Summary" sheet
- See all calculations automatically updated
- Print or save for records
1. MONTH START
├─ Set date in SheetTool
└─ Set company name
2. DAILY ENTRY (Throughout month)
├─ Security guard logs attendance
├─ Housekeeping staff logs attendance
├─ Reception logs meter readings
├─ Facility manager logs consumption
└─ Vendors log deliveries
3. MONTH END
├─ Review Summary sheet
├─ Check all calculations
├─ Export to PDF
└─ Archive & copy for next month
4. NEXT MONTH
└─ Copy this month's file
└─ Change date
└─ Change company name
└─ Start fresh entries
Electricity & DG Section:
- Inside Meter readings (UPS Room, AHU Room, BTU)
- Outside Meter readings (MSEB EB, DG, Building, A-Wing)
- All in standard units (KWH, KVAH, etc.)
Consumption Summary Table:
- Bisleri: Order, Total Stock, Usage, Closing Stock, Usage Amount, Closing Amount
- Medical Items: Order details, consumption, costs
- Stationery: 100+ items with stocks and usage
- HK Material: All cleaning supplies with tracking
- Food Consu: Daily orders and consumption
- Tea/Coffee: Vendor-wise consumption
- Toner: Printer supplies tracking
- Water: Jar delivery and usage
- Security Guards: Attendance & salary summary
- Housekeeping: Attendance & salary summary
MONTH: February 2026
COMPANY: SOC
ELECTRICITY & DG:
├─ Inside Meter - UPS Room: 1,078.00 KWH
├─ Inside Meter - AHU Room: 7,947.60 HVAC
├─ Outside Meter - MSEB EB: 6,940.00 KWH
├─ Outside Meter - DG: 80.00 KWH
└─ Building Meter: 89,894.00 KWH
CONSUMABLES SUMMARY:
├─ Bisleri Water: 20 units | Cost: ₹915.28
├─ Medical Items: 119 units | Cost: ₹3,263.99
├─ Stationery: 1,544 items | Cost: ₹16,382.12
├─ HK Material: 1,984 units | Cost: ₹51,402.50
├─ Food Orders: 0 orders | Cost: ₹0
├─ Veebha Coffee: 164 units | Cost: ₹24,960.00
├─ Sumant Coffee: 3,153 units | Cost: ₹19,120.56
├─ Toner: 10 cartridges | Cost: ₹6,000.00
├─ Water: 259 jars | Cost: ₹9,065.00
├─ Gallant SG: 4 guards | Cost: ₹34,721.87
├─ OOPL SG: 8 guards | Cost: ₹88,091.67
└─ Imperial HK: 12 staff | Cost: ₹113,108.17
TOTAL MONTHLY CONSUMPTION: ₹366,411.96
✅ All-in-One Tracking: Everything in one monthly template
✅ Automatic Calculations: No manual math needed
✅ Multi-Meter Support: Inside & outside readings
✅ Multi-Vendor Ready: Track multiple vendors
✅ Easy Data Entry: Simple yellow-cell entry system
✅ Password Protected: Secure data with password 123
✅ Multi-Company: Copy for each company/location
✅ Audit Trail: Complete monthly records
✅ No Formulas to Edit: Everything is set up
✅ Monthly Reports: Summary ready to print/email
- Go to relevant sheet (Stationery, HK Material, etc.)
- Add new row with:
- Item name
- Vendor
- Units
- Rate
- Summary automatically includes it
- Edit vendor name in consumption sheet
- All calculations update automatically
- Orders reflect new vendor
- Add to "Inside Meter" or "OutSide Meter" sheet
- Add to Summary for display
- Auto-calculated
- Copy entire file
- Rename file for new company
- Change company name in SheetTool
- Change date
- Start entering data
Scenario 1: Monthly Cost Control
Manager sees stationery costs ₹16,382 (highest expense)
Reviews consumption - finds excessive ordering
Reduces order quantity by 20%
Next month stationery costs: ₹13,100 (20% reduction)
Annual savings: ₹39,384
Scenario 2: Utility Monitoring
Electricity outside meter jumped from 6,940 to 8,200 KWH
Facility manager investigates
Finds A-Wing chiller running extra hours
Adjusts maintenance schedule
Next month normalized to 7,100 KWH
Saves ₹30,000+ monthly
Scenario 3: Attendance & Payroll
Security attendance tracked automatically
Gallant SG: 4 guards, ₹34,721.87 total
OOPL SG: 8 guards, ₹88,091.67 total
Imperial HK: 12 staff, ₹113,108.17 total
Total manpower cost: ₹235,921.71
HR knows exact payroll instantly
- Excel template design
- Advanced formulas (SUM, COUNTIF, automatic calculations)
- Multiple sheet management (17 worksheets)
- Data organization & structure
- Facility management knowledge
- Multi-category tracking
- Password protection
- Monthly reporting automation
- Employee attendance systems
- Utility consumption management
- Summary: Main dashboard (view only)
- Extra Bills: Add irregular charges
- Inside/Outside Meters: Enter daily readings
- Consumption Sheets: Enter daily usage
- Attendance Sheets: Mark daily attendance
Q: How to enter meter reading? A: Go to "Inside Meter" or "OutSide Meter" → Enter opening & closing readings in yellow cells → All calculations automatic
Q: How to add new employee? A: Go to attendance sheet (Gallant SG, OOPL SG, Imperial HK) → Add row with name & designation → Per-day salary calculates automatically
Q: How to change monthly date? A: Go to SheetTool → Change date in yellow cell → All sheets update automatically
Q: Can I protect individual sheets? A: Yes, password is 123 → Right-click sheet → Protect sheet
Q: How to copy for next month? A: Save as new file → Go to SheetTool → Change date → Reset all consumption to zero → Save
For customization or questions:
MIT License - Free to use and modify
📊 Track Everything - Manage All Consumptions - Control Costs - Easy Reporting
⭐ If this helps your facility management, please star this repository!
💬 Questions? Open an issue and I'll help you get started!
Password: 123 | 17 Worksheets | Multi-Company Ready