2022-08-31-accounts - Lympstone Preschool

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

Managers’ Report – September 2022

Great start to the year on roll we had 22 preschool children and 40 school children for BC/ASC

September Filled a vacancy for a Send/intervention practitioner - Karen Kinch was appointed
Sad news that Claire Foster our business manager given notice. Due to starting a new adventure on her farm!
Filled a vacancy for an office/administrator to fill the gap of Claire leaving. We became two mangers
Started our preschool year with a new curriculum after lots of research and not having to follow the EYFS curriculum which felt was taking staff away from the vital role of been with the children and also the children having a tick list of what they can do. We spent the summer term looking at opal and understanding what it was about and in September started on the new curriculum. It allowed more time for the staff to really get to know their children and cut down on inputting data onto the tapestry.
We also moved from tapestry as it didn’t cover opal curriculum so moved to a new online system called Learning journals. We also found this a great tool as it was going to have a HR and finance system in place.
Our newly appointed sen/intervention practitioner left and Tor Mackenzie took over the role and settled in well.
Oct found us feeling sad again as Vicki our compliance manager was now ready to move to new adventures after dedicating 11years of love sweat and tears. End of an era came at the end in Jan.
November, we recruited another office administrator to support Claire as office life was becoming very busy. lovely Katherine joined our team
Kate was appointed manager working alongside Me Caroline. We both got stuck in together
We preschool began starting to fill up with children which was great opal was running well. Feedback from staff was positive.
Life as two mangers become very busy, we found ourselves needing to recruit in one go. Tor, Jess and Sonia all were ready to move on to different pathways in their career. Amie also went on maternity leave in April. We did a recruitment drive and two wonderful practitioners joined our team Laura -supervisor and Kasia level 2.
Life at preschool for the children was lovely and all staff seem to settle in to their roles.
We had a good year of fund raising and ensuring that we stuck to our business plan to enable us to get out the deficit and into the red
We linked up really well with school throughout the year also ensuring our school transitions went smoothly for the children.
We had amazing support from parents throughout the year doing various challenges to raise money. And our local pub continued to support us in doing some fund raising. 5k inflatable, Poole to Exmouth run craft session in the pub, Easter walks, cake sale, raffle, glitter hair and tattoos.
It was a get year all in all. Very busy year for the mangers.

	A	B	E
1	HNC ACCOUNTING SOLUTIONS LIMITED
2
3	GENERAL LEDGER INDEX
4
5	Page	Account name
6
7	1	Accountancy	1
8	2	Bank charges	2
9	3	BOUGHT LEDGER CONTROL A/C	3
10	4	Car expenses -mileage	4
11	5	Corporation tax	5
12	6	Computer expenses	6
13	7	Discounts	7
14	8	Disposals of FA's	8
15	9	Electricity	9
16	10	Entertainingclients	10
17	11	Hotels & accomodation	11
18	12	Insurance	12
19	13	Interestpaid	13
20	14	Interest received	14
21	15	Legal &professional charges	15
22	16	Marketingexpenses	16
23	17	NI and PAYE CONTROL A/C	17
24	18	Ofce expenses	18
25	19	Pettycash	19
26	20	Postages	20
27	21	Printing& Stationery	21
28	22	Rates-Council tax & water rate	22
29	23	Rent	23
30	24	Repairs & renewals	24
31	25	Sales	25
32	26	SALES LEDGER CONTROL A/C	26
33	27	Salaries	27
34	28	Sundryexpenses	28
35	29	Telephone	29
36	30	Travel-Air	30
37	31	Travel-Rail	31
38	32	Travel-Taxis	32
39	33	VAT (Value Added Tax)	33
40	34	Employer's NI	34
41	35	Depreciation	35
42	36	Accruals	36
43	37	Prepayments	37
44	38	Sundrydebtors	38
45	39		39
46	40		40
47
48	PRIVATE LEDGER
49	100	Portman BuildingSoc
50	101	Business Premium a/c
51	102	Cash book-Current a/c
52	103	Current a/c -HNC
53	104	Director's fees
54	105	Fixed Assets-Cost
55	106	Fixed Assets-Depreciation
56	107	Reserves b/fwd
57	108	Share Capital

document7113129172415187496.xls\ GL Index

05/24/2023 13:55:51

LYMPSTONE PRE-SCHOOL Year ended 31 August 2022

----- Start of picture text -----
General ledger: Accountancy expenses
Date Details Ref DR Date Details Ref CR
14-Mar-98 SUNDRY b5 -345.56
-345.56 0.00
----- End of picture text -----

Cum TTL -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56 -345.56

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	LYMPSTONE PRE-SCHOOL							14 funded wk			13 funded wk				11 funded wk	Total =38 funde		d wks
2	Year ended 31 August 2022				only 38 wks funded now
3	8 months to 30 April 2022				Autumn term: 6/9 to 17/12. H-T:25/10-29/10				Spring term: 4/1 to 8/4. H-T:21-25/2			Summer term: 25/4to 19/7. H-T:30/5-3/6				5 wks holpay
4				31-Aug-21	30-Sep-21	31-Oct-21	30-Nov-21	31-Dec-21	31-Jan-22	28-Feb-22	31-Mar-22	30-Apr-22	31-May-22	30-Jun-22	31-Jul-22	31-Aug-22	Adjs	Year-2021-22
5		Account name			4 wks	3 wks	4 wks	3 wks	4 wks	3 wks	5 wks	1wk=Spr, 1=Smr	4 wks	4 wks	2 wks
6					1	2	3	4	5	6	7	8	9	10	11	12	15	14
7	BALANCE SHEET			B/fwd
8		Accruals		-705.00	-8,296.58	-4,383.26	-10,134.84	-6,269.53	-9,852.11	-8,116.59	-12,890.26	-11,643.05	-12,544.63	-15,077.21	-15,656.00	-2,272.00		-2,272.00
9		Otherprovisions		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
10		NI and PAYE CONTROL A/C		-768.16	-352.51	-509.83	-423.27	-504.84	-376.00	-2,100.98	-3,068.98	-1,317.39	-2,086.19	-1,964.56	-1,150.87	-1,879.01		-1,879.01
11		PettyCash		54.36	54.36	54.36	54.36	54.36	54.36	54.36	54.36	54.36	54.36	54.36	54.36	54.36	***	54.36
12		Prepayments -Insurance/cleaning		1008.67	856.67	1,420.51	1,268.51	1,116.51	964.52	812.52	1,336.95	2,152.54	2,435.64	2,276.74	2,117.83	1,482.51		1,482.51
13		Debtors-Session fees/ funding/milk		2897.98	5,216.90	-2,760.85	794.15	1,655.00	0.00	0.00	1,761.00	-11,000.00	-9,500.00	-7,449.00	-1,449.00	-4,764.00		-4,764.00
14		Prepaid income -DCC session fees & lunch club		8982.58	-5,993.98	-9,109.73	-3,478.38	1,685.60	-8,672.05	-1,548.98	-1,351.20	-25,919.67	-12,195.00	1,529.67	0.00	5,049.00		5,049.00
15		Holidayclub fund a/c		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
16		Alliance & Leicester DepA/C		*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
17		Scottish Widows Savings a/cs [x2]		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
18		Virgin MoneyDeposit A/c -wef Mar13		26353.91	26,353.91	26,353.91	26,353.91	19,853.91	19,853.91	19,853.91	19,853.91	19,853.91	19,853.91	19,853.91	19,853.91	19,853.91		19,853.91
19		Cash book-Current a/c		5489.87	15,920.56	16,199.24	6,599.99	2,457.61	19,282.25	22,855.25	26,792.46	57,552.69	53,502.15	45,387.70	44,846.07	35,756.59	***	35,756.59
20		Fixed Assets-Cost		19663.65	19,663.65	19,663.65	19,992.65	19,992.65	19,992.65	19,992.65	20,874.71	21,164.27	21,164.27	21,164.27	21,668.08	21,339.08		21,339.08
21		Fixed Assets-Depreciation		-17806.57	-17,923.82	-18,041.07	-18,158.32	-18,275.57	-18,392.82	-18,510.07	-18,647.38	-18,792.73	-18,938.08	-19,083.43	-19,228.78	-19,303.69		-19,303.69
22		Reserves b/fwd		-34169.12	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29	-45,171.29		-45,171.29
23		(Proft)/Loss -Currentyear		-11002.17	9,672.12	16,284.36	22,302.53	23,405.58	22,316.57	11,879.22	10,455.72	13,066.36	3,424.86	-1,521.15	-5,884.32	-10,145.47	***	-10,145.47
24				-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	-0.00
25
26	PROFIT & LOSS ACCOUNT			*2021*
27	Income			*Prioryear*										release 5k				Year-2021-22
28		Session fees -parents		44001	2736	2120	5344	4737	2940	8055	4843	2858	5769	6587	7933	1601		55,524
29		After-school 7 b'fast clubs-parents		21231	2845	2078	4608	1431	5494	3464	4201	2983	4622	1836	1140	75		34,777
30		Session fees -DCC (3 & 4yrs)	'd in Prioryr	131531	7454	8489	7454	6540	9346	7080	11682	5730	15206	13573	4490	5049		102,092
31		Toddlergroup		120	0	59	0	38	0	0	4	15	12	14	0	0		142
32		Holidayclub	accrued>>	12106	30	3	589	370	87	469	0	1327	349	329	4037	2255		9,846
33		BT Playlines Grant for lunch club	d income >>	0	0	0	0	0	0	0	0	0	0	0	0	0		0
34		DCC Grants for Equipmt/EYE changes	d income >>	0	0	0	0	0	0	0	0	0	0	0	0	0		0
35		DCC Re-imb 1-2-1/Spec needs/ courses	accrued>>	2899	152	-2785	152	114	152	114	189	76	152	152	1254	0	ok	-281
36		Donations		6043	47	46	0	250	2008	5587	5	49	77	77	1387	0		9,533
37		Fund-raising		7608	261	194	311	395	40	128	388	728	835	712	1092	83		5,167
38		Interest received		500	0	0	0	0	0	0	0	0	0	0	0	50	estd	50
39		Sundry/ Furloughgrant		1347	0	0	1	0	80	0	416	0	0	0	0	36		533
40				227387	13524	10204	18457	13875	20147	24898	21729	13767	27021	23279	21332	9149		217,383
41	Expenditure				of which £1.8k=20-21
42		Wages & NI (excl Holidayclub)		191185	20,667	13,930	21,016	13,151	17,512	13,592	18,383	15,149	16,031	16,434	15,587	1,089		182,542
43		Apprentice fees -exeter College	prepaid>>	0	0	0	0	0	0	0	0	0	0	0	0	0		0
44		Staf recruitment & trg+clothing+leaving present		1421	30	433	331	0	25	53	117	64	0	137	76	9		1,275
45		Premises costs: rent/maint chg/elec/	accrued>>	6084	278	412	308	301	475	317	299	447	491	276	384	2,336		6,325
46		Food/ snacks		3150	390	248	452	193	309	82	145	155	228	210	138	17		2,568
47		Toddlergroup exps		0	0	0	0	0	0	0	0	0	0	0	0	0		0
48		Insurance	prepaid>>	956	80	80	80	80	80	80	80	81	81	81	81	81		964
49		PLA mship&Course fees;Ofsted inspection/fees		260	0	504	220	0	0	0	0	0	0	0	0	0		724
50		Equipment & books [incl IT equipt]		2147	1,077	547	184	104	49	80	344	133	27	72	39	126		2,783
51		Stationery/photocopying/ofce supplies		1831	123	214	260	57	23	38	315	142	1	145	273	354		1,946
52		Repairs & maintenance		3245	417	157	1,025	317	272	101	400	39	86	470	234	156		3,673
53		Misc -fund-raising		1349	0	12	0	442	0	0	0	0	94	0	0	0		549
54		Misc -other [incl staf Xmas +y-end dinners]		2699	18	161	482	216	196	0	86	22	195	362	12	644		2,393
55		Depreciation charge		2058	117	117	117	117	117	117	137	145	145	145	145	75	laptop	1,497
56		P Cash -wages cleaning		0	0	0	0	0	0	0	0	0	0	0	0	0	refund	0
57		P Cash -wages other		0	0	0	0	0	0	0	0	0	0	0	0	0		0
58		P Cash -food		0	0	0	0	0	0	0	0	0	0	0	0	0		0
59		P Cash -stationery/ ofce supplies/postage		0	0	0	0	0	0	0	0	0	0	0	0	0		0
60		P Cash -Equipment & Maintenance		0	0	0	0	0	0	0	0	0	0	0	0	0		0
61		P Cash -Fund-raising		0	0	0	0	0	0	0	0	0	0	0	0	0		0
62		P Cash -Other		0	0	0	0	0	0	0	0	0	0	0	0	0		0
63				216,385	23,196	16,817	24,475	14,978	19,058	14,460	20,306	16,378	17,379	18,333	16,969	4,888		207,238
64
65	Proft/ (Loss) for the Month			*11,002*	-9,672	-6,612	-6,018	-1,103	1,089	10,437	1,423	-2,611	9,641	4,946	4,363	4,261	0	10,145
66																		0

document7113129172415187496.xls/ TRIAL BALANCE 2021-22 KATE

05/24/2023 13:55:51

----- Start of picture text -----
A B C D E F G H I L M N O P Q R S T U V W X Y Z AA AB
1 LYMPSTONE PRE-SCHOOL CURRENT YEAR PRIOR YEARS
2 Year ended 31 August 2022 31.8.22 updated- 27.9.21
3 5 -YR SUMMARY & FORECAST ACTUAL F'cast to- % Forecast BUDGET
4 2022 date v F'cast 2022 2022 2022 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007
5 (38/38wks to-date) [ 38wks] [ 38wks] 16.5.22
6
7 BALANCE SHEET
8 Accruals -2,272 -700 -2,272 -705 -9,370 -212 43 0 0 0 0 0 -90 -368 0 -0 0 -33
9 Other provisions 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 NI and PAYE CONTROL A/C -1,879 -800 -1,879 -768 -191 -533 10 0 0 0 0 -489 -502 -589 -382 -250 0 0
11 Petty Cash 54 54 54 54 54 7 100 80 53 51 5 2 19 29 26 2 -3 59
12 Prepayments -Insurance 1,483 1,000 1,483 1,009 1,035 2,414 732 361 353 344 338 318 303 296 299 288 255 244
13 SALES LEDGER CONTROL A/C -4,764 1,300 -4,764 2,898 2,963 351 1,201 1,310 194 195 1,150 351 0 153 147 506 880 1,176
14 Prepaid income -DCC session fees 5,049 8,000 SEN+DCC 5,049 8,983 -0 1,464 2,092 -578 0 0 -342 -0 2,053 -5,264 -5,525 -2,000 0 0
15 Holiday club fund a/c 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 Alliance & Leicester Dep A/C 0 0 0 0 0 0 0 1,131 987 2 2 0 4,245 4,239 24,722 15,706 9,092 7,615
17 Scottish Widows Savings a/cs [x2] 0 0 0 0 0 0 0 0 0 0 0 0 27,806 27,500 0 0 0 0
18 Virgin Money Deposit A/c -wef Mar13 19,854 27,643 =bal figure 19,854 26,354 35,854 35,854 25,810 15,731 15,738 15,438 19,743 31,425 0 0 0 0 0 0
19 Cash book-Current a/c 35,757 9,000 35,757 5,490 407 12,374 24,625 9,507 5,706 171 4,539 3,119 8,760 3,217 1,792 1,177 1,228 1,398
20 Fixed Assets-Cost 21,339 19,664 21,339 19,664 19,165 18,395 14,927 25,901 25,901 25,901 20,154 14,202 12,115 11,571 10,000 9,500 8,095 8,095
21 Fixed Assets-Depreciation -19,304 -19,801 -19,304 -17,807 -15,748 -13,576 -12,205 -23,193 -19,973 -16,586 -12,884 -11,069 -9,974 -9,080 -8,216 -6,270 -4,500 -2,880
22 Reserves b/fwd -45,171 -45,171 -45,171 -34,169 -56,538 -57,335 -30,250 -28,959 -25,517 -32,707 -37,859 -44,733 -31,703 -22,862 -18,658 -15,047 -15,674 -15,578
23 (Profit)/Loss -Current year -10,145 -2,145 -10,145 -11,002 22,368 798 -27,085 -1,290 -3,443 7,190 5,152 6,875 -13,030 -8,842 -4,203 -3,612 627 -96
24 -0.00 0 -1,956 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0
25
26 PROFIT & LOSS ACCOUNT Wk no: =est'd
27 Income 38 38 38 38
28 No. of pupils per term (est'd) 27/42/44 29/37/37 29/37/37 51/51/? 27/42/44 27/42/44 27/42/44 27/42/44 27/42/44 27/42/44 27/42/44 21/31/34 26/36/36 24/26/31 34/34/24 27/28/34 27/28/34 35/25/31
29 No. of pupils DCC funded (est'd) 19/31/37 ?/?/54 ?/?/54 32/40/47 19/31/37 19/31/37 19/31/37 19/31/37 19/31/37 19/31/37 19/31/37
30 Weeks per term (total=38) 14/11/13 14/13/11 14/13/11 14/13/11 14/13/11 14/13/11 14/11/13 14/11/13 14/11/13 14/11/13 14/11/13 14/11/13 14/11/13 14/11/13 14/11/13 14/12/12 14/12/12 14/12/12 14/12/13
31 Weeks/term funded by DCC (total=33) 14/13/11 14/13/11 14/13/11
38 Special needs children/term 2/2/2 1/1/1
39 Breakfast & After school clubs 34777 36584 -4.9% 36584 30000 ASC 34777 21231 22926 25055 15739 0 0 0 0 0 0 0 0 0 0 0
40 Holiday club 9766 13388 -27.1% 13388 14000 Hol club-10wks 9766 12002 6265 3444 1145 2500 3800 3800 3800 3500 3800 2730 1900 3440 3833 4976
41 Session fees -3 &4yr, addit 6 wk(39 -33 funded 55524 54551 1.8% 54551 30000 55524 44001 38431 33753 32500 11900 15117 12167 10181 8559 9821 5427 5191 2859 3735 3831
42 Session fees -DCC (3 & 4 yrs) 102092 96452 5.8% 96452 123,000 increased h-cou 102092 131531 92254 138419 119926 57700 58938 53016 55932 36373 50414 51731 44485 37701 33734 31450
43 202159 200975 0.6% 200975 197000 202159 208765 159877 200671 169311 72100 77855 68982 69914 48432 64035 59888 51577 44001 41302 40257
44 Prepaid early by DCC (#1533 taken in 2002 a/ 0 0 0 0 0 0 0 0 0 0 0 0 0 0
45 Total session fees 202159 200975 0.6% 200975 197000 202159 208765 159877 200671 169311 72100 77855 68982 69914 48432 64035 59888 51577 44001 41302 40257
4647 Toddler group 142 300 -52.6% 300 1250 jumped up 142 120 196 319 555 1,146 546 660 591 1,080 1,545 0 0 0 cookesh:03jan Holiday club 0 cookesh Holiday 0
48 VOLUNTARY Snacks Fund 80 0 #DIV/0! 0 0 80 104 54 54 1145 0 0 0 0 0 230 792 804 733 468 393
4950 BT PlaDCC Grants for Eylines Grant for lunch club quipmt/EYE changes 00 00 #DIV/0!#DIV/0! 0 0 00 other H Cookes:16/5/03 #1500 for eqpt grant grants 00 00 25135 8582 73700 00 650 20000 00 00 00 2000 3900 9920 1000 1210
51 DCC Re-imburse 1-2-1/Spec needs/ courses -281 -1459 -80.8% -1459 1440 Lum (yr1) and #270 released p sum -281 2899 -1464 2548 4472 817 5291 1092 655 462 2385 7280 5042 2131 1726 590
5253 Donations (incl Parish Council)Fund-raising f/c?f/c? 95335167 90004000 29.2%5.9% 90004000 20003000 Lotter fr 1/1/03 Lunch club introduction #540 Grant. y tickets 95335167 60437608 13331013 18032974 689170 36836036 40244449 2533450 41060 243228 10201318 150725 900654 325428 315709 1210297
5455 Interest receivedSundry/Furlough grant 53350 100035 -46.7%42.9% 1000 35 35 0 @food donations/0.5% H Cookes:16/5/03 #1500 for eqp 53350 t grant H Cookes:16/5/03 #1500 for e 1347500 qpt grant 23 0 32 44 1,416 66 1470 3010 Cookes:06nov12 Only £6k grant for DF for 342 695 1,280 320 5,618 624 7316312 926217 1010016 1725208 262161 135487
56 217383 213851 1.7% 213851 204725 (yr1) and #270 released 217383 (yr1) and #270 released 227387 163549 208612 191295 83929 92530 12mths to 31mar1376754 76866 58676 78160 78972 69482 50542 45042 43490
57 Expenditure fr 1/1/03 Lunch club introduction #540 fr 1/1/03 Lunch club introduction #540
58 No of staff on payroll 13.0 14.0 -7.1% 14.0 15.0 FTEs/35hr wk Grant. 13.0 Grant. 15.0 17.0 17.0 10.0 9.0 10.0 9.0 8.0 7.8 7.0 10.0 9.0 8.0 8.0
59 No of hrs in week -TOTAL 375.0 451.0 359.0 209.0 209.0 221.0 201.7 141.0 #REF! 170.63 133.90 #REF! #REF! #REF!
60 Hall rental cost per wk/rate per session £980/half-term £900/half- £900/half- £875/half- £850/half- £796/half- TBC £98/£14 £63/£10.50
61 No rental sessions per week 5=am;2=pm 5=am;2=pm 6
62 186k 6 wef 1/9/
63 Wages & NI (excl Hol. Club) 182,542 187758 -2.8% 187758 181,560 £4.5k increase 182,542 191,185 161,580 179,506 127,796 67,419 72,796 67,056 64,913 51,552 50,150 56,539 50,463 35,692 35,679 31,473
64 Wages -casual/cleaning 0 0 #DIV/0! 0 0 0 0 0 0 127 52 260 520 92 0 196 0 399 360 381 418
65 Staff recruitment,trng & clothing;TM 1,275 1500 -15.0% 1500 1,000 1,275 1,421 850 2,473 1,944 227 813 653 1,606 932 362 1,241 1,456 745 115 846
66 Premises costs: rent/maint ch accrued> g 6,325 4244 49.0% 4244 4,244 Monthly chgs 6,325 6,084 4,927 4,342 6,009 6,508 6,352 5,673 5,884 5,201 5,124 4,853 3,964 3,493 3,213 2,200
676869707172 Food/ snacks Toddler InsurancePLA mshiEStationerquipment & booksp &Course fees;Ofsted ins g y/ rou p'co p py ex in p g s /off suppp p ection&felies/ repaid> IT e 2,568 2,783 1,946 964 724 0 250010001000330015000 #DIV/0!-27.6%-15.7%29.7%-3.6%2.7% 250010003300 100015000 3,000 Hol club=nil no1,000 2,000 down 2,000 incl Ta300 EYA -Annual fee0 pestry & P H Cookes:16/5/03 Assumes that the new H Cookes: 16/5/03 new rates wd begin w Sept03 & carry on for be paid Min Wage all the 2004 FY.(4.50) and do 15hrs /wk, which will include ef May03, 2,568 2,783 1,946 964 724 clea 0 ner will H Cookes: 16/5/03 wbe paid Min Wage (4.50) and do 15hrs /wk, which will include c3hrs for e H Cookes:16/5/03 Assumes that the new rates wef May03 wd carry on for all the 2004 FY. -f M 3,150 2,147 1,831 ay03, 956 260 0 cleaner will 2,548 3,359 2,132 950 263 0 3,830 1,126 4,356 1,462 258 0 3,323 1,453 682 352 0 0 611 716 354 80 0 0 596 970 651 30 90 0 1,122 584 895 20 50 0 1,426 1,124 168 560 0 0 1,383 444 699 179 612 34 1,192 206 431 510 402 69 2,303 758 509 448 65 0 1,483 1,580 610 501 30 0 614 461 745 840 72 0 516 426 534 560 251 0 cookesh:03ja Holiday club 3,059 cookes Ho 423 379 411 593 iday 0
73 Repairs & maintenance 3,673 3300 11.3% 3300 3,000 incl PPE c3hrs for cleanin 3,673 g. cleanin 3,245 g. 3,553 4,742 11,193 110 401 289 507 579 1,146 550 388 419 363 122
7475 Misc -fund-raisinMisc -other [incl staff dinners; g payrol 2,393 549 3237800 -31.4%-26.1% 3237 800 1,200 25% 3,237 prize mone 2,393 549 1,349 2,699 3,061 469 2,620 3,276 2,121 3,561 1,232 888 239 897 Cookes:06nov12 Incl £2k donation to Village 947 728 1,167 966 334 970 2,664 234 388 156 H Cookes 18sep09 Bank chgs £61,045 41 653 0 431 590 977 29
7677 DeP Cash -wapreciation on new buildinges other g 1,497 0 15670 #DIV/0!-4.5% 1567 0 1,995 0 estd FA's =£400 additions H Cookes:16/5/03 #1500 DCC eqpt Grant 1,497 0 H Cookes:16/5/03 #1500 DCC eqpt Grant 2,058 0 2,172 0 1,372 0 3,030 0 3,220 0 3,387 0 Hall refurbishment in Jul12.3,703 8 1,815 127 1,095 30 894 0 864 0 1,946 0 1,770 10 1,620 0 1,548 0
78 P Cash -food 0 0 #DIV/0! 0 0 LESS #527 estd 0 LESS #527 estd 0 12 21 2,015 373 753 995 972 941 1,056 1,098 934 861 788 602
79 P Cash -stationery/ office supplies 0 0 #DIV/0! 0 0 cleaning costs (39wk x3hrs @4.50). 0 cleaning costs (39wk x3hrs @4.50). 0 22 0 88 94 154 61 83 88 75 89 88 40 73 125
80 P Cash -Equipment & Maintenance 0 0 #DIV/0! 0 0 0 0 15 25 409 650 568 596 546 350 339 165 313 162 129 105
81 P Cash -Other 0 0 #DIV/0! 0 0 0 0 3 0 105 105 132 46 63 128 82 105 37 -6 -0 87
82 207,238 211,706 -2.1% 211,706 204,536 207,238 216,385 185,917 209,410 164,210 82,639 89,087 83,944 82,018 65,551 65,130 70,131 65,279 46,930 45,669 43,394
83
84 Profit/ (Loss) for the Period 10,145 2,145 2,145 189 10,145 11,002 -22,368 -798 27,085 1,290 3,443 -7,190 -5,152 -6,875 13,030 8,842 4,203 3,612 -627 96
85
86
----- End of picture text -----

document7113129172415187496.xls/ P&L 5 yr SUMMARY-KATE

05/24/2023 13:55:51

LYMPSTONE PRE-SCHOOL PLAYGROUP

PROFIT AND LOSS ACCOUNT FOR THE YEAR ENDED 31 AUGUST 2022

Turnover & interest received EDDC grant Lunch and extra session fees After school club (ASC) & Holiday Club Toddler group DCC other grants -for New Build F&F DCC grants for Special needs & Courses Donations Fund-raising (mainly lottery) less costs Interest received (Virgin Money deposit account) Sundry income Administrative expenses Salaries & employer's NIC Other staf costs (cleaning, training & related expenses) Village hall rental,rates & utilities Food & snacks Play equipment and books Insurance, PLA membership Ofce supplies (photocopying, inkjet cartridges) New build costs; repairs and maintenance of buildings Miscellaneous (staf dinners, payroll services) Depreciation on fxed assets (buildings @20% per annum, computers @33% per annum) Proft for the year	2022 £ 102,092 65,289 34,857 142 0 (281) 9,533 4,618 50 533 216,835 182,542 1,275 6,325 2,568 2,783 1,688 1,946 3,673 2,393 1,497 206,689 10,145	2021 £ 131,531 56,003 21,335 120 0 2,899 6,043 6,260 500 1,347
		226,038 191,185 1,421 6,084 3,150 2,147 1,216 1,831 3,245 2,699 2,058
		215,036
		11,002

LYMPSTOME PRE-SCHOOL PLAYGROUP

BALANCE SHEET AS AT 31 AUGUST 2022

Fixed assets Cost (outdoor play area & equipment & grass £8,769; website £708; shed £669; Dell laptops £1,045; 4 Ipads £1,050; Plusnet & 3 Ipads £757; pergola £360; F&Furniture £2,931; fencing £2,618; phones £300; slide £242; tables £1434) Current assets Debtors Prepaymemts (insurance & rates; subscription) Cash at bank and in hand Creditors: Amounts falling due within one year NI and PAYE Accruals and other provisions Net current assets Net assets Reserves Brought forward at 1 September Proft for the year Carried forward at 31 August	2022 £ £ 21,339 (19,304) 2,035 285 1,483 55,665 57,432 (1,879) (2,272) (4,151) 53,281 55,317 45,171 10,145 55,317	2021 £ £ 19,664 (17,807) 1,857 11,881 1,009 31,898 44,787 (768) (705) (1,473) 43,314 45,171 34,169 11,002 45,171	2021 £ £ 19,664 (17,807) 1,857 11,881 1,009 31,898 44,787 (768) (705) (1,473) 43,314 45,171 34,169 11,002 45,171
			45,171
			34,169 11,002

			45,171

	A	B	C	D	E	F	G	H	I	J	K	L	O	P	Q	R
1	LYMPSTONE PRE-SCHOOL
2	Year ended 31 August 2014
3	TODDLERS CLUB					Y-T-Date	*Forecast*
4							2013-14
5						Year
6
7
8
9		No. of toddlersperyear					*19/18/19*	sayaverage 18.6
10		Weeksper term (total=38)				*14/11.5/12.*		5	38		ok
11		Session feeper child -parents					*2.50*	>2yr olds
12		Session feeper child -parents					*1.50*	>1yr olds
13		Session feeper child -parents					*1.00*	<1yr olds
14		Session feeper additional child -parents					*1.00*	<1yr olds
15												To break-even:	>2yr old	>1yr old	<1yr old	Total
16				%	Aver no's -Winter term		Child >2yr	>1 and <2	<1yr old	additional	1	At 3hrs each, at £2.50/£1.50	24	24	3	51
17		Children	18	80%		11.5	11.5				2	At 2.5hrs each, at £2.50/£1.50	21	21	2	44
18						2.6		2.6			3	At 3hrs each, at£3/£1.50	21	21	2	44
19						1.5			1.5
20			18	20%		3.0				3.0
21							11.5	2.6	1.5	3.0
22						Session fee	2.50	1.50	1.00	1.00
23						Income	28.75	3.9	1.5	3
24		Income
25		Children > 2year					1,093	38 wks
26		Children > 1year and <2year					148	38 wks
27		Children > 1year					57	38 wks
28		Children -additional					114	38 wks
29						Income	1,412
30
31		Expenses	split/1 wk	Hourlyrate	Er's NI@13.8%	Hrs/session=2+1hr set/tidyup
32		Staf costs	1.00	8.00	0	2	608	38 wks	Deputy
33			1.00	6.92	0.00	2	526	38 wks	Sonia
34							1,134
35
36		Room hire -village hall					456	38 wks@	12.00	GBP
37		Liabilityinsurance					0	covered byPre-school insurance
38		Other equipment costs					50	*est'd*
39							506
40
41						Total costs	1,640
42
43					Net income/(loss) -estimated		-228
44
45
46
47
48
49
50
51
52
53
54
55					Toys

document7113129172415187496.xls\ TODDLERS CLUB-BUDGET-2013-14

05/24/2023 13:55:52

	A	B	C	D	E	F	G	H	I	J	K	L	O	P	Q	R
1	LYMPSTONE PRE-SCHOOL
2	Year ended 31 August 2013
3	TODDLERS CLUB					Y-T-Date	*Forecast*
4							2012-13
5						Year
6
7
8
9		No. of toddlersperyear					*16/15/16*	sayaverage 12
10		Weeksper term (total=38)					*14/11/13*		38		ok
11		Session feeper child -parents					*2.50*	>2yr olds
12		Session feeper child -parents					*1.50*	>1yr olds
13		Session feeper child -parents					*1.00*	<1yr olds
14		Session feeper additional child -parents					*0.50*	<1yr olds
15												To break-even:	>2yr old	>1yr old	<1yr old	Total
16				%	Aver no's -Winter term		Child >2yr	>1 and <2	<1yr old	additional	1	At 3hrs each, at £2.50/£1.50	24	24	3	51
17		Children	12	80%		9.0	9.0				2	At 2.5hrs each, at £2.50/£1.50	21	21	2	44
18						2.6		2.6			3	At 3hrs each, at£3/£1.50	21	21	2	44
19						1.5			1.5
20			12	20%		2.8				2.8
21							9.0	2.6	1.5	2.8
22						Session fee	2.50	1.50	1.00	0.50
23						Income	22.5	3.9	1.5	1.4
24		Income
25		Children > 2year					855	38 wks
26		Children > 1year and <2year					148	38 wks
27		Children > 1year					57	38 wks
28		Children -additional					53	38 wks
29						Income	1,113
30
31		Expenses	split/1 wk	Hourlyrate	Er's NI @13.8%	Hrs/session=2+1hr set/tidyup
32		Staf costs	1.00	8.00	0	2	608	38 wks	Sue
33			1.00	6.85	0.00	2	521	38 wks	Sonia
34							1,129
35
36		Room hire -village hall					528	38 wks
37		Liabilityinsurance					0	covered byPre-school insurance
38		Other equipment costs					50	*est'd*
39							578
40
41						Total costs	1,707
42
43					Net income/(loss) -estimated		-593

document7113129172415187496.xls\ TODDLERS CLUB-BUDGET-2012-13

05/24/2023 13:55:52

LYMPSTONE PRE-SCHOOL	LYMPSTONE PRE-SCHOOL
Year ended 31 August 2022
Holiday Club Summary			Y-T-Date		*Forecast*
			2005		2005		2004		2003		2002	2001
			Year


PROFIT & LOSS ACCOUNT
Income
	No. ofpupilsperyear				*25/24/23*
	Weeksper term (total=39)				*14/13/12*


	Devon Comm Fund				100		0		350		0	99
	DCC Grant				250		0		0		0	141
	Lympstone Parish Council				250		250		250		250	150
	EDDC Sports Grant				0		0		0		0	250
	HolidayClub Deposits				700		632		779 ~~How~~		664	395
										~~How~~	~~rd Cooke~~	~~:~~
	Other -Norman Family Trust (taken as Non-Hol Club inc in A/cs)				0	*	400			0 Heavi	250 tree brewer	0 y
			0		1300		1282			1379	1164	1035
	Prepaid early by DCC (#1533 taken in 2002 a/cs)				0	*				0	0
	Total session fees		0		1300		1282			1379	1164	1035

	Sundry		0		0		0		0		0	0
			0		1300		1282		1379		1164	1035
Expenditure
	No of staf onpayroll		4		3.00		4		4
	Hall rental costper week				Gbp45/wk

	Wages & NI (incly-endprovision of #100)				700		618		655		450	387
	Wages -casual				0		0		0		0	0
	Village Hall rental	accrued>>			*160*		158		153		0	126
	Milk				0		0		0		0	0
	Bouncycastle				0		25		25		0	20
	Entertainment & disco				100		25		75		113	0
	Misc -other				50		127		138		0	83
	P Cash -exps				200		127		120		91	134
	P Cash -Other				0		46		0
	Prioryear costs				0				133		0	0
			0		1,210		1,126		1,299		654	750

Proft/ (Loss) for the Year			0.00		90		156		80		510	285

	Prioryear costs -paid in 2004

Netproft/(loss) foryear			0.00
USED AS FOLLOWS:
	Taken toproft		0.00				0.00		0.00


	Carried fwd to nextyear (max #100 eachyear)			~~H~~ re	~~Cookes:3/~~ lated to Au	~~1/~~ g0	80.4 ~~2~~ 2 Holiday	2	80.42
			0.0	0 cl	ub		156.01		80.42

document7113129172415187496.xls/ Holiday Club Summary

05/24/2023 13:55:52

	A	B	D	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	LYMPSTONE PRE-SCHOOL
2	Year ended 31 August 2022
3	CALCULATION OF SEN EXTRA COSTS vs DCC INCOME 2015-16
4
5
6
7		SEN Salary costs
8
9																		#REF!
10			Start date	New rates	Basic hrs	Plan/ course/ Tea towels	Total hrs	Grosspay	Emp'ers NI	Total cost		%	New rates	Basic hrs	Plan/ course/ extra Wed PM	Total hrs	Grosspay	Emp'ers NI	Total cost
11				wef 1/4/15	1-Sep-15	2015-16	2015-16		>#156/wk	per week		incr	wef 1/4/16	[cont'd]	2015-16	2015-16		>#136/wk	per week
12	A	Jan Lane		7.40	14.0	0.0	14.00	103.60	0.00	103.60		*0.0%*	7.40	14.0	0.0	14.0	103.60	0.00	103.60
13	B	Sonia de Freitas		7.06	7.0	0.0	7.00	49.42	0.00	49.42		*0.0%*	7.06	7.0	0.0	7.0	49.42	0.00	49.42
14	C	Natalie Turner		7.06	14.0	0.0	14.00	98.84	0.00	98.84		*0.0%*	7.06	14.0	0.0	14.0	98.84	0.00	98.84
15	D	Kate McIntyre		6.94	4.0	0.0	4.00	27.76	0.00	27.76		*0.0%*	6.94	0.0	0.0	0.0	0.00	0.00	0.00
16		Other
17					39.0	0.0	39.0	279.6	0.0	279.6			28.5	35.0	0.0	35.0	251.9	0.0	251.9
18					Note 1									Note 1
19									25									13
20						Total cost for frst 25 wks to 31mar16				6,991				Total cost for remaining 13 wks Apr-Aug16					3,274
21
22																Payto-date since 01jan16 -25wks			6,991
23
24								Rate	£6.50	6,991									10,265
25							Actual		Funded							Actual		Funded
26		SEN DCC income					Hrs/wk		Hrs/wk	Expected DCC						Hrs/wk		Hrs/wk	Expected DCC
27		Name of child:								weeklyincome									termlyincome
28		Logan Gaskell		Natalie Turner			14		7	£45.50						14	??	7	£45.50
29		Jensen Mackenzie		Jan Lane			14		7	£45.50							??	7	£45.50
30		Groupfunding		Kate McIntyre			4		4	£26.00
31			????	Sonia de Freitas			7	cover
32							39		18	£117.00						14		14	£91.00
33						Diference	0.0			1,638	14	wks			Diference	21.0			1,183	13	wks
34								Springterm		1,287	11	wks
35								so 2 terms=		2,925							so	3 terms=	4,108
36
37							NET LOSSper 25 WK PERIOD			-4,066						NET (LOSS)per 38 WK PERIOD			-6,157
38
39		NOTES:														2014-15: Estimated loss
40	1	Only18 hrs out a total of 39 hrs are funded byDCC SENgrants
41	2	All SEN hours have to be covered at a 1:1 ratio

document7113129172415187496.xls\ SEN extra costs vs income-15-16

05/24/2023

----- Start of picture text -----
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2022
3 CALCULATION OF EFFECT of SALARY INCREASES on WEEKLY STAFF COSTS 2021-22 Hours updated -30jan18
4 £242/wk est'd
5 Based on a 38-wk year, plus 5.6 weeks Holiday Pay =£1048/mth
6 Rate increase -provided for wef 1/9/22 -depends whether 'basic rate' goes up 13.8%+1.25% NHS levy
7 Four staff on one-for-one basis for Special Needs. But only covers approx 70%[?] of cost
8 Sep21 onwards Apr22 onwards
9 AVERAGE @13.8% @ 3% 5.7% EST'D AVERAGE @15.05% @ 3%
Extra Plan/ NEST Extra NEST
10 Start Finish Basic hrs/ trg/staff & comittee toddlers course/ pension EER's Basic hrs/ trg/staff & comittee Plan/ course/ toddlers pension EER's
date date New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032 % New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032
11 wef 1/8/21 1-Sep-21 2021-22 2021-22 2021-22 >#170/wk per week =£116/wk wef 1/4/22 incr wef 1/4/22 [cont'd] 2021-22 2021-22 2021-22 >#242/wk per week =£116/wk
12 Kate McIntyre Sep-15 12.00 33.8 5.2 0.0 39.00 468.00 41.12 509.12 10.56 12.00 6.7% 12.80 34.8 5.2 0.0 40.0 512.00 40.64 552.64 11.88
13 Caroline Armstrong (Head) Dec-13 12.00 24.5 7.5 0.0 32.00 384.00 29.53 413.53 8.04 12.00 6.7% 12.80 32.5 7.5 0.0 40.0 512.00 40.64 552.64 11.88
14 Claire Foster Apr-18 Oct-21 12.00 4.3 0.0 0.0 4.31 51.69 0.00 51.69 12.00 -100.0% 0.0 0.0 0.0 0.0 0.00 0.00 0.00
15 Chloe Fowler Jan-21 9.30 14.5 0.0 0.0 14.50 134.85 0.00 134.85 0.57 9.30 6.6% 9.91 17.8 0.0 0.0 17.8 175.90 0.00 175.90 1.80
16 Karen Kinch Aug-20 Oct-21 9.30 7.8 0.0 0.0 7.81 72.61 0.00 72.61 9.30 -100.0% 0.0 0.0 0.0 0.0 0.00 0.00 0.00
17 Lucy Gendall Jan-20 9.10 5.0 0.0 0.0 5.00 45.50 0.00 45.50 9.10 6.0% 9.65 33.3 0.0 0.0 33.3 320.86 11.87 332.73 6.15 L Harding
18 Tracey Mackie Dec-17 8.91 18.0 0.0 0.0 18.00 160.38 0.00 160.38 1.33 8.91 6.6% 9.50 18.0 0.0 0.0 18.0 171.00 0.00 171.00 1.65
19 Tor McKenzie Apr-19 9.80 16.8 0.2 0.0 17.00 166.60 0.00 166.60 1.52 9.80 -1.0% 9.70 9.0 0.0 0.0 9.0 87.30 0.00 87.30 Lucy Everest
20 Jan Lane Bank 9.40 32.0 0.0 0.0 32.00 300.80 18.05 318.85 5.54 9.40 6.6% 10.02 32.0 1.0 0.0 33.0 330.66 13.34 344.00 6.44
21 Katherine Billing ???? Admin 9.00 25.0 0.0 0.0 25.00 225.00 7.59 232.59 3.27 9.00 6.7% 9.60 30.0 0.0 0.0 30.0 288.00 6.92 294.92 5.16
22 Vicki Drinkwater Jul-09 Jan-22 12.00 18.5 0.0 0.0 18.46 221.54 7.11 228.65 3.17 12.00 -100.0% 0.0 0.0 0.0 0.0 0.00 0.00 0.00
23 Kyra Pengelley Jun-18 9.65 21.0 0.0 0.0 21.00 202.65 4.51 207.16 2.60 9.65 9.3% 10.55 39.5 0.0 0.0 39.5 416.73 26.30 443.02 9.02
24 Emelye Welch Jul-18 9.10 15.0 1.0 0.0 16.00 145.60 0.00 145.60 0.89 9.10 6.0% 9.65 34.5 0.0 0.0 34.5 332.93 13.68 346.61 6.51 K Brind
25 Sonia de Freitas Mar-20 9.10 32.0 0.0 0.0 32.00 291.20 16.73 307.93 5.26 9.10 8.2% 9.85 6.0 0.0 0.0 6.0 59.10 0.00 59.10 A Prosser
26 Tasha Oakley Feb-18 8.91 24.0 0.0 0.0 24.00 213.84 6.05 219.89 2.94 8.91 8.9% 9.70 24.5 0.0 0.0 24.5 237.65 0.00 237.65 3.65
27 Amie Pike Oct-18 9.90 12.0 0.0 8.0 20.00 198.00 3.86 201.86 2.46 9.90 5.1% 10.40 17.5 0.0 8.0 25.5 265.20 3.49 268.69 4.48 Laura Watts
28 Jess Turner Jan-19 9.30 27.0 0.0 0.0 27.00 251.10 11.19 262.29 4.05 9.30 -100.0% 0.0 0.0 0.0 0.0 0.00 0.00 0.00
29 Clare Marlow Sep-21 Admin 9.20 25.0 0.0 0.0 25.00 230.00 8.28 238.28 3.42 9.20 6.6% 9.81 9.0 0.0 0.0 9.0 88.29 0.00 88.29
30 Megan Wallace Sep-21 ???? 9.00 2.3 0.0 0.0 2.31 20.77 0.00 20.77 9.00 -100.0% 0.0 0.0 0.0 0.0 0.00 0.00 0.00 38 WK YEAR
31 358.5 13.9 8.0 380.38 3784.13 154.03 3938.16 55.61 338.3 13.7 8.0 360.0 3797.62 156.88 3954.49 68.61 Year:Apr22-Mar23
32 431.0 362.0 no extra cleaning cost 0.00 was 347.5 was £3775 0.00 163297 Gross
33 prior year prior year 3938.16 3954.49 5961 Employers NI
34
35 Winter term only for 11 wks Total cost for first 14 wks to 31dec21 55,134 12 Total cost for remaining 12 wks 47,454 = x 10wks 150271 38WKS
36 Total cost for first 12 wks to 31mar22 47,258 hols+half-terms: extra 10 wks@50+9hr each Kate+CA 8,990 119 0 ok
37 Plus: D Foxon's extra HGGI Study premium of £100/mth until end Dec10=4 mths 0 ER's NI saved -12 wks 3236.62 max £4k a+Jan+Jess 13,458 22,448 0
38 Plus: extra cost of opening Wed PM wefjan10=11 wk 0 Holiday pay on basic hrs: 5.6wks-Aug22 21,267 21267 2020-21 Actual =£21k -estd
39 26 102,392 Basic hrs: 338.3 91,169 171537
40 Pay to-date -26wks 102,392
41 0.00 0 Est'd total cost: 1st half 2021-22 102,392 Est'd total cost: 2021-22 193,561
42 9 Extra Provisions for 9 staff for: Less: ER's NI saved: -4,179 MAX allowed is £4k, per each FY
43 ER's NI saved : 0 £4000 already saved NEST pension contributions 1,445.78 942.09 2,388
44 191,770 £202,054 =2020/21 budget
45 Actual total cost: 1st half 2021-22 102,392 Actual cost -2019-20 191185
46 >>>(De)/ Increase on 2020-21 total 585
47 >>>(De)/Increase on 2020-21 -% 0.3%
----- End of picture text -----

document7113129172415187496.xls/ Wgs Fc 2022-CONFIDENTIAL-updatd

05/24/2023 13:55:52

----- Start of picture text -----
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2022
3 CALCULATION OF EFFECT of SALARY INCREASES on WEEKLY STAFF COSTS 2021-22 Hours updated -30jan18
4 £171/wk est'd
5 Based on a 38-wk year, plus 5.6 weeks Holiday Pay
6 Rate increase -provided for wef 1/9/22 -depends whether 'basic rate' goes up
7 Four staff on one-for-one basis for Special Needs. But only covers approx 70%[?] of cost
8 Sep21 onwards Apr22 onwards
9 AVERAGE @13.8% @ 3% 5.7% EST'D AVERAGE @13.8% @ 3%
Extra Plan/ NEST Extra NEST
10 Start Finish Basic hrs/ trg/staff & comittee toddlers course/ pension EER's Basic hrs/ trg/staff & comittee Plan/ course/ toddlers pension EER's
date date New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032 % New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032
11 wef 1/8/21 1-Sep-21 2021-22 2021-22 2021-22 >#170/wk per week =£116/wk wef 1/4/22 incr wef 1/4/22 [cont'd] 2021-22 2021-22 2021-22 >#171/wk per week =£116/wk
12 Kate McIntyre Sep-15 12.00 33.8 5.2 0.0 39.00 468.00 41.12 509.12 10.56 12.00 5.0% 12.60 29.6 5.2 0.0 34.8 438.48 36.91 475.39 9.67
13 Caroline Armstrong (Head) Dec-13 12.00 24.5 7.5 0.0 32.00 384.00 29.53 413.53 8.04 12.00 5.0% 12.60 24.5 7.5 0.0 32.0 403.20 32.04 435.24 8.62
14 Claire Foster Apr-18 Oct-21 12.00 4.3 0.0 0.0 4.31 51.69 0.00 51.69 12.00 5.0% 12.60 0.0 0.0 0.0 0.0 0.00 0.00 0.00
15 Chloe Fowler Jan-21 9.30 14.5 0.0 0.0 14.50 134.85 0.00 134.85 0.57 9.30 5.9% 9.85 14.5 0.0 0.0 14.5 142.83 0.00 142.83 0.80
16 Karen Kinch Aug-20 Oct-21 9.30 7.8 0.0 0.0 7.81 72.61 0.00 72.61 9.30 5.9% 9.85 0.0 0.0 0.0 0.0 0.00 0.00 0.00
17 Lucy Gendall Jan-20 9.10 5.0 0.0 0.0 5.00 45.50 0.00 45.50 9.10 6.0% 9.65 5.0 0.0 0.0 5.0 48.25 0.00 48.25
18 Tracey Mackie Dec-17 8.91 18.0 0.0 0.0 18.00 160.38 0.00 160.38 1.33 8.91 5.7% 9.42 18.0 0.0 0.0 18.0 169.56 0.00 169.56 1.61
19 Tor McKenzie Apr-19 9.80 16.8 0.2 0.0 17.00 166.60 0.00 166.60 1.52 9.80 6.1% 10.40 30.8 0.2 0.0 31.0 322.40 20.89 343.29 6.19
20 Jan Lane Bank 9.40 32.0 0.0 0.0 32.00 300.80 18.05 318.85 5.54 9.40 5.9% 9.95 32.0 0.0 0.0 32.0 318.40 20.34 338.74 6.07
21 Katherine Billing ???? Admin 9.00 25.0 0.0 0.0 25.00 225.00 7.59 232.59 3.27 9.00 4.7% 9.42 30.0 0.0 0.0 30.0 282.60 15.40 298.00 5.00
22 Vicki Drinkwater Jul-09 Jan-22 12.00 18.5 0.0 0.0 18.46 221.54 7.11 228.65 3.17 12.00 5.0% 12.60 0.0 0.0 0.0 0.0 0.00 0.00 0.00
23 Kyra Pengelley Jun-18 9.65 21.0 0.0 0.0 21.00 202.65 4.51 207.16 2.60 9.65 6.2% 10.25 25.0 0.0 0.0 25.0 256.25 11.76 268.01 4.21
24 Emelye Welch Jul-18 9.10 15.0 1.0 0.0 16.00 145.60 0.00 145.60 0.89 9.10 6.0% 9.65 7.0 1.0 0.0 8.0 77.20 0.00 77.20 -1.16
25 Sonia de Freitas Mar-20 9.10 32.0 0.0 0.0 32.00 291.20 16.73 307.93 5.26 9.10 6.0% 9.65 32.0 0.0 0.0 32.0 308.80 19.02 327.82 5.78
26 Tasha Oakley Feb-18 8.91 24.0 0.0 0.0 24.00 213.84 6.05 219.89 2.94 8.91 5.7% 9.42 24.0 0.0 0.0 24.0 226.08 7.60 233.68 3.30
27 Amie Pike Oct-18 9.90 12.0 0.0 8.0 20.00 198.00 3.86 201.86 2.46 9.90 6.1% 10.50 10.8 0.0 8.0 18.8 197.40 3.64 201.04 2.44
28 Jess Turner Jan-19 9.30 27.0 0.0 0.0 27.00 251.10 11.19 262.29 4.05 9.30 5.9% 9.85 35.0 0.0 0.0 35.0 344.75 23.98 368.73 6.86
29 Clare Marlow Sep-21 Admin 9.20 25.0 0.0 0.0 25.00 230.00 8.28 238.28 3.42 9.20 4.9% 9.65 8.0 0.0 0.0 8.0 77.20 0.00 77.20 -1.16
30 Megan Wallace Sep-21 ???? 9.00 2.3 0.0 0.0 2.31 20.77 0.00 20.77 9.00 4.7% 9.42 0.0 0.0 0.0 0.0 0.00 0.00 0.00 38 WK YEAR
31 358.5 13.9 8.0 380.38 3784.13 154.03 3938.16 55.61 326.2 13.9 8.0 348.1 3613.40 191.59 3804.99 58.23 Year:Apr22-Mar23
32 431.0 362.0 no extra cleaning cost 0.00 was 347.5 was £3775 0.00 155376 Gross
33 prior year prior year 3938.16 3804.99 7281 Employers NI
34
35 Winter term only for 11 wks Total cost for first 14 wks to 31dec21 55,134 12 Total cost for remaining 12 wks 45,660 = x 10wks 144590 38WKS
36 Total cost for first 12 wks to 31mar22 47,258 hols+half-terms: extra 10 wks@50+9hr each Kate+Vicky 8,882 97 0 ok
37 Plus: D Foxon's extra HGGI Study premium of £100/mth until end Dec10=4 mths 0 ER's NI saved -12 wks 3895.18 max £4k a+Jan+Jess 6,888 15,770 58
38 Plus: extra cost of opening Wed PM wefjan10=11 wk 0 Holiday pay on basic hrs: 5.6wks-Aug22 20,235 20235 2020-21 Actual =£21k -estd
39 26 102,392 Basic hrs: 326.2 81,664 164825
40 Pay to-date -26wks 102,392
41 0.00 0 Est'd total cost: 1st half 2021-22 102,392 Est'd total cost: 2021-22 184,056
42 9 Extra Provisions for 9 staff for: Less: ER's NI saved: -4,837 MAX allowed is £4k, per each FY
43 ER's NI saved : 0 £4000 already saved NEST pension contributions 1,445.78 853.40 2,299
44 181,518 £202,054 =2020/21 budget
45 Actual total cost: 1st half 2021-22 102,392 Actual cost -2019-20 191185
46 >>>(De)/ Increase on 2020-21 total -9667
47 >>>(De)/Increase on 2020-21 -% -5.1%
----- End of picture text -----

document7113129172415187496.xls/ Wgs Fc 2022-CONFIDENTIAL-sep

05/24/2023 13:55:52

----- Start of picture text -----
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2021
3 CALCULATION OF EFFECT of SALARY INCREASES on WEEKLY STAFF COSTS 2020-21 Hours updated -30jan18
4 £171/wk est'd
5 Based on a 38-wk year, plus one month's Holiday Pay
6 Rate increase planned wef 1/9/21
7 Four staff on one-for-one basis for Special Needs. But only covers approx 70%[?] of cost
8 Sep20 onwards Apr21 onwards
9 AVERAGE @13.8% @ 3% 2.0% EST'D AVERAGE @13.8% @ 3%
Extra Plan/ NEST Extra NEST
10 Start Finish Basic hrs/ trg/staff & comittee toddlers course/ pension EER's Basic hrs/ trg/staff & comittee Plan/ course/ toddlers pension EER's
date date New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032 % New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032
11 wef 1/8/20 1-Sep-20 2020-21 2020-21 2020-21 >#169/wk per week =£116/wk wef 1/4/21 incr wef 1/4/21 [cont'd] 2020-21 2020-21 2020-21 >#171/wk per week =£116/wk
12 Kate McIntyre Sep-15 9.70 33.8 6.7 0.0 40.50 392.85 30.89 423.74 8.31 9.70 2.0% 9.89 33.8 6.7 0.0 40.5 400.71 31.70 432.41 8.54
13 Caroline Armstrong (Head) Dec-13 11.25 24.5 7.5 0.0 32.00 360.00 26.36 386.36 7.32 11.25 2.0% 11.48 24.5 7.5 0.0 32.0 367.20 27.08 394.28 7.54
14 Claire Foster Apr-18 11.25 23.5 6.5 0.0 30.00 337.50 23.25 360.75 6.65 11.25 2.0% 11.48 23.5 6.5 0.0 30.0 344.25 23.91 368.16 6.85
15 Karen Skinner 9.20 0.0 0.0 0.0 0.00 0.00 0.00 0.00 9.20 2.0% 9.38 0.0 0.0 0.0 0.0 0.00 0.00 0.00
16 Karen Kinch Sep-20 9.00 31.0 0.0 0.0 31.00 279.00 15.18 294.18 4.89 9.00 2.0% 9.18 31.0 0.0 0.0 31.0 284.58 15.67 300.25 5.06
17 Lucy Gendall Jan-20 M'y leave 8.90 9.0 0.0 0.0 9.00 80.10 0.00 80.10 8.90 2.0% 9.08 9.0 0.0 0.0 9.0 81.70 0.00 81.70
18 Tracey Mackie Dec-17 8.72 19.0 0.0 0.0 19.00 165.68 0.00 165.68 1.49 8.72 2.0% 8.89 19.0 0.0 0.0 19.0 168.99 0.00 168.99 1.59
19 Tor McKenzie Apr-19 8.72 20.8 0.2 0.0 21.00 183.12 1.95 185.07 2.01 8.72 2.0% 8.89 20.8 0.2 0.0 21.0 186.78 2.18 188.96 2.12
20 Jan Lane Bank 9.20 39.5 0.0 0.0 39.50 363.40 26.83 390.23 7.42 9.20 2.0% 9.38 39.5 0.0 0.0 39.5 370.67 27.55 398.22 7.64
21 0.00 0.0 0.00 0.00 0.00 0.00 0.00 #DIV/0! 0.00 0.0 0.0 0.0 0.0 0.00 0.00 0.00
22 Vicki Drinkwater Jul-09 11.25 21.5 8.5 0.0 30.00 337.50 23.25 360.75 6.65 11.25 2.0% 11.48 21.5 8.5 0.0 30.0 344.25 23.91 368.16 6.85
23 Kyra Pengelley Jun-18 9.25 35.0 0.0 0.0 35.00 323.75 21.36 345.11 6.23 9.25 2.0% 9.44 35.0 0.0 0.0 35.0 330.23 21.97 352.20 6.43
24 Emelye Welch Jul-18 8.90 15.0 0.0 0.0 15.00 133.50 0.00 133.50 0.53 8.90 2.0% 9.08 15.0 0.0 0.0 15.0 136.17 0.00 136.17 0.61
25 Sonia de Freitas Mar-20 8.90 37.0 0.0 0.0 37.00 329.30 22.12 351.42 6.40 8.90 2.0% 9.08 37.0 0.0 0.0 37.0 335.89 22.75 358.64 6.60
26 Tasha Oakley Feb-18 8.72 24.3 0.0 0.0 24.25 211.46 5.86 217.32 2.86 8.72 2.0% 8.89 24.3 0.0 0.0 24.3 215.69 6.17 221.86 2.99
27 Amie Pike Oct-18 9.70 12.0 0.0 10.0 22.00 213.40 6.13 219.53 2.92 9.70 2.0% 9.89 12.0 0.0 10.0 22.0 217.67 6.44 224.11 3.05
28 Jess Turner Jan-19 7.00 29.3 0.0 0.0 29.25 204.75 4.93 209.68 2.66 7.00 2.0% 7.14 29.3 0.0 0.0 29.3 208.85 5.22 214.07 2.79
29 Amy Grady Jul-18 9.10 16.0 0.0 0.0 16.00 145.60 0.00 145.60 0.89 9.10 2.0% 9.28 16.0 0.0 0.0 16.0 148.51 0.00 148.51 0.98
30 Jun-18 0.0 0.0 0.0 0.00 0.00 0.00 0.00 0.00 #DIV/0! 0.00 0.0 0.0 0.0 0.0 0.00 0.00 0.00 38 WK YEAR
31 391.1 29.4 10.0 430.50 4060.91 208.11 4269.02 67.22 391.1 29.4 10.0 430.5 4142.13 214.56 4356.68 69.61 Year:Apr21-Mar22
32 342.0 362.0 no extra cleaning cost 0.00 no extra cleaning cost 0.00 178112 Gross
33 prior year prior year 4269.02 4356.68 8153 Employers NI
34
35 Winter term only for 11 wks Total cost for first 14 wks to 31dec20 59,766 12 Total cost for remaining 12 wks 52,280 = x 10wks 165554 38WKS
36 Total cost for first 12 wks to 31mar21 51,228 hols+half-terms: extra 10 wks@55hr each Kate 5,957 85 0 ok
37 Plus: D Foxon's extra HGGI Study premium of £100/mth until end Dec10=4 mths 0 ER's NI saved -12 wks 4093.17 max £4k Sonia+Kaz 10,892 16,849 cookeh:17dec 66
38 Plus: extra cost of opening Wed PM wefjan10=11 wk 0 Holiday pay on basic hrs: 5.6wks-Aug21 23,196 calc on average hrs over 23196 2019-20 Actual =£17k -estd
39 26 110,994 Basic hrs: 391.1 92,325 38 wks 188750
40 Pay to-date -26wks 110,994
41 0.00 0 Est'd total cost: 1st half 2020-21 110,994 Est'd total cost: 2020-21 203,319
42 9 Extra Provisions for 9 staff for: Less: ER's NI saved: -4,000 MAX allowed is £4k, per each FY
43 ER's NI saved : 1,005 £2995 already saved NEST pension contributions 1,747.83 986.73 2,735
44 202,054 £163,065 =2019/20 budget
45 Actual total cost: 1st half 2020-21 109,989 Actual cost -2019-20 161580
46 >>>(De)/ Increase on 2019-20 total 40474
47 >>>(De)/Increase on 2019-20 -% 25.0%
----- End of picture text -----

document7113129172415187496.xls/ Wgs Fc 2021-CONFIDENTIAL-sep

05/24/2023 13:55:52

----- Start of picture text -----
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2020
3 CALCULATION OF EFFECT of SALARY INCREASES on WEEKLY STAFF COSTS 2019-20 Hours updated -30jan18
4 £165/wk est'd
5 Based on a 38-wk year, plus one month's Holiday Pay
6 Rate increase planned wef 1/9/18
7 Four staff on one-for-one basis for Special Needs. But only covers approx 70%[?] of cost
8 Sep19 onwards Apr20 onwards
9 AVERAGE @13.8% @ 3% 0.0% EST'D AVERAGE @13.8% @ 3%
Extra Plan/ NEST Extra NEST
10 Start Finish Basic hrs/ trg/staff & comittee toddlers course/ pension EER's Basic hrs/ trg/staff & comittee Plan/ course/ toddlers pension EER's
date date New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032 % New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032
11 wef 1/4/19 1-Sep-19 2019-20 2019-20 2019-20 >#165/wk per week =£116/wk wef 1/4/20 incr wef 1/4/20 [cont'd] 2019-20 2019-20 2019-20 >#165/wk per week =£116/wk
12 Kate McIntyre Sep-15 8.40 33.8 0.2 0.0 34.00 285.60 16.64 302.24 5.09 8.40 3.1% 8.66 33.8 0.2 0.0 34.0 294.44 17.86 312.30 5.35
13 Caroline Armstrong (Head) Dec-13 10.70 24.5 5.5 0.0 30.00 321.00 21.53 342.53 6.15 10.70 2.8% 11.00 24.5 5.5 0.0 30.0 330.00 22.77 352.77 6.42
14 Claire Foster Apr-18 10.70 23.5 0.5 0.0 24.00 256.80 12.67 269.47 4.22 10.70 2.8% 11.00 23.5 0.5 0.0 24.0 264.00 13.66 277.66 4.44
15 Karen Skinner 8.80 17.3 0.2 0.0 17.50 154.00 0.00 154.00 1.14 8.80 2.3% 9.00 17.3 0.2 0.0 17.5 157.50 0.00 157.50 1.25
16 Ben Riches Sep-17 8.21 0.0 0.0 0.0 0.00 0.00 0.00 0.00 8.21 4.3% 8.56 0.0 0.0 0.0 0.0 0.00 0.00 0.00
17 Lucy Gendall Jan-20 M'y leave 8.40 16.0 0.0 0.0 16.00 134.40 0.00 134.40 0.55 8.40 3.1% 8.66 16.0 0.0 0.0 16.0 138.56 0.00 138.56
18 Tracey Mackie Dec-17 8.21 18.0 0.0 0.0 18.00 147.78 0.00 147.78 0.95 8.21 4.3% 8.56 18.0 0.0 0.0 18.0 154.08 0.00 154.08 1.14
19 Tor McKenzie Apr-19 8.21 15.8 0.2 0.0 16.00 131.36 0.00 131.36 0.46 8.21 5.5% 8.66 15.8 0.2 0.0 16.0 138.56 0.00 138.56 0.68
20 Jan Lane Bank 8.80 20.1 0.2 0.0 20.25 178.20 1.82 180.02 1.87 8.80 2.3% 9.00 20.1 0.2 0.0 20.3 182.25 2.38 184.63
21 Stacey Onoyiweta Jul-14 9.20 19.8 0.2 0.0 20.00 184.00 2.62 186.62 2.04 9.20 2.2% 9.40 19.8 0.2 0.0 20.0 188.00 3.17 191.17 2.16
22 Vicki Drinkwater Jul-09 10.70 21.5 2.5 0.0 24.00 256.80 12.67 269.47 4.22 10.70 -6.5% 10.00 21.5 2.5 0.0 24.0 240.00 10.35 250.35 3.72
23 Kyra Pengelley Jun-18 8.60 31.3 0.0 0.0 31.25 268.75 14.32 283.07 4.58 8.60 2.3% 8.80 31.3 0.0 0.0 31.3 275.00 15.18 290.18 4.77
24 Emelye Welch Jul-18 8.40 15.0 0.0 0.0 15.00 126.00 0.00 126.00 0.30 8.40 3.1% 8.66 15.0 0.0 0.0 15.0 129.90 0.00 129.90 0.42
25 Sharon Atkinson Jan-19 8.60 17.3 0.0 0.0 17.25 148.35 0.00 148.35 0.97 8.60 2.3% 8.80 17.3 0.0 0.0 17.3 151.80 0.00 151.80 1.07
26 Tasha Oakley Feb-18 8.21 20.0 0.0 0.0 20.00 164.20 0.00 164.20 1.45 8.21 4.3% 8.56 20.0 0.0 0.0 20.0 171.20 0.86 172.06 1.66
27 Amie Pike Oct-18 8.80 13.0 0.0 10.0 23.00 202.40 5.16 207.56 2.59 8.80 2.3% 9.00 13.0 0.0 10.0 23.0 207.00 5.80 212.80 2.73
28 Jess Turner Jan-19 6.30 17.8 0.0 0.0 17.75 111.83 0.00 111.83 6.30 30.3% 8.21 17.8 0.0 0.0 17.8 145.73 0.00 145.73
29 Amy Grady Jul-18 8.60 17.8 0.0 0.0 17.75 152.65 0.00 152.65 1.10 8.60 2.3% 8.80 17.8 0.0 0.0 17.8 156.20 0.00 156.20 1.21
30 Hayley Gillam Jun-18 8.21 0.0 0.0 0.0 0.00 0.00 0.00 0.00 8.21 4.3% 8.56 0.0 0.0 0.0 0.0 0.00 0.00 0.00 38 WK YEAR
31 342.3 9.5 10.0 361.75 3224.12 87.43 3311.54 37.69 342.3 9.5 10.0 361.8 3324.22 92.03 3416.25 37.01 Year:Apr20-Mar21
32 359.0 no extra cleaning cost 0.00 no extra cleaning cost 0.00 142941 Gross
33 prior year 3311.54 3416.25 3497 Employers NI
34
35 Winter term only for 11 wks Total cost for first 14 wks to 31dec19 46,362 12 Total cost for remaining 12 wks 40,995 = x 12wks 129817 38WKS
36 Total cost for first 12 wks to 31mar20 39,739 hols+half-terms: extra 12 wks@55hr each Kate 6,231 64 0 ok
37 Plus: D Foxon's extra HGGI Study premium of £100/mth until end Dec10=4 mths 0 ER's NI saved -12 wks 1872.18 max £3k Stacey O 6,787 13,018 cookeh:17dec 26
38 Plus: extra cost of opening Wed PM wefjan10=11 wk 0 Holiday pay on basic hrs: 5.6wks-Aug20 18,616 calc on average hrs over 18616 2018-9 Actual =£17k -estd
39 26 86,100 Basic hrs: 342.3 72,629 38 wks 148433
40 Pay to-date -26wks 86,100
41 0.00 0 Est'd total cost: 1st half 2019-20 86,100 Est'd total cost: 2019-20 158,729
42 9 Extra Provisions for 9 staff for: Less: ER's NI saved: -2,178 MAX allowed is £3k, per each FY
43 ER's NI saved : 306 £2901 already saved NEST pension contributions 979.91 534.28 1,514
44 158,065 £185,392 =2018/19 budget
45 Actual total cost: 1st half 2019-20 85,794 Actual cost -2018-19 179506
46 >>>(De)/ Increase on 2018-19 total -21441
47 >>>(De)/Increase on 2018-19 -% -11.9%
----- End of picture text -----

document7113129172415187496.xls/ Wgs Fc 2020-CONFIDENTIAL-oc (2)

05/24/2023 13:55:52

----- Start of picture text -----
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2020
3 CALCULATION OF EFFECT of SALARY INCREASES on WEEKLY STAFF COSTS 2019-20 Hours updated -30jan18
4 £165/wk est'd
5 Based on a 38-wk year, plus one month's Holiday Pay
6 Rate increase planned wef 1/9/18
7 Four staff on one-for-one basis for Special Needs. But only covers approx 70%[?] of cost
8 Sep19 onwards Apr20 onwards
9 AVERAGE @13.8% @ 3% 0.0% EST'D AVERAGE @13.8% @ 3%
Extra Plan/ NEST NEST
10 trg/staff & course/ EER's EER's
Start Finish Basic hrs/ comittee toddlers pension Holiday Days IN pension
date date New rates SEN [green] mtgs group Total hrs Gross pay Emp'ers NI Total cost >£6032 % New rates accrued LIEU Total hrs Gross pay Emp'ers NI Total cost >£6032
11 wef 1/4/19 1-Sep-19 2019-20 2019-20 2019-20 >#165/wk per week =£116/wk wef 1/4/20 incr wef 1/4/20 [cont'd] 2019-20 2019-20 2019-20 >#165/wk per week =£116/wk
12 Kate McIntyre Sep-15 8.40 0.0 0.00 0.00 0.00 0.00 -3.48 8.40 3.1% 8.66 4.16 0.0 0.0 4.2 36.03 0.00 36.03 -2.40
13 Caroline Armstrong (Head) Dec-13 10.70 0.0 0.00 0.00 0.00 0.00 -3.48 10.70 2.8% 11.00 135.22 0.0 0.0 135.2 1487.42 182.49 1669.91 41.14
14 Claire Foster Apr-18 10.70 0.0 0.00 0.00 0.00 0.00 -3.48 10.70 2.8% 11.00 0.00 0.0 0.0 0.0 0.00 0.00 0.00 -3.48
15 Karen Skinner 8.80 0.0 0.00 0.00 0.00 0.00 -3.48 8.80 2.3% 9.00 33.90 0.0 0.0 33.9 305.10 19.33 324.43 5.67
16 Karen Kinch Sep-20 9.00 0.0 0.00 0.00 0.00 0.00 9.00 0.0% 9.00 0.00 0.0 0.0 0.0 0.00 0.00 0.00
17 Lucy Gendall Jan-20 M'y leave 8.40 0.0 0.00 0.00 0.00 0.00 -3.48 8.40 3.1% 8.66 0.00 0.0 0.0 0.0 0.00 0.00 0.00
18 Tracey Mackie Dec-17 8.21 0.0 0.00 0.00 0.00 0.00 -3.48 8.21 4.3% 8.56 0.00 0.0 0.0 0.0 0.00 0.00 0.00 -3.48
19 Tor McKenzie Apr-19 8.21 0.0 0.00 0.00 0.00 0.00 -3.48 8.21 5.5% 8.66 0.00 0.0 0.0 0.0 0.00 0.00 0.00 -3.48
20 Jan Lane Bank 8.80 0.0 0.00 0.00 0.00 0.00 -3.48 8.80 2.3% 9.00 175.86 0.0 0.0 175.9 1582.74 195.65 1778.39
2122 StaceVicki Drinkwatery Onoyiweta JJul-14ul-09 Aug-20 10.709.20 0.00.0 0.000.00 0.000.00 0.000.00 0.000.00 -3.48-3.48 10.709.20 -6.5%2.2% 10.009.40 0.002.41 0.00.0 Howard Cookes: No cover for Vicki -so no 0.00.0 0.02.4 24.100.00 0.000.00 24.100.00 -3.48-2.76
23 Kyra Pengelley Jun-18 8.60 0.0 0.00 0.00 0.00 0.00 -3.48 8.60 2.3% 8.80 25.44 19.0 extra cost0.0 44.4 391.07 31.20 422.27 8.25
24 Emelye Welch Jul-18 8.40 0.0 0.00 0.00 0.00 0.00 -3.48 8.40 3.1% 8.66 0.00 0.0 0.0 0.0 0.00 0.00 0.00 -3.48
25 Sonia de Freitas Mar-20 8.60 0.0 0.00 0.00 0.00 0.00 -3.48 8.60 3.5% 8.90 114.20 47.5 0.0 161.7 1439.13 175.83 1614.96 39.69
26 Tasha Oakley Feb-18 8.21 0.0 0.00 0.00 0.00 0.00 -3.48 8.21 4.3% 8.56 0.00 0.0 0.0 0.0 0.00 0.00 0.00 -3.48
27 Amie Pike Oct-18 8.80 0.00 0.00 0.00 0.00 -3.48 8.80 2.3% 9.00 1.69 0.0 0.0 1.7 15.21 0.00 15.21 -3.02
28 Jess Turner Jan-19 6.30 0.0 0.00 0.00 0.00 0.00 6.30 30.3% 8.21 107.77 0.0 0.0 107.8 884.79 99.33 984.12
29 Amy Grady Jul-18 8.60 0.0 0.00 0.00 0.00 0.00 -3.48 8.60 2.3% 8.80 0.00 0.0 0.0 0.0 0.00 0.00 0.00 -3.48
30 Rose Western Jun-18 9.10 0.0 0.0 0.0 0.00 0.00 0.00 0.00 9.10 0.0% 9.10 1.81 0.0 0.0 1.8 16.47 0.00 16.47 38 WK YEAR
31 0.0 0.0 0.0 0.00 0.00 0.00 0.00 -55.68 602.5 66.5 0.0 669.0 6182.06 703.84 6885.90 62.22
32 359.0 no extra cleaning cost 0.00 no extra cleaning cost 0.00
33 prior year 0.00 6885.90
34
49
50
51 cookeh:17dec
52 calc on average hrs over
53 38 wks
54
55
----- End of picture text -----

document7113129172415187496.xls/ Wgs Fc 2020-HOLIDAY accrd-31aug

05/24/2023 13:55:52

----- Start of picture text -----
A B C D E F G H I J K L M N O P
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2022
3
4 General ledger: CB-R1 Cash book-Current a/c: RECEIPTS
5
After-schl Snack
6 Balance/ Session fees club - Session Toddler fund/ hol DCC/ other DCC Re- imb Donat- Interest
Date Details Ref (payments) Banked -parents parents fees -DCC group club Grants Spec needs ions Fund-raising rec'd Other
7 SEPTEMBER 2021
8 1-Sep Opening bal 5489.87
9 3-Sep P-Mail: hol club x1 40 55.31 55.31 hol club
10 3-Sep Holiday club -D Culley 41 19.80 19.80 hol club
11 6-Sep ASC fees -H+M Mason 42 243.00 243.00
12 7-Sep DCC EYEF Grant -winter term -1st hal 43 22799.00 22799.00
13 8-Sep Refund -Sainsburys -food 44 2.05 2.05
14 8-Sep Session fees -T Burt 45 139.00 139.00 summer hol club
15 9-Sep P-Mail: ASC fees x0; hol club x1; 46 398.97 381.97 snack/holiday club 17.00 uniform
16 10-Sep Holiday club -Mullen 47 96.53 96.53 hol club
17 14-Sep Session fees -J Finn 48 33.00 33.00 summer hol club
18 16-Sep P-Mail: ASC fees x0; hol club x2; 49 72.67 63.67 hol club x2 +snack 9.00 uniform
19 23-Sep P-Mail: ASC fees x1; session x1;s 50 481.95 12.20 469.75 snack/holiday club -summer
20 27-Sep ASC fees -Jimmy Kaley-Quick 51 312.50 312.50
21 27-Sep ASC fees -Ifvan Kaley-Quick 52 312.50 312.50
22 27-Sep ASC fees -D Jessett 53 120.00 120.00
23 27-Sep Holiday club -Waite family 54 118.80 118.80 summer hol club
24 28-Sep ASC fees -S Howell 55 268.20 268.20
25 28-Sep ASC fees -E Howell 56 358.20 358.20
26 29-Sep ASC fees -J Finn 57 273.00 273.00 donationSpiller
27 30-Sep P-Mail: donation; snack; uniform 58 26183.89 79.41 14.41 snack/b club 47.00 18.00 uniform
28 30-Sep Payments -month -15753.20
29 0 15920.56 26183.89 0.00 1899.60 22799.00 0.00 1392.24 0.00 0.00 47.00 44.00 0.00 2.05
30 OCTOBER 2021
31 1-Oct Opening bal 15920.56
32 1-Oct DCC EYEF Grant -Summer term ame 59 8982.58 8982.58 summer term
33 4-Oct Session fees -M Jenner 60 20.00 20.00 summer hol club
34 5-Oct ASC fees -M Groundsell 61 348.60 348.60
35 5-Oct ASC fees -G Groundsell 62 348.60 348.60
36 6-Oct Session fees -H Luke 63 1031.25 395.65 635.60 summer hol club
37 6-Oct Toddler group 64 49.00 chq 49.00 20/9, 27/9, 4/10
38 7-Oct P-Mail: ASC x4;session x1 65 552.56 432.75 119.81
39 8-Oct ASC fees -N Lison 66 118.80 118.80
40 11-Oct Contribution -easy fund-raising 67 16.22 chq 16.22 Easy f-r commission
41 11-Oct BSC classes - W+A Dingle 68 9.90 9.90 BSC
42 14-Oct P-Mail: ASC x2;session x2; 69 1484.81 867.06 617.75
43 14-Oct Session fees -A Little 70 378.00 378.00
44 14-Oct ASC fees -D Culley 71 888.60 888.60 prepaid ????
45 19-Oct Session fees -R Rejzl 72 2588.94 2588.94 prepaid ????
46 15-Oct ASC fees -R Rejzl 73 389.70 389.70
47 20-Oct Session fees -I Hands 74 346.50 346.50
48 21-Oct P-Mail: ASC x1;session x4 75 919.15 748.15 95.00 15.00 snack x2; other 46.00 15.00 Suncream
49 21-Oct ASC fees -JS Hill 76 546.00 546.00 prepaid ???? wages ref
50 21-Oct REFUND -Tor MacKenzie wages 77 136.62 136.62
51 27-Oct ASC fees -H+J Boswell 78 420.00 420.00 prepaid ????
52 28-Oct P-Mail: ASC x3;session x3 79 1738.62 1443.02 285.60 10.00 snack x 2
53 28-Oct ASC fees -D Jessett 80 120.00 120.00
54 31-Oct 21434.45 0.00
55 31-Oct Payments -month -21155.77
56 0 16199.24 21434.45 7200.07 4298.46 8982.58 58.90 680.60 0.00 0.00 46.00 31.22 0.00 136.62
57 NOVEMBER 2021
58 1-Nov Opening bal 16199.24
59 1-Nov ASC fees - N Leson 81 4.95 4.95
60 1-Nov Hol club -F&P Wallace 82 64.20 64.20 Hol club -Autumn
61 3-Nov Hol club -Y&J Kaley-Quick 83 156.25 156.25 Hol club -Autumn
62 4-Nov P-Mail: ASC x2;session x2; hol x3 84 1063.93 495.00 442.70 126.23
63 4-Nov Session fees-G&L Corrick 85 50.00 50.00
64 5-Nov ASC fees - D Culley 86 6.00 6.00
65 8-Nov Hol club -N Pryor 87 60.00 60.00 Hol club -Autumn
66 8-Nov ASC fees - E Taylor 88 243.00 243.00
67 9-Nov EDFC GAFF -refund 89 10.00 10.00 ?????
68 9-Nov Sainsburys food shop- refund 90 1.30 1.30
69 11-Nov P-Mail: ASC x3;session x2; snack 91-92 748.10 362.17 267.25 97.68 2 x hol club 21.00 Xmas carol concert
70 11-Nov Session fees -H Luke 93 437.50 437.50
71 12-Nov Lottery ticket -C Bones 94 50.00 50.00 Lottery
72 15-Nov Session fees -I Rejzi 95 115.01 115.01
73 15-Nov ASC fees -I Rejzl 96 32.18 32.18
74 16-Nov ASC fees -L McGregor 97 380.24 380.24
75 16-Nov ASC fees -R McGregor 98 470.00 470.00
76 16-Nov ASC fees -L McGregor 99 10.16 10.16
77 16-Nov Session fees -Z Attenborough 100 429.50 429.50
78 16-Nov ASC fees -B Bradford 1 4.95 4.95
79 19-Nov Session fees -A Ashby 2 155.52 155.52
80 23-Nov Session fees -A Ashby 3 credit -DWP 92.00 92.00
81 23-Nov Lottery ticket -C Southend 4 10.00 10.00 Lottery
82 23-Nov Session fees -S Dixen 5 804.38 804.38
83 24-Nov Holiday club -A&Z Brown 6 69.30 69.30 Hol club
84 25-Nov P-Mail: ASC x4;session x0; snack 07-08 429.44 354.94 15.00 59.50 Carol £23.50/uniform
85 26-Nov Session fees -A Spokes 9 287.50 287.50
86 29-Nov DCC EYEF Grant -winter term -2nd 10 2133.95 2133.95 winter term -second payment
87 29-Nov ASC fees -H&M Mason 11 486.00 486.00
88 29-Nov ASC fees -N Lison 12 4.95 4.95
89 29-Nov ASC fees -E Harvey 13 324.00 324.00
90 30-Nov ASC fees -E Taylor 14 243.45 243.45
91 30-Nov ASC fees -N Pryor 15 9435.76 58.00 58.00
92 30-Nov Payments -month -19035.01 0.00
93 0 6599.99 9435.76 3228.58 3332.77 2133.95 0.00 588.66 0.00 0.00 0.00 150.50 0.00 1.30
----- End of picture text -----

17 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:52

18 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:52

19 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

----- Start of picture text -----
A B C D E F G H I J K L M N O P
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2022
3
4 General ledger: CB-R1 Cash book-Current a/c: RECEIPTS
5
After-schl Snack
6 Balance/ Session fees club - Session Toddler fund/ hol DCC/ other DCC Re- imb Donat- Interest
Date Details Ref (payments) Banked -parents parents fees -DCC group club Grants Spec needs ions Fund-raising rec'd Other
242
243 APRIL 2022
244 1-Apr Opening bal 26792.46
245 1-Apr ASC fees -H&M Mason 50 826.80 826.80
246 1-Apr ASC fees -N Pryor 51 100.00 100.00
247 1-Apr ASC fees -E Mullen 52 187.50 187.50 summer term
248 1-Apr Paypal -transaction test 53 0.01 0.01
249 4-Apr Session fees - Ashby 54 500.05 500.05
250 4-Apr ASC fees -L Macgregor 55 9.90 9.90
251 5-Apr ASC fees -R Rejzl 56 346.00 346.00 summer term
252 5-Apr Lottery monthly payout 57 78.80 78.80 Lottery mthly
253 5-Apr March toddler gp; cake sale 58 47.72 HNC-Corrected 15.22 March 32.50 cake sale
254 6-Apr ASC fees -H&M Mason; F Toomey 59 254.00 11.00 243.00 summer term
255 6-Apr ASC fees -E &I Hands 60 372.33 372.33 summer term
256 6-Apr Session fees -I Rejzl 61 2109.75 2109.75 summer term
257 6-Apr Session fees -W Cleeves 62 546.25 546.25 summer term
258 7-Apr P Mail Session fees x11; ASCx2; 63-64 2381.26 2275.31 89.95 £1240=summer term 10.00 6.00 suncream
259 7-Apr Session fees - L Lambert 65 333.50 333.50 donations
260 7-Apr Session fees - S Davis 66 316.25 316.25
261 7-Apr ASC fees -M Groundsell 67 136.95 136.95
262 7-Apr ASC fees -G Groundsell 68 191.40 191.40
263 8-Apr DCC -Summer term 69 30374.00 30374.00
264 8-Apr Fund-raising -cake sale 70 281.00 281.00 cake sale
265 11-Apr ASC fees -A Austin-Little 71 123.00 123.00
266 11-Apr ASC fees -Y Kayley-Quick 72 269.25 269.25 summer term
267 11-Apr ASC fees -J Kayley-Quick 73 269.25 269.25 summer term
268 11-Apr Holiday club -J Finn 74 199.90 199.90 Hol club Easter
269 11-Apr Session fees - H Luke; hol club 75 412.50 205.50 summer term 207.00 Hol club Easter
270 12-Apr Lottery -donation 76 29.40 29.40 lottery
271 12-Apr Fund-raising Tess-bar event 77 285.56 285.56 bar event
272 13-Apr Donation -paypal giving funds 78 19.42 19.42 paypal giving funds
273 14-Apr P Mail Session fees x11; ASCx1; h 79-80 5111.40 4267.00 584.80 all summer term 259.60 hol club x 4
274 19-Apr Session fees - E Tristam; hol club 81 257.30 157.30 summer term 100.00 hol club x 1
275 20-Apr ASC fees -R Macgregor 82 72.05 72.05 summer term
276 20-Apr ASC fees -L Macgregor 83 163.59 163.59 summer term
277 22-Apr P Mail Session fees x0; ASCx1; ho 84 413.31 302.13 91.18 hol club x2 20.00 donation x1
278 25-Apr Holiday club M Goldsmith 85 62.00 62.00 hol club x1
279 25-Apr Holiday club Y Kayley-Quick 86 150.40 150.40 hol club x1
280 25-Apr Holiday club J Kayley-Quick 87 150.40 150.40 hol club x1
281 25-Apr Session fees - M Goldsmith 88 310.00 310.00 summer term
282 25-Apr ASC fees -H Mason 89 93.15 93.15 summer term
283 25-Apr Session fees - A Williams 90 2414.90 2414.90 summer term
284 26-Apr Session fees - W Cleeve 91 80.50 80.50 summer term
285 26-Apr Session fees - S Aiken 92 500.25 500.25 summer term
286 26-Apr Lottery -school 93 15.00 15.00 lottery
287 27-Apr ASC fees -P&E Ashenden 94 108.90 108.90 summer term
288 27-Apr ASC fees -P&E Ashenden 95 9.90 9.90 summer term
289 28-Apr P Mail Session fees x1; ASCx1; 96 346.30 51.75 294.55 summer term
290 29-Apr ASC fees -D Cully 97 3.00 3.00 summer term
291 29-Apr Holiday club N Pryor 98 106.38 106.38 hol club x1
292 27-Apr Holiday club -Easter -L McGregor 0.00
293 27-Apr ASC Y Kayly-Quick 0.00
294 27-Apr 51370.48 0.00
295 30-Apr Payments -month -20610.25 0.00
296 0 57552.69 51370.48 14079.31 4797.40 30374.00 15.22 1326.86 0.00 0.00 49.42 728.26 0.00 0.01
297 MAY 2022
298 1-May Opening bal 57552.69
299 5-May Session fees -E Al-sheikhly 99 390.60 390.60
300 5-May ASC fees -H Alpin Poole 100 54.45 54.45
301 3-May DCC -Amendment -spring funding 1 1632.99 1632.99 Spring addition
302 3-May ASC fees -D Cully 2 3.00 3.00
303 3-May ASC fees -E Taylor 3 350.40 350.40
304 3-May Session fees -E Tristram 4 353.40 353.40
305 3-May Session fees -B Scopes 5 232.70 232.70 corected -HNC
306 4-May ASC/ Session fees -Woodward-Bibble 6 738.45 353.40 385.05
307 4-May School lottery 7 78.80 78.80 lottery
308 4-May ASC fees -M+H Mason 8 93.15 93.15
309 4-May ASC fees -R+L MacGregor 9 234.75 234.75
310 4-May Holiday club -I Rejzl 10 40.30 40.30 Easter hol club
311 4-May Session fees - A Ashby 11 88.46 88.46
312 4-May Sum Up -monthly payout 12 72.78 10.00 62.78 Bar
313 4-May ASC fees -M+H Mason 13 243.00 243.00
314 5-May ASC fees -D Jessop 14 85.45 85.45
315 5-May Fund-raising: Easter Bonnet/Todd 15 cash 590.50 2.00 588.50 Easter Bonnet
316 5-May ASC fees -E Mullen 16 52.50 52.50
317 5-May ASC fees -J Finn ?? 158.12 158.12 ok
318 5-May Session fees -E Lomas 17 136.40 136.40
319 5-May Session fees -H Luke 18 412.50 412.50
320 6-May P Mail Session fees x2; ASCx7; Ho 19-20 682.23 304.11 338.40 39.72 suncream+E Bonnet
321 6-May ASC fees -G+L Corrick 21 180.00 180.00
322 6-May ASC fees -E Harvey 22 67.50 67.50
323 9-May Amazon -charity payment 23 6.38 6.38 Amazon charity payment
324 10-May ASC fees -H+J Boswell 24 200.00 200.00
325 10-May ASC fees -D Cully 25 749.30 749.30
326 10-May Lottery -players winner's donation 26 no page 27 14.70 14.70 Players winners donation
327 10-May P Mail Session fees x5; ASCx5; H 28-30 2627.99 1647.75 884.74 ok 15.50 Easter hol club 21.00 59.00 suncream x9/wet bag
328 17-May ASC fees -A Little 31 150.00 150.00
329 17-May School lottery winners -donation 32 14.70 14.70 Players winners donation
330 19-May P Mail Session fees x0; ASCx3; Ho 33 338.58 282.18 45.40 May hol club 5.00 6.00 suncream x1
331 20-May Amazon refund -suspended foldes 34 26.65 26.65
332 27-May May hol club -S Rushton 35 40.25 40.25 May hol club suspended
333 27-May ASC fees -D Jessop 36 109.90 109.90
334 30-May May hol club -Y Kayley Quick 37 104.00 104.00 May hol club
335 30-May May hol club -J Kayley Quick 38 104.00 104.00 May hol club
336 31-May Session fees -M Goldsmith 39 300.00 300.00
337 31-May School lottery winners -donation 40 15.00 15.00 Players winners donation
338 31-May Session fees -E Tristram 41 49.30 49.30
339 31-May 11823.18 0.00
340 31-May Payments -month -15873.72 0.00
341 0 53502.15 11823.18 4268.62 4621.89 1632.99 12.00 349.45 0.00 0.00 76.78 834.80 0.00 26.65
342 JUNE 2022
343 1-Jun Opening bal 53502.15
344 1-Jun Session fees-A Ashby 42 95.03 95.03
345 3-Jun Sum-up: Toddler gp x7; f-rg raffle 43 268.17 14.00 7x 254.17 raffle tickets
346 4-Jun Session fees-B Scopes 44 232.70 232.70
347 6-Jun P Mail Session fees x0; ASCx1; Ho 45 177.21 40.00 132.21 hol club x 3 5.00
348 6-Jun ASC fees -L+R MacGregor 46 232.96 232.96
349 7-Jun Session fees-E Tristram 47 500.00 500.00
350 8-Jun School lottery -monthly receipts 48 99.20 99.20 school lottery
351 8-Jun ASC fees -H+M Mason 49 243.00 243.00
05/24/2023 13:55:53 20 of 67 document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT
----- End of picture text -----

21 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

----- Start of picture text -----
A B C D E F G H I J K L M N O P
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2022
3
4 General ledger: CB-R1 Cash book-Current a/c: RECEIPTS
5
After-schl Snack
6 Balance/ Session fees club - Session Toddler fund/ hol DCC/ other DCC Re- imb Donat- Interest
Date Details Ref (payments) Banked -parents parents fees -DCC group club Grants Spec needs ions Fund-raising rec'd Other
374 JULY 2022
375 1-Jul Opening bal 45387.70
376 4-Jul ASC fees -L&R MacGregpr 71 242.85 242.85
377 4-Jul Summer holl club -J Finn 72 17.40 17.40 summer H/C
378 4-Jul Summer holl club -J Finn 73 24.44 24.44 summer H/C
379 4-Jul Summer holl club -A William 74 446.40 446.40 summer H/C
380 5-Jul Summer holl club -I Rejzl 75 277.44 ok 277.44 summer H/C
381 5-Jul Summer holl club -I Rejzl 76 12.45 12.45 summer H/C
382 5-Jul Summer holl club -A Hands 77 28.75 28.75 summer H/C
383 5-Jul School lottery -monthly receipts 78 91.60 91.60 school lottery
384 5-Jul Session fees -B Scopes 79 491.45 491.45
385 5-Jul Donation: Fund-raising Run 80 718.00 718.00 Fund-raising run
386 5-Jul Summer holl club -E Taylor 81 22.35 22.35 summer H/C
387 5-Jul Session fees -R Groves 82 51.75 51.75
388 5-Jul Session fees -A Ashby 83 95.03 95.03
389 5-Jul ASC fees -H&M Mason 84 186.30 186.30
390 5-Jul Fund-raising : sum-up monthly payou 85 199.14 199.14 Sumup monthly payout
391 5-Jul Session fees -E Tristram 86 548.65 548.65
392 7-Jul Session fees -M Goldsmith 86A 320.00 320.00
393 7-Jul P.Mail:2x ASC fees;1xHol Club 87 254.58 88.40 166.18 summer H/C
394 7-Jul ASC fees -H&M Mason 88 243.00 243.00
395 7-Jul Session fees -M Goldsmith 89 403.00 403.00
396 8-Jul DCC -Amendment -summer term 90 7272.97 7272.97 summer term amendment Ebay refund-mousetraps
397 9-Jul Ebay credit: postage for mousetraps 91 9.60 9.60
398 12-Jul Amazon refund -DC Charger returned 92 19.48 19.48
399 12-Jul Donation: school lottery 93 14.40 14.40 Amazon refund -DC
400 14-Jul P.Mail:1x ASC fees;1xSession; hol 94 1085.55 370.54 22.35 692.66 hol club x5 school lottery
401 18-Jul Holiday club -Z Mimmack 95 23.00 23.00 summer H/C
402 19-Jul Holiday club -H&C Staples 96 788.70 788.70 summer H/C
403 19-Jul Holiday club -M Goldsmith 97 41.65 41.65 summer H/C
404 19-Jul Holiday club -W Cleeves 98 207.00 ok 207.00 summer H/C
405 19-Jul Holiday club -E Tristram 99 655.50 655.50 summer H/C
406 20-Jul Holiday club -A Higgie 100 25.00 25.00 summer H/C deposit
407 20-Jul Donation -paypal giving funds 1 442.19 442.19 Paypal giving fund
408 21-Jul P.Mail:2x ASC fees;2xSession; hol 2 667.32 587.37 72.00 7.95 summer H/C
409 21-Jul Holiday club -B Scopes 3 172.50 172.50 summer H/C
410 22-Jul ASC fees -H&M Mason 4 124.50 124.50
411 25-Jul Holiday club -N Williams 5 103.50 103.50 summer H/C
412 26-Jul Donation: school lottery winner 6 12.90 12.90 Lottery winner
413 27-Jul Session fees-A Ashby 7 95.03 95.03
414 28-Jul P.Mail:4x ASC fees;1xSession; hol 8 364.61 34.50 160.61 169.50 summer H/C
415 28-Jul Holiday club -N Locke 9 16954.98 155.00 155.00 summer H/C
416 31-Jul Payments -month -17496.61 0.00
417 0 44846.07 16954.98 2997.32 1140.01 7272.97 0.00 4037.37 0.00 0.00 1386.63 91.60 0.00 29.08
418 AUGUST 2022
419 1-Aug Opening bal 44846.07
420 2-Aug VD -Refund for faulty Laptop -returne 10 329.00
421 2-Aug School lottery -monthly receipts 11 83.30 83.30 school lottery
422 2-Aug Holiday club -E Fietsch 12 141.00 141.00 summer H/C
423 3-Aug Session fees,holiday club-Honchar ?? 191.28 74.03 £25 deposit 117.25 summer H/C
424 4-Aug ASC fees -H&M Mason 13 243.00 243.00 Winter term
425 10-Aug Session fees-E&I Hands 14 685.95 685.95 winter term
426 10-Aug New starter deposit -H Staples 15 25.00 25.00 deposit
427 11-Aug Session fees-A Williams 16 920.00 920.00 Autumn term Amazon r
428 16-Aug Amazon refund -Blueroll order 17 9.22 9.22
429 17-Aug Session fees-A Williams 16 422.10 422.10 Autumn term blueroll ord
430 18-Aug P.Mail:2x Session fees; 1 x ASC/B 19 1145.48 1070.78 74.70 ok
431 18-Aug Session fees-L Rejzl 28 120.75 120.75 Autumn term
432 18-Aug Holiday club -H Luke 28 375.00 375.00 summer HC
433 18-Aug ASC fees -R Rejzl 28 426.30 426.30 Autumn term
434 22-Aug Holiday club -B Scopes 20 172.50 172.50 summer H/C
435 23-Aug New starter deposit -C Bastin 21 25.00 25.00 deposit
436 24-Aug New starter deposit -W Dyer 22 25.00 25.00 deposit
437 24-Aug ASC fees -F&A Toomey 23 154.70 154.70 Autumn term F-R walk
438 25-Aug P.Mail:4x Session fees; 24 1759.17 1759.17 Autumn term [of which £40.38=summer term]
439 30-Aug Session fees-O Walker 25 326.25 326.25 Autumn term
440 31-Aug ASC fees -D Jessop 26 112.00 112.00 Autumn term
441 31-Aug New starter deposit -R Dyer 27 25.00 25.00 deposit
442 31-Aug Lottery -paypal -HNC Adjustmt HC 7753.00 36.00 Y-end adjmt 36.00
443 31-Aug Payments -month -16842.48 0.00
444 CLOSING BALANCE 0 35756.59 7753.00 5479.03 1010.70 0.00 0.00 805.75 0.00 0.00 0.00 83.30 0.00 45.22
445 Autumn term 4319 936
446 31-Aug Closing bal per Bank Statement 35756.59
----- End of picture text -----

22 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

Q 1 2 3 4 5 6 Tfr from Dep a/c 7 8 9 10 11 12 13 Food 14 refund 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 0.0 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 fund 50 51 52 53 54 55 56 0.0 57 58 59 60 61 62 63 64 65 66 67 68 refund 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 m £36 85 86 87 88 89 90 91 92 93 0.00

23 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

Q 1 2 3 4 5 6 Tfr from Dep a/c 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108e 109 110 111 112 113 114 115 116 117 118 6500.0 119 date 120 121 122 123 124 125 126 6500.0 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 refund 150 151 refund 152 153 154 155 156 157 158 159 0.0

24 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

Q 1 2 3 4 5 6 Tfr from Dep a/c 160 161 162 163 164 165 1 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 0.0 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 wages 228 refund 229 230cream of 231 in transit 232 233 234 235 236 237 238 239 240 241 0.0

25 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

Q 1 2 3 4 5 6 Tfr from Dep a/c 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 0.0 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 g x1 328 329 330 331 refund 332d folders 333 334 335 336 337 338 339 340 341 0.0 342 343 344 345 346 347 348 349 350 351

26 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

----- Start of picture text -----
Q
1
2
3
4
5
6 Tfr from Dep
a/c
352 e
353
354
355
356
357
358
359
360
361
362 refund
363 ads
364
365
366
367
368
369
370
371
372
373 0.0
----- End of picture text -----

27 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

Q 1 2 3 4 5 6 Tfr from Dep a/c 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 C charger 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 0.0 418 419 420 329.00 421 FA's-refund 422 423 424 425 426 427 efund - 428 429 der 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 329.0 445 446

28 of 67

document7113129172415187496.xls\ Cash Book-RECEIPTS-PRINT

05/24/2023 13:55:53

----- Start of picture text -----
A B C D E F G H I J K L M N O P Q R
1 LYMPSTONE PRE-SCHOOL
2 Year ended 31 August 2022
3
4 General ledger: CB-Exp Cash book-Current a/c: EXPENDITURE
5
6 Staff Stationery Childrens
Wages- recruit/ trg/ /office Toddler equip-
Date Details Chq no. Ref Building society Wages -Net IR -NI & PAYE cleanincasual/ g clothing/leaving pres Hall rental snacksFood/ IT esupplies+ quipmt group exps Insur- ance PLA Mship & Fees ment & books MISC- maint- enance MISC- fund- raising
7 SEPTEMBER 2021
8 1-Sep VD -stamps, snack TFR 49 14.14 9.04 5.10 stamps toiletries
9 6-Sep CA -resources TFR 50 558.70 54.09 73.33 336.15 75.13
10 6-Sep TTS TFR 51 191.94 191.94 learning resources
11 8-Sep Sainsburys -food TFR 52 101.37 101.37
12 9-Sep Giffgaff -mobile SIM contract TFR 53 6.00 6.00 Mobile SIM
13 10-Sep NEST -Pensions -AUG TFR 54 768.16 768.16
14 10-Sep S Briggs -ink/printing TFR 55 16.49 16.49 printer ink
15 10-Sep D Crossman TFR 56 103.91 103.91 Tap repair
16 15-Sep VD-Sundry TFR 57 46.47 9.76 20.98 15.73
17 18-Sep VD -123 Reg m'ship; shed sign TFR 58 5.99 5.99 123 malware
18 21-Sep B Gas -elec TFR 59 130.25 130.25 elec
19 21-Sep BT Group -internet TFR 60 56.94 56.94 internet
20 21-Sep Itunes -Iphne storage TFR 61 0.79 0.79 Apple storage
21 21-Sep Wages-L Everest -Sep TFR 62 122.85 122.85
22 21-Sep Wages-T Oakley -Sep TFR 62 568.23 568.23
23 21-Sep Wages-A Pike -Sep TFR 62 398.48 398.48
24 21-Sep Wages-J Turner -Sep TFR 62 928.65 928.65
25 21-Sep Wages-Kyra Pengilley -Sep TFR 62 829.93 829.93
26 21-Sep Wages-C Foster -Sep TFR 62 508.72 508.72
27 21-Sep Wages -C Armstrong -Sep TFR 62 1509.36 1509.36
28 21-Sep Wages-V Drinkwater -Sep TFR 62 1358.77 1358.77
29 21-Sep Wages-C Fowler-Sep TFR 62 93.00 93.00
30 21-Sep Wages-J Lane-Sep TFR 62 994.06 994.06
31 21-Sep Wages-S de Freitas -Sep TFR 62 945.22 945.22
32 21-Sep Wages-K Kinch -Sep TFR 62 963.06 963.06
33 21-Sep Wages-T McKenzie -Sep TFR 62 337.25 337.25
34 21-Sep Wagex -K McIntyre -Sep TFR 62 1122.31 1122.31
35 21-Sep Wagex -M Wallace -Sep TFR 62 99.00 99.00
36 21-Sep Wagex -C Marlow -Sep TFR 62 135.00 135.00
37 21-Sep Wagex -T Mackie -Sep TFR 62 361.19 361.19
38 21-Sep Wagex -E Welch -Sep TFR 62 145.60 145.60
39 21-Sep LG-shaving foam TFR 63 13.30 13.30 shaving foam
40 21-Sep CA-Sundry items TFR 64 64.74 52.95 11.79 books
41 21-Sep The Consortium TFR 65 120.66 120.66 paints
42 21-Sep KF Bartlett -Aircon service TFR 66 237.60 237.60 Aircon ma
43 21-Sep TTS -sundry equipment TFR 67 381.41 381.41 sand & water tables+p
44 21-Sep HMRC -NI & PAYE -Sept TFR 68 1151.86 1151.86
45 21-Sep VD -Xmas meal deposit TFR 69 61.20
46 22-Sep Sainsburys -food TFR 70 101.55 101.55
47 23-Sep BT Group -dongle TFR 71 12.00 12.00 BT -Dongle
48 23-Sep Thompson Jenner TFR 72 86.40
49 23-Sep KM-Train fare TFR 73 10.35 10.35 train fare
50 23-Sep CA-Sundry items TFR 74 25.94 20.00 trg 5.94 book
51 29-Sep Sainsburys -food TFR 75 63.57 63.57
52 29-Sep Itunes -Ipads storage TFR 76 0.79 0.79 Apple storage
53 29-Sep TFR 0.00
54 Total -month 0 15753.20 11420.68 1920.02 0.00 30.35 205.19 392.33 123.47 0.00 0.00 0.00 1076.92 416.64 0.00
55 OCTOBER 2021
56 4-Oct VD -Laptop equipment TFR 77 62.52 62.52 laptop equipment
57 4-Oct SdeF -cleaning TFR 78 11.14 buttons, chalks, sc 11.14 ceaning
58 4-Oct CA- Sundry items TFR 79 115.97 78.98 36.99 toilet seat
59 4-Oct KM -Sundry items TFR 80 84.32 41.92 42.40ng +maint.
60 4-Oct CA-Sundry items TFR 81 18.28 18.28
61 5-Oct Sainsburys -food TFR 82 75.02 75.02
62 5-Oct VD -sundry items TFR 83 16.59 16.59 cleaning it
63 9-Oct Giffgaff -mobile SIM contract TFR 84 10.00 10.00 mobile phone
64 10-Oct Cgifford -Hoover TFR 85 50.00 50.00 hoover
65 11-Oct VD-Stationery TFR 86 9.89 9.89 laminating pouches
66 11-Oct NEST -Pensions -SEPT TFR 87 352.51 352.51
67 11-Oct HP Ink -office supplies TFR 88 1.99 1.99 HP Ink
68 12-Oct Sainsburys -food TFR 89 69.70 69.70
69 13-Oct S Briggs -ink/printing TFR 90 16.49 16.49 printer ink
70 13-Oct The Consortium TFR 91 191.98 191.98 toys
71 13-Oct CA-Sundry items TFR 92 24.51 6.97 spices 17.54 books
72 13-Oct VD -snack TFR 93 8.49 8.49 snack
73 13-Oct Coldwell Training -3 x staff TFR 94 320.00 320.00 F. Aid trg x3
74 13-Oct Early Years Alliance TFR 95 40.00 40.00 Educare -additonal places
75 13-Oct Learning Journal -annual fee TFR 96 504.00 504.00 Annual fee
76 14-Oct Amazon -toy TFR 97 9.99 9.99 toys
77 15-Oct Safer Food Group -level 2 -KM TFR 98 14.40 14.40 Safer Food group -level 2 -KM
78 18-Oct Amazon -toy TFR 99 7.99 7.99 Sundry
79 19-Oct Anglian water -bill TFR 100 128.14 128.14 water
80 19-Oct VD -123 Reg m'ship; shed sign TFR 1 20.38 20.38 123 malware
81 19-Oct S de F -honey TFR 2 3.98 3.98 honey
82 19-Oct HNC Accounting Solutions Ltd TFR 3 291.00
83 19-Oct The Consortium TFR 4 171.59 171.59 table
84 19-Oct Total Tee -childrens' uniform TFR 5 12.40 12.40
85 19-Oct Sainsburys -food TFR 6 69.84 69.84
86 20-Oct C Marlow -sundry items TFR 7 8.94 8.94 sundry
87 20-Oct VD -Sundy items TFR 8 13.65 13.65
88 21-Oct BG Business TFR 122.98 122.98 Elec
89 21-Oct BT Group TFR 56.94 56.94 tel
90 21-Oct Wages-L Everest -Oct TFR 10 104.65 104.65
91 21-Oct Wages-S de Freitas -Oct TFR 10 1165.13 1165.13
92 21-Oct Wages-T Oakley -Oct TFR 10 917.20 917.20
93 21-Oct Wages-A Pike -Oct TFR 10 595.79 595.79
94 21-Oct Wages-J Turner -Oct TFR 10 1051.33 1051.33
95 21-Oct Wages-Kyra Pengilley -Oct TFR 10 843.10 843.10
96 21-Oct Wages-C Foster -Oct TFR 10 544.62 544.62
97 21-Oct Wages -C Armstrong -Oct TFR 10 1618.32 1618.32
98 21-Oct Wages-V Drinkwater -Oct TFR 10 1491.52 1491.52
99 21-Oct Wages-KKinch-Oct TFR 10 1145.29 1145.29
100 21-Oct Wages-J Lane--Oct TFR 10 1072.10 1072.10
101 21-Oct Wages-M Wallace -Oct TFR 10 122.94 122.94
102 21-Oct Wages -T McKenzie -Oct TFR 10 721.71 721.71
103 21-Oct Wagex -K McIntyre -Oct TFR 10 1223.08 1223.08
104 21-Oct Wagex -E Welch -Oct TFR 10 522.69 522.69
105 21-Oct Wagex -T Mackie -Oct TFR 10 721.71 721.71
106 21-Oct Wagex -C Fowler -Oct TFR 10 662.63 662.63
107 21-Oct Wagex -C Marlow -Oct TFR 10 835.53 835.53
108 21-Oct HMRC -NI & PAYE -Oct TFR 11 1980.93 1980.93
109 21-Oct Parental Mal -annual renewal TFR 14 818.88 818.88 P-Mail annual fee ASC game
110 23-Oct Giffgaff -mobile SIM contract TFR 15 10.00 10.00 mobile phone
111 25-Oct BT Group -rental DD 16 12.00 12.00 BT line
112 26-Oct K Billing -training TFR 17 24.00 24.00 trg
113 28-Oct KM -training TFR 18 35.00 35.00 trg
114 30-Oct TFR 0.00
115 Total -month 0 21155.77 15359.34 2333.44 0.00 433.40 340.06 247.65 930.15 0.00 0.00 504.00 547.21 157.12 12.40
116 NOVEMBER 2021
117 30-Oct Itunes -Ipads storage TFR 19 0.79 0.79 Apple storage
118 1-Nov Giffgaff -mobile SIM contract TFR 20 10.00 10.00 mobile
119 2-Nov Sainsburys -food TFR 21 111.06 111.06
120 3-Nov Currys online -new printer TFR 22 124.99 124.99 new printer
121 4-Nov Giffgaff -mobile SIM contract TFR 23 10.00 10.00 mobile
05/24/2023 13:55:53 29 of 67 document7113129172415187496.xls\ Cash Book-EXPENSES-PRINT
----- End of picture text -----

30 of 67