MGC Divine — CAM & Electricity

Divine — CAM & Electricity

Apartment-owner bills (Electricity + Maintenance + CAM) · Fixed CAM charges · Vendors · Divine cash flow & P&L — live Supabase data

● Real-time

Total Bills

—

Bill Pending

—

Bill Received

—

This month

CAM Charges Total

—

This month

CAM Charges Pending

—

CAM Charges Received

—

As of now

🧾 Electricity Bills

⚡ Meter Readings

🔍 Meter Usage Check

🏭 Master Meter

🏢 CAM Charges

💸 Expenses

🏭 Vendors

💰 Cash Flow

📊 P&L Statement

📒 Receivables Ledger

📚 Bill History

Monthly CAM Bills

	Unit	Month	CAM	Elec Amt	Maint.	Arrears	Total	Paid	Balance	Status	Action
Loading…

Total Receivable

—

Accounts ledger

Bills (to issue)

—

current cycle

Apartments

—

3rd–8th floor

CAM / month

7,500 · 10,000

1 Bed · 2 Bed

CAM + Maintenance Receivables — Month by Month · click any number to edit

Unit	Client	Type	Nov & Dec 2025			Jan 2026			Feb 2026			Mar 2026			Apr 2026			Total Receivable	Total	Bills
Unit	Client	Type																Total Receivable	Total	Bills
Loading…

Total Billed

—

all months

Months

—

billing periods

Apartments

—

billed

Rows Shown

—

after filters

Month Summary

Charges for that month only — arrears are not included

Month	Period	Units	Electricity	Maintenance	CAM	Total	Source File
Loading…

Bill Detail

Unit	Client	Type	Month	Units	Rate	Electricity	Maintenance	CAM	Total
Loading…

Electricity Meter Readings

💡 Add a reading for every unit each month, then use Generate Monthly Bills on the Electricity Bills tab — it auto-pulls each unit's latest reading.

Unit	Date	Previous	Current	Units Used	Rate/Unit	Amount	Attachment
Loading…

Meter Usage Check — Vacant Unit Discrepancies

Flagged only

🚨 Flags a meter reading whose period shows electricity units consumed while the unit had no active Airbnb booking covering that window — i.e. usage nobody can explain because no guest was staying there.

Flagged Periods

—

Total Unexplained Units

—

Unit	Period	Units Used	Booking Status	Status
Loading…

Master Meter — Combined Building Bill

💡 The utility bills ONE combined meter for the whole building. Sub-meters never add up to it exactly — enter the master reading here and the gap (shared/common-area load + line loss) is converted to cost and split across every unit proportional to its own usage, so the total billed always reconciles with the real bill.

Reading Date

Total Bill Amount (₨)

Previous Reading

Current Reading

Master Units

—

This month's combined meter

Sum of Unit Readings

—

All sub-meters this month

Loss / Common Units

—

Loss Cost to Allocate

—

Split by usage share

Per-Unit Allocation Preview

Unit	Sub-meter Units	Usage Share	Loss Share (₨)	Applied?
Enter/select a master reading to preview allocation.

Cash Flow Ledger

Date	Type	Category	Description	Amount
Loading…

P&L Statement

Loading…

Fixed CAM Charges — per unit

💡 Fixed monthly CAM is auto-added to each owner's bill (folded into the electricity total) when you click Generate Monthly Bills. Click any CAM cell to edit it.

Unit	Floor	Type	Area (sq ft)	Owner / Tenant	CAM (₨ / month)
Loading…

Divine Expenses

Voucher	Date	Category	Description	Vendor	Amount	Status	Actions
Loading…

Vendor Directory

Vendor Name	Category	Email	Phone	Total Paid	Invoices	Status
Loading…

MGC DEVELOPMENTS — ELECTRICITY & CAM CHARGES BILL Bahria Town Phase-8 · Contact: 03087777890
Unit No	Billing Month	Reading Date	Due Date
Bill To		Contact #	Location

Description	Amount (Pkr)
Previous Bill Charged
Arrears
Bill
Actual Bill
Electricity Charges
Maintenance Charges (Electricity consumption of Street Lights, Parks, Tube Wells/Turbines, Mosques and Filter Plants)
CAM Charges (Lifts, Common Area Lights, Water Pumps, Fire Fighting, Cleaning) — fixed
Shared Line Loss Adjustment (building's combined meter vs. sub-meters, split by usage share)

Total Amount Payable
After Due Date Payable (incl. % surcharge)

Payment Account Details
Account Title	Account No