OpenCharities

This text was generated using OCR and may contain errors. Check the original PDF to see the document submitted to the regulator.

2022-01-01-accounts

Trustees’ Annual Report for the period

From 14/09/2020 - 01/01/2022

Charity name: The Katherine Allport Foundation

Charity registration number: 1191257

Objectives and Activities

SORP reference
Summary of the purposes of
the charity as set out in its
governing document		 Para 1.17 (a) providing free Cancer care hampers to those
affected by Cancer within the Staffordshire area
(b) promoting and assisting in additional support that
provide relief from the effects of Cancer treatment
such as, but not exclusively to Chemotherapy and
Radiotherapy.
(c) making grants from time to time to organisations
within Staffordshire that provide care and or guidance,
help and support to those affected by cancer
(d) by raising awareness of all cancers to promote
early Cancer detection and to save lives for the public
benefit.
(e) the provision of financial assistance, support,
education and practical advice .
Summary of the main
activities in relation to those
purposes for the public
benefit, in particular, the
activities, projects or
services identified in the
accounts.		 Para 1.17 and
1.19		 The Foundation has supplied Care Hampers to those
going through Cancer treatment in Staffordshire. They
contain all the essential items they will need to start
their Cancer journey.
We have held a successful event called “The Hamper
March” which allows people to walk a marathon over
a one month period whilst raising funds and
awareness for our Foundation. Upon completion they
received a medal,
We have made two grants to St Giles Hospice located
in Whittington, Staffordshire.
We have advertised the importance of self checking
for Cancer on our social media and have also gone to
Cancer groups to discuss our objectives and also the
importance of self checking for Cancer. During Covid
we especially prompted people to contact their GP to
discuss any abnormal symptoms they may have.
We have also distributed tablet computers to ensure
isolated people going through Cancer can still video
call and interact with their family members and health
care professionals. This was achieved due to us
receiving a grant from the South Staffs District
Community Innovation Fund.
Statement confirming whether
the trustees have had regard to
the guidance issued by the
Charity Commission on public
benefit		 Para 1.18 The trustees always ensure that we are following our
charitable objectives to achieve our goals and that
everything we do is for the public benefit. Our
ambitions are to support those going through Cancer
treatment in Staffordshire using the purposes stated
above.

Additional information (optional)

You may choose to include further statements where relevant about:

SORP reference Para 1.38 Policy on grant making Para 1.38 Policy on social investment including program related investment Para 1.38 Contribution made by volunteers Other

Achievements and Performance

SORP reference
Summary of the main
achievements of the charity,
identifying the difference the
charity’s work has made to
the circumstances of its
beneficiaries and any wider
benefits to society as a
whole.		 Para 1.20 - During this financial period we received 184 hamper
requests from those going through Cancer
treatment or received a referral from their friends or
family member through our website. The hampers
donated provide both a physical and much needed
mental boost during a truly difficult time in their
lives. The feedback we have received has been
overwhelmingly positive and it really puts a smile on
the recipients faces.
- Due to covid we created a very successful virtual
marathon walk called “The Hamper March”. The
participants walked the distance of a marathon
during the month of March whilst raising funds and
awareness of our Foundation. Our personal and
corporate social media platforms we inundated with
those taking npaer in
- During covid we applied for and received a grant
from the South Staffs Community Innovation Fund
of nearly £10000 to provide free tablet computers to
those isolated due to covid and going through
Cancer treatment. This allowed them to “see” their
loved ones using video messaging so they did not
feel isolated and alone during a time when they
need support the most. Staff from the local
chemotherapy unit in Cannock also applied on
patients behalf for our tablet computers. We also
donated 20 of these tablet computers to St Giles
Hospice and Katherine House Hospice to ensure
end of life patients could see loved ones during their
hospice admission.
- During covid we especially promoted the
importance of self checking for Cancers and
outlining the importance of raising any concerns, no
matter how small, with their GP. We did this through
word of mouth but mainly through our social media
(due to covid restrictions)
- We also made 2 donations to St Giles Hospice in
Whittington. One donation was £1000 and the other
£1500. The latter donation allowed us to become a
‘corporate sponsor’ of the St Giles memory tree that
displays the names of loved ones who has passed
away at St Giles. There is a plaque below the
memory tree with our charity name on it.
- We have been invited to and spoken to those going
through Cancer including the Burntwood Breast
Care support group. This allowed us to spread the
word of our Foundation and also offering any advice
they may need.

Additional information (optional)

You may choose to include further statements where relevant about:

Achievements against
objectives set		 Para 1.41
Performance of fundraising
activities against objectives
set		 Para 1.41
Investment performance
against objectives		 Para 1.41
Other

Financial Review

Review of the charity’s
financial position at the end
of the period		 Para 1.21 INCOME
The income during this financial period was £87,578.
£22510 of this income came from donations from
Businesses or organisations such as:-
- £2000 from Mid Counties COOP
- £1600 from Card Factory Foundation
- £2000 Central England COOP
- £9899.25 Community Foundation for Staffordshire
(Tablet Computer Fund)
- £1600 from DPD Group
- £1000 Arnold Clark Autos
- £500 Eaton Electrical
- £1055 Littleton Arms Pub, Huntington, following a
charity T-Shirt night
Another major income came from our Hamper March
Charity walk. The event raised approximately
£31,500. Due to income from the virtual event coming
from various platforms such as PayPal, Facebook,
JustGiving, cash donations and donating through our
website, it was a challenge to separate it from our
regular income/donations being made. Due to the
event however our income increased significantly
during the months of Feb, March, April 2021.
EXPENDITURE
The expenditure for this financial period totalled
£26989 with a large expenditure (£8926) funding the
items included within our Care Hampers. We
researched carefully to find the cheapest supplier for
our items whilst retaining the quality at all times. We
also used websites such as inKind direct that supplies
items to registered organisations for a significant
reduced price.
Another large expenditure of £9694 was the
purchasing of tablet computers that we donated to
isolated Cancer patients during Covid. This was
funded by the Community Foundation for
Staffordshire.
We also purchased merchandise to sell on to raise
awareness and funds for our charity. The larger
merchandise purchases were as follows:-
- Sep 2020 - Silicone Charity Wristbands £207
- Sep 2020 - Embroidered Fleeces £419
- May 2021 - Enamel Charity Badges x 500
- Dec 2021 - Hamper March Medals x 400 for
Hamper March 2022 event.
Our website also cost the charity £575 to set up and
operate over the financial period. A volunteer kindly
made the website for free for us and allows us to
advertise our charity and also accept online donations
through our website.
Statement explaining the
policy for holding reserves
stating why they are held		 Para 1.22 The Foundation does not as yet have an official
reserves policy.
At the end of this financial year we have £67,989 in
our account which are unrestricted funds that we can
use to achieve our charitable goals. A second account
holds £153.68 which is the money left over from the
tablet computer funds as identified above. This was to
ensure this donation was spent in full and so that
trustees could see how much of the donation we had
left to spend.
Amount of reserves held Para 1.22 £67,989
Reasons for holding zero
reserves		 Para 1.22 N/a
Details of fund materially in
deficit		 Para 1.24 N/a
Explanation of any
uncertainties about the
charity continuing as a going
concern		 Para 1.23 The trustees do not have any concerns or
uncertainties regarding the future of the Charity.

Additional information (optional)

You may choose to include further statements where relevant about:

The charity’s principal
sources of funds (including
any fundraising)		 Para 1.47
Investment policy and
objectives including any
social investment policy
adopted		 Para 1.46
A description of the principal
risks facing the charity		 Para 1.46
Other

Structure, Governance and Management

Description of charity’s
~~t~~
~~t~~
Type of governing document
(trust deed, royal charter)		 Para 1.25 Constitution of a Charitable Incorporated Organisation
(CIO) whose only voting members are its charity
trustees.
How is the charity
constituted?
(e.g unincorporated
association, CIO)		 Para 1.25 Charitable Incorporated Organisation (CIO)
Trustee selection methods
including details of any
constitutional provisions e.g.
election to post or name of
any person or body entitled
to appoint one or more
trustees		 Para 1.25 The eligibility to become a trustee is identified in our
constitution and is as follows:-
- The trustee must be a natural person
- The trustee must be at least 16 years old
- Potential Trustees must declare to our Foundation if
they have a conflict of interest that would exclude
them from being a trustee.
- Every trustee must be appointed by a resolution
passed at a properly convened meeting of charity
trustees.
- We would identify what skills are required for the
CIO trusteeship role and ensure the person meets
the criteria for the role.
Once appointed the trustee would be provided with a
copy of the charity constitution, a copy of the CIO
latest trustee annual report and statement of accounts
prior to their first meeting.

Additional information (optional)

You may choose to include further statements where relevant about:

Policies and procedures
adopted for the induction
and training of trustees		 Para 1.51
The charity’s organisational
structure and any wider
network with which the
charity works		 Para 1.51
Relationship with any related
parties		 Para 1.51

Other

Reference and Administrative details

Charity name The Katherine Allport Foundation
Other name the charity uses
Registered charity number 1191257
Charity’s principal address The Katherine Allport Foundation
4 Beech Grove, Huntington, Cannock, Staffs, WS12 4QW

Names of the charity trustees who manage the charity

Trustee name Office (if any) Dates acted if not for
whole year		 Name of person (or body)
entitled to appoint trustee
(if any)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20		 Scott Allport Whole financial
year
Pauline
Haughey		 Whole financial
year
Elizabeth
Haughey		 Appointed
18/01/2021
Claire Cale Appointed
08/03/2021

Corporate trustees – names of the directors at the date the report was approved

Director name

Name of trustees holding title to property belonging to the charity

Trustee name Dates acted if not for whole year

Funds held as custodian trustees on behalf of others

Description of the assets
held in this capacity		 None
Name and objects of the
charity on whose behalf the
assets are held and how this
falls within the custodian
charity’s objects		 None
Details of arrangements for
safe custody and
segregation of such assets
from the charity’s own assets		 None

Additional information (optional)

Names and addresses of advisers (Optional information)

Type of Name Address adviser

Name of chief executive or names of senior staff members (Optional ~~information)~~

Exemptions from disclosure

Reason for non-disclosure of key personnel details

Other optional information

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) Scott Allport

Position (eg Founding Trustee / Chair Secretary, Chair, etc)

Date 05/10/2022

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

Sep 2020 Account The Katherine Allport Foundation

Balance start of month £12,474.00

Expenses Planned £0 Actual £1,037

Income Planned £0 Actual £4,640

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,037
-£1,037		 Planned
Actual
Diff.
Totals
£0
£4,640
+£4,640
Hamper Expend £0 £285.05
-£285.05
£25.00
-£25.00
£0.00
£0.00
£0.00
£0.00
£625.76
-£625.76
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£48.00
-£48.00
£53.12
-£53.12		 Donations General £0 £519.38
£519.38
£2,000.00
£2,000.00
£129.02
£129.02
£218.00
£218.00
£0.00
£0.00
£0.00
£0.00
£1,773.14
£1,773.14
£0.00
£0.00
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Charitable Donations £0 Interest £0
Event / Fundraise Expen
£0		 Donations Justgiving / O
£0
Food For Charity Boxes £0 Other £0
Website Costs £0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses
Date
Amount
Description
Category
03/09/2020
£207.00
Silicone Wristband Child - AllMerchandise Purc		 Income
Date
Amount
Description
Category
04/09/2020
£390.00
Cash donations paid in toDonations General
17/09/2020
£25.00
Large Fleece Embrd Sale Merchandise Sales
21/09/2020
£1,179.78
Justgiving 1705386 SCOTDonations Justgiving
23/09/2020
£72.00
Wilko Event Merch Sales Merchandise Sales
23/09/2020
£218.00
Wilko Event Minus £72 MFundraising / Events
24/09/2020
£293.82
Paypal Donations (1st FebDonations Justgiving
26/09/2020
£20.00
Sue Newton - Funeral ColMerchandise Sales
28/09/2020
£299.54
JustGiving 1705386 Scot Donations Justgiving
28/09/2020
£30.00
Pauline Haughey Bank TraDonations General
28/09/2020
£0.98
Square. Test Card PaymenDonations General
29/09/2020
£2,000.00
Mid Counties Coop GrantDonations Business /
30/09/2020
£98.40
Olga Foster £100 DonatioDonations General
30/09/2020
£1.64
Kerry Harrison WristbandMerchandise Sales
30/09/2020
£10.38
Chris Pearson 10 x WristbMerchandise Sales
05/09/2020
£8.00
Cookbook
Hamper Expend
09/09/2020
£81.53
Hamper Products
Hamper Expend
10/09/2020
£418.76
FizzBizz Clothing/Merch
Merchandise Purc
11/09/2020
£60.00
Baskets x 6 Dunelm
Hamper Expend
12/09/2020
£25.00
Flowers CASH
Gifts / Experience
13/09/2020
£18.13
Amazon Personalised
Hamper Expend
16/09/2020
£18.39
Bodycare Products
Hamper Expend
17/09/2020
£11.05
Amazon Gift Bows
Hamper Expend
20/09/2020
£12.00
Hobbycraft
Hamper Expend
20/09/2020
£5.39
Ribbon Amazon
Hamper Expend
22/09/2020
£48.00
Squarespace Domain TransfeWebsite Costs
23/09/2020
£7.99
The Range personalise
Hamper Expend
23/09/2020
£5.10
B&M herbal tea envelopes
Hamper Expend
24/09/2020
£29.17
Stamps & Envelopes
Misc
24/09/2020
£22.80
Square Reader & Marketing KMisc
25/09/2020
£1.15
1st class postage for merch
Misc
24/09/2020
£24.00
4 neck pillow Matalan
Hamper Expend
27/09/2020
£5.00
Walking Book, The Works
Hamper Expend
28/09/2020
£5.00
Queen Book, The Works
Hamper Expend
28/09/2020
£3.47
Biscuit Selection, Home BargHamper Expend
28/09/2020
£20.00
Dunelm. Hedgehog Jar & RabHamper Expend		 17/09/2020
£25.00
Large Fleece Embrd Sale Merchandise Sales
21/09/2020
£1,179.78
Justgiving 1705386 SCOTDonations Justgiving
23/09/2020
£72.00
Wilko Event Merch Sales Merchandise Sales
23/09/2020
£218.00
Wilko Event Minus £72 MFundraising / Events
24/09/2020
£293.82
Paypal Donations (1st FebDonations Justgiving
26/09/2020
£20.00
Sue Newton - Funeral ColMerchandise Sales
28/09/2020
£299.54
JustGiving 1705386 Scot Donations Justgiving
28/09/2020
£30.00
Pauline Haughey Bank TraDonations General
28/09/2020
£0.98
Square. Test Card PaymenDonations General
29/09/2020
£2,000.00
Mid Counties Coop GrantDonations Business /
30/09/2020
£98.40
Olga Foster £100 DonatioDonations General
30/09/2020
£1.64
Kerry Harrison WristbandMerchandise Sales
30/09/2020
£10.38
Chris Pearson 10 x WristbMerchandise Sales

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

Oct 2020 Account The Katherine Allport Foundation

Balance start of month £16,069.59

Expenses Planned £0 Actual £703

Income Planned £0 Actual £369

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£703
-£703		 Planned
Actual
Diff.
Totals
£0
£369
+£369
Hamper Expend £0 £256.03
-£256.03
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£433.59
-£433.59
£10.17
-£10.17
£0.00
£0.00
£3.70
-£3.70		 Donations General £0 £320.58
£320.58
£0.00
£0.00
£48.34
£48.34
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Charitable Donations £0 Interest £0
Event / Fundraise Expen
£0		 Donations Justgiving / O
£0
Food For Charity Boxes £0 Other £0
Website Costs £0
Misc £0
£0
£0
£0
£0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount
Description
Category
05/10/2020
£3.70
postage 1st class. L fleece. JoyMisc		 Date
Amount
Description
Category
01/10/2020
£28.83
£30 Online Donation - J KDonations General
10/10/2020
£12.24
tesco hamper stuff
Hamper Expend
01/10/2020
£98.40
£100 Online Donation - ADonations General
11/10/2020
£12.00
Matalan 2 pillows
Hamper Expend
04/10/2020
£28.34
Joy Targett - Large FleeceMerchandise Sales
12/10/20
£21.21
home bargain
Hamper Expend
09/10/2020
£9.66
£10 donation Lynda PhippDonations General
13/10/2020
£16.98
The Range
Hamper Expend
12/10/2020
£24.45
£25 Online Donation - MiDonations General
13/10/2020
£7.00
socks B&M
Hamper Expend
21/10/2020
£20.00
£20 cash donation - DaveDonations General
13/10/2020
£12.00
blankets Dunhelm
Hamper Expend
22/10/2020
£39.24
£40 online donation less fDonations General
13/10/2020
£10.74
Tesco personalise
Hamper Expend
26/10/2020
£20.00
Liz Haughey General MerMerchandise Sales
16/10/2020
£8.00
Hamper Dunelm
Hamper Expend
27/10/0202
£100.00
Jane Davies Body Shop FuDonations General
16/10/2020
£10.00
Large Hamper Dunelm / XmaEvent / Fundraise
19/10/2020
£423.59
Hamper March 2021 MedalsEvent / Fundraise
19/10/2020
£3.98
Bodycare
Hamper Expend
19/10/2020
£4.00
The works
Hamper Expend
20/10/2020
£24.66
In Kind Direct - Order 20000Hamper Expend
21/10/2820
£6.00
Sports Direct
Hamper Expend
21/10/2020
£10.90
Home Bargain
Hamper Expend
26/10/2020
£10.17
Home Bargain Charity Food BFood For Charity B
28/10/2020
£11.92
Bodycare
Hamper Expend
28/10/2020
£4.98
home bargains
Hamper Expend
26/10/2020
£6.99
Amazon
Hamper Expend
28/10/2820
£10.79
B&M
Hamper Expend
29/10/2020
£16.16
Amazon
Hamper Expend
30/10/2020
£3.50
Tesco Xmas hamper
Hamper Expend		 01/10/2020
£98.40
£100 Online Donation - ADonations General
04/10/2020
£28.34
Joy Targett - Large FleeceMerchandise Sales
09/10/2020
£9.66
£10 donation Lynda PhippDonations General
12/10/2020
£24.45
£25 Online Donation - MiDonations General
21/10/2020
£20.00
£20 cash donation - DaveDonations General
22/10/2020
£39.24
£40 online donation less fDonations General
26/10/2020
£20.00
Liz Haughey General MerMerchandise Sales
27/10/0202
£100.00
Jane Davies Body Shop FuDonations General
31/10/2020
£42.00
Matalan
Hamper Expend
31/10/2020
£9.98
Amazon anti sick bands
Hamper Expend

GET STARTED

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

NOTE Only edit highlighted cells. Try not to alter cells that contain a formula.

Nov 2020 Account

Balance start of month £15,765.80

The Katherine Allport Foundation

Expenses Planned £0 Actual £1,229

Income Planned £0 Actual £967

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,229
-£1,229		 Planned
Actual
Diff.
Totals
£0
£967
+£967
Hamper Expend £0 £171.66
-£171.66
£0.00
£0.00
£0.00
£0.00
£1,000.00 -£1,000.00
£0.00
£0.00
£57.31
-£57.31
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00		 Donations General £0 £465.00
£465.00
£0.00
£0.00
£25.00
£25.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£477.07
£477.07
£0.00
£0.00
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Donations Justgiving / O
£0
Website Costs £0 Other £0
Misc £0
£0
£0
£0
£0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount
Description
Category
02/11/2020
£16.16
amazon hamper expend
Hamper Expend		 Date
Amount
Description
Category
02/11/2020
£20.00
Cash - Linda - St Giles DonDonations General
02/11/2020
£3.50
tesco
Hamper Expend
02/11/2020
£20.00
Cheque - Kenyon - St GileDonations General
02/11/2020
£9.98
amazion hamper exoend
Hamper Expend
04/11/2020
£20.00
Cash - Pat. Wilko - St GilesDonations General
02/11/2020
£8.99
Hamper Expend b&m
Hamper Expend
04/11/2020
£10.00
General Donation
Donations General
02/11/2020
£42.00
Matalan Hamper Items
Hamper Expend
12/11/2020
£38.34
Justgiving Online DonatioDonations Justgiving
05/11/2020
£15.30
Tesco Hamper Items
Hamper Expend
16/11/2020
£20.00
General Donation
Donations General
09/11/2020
£6.50
tesco
Hamper Expend
20/11/2020
£438.73
Facebook Fundraisers
Donations Justgiving
10/11/2020
£9.24
cook book am
Hamper Expend
25/11/2020
£180.00
Cash Donation - CelebratDonations General
20/11/2020
£6.00
Facebook Fundraiser ChargeEvent / Fundraise
29/11/2020
£25.00
Cash - Large White HoodiMerchandise Sales
20/11/2020
£1,000.00
St Giles Donation
Charitable Donati
29/11/2020
£15.00
Cash Donation - Vicky SauDonations General
23/11/2020
£51.31
Tesco Xmas hampers
Event / Fundraise
29/11/2020
£180.00
Cash Donation - Kevin La Donations General
26/11/2020
£9.98
Amazon hamper
Hamper Expend
27/11/2020
£5.00
Tesco hamper
Hamper Expend
28/11/2020
£4.99
Amazon book
Hamper Expend
28/11/2020
£7.95
Asda personalise
Hamper Expend
28/11/2020
£19.08
B&M hamper items
Hamper Expend
28/11/2020
£12.99
Amazon Photo Frame PersonHamper Expend		 02/11/2020
£20.00
Cheque - Kenyon - St GileDonations General
04/11/2020
£20.00
Cash - Pat. Wilko - St GilesDonations General
04/11/2020
£10.00
General Donation
Donations General
12/11/2020
£38.34
Justgiving Online DonatioDonations Justgiving
16/11/2020
£20.00
General Donation
Donations General
20/11/2020
£438.73
Facebook Fundraisers
Donations Justgiving
25/11/2020
£180.00
Cash Donation - CelebratDonations General

GET STARTED

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

NOTE Only edit highlighted cells. Try not to alter cells that contain a formula.

Dec 2020 Account The Katherine Allport Foundation

Balance start of month £15,287

Expenses Planned £0 Actual £1,110

Income Planned £0 Actual £4,052

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,110
-£1,110		 Planned
Actual
Diff.
Totals
£0
£4,052
+£4,052
Hamper Expend £0 £686
-£686
£0
£0
£0
£0
£0
£0
£107
-£107
£188
-£188
£0
£0
£28
-£28
£72
-£72
£30
-£30		 Donations General £0 £314
+£314
£1,950
+£1,950
£95
+£95
£986
+£986
£12
+£12
£0
£0
£23
+£23
£672
+£672
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
02/12/2020
£4.99
Refund Amazon Book
Other
02/12/2020
£24.45
Judith Stewart £25 Online Donation Less Fees Donations General
07/12/2020
£350.00
Mike Carr - Ryu Shotokan, Cannock Donation
Donations Business / Org
07/12/2020
£188.98
Facebook Donations
Donations Justgiving / Online
07/12/2020
£20.00
Navy Fleece Scott Allport (Reduced Price)
Merchandise Sales
08/12/2020
£10.00
Xmas Card Donation (Pauline)
Donations General
08/12/2020
£20.00
Grey Fleece Sian Haughey (Reduced Price)
Merchandise Sales
08/12/2020
£20.00
L+MS Simms cash donation (bank transfered inDonations General
10/12/2020
£116.91
Online Stripe Payments. Xmas Raffle 2020 (lessFundraising / Events
10/12/2020
£55.00
Linda / Sue / Pauline 2 x fleece 1 x polo
Merchandise Sales
11/12/2020
£19.52
Online Stripe Payments. Xmas Raffle 2020 (lessFundraising / Events
12/12/2020
£20.00
D Bulmer x 20 Raffle Tickets (Transfer from S A Fundraising / Events		 Date
Amount Description
Category
02/12/2020
£4.99
Refund Amazon Book
Other
02/12/2020
£24.45
Judith Stewart £25 Online Donation Less Fees Donations General
07/12/2020
£350.00
Mike Carr - Ryu Shotokan, Cannock Donation
Donations Business / Org
07/12/2020
£188.98
Facebook Donations
Donations Justgiving / Online
07/12/2020
£20.00
Navy Fleece Scott Allport (Reduced Price)
Merchandise Sales
08/12/2020
£10.00
Xmas Card Donation (Pauline)
Donations General
08/12/2020
£20.00
Grey Fleece Sian Haughey (Reduced Price)
Merchandise Sales
08/12/2020
£20.00
L+MS Simms cash donation (bank transfered inDonations General
10/12/2020
£116.91
Online Stripe Payments. Xmas Raffle 2020 (lessFundraising / Events
10/12/2020
£55.00
Linda / Sue / Pauline 2 x fleece 1 x polo
Merchandise Sales
11/12/2020
£19.52
Online Stripe Payments. Xmas Raffle 2020 (lessFundraising / Events
12/12/2020
£20.00
D Bulmer x 20 Raffle Tickets (Transfer from S A Fundraising / Events
02/12/2020
£38.00
pillows/blankets
Hamper Expend
02/12/2020
£4.99
tesco golf mag
Hamper Expend
03/12/2020
£5.75
Amazon book
Hamper Expend
03/12/2020
£5.00
CASH - 2 x Christmas bottles. Joyce Meredith Event / Fundraise Expend
04/12/2020
£71.86
Email Account Setup - Liz
Website Costs
07/12/2020
£6.00
Facebook Transfer Charge
Misc
07/12/2020
£3.00
Raffle Tickets x 3 Pound Land
Event / Fundraise Expend
07/12/2020
£106.55
Assorted Clothing Fizz Bizz
Merchandise Purchases
07/12/2020
£180.00
Hats x 40 - Hamper March 2020 - Fizz Bizz
Event / Fundraise Expend
08/12/2020
£6.95
Amazon book
Hamper Expend
07/12/2020
£7.85
Tesco personal items
Hamper Expend
08/12/2020
£12.99
Amazon photo frame
Hamper Expend		 02/12/2020
£4.99
Refund Amazon Book
Other
02/12/2020
£24.45
Judith Stewart £25 Online Donation Less Fees Donations General
07/12/2020
£350.00
Mike Carr - Ryu Shotokan, Cannock Donation
Donations Business / Org
07/12/2020
£188.98
Facebook Donations
Donations Justgiving / Online
07/12/2020
£20.00
Navy Fleece Scott Allport (Reduced Price)
Merchandise Sales
08/12/2020
£10.00
Xmas Card Donation (Pauline)
Donations General
08/12/2020
£20.00
Grey Fleece Sian Haughey (Reduced Price)
Merchandise Sales
08/12/2020
£20.00
L+MS Simms cash donation (bank transfered inDonations General
10/12/2020
£116.91
Online Stripe Payments. Xmas Raffle 2020 (lessFundraising / Events
10/12/2020
£55.00
Linda / Sue / Pauline 2 x fleece 1 x polo
Merchandise Sales
11/12/2020
£19.52
Online Stripe Payments. Xmas Raffle 2020 (lessFundraising / Events
12/12/2020
£20.00
D Bulmer x 20 Raffle Tickets (Transfer from S A Fundraising / Events
09/12/2020
£9.00
Tesco
Hamper Expend
09/12/2020
£7.50
Asda
Hamper Expend
12/12/2020
£7.59
Amazon book
Hamper Expend
12/12/2020
£62.00
Dunelm baskets/blankets
Hamper Expend
12/12/2020
£81.54
InKind Direct Order # 2000051649
Hamper Expend
12/12/2020
£40.58
Home Bargain Various Hamper Items
Hamper Expend
12/12/2020
£18.60
Tesco Various Hamper Items
Hamper Expend
12/12/2020
£100.00
Dunelm 10 baskets
Hamper Expend
13/12/2020
£9.00
Morrisons hamper stuff
Hamper Expend
13/12/2020
£44.91
Amazon personal gifts
Hamper Expend
13/12/2020
£5.69
Amazon book
Hamper Expend
15/12/2020
£13.98
Amazon anti sick bands
Hamper Expend
16/12/2020
£11.39
Amazon book
Hamper Expend
16/12/2020
£21.57
Tesco hamper stuff
Hamper Expend
18/12/2020
£9.40
Amazon chemo cookbook
Hamper Expend		 12/12/2020
£20.00
T Allport x 20 Raffle Tickets (Transfer from S Al Fundraising / Events
12/12/2020
£10.00
Cash Donation - Transfered from S Allport AccoDonations General
12/12/2020
£5.00
x 5 Raffle Ticket. M Allport. Bank Transfer fromFundraising / Events
14/12/2020
£19.52
Online Stripe Payments. Xmas Raffle 2020 (LessFundraising / Events
14/12/2020
£39.22
Online Stripe Payments. Xmas Raffle 2020 (LessFundraising / Events
14/12/2020
£269.81
Online Paypal Payments, Xmas Raffle 2020 (LesFundraising / Events
14/12/2020
£19.52
Online Stripe Payments. Xmas Raffle 2020 (LessFundraising / Events
14/12/2020
£1,600.00 Card Factory Foundation Grant
Donations Business / Org
16/12/2020
£9.66
Online Stripe Payments, Xmas Raffle 2020 (LessFundraising / Events
18/12/2020
£24.05
Online Stripe Payments, Xmas Raffle 2020 (LessFundraising / Events
18/12/2020
£200.00
E A Haughey - Bank Transfer & Cash PaymentsFundraising / Events
18/12/2020
£66.95
Online Paypal Payments, Xmas Raffle 2020 (LesFundraising / Events
19/12/2020
£20.00
Cheque L Clews Donation
Donations General
19/12/2020
£10.00
Cash Donation - V Kenyon - Transfered from S AFundraising / Events
19/12/2020
£12.00
Flapjack Work Sales - Cash Donations - TransfeFood Sales
18/12/2020
£5.30
Tesco biscuits, hot choc etc.
Hamper Expend
19/12/2820
£30.89
Home Bargain
Hamper Expend
21/12/2020
£6.00
Facebook Transfer Charge
Misc
21/12/2020
£17.99
3 x Hampers Amzazon (Test size)
Hamper Expend
21/12/2020
£11.60
Tesco General Hamper Purchases
Hamper Expend
21/12/2020
£59.08
InKind Direct Order #2000052263
Hamper Expend
22/12/2020
£28.00
Pauline Haughey Reimbursment - Hamper ItemReimbursment Volunteer / Tru
23/12/2020
£8.00
Asda 2 blankets
Hamper Expend
29/12/2020
£3.49
HP Instant Ink
Misc
29/12/2020
£15.87
Amazon personal gifts
Hamper Expend
30/12/2020
£6.50
Tesco Hamper Items
Hamper Expend
30/12/2020
£11.70
Sports Direct personalise
Hamper Expend
31/12/2020
£14.08
2nd Class Large Letter Stamps x 4 Books
Misc		 21/12/2020
£482.75
Facebook Donations
Donations Justgiving / Online
21/12/2020
£49.10
Online Stripe Payments, Xmas Raffle 2020 (LessFundraising / Events
21/12/2020
£50.00
£50 Cash Donation - Davies family - PAID IN ATDonations General
21/12/2020
£140.00
£140 Cash - General Donations - Transfered froDonations General
23/12/2020
£20.00
£20 Cash Donation - P Haughey Bank Transfer Donations General
23/12/2020
£17.99
Refund - 3 x Hampers Amazon (Test Size) - Too SOther
29/12/2020
£20.00
Christmas Card Donation - Liz Haughey - Bank TDonations General
29/12/2020
£96.59
Online Stripe Payments, Xmas Raffle 2020 (LessFundraising / Events

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

Jan 2021 Finance The Katherine Allport Foundation

Balance start of month £18,204

Expenses Planned £0 Actual £1,722

Income Planned £0 Actual £3,336

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,722
-£1,722		 Planned
Actual
Diff.
Totals
£0
£3,336
+£3,336
Hamper Expend £0 £670
-£670
£0
£0
£0
£0
£0
£0
£247
-£247
£701
-£701
£0
£0
£39
-£39
£0
£0
£65
-£65		 Donations General £0 £350
+£350
£500
+£500
£175
+£175
£2,191
+£2,191
£0
£0
£0
£0
£0
£0
£120
+£120
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
04/01/2021
£278.18
Stripe Payments - Hamper March 2021
Fundraising / Events
06/01/2021
£120.11
Facebook Payments
Donations Justgiving / Online
11/01/2021
£447.50
Stripe Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£81.81
Stripe Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£1,080.33 Paypal Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£500.00
EH Smith Foundation (For Carl Easter FundraiseDonations Business / Org
20/01/2021
£172.81
Facebook Payments
Fundraising / Events
20/01/2021
£100.00
Post Office Reimbursent For Error
Donations General
20/01/2021
£50.00
G Haughey Hoodies x 2
Merchandise Sales
20/01/2021
£25.00
P Haughey Hoddies x 1
Merchandise Sales
21/01/2021
£250.00
R Cecil (Donation In Memory Terry Hollis)
Donations General
25/01/2021
£50.00
Connektred 2 x Hoodies
Merchandise Sales		 Date
Amount Description
Category
04/01/2021
£278.18
Stripe Payments - Hamper March 2021
Fundraising / Events
06/01/2021
£120.11
Facebook Payments
Donations Justgiving / Online
11/01/2021
£447.50
Stripe Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£81.81
Stripe Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£1,080.33 Paypal Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£500.00
EH Smith Foundation (For Carl Easter FundraiseDonations Business / Org
20/01/2021
£172.81
Facebook Payments
Fundraising / Events
20/01/2021
£100.00
Post Office Reimbursent For Error
Donations General
20/01/2021
£50.00
G Haughey Hoodies x 2
Merchandise Sales
20/01/2021
£25.00
P Haughey Hoddies x 1
Merchandise Sales
21/01/2021
£250.00
R Cecil (Donation In Memory Terry Hollis)
Donations General
25/01/2021
£50.00
Connektred 2 x Hoodies
Merchandise Sales
01/01/2021
£16.99
Amazon book
Hamper Expend
02/01/2021
£38.14
H Bargain hamper essential
Hamper Expend
02/01/2021
£5.00
Tesco choc and biscuits
Hamper Expend
04/01/2021
£5.50
Tesco Hamper Items
Hamper Expend
05/01/2021
£20.80
4 Reels Curling Ribbon Amazon
Hamper Expend
05/01/2021
£189.00
100 x Neck Pillows - Something Different WhoHamper Expend
06/01/2021
£6.00
Facebook Money Transfer Charges
Misc
06/01/2021
£100.00
10 x Hamper Baskets Dunelm
Hamper Expend
11/01/2021
£27.90
Amazon photo frame and hamper wrap
Hamper Expend
11/01/2021
£50.00
ERROR - P,Office Withdrew Instead of paying iMisc
12/01/2021
£10.00
Tesco hamper products
Hamper Expend
13/01/2021
£12.98
Amazon adult jigsaw
Hamper Expend		 04/01/2021
£278.18
Stripe Payments - Hamper March 2021
Fundraising / Events
06/01/2021
£120.11
Facebook Payments
Donations Justgiving / Online
11/01/2021
£447.50
Stripe Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£81.81
Stripe Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£1,080.33 Paypal Payments - Hamper March 2021
Fundraising / Events
18/01/2021
£500.00
EH Smith Foundation (For Carl Easter FundraiseDonations Business / Org
20/01/2021
£172.81
Facebook Payments
Fundraising / Events
20/01/2021
£100.00
Post Office Reimbursent For Error
Donations General
20/01/2021
£50.00
G Haughey Hoodies x 2
Merchandise Sales
20/01/2021
£25.00
P Haughey Hoddies x 1
Merchandise Sales
21/01/2021
£250.00
R Cecil (Donation In Memory Terry Hollis)
Donations General
25/01/2021
£50.00
Connektred 2 x Hoodies
Merchandise Sales
13/01/2021
£4.20
Tesco pencils and biscuits
Hamper Expend
13/01/2021
£49.96
B & M blankets, water bottles,eye masks
Hamper Expend
13/01/2021
£243.59
100 x Hamper March Medals - Running Imp
Event / Fundraise Expend
14/01/2021
£6.45
Asda chocolate, biscuits, hot choc
Hamper Expend
14/01/2021
£28.08
Inkind direct
Hamper Expend
16/01/2021
£32.15
Amazon bike calendar, sickness bands, bows
Hamper Expend
16/01/2021
£39.55
Home Bargain hamper essentials
Hamper Expend
17/01/2021
£6.99
Printing, Prism Print. Hamper March Forms
Event / Fundraise Expend
19/01/2021
£39.23
Reimbursment - S Allport, Envelope Purchase Reimbursment Volunteer / Tru
19/01/2021
£17.07
Tesco hot choc, choc, biscuits
Hamper Expend
20/01/2021
£6.00
Facebook Money Transfer Charges
Misc
20/01/2021
£16.42
Hamper Items Tesco
Hamper Expend
21/01/2021
£450.00
100 x Hamper March Beanie Hats - Fizzbizz
Event / Fundraise Expend
21/01/2021
£175.41
9 x Hoodies Fizzbizz
Merchandise Purchases
29/01/2021
£16.00
B & M 2 storage boxes large
Hamper Expend		 25/01/2021
£25.00
J Hale. Hoodie x 1
Merchandise Sales
25/01/2021
£130.72
Stripe Payments - Hamper March 2021
Fundraising / Events
27/01/2021
£25.00
G Hickinbottom Hoodie x 1
Merchandise Sales
31/01/2021
£33.63
Amazon personalised items
Hamper Expend
27/01/2021
£8.95
Hamper March T Shirt - Youriconicdesign ETSYMerchandise Purchases
27/01/2021
£8.95
Hamper March T Shirt - Youriconicdesign ETSYMerchandise Purchases
27/01/2021
£8.95
Hamper March T Shirt - Youriconicdesign ETSYMerchandise Purchases
27/01/2021
£8.95
Hamper March T Shirt - Youriconicdesign ETSYMerchandise Purchases
27/01/2021
£17.90
2 x Hamper March T Shirt - Youriconicdesign EMerchandise Purchases
27/01/2021
£17.90
2 x Hamper March T Shirt - Youriconicdesign EMerchandise Purchases
28/01/2021
£3.49
HP Instant Ink
Misc

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

Feb 2021 Finance The Katherine Allport Foundation

Balance start of month £19,868

Expenses Planned £0 Actual £9,599

Income Planned £0 Actual £20,970

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£9,599
-£9,599		 Planned
Actual
Diff.
Totals
£0
£20,970
+£20,970
Hamper Expend £0 £722
-£722
£0
£0
£0
£0
£0
£0
£273
-£273
£27
-£27
£0
£0
£0
£0
£6
-£6
£8,517
-£8,517
£54
-£54		 Donations General £0 £190
+£190
£12,149
+£12,149
£152
+£152
£8,467
+£8,467
£0
£0
£0
£0
£12
+£12
£0
£0
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
01/02/2021
£50.00
Aimme and Liv Hoodie
Merchandise Sales
01/02/2021
£30.00
L Wooley Donation - Cheque
Donations General
01/02/2021
£101.78
Stripe Payments - Hamper March T Shirt x 7 LesMerchandise Sales
01/02/2021
£15.87
Stripe Payments - Hamper March 2021 (Split fr Fundraising / Events
03/02/2021
£160.00
B Lester - Cheque Donation
Donations General
04/02/2021
£2,048.94 Facebook Fundraisers - Hamper March 2021 MFundraising / Events
04/02/2021
£2,000.00 Central England Coop Grant
Donations Business / Org
08/02/2021
£84.93
Stripe Payments - Hamper March 2021
Fundraising / Events
10/02/2021
£9,899.25 Tablet Grant, Community Foundation for StaffoDonations Business / Org
15/02/2021
£72.94
Stripe Payments - Hamper March 2021
Fundraising / Events
22/02/2021
£11.95
Refund Amazon bags for tablets
Other
22/02/2021
£250.00
Connektred Dontation
Donations Business / Org		 Date
Amount Description
Category
01/02/2021
£50.00
Aimme and Liv Hoodie
Merchandise Sales
01/02/2021
£30.00
L Wooley Donation - Cheque
Donations General
01/02/2021
£101.78
Stripe Payments - Hamper March T Shirt x 7 LesMerchandise Sales
01/02/2021
£15.87
Stripe Payments - Hamper March 2021 (Split fr Fundraising / Events
03/02/2021
£160.00
B Lester - Cheque Donation
Donations General
04/02/2021
£2,048.94 Facebook Fundraisers - Hamper March 2021 MFundraising / Events
04/02/2021
£2,000.00 Central England Coop Grant
Donations Business / Org
08/02/2021
£84.93
Stripe Payments - Hamper March 2021
Fundraising / Events
10/02/2021
£9,899.25 Tablet Grant, Community Foundation for StaffoDonations Business / Org
15/02/2021
£72.94
Stripe Payments - Hamper March 2021
Fundraising / Events
22/02/2021
£11.95
Refund Amazon bags for tablets
Other
22/02/2021
£250.00
Connektred Dontation
Donations Business / Org
01/02/2021
£44.54
B & M hamper supplies
Hamper Expend
01/02/2021
£8.75
Tesco hamper supplies
Hamper Expend
02/02/2021
£31.44
Amazon personalised items
Hamper Expend
02/02/2021
£4.00
Poundland - Printer paper and highlighter pensMisc
02/02/2021
£27.45
Postage x 15 Hamper March Packs - 1st Class Event / Fundraise Expend
04/02/2021
£6.00
Facebook Fundraiser Transfer Fee
Misc
05/02/2021
£5.10
Tesco choc, biscuits hot choc
Hamper Expend
07/02/2021
£100.00
Dunelm 10 baskets
Hamper Expend
09/02/2021
£25.92
Inkind Direct
Hamper Expend
09/02/2021
£26.40
Costco Signup
Misc
10/02/2021
£22.48
Amazon hamper products
Hamper Expend
10/02/2021
£96.80
Home Bargain hamper products
Hamper Expend		 01/02/2021
£50.00
Aimme and Liv Hoodie
Merchandise Sales
01/02/2021
£30.00
L Wooley Donation - Cheque
Donations General
01/02/2021
£101.78
Stripe Payments - Hamper March T Shirt x 7 LesMerchandise Sales
01/02/2021
£15.87
Stripe Payments - Hamper March 2021 (Split fr Fundraising / Events
03/02/2021
£160.00
B Lester - Cheque Donation
Donations General
04/02/2021
£2,048.94 Facebook Fundraisers - Hamper March 2021 MFundraising / Events
04/02/2021
£2,000.00 Central England Coop Grant
Donations Business / Org
08/02/2021
£84.93
Stripe Payments - Hamper March 2021
Fundraising / Events
10/02/2021
£9,899.25 Tablet Grant, Community Foundation for StaffoDonations Business / Org
15/02/2021
£72.94
Stripe Payments - Hamper March 2021
Fundraising / Events
22/02/2021
£11.95
Refund Amazon bags for tablets
Other
22/02/2021
£250.00
Connektred Dontation
Donations Business / Org
10/02/2021
£5.99
Home Bargain personalise product
Hamper Expend
22/02/2021
£6,033.37 Facebook Fundraisers - Hamper March 2021 MFundraising / Events
10/02/2021
£13.00
Tesco personal products
Hamper Expend
22/02/2021
£10.65
Stripe Payments
Fundraising / Events
10/02/2021
£14.97
The Range craft sets
Hamper Expend
26/02/2021
£200.00
Tyler Davies Hamper March Key Ring FundraiseFundraising / Events
11/02/2021
£16.46
Amazon personalised gifts
Hamper Expend
13/02/2021
£5.00
Tesco hot chocolate/chocolate
Hamper Expend
14/82/2021
£14.50
Amazon personalised items
Hamper Expend
15/02/2021
£32.08
Amazon personalised items
Hamper Expend
15/02/2021
£3,599.70 Argos 30 WIFI tablets
Tablet Computer Purchases (S
16/02/2021
£4,917.00 Vodafone 33 PAYG tablets
Tablet Computer Purchases (S
16/02/2021
£11.95
Amazon bags for tablets
Misc
18/02/2021
£6.00
ionos email hosting
Website Costs
19/02/2021
£12.99
Amazon personalised items
Hamper Expend
20/02/2021
£15.00
B &M 3 blankets
Hamper Expend
20/02/2021
£37.64
Home Bargain hamper items
Hamper Expend
22/02/2021
£6.00
Facebook Fundraiser Transfer Fee
Misc
22/02/2021
£7.90
Tesco hamper products
Hamper Expend
24/02/2021
£9.09
Asda personalise items
Hamper Expend		 22/02/2021
£6,033.37 Facebook Fundraisers - Hamper March 2021 MFundraising / Events
22/02/2021
£10.65
Stripe Payments
Fundraising / Events
26/02/2021
£200.00
Tyler Davies Hamper March Key Ring FundraiseFundraising / Events
25/02/2021
£95.00
Dunelm 10 x baskets
Hamper Expend
27/02/2021
£272.86
Fizz Bizz 14 x Emroidered Fleece
Merchandise Purchases
27/02/2021
£5.00
1 x Hamper Basket - Poundland
Hamper Expend
227/02/2021 £48.98
Hamper items home bargains
Hamper Expend
27/02/2021
£22.10
B&M blankets
Hamper Expend
28/02/2021
£31.03
Amazon personalised items and gift bows
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

March 2021 Financ

Balance start of month £21,420

The Katherine Allport Foundation

Expenses Planned £0 Actual £1,339

Income Planned £0 Actual £11,365

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,339
-£1,339		 Planned
Actual
Diff.
Totals
£0
£11,365
+£11,365
Hamper Expend £0 £1,213
-£1,213
£0
£0
£0
£0
£22
-£22
£64
-£64
£18
-£18
£0
£0
£0
£0
£6
-£6
£0
£0
£16
-£16		 Donations General £0 £230
+£230
£1,600
+£1,600
£337
+£337
£9,198
+£9,198
£0
£0
£0
£0
£0
£0
£0
£0
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
01/03/2021
£19.32
Stripe Payments Hamper March
Fundraising / Events
01/03/2021
£25.00
Pauline hoody
Merchandise Sales
01/03/2021
£25.00
Liz hoody
Merchandise Sales
02/03/2021
£25.00
Jane Hale hoody
Merchandise Sales
02/03/2021
£50.00
Claire Cale hoody
Merchandise Sales
02/03/2021
£50.00
Joanne Wells hoody
Merchandise Sales
03/03/2021
£17.90
2 x Hamper March T Shirt Sales - Youriconicdesign Merchandise Sales		 Date
Amount Description
Category
01/03/2021
£19.32
Stripe Payments Hamper March
Fundraising / Events
01/03/2021
£25.00
Pauline hoody
Merchandise Sales
01/03/2021
£25.00
Liz hoody
Merchandise Sales
02/03/2021
£25.00
Jane Hale hoody
Merchandise Sales
02/03/2021
£50.00
Claire Cale hoody
Merchandise Sales
02/03/2021
£50.00
Joanne Wells hoody
Merchandise Sales
03/03/2021
£17.90
2 x Hamper March T Shirt Sales - Youriconicdesign Merchandise Sales
01/03/2021
£3.49
HP Instant Ink
Misc
01/03/2021
£4.45
Tesco hamper foods
Hamper Expend
03/03/2021
£13.95
Amazon personalised gift
Hamper Expend
03/03/2021
£9.97
Tesco hamper products
Hamper Expend
03/03/2021
£20.00
4 x Hamper Baskets Poundland
Hamper Expend
03/03/2021
£5.28
The Range personal gifts
Hamper Expend
06/03/2021
£47.54
B&M hamper items
Hamper Expend		 01/03/2021
£19.32
Stripe Payments Hamper March
Fundraising / Events
01/03/2021
£25.00
Pauline hoody
Merchandise Sales
01/03/2021
£25.00
Liz hoody
Merchandise Sales
02/03/2021
£25.00
Jane Hale hoody
Merchandise Sales
02/03/2021
£50.00
Claire Cale hoody
Merchandise Sales
02/03/2021
£50.00
Joanne Wells hoody
Merchandise Sales
03/03/2021
£17.90
2 x Hamper March T Shirt Sales - Youriconicdesign Merchandise Sales
06/03/2021
£22.97
Wolesley garden centre personalisHamper Expend
06/03/2021
£3.20
Postage for Merch and 2 x BadgeMisc
08/03/2021
£6.90
Tesco mens toiletries
Hamper Expend
08/03/2021
£14.00
Bag a bargain shower gel
Hamper Expend
08/03/2021
£53.69
Home Bsrgain hamper products
Hamper Expend
09/03/2021
£23.00
B & M blankets
Hamper Expend
10/03/2021
£22.00
Poundland 4 baskets + sweets
Hamper Expend
11/03/2021
£31.52
Amazon personalised items + anti sHamper Expend
12/03/2021
£13.99
Tesco personal hamper gifts
Hamper Expend
12/03/2021
£15.00
B&M hamper items
Hamper Expend
17/03/2021
£19.43
Home Bargains mens pillows/toiletHamper Expend
17/03/2021
£4.99
pets at home dog plaque
Hamper Expend
17/03/2021
£19.56
Poundstetcher mens items
Hamper Expend
19/03/2021
£22.45
Tesco food items
Hamper Expend
19/03/2021
£156.60
Home Bargain hamper items
Hamper Expend
20/03/2021
£16.48
Amazon Newcastle Utd glass
Hamper Expend
20/03/2021
£114.29
Amazon personalised items
Hamper Expend
20/03/2021
£22.25
Tesco hamper products
Hamper Expend
09/03/2821
£47.05
Amazon personalised items
Hamper Expend
09/03/2821
£20.97
Amazon anti sickness bands
Hamper Expend
17/03/2821
£99.36
Inkind direct toiletries
Hamper Expend		 03/03/2021
£8.95
1 x Hamper March T Shirt Sales - Youriconicdesign Merchandise Sales
04/03/2021
£4,669.83 Facebook Fundraiser Payments
Fundraising / Events
05/03/2021
£50.00
Alison hoodys
Merchandise Sales
08/03/2021
£391.13
Stripe Payments Hamper March
Fundraising / Events
15/03/2021
£29.28
Stripe Payments Hamper March
Fundraising / Events
18/03/2021
£4,014.81 Facebook Fundraiser Payments
Fundraising / Events
18/03/2021
£210.42
Hart School Donation
Donations General
19/03/2021
£1,600.00 DPD Group Donation
Donations Business / Org
22/03/2021
£24.45
Stripe Payments Hamper March
Fundraising / Events
28/03/2021
£48.90
Stripe Payments Hamper March
Fundraising / Events
29/03/2021
£20.00
D Laverne Donation
Donations General
29/03/2021
£10.00
Hat Sale J Tranter
Merchandise Sales
29/03/2021
£75.00
Deb Hoodie Sales x 3
Merchandise Sales
17/03/2021
£4.00
Asda water bottles
Hamper Expend
17/03/2021
£63.50
Fizz Bizz Beanie Hats
Merchandise Purchases
18/03/2021
£6.00
Facebook Bank Transfer Charges
Misc
22/03/2021
£6.00
IONOS Email
Website Costs
23/03/2021
£36.00
Tesco water bottles and mugs
Hamper Expend
23/03/2021
£21.85
Tesco Easter eggs donations
Charitable Donations
23/03/2021
£5.00
Poundland one basket
Hamper Expend
24/03/2021
£12.71
The Range hamper items
Hamper Expend
24/03/2021
£86.35
Home Bargain hamper items AveenHamper Expend
27/03/2021
£9.49
The Range items for boys hamper Hamper Expend
28/03/2021
£3.50
Asda items for boys hamper
Hamper Expend
28/03/2021
£32.35
B&M items for boys hamper
Hamper Expend
28/03/2021
£18.00
Tesco items for boys hamper
Hamper Expend
28/03/2021
£20.99
Amazon items for boys hamper
Hamper Expend
29/03/2021
£3.49
HP Instant Ink
Misc
31/03/2021
£40.00
Dunelm baskets x5
Hamper Expend
31/03/2021
£8.00
Poundland hamper items
Hamper Expend
31/03/2021
£7.57
B&M hot choc, book
Hamper Expend
31/03/2021
£18.98
Wolseley garden centre personalisHamper Expend
31/03/2021
£30.19
Tesco hamper products
Hamper Expend
31/03/2021
£32.19
Amazon personalised items
Hamper Expend
31/03/2021
£17.98
Amazon Pink Medal Envelopes
Event / Fundraise Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

April 2021 Finance

Balance start of month £39,906

The Katherine Allport Foundation

N/A Expenses Planned £0 Actual £683

Income Planned £0 Actual £20,974

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£683
-£683		 Planned
Actual
Diff.
Totals
£0
£20,974
+£20,974
Hamper Expend £0 £503
-£503
£0
£0
£0
£0
£0
£0
£139
-£139
£20
-£20
£0
£0
£0
£0
£6
-£6
£0
£0
£14
-£14		 Donations General £0 £20
+£20
£870
+£870
£170
+£170
£19,914
+£19,914
£0
£0
£0
£0
£0
£0
£0
£0
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Date **Amount ** Description Category
06/04/2021 £6.00 Facebook Bank Transfer Charges Misc
06/04/2021 £12.49 Amazon personalised items Hamper Expend
07/04/2021 £11.98 Tesco hamper products Hamper Expend
07/04/2021 £20.84 The Range hamper items Hamper Expend
07/04/2021 £31.76 B&M hamper items Hamper Expend
07/04/2021 £36.29 Asda hamper items Hamper Expend
10/04/2021 £25.48 Amazon personalised items Hamper Expend
12/04/2021 £100.00 Dunelm x 10 baskets Hamper Expend
12/04/2021 £59.28 InKind Direct Hamper Items Hamper Expend
14/04/2021 £31.03 Home Bargain hamper items Hamper Expend
14/04/2021 £13.50 Primark hamper items Hamper Expend
14/04/2021 £1.92 2 x 2nd Class stamps (merch postagMisc
15/04/2021 £36.52 Amazon personalised items +wrap Hamper Expend
17/04/2021 £42.89 Home Bargain hamper items Hamper Expend
17/04/2021 £20.41 Hamper March Medal Postage Event / Fundraise Expend
18/04/2021 £11.20 Tesco hamper products Hamper Expend
18/04/2021 £31.46 Asda hamper items Hamper Expend
21/04/2021 £16.50 Primark hamper items Hamper Expend
23/04/2021 £100.00 withdrawn petty cash float Merchandise Purchases
23/04/2021 £6.00 IONOS Email Website Costs
24/04/2021 £22.18 Amazon personalised items Hamper Expend
26/04/2021 £6.00 Facebook Bank Transfer Charges Misc
28/04/2021 £38.98 FizzBizz Merchandise Merchandise Purchases

Income

Date
Amount Description
Category
06/04/2021
£7,124.60 Facebook Fundraiser Payments
Fundraising / Events
06/04/2021
£30.00
Hats
Merchandise Sales
06/04/2021
£75.00
Hoodys
Merchandise Sales
06/04/2021
£20.00
D. Harrison donation
Donations General
06/04/2021
£70.00
Assorted sponsors
Fundraising / Events
08/04/2021
£720.00
South Staffs District Council Community InnovationDonations Business / Org
09/04/2021
£35.00
L Whitehouse sponsor
Fundraising / Events
09/04/2021
£50.00
L Whitehouse sponsor cheque
Fundraising / Events		 Date
Amount Description
Category
06/04/2021
£7,124.60 Facebook Fundraiser Payments
Fundraising / Events
06/04/2021
£30.00
Hats
Merchandise Sales
06/04/2021
£75.00
Hoodys
Merchandise Sales
06/04/2021
£20.00
D. Harrison donation
Donations General
06/04/2021
£70.00
Assorted sponsors
Fundraising / Events
08/04/2021
£720.00
South Staffs District Council Community InnovationDonations Business / Org
09/04/2021
£35.00
L Whitehouse sponsor
Fundraising / Events
09/04/2021
£50.00
L Whitehouse sponsor cheque
Fundraising / Events
06/04/2021
£7,124.60 Facebook Fundraiser Payments
Fundraising / Events
06/04/2021
£30.00
Hats
Merchandise Sales
06/04/2021
£75.00
Hoodys
Merchandise Sales
06/04/2021
£20.00
D. Harrison donation
Donations General
06/04/2021
£70.00
Assorted sponsors
Fundraising / Events
08/04/2021
£720.00
South Staffs District Council Community InnovationDonations Business / Org
09/04/2021
£35.00
L Whitehouse sponsor
Fundraising / Events
09/04/2021
£50.00
L Whitehouse sponsor cheque
Fundraising / Events
09/04/2021
£210.00
Finlay sponsor money
Fundraising / Events
09/04/2021
£115.00
Sian sponsor money
Fundraising / Events
09/04/2021
£40.00
Pauline sponsor money
Fundraising / Events
09/04/2021
£150.00
Heineken Grant - The Neighborly Foundation
Donations Business / Org
12/04/2021
£520.36
Stripe Payments
Fundraising / Events
12/04/2021
£1,850.00 Hamper March Cash Donations
Fundraising / Events
14/04/2021
£250.00
W/G Haughey Hamper March Donations
Fundraising / Events
19/04/2021
£899.22
Stripe Payments
Fundraising / Events
19/04/2021
£1,230.00 Hamper March Cash Donations
Fundraising / Events
23/04/2021
£310.00
W/G Haughey Hamper March Donations
Fundraising / Events
23/04/2021
£742.00
Hamper March Cash Donations
Fundraising / Events
23/04/2021
£642.00
Hamper March Cash Donations
Fundraising / Events
26/04/2021
£5,482.05 Facebook Fundraiser Payments
Fundraising / Events
26/04/2021
£163.28
Stripe Payments
Fundraising / Events
28/04/2021
£80.00
Tessa Hopcott Hamper March (Liz BT)
Fundraising / Events
28/04/2021
£50.00
Claire Cale hoodys x 2
Merchandise Sales
30/04/2021
£15.00
Tablet Holder - Liz Haughey
Merchandise Sales
30/04/2021
£100.00
D Adams-Hall Hamper March Bank Transfer
Fundraising / Events

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

May 2021 Finance

Balance start of month £59,514

The Katherine Allport Foundation

Expenses Planned £0 Actual £673

Income Planned £0 Actual £3,509

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£673
-£673		 Planned
Actual
Diff.
Totals
£0
£3,509
+£3,509
Hamper Expend £0 £241
-£241
£0
£0
£0
£0
£0
£0
£402
-£402
£0
£0
£0
£0
£0
£0
£18
-£18
£0
£0
£12
-£12		 Donations General £0 £623
+£623
£0
£0
£0
£0
£2,886
+£2,886
£0
£0
£0
£0
£0
£0
£0
£0
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
04/05/2021
£78.68
Stripe Payments
Fundraising / Events
05/05/2021
£2,075.02 Facebook Payments
Fundraising / Events
05/05/2021
£564.51
Paypal Payments - Hamper March
Fundraising / Events
10/05/2021
£157.36
Stripe Payments
Fundraising / Events
10/05/2021
£10.00
G Mason - Cheque, Hamper March
Fundraising / Events
20/05/2021
£519.72
Facebook Payments
Donations General
24/05/2021
£5.00
Amazon Smile Donation
Donations General
25/05/2021
£98.40
Stripe Payments
Donations General		 Date
Amount Description
Category
04/05/2021
£78.68
Stripe Payments
Fundraising / Events
05/05/2021
£2,075.02 Facebook Payments
Fundraising / Events
05/05/2021
£564.51
Paypal Payments - Hamper March
Fundraising / Events
10/05/2021
£157.36
Stripe Payments
Fundraising / Events
10/05/2021
£10.00
G Mason - Cheque, Hamper March
Fundraising / Events
20/05/2021
£519.72
Facebook Payments
Donations General
24/05/2021
£5.00
Amazon Smile Donation
Donations General
25/05/2021
£98.40
Stripe Payments
Donations General
05/05/2021
£6.00
Facebook Bank Transfer Charges
Misc
06/05/2021
£402.00
Premier Badges x 500
Merchandise Purchases
11/05/2021
£16.23
Hamper Items
Hamper Expend
12/05/2021
£6.38
Hamper Items
Hamper Expend
12/05/2021
£1.00
Hamper Items
Hamper Expend
12/05/2021
£3.36
Hamper Items
Hamper Expend
16/05/2021
£42.31
Amazon personalised items
Hamper Expend
16/05/2021
£7.96
The Range books
Hamper Expend		 04/05/2021
£78.68
Stripe Payments
Fundraising / Events
05/05/2021
£2,075.02 Facebook Payments
Fundraising / Events
05/05/2021
£564.51
Paypal Payments - Hamper March
Fundraising / Events
10/05/2021
£157.36
Stripe Payments
Fundraising / Events
10/05/2021
£10.00
G Mason - Cheque, Hamper March
Fundraising / Events
20/05/2021
£519.72
Facebook Payments
Donations General
24/05/2021
£5.00
Amazon Smile Donation
Donations General
25/05/2021
£98.40
Stripe Payments
Donations General
16/05/2021
£41.91
toiletries for hamper
Hamper Expend
19/05/2021
£33.63
Home Bargain hamper items
Hamper Expend
19/05/2021
£11.99
Amazon personalised items
Hamper Expend
20/05/2021
£6.00
Facebook Bank Transfer Charges
Misc
24/05/2021
£18.00
Ionos Email
Website Costs
26/05/2021
£24.00
Dunelm blankets
Hamper Expend
26/05/2021
£24.00
Dunelm blankets
Hamper Expend
26/05/2021
£7.71
Amazon personalised items
Hamper Expend
27/05/2021
£10.98
Amazon personalised items
Hamper Expend
27/05/2021
£2.27
Tesco hamper products
Hamper Expend
28/05/2021
£7.60
Tesco hamper products
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

June 2021 Finance

Balance start of month £62,275

The Katherine Allport Foundation

Expenses Planned £0 Actual £895

Income Planned £0 Actual £1,344

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£895
-£895		 Planned
Actual
Diff.
Totals
£0
£1,344
+£1,344
Hamper Expend £0 £524
-£524
£0
£0
£0
£0
£0
£0
£58
-£58
£0
£0
£0
£0
£0
£0
£306
-£306
£0
£0
£6
-£6		 Donations General £0 £209
+£209
£0
£0
£75
+£75
£0
£0
£0
£0
£0
£0
£0
£0
£1,061
+£1,061
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
06/06/2021
£75.00
3 x hoodys
Merchandise Sales
08/06/2021
£423.13
Justgiving Donations
Donations Justgiving / Online
14/06/2021
£65.00
Cash Donations - Scott Allport Bank Transfer
Donations General
14/06/2021
£24.45
Stripe Payments
Donations General
14/06/2021
£177.71
Justgiving Donations
Donations Justgiving / Online
21/06/2021
£229.09
Facebook Donations
Donations Justgiving / Online
21/06/2021
£39.24
Stripe Payments
Donations General
21/06/2021
£221.26
Justgiving Donations
Donations Justgiving / Online
22/06/2021
£60.00
J Surridge Donation BT
Donations General
28/06/2021
£9.61
Justgiving Donations
Donations Justgiving / Online
29/06/2821
£20.00
Amanda Pearce donation Pauline BT
Donations General		 Date
Amount Description
Category
06/06/2021
£75.00
3 x hoodys
Merchandise Sales
08/06/2021
£423.13
Justgiving Donations
Donations Justgiving / Online
14/06/2021
£65.00
Cash Donations - Scott Allport Bank Transfer
Donations General
14/06/2021
£24.45
Stripe Payments
Donations General
14/06/2021
£177.71
Justgiving Donations
Donations Justgiving / Online
21/06/2021
£229.09
Facebook Donations
Donations Justgiving / Online
21/06/2021
£39.24
Stripe Payments
Donations General
21/06/2021
£221.26
Justgiving Donations
Donations Justgiving / Online
22/06/2021
£60.00
J Surridge Donation BT
Donations General
28/06/2021
£9.61
Justgiving Donations
Donations Justgiving / Online
29/06/2821
£20.00
Amanda Pearce donation Pauline BT
Donations General
01/06/2021
£23.49
Amazon personalised items
Hamper Expend
02/06/2021
£5.97
The Range books
Hamper Expend
02/06/2021
£10.00
Asda 2 blankets
Hamper Expend
02/06/2021
£58.47
3 x fleece FizzBizz
Merchandise Purchases
03/06/2021
£100.00
Dunelm baskets x 10
Hamper Expend
05/06/2021
£10.00
Matalan lolly moulds
Hamper Expend
08/06/2021
£39.92
Amazon hamper items
Hamper Expend
09/06/2021
£16.47
Tesco hamper items
Hamper Expend
10/06/2021
£20.00
Primark personalised items
Hamper Expend
10/06/2021
£17.50
Asda personalised items
Hamper Expend
12/06/2021
£10.39
New Look personalised items
Hamper Expend
12/06/2021
£37.17
Asda hamper items
Hamper Expend		 06/06/2021
£75.00
3 x hoodys
Merchandise Sales
08/06/2021
£423.13
Justgiving Donations
Donations Justgiving / Online
14/06/2021
£65.00
Cash Donations - Scott Allport Bank Transfer
Donations General
14/06/2021
£24.45
Stripe Payments
Donations General
14/06/2021
£177.71
Justgiving Donations
Donations Justgiving / Online
21/06/2021
£229.09
Facebook Donations
Donations Justgiving / Online
21/06/2021
£39.24
Stripe Payments
Donations General
21/06/2021
£221.26
Justgiving Donations
Donations Justgiving / Online
22/06/2021
£60.00
J Surridge Donation BT
Donations General
28/06/2021
£9.61
Justgiving Donations
Donations Justgiving / Online
29/06/2821
£20.00
Amanda Pearce donation Pauline BT
Donations General
13/06/2021
£10.68
B & M hamper items
Hamper Expend
14/06/2021
£41.34
Amazon Hamper items
Hamper Expend
18/06/2021
£15.72
Amazon personalised items
Hamper Expend
19/06/2021
£10.14
Tesco hamper products
Hamper Expend
20/06/2021
£42.61
B&M hamper items
Hamper Expend
21/06/2021
£6.00
Facebook Bank Transfer Charge
Misc
23/06/2021
£1.24
Amazon Hamper items
Hamper Expend
23/06/2021
£18.00
Ionos Email Accounts
Website Costs
24/06/2021
£3.00
kiss and make up personal hamper Hamper Expend
24/06/2021
£36.00
Asda hamper items
Hamper Expend
24/06/2021
£52.97
Home Bargain hamper items
Hamper Expend
24/06/2021
£4.80
Tesco hamper products
Hamper Expend
24/06/2021
£5.00
The works books
Hamper Expend
25/06/2021
£10.00
Amazon book
Hamper Expend
28/06/2021
£288.00
Website Renewal
Website Costs

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

July 2021 Finance

Balance start of month £62,624

The Katherine Allport Foundation

Expenses Planned £0 Actual £603

Income Planned £0 Actual £2,034

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£603
-£603		 Planned
Actual
Diff.
Totals
£0
£2,034
+£2,034
Hamper Expend £0 £491
-£491
£0
£0
£0
£0
£0
£0
£0
£0
£53
-£53
£0
£0
£0
£0
£53
-£53
£0
£0
£6
-£6		 Donations General £0 £210
+£210
£1,500
+£1,500
£0
£0
£150
+£150
£0
£0
£0
£0
£0
£0
£174
+£174
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

E I I
xpenses
R
Date
Amount Description
Category		 ncome
Date
Amount Description
Category
07/07/2021
£174.20
Facebook Donations
Donations Justgiving / Online
07/07/2021
£500.00
Eaton Electrical Donation
Donations Business / Org
16/07/2021
£1,000.00 Arnold Clark Autos - Donation
Donations Business / Org
20/07/2021
£60.00
donation for Richard Souter
Donations General
28/07/2021
£150.00
cheque donated by Jack Haughey
Donations General
30/07/2021
£150.00
Wedding Favour Badges x 50 Donation K CheswortFundraising / Events
02/07/2021
£100.00
Dunelm x 10 baskets
Hamper Expend
02/07/2021
£22.00
Hobbycraft personalised items
Hamper Expend
04/07/2021
£18.59
Amazon personalised items
Hamper Expend
06/07/2021
£6.00
Facebook Bank Transfer Charge
Misc
07/07/2021
£7.00
Poundland hamper items
Hamper Expend
12/07/2021
£59.03
Amazon personalised items
Hamper Expend
12/07/2021
£20.54
Domain Renewal
Website Costs
12/07/2021
£14.39
Domain Renewal
Website Costs
15/07/2021
£52.70
Wedding Favour Card - Vista PrintEvent / Fundraise Expend
17/07/2021
£29.98
Amazon personalised items
Hamper Expend
17/07/2021
£10.00
Tesco hamper items
Hamper Expend
17/07/2021
£54.28
Home Bargain
Hamper Expend		 07/07/2021
£174.20
Facebook Donations
Donations Justgiving / Online
07/07/2021
£500.00
Eaton Electrical Donation
Donations Business / Org
16/07/2021
£1,000.00 Arnold Clark Autos - Donation
Donations Business / Org
20/07/2021
£60.00
donation for Richard Souter
Donations General
28/07/2021
£150.00
cheque donated by Jack Haughey
Donations General
30/07/2021
£150.00
Wedding Favour Badges x 50 Donation K CheswortFundraising / Events
18/07/2021
£18.00
IONOS Email Accounts
Website Costs
21/07/2021
£27.66
Amazon personalised items
Hamper Expend
21/07/2021
£11.94
Poundstretcher hamper items
Hamper Expend
21/07/2021
£18.00
Dunelm 3 blankets
Hamper Expend
21/07/2021
£63.98
Home Bargain hamper items
Hamper Expend
24/07/2021
£8.19
Amazon personalised items
Hamper Expend
24/07/2021
£10.29
Tesco
Hamper Expend
24/07/2021
£4.00
Asda personalise
Hamper Expend
28/07/2021
£21.97
Amazon personalised items
Hamper Expend
30/07/2021
£24.00
Matalan blankets x 4
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

August 2021 Finan

Balance start of month £64,076

The Katherine Allport Foundation

Expenses Planned £0 Actual £1,955

Income Planned £0 Actual £701

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,955
-£1,955		 Planned
Actual
Diff.
Totals
£0
£701
+£701
Hamper Expend £0 £681
-£681
£0
£0
£0
£0
£0
£0
£0
£0
£28
-£28
£0
£0
£0
£0
£18
-£18
£1,229
-£1,229
£0
£0		 Donations General £0 £197
+£197
£19
+£19
£0
£0
£240
+£240
£0
£0
£0
£0
£58
+£58
£187
+£187
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
04/08/2021
£98.40
Stripe Payments
Donations General
04/08/2021
£120.00
Katie Hannah Skydive Deposit
Fundraising / Events
06/08/2021
£60.00
Emma Staples Skydive Deposit
Fundraising / Events
09/08/2021
£49.10
Stripe Payments
Donations General
13/08/2021
£19.99
Amazon Refund
Other
17/08/2021
£19.03
Amazon Donations
Donations Business / Org
20/08/2021
£30.00
Funeral Donation Cheque
Donations General
23/08/2021
£60.00
Sue F Skydive Deposit
Fundraising / Events
25/08/2021
£186.96
Facebook Donations
Donations Justgiving / Online
31/08/2021
£38.40
Dunelm Refund
Other
31/08/2021
£19.52
Stripe Payments
Donations General		 Date
Amount Description
Category
04/08/2021
£98.40
Stripe Payments
Donations General
04/08/2021
£120.00
Katie Hannah Skydive Deposit
Fundraising / Events
06/08/2021
£60.00
Emma Staples Skydive Deposit
Fundraising / Events
09/08/2021
£49.10
Stripe Payments
Donations General
13/08/2021
£19.99
Amazon Refund
Other
17/08/2021
£19.03
Amazon Donations
Donations Business / Org
20/08/2021
£30.00
Funeral Donation Cheque
Donations General
23/08/2021
£60.00
Sue F Skydive Deposit
Fundraising / Events
25/08/2021
£186.96
Facebook Donations
Donations Justgiving / Online
31/08/2021
£38.40
Dunelm Refund
Other
31/08/2021
£19.52
Stripe Payments
Donations General
04/08/2021
£18.00
The works hamper items
Hamper Expend
04/08/2021
£21.00
Primark personalise items
Hamper Expend
04/08/2021
£12.84
Home Bargain items for hamper
Hamper Expend
05/08/2021
£8.52
E Bay donation pots
Event / Fundraise Expend
06/08/2021
£7.50
Tesco hamper products
Hamper Expend
07/08/2021
26..53
Tesco hamper products
Hamper Expend
07/08/2021
£5.25
Matalan ice lolly moulds
Hamper Expend
07/08/2021
£61.49
Home Bargain hamper items
Hamper Expend
08/08/2021
£17.94
The Range hamper items
Hamper Expend
08/08/2021
£23.83
Amazon personalised items
Hamper Expend
09/08/2021
£30.00
Dunelm baskets x3
Hamper Expend
09/08/2021
£19.97
Amazon sample baskets
Hamper Expend		 04/08/2021
£98.40
Stripe Payments
Donations General
04/08/2021
£120.00
Katie Hannah Skydive Deposit
Fundraising / Events
06/08/2021
£60.00
Emma Staples Skydive Deposit
Fundraising / Events
09/08/2021
£49.10
Stripe Payments
Donations General
13/08/2021
£19.99
Amazon Refund
Other
17/08/2021
£19.03
Amazon Donations
Donations Business / Org
20/08/2021
£30.00
Funeral Donation Cheque
Donations General
23/08/2021
£60.00
Sue F Skydive Deposit
Fundraising / Events
25/08/2021
£186.96
Facebook Donations
Donations Justgiving / Online
31/08/2021
£38.40
Dunelm Refund
Other
31/08/2021
£19.52
Stripe Payments
Donations General
15/08/2021
£16.85
Amazon hamper items
Hamper Expend
16/08/2021
£1,229.00 Amazon 7 tablets 4 portals
Tablet Computer Purchases (S
18/08/2021
£13.75
Tesco chocs for Xmas raffle
Event / Fundraise Expend
18/08/2021
£19.31
B&M hamper toiletries
Hamper Expend
18/08/2021
£30.00
Matalan blankets x 6
Hamper Expend
19/08/2021
£2.79
t shirt for fundraiser
Event / Fundraise Expend
19/08/2021
£2.50
transfers for the shirt
Event / Fundraise Expend
20/08/2021
£10.00
Dunelm basket x 1
Hamper Expend
23/08/2021
£18.00
IONOS Email Account
Website Costs
25/08/2021
£18.48
Amazon personalised items
Hamper Expend
25/08/2021
£29.97
B & M hamper items
Hamper Expend
25/08/2021
£14.00
Tesco hamper items
Hamper Expend
25/08/2021
£38.42
Asda hamper items
Hamper Expend
25/08/2021
£18.50
Matalan hamper items
Hamper Expend
27/08/2021
£38.40
Dunelm baskets x 4
Hamper Expend
28/08/2021
£33.94
Asda hamper items
Hamper Expend
28/08/2021
£5.98
Boots hamper toiletries child
Hamper Expend
28/08/2021
£22.00
Tesco hamper items
Hamper Expend
28/08/2021
£13.99
B & M hamper items
Hamper Expend
28/08/2021
£79.85
B & M hamper items and baskets
Hamper Expend
28/08/2021
£28.80
Dunelm baskets x3
Hamper Expend
31/08/2021
£44.47
Amazon personalised items
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

September 2021 F

Balance start of month £62,795

The Katherine Allport Foundation

Expenses Planned £0 Actual £909

Income Planned £0 Actual £3,080

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£909
-£909		 Planned
Actual
Diff.
Totals
£0
£3,080
+£3,080
Hamper Expend £0 £889
-£889
£2
-£2
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£18
-£18
£0
£0
£0
£0		 Donations General £0 £440
+£440
£845
+£845
£0
£0
£0
£0
£0
£0
£0
£0
£0
£0
£1,795
+£1,795
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
06/09/2021
£384.86
Stripe Payments
Donations General
10/09/2021
£773.31
PayPal Giving Fund
Donations Business / Org
10/09/2021
£1,290.26 Facebook Donations
Donations Justgiving / Online
10/09/2021
£339.25
PayPal Donations
Donations Justgiving / Online
13/09/2021
£25.00
donation Zoe Smith
Donations General
17/09/2021
£72.00
South Staffs Community Innovation
Donations Business / Org
20/09/2021
£9.66
Stripe Payments
Donations General
22/09/2021
£20.00
Donation Emma Shorthouse
Donations General
23/09/2021
£165.18
Facebook Donations
Donations Justgiving / Online		 Date
Amount Description
Category
06/09/2021
£384.86
Stripe Payments
Donations General
10/09/2021
£773.31
PayPal Giving Fund
Donations Business / Org
10/09/2021
£1,290.26 Facebook Donations
Donations Justgiving / Online
10/09/2021
£339.25
PayPal Donations
Donations Justgiving / Online
13/09/2021
£25.00
donation Zoe Smith
Donations General
17/09/2021
£72.00
South Staffs Community Innovation
Donations Business / Org
20/09/2021
£9.66
Stripe Payments
Donations General
22/09/2021
£20.00
Donation Emma Shorthouse
Donations General
23/09/2021
£165.18
Facebook Donations
Donations Justgiving / Online
01/09/2021
£11.10
Tesco chocolate etc.
Hamper Expend
04/09/2021
£83.15
Amazon personalised items
Hamper Expend
06/09/2021
£28.95
Amazon hamper items
Hamper Expend
08/09/2021
£19.61
Amazon personalised items
Hamper Expend
09/09/2021
£52.31
Amazon personalised items
Hamper Expend
09/09/2021
£92.58
Amazon Aveeno, E45 + toiletries
Hamper Expend
10/09/2021
£10.00
Newlife Cancer Socks x 9
Hamper Expend
10/09/2021
£16.00
Matalan pillows x 3
Hamper Expend
10/09/2021
£44.27
B&M Hamper items
Hamper Expend
10/09/2021
£63.92
The Range hamper items
Hamper Expend
10/09/2021
£42.00
Primark hamper items
Hamper Expend
11/09/2021
£6.00
Tesco biscuits
Hamper Expend		 06/09/2021
£384.86
Stripe Payments
Donations General
10/09/2021
£773.31
PayPal Giving Fund
Donations Business / Org
10/09/2021
£1,290.26 Facebook Donations
Donations Justgiving / Online
10/09/2021
£339.25
PayPal Donations
Donations Justgiving / Online
13/09/2021
£25.00
donation Zoe Smith
Donations General
17/09/2021
£72.00
South Staffs Community Innovation
Donations Business / Org
20/09/2021
£9.66
Stripe Payments
Donations General
22/09/2021
£20.00
Donation Emma Shorthouse
Donations General
23/09/2021
£165.18
Facebook Donations
Donations Justgiving / Online
11/09/2021
£20.65
B&M hamper items
Hamper Expend
13/09/2021
£67.51
Amazon personalised items
Hamper Expend
15/09/2021
£8.00
Dunelm
Hamper Expend
15/09/2021
£26.59
B&M hamper items
Hamper Expend
15/09/2021
£9.50
Tesco chocolate and biscuits
Hamper Expend
16/09/2021
£2.00
Deposit FIFA 22 for Gift
Gifts / Experience Days
18/09/2021
£18.00
IONOS Email
Website Costs
26/09/2021
£5.00
The Works Colouring books
Hamper Expend
26/09/2021
£5.47
Home Bargain hamper items
Hamper Expend
08/09/2821
£100.00
Dunelm baskets x 10
Hamper Expend
10/09/2821
£72.98
Home Bargain hamper items
Hamper Expend
15/09/2821
£8.99
Amazon personalised items
Hamper Expend
15/09/2821
£26.55
Asda personalised items
Hamper Expend
15/09/2821
£12.00
Matalan hamper items
Hamper Expend
26/09/2821
£55.65
Tesco hamper items
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

October 2021 Fina

Balance start of month £66,029

The Katherine Allport Foundation

Expenses Planned £0 Actual £2,765

Income Planned £0 Actual £526

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£2,765
-£2,765		 Planned
Actual
Diff.
Totals
£0
£526
+£526
Hamper Expend £0 £453
-£453
£53
-£53
£0
£0
£0
£0
£922
-£922
£1,320
-£1,320
£0
£0
£0
£0
£18
-£18
£0
£0
£0
£0		 Donations General £0 £20
+£20
£0
£0
£0
£0
£200
+£200
£0
£0
£0
£0
£0
£0
£306
+£306
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
08/10/2021
£305.84
Facebook Payment
Donations Justgiving / Online
18/10/2021
£20.00
B Baker Cheque Donation
Donations General
25/10/2021
£199.76
Stripe Online Payments
Fundraising / Events		 Date
Amount Description
Category
08/10/2021
£305.84
Facebook Payment
Donations Justgiving / Online
18/10/2021
£20.00
B Baker Cheque Donation
Donations General
25/10/2021
£199.76
Stripe Online Payments
Fundraising / Events
04/10/2021
£52.99
GAME FIFA 22 - Gift
Gifts / Experience Days
06/10/2021
£921.60
Rocket Merchandise - Pens / Air freMerchandise Purchases
13/10/2021
£22.75
Asda hamper items
Hamper Expend
13/10/2021
£21.98
Tesco hamper products
Hamper Expend
13/10/2021
£19.46
B&M hamper items
Hamper Expend
13/10/2021
£34.00
Primark hamper items
Hamper Expend
13/10/2021
£18.00
Matalan blankets
Hamper Expend
13/10/2021
£106.68
Amazon personalised items
Hamper Expend
13/10/2021
£14.98
Amazon personalised items
Hamper Expend
14/10/2021
£500.00
cash for curry night
Event / Fundraise Expend
15/10/2021
£250.00
cash for curry night
Event / Fundraise Expend
15/10/2021
£250.00
cash for curry night
Event / Fundraise Expend		 08/10/2021
£305.84
Facebook Payment
Donations Justgiving / Online
18/10/2021
£20.00
B Baker Cheque Donation
Donations General
25/10/2021
£199.76
Stripe Online Payments
Fundraising / Events
16/10/2021
£250.00
cash for curry night
Event / Fundraise Expend
16/10/2021
£14.69
Tesco hamper products
Hamper Expend
17/10/2021
£70.00
cash for curry night
Event / Fundraise Expend
22/10/2021
£22.98
Amazon personalised items
Hamper Expend
22/10/2021
£10.39
Tesco hamper products
Hamper Expend
25/10/2021
£100.00
Dunelm baskets x 10
Hamper Expend
25/10/2021
£18.00
Ionos Webmail
Website Costs
27/10/2021
£24.00
Matalan online x 4 pillows
Hamper Expend
27/10/2021
£6.00
Matalan blanket man's
Hamper Expend
27/10/2021
£20.41
Home Bargain hamper items
Hamper Expend
27/10/2021
£16.37
Amazon personalised items
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

Nov 2021 Finance

Balance start of month £63,842

The Katherine Allport Foundation

Expenses Planned £0 Actual £1,137

Income Planned £0 Actual £3,803

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,137
-£1,137		 Planned
Actual
Diff.
Totals
£0
£3,803
+£3,803
Hamper Expend £0 £887
-£887
£121
-£121
£0
£0
£0
£0
£0
£0
£11
-£11
£0
£0
£0
£0
£18
-£18
£0
£0
£100
-£100		 Donations General £0 £0
£0
£1,055
+£1,055
£0
£0
£2,307
+£2,307
£0
£0
£0
£0
£0
£0
£441
+£441
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Income

Date
Amount Description
Category		 Date
Amount Description
Category
01/11/2021
£99.68
Stripe Online Payments
Fundraising / Events
05/11/2021
£20.00
Sonya Curry Night Donation
Fundraising / Events
08/11/2021
£34.00
Debbie Ho Curry Donation
Fundraising / Events
08/11/2021
£84.75
Farish Quiz Donation
Fundraising / Events
08/11/2021
£176.67
Facebook Donations
Donations Justgiving / Online
08/11/2021
£565.86
Stripe Online Payments
Fundraising / Events
09/11/2021
£1,055.00 Littleton Arms Donation (Shirt Night)
Donations Business / Org
15/11/2021
£492.80
Stripe Online Payments
Fundraising / Events
22/11/2021
£245.02
Facebook Donations
Donations Justgiving / Online
29/11/2021
£1,010.25 Stripe Online Payments
Fundraising / Events
30/11/2021
£19.42
Justgiving Donation
Donations Justgiving / Online		 Date
Amount Description
Category
01/11/2021
£99.68
Stripe Online Payments
Fundraising / Events
05/11/2021
£20.00
Sonya Curry Night Donation
Fundraising / Events
08/11/2021
£34.00
Debbie Ho Curry Donation
Fundraising / Events
08/11/2021
£84.75
Farish Quiz Donation
Fundraising / Events
08/11/2021
£176.67
Facebook Donations
Donations Justgiving / Online
08/11/2021
£565.86
Stripe Online Payments
Fundraising / Events
09/11/2021
£1,055.00 Littleton Arms Donation (Shirt Night)
Donations Business / Org
15/11/2021
£492.80
Stripe Online Payments
Fundraising / Events
22/11/2021
£245.02
Facebook Donations
Donations Justgiving / Online
29/11/2021
£1,010.25 Stripe Online Payments
Fundraising / Events
30/11/2021
£19.42
Justgiving Donation
Donations Justgiving / Online
02/11/2021
£100.00
petty cash
Misc
02/11/2021
£21.48
B&M
Hamper Expend
02/11/2021
£3.99
Amazon personalised
Hamper Expend
03/11/2021
£10.99
Amazon
Event / Fundraise Expend
08/11/2021
£56.23
Amazon
Hamper Expend
10/11/2021
£39.00
Mstalan
Hamper Expend
10/11/2021
£32.09
B&M
Hamper Expend
10/11/2021
£6.79
Tesco
Hamper Expend
10/11/2021
£52.70
Asda
Hamper Expend
10/11/2021
£15.00
Dunelm baskets
Hamper Expend
11/11/2021
£68.22
Amazon
Hamper Expend
11/11/2021
£24.38
The Range
Hamper Expend		 01/11/2021
£99.68
Stripe Online Payments
Fundraising / Events
05/11/2021
£20.00
Sonya Curry Night Donation
Fundraising / Events
08/11/2021
£34.00
Debbie Ho Curry Donation
Fundraising / Events
08/11/2021
£84.75
Farish Quiz Donation
Fundraising / Events
08/11/2021
£176.67
Facebook Donations
Donations Justgiving / Online
08/11/2021
£565.86
Stripe Online Payments
Fundraising / Events
09/11/2021
£1,055.00 Littleton Arms Donation (Shirt Night)
Donations Business / Org
15/11/2021
£492.80
Stripe Online Payments
Fundraising / Events
22/11/2021
£245.02
Facebook Donations
Donations Justgiving / Online
29/11/2021
£1,010.25 Stripe Online Payments
Fundraising / Events
30/11/2021
£19.42
Justgiving Donation
Donations Justgiving / Online
13/11/2021
£20.00
Primark
Hamper Expend
14/11/2021
£9.28
Tesco
Hamper Expend
14/11/2021
£5.00
B&M
Hamper Expend
15/11/2021
£70.99
WBA football kit
Gifts / Experience Days
16/11/2021
£14.99
Amazon
Hamper Expend
17/11/2021
£37.82
Amazon
Hamper Expend
17/11/2021
£21.50
B&M
Hamper Expend
17/11/2021
£24.00
Amazon
Hamper Expend
17/11/2021
£16.80
Matalan
Hamper Expend
19/11/2021
£50.00
WBA Gift
Gifts / Experience Days
20/11/2021
£38.03
Amazon personalised
Hamper Expend
21/11/2021
£46.49
B&M
Hamper Expend
22/11/2021
£78.26
Amazon
Hamper Expend
23/11/2021
£18.00
Ionos Email
Website Costs
24/11/2021
£7.99
Amazon personalised
Hamper Expend
24/11/2021
£10.49
B&M HAMPER
Hamper Expend
24/11/2021
£76.30
Primark hamper
Hamper Expend
24/11/2021
£15.00
Asda hamper
Hamper Expend
25/11/2021
£18.73
Amazon personalised
Hamper Expend
25/11/2021
£100.00
10 x baskets Dunelm
Hamper Expend
25/11/2021
£25.98
Amazon personalised
Hamper Expend

GET STARTED

NOTE

Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.

Only edit highlighted cells. Try not to alter cells that contain a formula.

Dec 2021 Finance (Including 01/01/2022) The Katherine Allport Foundation

Balance start of month £66,509

Expenses

Planned £0 Actual £1,448

Income Planned £0 Actual £6,298

Expenses

Income

Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income		 Expenses
Income
Planned
Actual
Diff.
Totals
£0
£1,448
-£1,448		 Planned
Actual
Diff.
Totals
£0
£6,298
+£6,298
Hamper Expend £0 £253
-£253
£0
£0
£0
£0
£0
£0
£0
£0
£1,177
-£1,177
£0
£0
£0
£0
£18
-£18
£0
£0
£0
£0		 Donations General £0 £2,077
+£2,077
£22
+£22
£85
+£85
£2,858
+£2,858
£0
£0
£0
£0
£0
£0
£1,255
+£1,255
Gifts / Experience Days £0 Donations Business / Or
£0
Complimenary Therapy £0 Merchandise Sales £0
Charitable Donations £0 Fundraising / Events £0
Merchandise Purchases £0 Food Sales £0
Event / Fundraise Expen
£0		 Interest £0
Food For Charity Boxes £0 Other £0
Reimbursment Voluntee
£0		 Donations Justgiving / O
Website Costs £0
Tablet Computer Purcha
£0
Misc £0

Change or add categories by updating the Expenses and Income tables in the Summary sheet.

Expenses

Date **Amount ** Description Category
02/12/2021 £20.98 Amazon personalised Hamper Expend
04/12/2021 £49.47 B&M Hamper Items Hamper Expend
09/12/2021 £30.68 Amazon's Hamper Expend
11/12/2021 £16.00 Tesco blankets Hamper Expend
15/12/2021 £66.86 Home Bargain Hamper Items Hamper Expend
16/12/2021 £1,177.19 Running Imp x 400 Medals Hampe Event / Fundraise Expend
23/12/2021 £18.00 IONOS Email Website Costs
06/12/2021 £18.10 The Range Hamper Items Hamper Expend
16/12/2021 £27.52 Tesco Hamper Items Hamper Expend
16/12/2021 £23.20 Asda Hamper Items Hamper Expend

Income

Date
Amount Description
Category
01/12/2021
£85.42
Merchandise Sale
Merchandise Sales
01/12/2021
£387.00
Gymophobics Donation
Fundraising / Events
01/12/2021
£170.00
Ruby Donations
Fundraising / Events
01/12/2021
£66.42
Ambulance Donation Box
Donations General
01/12/2021
£1,916.00 Curry Night Ticket Sales
Fundraising / Events		 Date
Amount Description
Category
01/12/2021
£85.42
Merchandise Sale
Merchandise Sales
01/12/2021
£387.00
Gymophobics Donation
Fundraising / Events
01/12/2021
£170.00
Ruby Donations
Fundraising / Events
01/12/2021
£66.42
Ambulance Donation Box
Donations General
01/12/2021
£1,916.00 Curry Night Ticket Sales
Fundraising / Events
01/12/2021
£85.42
Merchandise Sale
Merchandise Sales
01/12/2021
£387.00
Gymophobics Donation
Fundraising / Events
01/12/2021
£170.00
Ruby Donations
Fundraising / Events
01/12/2021
£66.42
Ambulance Donation Box
Donations General
01/12/2021
£1,916.00 Curry Night Ticket Sales
Fundraising / Events
01/12/2021
£385.00
Curry Night Ticket Refund (Meals We Didnt Sell)
Fundraising / Events
01/12/2021
£250.00
Cheque Martin's Funeral
Donations General
01/12/2021
£110.00
General Cash Donations
Donations General
08/12/2021
£331.98
Facebook Donations
Donations Justgiving / Online
08/12/2021
£107.89
Paypal Donations
Donations Justgiving / Online
10/12/2021
£1,650.84 Donation Cheque
Donations General
13/12/2021
£22.43
Amazon Smile Donation
Donations Business / Org
20/12/2021
£88.34
Stripe Payments
Donations Justgiving / Online
24/12/2021
£726.33
Justgiving Donations
Donations Justgiving / Online

R￿￿$tÈrOd Offic&.. First Floor Of&"trs, 8¥90 Market Street. Hedn￿ord. StafFordshire, WS12 1AG Telephone". 01543 426271 Fax." 01543 878678 Email.. accounts@bradley5-Itd.co.uk Web.. vrf4y￿.brad1eY5-ltd.cO.uk Brad￿yOndCO BRADLEYS TAX k XCCthTANCY SERVICES The Katherine Allport Foundation 4 Beech Grove Huntington Cannock Staffordshire WS124QW Ih 25 October 2022 Dear Trustees, We have completed our audit of the Financial Accounts for The Katherine Allport Foundation. for the p¢riod ended l January 2022 and find that th¢ accounts for the period are a true and fair represenlation of the charities position. If you need any further assistance, please do not hesitate to contact us. Kind regards G. Lawton BA (Hons), FMAAT. Bradleys Accountancy Practice Company Number 4630957 Bradw Is z trading Style of 8radley Accountsncy Practice Ltd Directors." Susan Bradley. Philip BrBdley MAA T. coM￿nY Secretary. Susan Bradley

Section B Balance sheet

Fixed assets
Intangible assets (Note 15)
Tangible assets (Note 14)
Heritage assets (Note 16)
Investments (Note 17)
Total fixed assets
Current assets
Stocks (Note 18)
Debtors (Note 19)
Investments (Note 17.4)
Cash at bank and in hand (Note 24)
Total current assets
Creditors: amounts falling due within one
year (Note 20)
Net current assets/(liabilities)
Total assets less current liabilities
Creditors: amounts falling due after one
year (Note 20)
Provisions for liabilities
Total net assets or liabilities
Funds of the Charity
Endowment funds (Note 27)
Restricted income funds (Note 27)
Unrestricted funds
Revaluation reserve
Total funds
Signed by one or two trustees on behalf of all
the trustees		 Guidance Notes
B01
B02
B03
B04
B05
B06
B07
B08
B09
B10
B11
B12
B13
B14
B15
B16
B17
B18
B19
B20
B21		 Unrestricte
d funds
£
F01		 Restricted
income
funds
£
F02		 Endowment
funds
Total this
year
£
£
F03
F04		 Endowment
funds
Total this
year
£
£
F03
F04		 Total last
year
£
F05
- - - - -
- - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
- - - - -
67,989 - - 67,989 -
67,989 - - 67,989 -
- - - - -
67,989 - - 67,989 -
67,989 - - 67,989 -
- - - - -
- - - - -
67,989 - - 67,989 -
- - -
- - -
- - -
-
- - - - -
Signature Print Name Date of
approval
dd/mm/yyyy
Scott Allport 31/10/23

30/10/2023

CC17a (Excel)

1

Section C Notes to the accounts (cont)

Note 24 Cash at bank and in hand
Other
Cash at bank and on hand
Total
Short term cash investments (less than 3 months maturity date)
Short term deposits
This year
£		 Last year
£
- -
- -
67,989 -
- -
67,989 -

30/10/2023

CC17a (Excel)

1