**Cramlington Community Tennis Programme** ## **Accounts summary for the period 20 April 22 - 19th April 2023** |Cash book opening balance|£ 558.99| |---|---| |Income|£ 30,187.75| |Expenditure|£ 27,114.43| |Cash book & bank balance @ 19.04.2023|£ 3,632.31| ## **INCOME BREAKDOWN BY CATEGORY** |Coaching Fees
Membership Fees
Key Purchases
School Coaching
Donations
Fund Raising
Misc||£ 19,820.50
£ 1,297.25
£ 205.00
£ 225.00
£ -
£ 240.00
£ 8,400.00| |---|---|---| |||**£ 30,187.75**| ## **EXPENDITURE BREAKDOWN BY CATEGORY** |Coach/asst.coaches' wages
Court hire
Equipment
Misc||£ 16,008.51
£ 1,871.00
£ 227.50
£ 9,007.42| |---|---|---| |||**£ 27,114.43**| S Rowe Treasurer S J Grey Honorary Chair ## **MMUNITY TENNIS PROGRAMME** ## **0 APRIL 2022 - 19 APRIL 2023** |Date|Supp Ref|Name|Total|Coach/Asst
Coach wages|Court
Hire|Equipment|Misc| |---|---|---|---|---|---|---|---| |29.4.22
7.5.22
27.5.22
28.5.22
27.5.22
6.6.22
8.6.22
7.7.22
12.7.22
25.7.22
6.8.22
15.8.22
25.8.22
5.9.22
6.9.22
1.10.22
7.10.22
25.10.22
3.11.22
4.11.22
5.11.22
6.11.22
18.11.22
22.11.22|CCTP01/CLS1 202
Mail Box Fee
HSBC
CCTP01/CLS1 233
Stationery
Invoice
Dunlop Balls
Inv Apr/May
HSBC
Inv Apr/May
Inv Apr/May
CCTP01/CLS1 271
Inv Apr
HSBC
CCTP01/CLS1 316
Inv Jun/Jul
Inv Jun/Jul
Inv Jun/Jul
Inv
Inv Jun/Jul
HSBC
Ink
CCTP01/CLS1 347
Facebook Boost
Inv Jul/Aug
Inv
Inv Jul/Aug
HSBC
CCTP Team Entry
HSBC
Inv Sept
Inv Sept/Oct
Inv Sept/Oct
Inv Sept/Oct
Facebook Boost
LTA Registration & box
Court Repainting
Court Repainting
Court Repainting
Court Repainting
Heart Internet Renewal
HSBC
CCTP Team Entry (chq)|Cramlington LV Court Hire
Jane Grey
**Total expenditure Apr 22**
Account bank charges
Cramlington LV Court Hire
Jane Grey
Phil Barron
Judith Musgrave
Dan Grey
**Total expenditure May 22**
Account bank charges
Beth Rogan
Jack Lackenby
Cramlington LV Court Hire
Evie Mattison
**Total expenditure Jun 22**
Account bank charges
Cramlington LV Court Hire
Dan Grey
Jack Lackenby
Beth Rogan
Phil Barron
Evie Mattison
**Total expenditure Jul 22**
Account bank charges
Jane Grey
Cramlington LV Court Hire
Dan Grey
**Total expenditure Aug 22**
Beth Rogan
Phil Barron
Jack Lackenby
Account bank charges
**Total expenditure Sep 22**
Durham & Cleveland Leagues
Account bank charges
Dan Grey
Beth Rogan
Jack Lackenby
Evie Mattison
Dan Grey
Jane Grey
**Total expenditure Oct 22**
Dualway Courts
Dualway Courts
Dualway Courts
Dualway Courts
Jane Grey
Account bank charges
N'land & Durham League Fees
Schoolhire
Schoolhire
**Total expenditure Nov 22**|151.00
10.79
**161.79**
5.00
64.00
4.28
1337.00
30.00
73.00
**1513.28**
7.50
726.00
642.00
128.00
112.00
**1615.50**
5.00
128.00
120.00
840.00
870.00
1104.00
208.25
**3275.25**
5.00
35.98
96.00
60.00
**196.98**
504.00
56.26
1206.00
6.40
**1772.66**
45.00
5.00
24.00
366.00
402.00
187.25
30.00
699.48
**1758.73**
2500.00
2500.00
2500.00
60.00
11.99
5.00
20.00
824.00
96.00
**8516.99**|**0.00**
1337.00
73.00
**1410.00**
726.00
642.00
112.00
**1480.00**
120.00
840.00
870.00
1104.00
208.25
**3142.25**
**0.00**
504.00
56.26
1206.00
**1766.26**
24.00
366.00
402.00
187.25
**979.25**
**0.00**|151.00
**151.00**
64.00
**64.00**
128.00
**128.00**
128.00
**128.00**
96.00
**96.00**
**0.00**
**0.00**
824.00
96.00
**920.00**|**0.00**
30.00
**30.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**|10.79
**10.79**
5.00
4.28
**9.28**
7.50
**7.50**
5.00
**5.00**
5.00
35.98
60.00
**100.98**
6.40
**6.40**
45.00
5.00
30.00
699.48
**779.48**
2500.00
2500.00
2500.00
60.00
11.99
5.00
20.00
**7596.99**| |Date|Supp Ref|Name|Total|Coach/Asst
Coach wages|Court
Hire|Equipment|Misc| |---|---|---|---|---|---|---|---| |7.12.22
19.12.22
20.12.21
30.12.22
3.1.23
6.1.22
10.1.22
14.1.22
17.1.22
20.1.22
30.1.22
6.2.23
19.2.23
24.2.23
28.2.23
3.3.23
9.3.23
22.3.23
26.3.23
27.3.23
31.3.23
4.4.23
6.4.23
13.4.23
14.4.23|HSBC
Inv
Inv Nov
Inv Nov/Dec
Inv Nov/Dec
HSBC
CCTP team entry
Trophies
M'soft Ofce Licence
Amazon gift voucher
HSBC
Inv Jan/Feb
Inv
Inv Jan/Feb
Inv Jan/Feb
CCTP team entry
HSBC
Equipment purchase
Printer Ink
Microsoft 365
Tennis balls
Inv
Inv Feb/Mar
Inv Feb/Mar
HSBC
Inv Feb/Mar|Account bank charges
Phil Barron
Evie Mattison
Beth Rogan
Schoolhire
**Total expenditure Dec 22**
Jack Lackenby
Account bank charges
Durham & Cleveland Leagues
Jane Grey
Jane Grey
Shona Rowe
Schoolhire
**Total expenditure Jan 23**
Account bank charges
Evie Mattison
Phil Barron
Beth Rogan
Jack Lackenby
Schoolhire
**Total expenditure Feb 23**
N/land & Durham League fees
Account bank charges
Phil Barron
Jane Grey
Jane Grey
Judith Musgrave
Phil Barron
**Total expenditure Mar 23**
Evie Mattison
Beth Rogan
Account bank charges
Jack Lackenby
Schoolhire
**Total expenditure Apr 23**|6.23
1523.00
161.00
594.00
128.00
**2412.23**
402.00
5.40
45.00
73.90
59.99
40.00
96.00
**722.29**
5.00
162.75
1194.00
552.00
306.00
128.00
**2347.75**
12.00
5.00
120.00
45.49
59.99
77.50
1385.00
**1704.98**
147.00
504.00
5.00
300.00
160.00
**1116.00**|1523.00
161.00
594.00
**2278.00**
402.00
**402.00**
162.75
1194.00
552.00
306.00
**2214.75**
1385.00
**1385.00**
147.00
504.00
300.00
**951.00**|**0.00**
96.00
**96.00**
128.00
**128.00**
**0.00**
160.00
**160.00**|**0.00**
**0.00**
**0.00**
120.00
77.50
**197.50**
**0.00**|6.23
128.00
**134.23**
5.40
45.00
73.90
59.99
40.00
**224.29**
5.00
**5.00**
12.00
5.00
45.49
59.99
**122.48**
5.00
**5.00**| |||**GRAND TOTAL - EXPENDITURE**|**27114.43**|**16008.51**|**1871.00**|**227.50**|**9007.42**| ## **CRAMLNGTON COMMUNITY TENNIS PROGRAMME** ## **EXPENDITURE 20 APRIL 2022 - 19 APRIL 2023 - MONTHLY TOTALS** |||Total|Coach/Asst|Court|Equipment|Misc| |---|---|---|---|---|---|---| ||||Coach wages|Hire||| |Total expenditure|Apr-22|161.79|0.00|151.00|0.00|10.79| |Total expenditure|May-22|1,513.28|1,410.00|64.00|30.00|9.28| |Total expenditure|Jun-22|1,615.50|1,480.00|128.00|0.00|7.50| |Total expenditure|Jul-22|3,275.25|3,142.25|128.00|0.00|5.00| |Total expenditure|Aug-22|196.98|0.00|96.00|0.00|100.98| |Total expenditure|Sep-22|1,772.66|1,766.26|0.00|0.00|6.40| |Total expenditure|Oct-22|1,758.73|979.25|0.00|0.00|779.48| |Total expenditure|Nov-22|8,516.99|0.00|920.00|0.00|7,596.99| |Total expenditure|Dec-22|2,412.23|2,278.00|0.00|0.00|134.23| |Total expenditure|Jan-23|722.29|402.00|96.00|0.00|224.29| |Total expenditure|Feb-23|2,347.75|2,214.75|128.00|0.00|5.00| |Total expenditure|Mar-23|1,704.98|1,385.00|0.00|197.50|122.48| |Total expenditure|Apr-23|1,116.00|951.00|160.00|0.00|5.00| **Total expenditure 2022/2023** **### 16,008.51 1,871.00 227.50 9,007.42** Page 1 **CRAMLINGTON COMMUNITY TENNIS PROGRAMME** ## **INCOME 20 APRIL 2022 - 19 APRIL 2023** |Detail|Total
Amount|Coachg
Fees|M'ship
Fees|Key
Purchases|School
Coaching|Donations|Fund
Raising|Misc| |---|---|---|---|---|---|---|---|---| |Memberships
Course fees (bank transfer)
Course fees (cash/cheques)
**Total Banking April**
Course fees (bank transfer)
Memberships
Key purchases
**Total Banking May**
Course fees (bank transfer)
Memberships
Key purchases
**Total Banking June**
Course fees (bank transfer)
Course fees (cash/cheques)
Key purchases
**Total Banking July**
Course fees (bank transfer)
School coaching
**Total Banking August**
Course fees (Internet banking)
Grant from Cram Town Council
Key purchases
Refund from J Lackerby (overpayment)
**Total Banking September**
Course fees (Internet banking)
**Total Banking October**
Course fees (Internet banking)
Course fees (cash/cheques)
Transfer from savings a/c for court painting|441.25
785.50
524.00
**1750.75**
1099.50
195.00
30.00
**1324.50**
2419.25
101.00
60.00
**2580.25**
1147.75
249.00
85.00
**1481.75**
1007.00
225.00
**1232.00**
2232.50
240.00
30.00
840.00
**3342.50**
1490.75
**1490.75**
1925.75
207.50
7560.00|785.50
524.00
**1309.50**
1099.50
**1099.50**
2419.25
**2419.25**
1147.75
249.00
**1396.75**
1007.00
**1007.00**
2,232.50
**2232.50**
1,490.75
**1490.75**
1925.75
207.50|441.25
**441.25**
195.00
**195.00**
101.00
**101.00**
**0.00**
**0.00**
**0.00**
**0.00**|**0.00**
30.00
**30.00**
60.00
**60.00**
85.00
**85.00**
**0.00**
30.00
**30.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
225.00
**225.00**
**0.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
240.00
**240.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
840.00
**840.00**
**0.00**
7560.00| Page 2 **CRAMLINGTON COMMUNITY TENNIS PROGRAMME** ## **INCOME 20 APRIL 2022 - 19 APRIL 2023** |Detail|Total
Amount|Coachg
Fees|M'ship
Fees|Key
Purchases|School
Coaching|Donations|Fund
Raising|Misc| |---|---|---|---|---|---|---|---|---| |**Total Banking November**
Course fees(internet banking)
**Total Banking December**
Course fees (Internet banking)
**Total Banking January**
Course fees (Internet banking)
**Total Banking February**
Course fees (Internet banking)
**Total Banking March**
Course fees (Internet banking)
Memberships
**Total Banking April**|**9693.25**
868.50
**868.50**
1680.00
**1680.00**
1480.50
**1480.50**
1386.50
**1386.50**
1316.50
560.00
**1876.50**|**2133.25**
868.50
**868.50**
1680.00
**1680.00**
1480.50
**1480.50**
1386.50
**1386.50**
1316.50
**1316.50**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
560.00
**560.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**|**0.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**|**7560.00**
**0.00**
**0.00**
**0.00**
**0.00**
**0.00**| |**GRAND TOTALS**|**30187.75 **|**19820.50**|**1297.25**|**205.00**|**225.00**|**0.00**|**240.00**|**8400.00**| ## **CRAMLINGTON COMMUNITY TENNIS PROGRAMME** ## **INCOME 20 APRIL 22 - APRIL 23 MONTHLY TOTAL** ||||Coaching|M'ship|Key|School||Fund|| |---|---|---|---|---|---|---|---|---|---| |||Amount|Fees|Fees|Purchases|Coaching|Donations|Raising|Misc| |Total Income|Apr-22|1750.75|1309.50|441.25|0.00|0.00|0.00|0.00|0.00| |Total Income|May-22|1324.50|1099.50|195.00|30.00|0.00|0.00|0.00|0.00| |Total Income|Jun-22|2580.25|2419.25|101.00|60.00|0.00|0.00|0.00|0.00| |Total Income|Jul-22|1481.75|1396.75|0.00|85.00|0.00|0.00|0.00|0.00| |Total Income|Aug-22|1232.00|1007.00|0.00|0.00|225.00|0.00|0.00|0.00| |Total Income|Sep-22|3342.50|2232.50|0.00|30.00|0.00|0.00|240.00|840.00| |Total Income|Oct-22|1490.75|1490.75|0.00|0.00|0.00|0.00|0.00|0.00| |Total Income|Nov-22|9693.25|2133.25|0.00|0.00|0.00|0.00|0.00|7560.00| |Total Income|Dec-22|868.50|868.50|0.00|0.00|0.00|0.00|0.00|0.00| |Total Income|Jan-23|1680.00|1680.00|0.00|0.00|0.00|0.00|0.00|0.00| |Total Income|Feb-23|1480.50|1480.50|0.00|0.00|0.00|0.00|0.00|0.00| |Total Income|Mar-23|1386.50|1386.50|0.00|0.00|0.00|0.00|0.00|0.00| |Total Income|Apr-23|1876.50|1316.50|560.00|0.00|0.00|0.00|0.00|0.00| **30187.75 19820.50 1297.25 205.00 225.00 0.00 240.00 8400.00** **Total Income 2022/2023**