**----- Start of picture text -----**
2020/21 Invoiced Playgroup Fees
Child Name L/Y 09/20 10/20 11/20 12/20 01/21 02/21 03/21 04/21 05/21 06/21 07/21 Total
£0.00
George Broderick Jones £61.50 £137.00 £138.00 £72.00 £0.00 £0.00 £0.00 £0.00 £408.50
Leia-Ray Clutton £320.00 £266.50 £348.50 £225.50 £123.00 £225.00 £287.00 £287.00 £2,082.50
Francesca Laurito £200.00 £143.50 £184.50 £102.50 £164.00 £102.50 £143.50 £143.50 £1,184.00
Jacob Haughton-Madeley £150.50 £208.50 £246.00 £184.50 £0.00 £0.00 £0.00 £0.00 £789.50
Harriet Curtis £39.50 £36.00 £60.00 £0.00 £20.50 £61.50 £61.50 £279.00
Luca Efthymiou £34.00 £43.00 £36.00 £24.00 £48.00 £36.00 £221.00
Grace Bratherton £61.50 £0.00 £0.00 £0.00 £0.00 £61.50
Alfie Waters £114.50 £0.00 £61.50 £54.70 £61.50 £292.20
Eva and Jake Marshall £17.00 £0.00 £0.00 £0.00 £0.00 £17.00
Eric Gill £93.50 £188.00 £164.00 £205.00 £225.50 £876.00
Talia Thomas £150.00 £155.00 £164.00 £205.00 £225.50 £899.50
Wilfie Williams £34.00 £25.50 £42.50 £51.00 £153.00
Alfie Halley £31.50 £0.00 £0.00 £31.50
Louie Edmund Loughlin £93.50 £59.50 £153.00
Oliver Ward £136.00 £119.00 £255.00
Othello Parry-Robotham £61.50 £184.50 £246.00
Elizabeth Jennion £172.50 £225.50 £398.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
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
£0.00
Totals £0.00 £732.00 £856.50 £987.00 £1,062.50 £0.00 £0.00 £700.00 £818.50 £1,510.70 £1,680.00 £0.00 £8,347.20
**----- End of picture text -----**
**----- Start of picture text -----**
PAYMENTS: 01/21
Cheque Write Off PPA - Bounced HM Revenue TOTAL BANK
Date No. Payee Wages Hall Fees Fundraising Photographs Training Equipment Petty Cash Other Fees Membership Trips/Party Audit chqs & customs Uniform XX PAYMENTS BALANCE
0.00 Opening 10,486.53
25.01.21 Wirehouse 114.00 114.00
29.01.21 Zoe McWilliams 432.87 432.87
29.01.21 Kelly Credido 407.22 407.22
29.01.21 Sarah Jones 564.85 564.85
29.01.21 Helen Jowett 626.04 626.04
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
0.00
0.00
0.00
2,030.98 0.00 0.00 0.00 0.00 0.00 0.00 114.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,144.98 Closing 10,018.16
**----- End of picture text -----**
**HOLT UNDER FIVES 2020-2021** ## **INCOME AND EXPENDITURE ACCOUNT** **----- Start of picture text -----**
09/20 10/20 11/20 12/20 01/21 02/21 03/21 04/21 05/21 06/21 07/21 08/21 TOTALS
INCOME: Playgroup Fees 732.00 856.50 987.00 1,062.50 0.00 0.00 700.00 818.50 1,510.70 1,680.00 0.00 0.00 8,347.20
Toddlers 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
Funding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 794.25 207.00 751.50 0.00 1,752.75
Grants 0.00 0.00 0.00 0.00 0.00 0.00 7,711.49 0.00 0.00 0.00 0.00 0.00 7,711.49
Photographs/commision 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
Donations 0.00 500.00 0.00 0.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00
Fundraising 0.00 280.90 579.40 14.00 251.20 0.00 0.00 0.00 0.00 468.17 0.00 0.00 1,593.67
Insurance 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
Catelogue Money 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
Other 0.00 0.00 0.00 190.00 0.00 155.00 0.00 998.00 0.00 0.00 0.00 0.00 1,343.00
Returned Petty Cash 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
Playgroup Fees Returned 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
xx 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,082.56 664.19 483.74 2,230.49
Bank Interest 0.09 0.09 0.09 0.09 0.36
TOTALS 732.09 1,637.49 1,566.49 1,266.59 751.20 155.00 8,411.49 1,816.50 2,304.95 3,437.73 1,415.69 483.74 23,978.60
EXPENDITURE: Wages 2,412.22 2,897.98 2,485.72 2,079.88 2,015.18 1,945.58 2,199.22 2,280.11 2,887.48 21,203.37
Furlough Claim (972.66) (777.41) (626.04) (831.91) (2,015.18) (1,945.58) (1,268.50) (975.29) (9,412.57)
Hall Hire 420.00 420.00 510.00 330.00 0.00 0.00 1,680.00
Fundraising 0.00 135.00 192.70 20.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 347.70
Photographs 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
Training 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
Equipment 80.19 19.99 78.86 33.93 0.00 0.00 170.74 1,544.74 579.15 575.75 139.98 0.00 3,223.33
Petty Cash 0.00 15.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.00
Other 207.16 114.00 114.00 114.00 114.00 114.00 114.00 3,885.19 114.00 1,435.24 66.00 66.00 6,457.59
Write off Fees 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
PPA - Membership 0.00 0.00 0.00 0.00 0.00 0.00 0.00 294.49 0.00 0.00 0.00 0.00 294.49
Trips/Party 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
Audit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 100.00
Bounced Chq 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
Employers NI * 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
Uniform 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
xx 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
TOTALS 2,146.91 2,824.56 2,755.24 1,745.90 114.00 114.00 1,215.46 7,029.24 3,580.63 2,110.99 205.98 66.00 23,908.91
PROFIT/(LOSS) - Month (1,414.82) (1,187.07) (1,188.75) (479.31) 637.20 41.00 7,196.03 (5,212.74) (1,275.68) 1,326.74 1,209.71 417.74 69.69
PROFIT/(LOSS) - Yr to Date (1,414.82) (2,601.89) (3,790.64) (4,269.95) (3,632.75) (3,591.75) 3,604.28 (1,608.46) (2,884.14) (1,557.40) (347.69) 70.05 70.05
BALANCE SHEET 24,429.08 23,014.26 21,827.19 20,638.44 20,159.13 20,796.33 20,837.33 28,033.36 22,820.62 21,544.94 22,871.68 24,081.39 24,499.13 24,499.13
**----- End of picture text -----**
document7880710675797085246.xlsx 2020-21 Income & Expenditure 06/30/2022 11:59:39 **HOLT UNDER FIVES 2020-2021** **QTR 1** ## **BALANCE SHEET** **----- Start of picture text -----**
1 1 1
BAL SHEET Transactions BAL SHEET Transactions BAL SHEET Transactions BAL SHEET
01.09.20 09/20 30.09.20 10/20 31.10.20 11/20 30.11.20
Dr Cr Dr Cr Dr Cr Dr Cr Dr Cr Dr Cr Dr Cr
Bank: Current Account 11,364.61 3,363.46 2,768.99 11,959.08 3,522.47 3,099.68 12,381.87 1,520.40 2,940.37 10,961.90
Bank: Deposit Account 10,769.33 0.09 10,769.42 0.09 10,769.51 0.09 10,769.60
Cash 0.00 0.00 0.00
Creditors: Wxm CBC Hall Fees 510.00 0.00 420.00 930.00 0.00 420.00 1,350.00 0.00 510.00 1,860.00
Fundraising 0.00 0.00 0.00
Furlough Claim 2,892.96 972.66 2,892.96 972.66 777.41 1,750.07 (0.00) 626.04 626.04
Wages Due 2,393.82 2,393.82 0.00 2,797.29 2,797.29 0.00 2,454.12 2,454.12 0.00
HMRC Nat Ins 'ees 65.02 65.02 0.00 0.00 33.29 33.29 33.29 0.00 0.00
HMRC Nat Ins 'ers 0.00 0.00 0.00 0.00 0.00
HMRC Nat Ins Totals
HMRC Tax 22.80 22.80 18.40 18.40 18.40 67.40 67.40 67.40 31.60 31.60
Debtors: Playgroup Fees Due 732.00 470.50 261.50 856.50 991.50 126.50 987.00 941.00 172.50
Photographs 0.00 0.00 0.00 0.00 0.00 0.00
Reserves 24,429.08 1,414.82 23,014.26 1,187.07 21,827.19 1,188.75 20,638.44
TOTALS 25,026.90 25,026.90 8,964.67 8,964.67 23,962.66 23,962.66 9,159.23 9,159.23 23,277.88 23,277.88 6,877.09 6,877.09 22,530.04 22,530.04
0.00 ü 0.00 0.00 ü 0.00 0.00 ü 0.00 0.00 ü
**----- End of picture text -----**
**HOLT UNDER FIVES 2020-2021** **QTR 2** ## **BALANCE SHEET** **----- Start of picture text -----**
1 1 1
BAL SHEET Transactions BAL SHEET Transactions BAL SHEET Transactions BAL SHEET
01.12.20 12/20 31.12.20 01/21 31.01.21 02/21 28.02.21
Dr Cr Dr Cr Dr Cr Dr Cr Dr Cr Dr Cr Dr Cr
Bank: Current Account 10,961.90 1,809.04 2,284.41 10,486.53 1,676.61 2,144.98 10,018.16 2,242.18 2,081.58 10,178.76
Bank: Deposit Account 10,769.60 0.09 10,769.69 0.00 10,769.69 0.00 10,769.69
Cash 0.00 0.00 0.00 0.00
Creditors: Wxm CBC Hall Fees 1,860.00 0.00 330.00 2,190.00 0.00 0.00 2,190.00 0.00 0.00 2,190.00
Fundraising 0.00 0.00 0.00 0.00
Furlough Claim 626.04 831.91 626.04 831.91 2,015.18 831.91 2,015.18 1,945.58 2,015.18 1,945.58
Wages Due 0.00 2,084.88 2,084.88 0.00 2,030.98 2,030.98 0.00 1,967.58 1,967.58 0.00
HMRC Nat Ins 'ees 0.00 0.00 0.00 0.00
HMRC Nat Ins 'ers 0.00 0.00 0.00 0.00
HMRC Nat Ins Totals
HMRC Tax 31.60 31.60 (5.00) (5.00) (15.80) (20.80) (22.00) (42.80)
0.00
Debtors: Playgroup Fees Due 172.50 1,062.50 979.00 256.00 0.00 93.50 162.50 0.00 72.00 90.50
Photographs 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Reserves 20,638.44 479.31 20,159.13 637.20 20,796.33 41.00 20,837.33
TOTALS 22,530.04 22,530.04 6,299.33 6,299.33 22,344.13 22,344.13 5,722.77 5,722.77 22,965.53 22,965.53 6,155.34 6,155.34 22,984.53 22,984.53
0.00 ü 0.00 0.00 ü 0.00 0.00 ü 0.00 0.00
**----- End of picture text -----**
## **- HOLT UNDER FIVES 2020 2021** **----- Start of picture text -----**
1
BAL SHEET Transactions BAL S
01.03.21 03/21 31.0
Dr Cr Dr Cr Dr
Bank: Current Account 10,178.76 10,169.07 2,498.16 17,849.67
Bank: Deposit Account 10,769.69 0.00 10,769.69
Cash 0.00
Toddlers Float 0.00
Creditors: Wxm CBC Hall Fees 2,190.00 0.00 0.00
Fundraising
Furlough Claim 1,945.58 1,268.50 1,945.58 1,268.50
Wages Due 0.00 2,213.42 2,213.42
HMRC Nat Ins 'ees 0.00
HMRC Nat Ins 'ers 0.00
HMRC Nat Ins Totals 0.00
HMRC Tax (42.80) (14.20)
Debtors: Playgroup Fees Due 90.50 700.00 512.00 278.50
**----- End of picture text -----**
Photographs **0.00 0.00** Reserves **20,837.33** 7,196.03 **TOTALS 22,984.53 22,984.53** 14,350.99 14,350.99 **30,166.36** 0.00 0.00 0.00 e **----- Start of picture text -----**
QTR 3
**----- End of picture text -----**
## **BALANCE SHEET** **----- Start of picture text -----**
1 1
SHEET Transactions BAL SHEET Transactions BAL SHEET
03.21 04/21 30.04.21 05/21 31.05.21
Cr Dr Cr Dr Cr Dr Cr Dr Cr
2,762.00 8,004.53 12,607.14 3,060.74 3,542.22 12,125.66
0.00 10,769.69 0.00 10,769.69
0.00 0.00
0.00 0.00
2,190.00 0.00 0.00 2,190.00 0.00 0.00 2,190.00
975.29 1,268.50 975.29 975.29 0.00
0.00 2,280.11 2,280.11 0.00 2,849.07 2,849.07 0.00
0.00 0.00 19.01 19.01
0.00 0.00 0.00
0.00 0.00 0.00
(57.00) (57.00) 19.40 (37.60)
818.50 495.50 601.50 1,510.70 1,291.20 821.00
**----- End of picture text -----**
|**28,033.36**|5,212.74||**0.00**|**22,820.62**|1,275.68||**0.00**|**21,544.94**| |---|---|---|---|---|---|---|---|---| |**30,166.36**|12,048.64|12,048.64|**24,953.62**|**24,953.62**|8,696.19|8,696.19|**23,716.35**|**23,716.35**| |||||||||| |0.00
0.00
0.00
0.00
e
e||||||||| ## **- HOLT UNDER FIVES 2020 2021** **----- Start of picture text -----**
1
BAL SHEET Transactions BAL S
01.06.21 06/21 30.0
Dr Cr Dr Cr Dr
Bank: Current Account 12,125.66 12,125.66
Bank: Deposit Account 10,769.69 10,769.69
Cash 0.00
Toddlers Float 0.00
Creditors: Wxm CBC Hall Fees 2,190.00
Fundraising
Furlough Claim 1,945.58 1,945.58
Wages Due 0.00
HMRC Nat Ins 'ees 19.01
HMRC Nat Ins 'ers 0.00
HMRC Nat Ins Totals 0.00
HMRC Tax (37.60)
Debtors: Playgroup Fees Due 821.00 821.00
**----- End of picture text -----**
Photographs **0.00** Reserves **21,544.94 TOTALS 25,661.93 23,716.35** 0.00 0.00 **25,661.93** 1,945.58 0.00 1,945.58 ## **BALANCE SHEET** **----- Start of picture text -----**
1 1
SHEET Transactions BAL SHEET Transactions BAL S
6.21 07/21 31.07.21 08/21 31.0
Cr Dr Cr Dr Cr Dr Cr Dr
12,125.66 12,125.66
10,769.69 10,769.69
0.00 0.00
0.00 0.00
2,190.00 2,190.00
1,945.58 1,945.58
0.00 0.00
19.01 19.01
0.00 0.00
0.00 0.00
(37.60) (37.60)
821.00 821.00
**----- End of picture text -----**
|**21,544.94**|||**0.00**|**21,544.94**|||**0.00**| |---|---|---|---|---|---|---|---| |**23,716.35**|0.00|0.00|**25,661.93**|**23,716.35**|0.00|0.00|**25,661.93**| ||||||||| |0.00
1,945.58
0.00
1,945.58|||||||| **----- Start of picture text -----**
QTR 4
**----- End of picture text -----**
**SHEET 8.21** Cr **2,190.00 0.00 0.00 19.01 0.00 0.00 (37.60)** 21,544.94 23,716.35 ## **- HOLT UNDER FIVES 2019 2020** ## **1st September 2019 - 31st August 2020** ## **INCOME & EXPENDITURE ACCOUNT** |**INCOME:**
Playgroup Fees
Toddlers
Funding
Grants
Photographs/commision
Donations
Fundraising
Insurance
Catelogue Money
Other
Returned Petty Cash
Training
xx
Bank Interest
**EXPENDITURE:**
Wages
Hall Hire
Fundraising
Photographs
Training
Equipment
Petty Cash
Other
Write of Fees|2019/20
£
21,203.37
1,680.00
347.70
0.00
0.00
3,223.33
15.00
6,457.59
0.00|2019/20
£
0.00
0.00
1,752.75
7,711.49
0.00
1,000.00
1,593.67
0.00
0.00
1,343.00
0.00
0.00
2,230.49
0.36|2018/19
£
28,429.21
5,535.00
2,556.47
113.75
300.40
561.47
2,090.80
727.06
0.00|2018/19
£
11,960.85
735.32
27,057.75
0.00
130.00
0.00
8,034.99
0.00
0.00
1,084.04
0.00
0.00
0.00
77.40| |---|---|---|---|---| document7880710675797085246.xlsx Annual Statement 06/30/2022 11:59:40 |PPA - Membership
Trips/Party
Audit
Bounced Chq
HM Customs
Uniform
xx
Surplus for Year|294.49
0.00
100.00
0.00
0.00
0.00
0.00
33,321.48
15,631.76
(17,689.72)
15,631.76
15,631.76|158.00
283.30
0.00
0.00
0.00
0.00
0.00| |---|---|---| |||40,755.46
49,080.35
8,324.89| |||49,080.35
49,080.35| ## **- HOLT UNDER FIVES 2019 2020** ## **1st September 2019- 31st August 2020** ## **BALANCE SHEET** |Bank - Current Account
Bank - Deposit Account
Cash
Bank and Cash in Hand
Other Debtors:
Playgroup Fees Due||2018/19
£
12,125.66
10,769.69
0.00
22,895.35
0.00
821.00||2017/18
£
13,561.39
10,710.20
0.00| |---|---|---|---|---| |||||24,271.59
0.00
664.70| document7880710675797085246.xlsx Annual Statement 06/30/2022 11:59:40 |Photographs
Total Assets
Other Creditors:
Wrexham CBC - Hall Fees
Fundraising
Inland Revenue - PAYE
Inland Revenue Nat Ins
Playgroup Fees Overpd
Total Creditors
Net Assets
Financed by:
Surplus / (Defcit) B/fwd
Surplus / (Defcit) for Year|0.00
23,716.35
0.00
2,190.00
0.00
(37.60)
0.00
2,152.40
21,563.95
0.00
0.00
0.00|0.00| |---|---|---| |||24,936.29
0.00
90.00
0.00
21.80
81.21| |||193.01| |||24,743.28| |||16,418.39
8,324.89| |||24,743.28| document7880710675797085246.xlsx Annual Statement 06/30/2022 11:59:40 ## **- HOLT UNDER FIVES 2010 2011** ## **POSTING INSTRUCTIONS** ## Postings to the _**Income & Expenditure Account**_ and _**Balance Sheet**_ are made from the _**Ca Bank Current Account**_ . Provided the Cash Book and Bank Account are balanced and have the required information th be straight forward. There are, as always with accounting, exceptions! These are categories where the actual exp expenditure is not fully received or paid in the month - then they become Balance Sheet item The three categories evident so far are **Playgroup Fees** , **Wages** and **Hall Fees** and the actu these are posted to both the Balance Sheet and I & E Account as follows: **FIRST** _**Category From Posting 1**_ **Playgoup Fees- Detailed Fees Spreadsheet Balance SheetDr I & E Ac Wages - Detailed Wages Spreadsheet Balance SheetCr I & E Ac Hall Fees Wrexham CBC Invoice Balance SheetCr I & E Ac** Then the monthly actual amounts paid and received for the above are posted from the _**Cash**_ document7880710675797085246.xlsx Posting Instructions 06/30/2022 11:59:40 p ## y ## p ## _**Account**_ to the _**Balance Sheet**_ , as follows:. ## **SECOND** **Playgoup Fees** ## **Balance SheetCr** ## **Wages** ## **Balance SheetDr** ## **Hall Fees** ## **Balance SheetDr** The best way to start the month's figures would be by doing the **FIRST** set of postings above spreadsheets/invoice to the Balance Sheet and I & E Account. Then, for these three categorie receipts or payments (Cash & Bank) straight to the **Balance Sheet.** as per the **SECOND** pos Continue then to post all receipts and payments (Cash and Bank) straight to the I & E Accoun **Total Cash** and **Total Bank** receipts and payments to the Balance Sheet . The last entry is to post the _**Month's**_ Profit or Loss from the I & E A/c to the Balance Sheet (Re should then make the DR and CR columns in the Balance Sheet to equal each other exactly. The only thing remaining is to put the number **"1"** in row 5 in the Balance Sheet above the B **Then just sit back and watch the balances appear miraculously in front of your eyes** document7880710675797085246.xlsx Posting Instructions 06/30/2022 11:59:40 ## _**ash Book**_ and detailed en the posting should pected income or s. ual figures expected for ## _**Posting 2**_ ## **ccount Income** ## **ccount Expenditure** ## **ccount Expenditure** ## _**Book**_ & _**Bank**_ document7880710675797085246.xlsx Posting Instructions 06/30/2022 11:59:40 from the relevant es only, post any tings. t before posting the eserves). This posting BALSHEET Dr cloumn. **s!! JOB DONE!!** document7880710675797085246.xlsx Posting Instructions 06/30/2022 11:59:40