Spreadsheet: 166191d1341497314-excel-2007-eliminating-subtotals-in-pivot-table-par-q1-
Sheet: PAR Q1 +

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