
## **Men in Sheds (Goole) Charity Number:1184612** 

## **Annual Report For Year Ending 2024** 

Men in Sheds (Goole) Old Bowling Green,  Bartholomew Avenue,  Goole, East Yorkshire,  DN14 6YN **Contact Number:** 01405 761909 **Charity Number** :  1184612 

1 



## **Trustees’ Annual Report** 

## **For the year ending 2024** 

The trustees have the pleasure of presenting their annual report together with the financial report for year ending 2024. 

## **Reference and Administrative Information** 

**Charity Name:** Men in Sheds (Goole) **Charity Number:** 1184612 **Address:** Men in Sheds Old Bowling Green Bartholomew Avenue Goole East Yorkshire DN14 6YN **Current Trustees:** Tony Glynn Burndred (Chair) Jacky Crawford (Trustee) Sid Gilroy-Simpson (Trustee) Richard Paul Sugden (Trustee) Alf Deakins (Trustee) Peter Murray (Trustee) Walter William Graham (Trustee) 

All trustees were elected at the AGM 2023. 

2 

Men in Sheds (Goole) Old Bowling Green,  Bartholomew Avenue,  Goole, East Yorkshire,  DN14 6YN **Contact Number:** 01405 761909 **Charity Number** :  1184612 



**Structure, Governance and Management** 

## **Appointment of Trustees** 

Trustees are elected at the annual general meeting which this year was held in accordance with the Charity Commissions guidance. 

## **Objectives and Activities** 

## **Purpose** 

For the benefit, the preservation and protection of good health among men aged 18 years and older, living in Goole and surrounding areas, including those who are retired, unemployed or have health problems, through the provision of facilities for hobbies, recreation or other leisure time occupations including practical interests, skills sharing, the learning of skills, and helping with community-based projects. 

## **Project Summary for 2023-2024** 

This year has seen another period of growth and positive community impact for Men in Sheds (Goole). One of the standout achievements was the design and construction of a pagoda, proudly built by members in the centre of the old bowling green—a true showcase of teamwork, craftsmanship, and dedication. 

Members also contributed to the wider community by producing bird boxes for local groups and crafting planters for the ‘Incredible Edible’ initiative, supporting sustainable growing spaces in the area. 

Membership numbers increased significantly, with many new faces joining throughout the year. For some, the Shed became a vital space to connect with others, particularly those who might not otherwise have many opportunities to get out and socialise. The welcoming and supportive environment continues to bring together like-minded individuals, offering both practical activities and meaningful conversation. 

Men in Sheds (Goole) Old Bowling Green,  Bartholomew Avenue,  Goole, East Yorkshire,  DN14 6YN **Contact Number:** 01405 761909 **Charity Number** :  1184612 

3 



**Shed Accounting - made easy A Men's Shed  Cash Book  and  Receipts and Payments Account  template** 

## **3 Ste Set U p p** 

|**Step 1**||**Shed details**|**Shed details**|||
|---|---|---|---|---|---|
|Required||||||
||**Your Shed Name**||Men in Sheds(Goole)|||
|||||||
||**Your Charity or CIO number**||1184612|||
|||||||
||**Accountng start date**|||01/04/2023||
|||||||
||**Accountng end date**||Period or year end|31/03/2024||
|||||||
||**Bank and cash accounts**<br>Optonal||Current account|||
|||||||
||||Cash|||
|||||||





## **Step 2 Account Analysis** Optional 

## **Receipts** 

|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**|Membershipfees<br>||Annual subs and session fees<br>Usually unrestricted<br>Ofen restricted<br>Trading income<br>Interest received<br>Small receipts not ftng elsewhere|
|---|---|---|---|
||Donatons|||
||Grants|||
||Sales/event income|||
||Interest<br>|||
||Other/Band Practce|||
|**7**|Sale of assets<br>**Payments**||and/or investments|
|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**|Shedpremises costs||Rent, light & heat etc.<br>Nails, screws, glue, wood<br>under £25 suggested<br>To the Shed and/or equipment<br>Tea, cofee and biscuits<br>Printng, postage & statonery<br>UKMSA Membership<br>Small items not ftng elsewhere<br>Spare foryour own use|
||Insurance|||
||Materials & consumables|||
||Small tools(<£25)|||
||Repairs and refurbishment|||
||Refreshments & cleaning<br>|||
||Admin/Ofce costs<br>|||
||Subscriptons|||
||Sundry|||
||Garden|||
|**11**<br>**12**|Hand andpower Tools(>£25)||These rows must only be used for<br>fxed assetpurchases|
||Workshopmachines|||





|**Step 3**||**Priorperiod fgures**|||
|---|---|---|---|---|
|only required<br>if applicable  -->|**If this is your second or subsequent period complete the following.**||||
||**Prior Period Accountng start date**||01/04/2022||
||**Receipts**||**£**||
||Membership fees<br>Donatons<br>Grants<br>Sales / event income<br>Interest<br>Other/Band Practce<br>Sale of assets||113.00||
||||309.19||
||||2,391.79||
||||450.00||
||||187.81||
||||60.00||
||||0.00||
||**Total receipts for period ended**<br>**31/03/2023**<br>**Payments**||3,511.79||
||Shed premises costs<br>Insurance<br>Materials & consumables<br>Small tools (<£25)<br>Repairs and refurbishment<br>Refreshments & cleaning<br>Admin/Ofce costs<br>Subscriptons<br>Sundry<br>Garden<br>Hand and power Tools (>£25)<br>Workshop machines||843.00||
||||974.00||
||||815.00||
||||29.00||
||||573.00||
||||22.20||
||||372.00||
||||55.00||
||||23.00||
||||584.00||
||||59.99||
||||2,289.00||
||**Total payments for period ended**<br>**31/03/2023**<br>**Surplus / (defcit) for prior period**||6,639.19||
||||-3,127.40||





||**Current account balance at**<br>**31/03/2023**|**Current account balance at**<br>**31/03/2023**|16,043.10||
|---|---|---|---|---|
||||||
||**balance at**<br>**31/03/2023**||0.00||
||||||
||**Cash funds held at**<br>**31/03/2023**||124.50||
||**Total cash funds held at**<br>**31/03/2023**||16,167.60||
||**Restricted funds held at**<br>**31/03/2023**||2,075.00||
||**Unrestricted funds held at**<br>**31/03/2023**||14,092.60||
||**Total bank & cash funds held at**<br>**31/03/2022**||19,295.00||
||||0.00||
|||Looksgood|0.00||
||||||





|**Men in Sheds (Goole)**<br>**Cash Book Receipts**|**Men in Sheds (Goole)**<br>**Cash Book Receipts**|**Men in Sheds (Goole)**<br>**Cash Book Receipts**|**Men in Sheds (Goole)**<br>**Cash Book Receipts**||||**For the period ended**<br>**31-Mar-24**<br>**Receipt to**|**For the period ended**<br>**31-Mar-24**<br>**Receipt to**|**For the period ended**<br>**31-Mar-24**<br>**Receipt to**|**For the period ended**<br>**31-Mar-24**<br>**Receipt to**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pety cash"**|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|**Date**|**Who received from**|**Why received**||**Analysis Code**|**Restricted**<br>**funds**||**Current**<br>**account**|**0**|**Cash**||Membership<br>fees|Donatons|Grants|Sales / event<br>income|Interest|Other/Band<br>Practce|Sale of assets|
|28.04.2023<br>28.04.2023<br>28.04.2024<br>31.04.2024<br>03.05.2023<br>05.05.2023<br>05.05.2023<br>05.05.2023<br>05.05.2023<br>12.05.2023<br>12.05.2023<br>17.05.2023<br>18.05.2023<br>22.05.2023<br>25.05.2023<br>27.05.2023<br>29.05.2023<br>31.05.2023<br>02.06.2023<br>02.06.2023<br>04.07.2023<br>21.07.2023<br>27.07.2023<br>27.07.2023<br>01.08.2023<br>04.08.2023<br>21.08.2023<br>21.08.2023<br>29.08.2023<br>29.09.2023<br>22.09.2023<br>29.09.2023<br>11.10.2023<br>11.10.2023<br>11.10.2023<br>16.10.2023<br>11.10.2023<br>31.10.2023<br>31.10.2023<br>03.11.2023<br>06.11.2023<br>08.11.2023|Delta Academies Trust<br>Sid<br>Eion Begby<br>Donaton<br>Sid<br>Mr A Deakins<br>Mr WWG Graham<br>RP Sugden<br>RP Sugden<br>Sid<br>Pete Murphy<br>Donaton<br>Sid<br>Donaton<br>Sid<br>Sid<br>Sid<br>Sid<br>Derek Turville<br>Donaton<br>Family of B.Roe via Puntons<br>Sid<br>John Abbey<br>Ryan Youngman<br>Donaton<br>Various members of public<br>Sid<br>Dawn<br>Tim<br>Sid<br>Sid<br>Open Day event<br>John Frost<br>Kevin Rack<br>Sid<br>Sid<br>Wright Good Festval 2023<br>Transfer between accounts<br>Boothferry Lodge (Freemasons)<br>Wright Good Festval 2023<br>Kim (fower shop)<br>John|Electricity bills reimbursement<br>Band practce<br>Membership<br>Sale of planters<br>Band practce<br>Membership<br>Membership<br>Membership<br>Donaton<br>Band practce<br>Membership<br>Sale of planters<br>Band practce<br>Sale of planters<br>Band practce<br>Band practce<br>Band practce<br>Band practce<br>Membership<br>Sale of planters<br>Legacy donaton<br>Band practce<br>Membership<br>Membership<br>Planters<br>Open day donatons<br>Band practce<br>Membership<br>Membership<br>Band practce<br>Band practce<br>Donaton<br>Donaton<br>Trugs<br>Donaton<br>Band practce<br>Donaton - Bar box<br>Cash transfer<br>Donaton<br>Donaton<br>Donaton<br>Donaton||**2**<br>**2**<br>**1**<br>**2**<br>**2**<br>**1**<br>**1**<br>**1**<br>**2**<br>**2**<br>**1**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**1**<br>**2**<br>**2**<br>**2**<br>**1**<br>**1**<br>**2**<br>**2**<br>**2**<br>**1**<br>**1**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**6**<br>**2**<br>**2**<br>**2**<br>**2**|||2,550.24||||52.00<br>52.00<br>52.00<br>52.00<br>52.00<br>52.00<br>36.00<br>40.00<br>40.00<br>35.00|2,550.24<br>10.00<br>50.00<br>10.00<br>18.00<br>10.00<br>42.00<br>10.00<br>12.00<br>10.00<br>10.00<br>10.00<br>10.00<br>30.00<br>165.00<br>10.00<br>60.00<br>230.90<br>30.00<br>20.00<br>40.00<br>90.00<br>2.00<br>25.00<br>5.00<br>10.00<br>48.00<br>100.00<br>1,000.00<br>20.00<br>30.00||||0.00||
||||||||||10.00|||||||||
||||||||||52.00|||||||||
||||||||||50.00|||||||||
||||||||||10.00|||||||||
||||||||52.00|||||||||||
||||||||52.00|||||||||||
||||||||52.00|||||||||||
||||||||18.00|||||||||||
||||||||||10.00|||||||||
||||||||||52.00|||||||||
||||||||||42.00|||||||||
||||||||||10.00|||||||||
||||||||||12.00|||||||||
||||||||||10.00|||||||||
||||||||||10.00|||||||||
||||||||||10.00|||||||||
||||||||||10.00|||||||||
||||||||||52.00|||||||||
||||||||||30.00|||||||||
||||||||165.00|||||||||||
||||||||||10.00|||||||||
||||||||||36.00|||||||||
||||||||||40.00|||||||||
||||||||||60.00|||||||||
||||||||||230.90|||||||||
||||||||||30.00|||||||||
||||||||||40.00|||||||||
||||||||||35.00|||||||||
||||||||||20.00|||||||||
||||||||||40.00|||||||||
||||||||90.00|||||||||||
||||||||||2.00|||||||||
||||||||||25.00|||||||||
||||||||||5.00|||||||||
||||||||||10.00|||||||||
||||||||||48.00|||||||||
||||||||47.95||-47.95|||||||||
||||||||100.00|||||||||||
||||||||1,000.00|||||||||||
||||||||||20.00|||||||||
||||||||||30.00|||||||||





|17.11.2023<br>17.11.2023<br>18.11.2023<br>24.11.2023<br>24.11.2023<br>08.12.2023<br>13.12.2023<br>20.12.2023<br>12.01.2024<br>19.01.2024<br>30.01.2024<br>06.02.2024<br>07.02.2024<br>27.02.2024<br>27.02.2024|John<br>Sid<br>Clive Glocks<br>John<br>Sean Stewart<br>Sid<br>HEYCU<br>Walter Graham<br>Sid<br>Cash<br>Sid<br>Sid<br>Sid<br>St. Cuthberts Freemasons<br>Refreshment receipts|Donaton<br>Band practce<br>Donaton<br>Donaton<br>Scrap<br>Band practce<br>Interest<br>Donaton<br>Band practce<br>Credit Union<br>Band practce<br>Band practce<br>Band practce<br>Donaton<br>Volunteers||**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**<br>**5**<br>**2**<br>**2**<br>**6**<br>**2**<br>**2**<br>**2**<br>**2**<br>**2**|||||45.00|||45.00<br>10.00<br>30.00<br>12.00<br>20.00<br>30.00<br>30.00<br>30.00<br>20.00<br>20.00<br>20.00<br>100.00<br>35.02|||336.97|100.00||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||||||||10.00|||||||||
||||||||||30.00|||||||||
||||||||||12.00|||||||||
||||||||||20.00|||||||||
||||||||||30.00|||||||||
||||||||336.97|||||||||||
||||||||||30.00|||||||||
||||||||||30.00|||||||||
||||||||||100.00|||||||||
||||||||||20.00|||||||||
||||||||||20.00|||||||||
||||||||||20.00|||||||||
||||||||100.00|||||||||||
||||||||||35.02|||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||
|||||||||||||||||||





|**Ifyou need more r**|**ows add them above this row and copy**|**formulae from below**|||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
||||||||||||||||||||
|||||||||4,564.16|0.00|1,405.97||463.00|5,070.16|0.00|0.00|336.97|100.00|0.00|
|**Identfed as restricted (Y in column G)**<br>**Unrestricted**||||||||||||0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00|||||||
|||||||||||||463.00<br>5,070.16<br>0.00<br>0.00<br>336.97<br>100.00<br>0.00|||||||
||||||||||||||||||||





|**Men in Sheds (Goole)**<br>**Cash Book Payments**|**Men in Sheds (Goole)**<br>**Cash Book Payments**|**Men in Sheds (Goole)**<br>**Cash Book Payments**|**Men in Sheds (Goole)**<br>**Cash Book Payments**||||**For the period ended**<br>**31-Mar-24**<br>**Payment From**|**For the period ended**<br>**31-Mar-24**<br>**Payment From**|**For the period ended**<br>**31-Mar-24**<br>**Payment From**|**For the period ended**<br>**31-Mar-24**<br>**Payment From**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|**1**<br>**2**<br>**3**<br>**4**<br>**5**<br>**6**<br>**7**<br>**8**<br>**9**<br>**10**<br>**11**<br>**12**<br>**Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pety cash"**|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|**Date**|**Whopaid to**|**Why paid**||**Analysis Code**|**Restricted**<br>**funds**||**Current**<br>**account**|**0**|**Cash**||Shed premises<br>costs|Insurance<br>|Materials &<br>consumables|Small tools<br>(<£25)|Repairs and<br>refurbishment|Refreshments<br>& cleaning|Admin/Ofce<br>costs|Subscriptons|Sundry|Garden|Hand and<br>power Tools<br>(>£25)|Workshop<br>machines|
|21.04.23<br>25.04.23<br>02.06.23<br>09.06.23<br>09.06.23<br>15.06.23<br>20.07.23<br>14.08.23<br>14.08.23<br>14.08.23<br>10.11.23<br>10.11.23<br>08.12.23<br>13.12.23<br>12.01.23<br>12.01.23<br>12.01.23<br>03.04.23<br>11.04.23<br>26.04.23<br>03.05.23<br>03.05.23<br>03.05.23<br>23.05.23<br>20.05.23<br>27.05.23<br>30.05.23<br>02.06.23<br>04.05.23<br>26.06.23<br>14.06.23<br>17.07.23<br>17.07.23<br>12.07.23<br>30.06.23<br>19.07.23<br>10.07.23<br>07.07.23<br>27.07.23<br>01.08.23<br>01.08.23<br>04.08.23<br>04.09.23<br>19.07.23<br>25.08.23<br>05.09.23<br>22.09.23<br>12.09.23<br>22.09.23<br>29.09.23<br>29.09.23<br>09.10.23<br>16.10.23<br>01.11.23<br>01.11.23<br>06.10.23|Voluntary Acton Shefeld<br>Kennings Building Supplies<br>M. Ladbrook Ltd<br>East Riding of Yorks  Council<br>Kennings Building Supplies<br>Kennings Building Supplies<br>Mrs MA Gadd<br>Phoenix Accounts<br>Kennings Building Supplies<br>Kennings Building Supplies<br>Kennings Building Supplies<br>Kennings Building Supplies<br>Kennings Building Supplies<br>Complete Fire Solutons<br>Phoenix Accounts<br>Kennings Building Supplies<br>Kennings Building Supplies<br>Screwfx<br>Johnny<br>Post Ofce<br>B&Q<br>Toolstaton<br>Rawclife Road<br>Morrisons<br>Rawclife Road<br>Morrisons<br>Yes<br>Tesco<br>B&Q<br>Post Ofce<br>B&Q<br>B&Q<br>B&Q<br>Spar<br>Rawclife Road<br>Post Ofce<br>Marina's court fower shop<br>Rawclife Road<br>Morrisons<br>Screwfx<br>Screwfx<br>Screwfx<br>Auto Tecnica<br>Post Ofce<br>Post Ofce<br>Argos<br>B&Q<br>MKM<br>Kennings Building Supplies<br>B&Q<br>Morrisons<br>East Coast Sales<br>Morrisons<br>Lidl<br>no receipt<br>Toolstaton|Accounts (20-21)<br>Invoice details missing<br>Insurance<br>Rates<br>Timber<br>Building supplies<br>Centre Lathe (for metal)<br>Accounts (21-22)<br>Timber & fxings etc<br>Timber for festval bar<br>Garden hose<br>Building supplies<br>Building supplies<br>Fire extnguisher certfcate<br>Accounts ending March '23<br>Paint & Insulaton<br>Led Pen light<br>Tarpaulin<br>Vacuum cleaners<br>Mobile Phone top-up<br>Orbital Sander<br>Sanding discs<br>Petrol for mower<br>Refreshments etc for Alliance M<br>Petrol for mower<br>Mobile Phone top-up<br>Mower belts<br>Paint (dark oak)<br>Teak oil & white spirit<br>Mobile Phone top-up<br>Fence life<br>Mop & spray<br>Door ftngs<br>Diesel<br>Petrol for mower<br>Postage<br>Plants for open day<br>Diesel<br>Mobile Phone top-up<br>Wire wheel & degreaser<br>Screws<br>Broom handle & tarp<br>Lathe transport<br>postage for accounts<br>Mobile Phone top-up<br>EE broadband simcard<br>Weedkiller!!!! Wt<br>Sand & cement<br>Building sand<br>Fence life<br>Mobile Phone top-up<br>Safety Helmet<br>Bateries<br>Sanding discs<br>Petrol for mower<br>Overfow pipe & ftngs|ee|**7**<br>**3**<br>**2**<br>**9**<br>**5**<br>**5**<br>**12**<br>**7**<br>**5**<br>**3**<br>**10**<br>**5**<br>**5**<br>**1**<br>**7**<br>**5**<br>**4**<br>**3**<br>**12**<br>**7**<br>**11**<br>**3**<br>**10**<br>t<br>**6**<br>**10**<br>**7**<br>**10**<br>**5**<br>**3**<br>**7**<br>**10**<br>**6**<br>**5**<br>**9**<br>**10**<br>**7**<br>**10**<br>**9**<br>**7**<br>**5**<br>**3**<br>**3**<br>**9**<br>**7**<br>**7**<br>**7**<br>**10**<br>**5**<br>**5**<br>**5**<br>**7**<br>**9**<br>**3**<br>**3**<br>**9**<br>**5**|||504.00||||107.81|1,048.90|110.70<br>172.80<br>22.99<br>11.36<br>22.50<br>52.98<br>22.97<br>7.50<br>19.96|5.99|60.48<br>833.29<br>185.69<br>516.60<br>512.27<br>80.94<br>20.00<br>26.37<br>20.94<br>12.92<br>5.56<br>18.00<br>7.38|84.05<br>35.95|504.00<br>210.00<br>210.00<br>10.00<br>10.00<br>10.00<br>6.85<br>10.00<br>6.85<br>10.00<br>50.00<br>10.00||4.25<br>20.04<br>20.00<br>243.00<br>7.80<br>10.00|13.20<br>8.99<br>7.88<br>18.48<br>48.00<br>8.00<br>40.00<br>16.95|30.00|2,300.00<br>40.00|
||||||||110.70||||||||||||||||
||||||||1,048.90||||||||||||||||
||||||||4.25||||||||||||||||
||||||||60.48||||||||||||||||
||||||||833.29||||||||||||||||
||||||||2,300.00||||||||||||||||
||||||||210.00||||||||||||||||
||||||||185.69||||||||||||||||
||||||||172.80||||||||||||||||
||||||||13.20||||||||||||||||
||||||||516.60||||||||||||||||
||||||||512.27||||||||||||||||
||||||||107.81||||||||||||||||
||||||||210.00||||||||||||||||
||||||||80.94||||||||||||||||
||||||||5.99||||||||||||||||
||||||||||22.99||||||||||||||
||||||||||40.00||||||||||||||
||||||||||10.00||||||||||||||
||||||||||30.00||||||||||||||
||||||||||11.36||||||||||||||
||||||||||8.99||||||||||||||
||||||||||84.05||||||||||||||
||||||||||7.88||||||||||||||
||||||||||10.00||||||||||||||
||||||||||18.48||||||||||||||
||||||||||20.00||||||||||||||
||||||||||22.50||||||||||||||
||||||||||10.00||||||||||||||
||||||||||48.00||||||||||||||
||||||||||35.95||||||||||||||
||||||||||26.37||||||||||||||
||||||||||20.04||||||||||||||
||||||||||8.00||||||||||||||
||||||||||6.85||||||||||||||
||||||||||40.00||||||||||||||
||||||||||20.00||||||||||||||
||||||||||10.00||||||||||||||
||||||||||20.94||||||||||||||
||||||||||52.98||||||||||||||
||||||||||22.97||||||||||||||
||||||||||243.00||||||||||||||
||||||||||6.85||||||||||||||
||||||||||10.00||||||||||||||
||||||||||50.00||||||||||||||
||||||||||16.95||||||||||||||
||||||||||12.92||||||||||||||
||||||||||5.56||||||||||||||
||||||||||18.00||||||||||||||
||||||||||10.00||||||||||||||
||||||||||7.80||||||||||||||
||||||||||7.50||||||||||||||
||||||||||19.96||||||||||||||
||||||||||10.00||||||||||||||
||||||||||7.38||||||||||||||





|07.11.23<br>24.11.23<br>20.11.23<br>26.11.23<br>27.11.23<br>07.12.23<br>08.12.23<br>08.12.23<br>02.11.23<br>15.12.23<br>20.12.23<br>20.12.23<br>04.12.23<br>18.01.24<br>19.01.24<br>22.01.24<br>25.01.24<br>30.01.24<br>30.12.23<br>30.01.23<br>07..02.24<br>07.02.24<br>09.02.24<br>12.02.24<br>12.02.24<br>19.02.24<br>12.02.24<br>19.01.24<br>23.02.74<br>27.03.74<br>27.03.24<br>27.03.24<br>**Ifyou need more**|Discount Store<br>Rawclife Road<br>Trucut bandsaws<br>Morrisons<br>Screwfx<br>Western Wolds Mens Shed<br>Peter Halls<br>Ebay<br>B&Q<br>Dockside computers<br>Tesco<br>Arcade Electrical<br>Andy Walton<br>Carlisle DIY<br>Post Ofce<br>Morrisons<br>Boyes<br>Ebay<br>Morrisons<br>Post Ofce<br>Lidl<br>Home Bargains<br>Lidl<br>Screwfx<br>no receipt<br>Snaith Hall flling staton<br>Screwfx<br>Pety cash<br>Pety Cash<br>Pety Cash<br>Kennings Building Supplies<br>CEF<br>**rows add them above this row an**|Picture Hangers<br>Petrol for mower<br>3 bandsaw blades<br>Mobile Phone top-up<br>Electrics<br>Engraver<br>5 lever arch folders & dividers<br>Microsof Ofce 2019 pro<br>Varnish & staples<br>USB scanning cable<br>4 port mini-USB hub<br>Keys<br>Roof repair materials & labour<br>Overfow ftngs<br>Special delivery - accounts<br>AA bateries<br>3 light switches<br>Oil for lathe<br>Mobile Phone top-up<br>Mobile Phone top-up<br>20v Li-Ion Batery<br>Toilet rolls & waste baskets<br>2x 20v Li-Ion Bateries<br>Oil siphon<br>Petrol<br>Petrol for tool collecton<br>Flashband primer<br>Cash a/c<br>Cash a/c<br>Cash a/c<br>Building supplies<br>Electrical parts<br>**d copy formulae from below**||**5**<br>**10**<br>**3**<br>**7**<br>**1**<br>**12**<br>**7**<br>**7**<br>**5**<br>**7**<br>**7**<br>**7**<br>**5**<br>**5**<br>**7**<br>**3**<br>**5**<br>**3**<br>**7**<br>**7**<br>**4**<br>**6**<br>**4**<br>**4**<br>**3**<br>**3**<br>**3**<br>**9**<br>**9**<br>**9**<br>**5**<br>**5**|||||5.00||19.03||35.25<br>3.00<br>38.58<br>27.66<br>10.00<br>7.99|24.99<br>49.98<br>10.79|5.00<br>10.25<br>20.00<br>6.07<br>3.60<br>123.72<br>351.80|7.98|10.00<br>9.50<br>31.99<br>4.00<br>11.00<br>14.00<br>7.35<br>10.00<br>10.00||100.00<br>250.00<br>200.00|8.19||100.00|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||||||||8.19||||||||||||||
||||||||||35.25||||||||||||||
||||||||||10.00||||||||||||||
||||||||||19.03||||||||||||||
||||||||||100.00||||||||||||||
||||||||||9.50||||||||||||||
||||||||||31.99||||||||||||||
||||||||||10.25||||||||||||||
||||||||||4.00||||||||||||||
||||||||||11.00||||||||||||||
||||||||||14.00||||||||||||||
||||||||||20.00||||||||||||||
||||||||||6.07||||||||||||||
||||||||||7.35||||||||||||||
||||||||||3.00||||||||||||||
||||||||||3.60||||||||||||||
||||||||||38.58||||||||||||||
||||||||||10.00||||||||||||||
||||||||||10.00||||||||||||||
||||||||||24.99||||||||||||||
||||||||||7.98||||||||||||||
||||||||||49.98||||||||||||||
||||||||||10.79||||||||||||||
||||||||||27.66||||||||||||||
||||||||||10.00||||||||||||||
||||||||||7.99||||||||||||||
||||||||100.00||||||||||||||||
||||||||250.00||||||||||||||||
||||||||200.00||||||||||||||||
||||||||123.72||||||||||||||||
||||||||351.80||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||||||||||||||||||
||||||||7,902.44|0.00|1,530.47||126.84|1,048.90|566.24|91.75|2,820.88|127.98|1,155.54|0.00|855.09|169.69|30.00|2,440.00|
|**Identfed as restricted (Y in column G)**<br>**Unrestricted**|||||||||||0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00<br>0.00||||||||||||
||||||||||||126.84<br>1,048.90<br>566.24<br>91.75<br>2,820.88<br>127.98<br>1,155.54<br>0.00<br>855.09<br>169.69<br>30.00<br>2,440.00||||||||||||
||||||||||||||||||||||||





|**Men in Sheds (Goole)**<br>**Cash Book Summary and Reconciliaton**<br>**For the period ended**<br>**31/03/2024**|**Men in Sheds (Goole)**<br>**Cash Book Summary and Reconciliaton**<br>**For the period ended**<br>**31/03/2024**|**Men in Sheds (Goole)**<br>**Cash Book Summary and Reconciliaton**<br>**For the period ended**<br>**31/03/2024**|**Men in Sheds (Goole)**<br>**Cash Book Summary and Reconciliaton**<br>**For the period ended**<br>**31/03/2024**|**Men in Sheds (Goole)**<br>**Cash Book Summary and Reconciliaton**<br>**For the period ended**<br>**31/03/2024**|||||
|---|---|---|---|---|---|---|---|---|
|**Current account summary**<br>**Opening Balance**<br>**Receipts and net transfers**<br>**Payments**<br>**Closing Balance**<br>**Bank Reconciliaton**|||as at<br>as at||<br>01/04/2023<br> <br>31/03/2024||**£**<br>16,043.10<br>4,564.16<br>-7,902.44<br>**12,704.82**<br>**£**||
||**Balance per Bank Statement**||**on**||**31/03/2024**||12,704.82||
||**Add**<br>**Date**||**Payee/ details**<br>**Slip ref**||**£**||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||**Less**<br>**Date**||**Payee/ details**<br>**Chq No.**||**£**||0.00||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||**Reconciled balance**<br>**Diference**||||||0.00<br>12,704.82<br>0.00||
||||||||||
|**summary**<br>Opening Balance<br>Net transfers from/(to) current<br>Payments<br>Closing Balance|||account and other receipts (interest received)||||**£**<br>0.00<br>0.00<br>0.00<br>**0.00**||
||||||||||
|**Cash summary**<br>Opening cash held<br>Unbanked cash receipts<br>Cash payments<br>Closing cash held|||||||**£**<br>124.50<br>1,405.97<br>-1,530.47<br>**0.00**||
|**Cash counted by**|||name of cash counter|**On**|date||£||
||||||||||





## **Men in Sheds (Goole) Assets retained for the Shed’s own use 3/31/2024** 


||Optonal<br>**Quantty**<br>**Unit cost**<br>£|Optonal<br>**Quantty**<br>**Unit cost**<br>£|Optonal<br>**Quantty**<br>**Unit cost**<br>£|Optonal<br>Optonal<br>**Total cost**<br>**Unit value**<br>£<br>£|Optonal<br>Optonal<br>**Total cost**<br>**Unit value**<br>£<br>£|**Required**<br>**Total value**<br>£|**Required**<br>**Total value**<br>£|
|---|---|---|---|---|---|---|---|
||**Buildings**|||||||
|1<br>2<br>3<br>4<br>5||||0.00||0.00||
|||||0.00||0.00||
|||||0.00||0.00||
|||||0.00||0.00||
|||||0.00||0.00||
|||||**0.00**||**0.00**||
||**Large items of machinery**|||||||
|1<br>2<br>3<br>4<br>5<br>6<br>7<br>8<br>9<br>10||||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**||
||**Power tools**|||||||
|1 <br>2 <br>3 <br>4 <br>5 <br>6 <br>7 <br>8<br>9<br>10|Drills|||0.00||0.00||
||Sanders|||0.00||0.00||
||Bench saws|||0.00||0.00||
||Planers|||0.00||0.00||
||Routers|||0.00||0.00||
||Mult-tools|||0.00||0.00||
||Glue and heatguns|||0.00||0.00||
|||||0.00||0.00||
|||||0.00||0.00||
|||||0.00||0.00||
|||||**0.00**||**0.00**||
||**Hand tools**|||||||
|1 <br>2 <br>3 <br>4 <br>5 <br>6 <br>7 <br>8 <br>9 <br>10|Hand saws|||0.00||0.00||
||Hammers|||0.00||0.00||
||Chisels & other woodwork tools|||0.00||0.00||
||Screwdrivers and hex keys|||0.00||0.00||
||Pliers|||0.00||0.00||
||Boxed tool kits(tool sets)|||0.00||0.00||
||Files|||0.00||0.00||
||Clamps|||0.00||0.00||
||Levels,tapes,measuringand markingtools|||0.00||0.00||
||Other hand tools|||0.00||0.00||
|||||**0.00**||**0.00**||





||**Other assets**|||||||
|---|---|---|---|---|---|---|---|
|1 <br>2 <br>3 <br>4 <br>5<br>6<br>7<br>8<br>9<br>10|Workbenches|||0.00||0.00||
||Rackingand shelves|||0.00||0.00||
||Space heater|||0.00||0.00||
||Fridge,ketle,mugs etc.|||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||
||**Total cost and value**|||**0.00**<br>**0.00**||**0.00**<br>**0.00**||





||**Men in Sheds**|**(Goole)**|||**1184612**|||
|---|---|---|---|---|---|---|---|
||**WARNING**|**DO NOT FILE**|||||**CC16a**|
|Member|**For the period**<br>**from**|Period start date<br>**4/1/2023**||**To**|Period end date<br>**3/31/2024**|||
|||||||||



## **Section A Receipts and payments** 

|Member|Member|**Men in Sheds (Goole)**|**Men in Sheds (Goole)**|**Men in Sheds (Goole)**|**Men in Sheds (Goole)**|**1184612**|**1184612**||**CC16a**|
|---|---|---|---|---|---|---|---|---|---|
|||**WARNING DO NOT FILE**||||||||
|||**For the period**<br>**from**|Period start date<br>**4/1/2023**||**To**|Period end date<br>**3/31/2024**||||
|||||||||||
|**Section A Receipts andpayments**||||||||||
|**Receipts**|||**to the nearest £**<br>**Unrestricted**<br>**funds**||**to the nearest £**<br>**Restricted**<br>**funds**||**Total funds**<br>**to the nearest £**||**Last year**<br>**to the nearest £**|
|Membershipfees|||463.00||0.00||**463.00**||113|
|Donations|||5,070.16||0.00||**5,070.16**||309|
|Grants|||0.00||0.00||**0.00**||2,392|
|Sales / event income|||0.00||0.00||**0.00**||450|
|Interest|||336.97||0.00||**336.97**||188|
|Other/Band Practice|||100.00||0.00||**100.00**||60|
|**Sub total **(Gross income for AR)|||**5,970.13**||**0.00**||**5,970.13**||**3,512**|
|**Asset and investment sales**||||||||||
|Sale of assets|||0.00||0.00||**0.00**||0.00|
|Sale of investments|||0.00||0.00||**0.00**||0.00|
|**Sub total**|||**0.00**||**0.00**||**0.00**||**0.00**|
|||||||||||
|**Total receipts**|||**5,970.13**||**0.00**||**5,970.13**||**3,511.79**|
|**Payments**||||||||||
|Shed premises costs|||126.84||0.00||**126.84**||843.00|
|Insurance|||1,048.90||0.00||**1,048.90**||974.00|
|Materials & consumables|||566.24||0.00||**566.24**||815.00|
|Small tools (<£25)|||91.75||0.00||**91.75**||29.00|
|Repairs and refurbishment|||2,820.88||0.00||**2,820.88**||573.00|
|Refreshments & cleaning|||127.98||0.00||**127.98**||22.20|
|Admin/Office costs|||1,155.54||0.00||**1,155.54**||372.00|
|Subscriptions|||0.00||0.00||**0.00**||55.00|
|Sundry|||855.09||0.00||**855.09**||23.00|
|Garden|||169.69||0.00||**169.69**||584.00|
|**Sub total**|||**6,962.91**||**0.00**||**6,962.91**||**4,290.20**|
|**Asset and investmentpurchases**||||||||||
|Hand and power Tools (>£25)|||30.00||0.00||**30.00**||59.99|
|Workshop machines|||2,440.00||0.00||**2,440.00**||2,289.00|
|**Sub total**|||**2,470.00**||**0.00**||**2,470.00**||**2,348.99**|
|||||||||||
|**Total payments**|||**9,432.91**||**0.00**||**9,432.91**||**6,639.19**|
|||||||||||
|**Net of receipts/(payments)**|||**-3,462.78**||**0.00**||**-3,462.78**||**-3,127.40**|
|Transfers between funds|||0.00||0.00|||||
|**Cash funds last year end**|||14,092.60||2,075.00||**16,167.60**||19,295.00|
|**Cash funds this year end**|||**10,629.82**||**2,075.00**||**12,704.82**||**16,167.60**|
|||||||||||





## **Section B Statement of assets and liabilities at the end of the period** 

|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|**Section B Statement of assets and liabilities at the end of the period**|
|---|---|---|---|---|---|---|---|---|---|---|
|**Categories**<br>**Cash funds**|||**to nearest £**<br>**Unrestricted**<br>**funds**||**to nearest £**<br>**Restricted**<br>**funds**||**to the nearest £**<br>**Total current**<br>**Period**||**Last year**<br>**to the nearest £**||
|Current account|||**10,629.82**||**2,075.00**||**12,704.82**|||**16,043.10**|
|0.00|||**0.00**||**0.00**||**0.00**|||**0.00**|
|Cash|||**0.00**||||**0.00**|||**124.50**|
|**Total cash funds**|||**10,629.82**||**2,075.00**||**12,704.82**|||**16,167.60**|
|(agree balances with receipts and payments<br>account(s))|||OK||OK||OK||OK||
|**Other monetary assets**|||||||||||
|Stocks/goods for sale|||||||**0.00**||||
|Debtors|||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||0.00|||0.00|
|**Investment assets**|||||||||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||0.00|||0.00|
|**Assets retained for the Shed’s**<br>**own use**|||||||||||
|Buildings|||0.00||||**0.00**||||
|Large items of machinery|||0.00||||**0.00**||||
|Power tools|||0.00||||**0.00**||||
|Hand tools|||0.00||||**0.00**||||
|Other assets|||0.00||||**0.00**||||
||||||||0.00|||0.00|
|**Liabilities**|||||||||||
|Trade creditors|||||||**0.00**||||
|Accrued expenses|||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||**0.00**||||
||||||||0.00|||0.00|
|**Signed by one or two trustees on**<br>**behalf of all the trustees**||Signature|||Print Name||||Date of<br>approval||
||||||||||||
||||||||||||





on about the legal status and registering as CIO is giving in the UKMSA guide “Becoming a CIO”. 

although a month end always feels tidier. 



ccount) and thereafter just use the new account going forward. 



## **Shed Accounting* -  made easy** 

## **A Men's Shed Cash Book and Receipts and Payments Account template** 

*** suitable for all unincorporated Sheds across the UK, whether registered or not as a charity, and CIOs** 

**UKMSA recommends that all Men's Sheds prepare Accounts on the Receipts and Payments basis for their members and funders. For those registered as charities submission to their Charity Regulator may be a legal requirement. To help you do this we have prepared this spreadsheet template.** 

We have added **Receipts** and **Payments** tabs (a "cashbook") to a modified version of the template accounts provided by the Charity Commission in England and Wales. These modifications have been made so that the UKMSA template Receipts and Payments Account is also compliant with the additional disclosure requirements of the Scottish Charity Register and the Charity Commission for Northern Ireland. 

The **Receipt** and **Payment** tabs are used to automatically complete the Receipts and Payments Account (Section A). To finish your **Shed Accounts** you will only need to manually enter details, if any, of other assets and liabilities on the Statement of Assets and Liabilities (Section B). Scottish Men's Sheds (Registered with the OSCR) will also need to complete the Notes to the accounts (Section C). 

Once completed the **Shed Accounts** can be printed for your members and funders and if required submission to your Charity Regulator along with the Trustees' Annual Report (which needs to be prepared separately). 

**Note: this template IS NOT suitable for Men's Sheds registered as Limited Liability or Community Interest Companies.** 

**If your Men's Shed is a registered charity you can find your charity regulator's Receipts and Payments accounts pack, which includes guidance notes, by following the relevant link below:** 

England and Wales Scotland Northern Ireland 

It is assumed users have sufficient knowledge and experience of using spreadsheets to use this template. As we have no control over how you use this spreadsheet UKMSA does not accept any responsibility for the Receipts and Payments Accounts produced by this template which you use entirely at your own risk. 

## **What is a Receipts and Payments Account ?** 

A Receipts and Payments Account is a financial statement that summarises the movement of cash in and out during a financial period/year. In this context ‘cash’ includes bank and building society current and other accounts into which money is banked or used to make payments (PayPal for example). 

A Receipts and Payment Account only requires you to account for money transactions (cash and bank) and allows you to ignore non monetary transactions and unpaid items. This is much easier to understand and record than accruals accounting and, so long as the income is below £250,000, perfectly acceptable to all the UK Charity Regulators. 

## **Keep it simple** 

Only 2 things can happen to money, it comes in and it goes out. Records should be kept of money in and money out analysed into appropriate reasons why it came in and why it went out. In this template this is recorded on one tab for money in **(Receipts)** and one tab for money out **(Payments)** . 

Separate records should be maintained for separate bank and cash accounts, don't for example mix the cash and bank records up. In this template this is achieved by using separate columns for separate accounts ; For example; (I) Current account, (J) Deposit account and (K) Cash. The bank current account columns for Receipts and Payments (Column I on both the **Receipts** and **Payments** tabs) should mirror the bank statements with an explanation (analysis) for each transaction, nothing else. 

During the first year total bank receipts in less total bank payments out should always equal the bank balance. For second and subsequent years the opening balance plus receipts less payments should always equal the bank balance. It is important to check this **(Bank and Cash Summary)** after entering every bank statement to identify and correct any errors as you go. 

## **What is a cash book ?** 

A cash book is simply the name given to the record of cash and/or bank receipts and payments. Originally these would have been in physical cash books but today they are often recorded on spreadsheets. 

In this template the **Receipts** and **Payment** tabs together are the "Cash Book". Totals from these tabs are summarised on the **Bank and Cash Summary** so you can check the balances agree to your bank statements and cash counts. 

The analysis of receipts and payments into reason why money came in and went out is used to complete the Receipts and Payments Account. 



## **How to use this cash book** 

- **1** After a simple 2 or 3 step **Set Up** this spreadsheet can be used to record **Receipts** and **Payments** for up to 2 bank accounts and 1 cash account which should be more than enough for most Men's Sheds. 

- **2** Receipts and payments must be entered for the same period, usually a year, that your accounts will be prepared for. Start a new spreadsheet for each new year, check the UKMSA website for a newer version first. 

**3** 

Work methodically and enter transactions in strict date order. For each transaction enter the date, who received from/paid to and a brief comment why. 


**4** On both the **Receipts** and **Payments** tabs each entry is analysed into columns  (Columns M onwards) to identify why money came in or why it went out. These columns can be renamed on the **Set Up** tab to suit your receipts and payments as required. To populate these columns use column F to identify which column the receipt or payment should be allocated to by entering the relevant column number (Green numbers above column description). If you need to split a receipt or a payment across more than one column do it by splitting the transaction over 2 or more rows. 

WARNING: DO NOT add columns unless you are sure how these link to the final receipts and payment account and know how to add another row and formula in the correct place. 

**5** If the transaction is the receipt or payment of restricted funds put a Y in column G. 

- **6** Finally enter the transaction amount in the correct bank or cash account column - It is very important to do this correctly. 

- **7** You must then check your actual bank statement balance and cash count agree to the **Bank and Cash summary** figures calculated from your input. 

**8** If you do not give a reason why any money came in or went out or fail to reconcile the year end bank statement balance suitable warnings will be displayed on the **Shed Accounts** tab and elsewhere. These warnings will disappear when all issue have been fixed. 

**9** On both the **Receipts** and **Payments** tabs you can scroll right to check the "cross check" column. This will either show "looks OK" or "Error" to help you identify any rows where the analysis code may be missing. 

- **10** Finally review the **Shed Accounts** to ensure there are no warnings and they appear to make sense. In particular the bank and cash balances on Section B (page 2) should have "OK" under each cash fund. 

- **11** If you do have error warning messages the detail and source of these errors are given at the foot of the **Shed Accounts** (rows 158 - 172 after Section C) with some hints on how to correct them. 

## **12 Before you start** please take some time to test the functionality of this cash book. 

There are some example entries on both the **receipts** and **payments** tabs. You can change the analysis column by changing the column number in column F. Try it and see what happens. Have a play by deleting an analysis code for a receipt or a payment or both and see what error messages pop up. Change the bank reconciliation figure to see what warning appears on the **Shed Accounts** . 

You should also look at the **Bank and Cash Summary** to understand how each balance brought forward plus receipts less payments must equal the balance held at the period/year end. You MUST ensure that the bank and cash accounts either agree or are reconciled (differences explained). 

## **a** 

## **Refunds** 

Refunds can be entered as negative figures so that the refund amount is deducted from the same cost analysis that the original purchase was allocated to. 

## **b Transfers between cash and bank accounts** 

Transfers between cash and/or bank accounts need to be recorded on a single row as + (plus) and - (minus) entries **in columns I, J, K** as appropriate. No analysis is required because the net amount must be zero. You are just transferring cash from one account to another. 

All transfers should be recorded on the Receipts tab, enter the + (plus) amount in the account column receiving the transfer and an equal - (minus) amount in the account column making the transfer. 



|**c**<br>**d**<br>**e**<br>**f**|**Restricted Funds**<br>**Transfers between unrestricted and restricted funds**<br>Restricted funds should never be negatve and should be replaced by unrestricted funds if necessary.<br>**Endowment Funds**<br>**Accountng for other assets and liabilites**<br>If your Shed is a new CIO preparing accounts for the frst tme any transfer received from the bank account of a former unincorporated Men's Shed associatonIS NOT<br>a transfer between accountsand should be entered as the receipt of a donaton from the unincorporated associaton. If this is the case see the**Convertng to a CIO**tab<br>for explanaton.<br>If any receipt or payment relates to restricted funds put a Y in column G. It is important to identfy restricted items because unrestricted and restricted funds  must be<br>disclosed separately in the accounts. You also need to be able to show restricted funds have been spent appropriately.<br>Surplus restricted funds can not usually be transferred to unrestricted funds. Specifc agreement from the donor of the restricted funds would be required to do that.<br>Unrestricted funds may however be transferred to restricted funds, for example to support a capital purchase part funded by a restricted grant.<br>Transfers between unrestricted and restricted funds can be shown on the**Shed Accounts**at row 48 "transfers between funds". Any such transfer should be shown as a<br>positve (+) in the fund receiving the transfer and a negatve (-) in the fund making the transfer.<br>The**Shed Accounts**will automatcally show a transfer to restricted funds from unrestricted funds if required. You can however overwrite this balancing calculaton if<br>you wish to restrict more funds than required.<br>Endowment funds are special funds which must usually be invested to produce income and not actually be spent. It is considered unlikely that any Men's Shed will<br>have endowment funds and accordingly this cashbook DOES NOT provide for them.<br>At the end of the fnancial year/period a statement of assets and liabilites must also be prepared. For most Men’s Sheds we would expect to see some tools and<br>equipment. You can estmate the value, there is no need to prepare a detailed valuaton. If there are any unpaid bills or expenses the total amount should be disclosed,<br>you do not need to list every unpaid item.|**Restricted Funds**<br>**Transfers between unrestricted and restricted funds**<br>Restricted funds should never be negatve and should be replaced by unrestricted funds if necessary.<br>**Endowment Funds**<br>**Accountng for other assets and liabilites**<br>If your Shed is a new CIO preparing accounts for the frst tme any transfer received from the bank account of a former unincorporated Men's Shed associatonIS NOT<br>a transfer between accountsand should be entered as the receipt of a donaton from the unincorporated associaton. If this is the case see the**Convertng to a CIO**tab<br>for explanaton.<br>If any receipt or payment relates to restricted funds put a Y in column G. It is important to identfy restricted items because unrestricted and restricted funds  must be<br>disclosed separately in the accounts. You also need to be able to show restricted funds have been spent appropriately.<br>Surplus restricted funds can not usually be transferred to unrestricted funds. Specifc agreement from the donor of the restricted funds would be required to do that.<br>Unrestricted funds may however be transferred to restricted funds, for example to support a capital purchase part funded by a restricted grant.<br>Transfers between unrestricted and restricted funds can be shown on the**Shed Accounts**at row 48 "transfers between funds". Any such transfer should be shown as a<br>positve (+) in the fund receiving the transfer and a negatve (-) in the fund making the transfer.<br>The**Shed Accounts**will automatcally show a transfer to restricted funds from unrestricted funds if required. You can however overwrite this balancing calculaton if<br>you wish to restrict more funds than required.<br>Endowment funds are special funds which must usually be invested to produce income and not actually be spent. It is considered unlikely that any Men's Shed will<br>have endowment funds and accordingly this cashbook DOES NOT provide for them.<br>At the end of the fnancial year/period a statement of assets and liabilites must also be prepared. For most Men’s Sheds we would expect to see some tools and<br>equipment. You can estmate the value, there is no need to prepare a detailed valuaton. If there are any unpaid bills or expenses the total amount should be disclosed,<br>you do not need to list every unpaid item.|
|---|---|---|
||Please delete the example entries in columns B to K (both Receipts and Payments) before entering your own transactons. Columns L onwards are formulae and should<br>not be deleted.<br>Save your cash book spreadsheet with a new name, e.g.Your Men's Sheds Accounts 2020.xlsxto preserve this copy with the example entries.<br>Use a new spreadsheet for each accountng period/year. Save a fnal copy at the period/year end, enter closing balances and comparatve fgures on the Set Up tab of<br>a new spreadsheet for next period/year.||
||NOTE: Men's Sheds registered as either Limited Liability or Community Interest Companies must, under the Companies Act, prepare annual accounts on the accruals<br>basis. The Receipts and Payments Account produced by this template is not compliant with the accruals basis. Accordingly Men's Sheds registered as  companies (Ltd<br>or CIC) will have to prepare annual accounts using a diferent accounts template which include assets and liabilites and a balance sheet.||
||||
||**Rounding errors**: It is possible that the fnal accounts, shown to the nearest pound, could contain "rounding errors". This arises if the overall rounding up and rounding<br>down is unbalanced. To fx try adding a few pence as a receipt or payment to rebalance the fnal accounts.||
||||
||**PASSWORD PROTECTION: The formulae and formatng of this template have been protected to prevent accidental deleton. If**<br>**you need to unprotect any sheet the password is UKMSA.**||
||**Version 3.50 (Beta)**<br>Sunday, January 10, 2021||



