Willington Village Hall Treasurers Report – 2022-2023
The period of October 2022 through September 2023 was about as normal a year as we can all remember.
Demand for hall bookings dramatically increased over the course of the year and reached record income levels of over £3,000 per month in peak periods. There is over demand in the evenings with the hall at full capacity. There are lost revenue opportunities during Sundays with low bookings and some weekdays (school hours) which we should explore new hirers and/or incentives to achieve higher occupancy during these lower demand periods.
Actual Regular Hire Income for the Year was £29,512 (£31,541 banked due to carry over from prior year) which is an increase of 52% on the £19,313 from the prior year (figures are adjusted for cash received but delayed in banking from the prior year so as to reflect the money earned in the year).
There were no grants or subsidies during the year, but we were fortunate to receive fundraising donations from the sale of Alan Giffords book about the History of Willington for £310. An insurance claim for damage sustained by a bin-lorry was settled at £920.
Expense increases during the year as inflation affected utilities and the cost of goods. Gas expenditure for the year totalled £5,033 compared to £4,531 the prior year, however, there is a credit on account of £1,100 which will reduce the cost for the next few months. More regular accurate meter readings are required to stabilise the bills.
As expected, an increase in electricity bills as we caught up with underpayments as a result of prior inaccurate meter readings. Cost therefore increased to £1,432 compared to £413 the prior year. When you consider that the year prior to that was £1092, the actual use/cost has been stable over the past 3 years. The contract is up for renewal with EON and the recommendation is that we research the market and find a lower cost supplier that has SMART meter reading capability. This will allow us to have accurate monthly invoices.
Hall related expenses increased to £15,659.95 compared to £11,251 the prior year. This is as a result of an increase in labour costs and catching up on unpaid invoices from prior years (such as SDDC waste)
There was significant investment in fixtures/fittings/repair/maintenance over the course of the year totalling £13,643.80 compared to £2,792 the prior year. Roof repairs, foundation investigations, loft/asbestos checks, floor repairs as well as new tables and chairs for use in the new hire rooms.
This resulted in the closing bank balance increasing from £33,934.32 to £37,401.92 to for the year ending September 2023. A surplus of £3,467.60
It is also noted to the Committee that our Charity Account needs to be updated as annual returns have not been submitted for the past few years.
Recommendation would also be to look for an accounting software to allow digital record keeping in future.
John Houghton Treasurer Willington Village Hall – Nov 2023
| WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
WILLINGTON VILLAGE HALL ACCOUNTS PERIOD 2022- 2023 - All expenditure (Including NVH development costs , donations) |
2021/22 - 2022/23 % DIFF. |
2021/22 - 2022/23 % DIFF. |
2021/22 - 2022/23 % DIFF. |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INCOME | October | **November ** | December | January | February | March | April | May | June | July | August | September | Totals | Adjustments | ‘21 - 22’ | £ Diff | % Diff | |
| 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2022/23 | ||||||
| Regular Income - Cash Accounting (when in bank) | £3,765.27 | £3,228.75 | £1,648.50 | £2,249.50 | £2,772.50 | £1,872.75 | £3,237.25 | £1,339.00 | £2,313.75 | £2,507.75 | £1,987.05 | £4,619.28 | £31,541.35 | -£1,728.52 | £17585.25 | £13956.10 | 79.36% | |
| Adjusted Income(adding prioryear unbanked income) | £2,036.75 | £3,228.75 | £1,648.50 | £2,249.50 | £2,772.50 | £1,872.75 | £3,237.25 | £1,339.00 | £2,313.75 | £2,507.75 | £1,987.05 | £4,619.28 | £29,812.83 | £19313.77 | £10499.06 | 54.36% | ||
| Accrued Income - Accrual(earned in that month) | £0.00 | £0.00 | £0.00 | #DIV/0! | ||||||||||||||
| Refundsprovided | -£45.00 | -£45.00 | -£90.00 | -£90.00 | -£90.00 | £0.00 | 0.00% | |||||||||||
| DONATIONS(D)& FUND RAISING EVENTS(FRE) | £ Diff | % Diff | ||||||||||||||||
| Non-Rent Income(Donations and/or Claims) | £310.00 | £920.00 | £1,230.00 | £2,667.00 | -£1,437.00 | (53.88%) | ||||||||||||
| TOTAL INCOME | £3,765.27 | £3,228.75 | £1,648.50 | £2,249.50 | £2,772.50 | £1,872.75 | £3,547.25 | £1,339.00 | £2,313.75 | £3,427.75 | £1,987.05 | £4,619.28 | £32,771.35 | **£21,980.77 ** | £10,790.58 | 49.09% | ||
| EXPENDITURE | October | **November ** | December | January | February | March | April | May | June | July | August | September | Credit Offse | t ‘21 - 22’ |
£ Diff | % Diff | ||
| Mrs N. Phillips(caretaker duties) | £300.00 | £300.00 | -£1100 credit | £3600.00 | (£3300.00) | (91.67%) | ||||||||||||
| refunded byN.Phillips(remove from income) | £0.00 | -£1200.00 | 0.00% | |||||||||||||||
| Mrs E. Nightingale(caretaker duties) | £500.00 | £470.00 | £800.00 | £800.00 | £400.00 | £416.80 | £450.00 | £735.00 | £210.00 | £4,781.80 | £1460.00 | £3321.80 | 227.52% | |||||
| Neil Potter(cleaningduties) | £279.89 | £279.89 | £0.00 | £279.89 | #DIV/0! | |||||||||||||
| Electric(assumption EON Next) | £554.58 | £336.81 | £296.53 | £244.26 | £1,432.18 | £413.72 | £1018.46 | 246.17% | ||||||||||
| Water(Pennon) | £256.14 | £280.67 | £536.81 | £507.58 | £29.23 | 5.76% | ||||||||||||
| Gas(assumption British Gas) | £0.00 | £2,471.00 | (£2471.00) | (100.00%) | ||||||||||||||
| B Davis(reimbursegas bill) | £0.00 | £2060.00 | -£2060.00 | -100% | ||||||||||||||
| Smartest EnergyBusines(Gas Supply) | £173.42 | £318.84 | £539.60 | £901.87 | £891.40 | £715.34 | £617.38 | £432.92 | £235.74 | £115.84 | £111.08 | £0.00 | £5,053.43 | £20.09 |
£5033.34 | 25054% | ||
| SDDC | £15.00 | £15.00 | £15.00 | £15.00 | £10.17 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £110.17 | £143.60 | (£33.43) | (23.28%) | ||||
| Homewaregeneral supply | £0.00 | £112.04 | (£112.04) | (100.00%) | ||||||||||||||
| Hall Insurance - Ansvar Insurance | £96.95 | £96.88 | £96.88 | £96.88 | £96.88 | £96.88 | £96.88 | £96.88 | £96.88 | £96.88 | £968.87 | £914.81 | £54.06 | 5.91% | ||||
| Village Hall Mobile(tesco)/ YourCommsGroup | £10.00 | £159.96 | £25.20 | £25.20 | £25.20 | £25.20 | £27.70 | £27.70 | £27.70 | £27.70 | £27.70 | £27.70 | £436.96 | £120.00 | £316.96 | 264.13% | ||
| SDDC - Trade waste | £201.50 | £201.50 | £0.00 | £201.50 | #DIV/0! | |||||||||||||
| Fire extiguisher service(Chase) | £57.00 | £57.00 | £0.00 | £57.00 | #DIV/0! | |||||||||||||
| PRS | £450.84 | £450.84 | £338.48 | £112.36 | 33% | |||||||||||||
| Graham McCulloch(landscaping) | £150.00 | £150.00 | £300.00 | £290.00 | £10.00 | 3% | ||||||||||||
| Go Daddy- Website(B Davis Reimburse) | £173.00 | £173.00 | £0.00 | £173.00 | #DIV/0! | |||||||||||||
| B Davis 16 Chairs Reimbursement | £853.14 | £853.14 | £0.00 | £853.14 | #DIV/0! | |||||||||||||
| B Davis Table Chairs Reimbursement | £903.18 | £903.18 | £0.00 | £903.18 | #DIV/0! | |||||||||||||
| B Davis(Blinds reimburse) | £213.28 | £213.28 | £0.00 | £213.28 | #DIV/0! | |||||||||||||
| AndyMac(buildingwork) | £700.00 | £2,795.00 | £3,495.00 | £1399.30 | £2095.70 | 150% | ||||||||||||
| Bayliss Consulting- structural surveyJH reimbursements | £965.00 | £965.00 | £0.00 | £965.00 | #DIV/0! | |||||||||||||
| SDDC Trade Waste - JH reimbursements | £195.00 | £195.00 | £0.00 | £195.00 | #DIV/0! | |||||||||||||
| GCB Electrical - repairs - JH reimbursements | £108.00 | £108.00 | £0.00 | £108.00 | #DIV/0! | |||||||||||||
| NEW HALL DEVELOPMENT EXPENDITURE Ph 2 | October | November | December | January | February | March | April | May | June | July | August | September | £21,815.05 | ‘21 - 22’ | £ Diff | % Diff | ||
| AJ FloorCraft | £4,794.00 | £4,794.00 | £4,794.00 | |||||||||||||||
| EXPENSES / CONSUMABLES /REPAIRS | October | November | December | January | February | March | April | May | June | July | August | September | ‘21 - 22’ | £Diff | %Diff | |||
| Window Cleaner | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £75.00 | £75.00 | £0.00 | 0% | |||||||||
| PAT Testing (Lichfield PAT) | £60.00 | £60.00 | £0.00 | £60.00 | #DIV/0! | |||||||||||||
| Ball of Burton(plumbingrepairs) | £174.00 | £220.80 | £394.80 | £0.00 | £394.80 | #DIV/0! | ||||||||||||
| Spondon Felt(roof repair) | £600.00 | £600.00 | £0.00 | £600.00 | #DIV/0! | |||||||||||||
| Glynn Baker(electrical repairs) | £108.00 | £1,124.40 | £1,232.40 | £0.00 | £1232.40 | #DIV/0! | ||||||||||||
| Alex Lowe(plumbingkitchen taprepair) | £85.00 | £85.00 | £0.00 | £85.00 | #DIV/0! | |||||||||||||
| Nicola Phillps Expenses(secreterial supplies) | £68.50 | £68.50 | £0.00 £0.00 |
£68.50 | #DIV/0! | |||||||||||||
| SDDCplanningvariation | £89.00 | £89.00 | £89.00 | #DIV/0! | ||||||||||||||
| £2,604.70 | ||||||||||||||||||
| MONTHLY EXPENDITURE TOTALS | £1,809.14 | £2,031.75 | £1,368.68 | £4,160.36 | £1,073.48 | £7,756.26 | £2,565.13 | £1,135.30 | £1,019.82 | £592.68 | £2,555.45 | £3,235.70 | £29,303.75 | **£12,725.62 ** | £16,578.13 | 130.3% | ||
| J Hht | ||||||||||||||||||
| Unpaid invoices | ougon | |||||||||||||||||
| REVENUE MINUS EXPENDITURE | £3,467.60 | 10.58% | retained Treasurer |
|||||||||||||||
| Prior Year Revenue-Expenditure | £6,155.02 | Oct 2023 |
1
| RECONCILIATION | ||||||
| Oct 1st 2022 Opening Balance | £33,934.32 | |||||
| Sept 30th 2022 Closing Balance on Natwest | £37,401.92 | |||||
| Difference between open and closing balance | £3,467.60 | |||||
| Income Change in Fiscal Year (Q62 cell) | £3,467.60 | |||||
| Discrepancy between Balance and I&E form | £0.00 | |||||
| 03 - 04 = £5590 E i = (£632) (Ri | d | id | d fi l | t) |
03 - 04 = £5590. Excess income = (£632) (Repairs to door, windows and fire alarm system) 04 - 05 = £6841. Excess income = (£638) (New door and building plans) 05 - 06 = Figures to follow. 06 - 07 = £9663. Excess income = £410 (Including purchase of new chairs, boiler, hob, notice board etc...) 07 - 08 = £8457. Excess income = £2773. 08 - 09 = £15,303. Excess income =£7235. This figure includes a credit from EON of £2920. Thus real income minus expenditure = £4315. 09 - 10 = £12,831. Excess income = £3816.96 10 - 11 = £11,489. Excess income = £3812 11 - 12 = £17,521. Excess income = £7789 12 - 13 = £13,462. Excess income = £2375 (New fire doors, Central heating issues and cleaning and fire proofing of main stage curtains) 13 - 14 = £38,570. Excess income = £29,782 (Without donations Income = £13,683 with an EI = £4895) Car park modifications carried out over into 14'-15' accounting period. 14 - 15 = £16,598. Excess income = £6,454 (No major expenditure) 15 - 16 = £16,613. Excess income = £2,468 16 - 17 = £17,995. Excess income = £4876.43 (New chairs purchased - £3678.00) 17 - 18 = £59,986. Excess income = (£35,822) - This includes the 1st stage buidling work. Figures without Exp. £9,986. Excess income = £14,177 (Without donations = £4,177) 18 - 19 = £18,422. Excess income = £5,150 - This includes the !st stage building work final payment of £3,401 - Without any NVH expenses excess income is £7,911 Restated 19-20 - opening balance of £23,499.69 plus income of £11,528.53 and grants of £20,000 (£31,528.53 total revenue) - Less expenses of £9,332.63 and capital expenditure of £28,931 - reconciled balance = £16,764.69 matches closing bank balance of £16,764.59. Trading loss for the year of £6,735.10 Restated 20-21 - opening balance of £16,764.59 plus income of £9,218.85 and grants of £19,869.21 (£19,088.06 total revenue) - Less expenses of £10,348.31 and cap ex of £7,725.04. - reconciled balance of £27,779.30 matches closing bank balance of £27,779.30. Trading surplus of the year = £11,014.71 Restated 21 - 22- opening balance of £27,779.30 plus income of £18,785.25 (£1200 was repayment of wages by Nicky) and grant of £2,667 (£21,452.25 total revenu) Less expenses of £15,297.23 (which includes overpayment to Nicky of £1200 and building work of £1399.30) Reconciled balance of £33,934.32 matches closing balance of £33,934.32. Trading surplus of £6,155.02) Restated 22 - 23 - opening balance of £33,934.32 plus income of £31,541.35 and claims of £1230 (£32,771.35 total revenue) Less expenses of £15,659.95, building repairs of £11,674.2 and asset purchases of £1,969.60 = total costs of £29,303.75 Reconciled balance of £37,401.92 matches closing balance of £37,401.92. Trading surplus of £3,467.60 Need to consider accounting software and resolve charity account issue
2