|||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||**Men in Sheds**|**Haltemprice**||||**1188076**||||**WARNINGS**||
|||||||||||||**PRIOR YEAR NOT BALANCED see Set Up tab**||
||Member||**WARNING**|**DO NOT FILE**||||||**CC16a**||**The current account is reconciled which is good**||
||||**For the period**
**from**|Period start date
**1/3/2025**||**To**||Period end date
**28/2/2026**||||**There is a positive cash balance which is good**
**The accounts appear balanced which is good**||
|||||||||||||**Receipts not fully analysed**||
||**Section A Receipts and payments**|||||||||||**All payments have been analysed which is good**||
||**Receipts**|||**Unrestricted**
**funds**
**to the nearest £**||**Restricted**
**funds**
**to the nearest £**||**Total funds**
**to the nearest £**||**Last year**
**to the nearest £**||**There is a positive or nil balance on restricted funds which is**
**good**||
|||||||||||||**_Details about warnings can be found after row 160 below_**||
|||||||||||||||
||Membership fees|||3,840.00||0.00||**3,840.00**||7,475||The Rows here are per the columns on the
tab
These can be changed to suit your Shed on the
tab
**receipts**
**setup**||
||Donations|||6,272.01||0.00||**6,272.01**||2,868||||
||Grants|||3,300.00||0.00||**3,300.00**||2,500||**new**
If you have added any
columns to the receipts tab you will need to link
them to here by either adding new rows or editing the existing formulae||
||Sales / event income|||1,895.83||0.00||**1,895.83**||860||||
||Fundraising income|||503.96||0.00||**503.96**||748||||
||Room hire Inc U3A|||6,330.00||0.00||**6,330.00**||4,880||||
||**Asset and investment sales**
**Total receipts**
**Payments**
**Asset and investment purchases**
**Total payments**
**Net of receipts/(payments)**
**Cash funds last year end**
**Cash funds this year end**
Sale of assets
Sale of investments
Shed premises costs
Insurance
Materials & consumables
Small tools (<£25)
Repairs and renewals
Refreshments & cleaning
Admin/Office costs
Fundraising
Sundry
Equipment
Hand and power Tools (>£25)
Workshop machines
Transfers between funds
**_Sub total_**
**_Sub total_**
**_Sub total_**
**_Sub total_**
_(Gross income for AR)_|||**22,141.80**||**0.00**||**22,141.80**||**19,331**||Automatic calculation||
|||||||||||||||
|||||0.00||0.00||**0.00**||0.00||Will auto correct if next row used||
|||||0.00||0.00||**0.00**||0.00||Sale of any investments will require manual entry to complete||
|||||**0.00**||**0.00**||**0.00**||**0.00**||Automatic calculation||
|||||||||||||||
|||||**22,141.80**||**0.00**||**22,141.80**||**19,331.00**||Automatic calculation||
|||||||||||||||
|||||3,235.12||||**3,235.12**||8,343.37||The Rows here are per the columns on the
tab
These can be changed to suit your Shed on the
tab
**setup**
**payments**||
|||||657.68||||**657.68**||740.75||||
|||||1,117.10||||**1,117.10**||504.86||**new**
If you have added any
columns to the payments tab you will need to link
them to here by either adding new rows or editing the existing formulae||
|||||339.18||||**339.18**||127.30||||
|||||2,504.51||||**2,504.51**||3,647.26||||
|||||1,157.25||||**1,157.25**||252.82||||
|||||23.09||||**23.09**||604.11||||
|||||367.61||||**367.61**||404.72||||
|||||65.65||||**65.65**||0.00||||
|||||||||||||||
|||||1,705.20||||**1,705.20**||299.43||||
|||||**11,172.39**||**0.00**||**11,172.39**||**14,924.62**||Automatic calculation||
|||||||||||||||
|||||520.36||||**520.36**||||Column V on payments tab
Column W on payments tab||
|||||0.00||||**0.00**||1,500.00||||
|||||**520.36**||**0.00**||**520.36**||**1,500.00**||||
|||||||||||||||
|||||**11,692.75**||**0.00**||**11,692.75**||**16,424.62**||Automatic calculation||
|||||||||||||||
|||||**10,449.05**||**0.00**||**10,449.05**||**2,906.38**||Automatic calculation||
|||||0.00||0.00||||||Automatic calculation -
can be manually overwritten in cell H48||
|||||23,258.84||||**23,258.84**||20,352.46||From Set Up tab||
|||||**33,707.89**||**0.00**||**33,707.89**||**23,258.84**||Automatic calculation||
|||||||||||||||
||**Section B Statement of assets and liabilities at the end of the period**|||||||||||NOTE: This is not the same as a Balance Sheet||
||**Categories**
**Cash funds**|||**Unrestricted**
**funds**
**to nearest £**||**Restricted**
**funds**
**to nearest £**||**Total current**
**Period**
**to the nearest £**||**Last year**
**to the nearest £**||Only the cash funds need to balance||
||Co Op Bank|||**33,393.01**||**0.00**||**33,393.01**||**23,001.73**||Funds on deposit will be allocated to restricted funds first,
this can be changed by deleting the entry in cell H57||
|||||**0.00**||**0.00**||||||||
||Petty cash|||**314.88**||||**314.88**||**257.11**||||
||**Other monetary assets**
**_Total cash funds_**
(agree balances with receipts and payments
account(s))|||**33,707.89**||**0.00**||**33,707.89**||**23,258.84**||||
|||||OK||OK||OK||OK||- they indicate that the numbers are balanced and agree to the
Receipts and Payments account above.
NOTE the OKs||
|||||||||||||**These sections require manual entry**||
||Stocks/goods for sale|||||||**0.00**||||
Monetary assets means something that will be converted
into money for example:
Stock or Goods for resale and/or
Debtors (someone who owes you money)
AND it is more likely than not that you will receive payment||
||Debtors|||||||**0.00**||||||
|||||||||**0.00**||||||
|||||||||**0.00**||||||
|||||||||**0.00**||||||
||**Investment assets**|||||||0.00||0.00||Automatic calculation||
|||||||||||||||
|||||||||**0.00**||||Unlikely that you will have any investments||
|||||||||**0.00**||||||
|||||||||**0.00**||||||
|||||||||**0.00**||||||
|||||||||**0.00**||||||
||**Assets retained for the Shed’s**
**own use**|||||||0.00||0.00||Automatic calculation||
|||||||||||||||
|||||||||||||**Estimate the VALUE of assets which belong to your Shed.**||
||Buildings|||0.00||||**0.00**||||You can either use the
tab to keep a record of the tools and
machines you have or manually overwrite the entries here with your own
estimates.
**Shed Assets**
**Assets purchased with restricted grants should be shown in the restricted**
**column (Column H).**||
||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||Automatic calculation||
**----- Start of picture text -----**
Liabilities
Trade creditors 0.00 Enter details of amounts owed to others e.g.
Accrued expenses 0.00 Unpaid bills / trade creditors at the period end
0.00 Totals can be given, you do not need to list every single item
0.00
0.00
0.00 0.00 Automatic calculation
Signed by one or two trustees on Date of
behalf of all the trustees Signature Print Name approval
ADD SIGNATURE NAME(s) and DATE. PRINT the accounts. If you are
required to file these with your Charity Regulator you will need to file a pdf
copy. The filed copy does not required a physical signature but must have a
signatory name and be dated.
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 The print area for this page is set to print sections A and B only, if you
help the reader to understand the accounts better, they should be added. 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 The nature and purpose of the different funds held by the charity,
(may be stated on analysis of funds including any restrictions on their use.
worksheets) UKMSA note: funds come from? what are they for? And confirm what you have done If you have restricted funds explain why; where did the
with them. If there are any restricted cash funds at the year end
explain what will happen to them.
Individual / Number of grants
Type of activity or project supported institution made £
C2 Grants The number and amount of any grants paid out by 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 -
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
Authority under which paid £ section 67 of the Act and a decision of the charity trustees taken at a
C3b Trustee remuneration - 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
details 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.
C4a Trustee expenses If no expenses were paid to any charity trustee during the period then cross thisbox (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 trustees this must be stated.
UKMSA note: Expenses are for example travel and subsistence costs
and do not include reimbursement for purchases made on behalf of
the Shed.
relationshipNature of transactionNature of Transactionamount (£) outstanding atperiod end (£)Balance The nature of any transactions between the charity and any charitytrustee or person connected to a charity trustee (a connected person).
C5 Transactions with trustees For example, a charity trustee purchasing an asset from the charity or
a charity paying a firm for services such as professional advice where
and connected persons 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.
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.
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
£ Location tab
**----- End of picture text -----**
||Opening balances|23,258.84|The prior period/year figures are not balanced|Set Up|Double check the figures entered at Step 3 on Set Up tab|
|---|---|---|---|---|---|
||Bank reconciliation|0.00|Looks OK|Bank Summary||
||Negative cash|0.00|Looks OK|Cash Summary||
||Receipts analysis|0.00|Incomplete analysis of receipts|Receipts|Check analysis codes entered for all receipts and/or payments. You
can do this by viewing the cross check colunm (to the right of the
analysis columns) to find any marked 'error'|
||Payments analysis|0.00|Looks OK|Payments||
||Restricted funds negative|0.00|Looks OK|Restricted
exceed
payments
receipts||
||23,258.84
:( SAD FACE
**Error score**
Version 3.50 (Beta) 10/01/2021|||||