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
 
 
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
245,142.50 256,265.00 256,115.00 -4.34%49,990.0036,325.0010,510.0020,985.0026,780.508,785.0030,500.0042,016.0019,251.000.000.000.00
5
Subscriptions fees: Members 203,137.00 212,895.00 212,895.00 -4.58%46,210.0032,395.005,960.0016,815.0023,245.002,085.0026,450.0037,316.0012,661.00
6
Booking fees (Lights) 40,805.50 43,220.00 43,220.00 -5.59%3,780.003,930.004,400.004,020.003,535.506,700.003,450.004,400.006,590.00
7
League shirts 150.00 150.00 0.00%150.00
8
Affiliation fees - - #DIV/0!
9
Joining fees 1,050.00 - #DIV/0!150.00600.00300.00
10
11
OTHER CASH INFLOW
7,001.98 38.40 - 18134.32%1.410.570.007,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 7,000.00 - #DIV/0!7,000.00
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
217,386.83 242,345.31 234,123.92 -10.30%17,199.1533,384.5461,107.362,699.4044,252.3619,190.294,125.1117,549.2717,879.350.000.000.00
24
Salaries & Wages 73,000.00 86,620.00 93,549.60 -15.72%8,800.003,432.0017,248.0013,024.0012,936.008,536.009,024.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 29,301.90 51,729.00 31,646.05 -43.35%7,370.201,517.131,586.00780.783,000.003,000.006,047.796,000.00
29
Squash balls: league 3,600.00 8,128.00 8,128.00 -55.71%3,600.00
30
Telkom 4,305.44 5,940.85 5,940.85 -27.53%460.10464.01462.06486.54483.26487.34476.60499.38486.15
31
Computer expenses 2,657.45 3,399.75 3,399.75 -21.83%205.2051.30761.30281.50128.25360.1051.30818.50
32
Honoraria - -  
33
Internet - -
34
Tournaments & Functions 30,000.00 - 10,000.00 #DIV/0!30,000.00
35
Maintenance & Cleaning (equipment)
12,850.00 41,089.00 20,000.00 -68.73%3,130.005,000.001,910.001,960.00850.00
36
Bank Charges 4,667.15 5,617.67 5,617.67 -16.92%363.65798.10600.00300.00616.85496.85295.60495.40700.70
37
Printing & Stationary - - #DIV/0!
38
DSTV - - #DIV/0!
39
General and Other Expenses 1,150.00 - #DIV/0!850.00300.00
40
Entertainment - - #DIV/0!
41
Interest expense 12.89 1.04 0.581.6110.70
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)
34,757.65 13,958.09 21,991.08 - 149.01%32,792.262,941.03-50,597.3625,285.60-17,471.86-10,405.2926,374.8924,466.731,371.650.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