## **Trustees’ Annual Report for the period** **From January 2023 Period start date To December 2023 Period end date** ## **Charity name: Friends of Sir Charles Parsons School** ## **Charity registration number: 1165658** ## **Objectives and Activities** ||SORP reference|| |---|---|---| |Summary of the purposes of
the charity as set out in its
governing document|Para 1.17|To enhance the educaton of the students of Sir
Charles Parsons School and young adults with
disabilites in the local community by providing
or assistng in the provision of educatonal,
recreatonal and other charitable facilites not
normally provided bythe Local Authority.| |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|We have organised several events such as
Easter, summer and Christmas fayres, school
photo day and a Halloween disco. This has
enabled the school and their families to socialise
together and support each other. These funds
have been used to purchase new ‘switch’
technology for the students, two new trikes and
has covered the cost of class day trips out of
school.
We have also held rafes, sponsored events and
hosted stalls at external fayres which has raised
much needed funds towards a week long
residental experience at a specialist outdoor
pursuits actvity centre for our sixth form
students.| |Statement confirming
whether the trustees have
had regard to the guidance
issued by the Charity
Commission on public
benefit|Para 1.18|The Trustees of the Friends of Sir Charles
Parsons School have read and taken into
account the Charity Commission's guidance on
Public Beneft when planning actvites, raising
funds and providing equipment and resources
for the students of Sir Charles Parsons School.| ## **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|The charity has been able to raise a signifcant
amount of money through a range of fundraising
actvites as documented above.
The charity used funds to purchase switch
equipment, and pay for specialist residental
experiences, among other smaller projects.
The switch equipment has enabled a number of
young people of Sir Charles Parsons School to
access lessons more fully, for example by
communicatng or taking control of their
environment.
The residental experiences that were provided
allowed young people with a range of physical
and learning disabilites (including students with
profound and multple learning disabilites) to be
able to achieve through a range of physical
actvites, supportng them to develop more
awareness of themselves, as well as raising their
self esteem.| ## **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|Para 1.41|| against objectives Other ## **Financial Review** |**Financial Review**||| |---|---|---| |Review of the charity’s
financial position at the end
of the period|Para 1.21|During the fnancial period this report covers,
the Charity's: Income was £28721.31
Expenditure was £15546.79. Monies carried
forward from previous year was £26681.78.
Cash funds for the Year end were £39856.30| |Statement explaining the
policy for holding reserves
stating why they are held|Para 1.22|The Trustees consider that the Friends of Sir
Charles Parsons School require reserves to
provide funds which can be designated to
specifc projects for the beneft of the students
as and when they arise, and to enable these
projects to be undertaken at short notce. To
save a sum of money with the long term aim of
purchasing for the students a large piece of
equipment or resource, e.g replacing a mini bus
for instance. As a Charity relying mainly on small,
individual donatons, grants and fundraising
events as its source of funding, it is difcult to be
prescriptve with regard to the amount of
reserves the organisaton will be in a positon to
hold. We consider that we have a simple, stable
patern of receipts and payments, litle
susceptbility to outside infuences, and minimal
risk of serious disrupton to its charitable work.
Taking these factors into account, the Trustees
have agreed to keep reserves of £6000 for the
coming year. This amount will be reviewed
regularly during the next fnancial year, and
evaluated in light of any future needs,
opportunites or risks that may arise during this
period.| |Amount of reserves held|Para 1.22|£6000| |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|**N/A**| ## **Additional information (optional)** ## You may choose to include further statements where relevant about: The charity’s principal sources of funds (including Para 1.47 any fundraising) Investment policy and objectives including any Para 1.46 social investment policy adopted |A description of the principal
risks facing the charity|Para 1.46|| |---|---|---| |Other||| ## **Structure, Governance and Management** |Description of charity’s
trusts:||| |---|---|---| |Type of governing document
(trust deed, royal charter)|Para 1.25|Constitution| |How is the charity
constituted?
(e.g unincorporated
association, CIO)|Para 1.25|Association| |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|Elected by| ## **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 Friends of Sir Charles Parsons School| |---|---| |Other name the charity uses|-| |Registered charity number|1165658| |Charity’s principal address|Sir Charles Parsons School
Westbourne Avenue
Walker
Newcastle upon Tyne
NE6 4ED| ||| ## **Names of the charity trustees who manage the charity** |1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20|**Trustee name**|**Office (if any)**|**Dates acted if not for whole**
**year**|**Name of person (or body) entitled**
**to appoint trustee (ifany)**| |---|---|---|---|---| ||Helen Clarkson|Chairperson||| ||Janette Keen|Treasurer||| ||Joanne Anderson|Secretary||| ||Susan Giuliani|||| ||Sara Craig|||| ||Jason Swann|||| ||Andrew Gullon|||| ||Leanne Ginnelly|||| ||Joanne Whittington|||| |||||| |||||| |||||| |||||| |||||| |||||| |||||| |||||| |||||| |||||| |||||| – 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 Name and objects of the charity on whose behalf the assets are held and how this falls within the custodian charity’s objects Details of arrangements for safe custody and segregation of such assets from the charity’s own assets ## **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)** Joanne Anderson **Full name(s)** Helen Clarkson **Position (eg Secretary,** Chair Secretary **Chair, etc)** **Date** 23/09/2024 |**Spreadsheet Information**|**Spreadsheet Information**|**Spreadsheet Information**| |---|---|---| |**The following required forAll spreadsheets in line with the 'Spreadsheet Usage & Security Policy'**||| |**Business Area and Owner Details**||| |**Directorate**
**Team / Section**
**Name of Spreadsheet Creator**
*****
**Officer who created the spreadsheet**
**Name of Owner**
*****
**Officer responsible for the accuracy of the data**||| |||Chief Executive's Directorate| |||| |||AUDIT, INSURANCE & RISK| |||| |||CHERYL SPENCER| |||| |**Location and Purpose of the Spreadsheet**||| |**Name of Spreadsheet**
IA School Fund Ledger Proforma 2013/14 v5
*
**In line with stated naming conventions as per**
**Is this Spreadsheet deemed 'Critical'**
NO
*
**If deemed Critical, this MUST be recorded on the Critical Spreadsheet Register. Guidance at:**
**Document Classification**
NCC Internal Use Only
*
**State the Document Classification from the**
**Location of Spreadsheet**
''#$SS INSTRUCTIONS OFFICE 2003
*
**What is the spreadsheet used for (purpose)**
*****
**Brief description of purpose**
**Frequency of use**
Daily
*****
**Daily / Weekly / Monthly / Quarterly / Annual / Ad-Hoc**
NO
*
NO
*
**'Spreadsheet Usage and Security Policy'**
**'Spreadsheet Usage and Security Policy'**
**'Information Asset Classification Policy'**
**Server & Folder Name in which the spreadsheet**
**is located**
Proforma created for consultancy services to schools
for recording School Fund Income & Expenditure.
**This spreadsheet should only be used if obtained**
**from Internal Audit**
**Does data from another Spreadsheet feed into**
**'This' document**
**If so please give the Name and File Location,**
**i.e. server and folder**
**Does data from this Spreadsheet feed into**
**'Another' document**
**If so please give the Name and File Location,**
**i.e. server and folder**||| |||IA School Fund Ledger Proforma 2013/14 v5| ## **Version Control** * **Numbering in line with 'Spreadsheet Security Policy', list below the key events in the life of the spreadsheet. If you require additional rows on the version table below, please contact the Financial Systems & Accounting Team on extension 26507.** |**Version**
**Number**|**Purpose/Change**|**Author**|**Date**| |---|---|---|---| |2|Income & Bankings now before exp table|C L Spencer|**###**| |2|I&E Summary & balances sheet added|C L Spencer|**###**| |3|Cash Float ExpLedger added|C L Spencer|**###**| |4|Cash in Hand control totals added|C L Spencer|**###**| |4|User Intructions expanded|C L Spencer|**###**| |5|Minor Changes to Instructions and I&E
Summary|C L Spencer|**###**| ||||| |**User Instructions**|||| |*
**1**
**Enter below any specific user instructions you feel appropriate for the spreadsheet e.g.**
**descriptions of calculations, constants used, which values to update etc.**
**This workbook has been created in Microsoft Excel XP2003**. Some schools may use a different
version of Excel. If so the workbook is still compatible, however, the toolbar and whereabouts of some
functions may differ. If you have attended the IA SF Training and experience difficulty using this workbook
please contact Cheryl Spencer on 211 6505|||| |**2**
**This workbook contains**a 2014/15 & 2015/16 full year ledger and I&E Summary, AND a 2014/15 monthly
ledger and Summary. Either option can be used, (if you operate a small fund the annual ledger is
recommended). A cash float expenditure & balances log is also provided if a cash float is operated.|||| |**3**
**Full Year or Monthly Ledger?**Once you have decided, the worksheet name tabs are colour coded so you
know which sheets to use, i.e. if you decide on the annual ledger only use the pink worksheets (orange for
14/15), if you decide on a monthly ledger only use the blue worksheets|||| |**4**
**Worksheet Protection:**to avoid accidental change of formulae, worksheets are protected. Category
columns and rows can be added or deleted, however, the protection will need to be removed to allow the
formulae to be copied to the new cells containing column and row totals.|||| |**5**
**How to remove protection:**to minimise error protection should be removed and reinstated on a sheet by
sheet basis as and when necessary. To remove, select 'Protection' from the tools menu, then select
'Unprotect'. To reinstate select 'Protection' then 'Protect' then OK from the options box.|||| |**6**
**Adding additional rows:**click on a blank row number (the row will be highlighted grey) right click with the
mouse and select 'insert' Several rows can be inserted by highlighting more than one blank row, e.g. if 5
rows are highlighted, 5 more will be inserted|||| |**7**
**Copying formula if new rows added:**the formulae must be inserted in all new cells in the Income, Exp and
Running Bal total columns. E.g. click on the cell above the new cells in the Income tot col, move curser to bottom
right of cell until cross appears, click and drag the formula to the new cells|||| |**8**
**Adding or changing column categories:**All changes to columns in the Ledger must also be made in the
corresponding I&E Summary. Follow instructions at item 6 above but click on column Letter at top of
spreadsheet|||| |**9**
**Copying formula if new columns added:**the formulae must be inserted in all new cells in the totals row
at the foot of the spreadsheet (follow instructions at item 7). The same will need to be done in the I&E
Summary|||| |**10**
**Password Protection:**a password can be entered before clicking 'OK' in the options box referred to at 3
above. Once entered and protected, users will be prompted for a password should they try to remove the
protection. NB if the password is forgotton protected cells can NOT be unlocked!|||| |**11**
**Keep check on the control totals at foot of Spreadsheet Ledger**, if these differ to the corresponding cell
an error has occurred; this will usually be due to rows / cols added and formulae not copied to the new cells
OR formula being deleted while the sheet was unprotected.|||| |**12**
**Also refer to notes / comments on worksheets.**NB If preferred, comments boxes can be hidden by
right clicking on the cell & selecting 'Hide Comment'. A red triangle in the corner of the cell will still be
visible to indicate a cell comment exists. Hover curser over the cell to see the comment.|||| ## **Spreadsheet Information** **The following required for All spreadsheets in line with the 'Spreadsheet Us** ||**Business Area and Owner Details**||| |---|---|---|---| ||**Directorate**
Chief Executive's Directorat
**Team / Section**
AUDIT, INSURANCE & RIS
**Name of Spreadsheet Creator**
CHERYL SPENCER
*****
**Officer who created the spreadsheet**
**Name of Owner**
USERS OF ATTACHED PR
*****
**Officer responsible for the accuracy of the data contained within the spread**||| ||||Chief Executive's Directorat| ||||| ||||AUDIT, INSURANCE & RIS| ||||| ||||CHERYL SPENCER| ||||| ||||USERS OF ATTACHED PR| ||||| ||**Location and Purpose of the Spreadsheet**||| ||||| * **If so please give the Name and File Location, i.e. server and folder Does data from this Spreadsheet feed into** NO **'Another' document** * **If so please give the Name and File Location, i.e. server and folder** |#
#||**Version Control**|**Version Control**|**Version Control**| |---|---|---|---|---| |||*
**Numbering in line with 'Spreadsheet Security Policy', list below the key eve**
**spreadsheet. If you require additional rows on the version table below, ple**
**Systems & Accounting Team on extension 26507.**||| |||**Version**
**Number**|**Purpose/Change**|**Author**| ||#
#|2|Income & Bankings now before exp table|C L Spencer| |||2|I&E Summary & balances sheet added|C L Spencer| |||3|Cash Float ExpLedger added|C L Spencer| |||4|Cash in Hand control totals added|C L Spencer| |||4|User Intructions expanded|C L Spencer| |||5|Minor Changes to Instructions and I&E
Summary|C L Spencer| |||6|Windows 2010 Instructions added.|C L Spencer| |||6|CIH C/F added to Main Ledger|C L Spencer| |||6|Cumulative CIH added to monthly Ledgers|C L Spencer| |||6|Instructions added to I&E Summary|C L Spencer| |||7|Completed and Certified by added to I&E
Summary|C L Spencer| |||8|Minor change to categories & CFR link
added|C L Spencer| |||9|Cash float balance accounted for in I&E
Summary|C L Spencer| |||||| |||**User Instructions**||| * **Numbering in line with 'Spreadsheet Security Policy', list below the key eve spreadsheet. If you require additional rows on the version table below, plea Systems & Accounting Team on extension 26507.** * **Enter below any specific user instructions you feel appropriate for the spre descriptions of calculations, constants used, which values to update etc. 1 This workbook has been created in Microsoft Excel XP2003, however, s** ome different version of Excel. The instructions below are for school's using Windows schools have been upgraded to during 201314. Office 2003 instructions can stil spreadsheet. If you have attended a SF Traning Session and experience difficult ~~please contact Cheryl Spencer on 211 6505~~ **2 This workbook contains** a 2014/15 & 2015/16 full year ledger and I&E Summar ledger and Summary. Either option can be used, (if you operate a small fund the recommended). A cash float expenditure & balances log is also provided if a cas **3 Full Year or Monthly Ledger?** Once you have decided, the worksheet name tab know which sheets to use, i.e. if you decide on the annual ledger only use the pin 15/16), if you decide on a monthly ledger only use the blue worksheets **4 Worksheet Protection:** to avoid accidental change of formulae, worksheets are columns and rows can be added or deleted, however, the protection will need to formulae to be copied to the new cells containing column and row totals. **5 How to remove protection:** to minimise error, protection should be removed and sheet basis as and when necessary. To remove protection; select 'Un Protect Sh Tab'. To reinstate change back to 'Protect Sheet' An options box will appear - ju **6 Adding additional rows:** click on a blank row number (the row will be highlighte mouse and select 'insert' Several rows can be inserted by highlighting more than rows are highlighted, 5 more will be inserted **7 Copying formula if new rows added:** the formulae must be inserted in all new cells in Running Bal total columns. E.g. click on the cell above the new cells in the Income tot co right of cell until cross appears, click and drag the formula to the new cells **8 Adding or changing column categories:** All changes to columns in the Ledger corresponding I&E Summary. Follow instructions at item 6 above but click on colu spreadsheet **9 Copying formula if new columns added:** the formulae must be inserted in all n at the foot of the spreadsheet (follow instructions at item 7). The same will need Summary **10 Password Protection:** a password can be entered before clicking 'OK' in the opt above. Once entered and protected, users will be prompted for a password shou protection. **NB if the password is forgotton protected cells can NOT be unloc 11 Keep check on the control totals at foot of Spreadsheet Ledger** , if these diffe an error has occurred; this will usually be due to rows / cols added and formulae OR formula being deleted while the sheet was unprotected. **12 Also refer to notes / comments on worksheets.** NB If preferred, comments bo right clicking on the cell & selecting 'Hide Comment'. A red triangle in the corner o visible to indicate a cell comment exists. Hover curser over the cell to see the co ## **age & Security Policy'** e K ## ROFORMAS ## **dsheet** orma 2014/15 v6 **Security Policy' ster. Guidance at:** ## **ication Policy'** F 2010 tancy services to schools ncome & Expenditure. **only be used if obtained** ## **ents in the life of the ase contact the Financial** **Date** **### ###** **###** **### ###** **###** **### ### ###** **###** **### ###** ## **adsheet e.g.** e schools may use a s 2010, the version most l be found on the previous ty using this workbook ry, AND a 2014/15 monthly e annual ledger is sh float is operated. bs are colour coded so you nk worksheets (orange for e protected. Category be removed to allow the d reinstated on a sheet by heet' from the 'Review ust click ok. d grey) right click with the n one blank row, e.g. if 5 the Income, Exp and ol, move curser to bottom must also be made in the umn Letter at top of new cells in the totals row to be done in the I&E tions box referred to at 5 ld they try to remove the **cked!** er to the corresponding cell not copied to the new cells oxes can be hidden by of the cell will still be omment. **SCHOOL NAME: SCHOOL FUND LEDGER 2012/13** **----- Start of picture text -----**
2013/14 Cash In Hand -Banked in 2014/15 PREVIOUS YEARS CLOSING BOOK BALANCE / CURRENT YEAR OPENING BALANCE 5000.00
INCOME BANKINGS / DIRECT CREDIT EXPENDITURE BALANCE
Other Running
(Replace Deposit Reimburse Other Book
Raising Fund Raising Fund Category or delete with Exp Statement Slip No / Cash Float (Separate Fund Raising Category or (Replace with Exp (Opening Bal Balance
Recpt Income Description (e.g Trip name / for for col if not Misc Income No (BACS / Exp Log Charity (related delete col if Misc Expenditure + Income -
Date No Charity / Misc detail etc) Donations Uniform Trips Charity School needed) Income Total Amount Date Interest) Chq No Payee / Description Kept) Uniform Trips Donations expenditure) not needed) Spend Total Exp)
01/04/12 101 Example 200.00 200.00 1000011 Example 50.00 50.00 5150.00
02/04/12 102 Example 300.00 300.00 1000012 Example 350.00 350.00 5100.00
03/04/12 103 Example 150.00 150.00 650.00 05/04/2012 65231 1000013 Cancelled 0.00 5250.00
Cheryl Spencer:
Banking Adjustment -1.00 -1.00 -1.00 65231 Highlight cheque amounts 0.00 5249.00
05/04/12 104 University Mentoring - NOT SF! 150.00 150.00 1000014 Example 150.00 once confirmed to bank 150.00 5249.00
statement; any
Cheryl Spencer: 0.00 unhighlighted cells = 0.00 5249.00
All monies raised for cheques NYP
Cheryl Spencer: ALL MONIES RECEIVED FROM UNIVERSITIES FOR MENTORING STUDENTS SHOULD BE PAID INTO THE specific charities should be paid over to that charity! 0.000.000.00 Cheryl Spencer: Cells are underlined to clearly show what is included in banking; Cheryl Spencer: Highligh they appear in bank stateme ntt b ankings as Cheryl Spencer: Cheques must be recorded in sequence including cancelled chqs 0.000.000.00 5249.005249.005249.00
SCHOOL BUDGET 0.00 0.00 5249.00
0.00 0.00 5249.00
0.00 0.00 5249.00
Cheryl Spencer:
Notification of adjustment to bankings must 0.00 0.00 5249.00
be recorded in the ledger to enable a balanced bank reconciliation; the adj should 0.00 999911 Chq not presented -25.00 -25.00 5274.00
be referenced to (and ideally inserted below) 0.00 Cheryl Spencer: 0.00 5274.00
the orginal banking, and where known Any cheques not presented
recorded under the relevant income category 0.00 after 6 months (or year to 0.00 5274.00
- alternatively record against Misc. 0.00 be safe) should be added 0.00 5274.00
NB Original entry should not be changed as back to the Ledger
may not, then, agree to source documents. 0.00 0.00 5274.00
0.00 0.00 5274.00
N/A Bank Interest 1.25 1.25 1.25 31/05/2012 BS 21 1000015 Example 10.00 10.00 5265.25
N/A School Fund Grant 750.00 750.00 750.00 02/06/2012 BS 21 1000016 Example 20.00 20.00 5995.25
0.00 1000017 Example 30.00 30.00 5965.25
Cheryl Spencer:
Any direct bank credits 0.00 1000018 Example 40.00 40.00 5925.25
must be recorded in the
SF Ledger to enable a 0.00 1000019 Example 50.00 50.00 5875.25
balanced bank 0.00 1000020 Example 70.00 70.00 5805.25
reconcilation
0.00 1000021 Example 80.00 80.00 5725.25
0.00 1000022 Example 90.00 90.00 5635.25
0.00 1000023 Example 100.00 100.00 5535.25
0.00 1000024 Example 10.00 10.00 5525.25
0.00 1000025 Example 20.00 20.00 5505.25
0.00 1000026 Example 30.00 30.00 5475.25
0.00 1000027 Example 40.00 40.00 5435.25
0.00 1000028 Example 50.00 50.00 5385.25
0.00 1000029 Example 60.00 60.00 5325.25
0.00 1000030 Example 70.00 70.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
0.00 0.00 5255.25
Cheryl Spencer:
0.00 If this total differs to the 0.00 5255.25
control total above,
0.00 there is an error in the 0.00 5255.25
0.00 spreadsheet 0.00 5255.25
0.00 0.00 5255.25
Control Total 1550.25 Control Total 1295.00
Column Totals 200.00 0.00 300.00 150.00 0.00 750.00 150.25 1550.25 1400.25 Column Totals 210.00 170.00 445.00 280.00 40.00 80.00 70.00 1295.00 5255.25
Cash in Hand 150.00 Cheryl Spencer:
Cheryl Spencer: This total should always = the
This is the difference between the total income and latest running balance above and
total bankings as shown above. This should agree to the total book balance on the I&E
actual monies not yet banked. Summary
**----- End of picture text -----**
**NB All formulas (line and column totals) in this sheet are protected. To insert additional rows and / or columns, or formula in Bankings table, the protection will need to be removed; this can be done by selecting 'Protection' then 'Un Protect' from the Tools menu** - E10: Cheryl Spencer: Notification of adjustment to bankings must be recorded in the ledger to enable a balanced bank reconciliation; the adj should be referenced to (and ideally inserted below) the orginal banking, and where known recorded under the relevant income category - alternatively record against Misc. NB Original entry should not be changed as may not, then, agree to source documents. ## E11: Cheryl Spencer: ALL MONIES RECEIVED FROM UNIVERSITIES FOR MENTORING STUDENTS SHOULD BE PAID INTO THE SCHOOL BUDGET ## E27: Cheryl Spencer: Any direct bank credits must be recorded in the SF Ledger to enable a balanced bank reconcilation - I9: Cheryl Spencer: All monies raised for specific charities should be paid over to that charity! ## M9: Cheryl Spencer: Cells are underlined to clearly show what is included in banking; ## M55: Cheryl Spencer: If this total differs to the control total above, there is an error in the spreadsheet ## O9: Cheryl Spencer: Highlight bankings as they appear in bank statement O10: ## O57: Cheryl Spencer: This is the difference between the total income and total bankings as shown above. This should agree to actual monies not yet banked. ## S11: Cheryl Spencer: Cheques must be recorded in sequence including cancelled chqs ## T20: Cheryl Spencer: Any cheques not presented after 6 months (or year to be safe) should be added back to the Ledger ## X11: Cheryl Spencer: Highlight cheque amounts once confirmed to bank statement; any unhighlighted cells = cheques NYP ## AD55: Cheryl Spencer: This total should always = the latest running balance above and the total book balance on the I&E Summary **SCHOOL NAME:SCHOOL FUND LEDGER 2023** 12/01/2313/01/2316/01/23117/01/2323/01/2324/01/2324/01/2324/01/2324/01/2326/01/2326/01/2326/01/2326/01/2326/01/2326/01/2330/01/2330/01/2330/01/2330/0331/01/2301/02/2306/02/2308/02/2309/02/2307/02/2303/02/2303/02/2310/02/2313/02/2317/02/2324/01/2327/01/2310/02/2310/02/2317/02/2327/02/2328/02/2306/03/2306/03/2328/02/2302/03/2303/03/2306/03/2309/03/2309/03/2309/03/2310/03/2313/03/2313/03/2313/03/2313/03/23116/03/2317/03/2317/03/2320/03/2320/03/2315/03/2323/03/2323/03/2323/03/2323/03/2329/03/2323/03/2329/03/2329/03/2329/03/2330/03/2330/03/30/03/2330/03/2330/03/2331/03/2331/03/2331/03/2331/03/2331/03/2303/04/2304/04/2306/04/2317/04/2318/04/2319/04/2320/04/23220/04/2320/04/2321/04/2321/04/2324/04/2324/04/2324/04/2327/04/2302/05/2302/05/2302/05/2304/05/2310/05/2311/05/2311/05/231112/05/2312/05/2312/05/2315/05/2316/05/2316/05/2316/05/2318/05/2319/05/2319/05/2318/05/2219/05/2319/05/2319/05/2322/05/2323/05/23225/05/2325/05/2322/05/2322/05/2330/05/2305/06/2301/06/2306/06/2308/06/2325/05/2305/06/2305/06/2306/06/2308/06/2308/06/2309/06/2309/06/09/06/14/06/2312/06/2312/06/2319/06/2319/06/2319/06/2320/06/2316/06/2316/06/2322/06/2323/06/2323/06/2326/06/2326/06/2330/06/2330/06/005/07/2305/07/2306/07/2306/07/2306/07/2306/07/2306/07/2310/07/2312/07/2312/07/2313/07/2313/07/2314/07/23 bacs 70/de20/07/2321/07/232105/07/205/07/2306/07/2314/07/2318/07/2318/07/2319/07/2319/07/2319/07/2321/07/2321/07/2324/07/2331/07/2310/08/2321/08/2314/09/231414/09/214/09/2320/07/2321/07/2321/07/2308/09/2308/09/2308/09/2308/09/2311/09/2311/09/2314/09/2318/09/232302/2320/04239/016/03/0/05/05/3 **D** /0/05//07/2/0/09/ **ate** 11147/////22222222222223333333333333333 **R** 1276034127603512760361276037127603812760391276040127604112760421276043127604412760451276046127604712760481276049127605012760511276052127605312760541276055127605612760571276058127605912760601276061127606212760631276064127606512760661276067127606812760691276070127607112760721276073127127607512760761276077127607812760791276080127608112760821276083127608412760851276086127608712760881276089127609012760911271276093127609412760951276096127609712760981276099127610012761011276102127127610412761051276106127610712761081276109127611012761111276112127127127611512761161276117127611812761191271276124127612512761261276121127612212761231276127127612812761291276130127613112761321276135127613712761331276134127613612761381276139127614012761411276142127614312761441276145bacs 11bacs 12bacs 14bacs 15bacs 16bacs 18bacs 19bacs 20bacsbacs 22bacs 23bacs 24bacs 25bacs 26bacs 27bacs 28bacs 29bacs 30bacs 31bacsbacs 33bacs 34bacs 35bacs 36bacs 37bacs 38bacs 41bacs 42bacs 43bacs 44bacs 45bacs 46bacs 47bacs 49bacs 50bacs 51bacs 52bacs 53bacs 54bacs 55bacs 56bacs 57bacs 58bacs 60bacs 66bacs 67bacs 69bacs 71bacs 72bacsbacs 74bacs 75bacs 76bacs 77bacs 1bacs 3bacsbacs 5bacsbacsbacs 8 **ecpt** PS 1PS 260609666611111412 21 7 **N** 3 4 77403623230 **o** p Summer fair **FOSCPS** GNR Capita pay, classroom contributionsCapLate donation from christmas coffee morninCaVoid receiChildren in needVoid receiVoid receiHawkhirst Hawkhirst GNR GNR GNR Donation for GNRHawkhirst Hawkhirst payment from KVHawkhirst payment from AKCapNAmazon eroHawkhirst Hawkhirst Hawkhirst Hawkhirst Hawkhirst Capita pay, classroom contributionsCaCapita pay, classroom contributionsHawkhirst Hawkhirst payment from RSCake sale for Hawkhirst Capita pay, classroom contributionsHawkhirst Hawkhirst Hawkhirst Hawkhirst CaCaCaHawkhirst Hawkhirst Hawkhirst Hawkhirst Cake sale for hawkhirst donation Capita pay, classroom contributionsCapHawkhirst Easter raffle Donation from HFHawkhirst Cake sale for comic reliefCake sale for Hawkhirst Donation from HumlEaster raffle CaEaster raffle Cake sale for Hawkhirst Hawkhirst Donation to school Raffle ticket money for easter coffee morningCake sale for Hawkhirst EHawkhirst Hawkhirst Void receiCaComic relief sComic relief sEaster coffee morninEaster coffee morninEaster coffee morninCaDonation from RoCaAccess suite - residential Hawkhirst Hawkhirst payment from ISPay 360 (previously capita pay) classroom contribution payEnthuse donation for GNRHawkhirst Hawkhirst Easter fair fundsHawkhirst Hawkhirst PaAmazon euroPaPaCalvert trust PaCalvert trust payment from LJCaCalvert trust fundraisinPaEasCalvert trust Calvert trust cake saleCalvert trust Enthuse GNR donation Amazon euroResidential Calvert trust Calvert trust Calvert trust Calvert trust Calvert trust payment from LDCaCalvert trust Calvert trust fundraisinPaPaPaPaCalvert trust Donation from LHCalvert trust 100+ club number from VBCalvert trust Calvert trust Calvert trust payment from JJCaCaCalvert trust PaPaPaGNR entrPaEnthuse GNR sCalvert trust Calvert trust PaCalvert trust cake saleDonation from BarbersPaPaCaPaSummer raffle from AFClassroom contriution reimbursment Calvert trust Deli deliSummer raffle from GSSummer raffle from SWEnthuse - GNR sPay 360 Classroom contributionsPCalvert trust cake saleCalvert trust Calvert trust Joanne Allen bikes donation Calvert trust Calvert trust Calvert trust Calvert trust Calvert trust Calvert trust Calvert trust Twins Trust - Credit for GNR vestsPaNathans waste - raEnthuse - GNR sCalvert trust Calvert trust Calvert trust Donation to Calvert trust from CADonation to calvert trust from CADonation to calvert trust from CADonation from Donation for GNR sDonation to Calvert trust from CACalvert trust Donation to Calvert trust from AB **Income Description (e.g Trip name /** asteayayyyyyyyyyyyyyyyyyypthpppppppplvlvlvlvlv 360 classroom contributions 360 classroom contributions 360 classroom contributions 360 classroom contributions 360 Classroom contributions y 360 Classroom contributions 360 Residentials 360 Residentials 360 classroom contributions 360 classroom contributions 360 Residential 360 classroom contributions 360 Residential 360 Residential 360 classroom contributions 360 Residential 360 Residential itita iita ita ita ita itita ita ita ita 3603360eeeeetaa fundraisinaappppr 60 Residential rrrrt trrn **Charit** ttttlace from OFlace lace lace copay,ppay,pppppay,ppppstttt R Rga waaaaaaaarrrrustustustusustyffhts - donation y,y,y,y,y,y,y,y,y,ppppes for GLesaspppppppppppppppppppppppppppee classroom contributionsttt classroom contributions classroom contributions classroom contributions classroom contributions classroom contributionst classroom contributions classroom contributions classroom contributionst pppaaaaaaaaaaaaaaaaaaaaaaaaaaacccpp **y** ipppppaypppppppayppppppaypayppppayppppppppppppppaaapityyyyyyyyyyyyyyyyyyyyyyyyyyylll mdeae online donation ppdee **/ Misc detail etc** assassassaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaappyyyaid direct to bank ment from LJment from DWment from MMment from YAment from RTLment from RNment from RMment from JYment from HSment from RSment from MMment from AKment from RMment from LLment from HSment from RSment from KVment from RNment from JYment from MMment from YAment from LLment from HSment from RSment from RTLment from JMment from RMye online donatione online donation p ryyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyonsor moneonsor monement from GLment from EMment from MPpgment made bntiorom nagments from JBment from KHment from JWment from ZHmment from IDment from HIment from APment from KWment from ISment from TPmment from MJment from JMment from LJment from RMment from MJmmment from BFment from DRment from HImment from MJment for SB ment from KWment from HIment from KWment from LDment from DRment from TP ment from JMment from JMPment from BFment from ISment from DGment from MJonsor monepp online donation rnintyrrrionsor moneonsor moneaooooooeeeeeagal skbagp,l nnnnt frnl bay JWonsorshipaym m m ggggttttppppppayp fr fr fr fraaaaaagggcococoooooo,yyyyyydoy cake sale from cake sale HC donation mm Dm DRm Dm m TP (mentsmentsmentsmentsmentsmment chinesebankinntrinntrinpeetyySCaant ri,,n LL SKtiySGyybubutbuptp **)** oyyment social workeraid b((n,BBankintiti, SWig ISoooa includes receinnnnkinsssy social care(p51.1081.70789.8525.00 **Fundraisin** ggaid in error to fosc in includes 1276125 **External Charity** clgudesp **g** 127t 1276065 1276066 **Christmas** 6 **Sundries** 116,ps instead of bud 127) 6117 **FundraisinMorning Coffee** ) 1290.002631.60123.70600.001127.83360.00174.000630.0010.0020.0030.00 **INCOME** 7.005.00g.60et **g** ) **Class** 346.46170.8612.8473.0551.3454.3012.8424.6818.7632.59 **tri** 0.99600.990.994.940.9930.990.995.925.920.993.950.990.990.990.990.990.99 **ps** ...999951 **100+ C** 4.00 **lub Donat** 150.00648.40133.76141.40232.52 **i** 60.0030.0030.0030.0020.00514.6330.0050.0021.2031.5012.0030.0092.0932.2030.0096.2280.0083.0072.0015.4050.02 **o** 1.25.99 **ns** 0 **Residential Tri** 150.00150.00150.00174.81100.00100.00100.00100.00100.00100.00108.88113.60100.00100.00150.00350.00150.00350.00345.48100.00100.00100.003350.00120.00120.00350.00118.46120.00120.00120.00 **p** 250.0050.0050.0070.0050.0050.0050.0050.0050.0050.0050.0050.0050.0081.5039.6050.0080.0050.0049.3550.0024.50.0050.0050.003043.8230.0032.1030.0030.0030.0040.0030.003030.0038.3059.2230.0030.0030.00903090.0088.8488.8460.0060.0059.2350.6059.236059.262.9570.0060.0060.0060.0050.0060.0080.0015.0030.0050.00 **s** 5.005.7.....68000000000063 **MoneVirgin y Restricted FundinGrant g Income Total** 1290.002631.60123.70150.00150.00150.00346.46174.81100.00100.00100.00100.00100.00100.00108.88150.00600.00113.601789.85127.83360.00648.40100.00133.76100.00174.00150.00350.00141.40150.00350.00345.48100.00100.00170.86100.003350.00120.00120.00350.00118.46232.52120.00120.00120.0006260.0012.8451.1030.0030.0030.0020.0050.0050.0050.00514.6370.0050.0050.0050.0050.0050.0073.0550.0050.0051.3450.0050.0081.5054.3030.0030.0081.7012.8410.0039.6050.0050.0080.0050.0025.0024.6849.3550.0024.50.0050.0050.003043.8221.2030.0032.1030.0031.5030.0030.0040.0030.003030.0038.3059.2218.7630.0012.0030.0030.00903090.0088.8430.0088.8492.0960.0060.0059.2350.6032.2059.236059.220.0030.0030.0096.2232.5962.9570.0080.0060.0060.0060.0050.0083.0072.0060.0080.0015.0015.4050.0230.0050.0051.20.000.9960.000.000.0000.000.000.990.990.000.000.004.940.000.990.0037.000.000.000.990.995.925.925.990.990.000.000.003.950.990.000.000.990.990.000.000.004.000.990.990.990.000.000.000.000.000.005.000.000.0000.000.005.00..7.........6068000000000099995006031 1290.00 **Am** 2631.60123.70 560.00 370.00 346.46 100.00 174.81 300.00 200.00 100.00 108.88 150.00 169.60 600.00 113.60 1130.00 789.85 127.83 360.00 648.40 150.00 133.76 150.00 174.00 150.00 350.00 141.40 150.00 380.00 168.30 500.00 120.00 350.00 118.46 232.52 345.48516.00120.00170.86100.003350.0060.00 12.84 51.10 514.63 73.05 51.34 50.00 50.00 81.50 54.30 30.00 81.70 12.84 10.00 50.00 50.00 25.00 24.68 49.35 24.50.00 8043.82 21.20 30.00 62.10 31.50 30.00 59.22 18.76 83.00 72.00 88.8430.0088.8492.0959.2350.6032.2059.236059.220.0030.0030.0096.2232.5962.950.99 600.99 0.99 4.94 0.99 37.00 0.99 0.99 5.92 5.92 5.99 0.99 3.95 0.99 0.99 0.99 062 **BANKINGS / DIRECT CREDIT** 0.990.990.995.001.2...5.99995 **ou** .6800..7001 6003 **n** 6 **t** 19/01/202324/01/202331/01/202309/02/202317/02/202314/02/202308/03/202309/03/202309/03/202314/03/202314/03/202316/03/202331/03/202315/03/202324/03/202324/03/202329/03/202329/03/202329/03/202330/03/202330/03/30/03/202331/03/202331/03/202331/03/202331/03/202331/03/202319/04/202321/04/202321/04/202326/04/202326/04/202310/05/20231112/05/202318/05/202316/05/202318/05/202319/05/202319/05/202325/05/202315/06/202305/07/202323/06/202323/06/202305/019/07/202319/07/202305/07/20205/07/202319/07/202321/07/202321/07/2023/05/ **D** 7 **ate** /2220002223333 **Deposit Slip No (BACS / Statement Interest** 0488400488430488460499510499540499610499650499660499670499700499690499750499860499730001010499780499800220360499820499830049985049987049988049989049990049991049992049995049996000065049998048751004875578743410026878751348758487564875948760487614876548770487674876844877423714487694877444 **No /** 91486799887775044 **)** _bacs 2_ bacs 9bacs 10bacs 13100259 - Children In Need100260 - Mr Davies - 100+ club winninbacs 17bacs 39bacs 40bacs 48bacs 59bacs 61bacs 62bacs 63bacs 64bacs 65bacs 68 **C** 1002611002621002631002641002651002661002671002681002691100271100272 **h** 00 **q N** 27 **o** 0 _Nova International_ HC - Reimbursement for stickers JK - Reimbursement for HC - Reimbursement for collection bucketsSK - 100+ club winninSC - Reimbursement for easter coffee morninPettHF - 100+ club KK - Hawkhirst refundMrs S - Hawkhirst refundCG - 100+ club winninHC - Reimbursement for café till The scout association - Residential JH - 100+ club SCPS - Reimbursement for classroom contributions for class snacks Jan - DecTwins trust - GNR vestsTwins trust LJ - 100+ club winninAB - Reimbursement for x 2 trikesHC - Reimbursement for raffle The scout association - Hawkhirst residential Calvert trust - 6th form residential Ice Newcastle city council AB - 1MS - 100+ club winninAC - 100+ club winnin **Payee** pyrint and desi - GNR vests cash from bank00 **/ D** + **esc** c-l GNR vestsub **ri** winninpp **pt** aa **i** yy **o** _-_ ment ment **n** _GNR places_ gggsgg **(Separate Exp** gssss -s **Reimburse Cash Float** annual lottery licensep **Lo** ap **g** ger **Ke** s500.00pp **p** rize lates **t)** pa **Fundraisin** y **Charity** ment for Hawkhirst 51.10g pa **g** yment **Christmas Sundries FundraisinMorning EXPENDITURE Coffee** 31.3651.50 **PREVIOUS YEARS CLOSING BOOK BALANCE / CURRENT YEAR OPENING BALANCE g Class** 170.86 **Trips 100+ Cl** 47.0047.0047.5047.5047.5048.00448.0048.00 **ub** 8.00 **Do** 1183.20 **n** _664.00_ 320.00 **at** 16.8726.0967.2083.0083.0089.9120.00 **ions Residential Tri** 2691.203000.00150.00100.00904.80 **ps Restricted FundinGrant g Expenditure Total** 1183.202691.203000.00664.00500.00150.00100.00170.86320.00904.8016.8726.0967.2051.1047.0047.0031.3647.5047.5047.5083.0083.0048.0051.5089.9120.00448.0048.0080.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.00000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00..............0000000000000000000000000000 (Opening Bal **BALANCE** + Income - **Running Balance Book 2** Ex26741.7826077.7826078.77226209.3826222.2226222.2226273.3226273.3226273.3226423.3226573.3226603.3226633.3226663.3226683.3226733.3226783.3226833.322226900.1426970.1427020.1427070.1427120.1427270.1427253.2727227.1827573.6427574.6327508.4227457.3227410.3227460.3227510.3227685.1327727858.1827908.1828008.1828058.1828011.1828016.1227984.7628036.1028037.0928087.0928137.0928237.0928337.0927837.0927918.5927972.892728076.8428106.8428136.8428236.8428318.5428427.4228577.4228584.4228597.2628549.7628559.7628599.3628649.3628699.3629299.3629412.96229599.5629649.5629649.5629650.5530440.4030465.4030593.2331883.2332243.2332267.9132916.3132917.3032966.6533016.6533116.6533122.573333281.0133331.0133431.0133605.0133755.0133805.0133810.9333816.9233817.9133667.9133567.9133520.4133524.3633874.3633875.3533925.353395533999.1732815.9730124.7730125.7630146.9630176.9630209.0630239.0630380.4630411.9630561.9630911.9630941.9630971.9631011.9631041.96331101.9631140.2631141.2531200.4731545.9531498.4531327.5931244.5931263.3531293.3531305.3531405.3531409.3531439.3531539.3531569.353331779.3531780.3431869.1831870.1731900.1731989.0132081.1032141.1032201.1032260.3332310.9332343.1332344.1232403.3532320.353332391.5832071.5832020.0831115.2828115.2828135.2828306.1428406.1428436.1428441.1428351.2328381.2331012.8331109.0531141.643331880.3531950.3532030.3532090.3532150.3532270.3532330.3532380.3532500.3532850.3532933.3533051.8133123.8133356.3333336.33333333192.3333252.3333372.3333492.3333572.3333587.3333592.3333607.7333657.7533687.7533807.7533857.75 **668** 608568368859511122414159147.206596893802240.p)587171.36388 **1.7** 4.699.587.40....1.......6835856359635353533333 **8** 1184505 **----- Start of picture text -----**
18/09/2318/09/2329/09/2310/10/23105/05/10/2325/09/2326/09/2326/09/2327/09/2327/09/2329/09/2303/10/2303/10/2305/10/2309/10/2310/10/2312/10/2312/10/2313/10/2317/10/23119/10/2320/10/2318/10/2319/10/2319/10/2319/10/2324/10/2324/10/2325/10/2325/10/2325/10/2325/10/2327/10/2327/10/2327/10/2306/11/2306/07/11/2308/11/2309/11/2317/11/2320/11/2327/10/2327/10/2327/10/2326/10/2331/10/2309/11/2309/11/2314/11/2315/11/2317/11/2317/11/23220/11/230/8/0/11111110/0/0///2222233333 12761461276147127614812761491271276151127615212761531276154127615512761561276157127615812761591276160127616112761621276163127616412712761661276167127616812761691276170bacs100bacs101bacs105bacs 78bacs 79bacs 80bacs 82bacs 83bacs 85bacs 86bacs 87bacs 88bacs 89bacs 90bacs 91bacs 92bacsbacs 94bacs 95bacs96bacs97bacs98bacs996611935065 GNR sGNR sCalvert trust 100SuDirect credit from SSHC 100+ clubEnthuse - GNR donationsMH - 100+ club SW - 100+ club MS - 100+ clubEJ - 100+ clubSG - 100+ blubJAVY - 100+ clubParent BK SMcK IBEnthuse - GNR donations KH100+ club Calvert trust Halloween disco tickets100+ club Calvert trust Calvert trust Donation to Calvert trust 100+ club Halloween disco ticketsHalloween disco ticketsHalloween disco ticketsHalloween disco ticketsCalvert trust payment from TPHalloween disco ticketsHHalloween disco ticketsHalloween disco tickets100+ club Calvert trust Children In Need donations Parent Donation from J KnottParent Parent Donation from LGS foundation for Calvert trust100+ club Enthuse - GNR donationsa,, PHmmll, SH+- COo 100 club payments from staff and parents w,epp-eepppp, LB 100, GS - 100+ club r onsor moneonsor mone JW 100+ club aaaa+con yyyy clubpppppdpppffaaaaa+iaaapppppeeyyyyysco clubyyyaaaaamentsmentsmentsmentsment from SRment for Calvert trust ment for Calvert trust ment for 100+ clubyyyyy mment from DGment from DRment from HOment from DGment from raffletoicrninyyk,ets Column Totals EE fundraising g for Calvert trust 127.82 1075.47 0.00 5645.73 130.00 843.17 264.00 861.00 24.0012.0048.0012.0012.0024.0048.0036.0012.0012.00472.0070.0012.0060.0047.0022.0022.008.00 1356.782000.00 6373.46 349.63111.5248.0060.0015.0015.0015.0015.0014.003040.0024.006.00.00 13922.48 3000.00850.00160.00110.00588.00620.0060.0060.0060.0080.0050.0060.00 0.00 Control Total 0.00 28721.3128721.31 1356.782000.003000.00264.001850.00349.63160.00110.00127.82588.00620.00111.523048.0060.0060.0024.0012.0048.0012.0012.0024.0048.0036.0012.0012.00472.0070.0060.0015.0012.0060.0080.0050.0060.0015.0015.0015.0060.0014.003040.0024.0047.0022.0022.00800.000.000.006.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.00.....0000000000 28721.31 1356.78 2000.00 3000.00 773.42 324.00 1850.00 349.63 160.00 602.00 308.82 588.00 620.00 111.52 24.00 12.00 48.00 12.00 12.00 24.00 48.00 36.00 12.00 12.00 472.00 22.00 22.00 308.00.00 26/09/202310/10/2023107/11/202320/11/20230/10/2023 4878048782448786487888785 bacs 81bacs 84bacs102bacs103bacs11002741002751002760010274 3 SCComic Relief Red nose contributionNewcastle CitRedfox FOSCPS - PettAlison Butterfield - 100+ club winninHelen Clarkson Newcastle City Council HelPen S - Column Totals CglCaardenworld - christmas fair resourceslrkasssoyn - Rcoy Council - ICT resources for students funded b- cashreimbursement for card machinentrieimbutibuo- Accounts 2022 auditnrses m 1000.00 500.00ent for rgsaffle p896.55 947.65 rize air fryer 0.00 y foscps 12 272.85 60.009.99 17 341.72 0.86 472.00 43.50 2501.00 5666.57 517.5094.80 Control Total 6846.00 0.00 15546.7915546.79 2501.0017896.55500.00517.501260.0043.5094.80090.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00.....8699000000 33905.7533965.7534025.7534289.753333352.3434202.3434226.3434575.9732074.9732086.9732134.9732074.9732086.9732098.9732122.9732170.9732206.9732366.9732378.9732390.97333795.7533867.7533937.7533997.7534012.7534024.7534084.7534164.7534214.7534274.7534289.7534304.7534319.7534325.7534385.7534399.75334469.7534493.7534540.7534650.7534778.5734278.5734278.5734235.0734823.0736823.0737443.0737465.0740465.0740487.0740392.2739874.773939856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.3039856.30 39856.30 44142424442744.738989.7...78995758
**----- End of picture text -----**
**SCHOOL NAME:** ## **2023 INCOME & EXPENDITURE SUMMARY** ||||||||**2023 OPENING BOOK BALANCE**|**2023 OPENING BOOK BALANCE**|**2023 OPENING BOOK BALANCE**|**26681.78**|(A)| |---|---|---|---|---|---|---|---|---|---|---|---| ||||||||||||| ||||||**INCOME**||||||| ||**External**||**Coffee**||||||**Restricted**||| ||**Charity**|**Christmas**|**Morning**||||**Residential**||**Grant**||| ||**Fundraising**|**Sundries**|**Fundraising**|**Class Trips**|**100+ Club**|**Donations**|**Trips**|**Virgin Money**|**Funding**|**Total**|| ||1075.47|0.00|5645.73|843.17|861.00|6373.46|13922.48|0.00|0.00|**28721.31**|(B)| ||||||||||||| ||||||**EXPENDITURE**||||||| ||**Reimburse**||||||||||| ||**Cash Float**||||||||||| ||**(Separate**|**External**||**Coffee**|||||**Restricted**||| ||**Exp Log**|**Charity**|**Christmas**|**Morning**||||**Residential**|**Grant**||| ||**Kept)**|**Fundraising**|**Sundries**|**Fundraising**|**Class Trips**|**100+ Club**|**Donations**|**Trips**|**Funding**|**Total**|| ||1000.00|947.65|0.00|272.85|341.72|472.00|5666.57|6846.00|0.00|**15546.79**|(C)| ||||||||||||| |||||||||||13174.52|(D) = B-C| ||||||||||||| |||||||||||**39856.30**|(E) = A+D| **MONTHLY / YEAR END BANK RECONCILIATION** _Date_ Cash at Bank 39547.48 _(As per Bank Statement) Cash in Hand Control_ Cash in Hand _(physical monies not yet banked)_ Cash in Transit and my donate 308.82 _(bankings not yet deposited)_ 39856.30 Less Cheques not yet presented _Chq No Chq No Chq No Chq No Chq No Amount Chq No Amount Chq No Amount Chq No Amount_ 0.00 **RECONCILIATION TOTAL** 39856.30 _(Should = E)_ Completed by Date Certified by Date ## **SCHOOL NAME:** **SCHOOL FUND CASH FLOAT EXPENDITURE 2023** **Cash Float Opening Balance 34.68** |**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**|**SCHOOL NAME:**| |---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---| |**SCHOOL FUND CASH FLOAT EXPENDITURE 2023**
**Cash Float Opening Balance**
**34.68**||||||||||||||||| ||||**SF CASH FLOAT EXPENDITURE & BALANCE LOG**||||||||||**CASH FLOAT CHECKS**|||| |**Date**|**Voucher No**
**(Exp) OR Chq**
**No (Cash**
**Float**
**Reimbsmt)**|**Description**
|**Reimbursement of**
**Cash Float**
**(Credit)**|
**External**
**Charity**
**Fundraising**|**Christmas**
**Sundries**|**Coffee**
**Morning**
**Fundraising**|**Class Trips**|**George**
**Douglas**
**Award**|**All Sponsored**
**Events eg**
**Collection**
**buckets/tins**|**Residential**
**Trips**|**100+ Club**|**Running Cash**
**Float Balance**|
**ACTUAL**
**BALANCE**
**(To be verified**
**weekly)**||

Cher
Ente
whic
previ
balan|yl Spencer:
r opening balance
h should equal the
ous years closing
ce| |||||||||||||||**DATE OF**
**CHECK (&**
**initials)**||| |13/03/23|_pc 1 - 100262_|_Petty cash from bank_|_-500.00_|||||||||**534.68**||||| |29/03/23|_pc2_|_Indian delights for coffee morning_||||_120.00_||||||**414.68**||||| |29/03/23|_pc3_|_Reimbursement for raffleprizes_||||191.30||||||**223.38**||||| |29/03/23|_pc4_|_Raffleprize_||||50.00||||||**173.38**||||| |11/10/23|pc5|_Prizes for xmas coffee morning_||||60.00||||||**113.38**||||| |07/11/23|pc6|Sweets/choc cones||||30.00||||||**83.38**||||| |06/11/23|pc7|Staff meeting|||||||8.99|||**74.39**||||| |06/11/23|pc8|Pettycash from bank|-500.00|||||||||**574.39**||||| |06/11/23|pc9|Cashprize||||75.00||||||**499.39**||||| |09/11/23|pc10|Halloweenpartyconsumables|||||||72.95|||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||||||||||||**426.44**||||| |||**Column Totals**|**-1000.00**|**0.00**|**0.00**|**526.30**|**0.00**|**0.00**|**81.94**|**0.00**|**0.00**|**426.44**||||| |||Control Total|**1000.00**|||||||||||||| **Voluntary Fund Audit Certificate** Name of Account: Friends of Sir Charles Parsons School 31st December 2023 Year Ending: INCOME AND EXPENDITURE (I&E) ACCOUNT |**INCOME**
External Charity Fundraising
Christmas Sundries
Coffee Morning Fundraising
Class Trips
100+ club
Sponsored events
Residential Trips
Donations Received
My Donation - Virgin Money
Other
In Year Surplus / (Deficit)|I&E Main
Ledger
Auditor
Adjust
Cash
Repts
1,075.47
-
9,630.21
843.17
896.00
18,238.55
6,781.61|£
**EXPENDITURE**

Total
1,075.47
External Charity Fundraising
-
Christmas Sundries
9,630.21
Coffee Morning Fundraising
843.17
Class Trips
896.00
100+ Club
-
Sponsored events
18,238.55
Residential Trips
6,781.61
Donations / Transfers to SCP
-
Cash float reimbursement*
-
Other
37,465.01
37,465.01
(C)
21,597.75
(A-B)|I&E Main
Ledger
Auditor
Adjustm'ts
Cash
Exp
947.65
747.83
717.05
341.72
518.50
81.94
6,846.00
5,666.57
1,000.00
(1,000.00)|£
Total
947.65
-
1,464.88
341.72
518.50
81.94
6,846.00
5,666.57
-| |---|---|---|---|---| |||||-| ||37,465.01
-
-
(A)||16,068.27
(1,000.00)
798.99
(B)|15,867.26| |||||15,867.26| |||||| |YEAR END RECONCILIATION
**CASH BOOK SUMMARY**
Opening Balance as at: 01/01/2023
_Bank/cheque_
_26,681.78_
_Unverified cash balance_
_34.68_
In Year Surplus / (Deficit)
(C)
Closing Balance
**_Bank/cheque_**
**_48,078.52_**
_Unverified cash balance_
_235.69_||**YEAR END BANK RECONCILIATION**
26,716.46
Cash at Bank
31/12/2023
Income received and not yet banked
unverified cash balance
Cash in Transit
21,597.75
48,314.21
Less cheques not yet presented
48,314.21||46,224.92
-| |||||235.69| |||||1,853.60
48,314.21
-| |||||| |||||48,314.21| |||||| Signed: (Chair) Date: ## **Auditors Statement** We have examined the financial records relating to this fund and consider that the accounts reflect a true and fair view of the operation of the fund, taking into account the auditors adjustments as explained in the notes below. Signed: C L Spencer (Auditor) Date: 04 July 2024 ## **Cheryl Spencer, Senior Auditor, Audit, Insurance and Risk, Newcastle City Council** ## **Auditors Notes, Observations and Recommendations** > 1 An audit adjustment has been made for the cash float reimbursement, to allow the actual cash expenditure and cash float balance to be separately shown in the above I&E account and year end reconciliation. All cash expenditure, cash float reimbursement and balance have been appropriately recorded by the school. - 2 The account is supported by a constitution which clearly sets out the fund purpose and responsibility. This was updated June 2024 - 3 A two step bank authorisation system exists to ensure that all bank transactions are checked and authorised. > 4 A suitable ledger is maintained to record receipts and payments, bankings and direct bank transactions. This facilitates bank reconciliations, which are undertaken on a regular basis, signed and filed with the corresponding bank statement. > 5 The ledger also provides a reference to source records, and transactions were found in the main to be well supported. A recommendation for removing duplication in the process and thereby improving efficiency and effectiveness, was agreed. - 6 All receipts and payments recorded in the ledger were confirmed to the bank statements. 1 of 1