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
Monthly CAM Bills
UnitMonthCAMElec AmtMaint.ArrearsTotalPaidBalanceStatusAction
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
UnitClientType Nov & Dec 2025 Jan 2026 Feb 2026 Mar 2026 Apr 2026 Total ReceivableTotalBills
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.
UnitDatePreviousCurrentUnits UsedRate/UnitAmountAttachment
Loading…
Meter Usage Check β€” Vacant Unit Discrepancies
🚨 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
β€”
UnitPeriodUnits UsedBooking StatusStatus
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.
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
UnitSub-meter UnitsUsage ShareLoss Share (₨)Applied?
Enter/select a master reading to preview allocation.
Cash Flow Ledger
DateTypeCategoryDescriptionAmount
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.
UnitFloorTypeArea (sq ft)Owner / TenantCAM (₨ / month)
Loading…
Divine Expenses
VoucherDateCategoryDescriptionVendorAmountStatusActions
Loading…
Vendor Directory
Vendor NameCategoryEmailPhoneTotal PaidInvoicesStatus
Loading…
MGC Divine
Bahria Town Phase-8  Β·  Contact: 03087777890
Electricity & CAM Charges Bill
Unit No:
Contact #:
Billing Month:
Location:
Due Date:
Company Name:
Account Details:   Account Title:  
DescriptionAmount (Pkr)
Previous Bill Charged
Arrears
Bill
Actual Bill
Previous Reading
Current Reading
Units Consumed
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)
Signature: ___________________
MGC REAL ESTATE LLP
Bahria Town Phase-8