📊 SOC Monthly Consumption Report Template

A comprehensive Excel-based monthly consumption tracking system for corporate offices managing multiple utilities, supplies, and manpower with automated calculations and summary dashboards.

📋 What This Does

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

📸 View the File

Access SOC Monthly Consumption Report

Password: 123
Template Format: Change date & company name each month
Multi-Company Ready: Duplicate for each company/location

📸 System Screenshots

Monthly Consumption Summary Dashboard

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.

✨ Main Features

1. Summary Dashboard

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

2. Dual Meter Tracking (Electricity & DG)

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

3. Water & Beverage 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

4. Office Supplies Tracking

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

5. Facility Management Items

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

6. Food & Beverage Services

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

7. Manpower Attendance

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

8. Extra Bills Tracking

Additional charges (not regular consumption)
Company, expense type, vendor details
Bill date and amount tracking
Complete audit trail

🚀 How to Use

Quick Start (First Time)

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

Monthly Workflow

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

📊 What You'll See

Summary Dashboard Shows:

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

Example Report:

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

💡 Key Benefits

✅ 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

🔧 Customization

Add New Consumption Item:

Go to relevant sheet (Stationery, HK Material, etc.)
Add new row with:
- Item name
- Vendor
- Units
- Rate
Summary automatically includes it

Change Vendor:

Edit vendor name in consumption sheet
All calculations update automatically
Orders reflect new vendor

Add New Meter:

Add to "Inside Meter" or "OutSide Meter" sheet
Add to Summary for display
Auto-calculated

Multiple Companies:

Copy entire file
Rename file for new company
Change company name in SheetTool
Change date
Start entering data

📈 Real-World Scenarios

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

💼 Technical Skills Demonstrated

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

🎓 Training & Support

How to Navigate:

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

Common Tasks:

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

📞 Contact

For customization or questions:

📄 License

MIT License - Free to use and modify

🌟 Project Stats

📊 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

heysubu/soc-monthly-consumption-report