Following work sheets have been locked with password 'password'
Annual Summary Monthly Split Bank Rec
This is to stop accidental modification as sheets should only need changing if new expe These sheets are designed to auto-populate using information added to Bank income a
Therefore each month the user should only need to add bank transactions into correct Once completed the closing balances in the 'Bank rec' worksheet should agree to the b
ense or income classifications need to be added (or formulas broken by inappropriate e and outgoings sheets.
area for that month and check that all transactions are being captured in the totals (us bank statement closing balance.
editing of link destinations in other sheets).
sing in built checksums present in each work sheet)
Emmer Green Pre-school 2019/20 Accounts
Prepared by Anthony Evans
| Prepared by Anthony Evans | |||||
|---|---|---|---|---|---|
| Fees / lunch Club/Admissions Funding Fees/Funding Committee Fundraising Milk Grant Savings a/c interest Sponsorship Voluntary Donations/Commissions Other Computer / Garden Equipment Funded Pre-School trip Wages Pension Contribution Inland Revenue Compupaye Pay Roll Costs Rent Phone / broadband / text services Milk/snacks Stationery / Equipement Training / First Aid Subscriptions/Insurance Fundraising Petty Cash Pre-school trips/Party Other DBS Checks Computer / Garden Equipment Funded Chiltern Training FIRST AID Proft /Loss |
2016/17 27,692.37 80,195.83 |
2017/18 29,032.60 93,637.75 122,670.35 3,279.01 970.06 - - 2,221.43 41.00 - - 1,057.20 130,239.05 81,206.66 612.21 8,502.22 1,114.36 10,453.34 1,198.37 1,028.61 2,955.59 240.50 1,200.60 228.79 0.00 1,161.41 371.01 186.07 110,459.74 19,779.31 |
2018/19 37,244.37 57,432.00 |
||
| 107,888.20 3,980.60 754.40 - - 2,055.45 271.25 - - 1,226.50 |
94,676.37 2,395.70 720.16 17.63 - 2,047.27 131.37 - - 351.50 |
||||
| 116,176.40 | 100,340.00 | ||||
| 91,225.84 98.07 1,663.05 1,369.97 |
81,206.66 612.21 8,502.22 1,114.36 |
78,560.82 1,146.83 7,212.88 1,025.88 |
|||
| 11,152.92 903.34 995.48 3,791.65 222.09 1,013.96 188.81 0.00 1,950.38 465.54 366.03 115,407.13 769.27 |
11,140.75 970.81 851.41 3,119.36 1,004.70 954.00 0.00 0.00 1,231.19 557.10 269.74 |
||||
| 108,045.47 | |||||
| -7,705.47 |
Green Pre-school for the Year Ended 31st August 2018 and confirm that they reflect the entries made in the books and records presented to me. These Statements have not been audited.
6,546.74
Date
Signed
Sept Oct Nov Dec Jan Feb Wages £7,187.51 £7,069.31 £6,950.09 £7,072.13 £6,930.19 £7,113.51
Sept '19 Oct '19 Nov '19 Dec '19 Jan '20 Feb '20
Wages
Mar Apr May Jun Jul Aug £7,098.47 £6,995.57 £7,005.94 £6,949.87 £7,037.26 £7,037.26
Mar '20 Apr '20 May '20 Jun '20 Jul '20 Aug '20
£84,447.11 * 80% of the cost base goes on salaries * c. 10% increase in salary cost in 2020
| Date | Description |
|---|---|
| September | |
| 09/06/2019 | Legal & General Pension |
| 09/09/2019 | Virgin Media Broadband |
| 09/09/2019 | Printer / Copier Rental - System Support UK |
| 09/13/2019 | HMRC |
| 09/16/2019 | Hobbycraft |
| 09/17/2019 | Labels Stationary |
| 09/20/2019 | Lock |
| 09/23/2019 | Pay Check Ltd |
| 09/23/2019 | Phone Bill Virgin Media |
| 09/25/2019 | Pre-Med Care |
| 09/26/2019 | Salaries |
| Sept Total | |
| October | |
| 10/01/2019 | Muller UK - Milk |
| 10/01/2019 | HMRC |
| 10/07/2019 | Envelopes Stationary |
| 10/07/2019 | Muller UK - Milk |
| 10/07/2019 | Virgin Media Broadband |
| 10/07/2019 | Rent |
| 10/11/2019 | Groceries |
| 10/16/2019 | Legal & General Pension |
| 10/16/2019 | Phone Bill Virgin Media |
| 10/16/2019 | Muller UK - Milk |
| 10/21/2019 | Pay Check Ltd |
| 10/22/2019 | Muller UK - Milk |
| 10/23/2019 | Captia Recruitment - DBS (Alison) |
| 10/23/2019 | Captia Recruitment - DBS (Clare) |
| 10/23/2019 | Captia Recruitment - DBS (Claire D) |
| 10/23/2019 | Captia Recruitment - DBS (Stacie) |
| 10/25/2019 | Salaries |
Oct Total
November 11/04/2019 Muller UK - Milk 11/04/2019 Texting Service 11/04/2019 HMRC 11/05/2019 Bill Payment - Dep Refund (Mrs Van San) 11/05/2019 Bill Payment - Dep Refund (Mrs A Bogatova) 11/05/2019 Bill Payment - Dep Refund (Miss P Monk) 11/05/2019 Bill Payment - Dep Refund (Mrs A E Holmes)
11/06/2019 Muller UK - Milk 11/11/2019 Hexagon Trip 11/11/2019 Muller UK - Milk 11/11/2019 Rent 11/12/2019 Bus 11/14/2019 First Aid 11/15/2019 Pension 11/18/2019 Bill Payment - Miss H V Longstaf 11/18/2019 Phone 11/18/2019 Bill Payment - Mr Steven Ruffles 11/20/2019 Pay Check Ltd 11/22/2019 Payment to Tesco 11/25/2019 Payment to Caversham Park 11/26/2019 Salaries 11/27/2019 Muller UK - Milk 11/27/2019 HMRC
Nov Total
December
12/02/2019 Xmas presents for children 12/02/2019 Stationary 12/09/2019 Xmas food 12/10/2019 Turkey & plates 12/10/2019 Xmas party food 12/10/2019 Milk 12/10/2019 Milk 12/10/2019 Milk 12/10/2019 Copier & printing 12/10/2019 Rent 12/11/2019 Equipment & xmas food 12/16/2019 Fares to panto 12/17/2019 Milk 12/17/2019 Entertainer 12/19/2019 Pension 12/20/2019 Salaries 12/20/2019 Payroll fees
Dec Total
January
01/06/2020 Milk 01/06/2020 Phone Bill 01/06/2020 Milk 01/06/2020 Virgin Media Broadband 01/06/2020 Ref 577PG00119512 Inland Revenue
01/10/2020 Card payment to Tesco 01/15/2020 Pensions 01/15/2020 Rent 01/16/2020 Activityvillage Membership Subscription 01/20/2020 Card payment to Tesco 01/20/2020 Phone Bill 01/20/2020 Milk 01/21/2020 Amazon CANCELLED - refunded (see Income) 01/22/2020 Payroll fees 01/24/2020 Salaries 01/24/2020 Bill payment - Dee A Lamden 01/24/2020 Bill payment - Complete Office So 01/24/2020 Milk 01/24/2020 Virgin Media Broadband 01/29/2020 Ref 577PG00119512 Inland Revenue
Jan Total
February
02/03/2020 Card payment to Tesco (re. cooking) 02/05/2020 The Oracle Car Park - Training Course 02/10/2020 Card payment to Amazon 02/10/2020 Milk 02/10/2020 Bill payment to Rbc Main Account 02/11/2020 Card payment to Tesco 02/12/2020 Milk 02/17/2020 Pensions 02/18/2020 Payroll fees 02/24/2020 Card payment to Tesco 02/26/2020 Salaries 02/26/2020 Milk 02/26/2020 Milk 02/26/2020 Bill payment to Gbs re. Ofsted 02/26/2020 Simon Johnson - New joiner REFUND 02/26/2020 Qaisar Mehmood - New joiner REFUND 02/26/2020 Ref 577PG00119512 Inland Revenue
Feb Total
March
03/04/2020 Bill payment to Systems Support UK 03/04/2020 Bill payment to Rbc Main Acc Ref: 0002366014 03/05/2020 Card payment to PO Counters
03/05/2020 Card payment to Budgens Emmer Green 03/05/2020 Online payment to Complete Office So
03/05/2020 Bill payment to Muller UK
03/13/2020 Card payment to Tesco 03/18/2020 Bill payment to Muller UK 03/18/2020 Bill payment to Virgin Media 03/20/2020 DD to Pay Check Ltd Fees 03/20/2020 Cheque Ref: 300341 Nursery World 03/23/2020 DD to Legal & General 03/23/2020 Bill payment to Muller UK 03/26/2020 DD Salaries 03/30/2020 Ref 577PG00119512 Inland Revenue
Mar Total
April
04/20/2020 DD to Pay Check Ltd Fees 04/21/2020 DD to Legal & General 04/22/2020 Bill payment to Muller UK 04/22/2020 Bill payment to Virgin Media 04/22/2020 Bill payment to Rbc Main Acc Ref: 0002391908 04/24/2020 DD Salaries 04/27/2020 Virgin Media Broadband 04/28/2020 Preschool Leaning Insurance 04/29/2020 Card payment to PO Counters
Apr Total
May
05/06/2020 Card payment to Gifgaf (Mobile topup) 05/06/2020 Ref 577PG00119512 Inland Revenue 05/12/2020 Bill Payment HV Longstaf (Preschool PPE) 05/15/2020 DD to Legal & General 05/18/2020 Virgin Media ref: 742690202001 05/20/2020 DD to Pay Check Ltd Fees 05/26/2020 DD Salaries
May Total
June
06/02/2020 Virgin Media Broadband 06/03/2020 Ref 577PG00119512 Inland Revenue 06/10/2020 Card Payment to www.Ico.Org.UK 06/15/2020 Card payment to Gifgaf (Mobile topup) 06/16/2020 On-line Bill Payment to Mplc Ltd (licence fee) 06/17/2020 Card Payment to Tesco Store 3095 06/19/2020 DD to Legal & General 06/19/2020 DD to Pay Check Ltd Fees
06/24/2020 Virgin Media ref: 742690202001 06/26/2020 DD Salaries 06/29/2020 Online payment to Complete Office So 06/29/2020 Virgin Media Broadband 06/29/2020 Ref 577PG00119512 Inland Revenue
June Total
July
07/08/2020 Online payment to Complete Office So 07/20/2020 DD to Pay Check Ltd Fees 07/21/2020 DD to Legal & General 07/24/2020 DD Salaries 07/29/2020 Virgin Media Broadband 07/29/2020 Ref 577PG00119512 Inland Revenue
July Total
August
- 08/18/2020 DD to Legal & General 08/20/2020 DD to Pay Check Ltd Fees 08/26/2020 DD Salaries
August Total
Annual Totals
Grand Total
School year 2020-2021
September
09/01/2020 Card payment to Technologi Ireland Update of SW 09/07/2020 Virgin Media ref: 742690202001 09/07/2020 Virgin Media Broadband
09/07/2020 Ref 577PG00119512 Inland Revenue
09/09/2020 Lily Mulholland - REFUND of fees paid (moved) 09/11/2020 Card Payment to Tesco Store 3095
09/14/2020 Printer / Copier Rental - System Support UK 09/16/2020 Virgin Media ref: 742690202001
09/17/2020 DD to Legal & General
09/18/2020 DD to Pay Check Ltd Fees 09/21/2020 Card Payment to Tesco Store 3095 09/21/2020 Card Payment to Hobbycraft 09/25/2020 DD Salaries 09/29/2020 Virgin Media Broadband 09/29/2020 Ref 577PG00119512 Inland Revenue
September Total
| Cheque no | Total Amount 130.22 72.00 589.21 548.34 8.45 4.49 4.00 92.76 9.83 84.19 7,187.51 8,731.00 12.48 675.23 1.94 24.96 36.00 797.17 14.50 175.00 11.89 24.96 92.76 24.96 48.29 48.29 48.29 48.29 7,069.31 9,154.32 24.96 414.00 649.76 100.00 100.00 100.00 100.00 |
Pension Wages |
|---|---|---|
| 130.22 7187.51 |
||
| 130.22 7,187.51 |
||
| 175.00 7,069.31 |
||
| 175.00 7,069.31 |
||
| 24.96 714.00 24.96 1,116.05 27.00 8.48 180.31 4.79 11.94 60.00 92.76 20.70 432.00 6,950.09 21.84 675.96 11,854.56 30.00 16.14 14.00 48.07 23.10 18.72 18.72 24.96 342.00 1,276.58 18.20 9.00 18.72 130.00 172.76 7,072.13 92.76 9,325.86 6.24 12.37 18.72 100.80 662.92 |
180.31 6,950.09 |
|---|---|
| 180.31 6,950.09 |
|
| 172.76 7,072.13 |
|
| 172.76 7,072.13 |
|
| 6.00 170.31 797.18 19.95 20.45 9.91 18.72 17.45 92.76 6,930.19 6.49 18.59 18.72 43.20 641.53 9,612.50 14.05 5.20 28.10 18.72 1,276.30 16.65 18.72 165.71 92.76 3.74 7,113.51 9.36 18.72 50.00 100.00 100.00 660.68 9,692.22 342.00 876.91 7.32 12.65 16.14 18.72 |
170.31 6,930.19 |
|---|---|
| 170.31 6,930.19 |
|
| 165.71 7,113.51 |
|
| 165.71 7,113.51 |
|
| 7.30 18.72 23.77 92.76 119.00 169.95 17.16 7,098.47 688.07 9,508.94 92.76 172.55 7.80 11.69 956.61 6,995.57 144.00 873.22 9.10 9,263.30 10.00 614.66 19.94 157.04 9.36 92.76 7,005.94 0.00 7,909.70 48.00 614.66 40.00 6.00 127.91 38.75 159.85 92.76 |
169.95 7,098.47 |
|---|---|
| 169.95 7,098.47 |
|
| 172.55 6,995.57 |
|
| 172.55 6,995.57 |
|
| 157.04 7,005.94 |
|
| 157.04 7,005.94 |
|
| 159.85 |
| 9.36 6,949.87 2.38 48.00 297.57 8,435.11 18.59 92.76 159.85 7,070.13 48.00 102.45 7,491.78 159.85 92.76 7,192.22 7,444.83 |
6,949.87 |
|---|---|
| 159.85 6,949.87 |
|
| 159.85 7,070.13 |
|
| 159.85 7,070.13 |
|
| 159.85 7,192.22 |
|
| 159.85 7,192.22 |
1,973.40 84,634.94
108,424.12 - links to cell C10 on 'Bank Rec'
74.99 21.61 48.00 193.61 150.00 29.35 342.00 10.32 159.85 159.85
| 92.76 6.85 28.65 6,104.50 37.68 97.49 7,397.66 |
6,104.50 |
|---|---|
| 159.85 6,104.50 |
| Printing/ | Milk/ | |||||||
|---|---|---|---|---|---|---|---|---|
| HMR&C | Rent | Stationary | Equipment | Snacks | ||||
| 589.21 | ||||||||
| 548.34 | ||||||||
| 4.49 | ||||||||
| 548.34 | 0.00 | 593.70 | 0.00 | 0.00 | ||||
| 12.48 | ||||||||
| 675.23 | ||||||||
| 1.94 | ||||||||
| 24.96 | ||||||||
| 797.17 | ||||||||
| 24.96 | ||||||||
| 24.96 | ||||||||
| 675.23 | 797.17 | 1.94 | 0.00 | 87.36 | ||||
| 24.96 | ||||||||
| 649.76 |
| 24.96 | ||||
|---|---|---|---|---|
| 24.96 | ||||
| 1,116.05 | ||||
| 4.79 | ||||
| 60.00 | ||||
| 20.70 | ||||
| 21.84 | ||||
| 675.96 | ||||
| 1,325.72 | 1,116.05 | 0.00 | 85.49 | 96.72 |
| 16.14 | ||||
| 18.72 | ||||
| 18.72 | ||||
| 24.96 | ||||
| 342.00 | ||||
| 1,276.58 | ||||
| 18.72 | ||||
| 0.00 | 1,276.58 | 358.14 | 0.00 | 81.12 |
| 6.24 | ||||
| 18.72 |
662.92
| 6.00 | ||||
|---|---|---|---|---|
| 797.18 | ||||
| 20.45 | ||||
| 18.72 | ||||
| 6.49 | ||||
| 18.59 | ||||
| 18.72 | ||||
| 641.53 | ||||
| 1,304.45 | 797.18 | 18.59 | 32.94 | 62.40 |
| 14.05 | ||||
| 28.10 | ||||
| 18.72 | ||||
| 1,276.30 | ||||
| 16.65 | ||||
| 18.72 | ||||
| 3.74 | ||||
| 9.36 | ||||
| 18.72 | ||||
| 660.68 | ||||
| 660.68 | 1,276.30 | 0.00 | 62.54 | 65.52 |
| 342.00 | ||||
| 876.91 | ||||
| 7.32 | ||||
| 12.65 | ||||
| 16.14 | ||||
| 18.72 |
| 7.30 | ||||
|---|---|---|---|---|
| 18.72 | ||||
| 17.16 | ||||
| 688.07 | ||||
| 688.07 | 876.91 | 365.46 | 19.95 | 54.60 |
| 7.80 | ||||
| 956.61 | ||||
| 9.10 | ||||
| 0.00 | 956.61 | 9.10 | 0.00 | 7.80 |
| 614.66 | ||||
| 19.94 | ||||
| 614.66 | 0.00 | 0.00 | 19.94 | 0.00 |
| 614.66 | ||||
| 38.75 |
| 2.38 | ||||
|---|---|---|---|---|
| 297.57 | ||||
| 912.23 | 0.00 | 2.38 | 38.75 | 0.00 |
| 18.59 | ||||
| 102.45 | ||||
| 102.45 | 0.00 | 18.59 | 0.00 | 0.00 |
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 6,831.83 | 7,096.80 | 1,367.90 | 259.61 | 455.52 |
| 193.61 | ||||
| 29.35 | ||||
| 342.00 |
6.85 28.65 97.49 291.10 0.00 348.85 58.00 0.00
| Payroll | |||||||
|---|---|---|---|---|---|---|---|
| Phone | Internet | costs | Petty cash | Other | |||
| 72.00 | |||||||
| 8.45 | |||||||
| 4.00 | |||||||
| 92.76 | |||||||
| 9.83 | |||||||
| 9.83 | 72.00 | 92.76 | 0.00 | 12.45 | |||
| 36.00 | |||||||
| 14.50 | |||||||
| 11.89 | |||||||
| 92.76 | |||||||
| 11.89 | 36.00 | 92.76 | 0.00 | 14.50 | |||
| 414.00 | |||||||
| 100.00 | |||||||
| 100.00 | |||||||
| 100.00 | |||||||
| 100.00 |
| 11.94 | ||||
|---|---|---|---|---|
| 92.76 | ||||
| 432.00 | ||||
| 425.94 | 0.00 | 92.76 | 0.00 | 832.00 |
| 92.76 | ||||
|---|---|---|---|---|
| 0.00 | 0.00 | 92.76 | 0.00 | 0.00 |
| 12.37 | ||||
| 100.80 |
----- Start of picture text -----
9.91
17.45
92.76
43.20
22.28 144.00 92.76 0.00 17.45
5.20
92.76
100.00
100.00
0.00 0.00 92.76 0.00 205.20
----- End of picture text -----
| 23.77 | ||||
|---|---|---|---|---|
| 92.76 | ||||
| 23.77 | 0.00 | 92.76 | 0.00 | 0.00 |
| 92.76 | ||||
| 11.69 | ||||
| 144.00 | ||||
| 11.69 | 144.00 | 92.76 | 0.00 | 0.00 |
| 10.00 | ||||
| 9.36 | ||||
| 92.76 | ||||
| 19.36 | 0.00 | 92.76 | 0.00 | 0.00 |
| 48.00 | ||||
| 6.00 |
92.76
9.36
| 48.00 | |||||
|---|---|---|---|---|---|
| 15.36 | 96.00 | 92.76 | 0.00 | 0.00 | |
| 92.76 | |||||
| 48.00 | |||||
| 0.00 | 48.00 | 92.76 | 0.00 | 0.00 | |
| 92.76 | |||||
| 0.00 | 0.00 | 92.76 | 0.00 | 0.00 | |
| 540.12 | 540.00 | 1,113.12 | 0.00 | 1,081.60 | |
| = | |||||
| 1,080.12 | |||||
| 21.61 | |||||
| 48.00 | |||||
| 150.00 | |||||
| 10.32 |
92.76 37.68 31.93 85.68 92.76 0.00 150.00
| Subscriptions | Training / | ||||
|---|---|---|---|---|---|
| /Insurance | First Aid | **Fundraising ** | DBS Checks | Trips / parties | |
| 84.19 | |||||
| 0.00 | 84.19 | 0.00 | 0.00 | 0.00 | |
| 48.29 | |||||
| 48.29 | |||||
| 48.29 | |||||
| 48.29 | |||||
| 0.00 | 0.00 | 0.00 | 193.16 | 0.00 |
714.00 27.00 8.48
| 0.00 | 0.00 | 8.48 | 0.00 | 741.00 |
|---|---|---|---|---|
| 30.00 | ||||
| 14.00 | ||||
| 48.07 | ||||
| 23.10 | ||||
| 18.20 | ||||
| 9.00 | ||||
| 130.00 | ||||
| 0.00 | 0.00 | 0.00 | 0.00 | 272.37 |
| 19.95 | ||||
|---|---|---|---|---|
| 19.95 | 0.00 | 0.00 | 0.00 | 0.00 |
| 50.00 | ||||
| 50.00 | 0.00 | 0.00 | 0.00 | 0.00 |
119.00
| 119.00 | 0.00 | 0.00 | 0.00 | 0.00 |
|---|---|---|---|---|
| 873.22 | ||||
| 873.22 | 0.00 | 0.00 | 0.00 | 0.00 |
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 40.00 | ||||
| 127.91 |
| 167.91 | 0.00 | 0.00 | 0.00 | 0.00 |
|---|---|---|---|---|
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 1,230.08 | 84.19 | 8.48 | 193.16 | 1,013.37 |
| 74.99 |
74.99 0.00 0.00 0.00 0.00
Check (should be 0.00)
Total
130.22 72.00 589.21 548.34 8.45 4.49 4.00 92.76 9.83 84.19 7187.51
8,731.00 12.48 675.23 1.94 24.96 36.00 797.17 14.50 175.00 11.89 24.96 92.76 24.96 48.29 48.29 48.29 48.29 7069.31 9,154.32 24.96 414.00 649.76 100.00 100.00 100.00 100.00
24.96 714.00 24.96 1116.05 27.00 8.48 180.31 4.79 11.94 60.00 92.76 20.70 432.00 6950.09 21.84 675.96
11,854.56
30.00 16.14 14.00 48.07 23.10 18.72 18.72 24.96 342.00 1,276.58 18.20 9.00 18.72 130.00 172.76 7,072.13 92.76 9,325.86 6.24 12.37 18.72 100.80 662.92
6.00 170.31 797.18 19.95 20.45 9.91 18.72 17.45 92.76 6,930.19 6.49 18.59 18.72 43.20 641.53 9,612.50 14.05 5.20 28.10 18.72 1,276.30 16.65 18.72 165.71 92.76 3.74 7,113.51 9.36 18.72 50.00 100.00 100.00 660.68 9,692.22 342.00 876.91 7.32 12.65 16.14 18.72
| 7.30 18.72 23.77 92.76 119.00 169.95 17.16 7,098.47 688.07 |
|
|---|---|
| 9,508.94 | |
| 92.76 172.55 7.80 11.69 956.61 6,995.57 144.00 873.22 9.10 |
|
| 0.00 9,263.30 |
|
| 10.00 614.66 19.94 157.04 9.36 92.76 7,005.94 0.00 |
|
| 0.00 7,909.70 |
|
| 48.00 614.66 40.00 6.00 127.91 38.75 159.85 92.76 |
| 9.36 | ||||
|---|---|---|---|---|
| 6,949.87 | ||||
| 2.38 | ||||
| 48.00 | ||||
| 297.57 | ||||
| 0.00 | 8,435.11 | |||
| 18.59 | ||||
| 92.76 | ||||
| 159.85 | ||||
| 7,070.13 | ||||
| 48.00 | ||||
| 102.45 | ||||
| 0.00 | 7,491.78 | |||
| 159.85 | ||||
| 92.76 | ||||
| 7,192.22 | ||||
| 0.00 | 7,444.83 | |||
| check | 108,424.12 | should be | 0.00 | |
| 74.99 | ||||
| 21.61 | ||||
| 48.00 | ||||
| 193.61 | ||||
| 150.00 | ||||
| 29.35 | ||||
| 342.00 | ||||
| 10.32 | ||||
| 159.85 |
| 92.76 | |
|---|---|
| 6.85 | |
| 28.65 | |
| 6,104.50 | |
| 37.68 | |
| 97.49 | |
| 0.00 | 7,397.66 |
Total in Col D agrees to Totals in Col AA
Date
September
09/03/2019 09/03/2019 09/03/2019 09/16/2019 09/23/2019 09/24/2019 09/24/2019 09/24/2019 09/24/2019 09/26/2019 09/26/2019 09/26/2019 09/26/2019 09/27/2019 09/30/2019 09/30/2019
October
10/01/2019 10/01/2019 10/01/2019 10/01/2019 10/01/2019 10/02/2019 10/02/2019 10/02/2019 10/02/2019 10/04/2019 10/04/2019 10/04/2019 10/07/2019 10/07/2019 10/09/2019 10/09/2019 10/09/2019 10/09/2019 10/09/2019 10/09/2019 10/10/2019 10/14/2019 10/15/2019
10/16/2019 10/17/2019 10/22/2019 10/28/2019
November
11/06/2019 11/06/2019 11/06/2019 11/06/2019 11/06/2019 11/06/2019 11/07/2019 11/07/2019 11/07/2019 11/07/2019 11/07/2019 11/08/2019 11/08/2019 11/08/2019 11/08/2019 11/11/2019 11/11/2019 11/11/2019 11/12/2019 11/12/2019 11/12/2019 11/12/2019 11/12/2019 11/12/2019 11/12/2019 11/12/2019 11/13/2019 11/13/2019 11/14/2019 11/15/2019 11/15/2019 11/15/2019 11/15/2019 11/18/2019 11/18/2019 11/18/2019 11/22/2019 11/22/2019
11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/25/2019 11/26/2019 11/26/2019 11/28/2019 11/29/2019
December
12/02/2019 12/02/2019 12/02/2019 12/04/2019 12/04/2019 12/06/2019 12/10/2019 12/10/2019 12/11/2019 12/11/2019 12/16/2019 12/16/2019 12/17/2019 12/17/2019 12/17/2019 12/20/2019
January
01/02/2020 01/06/2020 01/07/2020 01/07/2020 01/07/2020 01/07/2020 01/07/2020
01/07/2020 01/07/2020 01/07/2020 01/07/2020 01/07/2020 01/09/2020 01/09/2020 01/09/2020 01/10/2020 01/10/2020 01/13/2020 01/14/2020 01/14/2020 01/14/2020 01/14/2020 01/15/2020 01/15/2020 01/16/2020 01/16/2020 01/17/2020 01/17/2020 20/01/2020 21/01/2020 21/01/2020 21/01/2020 21/01/2020 21/01/2020 22/01/2020 24/01/2020 27/01/2020 27/01/2020 27/01/2020 28/01/2020 29/01/2020 29/01/2020 29/01/2020
February
02/03/2020 02/05/2020 02/06/2020 02/13/2020 02/14/2020 02/17/2020
02/19/2020 02/24/2020 02/24/2020 02/24/2020 02/24/2020 02/25/2020 02/25/2020 02/26/2020 02/26/2020 02/27/2020 02/28/2020 02/28/2020 02/28/2020 02/28/2020 02/28/2020
March
03/02/2020 03/02/2020 03/02/2020 03/02/2020 03/02/2020 03/02/2020 03/02/2020 03/03/2020 03/03/2020 03/03/2020 03/03/2020 03/04/2020 03/04/2020 03/06/2020 03/02/2020 03/11/2020 03/11/2020 03/11/2020 03/11/2020 03/12/2020 03/12/2020 03/13/2020 03/16/2020 03/16/2020 03/16/2020 03/23/2020 03/30/2020
April
03/31/2020 04/02/2020 04/03/2020 04/14/2020 04/23/2020 04/23/2020 04/24/2020 04/24/2020 04/24/2020 04/24/2020 04/27/2020 04/27/2020 04/27/2020 04/27/2020 04/27/2020 04/28/2020 04/28/2020 04/28/2020 04/29/2020 04/29/2020 04/29/2020 04/29/2020
May
05/01/2020 05/12/2020 05/14/2020 05/19/2020
June
06/12/2020 06/17/2020 06/18/2020 06/22/2020 06/26/2020 06/29/2020 06/29/2020 06/29/2020
July
07/01/2020 07/02/2020 07/06/2020 07/10/2020 07/13/2020 07/15/2020 07/15/2020
August 08/14/2020
September 09/11/2020 09/14/2020 09/16/2020 09/16/2020 09/16/2020 09/16/2020 09/16/2020 09/16/2020 09/22/2020 09/22/2020 09/22/2020 09/25/2020 09/28/2020
| A/C No 80343277 fees |
A/C No 80343277 fees |
|---|---|
| Fees Gupta - refRGUP37097 94.50 Fees Smith - refRCHA43230 165.00 Fees Gupta - refRGUP37097 630.00 Fees Edenred - refCasper Van San 96.00 First Aid Course Fees - refJSWA64825 67.50 Fees Karn G - refLunch Term1 Avi 94.50 Fees Karn G - refLunch Term1 Avi 150.00 Fees Smith S - refR Chapman 22.50 Fees Bogato & Borgat - refM Bogatov 72.00 Fees A Verma - refR Didwania 94.50 Fees A Verma - refR Didwania 150.00 Fees Kiddivouchers - refMatilda Dickinson 72.00 Fees Taggart Olivia - refR Taggart Olivia 67.50 Fees R Tyler - refBrooklyn Asher 245.00 Fees Brown - refW Brown 72.00 |
|
| Sept Total | 2,093.00 |
| Contributions Taggart Olivia - ref R Taggert Contributions P Swayze - refJessica Swayze Fees King Liam - refT King 75.00 Fees Shah M&H - refViraj Shah Prescho 94.50 Fees Shah M&H - refViraj Shah Prescho 150.00 Contributions Holmes A E - refJholmes Fees A E Holmes - refJholmes 36.00 Fees A E Holmes - refJholmes 135.00 Fees Comp Voucher - ref0009462989 244.50 Contribution A Verma - refR Didwania Fees Edenred - refPY437741677 334.50 Fees Alam K - refZunairah Inaaya 49.50 Contributions Bogato & Borgat - refM Bogatov Fees Vipperla S - refRigved Vipperla 155.00 Fees M Northway - refBeatruce Northway 49.50 Fees Sonia Chhibba - refR Chhibba 67.50 Fees T Lisi - refZ Lisi 72.00 Fees Patterson Amanda - refT King 94.50 Milk Grant - refNmru-N993972L-2019 Contributions Comp Voucher - ref0009488481 Fees Jones I&K - refTheo Jones 45.00 Fees Edenred - refSiddharth Goteti 170.00 Fees Kuppaswamy Chokka - refE Lakshman 49.50 |
----- Start of picture text -----
Fees Thomas G E - refGthomas 165.00
Contribution Dickinson S E - refMatilda Contributi
Fees Smith S - refR Chapman 19.50
Deposit Henley on Thames - ref100171
Oct Total 2,006.50
----- End of picture text -----
| Oct Total | 2,006.50 |
|---|---|
| Fees Dustan Emily - Ref J Dustan | 27.00 |
| Fees National Savings - Ref Jswa64825 | 81.00 |
| Fees Amanda Patterson - Ref T King | 90.00 |
| Fees Amanda Patterson - Ref T King | 108.00 |
| Fees Edenred - Ref Casper Van San | 240.00 |
| Fees S Smith - Ref R Chapman | 27.00 |
| Panto - Ref M Bogatov | |
| Fees Bogato&Bogat - Ref M Bogatov | 81.00 |
| Fees A Verma - Ref R Didwania | 108.00 |
| Fees A Verma - Ref R Didwania | 180.00 |
| Milk Grant - refNmru-N993972L-2019 | |
| Fees Taggart Olivia - ref R Taggert | 81.00 |
| Fees Karn G - Ref Avi Kam | 108.00 |
| Fees Karn G - Ref Avi Kam | 180.00 |
| Fees Kiddi Vouchers - Ref Matilda Dickinson | 81.00 |
| Panto R Rapson - Ref Panto | |
| Fees R Rapson - Ref Panto | 81.00 |
| Fees M Boulton Smith - Ref E Boulton Singh | 180.00 |
| Panto Karn G - Ref Avi Panto | |
| Fees A E Holmes - refJholmes | 54.00 |
| Panto Dinkinson - Matilda Dickinson | |
| Fees Gupta - refRGUP37097 | 108.00 |
| Fees Gupta - refRGUP37097 | 180.00 |
| Fees A E Holmes - refJholmes | 180.00 |
| Fees Vipperla S - Ref Rigved Vipperia | 180.00 |
| Fees R Tyler - Ref Brooklyn Asher | 288.00 |
| Fees - Ref Rcha3230 | 180.00 |
| Fees Comp Voucher - Ref 0009566091 | 288.00 |
| Milk Grant - refNmru-N993972L-2019 | |
| Panto Vipperla S - Ref Rigved Vipperia | |
| Fees Jones I & K - Ref Theo Jones | 54.00 |
| Fees Jones I & K - Ref Theo Jones | 360.00 |
| Funding RBC | |
| Panto T Lisi - Ref Lisi Panto | |
| Fees T Lisi - Ref Lisi Panto | 81.00 |
| Fees Darren Northway - Ref B Northway | 81.00 |
| Contribution Dickinson - Ref Matilda | |
| Contribution A Verma - Ref R Didwania |
| Xmas Party Bogato&Bogat - Ref Mbogatov Xmas Party Bogato&Bogat - Ref Mbogatov Contribution Taggart Olivia - Ref R Taggart Contribution Bogato&Bogat - Ref Mbogatov Contribution P Swayze - Ref Jessica Swayze Fees Shah M&H - Ref Viraj Shah 188.00 Fees Smith S - Ref R Chapman 4.50 Panto Thomas GE - Ref George Fees Thomas GE - Ref H Thomas 180.00 Fees Brown - Ref W Brown 81.00 Xmas Brown - Ref W Brown Deposit Deposit Fees Edenred - Ref Siddharth 288.00 New Child Deposit Simon Johnson - Ref Preschool |
Xmas Party Bogato&Bogat - Ref Mbogatov Xmas Party Bogato&Bogat - Ref Mbogatov Contribution Taggart Olivia - Ref R Taggart Contribution Bogato&Bogat - Ref Mbogatov Contribution P Swayze - Ref Jessica Swayze Fees Shah M&H - Ref Viraj Shah 188.00 Fees Smith S - Ref R Chapman 4.50 Panto Thomas GE - Ref George Fees Thomas GE - Ref H Thomas 180.00 Fees Brown - Ref W Brown 81.00 Xmas Brown - Ref W Brown Deposit Deposit Fees Edenred - Ref Siddharth 288.00 New Child Deposit Simon Johnson - Ref Preschool |
|---|---|
| Nov Total | 4,428.50 |
| AE Holmes cont - ref holmes Xmas production - ref jungle Lakshman fees - ref el 36.00 AT Moore fees - ref josh moore 165.00 Cont - ref 0009612469 R Rapson xmas party - ref party MH Shah fees - ref viraj shah prescho 100.00 Thomas GE xmas prod - ref thomas prod MH Shah xmas - ref viraj Fees comp voucher - ref 0009630684 283.50 Panto Vipperla S - ref rigved panto Deposit new child Mehmood Q - ref Msmm Deposit Caversham 100174 Deposit Caversham 100172 Deposit Caversham 100173 Funding - ref 225245 |
|
| Dec Total | 584.50 |
| McCarthy & Wells - Photographs Fees - Edenred Ref: Caspar Van San 120.00 Fees - Emily Dunstan Ref: J Dunstan 54.00 Fees - Simon Jonson Ref: Invoice 54.00 Fees - Olivia Taggart Ref: R Taggart 76.50 Fees - Darren Northway Ref: B Northway 81.00 Fees - National Savings A Ref: Rgup37097 103.50 |
| Fees - Karn G Ref: Lunch Term3 Avi 103.50 Fees - National Savings A Ref: Rgup37097 150.00 Fees - Karn G Ref: Term3 Avi 180.00 Fees - S Smith Ref: R Chapman 27.00 Fees - K Alam Ref: Zunairah Inaaya 76.50 Fees - A Verma Ref: R Didwania 103.50 Fees - A Verma Ref: R Didwania 150.00 Fees - Kiddivouchers LT Ref: Matilda Dickinson 81.00 Fees - Amanda Patterson Ref: T King 75.00 Fees - Amanda Patterson Ref: T King 103.50 Fees - S Vipperla Ref: Rigved Vipperla 165.00 Fees - AE Holmes Ref: Jude Holmes 54.00 Fees - National Savings A Ref: Jswa64825 76.50 Fees - AE Holmes Ref: Jude Holmes 180.00 Fees - R Tyler Ref: Brooklyn Asher 253.50 Fees - M Boulton-Smith Ref: E Boulton-Singh 180.00 Fees - GE Thomas Ref: Gthomas 187.50 Fees - T Lisi Ref: Z Lisi 76.50 Fees - Bogato&Bogat Ref: M Bogatov 76.50 Fees - I & K Jones Ref: Theo Jones 49.50 Fees - I & K Jones Ref: Theo Jones 330.00 Fees - S Smith Ref: R Chapman 30.00 Fees - P Swayze Ref: Jessica Swayze 20.00 Fees - National Savings A Ref: Rcha43230 150.00 Fees - M&H Shah Ref: Viraj Shah Prescho 283.50 Amazon Refund (see Outgoings 21/01/2020) Deposit Re: 43Caversham 100425 Fees - Edenred Ref: Siddharth Gotet 253.50 Donation - Olivia Taggart Ref: R Taggart Donation - SE Dickinson Ref: Matilda Fees - Edenred Ref: Caspar Van San 91.50 Fees - K Alam Ref: Zunairah Inaaya 81.00 Donation - A Verma Ref: R Didwania Fees - R Rapson Ref: Umberellas 2.00 Fees - S Smith Ref: R Chapman 4.50 Fees - S Smith Ref: R Chapman 4.50 |
Fees - Karn G Ref: Lunch Term3 Avi 103.50 Fees - National Savings A Ref: Rgup37097 150.00 Fees - Karn G Ref: Term3 Avi 180.00 Fees - S Smith Ref: R Chapman 27.00 Fees - K Alam Ref: Zunairah Inaaya 76.50 Fees - A Verma Ref: R Didwania 103.50 Fees - A Verma Ref: R Didwania 150.00 Fees - Kiddivouchers LT Ref: Matilda Dickinson 81.00 Fees - Amanda Patterson Ref: T King 75.00 Fees - Amanda Patterson Ref: T King 103.50 Fees - S Vipperla Ref: Rigved Vipperla 165.00 Fees - AE Holmes Ref: Jude Holmes 54.00 Fees - National Savings A Ref: Jswa64825 76.50 Fees - AE Holmes Ref: Jude Holmes 180.00 Fees - R Tyler Ref: Brooklyn Asher 253.50 Fees - M Boulton-Smith Ref: E Boulton-Singh 180.00 Fees - GE Thomas Ref: Gthomas 187.50 Fees - T Lisi Ref: Z Lisi 76.50 Fees - Bogato&Bogat Ref: M Bogatov 76.50 Fees - I & K Jones Ref: Theo Jones 49.50 Fees - I & K Jones Ref: Theo Jones 330.00 Fees - S Smith Ref: R Chapman 30.00 Fees - P Swayze Ref: Jessica Swayze 20.00 Fees - National Savings A Ref: Rcha43230 150.00 Fees - M&H Shah Ref: Viraj Shah Prescho 283.50 Amazon Refund (see Outgoings 21/01/2020) Deposit Re: 43Caversham 100425 Fees - Edenred Ref: Siddharth Gotet 253.50 Donation - Olivia Taggart Ref: R Taggart Donation - SE Dickinson Ref: Matilda Fees - Edenred Ref: Caspar Van San 91.50 Fees - K Alam Ref: Zunairah Inaaya 81.00 Donation - A Verma Ref: R Didwania Fees - R Rapson Ref: Umberellas 2.00 Fees - S Smith Ref: R Chapman 4.50 Fees - S Smith Ref: R Chapman 4.50 |
|---|---|
| Jan Total | 4,088.50 |
| Fees - Bogato&Bogat Ref: M Bogatov 30.00 Donation - AE Holmes Ref: Jude Holmes Fees - Edenred Ref: Caspar Van San 120.00 Deposit Re: 43Caversham 100129 DH Wfru Ref: Nmru-N993972L-2020 Fees - C Mellin Ref: Ella Smith 150.00 |
| Comp Voucher Serv Ref: 0009775600 Fees - Emily Dunstan Ref: J Dunstan 54.00 Fees - G Karn Ref: Lunch Term4 Avi 103.50 Fees - S Vipperla Ref: Rigved Vipperia 165.00 Fees - G Karn Ref: Term4 Avi 180.00 Fees - National Savings A Ref: Jswa64825 76.50 Fees - Olivia Taggart Ref: R Taggart 76.50 Fees - Bogato&Bogat Ref: M Bogatov 76.50 Fees - S Smith Ref: R Chapman 27.00 Fees - Kiddivouchers LT Ref: Matilda Dickinson 81.00 Fees - Simon Johnson Ref: Invoice 54.00 Fees - National Savings A Ref:Rgup37097 103.50 Fees - National Savings A Ref: Rgup37097 150.00 DH Wfru Ref: Nmru-N993972L-2020 Fees - GE Thomas Ref: Gthomas 187.50 |
Comp Voucher Serv Ref: 0009775600 Fees - Emily Dunstan Ref: J Dunstan 54.00 Fees - G Karn Ref: Lunch Term4 Avi 103.50 Fees - S Vipperla Ref: Rigved Vipperia 165.00 Fees - G Karn Ref: Term4 Avi 180.00 Fees - National Savings A Ref: Jswa64825 76.50 Fees - Olivia Taggart Ref: R Taggart 76.50 Fees - Bogato&Bogat Ref: M Bogatov 76.50 Fees - S Smith Ref: R Chapman 27.00 Fees - Kiddivouchers LT Ref: Matilda Dickinson 81.00 Fees - Simon Johnson Ref: Invoice 54.00 Fees - National Savings A Ref:Rgup37097 103.50 Fees - National Savings A Ref: Rgup37097 150.00 DH Wfru Ref: Nmru-N993972L-2020 Fees - GE Thomas Ref: Gthomas 187.50 |
|---|---|
| Feb Total | 1,635.00 |
| Fees - I & K Jones Ref: Theo Jones 49.50 Fees - Amanda Patterson Ref: T King 75.00 Fees - Amanda Patterson Ref: T King 103.50 Fees - R Tyler Ref: Brooklyn Asher 253.50 Fees - I & K Jones Ref: Theo Jones 330.00 DH Wfru Ref: Nmru-N993972L-2020 Fees - C Mellin Ref: Ella Smith 22.50 Fees - AE Holmes Ref: Jude Holmes 54.00 Fees - National Savings A Ref: Rcha43230 180.00 Fees - AE Holmes Ref: Jude Holmes 180.00 Fees - K Alam Ref: Zunairah Inaaya 76.50 Fees - Edenred Ref: Caspar Van San 120.00 Comp Voucher Serv Ref: 0009810199 283.50 Fees - R Rapson Ref: Lunch 76.50 Fees - Darren Northway Ref: B Northway 81.00 Fees - A Verma Ref: R Didwania 103.50 Fees - A Verma Ref: R Didwania 150.00 Fees - M Boulton-Smith Ref: E Boulton-Singh 180.00 Brighter Futures F Ref: 233822 Contribution - Emily Dunstan Ref: J Dunstan Fees - JL Brown Ref: W Brown 81.00 New Child Deposit - S Meeks Ref: Isaac Buck Contribution - I & K Jones Ref: Theo Jones Contribution - P Swayze Ref: Jessica Swayze Fees - T Lisi Ref: Z Lisi 76.50 Contribution - C Mellin Ref: Ella Smith Fees - M&H Shah Ref: Viraj Shah Prescho 283.50 |
| Mar Total | 2,760.00 |
|---|---|
| Fees - JR Evans Ref: James Evans 110.00 Fees - Edenred Ref: Siddharth Coteti 150.00 Brighter Futures F Ref: 237021 Fees - E Kavak Ref: E Kavak 27.00 Fees - Olivia Taggart Ref: R Taggart 27.00 Fees - M&H Shah Ref: Viraj Shah Prescho 113.50 Fees - Dunstan Family Ref: J Dunstan 20.25 Fees - National Savings A Ref: Jswa64825 27.00 Fees - Kiddivouchers Ref: Matilda Dickinson 31.50 Fees - S Smith Ref: R Chapman 20.25 Fees - Simon Johnson Ref: Invoice 20.25 Fees - AE Holmes Ref: Jude Holmes 22.50 Fees - Edenred Ref: Caspar April Covid 83.25 Fees - C Mellin Ref: Ella Smith Lunch 6.75 Fees - C Mellin Ref: Ella Smith 45.00 Fees - Darren Northway Ref: B Northway 31.50 Fees - A Verma Ref: R Didwania 38.25 Fees - A Verma Ref: R Didwania 45.00 Fees - AT Moore 599 Ref: Joshua Moore 60.00 Fees - Comp Voucher Serv Ref: 0009890005 98.25 Fees - Deposit at Barclays PO Ref: 100130 (Moore) 165.00 Fees - JL Brown Ref: W Brown 31.50 |
|
| Apr Total | 1,173.75 |
| Fees - I & K Jones Ref: Theo Jones 15.75 Fees - National Savings A Ref:Rgup37097 84.00 Fees - I & K Jones Ref: Theo Jones 105.00 Fees - JR Evans Ref: James Evans 40.00 |
|
| May Total | 244.75 |
| Brighter Futures F Ref: 237021 Fees - Simon Johnson Ref: L Johnson 81.00 Fees - R Tyler ref: Brooklyn Asher 85.00 Fees - Bogato&Bogat Ref: M Bogatov 81.00 Fees - Amanda Patterson Ref: T King 81.00 Fees - Darren Northway Ref: B Northway 81.00 New Child Deposit - SJ Rixon ref: R Rixon Fees - SJ Rixon ref: R Rixon 165.00 |
----- Start of picture text -----
June Total 574.00
Fees - Comp Voucher Serv Ref: 0009949201 81.00
DH Wfru Ref: Nmru-N993972L-2020
Fees - M Hammerstone ref: E Hammerstone 150.00
Fees - JR Evans Ref: James Evans 81.00
Fees - L Mulholland ref: Casey Mulholland 150.00
New Child Deposit - Robert Dudding ref: I Dudding
Fees - Edenred Ref: Siddharth Coteti 81.00
July Total 543.00
Brighter Futures F Ref: 252816
August Total 0.00
2019-20 Annual Summary 20,131.50
School year 2020-2021
Fees - Anthony Evans Ref: Bethany Evans 240.00
New Child Deposit - S & L Ali ref: M Ali
Fees - Simon Johnson Ref: L Johnson 45.00
Fees - Y Ould-Hammouda Ref: Ould-Hammouda 150.00
Fees - GE Thomas Ref: G Thomas 72.00
Fees - AE Holmes Ref: Jude Holmes 72.00
Fees - MN Cozens Ref: A Cozens 94.00
Fees - MN Cozens Ref: A Cozens 630.00
Fees - AT Moore Ref: Joshua Moore 72.00
New Child Dep-Ceres Portilo Ref: Sam Ahmad Portilo
Fees - S Meeks Ref: Isaac Buck 49.50
Fees - Marco Rado Ref: Rosemaire Rado 72.00
Fees - S Smith Ref: R Chapman 45.00
September Total 1,541.50
----- End of picture text -----
| (contributi | photos, easy | |
|---|---|---|
| lunch | admission ons) |
fundraising) |
| 0.00 | 0.00 | 0.00 | 0.00 |
|---|---|---|---|
| 15.00 | |||
| 20.00 | |||
| 5.00 | |||
| 20.00 | |||
| 15.00 | |||
| 10.00 |
15.00 361.48 0.00 361.48 loo.00 0.00 15.00 20.00
15.00 15.00 20.00
----- Start of picture text -----
100.00
0.00 100.00 85.00 0.00
5.00
10.00
100.00
0.00 100.00 15.00 0.00
47.92
----- End of picture text -----
15.00 15.00 20.00 0.00 0.00 50.00 47.92 5.00
10.00
----- Start of picture text -----
0.00 0.00 15.00 0.00
----- End of picture text -----
10.00 100.00 10.00 20.00 10.00
0.00 100.00 50.00 0.00
| 0.00 | 0.00 | 0.00 | 0.00 |
|---|---|---|---|
| 0.00 | 0.00 | 0.00 | 0.00 |
| 100.00 |
----- Start of picture text -----
0.00 100.00 0.00 0.00
100.00
0.00 100.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 861.48 315.00 47.92
20,992.98 362.92
100.00
100.00
0.00 200.00 0.00 0.00
----- End of picture text -----
| Funding | ||||||
|---|---|---|---|---|---|---|
| First | Aid | photos | RBC | Milk Grant | ||
| 140.00 | ||||||
| 140.00 | 0.00 | 0.00 | 0.00 |
78.00
0.00 0.00 0.00 78.00 54.60 51.74 4,246.00
| 0.00 | 0.00 | 4,246.00 | 106.34 |
|---|---|---|---|
| 18,792.00 | |||
| 0.00 | 0.00 | 18,792.00 | 0.00 |
0.00 0.00 0.00 0.00 57.72
21.55 0.00 0.00 0.00 79.27 55.12 3,432.00
----- Start of picture text -----
0.00 0.00 3,432.00 55.12
22,487.00
0.00 0.00 22,487.00 0.00
0.00 0.00 0.00 0.00
----- End of picture text -----
5,891.76
----- Start of picture text -----
0.00 0.00 5,891.76 0.00
24.96
0.00 0.00 0.00 24.96
10,518.55
0.00 0.00 10,518.55 0.00
140.00 0.00 65,367.31 343.69
0.00 0.00 0.00 0.00
----- End of picture text -----
| Other Committee Fundraising Training / Preschool trip |
Total |
|---|---|
| 94.50 165.00 630.00 96.00 140.00 67.50 94.50 150.00 22.50 72.00 94.50 150.00 72.00 67.50 245.00 72.00 |
|
| 0.00 0.00 0.00 |
2,233.00 |
| 15.00 20.00 75.00 94.50 150.00 5.00 36.00 135.00 244.50 20.00 334.50 49.50 15.00 155.00 49.50 67.50 72.00 94.50 78.00 10.00 45.00 170.00 49.50 |
| 165.00 15.00 19.50 361.48 |
|
|---|---|
| 0.00 0.00 0.00 |
2,545.98 |
| 28.00 28.00 28.00 56.00 14.00 28.00 |
27.00 81.00 90.00 108.00 240.00 27.00 28.00 81.00 108.00 180.00 54.60 81.00 108.00 180.00 81.00 28.00 81.00 180.00 28.00 54.00 56.00 108.00 180.00 180.00 180.00 288.00 180.00 288.00 51.74 14.00 54.00 360.00 4,246.00 28.00 81.00 81.00 15.00 20.00 |
| 4.00 7.50 84.00 11.50 199.00 350.00 |
4.00 7.50 15.00 15.00 20.00 188.00 4.50 84.00 180.00 81.00 11.50 199.00 350.00 288.00 100.00 |
|---|---|
| 0.00 549.00 289.00 |
9,803.84 |
| 17.50 4.00 31.00 2.50 14.00 61.00 294.50 489.50 |
5.00 17.50 36.00 165.00 10.00 4.00 100.00 31.00 2.50 283.50 14.00 100.00 61.00 294.50 489.50 18,792.00 |
| 0.00 845.00 69.00 |
20,405.50 |
| 47.92 120.00 54.00 54.00 76.50 81.00 103.50 |
| 17.45 182.50 |
17.45 182.50 |
17.45 182.50 |
103.50 150.00 180.00 27.00 76.50 103.50 150.00 81.00 75.00 103.50 165.00 54.00 76.50 180.00 253.50 180.00 187.50 76.50 76.50 49.50 330.00 30.00 20.00 150.00 283.50 17.45 182.50 253.50 15.00 15.00 91.50 81.00 20.00 2.00 4.50 4.50 |
|---|---|---|---|
| 0.00 | 199.95 | 0.00 | 4,386.37 |
| 251.50 | 30.00 5.00 120.00 251.50 57.72 150.00 |
| 10.00 54.00 103.50 165.00 180.00 76.50 76.50 76.50 27.00 81.00 54.00 103.50 150.00 21.55 187.50 |
|||
|---|---|---|---|
| 0.00 | 251.50 | 0.00 | 1,980.77 |
| 49.50 75.00 103.50 253.50 330.00 55.12 22.50 54.00 180.00 180.00 76.50 120.00 283.50 76.50 81.00 103.50 150.00 180.00 3,432.00 10.00 81.00 100.00 10.00 20.00 76.50 10.00 283.50 |
| 0.00 | 0.00 | 0.00 | 6,397.12 |
| 110.00 150.00 22,487.00 27.00 27.00 113.50 20.25 27.00 31.50 20.25 20.25 22.50 83.25 6.75 45.00 31.50 38.25 45.00 60.00 98.25 165.00 31.50 |
|||
| 0.00 | 0.00 | 0.00 | 23,660.75 |
| 15.75 84.00 105.00 40.00 |
|||
| 0.00 | 0.00 | 0.00 | 244.75 |
| 5,891.76 81.00 85.00 81.00 81.00 81.00 100.00 165.00 |
----- Start of picture text -----
0.00 0.00 0.00 6,565.76
81.00
24.96
150.00
81.00
150.00
100.00
81.00
0.00 0.00 0.00 667.96
10,518.55
0.00 0.00 0.00 10,518.55
0.00 1,845.45 358.00
Vertical total
Check Total 89,410.35
240.00
100.00
45.00
150.00
72.00
72.00
94.00
630.00
72.00
100.00
49.50
72.00
45.00
0.00
0.00 0.00 0.00 1,741.50
----- End of picture text -----
LnecK (Should be 0.00)
What are these? What are these?
What are these? What are these? What are these?
What is this? What is this?
Horizontal Total 0.00
Emmer Green Pre-school Monthly Expenditure Monthly Expenditure 2019-2020
Bank reconciliation 2019/2020
| As 30.08.20 | Debit Credit |
Debit Credit |
|---|---|---|
| Opening balance 1 Sept 19 b/fwd |
39,329.63 | |
| Income 2019/20 Payments 2019/20 Closing Balance Balance per statement current account Balance per statement business saver Balance per fundraising account Total Balance |
89,410.35 108,424.12 20,315.86 |
|
| 128,739.98 128,739.98 |
||
| 20,315.86 £10,921.29 £682.54 |
||
| 31,919.69 |
Monthly Bank Reconciliation Barclays : A/C Number 80343277 2018/19
| Statement Period | Opening Balance | |
|---|---|---|
| 1 | 31/08/2019 - 27/09/2019 | 39,329.63 |
| 2 | 28/09/2019 - 30/10/2019 | 32,514.63 |
| 3 | 31/10/2019 - 29/11/2019 | 26,223.29 |
| 4 | 30/11/2019 - 30/12/2019 | 24,172.57 |
| 5 | 31/12/2019 - 30/01/2020 | 35,252.21 |
| 6 | 31/01/2020 - 28/02/2020 | 30,026.08 |
| 7 | 29/02/2020 - 30/03/2020 | 22,314.63 |
| 8 | 31/03/2020 - 29/04/2020 | 19,202.81 |
| 9 | 30/04/2020 - 29/05/2020 | 33,600.26 |
| 10 | 30/05/2020 - 29/06/2021 | 25,935.31 |
| 11 | 30/06/2020 - 30/07/2022 | 24,065.96 |
| 12 | 31/07/2020 - 28/08/2020 | 17,242.14 |
| Total | ||
| Check (this should be zero) | >>>>>>>> |
| Balance as per | Check (should | |||
|---|---|---|---|---|
| Income/Deposits | Bank Outgoings | Closing Balance | Bank St. | be zero) |
| 2,233.00 | 8,731.00 | 32,831.63 | 32,514.63 | 317.00 |
| 2,545.98 | 9,154.32 | 25,906.29 | 26,223.29 | -317.00 |
| 9,803.84 | 11,854.56 | 24,172.57 | 24,172.57 | 0.00 |
| 20,405.50 | 9,325.86 | 35,252.21 | 35,252.21 | 0.00 |
| 4,386.37 | 9,612.50 | 30,026.08 | 30,026.08 | 0.00 |
| 1,980.77 | 9,692.22 | 22,314.63 | 22,314.63 | 0.00 |
| 6,397.12 | 9,508.94 | 19,202.81 | 19,202.81 | 0.00 |
| 23,660.75 | 9,263.30 | 33,600.26 | 33,600.26 | 0.00 |
| 244.75 | 7,909.70 | 25,935.31 | 25,935.31 | 0.00 |
| 6,565.76 | 8,435.11 | 24,065.96 | 24,065.96 | 0.00 |
| 667.96 | 7,491.78 | 17,242.14 | 17,242.14 | 0.00 |
| 10,518.55 | 7,444.83 | 20,315.86 | 20,315.86 | 0.00 |
| 89,410.35 | 108,424.12 | |||
| 0.00 | 0.00 |
Savings Account 2018/2019 A/c No: 70498610
Bank Reconciliation
| Start Balance Sept 2019 Amount Out (Details below) Amount in (Details Below) Closing Balance Aug 2020 (agreed to statement) Payments Date Receipts Date 09/02/2019 12/02/2019 03/02/2020 06/08/2020 |
£10,903.65 0.00 17.64 10,921.29 |
|---|---|
| 10,921.29 10,921.29 |
|
| Description Cheque no Description Interest (3rd Jun - 1st Sept) Interest (2nd Sept - 1st Dec) Interest (2nd Dec - 1st Mar) Interest (2nd Mar - 7th Jun) |
| A | B | Amount Out | |
|---|---|---|---|
| 0.00 | |||
| 0.00 | |||
| 0.00 | |||
| 0.00 | |||
| 0.00 | |||
| 0.00 | 0.00 |
| Interest | B | Money In | ||
|---|---|---|---|---|
| 5.43 | 5.44 | Interest | ||
| 5.44 | 5.44 | |||
| 3.83 | 3.83 | |||
| 2.93 | 2.93 | |||
| 17.63 | 0.00 | 17.64 |
Fundraising Account 2018/2019
Bank Reconciliation
| Start Balance Sept 2019 Amount Out (Details below) Amount in (Details Below) Closing Balance Aug 2019 |
5.00 682.54 |
|---|---|
| 687.54 |
Payments
| Date | Description | |
|---|---|---|
| 05/21/2020 | Direct debit from Amazon | |
| Receipts | ||
| Date | Description | |
| 12/31/2019 | Interest 29/12/18 - 30/12/19 |
A/C No: 80414565
682.54
6.37
688.91
| Cheque no Ref:4445844997396563 |
A B Amount Out 5.00 0.00 0.00 0.00 0.00 |
|---|---|
| 0.00 5.00 |
| A | B | Money In | ||
|---|---|---|---|---|
| 1.37 | 1.37 | |||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | ||||
| 0.00 | 1.37 | 1.37 |
Business Accounts at a Glance 2017/2018
09/29/2017
Business Current Account Business Savings Account Fundraising Account
£21,072.11 Bank rec agree £10,869.18 No movement £679.87 No movement
10/30/2017
Business Current Account Business Savings Account Fundraising Account
£13,793.61 Bank rec agree £10,869.18 Statement see £679.87 No movement
11/29/2017
Business Current Account Business Savings Account Fundraising Account
£13,619.45 Bank rec agree No Summary o £679.87 No movement
12/17
Business Current Account Business Savings Account Fundraising Account
£26,974.73 Agreed to stmt No Summary o £681.17 Statemnt seen
01/18
Business Current Account Business Savings Account Fundraising Account
£20,639.57 Agreed to stmt £10,871.09 Agreed to stmt £681.17 Agreed to stmt
03/18
Business Current Account Business Savings Account Fundraising Account
£11,029.25 Agreed to stmt £10,876.51 Agreed to stmt £681.17 Agreed to stmt
04/18
Business Current Account Business Savings Account Fundraising Account
£41,865.80 Agreed to stmt £10,876.51 Agreed to stmt £681.17 Agreed to stmt
05/18
Business Current Account Business Savings Account Fundraising Account
£33,493.03 Agreed to stmt £10,876.51 Agreed to stmt £681.17 Agreed to stmt
06/18
Not provided
ed for September entries for September for September
ed for October entries en to 19/10/17 and balance agreed.
for October
ed for November entries - confirm no transaction on 30 Nov when rec December statem or statement provided
for November
t to 29/12/17
or statement provided
n to 04/01/18 and balance agreed
t to 30/01/18 t to 30/01/18 t to 30/01/18
t to 29/03/18 t to 29/03/18 t to 29/03/18
t to 27/04/18 t to 27/04/18 t to 27/04/18
t to 30/05/18 t to 30/05/18 t to 30/05/18
ients
| Current Totals from banking sheets | 89,410.35 | as per ban |
|---|---|---|
| -108,424.12 | ||
| -19,013.77 | ||
| Monthly | ||
| Current total on Monthly summary | -7,723.10 | |
| Diference vs banking sheets - should be nil | -11,290.67 | |
| Annual | ||
| Current total on annual summary | -7,705.47 | |
| Diference vs banking sheets - should be nil | -11,308.30 | |
| all green cells should |
k rec sheet be same number
ueries: Date er Statement
----- Start of picture text -----
Fundraising 2016-17 Voluntary Contributions - in cash / cheque
Donations and Commissions
Income Sept / Oct Nov / Dec Jan / Feb Mar / Apr May / Jun July / Aug Sept/Oct Nov/Dec Jan / Feb Mar / Apr May / Jun Jul / Aug
Easy Fundrasing website £34.66
Harvest festvial: cake sale £39.00 £44.00 £315.00 £210.00 £15.00 £260.00 £246.50 £75.00
Bingo Night 18th Nov £452.00 £145.00 £50.00 £65.00 £45.00
Christmas Fair £264.45 £20.00 £165.00 £140.00
Christmas Donation £100.00
Christmas fair stalls £50.00
Christmas Party / fair £108.00 TOTAL DONATIONS
Christmas party £29.50 £315.00 £375.00 £230.00 £325.00 £431.50 £75.00 £1,751.50
Christmas fair / party £246.00
Christmas party £62.00
Easy Fundraising £21.65
Kids Klub £35.50
Minime Commissions £48.00
Commission £78.80
Obstacle Course £672.80
Obstacle Course £489.00
Obstacle Course £5.00
Silent Auction £30.00
Easy Fundraising £29.54
May Fair £987.41
Sports Day £349.89
Gross funds raised £73.66 £1,293.95 £245.95 £1,226.34 £987.41 £349.89 £4,177.20
----- End of picture text -----
| Costs Christmas party - hobby craft £76.05 Chirstmas party groceries £25.14 Christmas fair - tesco £40.68 Christmas party books £31.00 Christmas party food £31.15 Christmas party entertainer £100.00 RBC Rent of Hall Bingo Night £35.75 May Fair foat £100.00 Sports day food £50.49 Costs £0.00 £304.02 £0.00 £35.75 £100.00 £50.49 £490.26 TOTAL NET Net Funds Raised 2016/17 £73.66 £989.93 £245.95 £1,190.59 £887.41 £299.40 £3,686.94 |
Costs Christmas party - hobby craft £76.05 Chirstmas party groceries £25.14 Christmas fair - tesco £40.68 Christmas party books £31.00 Christmas party food £31.15 Christmas party entertainer £100.00 RBC Rent of Hall Bingo Night £35.75 May Fair foat £100.00 Sports day food £50.49 Costs £0.00 £304.02 £0.00 £35.75 £100.00 £50.49 £490.26 TOTAL NET Net Funds Raised 2016/17 £73.66 £989.93 £245.95 £1,190.59 £887.41 £299.40 £3,686.94 |
Costs Christmas party - hobby craft £76.05 Chirstmas party groceries £25.14 Christmas fair - tesco £40.68 Christmas party books £31.00 Christmas party food £31.15 Christmas party entertainer £100.00 RBC Rent of Hall Bingo Night £35.75 May Fair foat £100.00 Sports day food £50.49 Costs £0.00 £304.02 £0.00 £35.75 £100.00 £50.49 £490.26 TOTAL NET Net Funds Raised 2016/17 £73.66 £989.93 £245.95 £1,190.59 £887.41 £299.40 £3,686.94 |
|---|---|---|
£73.66 £989.93 £245.95 £1,190.59 £887.41 £299.40 |
£3,686.94 |
GRAND TOTAL £5,438.44