OpenCharities

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

2024-12-31-accounts

Pr
Ro
Excel Cashbook Easy
Month1
Month2
Month3
Month4
Month5
Month6
Month7
Month8
Month9
Month10
Month11
Month12
YTD
Excel Cashbook Easy
Month1
Month2
Month3
Month4
Month5
Month6
Month7
Month8
Month9
Month10
Month11
Month12
YTD
ofit and Loss Statement
lleston Civic Trust
January
February
March
April
May
June
July
August
September
October
November
December
YTD
Inc ome
Cash 110.00
424.85
32.50
81.80
90.00
1,122.15
73.00
20.00
15.00
98.15
1,033.02
5.00
Cheque 80.00
80.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Transfer 866.50
294.50
713.16
155.00
1,825.00
120.00
653.20
16,065.00
191.00
3,309.50
68.00
2,046.50
Total Income 1,056.50
799.35
745.66
236.80
1,915.00
1,242.15
726.20
16,085.00
206.00
3,407.65
1,101.02
2,051.50
E
Gross Profit 1,056.50
799.35
745.66
236.80
1,915.00
1,242.15
726.20
16,085.00
206.00
3,407.65
1,101.02
2,051.50
xpenses
Cheque 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
19,200.00
0.00
0.00
Transfer 1,183.63
207.49
444.61
411.57
2,480.62
95.00
919.95
817.62
138.50
163.30
928.88
8.17
Cash 0.00
16.25
16.00
98.50
25.00
1,061.00
32.50
0.00
0.00
22.00
469.02
0.00
Total Expenses 1,183.63
223.74
460.61
510.07
2,505.62
1,156.00
952.45
817.62
138.50
19,385.30
1,397.90
8.17
Net Profit/(Loss) (127.13)
575.61
285.05
(273.27)
(590.62)
86.15
(226.25)
15,267.38
67.50
(15,977.65)
(296.88)
2,043.33
(Gross Profit less Expenses)
ADJUSTMENTS
If your income or expenses include items that should be on a Balance Sheet, you can exclude them from this P&L Report. Enter them into the schedule below to get your true profit or ask your Professionl Bookkeeper or Accountant to prepare a Balance Sheet and adjust your income statement
January
February
March
April
May
June
July
August
September
October
November
December
Total YTD
Personal Expenses 0.00
Personal MoneyDeposited 0.00
Loans Received 0.00
Loan Repayments 0.00
Asset Purchases 0.00
Tax Payments(Income, Payroll, Sales Tax) 0.00
Uncleared Cheques 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
True Net Profit/(Loss) (127.13)
575.61
285.05
(273.27)
(590.62)
86.15
(226.25)
15,267.38
67.50
(15,977.65)
(296.88)
2,043.33
833.22

1

RECONCILIATION WORKSHEET RECONCILIATION WORKSHEET
Month to Report 12
Opening Bank Balance 5,576.13
Opening Cash Posi>on 24.90
Expected Closing Bank Balance
7,614.46
Expected Closing Cash Balance
29.90
Actual Bank Balance
Actual Cash Balance
Diference Bank
Diference Cash
Uncleared Paid Cheques
0

1

Rolleston Civic Trust
January
Rolleston Civic Trust
January
Rolleston Civic Trust
January
Rolleston Civic Trust
January
MONEY IN
Details Income
Date Payment Type Name Descripton Cheque
No
Cash Cheque
DO NOT DELETE THIS TOTALS ROW 50.00 10.00
Cheque Received Whoever Does not update Bank Balance (column AM) until banked.
You should use a separate line for the banking to help the
auditor compare to the bank statement
10.00
Cheque Paid and Cashed Whoever If the cheque has been cashed in the same month it was
raised then put the figure in Money Out - Cheque
(Column Q) as this impacts the bank balance
100960
Cheque Paid and Not Cashed Whoever If the cheque has been raised but not cashed in the same
month it was raised then you should put the figure in
Uncleared Cheques Paid (column AQ) so that it doesn’t
impact the balance balance but is registered. When the
cheque is cashed you should put a line in the new month
as per line 14 below
100961
Cheque cashed after being raised in
aprevious month
This impact the bank account, and will reduce the amount
of uncleared cheques(column AQ)

100959
Transfer Received Whoever This goes straight into the bank so should just be put in
the Money In - Transfer (column J)
Transfer Paid Whoever This goes straight out of the bank so should just be put in
Money Out - Transfer (column R)

1

Cash Received Whoever This does not impact the bank account until it is banked
so should go in Money In - Cash. This will increase the
Retained Cash and Cheques figure until it is banked. You
should ideally have a separate line for the banking
50.00
Cash Paid Whoever This does not impact the bank account but comes out of
the Retained Case and Cheques column (column AP) as it
assumes you paid it out of the cash in hand / petty cash
pot.
Banked Cheques and Cash This is where you bank any cash or cheques you hold. You
should have a separate line for the bank transaction to
make it easier for the auditors to sign off that the bank
statement matches this sheet
CLOSING BANK BALANCE ROW
Fields impacted by change
Fields impacted by a cheque being cashed after the month it was sent out. This is where you register the fact
that you have raised a cheque (a commitment) but it has not come off the bank balance at that time

2

MONEY OUT
Total
Money In
Total
Money
Out
BANK
BALANCE
Banked
Cash and
Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Transfer Cheque Transfer Cash
30.00 30.00 50.00 40.00 60.00 1,910.90 5,527.21
Opening
Bank
Balance
40.25
30.00
10.00 0.00 5,527.21 50.25
0.00 20.00 20.00 5,507.21 50.25
0.00 137.50 5,507.21 50.25
25.00
5.00 30.00 0.00 5,477.21 50.25
-30.00
30.00
0.00
811.70 5,507.21 50.25
0.00 40.00 811.70 5,467.21 50.25

3

0.00 65.00 5,467.21 100.25
0.00 60.00
65.00
5,467.21 40.25
10.00 0.00 5,497.21 30 10.25
5.00 0.00 5,497.21 10.25
0.00 0.00 5,497.21 10.25
0.00 0.00 5,497.21 10.25
5,497.21 Closing
Bank
Balance
10.25
25.00

4

OpeningBank Balance Closing Cash Balance
Month 1 6705.84 6573.71
Month 2 6573.71 7199.32
Month 3 7199.32 7467.87
Month 4 7467.87 7211.3
Month 5 7211.3 6555.68
Month 6 6555.68 6580.68
Month 7 6580.68 6498.93
Month 8 6498.93 21746.31
Month 9 21714.31 21798.81
Month 10 21798.81 5745.01
Month 11 5745.01 5576.13
Month 12 5576.13 7614.46

1

Column B comes from the closing bank balance from the actual statement received from the bank. When received it should be filled in on this table

The actual value of the unbanked cash and cheques we hold in column C when we receive the bank statement from the month. The figure is just from adding up the unbanked cash and cheques RCT hold today

2

Rolleston Civic Trust
January
Rolleston Civic Trust
January
Rolleston Civic Trust
January
Rolleston Civic Trust
January
Rolleston Civic Trust
January
Rolleston Civic Trust
January
MONEY IN
Details Income
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer
DO NOT DELETE THIS TOTALS ROW 110.00 80.00 866.50
1-Jan-24 BACS Bullivant,Warren,Hunt Subscriptions R1 15.00
2-Jan-24 BACS Boston Seeds Bluebell bulbs P1
2-Jan-24 Cheques HSBC Cleared cheques from 29/12/23
3-Jan-24 BACS ApplebyCurtains Rollestonian Advertisement R2 40.00
1-Jan-24 BACS Simnet,Parker,Wardell Subscriptions R3 15.00
2-Jan-24 BACS Baxendale,Irwin,Martin,Winst oSubscriptions R4 35.00
3-Jan-24 BACS Ward,Crofts,Cotton,Lewis Subscriptions and donation R5 35.00
4-Jan-24 BACS Smith Subscriptions R6 5.00
6-Jan-24 Cash Matkin,Press,Moreton Subscriptions(paid in 8/1 at Rolleston PO) R7 15.00
7-Jan-24 Cheque PD Longland Rollestonian Advertisement(cleared 10/1) R8 80.00
7-Jan-24 BACS Goodhead,Atton Subscriptions R9 10.00
10-Jan-24 BACS Jameson Subscriptions R10 5.00
13-Jan-24 BACS Overton: DGL Cleaning Rollestonian Advertisement R11 60.00
14-Jan-24 BACS Dovecliff Hall Rollestonian Advertisement R12 160.00
14-Jan-24 BACS IA BA BU T/AS SW Rollestonian Advertisement R13 80.00
15-Jan-24 BACS Overton/Boiler Repair Man Rollestonian Advertisement R14 20.00
16-Jan-24 BACS Rai,Ritchie,Starley Subscriptions R15 20.00
17-Jan-24 Cash Badcock Subscriptions and donation R16 10.00
17-Jan-23 BACS East Staffs Lottery Donation R17 31.50
17-Jan-24 BACS Beveridge,Fitzsimon,Peate Subscriptions R18 15.00
20-Jan-24 BACS Carvell Rollestonian Advertisement R19 40.00
20-Jan-24 BACS Loughlin Subscriptions R20 5.00

1

21-Jan-24 BACS Morris Subscriptions R21 5.00
21-Jan-24 CASH Killick,Waters,Knowles,Barne tSubscriptions R22 35.00
21-Jan-24 BACS Sharples Subscriptions R23 5.00
22-Jan-24 BACS Hewes Subscriptions R24 5.00
23-Jan-24 BACS Craythrone Farm Rollestonian Advertisement R25 100.00
23-Jan-24 BACS Kniveton Subscriptions R26 5.00
25-Jan-24 BACS Cowlishaw Rollestonian Advertisement R27 40.00
26-Jan-24 BACS Sanderson Subscriptions R28 5.00
27-Jan-24 BACS Faukner,Hirons Subscriptions R29 10.00
28-Jan-24 BACS HSBC Bank Charges P2
28-Jan-24 BACS Isham Subscriptions R30 5.00
30-Jan-24 BACS Fennell,Mival Subscriptions R31 10.00
31-Jan-24 Cash Loughlin,Onewell,Topliss,Picke Subscriptions R32 50.00
25-Jan-24 Cash Rolleston Post Office Paid in Cash at Rolleston Post Office
31-Jan-24 BACS JMP 2000 Ltd(Reflex Print) Rollestonian Printing P3
23-Jan-24 BACS Barnes(Tennis) Rollestonian Advertisement R35 85.00
CLOSING BANK BALANCE ROW

2

MONEY OUT
Total Money In Total Money Out BANK BALANCE Banked
Cash and
Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Cheque **Transfer ** Cash
1,056.50 0.00 1,183.63 0.00 1,183.63 6,705.84
Opening
Bank
Balance
105.30
15.00 0.00 6,720.84 105.30
0.00 505.99 505.99 6,214.85 105.30
0.00 0.00 6,259.85 45 60.30
40.00 0.00 6,299.85 60.30
15.00 0.00 6,314.85 60.30
35.00 0.00 6,349.85 60.30
35.00 0.00 6,384.85 60.30
5.00 0.00 6,389.85 60.30
15.00 0.00 6,404.85 15 60.30
80.00 0.00 6,484.85 80 60.30
10.00 0.00 6,494.85 60.30
5.00 0.00 6,499.85 60.30
60.00 0.00 6,559.85 60.30
160.00 0.00 6,719.85 60.30
80.00 0.00 6,799.85 60.30
20.00 0.00 6,819.85 60.30
20.00 0.00 6,839.85 60.30
10.00 0.00 6,839.85 70.30
31.50 0.00 6,871.35 70.30
15.00 0.00 6,886.35 70.30
40.00 0.00 6,926.35 70.30
5.00 0.00 6,931.35 70.30

3

5.00 0.00 6,936.35 70.30
35.00 0.00 6,936.35 105.30
5.00 0.00 6,941.35 105.30
5.00 0.00 6,946.35 105.30
100.00 0.00 7,046.35 105.30
5.00 0.00 7,051.35 105.30
40.00 0.00 7,091.35 105.30
5.00 0.00 7,096.35 105.30
10.00 0.00 7,106.35 105.30
0.00 6.64 6.64 7,099.71 105.30
5.00 0.00 7,104.71 105.30
10.00 0.00 7,114.71 105.30
50.00 0.00 7,114.71 155.30
0.00 0.00 7,159.71 45 110.30
0.00 671.00 671.00 6,488.71 110.30
85.00 0.00 6,573.71 110.30
0.00 0.00 6,573.71 110.30
0.00 0.00 6,573.71 110.30
0.00 0.00 6,573.71 110.30
0.00 0.00 6,573.71 110.30
0.00 0.00 6,573.71 110.30
6,573.71 Closing
Bank
Balance
110.30
0.00

4

Rolleston
February
Civic Trust Civic Trust Civic Trust
MONEY IN MONEYOUT
Details Income Total Money In Total
Money
Out
BANK
BALANCE
Banked
Cash and
Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash **Cheque ** Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 424.85 80.00 294.50 799.35 0.00 207.49 16.25 223.74 6,573.71
Opening
Bank
Balance
110.30
0.00
1-Feb-24 Cash Bredstuen, Cleary, Burston, Bus Subscriptions and Donations R33 73.20 73.20 0.00 6,573.71 183.50
1-Feb-24 Cash Rolleston Post Office Paid in at Post Office 0.00 0.00 6,696.91 123.2 60.30
1-Feb-24 Cheque Elaine Tolley (Badger's Hollow) Rollestonian Advertisement R34 80.00 80.00 0.00 6,776.91 80 60.30
1-Feb-24 BACS Skeet, Fletcher Subscriptions R36 10.00
10.00
0.00 6,786.91 60.30
3-Feb-24 BACS Waitrose (K Wright) Auditor Gift P4 0.00 33.97 33.97 6,752.94 60.30
4-Feb-24 BACS Swinbourne (Harcourt), Fisher Subscriptions R37 10.00
10.00
0.00 6,762.94 60.30
5-Feb-24 BACS Minns Subscriptions R38 5.00
5.00
0.00 6,767.94 60.30
7-Feb-24 BACS East Staffs Lottery Charity Donation R39 37.50
37.50
0.00 6,805.44 60.30
7-Feb-24 BACS Milton Donation for Trolley R40 25.00
25.00
0.00 6,830.44 60.30
8-Feb-24 BACS Paul Watson Rollestonian Advertisement R41 40.00
40.00
0.00 6,870.44 60.30
10-Feb-24 Cash Dunleavy, Longland, Gaunt, Min Subscriptions and Donations R42 40.00 40.00 0.00 6,870.44 100.30
14-Feb-24 Cash Faulkener, Chamberlain, Johnst oSubscriptions R43 30.00 30.00 0.00 6,940.44 70 60.30
17-Feb-24 Cash Redgrave, Price Subscriptions R44 10.00 10.00 0.00 6,940.44 70.30
19-Feb-24 BACS T Salmon (tce equipment) Reimbursement of Trolley invoice P5 0.00 164.99 164.99 6,775.45 70.30
18-Feb-24 BACS ST Catering Donation towards Trolley R45 50.00
50.00
0.00 6,825.45 70.30
19-Feb-24 Cash Quiz Night Takings R46 105.25 105.25 0.00 6,825.45 175.55
19-Feb-24 Cash Quiz Night Donations Donations towards Friends of Brook Hollows R47 166.40 166.40 0.00 6,825.45 341.95
19-Feb-24 Cash Quiz Night Outlay Quiz Night Prizes P6 0.00 16.25
16.25
6,825.45 325.70
23-Feb-24 Cash Rolleston Post Office Cash Paid into bank 0.00 0.00 7,090.85 265.4 60.30
26-Feb-24 BACS Allum Subscriptions P48 5.00
5.00
0.00 7,095.85 60.30
27-Feb-24 BACS Staley Donation for Trolley P49 12.00
12.00
0.00 7,107.85 60.30
27-Feb-24 BACS Davis Donation for Trolley P50 20.00
20.00
0.00 7,127.85 60.30
28-Feb-24 BACS HSBC Bank Charges P7 0.00 8.53 8.53 7,119.32 60.30
28-Feb-24 BACS Daniel Marks Rollestonian Advertisement P51 80.00
80.00
0.00 7,199.32 60.30
0.00 0.00 7,199.32 60.30
0.00 0.00 7,199.32 60.30
CLOSING BANK BALANCE ROW 7,199.32 Closing
Bank
Balance
60.30
0.00

1

Rolleston
March
Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total Money In Total
Money Out
BANK
BALANCE
Banked Cash
and Cheques
Retained Cash
and Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 32.50 0.00 713.16 745.66 0.00 444.61 16.00 460.61 7,199.32
Opening
Bank
Balance
60.30
0.00
5-Mar-24 BACS East Staffs Lottery CharityDonation R53 30.00
30.00
0.00 7,229.32 60.30
5-Mar-24 BACS Craythorne Farm Rollestonian Invoice R54 100.00
100.00
0.00 7,329.32 60.30
18-Mar-24 BACS Rolleston Parish Council Newsletter Inserts Invoice R52 533.16
533.16
0.00 7,862.48 60.30
18-Mar-24 BACS Boston Seeds Wild Flower seeds 589056 Invoice P8 0.00 29.99 29.99 7,832.49 60.30
21-Mar-24 BACS ApplebyCurtains Rollestonian Invoice R55 50.00
50.00
0.00 7,882.49 60.30
26-Mar-24 Cash Word Games evening Cash Takings R56 32.50 32.50 0.00 7,882.49 92.80
26-Mar-24 Cash Rolleston Cricket Club Donation in lieu of room hire P9 0.00 16.00
16.00
7,882.49 76.80
28-Mar-24 BACS Marsh Commercial Public LiabilityInsurance invoice 9985831 P10 0.00 299.50 299.50 7,582.99 76.80
28-Mar-24 BACS HSBC Bank Charges P11 0.00 7.14 7.14 7,575.85 76.80
30-Mar-24 BACS Tim Salmon Reimbursement for Ramp P12 0.00 107.98 107.98 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
0.00 0.00 7,467.87 76.80
CLOSING BANK BALANCE ROW 7,467.87 Closing
Bank
Balance
76.80
0.00

1

Rolleston Civic Trust
April
Rolleston Civic Trust
April
Rolleston Civic Trust
April
Rolleston Civic Trust
April
MONEY IN MONEY OUT
Details Income Total Money In Total
Money
Out
BANK
BALANCE
Banked Cash
and Cheques
Retained Cash
and Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash **Cheque ** Transfer **Cheque ** Transfer Cash
DO NOT DELETE THIS TOTALS ROW 81.80 0.00 155.00 236.80 0.00 411.57 98.50 510.07 7,467.87
Opening
Bank
Balance
76.80
0.00
4-Apr-24 BACS East Staffordshire Lottery CharityDonation R57 35.00
35.00
0.00 7,502.87 76.80
7-Apr-24 BACS ApplebyCurtains Refund overpayment P13 0.00 50.00 50.00 7,452.87 76.80
9-Apr-24 BACS Craythorne Farm Rollestonian Invoice R58 100.00
100.00
0.00 7,552.87 76.80
14-Apr-24 BACS Rolleston Village Fayre Donation towards Children’s Prizes P14 0.00 100.00 100.00 7,452.87 76.80
21-Apr-24 BACS Barbara Gaunt Reimbursement of Fat Balls for Brook Hollows P15 0.00 7.00 7.00 7,445.87 76.80
22-Apr-24 BACS Hickinson Subscriptions R59 5.00
5.00
0.00 7,450.87 76.80
23-Apr-24 BACS Rachel Delicata Subscriptions R60 5.00
5.00
0.00 7,455.87 76.80
23-Apr-24 BACS Susan Cotton Subscriptions R61 5.00
5.00
0.00 7,460.87 76.80
25-Apr-24 Cash Speaker eveningand AGM Cash Takings R62 76.75 76.75 0.00 7,460.87 153.55
25-Apr-24 Cash RodneyPaul Speaker Fees P16 0.00 55.00
55.00
7,460.87 98.55
25-Apr-24 Cash Speaker eveningand AGM Donation to Rolleston Cricket Club P17 0.00 43.50
43.50
7,460.87 55.05
25-Apr-24 BACS Laura Faulkener - Powell Subscriptionspaid byLaura Faulkener R63 5.00
5.00
0.00 7,465.87 55.05
26-Apr-24 Cash James Downes Subscriptions R64 5.05 5.05 0.00 7,465.87 60.10
28-Apr-24 BACS HSBC Bank Charges P18 0.00 5.00 5.00 7,460.87 60.10
28-Apr-24 BACS Tim Salmon Reimbursement for Stakes P19 0.00 70.00 70.00 7,390.87 60.10
29-Apr-24 BACS Rolleston Civic Trust Reimbursement of overpayment P20 0.00 179.57 179.57 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
0.00 0.00 7,211.30 60.10
CLOSING BANK BALANCE ROW 7,211.30 Closing
Bank
Balance
60.10
0.00

1

Rolleston
May
Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total Money In Total
Money
Out
BANK
BALANCE
Banked Cash
and Cheques
Retained Cash
and Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 90.00 0.00 1,825.00 1,915.00 0.00 2,480.62 25.00 2,505.62 7,211.30
Opening
Bank
Balance
60.10
0.00
5-May-24 BACS S Stevenson Subscriptions R65 5.00
5.00
0.00 7,216.30 60.10
8-May-24 BACS East Staffs Lottery LotteryDonation R66 75.00
75.00
0.00 7,291.30 60.10
8-May-24 BACS L Faukener on behalf ofJBurto Subscriptions R67 5.00
5.00
0.00 7,296.30 60.10
10-May-24 BACS Rachel Hanneffy Subscriptions R68 5.00
5.00
0.00 7,301.30 60.10
12-May-24 BACS JMP 2000(Reflex Print) Rollestonian Invoice P21 0.00 725.62 725.62 6,575.68 60.10
15-May-24 BACS Anonymous Donation Donation to FoBH topayfor statue R69 1,700.00
1,700.00
0.00 8,275.68 60.10
15-May-24 BACS Andrew Frost Payment towards statue P22 0.00 999.00 999.00 7,276.68 60.10
16-May-24 BACS Andrew Frost Payment towards statuepart 2 P23 0.00 701.00 701.00 6,575.68 60.10
16-May-24 Cash Speaker Evening Cash takings R70 55.00 55.00 0.00 6,575.68 115.10
16-May-24 Cash Rolleston Cricket Club Donation towards room hire P24 0.00 25.00
25.00
6,575.68 90.10
16-May-24 BACS Staffordshire Wildlife Trust Speaker donation P25 0.00 50.00 50.00 6,525.68 90.10
27-May-24 BACS G Bennett Subscriptions and donation R71 25.00
25.00
0.00 6,550.68 90.10
27-May-24 BACS Tulloch Subscriptions R72 5.00
5.00
0.00 6,555.68 90.10
28-May-24 BACS HSBC Bank Charges P26 0.00 5.00 5.00 6,550.68 90.10
28-May-24 BACS Hill Subscriptions R73 5.00
5.00
0.00 6,555.68 90.10
28-May-24 Cash Williamson,Ridgway,Cartwrigh Subscriptions and donation R74 35.00 35.00 0.00 6,555.68 125.10
0.00 0.00 6,555.68 125.10
0.00 0.00 6,555.68 125.10
0.00 0.00 6,555.68 125.10
CLOSING BANK BALANCE ROW 6,555.68 Closing
Bank
Balance
125.10
0.00

1

Rolleston
June
Civic Trust Civic Trust Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total Money In Total
Money
Out
BANK
BALANCE
Banked Cash
and Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 1,122.15 0.00 120.00 1,242.15 0.00 95.00 1,061.00 1,156.00 6,555.68
Opening
Bank
Balance
125.10
0.00
2-Jun-24 Cash Plant Fair Sales from donatedplants R75 1,057.15 1,057.15 0.00 6,555.68 1,182.25
2-Jun-24 Cash Plant Fair Donation Donation from Donor R76 5.00 5.00 0.00 6,555.68 1,187.25
2-Jun-24 Cash St Mary’s Church Funds Donation from Plant Fairproceeds P27 0.00 1,056.00
1,056.00
6,555.68 131.25
2-Jun-24 Cash St Mary’s Church Funds Donation from Plant Fairproceeds P28 0.00 5.00
5.00
6,555.68 126.25
10-Jun-24 BACS Firs Nursery Rollestonian Invoice Transferred byA Overton R77 80.00
80.00
0.00 6,635.68 126.25
10-Jun-24 Cash Purdom,Gillespie,McPherson, Subscriptions R78 20.00 20.00 0.00 6,635.68 146.25
10-Jun-24 BACS TJSalmon Reimbursement for HadleyReclaim Ltd -Boards P29 0.00 90.00 90.00 6,545.68 146.25
11-Jun-24 BACS East Staffs Lottery Donation from the Lottery R79 40.00
40.00
0.00 6,585.68 146.25
12-Jun-24 Cash Jane Wilson Subscriptions R80 5.00 5.00 0.00 6,585.68 151.25
16-Jun-24 Cash Cynthia Babb, Jill Maronge,Sim oSubscriptions and donation R81 35.00 35.00 0.00 6,585.68 186.25
28-Jun-24 BACS HSBC Bank Charges P30 0.00 5.00 5.00 6,580.68 186.25
0.00 0.00 6,580.68 186.25
0.00 0.00 6,580.68 186.25
CLOSING BANK BALANCE ROW 6,580.68 Closing
Bank
Balance
186.25
0.00

1

Rolleston
July
Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total
Money In
Total
Money Out
BANK
BALANCE
Banked
Cash and
Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 73.00 0.00 653.20 726.20 0.00 919.95 32.50 952.45 6,580.68
Opening
Bank
Balance
186.25
0.00
2-Jul-24 BACS East Staffs Lottery Donation R82 39.00
39.00
0.00 6,619.68 186.25
4-Jul-24 BACS Barker Subscription R83 5.00
5.00
0.00 6,624.68 186.25
13-Jul-24 Cash Williams Subscription R84 5.00 5.00 0.00 6,624.68 191.25
13-Jul-24 BACS Rolleston Parish Council Invoice for share ofplanters P31 0.00 275.00 275.00 6,349.68 191.25
13-Jul-24 BACS T Salmon Reimbursement for Compost P32 0.00 15.00 15.00 6,334.68 191.25
13-Jul-24 BACS T Salmon Reimbursement for Tools P33 0.00 20.75 20.75 6,313.93 191.25
16-Jul-24 BACS G Oliver Subscription R85 5.00
5.00
0.00 6,318.93 191.25
17-Jul-24 Cash Speaker Evening Takings at door R86 68.00 68.00 0.00 6,318.93 259.25
17-Jul-24 Cash Rolleston Cricket Club Donation in Lieu of Room Hire P34 0.00 32.50
32.50
6,318.93 226.75
19-Jul-24 BACS Veola ES Stafford Donation towards compost bins in the Orchard R87 604.20
604.20
0.00 6,923.13 226.75
25-Jul-24 Cash Banked Cash At Rolleston Post Office 0.00 0.00 7,108.13 185 41.75
28-Jul-24 BACS HSBC Bank Charges P35 0.00 5.00 5.00 7,103.13 41.75
29-Jul-24 BACS T Salmon Payent for Compost Bin P36 0.00 604.20 604.20 6,498.93 41.75
0.00 0.00 6,498.93 41.75
CLOSING BANK BALANCE ROW 6,498.93 Closing
Bank
Balance
41.75
0.00

1

Rolleston
August
Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total
Money In
Total
Money
Out
BANK
BALANCE
Banked Cash
and Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
**Cash ** Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 20.00 0.00 16,065.00 16,085.00 0.00 817.62 0.00 817.62 6,498.93
Opening
Bank
Balance
41.75
0.00
2-Aug-24 BACS Reflex Print Invoice for Rollestonian(Colour cover) P37 0.00 767.65 767.65 5,731.28 41.75
6-Aug-24 BACS East Staffs Lottery Donation R88 45.00
45.00
0.00 5,776.28 41.75
18-Aug-24 BACS Karen Wright Reimbursement for Banner artwork(Vinyl Banners Printing) P38 0.00 9.98 9.98 5,766.30 41.75
18-Aug-24 BACS Karen Wright Reimbursement for Banner(Vinyl Banners Printing) P39 0.00 33.85 33.85 5,732.45 41.75
19-Aug-24 Cash Lewis Farrimond Subscriptions R89 5.00 5.00 0.00 5,732.45 46.75
19-Aug-24 Cash Gill Booth Subscriptions R90 5.00 5.00 0.00 5,732.45 51.75
19-Aug-24 Cash AngieJohnson Subscriptions R91 5.00 5.00 0.00 5,732.45 56.75
19-Aug-24 Cash Kevin Banton Subscriptions R92 5.00 5.00 0.00 5,732.45 61.75
19-Aug-24 BACS FelicityTaylor Subscriptions R93 5.00
5.00
0.00 5,737.45 61.75
24-Aug-24 BACS Mowforth Subscriptions and donation R94 15.00
15.00
0.00 5,752.45 61.75
27-Aug-24 BACS East Staffs Borough Council Friends of Brook Hollows Grant Payment R95 16,000.00
16,000.00
0.00 21,752.45 61.75
28-Aug-24 BACS HSBC Bank Charges P40 0.00 6.14 6.14 21,746.31 61.75
0.00 0.00 21,746.31 61.75
0.00 0.00 21,746.31 61.75
0.00 0.00 21,746.31 61.75
CLOSING BANK BALANCE ROW 21,746.31 Closing
Bank
Balance
61.75
0.00

1

Rolleston
September
Civic Trust Civic Trust Civic Trust
MONEY IN MONEYOUT
Details Income Total
Money In
Total
Money
Out
BANK
BALANCE
Banked
Cash and
Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash **Cheque ** Transfer Cheque **Transfer ** Cash
DO NOT DELETE THIS TOTALS ROW 15.00 0.00 191.00 206.00 0.00 138.50 0.00 138.50 21,746.31
Opening
Bank
Balance
61.75
0.00
3-Sep-24 BACS East Staffs Lottery Charity Donation R96 36.00
36.00
0.00 21,782.31 61.75
6-Sep-24 BACS Jackson Subscriptions R97 5.00
5.00
0.00 21,787.31 61.75
12-Sep-24 BACS Karen Wright Reimbursement for payment of Netnerd invoice P41 0.00 59.99 59.99 21,727.32 61.75
12-Sep-24 BACS Tim Salmon Reimbursement for payment of Pete’s Printing-tickets P42 0.00 35.00 35.00 21,692.32 61.75
12-Sep-24 Cash Clarke, Ben Starbuck, Lovatt Subscriptions R98 15.00 15.00 0.00 21,692.32 76.75
15-Sep-24 BACS Robert Peate Proceeds from Car Boot Sale R99 140.00
140.00
0.00 21,832.32 76.75
22-Sep-24 BACS Tim Salmon Reimbursement for B&Q Padlock and chain P43 0.00 14.51 14.51 21,817.81 76.75
22-Sep-24 BACS Tim Salmon Reimbursement for Hadley Reclaim wood P44 0.00 24.00 24.00 21,793.81 76.75
28-Sep-24 BACS ESBC Bank Charges P45 0.00 5.00 5.00 21,788.81 76.75
29-Sep-24 BACS Keith Smith, Davis Subscriptions R100 10.00
10.00
0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
0.00 0.00 21,798.81 76.75
CLOSING BANK BALANCE ROW 21,798.81 Closing
Bank
Balance
76.75
0.00

1

Rolleston Civic Trust
October
Rolleston Civic Trust
October
Rolleston Civic Trust
October
Rolleston Civic Trust
October
MONEY IN MONEY OUT
Details Income Total
Money In
Total
Money
Out
BANK
BALANCE
Banked Cash
and Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 98.15 0.00 3,309.50 3,407.65 19,200.00 163.30 22.00 19,385.30 21,798.81
Opening
Bank
Balance
76.75
0.00
4-Oct-24 BACS RosemaryBowen Subscriptions R101 5.00
5.00
0.00 21,803.81 76.75
6-Oct-24 BACS Barbara Roberts Subscriptions R102 5.00
5.00
0.00 21,808.81 76.75
7-Oct-24 BACS Lorna Cox Subscription and Wine Tastingtickets R103 45.00
45.00
0.00 21,853.81 76.75
9-Oct-24 BACS Tim Salmon Reimbursement of breakfast for FOBH P46 0.00 75.30 75.30 21,778.51 76.75
15-Oct-24 BACS Rolleston Pariah Council Invoice raised on 5 Oct for donation towards VAT R104 3,200.00
3,200.00
0.00 24,978.51 76.75
10-Oct-24 BACS Baines/Fern Subscriptions R105 10.00
10.00
0.00 24,988.51 76.75
15-Oct-24 BACS East Staffs Lottery Donation from Lottery R106 44.50
44.50
0.00 25,033.01 76.75
25-Oct-24 Cheque StockleyPark Tree Services Forgroundworks(FOBH)at Brook Hollows 100981 P47 0.00 19,200.00 19,200.00 5,833.01 76.75
25-Oct-24 Cash Fitton/Farrington/Roberts/Kels aSubscriptions R107 20.00 20.00 0.00 5,833.01 96.75
25-Oct-24 Cash Tim Salmon Prizes forQuiz Night P48 0.00 22.00
22.00
5,833.01 74.75
25-Oct-24 Cash Quiz Night Quiz Night Takings R108 78.15 78.15 0.00 5,833.01 152.90
27-Oct-24 BACS Tim Salmon Reimbursement for Remembrance DayWreath P49 0.00 18.00 18.00 5,815.01 152.90
27-Oct-24 BACS Pete’s Printing MembershipCards 2025 P50 0.00 65.00 65.00 5,750.01 152.90
28-Oct-24 BACS HSBC Bank Charges P51 0.00 5.00 5.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
0.00 0.00 5,745.01 152.90
CLOSING BANK BALANCE ROW 5,745.01 Closing
Bank
Balance
152.90
0.00

1

Rolleston
November
Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total
Money In
Total
Money
Out
BANK
BALANCE
Banked
Cash and
Cheques

Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
Cash Cheque Transfer Cheque Transfer Cash
DO NOT DELETE THIS TOTALS ROW 1,033.02 0.00 68.00 1,101.02 0.00 928.88 469.02 1,397.90 5,745.01
Opening
Bank
Balance
152.90
0.00
1-Nov-24 BACS Tim Salmon White and Walker subscriptions R109 10.00
10.00
0.00 5,755.01 152.90
3-Nov-24 BACS JMP2000(Reflex Print) Rollestonianprint invoice P52 0.00 795.00 795.00 4,960.01 152.90
10-Nov-24 BACS St Mary’s Church Advent Christmas Tree P53 0.00 25.00 25.00 4,935.01 152.90
10-Nov-24 BACS Barbara Gaunt Bird Seed P54 0.00 21.99 21.99 4,913.02 152.90
10-Nov-24 BACS Barbara Gaunt Bird Seed P55 0.00 6.49 6.49 4,906.53 152.90
19-Nov-24 BACS East Staffs Lottery CharityDonation R110 35.00
35.00
0.00 4,941.53 152.90
19-Nov-24 BACS Fitchett-Watkin Subscriptions R111 5.00
5.00
0.00 4,946.53 152.90
21-Nov-24 BACS Rai and Bansal Donation for Painting R112 18.00
18.00
0.00 4,964.53 152.90
21-Nov-24 Cash Wine TastingEvening Ticket Sales R113 848.00 848.00 0.00 4,964.53 1,000.90
21-Nov-24 Cash Wine TastingEvening Raffle R114 185.02 185.02 0.00 4,964.53 1,185.92
21-Nov-24 Cash Sainsburys Food for Wine TastingEvening P56 0.00 28.09
28.09
4,964.53 1,157.83
21-Nov-24 Cash Sainsburys Wine P57 0.00 60.00
60.00
4,964.53 1,097.83
21-Nov-24 Cash Tesco Wine P58 0.00 68.00
68.00
4,964.53 1,029.83
21-Nov-24 Cash Lidl Wine P59 0.00 79.92
79.92
4,964.53 949.91
21-Nov-24 Cash Co-operative Food for Wine TastingEvening P60 0.00 10.75
10.75
4,964.53 939.16
21-Nov-24 Cash Laithwaites Wine P61 0.00 79.92
79.92
4,964.53 859.24
21-Nov-24 Cash Ocado Wine P62 0.00 72.00
72.00
4,964.53 787.24
21-Nov-24 Cash Direct Wines Wine P63 0.00 70.34
70.34
4,964.53 716.90
28-Nov-24 Cash Rolleston Post Office Payment of cash into bank 0.00 0.00 5,656.53 692 24.90
28-Nov-24 BACS HSBC Bank Charges P64 0.00 5.40 5.40 5,651.13 24.90
28-Nov-24 BACS St Mary’s MemoryTree for church P65 0.00 75.00 75.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
0.00 0.00 5,576.13 24.90
CLOSING BANK BALANCE ROW 5,576.13 Closing
Bank
Balance
24.90
0.00

1

Rolleston
December
Civic Trust Civic Trust Civic Trust
MONEY IN MONEY OUT
Details Income Total
Money In
Total
Money
Out
BANK
BALANCE
Banked
Cash and
Cheques
Retained
Cash and
Cheques
Uncleared
Cheques
Paid
Date Payment Type Name Descripton Cheque
No
**Cash ** **Cheque ** Transfer **Cheque ** Transfer Cash
DO NOT DELETE THIS TOTALS ROW 5.00 0.00 2,046.50 2,051.50 0.00 8.17 0.00 8.17 5,576.13
Opening
Bank
Balance
24.90
0.00
1-Dec-24 BACS Salmon Subscriptions R115 10.00
10.00
0.00 5,586.13 24.90
2-Dec-24 BACS Wright, Crofts, Tattersall, Hami Subscriptions R116 55.00
55.00
0.00 5,641.13 24.90
3-Dec-24 BACS Allin Subscriptions R117 5.00
5.00
0.00 5,646.13 24.90
4-Dec-24 BACS Hill, Dickens, Greenwood, Mar tSubscriptions R118 30.00
30.00
0.00 5,676.13 24.90
5-Dec-24 BACS Bush Subscriptions R119 5.00
5.00
0.00 5,681.13 24.90
7-Dec-24 BACS Salmon for Wilson and Lovatt Subscriptions R120 10.00
10.00
0.00 5,691.13 24.90
8-Dec-24 BACS Starley Subscriptions R121 5.00
5.00
0.00 5,696.13 24.90
9-Dec-24 BACS Norman Subscriptions R122 5.00
5.00
0.00 5,701.13 24.90
9-Dec-24 BACS Paul Watson Rollestonian Invoice R123 40.00
40.00
0.00 5,741.13 24.90
9-Dec-24 BACS David King Gardens Rollestonian Invoice R124 80.00
80.00
0.00 5,821.13 24.90
10-Dec-24 BACS East Staffs Lottery Charity Donation R125 33.50
33.50
0.00 5,854.63 24.90
10-Dec-24 BACS P Longland Rollestonian Invoice R126 80.00
80.00
0.00 5,934.63 24.90
10-Dec-24 BACS Stretch Subscriptions R127 5.00
5.00
0.00 5,939.63 24.90
11-Dec-24 BACS Wardleworth Subscriptions R128 5.00
5.00
0.00 5,944.63 24.90
11-Dec-24 BACS J Knight Footcare Rollestonian Invoice R129 40.00
40.00
0.00 5,984.63 24.90
11-Dec-24 BACS Prince and Son Rollestonian Invoice R130 80.00
80.00
0.00 6,064.63 24.90
11-Dec-24 BACS Timothy Warr Antiques Rollestonian Invoice R131 80.00
80.00
0.00 6,144.63 24.90
11-Dec-24 BACS Beveridge Subscriptions R132 5.00
5.00
0.00 6,149.63 24.90
11-Dec-24 BACS Boiler Repairman Rollestonian Invoice R133 80.00
80.00
0.00 6,229.63 24.90
11-Dec-24 BACS VSR Dental Rollestonian Invoice R134 88.00
88.00
0.00 6,317.63 24.90
12-Dec-24 BACS Anthony HS Rollestonian Invoice R135 40.00
40.00
0.00 6,357.63 24.90
12-Dec-24 BACS Cunninghame, Gallone Subscriptions R136 10.00
10.00
0.00 6,367.63 24.90
12-Dec-24 BACS MJ Finlay Rollestonian Invoice R137 60.00
60.00
0.00 6,427.63 24.90
13-Dec-24 BACS M and M Tree Rollestonian Invoice R138 80.00
80.00
0.00 6,507.63 24.90
13-Dec-24 BACS Overton for Micro Property Rollestonian Invoice R139 40.00
40.00
0.00 6,547.63 24.90
13-Dec-24 BACS Downes Subscriptions R140 5.00
5.00
0.00 6,552.63 24.90
14-Dec-24 BACS PA Tolley Rollestonian Invoice R141 80.00
80.00
0.00 6,632.63 24.90
16-Dec-24 BACS Barker, Salmon for Favell Subscriptions R142 10.00
10.00
0.00 6,642.63 24.90
17-Dec-24 BACS Gale,Hayes,Farr,Hiatt Subscriptions R143 20 20.00 0.00 6,662.63 24.90
18-Dec-24 BACS Good Life Pharmacy Rollestonian Invoice R144 160 160.00 0.00 6,822.63 24.90
21-Dec-24 Cash Connor Subscriptions R145 5.00 5.00 0.00 6,822.63 29.90
21-Dec-24 BACS S Williams Subscriptions R146 5 5.00 0.00 6,827.63 29.90
21-Dec-24 BACS MH Plumbing Rollestonian Invoice R147 80 80.00 0.00 6,907.63 29.90
22-Dec-24 BACS Wilding,Martin,Goodwin Subscriptions R148 15 15.00 0.00 6,922.63 29.90
23-Dec-24 BACS Simon Richardson Rollestonian Invoice R149 40 40.00 0.00 6,962.63 29.90
23-Dec-24 BACS Hunt,Boast,Preece,Cotton,F aSubscriptions R150 45 45.00 0.00 7,007.63 29.90
24-Dec-24 BACS Maronge,Fraser,Foster Subscriptions R151 15 15.00 0.00 7,022.63 29.90
24-Dec-24 BACS Dovecliff Hall Rollestonian Invoice R152 160 160.00 0.00 7,182.63 29.90
24-Dec-24 BACS Robson Subscriptions R153 5 5.00 0.00 7,187.63 29.90

1

28-Dec-24 BACS HSBC Bank Charges P66 0.00 8.17 8.17 7,179.46 29.90
28-Dec-24 BACS Holmes,Hickinson Subscriptions R154 10 10.00 0.00 7,189.46 29.90
29-Dec-25 BACS Brandon Subscriptions R155 5 5.00 0.00 7,194.46 29.90
30-Dec-25 BACS Fir Farm Nursery Rollestonian Invoice R156 80 80.00 0.00 7,274.46 29.90
30-Dec-25 BACS Ward Subscriptions and Donation R157 20.00
20.00
0.00 7,294.46 29.90
31-Dec-25 BACS Dean and Smedley Rollestonian Invoice R158 160.00
160.00
0.00 7,454.46 29.90
31-Dec-24 BACS Senad Ltd Rollestonian Invoice R159 160.00
160.00
0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
0.00 0.00 7,614.46 29.90
CLOSING BANK BALANCE ROW 7,614.46 Closing
Bank
Balance
29.90
0.00

2

MONTHS

Typing Information into the HEADERS will carry throug

MONTH HEADERS

Month1 Month2 Month3 Month4 Month5 Month6
January February March April May June
Type in the months of your financial year - if Month1 of your financial year is April
the tab names for each monthly worksheet along the bottom of this Cashbook. Y
coding - I have left VBA coding out of this Cashbook to keep it si

Type in the months of your financial year - if Month1 of your financial year is April the tab names for each monthly worksheet along the bottom of this Cashbook. Y coding - I have left VBA coding out of this Cashbook to keep it sim

1

Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy Excel Cashbook Easy
Month7 Month8 Month9 Month10 Month11 Month12
July August September October November December

, type ''April'' underneath Month1, ''May'' under Month2 etc. You can also rename You have to do it manually. It cannot be done automatically in Excel without VBA mple. Type 'How to rename worksheet' in your Excel Help Centre.

2

ACCOUNTS

Typing Information into the HEADERS will carry through to each page of this workbook

BUSINESS NAME HEADER Rolleston Civic Trust

ACCOUNT HEADERS

Type your headers into the green boxes titled Account 1, Account 2 and so on. You can rename the

ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
ACCOUNTS
Typing Information into the HEADERS will carry through to each page of this workbook
BUSINESS NAME HEADER
Rolleston Civic Trust
ACCOUNT HEADERS
Type your headersintothe greenboxestitledAccount 1,Account 2and so on. You can renamethe
Details Income Expenses
Date Payment
Type
Name Descripton Cheque No Cash Cheque Transfer Total Money
In
Cheque Transfer Cash Total Money
Out
1
2
3
1
2
3

1

Date Payment Type
1-Jan-24 BACS
3-Jan-24 BACS
1-Jan-24 BACS
2-Jan-24 BACS
3-Jan-24 BACS
4-Jan-24 BACS
6-Jan-24 Cash
7-Jan-24 Cheque
7-Jan-24 BACS
10-Jan-24 BACS
13-Jan-24 BACS
14-Jan-24 BACS
14-Jan-24 BACS
15-Jan-24 BACS
16-Jan-24 BACS
17-Jan-24 Cash
17-Jan-23 BACS
17-Jan-24 BACS
20-Jan-24 BACS
20-Jan-24 BACS
21-Jan-24 BACS
21-Jan-24 CASH
21-Jan-24 BACS
22-Jan-24 BACS
23-Jan-24 BACS
23-Jan-24 BACS
25-Jan-24 BACS
26-Jan-24 BACS
27-Jan-24 BACS
28-Jan-24 BACS
30-Jan-24 BACS
31-Jan-24 Cash
23-Jan-24 BACS
1-Feb-24 Cash
1-Feb-24 Cheque
1-Feb-24 BACS
4-Feb-24 BACS
5-Feb-24 BACS
7-Feb-24 BACS
7-Feb-24 BACS
8-Feb-24 BACS
10-Feb-24 Cash
14-Feb-24 Cash
17-Feb-24 Cash
18-Feb-24 BACS
19-Feb-24 Cash

1

19-Feb-24 Cash 26-Feb-24 BACS 27-Feb-24 BACS 27-Feb-24 BACS 28-Feb-24 BACS 5-Mar-24 BACS 5-Mar-24 BACS 18-Mar-24 BACS 21-Mar-24 BACS 26-Mar-24 Cash 4-Apr-24 BACS 9-Apr-24 BACS 22-Apr-24 BACS 23-Apr-24 BACS 23-Apr-24 BACS 25-Apr-24 Cash 25-Apr-24 BACS 26-Apr-24 Cash 5-May-24 BACS 8-May-24 BACS 8-May-24 BACS 10-May-24 BACS 15-May-24 BACS 16-May-24 Cash 27-May-24 BACS 27-May-24 BACS 28-May-24 BACS 28-May-24 Cash 2-Jun-24 Cash 2-Jun-24 Cash 10-Jun-24 BACS 10-Jun-24 Cash 11-Jun-24 BACS 12-Jun-24 Cash 16-Jun-24 Cash 2-Jul-24 BACS 4-Jul-24 BACS 13-Jul-24 Cash 16-Jul-24 BACS 17-Jul-24 Cash 19-Jul-24 BACS 6-Aug-24 BACS 19-Aug-24 Cash 19-Aug-24 Cash 19-Aug-24 Cash 19-Aug-24 Cash 19-Aug-24 BACS 24-Aug-24 BACS 27-Aug-24 BACS 3-Sep-24 BACS

2

6-Sep-24 BACS 12-Sep-24 Cash 15-Sep-24 BACS 29-Sep-24 BACS 4-Oct-24 BACS 6-Oct-24 BACS 7-Oct-24 BACS 15-Oct-24 BACS 10-Oct-24 BACS 15-Oct-24 BACS 25-Oct-24 Cash 25-Oct-24 Cash 1-Nov-24 BACS 19-Nov-24 BACS 19-Nov-24 BACS 21-Nov-24 BACS 21-Nov-24 Cash 21-Nov-24 Cash 1-Dec-24 BACS 2-Dec-24 BACS 3-Dec-24 BACS 4-Dec-24 BACS 5-Dec-24 BACS 7-Dec-24 BACS 8-Dec-24 BACS 9-Dec-24 BACS 9-Dec-24 BACS 9-Dec-24 BACS 10-Dec-24 BACS 10-Dec-24 BACS 10-Dec-24 BACS 11-Dec-24 BACS 11-Dec-24 BACS 11-Dec-24 BACS 11-Dec-24 BACS 11-Dec-24 BACS 11-Dec-24 BACS 11-Dec-24 BACS 12-Dec-24 BACS 12-Dec-24 BACS 12-Dec-24 BACS 13-Dec-24 BACS 13-Dec-24 BACS 13-Dec-24 BACS 14-Dec-24 BACS 16-Dec-24 BACS 17-Dec-24 BACS 18-Dec-24 BACS 21-Dec-24 Cash 21-Dec-24 BACS

3

21-Dec-24 BACS 22-Dec-24 BACS 23-Dec-24 BACS 23-Dec-24 BACS 24-Dec-24 BACS 24-Dec-24 BACS 24-Dec-24 BACS 28-Dec-24 BACS 29-Dec-25 BACS 30-Dec-25 BACS 30-Dec-25 BACS 31-Dec-25 BACS 31-Dec-24 BACS

4

Name DO NOT DELETE THIS TOTALS RO Bullivant, Warren, Hunt Appleby Curtains Simnet, Parker, Wardell Baxendale, Irwin, Martin, Winstone, Rawlings, Pickering, Colladine Ward, Crofts, Cotton, Lewis Smith Matkin, Press, Moreton PD Longland Goodhead, Atton Jameson Overton: DGL Cleaning Dovecliff Hall IA BA BU T/AS SW Overton/Boiler Repair Man Rai, Ritchie, Starley Badcock East Staffs Lottery Beveridge, Fitzsimon, Peate Carvell Loughlin Morris Killick, Waters, Knowles, Barnett, Taylor, Wells Sharples Hewes Craythrone Farm Kniveton Cowlishaw Sanderson Faukner, Hirons Isham Fennell, Mival Loughlin, Onewell,Topliss, Pickering, Dickens, Campbell,Alderson,Lo Barnes (Tennis) Bredstuen, Cleary, Burston, Bush, Gaunt, Graham, Haywood, Bissell Elaine Tolley (Badger's Hollow) Skeet, Fletcher Swinbourne (Harcourt), Fisher Minns East Staffs Lottery Milton Paul Watson Dunleavy, Longland, Gaunt, Minns V, Bissell, Bradbury, Hunter Faulkener, Chamberlain, Johnston, Cook, Atterall, Alcock Redgrave, Price ST Catering Quiz Night

7

Quiz Night Donations Allum Staley Davis Daniel Marks East Staffs Lottery Craythorne Farm Rolleston Parish Council Appleby Curtains Word Games evening East Staffordshire Lottery Craythorne Farm Hickinson Rachel Delicata Susan Cotton Speaker evening and AGM Laura Faulkener - Powell James Downes S Stevenson East Staffs Lottery L Faukener on behalf of J Burton Rachel Hanneffy Anonymous Donation Speaker Evening G Bennett Tulloch Hill Williamson, Ridgway, Cartwright, Ing, Campion, Westmacott Plant Fair Plant Fair Donation Firs Nursery Purdom, Gillespie, McPherson, Claber East Staffs Lottery Jane Wilson Cynthia Babb, Jill Maronge, Simon Hurcomb, James Branney, Lynda East Staffs Lottery Barker Williams G Oliver Speaker Evening Veola ES Stafford East Staffs Lottery Lewis Farrimond Gill Booth Angie Johnson Kevin Banton Felicity Taylor Mowforth East Staffs Borough Council East Staffs Lottery

8

Jackson Clarke, Ben Starbuck, Lovatt Robert Peate Keith Smith, Davis Rosemary Bowen Barbara Roberts Lorna Cox Rolleston Pariah Council Baines/Fern East Staffs Lottery Fitton/Farrington/Roberts/Kelsall Quiz Night Tim Salmon East Staffs Lottery Fitchett-Watkin Rai and Bansal Wine Tasting Evening Wine Tasting Evening Salmon Wright, Crofts, Tattersall, Hamilton, Faulkner, Yeo, Hewes, Bullivant, Allin Hill, Dickens, Greenwood, Martin, McNair, Smedley Bush Salmon for Wilson and Lovatt Starley Norman Paul Watson David King Gardens East Staffs Lottery P Longland Stretch Wardleworth J Knight Footcare Prince and Son Timothy Warr Antiques Beveridge Boiler Repairman VSR Dental Anthony HS Cunninghame, Gallone MJ Finlay M and M Tree Overton for Micro Property Downes PA Tolley Barker, Salmon for Favell Gale, Hayes, Farr, Hiatt Good Life Pharmacy Connor S Williams

9

MH Plumbing Wilding, Martin, Goodwin Simon Richardson Hunt, Boast, Preece, Cotton, Farmer, Pickering, Hymns, Jordan, Whe Maronge, Fraser, Foster Dovecliff Hall Robson Holmes, Hickinson Brandon Fir Farm Nursery Ward Dean and Smedley Senad Ltd

10

Descripton Cheque No Cash







OW 3,105.47
Subscriptions R1
Rollestonian Advertisement R2
Subscriptions R3
Subscriptions R4
Subscriptions and donation R5
Subscriptions R6
Subscriptions (paid in 8/1 at Rolleston PO) R7 15.00
Rollestonian Advertisement(cleared 10/1) R8
Subscriptions R9
Subscriptions R10
Rollestonian Advertisement R11
Rollestonian Advertisement R12
Rollestonian Advertisement R13
Rollestonian Advertisement R14
Subscriptions R15
Subscriptions and donation R16 10.00
Donation R17
Subscriptions R18
Rollestonian Advertisement R19
Subscriptions R20
Subscriptions R21
Subscriptions R22 35.00
Subscriptions R23
Subscriptions R24
Rollestonian Advertisement R25
Subscriptions R26
Rollestonian Advertisement R27
Subscriptions R28
Subscriptions R29
Subscriptions R30
Subscriptions R31
Subscriptions R32 50.00
Rollestonian Advertisement R35
Subscriptions andDonations R33 73.20
Rollestonian Advertisement R34
Subscriptions R36
Subscriptions R37
Subscriptions R38
CharityDonation R39
Donation for Trolley R40
Rollestonian Advertisement R41
Subscriptions and Donations R42 40.00
Subscriptions R43 30.00
Subscriptions R44 10.00
DonationtowardsTrolley R45
Takings R46 105.25

13

Donations towards Friends of Brook Hollows R47 166.40















Subscriptions P48
Donation for Trolley P49
Donation for Trolley P50
Rollestonian Advertisement P51
CharityDonation R53
Rollestonian Invoice R54
Newsletter Inserts Invoice R52
Rollestonian Invoice R55
Cash Takings R56 32.50
CharityDonation R57
Rollestonian Invoice R58
Subscriptions R59
Subscriptions R60
Subscriptions R61
Cash Takings R62 76.75
Subscriptionspaid byLaura Faulkener R63
Subscriptions R64 5.05
Subscriptions R65
LotteryDonation R66
Subscriptions R67
Subscriptions R68
Donation to FoBH to pay for statue R69
Cash takings R70 55.00
Subscriptions and donation R71
Subscriptions R72
Subscriptions R73
Subscriptions and donation R74 35.00
Sales from donated plants R75 1,057.15
Donation from Donor R76 5.00
Rollestonian InvoiceTransferred byAOverton R77
Subscriptions R78 20.00
Donation from the Lottery R79
Subscriptions R80 5.00
Subscriptions and donation R81 35.00
Donation R82
Subscription R83
Subscription R84 5.00
Subscription R85
Takings at door R86 68.00
Donation towards compost bins in the Orchard R87
Donation R88
Subscriptions R89 5.00
Subscriptions R90 5.00
Subscriptions R91 5.00
Subscriptions R92 5.00
Subscriptions R93
Subscriptions and donation R94
Friends of Brook Hollows Grant Payment R95
CharityDonation R96

14

Subscriptions R97



Subscriptions R98 15.00
Proceeds from Car Boot Sale R99
Subscriptions R100
Subscriptions R101
Subscriptions R102
Subscription and Wine Tasting tickets R103
Invoice raised on 5 Oct for donation towards VAT R104
Subscriptions R105
Donation from Lottery R106
Subscriptions R107 20.00
Quiz Night Takings R108 78.15
White and Walker subscriptions R109
CharityDonation R110
Subscriptions R111
Donation for Painting R112
TicketSales R113 848.00
Raffle R114 185.02
Subscriptions R115
Subscriptions R116
Subscriptions R117
Subscriptions R118
Subscriptions R119
Subscriptions R120
Subscriptions R121
Subscriptions R122
Rollestonian Invoice R123
Rollestonian Invoice R124
CharityDonation R125
Rollestonian Invoice R126
Subscriptions R127
Subscriptions R128
Rollestonian Invoice R129
Rollestonian Invoice R130
Rollestonian Invoice R131
Subscriptions R132
Rollestonian Invoice R133
Rollestonian Invoice R134
Rollestonian Invoice R135
Subscriptions R136
Rollestonian Invoice R137
Rollestonian Invoice R138
Rollestonian Invoice R139
Subscriptions R140
Rollestonian Invoice R141
Subscriptions R142
Subscriptions R143
Rollestonian Invoice R144
Subscriptions R145 5
Subscriptions R146

15

Rollestonian Invoice R147
Subscriptions R148
Rollestonian Invoice R149
Subscriptions R150
Subscriptions R151
Rollestonian Invoice R152
Subscriptions R153
Subscriptions R154
Subscriptions R155
Rollestonian Invoice R156
Subscriptions and Donation R157
Rollestonian Invoice R158
Rollestonian Invoice R159

16

Cheque Transfer Total Money
In
Subscriptio
ns
Quiz
Night
Takings
Rollestonian
Invoice
160.00 26,307.36 29,572.83 1,857.45 183.40 2,038.00
15.00
15.00
15.00
40.00
40.00
15.00
15.00
15.00
35.00
35.00
35.00
35.00
35.00
35.00
5.00
5.00
5.00
15.00 15.00
80.00 80.00
10.00
10.00
10.00
5.00
5.00
5.00
60.00
60.00
160.00
160.00
80.00
80.00
20.00
20.00
20.00
20.00
20.00
10.00 10.00
31.50
31.50
15.00
15.00
15.00
40.00
40.00
5.00
5.00
5.00
5.00
5.00
5.00
35.00 35.00
5.00
5.00
5.00
5.00
5.00
5.00
100.00
100.00
5.00
5.00
5.00
40.00
40.00
5.00
5.00
5.00
10.00
10.00
10.00
5.00
5.00
5.00
10.00
10.00
10.00
50.00 50.00
85.00
85.00
73.20 73.20
80.00 80.00
10.00
10.00
10.00
10.00
10.00
10.00
5.00
5.00
5.00
37.50
37.50
25.00
25.00
25.00
40.00
40.00
40.00 40.00
30.00 30.00
10.00 10.00
50.00
50.00
50.00
105.25 105.25

19

166.40


5.00
5.00
5.00
12.00
12.00
12.00
20.00
20.00
20.00
80.00
80.00
30.00
30.00
100.00
100.00
100.00
533.16
533.16
50.00
50.00
50.00
32.50
35.00
35.00
100.00
100.00
100.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
76.75
5.00
5.00
5.00
5.05 5.05
5.00
5.00
5.00
75.00
75.00
5.00
5.00
5.00
5.00
5.00
5.00
1,700.00
1,700.00
55.00
25.00
25.00
25.00
5.00
5.00
5.00
5.00
5.00
5.00
35.00 35.00
1,057.15
5.00
80.00
80.00
80.00
20.00 20.00
40.00
40.00
5.00 5.00
35.00 35.00
39.00
39.00
5.00
5.00
5.00
5.00 5.00
5.00
5.00
5.00
68.00
604.20
604.20
604.20
45.00
45.00
5.00 5.00
5.00 5.00
5.00 5.00
5.00 5.00
5.00
5.00
5.00
15.00
15.00
15.00
16,000.00
16,000.00
36.00
36.00

20

5.00
5.00
5.00












15.00 15.00
140.00
140.00
10.00
10.00
10.00
5.00
5.00
5.00
5.00
5.00
5.00
45.00
45.00
5.00
3,200.00
3,200.00
10.00
10.00
10.00
44.50
44.50
20.00 20.00
78.15 78.15
10.00
10.00
10.00
35.00
35.00
5.00
5.00
5.00
18.00
18.00
18.00
848.00
185.02
10 10.00 10.00
55 55.00 55.00
5 5.00 5.00
30 30.00 30.00
5.00
5.00
5.00
10.00
10.00
10.00
5.00
5.00
5.00
5.00
5.00
5.00
40.00
40.00
40.00
80.00
80.00
80.00
33.50
33.50
80.00
80.00
80.00
5.00
5.00
5.00
5.00
5.00
5.00
40 40.00 40.00
80 80.00 80.00
80 80.00 80.00
5 5.00 5.00
80 80.00 80.00
88 88.00 88.00
40 40.00 40.00
10 10.00 10.00
60 60.00 60.00
80 80.00 80.00
40 40.00 40.00
5 5.00 5.00
80 80.00 80.00
10 10.00 10.00
20 20.00 20.00
160 160.00 160.00
5.00 5.00
5 5.00 5.00

21

80 80.00 80.00
15 15.00 15.00
40 40.00 40.00
45 45.00 45.00
15 15.00 15.00
160 160.00 160.00
5 5.00 5.00
10 10.00 10.00
5 5.00 5.00
80 80.00 80.00
20 20.00 20.00
160 160.00 160.00
160 160.00 160.00

22

Rollesto
nian
Advert
Rolleston PC
Inserts
Wine
Tasting
Meeting
Takings
Bird Seed Amazon
Charity
Lottery
905.00 533.16 1,073.02 232.25 0.00 0.00 482.00
40.00
80.00
60.00
160.00
80.00
20.00
31.50
40.00
100.00
40.00
85.00
80.00
37.50
40.00

25

80.00 30.00 533.16 32.50 35.00 76.75 75.00 55.00 40.00 39.00 68.00 45.00 36.00

26

40 44.50 35.00 848.00 185.02 33.50 27

Plant Sale Car Boot
Sale
FOBH Total
1,062.15 140.00 21,066.40 29,572.83
15.00
40.00
15.00
35.00
35.00
5.00
15.00
80.00
10.00
5.00
60.00
160.00
80.00
20.00
20.00
10.00
31.50
15.00
40.00
5.00
5.00
35.00
5.00
5.00
100.00
5.00
40.00
5.00
10.00
5.00
10.00
50.00
85.00
73.20
80.00
10.00
10.00
5.00
37.50
25.00
40.00
40.00
30.00
10.00
50.00
105.25

31

166.40
166.40
5.00
12.00
20.00
80.00
30.00
100.00
533.16
50.00
32.50
35.00
100.00
5.00
5.00
5.00
76.75
5.00
5.05
5.00
75.00
5.00
5.00
1,700.00
1,700.00
55.00
25.00
5.00
5.00
35.00
1,057.15 1,057.15
5.00 5.00
80.00
20.00
40.00
5.00
35.00
39.00
5.00
5.00
5.00
68.00
604.20
45.00
5.00
5.00
5.00
5.00
5.00
15.00
16,000.00
16,000.00
36.00

32

5.00
15.00
140.00 140.00
10.00
5.00
5.00
45.00
3,200.00 3,200.00
10.00
44.50
20.00
78.15
10.00
35.00
5.00
18.00
848.00
185.02
10.00
55.00
5.00
30.00
5.00
10.00
5.00
5.00
40.00
80.00
33.50
80.00
5.00
5.00
40.00
80.00
80.00
5.00
80.00
88.00
40.00
10.00
60.00
80.00
40.00
5.00
80.00
10.00
20.00
160.00
5.00
5.00

33

80.00 15.00 40.00 45.00 15.00 160.00 5.00 10.00 5.00 80.00 20.00 160.00 160.00

34

Date Payment
Type
Name
DO N
2-Jan-24 BACS Boston Seeds
28-Jan-24 BACS HSBC
31-Jan-24 BACS JMP 2000 Ltd(Reflex Print)
3-Feb-24 BACS Waitrose(K Wright)
19-Feb-24 BACS T Salmon(tce equipment)
19-Feb-24 Cash Quiz Night Outlay
28-Feb-24 BACS HSBC
18-Mar-24 BACS Boston Seeds
26-Mar-24 Cash Rolleston Cricket Club
28-Mar-24 BACS Marsh Commercial
28-Mar-24 BACS HSBC
30-Mar-24 BACS Tim Salmon
7-Apr-24 BACS ApplebyCurtains
14-Apr-24 BACS Rolleston Village Fayre
21-Apr-24 BACS Barbara Gaunt
25-Apr-24 Cash RodneyPaul
25-Apr-24 Cash Speaker eveningand AGM
28-Apr-24 BACS HSBC
28-Apr-24 BACS Tim Salmon
29-Apr-24 BACS Rolleston Civic Trust
12-May-24 BACS JMP 2000(Reflex Print)
15-May-24 BACS Andrew Frost
16-May-24 BACS Andrew Frost
16-May-24 Cash Rolleston Cricket Club
16-May-24 BACS Staffordshire Wildlife Trust
28-May-24 BACS HSBC
2-Jun-24 Cash St Mary’s Church Funds
2-Jun-24 Cash St Mary’s Church Funds
10-Jun-24 BACS TJ Salmon
28-Jun-24 BACS HSBC
13-Jul-24 BACS Rolleston Parish Council
13-Jul-24 BACS T Salmon
13-Jul-24 BACS T Salmon
17-Jul-24 Cash Rolleston Cricket Club
28-Jul-24 BACS HSBC
29-Jul-24 BACS T Salmon
2-Aug-24 BACS Reflex Print
18-Aug-24 BACS Karen Wright
18-Aug-24 BACS Karen Wright
28-Aug-24 BACS HSBC
12-Sep-24 BACS Karen Wright
12-Sep-24 BACS Tim Salmon
22-Sep-24 BACS Tim Salmon
22-Sep-24 BACS Tim Salmon
28-Sep-24 BACS ESBC
9-Oct-24 BACS Tim Salmon
25-Oct-24 Cheque StockleyPark Tree Services

1

25-Oct-24 Cash Tim Salmon
27-Oct-24 BACS Tim Salmon
27-Oct-24 BACS Pete’s Printing
28-Oct-24 BACS HSBC
3-Nov-24 BACS JMP2000(Reflex Print)
10-Nov-24 BACS St Mary’s Church
10-Nov-24 BACS Barbara Gaunt
10-Nov-24 BACS Barbara Gaunt
21-Nov-24 Cash Sainsburys
21-Nov-24 Cash Sainsburys
21-Nov-24 Cash Tesco
21-Nov-24 Cash Lidl
21-Nov-24 Cash Co-operative
21-Nov-24 Cash Laithwaites
21-Nov-24 Cash Ocado
21-Nov-24 Cash Direct Wines
28-Nov-24 BACS HSBC
28-Nov-24 BACS St Mary’s
28-Dec-24 BACS HSBC

2

Descripton Cheque No Cheque
NOT DELETE THIS TOTALS ROW 19,200.00
Bluebell bulbs P1
Bank Charges P2
Rollestonian Printing P3
Auditor Gift P4
Reimbursement of Trolleyinvoice P5
Quiz Night Prizes P6
Bank Charges P7
Wild Flower seeds 589056 Invoice P8
Donation in lieu of room hire P9
Public LiabilityInsurance invoice 9985831 P10
Bank Charges P11
Reimbursement for Ramp P12
Refund overpayment P13
Donation towards Children’s Prizes P14
Reimbursement of Fat Balls for Brook Hollows P15
Speaker Fees P16
Donation to Rolleston Cricket Club P17
Bank Charges P18
Reimbursement for Stakes P19
Reimbursement of overpayment P20
Rollestonian Invoice P21
Payment towards statue P22
Payment towards statuepart 2 P23
Donation towards room hire P24
Speaker donation P25
Bank Charges P26
Donation from Plant Fairproceeds P27
Donation from Plant Fairproceeds P28
Reimbursement for HadleyReclaim Ltd -Boards P29
Bank Charges P30
Invoice for share ofplanters P31
Reimbursement for Compost P32
Reimbursement for Tools P33
Donation in Lieu of Room Hire P34
Bank Charges P35
Payent for Compost Bin P36
Invoice for Rollestonian(Colour cover) P37
Reimbursement for Banner artwork(Vinyl Banners Printing) P38
Reimbursement for Banner(Vinyl Banners Printing) P39
Bank Charges P40
Reimbursement forpayment of Netnerd invoice P41
Reimbursement forpayment of Pete’s Printing- tickets P42
Reimbursement for B&QPadlock and chain P43
Reimbursement for HadleyReclaim wood P44
Bank Charges P45
Reimbursement of breakfast for FOBH P46
Forgroundworks(FOBH)at Brook Hollows 100981 P47 19,200.00

7

Prizes forQuiz Night P48
Reimbursement for Remembrance DayWreath P49
MembershipCards 2025 P50
Bank Charges P51
Rollestonianprint invoice P52
Advent Christmas Tree P53
Bird Seed P54
Bird Seed P55
Food for Wine TastingEvening P56
Wine P57
Wine P58
Wine P59
Food for Wine TastingEvening P60
Wine P61
Wine P62
Wine P63
Bank Charges P64
MemoryTree for church P65
Bank Charges P66

8

Transfer Cash Total
Money Out
PL
Insurance
St Mary's Xmas
Tree Festival
Rolleston Village
Fayre Society
7,799.34 1,740.27 28,739.61 299.50 25.00 100.00
505.99 505.99
6.64 6.64
671.00 671.00
33.97 33.97
164.99 164.99
16.25
16.25
8.53 8.53
29.99 29.99
16.00
16.00
299.50 299.50 299.50
7.14 7.14
107.98 107.98
50.00 50.00
100.00 100.00 100.00
7.00 7.00
55.00
55.00
43.50
43.50
5.00 5.00
70.00 70.00
179.57 179.57
725.62 725.62
999.00 999.00
701.00 701.00
25.00
25.00
50.00 50.00
5.00 5.00
1,056.00
1,056.00
5.00
5.00
90.00 90.00
5.00 5.00
275.00 275.00
15.00 15.00
20.75 20.75
32.50
32.50
5.00 5.00
604.20 604.20
767.65 767.65
9.98 9.98
33.85 33.85
6.14 6.14
59.99 59.99
35.00 35.00
14.51 14.51
24.00 24.00
5.00 5.00
75.30 75.30
19,200.00

13

22.00
22.00
18.00 18.00
65.00 65.00
5.00 5.00
795.00 795.00
25.00 25.00 25.00
21.99 21.99
6.49 6.49
28.09
28.09
60.00
60.00
68.00
68.00
79.92
79.92
10.75
10.75
79.92
79.92
72.00
72.00
70.34
70.34
5.40 5.40
75.00 75.00
8.17 8.17
22.00
22.00
18.00 18.00
65.00 65.00
5.00 5.00
795.00 795.00
25.00 25.00 25.00
21.99 21.99
6.49 6.49
28.09
28.09
60.00
60.00
68.00
68.00
79.92
79.92
10.75
10.75
79.92
79.92
72.00
72.00
70.34
70.34
5.40 5.40
75.00 75.00
8.17 8.17

14

Church
Maintenance
Fund
Donations
to Cricket
Club
Printing
Costs
Sundry
Expenses
Web Hosting Rollestonian
Invoice
(credit)
Planters
1,136.00 43.50 3,103.10 1,378.72 59.99 50.00 275.00
505.99
671.00
33.97
29.99
50.00
7.00
43.50
179.57
725.62
1,056.00
5.00
275.00
604.20
767.65
9.98
33.85
59.99
35.00

19

18.00 65.00 795.00 75.00 20

Unused Speakers Fees Room Hire -
Rolleston CC and
Rolleston Club
Wine Tasting Quiz Night Prizes
0.00 105.00 73.50 469.02 38.25
16.25
16.00
55.00
25.00
50.00
32.50

25

22.00 28.09 60.00 68.00 79.92 10.75 79.92 72.00 70.34

26

FOBH Bank Charges Total
21,511.01 72.02 28,739.61
505.99
6.64
6.64
671.00
33.97
164.99 164.99
16.25
8.53
8.53
29.99
16.00
299.50
7.14
7.14
107.98 107.98
50.00
100.00
7.00
55.00
43.50
5.00
5.00
70.00 70.00
179.57
725.62
999.00 999.00
701.00 701.00
25.00
50.00
5.00
5.00
1,056.00
5.00
90.00 90.00
5.00
5.00
275.00
15.00 15.00
20.75 20.75
32.50
5.00
5.00
604.20
767.65
9.98
33.85
6.14
6.14
59.99
35.00
14.51 14.51
24.00 24.00
5.00
5.00
75.30 75.30
19,200.00 19,200.00

31

22.00
18.00
65.00
5.00
5.00
795.00
25.00
21.99 21.99
6.49 6.49
28.09
60.00
68.00
79.92
10.75
79.92
72.00
70.34
5.40
5.40
75.00
8.17
8.17

32

Opening Balances Opening Balances Receipts Receipts
Bank 6705.84
RetainedCash/Cheques 105.30 Fees and Donations £
**Total Assets ** 6811.14 Subscrptions 1857.45
FOBH Donations 21066.40
Lottery (FoBH) 482.00
MonthlyMeetingEntranceFees 232.25
Total Fees and Donations
Sales of Advertising
Rollestonian - Advertising 2943.00
Rolleston PCInserts 533.16
Total Sales
Events
Plant Sale 1062.15
WineTastingEvening 1073.02
Quiz Night 183.40
Car Boot Sale 140.00
Total Event Receipts
Total Receipts

1

Payments Payments Payments
£ Governance / Management £ £
PublicLiabilityInsurance 299.50
BankCharges 72.02
WebHosting 59.99
Total Governance/Maintenance 431.51
23638.10
Events
ChristmasTreeFestival 25.00
Speaker Fees 105.00
Room Hire-Cricket Club /RollestonClub 73.50
3476.16 Quiz NightPrizes 38.25
Total Events 241.75
Donations
RollestonVillageFayre Society 100.00
Cricket ClubDonations 43.50
Church MaintenanceFund 1136.00
2458.57 Total Donations 1279.50
Expenses
WineTasting 469.02
Printing 3103.10
FOBH 21511.01
Planters 275.00
SundryExpenses 1428.72
Total Expenses 26786.85
29572.83 Total Payments 28739.61
Balance as at 1January 2024 £ £
BankCurrentAccount 6705.84
Cash in Hand 105.30 6811.14
ExcessReceipts 833.22
7644.36
Balance as at 31 December 2022 £ £
BankCurrentAccount 7614.46
Cash in Hand 29.90
7644.36

2

Closing Balances Closing Balances Monthly Tota Monthly Tota
Bank 7614.46 Month Receipts
RetainedCash/Cheques 29.90 January 1056.50
**Total Assets ** 7644.36 February 799.35
March 745.66
April 236.80
May 1915.00
June 1242.15
July 726.20
August 16085.00
September 206.00
October 3407.65
November 1101.02
December 2051.50
Totals 29572.83

3

als Payments 1183.63 223.74 460.61 510.07 2505.62 1156.00 952.45 817.62 138.50 19385.30 1397.90 8.17 28739.61

4

Rolleston Civic Trust
Receipts and Payments
for Year Ending December
2024
Receipts Income Expense Profit
Subscrptions and Donations 1857.45
Subscription Profit 1857.45
Rollestonian
Rollestonian-Advertising 2943.00
Rolleston PC Inserts 533.16
Less Costs 3103.10
Rollestonian Profit 373.06
Speakers
Entrance Fees 232.25
Quiz Night 183.40
Less Costs 260.25
Speakers Profit 155.40
Wine Tasting
WineTastingReceipts 1073.02
WineTasting Costs 469.02
Wine Tasting Profit 604.00
FOBH
Donations 21066.40
LotteryDonations(FOBH) 482.00
FOBH Costs 21511.01
FOBH Profit 37.39
Other Income
Plant Sale 1062.15
Car Boot Sale 140.00
Other Income 1202.15
Total Net Receipts 29572.83 25343.38 4229.45
Balance at 1 January 2024
Bank Current Account 6,705.84
Cash in Hand 105.30 6,811.14
Excess Receipts 833.22
Opening Balance 7,644.36

1

I have examined the accounts with the books and vouchers by Rolleston Civic Trust and ce David Phillips Hon. Examiner

2

Payments Expense Total
Governance
PublicLiabilityInsurance 299.50
BankCharges 72.02
WebHosting 59.99
TotalGovernanceCosts 431.51
Other Event Costs
Christmas Tree Festival 25.00
Total EventCosts 25.00
Donations
Rolleston Village Fayre Society 100.00
Church Maintenance Fund 1136.00
Planters 275.00
Total Donations 1511.00
Sundry Expenses
SundryExpenses 1428.72
TotalSundry Expenses 1428.72
Total Payments 3396.23
Balance as at 31 December 2024
Bank Current Account 7614.46
Cash in Hand 29.90
Closing Balance 7644.36

3

Rolleston Civic Trust: Annual Statement 2024.

We’re please to announce that subscriptions have increased this year, from Friends of Brook Hollows signing up and the successful History Walks, breaking 200 members for the first time in many years. Subscriptions are paid mostly in December and January, and there has been a significant upturn in those paying by BACs before Christmas.

The change to white paper, including the introduction of a colour cover and more copies printed as the village has expanded has kept costs the same. Some advertisers are late paying, but there’s still a small surplus of £373 with more payments coming in in January 2025, I expect a similar surplus to 2023.

Speakers have reduced last year, due to increased hiring fees, but we have had a couple of ‘volunteer’ speakers which kept costs down along with takings from the Quiz, these now have given a profit of £155.

Friend of Brook Hollows, which the Civic Trust provides banking for, has been separated out of the main accounts for greater clarity. With the generous financial and also practical help the Friends of Brook Hollows were awarded a £16000 Grant to clear up the island. The Parish Council kindly paid the VAT bill (£3200). An anonymous donation also allowed the Friends to purchase the Red Squirrel statue (£1700). The Charity Donations from the East Staffordshire Lottery have paid for a variety of tools and wood for general maintenance.

The Car Boot Sale was relatively successful and will be repeated this year, depending on weather, and the condition of the Rec.

The Plant Sale exceeded all expectations. The generosity of Rolleston’s Residents in donating plants meant that St Mary’s Church Maintenance Fund received £1062. The Church is the oldest building in the village, Grade 1, and need money to keep it in reasonable condition. Rumours that the Government are imposing VAT on maintenance costs, will reduce the amount of work that they will be able to do in future - a major concern for all charities in future, including the Trust.

Our Insurance Brokers have found a saving for our Third Party Liability Insurance, and web hosting remains the same.

Sundry expenses include bluebell bulbs for Brook Hollows, paid for from donations in 2023. printing costs, etc. Because the Community Garden do not have a bank account, we were able to receive a grant and pay out for compost bins for the garden.

We have also continued to support the Village Gala, the church Christmas tree and Advent Festival and half of the costs of the planters renewed twice a year.

Bank Charges are a frustration. The more we can receive and pay money via BACs the lower the charges will be, and the happier I am!!! A New Year’s Resolution is to benchmark alternative banks to see if there is a cheaper option. We bank with HSBC and it is cheaper than Lloyds by £2 a month and 20p per cheque transaction.

You might have noticed a very healthy Bank Balance. This has built up over the last three years, mostly from our main fund raiser the Wine Tasting Evening. This will allow us to look for a significant project to fund to benefit the village, whilst still supporting the initiatives we already contribute to.

Thanks go again to David Philips who audits our accounts. It is much appreciated.

Karen Wright Treasurer.

Rolleston Civi¢ Trust Receipts and Payments for Year Ending December 2024 Receipts Income Expense Profit Payments Expense Total Subscrptions and D017ations Subscription Profil 1857.45 Governance 1857.45 Putrlic Liability Insurance Bank Charges Web Hosting Totsl Governance Costs 299.50 72.02 Rollestonian Rolleslonian Advertisin 59.99 2943 431.51 Rolleslon PC Inserts 533.16 Less Costs 3103.10 Other Event Costs Rollestonian Profit 373.06 Christtnas Tree Festrval Total Event Costs 25 25.00 Speakers Entrance Fees 232.25 Donation$ Quiz Night Less Costs 183.40 R￿￿stOn Willage Fayre Society Church Ktsintenance Fund 1(H).00 260.25 1136.00 Speakers Profit 155.40 anlers 275.00 Total Donations 1511.00 Wine Tasting Wine Tasting Receipts Wine Tasting Costs Wine Tastin 1073.02 Sundry Expenses sU￿ry Expenses Total Sund Ex 469 02 1428.72 Profit 604.00 1428.72 FOBH t)onalions 21(￿6.40 Lottery Donat￿nS IFOBHI F08H Costs 482.00 21511.01 FOBH Profit 37.39 Other Income P13nl Sale 1062.15 Car Boot Sale 140.00 Other Incomè 1202.15 Totsl Net Receipt5 29572.83 25343.38 4229.45 Total Payii)gnts 3396.23 Balanc8 as at 1 January 2024 Bank Current A¢counl 6.705.84 Cash in Hand Balance as at 31 Dec$mber 2024 Bank Currenl Account Cash in Hand 105.30 6.811.14 833.22 7614.46 Excess Receipts Opening Balanca 29.90 7.644.36 Closing Balanc• 7644.36 Ihavee the accounts wrth the kx)oks and vouchers by Ro118Ston Civic Trust and certfy thal the accounts submilte(I herewith are a true record. in8r 1 1-1afGU 2oZi