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
260,704.50 256,265.00 256,115.00 1.73%49,990.0036,325.0010,510.0020,985.0026,780.508,785.0030,500.0042,016.0019,251.003,150.007,502.004,910.00
5
Subscriptions fees: Members 213,777.00 212,895.00 212,895.00 0.41%46,210.0032,395.005,960.0016,815.0023,245.002,085.0026,450.0037,316.0012,661.00900.006,445.003,295.00
6
Booking fees (Lights) 45,727.50 43,220.00 43,220.00 5.80%3,780.003,930.004,400.004,020.003,535.506,700.003,450.004,400.006,590.002,250.001,057.001,615.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,251.98 38.40 - 18785.36%1.410.570.007,000.000.000.000.000.000.000.00150.00100.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
Visitors 250.00 - #DIV/0!150.00100.00
19
Maintenance fee - -
20
- -
21
Interest received - bank 1.98 38.40 -94.84%1.410.57
22
23
MINUS: CASH OUTFLOW
381,199.82 242,345.31 247,157.05 57.30%17,199.1533,384.5461,107.362,699.4044,252.3619,190.294,125.1117,549.2717,879.3535,664.967,495.84120,652.19
24
Salaries & Wages 98,496.00 86,620.00 93,549.60 13.71%8,800.003,432.0017,248.0013,024.0012,936.008,536.009,024.0010,536.003,872.0011,088.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 39,202.94 51,729.00 42,339.18 -24.21%7,370.201,517.131,586.00780.783,000.003,000.006,047.796,000.005,000.001,613.043,288.00
29
Squash balls: league 11,740.00 8,128.00 8,128.00 44.44%3,600.003,300.004,840.00
30
Telkom 5,809.38 5,940.85 5,940.85 -2.21%460.10464.01462.06486.54483.26487.34476.60499.38486.15506.55505.8491.59
31
Computer expenses 3,302.65 3,399.75 3,399.75 -2.86%205.2051.30761.30281.50128.25360.1051.30818.5026.9053.80564.50
32
Honoraria - -  
33
Internet - -
34
Tournaments & Functions 38,320.75 - 10,000.00 #DIV/0!30,000.008,320.75
35
Maintenance & Cleaning (equipment)
16,390.20 41,089.00 20,000.00 -60.11%3,130.005,000.001,910.001,960.00850.003,090.20450.00
36
Bank Charges 5,891.05 5,617.67 5,617.67 4.87%363.65798.10600.00300.00616.85496.85295.60495.40700.70643.60374.20206.10
37
Printing & Stationary - - #DIV/0!
38
DSTV - - #DIV/0!
39
General and Other Expenses 1,907.96 - #DIV/0!850.00300.00600.96157.00
40
Stock written off 99,724.00 - #DIV/0!99,724.00
41
Interest expense 12.89 1.04 0.581.6110.70
42
NSA League fees 32,690.00 32,900.00 32,690.00 -0.64%30,350.002,340.00
43
Transponders 1,500.00 - 1,500.00 #DIV/0!1,500.00
44
Prizes 2,220.00 4,500.00 -50.67%1,300.00920.00
45
46
NET CASH INFLOW/ (OUTFLOW)
-113,243.34 13,958.09 8,957.95 - -911.31%32,792.262,941.03-50,597.3625,285.60-17,471.86-10,405.2926,374.8924,466.731,371.65-32,514.96156.16-115,642.19
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
 
 
Main menu