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 LcEc() c>£ ¢DCJC
IN (Q f Ln LO a) 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 É
0558