Trustees’ Annual Report for the period
From 02/01/2022 - 01/01/2023
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. We have provided free extra warm fleeces to those going through Cancer so they can keep warm during the cost of living crisis. This was funded by a £5000 grant from the Community Foundation for Staffordshire |
|---|---|---|
| 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 119 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. - We also made 2 donations to St Giles Hospice in Whittington. One donation was £1500 and the other £2000. The donations allow us to be 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 ran our second "Hamper March" event where supporters walked the distance of a marahon throughout March whilst raising funds for our cause. - We distrubted nearly 300 extra warm fleeces to those going through Cancer tretment in Staffordshire. This was funded by a £5000 grant from The Community Foundation for Staffordshire. It was in response to the cost of living crisis experienced. |
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 £33943. £9812 of this income came from donations from Businesses or organisations such as:- - £5000 from Community Foundation for Staffordshire - £1585 from Rugeley British Legion Darts Team - £573 Gymophobics Ladies Gym - £600 Chase Colts FC Donation - £140 Hednesford"Old Boys" Donation. Another major income came from our Hamper March Charity walk. The event raised approximately £7675. Due to income from the 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. - We also held a Skydiving event in which we had 10 participants taking part. Each raising at least £450 to participate. EXPENDITURE The expenditure for this financial period totalled £17847 with a large expenditure (£8053) 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. Due to the cost of living increase the hampers cost more to produce. Another large expenditure of £3411 was the puchasing of fleeces for our Cosy for Chemo Fund. The rest of the fund will be spent in the coming year. Our website also cost the charity £606. This also includes the cost of our charity email addresses and also the purchasing of the Cosy for Chemo website. -£155 Jessups Dress down day - £8893 was donated in total through our Facebook page - £8700 was donated in total through Justgiving |
|---|---|---|
| Statement explaining the policy for holding reserves stating why they are held |
Para 1.22 P 122 |
The Foundation does not as yet have an official reserves policy. use to achieve our charitable goals. At the end of this financial year we have £85190.82 in our account which are unrestricted funds that we can 190.82 £8519082 |
|---|---|---|
| Amount of reserves held Reasons for holding zero reserves |
ara . Para 1.22 |
N/a £85 . |
| 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 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 |
Whole financial year | |||
| Claire Cale | Whole finacial year | |||
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 12/10/2023
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.
Jan 2022 Finance The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings -£432 Saved this month
£0 -£432
Expenses Planned £0 Actual £2,071
Income
Planned £0 Actual £1,638
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £2,071 -£2,071 |
Planned Totals £0 |
Actual Diff. £1,638 +£1,638 |
|||||
| Hamper Expend | £0 | £553 -£553 £0 £0 £0 £0 £1,500 -£1,500 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £0 £0 £0 £0 |
Donations General | £0 | £100 +£100 £1,123 +£1,123 £0 £0 £60 +£60 £0 £0 £0 £0 £0 £0 £356 +£356 |
||
| 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 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £1,638 | +£1,638 | ||
| Donations General | £0 | £100 | +£100 | ||
| Donations Business / Or | £0 | £1,123 | +£1,123 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £60 | +£60 | ||
| Food Sales | £0 | £0 | £0 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Donations Justgiving / O | £356 | +£356 | |||
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/2022 £48.90 Stripe Payments Donations Justgiving / Online 10/01/2022 £100.00 A Ford Donation Donations General 10/01/2022 £155.00 Jessup Donation (Dress Down Fundraiser) Donations Business / Org 10/01/2022 £967.59 Paypal Donations Donations Business / Org 10/01/2022 £177.67 Stripe Payments Donations Justgiving / Online 10/01/2022 £50.00 L Mahon Skydive Donation Fundraising / Events 11/01/2022 £98.29 Justgiving Donations Donations Justgiving / Online 13/01/2022 £10.00 L Mahon Skydive Donation Fundraising / Events 17/01/2022 £23.27 Stripe Payments Donations Justgiving / Online 24/01/2022 £7.69 Stripe Payments Donations Justgiving / Online |
Date Amount Description Category 04/01/2022 £48.90 Stripe Payments Donations Justgiving / Online 10/01/2022 £100.00 A Ford Donation Donations General 10/01/2022 £155.00 Jessup Donation (Dress Down Fundraiser) Donations Business / Org 10/01/2022 £967.59 Paypal Donations Donations Business / Org 10/01/2022 £177.67 Stripe Payments Donations Justgiving / Online 10/01/2022 £50.00 L Mahon Skydive Donation Fundraising / Events 11/01/2022 £98.29 Justgiving Donations Donations Justgiving / Online 13/01/2022 £10.00 L Mahon Skydive Donation Fundraising / Events 17/01/2022 £23.27 Stripe Payments Donations Justgiving / Online 24/01/2022 £7.69 Stripe Payments Donations Justgiving / Online |
|
|---|---|---|---|
| 02/01/2022 £66.92 Amazon Hamper Expend 04/01/2022 £1,500.00 St Giles Donation (Large EngravedCharitable Donations 07/01/2022 £62.47 Amazon Hamper Items Hamper Expend 10/01/2022 £70.18 Inkind Direct Hamper Expend 10/01/2022 £16.00 Tesco Hamper Items Hamper Expend 11/01/2022 £77.72 Amazon Hamper Items Hamper Expend 12/01/2022 £100.00 Baskets Dunelm Hamper Expend 17/01/2022 £15.81 Tesco Hamper Items Hamper Expend 21/01/2022 £31.50 Primark Hamper Items Hamper Expend 24/01/2022 £18.00 Ionos Webmail Website Costs 26/01/2022 £23.11 Amazon Hamper Items Hamper Expend 27/01/2022 £3.00 Asda Hamper Items Hamper Expend |
|||
| 04/01/2022 £48.90 Stripe Payments Donations Justgiving / Online |
|||
| 10/01/2022 £100.00 A Ford Donation Donations General |
|||
| 10/01/2022 £155.00 Jessup Donation (Dress Down Fundraiser) Donations Business / Org |
|||
| 10/01/2022 £967.59 Paypal Donations Donations Business / Org |
|||
| 10/01/2022 £177.67 Stripe Payments Donations Justgiving / Online |
|||
| 10/01/2022 £50.00 L Mahon Skydive Donation Fundraising / Events |
|||
| 11/01/2022 £98.29 Justgiving Donations Donations Justgiving / Online |
|||
| 13/01/2022 £10.00 L Mahon Skydive Donation Fundraising / Events |
|||
| 17/01/2022 £23.27 Stripe Payments Donations Justgiving / Online |
|||
| 24/01/2022 £7.69 Stripe Payments Donations Justgiving / Online |
|||
| 27/01/2022 £26.00 Matalan Baskets Hamper Expend 27/01/2022 £11.59 B & M Hamper Items Hamper Expend 28/01/2022 £48.50 Primark Hamper Items 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.
Feb 2022 Finance The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £892 Saved this month
£0 £892
Expenses Planned £0 Actual £865
Income Planned £0 Actual £1,758
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £865 -£865 |
Planned Totals £0 |
Actual Diff. £1,758 +£1,758 |
|||||
| Hamper Expend | £0 | £847 -£847 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £0 £0 £0 £0 |
Donations General | £0 | £50 +£50 £18 +£18 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £1,690 +£1,690 |
||
| 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 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £1,758 | +£1,758 | ||
| Donations General | £0 | £50 | +£50 | ||
| Donations Business / Or | £0 | £18 | +£18 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Food Sales | £0 | £0 | £0 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Donations Justgiving / O | £1,690 | +£1,690 | |||
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/2022 £58.06 Justgiving Donations Donations Justgiving / Online 07/02/2022 £106.87 Stripe Payments Donations Justgiving / Online 10/02/2022 £216.63 Facebook Donations Donations Justgiving / Online 14/02/2022 £146.11 Stripe Payments Donations Justgiving / Online 15/02/2022 £592.80 Justgiving Donations Donations Justgiving / Online 17/02/2022 £50.00 Burntwood Breast Care Cash Donation Donations General 21/02/2022 £91.30 Stripe Payments Donations Justgiving / Online 22/02/2022 £198.20 Justgiving Donations Donations Justgiving / Online 22/02/2022 £279.96 Facebook Donations Donations Justgiving / Online 23/02/2022 £17.61 Amazon Smile Donation Donations Business / Org |
Date Amount Description Category 01/02/2022 £58.06 Justgiving Donations Donations Justgiving / Online 07/02/2022 £106.87 Stripe Payments Donations Justgiving / Online 10/02/2022 £216.63 Facebook Donations Donations Justgiving / Online 14/02/2022 £146.11 Stripe Payments Donations Justgiving / Online 15/02/2022 £592.80 Justgiving Donations Donations Justgiving / Online 17/02/2022 £50.00 Burntwood Breast Care Cash Donation Donations General 21/02/2022 £91.30 Stripe Payments Donations Justgiving / Online 22/02/2022 £198.20 Justgiving Donations Donations Justgiving / Online 22/02/2022 £279.96 Facebook Donations Donations Justgiving / Online 23/02/2022 £17.61 Amazon Smile Donation Donations Business / Org |
|
|---|---|---|---|
| 03/02/2022 £15.43 The Range Hamper Expend 04/02/2022 £27.66 Amazon personalised items Hamper Expend 07/02/2022 £27.00 Matalan Blankets Hamper Expend 07/02/2022 £53.00 Primark hamper items Hamper Expend 07/02/2022 £9.00 Asda Hamper Items Hamper Expend 07/02/2022 £5.00 Tesco Hamper Items Hamper Expend 07/02/2022 £26.27 Tesco Hamper Items Hamper Expend 09/02/2022 £61.04 Amazon Aveeno, E45, Lypsyl Hamper Expend 14/02/2022 £15.96 Amazon Hamper Items Hamper Expend 14/02/2022 £23.76 Tesco Hamper Items Hamper Expend 17/02/2022 £30.00 Dunelm x 3 baskets Hamper Expend 21/02/2022 £29.25 Amazon personalised items Hamper Expend |
01/02/2022 £58.06 Justgiving Donations Donations Justgiving / Online |
||
| 07/02/2022 £106.87 Stripe Payments Donations Justgiving / Online |
|||
| 10/02/2022 £216.63 Facebook Donations Donations Justgiving / Online |
|||
| 14/02/2022 £146.11 Stripe Payments Donations Justgiving / Online |
|||
| 15/02/2022 £592.80 Justgiving Donations Donations Justgiving / Online |
|||
| 17/02/2022 £50.00 Burntwood Breast Care Cash Donation Donations General |
|||
| 21/02/2022 £91.30 Stripe Payments Donations Justgiving / Online |
|||
| 22/02/2022 £198.20 Justgiving Donations Donations Justgiving / Online |
|||
| 22/02/2022 £279.96 Facebook Donations Donations Justgiving / Online |
|||
| 23/02/2022 £17.61 Amazon Smile Donation Donations Business / Org |
|||
| 21/02/2022 £22.00 The Works Hamper Items Hamper Expend 21/02/2022 £11.54 Home Bargain Hamper Items Hamper Expend 21/02/2022 £49.78 Tesco Hamper Items Hamper Expend 21/02/2022 £21.60 Asda Hamper Items Hamper Expend 21/02/2022 £11.99 Amazon Hamper Items Hamper Expend 23/02/2022 £18.00 IONOS Webmail Website Costs 24/02/2022 £48.41 B & M Hamper Items Hamper Expend 25/02/2022 £91.43 Amazon hamper items Hamper Expend 25/02/2022 £100.00 Dunelm baskets x 10 Hamper Expend 25/02/2022 £98.40 Primark Hamper Items Hamper Expend 28/02/2022 £18.98 B & M Hamper Items Hamper Expend 28/02/2022 £28.89 The Range Hamper Items Hamper Expend 28/02/2022 £20.74 Amazon Hamper Items 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.
March 2022 Financ
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £3,586 Saved this month
£0 £3,586
Expenses Planned £0 Actual £665
Income Planned £0 Actual £4,252
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £665 -£665 |
Planned Totals £0 |
Actual Diff. £4,252 +£4,252 |
|||||
| Hamper Expend | £0 | £647 -£647 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £0 £0 £0 £0 |
Donations General | £0 | £367 +£367 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £3,885 +£3,885 |
||
| 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 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £4,252 | +£4,252 | ||
| Donations General | £0 | £367 | +£367 | ||
| Donations Business / Or | £0 | £0 | £0 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Food Sales | £0 | £0 | £0 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Donations Justgiving / O | £3,885 | +£3,885 | |||
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/2022 £111.21 Justgiving Donations Donations Justgiving / Online 02/03/2022 £157.00 Gymophobic Donations Donations General 04/03/2022 £210.00 HAYWARDBEFRI Donations Donations General 07/03/2022 £900.70 Facebook Donations Donations Justgiving / Online 07/03/2022 £46.73 Stripe Payments Donations Justgiving / Online 07/03/2022 £140.24 Justgiving Donations Donations Justgiving / Online 14/03/2022 £68.62 Stripe Payments Donations Justgiving / Online 15/03/2022 £422.92 Justgiving Donations Donations Justgiving / Online 21/03/2022 £1,293.68 Facebook Donations Donations Justgiving / Online 21/03/2022 £569.46 Justgiving Donations Donations Justgiving / Online 28/03/2022 £39.24 Stripe Payments Donations Justgiving / Online 28/03/2022 £291.90 Justgiving Donations Donations Justgiving / Online |
Date Amount Description Category 01/03/2022 £111.21 Justgiving Donations Donations Justgiving / Online 02/03/2022 £157.00 Gymophobic Donations Donations General 04/03/2022 £210.00 HAYWARDBEFRI Donations Donations General 07/03/2022 £900.70 Facebook Donations Donations Justgiving / Online 07/03/2022 £46.73 Stripe Payments Donations Justgiving / Online 07/03/2022 £140.24 Justgiving Donations Donations Justgiving / Online 14/03/2022 £68.62 Stripe Payments Donations Justgiving / Online 15/03/2022 £422.92 Justgiving Donations Donations Justgiving / Online 21/03/2022 £1,293.68 Facebook Donations Donations Justgiving / Online 21/03/2022 £569.46 Justgiving Donations Donations Justgiving / Online 28/03/2022 £39.24 Stripe Payments Donations Justgiving / Online 28/03/2022 £291.90 Justgiving Donations Donations Justgiving / Online |
|
|---|---|---|---|
| 01/03/2022 £7.39 Tesco Hamper Items Hamper Expend 05/03/2022 £26.94 Amazon Hamper Items Hamper Expend 07/03/2022 £37.22 Amazon Hamper Items Hamper Expend 08/03/2022 £20.89 Amazon Hamper Items Hamper Expend 08/03/2022 £15.91 Tesco Hamper Items Hamper Expend 14/03/2022 £23.00 Tesco Hamper Items Hamper Expend 14/03/2022 £28.50 Asda Hamper Items Hamper Expend 14/03/2022 £20.99 Amazon Hamper Items Hamper Expend 14/03/2022 £4.75 Tesco Hamper Items Hamper Expend 21/03/2022 £15.50 Tesco Hamper Items Hamper Expend 21/03/2022 £100.00 Dunelm baskets x 10 Hamper Expend 21/03/2022 £36.92 Amazon Hamper Items Hamper Expend |
01/03/2022 £111.21 Justgiving Donations Donations Justgiving / Online |
||
| 02/03/2022 £157.00 Gymophobic Donations Donations General |
|||
| 04/03/2022 £210.00 HAYWARDBEFRI Donations Donations General |
|||
| 07/03/2022 £900.70 Facebook Donations Donations Justgiving / Online |
|||
| 07/03/2022 £46.73 Stripe Payments Donations Justgiving / Online |
|||
| 07/03/2022 £140.24 Justgiving Donations Donations Justgiving / Online |
|||
| 14/03/2022 £68.62 Stripe Payments Donations Justgiving / Online |
|||
| 15/03/2022 £422.92 Justgiving Donations Donations Justgiving / Online |
|||
| 21/03/2022 £1,293.68 Facebook Donations Donations Justgiving / Online |
|||
| 21/03/2022 £569.46 Justgiving Donations Donations Justgiving / Online |
|||
| 28/03/2022 £39.24 Stripe Payments Donations Justgiving / Online |
|||
| 28/03/2022 £291.90 Justgiving Donations Donations Justgiving / Online |
|||
| 22/03/2022 £49.09 Home Bargain Hamper Items Hamper Expend 22/03/2022 £47.05 Asda Hamper Items Hamper Expend 22/03/2022 £52.45 Matalan Hamper Items Hamper Expend 22/03/2022 £24.87 B &M Hamper Items Hamper Expend 22/03/2022 £38.00 Dunelm Hamper Items Hamper Expend 22/03/2022 £15.42 The Range Hamper Items Hamper Expend 22/03/2022 £10.82 Tesco Hamper Items Hamper Expend 23/03/2022 £23.09 Amazon Hamper Items Hamper Expend 23/03/2022 £18.00 IONOS Webmail Website Costs 28/03/2022 £23.68 Amazon Hamper Items Hamper Expend 30/03/2022 £24.88 Amazon Hamper Items 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.
April 2022 Finance
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £7,104 Saved this month
£0 £7,104
Expenses Planned £0 Actual £1,116
Income Planned £0 Actual £8,221
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £1,116 -£1,116 |
Planned Totals £0 |
Actual Diff. £8,221 +£8,221 |
|||||
| Hamper Expend | £0 | £903 -£903 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £100 -£100 £0 £0 £95 -£95 |
Donations General | £0 | £96 +£96 £1,585 +£1,585 £0 £0 £1,573 +£1,573 £908 +£908 £0 £0 £0 £0 £3,169 +£3,169 £0 £0 £890 +£890 |
||
| Gifts / Experience Days | £0 | Donations Business / Or | £0 |
||||
| Complimenary Therapy | £0 | Merchandise Sales | £0 | ||||
| Charitable Donations | £0 | Fundraising / Events | £0 | ||||
| Merchandise Purchases | £0 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £8,221 | +£8,221 | ||
| Donations General | £0 | £96 | +£96 | ||
| Donations Business / Or | £0 | £1,585 | +£1,585 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £1,573 | +£1,573 | ||
| Justgiving Donations | £0 | £908 | +£908 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Facebook Donations | £3,169 | +£3,169 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £890 | +£890 | |||
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/04/2022 £1,958.04 Facebook Donations Facebook Donations 04/04/2022 £29.18 Stripe Payments Stripe Payments 04/04/2022 £107.30 Justgiving Donations Justgiving Donations 05/04/2022 £60.00 H Allman Skydive Deposit Fundraising / Events 05/04/2022 £1,585.00 Rugeley British Legion Ladies Darts Donation Donations Business / Org 05/04/2022 £776.70 PayPal Online Donations Fundraising / Events 11/04/2022 £787.00 Stripe Payments Stripe Payments 11/04/2022 £271.00 A Crawford Hamper March Donations Fundraising / Events 11/04/2022 £742.10 Justgiving Donations Justgiving Donations 13/04/2022 £375.00 Nicki Hewitt Donations Fundraising / Events 13/04/2022 £90.00 Jo Cooper Donations Fundraising / Events 13/04/2022 £96.00 General Cash Donations Donations General |
Date Amount Description Category 04/04/2022 £1,958.04 Facebook Donations Facebook Donations 04/04/2022 £29.18 Stripe Payments Stripe Payments 04/04/2022 £107.30 Justgiving Donations Justgiving Donations 05/04/2022 £60.00 H Allman Skydive Deposit Fundraising / Events 05/04/2022 £1,585.00 Rugeley British Legion Ladies Darts Donation Donations Business / Org 05/04/2022 £776.70 PayPal Online Donations Fundraising / Events 11/04/2022 £787.00 Stripe Payments Stripe Payments 11/04/2022 £271.00 A Crawford Hamper March Donations Fundraising / Events 11/04/2022 £742.10 Justgiving Donations Justgiving Donations 13/04/2022 £375.00 Nicki Hewitt Donations Fundraising / Events 13/04/2022 £90.00 Jo Cooper Donations Fundraising / Events 13/04/2022 £96.00 General Cash Donations Donations General |
|
|---|---|---|---|
| 01/04/2022 £25.91 Home Bargains Hamper Items Hamper Expend 04/04/2022 £11.00 ASDA Hamper Items Hamper Expend 04/04/2022 £50.00 Primark Hamper Items Hamper Expend 04/04/2022 £100.00 Petty Cash Withdrawal Petty Cash 05/04/2022 £101.95 Amazon Hamper Items Hamper Expend 05/04/2022 £11.25 Etsy Personalised Hamper Item Hamper Expend 07/04/2022 £15.00 ASDA Hamper Items Hamper Expend 08/04/2022 £33.74 Tesco Hamper Items Hamper Expend 11/04/2022 £40.96 B&M Hamper Items Hamper Expend 11/04/2022 £150.00 Dunelm Hamper Baskets Hamper Expend 11/04/2022 £14.00 B&Q Hamper Items Hamper Expend 13/04/2022 £36.11 Amazon Hamper Items Hamper Expend |
04/04/2022 £1,958.04 Facebook Donations Facebook Donations |
||
| 04/04/2022 £29.18 Stripe Payments Stripe Payments |
|||
| 04/04/2022 £107.30 Justgiving Donations Justgiving Donations |
|||
| 05/04/2022 £60.00 H Allman Skydive Deposit Fundraising / Events |
|||
| 05/04/2022 £1,585.00 Rugeley British Legion Ladies Darts Donation Donations Business / Org |
|||
| 05/04/2022 £776.70 PayPal Online Donations Fundraising / Events |
|||
| 11/04/2022 £787.00 Stripe Payments Stripe Payments |
|||
| 11/04/2022 £271.00 A Crawford Hamper March Donations Fundraising / Events |
|||
| 11/04/2022 £742.10 Justgiving Donations Justgiving Donations |
|||
| 13/04/2022 £375.00 Nicki Hewitt Donations Fundraising / Events |
|||
| 13/04/2022 £90.00 Jo Cooper Donations Fundraising / Events |
|||
| 13/04/2022 £96.00 General Cash Donations Donations General |
|||
| 13/04/2022 £95.00 S Tonks Skydive Refund Other 14/04/2022 £55.05 Amazon Hamper Items Hamper Expend 14/04/2022 £24.00 Matalan Hamper Items Hamper Expend 14/04/2022 £46.50 ASDA Hamper Items Hamper Expend 14/04/2022 £31.96 B&M Hamper Items Hamper Expend 14/04/2022 £40.00 Tesco Hamper Items Hamper Expend 19/04/2022 £6.00 Primark Hamper Items Hamper Expend 20/04/2022 £85.02 Amazon Hamper Items Hamper Expend 24/04/2022 £18.10 Tesco hamper products Hamper Expend 25/04/2022 £18.00 Ionos Webmail Website Costs 25/04/2022 £24.41 Inkind Direct Hamper Items Hamper Expend 25/04/2022 £64.24 Amazon Hamper Items Hamper Expend 25/04/2022 £18.10 Tesco Hamper Items Hamper Expend |
19/04/2022 £73.55 Stripe Payments Stripe Payments |
||
| 19/04/2022 £58.66 Justgiving Donations Justgiving Donations |
|||
| 20/04/2022 £1,211.23 Facebook Donations Facebook Donations |
|||
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.
May 2022 Finance
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £259 Saved this month
£0 £259
Expenses Planned £0 Actual £2,145
Income Planned £0 Actual £2,404
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £2,145 -£2,145 |
Planned Totals £0 |
Actual Diff. £2,404 +£2,404 |
|||||
| Hamper Expend | £0 | £423 -£423 £0 £0 £0 £0 £0 £0 £0 £0 £1,703 -£1,703 £0 £0 £0 £0 £18 -£18 £0 £0 £2 -£2 £0 £0 |
Donations General | £0 | £350 +£350 £326 +£326 £0 £0 £180 +£180 £456 +£456 £0 £0 £16 +£16 £880 +£880 £0 £0 £197 +£197 |
||
| Gifts / Experience Days | £0 | Donations Business / Or | £0 |
||||
| Complimenary Therapy | £0 | Merchandise Sales | £0 | ||||
| Charitable Donations | £0 | Fundraising / Events | £0 | ||||
| Merchandise Purchases | £0 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £2,404 | +£2,404 | ||
| Donations General | £0 | £350 | +£350 | ||
| Donations Business / Or | £0 | £326 | +£326 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £180 | +£180 | ||
| Justgiving Donations | £0 | £456 | +£456 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £16 | +£16 | ||
| Facebook Donations | £880 | +£880 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £197 | +£197 | |||
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 03/05/2022 £5.00 PAYPAL Giving Fund Donations Business / Org 03/05/2022 £20.00 Donnell Cheque Donations General 03/05/2022 £20.00 Donnell Cheque Donations General 03/05/2022 £20.00 Donnell Cheque Donations General 04/05/2022 £123.17 Facebook Online Donations Facebook Donations 09/05/2022 £15.79 Credit Amazon Other 16/05/2022 £160.00 HART Ambulance Donation Donations General 16/05/2022 £196.80 Stripe Online Donations Stripe Payments 16/05/2022 £398.40 Justgiving Donations Justgiving Donations 16/05/2022 £320.77 Cheque Paypal Giving Fund Donations Business / Org 18/05/2022 £110.00 Cheque D Burns Donations General 23/05/2022 £20.00 K Phillips Donation Donations General |
Date Amount Description Category 03/05/2022 £5.00 PAYPAL Giving Fund Donations Business / Org 03/05/2022 £20.00 Donnell Cheque Donations General 03/05/2022 £20.00 Donnell Cheque Donations General 03/05/2022 £20.00 Donnell Cheque Donations General 04/05/2022 £123.17 Facebook Online Donations Facebook Donations 09/05/2022 £15.79 Credit Amazon Other 16/05/2022 £160.00 HART Ambulance Donation Donations General 16/05/2022 £196.80 Stripe Online Donations Stripe Payments 16/05/2022 £398.40 Justgiving Donations Justgiving Donations 16/05/2022 £320.77 Cheque Paypal Giving Fund Donations Business / Org 18/05/2022 £110.00 Cheque D Burns Donations General 23/05/2022 £20.00 K Phillips Donation Donations General |
|
|---|---|---|---|
| 03/05/2022 £52.50 Postage Hamper March Medals Event / Fundraise Expend 03/05/2022 £2.00 Thank You Card, Card Factory Misc 03/05/2022 £10.50 COOP Hamper Expend Hamper Expend 13/05/2022 £102.34 Amazon Hamper Items Hamper Expend 13/05/2022 £18.12 B&M Hamper Items Hamper Expend 13/05/2022 £20.91 Tesco Hamper Items Hamper Expend 13/05/2022 £29.25 ASDA Hamper Items Hamper Expend 13/05/2022 £30.90 B&M Hamper Items Hamper Expend 13/05/2022 £36.00 Matalan Hamper Items Hamper Expend 16/05/2022 £7.68 Home Bargains Hamper Items Hamper Expend 18/05/2022 £99.11 Amazon Hamper Items Hamper Expend 20/05/2022 £16.98 Amazon Hamper Items Hamper Expend |
03/05/2022 £5.00 PAYPAL Giving Fund Donations Business / Org |
||
| 03/05/2022 £20.00 Donnell Cheque Donations General |
|||
| 03/05/2022 £20.00 Donnell Cheque Donations General |
|||
| 03/05/2022 £20.00 Donnell Cheque Donations General |
|||
| 04/05/2022 £123.17 Facebook Online Donations Facebook Donations |
|||
| 09/05/2022 £15.79 Credit Amazon Other |
|||
| 16/05/2022 £160.00 HART Ambulance Donation Donations General |
|||
| 16/05/2022 £196.80 Stripe Online Donations Stripe Payments |
|||
| 16/05/2022 £398.40 Justgiving Donations Justgiving Donations |
|||
| 16/05/2022 £320.77 Cheque Paypal Giving Fund Donations Business / Org |
|||
| 18/05/2022 £110.00 Cheque D Burns Donations General |
|||
| 23/05/2022 £20.00 K Phillips Donation Donations General |
|||
| 23/05/2022 £18.00 IONOS Webmail Website Costs 23/05/2022 £1,650.00 Parachute Jump Payment Event / Fundraise Expend 26/05/2022 £30.00 Matalan Hamper Items Hamper Expend 27/05/2022 £21.00 Primark Hamper Items Hamper Expend |
23/05/2022 £57.86 Justgiving Donations Justgiving Donations |
||
| 23/05/2022 £180.00 SkyDive Deposits Fundraising / Events |
|||
| 23/05/2022 £86.40 Facebook Online Donations Facebook Donations |
|||
| 23/05/2022 £670.00 Facebook Online Donations Facebook Donations |
|||
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.
June 2022 Finance
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £1,680 Saved this month
£0 £1,680
Expenses Planned £0 Actual £602
Income Planned £0 Actual £2,282
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £602 -£602 |
Planned Totals £0 |
Actual Diff. £2,282 +£2,282 |
|||||
| Hamper Expend | £0 | £248 -£248 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £354 -£354 £0 £0 £0 £0 £0 £0 |
Donations General | £0 | £0 £0 £0 £0 £0 £0 £370 +£370 £0 £0 £0 £0 £0 £0 £1,912 +£1,912 £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 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £2,282 | +£2,282 | ||
| Donations General | £0 | £0 | £0 | ||
| Donations Business / Or | £0 | £0 | £0 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £370 | +£370 | ||
| Justgiving Donations | £0 | £0 | £0 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Facebook Donations | £1,912 | +£1,912 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £0 | £0 | |||
Change or add categories by updating the Expenses and Income tables in the Summary sheet.
Expenses
Income
| Date | **Amount ** | Description | Category |
|---|---|---|---|
| 06/06/2022 | £56.00 | Dunelm Hamper Items | Hamper Expend |
| 09/06/2022 | £28.63 | Amazon Hamper Items | Hamper Expend |
| 20/06/2022 | £7.10 | Tesco Hamper Items | Hamper Expend |
| 20/06/2022 | £14.00 | The Works Hamper Items | Hamper Expend |
| 23/06/2022 | £18.00 | IONOS Webmail | Website Costs |
| 23/06/2022 | £45.40 | Amazon Hamper Items | Hamper Expend |
| 23/06/2022 | £20.90 | Tesco Hamper Items | Hamper Expend |
| 24/06/2022 | £26.20 | Primark Hamper Items | Hamper Expend |
| 27/06/2022 | £17.97 | Amazon Hamper Items | Hamper Expend |
| 29/06/2022 | £336.00 | Website Renewal Costs | Website Costs |
| 30/06/2022 | £31.56 | Home Bargains Hamper Items | Hamper Expend |
| Date | **Amount ** | Description | Category |
|---|---|---|---|
| 06/06/2022 | £10.00 | Skydive Deposits | Fundraising / Events |
| 06/06/2022 | £25.00 | Skydive Deposits | Fundraising / Events |
| 06/06/2022 | £25.00 | Skydive Deposits | Fundraising / Events |
| 06/06/2022 | £310.00 | Skydive Deposits | Fundraising / Events |
| 06/06/2022 | £1,912.00 | Facebook Donations | Facebook Donations |
| 10/06/2022 | £153.69 | Tablet Computer Fund Remaining Transfer |
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.
July 2022 Finance
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £540 Saved this month
£0 £540
Expenses Planned £0 Actual £422
Income Planned £0 Actual £962
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £422 -£422 |
Planned Totals £0 |
Actual Diff. £962 +£962 |
|||||
| Hamper Expend | £0 | £369 -£369 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £53 -£53 £0 £0 £0 £0 £0 £0 |
Donations General | £0 | £190 +£190 £194 +£194 £25 +£25 £0 £0 £333 +£333 £0 £0 £13 +£13 £0 £0 £0 £0 £207 +£207 |
||
| Gifts / Experience Days | £0 | Donations Business / Or | £0 |
||||
| Complimenary Therapy | £0 | Merchandise Sales | £0 | ||||
| Charitable Donations | £0 | Fundraising / Events | £0 | ||||
| Merchandise Purchases | £0 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £962 | +£962 | ||
| Donations General | £0 | £190 | +£190 | ||
| Donations Business / Or | £0 | £194 | +£194 | ||
| Merchandise Sales | £0 | £25 | +£25 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Justgiving Donations | £0 | £333 | +£333 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £13 | +£13 | ||
| Facebook Donations | £0 | £0 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £207 | +£207 | |||
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/07/2022 £21.00 Hobbycraft Hamper Items Hamper Expend 04/07/2022 £29.25 Tesco Hamper Items Hamper Expend 04/07/2022 £36.90 ASDA Hamper Items Hamper Expend 06/07/2022 £66.00 Matalan Hamper Items Hamper Expend 07/07/2022 £15.55 Tesco Hamper Items Hamper Expend 07/07/2022 £35.62 B&M Hamper Items Hamper Expend 08/08/2022 £92.04 Amazon Hamper Items Hamper Expend 11/07/2022 £51.00 Matalan Hamper Items Hamper Expend 12/07/2022 £34.93 Website Costs Website Costs 18/07/2022 £21.87 Amazon Hamper Items Hamper Expend 25/07/2022 £18.00 IONOS Webmail Website Costs |
04/07/2022 | £206.86 Stripe Online Payments Stripe Payments |
| 06/07/2022 | £20.00 E Waldron Donation Donations General |
|
| 06/07/2022 | £140.00 Hednesford Old Boys Donation Donations General |
|
| 06/07/2022 | £194.30 Gymophobics Donation Donations Business / Org |
|
| 12/07/2022 | £247.94 Justgiving Donations Justgiving Donations |
|
| 14/07/2022 | £3.00 Amazon Refund Other |
|
| 14/07/2022 | £9.65 Amazon Refund Other |
|
| 18/07/2022 18/07/2022 18/07/2022 |
£25.00 Hoody Purchase Merchandise Sales |
|
| £30.00 Cash Donations Paid In Donations General |
||
| £85.53 Justgiving Donations Justgiving Donations |
||
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.
Aug 2022 Finance
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £365 Saved this month
£0 £365
Expenses Planned £0 Actual £309
Income Planned £0 Actual £673
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £309 -£309 |
Planned Totals £0 |
Actual Diff. £673 +£673 |
|||||
| Hamper Expend | £0 | £267 -£267 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £0 £0 £24 -£24 £0 £0 |
Donations General | £0 | £211 +£211 £240 +£240 £0 £0 £0 £0 £76 +£76 £0 £0 £14 +£14 £132 +£132 £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 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £673 | +£673 | ||
| Donations General | £0 | £211 | +£211 | ||
| Donations Business / Or | £0 | £240 | +£240 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Justgiving Donations | £0 | £76 | +£76 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £14 | +£14 | ||
| Facebook Donations | £132 | +£132 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £0 | £0 | |||
Change or add categories by updating the Expenses and Income tables in the Summary sheet.
Expenses
Income
| Date | **Amount ** | Description | Category |
|---|---|---|---|
| 01/08/2022 | £17.98 | Amazon Hamper Items | Hamper Expend |
| 03/08/2022 | £31.82 | Amazon Hamper Items | Hamper Expend |
| 03/08/2022 | £24.00 | Cannock Print Printing | Misc |
| 05/08/2022 | £14.96 | Amazon Hamper Items | Hamper Expend |
| 09/08/2022 | £12.61 | Amazon Hamper Items | Hamper Expend |
| 09/08/2022 | £8.25 | Tesco Hamper Items | Hamper Expend |
| 12/08/2022 | £49.00 | Matalan Hamper Items | Hamper Expend |
| 15/08/2022 | £79.91 | Amazon Hamper Items | Hamper Expend |
| 15/08/2022 | £22.20 | Primark Hamper Items | Hamper Expend |
| 23/08/2022 | £18.00 | IONOS Webmail | Website Costs |
| 30/08/2022 | £26.92 | Amazon Hamper Items | Hamper Expend |
| 30/08/2022 | £2.99 | Home Bargains Hamper Items | Hamper Expend |
| Date | **Amount ** | Description | Category |
|---|---|---|---|
| 02/08/2022 | £28.82 | Justgiving Donations | Justgiving Donations |
| 05/08/2022 | £132.00 | Facebook Donations | Facebook Donations |
| 10/08/2022 | £65.00 | Cheque Via BMB Rem | Donations General |
| 10/08/2022 | £115.99 | Paypal Donations | Donations General |
| 16/08/2022 | £13.71 | Amazon Refund / Return | Other |
| 30/08/2022 | £10.00 | Cash Donation Paid in Pauline | Donations General |
| 30/08/2022 | £47.63 | Justgiving Donations | Justgiving Donations |
| 30/08/2022 | £20.00 | Cash Donation Paid in Scott | Donations General |
| 30/08/2022 | £240.00 | Com Comit Fund Cheque | Donations Business / Org |
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.
Sep 2022 Finance The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings £156 Saved this month
£0 £156
Expenses Planned £0 Actual £256
Income Planned £0 Actual £412
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £256 -£256 |
Planned Totals £0 |
Actual Diff. £412 +£412 |
|||||
| Hamper Expend | £0 | £238 -£238 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £0 £0 £0 £0 £0 £0 |
Donations General | £0 | £170 +£170 £102 +£102 £0 £0 £0 £0 £140 +£140 £0 £0 £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 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £412 | +£412 | ||
| Donations General | £0 | £170 | +£170 | ||
| Donations Business / Or | £0 | £102 | +£102 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Justgiving Donations | £0 | £140 | +£140 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Facebook Donations | £0 | £0 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £0 | £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 |
|---|---|---|---|---|---|---|---|
| 05/09/2022 | £10.94 | Amazon Hamper Items | Hamper Expend | 13/09/2022 | £101.60 | Lichfield Food Festival Donation | Donations Business / Org |
| 05/09/2022 | £7.00 | Matalan Hamper Items | Hamper Expend | 26/09/2022 | £20.00 | A Orton Donation | Donations General |
| 05/09/2022 | £7.96 | Range Hamper Items | Hamper Expend | 27/09/2022 | £140.24 | Justgiving Donations | Justgiving Donations |
| 06/09/2022 | £20.68 | Amazon Hamper Items | Hamper Expend | 27/09/2022 | £150.00 | Cash Donations Paid In / Transfered | Donations General |
| 12/09/2022 | £11.70 | Tesco Hamper Items | Hamper Expend | ||||
| 12/09/2022 | £64.34 | Home Bargains Hamper Items | Hamper Expend | ||||
| 14/09/2022 | £56.95 | Amazon Hamper Items | Hamper Expend | ||||
| 22/09/2022 | £10.99 | Amazon Hamper Items | Hamper Expend | ||||
| 22/09/2022 | £46.96 | Amazon Hamper Items | Hamper Expend | ||||
| 23/09/2022 | £18.00 | IONOS Webmail | Website Costs |
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.
Oct 2022 Finance The Katherine Allport Foundation
Increase in total savings
START BALANCE END BALANCE
-£560 Saved this month
£0 -£560
Expenses Planned £0 Actual £771
Income Planned £0 Actual £211
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £771 -£771 |
Planned Totals £0 |
Actual Diff. £211 +£211 |
|||||
| Hamper Expend | £0 | £512 -£512 £0 £0 £0 £0 £0 £0 £0 £0 £165 -£165 £0 £0 £0 £0 £18 -£18 £0 £0 £76 -£76 £0 £0 |
Donations General | £0 | £100 +£100 £0 £0 £0 £0 £0 £0 £111 +£111 £0 £0 £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 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £211 | +£211 | ||
| Donations General | £0 | £100 | +£100 | ||
| Donations Business / Or | £0 | £0 | £0 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Justgiving Donations | £0 | £111 | +£111 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Facebook Donations | £0 | £0 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £0 | £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 03/10/2022 £48.45 Justgiving Donations Justgiving Donations 13/10/2022 £100.00 Debbie Davies Coffee Morning Donations General 17/10/2022 £62.55 Justgiving Donations Justgiving Donations |
Date Amount Description Category 03/10/2022 £48.45 Justgiving Donations Justgiving Donations 13/10/2022 £100.00 Debbie Davies Coffee Morning Donations General 17/10/2022 £62.55 Justgiving Donations Justgiving Donations |
|
|---|---|---|---|
| 06/10/2022 £165.00 Skydive Event Event / Fundraise Expend 10/10/2022 £100.00 Dunelm Hamper Items Hamper Expend 12/10/2022 £62.36 Amazon Hamper Items Hamper Expend 12/10/2022 £7.00 Printing - Cannock Print Misc 12/10/2022 £8.50 Acorn Florists Misc 13/10/2022 £17.00 Matalan Hamper Items Hamper Expend 13/10/2022 £63.56 Tesco Hamper Items Hamper Expend 14/10/2022 £60.00 Primark Hamper Items Hamper Expend 17/10/2022 £19.00 The Works Hamper Items Hamper Expend 17/10/2022 £19.50 Tesco Hamper Items Hamper Expend 17/10/2022 £34.00 B&M Hamper Items Hamper Expend 17/10/2022 £54.47 B&M Hamper Items Hamper Expend |
03/10/2022 £48.45 Justgiving Donations Justgiving Donations |
||
| 13/10/2022 £100.00 Debbie Davies Coffee Morning Donations General |
|||
| 17/10/2022 £62.55 Justgiving Donations Justgiving Donations |
|||
| 21/10/2022 £55.90 Amazon Hamper Items Hamper Expend 24/10/2022 £18.00 IONOS Webmail Website Costs 27/10/2022 £26.70 The Range Hamper Items Hamper Expend 31/10/2022 £60.00 Bradleys Account Services Misc |
|||
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 2022 Finance
The Katherine Allport Foundation
START BALANCE END BALANCE
Increase in total savings -£2,566 Saved this month
£0 -£2,566
Expenses Planned £0 Actual £3,563
Income Planned £0 Actual £997
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £3,563 -£3,563 |
Planned Totals £0 |
Actual Diff. £997 +£997 |
|||||
| Hamper Expend | £0 | £1,545 -£1,545 £0 £0 £0 £0 £2,000 -£2,000 £0 £0 £0 £0 £0 £0 £0 £0 £18 -£18 £0 £0 £0 £0 £0 £0 |
Donations General | £0 | £78 +£78 £624 +£624 £0 £0 £0 £0 £290 +£290 £0 £0 £0 £0 £0 £0 £0 £0 £5 +£5 |
||
| Gifts / Experience Days | £0 | Donations Business / Or | £0 |
||||
| Complimenary Therapy | £0 | Merchandise Sales | £0 | ||||
| Charitable Donations | £0 | Fundraising / Events | £0 | ||||
| Merchandise Purchases | £0 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Food For Charity Boxes | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £997 | +£997 | ||
| Donations General | £0 | £78 | +£78 | ||
| Donations Business / Or | £0 | £624 | +£624 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Justgiving Donations | £0 | £290 | +£290 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £0 | £0 | ||
| Facebook Donations | £0 | £0 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £5 | +£5 | |||
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 11/11/2022 £10.00 Donation Paid in - Pauline Donations General 14/11/2022 £232.03 Justgiving Donations Justgiving Donations 15/11/2022 £18.60 Amazon Donations Donations Business / Org 16/11/2022 £85.00 G Force Netball Donation Donations Business / Org 16/11/2022 £41.34 Paypal Giving Fund Cheque Donations Business / Org 21/11/2022 £4.73 Stripe Payments Stripe Payments 21/11/2022 £20.00 Cash Donations Paid In Donations General 28/11/2022 £57.86 Justgiving Donations Justgiving Donations 29/11/2022 £100.00 Belt Road Club Donation Donations Business / Org 29/11/2022 £379.00 Gymophobics Donation Donations Business / Org 29/11/2022 £28.00 Cash Donations Paid In Donations General 30//11/2022 £20.00 Cash Donations Paid In Donations General |
Date Amount Description Category 11/11/2022 £10.00 Donation Paid in - Pauline Donations General 14/11/2022 £232.03 Justgiving Donations Justgiving Donations 15/11/2022 £18.60 Amazon Donations Donations Business / Org 16/11/2022 £85.00 G Force Netball Donation Donations Business / Org 16/11/2022 £41.34 Paypal Giving Fund Cheque Donations Business / Org 21/11/2022 £4.73 Stripe Payments Stripe Payments 21/11/2022 £20.00 Cash Donations Paid In Donations General 28/11/2022 £57.86 Justgiving Donations Justgiving Donations 29/11/2022 £100.00 Belt Road Club Donation Donations Business / Org 29/11/2022 £379.00 Gymophobics Donation Donations Business / Org 29/11/2022 £28.00 Cash Donations Paid In Donations General 30//11/2022 £20.00 Cash Donations Paid In Donations General |
|
|---|---|---|---|
| 01/11/2022 £14.10 Amazon Hamper Items Hamper Expend 01/11/2022 £80.93 Amazon Hamper Items Hamper Expend 03/11/2022 £21.58 Amazon Hamper Items Hamper Expend 03/11/2022 £78.50 Dunelm Hamper Items Hamper Expend 03/11/2022 £84.53 Amazon Hamper Items Hamper Expend 03/11/2022 £10.35 HobbyCraft Hamper Items Hamper Expend 03/11/2022 £16.00 Matalan Hamper Items Hamper Expend 03/11/2022 £40.80 ASDA Hamper Items Hamper Expend 04/11/2022 £24.20 Tesco Hamper Items Hamper Expend 07/11/2022 £98.00 Matalan Hamper Items Hamper Expend 08/11/2022 £2,000.00 St Giles Donation Charitable Donations 09/11/2022 £34.73 Amazon Hamper Items Hamper Expend |
11/11/2022 £10.00 Donation Paid in - Pauline Donations General |
||
| 14/11/2022 £232.03 Justgiving Donations Justgiving Donations |
|||
| 15/11/2022 £18.60 Amazon Donations Donations Business / Org |
|||
| 16/11/2022 £85.00 G Force Netball Donation Donations Business / Org |
|||
| 16/11/2022 £41.34 Paypal Giving Fund Cheque Donations Business / Org |
|||
| 21/11/2022 £4.73 Stripe Payments Stripe Payments |
|||
| 21/11/2022 £20.00 Cash Donations Paid In Donations General |
|||
| 28/11/2022 £57.86 Justgiving Donations Justgiving Donations |
|||
| 29/11/2022 £100.00 Belt Road Club Donation Donations Business / Org |
|||
| 29/11/2022 £379.00 Gymophobics Donation Donations Business / Org |
|||
| 29/11/2022 £28.00 Cash Donations Paid In Donations General |
|||
| 30//11/2022 £20.00 Cash Donations Paid In Donations General |
|||
| 09/11/2022 £15.90 Home Bargains Hamper Items Hamper Expend 09/11/2022 £29.20 Tesco Hamper Items Hamper Expend 09/11/2022 £62.88 Aldi Hamper Items Hamper Expend 10/11/2022 £28.67 The Range Hamper Items Hamper Expend 11/11/2022 £25.85 Amazon Hamper Items Hamper Expend |
|||
| 14/11/2022 £59.99 Argos Hamper Items Hamper Expend 14/11/2022 £98.00 Amazon Hamper Items Hamper Expend 14/11/2022 £48.60 Tesco Hamper Items Hamper Expend 17/11/2022 £50.25 Matalan Hamper Items Hamper Expend 17/11/2022 £11.94 The Range Hamper Items Hamper Expend 17/11/2022 £48.00 Dunelm Hamper Items Hamper Expend 18/11/2022 £65.58 Amazon Hamper Items Hamper Expend 18/11/2022 £7.00 Dunelm Hamper Items Hamper Expend 18/11/2022 £38.57 B&M Hamper Items Hamper Expend 21/11/2022 £47.55 ASDA Hamper Items Hamper Expend 22/11/2022 £25.54 Amazon Hamper Items Hamper Expend |
23/11/2022 £18.00 IONOS Webmail 25/11/2022 £77.53 Amazon Hamper Items 28/11/2022 £70.85 Amazon Hamper Items 28/11/2022 £11.04 Home Bargains Hamper Items 28/11/2022 £18.00 Dunelm Hamper Items 28/11/2022 £20.63 B&M Hamper Items 28/11/2022 £21.10 Tesco Hamper Items 28/11/2022 £46.00 Primark Hamper Items 28/11/2022 £74.00 Dunelm Hamper Items 29/11/2022 £38.50 Amazon Hamper Items
Website Costs Hamper Expend Hamper Expend Hamper Expend Hamper Expend Hamper Expend Hamper Expend Hamper Expend Hamper Expend 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.
Dec 2022 (Inc 01/01/2023) Finance
The Katherine Allport Foundation
START BALANCE END BALANCE £0 £4,918
Increase in total savings £4,918 Saved this month
Expenses Planned £0 Actual £5,062
Income
Planned £0 Actual £9,980
Expenses
Income
| Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
Expenses Income |
|---|---|---|---|---|---|---|---|
| Planned Actual Diff. Totals £0 £5,062 -£5,062 |
Planned Totals £0 |
Actual Diff. £9,980 +£9,980 |
|||||
| Hamper Expend | £0 | £1,501 -£1,501 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £3,484 -£3,484 £0 £0 £37 -£37 £0 £0 £40 -£40 £0 £0 |
Donations General | £0 | £3,489 +£3,489 £5,600 +£5,600 £0 £0 £0 £0 £455 +£455 £0 £0 £90 +£90 £109 +£109 £0 £0 £238 +£238 |
||
| Gifts / Experience Days | £0 | Donations Business / Or | £0 |
||||
| Complimenary Therapy | £0 | Merchandise Sales | £0 | ||||
| Charitable Donations | £0 | Fundraising / Events | £0 | ||||
| Merchandise Purchases | £0 | Justgiving Donations | £0 | ||||
| Event / Fundraise Expen | £0 |
Interest | £0 | ||||
| Cosy for Chemo Fund | £0 | Other | £0 | ||||
| Reimbursment Voluntee | £0 |
Facebook Donations | |||||
| Website Costs | £0 | Other Online Donations | £0 |
||||
| Petty Cash | £0 | Stripe Payments | |||||
| Misc | £0 | ||||||
| Other | £0 | ||||||
| Income | |||||
|---|---|---|---|---|---|
| Planned | Actual | Diff. | |||
| Totals | £0 | £9,980 | +£9,980 | ||
| Donations General | £0 | £3,489 | +£3,489 | ||
| Donations Business / Or | £0 | £5,600 | +£5,600 | ||
| Merchandise Sales | £0 | £0 | £0 | ||
| Fundraising / Events | £0 | £0 | £0 | ||
| Justgiving Donations | £0 | £455 | +£455 | ||
| Interest | £0 | £0 | £0 | ||
| Other | £0 | £90 | +£90 | ||
| Facebook Donations | £109 | +£109 | |||
| Other Online Donations | £0 | £0 | £0 | ||
| Stripe Payments | £238 | +£238 | |||
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 05/12/2022 £107.66 Stripe Payments Stripe Payments 05/12/2022 £90.00 Refund Matalan Other 05/12/2022 £109.07 Facebook Donations Facebook Donations 06/12/2022 £319.70 Justgiving Donations Justgiving Donations 07/12/2022 £1,078.54 Paypal Donations Donations General 12/12/2022 £9.66 Stripe Payments Stripe Payments 12/12/2022 £130.22 Justgiving Donations Justgiving Donations 13/12/2022 £600.00 Chase Colts Donation Donations Business / Org 14/12/2022 £60.00 Cash Donations Paid In Donations General 19/12/2022 £107.26 Stripe Payments Stripe Payments 23/12/2022 £5,000.00 Community Foundation Staffs - Cosy for Chemo FunDonations Business / Org 28/12/2022 £13.40 Stripe Payments Stripe Payments |
Date Amount Description Category 05/12/2022 £107.66 Stripe Payments Stripe Payments 05/12/2022 £90.00 Refund Matalan Other 05/12/2022 £109.07 Facebook Donations Facebook Donations 06/12/2022 £319.70 Justgiving Donations Justgiving Donations 07/12/2022 £1,078.54 Paypal Donations Donations General 12/12/2022 £9.66 Stripe Payments Stripe Payments 12/12/2022 £130.22 Justgiving Donations Justgiving Donations 13/12/2022 £600.00 Chase Colts Donation Donations Business / Org 14/12/2022 £60.00 Cash Donations Paid In Donations General 19/12/2022 £107.26 Stripe Payments Stripe Payments 23/12/2022 £5,000.00 Community Foundation Staffs - Cosy for Chemo FunDonations Business / Org 28/12/2022 £13.40 Stripe Payments Stripe Payments |
|
|---|---|---|---|
| 01/12/2022 £57.00 Tesco Hamper Items Hamper Expend 02/12/2022 £90.00 Matalan Hamper Items Hamper Expend 02/12/2022 £20.00 Cosy for Chemo Fund Fleece PrimaCosy for Chemo Fund 05/12/2022 £55.75 Amazon Hamper Items Hamper Expend 05/12/2022 £160.00 Cosy for Chemo Fund Fleeces Cosy for Chemo Fund 05/12/2022 £3.79 B&M Hamper Items Hamper Expend 06/12/2022 £19.20 Cosy for Chemo Website Website Costs 06/12/2022 £600.00 Cosy for Chemo Fund Fleeces Cosy for Chemo Fund 06/12/2022 £39.99 Engraving Company Misc 08/12/2022 £10.54 The Range Hamper Items Hamper Expend 08/12/2022 £13.50 ASDA Hamper Items Hamper Expend 08/12/2022 £28.00 Matalan Hamper Items Hamper Expend |
05/12/2022 £107.66 Stripe Payments Stripe Payments |
||
| 05/12/2022 £90.00 Refund Matalan Other |
|||
| 05/12/2022 £109.07 Facebook Donations Facebook Donations |
|||
| 06/12/2022 £319.70 Justgiving Donations Justgiving Donations |
|||
| 07/12/2022 £1,078.54 Paypal Donations Donations General |
|||
| 12/12/2022 £9.66 Stripe Payments Stripe Payments |
|||
| 12/12/2022 £130.22 Justgiving Donations Justgiving Donations |
|||
| 13/12/2022 £600.00 Chase Colts Donation Donations Business / Org |
|||
| 14/12/2022 £60.00 Cash Donations Paid In Donations General |
|||
| 19/12/2022 £107.26 Stripe Payments Stripe Payments |
|||
| 23/12/2022 £5,000.00 Community Foundation Staffs - Cosy for Chemo FunDonations Business / Org |
|||
| 28/12/2022 £13.40 Stripe Payments Stripe Payments |
|||
| 09/12/2022 £140.00 Matalan Hamper Items Hamper Expend 12/12/2022 £40.97 Tesco Hamper Items Hamper Expend 12/12/2022 £63.33 Amazon Hamper Items Hamper Expend 12/12/2022 £25.00 The Works Hamper Items Hamper Expend 12/12/2022 £36.50 Tesco Hamper Items Hamper Expend 12/12/2022 £67.02 Tesco Hamper Items Hamper Expend 12/12/2022 £96.50 Dunelm Hamper Items Hamper Expend |
28/12/2022 £2,350.00 Cash Donations Paid In Donations General |
||
| 29/12/2022 £4.70 Justgiving Donations Justgiving Donations |
|||
| 14/12/2022 £16.49 Bags Cosy for Chemo Fund Cosy for Chemo Fund 14/12/2022 £116.98 Amazon Hamper Items Hamper Expend 14/12/2022 £6.99 Kiss n Make Up Hamper Items Hamper Expend 14/12/2022 £9.00 Printing Cosy For Chemo - CannocCosy for Chemo Fund 14/12/2022 £14.77 Tesco Hamper Items Hamper Expend 14/12/2022 £22.00 The Works Hamper Items Hamper Expend 15/12/2022 £35.17 B&M Hamper Items Hamper Expend 15/12/2022 £40.00 Cosy for Chemo Fund Fleeces Cosy for Chemo Fund 15/12/2022 £83.00 Dunelm Hamper Items Hamper Expend 16/12/2022 £24.15 Amazon Hamper Items Hamper Expend |
16/12/2022 £247.39 Cosy for Chemo Fleeces New Look Cosy for Chemo Fund 19/12/2022 £340.00 Cosy for Chemo Fleeces Online HoCosy for Chemo Fund 19/12/2022 £2,024.10 Cosy for Chemo Fleeces New Look Cosy for Chemo Fund 19/12/2022 £20.00 Cosy for Chemo Fleeces Primark Cosy for Chemo Fund 19/12/2022 £41.00 Primark Hamper Items Hamper Expend 21/12/2022 £3.29 Fleece Postage Hermes Cosy for Chemo Fund 21/12/2022 £3.29 Fleece Postage Hermes Cosy for Chemo Fund 23/12/2022 £18.00 IONOS Webmail Website Costs 28/12/2022 £149.19 Amazon Hamper Items Hamper Expend 28/12/2022 £280.00 Matalan Hamper Items Hamper Expend
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 |
Unrestricted funds £ F01 |
Restricted income funds £ F02 |
Endowment funds Total this year £ £ F03 F04 |
Endowment funds Total this year £ £ F03 F04 |
Total last year £ F05 |
|---|---|---|---|---|---|---|
| - | - | - | - | - | ||
| - | - | - | - | |||
| - | - | - | - | - | ||
| - | - | - | - | - | ||
| - | - | - | - | - | ||
| - | - | - | - | - | ||
| - | - | - | - | - | ||
| - | - | - | - | - | ||
| 84,968 | - | - | 84,968 | - | ||
| 84,968 | - | - | 84,968 | - | ||
| - | - | - | - | - | ||
| 84,968 | - | - | 84,968 | - | ||
| 84,968 | - | - | 84,968 | - | ||
| - | - | - | - | - | ||
| - | - | - | - | - | ||
| 84,968 | - | - | 84,968 | - | ||
| - | - | - | ||||
| - | - | - | ||||
| - | - | - | ||||
| - | ||||||
| - | - | - | - | - | ||
| 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
| 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 £ |
| - | - | |
| - | - | |
| 84,968 | 67,989 | |
| - | - | |
| 84,968 | 67,989 |
30/10/2023
CC17a (Excel)
1