Payments Schedules to Approve:
P Edwards Mileage Claim 12/4/2023
| |
|
|
|
| Date |
Description |
miles |
rate |
total |
| 20/02/2023 |
PCM Feb |
12.6 |
0.45 |
5.67 |
| 06/03/2023 |
Agenda |
12.6 |
0.45 |
5.67 |
| 13/03/2023 |
PCM March |
12.6 |
0.45 |
5.67 |
| 20/03/2023 |
Election notices |
12.6 |
0.45 |
5.67 |
| 03/04/2023 |
Guildhall bath election |
24 |
0.45 |
10.80 |
| 05/04/2023 |
Election notices |
12.6 |
0.45 |
5.67 |
| 12/04/2023 |
Agenda |
12.6 |
0.45 |
5.67 |
| |
|
|
|
44.82 |
P Edwards – petty cash payments
| Philip Edwards |
Petty Cash top up to £100 |
49.79 |
|
49.79 |
Subtotal above: £94.61
| April 2023 |
Payments to approve |
|
|
|
|
|
| Bank Date |
Inv Date |
To |
Details |
Net |
Vat |
Gross |
|
| 18/04/2023 |
12/04/2023 |
Staff |
Staff expenses |
44.82 |
|
44.82 |
|
| 24/04/2023 |
24/03/2023 |
Wicksteed |
Roundabout plate |
74.20 |
14.84 |
89.04 |
|
| 24/04/2023 |
28/03/2023 |
West Harptree VCC |
Electricity contributions |
75.00 |
|
75.00 |
|
| |
|
|
SUBTOTAL |
|
|
|
208.86 |
| April 2023 |
Internal Transfer to approve |
|
|
|
|
|
| Bank Date |
Inv Date |
To |
Details |
Net |
Vat |
Gross |
|
| 18/04/2023 |
12/04/2023 |
Philip Edwards (Petty Cash) |
Internal transfer from bank to Philip Edwards |
52.79 |
|
52.79 |
|
| 18/04/2023 |
12/04/2023 |
Philip Edwards (Petty Cash) |
Internal transfer from Philip Edwards to petty cash |
-52.79 |
|
-52.79 |
|
| |
|
|
SUBTOTAL |
|
|
|
0.00 |
Petty Cash Float
| Date: |
Petty Cash: |
Float Balance: |
To: |
Details: |
| 26/09/2022 |
100 |
100 |
P Edwards |
Cash Float – internal transfer bank to cash float |
| 25/03/2023 |
0.2 |
100.2 |
Philip Edwards |
Wages – returned overpayment tax adjustment |
| 16/03/2023 |
-3 |
97.2 |
M&S |
Christmas Thank you cards |
| 16/03/2023 |
-49.99 |
47.21 |
Blue Nandu |
MS 365 1yr subscription |
To Return Petty Cash float to £100: 100 – 47.21 = £52.79
Payments to note
| Regular payments |
|
|
|
|
|
| Inv Date |
To |
Details |
Net |
Vat |
Gross |
|
| 02/03/2023 |
SSE |
Bus shelter & street lighting |
45.50 |
2.28 |
47.78 |
|
| |
Staff |
Staff salaries, expenses |
450.20 |
|
450.20 |
|
| |
|
SUBTOTAL |
|
|
|
497.98 |
| Petty Cash payments |
|
|
|
|
|
| Inv Date |
To |
Details |
Net |
Vat |
Gross |
|
| 30/11/2022 |
M&S |
Christmas Thank you cards |
3.00 |
|
3.00 |
|
| 16/03/2023 |
Blue Nandu |
MS 365 1yr subscription |
41.31 |
8.68 |
49.99 |
|
| |
|
SUBTOTAL |
|
|
|
52.99 |
Receipts to note
| Mar 2023 |
Receipts |
|
|
|
|
|
|
| Bank Date |
Inv Date |
To |
Details |
Net |
Vat |
Gross |
|
| 31/03/2023 |
|
Natwest |
Bank Interest |
19.39 |
|
19.39 |
|
| |
|
|
SUBTOTAL |
|
|
|
19.39 |
Bank Reconciliation Report
| Reconciliation of balances 31st March 2023 |
|
| Balance per bank statements |
|
|
| NatWest Current A/C |
3,255.67 |
|
| NatWest Reserve A/C |
22,852.26 |
|
| SUBTOTAL bank statements |
|
26,107.93 |
| |
|
|
| Less unpresented payments |
|
0.00 |
| Unbanked cash (cash float) |
47.21 |
47.21 |
| |
|
|
| NET BALANCES |
|
26,155.14 |
| |
|
|
| The net balances reconcile to the Cash Book (receipts and payments account) as follows: |
|
|
| Opening Balance at 1 April 2022 |
|
25,118.82 |
| Add: Receipts in the year |
|
17,999.92 |
| Less: Payments in the year |
|
-16963.60 |
| |
|
|
| CLOSING BALANCE per Cash Book |
|
26,155.14 |
Year to date spend against budget
