Numbers Sheet Name Numbers Table Name 24-25 Summary Table 1 Bank S 23 24 Analysed Table 1
Excel Worksheet Name
24-25 Summary
Bank S 23 24 Analysed
## **Summary of income and exp**
|**Income**|**Bank**||**Cash**||**Deposit**|**Deposit**|
|---|---|---|---|---|---|---|
|Funding and Grant|£|9,806.41|||||
|Fees|£|4,366.26|||||
|Donatons|£|580.41|||||
|Refund|£|1,260.00|||||
|B2B Loan|£|500.00|||||
|Card Cashback|£|0.40|||||
|**TOTAL INCOME**|£|16,513.48|£|-|£|-|
|**Expenditure**||**Bank**||**Cash**|**Deposit**||
|Rent|£|3,100.00|||||
|Telephone|£|84.71|||||
|Training|£|25.00|||||
|Accountancy Fees|£|243.00|||||
|HMRC|£|246.12|||||
|Wages|£|15,692.71|||||
|Other|£|1,964.42|||||
|**TOTAL EXPENDITURE**|£|21,355.96|£|-|£|-|
|**Surplus of Income over Expenditure**|||||||
|**Represented by**||**Bank**||**Cash**|**Deposit**||
|Opening Balance|**£**|**1,176.63**|||||
|Previous Period Adjustment||0|||||
|Adjusted Opening Balance|**£**|**1,176.63**|||||
|Transfer from savings|£|3,207.14|||||
|Movement in Period|£|-4,842.48|||||
|**CLOSING BALANCE**|**£**|**-**|**£**|**-**|**£**|**-**|
3
**Total** £ 9,806.41 £ 4,366.26 £ 580.41 £ 1,260.00 £ 500.00 £ 0.40
- £ 16,513.48
**Total** £ 3,100.00 £ 84.71 £ 25.00 £ 243.00 £ 246.12 £ 15,692.71 £ 1,964.42
- £ 21,355.96
- **£ -4,842.48**
- **Total**
- £ 1,176.63 £ - £ 1,176.63 £ 3,207.14 £ - **£ -1,635.34 £ -458.71**
4
|**DATE**
**DESCRIPTION**|**CHQ NUMBER **|**Payment out**|**Payment in**|**RECEIPT**|**BALANCE**|**Rent**|**Telephone**|**Training**|**Accountancy**
**Fees**|**HMRC**|**Wages**|**OTHER**|**To Deposit**
**account**|**Funding/**
**Grant**|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|**STARTING BALANCE**|1,176.63||||||||||||||
|**02.04.2024**Invoice - Hoadley|||£ 5.00||||||||||||
|**02.04.2024**Invoice - Bella Donna|||£ 5.00||||||||||||
|**02.04.2024**Invoice - James|||£ 5.00||||||||||||
|**02.04.2024**Invoice - Williams|||£ 6.00||||||||||||
|**02.04.2024**Invoice - Hancock|||£ 10.00||||||||||||
|**02.04.2024**Invoice - Hancock|||£ 10.00||||||||||||
|**02.04.2024**Invoice - Banner|||£ 12.00||||||||||||
|**02.04.2024**Invoice - Lewis|||£ 18.00||||||||||||
|**02.04.2024**Invoice - Wood|||£ 112.50||||||||||||
|**02.04.2024**Polson|||£ 2.00||||||||||||
|**04.04.2024**Sky Subscribers (Phone)||£ 5.00|||||£ 5.00||||||||
|**12.04.2024**Aibl Wales Client||£ 30.00||||||||||£ 30.00|||
|**12.04.2024**Wages - Lowe||£ 57.20|||||||||£ 57.20||||
|**12.04.2024**Wages - Purchase||£ 60.00|||||||||£ 60.00||||
|**12.04.2024**Wages - Davies||£ 126.00|||||||||£ 126.00||||
|**12.04.2024**Wages - Thomas||£ 195.00|||||||||£ 195.00||||
|**19.04.2024**Wages - Lowe||£ 57.20|||||||||£ 57.20||||
|**19.04.2024**Wages - Purchase||£ 102.00|||||||||£ 102.00||||
|**19.04.2024**Wages - Davies||£ 113.00|||||||||£ 113.00||||
|**19.04.2024**Wages - Thomas||£ 208.00|||||||||£ 208.00||||
|**19.04.2024**Welsh GOV|||£ 12.50|||||||||||£ 12.50|
|**25.04.2024**Pemb CC|||£ 1,925.00|||||||||||£ 1,925.00|
|**25.04.2024**Welsh GOV|||£ 50.00|||||||||||£ 50.00|
|**29.04.2024**Wages - Thomas||£ 57.30|||||||||£ 57.30||||
|**29.04.2024**Wages - Lowe||£ 85.80|||||||||£ 85.80||||
|**29.04.2024**Wages - Davies||£ 98.00|||||||||£ 98.00||||
|**29.04.2024**Wages - Purchase||£ 156.00|||||||||£ 156.00||||
|**29.04.2024**Wages - Thomas||£ 234.00|||||||||£ 234.00||||
|**02.05.2024**Welsh GOV|||£ 62.50|||||||||||£ 62.50|
|**03.05.2024**HMRC - (Ref: 615PH00123424)||£ 19.20|||||||||£ 19.20||||
|**03.05.2024**Wages - Lowe||£ 85.80|||||||||£ 85.80||||
|**03.05.2024**Wages - Davies||£ 89.00|||||||||£ 89.00||||
|**03.05.2024**Wages - Purchase|||||||||||||||
|**03.05.2024**Wages - Thomas|||||||||||||||
|**03.05.2024**Rent - Jefreyston Playstation (REF 007)||£ 1,320.00||||£ 1,320.00|||||||||
|**03.05.2024**Transfer from Templetots (BARCLAYS)|||£ 500.00||||||||||||
|**07.05.2024**Sky Subscribers (Phone)||£ 8.00|||||£ 8.00||||||||
|**09.05.2024**Welsh GOV|||£ 62.50|||||||||||£ 62.50|
|**10.05.2024**Wages - Lowe||£ 85.80|||||||||£ 85.80||||
|**10.05.2024**Wages - Davies||£ 89.00|||||||||£ 89.00||||
|**10.05.2024**Wages - Purchase||£ 90.00|||||||||£ 90.00||||
|**10.05.2024**Wages - Thomas||£ 162.50|||||||||£ 162.50||||
|**16.05.2024**Welsh GOV|||£62.50|||||||||||£62.50|
|**17.05.2024**Wages - Purchase||£ 60.00|||||||||£ 60.00||||
|**17.05.2024**Wages - Lowe||£ 85.80|||||||||£ 85.80||||
|**17.05.2024**Wages - Davies||£ 113.20|||||||||£ 113.20||||
|**17.05.2024**Wages - Thomas||£ 195.00|||||||||£ 195.00||||
|**17.05.2024**Transfer from Templetots (BARCLAYS)|||£ 500.00||||||||||||
|**28.05.2024**Wages - Lowe||£ 57.20|||||||||£ 57.20||||
|**28.05.2024**Wages - Purchase||£ 90.00|||||||||£ 90.00||||
|**28.05.2024**Wages - Davies||£ 113.00|||||||||£ 113.00||||
|**28.05.2024**Wages - Thomas||£ 195.00|||||||||£ 195.00||||
|**28.05.2024**Invoice - Williams|||£ 112.50||||||||||||
|**28.05.2024**Invoice - Coles|||£ 200.00||||||||||||
|**28.05.2024**Transfer from Templetots (BARCLAYS)|||£ 300.00||||||||||||
|**28.05.2024**Invoice - Turpin|||£ 25.00||||||||||||
|**31.05.2025**Welsh GOV|||£ 62.50|||||||||||£ 62.50|
|**05.06.2025**Sky Subscribers (Phone)||£ 8.00|||||£ 8.00||||||||
|**10.06.2024**Wages - Cole||£ 23.00|||||||||£ 23.00||||
|**10.06.2024**Wages - Lowe||£ 28.60|||||||||£ 28.60||||
|**10.06.2024**Wages - Purchase||£ 90.00|||||||||£ 90.00||||
|**10.06.2024**Wages - Davies||£ 132.10|||||||||£ 132.10||||
|**10.06.2024**Wages - Thomas||£ 162.50|||||||||£ 162.50||||
|**13.06.2024**Welsh GOV|||£ 25.00|||||||||||£ 25.00|
5
|**17.06.2024**Accountant|£ 81.00|||£ 81.00|||
|---|---|---|---|---|---|---|
|**17.06.2024**Wages - Purchase|£ 90.00||||£ 90.00||
|**17.06.2024**Wages - Davies|£ 91.10||||£ 91.10||
|**17.06.2024**Wages - Thomas|£ 162.50||||£ 162.50||
|**17.06.2024**Transfer from Templetots (BARCLAYS)||£ 500.00|||||
|**20.06.2024**Welsh GOV||£ 75.00||||£ 75.00|
|**21.06.2025**Wages - Cole|£ 22.80||||£ 22.80||
|**21.06.2025**Wages - Davies|£ 65.20||||£ 65.20||
|**21.06.2025**Wages - Purchase|£ 90.00||||£ 90.00||
|**21.06.2025**Wages - Thomas|£ 195.00||||£ 195.00||
|**21.06.2025**Transfer from Templetots (BARCLAYS)||£ 200.00|||||
|**27.06.2025**Invoice - Bella Donna||£ 5.00|||||
|**27.06.2025**Invoice - Coles||£ 10.00|||||
|**27.06.2025**Pemb CC||£ 960.00||||£ 960.00|
|**27.06.2025**Welsh GOV||£ 87.50||||£ 87.50|
|**28.06.2025**Invoice - Williams||£ 5.00|||||
|**28.06.2025**Invoice - Banner||£ 15.00|||||
|**01.07.2024**Wages - Davies|£ 113.00||||£ 113.00||
|**01.07.2024**Wages - Purchase|£ 120.00||||£ 120.00||
|**01.07.2024**Wages - Thomas|£ 195.00||||£ 195.00||
|**04.07.2024**Sky Subscribers (Phone)|£ 8.00||£ 8.00||||
|**04.07.2024**Welsh GOV||£ 100.00||||£ 100.00|
|**05.07.2024**Invoice - Bella Donna||£ 75.00|||||
|**08.06.2024**Wages - Purchase|£ 90.00||||£ 90.00||
|**08.06.2024**Wages - Davies|£ 113.00||||£ 113.00||
|**08.06.2024**Wages - Thomas|£ 195.00||||£ 195.00||
|**11.06.2024**Welsh GOV||£ 75.00||||£ 75.00|
|**12.07.2024**Wages - Lowe|£ 28.60||||£ 28.60||
|**12.07.2024**Wages - Davies|£ 115.10||||£ 115.10||
|**12.07.2024**Wages - Purchase|£ 120.00||||£ 120.00||
|**12.07.2024**Wages - Thomas|£ 162.50||||£ 162.50||
|**18.07.2024**Pemb CC||£ 1,430.00||||£ 1,430.00|
|**18.07.2024**Welsh GOV||£ 112.50||||£ 112.50|
|**19.07.2024**Wages - Lowe|£ 37.97||||£ 37.97||
|**19.07.2024**Wages - Lowe|£ 37.97||||£ 37.97||
|**19.07.2024**Wages - Lowe|£ 57.20||||£ 57.20||
|**19.07.2024**Wages - Purchase|£ 82.54||||£ 82.54||
|**19.07.2024**Wages - Purchase|£ 82.54||||£ 82.54||
|**19.07.2024**Wages - Davies|£ 89.20||||£ 89.20||
|**19.07.2024**Wages - Davies|£ 89.24||||£ 89.24||
|**19.07.2024**Wages - Davies|£ 89.24||||£ 89.24||
|**19.07.2024**Wages - Purchase|£ 90.00||||£ 90.00||
|**19.07.2024**Wages - Thomas|£ 160.05||||£ 160.05||
|**19.07.2024**Wages - Thomas|£ 160.06||||£ 160.06||
|**19.07.2024**Wages - Thomas|£ 195.00||||£ 195.00||
|**19.07.2024**Invoice - Williams||£ 162.50|||||
|**22.07.2024**Invoice - Turpin||£ 162.50|||||
|**23.07.2024**Square||£ 5.89|||||
|**24.07.2024**Invoice - Hemsley||£ 237.50|||||
|**24.07.2024**Invoice - Coles||£ 237.50|||||
|**26.07.2024**Invoice - Coles||£ 10.00|||||
|**29.07.2024**Invoice - Williams||£ 5.00|||||
|**29.07.2024**Square||£ 36.47|||||
|**01.08.2024**Pemb CC||£ 416.00||||£ 416.00|
|**06.08.2024**Sky Subscribers (Phone)|£ 8.00||£ 8.00||||
|**27.08.2024**Square||£ 160.46|||||
|**04.09.2024**Sky Subscribers (Phone)|£ 8.00||£ 8.00||||
|**09.09.2024**Wages - Lowe|£ 57.20||||£ 57.20||
|**09.09.2024**Wages - Purchase|£ 126.00||||£ 126.00||
|**09.09.2024**Wages - Davies|£ 137.30||||£ 137.30||
|**09.09.2024**Wages - Thomas|£ 201.50||||£ 201.50||
|**13.09.2024**Wages - Lowe|£ 85.80||||£ 85.80||
|**13.09.2024**Wages - Davies|£ 120.00||||£ 120.00||
|**13.09.2024**Wages - Thomas|£ 195.00||||£ 195.00||
|**20.09.2024**Wages - Davies|£ 92.50||||£ 92.50||
|**20.09.2024**Wages - Purchase|£ 156.00||||£ 156.00||
|**20.09.2024**Wages - Thomas|£ 169.00||||£ 169.00||
6
|**23.09.2024**Bill payment|£ 50.00|||||||£ 50.00||
|---|---|---|---|---|---|---|---|---|---|
|**23.09.2024**Accountant|£ 81.00|||||£ 81.00||||
|**23.09.2024**Welsh GOV||£75.00|||||||£75.00|
|**25.09.2024**HMRC|£ 200.00||||||£ 200.00|||
|**01.10.2024**Ansvar Insurance|£ 68.41||||||£ 68.41|||
|**08.10.2024**Credit National Savings||£ 283.50|||||||£ 283.50|
|**21.10.2024**Transfer to Wise ACC (1608.06)|£ 1,608.06|||||||£ 1,608.06||
|**21.10.2024**Transfer from Templetots (BARCLAYS)||£ 1,030.83||||||||
|**22.10.2024**Credit National Savings||£ 54.00|||||||£ 54.00|
|**29.10.2024**Ansvar Insurance||£ 68.41|||||||£ 68.41|
|**15.11.2021**Credit National Savings||£ 283.50|||||||£ 283.50|
|**29.11.2024**Ansvar Insurance|£ 68.41||||||£ 68.41|||
|**29.11.2024**ICO|£ 35.00||||||£ 35.00|||
|**03.12.2024**Transfer to Wise Invoice - Billy|£ 397.26||||||£ 397.26|||
|**03.12.2024**Invoice - Coles||£ 81.00||||||||
|**03.12.2024**Invoice - Coles||£ 148.50||||||||
|**03.12.2024**Transfer from Templetots (BARCLAYS)||£ 2.08||||||||
|**31.12.2024**Ansvar Insurance|£ 68.41||||||£ 68.41|||
|**24.01.2024**Invoice - Wood||£ 13.50||||||||
|**18.09.2024**Topped up balance||£ 45.00||||||||
|**18.09.2024**Opening account fee|£ 45.00|||||||£ 45.00||
|**20.09.2024**Transfer from Templetots (BARCLAYS)||£ 50.00||||||||
|**21.09.2024**Invoice - Walker||£ 418.50||||||||
|**24.09.2024**Invoice - Turpin||£ 297.00||||||||
|**25.09.2024**Invoice - Ahern||£ 418.50||||||||
|**27.09.2024**Wages - Davies|£ 132.00||||||£ 132.00|||
|**27.09.2024**Wages - Purchase|£ 129.00||||||£ 129.00|||
|**27.09.2024**Wages - Thomas|£ 195.00||||||£ 195.00|||
|**30.09.2024**Funding - PCC||£ 2,062.50|||||||£ 2,062.50|
|**03.10.2024**Invoice - Myers||£ 94.50||||||||
|**04.10.2024**Sky Subscribers (Phone)|£ 8.00|||£ 8.00||||||
|**04.10.2024**Wages - Thomas|£ 188.50||||||£ 188.50|||
|**04.10.2024**Wages - Davies|£ 62.50||||||£ 62.50|||
|**04.10.2024**Wages - Purchase|£ 60.00||||||£ 60.00|||
|**04.10.2024**Wages - Lowe|£ 114.40||||||£ 114.40|||
|**08.10.2024**Bill - PCC|£ 25.00||||£ 25.00|||||
|**10.10.2024**Funding - PCC||£ 325.00|||||||£ 325.00|
|**11.10.2024**Wages - Thomas|£ 195.00||||||£ 195.00|||
|**11.10.2024**Wages - Purchase|£ 120.00||||||£ 120.00|||
|**11.10.2024**Wages - Lowe|£ 114.40||||||£ 114.40|||
|**18.10.2024**Wages - Thomas|£ 195.00||||||£ 195.00|||
|**18.10.2024**Wages - Davies|£ 32.50||||||£ 32.50|||
|**18.10.2024**Wages - Purchase|£ 144.00||||||£ 144.00|||
|**18.10.2024**Wages - Lowe|£ 114.40||||||£ 114.40|||
|**20.10.2024**Transfer from Templetots (BARCLAYS)||£ 1,608.06||||||||
|**25.10.2024**Wages - Thomas|£ 130.00||||||£ 130.00|||
|**25.10.2024**Wages - Davies|£ 65.00||||||£ 65.00|||
|**25.10.2024**Wages - Purchase|£ 120.00||||||£ 120.00|||
|**25.10.2024**Wages - Lowe|£ 114.40||||||£ 114.40|||
|**31.10.2024**Funding - PCC||£ 550.00|||||||£ 550.00|
|**01.11.2024**Rent - Jefreyston Playstation (REF 009)|£ 760.00||£ 760.00|||||||
|**01.11.2024**Rent - Jefreyston Playstation (REF 008)|£ 1,020.00||£ 1,020.00|||||||
|**06.11.2024**Sky Subscribers (Phone)|£ 8.00|||£ 8.00||||||
|**07.11.2024**Invoice - Walker||£ 378.00||||||||
|**08.11.2024**Invoice - Myers||£ 13.50||||||||
|**08.11.2024**Wages - Thomas|£ 195.00||||||£ 195.00|||
|**08.11.2024**Wages - Purchase|£ 135.00||||||£ 135.00|||
|**08.11.2024**Wages - Lowe|£ 128.70||||||£ 128.70|||
|**12.11.2024**Invoice - Ahern||£364.50||||||||
|**14.11.2024**Invoice - Silethemba||£297.00||||||||
|**15.11.2024**Wages - Lowe|£ 114.40||||||£ 114.40|||
|**15.11.2024**Wages - Purchase|£ 120.00||||||£ 120.00|||
|**15.11.2024**Wages - Davies|£ 72.04||||||£ 72.04|||
|**15.11.2024**Wages - Thomas|£ 162.50||||||£ 162.50|||
|**22.11.2024**Wages - Lowe|£ 114.40||||||£ 114.40|||
|**22.11.2024**Wages - Purchase|£ 150.00||||||£ 150.00|||
|**22.11.2024**Wages - Thomas|£ 201.50||||||£ 201.50|||
7
|**27.11.2024**Bill - HMRC|£ 200.00||||£ 200.00||||
|---|---|---|---|---|---|---|---|---|
|**29.11.2024**Wages - Lowe|£ 120.12|||||£ 120.12|||
|**29.11.2024**Wages - Purchase|£ 125.00|||||£ 125.00|||
|**29.11.2024**Wages - Thomas|£ 130.00|||||£ 130.00|||
|**02.12.2024**Invoice - Turpin||£ 283.50|||||||
|**02.12.2024**Donation - SQUARE||£ 6.88|||||||
|**03.12.2024**Invoice - Coles||£ 397.26|||||||
|**04.12.2024**Sky Subscribers (Phone)|£ 8.00||£ 8.00||||||
|**05.12.2024**Funding - PCC (REF: A003785)||£ 156.00||||||£ 156.00|
|**06.12.2024**Wages - Thomas|£ 97.50|||||£ 97.50|||
|**06.12.2024**Wages - Purchase|£ 122.50|||||£ 122.50|||
|**06.12.2024**Wages - Lowe|£ 114.40|||||£ 114.40|||
|**13.12.2024**Wages - Thomas|£ 104.00|||||£ 104.00|||
|**13.12.2024**Wages - Purchase|£ 92.50|||||£ 92.50|||
|**13.12.2024**Wages - Lowe|£ 114.40|||||£ 114.40|||
|**14.11.2024**Bill - Accountant|£ 81.00|||£ 81.00|||||
|**20.12.2024**Invoice - Silethemba||£ 13.50|||||||
|**20.12.2024**Invoice - Williams||£ 10.00|||||||
|**20.12.2024**Wages - Lowe|£ 228.80|||||£ 228.80|||
|**20.12.2024**Wages - Purchase|£ 244.76|||||£ 244.76|||
|**20.12.2024**Wages - Thomas|£ 415.41|||||£ 415.41|||
|**21.12.2024**Donation - SQUARE||£ 15.21|||||||
|**03.01.2025**Card Cashback||£ 0.40|||||||
|**06.01.2025**Sky Subscribers (Phone)|£ 8.00||£ 8.00||||||
|**07.01.2025**B2B Loan (Luke Walker)||£ 500.00|||||||
|**09.01.2025**Funding - PCC (REF: A003785)||£ 130.00||||||£ 130.00|
|**10.01.2025**Wages - Purchase|£ 162.00|||||£ 162.00|||
|**10.01.2025**Wages - Lowe|£ 131.56|||||£ 131.56|||
|**10.01.2025**Wages - Cannaby|£ 120.00|||||£ 120.00|||
|**17.01.2025**Wages - Purchase|£ 196.28|||||£ 196.28|||
|**17.01.2025**Wages - Lowe|£ 98.70|||||£ 98.70|||
|**20.01.2025**Rent - Refund - Jefreyston Playstation||£ 1,260.00|||||||
|**21.01.2025**Wages - Cannaby|£ 182.64|||||£ 182.64|||
|**21.01.2025**HMRC - (Ref: 615PH00123424)|£ 46.12||||£ 46.12||||
|**30.01.2025**Pemb CC||£ 300.00||||||£ 300.00|
|**02.02.2025**Repayment - Walker|£ 150.15||||||£ 150.15||
|**04.02.2025**Wages - Purchase|£ 225.17|||||£ 225.17|||
|**04.02.2025**Wages - Lowe|£ 213.53|||||£ 213.53|||
|**02.02.2025**Transfer from Templetots (BARCLAYS)||£ 124.23|||||£ 19.25||
|**11.02.2025**Milk|£ 19.25||||||£ 61.96||
|**20.03.2025**Peter Moorhouse bill|£ 61.96||£ 7.71||||||
|**21.03.2025**Sky Subscribers (Phone)|£ 7.71||||||||
END BALANCE: **£ -**
**£ - £ 21,355.96 £ 21,328.68 £ - £ 3,100.00 £ 84.71 £ 25.00 £ 243.00 £ 246.12 £ 15,692.71 £ 1,964.42 £ - £ 9,806.41** TOTAL NET: **£ -27.28 TOTAL OUT: £ 21,355.96**
**Totals**
8
**From Fees FundraisingDonations/ Refund Loan CashbackCard AccountDeposit** £ 5.00 £ 5.00 £ 5.00 £ 6.00 £ 10.00 £ 10.00 £ 12.00 £ 18.00 £ 112.50 £ 2.00
£ 500.00
£ 500.00
£ 112.50 £ 200.00
£ 300.00
£ 25.00
9
£ 500.00
£ 200.00 £ 5.00 £ 10.00 £ 5.00 £ 15.00
£ 75.00
£ 162.50 £ 162.50 £ 5.89 £ 237.50 £ 237.50 £ 10.00 £ 5.00 £ 36.47 £ 160.46
10
£ 1,030.83
£ 81.00 £ 148.50 £ 2.08 £ 13.50 £ 45.00 £ 50.00 £ 418.50 £ 297.00 £ 418.50
£ 94.50
£ 378.00 £ 13.50 £364.50 £297.00
11
£ 283.50 £ 6.88 £ 397.26
£ 13.50 £ 10.00 £ 15.21 £ 0.40 £ 500.00
£ 1,260.00
£ 124.23
**£ 4,366.26 £ 580.41 £ 1,260.00 £ 500.00 £ 0.40 £ 3,207.14 £ 19,720.62**
12