Spreadsheet: 462733d1464174240-index-match-formula-to-return-specified-value-is_sample
Sheet: Fin Data 2016

Period Ending (Actual) | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | TOTAL
Revenue | 169428.34 | 500206.19 | 146379.31 | 5948.98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 821962.8200000001
Coordination Fees | 124795.86 | 465790.92 | 142637.65 | 5948.98 |  |  |  |  |  |  |  |  | 739173.41
Commission | 44632.48 | 34415.27 | 3741.66 | 0 |  |  |  |  |  |  |  |  | 82789.41
Other | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
Expenses | 218376.93 | 317741.12 | 353273.82 | 244183.66 |  |  |  |  |  |  |  |  | 1133575.53
Bank Charges | 276.13 | 685.9100000000001 | 3210.8 | 1511.93 |  |  |  |  |  |  |  |  | 5684.77
Credit card charges | 476.41 | -1135.5 | 1952.29 | 3571.7 |  |  |  |  |  |  |  |  | 4864.9
Casual staff / Bookeeping | 3900 | 9315 | 22775 | 23108.2 |  |  |  |  |  |  |  |  | 59098.2
Coordinator expenses | 945.8 | 2959.04 | 639.2 | 1063.36 |  |  |  |  |  |  |  |  | 5607.4
Computer Expenses |  |  |  |  |  |  |  |  |  |  |  |  | 0
Electricity, rates & water | 427.25 | 9135.99 | 2404.88 | 3196.79 |  |  |  |  |  |  |  |  | 15164.91
Fax/copier rental | 650 | 650 | 650 | 3237.46 |  |  |  |  |  |  |  |  | 5187.46
Furniture & fittings | 60.53 |  |  |  |  |  |  |  |  |  |  |  | 60.53
Gifts | -150 | -150 | 529.89 |  |  |  |  |  |  |  |  |  | 229.89
Marketing expenses |  | 3256 | 2999.74 | -1773.84 |  |  |  |  |  |  |  |  | 4481.9
Office rental | -2191.91 | 26059.85 | -4375.43 | 6941.18 |  |  |  |  |  |  |  |  | 26433.69
Internet |  |  |  | 154 |  |  |  |  |  |  |  |  | 154
Post, telephone and fax | 2390 | 1151.52 | 2158.53 | 402.96 |  |  |  |  |  |  |  |  | 6103.01
Printing & copying | 920 | 510.46 | 666.29 | -1914.46 |  |  |  |  |  |  |  |  | 182.29
Professional Services | 38000 | 24243.75 | 25000 | 25000 |  |  |  |  |  |  |  |  | 112243.75
Refreshments | 266.5 | 173.7 | 333.65 | 1359.41 |  |  |  |  |  |  |  |  | 2133.26
Registration material |  | 421.49 |  | -1320 |  |  |  |  |  |  |  |  | -898.51
Recruitment |  |  |  |  |  |  |  |  |  |  |  |  | 0
Repairs & maintenance |  |  | 10000 | 10049.69 |  |  |  |  |  |  |  |  | 20049.69
SAACI Subscriptions |  |  |  |  |  |  |  |  |  |  |  |  | 0
Salaries | 167751.24 | 232236.12 | 259654.48 | 169954.62 |  |  |  |  |  |  |  |  | 829596.46
Stationary | 230.44 | 1261.7 | 1779.83 | 4.45 |  |  |  |  |  |  |  |  | 3276.42
Staff training |  |  |  | 7140 |  |  |  |  |  |  |  |  | 7140
Staff uniforms |  |  | 12254.1 |  |  |  |  |  |  |  |  |  | 12254.1
Transport |  |  |  | 1500 |  |  |  |  |  |  |  |  | 1500
Web design | 130.7 | 130.7 | 130.7 | 130.7 |  |  |  |  |  |  |  |  | 522.8
Health Science Faculty Fees | 11909.87 | 11909.87 | 11909.87 | 11909.87 |  |  |  |  |  |  |  |  | 47639.48
Management time cost |  |  |  |  |  |  |  |  |  |  |  |  | 0
Security |  |  |  |  |  |  |  |  |  |  |  |  | 0
HR costs | 4578.65 | 4578.65 | 4578.65 | 4578.65 |  |  |  |  |  |  |  |  | 18314.6
ICTS connection | 7331.22 | 7331.22 | 7331.22 | 7331.22 |  |  |  |  |  |  |  |  | 29324.88
Recoveries | -7616.03 | -5074.48 | -1400 | -21044.36 |  |  |  |  |  |  |  |  | -35134.87
Bank charges | 4938.03 | 927.78 |  | 16544.36 |  |  |  |  |  |  |  |  | 22410.17
Credit Card Charges |  |  |  |  |  |  |  |  |  |  |  |  | 0
Telephone | 930 | 550 | 400 | 4000 |  |  |  |  |  |  |  |  | 5880
Printing |  |  |  |  |  |  |  |  |  |  |  |  | 0
Registration material |  | 1361.7 |  |  |  |  |  |  |  |  |  |  | 1361.7
Stationery | 1348 | 935 | 1000 | 500 |  |  |  |  |  |  |  |  | 3783
Web Site Charges | 400 | 1300 |  |  |  |  |  |  |  |  |  |  | 1700
Depreciation | 2719.09 | 10399.32 | 21516.88 | 4665.45 |  |  |  |  |  |  |  |  | 39300.74
Interest | 0 | 634.56 | 1830.6 | 3625.11 |  |  |  |  |  |  |  |  | 6090.27
Received |  | 634.56 | 1830.6 | 3625.11 |  |  |  |  |  |  |  |  | 6090.27
Paid
Surplus/Deficit | -51667.67999999999 | 172700.31 | -226580.79 | -239275.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -344823.1800000002
Quick Books | -51667.68 | 172700.31 | -226580.79 | -239275.02
Difference | 0 | 0 | 0 | 0
Period Ending (Budget) | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | TOTAL
Revenue | 137271.6041322314 | 259586.7768595041 | 346066.8950768877 | 276853.5160615102 | 221482.8128492081 | 110741.4064246041 | 179954.7854399816 | 304538.8676676612 | 415280.2740922652 | 332224.2192738122 | 549258.4710743802 | 235325.4886522837 | 3368585.11760433
Coordination Fees | 110412.1 | 210000 | 294414.0025149042 | 235531.2020119234 | 188424.9616095387 | 94212.48080476935 | 153095.2813077502 | 259084.3222131158 | 353296.8030178851 | 282637.4424143081 | 487275 | 200201.5217101349 | 2868585.11760433
Commission | 26859.50413223141 | 49586.77685950413 | 51652.89256198347 | 41322.31404958678 | 33057.85123966942 | 16528.92561983471 | 26859.50413223141 | 45454.54545454546 | 61983.47107438017 | 49586.77685950413 | 61983.47107438017 | 35123.96694214876 | 499999.9999999999
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses | 220869.566016529 | 350207.185107438 | 195960.249570248 | 235514.0647561984 | 208642.2369049587 | 241891.0702024793 | 225029.058516529 | 225187.5786818182 | 227248.0343842975 | 225702.692607438 | 227248.0343842975 | 223899.7938677686 | 2807399.565000001
Bank Charges | 1495.629318181818 | 2761.161818181818 | 2876.210227272728 | 2300.968181818182 | 1840.774545454546 | 920.3872727272728 | 1495.629318181818 | 2531.065000000001 | 3451.452272727274 | 2761.161818181818 | 3451.452272727274 | 1955.822954545455 | 27841.71500000001
Credit card charges | 482.1141322314049 | 890.0568595041323 | 927.1425619834712 | 741.7140495867768 | 593.3712396694215 | 296.6856198347107 | 482.1141322314049 | 815.8854545454545 | 1112.571074380165 | 890.0568595041323 | 1112.571074380165 | 630.4569421487605 | 8974.740000000002
Casual staff / Bookkeeping | 3999.272727272727 | 7383.272727272727 | 7690.909090909092 | 6152.727272727273 | 4922.181818181818 | 2461.090909090909 | 3999.272727272727 | 6768 | 9229.09090909091 | 7383.272727272727 | 9229.09090909091 | 5229.818181818183 | 74447.99999999999
Coordinator expenses | 902.9644752066117 | 1667.011338842975 | 1736.470144628099 | 1389.176115702479 | 1111.340892561984 | 555.6704462809918 | 902.9644752066117 | 1528.093727272727 | 2083.76417355372 | 1667.011338842975 | 2083.76417355372 | 1180.799698347108 | 16809.031
Computer Expenses | 137.8874545454546 | 254.5614545454546 | 265.1681818181819 | 212.1345454545455 | 169.7076363636364 | 84.8538181818182 | 137.8874545454546 | 233.348 | 318.2018181818183 | 254.5614545454546 | 318.2018181818183 | 180.3143636363637 | 2566.828000000001
Electricity, rates & water | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 3233.94375 | 38807.32499999999
Fax/copier rental | 460.9090909090909 | 850.9090909090909 | 886.3636363636365 | 709.0909090909091 | 567.2727272727273 | 283.6363636363636 | 460.9090909090909 | 780 | 1063.636363636364 | 850.9090909090909 | 1063.636363636364 | 602.7272727272729 | 8580
Furniture & fittings | 0 | 0 | 0 | 0 | 0 | 4379.551 | 0 | 0 | 0 | 0 | 0 | 0 | 4379.551
Gifts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Marketing expenses | 0 | 10000 | 10000 | 40000 | 25000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 85000
Office rental | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 14386.83125 | 172641.975
Internet | 57.42218181818183 | 106.0101818181818 | 110.4272727272728 | 88.3418181818182 | 70.67345454545456 | 35.33672727272728 | 57.42218181818183 | 97.17600000000002 | 132.5127272727273 | 106.0101818181818 | 132.5127272727273 | 75.09054545454548 | 1068.936
Post, telephone and fax | 1384.991636363636 | 2556.907636363637 | 2663.445454545455 | 2130.756363636364 | 1704.605090909091 | 852.3025454545456 | 1384.991636363636 | 2343.832 | 3196.134545454546 | 2556.907636363637 | 3196.134545454546 | 1811.14290909091 | 25782.152
Printing & copying | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 501.3882500000001 | 6016.659000000001
Professional Services | 38000 | 24475 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 62475
Refreshments | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 410.2037500000001 | 4922.445000000002
Registration material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Recruitment | 0 | 0 | 0 | 10841.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10841.6
Repairs & maintenance | 86.42813636363638 | 159.5596363636364 | 166.2079545454546 | 132.9663636363637 | 106.3730909090909 | 53.18654545454547 | 86.42813636363638 | 146.263 | 199.4495454545455 | 159.5596363636364 | 199.4495454545455 | 113.0214090909091 | 1608.893
SAACI Subscriptions | 0 | 0 | 0 | 0 | 0 | 15929.738 | 0 | 0 | 0 | 0 | 0 | 0 | 15929.738
Salaries | 160838 | 160838 | 160838 | 160838 | 160838 | 200838 | 200838 | 200838 | 200838 | 200838 | 200838 | 200838 | 2210056
Stationary | 0 | 839.4925000000002 | 0 | 0 | 0 | 0 | 839.4925000000002 | 0 | 0 | 0 | 0 | 0 | 1678.985
Staff training | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Staff uniforms | 0 | 1320 | 0 | 0 | 0 | 0 | 1320 | 0 | 0 | 0 | 0 | 0 | 2640
Transport | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Web design | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 150.9585 | 1811.502
Health Science Faculty Fees | 0 | 127870 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 127870
Management time cost | 0 | 127870 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 127870
Security | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HR costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ICTS connection | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Recoveries | -5659.378636363636 | -10448.08363636364 | -10883.42045454546 | -8706.736363636366 | -6965.389090909091 | -3482.694545454545 | -5659.378636363636 | -9577.41 | -13060.10454545455 | -10448.08363636364 | -13060.10454545455 | -7400.72590909091 | -105351.51
Bank charges | 2518.581590909091 | 4649.689090909092 | 4843.426136363638 | 3874.74090909091 | 3099.792727272728 | 1549.896363636364 | 2518.581590909091 | 4262.215 | 5812.111363636365 | 4649.689090909092 | 5812.111363636365 | 3293.529772727274 | 46884.36500000001
Credit Card Charges | 1169.003136363636 | 2158.159636363636 | 2248.082954545455 | 1798.466363636364 | 1438.773090909091 | 719.3865454545454 | 1169.003136363636 | 1978.313 | 2697.699545454546 | 2158.159636363636 | 2697.699545454546 | 1528.696409090909 | 21761.443
Telephone | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Printing | 363.7092727272728 | 671.4632727272729 | 699.4409090909093 | 559.5527272727273 | 447.6421818181819 | 223.8210909090909 | 363.7092727272728 | 615.508 | 839.3290909090911 | 671.4632727272729 | 839.3290909090911 | 475.6198181818183 | 6770.588000000001
Registration material | 313.9913636363637 | 579.6763636363637 | 603.8295454545456 | 483.0636363636364 | 386.4509090909091 | 193.2254545454546 | 313.9913636363637 | 531.3700000000001 | 724.5954545454547 | 579.6763636363637 | 724.5954545454547 | 410.604090909091 | 5845.070000000001
Stationery | 788.918 | 1456.464 | 1517.15 | 1213.72 | 970.976 | 485.488 | 788.918 | 1335.092 | 1820.58 | 1456.464 | 1820.58 | 1031.662 | 14686.012
Web Site Charges | 505.1752727272727 | 932.6312727272726 | 971.4909090909092 | 777.1927272727272 | 621.7541818181818 | 310.8770909090909 | 505.1752727272727 | 854.9119999999999 | 1165.789090909091 | 932.6312727272726 | 1165.789090909091 | 660.6138181818183 | 9404.032
Depreciation | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 15000
Interest | 1278.044772727273 | 2359.467272727273 | 2457.778409090909 | 1966.222727272728 | 1572.978181818182 | 786.489090909091 | 1278.044772727273 | 2162.845 | 2949.334090909092 | 2359.467272727273 | -49300.66590909091 | 1671.289318181819 | -28458.70499999999
Received | 1278.044772727273 | 2359.467272727273 | 2457.778409090909 | 1966.222727272728 | 1572.978181818182 | 786.489090909091 | 1278.044772727273 | 2162.845 | 2949.334090909092 | 2359.467272727273 | 2949.334090909092 | 1671.289318181819 | 23791.29500000001
Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -52250 | 0 | -52250
Surplus/Deficit | -83569.91711157028 | -89510.9409752066 | 151314.4239157307 | 42055.67403258454 | 13163.55412606764 | -131613.1746869662 | -45046.22830382007 | 80264.13398584304 | 189731.5737988768 | 107630.9939391014 | 271459.7707809918 | 11846.98410269689 | 517726.8476043288
 | -83569.91711157028 | -89510.9409752066 | 151314.4239157307 | 42055.67403258454 | 13163.55412606764 | -131613.1746869662 | -45046.22830382007 | 80264.13398584304 | 189731.5737988768 | 107630.9939391014 | 271459.7707809918 | 11846.98410269689
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0