Set billing period each month before entering readings. Building codes are fixed (Hilton=4 | Borgo Retail=8 | Borgo Res=7 | Bloem=9). All changes sync live between both users.
Active Tariff
—Prepaid units skipped automatically. Enter previous and current readings — usage and Rand value calculate instantly. Previous readings persist from last save.
| Unit | Tenant | Code | Prev Reading | Current Reading | Usage (kWh) | Rand Value | Status |
|---|
Shop 1&2 has 2 electricity meters. Shops 4 and 5 have 3 electricity meters each. Enter opening & closing per meter — usage per meter is shown, combined usage and one cost figure per tenant. All other shops enter a single reading pair. Previous readings persist.
| Shop / Meter | Tenant | Code | Prev (kWh) | Current (kWh) | Usage | Season | Usage Cost | Fixed Share | Total (incl VAT) |
|---|
Retail: CoJ business tariff, levy shared. Shop 1&2 has 2 water meters — enter each separately, combined usage used for billing. Fixed (MRI auto, not in CSV): Shop 3 water R450/sewer R450 · Shop 7 sewer R229.40 · Res Unit 13 water R273.
Residential: Stepped tariff — water only.
Residential: Stepped tariff — water only.
Retail — Water & Sewer
WT00SE00| Shop / Meter | Tenant | Code | Prev (KL) | Current (KL) | Usage | Water (ex VAT) | VAT | Water Total | Sewer Total |
|---|
Residential — Water
WT00| Unit | Tenant | Code | Prev (KL) | Current (KL) | Usage | Step Breakdown | Levy | Total (incl VAT) |
|---|
Update all tariff rates here every July when new CoJ schedules are published. Saving syncs both users immediately.
⚡ Hilton Electricity
Flat rate all-in incl VAT (R/kWh)
⚡ Borgo Business Elec — Summer (Sep–May)
Block 1 (0–500 kWh)
Block 2 (501–1000)
Block 3 (1001–2000)
Block 4 (2001–3000)
Block 5 (3000+)
⚡ Borgo Business Elec — Winter (Jun–Aug)
Block 1 (0–500 kWh)
Block 2 (501–1000)
Block 3 (1001–2000)
Block 4 (2001–3000)
Block 5 (3000+)
⚡ Electricity Fixed Charges
Service Charge (R/month)
Network Charge <50kVA
Network Surcharge
VAT
💧 Business Water (Borgo Retail)
Step 1 ≤200 KL (R/KL)
Step 2 200+ KL (R/KL)
Water Levy (R/month)
Levy split (# shops)
Water VAT
Sewer Rate (R/KL)
Sewer VAT
💧 Residential Water (Borgo)
0–6 KL (R/KL — free)
6–10 KL
10–15 KL
15–20 KL
20–30 KL
30–40 KL
40–50 KL
50+ KL
Res Water Levy (R/unit)
VAT
🌊 Bloem Water Tariffs
Tariff 1 — Standard (R/KL ex VAT)
Tariff 2 — Higher (R/KL ex VAT)
VAT
Mark units Vacant or Tenanted and update names/codes. Changes sync live to both users.
Hilton Court
| Unit | Status | Tenant Name | MRI Code | Prepaid | Action |
|---|
Borgo — Retail Shops
| Shop | Status | Tenant Name | MRI Code | Fixed Charges (MRI) | Action |
|---|
Borgo — Residential
| Unit | Status | Tenant Name | MRI Code | Fixed Water | Action |
|---|
Bloem — Water Tenants
| Unit | Status | Tenant / Entity | MRI Code | Meter No. | Rate (ex VAT) | Meters | Action |
|---|
Review CSV rows before downloading. Fixed-charge (MRI automated) and vacant units excluded.
Hilton Rows
0
Borgo Rows
0
Bloem Rows
0
Total Charges
R 0
📋 Log to Google Sheets
Logs all units (including prepaid & vacant) to three permanent tabs in the master spreadsheet: Hilton Readings Log, Borgo Readings Log, Bloem Readings Log. Appends — never overwrites. Run this after saving readings each month, before rolling over.
Hilton Court — CSV
— Enter readings first —
Borgo — CSV
— Enter readings first —
Bloem — CSV
— Enter readings first —
Bloem Water — flat rate per KL ex VAT (15% VAT added). Bloem Truss & Timbers has 3 meters — readings entered per meter, tallied to one CSV row. GFS Express is a fixed MRI charge (excluded from CSV). Vacant units excluded.
| Unit / Meter | Tenant / Entity | Meter No. | Prev (KL) | Current (KL) | Usage (KL) | Rate (ex VAT) | Amount (ex VAT) | VAT | Total (incl VAT) |
|---|