Old School **Bank reconciliation to 31 March 2023** Bank balances Cashbook Community account £ 22,419.79 Opening balance 1 April 2022 £ 28,927.32 Cash £ 555.00 Less o/s cheques £ - Skipton Building Society £ - _Add:_ **Total £ 22,974.79** Receipts: less o/s cheques April-Feb £ 4,040.00 Mar £ 2,654.50 £ 6,694.50 Payments: £ - April-Feb £ 10,480.85 plus o/s deposits March £ 2,166.18 £ 12,647.03 Total cheques £ - £ - -£ 12,647.03 Net balances as at 31 March 2023 £ 22,974.79 Closing balance per cash book at 31 March 2023 £ 22,974.79 1 / 1 **----- Start of picture text -----**
Receipts and payments at end of March 2023
Year 2022/23 Totals by month
Receipts/pay Receipts/paym
Receipts 20/21 ments 21/22 ents 22/23 Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Receipts Incomplete figures for 20/21
Category Sub-Category
Hall hire York City FC 800.00 £ 1,020.00 - - - - 220 - 220 200 - - 380 -
Sue Clayton Art 890.00 £ 1,540.00 - - 180 250 - - - 100 - - - 1,010
HWYCA 1,110.00 £ 800.00 - - 180 - - - - - - - - 620
York Society of Spiritualists 1,075.00 £ 1,210.00 - - 350 200 - 275 - - - 175 - 210
Wing Chun Class 555.00 £ 600.00 30 - 45 60 105 - 60 75 60 45 60 60
WPC and CYC 210.00 £ 40.00 - - 40 - - - - - - - - -
Other 7,310.00 £ 744.50 40 - 200 - - - - 50 - - - 455
Total bank 11,950.00 £ 5,954.50
Cash Persian Rugs and beds weekend bookings 590.00 £ 50.00 - 50 - - - - - - - - - -
Simon Peters £ 300.00 25 125 50 - - 100 - - - - - -
U3A Dance 370 £ 90.00 15 45.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
UNALLOCATED CASH £ 300.00 300.00
Total cash 960.00 £ 740.00 - - - - - - - 300
Hall Hire: 1,410.00 12,910.00 £ 6,694.50 £ 110 £ 220 £ 1,075 £ 510 £ 325 £ 375 £ 280 £ 425 £ 60 £ 220 £ 440 £ 2,955
Other Grants CYC and WPC 20,381.00 10,334.00
Energy refund 1,065.65
Water refund 666.11 53.94
Interest Skipton BS 26.62 8.58
Donations 60
Other income: 22,139.38 10,456.52 £ -
Income Totals: 23,549.38 23,366.52 £ 6,694.50 £ 110 £ 220 £ 1,075 £ 510 £ 325 £ 375 £ 280 £ 425 £ 60 £ 220 £ 440 £ 2,955
Payments
Category Sub-Category
Administration Audit fees 30.00 £ - - - - - - - - - - - - -
Insurance £ 657.04 - - - - - - 657 - - - - -
Sage accounts £ 129.60 - - - 14 14 14 14 14 14 14 14 14
Legal fees (CIO work) 1,512.00
Bank charges 22.73 £ 67.07 8 6 5 5 5 5 6 5 6 5 5 5
MS 365, website, PC and printer 57.83 £ 576.70 267 - - 75 - - - - - - 163 72
Stationery, postage 9.54 £ - - - - - - - - - - - - -
Fire alarm system 872.09 £ -
Music License 132.00 £ 672.24 - 336 336
Lease 1.00 £ 1.00 - - - - - - - - - - - 1
Administration: £ 2,637 £ 2,103.65 275.11 5.80 5.00 94.40 355.92 19.40 677.58 19.80 20.60 19.40 518.24 92.40
Staff Administration 3,000.00 3,000.00 £ 3,000.00 250 250 250 250 250 250 250 250 250 250 250 250
Other £ - - - - - - - - - - - - -
Staff: £ 3,000 £ 3,000 £ 3,000.00 250 250 250 250 250 250 250 250 250 250 250 250
Administration: £ 5,637 £ 5,103.65 £ 525 £ 256 £ 255 £ 344 £ 606 £ 269 £ 928 £ 270 £ 271 £ 269 £ 768 £ 342
Hall Minster Cleaning 2,487.29 2,385.93 £ 2,767.90 228 228 228 228 - 228 - 633 - 536 228 228
Window Cleaning 250.00 £ 290.00 25 25 25 25 - 25 - 75 - 30 30 30
PHS and PPS group 120.22 £ 153.30 37 90 26
Electrical usage 402.31 416.88 £ 855.35 215 - - - 226 - - - - 38 - 452 -
Gas 1,715.04 812.01 £ 501.20 116 - - - - 116 - - 87 - - 183
Water 1,124.63 185.65 £ 220.90 - - 57 - - 63 - - - 39 - 62
CYC-NDR 0.00 52.92 £ 205.95 52 52 - - - - - - - - 102 -
Fire safety and boiler check 121.50 £ 124.38 64 - - - - - - - - - 60
Other 3,068.94 15,912.33 £ 2,424.40 210 40 50 30 - - - 122 80 39 533 1,320
Hall maintenance 8,798.21 20,257.44 £ 7,543.38 946.81 345.42 361.01 373.23 226.47 431.85 0.00 829.63 128.97 644.35 1431.86 1823.78
Expenditure totals: £ 11,798 £ 25,894.63 £ 12,647.03 £ 1,472 £ 601 £ 616 £ 718 £ 832 £ 701 £ 928 £ 1,099 £ 400 £ 914 £ 2,200 £ 2,166
Income less expenditure £ 11,751 -£ 2,528.11 -£ 5,952.53
loss loss
Petty cash payments 77.39
**----- End of picture text -----**
Note: To make the report readable, the figures are rounded. This may cause some small, false discrepancies in the column totals. 1 / 1