Financials for year ending 31 December 2016.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...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
31-Dec-1631-Dec-15% MovementJan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16
3
4
MEMBERS CONTRIBUTIONS
256,265.00 231,692.00 10.61%54,785.0041,890.0018,555.0018,860.0011,035.005,630.0038,855.0033,610.0010,940.005,695.0011,780.004,630.00
5
Subscriptions fees: Members 212,895.00 159,095.00 33.82%50,585.0035,810.0014,105.0012,110.008,235.003,630.0036,585.0029,720.008,690.002,845.008,530.002,050.00
6
Booking fees (Lights) 43,220.00 57,957.00 -25.43%4,200.005,930.004,450.006,750.002,800.002,000.002,270.003,890.002,250.002,850.003,250.002,580.00
7
League shirts 150.00 6,300.00 -97.62%150.00
8
Affiliation fees - 6,140.00 -100.00%
9
Joining fees - 2,200.00 -100.00%
10
11
OTHER CASH INFLOW
38.40 21,540.04 -99.82%0.841.805.664.893.503.822.803.494.343.382.251.63
12
Transponders & remotes - 4,575.00 -100.00%
13
Interest received - local stock - -
Local registered stock value is R99 724. Therefore, this income is 10% of the value
14
League fees - 6,720.00 -100.00%
15
Profit : sale of colddrinks & beers - -
16
Club Championship - -
17
Other receipts - 7,210.00 -100.00%
18
Donations received - 3,000.00 -100.00%
19
Maintenance fee - -
20
Diverse inkome - -
21
Interest received - bank 38.40 35.04 9.59%0.841.805.664.893.503.822.803.494.343.382.251.63
22
23
MINUS: CASH OUTFLOW
242,345.31 278,854.56 -13.09%6,122.0315,186.0248,377.0323,849.48788.8830,109.442,924.1650,928.0822,515.2515,647.3413,665.6212,231.98
24
Salaries & Wages 86,620.00 102,480.00 -15.48%8,100.006,480.0013,600.0014,880.002,000.0010,760.007,440.007,760.007,760.007,840.00
25
Amortisation : capital improvements
- -
This amount was the same for the last two years. Assume same this year
26
Affiliation fees : Northerns 2,420.00 7,560.00 -67.99%2,420.00
27
Rent paid : courts ( incl Rates and Taxes)
- 25,442.53 -100.00%
28
Water & Lights 51,729.00 38,527.59 34.26%5,000.003,000.005,000.004,000.008,000.008,729.005,000.005,000.005,000.003,000.00
29
Squash balls: league 8,128.00 1,800.00 351.56%8,128.00
30
Telkom 5,940.85 5,519.39 7.64%483.77511.29491.61510.18495.98535.14465.96475.08460.10480.04562.47469.23
31
Computer expenses 3,399.75 3,979.25 -14.56%271.00331.30323.30265.65624.60466.00153.90451.00513.00
32
Honoraria - -
33
Internet - -
34
Tournaments & Functions - 1,900.00 -100.00%
35
Maintenance & Cleaning (equipment)
41,089.00 13,002.65 216.00%2,770.005,000.0030,039.002,430.00850.00
36
Bank Charges 5,617.67 4,994.55 12.48%367.05472.60654.12473.65292.90449.70458.20459.00731.25506.30343.15409.75
37
Printing & Stationary - 760.90 -100.00%
38
DSTV - 348.00 -100.00%
39
General and Other Expenses - 40,053.31 -100.00%
40
Entertainment - 2,771.39 -100.00%
41
Interest expense 1.04 - 0.210.83
42
NSA League fees 32,900.00 26,640.00 23.50%27,300.003,200.002,400.00
43
Transponders - 225.00 -100.00%
44
Prizes 4,500.00 2,850.00 57.89%3,900.00600.00
45
46
NET CASH INFLOW/ (OUTFLOW)
13,958.09 -25,622.52 -154.48%48,663.8126,705.78-29,816.37-4,984.5910,249.62-24,475.6235,933.64-17,314.59-11,570.91-9,948.96-1,883.37-7,600.35
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