Spreadsheet: 166191d1341497314-excel-2007-eliminating-subtotals-in-pivot-table-par-q1-
Sheet: Sheet1

Sum of Movements |  |  | Period
PropertyID | TransactionCode | TransactionDescription | 201203 | 201204 | 201205 | Grand Total
8 | 9 | -Rent: Retail | -628550.23 | -673429.37 | -653755.12 | -1955734.72
 | 0009 Total |  | -628550.23 | -673429.37 | -653755.12 | -1955734.72
 | 10 | -Recovery: Operating Cost | -148101.99 | -148101.99 | -149364.69 | -445568.67
 | 0010 Total |  | -148101.99 | -148101.99 | -149364.69 | -445568.67
 | 11 | -Rent: Offices | -13583.9 | -13583.9 | -13583.9 | -40751.7
 | 0011 Total |  | -13583.9 | -13583.9 | -13583.9 | -40751.7
 | 14 | -Rent: Storage | -798.6 | -798.6 | -798.6 | -2395.8
 | 0014 Total |  | -798.6 | -798.6 | -798.6 | -2395.8
 | 15 | -Rent: Turnover Clause | -23500 | -26165.21 | -30470.71 | -80135.92
 | 0015 Total |  | -23500 | -26165.21 | -30470.71 | -80135.92
 | 18 | -Rent: Specialized | -14046.41 | -14046.41 | -14046.41 | -42139.23
 | 0018 Total |  | -14046.41 | -14046.41 | -14046.41 | -42139.23
 | 30 | -Lease Fees |  | -1500 |  | -1500
 | 0030 Total |  |  | -1500 |  | -1500
 | 32 | -Meter Reading Fee | -1110.25 | -1134.42 | -1139.92 | -3384.59
 | 0032 Total |  | -1110.25 | -1134.42 | -1139.92 | -3384.59
 | 40 | -Recovery: Assessment Rat | -28599.92 | -28709.32 | -24994.1 | -82303.34
 | 0040 Total |  | -28599.92 | -28709.32 | -24994.1 | -82303.34
 | 41 | -Recovery: Refuse | -14558.33 | -15789.86 | -15344.88 | -45693.07
 | 0041 Total |  | -14558.33 | -15789.86 | -15344.88 | -45693.07
 | 42 | -Recovery: Electricity | -300885.17 | -294495.08 | -301931.39 | -897311.64
 | 0042 Total |  | -300885.17 | -294495.08 | -301931.39 | -897311.64
 | 43 | -Recovery: Water | -20804.76 | -21370.53 | -20678.38 | -62853.67
 | 0043 Total |  | -20804.76 | -21370.53 | -20678.38 | -62853.67
 | 48 | -Recovery Water COMMON | 3035.01 | 3327.53 | 1956.3 | 8318.84
 | 0048 Total |  | 3035.01 | 3327.53 | 1956.3 | 8318.84
 | 49 | -Recovery Elec COMMON | 6267.27 | 3962.44 | 5368.99 | 15598.7
 | 0049 Total |  | 6267.27 | 3962.44 | 5368.99 | 15598.7
 | 51 | -Recovery: Late Pmt Fee | -956.14 | 1454.98 |  | 498.84
 | 0051 Total |  | -956.14 | 1454.98 |  | 498.84
 | 52 | -Recovery: Cash Dep Fee | -706.97 | -501.63 | -577.09 | -1785.69
 | 0052 Total |  | -706.97 | -501.63 | -577.09 | -1785.69
 | 54 | -Recovery: AOD Tenant | -17988.62 | -10833.33 | -10833.33 | -39655.28
 | 0054 Total |  | -17988.62 | -10833.33 | -10833.33 | -39655.28
 | 63 | -Recovery: Promotion Fund | -10953.95 | -10949.75 | -10996.93 | -32900.63
 | 0063 Total |  | -10953.95 | -10949.75 | -10996.93 | -32900.63
 | 1100 | Utility-Water Charge | 24707.98 | 23683.56 | 22461.32 | 70852.86
 | 1100 Total |  | 24707.98 | 23683.56 | 22461.32 | 70852.86
 | 1110 | Utility-Refuse |  |  | 11008.52 | 11008.52
 | 1110 Total |  |  |  | 11008.52 | 11008.52
 | 1111 | Utility-Rubble Removal | 8454.9 | 11790.79 | 1000 | 21245.69
 | 1111 Total |  | 8454.9 | 11790.79 | 1000 | 21245.69
 | 1130 | Utility-Electricity | 293365.74 | 231063.06 | 226813.28 | 751242.0800000001
 | 1130 Total |  | 293365.74 | 231063.06 | 226813.28 | 751242.0800000001
 | 1912 | COS-Aircons-PAR |  |  | 69650 | 69650
 | 1912 Total |  |  |  | 69650 | 69650
 | 2008 | [NAME] | 42000 | 42000 | 42000 | 126000
 | 2008 Total |  | 42000 | 42000 | 42000 | 126000
 | 2020 | [NAME] Tnts-3rdParty | 9615 | 3070.17 | 13500 | 26185.17
 | 2020 Total |  | 9615 | 3070.17 | 13500 | 26185.17
 | 2030 | Bad Debts Expense |  | 59067.68 |  | 59067.68
 | 2030 Total |  |  | 59067.68 |  | 59067.68
 | 2040 | Bank Charges-Current a/c | 582.81 | 716.27 | 745.38 | 2044.46
 | 2040 Total |  | 582.81 | 716.27 | 745.38 | 2044.46
 | 2050 | Cleaning exp-3RD PARTY |  | 23000 | 13700 | 36700
 | 2050 Total |  |  | 23000 | 13700 | 36700
 | 2051 | Cleaning exp-NEVADA | 10528 | 6480 | 6480 | 23488
 | 2051 Total |  | 10528 | 6480 | 6480 | 23488
 | 2061 | Collection Costs: NEVADA | 60792 | 62633 | 62060 | 185485
 | 2061 Total |  | 60792 | 62633 | 62060 | 185485
 | 2072 | Commission: TERRAFORM | 102221 | 102221 | 102221 | 306663
 | 2072 Total |  | 102221 | 102221 | 102221 | 306663
 | 2095 | Consumables |  | 119.59 |  | 119.59
 | 2095 Total |  |  | 119.59 |  | 119.59
 | 2103 | Depn-Aircons |  |  | 10672.49 | 10672.49
 | 2103 Total |  |  |  | 10672.49 | 10672.49
 | 2111 | Depn-Carports |  |  | 3611.05 | 3611.05
 | 2111 Total |  |  |  | 3611.05 | 3611.05
 | 2120 | Depn-Elec Equipment |  |  | 2826.8 | 2826.8
 | 2120 Total |  |  |  | 2826.8 | 2826.8
 | 2130 | Depn-F&F |  |  | 1308.55 | 1308.55
 | 2130 Total |  |  |  | 1308.55 | 1308.55
 | 2131 | Depn-Fencing |  |  | 606.75 | 606.75
 | 2131 Total |  |  |  | 606.75 | 606.75
 | 2144 | Depn-Generators |  |  | 21356.78 | 21356.78
 | 2144 Total |  |  |  | 21356.78 | 21356.78
 | 2145 | Depn-LB Improvements |  |  | 31899.3 | 31899.3
 | 2145 Total |  |  |  | 31899.3 | 31899.3
 | 2147 | Depn-Lighting |  |  | 10555.1 | 10555.1
 | 2147 Total |  |  |  | 10555.1 | 10555.1
 | 2151 | Depn-Meters |  |  | 3101.23 | 3101.23
 | 2151 Total |  |  |  | 3101.23 | 3101.23
 | 2161 | Depn-Security System |  |  | 19132.11 | 19132.11
 | 2161 Total |  |  |  | 19132.11 | 19132.11
 | 2162 | Depn-Signage |  |  | 2409.33 | 2409.33
 | 2162 Total |  |  |  | 2409.33 | 2409.33
 | 2166 | Depn-Tenant Instal'ns |  |  | 45816.59 | 45816.59
 | 2166 Total |  |  |  | 45816.59 | 45816.59
 | 2210 | Donations: disallow |  | 50 |  | 50
 | 2210 Total |  |  | 50 |  | 50
 | 2220 | Entertainment Exp |  | 679.15 | 583.05 | 1262.2
 | 2220 Total |  |  | 679.15 | 583.05 | 1262.2
 | 2240 | Insurance Exp | 3096.64 | 3096.64 | 3096.64 | 9289.92
 | 2240 Total |  | 3096.64 | 3096.64 | 3096.64 | 9289.92
 | 2265 | Legal Expense-Revenue | 2698.48 |  | 5308.74 | 8007.219999999999
 | 2265 Total |  | 2698.48 |  | 5308.74 | 8007.219999999999
 | 2269 | Licence compliance fees | 3700 |  |  | 3700
 | 2269 Total |  | 3700 |  |  | 3700
 | 2280 | Motor Veh Exp-R&M |  | 50 |  | 50
 | 2280 Total |  |  | 50 |  | 50
 | 2300 | Printing & Stationery |  | 146.93 |  | 146.93
 | 2300 Total |  |  | 146.93 |  | 146.93
 | 2310 | Utilities: Rates & Levie | 27357.52 | 27357.52 | 27357.52 | 82072.56
 | 2310 Total |  | 27357.52 | 27357.52 | 27357.52 | 82072.56
 | 2365 | Hygiene Services |  | 1699.65 | 1503.16 | 3202.81
 | 2365 Total |  |  | 1699.65 | 1503.16 | 3202.81
 | 2403 | R&M -Building Repairs | 13088 | 6132.54 | 112411.31 | 131631.85
 | 2403 Total |  | 13088 | 6132.54 | 112411.31 | 131631.85
 | 2404 | R&M -Electrical | 3210 | 14855 | 360 | 18425
 | 2404 Total |  | 3210 | 14855 | 360 | 18425
 | 2406 | R&M -Plumbing | 1890 |  |  | 1890
 | 2406 Total |  | 1890 |  |  | 1890
 | 2408 | R&M -Discount Received |  |  | -300.21 | -300.21
 | 2408 Total |  |  |  | -300.21 | -300.21
 | 2413 | R&M -Gardens & Landscap | 18400 |  |  | 18400
 | 2413 Total |  | 18400 |  |  | 18400
 | 2420 | R&M -NEV CONTRACT | 7751 |  | 2485 | 10236
 | 2420 Total |  | 7751 |  | 2485 | 10236
 | 2500 | Security expense | 21228.07 | 20175.44 | 20175.44 | 61578.95
 | 2500 Total |  | 21228.07 | 20175.44 | 20175.44 | 61578.95
 | 2510 | Telephone-Landline | 886.98 | 790.08 | 748.2 | 2425.26
 | 2510 Total |  | 886.98 | 790.08 | 748.2 | 2425.26
 | 3000 | Int Income-Tenant Arrear | -329.09 | 39.59 |  | -289.5
 | 3000 Total |  | -329.09 | 39.59 |  | -289.5
 | 3210 | Int EXP INTERCO-NEV |  |  | 117161.31 | 117161.31
 | 3210 Total |  |  |  | 117161.31 | 117161.31
 | 3500 | [NAME] OVERDRAFTS | 2951.24 | 1426.96 | 1187.9 | 5566.1
 | 3500 Total |  | 2951.24 | 1426.96 | 1187.9 | 5566.1
 | 3960 | Int Exp PAR [NAME] 1637 | 61752.58 | 299942.82 | 238189.89 | 599885.29
 | 3960 Total |  | 61752.58 | 299942.82 | 238189.89 | 599885.29
 | 4004 | COP- Building Materials | 132858.07 |  |  | 132858.07
 | 4004 Total |  | 132858.07 |  |  | 132858.07
 | 4007 | COP-NEV Contract | 11340 |  |  | 11340
 | 4007 Total |  | 11340 |  |  | 11340
 | 4099 | COP-Tfr to IMPROVMENTS | -120280 |  |  | -120280
 | 4099 Total |  | -120280 |  |  | -120280
 | 4100 | COP-Trf to Assets | -23918.07 |  |  | -23918.07
 | 4100 Total |  | -23918.07 |  |  | -23918.07
 | 4860 | UnRealizd Reval-Building |  |  | -30000000 | -30000000
 | 4860 Total |  |  |  | -30000000 | -30000000
 | 4930 | Taxation-STC | 260000 |  |  | 260000
 | 4930 Total |  | 260000 |  |  | 260000
 | 4950 | DISTRIBUTIONS |  | 130000 |  | 130000
 | 4950 Total |  |  | 130000 |  | 130000
 | 4960 | Transfer To/(From) NDR |  |  | 30000000 | 30000000
 | 4960 Total |  |  |  | 30000000 | 30000000
 | 5200 | EQUITY-N D R |  |  | -30000000 | -30000000
 | 5200 Total |  |  |  | -30000000 | -30000000
 | 5400 | EQUITY-DISTRIBUTIONS PAID | 2600000 |  |  | 2600000
 | 5400 Total |  | 2600000 |  |  | 2600000
 | 5515 | EQUITY-Loan-PMFT | -1626274.52 | -2275000 |  | -3901274.52
 | 5515 Total |  | -1626274.52 | -2275000 |  | -3901274.52
 | 5525 | EQUITY-Loan-S.Remoundos | -130000 | 97500 |  | -32500
 | 5525 Total |  | -130000 | 97500 |  | -32500
 | 5550 | EQUITY-Loan-S.Rockas |  | 1000000 |  | 1000000
 | 5550 Total |  |  | 1000000 |  | 1000000
 | 5640 | EQUITY-Current Loan-D.Tes | 199019.61 | -42466.77 |  | 156552.84
 | 5640 Total |  | 199019.61 | -42466.77 |  | 156552.84
 | 5641 | EQUITY-Current-A.Pompa | -40784.31 | 30909.02 |  | -9875.289999999997
 | 5641 Total |  | -40784.31 | 30909.02 |  | -9875.289999999997
 | 5650 | EQUITY-Current Loan-S.Roc | -101960.78 | 198249.22 |  | 96288.44
 | 5650 Total |  | -101960.78 | 198249.22 |  | 96288.44
 | 7000 | CL CREDITORS CONTROL | -67077.53 | 41652.19 | 69477.76 | 44052.42
 | 7000 Total |  | -67077.53 | 41652.19 | 69477.76 | 44052.42
 | 7010 | CL ACCRUALS | 31068 | 163013 |  | 194081
 | 7010 Total |  | 31068 | 163013 |  | 194081
 | 7100 | CL TNT DEPOSITS | 28496.53 | -14124.19 | -7280.4 | 7091.939999999999
 | 7100 Total |  | 28496.53 | -14124.19 | -7280.4 | 7091.939999999999
 | 7661 | BANK Parkrand Piazza FNB | 570532.77 | 23245.58 | 94251.08 | 688029.4299999999
 | 7661 Total |  | 570532.77 | 23245.58 | 94251.08 | 688029.4299999999
 | 7940 | CL VAT ACCOUNT | -102882.83 | 37303.24 | -77362.83 | -142942.42
 | 7940 Total |  | -102882.83 | 37303.24 | -77362.83 | -142942.42
 | 7970 | CL SARS PAYABLE | -260000 | 260000 |  | 0
 | 7970 Total |  | -260000 | 260000 |  | 0
 | 8233 | ASSET LB Improv 2013 | 120280 |  |  | 120280
 | 8233 Total |  | 120280 |  |  | 120280
 | 8299 | ASSET LB REVALUATION |  |  | 30000000 | 30000000
 | 8299 Total |  |  |  | 30000000 | 30000000
 | 8310 | ASSET OA Aircons | 6541 |  |  | 6541
 | 8310 Total |  | 6541 |  |  | 6541
 | 8311 | ASSET OD AccDep-Aircon |  |  | -10672.49 | -10672.49
 | 8311 Total |  |  |  | -10672.49 | -10672.49
 | 8328 | ASSET OD AccDep-LB Imp |  |  | -31899.3 | -31899.3
 | 8328 Total |  |  |  | -31899.3 | -31899.3
 | 8350 | ASSET OA Carports | 125000 |  |  | 125000
 | 8350 Total |  | 125000 |  |  | 125000
 | 8351 | ASSET OD AccDep-Carports |  |  | -3611.05 | -3611.05
 | 8351 Total |  |  |  | -3611.05 | -3611.05
 | 8431 | ASSET OD AccDep-Meters |  |  | -3101.23 | -3101.23
 | 8431 Total |  |  |  | -3101.23 | -3101.23
 | 8490 | ASSET OA Fencing & Gates |  | 22000 | 17240 | 39240
 | 8490 Total |  |  | 22000 | 17240 | 39240
 | 8491 | ASSET OD AccDep-Fencing |  |  | -606.75 | -606.75
 | 8491 Total |  |  |  | -606.75 | -606.75
 | 8511 | ASSET OD AccDep-F&F |  |  | -1308.55 | -1308.55
 | 8511 Total |  |  |  | -1308.55 | -1308.55
 | 8521 | ASSET OD AccDep-Equip-Ele |  |  | -2826.8 | -2826.8
 | 8521 Total |  |  |  | -2826.8 | -2826.8
 | 8531 | ASSET OD AccDep-Generator |  |  | -21356.78 | -21356.78
 | 8531 Total |  |  |  | -21356.78 | -21356.78
 | 8551 | ASSET OD AccDep-Lighting |  |  | -10555.1 | -10555.1
 | 8551 Total |  |  |  | -10555.1 | -10555.1
 | 8581 | ASSET OD AccDep-Security |  |  | -19132.11 | -19132.11
 | 8581 Total |  |  |  | -19132.11 | -19132.11
 | 8591 | ASSET OD AccDep-Signage |  |  | -2409.33 | -2409.33
 | 8591 Total |  |  |  | -2409.33 | -2409.33
 | 8700 | ASSET OA Tnt Instalations | 23918.07 | 6000 | 9122.81 | 39040.88
 | 8700 Total |  | 23918.07 | 6000 | 9122.81 | 39040.88
 | 8701 | ASSET OD AccDep-Tnt Insta |  |  | -33472.84 | -33472.84
 | 8701 Total |  |  |  | -33472.84 | -33472.84
 | 8900 | INTER-CO NEVADA | -1110102.4 | -758035.58 | 108057.25 | -1760080.73
 | 8900 Total |  | -1110102.4 | -758035.58 | 108057.25 | -1760080.73
 | 8940 | INTER-CO KALAMATA |  | 1502500 |  | 1502500
 | 8940 Total |  |  | 1502500 |  | 1502500
 | 8961 | ASSET OD AccDep-Tnt Insta |  |  | -12343.75 | -12343.75
 | 8961 Total |  |  |  | -12343.75 | -12343.75
 | 9000 | [NAME] | -29879.5 | -112368.7 | -74222.96 | -216471.16
 | 9000 Total |  | -29879.5 | -112368.7 | -74222.96 | -216471.16
8 Total |  |  | 2.328306436538696e-10 | 1.891748979687691e-10 | 4.147295840084553e-09 | 3.37604433298111e-09