Bank reconciliation, year ending 31 March 2016

2015/16 End of Year Accounts
2015/16 Day Book
2015
Transaction
Date
Current Account
Invoice No.
Invoice
Date
Transactio n No.
Payee
18-May-16
02-Apr-15
17-Apr-15
20-Apr-15
05-May-15
05-Jun-15
03-Jul-15
27-Jul-15 3844 30-Apr-15
27-Jul-15 3858 11-Jun-15
27-Jul-15 3870 26-Jun-15
27-Jul-15 3886 30-Jul-15
27-Jul-15 H1146D590C 01-Apr-15
27-Jul-15 H11AD697EE 09-Jul-15
27-Jul-15 4938 01-Apr-15
27-Jul-15 4938 01-Apr-15
27-Jul-15 017557 01-Jul-15
27-Jul-15 01-Jun-15
27-Jul-15 25-Jul-15
27-Jul-15 25-Jul-15
27-Jul-15 25-Jul-15
27-Jul-15 25-Jul-15
27-Jul-15 00017743 27-Apr-15
28-Sep-15
28-Sep-15
30-Sep-15
07-Oct-15 07888 27-Jul-15
12-Oct-15 3904 21-8-115
12-Oct-15 22-Sep-15
19-Oct-15 04-Jun-15
09-Oct-15 20-Sep-15
09-Oct-15 20-Sep-15
08-Oct-15 08-Oct-15
08-Oct-15 547/2079383 01-Sep-15
08-Oct-15 049914 24-Sept 14
08-Oct-15 054273 25-Mar-15
08-Oct-15 056162 09-Jun-15
08-Oct-15 058621 11-Sep-15
08-Oct-15 5257 21-Jul-15
09-Oct-15 E2047002408 08-May-15
08-Oct-15 E2047002409 14-Sep-15
08-Oct-15 POL-2015-02101 31-Aug-15
08-Oct-15
08-Oct-15
08-Oct-15
14-Oct-15 23-Sep-15
26-Oct-15
07-Dec-15 3924 29-Sep-15
07-Dec-15 3087833 30-Sep-15
07-Dec-15 1430231 26-Sep-15
07-Dec-15 153 29-Sep-15
07-Dec-15 059528 09-Oct-15
07-Dec-15 3943 24-Oct-15
07-Dec-15 5105 30-Apr-15
07-Dec-15 24-Nov-15
07-Dec-15 24-Nov-15
07-Dec-15 00018291 04-Aug-15
22-Dec-15 149 03-Nov-15
31-Dec-15
29-Jan-16 5353 25-Nov-15
29-Jan-16 061029 03-Dec-15
29-Jan-16 27-Jan-16
29-Jan-16 27-Jan-16
29-Jan-16 H1263E544A 01-Jan-16
29-Jan-16 01573 12-Jan-16
22-Feb-16 27-Jan-16
29-Mar-16 5446 29-Feb-16
29-Mar-16 5436 16-Feb-16
29-Mar-16 16-Mar-16
29-Mar-16 16-Mar-16
29-Mar-16 063620 19-Mar-16
30-Mar-16 5405 09-Feb-16
31-Mar-16
31-Mar-16 adjustment 23-Jul-14
04-Apr-16 23-Mar-16
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
300052
300053
300056
300054
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
300055
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
BACS
300058
BACS
BACS
BACS
BACS
BACS
BACS
300059
BACS
BACS
BACS
BACS
BACS
BACS
CHEQUE
300060
18-May-16
Item Description
Total
Received
DR CR
Totals 49305.97 35177.73
Total Paid Balance
Bank
Reconciled
14128.24
Balance B/Fwd 2014 11261.74 11261.74
Co-op Interest 1.54 11263.28
SNC Precept PART 1 7330.00 18593.28
Co-op Fee Copy Item 10.00 18583.28
Co-op Interest 1.94 18585.22
Co-op Interest 2.75 18587.97
Co-op Interest 1.69 18589.66
Brown and Barden Grass Cutting 234.85 18354.81
Brown and Barden Grass Cutting 234.85 18119.96
Brown and Barden Grass Cutting 234.85 17885.11
Brown and Barden Grass Cutting 234.85 17650.26
E.On Electricity 156.81 17493.45
E.On Electricity 478.22 17015.23
NCALC Internal Audit 155.00 16860.23
NCALC Subscription 353.39 16506.84
Playsafety Ltd Playground Inspection 78.00 16428.84
S Loake Wages 669.20 15759.64
S Loake Newsletter 105.16 15654.48
S Loake Wages 494.93 15159.55
S Loake Office expenses 9.60 15149.95
S Loake General Maintenance (Bark) 190.00 14959.95
Top Print Newsletter 144.25 14815.70
SNC School Drainage Project 22808.00 37623.70
SNC Precept PART 2 7330.00 44953.70
Unity Interest 3.36 44957.06
Linnell Bros General Maintenance (Bark) 456.00 44501.06
Brown and Barden Grass Cutting 234.85 44266.21
S Lidgley Bulbs 62.48 44203.73
SNAST NHW Subscription 10.00 44193.73
H du Bois Office expenses 33.98 44159.75
H du Bois Wages 319.28 43840.47
ACRE Subscription 35.00 43805.47
Came & Company Insurance 1169.09 42636.38
E.On Lighting Maintenance 124.93 42511.45
E.On Lighting Maintenance 124.93 42386.52
E.On Lighting Maintenance 124.93 42261.59
E.On Lighting Maintenance 124.93 42136.66
NCALC NCALC Training 39.00 42097.66
Helmdon Primary School Field Rent 350.00 41747.66
Helmdon Primary School Drainage Project 22808.00 18939.66
Parish Online Mapping Subs 33.60 18906.06
Helmdon WI Grants to Village Organisations 100.00 18806.06
Helmdon Fellowship Grants to Village Organisations 150.00 18656.06
Whistley Scouts Grants to Village Organisations 250.00 18406.06
Helmdon Churchyard Chuchyard Maintenance 400.00 18006.06
HMRC VAT refund 528.48 18534.54
Brown and Barden Grass Cutting 234.85 18299.69
SNC Election Expenses 39.00 18260.69
BDO LLP External Audit 120.00 18140.69
Clare Nash ArchitecturePump Garden Plans 450.00 17690.69
E.On Electricity Repairs 56.33 17634.36
Brown and Barden Grass Cutting 234.85 17399.51
NCALC NCALC Training 11.33 17388.18
H du Bois Wages 648.26 16739.92
H du Bois Office expenses 40.74 16699.18
Top Print Newsletter 181.75 16517.43
Reading Room Room Hire 127.50 16389.93
Unity Interest 5.68 16395.61
NCALC NCALC Training 150.00 16245.61
E.On Lighting Maintenance 124.93 16120.68
H du Bois Wages 648.26 15472.42
H du Bois Office expenses 32.96 15439.46
E.On Electricity 216.39 15223.07
D Moody WebSite Management 150.00 15073.07
CPRE Subscription 36.00 15037.07
NCALC NCALC Training 39.00 14998.07
NCALC The Good Councillor Guide 25.00 14973.07
H du Bois Wages 635.70 14337.37
H du Bois Office Expenses 55.99 14281.38
E.On Lighting Maintenance 124.93 14156.45
NCALC NCALC Training 34.00 14122.45
Unity Interest 3.85 14126.30
V.Vicars unpresented cheque 26.94 14153.24
ACRE Village of the Year Entry 25.00 14128.24
102
103
103
103
104
105
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
6
6
6
6
6
6
6
6
6
6
6
6
7
7
7
7
7
7
8
9
9
9
9
9
9
9
10
The Unity balance stood at £14,153.24 at 31st March, 2016.
There was one adjustment made for a cheque that was issued on 23-7-14 but never received or cashed.
There was one unpresented cheque for £25.00 which cleared on 4th April – this gives a carry over into
2016/17 of £14,128.24.
1

2015/16 Budget vs Actual
Code EXPENDITURE
100 1. Lighting
101 Street lighting
102 Electricity repairs
103 Other
200 2. Parks & Open Spaces
201 Grass cutting
202 Playground equip. inspection
203 School field rent
204 War memorial and pump garden
205 Bulbs
206 Specific projects from sinking funds
207 General maintenance
208 Other (Jubilee Wall)
300 3. Sinking Fund
301 Playground equipment
302 Notice boards
303 Computer
304 War memorial
305 Village seats
306 Other
400 4. General Administration
401 Audit charge
402 Clerk's salary
403 Clerk's expenses
404 Election expenses
405 Insurances
406 NCALC training
407 Subscriptions
408 Reading Room rent
409 Newsletter (Talkabout)
410 Web site
411 Traffic calming measures
412 Other
500 Grants
501 Grants to Village Organisations
502 Village of the Year – Nat comp
503 S. 137
600 6. Burial Grounds
601 Churchyard Maintenance
602 Contingency
Total Regular Expenditure
701 Transfer Out
702 To Deposit Account
703 Other
704 Vat Paid
Total Expenditure
900 INCOME
901 Precept
902 Interest
903 Allotments
904 Newsletter
905 Grants+Prizes
906 Donations
907 Dividends
908 Village Hall – Reading Room
910 Vat Repayment
Budget
1,500.00
1,100.00
400.00
2014-2015
Actual Remaining
925.59 574.41
613.26 486.74
312.33 87.67
3,087.00 2,580.51
1,420.00 1,369.97
72.00 65.00
350.00 350.00
75.00
20.00 312.21
750.00 483.33
150.00
250.00
625.00 4,579.00
4,579.00
500.00
125.00
7,712.79
280.00
4,601.79
140.00
200.00
1,278.00
58.00
240.00
150.00
565.00
150.00
6,408.94
100.00
4,151.48
75.49
50.00
1,250.00
1,250.00
66.95
1,343.60
1,250.00
93.60
400.00
400.00
400.00
400.00
1,194.78
365.99
28.00
135.00
141.25
150.00
14,574.79 16,237.64
456.46
-28.25
7.00
75.00
-292.21
266.67
150.00
250.00
see sinking fund doc
1,303.85
180.00
450.31
64.51
200.00
83.22
-307.99
212.00
15.00
423.75
-16.95
31.40
125.00
-93.60
-1,662.85
1,472.61
17,710.25
Budget
1,175.00
750.00
425.00
2015-2016
Actual Remaining
1,424.36 -249.36
1,377.42 -627.42
46.94 378.06
3,050.00 25,638.10 -22,588.10
1,500.00 1,369.97 130.03
75.00 65.00 10.00
350.00 350.00
150.00 150.00
75.00 25.13 49.87
750.00 23,258.00 -22,508.00
150.00 570.00 -420.00
see sinking fund doc
7,575.01
255.00
4,015.00
150.00
0.01
1,220.00
150.00
450.00
225.00
960.00
150.00
6,461.71
255.00
3,415.63
173.27
39.00
1,099.43
298.33
462.39
127.50
431.16
150.00
1,113.30
1,350.00
1,350.00
10.00
525.00
500.00
25.00
-10.00
825.00
850.00
-25.00
900.00 400.00 500.00
400.00 400.00
500.00 500.00
14,050.01 34,449.17 -20,399.16
701.62
35,150.79
14,660.00 14,660.00
25.00 19.51
160.00 140.00
5.49
15.00
1,190.00
60.00
-1,190.00
-60.00
22,808.00 22,808.00
3,173.93 -3,173.93 528.48
14,660.00 14,660.00
25.00 20.81
160.00
Total Regular Income
909 Misc Transfers In
19,243.44 38,017.29
Total Working Income 19,243.44 38,017.29
Balance 1,533.19 2,866.50
2
599.37
-23.27
-38.99
120.57
-148.33
-12.39
97.50
528.84
-4.19
-160.00
528.48

2015/16 Bank Reconciliation
Helmdon Parish Council
Bank Reconcilliation
Year Ending 31st March 2016
Unity account balance 31st March 2016 £14,153.24
Less Unpresented cheques
300060 ACRE Vi l l a ge of the Yea r Entry
Total
£25.00
£25.00
Add payments not yet credited
Total
£0.00
£14,128.24
Cash Book Balance at 31st March 2016 £14,128.24
Difference between bank account and cash book £0.00
Summary of Accounts and Holdings
Value at
31.03.15
Value at
31.03.16
£91,805.00 Asset Register £97,120.00
£11,288.69
N/A
Unity
Unity
Tailored Account
Deposit Account
£14,128.24
£0.00
Total £111,248.24 £103,093.69
3

2015/16 Year End Bank Statement
4