1
Planner
2022-01-24
Budget - Draft prepared & circulated to committee
Proposed
2022-02-01
Budget approved & circulated to owners
Proposed
2
Finances
BANK
R 384 599.78
INVESTMENT
R 551 233.06
SURPLUS
R 90 302.59
CUSTOMER CONTROL BALANCE
R 1 190 805.47
SUPPLIER CONTROL BALANCE
R -164 221.97
Reminders
Sent
Sent
9
Payment
Arrangements
Arrangements
1
Handed
Over
Over
8
3
Actual vs Budget
| Sep 2021 | YTD | Budget YTD | Variance | Total Budget | |
|---|---|---|---|---|---|
TOTAL INCOME | 466 271.48 | 3 220 010.88 | 3 219 389.18 | 621.70 |
5 518 953.00 |
| 1000/000 LEVY INCOME | 321 996.59 | 2 272 723.61 | 2 425 045.00 | (152 321.39) |
4 157 220.00 |
| 1000/001 Levies | 325 121.17 | 2 275 848.19 | 2 425 045.00 | (149 196.81) |
4 157 220.00 |
| 1000/002 Special Levy | -3 124.58 | -3 124.58 | 0.00 | (3 124.58) |
0.00 |
| 1100/000 MUNICIPAL RECOVERIES | 110 834.26 | 703 491.74 | 656 910.31 | 46 581.43 |
1 126 132.00 |
| 1100/002 Water Recovered | 100 021.85 | 635 220.11 | 602 917.56 | 32 302.55 |
1 033 573.00 |
| 1100/004 Gas Recovered | 10 272.41 | 64 491.63 | 53 992.75 | 10 498.88 |
92 559.00 |
| 1100/005 Refuse Recovered | 540.00 | 3 780.00 | 0.00 | 3 780.00 |
0.00 |
| 1200/000 OTHER INCOME | 33 440.63 | 243 795.53 | 137 433.87 | 106 361.66 |
235 601.00 |
| 1200/001 Interest Received Arrears | 25 779.68 | 188 722.94 | 78 181.81 | 110 541.13 |
134 026.00 |
| 1200/002 Interest Received Bank | 1 987.91 | 12 391.71 | 5 005.56 | 7 386.15 |
8 581.00 |
| 1200/003 Penalty Income | 0.00 | 250.00 | 145.81 | 104.19 |
250.00 |
| 1200/007 Telephone and Gate Access Levy | 5 673.04 | 42 430.88 | 54 100.69 | (11 669.81) |
92 744.00 |
| TOTAL EXPENSES | 463 291.55 | 3 129 708.29 | 3 268 278.51 | 138 570.22 |
5 602 763.00 |
| 2000/000 ADMINISTRATIVE EXPENSES | 178 505.94 | 1 196 987.01 | 1 485 965.81 | 288 978.80 |
2 547 370.00 |
| 2000/001 Audit & Tax Fees | 1 129.00 | 3 504.00 | 7 510.44 | 4 006.44 |
12 875.00 |
| 2000/002 Bank Charges | 1 215.31 | 8 834.16 | 9 293.06 | 458.90 |
15 931.00 |
| 2000/003 Management Fee | 10 987.02 | 76 909.14 | 98 000.00 | 21 090.86 |
168 000.00 |
| 2000/006 Garden & Cleaning Services | 0.00 | 0.00 | 838.81 | 838.81 |
1 438.00 |
| 2000/007 Insurance | 6 264.63 | 45 553.33 | 45 593.94 | 40.61 |
78 161.00 |
| 2000/008 Legal & Professional Fees | 400.00 | -1 671.06 | 39 625.25 | 41 296.31 |
67 929.00 |
| 2000/010 Ombud, Meetings & Related Expenses | 0.00 | 3 154.00 | 2 656.50 | (497.50) |
4 554.00 |
| 2000/012 Telephone: Gate access | 13 128.12 | 91 464.06 | 87 936.94 | (3 527.12) |
150 749.00 |
| 2000/014 Security Armed Response | 4 193.00 | 24 559.00 | 37 107.00 | 12 548.00 |
63 612.00 |
| 2000/015 Security Services / Guarding | 138 877.96 | 933 389.16 | 949 537.75 | 16 148.59 |
1 627 779.00 |
| 2000/020 Consulting Fees | 1 500.00 | 3 950.00 | 0.00 | (3 950.00) |
0.00 |
| 2000/021 Internet and Domain Hosting | 810.90 | 7 341.22 | 6 655.81 | (685.41) |
11 410.00 |
| 2000/022 Gifts | 0.00 | 0.00 | 1 750.00 | 1 750.00 |
3 000.00 |
| 2000/027 Bad debt | 0.00 | 0.00 | 199 460.31 | 199 460.31 |
341 932.00 |
| 2100/000 MUNICIPAL EXPENSES | 165 776.05 | 982 354.75 | 782 183.57 | (200 171.18) |
1 340 886.00 |
| 2100/001 Water | 139 729.97 | 839 523.01 | 632 556.19 | (206 966.82) |
1 084 382.00 |
| 2100/004 Electricity | 14 274.01 | 81 919.97 | 100 185.19 | 18 265.22 |
171 746.00 |
| 2100/005 Rates | 835.20 | 5 782.20 | 5 747.00 | (35.20) |
9 852.00 |
| 2100/006 Gas | 10 936.87 | 55 129.57 | 43 695.19 | (11 434.38) |
74 906.00 |
| 2200/000 REPAIRS & MAINTENANCE | 40 442.85 | 396 192.88 | 517 463.94 | 121 271.06 |
887 081.00 |
| 2200/001 Fire Equipment & Services | 0.00 | 0.00 | 816.69 | 816.69 |
1 400.00 |
| 2200/002 General Building | -2 952.00 | 25 431.88 | 23 893.94 | (1 537.94) |
40 961.00 |
| 2200/003 Plumbing & Water Monitoring | 8 893.11 | 53 352.57 | 129 610.81 | 76 258.24 |
222 190.00 |
| 2200/004 Electrical | 295.50 | 13 635.10 | 33 569.06 | 19 933.96 |
57 547.00 |
| 2200/005 Consumables | 10 016.35 | 35 923.52 | 34 694.31 | (1 229.21) |
59 476.00 |
| 2200/006 Gate, CCTV & Electric Fence | -850.00 | 59 766.72 | 96 786.69 | 37 019.97 |
165 920.00 |
| 2200/008 Refuse Removal | 16 542.75 | 111 387.85 | 111 126.19 | (261.66) |
190 502.00 |
| 2200/009 Gardening Expense General | -4 150.00 | 20 752.58 | 16 229.50 | (4 523.08) |
27 822.00 |
| 2200/012 Roads & Kerbing | 0.00 | 862.50 | 2 545.06 | 1 682.56 |
4 363.00 |
| 2200/015 Motor Vehicle Maintenance | 972.05 | 12 264.79 | 10 670.94 | (1 593.85) |
18 293.00 |
| 2200/016 Motor Vehicle (Fuel) | 10 934.53 | 55 852.35 | 52 279.50 | (3 572.85) |
89 622.00 |
| 2200/018 Cleaning Materials | 340.56 | 728.47 | 0.00 | (728.47) |
0.00 |
| 2200/021 Equipment - Office | 100.00 | 3 349.79 | 3 120.81 | (228.98) |
5 350.00 |
| 2200/022 Security: Maintenance & Equipment | 300.00 | 2 884.76 | 2 120.44 | (764.32) |
3 635.00 |
| 2300/000 SPECIAL PROJECTS | 14 013.68 | 93 937.85 | 0.00 | (93 937.85) |
0.00 |
| 2300/003 Improvements | 14 013.68 | 93 937.85 | 0.00 | (93 937.85) |
0.00 |
| 4000/000 PERSONNEL | 64 553.03 | 460 235.80 | 482 665.19 | 22 429.39 |
827 426.00 |
| 4000/003 Salaries & Wages | 64 553.03 | 460 235.80 | 482 665.19 | 22 429.39 |
827 426.00 |
| SURPLUS / SHORTFALL | 2 979.93 | 90 302.59 | -48 889.33 | 139 191.92 |
-83 810.00 |
4
Balance Sheet
Net Surplus
90 302.59
5000/000
EQUITY & RESERVES
-
1 739 937.24
5000/001
Retained Income
-
1 067 226.24
5000/004
Funds Capitalised
-
672 711.00
6000/000
CURRENT LIABILITIES
-
233 840.06
6000/003
Supplier Control Account
-
164 221.97
6000/006
Owner Deposits
-
50 000.00
6000/007
SARS: Income Tax Payable
-
19 618.09
6050/000
CONTROL ACCOUNTS
-
162 431.67
6050/003
Insurance Claims Control Account
-
155 111.23
6050/008
Unreferenced Receipts Control Account
-
7 320.44
6100/000
LONG TERM LIABILITIES
-
300 000.00
6100/002
Provision for bad debts
-
300 000.00
6500/000
FIXED ASSETS
399 873.25
-
6500/001
Fixed Assets: Roads & Reticulation
207 827.00
-
6500/003
Fixed Assets - Land & Buildings
122 916.00
-
6500/004
Fixed Assets - Motor Vehicles
200 970.75
-
6500/005
Accumulated Depreciation - Motor Vehicles
-
140 680.50
6500/006
Fixed Asset: Garden Equipment
8 840.00
-
7000/000
CURRENT ASSETS
1 190 805.47
-
7000/001
Customer Control Account
1 190 805.47
-
8000/000
BANK
935 832.84
-
8000/001
Standard Bank Current 002456214
312 142.75
-
8000/002
Standard Bank Current Petty Cash 002459094
11 039.63
-
8000/005
Standard Bank Current 002459930
551 233.06
-
8000/006
Netcash 52937645120
5 727.12
-
8000/007
Standard Bank Savings 002495201
55 690.28
-
2 526 511.56
2 526 511.56
5
Reserve Fund vs Budget
| May 2021 | Jun 2021 | Jul 2021 | Aug 2021 | Sep 2021 | YTD | Budget YTD | Variance | Total Budget | |
TOTAL INCOME | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | (0.00) |
0.00 |
| TOTAL EXPENSES | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
0.00 |
| SURPLUS / SHORTFALL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | (0.00) |
0.00 |
6
Outstanding Debtors
| Customer Name | 120 days | 90 days | 60 days | 30 days | Current | Balance |
| MJM002-E260: M J & M M RAVENGANI(SOLD) 2024-05-13 08:37:00: Balance Paid |
568 787.55 | 19 319.12 | 15 411.11 | 15 614.57 | 15 923.07 | 635 055.42 |
| MJT001-E224: MJT NDLOVU (Handed over to Attorneys) 2024-06-04 14:53:00: Clearances extended until end July 2024. Pend until end July 2024 |
321 455.01 | 10 403.43 | 27 735.67 | 10 707.64 | 10 923.69 | 381 225.44 |
| LIV001-E254: LIVING MEMORIES FUNERAL SERVICES PTY LTD (H/O E) (Handed over to Attorneys) 2024-07-02 15:35:00: Awaiting outcome on judgment. Case: 2023/089744 (2nd action) |
110 804.38 | 5 724.25 | 5 838.74 | 5 955.51 | 7 046.37 | 135 369.25 |
| NPC001-E243: N P CEMBI(SOLD) 2024-03-25 10:07:00: Removed Collection Status |
71 782.60 | 4 943.82 | 5 052.18 | 5 175.99 | 6 253.16 | 93 207.75 |
| QNK001-E281: Q & N KEMA JORDAAN (Handed over to Attorneys) 2024-06-07 12:36:00: Awaiting Rule 46 hearing date. |
59 771.15 | 4 758.90 | 4 819.64 | 4 935.30 | 6 017.68 | 80 302.67 |
| JDE001-E229: J DEPPE & I DEPPE 2024-05-07 18:14:00: Debt Status [CSO2] CSOS Application Submitted |
19 983.32 | 4 634.00 | 4 389.35 | 4 397.14 | 5 079.72 | 38 483.53 |
| VSJ001-E272A: VSJ CLARK(SOLD) 2023-02-08 08:49:00: Balance Paid |
11 981.50 | 5 087.68 | 7 722.82 | 4 526.80 | 7 253.46 | 36 572.26 |
| KAO001-E242: K A OKANLOMO (Handed over to Attorneys) 2024-06-12 10:47:00: Trial date allocated: 28 August 2028 |
0.00 | 0.00 | 5 896.54 | 3 801.65 | 4 309.82 | 14 008.01 |
| AGH001-E282: A GHAFFAR(SOLD) 2023-05-02 10:40:00: Balance Paid |
0.00 | 0.00 | 818.25 | 3 751.28 | 3 981.94 | 8 551.47 |
| LND001-E227B: L N DESIGNS PROPRIETARY LIMITED (Handed over to Attorneys) 2024-07-02 11:55:00: Debt Status [LC03] Legal Default Judgment Application: Request for Default Judgment drafted and uploaded to Court online. |
0.00 | 0.00 | 0.00 | 3 628.28 | 3 853.86 | 7 482.14 |
| [1] [1] PTM001-E259A: PT MASIPA & LK MASIPA 2024-06-03 09:30:00: Balance Paid |
0.00 | 0.00 | 0.00 | 0.00 | 3 701.10 | 3 701.10 |
| WSW001-E273A: W SWANEPOEL & R SWANEPOEL 2024-06-03 09:30:00: Balance Paid |
0.00 | 0.00 | 0.00 | 0.00 | 493.43 | 493.43 |
| [1] [1] JID001-E277: JI DE JAGER & NE DE JAGER(SOLD) 2023-08-08 08:36:00: Balance Paid |
0.00 | 0.00 | 0.00 | 0.00 | 376.30 | 376.30 |
| PET001-E291: PETKOV TRUST 2024-07-02 10:21:00: Balance Paid |
0.00 | 0.00 | 0.00 | 0.00 | 204.99 | 204.99 |
| PJR001-E234B: PJ & R JANSE VAN RENSBURG 2024-06-10 13:02:00: Debt Status [RL1] Reminder Letter 1 - no 10% |
0.00 | 0.00 | 0.00 | 0.00 | 121.03 | 121.03 |
| [1] ENI001-E241: EN & IS SCHALKWYK (Handed over to Attorneys) 2024-07-04 08:17:00: Writ on movable property delivered to Sheriff for execution. |
0.00 | 0.00 | 0.00 | 0.00 | 106.22 | 106.22 |
| SHA001-E270B: SHAUN ROBBERTSE 2024-07-05 11:32:00: Balance Paid |
0.00 | 0.00 | 0.00 | 0.00 | 47.07 | 47.07 |
| 1 164 565.51 | 54 871.20 | 77 684.30 | 62 494.16 | 75 692.91 | 1 435 308.08 |
7
Outstanding Creditors
| Supplier | 120+ days | 90 days | 60 days | 30 days | Current | Balance |
|---|---|---|---|---|---|---|
| RAN003: Rand Water 1249694930 | 0.00 | 0.00 | 0.00 | 0.00 | -138 867.47 | -138 867.47 |
| ALA001: Alan Levy 1790919 | 0.00 | 0.00 | 0.00 | 0.00 | -9 725.00 | -9 725.00 |
| BRI004: Brinant Group 62189709284 | 0.00 | 0.00 | 0.00 | 0.00 | -5 734.53 | -5 734.53 |
| GAS002: Gas 2 U Suppliers 1930051549 | 0.00 | 0.00 | 0.00 | 0.00 | -4 395.11 | -4 395.11 |
| BRI007: Brinant Alarms 370091175 | 0.00 | 0.00 | 0.00 | 0.00 | -4 193.00 | -4 193.00 |
| FHC001: FH Chamberlain Trading 51460050127 | 0.00 | 0.00 | 0.00 | 0.00 | -1 777.00 | -1 777.00 |
| ADA003: ADA Architects 1602233837 | 0.00 | 0.00 | 0.00 | 0.00 | -1 500.00 | -1 500.00 |
| CLE003: Clear Access 62473337684 | 0.00 | 0.00 | 0.00 | 0.00 | 630.92 | 630.92 |
| IRE001: Irene Glen Petty Cash | 0.00 | 0.00 | 0.00 | 0.00 | 1 339.22 | 1 339.22 |
| Totals | 0.00 | 0.00 | 0.00 | 0.00 | -164 221.97 | -164 221.97 |