OpenCharities

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

2021-08-31-accounts

----- 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