## **Trustees’ Annual Report for the period** **From: 15.04.2020 to: 05.04.2021** **Charity name: Jon Shaw Foundation** **Charity registration number: 1189073** ## **Objectives and Activities** **----- Start of picture text -----**
SORP reference
Summary of the purposes Para 1.17  To promote and protect the
of the charity as set out physical and mental health of
in its governing
young people and the families
document
of young people diagnosed
with epilepsy in the Cheshire
and West Yorkshire areas
through the provision of
financial assistance for
equipment and services not
normally provided by the
statutory authorities.
 To provide support for and
protect the mental health of
bereaved siblings in the
Cheshire and West Yorkshire
areas through provision of
financial assistance for
activities and services not
normally provided by the
statutory authorities.
 To advance the education of
the general public in all areas
relating to SUDEP through
promotion of the subject at
fundraising events and
signposting organisations
specialising in SUDEP.
Summary of the main Para 1.17 and We have donated 6 Nightwatch
1.19
activities in relation to Seizure monitor/alarm units and 1
those purposes for the anti suffocation pillow to support
public benefit, in
young people living with epilepsy.
particular, the activities,
We continue to receive applications
projects or services
for support from around England,
identified in the
accounts. when we are unable to support
because the applicant does not fall
within the criteria of the
**----- End of picture text -----**
**----- Start of picture text -----**
constitution, we signpost other
charities which can support.
We have organised “Fun in the
Forest” activity days aimed at
bereaved siblings. Made contact
with local schools and the
bereavement team at Leighton
Hospital
We have made presentations in a
primary school about the risks
associated with epilepsy, held
meetings via zoom with local health
officials and neurological team at
the University hospital in Stoke. We
are due to share our experience
with support groups organised by
the Epilepsy Team from the same
hospital.
Statement confirming Para 1.18 The Trustees have been made
whether the trustees aware of the guidance on public
have had regard to the benefit and take it into account
guidance issued by the
when making any decisions to
Charity Commission on
which the guidance is relevant.
public benefit
**----- End of picture text -----**
## **Achievements and Performance** **----- Start of picture text -----**
SORP reference
Summary of the main Our main achievements have been:
achievements of the  Improving the lives of young
charity, identifying the
people living with epilepsy
difference the charity’s Para 1.20 and their families. The
work has made to the
equipment we have been able
circumstances of its
to fund has helped to manage
beneficiaries and any
wider benefits to society seizures, particularly
as a whole. nocturnal seizures. One family
told us that because of the
monitor we had donated, her
son had been given the
correct level of anti-seizure
medication and she and the
family as a whole were able
to sleep much better knowing
that if they were needed the
monitor would alert them.
This has improved
relationships and stress levels
within the family.
 We are looking forward to our
very first activity for bereaved
**----- End of picture text -----**
siblings, we have been unable to reach out during the COVID pandemic but now we are able to organise events, the first of which is a “Fun in the Forest” day, we have a small number of siblings ready to attend, we held a taster day so are confident that the young people will have lots of fun.  We are doing very well promoting awareness of SUDEP (our 3[rd] aim) and working closely with local health officials and hospitals to encourage clinicians to discuss the risks associated with epilepsy. We have been to primary schools to discuss our experience and signposted those interested to websites containing articles about research and further information. We are also meeting with parents at support groups run by the neurological department at the University Hospital in Stoke. ## **Additional information (optional)** You may choose to include further statements where relevant about: **----- Start of picture text -----**
Achievements set against
Objectives 1 and 3 are being met,
Achievements against Para 1.41 our 2 [nd] objective, to support
objectives set bereaved siblings has been affected
negatively by the continued lock
downs, but we are now able to
organise support.
We have secured a small amount of
regular income through a weekly
Performance of lottery, and we have been fortunate
fundraising activities Para 1.41
to have a supporter who donates a
against objectives set
monthly amount. Other funds come
from one off fundraisers which we
try to organise once per month.
These have largely been online
raffles, again, due to lock down
**----- End of picture text -----**
restrictions, however we have had the support of local schools who have organised events to raise a substantial amount. Our target is to hold 3 large fundraising events per year and smaller events each month for example pub quiz, bingo and race nights. ## **Financial Review** **----- Start of picture text -----**
Review of the charity’s Para 1.21 We have received £7,657 from
financial position at the donations. We have received £10,690
end of the period from fundraising events. We have
received £6,052 from on-line
fundraising.
Received total: £24,399
We have paid out £4,429 on life-saving
equipment, including monitors. We
have paid out £2,285 on fundraising
events (including deposits and disco
for the’ Black Tie’ dinner). We have
paid out £781 for promotion and
advertising materials.
Payment total: £7,495
Total current balance: £16,690
Statement explaining the Para 1.22 In the event that we have no income
policy for holding we can pay essential insurance and
reserves stating why they have a small fund to re-start
are held fundraising.
Amount of reserves held Para 1.22 £1000
Reasons for holding zero Para 1.22 N/A
reserves
Details of fund materially Para 1.24 N/A
in deficit
Explanation of any Para 1.23 N/A
uncertainties about the
charity continuing as a
going concern
**----- End of picture text -----**
## **Additional information (optional)** You may choose to include further statements where relevant about: **----- Start of picture text -----**
Our principal sources of funds
(making over £100) for the year
The charity’s principal 2020 – 2021 were:
sources of funds Para 1.47
Monthly donation = £440
(including any
One-off donations = £7,218
fundraising)
Weekly Lottery = £633
Fundraising events = £10,750
PayPal = £220
Just Giving = £4,921
Investment policy and Reserve funds to be invested in an
objectives including any easy access account.
social investment policy
adopted Para 1.46
A description of the Inadequate funds to achieve our
principal risks facing the objectives.
charity Para 1.46 Lack of regular income, and
disruption of fundraising activities.
**----- End of picture text -----**
## **Structure, Governance and Management** **----- Start of picture text -----**
Description of charity’s N/A
trusts:
Type of governing Para 1.25 Constitution
document
(trust deed, royal
charter)
How is the charity Para 1.25 CIO
constituted?
(e.g unincorporated
association, CIO)
Trustee selection Para 1.25 Apart from the first charity
methods including details
trustees, every trustee must be
of any constitutional
appointed for a term of three years
provisions e.g. election to
post or name of any by a resolution passed at a properly
person or body entitled convened meeting of the charity
to appoint one or more trustees.
trustees
In selecting individuals for
appointment as charity trustees,
the charity trustees must have
regard to the skills, knowledge and
experience needed for the effective
administration of the CIO.
**----- End of picture text -----**
## **Additional information (optional)** **----- Start of picture text -----**
You may choose to include further statements where relevant about:
We have a welcome pack for new
trustees, including
Policies and procedures An introduction to the Foundation,
adopted for the induction Para 1.51 Outline of main duties of trustees
and training of trustees
Declaration of eligibility
Further information pertinent to JSF.
Currently 7 Trustees, including
Chair, Treasurer and 5 trustees.
The charity’s
organisational structure Para 1.51
Increasing to 11 Trustees, 7 in
and any wider network
Cheshire, 4 in Yorkshire
with which the charity
There will be 2 x sub committees,
works
One will oversee and develop Risk
Management / Register
One will oversee Finance, including
fundraising.
We work closely with Peter Doody
Foundation, and Hope for Paediatric
Epilepsy if we cannot support a
request, we will refer it on.
We work with ‘Head Into The Wild’,
which provides Forest Schools
**----- End of picture text -----**
Relationship with any Para 1.51 related parties activity days for our bereaved siblings. We work with NightWatch Epilepsy Monitor suppliers. ## **Reference and Administrative details** Charity name Jon Shaw Foundation Other name the charity N/A uses Registered charity 118907 number Charity’s principal 301 Stoneley Road address Crewe Cheshire CW1 4NE ## **Names of the charity trustees who manage the charity** **----- Start of picture text -----**
Name of person (or
Dates acted if not
Trustee name Office (if any) body) entitled to
for whole year
appoint trustee (if any)
1 Wendy Shaw Chair Whole year
2 Naomi Obrien Treasurer Whole year
Christopher None Whole year
3
Maloney
4 Nikki Lawton Safeguarding Whole year
5 Sharon Shaw Whole year
6 Matthew Shaw Whole year
7 Rosalind Hall Whole year
8
9
10
**----- End of picture text -----**
## **Funds held as custodian trustees on behalf of others** Description of the assets held in this capacity N/A Name and objects of the charity on whose behalf the assets are N/A held and how this falls within the custodian charity’s objects Details of arrangements for safe custody and segregation of such N/A assets from the charity’s own assets ## **Declarations** **The trustees declare that they have approved the trustees’ report above.** **Signed on behalf of the charity’s trustees** **Signature(s) Full name(s) Position (eg** Chair Treasurer **Secretary, Chair, etc)** **Date** **A Simple Accounts Spreadsheet** for Small Charities and Voluntary Organisations ## **Jon Shaw Foundation** # **Receipts & Payments Accounts For the Financial Year Ending 5 April 2021** **Copyright © 2012-20 Small Charity Support** All copyright and intellectual property rights reserved. This spreadsheet is **NOT** in the public domain However, small charities and other voluntary organisations are invited to request permission to use this spreadsheet free of charge. Please write to SASfSC@smallcharitysupport.uk This spreadsheet is made available "as is" with no warranties, express or implied about its completeness, or accuracy or fit-for-purpose. Anyone using this spreadsheet must take all appropriate steps to satisfy themselves that it will be suitable for their needs. **Bank Transactions, FYE: Apr 5, 21** ## **Jon Shaw Foundation** |**_Date_**|**_Category_**|**_Payee_**|**_Comment_**|**_Amount_**
**_R'd_**|**_Balance_**| |---|---|---|---|---|---| |**Apr 5, 20**||||**Brought Forward**|**0.00**| |Jan 3, 20|_R1-Donations||Bank account handover|540.00|540.00| |Jan 3, 20|_R2-Shorts Challenge|||156.00|696.00| |Jan 8, 20|_R2-80'Disco||Tickets|40.00|736.00| |Jan 11, 20|_R2-80'Disco||Tickets|100.00|836.00| |Jan 14, 20|_R2-80'Disco||Tickets|122.00|958.00| |Jan 21, 20|_R2-80'Disco||Tickets|220.00|1,178.00| |Jan 25, 20|_R2-80'Disco||Tickets|20.00|1,198.00| |Jan 25, 20|_R2-80'Disco||Tickets|50.00|1,248.00| |Jan 31, 20|_R2-80'Disco||Tickets|180.00|1,428.00| |Feb 6, 20|_R2-80'Disco||Tickets|20.00|1,448.00| |Feb 12, 20|_R2-80'Disco||Tickets|10.00|1,458.00| |Feb 20, 20|_R2-80'Disco||Tickets|20.00|1,478.00| |Feb 20, 20|_R2-80'Disco||Tickets|40.00|1,518.00| |Feb 25, 20|_R2 Quiz night||The White Lion|255.00|1,773.00| |Mar 2, 20|_R2-80'Disco||Tickets|20.00|1,793.00| |Mar 2, 20|_R2-80'Disco||Tickets|30.00|1,823.00| |Mar 3, 20|_R2-80'Disco||Tickets|20.00|1,843.00| |Mar 7, 20|_P1F-80's Disco||Caterer|-600.00|1,243.00| |Mar 10, 20|_R1-Donations||Arriva train|240.00|1,483.00| |Mar 11, 20|_R2-80'Disco||Tickets|10.00|1,493.00| |Mar 16, 20|_R2-80'Disco||Tickets|100.00|1,593.00| |Mar 16, 20|_R2-80'Disco||Rafe, on the door, and donations|1,340.00|2,933.00| |Mar 16, 20|_R2-80'Disco|||500.00|3,433.00| |Mar 23, 20|_R2-80'Disco||Crewe Alex Shirt|54.00|3,487.00| |Mar 30, 20|_R2- Mothers day Rafe||Rafe|5.00|3,492.00| |Apr 2, 20|_R2- Mothers day Rafe|||150.00|3,642.00| |Apr 3, 20|_R1-Donations|N H Mitchell|N H Mitchell|250.00|3,892.00| |Apr 8, 20|_R2 Easter Rafe|||10.05|3,902.05| |Apr 8, 20|_R1-T Shirts||Paypal code 3845|0.01|3,902.06| |Apr 8, 20|_R1-T Shirts||Paypal: PPWDL4KAJ22242DKUE|94.95|3,997.01| |Apr 20, 20|_R1-Donations|K Mullen|K Mullen|1,000.00|4,997.01| |May 1, 20|_R2 Easter Rafe||Rafe|40.00|5,037.01| |May 1, 20|_R1-T Shirts||Paypal: PPWDL4KAJ22262CC8G|134.81|5,171.82| |May 2, 20|_R1-Reccuring donation|N H Mitchell|N H Mitchell|30.00|5,201.82| |May 15, 20|_R1-T Shirts|S&J Holt|T Shirt|10.00|5,211.82| |May 15, 20|_R1-T Shirts|PM Shaw|T Shirt|20.00|5,231.82| |May 27, 20|_R2-Black tie|B Gilligan|Dinner Ticket Deposit|100.00|5,331.82| |May 28, 20|_R2-Black tie|Mark and Jenna|Dinner Ticket Deposit|80.00|5,411.82| |May 29, 20|_R2-Black tie|SA Shaw|2x Dinner tickets Full|80.00|5,491.82| |May 30, 20|_R2-Black tie|L Picken|Dinner Ticket Deposit|40.00|5,531.82| |May 30, 20|_R2-Black tie|W Shaw|Dinner Ticket Deposit|60.00|5,591.82| |May 31, 20|_R2-Black tie|N O'Brien|Dinner Ticket Deposit|100.00|5,691.82| |Jun 2, 20|_R4G-Just Giving||Break down in Folder|197.89|5,889.71| |Jun 2, 20|_R2-Black tie|W Shaw|Dinner Ticket Deposit|20.00|5,909.71| Copyright © 2012 BigSoc Support. All rights reserved |Jun 3, 20|_R1-Reccuring donation|NH Mitchell|Monthly payment|30.00|5,939.71| |---|---|---|---|---|---| |Jun 3, 20|_R1-Donations|W Shaw|Crowdfunding|1,167.39|7,107.10| |Jun 3, 20|_R2-Black tie|David Craig Jackson|2x Dinner tickets Full|80.00|7,187.10| |Jun 3, 20|_R2-Black tie|W Shaw|Dinner Ticket Deposit (Roz & Billie)|20.00|7,207.10| |Jun 4, 20|_R2-Black tie|L Picken|Dinner Ticket Deposit|20.00|7,227.10| |Jun 7, 20|_R2-Black tie|J Garratt|Bluebells forist|90.00|7,317.10| |Jun 7, 20|_R2-Black tie|Lorraine Wilby|Dinner Ticket Deposit|30.00|7,347.10| |Jun 8, 20|_R4G-Just Giving|JSF|Break down in Folder|328.72|7,675.82| |Jun 8, 20|_R1-Donations|Paypal|Sarah Louise Marathon|52.20|7,728.02| |Jun 8, 20|_R2-Black tie|Lynn Smalley|Dinner Ticket Deposit|60.00|7,788.02| |Jun 8, 20|_R1-Donations|W Shaw|Donation/ Balloons|50.00|7,838.02| |Jun 8, 20|_P1O-Balloons|N O'Brien|Fundraising Balloons|-96.00|7,742.02| |Jun 8, 20|_R2-Black tie|Karen Marie Frost|Dinner Ticket Deposit|10.00|7,752.02| |Jun 8, 20|_R2-Black tie|S & H Lawton|Dinner Ticket Deposit|20.00|7,772.02| |Jun 9, 20|_P1F-Black Tie Dinner|N O'Brien|Crewe Hall Deposit|-1,020.00|6,752.02| |Jun 9, 20|_R2-Black tie|W Shaw|Dinner Ticket Deposit|20.00|6,772.02| |Jun 10, 20|_R2-Black tie|Fagan-Dyson|Dinner Ticket Deposit|20.00|6,792.02| |Jun 10, 20|_R2-Black tie|G King|Dinner Ticket Deposit|40.00|6,832.02| |Jun 12, 20|_R2-Black tie|G King|Dinner Ticket Deposit|40.00|6,872.02| |Jun 12, 20|_R2-Black tie|G King|Dinner Ticket Deposit|20.00|6,892.02| |Jun 12, 20|_R2-Black tie|Rachel Astbury|Dinner Ticket Deposit|10.00|6,902.02| |Jun 12, 20|_R2-Black tie|Cash deposit|Dinner Ticket Deposit|40.00|6,942.02| |Jun 13, 20|_R2-Black tie|FB Smith|Dinner Ticket Deposit|40.00|6,982.02| |Jun 14, 20|_P1F-Black Tie Dinner|N O'Brien|50% Disco Deposit|-125.00|6,857.02| |Jun 15, 20|_R1-Donations||Cash deposit|110.00|6,967.02| |Jun 15, 20|_R4G-Just Giving||Break down in Folder|508.12|7,475.14| |Jun 15, 20|_R2-Black tie|CM Giles|Dinner Ticket Deposit|130.00|7,605.14| |Jun 18, 20|_R2-Black tie|C & JL Stubbs|Dinner Ticket Deposit|20.00|7,625.14| |Jun 18, 20|_R2-Black tie|Clayton-Barker|Dinner Ticket Deposit|40.00|7,665.14| |Jun 19, 20|_R2-Black tie|CM Giles|Dinner Ticket Deposit|10.00|7,675.14| |Jun 22, 20|_R2-Black tie|R Thomas|Dinner Ticket Deposit|10.00|7,685.14| |Jun 22, 20|_R2-Black tie|GC King|Dinner Ticket Deposit|20.00|7,705.14| |Jun 22, 20|_R2-Black tie|Haydon Tunney|Dinner Ticket Deposit|20.00|7,725.14| |Jun 22, 20|_R2-Black tie|SL Scott|Dinner Ticket Deposit|30.00|7,755.14| |Jun 22, 20|_R4G-Just Giving||Break down in Folder|324.57|8,079.71| |Jun 23, 20|_R2-Black tie|PJ Appleton|Dinner Ticket Deposit|80.00|8,159.71| |Jun 24, 20|_R2-Black tie|Lorraine Wilby (Matt)|Dinner Ticket Deposit|10.00|8,169.71| |Jun 24, 20|_R2-Black tie|Linda Coates|Dinner Ticket Deposit|20.00|8,189.71| |Jun 25, 20|_R2-Black tie|N H Mitchell|Monthly payment|80.00|8,269.71| |Jun 26, 20|_R2-Black tie|Wendy Ann Shaw|Dinner Ticket Deposit|10.00|8,279.71| |Jun 26, 20|_R2-Black tie|L Birch|Dinner Ticket Deposit|10.00|8,289.71| |Jun 26, 20|_R2-Black tie|Edward Whalley|2x Dinner tickets Full|80.00|8,369.71| |Jun 26, 20|_R4G-Just Giving||Break down in Folder|135.33|8,505.04| |Jun 27, 20|_R2-Black tie|AJ Whitehead|Dinner Ticket Deposit|20.00|8,525.04| |Jul 2, 20|_R2-Black tie|CJ Tizard|Dinner Ticket Deposit|40.00|8,565.04| |Jul 2, 20|_R1-Reccuring donation|N H Mitchell|Monthly payment|50.00|8,615.04| |Jul 3, 20|_R1-Donations|W Shaw||28.00|8,643.04| |Jul 3, 20|_P1T-T shirts|W Shaw|JSF Run|-410.60|8,232.44| |Jul 6, 20|_R4G-Just Giving||Break down in Folder|138.81|8,371.25| Copyright © 2012 BigSoc Support. All rights reserved |Jul 13, 20
_R4G-Just Giving
Jul 16, 20
_R2-Black tie
Lorraine Wilby
Jul 17, 20
_R2-Black tie
Keiran O'Gorman
Jul 17, 20
_R1-Donations
Round Table
Jul 20, 20
_P1F-Black Tie Dinner
Ernest Jones
Jul 20, 20
_P1F-Black Tie Dinner
Ernest Jones
Jul 20, 20
_P1F-Black Tie Dinner
Ernest Jones
Jul 22, 20
_R4G-Just Giving
Jul 24, 20
_R2-Black tie
Wendy Shaw
Jul 25, 20
_R2-Black tie
Chris Maloney
Jul 27, 20
_R1-T Shirts
Jul 28, 20
_R2-Black tie
Lorraine Wilby
Aug 1, 20
_R1-Reccuring donation
NH Mitchell
Aug 3, 20
_P4A-Ecclesiastical Insurance
Aug 5, 20
_R4G-Just Giving
Aug 7, 20
_R2-Black tie
Wendy Shaw
Aug 11, 20
_R4G-Just Giving
Aug 12, 20
_R2-Black tie
Wendy Shaw
Aug 13, 20
_R4G-Amazon
Aug 15, 20
_R2-Black tie
Wendy Shaw
Aug 18, 20
_R4G-Just Giving
Aug 19, 20
_P1F-Black Tie Dinner
Paul Milledge
Aug 24, 20
_R1-Donations
Rhino Security
Aug 25, 20
_R4G-Just Giving
Aug 26, 20
_R4G-Just Giving
Sep 1, 20
_P4A-Ecclesiastical Insurance
Sep 1, 20
_R4G-Just Giving
Sep 1, 20
_R1-Reccuring donation
NH Mitchell
Sep 21, 20
_R4G-Facebook
Sep 25, 20
_R4G-Just Giving
Sep 28, 20
_R1-Donations
Morning Foods
Oct 1, 20
_P4A-Ecclesiastical Insurance
Oct 1, 20
_R1-Reccuring donation
NH Mitchell
Oct 9, 20
Oct 9, 20
_P1F-Black Tie Dinner
Paul Milledge
Oct 14, 20
Oct 20, 20
_P1T-Night Monitors and equipment
Oct 23, 20
_R4G-Just Giving
Oct 26, 20
_R2-Black tie
Oct 27, 20
_P1T-Night Monitors and equipment
Oct 27, 20
_R4G-Just Giving
Nov 2, 20
_P4A-Ecclesiastical Insurance
Nov 3, 20
_R4G-Just Giving
Nov 4, 20
_P1F- Advertising and information leafets
Nov 5, 20
_R1-Reccuring donation
NH Mitchell
Nov 10, 20
_R4G-One Lottery
Nov 12, 20
_R2 Marcus Rashford shirt
K Sayer
Nov 12, 20
_R2 Christmas Rafe
D Fallon
Nov 13, 20
_R2 Christmas Rafe
CF+DM Tunney|Break down in Folder
193.57
8,564.82
90.00
8,654.82
100.00
8,754.82
For Black Tie prizes
300.00
9,054.82
Prize
-85.00
8,969.82
Prize
-102.00
8,867.82
Prize
-97.75
8,770.07
Breakdown in folder
96.30
8,866.37
Dinner ticket deposit
20.00
8,886.37
Dinner ticket deposit and shirt
20.00
8,906.37
Paypal
19.12
8,925.49
Dinner tickets
80.00
9,005.49
Monthly payment
30.00
9,035.49
Monthly direct debit
-18.43
9,017.06
Breakdown in folder
115.71
9,132.77
Dinner ticket deposit
40.00
9,172.77
Breakdown in folder
757.23
9,930.00
Dinner ticket deposit
50.00
9,980.00
Donation
5.11
9,985.11
Dinner ticket deposit
40.00
10,025.11
Breakdown in folder
130.42
10,155.53
Disco payment
-60.00
10,095.53
Rhino security
100.00
10,195.53
Breakdown in folder
102.60
10,298.13
Breakdown in folder
441.44
10,739.57
Monthly direct debit
-18.32
10,721.25
Breakdown in folder
19.22
10,740.47
Monthly payment
30.00
10,770.47
Facebook donations
97.56
10,868.03
Breakdown in folder
19.22
10,887.25
500.00
11,387.25
Monthly direct debit
-18.32
11,368.93
Monthly payment
30.00
11,398.93
Accidental card use
-20.65
11,378.28
Disco payment
-65.00
11,313.28
Money paid back in
20.65
11,333.93
-2,622.90
8,711.03
Breakdown in folder
4.75
8,715.78
TunneyCF+DM
20.00
8,735.78
-1,748.59
6,987.19
Breakdown in folder
87.49
7,074.68
Monthly direct debit
-18.32
7,056.36
Breakdown in folder
77.08
7,133.44
Nettl Hub (Wedgemoor Ltd)
-215.00
6,918.44
Monthly payment
30.00
6,948.44
21.50
6,969.94
20.00
6,989.94
20.00
7,009.94
20.00
7,029.94| |---|---| Copyright © 2012 BigSoc Support. All rights reserved |Nov 13, 20|_R2 Christmas Rafe|R Chamberlain||20.00|7,049.94| |---|---|---|---|---|---| |Nov 14, 20|_R2 Christmas Rafe|L Smalley||20.00|7,069.94| |Nov 14, 20|_R2 Christmas Rafe|GP+GL Cook||20.00|7,089.94| |Nov 14, 20|_R2 Christmas Rafe|HM Nixon||20.00|7,109.94| |Nov 15, 20|_R2 Christmas Rafe|Lorraine Wilby||20.00|7,129.94| |Nov 15, 20|_R2 Christmas Rafe|PM Shaw||40.00|7,169.94| |Nov 16, 20|_R4G-Amazon|||14.02|7,183.96| |Nov 16, 20|_R4G-Easy Fundraising|||42.50|7,226.46| |Nov 17, 20|_R2 Christmas Rafe|L Picken||20.00|7,246.46| |Nov 18, 20|_R2 Marcus Rashford shirt|David Craig Jackson||50.00|7,296.46| |Nov 18, 20|_R2 Christmas Rafe|Alec Procter||10.00|7,306.46| |Nov 19, 20|_R2 Marcus Rashford shirt|Rachelle Wilde||70.00|7,376.46| |Nov 20, 20|_R4G-Paypal|||98.75|7,475.21| |Nov 21, 20|_R2 Christmas Rafe|Wendy Shaw||60.00|7,535.21| |Nov 21, 20|_R2 Christmas Rafe|L Henshall||10.00|7,545.21| |Nov 23, 20|_R2 Marcus Rashford shirt|Naomi O'Brien||20.00|7,565.21| |Nov 24, 20|_R2-Black tie|K Sayer||20.00|7,585.21| |Nov 25, 20|_R2 Marcus Rashford shirt|Naomi O'Brien||40.00|7,625.21| |Nov 26, 20|_R2 Marcus Rashford shirt|D gregory||70.00|7,695.21| |Nov 26, 20|_R2 Marcus Rashford shirt|W Shaw|For G King|20.00|7,715.21| |Nov 26, 20|_R2 Marcus Rashford shirt|D Hilton||20.00|7,735.21| |Nov 27, 20|_R2 Marcus Rashford shirt|A Shaw||20.00|7,755.21| |Nov 28, 20|_R2 Marcus Rashford shirt|J Cowan||20.00|7,775.21| |Nov 29, 20|_R2 Marcus Rashford shirt|K Tuck||50.00|7,825.21| |Nov 30, 20|_R2 Marcus Rashford shirt|R Hall||20.00|7,845.21| |Dec 1, 20|_P4A-Ecclesiastical Insurance||Monthly direct debit|-18.32|7,826.89| |Dec 1, 20|_R2 Marcus Rashford shirt|David Craig Jackson||50.00|7,876.89| |Dec 1, 20|_R4G-Just Giving||Breakdown in folder|48.25|7,925.14| |Dec 3, 20|_R1-Reccuring donation|NH Mitchell|Monthly payment|30.00|7,955.14| |Dec 3, 20|_R4G-One Lottery|||14.40|7,969.54| |Dec 7, 20|_R2 Christmas Rafe|Rachelle Wilde||10.00|7,979.54| |Dec 7, 20|_R2 Christmas Rafe|S&J Holt||20.00|7,999.54| |Dec 7, 20|_R2 Christmas Rafe|W Shaw||100.00|8,099.54| |Dec 9, 20|_R4G-One Lottery|||153.50|8,253.04| |Dec 9, 20|_R2 Christmas Rafe|CA Gallagher||30.00|8,283.04| |Dec 9, 20|_R2-Black tie|CA Gallagher||20.00|8,303.04| |Dec 11, 20|_R1-Donations||Split proceeds from a run|125.10|8,428.14| |Dec 12, 20|_R1-Donations|Petal Power||25.00|8,453.14| |Dec 12, 20|_R2 Christmas Rafe|Naomi O'Brien||80.00|8,533.14| |Dec 14, 20|_R2 Christmas Craft Fair|Wendy Shaw||102.00|8,635.14| |Dec 14, 20|_R2 Christmas Craft Fair|Wendy Shaw||110.00|8,745.14| |Dec 14, 20|_R2 Christmas Craft Fair|Wendy Shaw||200.00|8,945.14| |Dec 15, 20|_R2 Christmas Craft Fair|Wendy Shaw||50.00|8,995.14| |Dec 15, 20|_R2 Christmas Craft Fair|Wendy Shaw||326.00|9,321.14| |Dec 15, 20|_R2 Christmas Craft Fair|Wendy Shaw||492.00|9,813.14| |Dec 17, 20|_R1-Donations|Alextra Accountant||500.00|10,313.14| |Dec 22, 20|_R4G-Just Giving|||374.06|10,687.20| |Dec 24, 20|_R4G-Just Giving|||203.00|10,890.20| |Dec 29, 20|_R1-Donations|Wendy Shaw||10.00|10,900.20| Copyright © 2012 BigSoc Support. All rights reserved |Jan 4, 21|_P4A-Ecclesiastical Insurance||Monthly direct debit|-18.32|10,881.88| |---|---|---|---|---|---| |Jan 5, 21|_R4G-One Lottery|||130.50|11,012.38| |Jan 5, 21|_R1-Donations|Wendy Shaw||10.00|11,022.38| |Jan 5, 21|_R1-Donations|Wendy Shaw|From Mike|20.00|11,042.38| |Jan 5, 21|_R4G-Just Giving|||109.22|11,151.60| |Jan 7, 21|_R1-Reccuring donation|NH Mitchell|Monthly payment|50.00|11,201.60| |Jan 8, 21|_R4G-Just Giving|||135.36|11,336.96| |Jan 11, 21|_R1-Donations|R Hall|Roz, one lottery winnings|15.12|11,352.08| |Jan 12, 21|_R4G-Just Giving|||22.55|11,374.63| |Jan 19, 21|_R2-Black tie|CA Macleod|Tickets|200.00|11,574.63| |Jan 20, 21|_R4G-Giving com|||2.37|11,577.00| |Jan 22, 21|_R4G-Paypal|||9.41|11,586.41| |Jan 26, 21|_R4G-Just Giving|||68.96|11,655.37| |Jan 27, 21|_R2-Black tie|H M Nixon||60.00|11,715.37| |Jan 29, 21|_R1-Donations|||64.77|11,780.14| |Feb 1, 21|_P4A-Ecclesiastical Insurance||Monthly direct debit|-18.32|11,761.82| |Feb 1, 21|_R1-Reccuring donation|NH Mitchell|Monthly payment|30.00|11,791.82| |Feb 2, 21|_R4G-Just Giving|||19.42|11,811.24| |Feb 2, 21|_R4G-One Lottery|||130.00|11,941.24| |Feb 8, 21|_R2-Black tie|M&R Binner|Tickets|100.00|12,041.24| |Feb 9, 21|_P1T-Night Monitors and equipment||Monitor pillow|-57.94|11,983.30| |Feb 10, 21|_R4G-Just Giving|||7.12|11,990.42| |Feb 11, 21|_R4G-Amazon|||17.99|12,008.41| |Feb 12, 21|_R2 Escape the room|CF&DM Tunney||20.00|12,028.41| |Feb 12, 21|_R2-Black tie|Karen Frost|Tickets|20.00|12,048.41| |Feb 13, 21|_R2 Escape the room|Wendy Shaw||20.00|12,068.41| |Feb 15, 21|_R2 Escape the room|Lorraine Wilby||20.00|12,088.41| |Feb 15, 21|_R2 Escape the room|Naomi O'Brien||20.00|12,108.41| |Feb 15, 21|_R2 Escape the room|SL Scott||20.00|12,128.41| |Feb 15, 21|_R2 Escape the room|Roz Hall||20.00|12,148.41| |Feb 16, 21|_P1F- Escape the Room||Payment for screens|-120.00|12,028.41| |Feb 16, 21|_R2 Escape the room|Mike Shaw||20.00|12,048.41| |Feb 17, 21|_R1-Donations|NH Mitchell||550.00|12,598.41| |Feb 18, 21|_R2 Escape the room|Wendy Shaw||60.00|12,658.41| |Feb 19, 21|_R2 Escape the room|Chris Maloney||20.00|12,678.41| |Feb 20, 21|_P1F- Escape the Room||Payment for screens|-10.00|12,668.41| |Feb 21, 21|_R2 Escape the room|PM Shaw||20.00|12,688.41| |Feb 21, 21|_R2-Black tie|PM Shaw|Tickets|80.00|12,768.41| |Feb 22, 21|_R2-Black tie|T Southward|Tickets|20.00|12,788.41| |Feb 22, 21|_R2-Black tie|Elizabeth Jones|Tickets|20.00|12,808.41| |Feb 25, 21|_R2- Mothers day Rafe|D Edwards||10.00|12,818.41| |Feb 25, 21|_R1-Donations|High Seat Limited||1,100.00|13,918.41| |Feb 26, 21|_R2 Eco racing|||131.54|14,049.95| |Feb 28, 21|_R2- Mothers day Rafe|CF and DM rafe||10.00|14,059.95| |Mar 1, 21|_P4A-Ecclesiastical Insurance||Monthly direct debit|-18.32|14,041.63| |Mar 1, 21|_R2- Mothers day Rafe|Mike Shaw||10.00|14,051.63| |Mar 1, 21|_R2- Mothers day Rafe|B and NJ Law||10.00|14,061.63| |Mar 1, 21|_R1-Reccuring donation|N H Mitchell||50.00|14,111.63| |Mar 2, 21|_R4G-Just Giving|||78.05|14,189.68| Copyright © 2012 BigSoc Support. All rights reserved |Mar|3, 21|_R4G-One Lottery|||133.00|14,322.68| |---|---|---|---|---|---|---| |Mar|3, 21|_R4G-Just Giving|||2.37|14,325.05| |Mar|3, 21|_R2 Escape the room|||20.00|14,345.05| |Mar|4, 21|_R2 Easter Rafe|||20.00|14,365.05| |Mar|4, 21|_R2 Easter Rafe|||10.00|14,375.05| |Mar|5, 21|_R2 Easter Rafe|||20.00|14,395.05| |Mar|5, 21|_R2 Easter Rafe|||10.00|14,405.05| |Mar|6, 21|_R2 Easter Rafe|||10.00|14,415.05| |Mar|7, 21|_R2 Easter Rafe|||12.00|14,427.05| |Mar|10, 21|_R4G-Just Giving|||4.74|14,431.79| |Mar|11, 21|_R4G-Paypal|||87.14|14,518.93| |Mar|16, 21|_R2 Easter Rafe|||5.00|14,523.93| |Mar|16, 21|_R2 Easter Rafe|||5.00|14,528.93| |Mar|16, 21|_R2 Easter Rafe|||5.00|14,533.93| |Mar|16, 21|_R2 Easter Rafe|||5.00|14,538.93| |Mar|16, 21|_R2 Easter Rafe|||5.00|14,543.93| |Mar|16, 21|_R2 Easter Rafe|||5.00|14,548.93| |Mar|16, 21|_R4G-One Lottery|||34.80|14,583.73| |Mar|18, 21|_R2 Easter Rafe|||2.00|14,585.73| |Mar|19, 21|_R4G-Collection bucket|||60.00|14,645.73| |Mar|19, 21|_R2 Ribbon Badges|||40.00|14,685.73| |Mar|20, 21|_R2 Easter Rafe|||2.00|14,687.73| |Mar|21, 21|_R2 Easter Rafe|||20.00|14,707.73| |Mar|22, 21|_R2 Easter Rafe|||5.00|14,712.73| |Mar|23, 21|_R2 Easter Rafe|||10.00|14,722.73| |Mar|23, 21|_R2 Easter Rafe|||5.00|14,727.73| |Mar|24, 21|_R4G-One Lottery|||15.60|14,743.33| |Mar|25, 21|_P4A-CVS payment|||-48.75|14,694.58| |Mar|25, 21|_R2 Easter Rafe|||5.00|14,699.58| |Mar|25, 21|_R2 Easter Rafe|||10.00|14,709.58| |Mar|25, 21|_R2 Easter Rafe|||5.00|14,714.58| |Mar|25, 21|_R2 Easter Rafe|||5.00|14,719.58| |Mar|27, 21|_R2 Pebble brook Sch|||345.00|15,064.58| |Mar|27, 21|_R1-Donations||Paid in with amount below|181.00|15,245.58| |Mar|27, 21|_R2 Easter Rafe||Paid in with amount above|564.00|15,809.58| |Mar|30, 21|_R4G-Just Giving|||169.39|15,978.97| |Mar|31, 21|_R4G-Easy Fundraising|||38.10|16,017.07| |Mar|31, 21|_R2 Hungerford Road School|||620.00|16,637.07| |Mar|31, 21|_R2 Ribbon Badges||Ryedale pharmacy|56.00|16,693.07| |Mar|31, 21|_R4G-Paypal|||24.39|16,717.46| |Apr|1, 21|_P4A-Ecclesiastical Insurance||Monthly direct debit|-18.32|16,699.14| |Apr|2, 21|_R1-Reccuring donation|N H Mitchell||50.00|16,749.14| |Apr|2, 21|_P1F- Advertising and information leafets|Paid by W Shaw|Charity boxes|-59.00|16,690.14| Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved Copyright © 2012 BigSoc Support. All rights reserved ## **End of Transactions** Copyright © 2012 BigSoc Support. All rights reserved **----- Start of picture text -----**
Jon Shaw Foundation Budget Report: Apr 5, 21
Prev Yr This Yr Budget to Actual To
RECEIPTS Out-turn Budget 05-Apr-21 05-Apr-21 Variance
R1-VOLUNTARY INCOME
R1-Donations 0 0 6,939 6,939
R1-Reccuring donation 0 0 440 440
R1-T Shirts 0 0 279 279
0 0 0 7,657 7,657
R2-INCOME GENERATION
R2-80'Disco 0 0 2,896 2,896
R2-Black tie 0 0 2,670 2,670
R2-Shorts Challenge 0 0 156 156
R2- Mothers day Raffle 0 0 195 195
R2 Easter Raffle 0 0 795 795
R2 Quiz night 0 0 255 255
R2 Marcus Rashford shirt 0 0 470 470
R2 Christmas Raffle 0 0 520 520
R2 Christmas Craft Fair 0 0 1,280 1,280
R2 Escape the room 0 0 260 260
R2 Eco racing 0 0 132 132
R2 Pebble brook Sch 0 0 345 345
R2 Ribbon Badges 0 0 96 96
R2 Hungerford Road School 0 0 620 620
0 0 0 10,690 10,690
R3-INVESTMENT INCOME
R3-Inserts to be ABOVE this row 0 0 0 0
0 0 0 0 0
R4-CHARITABLE INCOME
R4G-GENERAL FUNDS
R4G-Just Giving 0 0 4,921 4,921
R4G-Amazon 0 0 37 37
R4G-Facebook 0 0 98 98
R4G-One Lottery 0 0 633 633
R4G-Easy Fundraising 0 0 81 81
R4G-Paypal 0 0 220 220
R4G-Giving com 0 0 2 2
R4G-Collection bucket 0 0 60 60
0 0 0 6,052 6,052
R4R-RESTRICTED FUNDS
R4R-Inserts to be ABOVE this row 0 0 0 0
0 0 0 0 0
R9-ADVANCE RECEIPTS
R9-Inserts to be ABOVE this row 0 0 0 0
0 0 0 0 0
TOTAL RECEIPTS 0 0 0 24,399 24,399
**----- End of picture text -----**
Copyright © 2012-14 Small Charity Support. All rights reserved **Jon Shaw Foundation** **Budget Report: Apr 5, 21** **----- Start of picture text -----**
Prev Yr This Yr Budget to Actual To
PAYMENTS Out-turn Budget 05-Apr-21 05-Apr-21 Variance
P1-GENERATING FUNDS
P1F-FUNDRAISING
P1F-80's Disco 0 0 600 600
P1F-Black Tie Dinner 0 0 1,555 1,555
P1F- Escape the Room 0 0 130 130
P1F- Advertising and information leaflets 0 0 274 274
P1T-CHARITABLE TRADING
P1T-T shirts 0 0 411 411
P1T-Night Monitors and equipment 0 0 4,429 4,429
P1O-OTHER
P1O-Balloons 0 0 96 96
0 0 0 7,495 7,495
P2-CHARITABLE ACTIVITIES
P2R-RESTRICTED FUNDS
P2R-Inserts to be ABOVE this row 0 0 0 0
0 0 0 0 0
P2O-OTHER ACTIVITIES
P2O-Inserts to be ABOVE this row 0 0 0 0
0 0 0 0 0
**----- End of picture text -----**
Copyright © 2012-14 Small Charity Support. All rights reserved **----- Start of picture text -----**
Jon Shaw Foundation Budget Report: Apr 5, 21
P4-ADMINISTRATION
P4G-GOVERNANCE
P4G-Trustees Meetings 0 0 0 0
P4G-Trustees Expenses 0 0 0 0
P4G-Trustees Development 0 0 0 0
P4G-Inserts to be ABOVE this row 0 0 0 0
P4A-GENERAL ADMINISTRATION
P4A-Ecclesiastical Insurance 0 0 165 165
P4A-CVS payment 0 0 49 49
P4A-Inserts to be ABOVE this row 0 0 0 0
0 0 0 214 214
P9-ADVANCE PAYMENTS
P9-Inserts to be ABOVE this row 0 0 0 0
0 0 0 0 0
TOTAL PAYMENTS 0 0 0 7,709 7,709
NET RECEIPTS LESS PAYMENTS 0 0 0 16,690 16,690
EXCLUDING ADVANCE RECEIPTS & PAYMENTS
Total Receipts 0 0 0 24,399 24,399
Total Payments 0 0 0 7,709 7,709
Net Receipts Less Payments 0 0 0 16,690 16,690
**----- End of picture text -----**
Copyright © 2012-14 Small Charity Support. All rights reserved **----- Start of picture text -----**
Receipts & Payments Account for the Financial Year Ended 05-Apr-21
Current Financial Year, Apr'20-Apr'21 Last Year
General Designated Restricted Total Total
Funds Funds Funds
RECEIPTS £ £ £ £ £
Voluntary Income 7,657 7,657 0
Income Generation 10,690 10,690 #NAME?
Investment Income 0 0 0
Charitable Income 6,052 0 6,052 0
Advance Receipts 0 0 0
TOTAL RECEIPTS 24,399 0 24,399 #NAME?
PAYMENTS £ £ £ £ £
Costs of Generating Funds
Fundraising 2,559 2,559 0
Charitable Trading 4,840 4,840 0
Other 96 96 0
Sub-total 7,495 0 0 7,495 0
Charitable Activities
Specific Projects 0 0 0
General Activities 0 0
Sub-total 0 0 0 0 0
Support Costs
Governance 0 0 0
Administration 214 214 0
Sub-total 214 0 0 214 0
Advance Payments 0 0 0
TOTAL PAYMENTS 7,709 7,709 0 7,709 0
NET RECEIPTS-PAYMENTS 24,399 -7,709 0 16,690 #NAME?
**----- End of picture text -----**
**----- Start of picture text -----**
Statement of Cash Assets & Liabilities at 05-Apr-21
Cash Assets 06-Apr-20Bt'Fwd at in PeriodReceipts Paymentsin Period Transfersin Period 05-Apr-21Cd'Fwd at
Cash at Bank & in Hand
Petty Cash 0 0 0 0 0
Bank, Current Account 0 24,419 -7,729 0 16,690
0 24,419 -7,729 0 16,690
Outstanding Transactions
Receipts (Unreconciled Deposits) 0 0
Payments (Unpresented Cheques) 0 0
0 0
Investment/Deposit Accounts Bt'Fwd Interest Net Transfers Cd'Fwd
Bank, Deposit Account 0 0 0 0
Total Cash Assets 0 16,690
**----- End of picture text -----**
**----- Start of picture text -----**
A B C D E F G H I J K L M N O P Q R S T U V W
1 Jon Shaw Foundation Monthly Budget - FYE: 05-Apr-21 IMPORTANT
2 RECEIPTS 05-Apr-21Actual To Full YearBudget Budget to05-Apr-21 05/20 06/20 07/20 08/20 09/20 10/20 11/20 12/20 01/21 02/21 03/21 04/21 SumCheck:Year Total Do not change
3 R1-VOLUNTARY INCOME the formulae in
45 _R1-Donations_R1-Reccuring donation 6,938.58 440.00 0.00 0.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 0.000.00 OKOK the shaded cells.
6 _R1-T Shirts 278.89 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 OK
7 _R1-Set as Required or Delete-4 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 OK
8 _R1-Set as Required or Delete-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 0.00 0.00 OK
9 _R1-Set as Required or Delete-6 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 OK
10 _R1-Set as Required or Delete-7 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 OK
11 _R1-Inserts to be ABOVE this row 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 OK
12 R2-INCOME GENERATION
13 _R2-80'Disco 2,896.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 OK
14 _R2-Black tie 2,670.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 OK
15 _R2-Shorts Challenge 156.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 OK
16 _R2-21 4 21 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 OK
17 _R2- Mothers day Raffle 195.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 OK
18 _R2 Easter Raffle 795.05 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 OK
19 _R2 Quiz night 255.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 OK
20 _R2 Marcus Rashford shirt 470.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
21 _R2 Christmas Raffle 520.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 OK
22 _R2 Christmas Craft Fair 1,280.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 OK
23 _R2 Escape the room 260.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 OK
24 _R2 Eco racing 131.54 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 OK
25 _R2 Sandbach sch 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 OK
26 _R2 Pebble brook Sch 345.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 OK
27 _R2 Monks Coppenhall Sch 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 OK
28 _R2 Ribbon Badges 96.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 OK
29 _R2 Hungerford Road School 620.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 OK
30 _R2-Inserts to be ABOVE this row 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 OK
31 R3-INVESTMENT INCOME
32 _R3-Set as Required or Delete-1 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 OK
33 _R3-Set as Required or Delete-2 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 OK
34 _R3-Inserts to be ABOVE this row 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 OK
35 R4-CHARITABLE INCOME
36 R4G-GENERAL FUNDS
37 _R4G-Just Giving 4,920.96 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 OK
38 _R4G-Amazon 37.12 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 OK
39 _R4G-Facebook 97.56 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 OK
40 _R4G-One Lottery 633.30 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 OK
41 _R4G-Easy Fundraising 80.60 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 OK
42 _R4G-Paypal 219.69 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 OK
43 _R4G-Giving com 2.37 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 OK
44 _R4G-Collection bucket 60.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 OK
45 _R4G-Inserts to be ABOVE this row 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 OK
46 R4R-RESTRICTED FUNDS 0.00
47 _R4R-Set as Required or Delete-1 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 OK
48 _R4R-Set as Required or Delete-2 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 OK
49 _R4R-Set as Required or Delete-3 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 OK
50 _R4R-Set as Required or Delete-4 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 OK
51 _R4R-Inserts to be ABOVE this row 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 OK
52 R9-ADVANCE RECEIPTS
53 _R9-Set as Required or Delete-1 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 OK
54 _R9-Set as Required or Delete-2 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 OK
55 _R9-Inserts to be ABOVE this row 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 OK
56
57 PAYMENTS NOTE: Enter all payments budget figures as negative – eg: -1234.56
58 P1-GENERATING FUNDS
59 P1F-FUNDRAISING
60 _P1F-80's Disco -600.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 OK
61 _P1F-Black Tie Dinner -1,554.75 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 OK
62 _P1F-Billy Shorts 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 OK
63 _P1F-21 4 21 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 OK
64 _P1F-Mothers day raffle 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 OK
65 _P1F-Easter Raffle 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 OK
66 _P1F- Escape the Room -130.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 OK
67 _P1F- Advertising and information leaflet -274.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 OK
68
69 _P1F-Inserts to be ABOVE this row 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 OK
70 P1T-CHARITABLE TRADING
71 _P1T-T shirts -410.60 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 OK
72 _P1T-Night Monitors and equipment -4,429.43 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 OK
73 _P1T-Set as Required or Delete-3 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 OK
74 _P1T-Inserts to be ABOVE this row 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 OK
75 P1O-OTHER
76 _P1O-Balloons -96.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 OK
77 _P1O-Set as Required or Delete-2 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 OK
78 _P1O-Inserts to be ABOVE this row 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 OK
79 P2-CHARITABLE ACTIVITIES
80 P2R-RESTRICTED FUNDS
81 _P2R- 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 OK
82 _P2R- 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 OK
83 _P2R-Set as Required or Delete-3 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 OK
84 _P2R-Set as Required or Delete-4 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 OK
85 _P2R-Set as Required or Delete-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 0.00 0.00 OK
86 _P2R-Set as Required or Delete-6 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 OK
87 _P2R-Set as Required or Delete-7 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 OK
88 _P2R-Set as Required or Delete-8 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 OK
89 _P2R-Set as Required or Delete-9 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 OK
90 _P2R-Inserts to be ABOVE this row 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 OK
91 P2O-OTHER ACTIVITIES
92 _P2O-Set as Required or Delete-1 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 OK
93 _P2O-Set as Required or Delete-2 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 OK
94 _P2O-Set as Required or Delete-3 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 OK
95 _P2O-Set as Required or Delete-4 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 OK
96 _P2O-Set as Required or Delete-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 0.00 0.00 OK
97 _P2O-Set as Required or Delete-6 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 OK
98 _P2O-Set as Required or Delete-7 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 OK
99 _P2O-Set as Required or Delete-8 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 OK
100 _P2O-Set as Required or Delete-9 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 OK
101 _P2O-Inserts to be ABOVE this row 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 OK
102 P4-ADMINISTRATION
103 P4G-GOVERNANCE
104 _P4G-Trustees Meetings 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 OK
105 _P4G-Trustees Expenses 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 OK
106 _P4G-Trustees Development 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 OK
107 _P4G-Inserts to be ABOVE this row 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 OK
108 P4A-GENERAL ADMINISTRATION
109 _P4A-Ecclesiastical Insurance -164.99 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 OK
110 _P4A-CVS payment -48.75 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 OK
111 _P4A-Set as Required or Delete-3 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 OK
112 _P4A-Set as Required or Delete-4 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 OK
113 _P4A-Set as Required or Delete-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 0.00 0.00 OK
114 _P4A-Set as Required or Delete-6 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 OK
115 _P4A-Set as Required or Delete-7 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 OK
116 _P4A-Set as Required or Delete-8 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 OK
117 _P4A-Set as Required or Delete-9 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 OK
118 _P4A-Set as Required or Delete-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 OK
119 _P4A-Set as Required or Delete-11 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 OK
120 _P4A-Set as Required or Delete-12 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 OK
121 _P4A-Set as Required or Delete-13 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 OK
122 _P4A-Set as Required or Delete-14 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 OK
123 _P4A-Inserts to be ABOVE this row 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 OK
124 P9-ADVANCE PAYMENTS
125 _P9-Set as Required or Delete-1 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 OK
126 _P9-Set as Required or Delete-2 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 OK
127 _P9-Inserts to be ABOVE this row 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 OK
128 T-INTERNAL TRANSFERS
129 _Transfer To Cash 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 OK
130 _Transfer From Cash 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 OK
131 _Transfer To Deposit Account 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 OK
132 _Transfer From Deposit Account 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 OK
133 _Deposit Account Interest 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 OK
134 _Creditor-HMRC 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 OK
135 _Creditor-NEST 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 OK
136 _T-Set as Required or Delete-1 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 OK
137 _T-Inserts to be ABOVE this row 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 OK
138 OTHER TRANSACTIONS
139 _O-PFY Unreconciled 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 OK
140 _O-Liabilities 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 OK
141 _O-Other 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 OK
142 _O-Inserts to be ABOVE this row 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 OK
143 ===========================================
144
**----- End of picture text -----**
|**Jon Shaw Foundation**
**Cash Transactions, FYE: Apr 5, 21**
**_Date_**
**_Ref_**
**_Category_**
**_Fund_**
**_Payee_**
**_Comment_**
**_Amount_**
**_R'd_**
**_Balance_**
**Apr 5, 20**
**Brought Forward**
**0.00**|**0.00**
**Balance at**
**05-Apr-21**|**_To Cash_**
**Bank<:>Cash**
**Transfers**|**WARNING!**
**Only enter data into columns A-H and cell I3.**
**Do NOT alter the formulae in rows 1&2 or columns I, K & L**|**Report Date**
**Latest Entry**
**_5 Apr 21_**
**_30 Dec 99_**| |---|---|---|---|---| ||**Report**|**0.00**
**_To Bank_**
**0.00**||| |||||| |||||| |||||| |||||| |||||| ## **Jon Shaw Foundation** _**Date Ref Category**_ **Apr 5, 20** _**Fund**_ End of Transactions ## **Deposit Account, FYE: Apr 5, 21** _**Comment Amount R'd**_ **Brought Forward 0.00** **Balance at 05-Apr-21 0.00** **Report** **Bank<:>Deposit Transfers WARNING! Only enter data into colums A-H and cell I3.** _**To Deposit**_ **Do NOT alter the formulae in rows 1&2 or co 0.00** _**To Bank**_ **0.00** Dlumns I, K & L ## **Jon Shaw Foundation: Cash** **----- Start of picture text -----**
Opening Balance Cash Flow
£0 04/20 05/20 06/20 07/20 08/20 09/20
Receipts 0 0 0 0 0
Budget Payments 0 0 0 0 0
Net 0 0 0 0 0
Receipts 5,802 7,827 10,484 11,688 13,404
Actual Payments 600 600 2,252 2,555 2,633
Net 5,202 7,227 8,232 9,133 10,770
Budget Bal 0 0 0 0 0 0
Actual Bal 0 5,202 7,227 8,232 9,133 10,770
l )
a
u
t
c
A
&
d
e
t
e
g
d
u
B
(
s
t
n
e
m
y
a
P
&
t s
i p
e
c
e
R
**----- End of picture text -----**
## **Cash Flow - Actual-to-D** **----- Start of picture text -----**
£30,000
£25,000
£20,000
£15,000
£10,000
£5,000
£0
04/20 05/20 06/20 07/20 08/20 09/20 10/20 11
Budget (Receipts) Budget (Pay
Actual (Paymentsl) Budget (Ca
**----- End of picture text -----**
## **h Flow to 05-Apr-21** **----- Start of picture text -----**
- FYE: 05-Apr-21
10/20 11/20 12/20 01/21 02/21 03/21 04/21
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
14,050 14,290 15,330 18,530 19,338 22,008 24,419
2,651 7,342 7,360 7,379 7,397 7,603 7,729
11,399 6,948 7,970 11,152 11,941 14,405 16,690
0 0 0 0 0 0 0
11,399 6,948 7,970 11,152 11,941 14,405 16,690
**----- End of picture text -----**
**----- Start of picture text -----**
Date vs Budget
£18,000
£16,000
£14,000
£12,000
£10,000
£8,000
£6,000
£4,000
£2,000
£0
1/20 12/20 01/21 02/21 03/21 04/21
yments) Actual (Receipts)
sh Assets) Actual (Cash Assets)
**----- End of picture text -----**
## **Jon Shaw Foundati** **As some of the cells in this Recurring Transaction Work “Paste/Values ” when inserting the data into transactio DO NOT ALTER THE F** **----- Start of picture text -----**
Date Ref Category Fund
Regular Monthly Transactions
Jul 2, 20 Stmnt _R1-Reccuring donation
Jul 1, 20 _R3-Set as Required or Delete-1
Jul 1, 20 _P4A-Set as Required or Delete-2
Jul 1, 20 _P4A-Set as Required or Delete-3
Jul 1, 20
Jul 1, 20
Jul 1, 20
Jul 1, 20
The following group of Recurring Transactions shows how regular monthly s
The amounts of PAYE income tax and NIC due h
Regular Monthly Salary Transactions
Jul 16, 20 GWSO E6a_Salaries & Labour
Jul 16, 20 GWSO E6a_Salaries & Labour
Jul 16, 20 GWSO CDa_HMRC (Creditor)
Jul 16, 20 GWSO CDa_HMRC (Creditor)
Jul 16, 20 GWSO CDb_NEST (Creditor)
Jul 16, 20 GVSP E6a_Salaries & Labour
Jul 16, 20 GVSP CDb_NEST (Creditor)
Jul 16, 20 NESTDD CDb_NEST (Creditor)
**----- End of picture text -----**
**----- Start of picture text -----**
Frequent Transactions
Jul 3, 20 Stmnt _P4A-Set as Required or Delete-1
Jul 3, 20 Stmnt _R3-Set as Required or Delete-1
Jul 18, 20 DirDeb E6c_Postage & Telephone
Jul 18, 20 DirDeb E5j_Business Rates
Jul 1, 20 Stmnt
Jul 1, 20
Jul 1, 20
Jul 1, 20
**----- End of picture text -----**
**----- Start of picture text -----**
Transfers Between Accounts
Transfers between Bank & Petty Cash
Trfer _Transfer To Cash
Dec 30, 99 Trfer _Transfer To Cash
Trfer _Transfer From Cash
Dec 30, 99 Trfer _Transfer From Cash
Transfers between Bank(Current) & Deposit Acccounts
Trfer _Transfer To Deposit Account
**----- End of picture text -----**
**----- Start of picture text -----**
Dec 30, 99 Trfer _Transfer To Deposit Account
Trfer _Transfer From Deposit Account
Dec 30, 99 Trfer _Transfer From Deposit Account
**----- End of picture text -----**
**As some of the cells in this Recurring Transaction Work “Paste/Values ” when inserting the data into transactio DO NOT ALTER THE F** ## **ion - Recurring Transactions** **ksheet use formulae, it is ESSENTIAL to remove the formulae by using ons worksheets otherwise errors will occur when sorting transactions. ORMULAE IN CELLS COLOURED PINK** **----- Start of picture text -----**
Payee Comment Amount
DO NOT change the cells coloured Pink
**----- End of picture text -----**
salary payments to an employee, with the deduction of PAYE & NIC to HMRC, can be handled. have to be calculated and, where necessary, entered independently. ||**DO NOT change the cells coloured Pink**|**DO NOT change the cells coloured Pink**|| |---|---|---|---| |Bloggs, Jo|Salary-Basic|-1,833.88|| |Bloggs, Jo|Salary-Bonus/Adjustments|0.00|| |HMRC|Employee PAYE Deduction|174.80|| |HMRC|Employee NIC Deduction|138.46|| |NEST Pensions|Employee NEST Deduction|10.79|| |NEST Pensions|Employer NEST Contribution|-13.49|| |NEST Pensions|Employer NEST Contribution|13.49|| |NEST Pensions|Payment to NEST|-24.28|| **----- Start of picture text -----**
DO NOT change the cells coloured Pink
Barclays Commission charges -0.10
Barclays Loyalty reward 0.10
BT Telephone charges -0.10
Somewhere BC Business Rates -278.00
**----- End of picture text -----**
**Change ONLY the cells coloured Green** |Transfer to Petty Cash|-0.10|T| |---|---|---| |Transfer from Bank|0.10|T| |Transfer to Bank|-0.10|T| |Transfer from PettyCash|0.10|T| |Transfer to Deposit Account|-0.10|T| |Transfer from Bank|0.10|T| |---|---|---| |Transfer to Bank|-0.10|T| |Transfer from Deposit Account|0.10|T| **ksheet use formulae, it is ESSENTIAL to remove the formulae by using ons worksheets otherwise errors will occur when sorting transactions. ORMULAE IN CELLS COLOURED PINK** ## **Month** **7** **Payment Date** 2 1 1 1 1 1 1 1 **Payment Date** 16 485.33 NEST Base earning 1,509.83 Net Pay 3 3 18 18 1 1 1 1 These cells get pasted (as VALUES) into the Bank worksheet These cells get pasted (as VALUES) into the Cash worksheet These cells get pasted (as VALUES) into the Bank worksheet These cells get pasted (as VALUES) into the Cash worksheet These cells get pasted (as VALUES) into the Bank worksheet These cells get pasted (as VALUES) into the Cash worksheet These cells get pasted (as VALUES) into the Bank worksheet These cells get pasted (as VALUES) into the Cash worksheet The "T"s in column-H flag the transactions as transfers to ensure that they don't get double-counted when aggregating payments & receipts **Funds Report at:** ## **Jon Shaw Foundation** ||**_Summary_**
**_Bt.Fwd_**
**_Receipts_**
**_Payments_**
**_Transfers_**| |---|---| ||| |General Fund
Designated Funds
**Total Unrestricted Funds**
**Total Restricted Funds**
**Total Funds**|0
###
###
0
0
###
###
0
**0**
**#NAME?**
**#NAME?**
**0**
**0**
**#NAME?**
**#NAME?**
**0**
**0**
**#NAME?**
**#NAME?**
**0**
**_Bt.Fwd_**
**_Receipts_**
**_Payments_**
**_Transfers_**
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###| ||| |**_Fund {Blank = General}_**|| |**DESIGNATED FUNDS**|| |D1-Rename or delete
D2-Rename or delete
D3-Rename or delete
D4-Rename or delete
D5-Rename or delete|| |**RESTRICTED FUNDS**|| |R1-Rename or delete
R2-Rename or delete
R3-Rename or delete
R4-Rename or delete
R5-Rename or delete
R6-Rename or delete
R7-Rename or delete
R8-Rename or delete
R9-Rename or delete
R10-Rename or delete|| |**End of List of Funds**|| **Apr 5, 21** _**Cd.Fwd**_ #NAME? #NAME? ## **#NAME?** ## **#NAME?** ## **###** _**Cd.Fwd**_ #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?