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