Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
229x Filetype XLSX File size 0.05 MB Source: www.clapham-wsx-pc.gov.uk
Sheet 1: Bank Reconciliation 30.9.21
| Financial Year Ending 31 March 2022 | |||||||||||||||
| Clapham Parish Council | |||||||||||||||
| £ | £ | ||||||||||||||
| Balances per bank statement at 30.9.21 | Cash Book at 30/9/21 | £ | |||||||||||||
| Community Acct Bal | 9,680.92 | Cash Book | Bal B/F 1/4/21 | 23232.36 | |||||||||||
| Community Instant Access Acct Bal | 15,058.07 | 24,738.99 | Add Receipts | 12916.05 | |||||||||||
| Less Payments | -12023.84 | ||||||||||||||
| Add: outstanding receipts | Bal C/F 30/9/21 | 24124.57 | |||||||||||||
| Balances at 31/3/21 | REPRESENTED BY | ||||||||||||||
| Community Acct Bal | 9680.92 | ||||||||||||||
| - | Community Instant Access Acct Bal | 15058.07 | |||||||||||||
| Less: outstanding payments | Less cheques issued not presented as at 30/9/21 | -614.42 | |||||||||||||
| cheque no. | 800232 | 12.00 | |||||||||||||
| 800234 | 108.10 | 24124.57 | |||||||||||||
| 800235 | 360.00 | ||||||||||||||
| 800236 | 32.12 | ||||||||||||||
| 800237 | 90.20 | ||||||||||||||
| 800238 | 12.00 | 614.42 | |||||||||||||
| Net bank balances as at 30/9/21 | 24,124.57 | ||||||||||||||
| (per cashbook) | |||||||||||||||
| Prepared by | |||||||||||||||
| Sarah Linfield Clerk/RFO |
| Year to Date 1/4/21 - 31/3/22 | YTD Actuals | YTD Budget Planned | YTD Variance to Budget | % Actual Spend YTD v Annual Budget | ||||
| Receipts | At 30.9.21 | £ | ||||||
| Precepts | £12,661.00 | £12,661.00 | £0.00 | |||||
| Bank Interest | £7.30 | £10.00 | £2.70 | |||||
| Grant | £0.00 | £- | £0.00 | |||||
| VAT ( PRIOR YR REFUND) | £247.75 | £400.00 | £152.25 | |||||
| Total Receipts | £12,916.05 | £13,071.00 | £154.95 | |||||
| Payments | ||||||||
| Admin costs | £169.97 | £225.00 | £55.03 | Within Budget | 75.54% | |||
| Clerk’s salary – gross | £2,801.96 | £5,450.00 | £2,648.04 | Within Budget | 51.41% | |||
| Clerk “overtime” - gross | £0.00 | £- | £0.00 | Within Budget | #DIV/0! | |||
| Defibrillator | £0.00 | £25.00 | £25.00 | Within Budget | 0.00% | |||
| Electoral expenses | £0.00 | £750.00 | £750.00 | Within Budget | 0.00% | |||
| Expenses - Clerk | £96.36 | £180.44 | £84.08 | Within Budget | 53.40% | |||
| Expenses - Councillors | £0.00 | £- | £0.00 | Within Budget | #DIV/0! | |||
| External Auditor | £300.00 | £245.00 | -£55.00 | Over Budget | 122.45% | |||
| GDPR Compliance/Lap top | £0.00 | £- | £0.00 | Within Budget | #DIV/0! | |||
| Grant /Donations | £99.31 | £250.00 | £150.69 | Within Budget | 39.72% | |||
| Gritting | £0.00 | £550.00 | £550.00 | Within Budget | 0.00% | |||
| Hall hire/Zoom subscription | £35.99 | £117.00 | £81.01 | Within Budget | 30.76% | |||
| Insurance | £439.61 | £378.26 | -£61.35 | Over Budget | 116.22% | Admin fee £50 | ||
| Internal auditor | £100.00 | £300.00 | £200.00 | Within Budget | 33.33% | |||
| New Equipment | £86.57 | £75.00 | -£11.57 | Over Budget | 115.43% | Litter picking - equipment on loan | ||
| Newsletter | £132.00 | £120.00 | -£12.00 | Over Budget | 110.00% | |||
| Noticeboard refurbishment | £0.00 | £100.00 | £100.00 | Within Budget | 0.00% | |||
| Playground & Adult Gym Equipment, annual checks and rec ground maintenance | £0.00 | £600.00 | £600.00 | Within Budget | 0.00% | |||
| Recreation events | £0.00 | £1,000.00 | £1,000.00 | Within Budget | 0.00% | |||
| Recreation ground (grass-cutting and maintenance) | £623.94 | £1,000.00 | £376.06 | Within Budget | 62.39% | |||
| Subscriptions | £118.00 | £256.30 | £138.30 | Within Budget | 46.04% | |||
| Training costs | £235.00 | £240.00 | £5.00 | Within Budget | 97.92% | |||
| VAT | £1,148.84 | |||||||
| Waste bins on Recreation Ground | £0.00 | £600.00 | £600.00 | Within Budget | 0.00% | |||
| Website (hosting and maintenance) | £50.00 | £199.00 | £149.00 | Within Budget | 25.13% | |||
| Copy of NP evidence base | £275.00 | £- | -£275.00 | Over Budget | Copy of NP evidence base | |||
| Insurance/repair claims | £283.29 | £- | -£283.29 | Over Budget | Unexpected repair claim and policy excess for horse chestnut claim | |||
| CIL spend | £5,028.00 | £- | -£5,028.00 | Over Budget | From Ear Marked Reserves | CIL spend -path | ||
| Total Payments | £12,023.84 | £12,661.00 |
| RESERVES: at 30.9.21 | Commentary/Explanation | |||||
| Brought forward | Income Per I&E | Expenditure per I&E | Transfers | At 30.9.21 | ||
| 1.4.21 | ||||||
| RESERVES: | 23,232.36 | £12,916.05 | -£12,023.84 | £24,124.57 | ||
| (1)TOTAL GENERAL RESERVES | 9,381.61 | £12,916.05 | -£6,995.84 | -£1,500.00 | £13,801.82 | |
| (2)TOTAL EARMARKED RESERVES | ||||||
| Recreation Refurbishment (CIL) | 4,664.91 | -£4,664.91 | £- | Part of spend on path, manhole cover and remove old play surface, total £5028 (resudue from CIL VAT - see line 16) | ||
| Pocket Parks | £- | |||||
| Playground Donation | £- | |||||
| Election costs | 750.00 | £1,500.00 | £2,250.00 | Transfers 2020/21 (5.5.21 minute 12 (iii) 2021/22 (29.7.21 minute 33 (iv)) |
||
| VAT (on Pocket Park, CIL & Donation spend) | ||||||
| CIL VAT | 3,251.35 | -£363.09 | £2,888.26 | Line 16 -part of spend on path, manhole cover and remove old play surface, total £5028 | ||
| CPR Donation VAT | 1,017.45 | £1,017.45 | ||||
| Pocket Parks VAT | 4,167.04 | £4,167.04 | £840 refunded April 2020 & £3327.04 Nov 2020 | |||
| TOTAL RESERVES (1) + (2): | 23,232.36 | £12,916.05 | -£12,023.84 | £- | £24,124.57 | |
no reviews yet
Please Login to review.
