Dereham Men’s Shed 62A Norwich Street Dereham Norfolk NR19 1AD
Objectives and Activities
The objectives of Dereham Men’s Shed (DMS) are to promote social inclusion for the public benefit by engaging adult males aged 18 and over within the Dereham area who may be at risk of social isolation and to relieve the needs of those who are socially excluded by assisting them to integrate in society through the provision of facilities where they can meet to undertake, jointly or individually for
-
Creative, physical, or recreational activities
-
Learning or passing on skills or knowledge
-
Social support.
Further opportunities are undertaken to work in partnership with local groups and organisations to support our community.
DMS is managed by the Trustees. Any member of DMS can volunteer to become a Trustee and their appointment is formalised and approved during a general meeting of the membership.
The DMS Trustees have had regard to the guidance issued by the Charity Commission on public benefit. The Trustees believe that they have complied with the objectives of our charity as stated and are very much aware of ensuring that the wider community benefit from the Shed’s activities and not solely the personal benefit that the shed members enjoy.
Achievements and Performance
Members of Dereham Men’s Shed have continued to meet on a weekly basis as the UK emerged from the pandemic and the restrictions of meeting in large groups started to ease for everyone. Our weekly meetings provide the opportunity for members to meet socially to provide support to each other and make new friends.
Our regular meetings and Shed activities took on a new focus at the start of this reporting period as we reached an agreement with the Dereham Theatre Company to share the use of their premises, located in the centre of our town, as a base for our Shed. We formally took up residence from 1 August 2022 The agreement reached was for our Shed to have sole use of their old storage room which has been
Trustee’s Annual Report 2022
Page 1
transformed into a small workshop for use by our members as well as full use of a large kitchen area, and their rehearsal room which is a perfect space for presentations.
In response to the theatre companies generosity our members immediately got to work helping to transform their rehearsal room into a bright newly painted space they are able to use for both their youth section as well as the main company before the work began to create a workshop in the old storage room.
This new workshop has enabled the Shed to increase the range of activities members can participate in and we are now open for an additional morning during the week. The workshop provides the opportunity for some members to take on personal and well as community based projects that have come our way. Two of the more recent high profile community based projects has been the construction of a few small items such as bird boxes, a hedgehog hotel and other similar artefacts for inclusion within the much larger community ‘pocket park’, this is a area which now provides members of the local community with a relaxing space in the middle of Dereham town centre. Secondly a number of our members helped sisters from the Community of Our Lady of Walsingham with a few gardening tasks at the local convent.
The tasks outlined above and a few others which have been completed provide our Shed with a small income from the kind donations received in response to the effort provided from our members.
During this shortened reporting period the Shed saw 6 new members join our shed. We continue to advertise the Shed online and through local outlets to attract new members.
Financial Review
Funds held 31/03/2022
Bank account £3445.00 Petty cash £62.43
Income
| Income | |
|---|---|
| Membership fees | £485 |
| Donations | £438 |
| Sales/events income | £209 |
| Members refreshments | £754 |
| Other | £35 |
Trustee’s Annual Report 2022 Page 2
TOTAL £1921
Expenditure
| Expenditure | |
|---|---|
| Shed premises costs | £122 |
| Materials and consumables | £36 |
| Member’s refreshments and Xmas meal. | £348 |
| Admin/office costs | £151 |
| Subscriptions | £62 |
| Sundry | £220 |
| Advertising | £50 |
| Workshop machines (Asset Purchase) | £80 |
| TOTAL | £1069 |
DMS does not have any debts.
Financial Operating Model:
Our income is primarily derived from membership fees and contributions from members when attending the weekly meetings. A second source of income is from artefacts make in the workshop and sold at local events particularly spring and summer outdoor fetes as well as Christmas events.
The committee increased the annual membership subscription for 2022 back to the pre-pandemic level. The subscription had been reduced during 2021 in light of the minimal activities available to members during the periods of lockdown everyone experienced.
Our expenditure is kept to a minimum although a few tools have been procured to equip the workshop. The agreement reached with the theatre company is that we pay a peppercorn rent for the use of their premises in return for support and
Trustee’s Annual Report 2022
Page 3
assistance with the building of sets and other production artefacts required for their theatrical productions.
Structure, Governance and Management
DMS is a Charitable Incorporated Organisation (CIO).
The CIO is governed by a constitution, with charity trustees being elected by members during a General Meeting.
The Trustees are responsible for the governance of the charity and direct how it is managed and run.
Administration Information
| Administration Information | |
|---|---|
| Charity name | Dereham Men’s Shed |
| Registered charity number | 1192142 |
| Charity address | Dereham Men’s Shed 62A Norwich Street Dereham Norfolk NR19 1AD |
Name of the Trustees
| Trustee Name | Office | Duration in Office | Appointed by |
|---|---|---|---|
| John Collins | Chair | Whole period | Member’s AGM |
| Ian Grixti | Treasurer | Whole period | Member’s AGM |
| Kevin Green | Secretary | Whole period | Member’s AGM |
| Chris Lambert | Whole period | Member’s AGM | |
| John Pye | Whole period | Member’s AGM | |
| Howard Martin | Whole period | Member’s AGM |
Trustee’s Annual Report 2022 Page 4
Declarations
The Trustees declare that they have approved the trustees’ report above.
| Trustee Name | Signature | Position | Date |
|---|---|---|---|
| John Collins | John Collins | Chairman | 13/4/2022 |
| Ian Grixti | Ian Grixti | Treasurer | 13/4/2022 |
Trustee’s Annual Report 2022 Page 5
----- Start of picture text -----
Shed Accoun+ng - 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 chari+es 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 modifica@ons have been made so that the UKMSA template Receipts and Payments Account is also compliant with the addi@onal disclosure requirements of the
ScoJsh Charity Register and the Charity Commission for Northern Ireland.
The Receipt and Payment tabs are used to automa@cally complete the Receipts and Payments Account (Sec@on A). To finish your Shed Accounts you will only need to
manually enter details, if any, of other assets and liabili@es on the Statement of Assets and Liabili@es (Sec@on B). ScoJsh Men's Sheds (Registered with the OSCR) will
also need to complete the Notes to the accounts (Sec@on 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 enCrely at your own risk. Scroll down for instruc+ons
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 transac@ons (cash and bank) and allows you to ignore non monetary transac@ons and unpaid
items. This is much easier to understand and record than accruals accoun@ng 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
Doing this makes reconcilia@ons and
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 explana@on (analysis) for each transac@on, nothing else. finding errors much easier
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) a^er entering every bank statement to
iden@fy 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 o^en 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. on the Shed Accounts tab
How to use this cash book
1 A^er 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 transac@ons in strict date order. For each transac@on enter the date, who received from/paid to and a brief comment why.
----- End of picture text -----
1
| Every receipt and every payment must be allocated to an analysis column otherwise the accounts will not balance |
|||
| 4 | On both theReceiptsandPaymentstabs each entry is analysed into columns (Columns M onwards) to iden@fy why money came in or why it went out. These columns can be renamed on theSet Uptab to suit your receipts and payments as required. To populate these columns use column F to iden@fy which column the receipt or payment should be allocated to by entering the relevant column number (Green numbers above column descrip@on). If you need to split a receipt or a payment across more than one column do it by spliJng the transac@on over 2 or more rows. |
||
| WARNING: DO NOT add columns unless you are sure how these link to the fnal receipts and payment account and know how to add another row and formula in the correct place. |
DO NOT USE ANALYSIS COLUMNS FOR TRANSFERS BETWEEN CASH OR ANY BANK ACCOUNTS. Transfers are not receipts or payments, See 12b below. |
||
| 5 | If the transac@on is the receipt or payment of restricted funds put a Y in column G. | ||
| 6 | Finally enter the transac@on 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 theBank and Cash summaryfgures 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 theShed Accountstab and elsewhere. These warnings will disappear when all issue have been fxed. |
||
| 9 | On both theReceiptsandPaymentstabs you can scroll right to check the "cross check" column. This will either show "looks OK" or "Error" to help you iden@fy any rows where the analysis code may be missing. |
||
| 10 | Finally review theShed Accountsto ensure there are no warnings and they appear to make sense. In par@cular the bank and cash balances on Sec@on 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 theShed Accounts(rows 158 - 172 a^er Sec@on C) with some hints on how to correct them. |
||
| 12 | Before you startplease take some @me to test the func@onality of this cash book. | ||
| There are some example entries on both thereceiptsandpaymentstabs. You can change the analysis column by changing the column number in column F. Try it and see what happens. Have a play by dele@ng an analysis code for a receipt or a payment or both and see what error messages pop up. Change the bank reconcilia@on fgure to see what warning appears on theShed Accounts. |
|||
| You should also look at theBank and Cash Summaryto 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 (diferences explained). |
|||
| a | Refunds | ||
| Refunds can be entered as nega@ve fgures so that the refund amount is deducted from the same cost analysis that the original purchase was allocated to. | see example ref 13 on payments tab | ||
| b | Transfers between cash and bank accounts | DO NOT USE ANALYSIS COLUMNS FOR TRANSFERS TO OR FROM CASH OR ANY OTHER BANK ACCOUNTS. Read 5b here. |
|
| Transfers between cash and/or bank accounts need to be recorded on a single row as + (plus) and - (minus) entriesin columns I, J, Kas 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. |
see examples ref 2, 5, 14 and 15 on receipts tab |
||
| If your Shed is a new CIO preparing accounts for the frst @me any transfer received from the bank account of a former unincorporated Men's Shed associa@onIS NOT a transfer between accountsand should be entered as the receipt of a dona@on from the unincorporated associa@on. If this is the case see theConver+ng to a CIOtab for explana@on. |
see example ref 1 on receipts tab showing transfer of funds into new CIO as a dona@on |
||
| c | Restricted Funds | ||
| If any receipt or payment relates to restricted funds put a Y in column G. It is important to iden@fy restricted items because unrestricted and restricted funds must be disclosed separately in the accounts. You also need to be able to show restricted funds have been spent appropriately. |
see examples ref 6 on receipts tab and ref 4 on payments tab |
||
| d | Transfers between unrestricted and restricted funds | ||
| Restricted funds should never be nega@ve and should be replaced by unrestricted funds if necessary. | |||
| 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. Unrestricted funds may however be transferred to restricted funds, for example to support a capital purchase part funded by a restricted grant. |
A transfer from unrestricted funds to restricted funds is much easier than trying to account for an asset split across 2 funds. |
||
| Transfers between unrestricted and restricted funds can be shown on theShed Accountsat row 48 "transfers between funds". Any such transfer should be shown as a posi@ve (+) in the fund receiving the transfer and a nega@ve (-) in the fund making the transfer. |
|||
| TheShed Accountswill automa@cally show a transfer to restricted funds from unrestricted funds if required. You can however overwrite this balancing calcula@on if you wish to restrict more funds than required. |
|||
| e | Endowment Funds | ||
| 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 have endowment funds and accordingly this cashbook DOES NOT provide for them. |
If you have Endowment funds contact UKMSA for advice. |
||
| f | Accoun+ng for other assets and liabili+es | ||
| At the end of the fnancial year/period a statement of assets and liabili@es must also be prepared. For most Men’s Sheds we would expect to see some tools and equipment. You can es@mate the value, there is no need to prepare a detailed valua@on. If there are any unpaid bills or expenses the total amount should be disclosed, you do not need to list every unpaid item. |
NOTE:This is not the same as a balance sheet |
||
| Please delete the example entries in columns B to K (both Receipts and Payments) before entering your own transac@ons. Columns L onwards are formulae and should not be deleted. |
2
Save your cash book spreadsheet with a new name, e.g. Your Men's Sheds Accounts 2020.xlsx to preserve this copy with the example entries.
Use a new spreadsheet for each accoun@ng period/year. Save a final copy at the period/year end, enter closing balances and compara@ve figures on the Set Up tab of 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 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 or CIC) will have to prepare annual accounts using a different accounts template which include assets and liabili@es and a balance sheet.
Rounding errors : It is possible that the final accounts, shown to the nearest pound, could contain "rounding errors". This arises if the overall rounding up and rounding down is unbalanced. To fix try adding a few pence as a receipt or payment to rebalance the final accounts.
PASSWORD PROTECTION: The formulae and formadng of this template have been protected to prevent accidental dele+on. If you need to unprotect any sheet the password is UKMSA.
Version 3.50 (Beta) Sunday, January 10, 2021
Register and/or Send us Feedback
Please let us know if you are using this spreadsheet for your Shed Accounts and would like to receive no@fica@on of any updates or fixes. You can also send us feedback, good or bad, likes or dislikes and any requests for new features or updates. Just send an email to shedaccounts@ukmsa.org.uk
This is a "Beta" version which UKMSA members may choose to test. A "beta" release is a version that has been tested internally and is being tested by the wider community. It usually has fixes for bugs in the previous version, and has new features that are subject to change and need tesCng and may have their own bugs or limitaCons.
Version history
Version 1 (First dra^) Internal first dra^ not officially circulated
Version 2 (Beta) Added analysis func+onality for Restricted Funds Added Set Up tab with prior period compara@ve input op@on Fixed CC Receipts and Payments template Improved instruc@ons Added condi@onal formaJng to display warnings if accounts unbalanced or bank not reconciled Added "Conver@ng to a CIO" tab (Text of UKMSA Legal and accoun@ng considera@ons guidance) Version 2.10 (Beta) Worksheets Protected, Password: UKMSA Bug fixed in error repor@ng. ABS func@on used to prevent compensa@ng errors repor@ng 0 (no error).
Version 3.00 (Beta) Modified Charity Accounts template for Scodsh and Northern Irish Chari+es Added compara@ve column to Statement of Assets and Liabili@es and Added Notes to the Accounts for ScoJsh Chari@es (Op@onal for others) Compara@ve dates on set up tab corrected Error repor@ng on CC Accounts improved Improved instruc@ons Op@on to rename bank accounts added on Set Up tab Added Shed Assets tab and instruc@ons about repor@ng assets and liabili@es at the period end Version 3.10 (Beta) Minor edits follow peer review sugges@ons Added links to charity regulator's receipts and payments accounts packs Fixed link on payments analysis columns to setup tab, was linking to previous version Changed name to Shed Accoun@ng (not all Sheds are chari@es) Version 3.20 (Beta) Rearranged payment headings on set up tab Added automa@c calcula@on for transfer between funds on Receipts and payments account Version 3.25 (Beta) Fixed totals on receipts tab for column M onwards - error arises if new row added above row 6 Allow users to add rows on receipts, payments and summary sheets when password protec@on on
Version 3.30 (Beta) Corrected formula in cell U5 on payments tab Corrected formula in cell E75 on setup tab Various comments and warnings edited/corrected Spelling checked, minor correc@ons Version 3.35 (Beta) Minor formaJng on Shed Accounts fixed Version 3.50 (Beta) 10/01/2021 Fixed cross cast error repor@ng on payments tab by adding "Round ,2" func@on to totals and to final cross check Repeated as above on Receipts tab JiC Added warning to top of Receipts and Payment analysis columns not to add an "account" such as pepy cash with a comment box of explana@on Numbered the instruc@ons above, added warning at 4 about adding addi@onal columns; these will not link to Shed Accounts without manual input Added warning at 4 and 12b NOT TO USE ANALYSIS COLUMNS FOR BANK/CASH TRANSFERS - doing so will result in transfers showing as receipts or payments Added instruc@on to Shed Accounts. Requirement to link receipts and payment rows if extra columns have been added to receipts or payments tabs Checked Shed Accounts error repor@ng fixed (row 168) Spelling checked, minor correc@ons Added version number to all pages (users have deleted instruc@on page)
Known issues
Possible rounding error on Shed Accounts Men don't read instruc@ons
3
| Shed Accoun+ng - made easy | Shed Accoun+ng - made easy | Shed Accoun+ng - made easy | Shed Accoun+ng - made easy | Shed Accoun+ng - made easy | Shed Accoun+ng - made easy | Shed Accoun+ng - made easy | ||||
|---|---|---|---|---|---|---|---|---|---|---|
| A Men's Shed Cash Book and Receipts and Payments Account template | ||||||||||
| 3 Step Set Up | Instruc+ons | |||||||||
| Step 1 | Shed details | These details will appear on theShed Accountsto iden@fy your Shed and the accoun@ng period which you are repor@ng on. |
||||||||
| Required | ||||||||||
| Your Shed Name | Dereham Men’s Shed | |||||||||
| Your Charity or CIO number | 1192142 | If you have one, unregistered chari@es can delete / leave blank. | ||||||||
| Accoun+ng start date | 01/08/2021 | Either your start date or the day immediately a^er your last accounts. | ||||||||
| Accoun+ng end date | Period or year end | 31/03/2022 | Usually a month end - your frst accounts can be for a shorter or longer period to | |||||||
| reach a convenient date (year end) of your choice. | ||||||||||
| Bank and cash accounts | Current account | Op@onal, you may name your bank account or change the descrip@ons | ||||||||
| Op@onal | Deposit account | |||||||||
| Cash | or Pepy Cash / Cash Tin | |||||||||
| Step 2 | Account Analysis | Think about why money comes in and why money goes out. You may use the suggested reasons or amend the lists to suit your own Shed. |
||||||||
| Op@onal | ||||||||||
| Receipts | There are no specifc rules about what you must include here. | |||||||||
| 1 | Membership fees | Annual subs and session fees | ||||||||
| 2 | Dona@ons | Usually unrestricted | Dona@ons include collec@ons (e.g. supermarket bag packing). | |||||||
| 3 | Grants | O^en restricted | Grants are usually restricted, but some can be for "core costs". | |||||||
| 4 | Sales / event income | Trading income | Do not included asset sales, see below. X |
|||||||
| 5 | Interest | Interest received | ||||||||
| 6 | Other | Small receipts not fJng elsewhere | Refunds for returned goods for example but see op@on below. Y |
|||||||
| 7 | Sale of assets | and/or investments | Sale of a machine or other piece of equipment previously used. X |
|||||||
| Payments | There are no specifc rules about what you must include here. | |||||||||
| 1 | Shed premises costs | Rent, light & heat etc. | All costs associated with providing the physical shed/work space. | |||||||
| 2 | Insurance | |||||||||
| 3 | Materials & consumables | Nails, screws, glue, wood | Refunds for returned items can be entered as a nega@ve number. Y |
|||||||
| 4 | Small tools (<£25) | under £25 suggested | Replacements should go to repairs and renewals below. Z |
|||||||
| 5 | Repairs and renewals | To the Shed and/or equipment | Includes replacing broken or lost small tools . Z |
|||||||
| 6 | Refreshments & cleaning | Tea, cofee and biscuits | ||||||||
| 7 | Admin/Ofce costs | Prin@ng, postage & sta@onery | Sta@onery, prin@ng, telephone, postage, computer so^ware etc. | |||||||
| 8 | Subscrip@ons | UKMSA Membership | ||||||||
| 9 | Sundry | Small items not fJng elsewhere | ||||||||
| 10 | Spare for your own use | Blank for your own use if required (op@onal). | ||||||||
| 11 | Hand and power Tools (>£25) | These rows must only be fxed assetpurchases |
used for | Fixed assets are items used and kept from year to year. Small items are o^en ignored and it is up to you to decide what £ level is small. |
||||||
| 12 | Workshopmachines | |||||||||
| Step 3 | Priorperiod fgures | DO NOT complete this if your Shed is a new CIO and the prior period fgures relate to a previous unincorporated associa+on. |
||||||||
| only required | ||||||||||
| if applicable --> | If this is your second or subsequent period complete the following. | If this is the case please see theConver+ng to a CIOtab for guidance | ||||||||
| Prior Period Accoun+ng start date | 03/11/2020 | |||||||||
| £ | ||||||||||
| Receipts | ||||||||||
| Membership fees | 240.00 | |||||||||
| Dona@ons | 2,548.23 | |||||||||
| Grants | ||||||||||
| Sales / event income | 113.00 | |||||||||
| Members refreshment and Xmas Meal | 22.00 | |||||||||
| Other | ||||||||||
| Sale of assets | ||||||||||
| Total receipts for period ended 31/07/2021 |
2,923.23 | Check this agrees to your last accounts | ||||||||
| Payments | ||||||||||
| Shed premises costs | ||||||||||
| Insurance | 157.00 | |||||||||
| Materials & consumables | 18.63 | |||||||||
| Small tools (<£25) | ||||||||||
| Repairs and renewals | ||||||||||
| Members refreshment and Xmas Meal | ||||||||||
| Admin/Ofce costs | 18.34 | |||||||||
| Subscrip@ons | 24.00 | |||||||||
| Sundry | 50.00 | |||||||||
| 0 | ||||||||||
| Hand and power Tools (>£25) | ||||||||||
| Workshop machines | ||||||||||
| Total payments for period ended 31/07/2021 |
267.97 | Check this agrees to your last accounts | ||||||||
| Surplus / (defcit) for prior period | 2,655.26 | Check this agrees to your last accounts |
1
| Current account balance at 31/07/2021 |
2,588.48 | Include the pennies | |||
| Deposit account balance at 31/07/2021 |
Include the pennies | ||||
| Cash funds held at 31/07/2021 |
66.78 | Include the pennies | |||
| Total cash funds held at 31/07/2021 |
2,655.26 | Check this agrees to your last accounts | |||
| Restricted funds held at 31/07/2021 |
|||||
| Unrestricted funds held at 31/07/2021 |
2,655.26 | Check this agrees to your last accounts | |||
| Total bank & cash funds held at 02/11/2020 |
0.00 | Total cash funds brought forward from earlier period,note the DATE | |||
| Looksgood | 0.00 | This must be blank / zero | |||
| Version 3.50 (Beta) 10/01/2021 |
2
| Dereham Men’s Shed | Dereham Men’s Shed | Dereham Men’s Shed | Dereham Men’s Shed | For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
|||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash Book Receipts | ||||||||||||||||||||||
| Receipt to | Analysis codes: Reason why money came in- DO NOT ADD other "accounts" such as "pemy cash" | |||||||||||||||||||||
| 1 2 3 4 5 6 7 |
||||||||||||||||||||||
| Ref | Date | Who received from | Why received | Analysis Code | Restricted funds |
Current account |
Deposit account |
Cash | Membership fees |
Dona@ons | Grants | Sales / event ~~income~~ |
Members Refreshments ~~and Xmas Meal~~ |
Other | Sale of assets | **Cross check ** | Error count | |||||
| 9 | 04/08/2021 | Members | Teas/cofees at Mee@ng | 5 | 9.80 | 9.80 | Looks OK | |||||||||||||||
| 10 | 09/08/2021 | K Green | Dona@on from H Myhill | 2 | 10.00 | 10.00 | Looks OK | |||||||||||||||
| 11 | 08/08/2021 | I Grix@ | Sale of Keyhooks | 4 | 10.00 | 10.00 | Looks OK | |||||||||||||||
| 12 | 11/08/2021 | K Green | Dona@on from H Myhill | 2 | 5.00 | 5.00 | Looks OK | |||||||||||||||
| 13 | 18/08/2021 | Members | Teas/cofees at Mee@ng | 5 | 22.90 | 22.90 | Looks OK | |||||||||||||||
| 14 | 18/08/2021 | EasyFundraising | Raised from internetpurchases | 2 | 54.30 | 54.30 | Looks OK | |||||||||||||||
| 15 | 21/08/2021 | I Grix@ | Sale of items from fete | 4 | 30.00 | 30.00 | Looks OK | |||||||||||||||
| 16 | 21/08/2021 | Cash from fete | Sale of items at fete | 4 | 117.50 | 117.50 | Looks OK | |||||||||||||||
| 17 | 23/08/2021 | PepyCash Banked | Transfer between cash and bank | 205.00 | -205.00 | Looks OK | ||||||||||||||||
| 18 | 25/08/2021 | Michael Walby | Membershipfee 2021 | 1 | 5.00 | 5.00 | Looks OK | |||||||||||||||
| 19 | 25/08/2021 | Members | Teas/cofees at Mee@ng | 5 | 10.50 | 10.50 | Looks OK | |||||||||||||||
| 20 | 01/09/2021 | Members | Teas/cofees at Mee@ng | 5 | 8.50 | 8.50 | Looks OK | |||||||||||||||
| 21 | 08/09/2021 | Members | Teas/cofees at Mee@ng | 5 | 7.80 | 7.80 | Looks OK | |||||||||||||||
| 22 | 16/09/2021 | Archant Community | Dona@on from coupons collected | 2 | 30.00 | 30.00 | Looks OK | |||||||||||||||
| 23 | 17/09/2021 | I Grix@ | EbaySale of books | 4 | 5.50 | 5.50 | Looks OK | |||||||||||||||
| 24 | 22/09/2020 | Members | Teas/cofees at Mee@ng | 5 | 27.00 | 27.00 | Looks OK | |||||||||||||||
| 25 | 29/09/2021 | Members | Teas/cofees at Mee@ng | 5 | 7.00 | 7.00 | Looks OK | |||||||||||||||
| 26 | 06/10/2021 | PepyCash Banked | Transfer between cash and bank | 70.00 | -70.00 | Looks OK | ||||||||||||||||
| 27 | 06/10/2021 | Bryan Thacker | Membershipfee 2021 | 1 | 5.00 | 5.00 | Looks OK | |||||||||||||||
| 28 | 06/10/2021 | Members | Teas/cofees at Mee@ng | 5 | 13.20 | 13.20 | Looks OK | |||||||||||||||
| 29 | 07/10/2021 | Beavers | Refund StompRockets Materials | 6 | 35.00 | 35.00 | Looks OK | |||||||||||||||
| 30 | 09/10/2021 | M Groome | Dona@on | 2 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 31 | 20/10/2021 | A Sharp | Membershipfee 2021 | 1 | 5.00 | 5.00 | Looks OK | |||||||||||||||
| 32 | 20/10/2021 | Members | Teas/cofees at Mee@ng | 5 | 20.90 | 20.90 | Looks OK | |||||||||||||||
| 33 | 27/10/2021 | William G | Membershipfee 2021 | 1 | 5.00 | 5.00 | Looks OK | |||||||||||||||
| 34 | 27/10/2021 | Members | Teas/cofees at Mee@ng | 5 | 10.00 | 10.00 | Looks OK | |||||||||||||||
| 35 | 04/11/2021 | EasyFundraising | Raised from internetpurchases | 2 | 46.61 | 46.61 | Looks OK | |||||||||||||||
| 36 | 08/11/2021 | T George | Xmas Lunch Deposit | 5 | 10.00 | 10.00 | Looks OK | |||||||||||||||
| 37 | 08/11/2021 | I Grix@ | Xmas Lunch Deposit | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 38 | 08/11/2021 | J Collins | Xmas Lunch Deposit | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 39 | 10/11/2021 | H Mar@n | Xmas Lunch Deposit | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 40 | 10/11/2021 | Members | Teas/cofees at Mee@ng | 5 | 26.40 | 26.40 | Looks OK | |||||||||||||||
| 41 | 12/11/2021 | S Malin | Xmas Lunch Deposit | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 42 | 14/11/2021 | T Mack | Xmas Lunch Deposit | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 43 | 15/11/2021 | R Millep | Xmas Lunch Deposit | 5 | 10.00 | 10.00 | Looks OK | |||||||||||||||
| 44 | 15/11/2021 | R Chapman | Xmas Lunch Deposit | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 45 | 17/11/2021 | Members | Teas/cofees at Mee@ng | 5 | 12.70 | 12.70 | Looks OK | |||||||||||||||
| 46 | 24/11/2021 | I Grix@ | Balance Xmas Meal | 5 | 19.90 | 19.90 | Looks OK | |||||||||||||||
| 47 | 24/11/2021 | Members | Teas/cofees at Mee@ng | 5 | 10.00 | 10.00 | Looks OK | |||||||||||||||
| 48 | 24/11/2021 | T Mack | Balance Xmas meal | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 49 | 24/11/2021 | Robin Chapman | Balance Xmas meal | 5 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 50 | 24/11/2021 | J Collins | Balance Xmas meal | 5 | 26.90 | 26.90 | Looks OK | |||||||||||||||
| 51 | 24/11/2021 | R Millep | Balance Xmas meal | 5 | 16.95 | 16.95 | Looks OK | |||||||||||||||
| 52 | 25/11/2021 | T George | Balance Xmas meal | 5 | 16.95 | 16.95 | Looks OK | |||||||||||||||
| 53 | 26/11/2021 | PepyCash Banked | Transfer between cash and bank | 215.00 | -215.00 | Looks OK | ||||||||||||||||
| 54 | 26/11/2021 | H Mar@n | Balance Xmas Meal | 5 | 53.90 | 53.90 | Looks OK | |||||||||||||||
| 55 | 28/11/2021 | S Malin | Balance Xmas Meal | 5 | 33.90 | 33.90 | Looks OK | |||||||||||||||
| 56 | 28/11/2021 | Cash from fete | Sale of items at fete | 4 | 46.00 | 46.00 | Looks OK | |||||||||||||||
| 57 | 30/11/2021 | PepyCash Banked | Transfer between cash and bank | 50.00 | -50.00 | Looks OK | ||||||||||||||||
| 58 | 01/12/2021 | Members | Teas/cofees at Mee@ng | 5 | 26.00 | 26.00 | Looks OK | |||||||||||||||
| 59 | 07/12/2021 | Patrick Moore | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 60 | 08/12/2021 | Members | Teas/cofees at Mee@ng | 5 | 21.00 | 21.00 | Looks OK | |||||||||||||||
| 61 | 08/12/2021 | Will Grierson | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 62 | 09/12/2021 | 64 Million Ar@st’s | Dona@on re UKMSA | 2 | 50.00 | 50.00 | Looks OK | |||||||||||||||
| 63 | 13/12/2021 | PepyCash Banked | Transfer between cash and bank | 55.00 | -55.00 | Looks OK | ||||||||||||||||
| 64 | 15/12/2021 | John Collins | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | |||||||||||||||
| 65 | 15/12/2021 | Members | Teas/cofees at Mee@ng | 5 | 22.10 | 22.10 | Looks OK | |||||||||||||||
| 66 | 17/12/2021 | PepyCash Banked | Transfer between cash and bank | 50.00 | -50.00 | Looks OK | ||||||||||||||||
| 67 | 22/12/2021 | Tesco | Dona@on | 2 | 200.00 | 200.00 | Looks OK | |||||||||||||||
| 68 | 01/01/2022 | Ian Grix@ | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK |
1
| 69 | 04/01/2022 | Richard Millep | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | Looks OK | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70 | 04/01/2022 | John Taylor | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 71 | 04/01/2022 | Howard Mar@n | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 72 | 04/01/2022 | Alex Sharp | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 73 | 04/01/2022 | John Pye | Membership fee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 74 | 13/02/2022 | Chris Lambert | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 75 | 14/01/2022 | Members | Teas/cofees at Mee@ng | 5 | 16.00 | 16.00 | Looks OK | ||||||||||||||||
| 76 | 14/01/2022 | Members | Membershipfee for 2022 | 1 | 140.00 | 140.00 | Looks OK | ||||||||||||||||
| 77 | 14/01/2022 | PepyCash Banked | Transfer between cash and bank | 10.00 | -10.00 | Looks OK | |||||||||||||||||
| 78 | 19/01/2022 | Members | Teas/cofees at Mee@ng | 5 | 14.00 | 14.00 | Looks OK | ||||||||||||||||
| 79 | 19/01/2022 | Members | Membershipfee for 2022 | Cofee | 25.00 | 25.00 | Looks OK | ||||||||||||||||
| 80 | 26/01/2022 | Members | Membershipfee for 2022 | 1 | 40.00 | 40.00 | Looks OK | ||||||||||||||||
| 81 | 26/01/2022 | Members | Teas/cofees at Mee@ng | 5 | 13.00 | 13.00 | Looks OK | ||||||||||||||||
| 82 | 26/01/2022 | Members | Dona@on | 2 | 12.00 | 12.00 | Looks OK | ||||||||||||||||
| 83 | 28/01/2022 | PepyCash Banked | Transfer between cash and bank | 85.00 | -85.00 | Looks OK | |||||||||||||||||
| 84 | 02/02/2022 | Members | Teas/cofees at Mee@ng | 5 | 19.25 | 19.25 | Looks OK | ||||||||||||||||
| 85 | 02/02/2022 | Robin Davis | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 86 | 04/02/2021 | PepyCash Banked | Transfer between cash and bank | 75.00 | -75.00 | Looks OK | |||||||||||||||||
| 87 | 08/02/2022 | Brian Gwinnell | Membershipfee for 2022 | 1 | 20.00 | 20.00 | Looks OK | ||||||||||||||||
| 88 | 09/02/2022 | Members | Teas/cofees at Mee@ng | 5 | 16.00 | 16.00 | Looks OK | ||||||||||||||||
| 89 | 16/02/2022 | Members | Teas/cofees at Mee@ng | 5 | 12.90 | 12.90 | Looks OK | ||||||||||||||||
| 90 | 23/02/2022 | Members | Teas/cofees at Mee@ng | 5 | 11.00 | 11.00 | Looks OK | ||||||||||||||||
| 91 | 25/02/2022 | PepyCash Banked | Transfer between cash and bank | 45.00 | -45.00 | Looks OK | |||||||||||||||||
| 92 | 02/03/2022 | Members | Teas/cofees at Mee@ng | 5 | 11.00 | 11.00 | Looks OK | ||||||||||||||||
| 93 | 09/03/2022 | Members | Teas/cofees at Mee@ng | 5 | 12.00 | 12.00 | Looks OK | ||||||||||||||||
| 94 | 09/03/2022 | K Green | Membershipfee for 2022 | 1 | 10.00 | 10.00 | Looks OK | ||||||||||||||||
| 95 | 09/03/2022 | K Green | Dona@on from visitor to DMS | 2 | 10.00 | 10.00 | Looks OK | ||||||||||||||||
| 96 | 13/03/2022 | I Grix@ | Overpayment for CDMS 16 | 6 | 0.10 | 0.10 | Looks OK | ||||||||||||||||
| 97 | 16/03/2022 | K Green | Membershipfee for 2022 | 1 | 10.00 | 10.00 | Looks OK | ||||||||||||||||
| 98 | 30/03/2022 | Members | Teas/cofees at Mee@ng | 5 | 25.00 | 25.00 | Looks OK | ||||||||||||||||
| Looks OK | |||||||||||||||||||||||
| Looks OK | |||||||||||||||||||||||
| If you need more rows add them above this row and copy formulae from below | Looks OK | ||||||||||||||||||||||
| 1,846.06 | 0.00 | 75.40 | 485.00 | 437.91 | 0.00 | 209.00 | 754.45 | 35.10 | 0.00 | Looks OK | 0 | ||||||||||||
| Iden+fed as restricted (Y in column G) | 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
||||||||||||||||||||||
| Unrestricted | 485.00 437.91 0.00 209.00 754.45 35.10 0.00 |
||||||||||||||||||||||
| DO NOT DELETE THIS LINECopy and paste if addi@onal rows are required or exis@ng ones are corrupted | |||||||||||||||||||||||
| Copyandpaste this ENTIRE row | Looks OK | ||||||||||||||||||||||
| Version 3.50(Beta)10/01/2021 | |||||||||||||||||||||||
2
| Dereham Men’s Shed | For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
For the period ended 31-Mar-22 |
||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash Book Payments | ||||||||||||||||||||||||||
| Payment From | Analysis codes: Reason why money went out -DO NOT ADD other "accounts" such as "pemy cash" | |||||||||||||||||||||||||
| 1 2 3 4 5 6 7 8 9 10 11 12 |
||||||||||||||||||||||||||
| Ref | Date | Who paid to | Why paid | Analysis Code | Restricted funds |
Current account |
Deposit account |
Cash | Shed premises costs |
Insurance | Materials & consumables |
Small tools (<£25) |
Repairs and renewals |
Members Refreshments and Xmas Meal |
Admin/ Ofce costs |
Subscrip@ons | Sundry | Adver@sing | Hand and power Tools |
Workshop machines |
Cross check | |||||
| 4 | 9/8/21 | RF Millep | CDMS 4 Materials for StompRockets | 3 | 26.21 | 26.21 | Looks OK | |||||||||||||||||||
| 5 | 18/8/21 | Paragon Internet GroupCDMS2 | CDMS 5 Website Secure Cer@fcate(SSL) | 7 | 49.99 | 49.99 | Looks OK | |||||||||||||||||||
| 6 | 18/08/2021 | RF Millep | Refund CDMS 6prin@ngcosts for leafets | 10 | 50.18 | 50.18 | Looks OK | |||||||||||||||||||
| 7 | 18/09/2021 | CAN | CDMS 8Annual Silver Membership | 8 | 50.00 | 50.00 | Looks OK | |||||||||||||||||||
| 8 | 29/9/21 | I Grix@ | CDMS 9 Refund forpurchase of the Gazebo | 9 | 219.99 | 219.99 | Looks OK | |||||||||||||||||||
| 9 | 15/11/21 | Coachmakers Pub & Kitchen | CDMS 10 Members deposit for xmas dinner | 6 | 70.00 | 70.00 | Looks OK | |||||||||||||||||||
| 10 | 25/11/21 | K Green | Reimbursed for CDMS 11 electrical items for shed | 1 | 17.81 | 17.81 | Looks OK | |||||||||||||||||||
| 11 | 30/11/21 | H Mar@n | CDMS 12 Overpayment in Balance for Xmas Meal | 6 | 20.00 | 20.00 | Looks OK | |||||||||||||||||||
| 12 | 5/12/21 | I Grix@ | Refundpayment for CDMS 13 DMS Xmas Meal | 6 | 258.30 | 258.30 | Looks OK | |||||||||||||||||||
| 13 | 6/12/21 | H Mar@n | Reimbursed for CDMS 14 electrical items for shed | 1 | 8.59 | 8.59 | Looks OK | |||||||||||||||||||
| 14 | 6/1/22 | I Grix@ | Reimbursed for CDMS 15 Titan VAC | 12 | 79.99 | 79.99 | Looks OK | |||||||||||||||||||
| 15 | 6/1/22 | I Grix@ | Reimbursed for CDMS 16 Trestle tables | 7 | 100.95 | 100.95 | Looks OK | |||||||||||||||||||
| 16 | 22/1/22 | R Millep | Reimbursed forCDMS 17 First aid Equipment | 1 | 40.02 | 40.02 | Looks OK | |||||||||||||||||||
| 17 | 16/2/22 | I Grix@ | Reimbursed for CDMS 19 PPE Equipment | 1 | 45.65 | 45.65 | Looks OK | |||||||||||||||||||
| 18 | 21/2/22 | R Millep | Reimbursed for CDMS 20 SafetyTape | 1 | 9.99 | 9.99 | Looks OK | |||||||||||||||||||
| 19 | 3/3/22 | About Dereham | Annual subscrip@on CDMS 21 | 8 | 12.00 | 12.00 | Looks OK | |||||||||||||||||||
| 20 | 30/3/22 | R Millep | Reimbursed for CDMS 22 workshopconsumables | 3 | 9.75 | 9.75 | Looks OK | |||||||||||||||||||
| 99 | Looks OK | |||||||||||||||||||||||||
| 100 | Looks OK | |||||||||||||||||||||||||
| If you need mor | e rows add them above this row and copy formulae from below | Looks OK | ||||||||||||||||||||||||
| 989.67 | 0.00 | 79.75 | 122.06 | 0.00 | 35.96 | 0.00 | 0.00 | 348.30 | 150.94 | 62.00 | 219.99 | 50.18 | 0.00 | 79.99 | Looks OK | |||||||||||
| Iden+fed as restricted (Y in column G) | 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 |
|||||||||||||||||||||||||
| Unrestricted | 122.06 0.00 35.96 0.00 0.00 348.30 150.94 62.00 219.99 50.18 0.00 79.99 |
|||||||||||||||||||||||||
| DO NOT DELETE THIS LINECopy and paste if addi@onal rows are required or exis@ng ones are corrupted | ||||||||||||||||||||||||||
| Copyandpaste this ENTIRE row | Looks OK | |||||||||||||||||||||||||
| Version 3.50(Beta)10/01/2021 | ||||||||||||||||||||||||||
1
| Dereham Men’s Shed | Dereham Men’s Shed | Dereham Men’s Shed | Dereham Men’s Shed | Dereham Men’s Shed | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash Book Summary and Reconcilia+on | You can work to any closing date of your choice during the period, e.g. month or quarter ends. |
||||||||||||
| For the period ended | 31/03/2022 | ||||||||||||
| Current account summary | £ | ||||||||||||
| Opening Balance | as at 01/08/2021 |
2,588.48 | From last year as entered onSet uptab | ||||||||||
| Receipts and net transfers | 1,846.06 | Per Column I onReceipts Tab | |||||||||||
| Payments | -989.67 | Per Column I onPayments Tab | |||||||||||
| Closing Balance | as at 31/03/2022 |
3,444.87 | Agree or reconcile this to the bank statement below | ||||||||||
| Bank Reconcilia+on | £ | ||||||||||||
| Balance per Bank Statement | on | 31/03/2022 | 3,444.87 | Enter balance from bank statement at period end date | |||||||||
| If there is a diference idenCfy the reason(s) why below | |||||||||||||
| Add Date |
Payee/ details | Slip ref | £ | ||||||||||
| List any receipts in cash book not on bank statement by period end and/or make appropriate correc@ons to entries onReceiptstab for items on bank statement. |
|||||||||||||
| 0.00 | |||||||||||||
| Less Date |
Payee/ details | Chq No. | £ | ||||||||||
| 0.00 | |||||||||||||
| Reconciled balance | 3,444.87 | ||||||||||||
| Diference | 0.00 | Looks Good | |||||||||||
| Deposit account summary | £ | ||||||||||||
| Opening Balance | 0.00 | From last year as entered onSet uptab | |||||||||||
| Net transfers from/(to) current account and other receipts (interest received) | 0.00 | Per Column J onReceipts Tab | |||||||||||
| Payments | 0.00 | Per Column I onPayments Tab | |||||||||||
| This may be nil if only payments are to current account | |||||||||||||
| Closing Balance | 0.00 | Closing balance must equal bank statement balance | |||||||||||
| Cash summary | £ | ||||||||||||
| Opening cash held | 66.78 | From last year as entered onSet uptab | |||||||||||
| Unbanked cash receipts | 75.40 | Per Column K onReceipts Tab | |||||||||||
| Cash payments | -79.75 | Per Column K onPayments Tab | |||||||||||
| Closing cash held | 62.43 | Note: Cash can not be nega@ve | |||||||||||
| Cash counted by | Ian Grix@ Treasurer | On | 31/03/2022 | 62.43 | Any diference should be inves@gated, corrected or wripen | ||||||||
| of as appropriate. | |||||||||||||
| Version 3.50(Beta)10/01/2021 |
1
| Dereham Men’s Shed | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Assets retained for the Shed’s own use | This sheet is unprotected so you can edit it to suit your own purposes. Do note however that the group headings and sub totals in column H are linked to rows 78 to 82 on theShed Accounts. |
||||||||||||
| 31/03/2022 | |||||||||||||
| Op@onal | Op@onal Op@onal |
Required | |||||||||||
| Quan+ty Unit cost |
Total cost Unit value |
Total value | |||||||||||
| £ | £ £ |
£ | |||||||||||
| Buildings | |||||||||||||
| 1 | 0.00 | 0.00 | ∞∞ | ||||||||||
| 0.00 | 0.00 | ||||||||||||
| Large items of machinery | |||||||||||||
| 1 | Band saw Value £10 DMS041 | 1 | 0.00 | 10.00 | 10.00 | UKMSA also recommends that Men's Sheds make a photographic record |
|||||||
| 2 | Performance Pillar Drill DMS026 | 1 | 0.00 | 25.00 | 25.00 | of their Shed contents which could prove helpful in the event of an insurance claim |
|||||||
| 3 | TIP DB1000 Woodwork lathe DMS028 | 1 | 0.00 | 50.00 | 50.00 | . | |||||||
| 4 | Suregrave computerised Router + components DMS045-052/055-059 | 1 | 0.00 | 100.00 | 100.00 | ||||||||
| 5 | Roland Came Vinyl Cuper + Components DMS 053 /DMS054 | 1 | 0.00 | 30.00 | 30.00 | All assets belonging to the Shed should be listed, including donated tools and equipment, and not just items actually purchased. |
|||||||
| 6 | Dewalt Chargers DMS036 &DMS038 | 2 | 0.00 | 0.00 | 0.00 | ||||||||
| 7 | ELU Chop Saw DMS040 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 8 | 0.00 | 0.00 | |||||||||||
| 9 | 0.00 | 0.00 | On the Statement of Assets and Liabili@es the "value", not original cost, of assets held should be given. This can be es@mated and recorded here using any reasonable method. These values should be reviewed and updated at least annually. |
||||||||||
| 10 | 0.00 | 0.00 | |||||||||||
| 0.00 | 215.00 | ||||||||||||
| Power tools | |||||||||||||
| 1 | Bosch Angle Grinder DMS029 | 1 | 0.00 | 5.00 | 5.00 | ||||||||
| 2 | Skil Belt Sander DMS001 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 3 | Grinders DMS003 & DMS037 | 2 | 0.00 | 5.00 | 10.00 | Large more valuable items should be listed individually, while small value items can be grouped. For example hand tools could be listed by category. |
|||||||
| 4 | Circular Saws DMS024/025//032 | 3 | 0.00 | 5.00 | 15.00 | ||||||||
| 5 | B&D detail sander DMS012 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 6 | Drills DMS015/018/034/035/060/064 | 6 | 0.00 | 5.00 | 30.00 | ||||||||
| 7 | Jigsaw DMS021/061 | 2 | 0.00 | 0.00 | 0.00 | You may wish to set a limit for individual items to be listed. UKMSA suggest this should be somewhere between £50 and £100 per item or set. |
|||||||
| 8 | Sanders DMS002/009/010/013/014/019/020/060 | 8 | 0.00 | 0.00 | 0.00 | ||||||||
| 9 | Planers DMS063/011 | 2 | 0.00 | 5.00 | 10.00 | ||||||||
| 10 | routers DMS005/016/042 | 3 | 0.00 | 5.00 | 15.00 | ||||||||
| 0.00 | 85.00 | ||||||||||||
| Hand tools | |||||||||||||
| 1 | Hand Saws, Hacksaws and knifes. Various types and sizes. | 32 | 0.00 | 0.00 | 0.00 | ||||||||
| 2 | Screwdrivers. Various sizes types and sizes. | 69 | 0.00 | 0.00 | 0.00 | ||||||||
| 3 | Hammers and Mallets. Various types and sizes. | 19 | 0.00 | 0.00 | 0.00 | ||||||||
| 4 | Chisels. Various types and sizes | 43 | 0.00 | 0.00 | 0.00 | ||||||||
| 5 | Pliers. Various types and sizes. | 33 | 0.00 | 0.00 | 0.00 | ||||||||
| 6 | Wrenches. Various types and sizes. | 6 | 0.00 | 0.00 | 0.00 | ||||||||
| 7 | Spanners - Open ended and ring. Various sizes | 67 | 0.00 | 0.00 | 0.00 | ||||||||
| 8 | Clamps. Various types and sizes. | 25 | 0.00 | 0.00 | 0.00 | ||||||||
| 9 | Sprit levels. Various lengths. | 9 | 0.00 | 0.00 | 0.00 | ||||||||
| 10 | Planes and surforms. Various types and sizes. | 18 | 0.00 | 0.00 | 0.00 | ||||||||
| 0.00 | 0.00 | ||||||||||||
| Other assets | |||||||||||||
| 1 | Wooden Bench Horses | 5 | 0.00 | 0.00 | 0.00 | ||||||||
| 2 | 6” Metal ruler, engineers square, Internal and external Calipers, Dividers | 5 | 0.00 | 0.00 | 0.00 | ||||||||
| 3 | Dovetail joint rig | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 4 | Fixed Wall heaters DMS067 and DMS068 | 2 | 40.00 | 40.00 | 80.00 | ||||||||
| 5 | Titan wet & dry Vacuum Cleaner DMS065 | 1 | 79.99 | 79.99 | 79.99 | ||||||||
| 6 | Portable, Engineer and woodworking Vices, Engineers instrument cabinet | 4 | 0.00 | 0.00 | 0.00 | ||||||||
| 7 | Gazebo | 1 | 0.00 | 219.99 | 219.99 | ||||||||
| 8 | Can@lever box of taps, dies and drill bits | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 9 | Handheld Vacuum DMS062 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 10 | Sash Cramps | 3 | 0.00 | 0.00 | 0.00 | ||||||||
| 11 | Philips Vacuum DMS027 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 12 | Folding Trestle tables cost £47.95 each | 2 | 95.90 | 47.95 | 95.90 | ||||||||
| 13 | Burgess Engraver DMS030 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 14 | Glue Gun DMS033 | 1 | 0.00 | 0.00 | 0.00 | ||||||||
| 15 | Soldering Irons DMS007/008/022/023 | 4 | 0.00 | 0.00 | 0.00 | ||||||||
| 215.89 | 475.88 | ||||||||||||
| Total cost and value | 215.89 | 775.88 | |||||||||||
| Version 3.50 (Beta) 10/01/2021 | |||||||||||||
1
| Member | Dereham Men’s Shed | 1192142 | CC16a | All looks OK | |||||||||
| Prior year appears balanced which is good | |||||||||||||
| Receipts and payments accounts | The current account is reconciled which is good | ||||||||||||
For the period from |
Period start date |
To |
Period end date |
There is a posi+ve cash balance which is good | |||||||||
| 01/08/2021 | 31/03/2022 | The accounts appear balanced which is good | |||||||||||
| All receipts have been analysed which is good | |||||||||||||
| Section A Receipts andpayments | All payments have been analysed which is good | ||||||||||||
| Unrestricted funds |
Restricted funds |
Total funds | Last year | There is a posi+ve or nil balance on restricted funds which is good |
|||||||||
| to the nearest £ | to the nearest £ | to the nearest £ | to the nearest £ | Remember to review the accounts to make sure they make sense | |||||||||
| Receipts | |||||||||||||
| Membership fees | 485 | 0 | 485 | 240 | The Rows here are per the columns on thereceiptstab | ||||||||
| Donations | 438 | 0 | 438 | 2,548 | These can be changed to suit your Shed on thesetuptab | ||||||||
| Grants | 0 | 0 | 0 | 0 | If you have added anynewcolumns to the receipts tab you will need to link them to here by either adding new rows or edi@ng the exis@ng formulae |
||||||||
| Sales / event income | 209 | 0 | 209 | 113 | |||||||||
| Members Refreshments and Xmas Meal | 754 | 0 | 754 | 22 | |||||||||
| Other | 35 | 0 | 35 | 0 | |||||||||
| Sub total (Gross income for AR) | 1,921 | 0 | 1,921 | 2,923 | Automa@c calcula@on | ||||||||
| Asset and investment sales | |||||||||||||
| Sale of assets | 0 | 0 | 0 | 0 | Will auto correct if next row used | ||||||||
| Sale of investments | 0 | 0 | 0 | 0 | Sale of any investments will require manual entry to complete | ||||||||
| Sub total | 0 | 0 | 0 | 0 | Automa@c calcula@on | ||||||||
| Total receipts | 1,921 | 0 | 1,921 | 2,923 | Automa@c calcula@on | ||||||||
| Payments | |||||||||||||
| Shed premises costs | 122 | 0 | 122 | 0 | The Rows here are per the columns on thepaymentstab | ||||||||
| Insurance | 0 | 0 | 0 | 157 | These can be changed to suit your Shed on thesetuptab | ||||||||
| Materials & consumables | 36 | 0 | 36 | 19 | If you have added anynewcolumns to the payments tab you will need to link them to here by either adding new rows or edi@ng the exis@ng formulae |
||||||||
| Small tools (<£25) | 0 | 0 | 0 | 0 | |||||||||
| Repairs and renewals | 0 | 0 | 0 | 0 | |||||||||
| Members Refreshments and Xmas Meal | 348 | 0 | 348 | 0 | |||||||||
| Admin/Office costs | 151 | 0 | 151 | 18 | |||||||||
| Subscriptions | 62 | 0 | 62 | 24 | |||||||||
| Sundry | 220 | 0 | 220 | 50 | |||||||||
| Advertising | 50 | 0 | 50 | 0 | |||||||||
| Sub total | 989 | 0 | 989 | 268 | Automa@c calcula@on | ||||||||
| Asset and investment purchases | |||||||||||||
| Hand and power Tools (>£25) | 0 | 0 | 0 | 0 | Column V on payments tab | ||||||||
| Workshop machines | 80 | 0 | 80 | 0 | Column W on payments tab | ||||||||
| Sub total | 80 | 0 | 80 | 0 | |||||||||
| Total payments | 1,069 | 0 | 1,069 | 268 | Automa@c calcula@on | ||||||||
| Net of receipts/(payments) | 852 | 0 | 852 | 2,655 | Automa@c calcula@on | ||||||||
| Transfers between funds | 0 | 0 | Automa@c calcula@on -can be manually overwripen in cell H48 | ||||||||||
| Cash funds last year end | 2,655 | 0 | 2,655 | 0 | From Set Up tab | ||||||||
| Cash funds this year end | 3,507 | 0 | 3,507 | 2,655 | Automa@c calcula@on | ||||||||
| Section B Statement of assets and liabilities at the end of the period | NOTE: This is not the same as a Balance Sheet | ||||||||||||
| Categories | Only the cash funds need to balance | ||||||||||||
| Unrestricted funds |
Restricted funds |
Total current Period |
Last year | ||||||||||
| Cash funds | to nearest £ | to nearest £ | to the nearest £ | to the nearest £ | |||||||||
| Current account | 3,445 | 0 | 3,445 | 2,588 | Funds on deposit will be allocated to restricted funds frst, | ||||||||
| Deposit account | 0 | 0 | 0 | 0 | this can be changed by dele@ng the entry in cell H57 | ||||||||
| Cash | 62 | 62 | 67 | ||||||||||
| Total cash funds | 3,507 | 0 | 3,507 | 2,655 | |||||||||
| (agree balances with receipts and payments account(s)) |
OK | OK | OK | OK | NOTE the OKs- they indicate that the numbers are balanced and agree to the Receipts and Payments account above. |
||||||||
| Other monetary assets | These sec+ons require manual entry | ||||||||||||
| Stocks/goods for sale | 0 | Monetary assets means something that will be converted | |||||||||||
| Debtors | 0 | into money for example: | |||||||||||
| 0 | Stock or Goods for resale and/or | ||||||||||||
| 0 | Debtors (someone who owes you money) | ||||||||||||
| 0 | AND it is more likely than not that you will receive payment | ||||||||||||
| 0 | 0 | Automa@c calcula@on | |||||||||||
| Investment assets | |||||||||||||
| 0 | Unlikely that you will have any investments | ||||||||||||
| 0 | |||||||||||||
| 0 | |||||||||||||
| 0 | |||||||||||||
| 0 | |||||||||||||
| 0 | |||||||||||||
| 0 | 0 | Automa@c calcula@on |
1
| Assets retained for the Shed’s own use |
Assets retained for the Shed’s own use |
|||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Es+mate the VALUE of assets which belong to your Shed. | ||||||||||||||
| Buildings | 0 | 0 | You can either use theShed Assetstab to keep a record of the tools and machines you have or manually overwrite the entries here with your own es@mates. |
|||||||||||
| Large items of machinery | 0 | 215 | 85 | |||||||||||
| Power tools | 0 | 85 | 70 | |||||||||||
| Hand tools | 0 | 0 | Assets purchased with restricted grants should be shown in the restricted column (Column H). |
|||||||||||
| Other assets | 376 | 100 | 476 | |||||||||||
| 776 | 155 | Automa@c calcula@on | ||||||||||||
| Liabilities | ||||||||||||||
| Trade creditors | 0 | Enter details of amounts owed to others e.g. | ||||||||||||
| Accrued expenses | 0 | Unpaid bills / trade creditors at the period end | ||||||||||||
| 0 | Totals can be given, you do not need to list every single item | |||||||||||||
| 0 | ||||||||||||||
| 0 | ||||||||||||||
| 0 | 0 | Automa@c calcula@on | ||||||||||||
| Signed by one or two trustees on behalf of all the trustees |
Signature | Print Name | Date of approval |
ADD SIGNATURE NAME(s) and DATE. PRINT the accounts. If you are required to fle these with your Charity Regulator you will need to fle a pdf copy. The fled copy does not required a physical signature but must have a signatory name and be dated. |
||||||||||
| I Grixti | I Grixti | 13/04/2022 | ||||||||||||
| J Collins | J Collins | 13/04/2022 | ||||||||||||
| Scottish Charities are also required to complete notes to | the accounts, | see Section C below | ||||||||||||
| Notes to the accounts are not required by the Charity Commissions for England and Wales and Northern Ireland, although if notes would help the reader to understand the accounts better, they should be added. |
The print area for this page is set to print sections A and B only, if you require Section C either print it separately or delete these rows and reset the print area. Select Page Layout menu tab, Print Area option. |
|||||||||||||
| The OSCR (Scottish Charity Regulator) however does appear to require the following to be completed. | ||||||||||||||
| Section C Notes to the Accounts | Guidance notes from the Scottish Charity Regulator | |||||||||||||
| C1 Nature and purpose of funds(may be stated on analysis of funds worksheets) |
The nature and purpose of the different funds held by the charity, including any restrictions on their use. UKMSA note:If you have restricted funds explain why; where did the funds come from? what are they for? And confirm what you have done with them. If there are any restricted cash funds at the year end explain what will happen to them. |
|||||||||||||
| Type of activity or project supported | Individual / institution |
Number of grants made |
£ | |||||||||||
| C2 Grants | The number and amount of any grantspaid outby the charity; the type of activity or project supported by those grants and whether they were paid out to an individual or an organisation. UKMSA note:We do expect many, if any, Men's Sheds will be awarding grants to other charities. |
|||||||||||||
| Total | - 0 |
|||||||||||||
| C3a Trustee remuneration | If no remuneration was paid during the period to any charity trustee or person connected to a trustee cross this box (otherwise complete section 3b) |
X | The amount of remuneration paid to a charity trustee or person connected to a charity trustee. The note must also state the authority under which that remuneration was paid (e.g. the provision under section 67 of the Act and a decision of the charity trustees taken at a meeting on a specified date). See Section 5 of OSCR’s Guidance for Charity Trustees. If no remuneration was paid to a charity trustee or someone connected to a charity trustee, this must be stated. UKMSA note:We would not expect any trustees to receive remuneration (payment for their services), this does not include expenses see C4a and b below. |
|||||||||||
| Authority under which paid | £ | |||||||||||||
| C3b Trustee remuneration - details |
||||||||||||||
| C4a Trustee expenses | If no expenses were paid to any charity trustee during the period then cross this box (otherwise complete section 4b) |
X | ||||||||||||
| Number of trustees |
£ | |||||||||||||
| C4b Trustee expenses - details | The total amount of expenses, if any, paid to charity trustees and the number of charity trustees receiving expenses. If no expenses were paid to charity trusteesthis must be stated. UKMSA note:Expenses are for example travel and subsistence costs anddo notinclude reimbursement for purchases made on behalf of the Shed. |
|||||||||||||
| Nature of relationship |
Nature of transaction |
Transaction amount (£) |
Balance outstanding at period end (£) |
The nature of any transactions between the charity and any charity trustee or person connected to a charity trustee (a connected person). For example, a charity trustee purchasing an asset from the charity or a charity paying a firm for services such as professional advice where a charity trustee has a substantial interest in the firm. This note must include: • the nature of the relationship • the nature and amount of the transaction • any outstanding balances at the financial year end. |
||||||||||
| C5 Transactions with trustees and connected persons |
||||||||||||||
| C6 Other information | Any further information required to reasonably assist the reader to understand the statement of accounts. UKMSA note:For example if you receive a large grant towards the year end which will be spent in the next financial period you may wish to explain that is why there appears to be a large surplus. In the following year you could then explain the large deficit arises from spending the funds provided in the previous period/year. Think about what question(s) someone reading the accounts may ask and try to answer them before they need to. |
2
| If the Charity Accounts displays a "WARNING DO NOT FILE" message above you can trace the error(s) below | |||||||
| Error source | Error | Error message | Error | Comment | |||
| £ | Loca+on tab | ||||||
| Opening balances | 0.00 | Looks OK | Set Up | ||||
| Bank reconcilia@on | 0.00 | Looks OK | Bank Summary | ||||
| Nega@ve cash | 0.00 | Looks OK | Cash Summary | ||||
| Receipts analysis | 0.00 | Looks OK | Receipts | ||||
| Payments analysis | 0.00 | Looks OK | Payments | ||||
| Restricted funds nega@ve | 0.00 | Looks OK | Restricted paymentsexceed receipts |
||||
| Error score 0.00 That's very cool WELL DONE |
Version 3.50 (Beta) 10/01/2021 | ||||||
3
----- Start of picture text -----
Conver+ng an Unincorporated Associa+on Men’s Shed to a Charitable Incorporated Organisa+on:
Legal and Accoun@ng Considera@ons
Men’s Sheds o^en start as unincorporated associa@ons (UIA) because they are quick and easy to establish. As such they are regulated and governed by the rules they
set themselves - through their own cons@tu@on.
An Unincorporated Associa@on is not a legal en@ty in its own right. It is akin to a partnership where the members are all jointly and severally liable for the debts.
As the Shed grows however the members may decide there is a need for a more formal structure and the benefits of charitable status. Whilst there are many different
legal structures to choose from, this is where many choose to become Charitable Incorporated Organisa@ons.
A Charitable Incorporated Organisa@on (CIO) is a legal en@ty which at law has a separate iden@ty from its members - which is why the members are not liable for its
debts.
The purpose of this help sheet is to explain some of the legal and accoun@ng issues which arise when the members of a Men’s Shed decide to change legal status.
Specific informa@on about the legal status and registering as CIO is giving in the UKMSA guide “Becoming a CIO”.
An UIA can not “convert” to a CIO because it is not a legal en@ty to start with. What actually happens is the UIA ceases, transfers its assets (and liabili@es) to a new CIO
and the CIO starts. This is why the new CIO will have to open a new bank account in its own name .
The accoun@ng records should follow the legal posi@on. One set of accounts are brought to a close and a new set are started. The 2 should never be mixed and separate
accounts should be prepared for each.
For a while the two bodies (UIA and CIO) will co-exist, but only one should be ac@ve.
When the members of an UIA make a decision to transfer their ac@vity and assets (and liabili@es) including the bank balance to a new CIO they will need to decide
when to do so and advise anyone using the old account details of the new account (and new CIO status).
The best advice is to pick a clear date to switch from one to the other and have everything set up in @me. There is no urgency and the new CIO can be dormant for
some @me if need be while arranging a new bank account and other mapers.
It would be good prac@ce, but not essen@al, for the UIA to clear any bills first and @dy its own affairs up. If the UIA is in the middle of some ac@vity with financial
consequences, such as a fundraising campaign, it may prefer to finish that before transferring over to the CIO. If things are simple a transfer can be done at any
convenient @me, although a month end always feels @dier.
Think of it being like a house move, choose a comple@on date and move. All furniture and possessions are transferred in a single day and therea^er you don’t return to
the old house.
The cash funds transferred is a receipt in the CIO’s accounts and should appear as a dona+on from the UIA in the first Receipts and Payments Account. Under
Receipts and Payments accoun+ng other assets, such as tools and equipment, transferred are not recorded as a dona+on. They should however be included on the
list of Shed Assets.
There is no need (if you are preparing receipts and payments accounts) to worry about who’s bill is who’s. Up to transfer date use old account, on transfer day transfer
funds (close old account) and therea^er just use the new account going forward.
If for any reason the old account remains open and receives further receipts, perhaps standing orders or grants, you can transfer the new receipts as and when
received. You should however seek to get everything paid to the new account as soon as possible and only use the new account for payments out.
The old UIA should draw up accounts for the members in accordance with its own cons+tu+on. These should show the final transfer as a dona+on to the CIO and
the accounts should then show reserves (funds) going to zero.
The new CIO must keep records and prepare accounts in accordance with the Chari@es Act. This template has been designed to help you comply with those
requirements.
Version 3.50 (Beta) 10/01/2021
----- End of picture text -----
1