1st Matchborough Scout Group - 2022/23 Cashflow
| April £ |
May £ |
June £ |
July £ |
August £ |
September £ |
October £ |
November £ |
December £ |
January £ |
February £ |
March £ |
Total | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INCOME | |||||||||||||||
| Excess Sectional Income | Unrestricted | £ 40.00 | £ 880.00 | £ 240.00 | £ 480.00 | £ 730.00 | £ 40.00 | £ 980.00 | £ 200.00 | £ 120.00 | £3,710.00 | ||||
| Capitation Fee | £0.00 | ||||||||||||||
| Gift Aid | £3,710.00 | ||||||||||||||
| £0.00 | |||||||||||||||
| HQLettings | £ 2,400.00 | £2,400.00 | |||||||||||||
| Grants | £0.00 | ||||||||||||||
| Fundraising | £ 793.25 | £793.25 | |||||||||||||
| GroupShop | £0.00 | ||||||||||||||
| Amazon Smile | £ 5.14 | £ 5.12 | £ 5.70 | £ 7.83 | £23.79 | ||||||||||
| BrumJam Resolution (General Funds) |
£0.00 | ||||||||||||||
| Other Income | £ 201.61 | £201.61 | |||||||||||||
| £ 2,440.00 | £ 885.14 | £ 240.00 | £ - | £ 5.12 | £ 480.00 | £ 730.00 | £ 5.70 | £ 40.00 | £ 1,982.69 | £ 200.00 | £ 120.00 | £3,418.65 | |||
| Grants | Restricted | £ 500.00 | £ 300.00 | £800.00 | |||||||||||
| Minibus | £ 16,849.20 | £16,849.20 | |||||||||||||
| Redditch District | £0.00 | ||||||||||||||
| Brumjam Resolution (Ringfenced) |
£0.00 | ||||||||||||||
| ShireJam | £ 10.00 | £ 50.00 | £ 45.00 | £ 5.00 | £110.00 | ||||||||||
| Other Events | £ 628.00 | £ 202.80 | £ 6.99 | £ 40.00 | £ 139.00 | £ 32.00 | £1,048.79 | ||||||||
| Other Income | £ 250.00 | £250.00 | |||||||||||||
| £ - | £ - | £ 628.00 | £ 202.80 | £ - | £ 500.00 | £ 10.00 | £ 16,906.19 | £ 45.00 | £ 295.00 | £ 439.00 | £ 32.00 | £19,057.99 | |||
| TOTAL INCOME | £ 2,440.00 | £ 885.14 | £ 868.00 | £ 202.80 | £ 5.12 | £ 980.00 | £ 740.00 | £ 16,911.89 | £ 85.00 | £ 2,277.69 | £ 639.00 | £ 152.00 | £26,186.64 | ||
| EXPENDITURE | |||||||||||||||
| Loan Repayments | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £ 60.00 | £720.00 | ||
| Subsciption Payments | £ 2,397.00 | £ 255.00 | £2,652.00 | ||||||||||||
| Water | £ 48.92 | £ 48.92 | £ 48.92 | £ 48.92 | £ 48.92 | £ 48.92 | £ 41.95 | £ 41.95 | £ 293.95 | £ 32.47 | £ 28.90 | £732.74 | |||
| Electricity | £ 237.40 | £ 181.31 | £ 940.26 | £ 449.64 | £ 228.35 | £2,036.96 | |||||||||
| Hut Internet | £ 21.90 | £ 21.90 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £ 23.62 | £280.00 | ||
| Repairs and Maintenance | £ 119.99 | £ 3,821.02 | £3,941.01 | ||||||||||||
| Equipment | £ 510.00 | £510.00 | |||||||||||||
| Minibus | £ 59.88 | £ 1,634.56 | £ 12,390.70 | £(1,104.09) | £12,981.05 | ||||||||||
| GroupExpenses | £ 1,193.07 | £ 500.00 | £ 101.88 | £ 68.00 | £ 495.00 | £ 192.99 | £2,550.94 | ||||||||
| Redditch District | £0.00 | ||||||||||||||
| GroupShop | £0.00 | ||||||||||||||
| Brumjam Resolution | £0.00 | ||||||||||||||
| Other Expenditure (including sectional expense) |
£ 195.00 | £ 106.64 | £ 341.73 | £ 223.99 | £ 60.00 | £ 59.95 | £ 41.02 | £ 90.00 | £1,118.33 | ||||||
| Unconfirmed cheque | £0.00 | ||||||||||||||
| Returned cheque | £0.00 | ||||||||||||||
| Grant Items(restricted funds) | |||||||||||||||
| TOTAL EXPENDITURE | £ 368.22 | £ 2,722.82 | £ 2,062.24 | £ 655.58 | £ 4,453.56 | £ 458.41 | £ 1,083.88 | £ 568.40 | £ 2,296.15 | £ 13,217.91 | **£(669.65) ** | £ 305.51 | £27,523.03 | ||
| £25,203.48 | |||||||||||||||
| Bank at 01/04/22 | £ 25,203.48 | ||||||||||||||
| Net Cashflow | £ 2,071.78 £ 27,275.26 |
£ (1,837.68) £ (1,194.24) £ 25,437.58 £ 24,243.34 |
£ (452.78) £ 23,790.56 |
£ (4,448.44) £ 19,342.12 |
£ 521.59 £ 19,863.71 |
£ (343.88) £ 19,519.83 |
£ 16,343.49 £ 35,863.32 |
£ (2,211.15) £ 33,652.17 |
£ (10,940.22) £ 22,711.95 |
£ 1,308.65 £ 24,020.60 |
£ (153.51) £ 23,867.09 |
-£1,336.39 £23,867.09 |
|||
| Cumulative Cashflow |
| OPENING BALANCE 01/04/22 | 25203.48 2 donations 4533.79 3710.00 2 3 charitaable actvities 16849.20 4 other trading £4,803.65 £2,400.00 4 793.25 4 800.00 2 16849.20 3 23.79 2 1610.40 4 26186.64 720.00 2652.00 3049.70 3941.01 510.00 2550.94 12981.05 1118.33 27523.03 -1336.39 23867.09 |
|---|---|
| CREDITS | |
| Excess Sectional Income + Subscriptions + Capitation Fee Gift Aid HQ Lettings Fundraising Events |
|
| Grants (Restricted and Unrestricted - exc minibus) | |
| Minibus Grant Brumjam Resolution (General Funds) Brumjam Resolution (Ringfenced Funds) Amazon Smile Other Income TOTAL CREDITS |
|
| 26186.64 | |
| DEBITS Loan Repayments Subscription Payments Utilities (Electric/Water/Internet) Repairs and maintenance Equipment Group expenses Minibus Events & Section Activities Brumjam Resolution Group shop TOTAL DEBITS |
|
| 27523.03 | |
| NET INCOME (CREDITS MINUS DEBITS) | |
| CLOSING BALANCE 31/03/23 | 23867.09 |