Financials for year ending 31 December 2017.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
31-Dec-1731-Dec-16Budget 2017% MovementJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17
3
4
MEMBERS CONTRIBUTIONS
160,375.50 256,265.00 256,115.00 -37.42%49,990.0036,325.0010,510.0027,985.0026,780.508,785.000.000.000.000.000.000.00
5
Subscriptions fees: Members 133,710.00 212,895.00 212,895.00 -37.19%46,210.0032,395.005,960.0023,815.0023,245.002,085.00
6
Booking fees (Lights) 26,365.50 43,220.00 43,220.00 -39.00%3,780.003,930.004,400.004,020.003,535.506,700.00
7
League shirts 150.00 150.00 0.00%150.00
8
Affiliation fees - - #DIV/0!
9
Joining fees 150.00 - #DIV/0!150.00
10
11
OTHER CASH INFLOW
1.98 38.40 - -94.84%1.410.570.000.000.000.000.000.000.000.000.000.00
12
Transponders & remotes - - #DIV/0!
13
Interest received - local stock - -
Local registered stock value is R99 724. Therefore, this income is 10% of the value
14
League fees - - #DIV/0!
15
Profit : sale of colddrinks & beers - -
16
Club Championship - -
17
Other receipts - - #DIV/0!
18
Donations received - - #DIV/0!
19
Maintenance fee - -
20
Diverse inkome - -
21
Interest received - bank 1.98 38.40 -94.84%1.410.57
22
23
MINUS: CASH OUTFLOW
177,833.10 242,345.31 217,872.31 -26.62%17,199.1533,384.5461,107.362,699.4044,252.3619,190.290.000.000.000.000.000.00
24
Salaries & Wages 55,440.00 86,620.00 93,549.60 -36.00%8,800.003,432.0017,248.0013,024.0012,936.00
25
Amortisation : capital improvements
- -
This amount was the same for the last two years. Assume same this year
26
Affiliation fees : Northerns 8,700.00 2,420.00 8,700.00 259.50%8,700.00
27
Rent paid : courts ( incl Rates and Taxes)
15,292.00 - 15,292.00 #DIV/0!15,292.00
28
Water & Lights 14,254.11 51,729.00 15,394.44 -72.44%7,370.201,517.131,586.00780.783,000.00
29
Squash balls: league 3,600.00 8,128.00 8,128.00 -55.71%3,600.00
30
Telkom 2,843.31 5,940.85 5,940.85 -52.14%460.10464.01462.06486.54483.26487.34
31
Computer expenses 1,787.65 3,399.75 3,399.75 -47.42%205.2051.30761.30281.50128.25360.10
32
Honoraria - -  
33
Internet - -
34
Tournaments & Functions 30,000.00 - 10,000.00 #DIV/0!30,000.00
35
Maintenance & Cleaning (equipment)
10,040.00 41,089.00 20,000.00 -75.57%3,130.005,000.001,910.00
36
Bank Charges 3,175.45 5,617.67 5,617.67 -43.47%363.65798.10600.00300.00616.85496.85
37
Printing & Stationary - - #DIV/0!
38
DSTV - - #DIV/0!
39
General and Other Expenses 850.00 - #DIV/0!850.00
40
Entertainment - - #DIV/0!
41
Interest expense 0.58 1.04 0.58
42
NSA League fees 30,350.00 32,900.00 30,350.00 -7.75%30,350.00
43
Transponders 1,500.00 - 1,500.00 #DIV/0!1,500.00
44
Prizes - 4,500.00 -100.00%
45
46
NET CASH INFLOW/ (OUTFLOW)
-17,455.62 13,958.09 38,242.69 - -225.06%32,792.262,941.03-50,597.3625,285.60-17,471.86-10,405.290.000.000.000.000.000.00
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Statement of Receipts and Expen
Balance Sheet