J c£ ¢ c ro 2 ) 3 c rts o ffl qj Jt J ¢D'E ¢1 Ll- Jilki c&ffj£ O£z5 SfL££xo (nojtj )££￿ o w OJ c o) ictiwt L￿cEc() c>£ ¢DCJC IN (Q f Ln LO a) o o I Date Details amount File ref File ref 1 2 **Only the date entry and opening balances in this row No entries in this row** 09/01/2020 Stripe 1236.13 09/07/2020 Asda George 670.5 09/08/2020 School Lottery 117.7 09/09/2020 Sumup 66.36 09/15/2020 School Lottery 15.3 09/15/2020 Zeco 1323.55 09/16/2020 Sumup 438.95 09/22/2020 Sumup 272.3 09/22/2020 School Lottery 15.6 09/22/2020 Eye Image UK Embroidery 384 09/29/2020 School Lottery 15.6 09/29/2020 Sumup 42.76 10/01/2020 Stripe 2542.5 10/06/2020 Sumup 93.89 10/06/2020 Queens Theatre Refund 1267.5 10/07/2020 Stripe 186.62 Refunds 10/09/2020 Zeco 345.2 10/12/2020 School Lottery 84 10/28/2020 Bank Credit 467.9 10/28/2020 Bank Credit 1244.28 10/28/2020 Sumup 57.02 10/29/2020 School Lottery 31.8 11/02/2020 Stripe 134.25 11/03/2020 School Lottery 15.9 11/03/2020 Costco - Ribbon 7.99 11/10/2020 School Lottery 100.7 11/18/2020 Compensation from bank 100 12/01/2020 Stripe 663.92 12/07/2020 Zeco 624.7 12/09/2020 School Lottery 100.4 12/09/2020 Tesco 178.89 12/14/2020 Tesco 19 12/14/2020 Cash Withdrawal 200 12/15/2020 Sumup 16.22 12/16/2020 School Lottery 14.1 12/17/2020 Tesco 117 12/17/2020 B&M 5.1 12/17/2020 B&M 15.61 12/21/2020 Tesco 15 12/23/2020 Sumup 7.86 01/04/2021 Stripe 1258 01/05/2021 School Lottery 75.2 01/05/2021 Stripe 77.5 refunds 01/12/2021 School Lottery 14.1 01/18/2021 M Haynes - HLP School fundraising 200.5 02/01/2021 Stripe 67.96 02/02/2021 School Lottery 70.8 02/08/2021 Costco - Membership 43.2 02/11/2021 Amazon 18.99 02/16/2021 School Lottery 13.2 03/01/2021 Stripe 59.45 03/02/2021 Groupon 71.97 03/02/2021 Something Different Wholesale 119.88 03/03/2021 School Lottery 83.6 03/04/2021 Poundland 288.5 03/04/2021 B&M 52 03/04/2021 Home Bargains 273.3 03/05/2021 Wilko 53 03/08/2021 Tesco 300 03/08/2021 One Below 67 03/08/2021 Poundland 20 03/08/2021 Poundland 90 03/08/2021 Poundstretcher 42.96 03/08/2021 Poundland 60 03/08/2021 Poundland 47 03/09/2021 Sumup 73.24 03/09/2021 Sainsburys 16.5 03/09/2021 Asda 60.68 03/09/2021 B&M 113.8 03/15/2021 Wilko 53 refund 03/16/2021 School Lottery 13.5 03/16/2021 Sumup 73.24 03/23/2021 Sumup 80.61 03/29/2021 The Range 28.01 03/29/2021 Poundland 9.1 03/29/2021 Asda 10 03/29/2021 Tesco 11.9 03/30/2021 Sumup 48.66 03/30/2021 Amazon 8.69 03/30/2021 Poundland 10 04/01/2021 Stripe 782.73 04/06/2021 credit - xmas cards - Mrs Waddington 232.75 04/06/2021 credit - panto 965 04/06/2021 credit - xmas raffle 349.5 04/06/2021 credit - DVD sales 80 04/06/2021 credit - mothers day 1409.35 04/06/2021 credit - coin wars 400.47 04/06/2021 credit - breakfast with santa 78.7 04/06/2021 credit - donation snowflakes 158 04/06/2021 credit - egg hunt 518.62 04/06/2021 credit - egg hunt 145 04/06/2021 credit - panto 150 04/06/2021 credit - egg comp 47.5 04/06/2021 credit - raffle 172.4 04/06/2021 credit - raffle 305.2 04/06/2021 Sumup 36.37 04/06/2021 credit - Uniform 120 04/06/2021 credit - Uniform 228.45 04/06/2021 debit - reindeer/panto 670 04/07/2021 School Lottery 90 04/07/2021 Unpaid Cheque - Waddington 222.14 04/12/2021 Parentkind - Membership 123 04/14/2021 Asda George 1200 04/26/2021 Eye Image UK Embroidery 499.2 04/27/2021 Zeco 1802.9 04/28/2021 Sumup 118.46 05/04/2021 Stripe 279.89 05/05/2021 Sumup 41.29 05/11/2021 School Lottery 83.9 05/12/2021 Sumup 154.34 05/24/2021 Amazon Smile 13.14 credit 05/25/2021 Sumup 188.76 06/01/2021 Stripe 534.03 06/02/2021 Sumup 107.16 06/08/2021 School Lottery 13.2 06/11/2021 School Lottery 100.1 06/15/2021 Sumup 13.76 06/16/2021 Card Factory 16.83 06/16/2021 Home Bargains 202.68 06/16/2021 Card Factory 127.17 06/16/2021 Card Factory 39.8 06/16/2021 Poundland 533 06/17/2021 Amazon 10.99 06/17/2021 Cash Withdrawal - FD Float 60 06/17/2021 Cash Withdrawal - FD Float 40 06/18/2021 Cash Withdrawal - FD Float 240 06/21/2021 Asda George 842 06/22/2021 Sumup 87.01 06/23/2021 Actifwear - Leavers Hoodies 509.45 06/24/2021 Asda George 680 07/01/2021 Stripe 804.06 07/01/2021 Eye Image UK Embroidery 609.6 07/05/2021 Asda George 24 refund 07/05/2021 Asda George 28 refund 07/05/2021 Asda George 12 refund 07/05/2021 Asda George 18 refund 07/05/2021 Asda George 6 refund 07/05/2021 Asda George 8 refund |07/05/2021|Asda George|6|refund| |---|---|---|---| |07/05/2021|Asda George|36|refund| |07/05/2021|Asda George|42|refund| |07/05/2021|Asda George|6|refund| |07/05/2021|Asda George|18|refund| |07/05/2021|Asda George|12|refund| |07/05/2021|Asda George|6|refund| |07/05/2021|Asda George|12|refund| |07/05/2021|Asda George|36|refund| |07/05/2021|Asda George|12|refund| |07/05/2021|Asda George|18|refund| |07/05/2021|Asda George|36|refund| |07/05/2021|Asda George|6|refund| |07/05/2021|Asda George|24|refund| |07/05/2021|Asda George|16|refund| |07/05/2021|Asda George|18|refund| |07/06/2021|Sumup|65.37|| |07/06/2021|School Lottery|68.4|| |07/16/2021|Amazon - leavers|45.73|| |07/20/2021|Iceland|36.5|| |07/20/2021|Amazon cellophane|12.32|| |07/21/2021|Iceland|12|refund| |07/21/2021|Iceland|35.5|| |07/26/2021|credit - bubble bounce|293.15|| |07/26/2021|credit - rafe|352|| |07/26/2021|credit - school council|423.38|| |07/26/2021|credit - fathers day|1568.35|| |07/26/2021|credit - rafe/school council|285|| |07/27/2021|School Lottery|12.9|| |07/27/2021|Sumup|169.1|| |07/27/2021|Harrow Lodge - Playground|20000|| |07/28/2021|Liberty Centre - Parking for Bank|4|| |08/02/2021|Stripe|2548.6|| |08/03/2021|School Lottery|68.8|| |08/11/2021|Asda George|210|| |08/17/2021|Amazon Smile|23.94|credit| |08/18/2021|Sumup|271.34|| |08/31/2021|Zeco|2516|| |08/31/2021|Costco|14.37|| Copy this row and insert where you need an extra row. More than 1 bla **No entries in this row** Date Details amount **I N C O M** Uniform _Lottery_ Adventure _Fathers Easter_ Xmas Events Island _Day Events_ ||**No entries in this row**|| |---|---|---| |1,236.13||| ||117.70|| |66.36||| ||15.30|| |438.95||| |272.30||| ||15.60|| ||15.60|| |42.76||| |2,519.53||| |93.89||| |37.38||| ||84.00|| |467.90||| |1,244.28||| |57.02||| ||31.80|| |134.25||| ||15.90|| ||100.70|| |398.45||105.33| ||100.40|| |16.22||| ||14.10|| |7.86||| |948.74||305.73| ||75.20|| 14.10 67.96 70.80 18.99 13.20 59.45 83.60 73.24 13.50 73.24 80.61 48.66 782.73 349.50 78.70 158.00 518.62 145.00 47.50 172.40 305.20 36.37 120.00 228.45 90.00 118.46 279.89 41.29 83.90 154.34 188.76 534.03 107.16 13.20 100.10 13.76 87.01 716.56 24.00 28.00 12.00 18.00 6.00 8.00 6.00 36.00 42.00 6.00 18.00 12.00 6.00 12.00 36.00 12.00 18.00 36.00 6.00 24.00 16.00 18.00 65.37 68.40 352.00 1,568.35 150.00 12.90 169.10 2,258.10 68.80 271.34 nk row can be copied and inserted at any time. Always choose insert copied cell **No entries in this row** **14,957.90 1,218.80 - 1,568.35 1,709.71 997.26** |**E**
**£ -**
Panto
Misc
Cash
-
**No entries**
**in this col.**
**Current**
**balance**
Mothers
Day Stalls
Bubble
Bounce
Total
income
**Steve.**Enter cash
|**£ -**

**Current**
**balance**|**£ -**

**Current**
**balance**|**£ -**

**Current**
**balance**| |---|---|---|---| |||-
**Steve.**Enter cash
|| |**No entries in this row**

any) at start of per||any) at start of per|| |1,236.13
-
117.70
66.36
15.30
-
438.95
272.30
15.60
-
15.60
42.76
22.98
2,542.51
93.89
1,267.50
1,267.50
37.38
-
84.00
467.90
1,244.28
57.02
31.80
134.25
15.90
-
100.70
100.00
100.00
160.14
663.92
-
100.40
-
-
-
16.22
14.10
-
-
-
-
7.86
56.53
1,311.00
75.20|||| ||||-| |---|---|---|---| ||||14.10| ||200.50||200.50| ||||67.96| ||||70.80| ||||-| ||||18.99| ||||13.20| ||||59.45| ||||-| ||||-| ||||83.60| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||73.24| ||||-| ||||-| ||||-| |||53.00|53.00| ||||13.50| ||||73.24| ||||80.61| ||||-| ||||-| ||||-| ||||-| ||||48.66| ||||-| ||||-| ||||782.73| ||232.75||232.75| |965.00|||965.00| ||||349.50| ||80.00||80.00| |||1,409.35|1,409.35| ||400.47||400.47| ||||78.70| ||||158.00| ||||518.62| ||||145.00| |---|---|---|---| |150.00|||150.00| ||||47.50| ||||172.40| ||||305.20| ||||36.37| ||||120.00| ||||228.45| ||||-| ||||90.00| ||||-| ||||-| ||||-| ||||-| ||||-| ||||118.46| ||||279.89| ||||41.29| ||||83.90| ||||154.34| ||13.14||13.14| ||||188.76| ||||534.03| ||||107.16| ||||13.20| ||||100.10| ||||13.76| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||-| ||||87.01| ||||-| ||||-| |||87.50|804.06| ||||-| ||||24.00| ||||28.00| ||||12.00| ||||18.00| ||||6.00| ||||8.00| |||6.00|| |---|---|---|---| |||36.00|| |||42.00|| |||6.00|| |||18.00|| |||12.00|| |||6.00|| |||12.00|| |||36.00|| |||12.00|| |||18.00|| |||36.00|| |||6.00|| |||24.00|| |||16.00|| |||18.00|| |||65.37|| |||68.40|| |||-|| |||-|| |||-|| ||12.00|12.00|| |||-|| ||293.15|293.15|| |||352.00|| |423.38||423.38|| |||1,568.35|| |135.00||285.00|| |||12.90|| |||169.10|| |||-|| |4.00||4.00|| ||290.50|2,548.60|| |||68.80|| |||-|| |23.94||23.94|| |||271.34|| |||-|| |||-|| |||-|| |||-|| |||-|| |||-|| |||-|| |ls and not paste from the right click drop down menu.||-|| |**No entries in this row**|||| |**2,622.15 1,613.18 1,462.35**|**683.15**|**26,832.85**|**-**| ||||| Total income Cash **----- Start of picture text -----**
£10,107.49 - 10,624.86 E
X P E
Bank Total Exp Uniform Lottery Adventure Fathers
Island Day
balance (if 20,732.35
riod
No entries in this row No entries in this row No entries
1,236.13 - Steve. This cell shows the current
Steve.
- 670.50 670.50 670.50 position for the period
Enter bank
117.70 - balance at
66.36 - start of Steve. Enter the value of cell W3 in this cell. Not a
period formula.
15.30 -
- 1,323.55 1,323.55 1,323.55
in this col. No entries
**----- End of picture text -----**
||

-|
15.30
1,323.55|
-
1,323.55
peri|1,323.55
formula.
od| |---|---|---|---|---| |||438.95|-|| |||272.30|-|| |||15.60|-|| ||-|384.00|384.00|384.00| |||15.60|-|| |||42.76|-|| |||2,542.51|-|| |||93.89|-|| |||1,267.50|-|| ||-|186.62|224.00|| ||-|345.20|345.20|345.20| |||84.00|-|| |||467.90|-|| |||1,244.28|-|| |||57.02|-|| |||31.80|-|| |||134.25|-|| |||15.90|-|| ||-|7.99|7.99|| |||100.70|-|| |||-|100.00|| |||663.92|-|| ||-|624.70|624.70|624.70| |||100.40|-|| ||-|178.89|178.89|| ||-|19.00|19.00|| ||-|200.00|200.00|| |||16.22|-|| |||14.10|-|| ||-|117.00|117.00|| ||-|5.10|5.10|| ||-|15.61|15.61|| ||-|15.00|15.00|| |||7.86|-|| |||1,258.00|53.00|| |||75.20|-|| - 77.50 77.50 14.10 - 200.50 - 67.96 - 70.80 - - 43.20 43.20 18.99 - 13.20 - 59.45 - - 71.97 71.97 - 119.88 119.88 83.60 - - 288.50 288.50 - 52.00 52.00 - 273.30 273.30 - 53.00 53.00 - 300.00 300.00 - 67.00 67.00 - 20.00 20.00 - 90.00 90.00 - 42.96 42.96 - 60.00 60.00 - 47.00 47.00 73.24 - - 16.50 16.50 - 60.68 60.68 - 113.80 113.80 53.00 - 13.50 - 73.24 - 80.61 - - 28.01 28.01 - 9.10 9.10 - 10.00 10.00 - 11.90 11.90 48.66 - - 8.69 8.69 - 10.00 10.00 782.73 - 232.75 - 965.00 - 349.50 - 80.00 - 1,409.35 - 400.47 - 78.70 - 158.00 - 518.62 - ||145.00|-||| |---|---|---|---|---| ||150.00|-||| ||47.50|-||| ||172.40|-||| ||305.20|-||| ||36.37|-||| ||120.00|-||| ||228.45|-||| |-|670.00|670.00||| ||90.00|-||| |-|222.14|222.14||| |-|123.00|123.00||| |-|1,200.00|1,200.00|1,200.00|| |-|499.20|499.20|499.20|| |-|1,802.90|1,802.90|1,802.90|| ||118.46|-||| ||279.89|-||| ||41.29|-||| ||83.90|-||| ||154.34|-||| ||13.14|-||| ||188.76|-||| ||534.03|-||| ||107.16|-||| ||13.20|-||| ||100.10|-||| ||13.76|-||| |-|16.83|16.83||16.83| |-|202.68|202.68||202.68| |-|127.17|127.17||127.17| |-|39.80|39.80||39.80| |-|533.00|533.00||533.00| |-|10.99|10.99||10.99| |-|60.00|60.00||60.00| |-|40.00|40.00||40.00| |-|240.00|240.00||240.00| |-|842.00|842.00|842.00|| ||87.01|-||| |-|509.45|509.45||| |-|680.00|680.00|680.00|| ||804.06|-||| |-|609.60|609.60|609.60|| ||24.00|-||| ||28.00|-||| ||12.00|-||| ||18.00|-||| ||6.00|-||| ||8.00|-||| |6.00 -||| |---|---|---| |36.00 -||| |42.00 -||| |6.00 -||| |18.00 -||| |12.00 -||| |6.00 -||| |12.00 -||| |36.00 -||| |12.00 -||| |18.00 -||| |36.00 -||| |6.00 -||| |24.00 -||| |16.00 -||| |18.00 -||| |65.37 -||| |68.40 -||| |- 45.73 45.73||| |- 36.50 36.50||| |- 12.32 12.32||| |12.00 -||| |- 35.50 35.50||| |293.15 -||| |352.00 -||| |423.38 -||| |1,568.35 -||| |285.00 -||| |12.90 -||| |169.10 -||| |- 20,000.00 20,000.00||| |4.00 -||| |2,548.60 -||| |68.80 -||| |- 210.00 210.00|210.00|| |23.94 -||| |271.34 -||| |- 2,516.00 2,516.00|2,516.00|| |- 14.37 14.37||| |- -||| |- -||| |- -||| |- -||| |- -||| |- -||| |**No entries in this row**|**No entries in this row**|**No entries**| |**- 10,624.86 37,457.71**|**11,707.65 -**|**- 1,270.47**| Bank Total Exp **----- Start of picture text -----**
Surplus -10,624.86
Bank/cash -10,624.86
Checked
**----- End of picture text -----**
|**N**

_Easter_
_Events_|**D**
Xmas Events|**IT**
Panto|**U**
Misc|**R**
Mothers
Day Stall|**E**
Bubble
Bounce|**in this col.**
|**No entries**| |---|---|---|---|---|---|---|---| |**s in this row**|||**No entries in**|**this row**|||| |a|||||||| |80.00||144.00|||||| ||7.99||||||| ||||100.00||||| ||178.89||||||| |||19.00|||||| |||200.00|||||| ||117.00||||||| ||5.10||||||| ||15.61||||||| ||15.00||||||| ||49.00|4.00|||||| 77.50 300.00 28.01 9.10 10.00 11.90 8.69 10.00 43.20 71.97 119.88 288.50 52.00 273.30 53.00 67.00 20.00 90.00 42.96 60.00 47.00 16.50 60.68 113.80 500.00 170.00 222.14 123.00 509.45 45.73 36.50 12.32 35.50 20,000.00 14.37 |**s in this row**
**No entries in this row**|| |---|---| |**457.70 978.41 537.00 21,057.89 1,376.59 72.00**|| ||| |Column Heading
Uniform
Lottery
Adventure Island
Fathers Day
Easter Events
Xmas Events
Panto
Misc
Mothers Day
Bubble Bounce
Totals
Totals from cash book totals
Surplus/defcit from blue cell.|Income
Expenditure
14,957.90 11,707.65
1,218.80 -
- -
1,568.35 1,270.47
1,709.71 457.70
997.26 978.41
2,622.15 537.00
1,613.18 21,057.89
1,462.35 1,376.59
683.15 72.00
- -
- -
- -
- -
- -| |---|---| ||**26,832.85 37,457.71**| ||**26,832.85 37,457.71**| |Should be zeros (i.e. the same), if
not there's a posting error|**0.00**
**0.00**| Surplus /Deficit(-) 3,250.25 1,218.80 - 297.88 1,252.01 18.85 2,085.15 - 19,444.71 85.76 611.15 - - - - - **- 10,624.86** **- 10,624.86 - 10,624.86 0.00 0.00** 8o8o>¢D f5 ¢DEs J c c t (u Q> c É 05587J osEufL