Bank reconciliation – pro forma
Name of smaller authority: | Ryde Town Council |
IOW
County area (local councils and parish meetings only):
Financial year ending 31 March 2024
Prepared by (Name and Role): | Robert Clark - Finance Assistant |
Date: | 30/04/2023 |
£ | £ |
Balance per bank statements as at 30/04/23: | |
NWB Business Reserve Account | 45050333 |
NWB Business Current Account | 45050325 |
Mayors Charity | 45183104 |
Nationwide BS | 90160478 |
Network Ryde Business Current | 45182981 |
1,670,227.75 |
1,000.00 |
2,214.95 |
200,000.00 |
1,777.18 |
1,875,219.88 |
Cash Floats |
Ryde Town Council Petty Cash |
Network Ryde Petty Cash |
Marina Cash float |
224.28 |
32.97 |
115.00 |
372.25 |
Less: any unpresented cheques as at 30/04/23 (enter these as negative numbers) | |
Yearly Interest | item 1 |
item 2 | |
item 3 | |
item 4 | |
[add more lines if necessary] | item 5 |
item 6 | |
item 7 | |
item 8 | |
-
Add: any un-banked cash as at 30/04/23 |
Deposit 31 March 2023 |
-
Net balances as at 30/4/23 (Box 8) 1,875,592.13
03/05/2023
Checked By (Name/Job Title) Date
Approved By Chair of Finance Date
Transactions from 24-APR-2023 to 30-APR-2023
Account name or alias
RYDE TOWN COUNCIL
Debit or credit
Any
Account number
45050325
Current cleared balance
27079.62
Sort code
54-41-07
Account currency
GBP
Your deposit is eligible for protection under the Financial Services Compensation Scheme (FSCS). A link to the FSCS Information Sheet and list of exclusions can be found on your digital statement. For further information about the compensation provided by the FSCS, refer to the FSCS website at www.FSCS.org.uk.
Date Type Transaction details Debit Credit Balance
Closing balance 1,000.00
1,000.00
28-Apr-2023 D/D PAYPAL PAYMENT, 5FX2222BXJXY2 -732.99
1,732.99
28-Apr-2023 D/D PAYPAL PAYMENT, 5FX2222BXJXY2 -15.17
1,803.16
1,748.16
28-Apr-2023 D/D ICO, ZA350943 -55.00
28-Apr-2023 POS 2343 27APR23, AMZNBUSINES,
1,823.16
S*4R3CW27G5, AMAZON.CO.UK LU
-20.00
28-Apr-2023 CHG 31MAR A/C 45050325 -39.20
28-Apr-2023 FROM 45050333 262.96
1,862.36
28-Apr-2023 CHP RYDE SCHOOL INV, PCM55CI11606562, RYDE SCHOOL
28-Apr-2023 BAC ANDRE KUROWSKI, MAYOR, FP 28/04/23
0928, 00156471632BBDSHHP
27-Apr-2023 POS 2343 26APR23, AMZNMKTPLACE, AMAZON.
CO.UK GB
-56.99
499.50
1,099.90
1,599.40
99.90
1,000.00
1,062.99
1,056.99
27-Apr-2023 POS 2343 26APR23, GIFFGAFF, LONDON GB -6.00
27-Apr-2023 EBP ISLE OF WIGHT COUN, 9692304/1, FP 27/04
/23 10, 40144028456909000N
-4,806.76
5,869.75
27-Apr-2023 EBP SUPPLIERS, RYDE TOWN COUNCIL, FP / / -25,137.98
1,954.77
27-Apr-2023 FROM 45050333 29,052.96 31,007.73
27-Apr-2023 BAC IL-OPTIMUM LTD, RTC 664, FP 27/04/23
1458, POP4A6OG35LXO9UY5Q
499.50
1,455.27
27-Apr-2023 BAC YIF - ADMIN, YIF EXPENSES, FP 27/04/23 355.37
0350, MF00081A74296C6D00
1,099.90
, RTC 658, FP 27/04/23 1538,
27-Apr-2023 BAC
26-Apr-2023 D/D
200000001117636180
1,009.99
PAYPAL PAYMENT, 5FX2222BXJXY2 -9.99
99.90
1,000.00
26-Apr-2023 EBP COMMUNITY ACTION I, COMMUNITY
ACTION, FP 26/04/23 10, 51135248828512000N
-579.50
26-Apr-2023 FROM 45050333 384.69 1,589.49
26-Apr-2023 BAC CUTTING N, RTC645 ANTIEK, FP 26/04/23
1705, 001824045071624001
26-Apr-2023 BAC SUMUP PAYMENTS ACC, PID282040-
SUMUP, FP 26/04/23 1743, ZLW5NPLOPXO5Q214JM
25-Apr-2023 TO 45050333 -17.91
10.00
194.80
1,204.80
1,194.80
1,000.00
Transactions from 24-APR-2023 to 30-APR-2023
25-Apr-2023 | D/D | BT GROUP PLC, WM38967955-000031 | -183.42 | 1,017.91 | |
25-Apr-2023 | POS | 2343 24APR23, AMZNMKTPLACE, AMAZON. | -12.99 | 1,201.33 | |
25-Apr-2023 | BAC | SUMUP PAYMENTS ACC, PID280934- 5W48NDD9O66WZN9MRO | 125.84 | 1,214.32 | |
25-Apr-2023 | BAC | SUMUP PAYMENTS ACC, PID281483- 5W48NDD955JG1N9MRO | 88.48 | 1,088.48 | |
24-Apr-2023 | D/D | CORONA ENERGY RETA, 20446943 | -199.40 | 1,000.00 | |
24-Apr-2023 | POS | 2343 21APR23, GIFFGAFF, LONDON GB | -6.00 | 1,199.40 | |
24-Apr-2023 | POS | 7164 23APR23, CANVA*, I03764-10504791, | -99.99 | 1,205.40 | |
24-Apr-2023 | POS | 2343 22APR23, GIFFGAFF, LONDON GB | -6.00 | 1,305.39 | |
24-Apr-2023 | FROM 45050333 | 40.59 | 1,311.39 | ||
24-Apr-2023 | BAC | IW COUNCIL - AP, 1000 2002960257 K | 270.80 | 1,270.80 | |
Opening balance | 1,000.00 | ||||
Totals | -31,985.29 | 31,985.29 |
CO.UK GB
SUMUP, FP 24/04/23 1839,
SUMUP, FP 25/04/23 1652,
CAMDEN US
Transactions from 24-APR-2023 to 30-APR-2023
Account name or alias
RYDE TOWN COUNCIL
Debit or credit
Any
Account number
45050333
Current cleared balance
1670227.75
Sort code
54-41-07
Account currency
GBP
Your deposit is eligible for protection under the Financial Services Compensation Scheme (FSCS). A link to the FSCS Information Sheet and list of exclusions can be found on your digital statement. For further information about the compensation provided by the FSCS, refer to the FSCS website at www.FSCS.org.uk.
The interest rate is 1.05% gross 1.06% AER.
This is based on the balance of 30th of April 2023.
Date | Type | Transaction details | Debit | Credit | Balance | |
Closing balance | 1,670,227.75 | |||||
28-Apr-2023 | TO 45050325 | -262.96 | 1,670,227.75 | |||
28-Apr-2023 | INT | 28APR GRS 45050333 | 949.95 | 1,670,490.71 | ||
27-Apr-2023 | TO 45050325 | -29,052.96 | 1,669,540.76 | |||
26-Apr-2023 | TO 45050325 | -384.69 | 1,698,593.72 | |||
25-Apr-2023 | FROM 45050325 | 17.91 | 1,698,978.41 | |||
24-Apr-2023 | TO 45050325 | -40.59 | 1,698,960.50 | |||
Opening balance | 1,699,001.09 | |||||
Totals | -29,741.20 | 967.86 |
Account type: BUSINESS CURRENT
Account number: 45182981
Sort code: 54-41-07
Account name: NETWORK RYDE
Your transactions
Showing: 1-Apr-2023 to 30-Apr-2023, All Transactions
Date | Type | Description | Paid in | Paid out | Balance | ||
28 | Apr | 2023 | CHG | 31MAR A/C 45182981 | £10.15 | £1,777.18 | |
27 | Apr | 2023 | POS | 2482 26APR23, PAYBYPHONE RE ISLE, OF | £2.10 | £1,787.33 | |
, HATFIELD GB | |||||||
26 | Apr | 2023 | POS | 1624 25APR23 , GIFFGAFF , LONDON GB | £10.00 | £1,789.43 | |
26 | Apr | 2023 | POS | 2482 25APR23 C , ICELAND 993 , RYDE GB | £6.20 | £1,799.43 | |
26 | Apr | 2023 | POS | 1624 25APR23 , GIFFGAFF , LONDON GB | £10.00 | £1,805.63 | |
25 | Apr | 2023 | POS | 2482 24APR23 C , ICELAND 993 , RYDE GB | £11.38 | £1,815.63 | |
24 | Apr | 2023 | POS | 1624 21APR23 , GIFFGAFF , LONDON GB | £10.00 | £1,827.01 | |
24 | Apr | 2023 | POS | 2482 20APR23 C , THEWORKS , RYDE GB | £4.00 | £1,837.01 | |
24 | Apr | 2023 | POS | 2482 22APR23 C , CO-OP GROUP 070626, | £19.80 | £1,841.01 | |
RYDE (SF) GB | |||||||
24 | Apr | 2023 | POS | 2482 22APR23 C , POUNDLAND , RYDE GB | £5.50 | £1,860.81 | |
24 | Apr | 2023 | POS | 2482 22APR23 C , THEWORKS , RYDE GB | £5.00 | £1,866.31 | |
24 | Apr | 2023 | POS | 2482 22APR23 C , WH SMITH RYDE IOW , | £5.99 | £1,871.31 | |
RYDE GB | |||||||
24 | Apr | 2023 | POS | 2482 22APR23 , FRENCH FRANKS FOOD, | £10.70 | £1,877.30 | |
COM , RYDE PO33 GB | |||||||
19 | Apr | 2023 | POS | £215.94 | £1,888.00 | ||
MILTON KEYNES GB | |||||||
18 | Apr | 2023 | POS | 2482 17APR23, DOMINO S PIZZA, | £49.37 | £2,103.94 | |
DOMINOS.CO.UK GB | |||||||
14 | Apr | 2023 | POS | 2482 13APR23 , AMZNMKTPLACE , | £4.74 | £2,153.31 | |
AMAZON.CO.UK GB | |||||||
14 | Apr | 2023 | POS | 2482 13APR23 , AMZNMKTPLACE , | £5.48 | £2,158.05 | |
AMAZON.CO.UK GB | |||||||
14 | Apr | 2023 | POS | 2482 13APR23 , AMZNMKTPLACE , | £5.48 | £2,163.53 | |
AMAZON.CO.UK GB | |||||||
14 | Apr | 2023 | POS | 2482 13APR23 C , ICELAND 993 , RYDE GB | £26.45 | £2,169.01 | |
13 | Apr | 2023 | POS | 2482 12APR23 C , ICELAND 993 , RYDE GB | £6.50 | £2,195.46 | |
13 | Apr | 2023 | POS | 2482 12APR23 , AMZNMKTPLACE , | £3.14 | £2,201.96 | |
AMAZON.CO.UK GB | |||||||
13 | Apr | 2023 | POS | 2482 12APR23 C , RYDE SUPERBOWL , | £8.00 | £2,205.10 | |
SURREY GB | |||||||
13 | Apr | 2023 | POS | 2482 12APR23 C , RYDE SUPERBOWL , | £90.00 | £2,213.10 | |
SURREY GB | |||||||
13 | Apr | 2023 | POS | 2482 12APR23 C, TESCO STORES 5567, | £37.38 | £2,303.10 | |
RYDE GB | |||||||
13 | Apr | 2023 | POS | 2482 12APR23 C , SUPERDRUG STORES , | £6.00 | £2,340.48 | |
PLC, RYDE GB | |||||||
13 | Apr | 2023 | BAC | RYDE TOWN COUNCIL , WARD ALLOC , FP | £250.00 | £2,346.48 | |
13/04/23 1415 , 63141534520836000N, | |||||||
WARDALLOC | |||||||
12 | Apr | 2023 | POS | 2482 11APR23 C , ICELAND 993 , RYDE GB | £1.30 | £2,096.48 | |
12 Apr 2023
DPC
FROM A/C 45050325, VIA ONLINE - XFER
£2,000.00
£2,097.78
11 Apr 2023 C/L
POST OFFICE 11APR
£90.00
£97.78
11 Apr 2023 POS
11 Apr 2023
POS
2482 05APR23 , AMZNMKTPLACE , AMAZON.CO.UK GB
2482 05APR23 C , THEWORKS , RYDE GB
£16.99
£187.78
£4.00
£204.77
6 Apr 2023
POS
2482 05APR23 C , JR ZONE , NEWPORT GB
£8.85
£208.77
6 Apr 2023
POS
2482 05APR23 C , JR ZONE , NEWPORT GB
£5.90
£217.62
6 Apr 2023 POS
2482 05APR23 , CO-OP GROUP 070626, RYDE {SF) GB
2482 05APR23 C , POUNDLAND , RYDE GB
£3.35
£223.52
6 Apr 2023
POS
£8.80
£226.87
6 Apr 2023 POS
2482 05APR23 , IKEA LTD SHOP , ONLINE , LONDON GB
2482 05APR23 C , CO-OP GROUP 070626, RYDE {SF) GB
2482 04APR23 , AMZNMKTPLACE , AMAZON.CO , AMAZON.CO.UK GB
2482 04APR23 C , POUNDLAND , RYDE GB
£44.00
£235.67
6 Apr 2023
POS
£5.45
£279.67
5 Apr 2023
POS
£7.79
£285.12
5 Apr 2023
POS
£3.50
£292.91
5 Apr 2023 POS
2482 04APR23 C, ICED INSPIRATIONS, RYDE GB
2482 03APR23 C, TESCO STORES 5567, RYDE GB
2482 03APR23 C, TESCO STORES 5567, RYDE GB
2482 03APR23 , AMZNMKTPLACE , AMAZON.CO.UK GB
2482 03APR23 , AMZNMKTPLACE , AMAZON.CO , AMAZON.CO.UK GB
2482 03APR23 , AMZNMKTPLACE , AMAZON.CO , AMAZON.CO.UK GB
2482 03APR23 , AMZNMKTPLACE , AMAZON.CO , AMAZON.CO.UK GB
£12.38
£296.41
4 Apr 2023
POS
£8.57
£308.79
4 Apr 2023
POS
£33.60
£317.36
4 Apr 2023
POS
£49.94
£350.96
4 Apr 2023
POS
£5.99
£400.90
4 Apr 2023
POS
£2.49
£406.89
4 Apr 2023
POS
£6.99
£409.38
NatWest
© National Westminster Bank Pie, downloaded from the NatWest online transactions service on 2nd May 2023. Search "transactions" on natwest.co.uk for more information.
National Westminster Bank Pie, registered in England and Wales No. 929027. Registered office: 250 Bishopsgate, London EC2M 4M. Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.
Bank reconciliation – pro forma
Name of smaller authority: | Ryde Town Council |
IOW
County area (local councils and parish meetings only):
Financial year ending 31 March 2024
Prepared by (Name and Role): | Robert Clark - Finance Assistant |
Date: | 31/05/2023 |
£ | £ |
Balance per bank statements as at 31/05/23: | |
NWB Business Reserve Account | 45050333 |
NWB Business Current Account | 45050325 |
Mayors Charity | 45183104 |
Nationwide BS | 90160478 |
Network Ryde Business Current | 45182981 |
1,568,364.60 |
1,000.00 |
1,314.60 |
200,000.00 |
6,171.97 |
1,776,851.17 |
Cash Floats |
Ryde Town Council Petty Cash |
Network Ryde Petty Cash |
Marina Cash float |
218.11 |
146.65 |
115.00 |
479.76 |
Less: any unpresented cheques as at 31/05/23 (enter these as negative numbers) | |
Yearly Interest | item 1 |
item 2 | |
item 3 | |
item 4 | |
[add more lines if necessary] | item 5 |
item 6 | |
item 7 | |
item 8 | |
-
Add: any un-banked cash as at 30/04/23 |
Deposit 31 March 2023 |
-
Net balances as at 30/4/23 (Box 8) 1,777,330.93
05/06/2023
Checked By (Name/Job Title) Date
Approved By Chair of Finance Date
Transactions from 29-MAY-2023 to 31-MAY-2023
Account name or alias
RYDE TOWN COUNCIL
Debit or credit
Any
Account number
45050325
Current cleared balance
313.03
Sort code
54-41-07
Account currency
GBP
Your deposit is eligible for protection under the Financial Services Compensation Scheme (FSCS). A link to the FSCS Information Sheet and list of exclusions can be found on your digital statement. For further information about the compensation provided by the FSCS, refer to the FSCS website at www.FSCS.org.uk.
Date Type Transaction details Debit Credit Balance
Closing balance 1,000.00
31-May-2023 D/D WL ITS FUELGENIE, 63562950074709 -9.37 1,000.00
31-May-2023 D/D WIGHTFIBRE LTD, 200022627 -12.06 1,009.37
31-May-2023 D/D WIGHTFIBRE LTD, 200021302 -51.67 1,021.43
31-May-2023 POS 2343 30MAY23, SLCC ENTERPRISES, LTD,
TAUNTON GB
31-May-2023 EBP COMMUNITY ACTION I, 10331, FP 31/05/23
10, 43152328393606000N
-144.00 1,073.10
-932.92 1,217.10
31-May-2023 CHG 28APR A/C 45050325 -31.50 2,150.02
31-May-2023 FROM 45050333 867.69 2,181.52
31-May-2023 BAC SUMUP PAYMENTS ACC, PID298686-
SUMUP, FP 30/05/23 2131, 4Q8MN59Z7YQPJV95GL
31-May-2023 BAC SUMUP PAYMENTS ACC, PID299251-
SUMUP, FP 31/05/23 1613, 4Q8MN59ZYOQ4JV95GL
294.66 1,313.83
19.17 1,019.17
30-May-2023 TO 45050333 -46,914.54 1,000.00
47,914.54
30-May-2023 D/D BT DIRECT DEBITS, SD43164221Q056 -185.43
48,099.97
30-May-2023 D/D BIFFA WASTE SERVIC, R29402 -444.58
48,544.55
30-May-2023 POS 2343 28MAY23, GIFFGAFF, LONDON GB -10.00
48,554.55
30-May-2023 POS 2343 26MAY23, GIFFGAFF, LONDON GB -6.00
48,560.55
30-May-2023 BAC HISTORIC ENGLAND, BACS 47,121.00
30-May-2023 BAC PAYPAL, PPWDL5FX222242MHHG, FP 30/05
/23 1305, PPWD100000000K612V
439.55 1,439.55
Opening balance 1,000.00
Totals -48,742.07 48,742.07
Transactions from 29-MAY-2023 to 31-MAY-2023
Account name or alias
RYDE TOWN COUNCIL
Debit or credit
Any
Account number
45050333
Current cleared balance
1552819.57
Sort code
54-41-07
Account currency
GBP
The interest rate is 1.35% gross 1.36% AER.
This is based on the balance of 31st of May 2023.
Date | Type | Transaction details | Debit | Credit | Balance | |
Closing balance | 1,568,364.60 | |||||
31-May-2023 | TO 45050325 | -867.69 | 1,568,364.60 | |||
31-May-2023 | INT | 31MAY GRS 45050333 | 1,624.36 | 1,569,232.29 | ||
30-May-2023 | FROM 45050325 | 46,914.54 | 1,567,607.93 | |||
Opening balance | 1,520,693.39 | |||||
Totals | -867.69 | 48,538.90 |
Account type: BUSINESS CURRENT
Account number: 45182981
Sort code: 54-41-07
Account name: NETWORK RYDE
Date: 1st June 2023
Showing: 1-May-2023 to 31-May-2023, All Transactions
Date
31 May 2023
31 May 2023
30 May 2023
26 May 2023
26 May 2023
26 May 2023
23 May 2023
22 May 2023
18 May 2023
18 May 2023
17 May 2023
17 May 2023
16 May 2023
10 May 2023
10 May 2023
10 May 2023
5 May 2023
4 May 2023
4 May 2023
3 May 2023
2 May 2023
2 May 2023
2 May 2023
2 May 2023
Type POS CHG
POC POS
POS POS POS POS POS
POS POS
POS
POS POS
POS POS POS POS
DPC POS POC POS
POS POS
Description
2482 30MAY23 C , ICELAND 993 , RYDE GB
28APR A/C 45182981 POST OFFICE 30MAY
2482 25MAY23 , PAYBYPHONE RE ISLE, OF
, HATFIELD GB
1624 25MAY23 , GIFFGAFF , LONDON GB
1624 25MAY23 , GIFFGAFF , LONDON GB
2482 22MAY23 C , ICELAND 993 , RYDE GB
1624 21MAY23 , GIFFGAFF , LONDON GB
2482 17MAY23 , DOMINO S PIZZA , MILTON KEYNES GB
2482 17MAY23 C , ICELAND 993 , RYDE GB
2482 15MAY23 , AMZNBUSINES , S*WW4X00GB5 , LUXEMBOURG, L LU
2482 16MAY23 C , CO-OP GROUP 070626, RYDE (SF) GB
2482 15MAY23 C , ICELAND 993 , RYDE GB
2482 09MAY23 , FLORAL BOUTIQUE , IOW
, RYDE GB
2482 09MAY23 C , ICELAND 993 , RYDE GB
2482 09MAY23 C , ICELAND 993 , RYDE GB
2482 04MAY23 C , ICELAND 993 , RYDE GB
2482 03MAY23 C , CO-OP GROUP 070626, RYDE (SF) GB
FROM A/C 45050325, VIA ONLINE - XFER 2482 02MAY23 C , ICELAND 993 , RYDE GB POST OFFICE 02MAY
2482 29APR23 C , BURGER KING , NEWPORT GB
2482 01MAY23 , AMZNMKTPLACE , AMAZON.CO.UK GB
2482 29APR23 , AMZNMKTPLACE , AMAZON.CO.UK GB
Paid in
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
£5,000.00
-
-
-
-
-
-
Paid out
£3.50
£2.50
£10.00
£15.40
£10.50
£10.00
£42.00
£10.00
£34.90
£15.59
£22.55
£150.00
£8.75
-
£4.25
£7.23
£35.00
£17.67
£10.10
£12.79
£150.00
£1,728.28
£6,556.70
£6,571.05
£1,578.28
£6,560.95
£1,571.05
£1.25
£14.24
£6,339.87
£6,350.37
£6,174.47
£6,444.92
£6,392.92
£6,402.92
£6,360.37
£6,189.87
£6,453.67
£6,370.37
£6,488.57
£6,504.16
£6,507.66
£6,171.97
Balance
£1,745.95
£16.99
£6,555.45
£1,760.19
£6,542.66
© National Westminster Bank Plc, downloaded from the NatWest online transactions service on 1st June 2023. Search ''transactions'' on natwest.co.uk for more information.
National Westminster Bank Plc, registered in England and Wales No. 929027. Registered office: 250 Bishopsgate, London EC2M 4AA. Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.
Account type: BUSINESS CURRENT
Account number: 45183104
Sort code: 54-41-07
Account name: RYDE TOWN MAYORS CHA
Your transactions
Showing: 1-Apr-2023 to 31-May-2023, All Transactions
Date | Type | Description | Paid in | Paid out | Balance |
31 Moy 2023 | CHG | 28APR A/C 45183104 | £0.35 | £1,314.60 | |
2 Moy 2023 | DPC | OAKFIELD CE PRIMAR, DONATION , VIA | £500.00 | £1,314.95 | |
ONLINE - PYMT , FP 02/05/23 10 , | |||||
45101208048115000N | |||||
2 Moy 2023 | DPC | IW FOOD BANK , DONATION , VIA ONLINE | £400.00 | £1,814.95 | |
- PYMT | |||||
28 Apr 2023 | CHG | 31MAR A/C 45183104 | £3.31 | £2,214.95 | |
11 Apr 2023 | BAC | PORTER S , RUG BAND , FP 06/04/23 2236 | £100.00 | £2,218.26 | |
, RP4679965724327300 |
© National Westminster Bank Pie, downloaded from the NatWest online transactions service on 5th June 2023. Search "transactions" on natwest.co.uk for more information.
National Westminster Bank Pie, registered in England and Wales No. 929027. Registered office: 250 Bishopsgate, London EC2M 4M. Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.