case study
rayatita007Senior_Finance_Associate_-_Business_Case.xlsx
1. Cash Flow Forecast
Category | 2019-01 | 2019-02 | 2019-03 | 2019-04 | 2019-05 | 2019-06 | 2019-07 | 2019-08 | 2019-09 | 2019-10 | 2019-11 | 2019-12 | January | February | March | April | May | June | Actual YTD | Budget YTD | Diff | Forecast FY | Budget FY | Diff | ||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Colour code | ||||||||||||||
LOCAL CURRENCY | Forecast | |||||||||||||||||||||||||||||||
INCOME | - | - | - | - | - | - | - | - | - | - | - | - | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | - | - | - | - | - | - | - | Actual | ||||||
School fees | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | - | - | Budget | |||||||||||||||||||||||
Registration fees | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | - | |||||||||||||||||||||||||
Other income | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | - | - | Month | |||||||||||||||||||||||
EXPENSES | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 1 | ||||||
Other income related expenses | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | - | - | ||||||||||||||||||||||||
Salaries - Teaching staff | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Salaries - Admin staff | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Travel costs | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Quality / accreditation | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Academics | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Scholarships | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Marketing and student recruitment | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Communication and IT/IS costs | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Office costs | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Property expenses | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Depreciation | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Professional costs | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Bad debt | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Platform Costs | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Interests on loans | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
Tax | forecasted | forecasted | forecasted | forecasted | forecasted | forecasted | - | - | ||||||||||||||||||||||||
INVESTMENTS | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||
Building and structures | - | - | ||||||||||||||||||||||||||||||
Equipment | - | - | ||||||||||||||||||||||||||||||
Vehicle | - | - | ||||||||||||||||||||||||||||||
General installations | - | - | ||||||||||||||||||||||||||||||
IT - Laptop | - | - | ||||||||||||||||||||||||||||||
INTERBANK TRANSFERS | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||
Loan | - | |||||||||||||||||||||||||||||||
Withdrawal of Petty Cash | - | |||||||||||||||||||||||||||||||
Deposit from Petty Cash | - | |||||||||||||||||||||||||||||||
Transfer from bank account | - | |||||||||||||||||||||||||||||||
TOTAL | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||
Opening Balance | 200,000 | |||||||||||||||||||||||||||||||
Closing balance |
Please complete this table using inputs from the following tabs. Additional comments: - Please implement formula checks to ensure completeness of the information inputted. - Implement automated color coded cells for column W and AA, depending if YTD Actuals and FY Forecast are over/under budget
2. Forecast 2019
2019-01 | 2019-02 | 2019-03 | 2019-04 | 2019-05 | 2019-06 | 2019-07 | 2019-08 | 2019-09 | 2019-10 | 2019-11 | 2019-12 | |||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL | ||
Income | - 0 | 897,473 | 90,525 | 303,900 | 90,525 | 90,525 | 90,525 | 90,525 | 303,900 | 90,525 | - 0 | - 0 | 2,048,425 | |
400000 | School fees | - 0 | 897,473 | 90,525 | 303,900 | 90,525 | 90,525 | 90,525 | 90,525 | 303,900 | 90,525 | - 0 | - 0 | 2,048,425 |
400020 | Foundation Course 1 | 806,948 | - 0 | 806,948 | ||||||||||
400030 | Foundation Course 2 | - 0 | - 0 | |||||||||||
400040 | Cambridge Secondary 1 | - 0 | - 0 | |||||||||||
400050 | Cambridge Secondary 2 | 11,130 | 11,130 | 11,130 | 11,130 | 11,130 | 11,130 | 11,130 | 11,130 | 11,130 | - 0 | 100,170 | ||
400060 | AS level | 69,199 | 69,199 | 264,574 | 69,199 | 69,199 | 69,199 | 69,199 | 264,574 | 69,199 | - 0 | 1,013,538 | ||
400070 | A level | 10,197 | 10,197 | 28,197 | 10,197 | 10,197 | 10,197 | 10,197 | 28,197 | 10,197 | - 0 | 127,770 | ||
400200 | Registration fees | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
400210 | Registration fees | - 0 | ||||||||||||
Other income | - 0 | 213,417 | 140,000 | 140,000 | 80,000 | 80,000 | 110,000 | 50,000 | 287,500 | 50,000 | - 0 | - 0 | 1,150,917 | |
700000 | Other income | - 0 | 213,417 | 140,000 | 140,000 | 80,000 | 80,000 | 110,000 | 50,000 | 287,500 | 50,000 | - 0 | - 0 | 1,150,917 |
700010 | Books | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
700020 | Calculators | - | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
700030 | Canteen | - | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
700040 | Examination fee | 133,417 | - 0 | - 0 | - 0 | - 0 | 237,500 | - 0 | - 0 | - 0 | 370,917 | |||
700050 | Study tour | - | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
700060 | Uniforms | - | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
700070 | Transport | - | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
700080 | Other extra-curriculum activities | - | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||
700090 | Homestay | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 50,000 | 50,000 | 50,000 | 50,000 | - 0 | - 0 | 600,000 | |
700100 | Other | 60,000 | 60,000 | - 0 | 60,000 | - 0 | - 0 | - 0 | - 0 | 180,000 | ||||
Expenses | - 0 | - 832,945 | - 612,986 | - 495,735 | - 495,735 | - 528,086 | - 464,058 | - 464,058 | - 533,090 | - 457,808 | - 411,308 | - 191,026 | - 5,486,836 | |
600000 | Other income related expenses | - 0 | - 96,545 | - 177,518 | - 74,400 | - 74,400 | - 74,400 | - 46,500 | - 46,500 | - 155,821 | - 46,500 | - 0 | - 0 | - 792,584 |
600010 | Books | - | - 22,145 | - 31,640 | - 53,785 | |||||||||
600020 | Calculators | - | - 0 | - 0 | - 0 | |||||||||
600030 | Canteen | - 0 | - 0 | - 0 | ||||||||||
600040 | Examination fee | - | - 0 | - 71,478 | - 109,321 | - 180,799 | ||||||||
600050 | Study tour | - | - 0 | - 0 | - 0 | |||||||||
600060 | Uniforms | - 0 | - 0 | - 0 | ||||||||||
600070 | Homestay | - 74,400 | - 74,400 | - 74,400 | - 74,400 | - 74,400 | - 46,500 | - 46,500 | - 46,500 | - 46,500 | - 558,000 | |||
600080 | Other extra-curriculum activities | - | - 0 | - 0 | - 0 | |||||||||
600100 | Salaries - Teaching staff | - 0 | - 440,564 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 0 | - 2,423,102 |
600110 | Basic salaries | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 220,282 | - 2,202,820 | ||
600120 | Staff salary - foreign component | - 220,282 | - 0 | - 220,282 | ||||||||||
600130 | Other employee costs | - 0 | ||||||||||||
600140 | Transport allowance | - 0 | ||||||||||||
600150 | PAYE | - 0 | ||||||||||||
600180 | UIF | - 0 | ||||||||||||
600190 | SDL | - 0 | ||||||||||||
600200 | Salaries - Admin staff | - 0 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 0 | - 66,167 | - 66,167 | - 66,167 | - 661,670 |
600210 | Basic Salaries | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 66,167 | - 727,837 | |
600220 | Staff salary - foreign component | - 0 | - 0 | - 0 | ||||||||||
600230 | Employee benefits(rent,medical aid, flight) | - 0 | ||||||||||||
600240 | Transport allowance | - 0 | ||||||||||||
600250 | PAYE | - 0 | ||||||||||||
600260 | SDL | - 0 | ||||||||||||
600270 | UIF | - 0 | ||||||||||||
600280 | Bonuses | - 0 | ||||||||||||
600290 | Other employee costs | - 0 | ||||||||||||
600300 | Travel costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
600310 | Accommodation | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600320 | Car hire / rental expenses | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600330 | Flights | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600340 | Vehicle expenses | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600350 | Visa costs | - 0 | - 0 | - 0 | ||||||||||
600400 | Quality / accreditation | - 0 | - 22,000 | - 15,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 37,000 |
600410 | Accreditation costs | - 10,000 | - 15,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 25,000 | ||||
600420 | Quality costs / training | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
600430 | Seminar, Conference and Workshop Costs | - 12,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 12,000 | |||||
600500 | Academics | - 0 | - 14,250 | - 7,250 | - 7,250 | - 7,250 | - 7,250 | - 7,250 | - 7,250 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 61,750 |
600510 | Art and Music | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600520 | Laboratory | - 6,250 | - 6,250 | - 6,250 | - 6,250 | - 6,250 | - 6,250 | - 6,250 | - 43,750 | |||||
600530 | Library | - 7,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 7,000 | |||||
600540 | Physical and Health Education | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 11,000 | |
600550 | Other educational costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||
600600 | Scholarships | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
600610 | Cost of Scholarship Students | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600620 | Cost of Scholarship Students Recruitment | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
600700 | Marketing and student recruitment | - 0 | - 15,000 | - 11,500 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 116,500 |
600710 | Advertising | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 10,000 | - 110,000 | |
600720 | Events | - 0 | ||||||||||||
600730 | Online Marketing | - 0 | - 0 | - 0 | ||||||||||
600740 | Marketing material | - 0 | ||||||||||||
600750 | Open days | - 0 | ||||||||||||
600760 | Partnerships | - 0 | ||||||||||||
600770 | Other marketing costs | - 5,000 | - 1,500 | - 6,500 | ||||||||||
600800 | Communication and IT/IS costs | - 0 | - 18,067 | - 10,266 | - 12,633 | - 12,633 | - 17,856 | - 7,856 | - 7,856 | - 7,856 | - 7,856 | - 7,856 | - 7,856 | - 118,591 |
600810 | Internet | - 2,981 | - 2,981 | - 2,981 | - 2,981 | - 2,981 | - 2,981 | - 2,981 | - 2,981 | - 2,981 | - 26,829 | |||
600820 | Landline | - 4,555 | - 1,754 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 33,309 | |
600830 | Licences | - | - 4,777 | - 4,777 | - 4,777 | - 4,777 | - 10,000 | - 29,108 | ||||||
600840 | Mobile communications | - 2,735 | - 2,735 | - 875 | - 875 | - 875 | - 875 | - 875 | - 875 | - 875 | - 875 | - 875 | - 13,345 | |
600850 | Non Capital IT Equipment | - 5,000 | - 5,000 | |||||||||||
600860 | IT Repairs and Maintenance | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 11,000 | |
600900 | Office costs | - 0 | - 24,677 | - 10,777 | - 10,777 | - 10,777 | - 37,905 | - 11,777 | - 11,777 | - 43,905 | - 11,777 | - 11,777 | - 11,777 | - 197,703 |
600910 | Bank charges | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 22,000 | |
600920 | Courier and postage | - 900 | - 26,128 | - 26,128 | - 53,156 | |||||||||
600930 | Entertainment | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 8,000 | ||||
600940 | Health and Safety | - 12,000 | - 6,000 | - 18,000 | ||||||||||
600950 | Insurance | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 1,277 | - 14,047 | |
600960 | Printing and stationery | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 55,000 | |
600970 | Other office costs | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 16,500 | |
600980 | Vehicle and fuel | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 11,000 | |
601000 | Property expenses | - 0 | - 114,826 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 93,726 | - 1,052,087 |
601010 | Cleaning | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 22,000 | |
601020 | Property repairs / maintenance / improvements | - 21,100 | - 21,100 | |||||||||||
601030 | Rent | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 72,726 | - 799,987 | |
601040 | Security | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 11,000 | |
601050 | Utilities | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 242,000 | |
601100 | Depreciation | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601110 | Depreciation of buildings and structures | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
601120 | Depreciation of equipment and furnishings | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
601130 | Depreciation of vehicles | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
601200 | Professional costs | - 0 | - 20,849 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 25,849 |
601210 | Accounting fees | - 0 | - 0 | - 0 | ||||||||||
601220 | Audit fees | - 20,349 | - 0 | - 20,349 | ||||||||||
601230 | Consulting fees | - 0 | ||||||||||||
601240 | Legal fees | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 500 | - 5,500 | |
601300 | Bad debt | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601310 | Bad debt provisions | - 0 | - 0 | |||||||||||
601320 | Write offs | - 0 | - 0 | - 0 | ||||||||||
601400 | Platform Costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601410 | Platform management fees | - 0 | ||||||||||||
601420 | Licence fees | - 0 | ||||||||||||
601500 | Interests on loans | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601510 | External loans | - 0 | ||||||||||||
601520 | Intercompany loans | - 0 | ||||||||||||
601600 | Tax | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601610 | Corporate tax | - 0 | ||||||||||||
601620 | Tax risk provision | - 0 | ||||||||||||
601630 | Withholding tax-local | - 0 | ||||||||||||
EBITDA | - 0 | 277,945 | - 382,461 | - 51,835 | - 325,210 | - 357,561 | - 263,533 | - 323,533 | 58,310 | - 317,283 | - 411,308 | - 191,026 | - 2,287,494 | |
INVESTMENTS | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
Building and structures | - 0 | |||||||||||||
Equipment | - 0 | |||||||||||||
Vehicle | - 0 | |||||||||||||
General installations | - 0 | |||||||||||||
IT - Laptop | - 0 | |||||||||||||
SOURCE OF INFO FOR REFORECASTED NUMBERS - NO INPUT REQUIRED IN THIS TAB.
3. Budget 2019
Enko Sandton | 2019-01 | 2019-02 | 2019-03 | 2019-04 | 2019-05 | 2019-06 | 2019-07 | 2019-08 | 2019-09 | 2019-10 | 2019-11 | 2019-12 | |||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL 2019 | H1 2019 | ||
Assets | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
100000 | Non currents assets | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
100010 | Buildings and structures | - 0 | - 0 | ||||||||||||
100030 | Equipment and furnishings | - 0 | - 0 | ||||||||||||
Income | 852,050 | 89,550 | 89,550 | 259,550 | 89,550 | 89,550 | 89,550 | 89,550 | 259,550 | 89,550 | - 0 | - 0 | 1,998,000 | 1,469,800 | |
400000 | School fees | 829,550 | 89,550 | 89,550 | 259,550 | 89,550 | 89,550 | 89,550 | 89,550 | 259,550 | 89,550 | - 0 | - 0 | 1,975,500 | 1,447,300 |
400020 | Foundation Course 1 | - 0 | - 0 | - 0 | - 0 | ||||||||||
400030 | Foundation Course 2 | - 0 | - 0 | - 0 | - 0 | ||||||||||
400040 | Cambridge Secondary 1 | 529,550 | 29,550 | 29,550 | 199,550 | 29,550 | 29,550 | 29,550 | 29,550 | 199,550 | 29,550 | - 0 | - 0 | 1,135,500 | 847,300 |
400050 | Cambridge Secondary 2 | 60,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | - 0 | - 0 | 168,000 | 120,000 |
400060 | AS level | 60,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | 12,000 | - 0 | - 0 | 168,000 | 120,000 |
400070 | A level | 180,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | 36,000 | - 0 | - 0 | 504,000 | 360,000 |
400200 | Registration fees | 22,500 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 22,500 | 22,500 |
400210 | Registration fees | 22,500 | 22,500 | 22,500 | |||||||||||
Other income | 60,000 | 20,000 | 385,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 270,000 | 20,000 | - 0 | - 0 | 855,000 | 525,000 | |
- 0 | - 0 | ||||||||||||||
700000 | Other income | 60,000 | 20,000 | 385,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 270,000 | 20,000 | - 0 | - 0 | 855,000 | 525,000 |
700010 | Books | 40,000 | 15,000 | 55,000 | 55,000 | ||||||||||
700020 | Calculators | - 0 | - 0 | ||||||||||||
700030 | Canteen | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||
700040 | Examination fee | - 0 | - 0 | 350,000 | 175,000 | 525,000 | 350,000 | ||||||||
700050 | Study tour | - 0 | - 0 | ||||||||||||
700060 | Uniforms | - 0 | - 0 | ||||||||||||
700070 | Transport | - 0 | - 0 | ||||||||||||
700080 | Other extra-curriculum activities | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||
700090 | Homestay | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | 20,000 | - 0 | 200,000 | 120,000 | |
700100 | Annual award cocktail | - 0 | - 0 | - 0 | - 0 | - 0 | 75,000 | 75,000 | - 0 | ||||||
Expenses | - 696,757 | - 478,357 | - 429,257 | - 433,657 | - 439,257 | - 433,257 | - 427,257 | - 427,257 | - 792,657 | - 482,257 | - 344,376 | - 527,176 | - 5,911,522 | - 2,910,542 | |
- 0 | - 0 | ||||||||||||||
600000 | Other income related expenses | - 168,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 368,000 | - 73,000 | - 0 | - 0 | - 735,000 | - 258,000 |
600010 | Books | - 50,000 | - 50,000 | - 50,000 | |||||||||||
600020 | Calculators | - 0 | - 0 | ||||||||||||
600030 | Canteen | - 0 | - 0 | ||||||||||||
600040 | Examination fee | - 100,000 | - 350,000 | - 450,000 | - 100,000 | ||||||||||
600050 | Study tour | - 0 | - 0 | - 0 | |||||||||||
600060 | Uniforms | - 0 | - 0 | ||||||||||||
600070 | Transport | - 0 | - 0 | ||||||||||||
600080 | Other extra-curriculum activities | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||
600090 | Homestay | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 18,000 | - 0 | - 0 | - 180,000 | |
xxxx | Annual award cocktail | - 55,000 | |||||||||||||
600100 | Salaries - Teaching Staff | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 0 | - 0 | - 540,000 | - 324,000 |
600110 | Basic salaries | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 54,000 | - 540,000 | - 324,000 | ||
600120 | Staff salary - foreign component | - 0 | - 0 | ||||||||||||
600130 | Employee benefits (rent, medical aid, flight) | - 0 | - 0 | ||||||||||||
600140 | Transport allowance | - 0 | - 0 | ||||||||||||
600150 | PAYE | - 0 | - 0 | ||||||||||||
600160 | SDL | - 0 | - 0 | ||||||||||||
600170 | UIF | - 0 | - 0 | ||||||||||||
600180 | Bonuses | - 0 | - 0 | ||||||||||||
600190 | Other Employee costs | - 0 | - 0 | ||||||||||||
600200 | Salaries - Admin Staff | - 192,150 | - 192,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 1,845,800 | - 968,900 |
600210 | Basic salaries | - 192,150 | - 192,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 146,150 | - 1,845,800 | - 968,900 |
600220 | Staff salary - foreign component | - 0 | - 0 | ||||||||||||
600230 | Employee benefits (rent, medical aid, flight) | - 0 | - 0 | ||||||||||||
600240 | Transport allowance | - 0 | - 0 | ||||||||||||
600250 | PAYE | - 0 | - 0 | ||||||||||||
600260 | SDL | - 0 | - 0 | ||||||||||||
600270 | UIF | - 0 | - 0 | ||||||||||||
600280 | Bonuses | - 0 | - 0 | ||||||||||||
600290 | Other Employee costs | - 0 | - 0 | ||||||||||||
600300 | Travel costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
600310 | Accommodation | - 0 | - 0 | ||||||||||||
600320 | Car hire / rental expenses | - 0 | - 0 | ||||||||||||
600330 | Flights | - 0 | - 0 | ||||||||||||
600340 | Vehicle expenses | - 0 | - 0 | ||||||||||||
600350 | Visa costs | - 0 | - 0 | ||||||||||||
600400 | Quality / accreditation | - 16,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 27,000 | - 21,000 |
600410 | Accreditation costs | - 0 | - 0 | ||||||||||||
600420 | Quality costs / training | - 0 | - 0 | ||||||||||||
600430 | Seminar, Conference and Workshop Costs | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 12,000 | - 6,000 |
xxxx | Memberships | - 15,000 | - 15,000 | - 15,000 | |||||||||||
600500 | Academics | - 25,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 80,000 | - 50,000 |
600510 | Art and Music | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 12,000 | - 6,000 |
600520 | Laboratory | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 36,000 | - 18,000 |
600530 | Library | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 12,000 | - 6,000 |
600540 | Physical and Health Education | - 0 | - 0 | - 0 | |||||||||||
600550 | Other educational costs | - 20,000 | - 20,000 | - 20,000 | |||||||||||
600600 | Scholarships | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 0 | - 0 | - 250,900 | - 150,540 |
600610 | Cost of Scholarship Students | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 25,090 | - 250,900 | - 150,540 | ||
600620 | Cost of Scholarship Students Recruitment | - 0 | - 0 | ||||||||||||
600700 | Marketing and student recruitment | - 30,000 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 17,500 | - 222,500 | - 117,500 |
600710 | Advertising | - 25,000 | - 12,500 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 16,000 | - 197,500 | - 101,500 |
600720 | Events | - 0 | - 0 | ||||||||||||
600730 | Online Marketing | - 0 | - 0 | ||||||||||||
600740 | Printing | - 0 | - 0 | ||||||||||||
600750 | Telemarketers | - 0 | - 0 | ||||||||||||
600760 | Commissions | - 0 | - 0 | ||||||||||||
600770 | Other marketing costs | - 5,000 | - 5,000 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 25,000 | - 16,000 |
600800 | Communication and IT/IS costs | - 15,635 | - 15,635 | - 15,635 | - 15,635 | - 12,635 | - 12,635 | - 12,635 | - 12,635 | - 12,635 | - 12,635 | - 12,635 | - 12,635 | - 163,620 | - 87,810 |
600810 | Internet | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 1,900 | - 22,800 | - 11,400 |
600820 | Landline | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 24,000 | - 12,000 |
600830 | Licences | - 5,000 | - 5,000 | - 5,000 | - 5,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 36,000 | - 24,000 |
600840 | Mobile communications | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 2,735 | - 32,820 | - 16,410 |
600850 | Non Capital IT Equipment | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 24,000 | - 12,000 |
600860 | IT Repairs and Maintenance | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 24,000 | - 12,000 |
600900 | Office costs | - 22,200 | - 16,100 | - 13,000 | - 14,000 | - 26,000 | - 20,000 | - 14,000 | - 14,000 | - 26,000 | - 14,000 | - 30,000 | - 13,000 | - 222,300 | - 111,300 |
600910 | Bank charges | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 24,000 | - 12,000 |
600920 | Courier and postage | - 0 | - 900 | - 1,000 | - 13,000 | - 7,000 | - 1,000 | - 1,000 | - 13,000 | - 1,000 | - 17,000 | - 0 | - 54,900 | - 21,900 | |
600930 | Entertainment | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 18,000 | - 9,000 |
600940 | Health and Safety | - 9,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 31,000 | - 19,000 |
600950 | Insurance | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 24,000 | - 12,000 |
600960 | Printing and stationery | - 5,200 | - 5,200 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 40,400 | - 22,400 |
600970 | Other office costs | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 1,500 | - 18,000 | - 9,000 |
600980 | Vehicle and fuel | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 12,000 | - 6,000 |
601000 | Property expenses | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 95,091 | - 1,141,092 | - 570,546 |
601010 | Cleaning | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 36,000 | - 18,000 |
601020 | Property repairs / maintenance / improvements | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 2,000 | - 24,000 | - 12,000 |
601030 | Rent | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 67,091 | - 805,092 | - 402,546 |
601040 | Security | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 1,000 | - 12,000 | - 6,000 |
601050 | Utilities | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 22,000 | - 264,000 | - 132,000 |
601100 | Depreciation | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601110 | Depreciation of buildings and structures | - 0 | - 0 | ||||||||||||
601120 | Depreciation of equipment and furnishings | - 0 | - 0 | ||||||||||||
601130 | Depreciation of vehicles | - 0 | - 0 | ||||||||||||
601200 | Professional costs | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 9,000 | - 108,000 | - 54,000 |
601210 | Accounting fees | - 0 | - 0 | ||||||||||||
601220 | Audit fees | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 6,000 | - 72,000 | - 36,000 |
601230 | Consulting fees | - 0 | - 0 | ||||||||||||
601240 | Legal fees | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 3,000 | - 36,000 | - 18,000 |
601300 | Bad debt | - 16,591 | - 1,791 | - 1,791 | - 5,191 | - 1,791 | - 1,791 | - 1,791 | - 1,791 | - 5,191 | - 1,791 | - 0 | - 0 | - 39,510 | - 28,946 |
601310 | Bad debt provisions | - 16,591 | - 1,791 | - 1,791 | - 5,191 | - 1,791 | - 1,791 | - 1,791 | - 1,791 | - 5,191 | - 1,791 | - 0 | - 0 | - 39,510 | - 28,946 |
601320 | Write offs | - 0 | - 0 | ||||||||||||
601400 | Platform Costs | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 227,800 | - 535,800 | - 168,000 |
601410 | Platform management fees | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 28,000 | - 336,000 | - 168,000 |
601420 | Licence fees | - 199,800 | - 199,800 | - 0 | |||||||||||
601500 | Interests on loans | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601510 | External loans | - 0 | - 0 | ||||||||||||
601520 | Intercompany loans | - 0 | - 0 | ||||||||||||
601600 | Tax | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
601610 | Corporate tax | - 0 | - 0 | ||||||||||||
601620 | Tax risk provision | - 0 | - 0 | ||||||||||||
EBITDA | 215,293 | - 368,807 | 45,293 | - 154,107 | - 329,707 | - 323,707 | - 317,707 | - 317,707 | - 263,107 | - 372,707 | - 344,376 | - 527,176 | - 3,058,522 | - 915,742 | |
SOURCE OF INFO FOR BUDGETED NUMBERS - NO INPUT REQUIRED IN THIS TAB.
4. Actual (Jan 19) - Bank
YYYY-MM | Date | Amount | Balance | Category | Sub-category | Account | Description | Hard data | |||||||
2019-01 | 03 Jan | 1500 | 237083.25 | Income | Registration fees | Registration fees | registration fees | ||||||||
2019-01 | 03 Jan | -8576.59 | 228506.66 | Expenses | Property expenses | Cleaning | property cleaning | ||||||||
2019-01 | 03 Jan | -1.1 | 228505.56 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 04 Jan | -6800 | 221705.56 | Expenses | Marketing and student recruitment | Other marketing costs | Angels car rental | ||||||||
2019-01 | 04 Jan | -534.65 | 221170.91 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 04 Jan | -1.1 | 221169.81 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 05 Jan | -993.37 | 220176.44 | Expenses | Office costs | Other office costs | decorative plant supplier | ||||||||
2019-01 | 07 Jan | 740 | 220916.44 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 07 Jan | 1960 | 222876.44 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 07 Jan | -187.8 | 222688.64 | Expenses | Other income related expenses | Canteen | petty cash box and receipt book for tuckshop | ||||||||
2019-01 | 07 Jan | -2359.6 | 220329.04 | Expenses | Communication and IT/IS costs | Internet | internet and telephone lines | ||||||||
2019-01 | 07 Jan | -1089 | 219240.04 | Expenses | Communication and IT/IS costs | Mobile communications | purchase of airtime | ||||||||
2019-01 | 07 Jan | -420.44 | 218819.6 | Expenses | Marketing and student recruitment | Other marketing costs | fuel | ||||||||
2019-01 | 07 Jan | -6.2 | 218813.4 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 07 Jan | -6.2 | 218807.2 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 07 Jan | -6.2 | 218801 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 07 Jan | -1.1 | 218799.9 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 08 Jan | -671.42 | 218128.48 | Expenses | Marketing and student recruitment | Other marketing costs | fuel | ||||||||
2019-01 | 08 Jan | -6.2 | 218122.28 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 09 Jan | 500 | 218622.28 | Expenses | School fees | School fees | outstanding school fees-2016 | ||||||||
2019-01 | 09 Jan | -1576 | 217046.28 | Expenses | Property expenses | Cleaning | house cleaning items | ||||||||
2019-01 | 09 Jan | -144 | 216902.28 | Expenses | Office costs | Other office costs | cabinet paper and sello tape | ||||||||
2019-01 | 09 Jan | -4006 | 212896.28 | Investments | IT - Laptop | IT - Laptop | purchase of computer for Examinations officer | ||||||||
2019-01 | 09 Jan | -6.2 | 212890.08 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 09 Jan | -6.2 | 212883.88 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 09 Jan | -6.2 | 212877.68 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 10 Jan | 7428.98 | 220306.66 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 10 Jan | 3500 | 223806.66 | Other income | Other income | Other | refund from car hire-Rent my ride | ||||||||
2019-01 | 10 Jan | -354 | 223452.66 | Expenses | Property expenses | Improvements | purchase of locks | ||||||||
2019-01 | 10 Jan | -1465.25 | 221987.41 | Expenses | Other income related expenses | Canteen | items purchased for tuckshop | ||||||||
2019-01 | 10 Jan | -1499 | 220488.41 | Expenses | Academics | Other educational costs | platters for the orientation day | ||||||||
2019-01 | 10 Jan | -6.2 | 220482.21 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 10 Jan | -6.2 | 220476.01 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 10 Jan | -6.2 | 220469.81 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 10 Jan | -1277.3 | 219192.51 | Expenses | Property expenses | Insurance | property insurance | ||||||||
2019-01 | 11 Jan | 1500 | 220692.51 | Income | Registration fees | Registration fees | Registration fees-2019 | ||||||||
2019-01 | 11 Jan | -205 | 220487.51 | Expenses | Property expenses | Improvements | purchase of locks | ||||||||
2019-01 | 11 Jan | -26128.05 | 194359.46 | Expenses | Office costs | Courier and postage | examination papers to cambridge | ||||||||
2019-01 | 11 Jan | -4545 | 189814.46 | Expenses | Academics | Other educational costs | student tour around johannesburg | ||||||||
2019-01 | 11 Jan | -6.2 | 189808.26 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 12 Jan | -112.51 | 189695.75 | Expenses | Office costs | Other office costs | juice for lunch-orientation week | ||||||||
2019-01 | 12 Jan | -1220 | 188475.75 | Expenses | Academics | Other educational costs | parents day- refreshments served | ||||||||
2019-01 | 12 Jan | -6.2 | 188469.55 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 12 Jan | -6.2 | 188463.35 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 14 Jan | 3383.04 | 191846.39 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 14 Jan | 4260 | 196106.39 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 14 Jan | 326.5 | 196432.89 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 14 Jan | 18850 | 215282.89 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 14 Jan | -341.65 | 214941.24 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 14 Jan | -40.35 | 214900.89 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 15 Jan | 4238.5 | 219139.39 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 15 Jan | -510.1 | 218629.29 | Expenses | Marketing and student recruitment | Other marketing costs | fuel | ||||||||
2019-01 | 15 Jan | -6.2 | 218623.09 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 43481 | 90000 | 308623.09 | Income | School fees | School fees | Registration fees-2019 | ||||||||
2019-01 | 16 Jan | 1500 | 310123.09 | Income | Registration fees | Registration fees | Registration fees-2019 | ||||||||
2019-01 | 16 Jan | 1500 | 311623.09 | Income | Registration fees | Registration fees | Registration fees-2019 | ||||||||
2019-01 | 17 Jan | 86300 | 397923.09 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 17 Jan | -1499.44 | 396423.65 | Expenses | Property expenses | Cleaning | purchase to hoover | ||||||||
2019-01 | 17 Jan | -2600 | 393823.65 | Expenses | Academics | Other educational costs | university consulting fee | ||||||||
2019-01 | 17 Jan | -9605 | 384218.65 | Expenses | Other income related expenses | uniforms | uniform supplier | ||||||||
2019-01 | 17 Jan | -6.2 | 384212.45 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 18 Jan | 143925 | 528137.45 | Other income | Other income | Other | |||||||||
2019-01 | 18 Jan | -1218.99 | 526918.46 | Expenses | Academics | Art and Music | purchase of material for art | ||||||||
2019-01 | 18 Jan | -554.82 | 526363.64 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 18 Jan | -6.2 | 526357.44 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 19 Jan | -1500 | 524857.44 | Expenses | Salaries - Admin staff | Basic salaries | salary advance-mazvita akintola | ||||||||
2019-01 | 21 Jan | 17860 | 542717.44 | Income | School fees | School fees | outstanding school fee balance 2018 | ||||||||
2019-01 | 21 Jan | -545.7 | 542171.74 | Expenses | Marketing and student recruitment | Other marketing costs | fuel | ||||||||
2019-01 | 21 Jan | -6.2 | 542165.54 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 22 Jan | -604.9 | 541560.64 | Expenses | Marketing and student recruitment | Marketing material | printing of flyers | ||||||||
2019-01 | 22 Jan | -164 | 541396.64 | Expenses | Property expenses | Improvements | new lock purchased for property | ||||||||
2019-01 | 22 Jan | -6.2 | 541390.44 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 22 Jan | -6.2 | 541384.24 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 22 Jan | -120 | 541264.24 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -18609.2 | 522655.04 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -49 | 522606.04 | Expenses | Property expenses | Cleaning | dust masks | ||||||||
2019-01 | 24 Jan | -1790.6 | 520815.44 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -2509.32 | 518306.12 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -14000 | 504306.12 | Expenses | Salaries - Admin staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -22211.54 | 482094.58 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -21903.67 | 460190.91 | Expenses | Salaries - Admin staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -24303.57 | 435887.34 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -900 | 434987.34 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -2025 | 432962.34 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -2850 | 430112.34 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 24 Jan | -6.2 | 430106.14 | Office costs | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.1 | 430105.04 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.25 | 430103.79 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.1 | 430102.69 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.25 | 430101.44 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.25 | 430100.19 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.1 | 430099.09 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.1 | 430097.99 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.25 | 430096.74 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 24 Jan | -1.25 | 430095.49 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 25 Jan | 1500 | 431595.49 | Income | Registration fees | Registration fees | Registration fee-2019 | ||||||||
2019-01 | 25 Jan | 1500 | 433095.49 | Income | Registration fees | Registration fees | Registration fee-2019 | ||||||||
2019-01 | 25 Jan | -3000 | 430095.49 | Expenses | Salaries - Admin staff | Basic salaries | Irene part time staff | ||||||||
2019-01 | 25 Jan | -1500 | 428595.49 | Expenses | Salaries - Admin staff | Basic salaries | Primrose staff | ||||||||
2019-01 | 25 Jan | -2529.6 | 426065.89 | Expenses | Office costs | entertainment | staff lunch-mazvita marketing offices resignation | ||||||||
2019-01 | 25 Jan | -6.2 | 426059.69 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 25 Jan | -52.1 | 426007.59 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 25 Jan | -1.25 | 426006.34 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 25 Jan | -1.25 | 426005.09 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 26 Jan | -4777.13 | 421227.96 | Expenses | Property expenses | Cleaning | cleaning of school toilet and suppliers of all toilet sanitation | ||||||||
2019-01 | 26 Jan | -8500 | 412727.96 | Expenses | Salaries - Admin staff | Basic salaries | staff salary | ||||||||
2019-01 | 26 Jan | -405.34 | 412322.62 | Expenses | Marketing and student recruitment | Other marketing costs | fuel | ||||||||
2019-01 | 26 Jan | -6.2 | 412316.42 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 26 Jan | -1.25 | 412315.17 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 28 Jan | 27730 | 440045.17 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 28 Jan | 4088.5 | 444133.67 | Other income | Other income | Examination fee | examination fee-2019 | ||||||||
2019-01 | 28 Jan | 8000 | 452133.67 | Other income | Other income | Laboratory | lab workshop sessions | ||||||||
2019-01 | 28 Jan | 2000 | 454133.67 | Other income | Other income | Examination fee | examination fee-2019 | ||||||||
2019-01 | 28 Jan | 500 | 454633.67 | Income | School fees | School fees | outstanding school fee balance 2016 | ||||||||
2019-01 | 28 Jan | 92730 | 547363.67 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 29 Jan | 2000 | 549363.67 | Other income | Other income | Examination fee | examination fee-2019 | ||||||||
2019-01 | 29 Jan | 517.9 | 549881.57 | Income | School fees | School fees | outstanding school fee balance 2016 | ||||||||
2019-01 | 29 Jan | 5873 | 555754.57 | Other income | Other income | Examination fee | examination fee-2019 | ||||||||
2019-01 | 29 Jan | 1500 | 557254.57 | Income | Registration fees | Registration fees | registration fees-2019 | ||||||||
2019-01 | 29 Jan | 8272.5 | 565527.07 | Other income | Other income | Examination fee | examination fee-2019 | ||||||||
2019-01 | 29 Jan | 2419.25 | 567946.32 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 29 Jan | 4338.5 | 572284.82 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 29 Jan | 4500 | 576784.82 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 29 Jan | 6257.75 | 583042.57 | Income | School fees | School fees | school fees-2019 | ||||||||
2019-01 | 29 Jan | -570 | 582472.57 | Expenses | Professional costs | Accounting fees | SARS submission | ||||||||
2019-01 | 29 Jan | -3519.96 | 578952.61 | Expenses | Office costs | Printing and stationary | printer rental with supplier | ||||||||
2019-01 | 29 Jan | -10373 | 568579.61 | Expenses | Office costs | Health and Safety | service of fire extinguishers | ||||||||
2019-01 | 29 Jan | -115 | 568464.61 | Expenses | Property expenses | security | call out fee for ADT | ||||||||
2019-01 | 29 Jan | -1550.32 | 566914.29 | Expenses | Office costs | Health and Safety | service of fire extinguishers | ||||||||
2019-01 | 29 Jan | -3230 | 563684.29 | Expenses | Marketing and student recruitment | Other marketing costs | canvas Printing | ||||||||
2019-01 | 29 Jan | -1105 | 562579.29 | Expenses | Office costs | Other office costs | once of assistance of a general worker wage | ||||||||
2019-01 | 29 Jan | -591.1 | 561988.19 | Expenses | Office costs | Other office costs | provider for the water dispensers | ||||||||
2019-01 | 29 Jan | -2100 | 559888.19 | Expenses | Communication and IT/IS costs | landline | landline installation | ||||||||
2019-01 | 29 Jan | -1070 | 558818.19 | Expenses | Communication and IT/IS costs | Mobile communications | airtime | ||||||||
2019-01 | 29 Jan | -11822 | 546996.19 | Expenses | Marketing and student recruitment | advertising | Enko Sandton signage installed | ||||||||
2019-01 | 29 Jan | -3641 | 543355.19 | Expenses | Communication and IT/IS costs | landline | purchase of corded phone x 4 | ||||||||
2019-01 | 29 Jan | -4971.21 | 538383.98 | Expenses | Office costs | Printing and stationary | groceries and stationery purchases | ||||||||
2019-01 | 29 Jan | -287.5 | 538096.48 | Expenses | Professional costs | Accounting fees | monthly fee for SARS submission | ||||||||
2019-01 | 29 Jan | -359.72 | 537736.76 | Expenses | Property expenses | Improvements | purchase of locks | ||||||||
2019-01 | 29 Jan | -20349.01 | 517387.75 | Expenses | Professional costs | audit fees | auditors fees | ||||||||
2019-01 | 29 Jan | -7071.25 | 510316.5 | Expenses | Academics | Laboratory | purchase of chemicals for the lab | ||||||||
2019-01 | 29 Jan | -1586.74 | 508729.76 | Expenses | Salaries - Teaching Staff | Basic salaries | Teachers salary | ||||||||
2019-01 | 29 Jan | -6.2 | 508723.56 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 29 Jan | -6.2 | 508717.36 | Expenses | Office costs | bank charges | bank charges | ||||||||
2019-01 | 30 Jan | -5015 | 503702.36 | Expenses | Academics | Other educational costs | tutor for chemistry | ||||||||
2019-01 | 30 Jan | -1460.5 | 502241.86 | Expenses | Office costs | Other office costs | provider for the water dispensers | ||||||||
2019-01 | 31 Jan | -996 | 501245.86 | Expenses | Property expenses | Property repairs / maintenance / improvements | |||||||||
2019-01 | 31 Jan | 72.13 | 501317.99 | Other income | Other income | Other | donation | ||||||||
2019-01 | 31 Jan | 1499 | 502816.99 | Other income | Other income | Other | refund for hoover | ||||||||
xxx | |||||||||||||||
??? previously bank charges | |||||||||||||||
??? To check? | |||||||||||||||
xxx Category to create: Expenses/Investment/Equipment | |||||||||||||||
xxx Category to create: Expenses/Investment/General Installations | |||||||||||||||
xxx Category to create: Expenses/Investment/General Installations | |||||||||||||||
xxx | |||||||||||||||
xxx | |||||||||||||||
SOURCE OF INFO FOR JAN ACTUAL NUMBERS - NO INPUT REQUIRED IN THIS TAB.