## **Longstanton Village Hall and Recreation Ground** 

## **Charity No.: 300408** 

## Annual Report 2021/22 

## Charity Information 

**Address** 

24 High Street Longstanton Cambridge CB24 3BS 

**Trustees** Longstanton Parish Council (Sole Trustee) **Bankers** Unity Trust Bank 

**Independent Examiners** Canalbs Ltd **Accounting Period** 1/4/2020 to 31/3/2021 

**Monthly meeting date** 3[rd] Tuesday of the month (or the 4[th] Tuesday of the 3[rd] isn’t after the 20[th] of the month) 

## Trustee Report 

2020/21 was a challenging year for the charity with ever changing COVID restrictions, starting with a full shutdown of the Village Hall and Pavilion to various stages of opening with restrictions in opening hours and permitted activity types. 

The Recreation Ground has been able to stay open for access throughout COVID and allowed residents to access a safe outdoor space for exercise and recreation. 

The Charity is responsible for the Village Hall at 24 High Street, and the Recreation ground (including the pavilion) on Over Road. The Pavilion is on a lease to operate as a bar and there are agreements with some of the sports clubs, with some still being reviewed, to use areas of the recreation ground for their respective activities. The Village Hall is available for hire and is used by a range of community groups and individuals. The back office is let to the Parish Council. 

The Charity is currently in negotiations to transfer the Recreation Ground extension into its ownership. It is currently privately owned and open for public use by agreement with the owner. 

Long term the Charity hopes to build an improved pavilion facility on the land. 

The Finances of the Charity have been sustained during COVID by grants which have left the Charity in a good financial position. 

Hopefully the Hall will soon be able to get back to normal operation. Many clubs are starting to get going again although much is dependent on government guidance for safe use. 

**Longstanton Village Hall and Recreation Ground** 

Longstanton Village Hall, 24 High Street, Longstanton, Cambridge, CB24 3BS Tel: 01954 782323    Email: villageinstitute@gmail.com 



13/06/2021 

Page 1 

**Longstanton Village Hall & Recreation** 

> 12:25 **Detailed Balance Sheet - Excluding Stock Movement** 

## **Month 12  Date 31/03/2021** 

||||**Month 12  Date 31/03/2021**|**Month 12  Date 31/03/2021**|**Month 12  Date 31/03/2021**|
|---|---|---|---|---|---|
|**A/c**|**Description**||**Actual**|||
||_Current Assets_|||||
|105|VAT Control A/c||1,117|||
|200|Current Bank A/c||43,231|||
||**Total Current Assets**||**44,348**|||
|||||||
||_Current Liabilities_|||||
|501|Other Creditors||60|||
|565|Holding Deposits||300|||
|566|Damage Deposits||250|||
||**Total Current Liabilities**|||**610**||
|||||||
||**Net Current Assets**||||**43,738**|
|**Total Assets less Current Liabilities**|||||**43,738**|
||_Represented by :-_|||||
|300|Current Year Fund||19,766|||
|310|General Reserves||3,446|||
|320|Pavilion Earmarked Reserves||20,527|||
||**Total Equity**||||**43,738**|
|||||||





> 13/06/2021 Longstanton Village Hall & Recreation 

12:26 

Current Month is: 12 

Receipts and Payments Summary - Cashbook 1 

Current Bank A/c 

|||Receipt Totals|Payment Totals||
|---|---|---|---|---|
|Month 1||0.00|614.52||
|Month 2||1,229.83|708.60||
|Month 3||310.48|543.66||
|Month 4||882.76|1,014.33||
|Month 5||775.18|741.64||
|Month 6||990.15|1,399.91||
|Month 7||21,492.20|1,573.67||
|Month 8||1,285.71|461.48||
|Month 9||1,091.34|2,163.64||
|Month 10||1,037.59|295.93||
|Month 11||375.00|140.00||
|Month 12||1,097.11|158.00||
|Closing Balance<br>Total Receipts / Payments<br>Opening Balance||53,046.62<br>22,479.27<br>30,567.35|43,231.24<br>53,046.62<br>9,815.38|43,231.24<br>Closing Trial<br>Balance|
||||||
||||||





13/06/2021 12:23 

Page 1 

## Longstanton Village Hall & Recreation 

## Earmarked Reserves 

||Account||Opening Balance||Net Transfers||Closing Balance|
|---|---|---|---|---|---|---|---|
|320|Pavilion Earmarked Reserves||0.00||20,526.62||20,526.62|
||||0.00||20,526.62||20,526.62|
|||||||||
|||||||||





13/06/2021 12:26 

Page 1 

Longstanton Village Hall & Recreation 

Month No: 12 

Detailed Income & Expenditure by Budget Heading 31/03/2021 

Cost Centre Report 

|||Actual Year<br>To Date|Current<br>Annual Bud|Variance<br>Annual Total|Committed<br>Expenditure<br>Funds<br>Available|Committed<br>Expenditure<br>Funds<br>Available|% Spent|Transfer<br>to/from EMR|
|---|---|---|---|---|---|---|---|---|
|100|General Income||||||||
|560|Receipts in Advance|(250)|0|250|||0.0%||
|1070|Pavilion Rent|24,839|0|(24,839)|||0.0%|20,527|
|1075|Pavilion Insurance|192|0|(192)|||0.0%||
|1100|Hall Hire|1,418|8,000|6,582|||17.7%||
|1140|Office Rental|2,702|3,602|900|||75.0%||
|1150|Recreation Ground Income|200|0|(200)|||0.0%||
||General Income :- Income|29,101|11,602|(17,499)|||||
||Net Income|29,101|11,602|(17,499)|||||
|6001|less Transfer to EMR|20,527|||||||
||Movement to/(from) Gen Reserve|8,574|||||||
|110|Administration||||||||
|4001|Refund of Deposit|350|0|(350)||(350)|0.0%||
|4100|Bank Charges|72|72|0||0|100.0%||
|4120|Professional Fees|925|3,600|2,675|210|2,465|31.5%||
|4130|Subscriptions & Memberships|792|700|(92)||(92)|113.2%||
|4140|Insurance|887|900|13||13|98.6%||
|4150|Stationery|21|45|24||24|47.3%||
|4160|Postage|10|8|(2)||(2)|131.3%||
|4170|Fixtures & Fittings|230|200|(30)||(30)|114.8%||
|4180|Cleaning Materials|206|200|(6)||(6)|103.2%||
|4190|Cleaning|662|3,096|2,434||2,434|21.4%||
|4200|Gas|1,483|900|(583)||(583)|164.7%||
|4210|Electric|1,265|900|(365)||(365)|140.6%||
|4220|Water|10|300|290||290|3.2%||
|4225|Health & Safety|0|300|300||300|0.0%||
|4230|Document Storage|0|40|40||40|0.0%||
|4990|Sundries|0|100|100||100|0.0%||
||Administration :- Indirect Expenditure|6,912|11,361|4,448||||0|
||||||210|4,238|62.7%||
||Net Expenditure|(6,912)|(11,361)|(4,448)|||||
|120|Maintenance||||||||
|4400|Window Cleaning|10|80|70||70|12.5%||
|4410|Fire Extinguisher|156|330|174||174|47.3%||
|4420|Plumbing & Heating|443|300|(143)||(143)|147.7%||
|4430|Repairs|1,720|600|(1,120)|5,460|(6,580)|1196.7%||
|4435|Grounds Maintenance|94|0|(94)||(94)|0.0%||



Continued over page 



13/06/2021 

Page 2 

Longstanton Village Hall & Recreation 

12:26 

Detailed Income & Expenditure by Budget Heading 31/03/2021 

Month No: 12 Cost Centre Report 

||Actual Year<br>To Date|Current<br>Annual Bud|Variance<br>Annual Total|Committed<br>Expenditure<br>Funds<br>Available|Committed<br>Expenditure<br>Funds<br>Available|% Spent|Transfer<br>to/from EMR|
|---|---|---|---|---|---|---|---|
|4990 Sundries|0|50|50||50|0.0%||
|Maintenance :- Indirect Expenditure|2,423|1,360|(1,063)|||||
|||||5,460|(6,523)|||
|Net Expenditure|(2,423)||1,063|||||
|||(1,360)||||||
|||||||||
|Grand Totals:- Income<br>Net Income over Expenditure<br>Expenditure|9,335<br>29,101<br>19,766|12,721<br>11,602|(17,499)<br>3,385<br>(20,884)|5,670|(2,285)|250.8%<br>118.0%||
|||(1,119)||||||
|||||||||
|less Transfer to EMR|20,527|||||||
|Movement to/(from) Gen Reserve|(761)|||||||





13/06/2021 12:24 

Page 1 

User :EW 

## Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>100 Debtors<br>(none)|Date<br>Reference<br>100 Debtors<br>(none)|Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||||Opening Balance<br>1,466.50|||
||1|01/04/2020|7|Journal|Debtors|1,466.50||
||||Debtors<br>Account<br>Centre||Account Totals<br>0.00<br>Net Balance Month 12<br>1,466.50<br>1,466.50<br>____________<br>____________|||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>101 Other Debtors<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
|||||||||
||||Other Debtors<br>Account<br>Centre||Account Totals<br>Net Balance Month 12<br>0.00<br>____________|____________|0.00<br>0.00<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>105 VAT Control A/c<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
||||||Opening Balance<br>1,116.66|||
||1|01/04/2020|Purchase Ledger||Daybook Page No : 14<br>51.99|||
||2|01/05/2020|Purchase Ledger||Daybook Page No : 15<br>53.04|||
||2|01/05/2020|109<br>Cashbook||Dual fuel new account<br>6.43|||
||2|07/05/2020|106<br>Cashbook||Scottish Hydro<br>5.81|||
||2|18/05/2020|108<br>Cashbook||Closing balance<br>6.18|||
||3|01/06/2020|Purchase Ledger||Daybook Page No : 16<br>19.36|||
||3|01/06/2020|BULBJUN<br>Cashbook||June Utilities Payment<br>6.43|||
||3|22/06/2020|111<br>Cashbook||Annual Membership<br>9.50|||
||4|30/06/2020|Purchase Ledger||Daybook Page No : 17<br>81.77|||
||4|30/06/2020|BULBJUL<br>Cashbook||Utilities for July<br>6.43|||
||4|01/07/2020|Purchase Ledger||Daybook Page No : 18<br>13.69|||
||4|01/07/2020|Purchase Ledger||Daybook Page No : 19<br>9.50|||
||4|01/07/2020|9<br>Journal||Entered into cashbook<br>5.81|||
||4|01/07/2020|10<br>Journal||Entered into cashbook<br>6.18|||
||5|01/07/2020|Purchase Ledger||Daybook Page No : 20|||
||5|01/08/2020|Purchase Ledger||Daybook Page No : 21<br>6.00|||
||5|01/08/2020|Purchase Ledger||Daybook Page No : 22<br>53.40|||
||5|03/08/2020|DD0801<br>Cashbook||Monthly Gas & Electricity<br>6.43|||
||6|01/09/2020|Purchase Ledger||Daybook Page No : 23|||
||6|01/09/2020|DD0903<br>Cashbook||Monthly DD<br>6.43|||
||7|01/10/2020|DD<br>Cashbook||Monthly Bill<br>6.43|||
||7|19/10/2020|Purchase Ledger||Daybook Page No : 24<br>189.19|||
||8|01/11/2020|Purchase Ledger||Daybook Page No : 25<br>79.35|||





13/06/2021 

Page 2 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

12:24 

A/c Code 105 VAT Control A/c 

||Centre<br>Month|Date<br>(none)|Reference|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||8|01/11/2020|DD|Cashbook|Monthly Gas & Electric|6.43||
||9|01/11/2020|Purchase Ledger||Daybook Page No : 26|203.17||
||9|01/12/2020|Purchase Ledger||Daybook Page No : 27|37.40||
||9|01/12/2020|DD<br>Cashbook||Monthly DD|25.00||
||10|01/01/2021|Purchase Ledger||Daybook Page No : 28|25.98||
||10|04/01/2021|DD<br>Cashbook||Monthly Utilities|6.43||
||11|01/02/2021|DD<br>Cashbook||Monthly Utilities|6.43||
||12|01/03/2021|DD<br>Cashbook||Monthly Utility Bills|6.43||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||10.04|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||43.00|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||40.00|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||19.36|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||9.50|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||4.17|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||57.80|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||53.40|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||6.00|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||66.46|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||122.73|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||13.29|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||66.06|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||25.00|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||53.17|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||150.00|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||14.32|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||37.40|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT||11.66|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||5.81|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.18|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||5.81|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.18|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||10.30|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||13.69|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT||6.43|
||12|31/03/2021|13<br>Journal||Correcting incorrect VAT|5.81||
||12|31/03/2021|13<br>Journal||Correcting incorrect VAT|6.18||





13/06/2021 12:24 

Page 3 User :EW 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>105 VAT Control A/c<br>(none)|Date<br>Reference<br>105 VAT Control A/c<br>(none)|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||VAT Control A/c<br>Account<br>Centre||Account Totals<br>1,116.66<br>Net Balance Month 12<br>2,053.78<br>937.12<br>____________<br>____________|____________||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>200 Current Bank A/c<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Refer to Cashbook For Details|||
|||||||||
||||Current Bank A/c<br>Account<br>Centre||Account Totals<br>Refer to Cashbook<br>____________|____________|____________|
|||||||||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>310 General Reserves<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
||||||Opening Balance||23,972.26|
|||||||||
||||General<br>Account<br>Centre|Reserves|Account Totals<br>Net Balance Month 12<br>0.00<br>____________|____________|23,972.26<br>23,972.26<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>Source<br>320 Pavilion Earmarked Reserves<br>(none)|||Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||0.00|
||7|23/10/2020|BACS|Cashbook|Pavilion Earmarked Reserves||20,526.62|
||||Pavilion<br>Account<br>Centre|Account Totals<br>Net Balance Month 12<br>Earmarked Reserves<br>0.00<br>____________||____________|20,526.62<br>20,526.62<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>500 Creditors<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||0.00|
||1|01/04/2020|Purchase Ledger||Daybook Page No : 14||727.88|
||1|01/04/2020|100<br>Cashbook||Fenland Roofline Limited<br>240.00|||
||1|01/04/2020|101<br>Cashbook||Longstanton Parish Council<br>145.98|||
||1|01/04/2020|102<br>Cashbook||Anglian Water Business Limited<br>90.04|||





13/06/2021 12:24 

Page 4 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>500 Creditors<br>(none)|Date<br>Reference<br>500 Creditors<br>(none)|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||2|01/05/2020|Purchase Ledger||Daybook Page No : 15||318.24|
||2|01/05/2020|105<br>Cashbook||Complete Cleaning Management L|318.24||
||3|01/06/2020|Purchase Ledger||Daybook Page No : 16||280.16|
||3|30/06/2020|106<br>Cashbook||Jaydee Living Limited|116.16||
||3|30/06/2020|107<br>Cashbook||Longstanton Parish Council|164.00||
||4|30/06/2020|Purchase Ledger||Daybook Page No : 17||645.21|
||4|01/07/2020|Purchase Ledger||Daybook Page No : 18||287.62|
||4|01/07/2020|112<br>Cashbook||Cambridgeshire ACRE|82.00||
||4|01/07/2020|113<br>Cashbook||PPL PRS Limited|346.76||
||4|01/07/2020|Purchase Ledger||Daybook Page No : 19|57.00||
||4|01/07/2020|9<br>Journal||Entered into cashbook|122.04||
||4|01/07/2020|10<br>Journal||Entered into cashbook|129.82||
||4|13/07/2020|115<br>Cashbook||SSE Southern Electric|216.45||
||4|20/07/2020|114<br>Cashbook||SSE Scottish Hydro|287.62||
||4|22/07/2020|ACREcorr<br>Cashbook||Cambridgeshire ACRE||57.00|
||5|01/07/2020|Purchase Ledger||Daybook Page No : 20||603.14|
||5|01/08/2020|5001<br>Cashbook||Customark Limited|195.00||
||5|01/08/2020|5002<br>Cashbook||GDL Services|408.14||
||5|01/08/2020|Purchase Ledger||Daybook Page No : 21||36.00|
||5|01/08/2020|Purchase Ledger||Daybook Page No : 22||320.40|
||6|01/09/2020|9001<br>Cashbook||Complete Cleaning Management L|36.00||
||6|01/09/2020|9002<br>Cashbook||J Kilborn & Son Limited|320.40||
||6|01/09/2020|Purchase Ledger||Daybook Page No : 23||887.01|
||6|01/09/2020|9003<br>Cashbook||Community Action Suffolk Limit|887.01||
||7|19/10/2020|Purchase Ledger||Daybook Page No : 24||1,135.17|
||7|31/10/2020|10001<br>Cashbook||Complete Cleaning Management L|398.77||
||7|31/10/2020|10002<br>Cashbook||PS Plumbing Solutions Limited|736.40||
||8|01/11/2020|Purchase Ledger||Daybook Page No : 25||321.48|
||8|01/11/2020|2011001<br>Cashbook||Complete Cleaning Management L|79.75||
||8|27/11/2020|2011002<br>Cashbook||SSE Southern Electric|241.73||
||9|01/11/2020|Purchase Ledger||Daybook Page No : 26||1,781.24|
||9|01/12/2020|Purchase Ledger||Daybook Page No : 27||224.40|
||9|31/12/2020|2012001<br>Cashbook||Complete Cleaning Management L|319.02||
||9|31/12/2020|2012002<br>Cashbook||DB Roofing Services|529.00||
||9|31/12/2020|2012003<br>Cashbook||GDL Services|33.22||
||9|31/12/2020|2012004<br>Cashbook||Hallmaster LiImited|224.40||
||9|31/12/2020|2012005<br>Cashbook||Wellers Hedleys|900.00||
||10|01/01/2021|Purchase Ledger||Daybook Page No : 28||155.93|
||10|31/01/2021|2101001<br>Cashbook||Chubb Fire & Security Limited|155.93||
||||Creditors<br>Account<br>Centre||Account Totals<br>0.00<br>Net Balance Month 12<br>7,780.88<br>7,780.88<br>____________<br>____________|____________||





|13/06/2021<br>12:24|13/06/2021<br>12:24|||Nominal Ledger Report by ACCOUNT<br>Longstanton Village Hall & Recreation|Nominal Ledger Report by ACCOUNT<br>Longstanton Village Hall & Recreation||User :EW<br>Page 5|
|---|---|---|---|---|---|---|---|
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>501 Other Creditors<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||540.17|
||1|01/04/2020|6|Journal|Creditors|480.20||
||||Other Creditors<br>Account<br>Centre||Account Totals<br>Net Balance Month 12<br>480.20<br>____________|____________|59.97<br>540.17<br>____________|
|||||||480.20||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>560 Receipts in Advance<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||0.00|
||1|01/04/2020|8|Journal|Dep for New Year Party|250.00||
||||Receipts in Advance<br>General Income<br>Account<br>Centre||Account Totals<br>250.00<br>Net Balance Month 12<br>250.00<br>____________|____________|0.00<br>____________|
|||||||250.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>565 Holding Deposits<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
||||||Opening Balance||300.00|
|||||||||
||||Holding<br>Account<br>Centre|Deposits|Account Totals<br>Net Balance Month 12<br>0.00<br>____________|____________|300.00<br>300.00<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>566 Damage Deposits<br>(none)||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||250.00|
|||||||||
||||Damage<br>Account<br>Centre|Deposits|Account Totals<br>Net Balance Month 12<br>0.00<br>____________|____________|250.00<br>250.00<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>1070 Pavilion Rent<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
||||||Opening Balance||0.00|
||4|20/07/2020|101125|Cashbook|101125 - Pavilion Rent July||375.00|
||5|10/08/2020|BACS|Cashbook|Inv 101127 - Aug Rent||375.00|





13/06/2021 

Page 6 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

12:24 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>1070 Pavilion Rent<br>100 General Income|Date<br>Reference<br>1070 Pavilion Rent<br>100 General Income|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||6|01/09/2020|JARSep20|Cashbook|Pavilion Rent Sept (101130)||468.75|
||7|01/10/2020|BACS|Cashbook|Pavilion Rent - Oct Inv 101134||562.50|
||7|23/10/2020|BACS|Cashbook|Pavilion Earmarked Reserves||20,526.62|
||8|03/11/2020|PavRent|Cashbook|Pavilion Rent - Nov 20||656.25|
||9|01/12/2020|101142|Cashbook|Pavilion Rent - December||750.00|
||10|08/01/2021|101151|Cashbook|101151 - Pavilion Rent - Jan||375.00|
||11|02/02/2021|JarJarRent|Cashbook|Pavilion Rent February||375.00|
||12|01/03/2021|JarJarRent|Cashbook|March Pavilion Rent||350.00|
||12|02/03/2021|JarJarRent|Cashbook|March Rent||25.00|
||||Pavilion<br>General<br>Account<br>Centre|Rent<br>Income|Account Totals<br>Net Balance Month 12<br>0.00<br>____________|____________|24,839.12<br>24,839.12<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>1075 Pavilion Insurance<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||0.00|
||4|06/07/2020|101124|Cashbook|101124 - Insurance||192.14|
||||Pavilion<br>General<br>Account<br>Centre|Insurance<br>Income|Account Totals<br>Net Balance Month 12<br>0.00<br>____________|____________|192.14<br>192.14<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>1100 Hall Hire<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>8,000<br>0|
|||||||Debit||
||||||Opening Balance||0.00|
||1|01/04/2020|7|Journal|Music Madness<br>20.56|||
||1|01/04/2020|7|Journal|All Saints Church<br>51.45|||
||1|01/04/2020|7|Journal|Music Madness<br>15.43|||
||1|01/04/2020|7|Journal|Longstanton WI<br>20.58|||
||1|01/04/2020|7|Journal|Mucky Pups<br>20.58|||
||1|01/04/2020|7|Journal|All Saints Church<br>41.16|||
||1|01/04/2020|7|Journal|Longstanton PC<br>144.06|||
||1|01/04/2020|7|Journal|Cambridge Freestyle<br>72.04|||
||1|01/04/2020|7|Journal|Zumba Gold<br>30.87|||
||1|01/04/2020|7|Journal|Music Madness<br>10.30|||
||1|01/04/2020|7|Journal|Rainbow Baby Club<br>10.30|||
||1|01/04/2020|7|Journal|All Saints Church<br>30.87|||
||1|01/04/2020|7|Journal|LDHS<br>15.44|||
||1|01/04/2020|7|Journal|Longstanton WI<br>20.58|||
||1|01/04/2020|7|Journal|Little Leprechauns<br>20.58|||
||1|01/04/2020|7|Journal|Clare Harrison<br>20.58|||





13/06/2021 

Page 7 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

12:24 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>1100 Hall Hire<br>100 General Income|Date<br>Reference<br>1100 Hall Hire<br>100 General Income|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||1|01/04/2020|7|Journal|Mucky Pups|20.58||
||1|01/04/2020|8|Journal|Dep for New Year Party||250.00|
||2|04/05/2020|101119|Cashbook|Little Leprechauns 101119||20.58|
||2|04/05/2020|101115|Cashbook|101115 Cambs Freestyle Hall||72.04|
||2|06/05/2020|101113|Cashbook|101113 Zumba Gold||30.87|
||2|13/05/2020|101112|Cashbook|101112 Mucky Pups||20.58|
||2|13/05/2020|101097|Cashbook|101097 - Mucky Pups||20.58|
||2|21/05/2020|000377|Cashbook|101087 Hall Hire||20.58|
||2|28/05/2020|111 122|Cashbook|101111 Mtg Hall Hire||30.00|
||2|28/05/2020|111 122|Cashbook|101111 Hall hire for groups||114.06|
||3|10/06/2020|101117|Cashbook|101117 - Hall Hire||10.30|
||4|03/07/2020|101120|Cashbook|101120 LDHS Hall Hire||15.44|
||6|08/09/2020|000379|Cashbook|Longstanton WI (101099||20.58|
||6|08/09/2020|000379|Cashbook|All Saints (101080)||30.87|
||6|08/09/2020|000379|Cashbook|All Saints (101092)||51.45|
||6|08/09/2020|000379|Cashbook|All Saints (101106)||41.16|
||6|08/09/2020|000379|Cashbook|All Saints (101121)||30.87|
||6|11/09/2020|Music|Cashbook|Music Madness (100116)||10.30|
||6|11/09/2020|Music|Cashbook|Music Madness (101101)||15.43|
||6|11/09/2020|Music|Cashbook|Music Madness (101089)||20.56|
||7|05/10/2020|000380|Cashbook|Hall Hire - Inv 101133||51.45|
||7|13/10/2020|BACS|Cashbook|Hall Hire - Inv 101135||51.45|
||8|05/11/2020|101139|Cashbook|101139 Bounce - Hall Hire||123.48|
||8|10/11/2020|101140|Cashbook|101140 Hall hire||123.48|
||8|16/11/2020|101141|Cashbook|101141 Hall Hire||41.16|
||8|30/11/2020|101138|Cashbook|101138 Hall Hire for Rainbows||41.16|
||9|16/12/2020|101143|Cashbook|101143 Hall hire Rainbows||41.16|
||10|07/01/2021|101146|Cashbook|101146- Hall hire for Bounce||92.61|
||10|11/01/2021|101149|Cashbook|101149-Hall hire for Rainbows||15.45|
||10|14/01/2021|101147|Cashbook|101147- Jill Bridger Dance||61.74|
||10|26/01/2021|101148|Cashbook|101148-Hall Hire-Dance Lessons||61.74|
||10|28/01/2021|101150|Cashbook|101150 - Hall hire Rainbows||30.87|
||12|15/03/2021|BACS|Cashbook|Hall Hire - 101154||87.50|
||12|29/03/2021|BACS|Cashbook|Hall Hire Elections - 101083||334.43|
||||Hall Hire<br>General Income<br>Account<br>Centre||Account Totals<br>Net Balance Month 12<br>565.96<br>____________|____________|1,417.97<br>1,983.93<br>____________|
|||||||565.96||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>1140 Office Rental<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>3,602<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||0.00|
||1|01/04/2020|7|Journal|Longstanton PC<br>300.18|||





13/06/2021 

Page 8 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

12:24 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>1140 Office Rental<br>100 General Income|Date<br>Reference<br>1140 Office Rental<br>100 General Income|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||1|01/04/2020|7|Journal|Mucky Pups|600.36||
||2|28/05/2020|111 122|Cashbook|101122 Office Rental||600.36|
||2|28/05/2020|111 122|Cashbook|101111 Office Rental||300.18|
||3|26/06/2020|101123|Cashbook|101123 - Office Rent||300.18|
||4|27/07/2020|101126|Cashbook|101126 Jun Office Rent||300.18|
||5|26/08/2020|BACS|Cashbook|Inv 101128 - Parish Office Ren||300.18|
||6|23/09/2020|LPCSept|Cashbook|Office Rental (101131)||300.18|
||7|23/10/2020|BACS|Cashbook|Office Rental - Inv 101136||300.18|
||8|30/11/2020|101138|Cashbook|101138 Parish Office Rental||300.18|
||9|16/12/2020|101143|Cashbook|101143 Office Rental||300.18|
||10|28/01/2021|101150|Cashbook|101150 - Office Rental||300.18|
||12|26/03/2021|BACS|Cashbook|Office Rent - 101156||300.18|
||||Office Rental<br>General Income<br>Account<br>Centre||Account Totals<br>Net Balance Month 12<br>900.54<br>____________|____________|2,701.62<br>3,602.16<br>____________|
|||||||900.54||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>1150 Recreation Ground Income<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance||0.00|
||5|26/08/2020|BACS|Cashbook|Inv 101129 - Rec Rent||100.00|
||10|01/01/2021|101132|Cashbook|101132 -Hire of Football Pitch||20.00|
||10|04/01/2021|101145|Cashbook|101145-Hire of Football Pitch||80.00|
||||Account Totals<br>Net Balance Month 12<br>Recreation Ground Income<br>General Income<br>0.00<br>Account<br>Centre<br>____________|||____________|200.00<br>200.00<br>____________|
|||||||0.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4001 Refund of Deposit<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||3|09/06/2020|110|Cashbook|Return of Deposit|50.00||
||7|01/09/2020|BACS|Cashbook|Refund of Deposit due to C-19|250.00||
||7|19/10/2020|BACS|Cashbook|Return of Deposit|50.00||
||||Refund of Deposit<br>Administration<br>Account<br>Centre||Account Totals<br>350.00<br>Net Balance Month 12<br>350.00<br>____________|____________|0.00<br>____________|
|||||||350.00||





13/06/2021 

Page 9 

User :EW 

12:24 

## Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4100 Bank Charges<br>110 Administration|Date<br>Reference<br>4100 Bank Charges<br>110 Administration|Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>72<br>0|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||3|30/06/2020|JUNCHARGES|Cashbook|Bank Charges|18.00||
||6|30/09/2020|DD0902|Cashbook|Bank Charges|18.00||
||9|31/12/2020|DD|Cashbook|Qtrly Bank Charge|18.00||
||12|31/03/2021|DD|Cashbook|Qrtly Bank Charge|18.00||
||||Bank Charges<br>Administration<br>Account<br>Centre||Account Totals<br>72.00<br>Net Balance Month 12<br>72.00<br>____________|____________|0.00<br>____________|
|||||||72.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4120 Professional Fees<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>3,600<br>210|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||4|06/07/2020|CAM003<br>Purchase Ledger||6865/LVH5/Professional Fees|20.83||
||9|16/12/2020|WEL001<br>Purchase Ledger||Professional fees for Lease|750.00||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|4.17||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|150.00||
||||Professional Fees<br>Administration<br>Account<br>Centre||Account Totals<br>925.00<br>Net Balance Month 12<br>925.00<br>____________|____________|0.00<br>____________|
|||||||925.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>Source<br>4130 Subscriptions & Memberships<br>110 Administration|||Transaction Detail|Annual Budget<br>Committed|Credit<br>700<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||3|18/06/2020|LPC001<br>Purchase Ledger||Accounting Software Sub|164.00||
||3|22/06/2020|111<br>Cashbook||Annual Membership|47.50||
||4|24/06/2020|CAM003<br>Purchase Ledger||Cambridgeshire ACRE Membership|47.50||
||4|16/07/2020|PPL001<br>Purchase Ledger||Annual PRS/PPL Licence|288.96||
||4|22/07/2020|CAM003<br>Purchase Ledger||Entered Twice - Correction||47.50|
||9|18/12/2020|HAL001<br>Purchase Ledger||Hallmaster Subscription|187.00||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|9.50||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|57.80||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|37.40||
||||Account Totals<br>792.16<br>Net Balance Month 12<br>Subscriptions & Memberships<br>Administration<br>839.66<br>Account<br>Centre<br>____________|||____________|47.50<br>____________|
|||||||839.66||





13/06/2021 

Page 10 

User :EW 

12:24 

## Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4140 Insurance<br>110 Administration|Date<br>Reference<br>4140 Insurance<br>110 Administration|Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>900<br>0|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||6|29/05/2020|CAS001<br>Purchase Ledger||Annual Insurance|887.01||
||||Insurance<br>Administration<br>Account<br>Centre||Account Totals<br>887.01<br>Net Balance Month 12<br>887.01<br>____________|____________|0.00<br>____________|
|||||||887.01||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4150 Stationery<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>45<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||1|31/03/2020|LPC001<br>Purchase Ledger||Stationery and Printing|21.30||
||||Stationery<br>Administration<br>Account<br>Centre||Account Totals<br>21.30<br>Net Balance Month 12<br>21.30<br>____________|____________|0.00<br>____________|
|||||||21.30||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4160 Postage<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>8<br>0|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||1|31/03/2020|LPC001<br>Purchase Ledger||2nd Class Stamps|2.90||
||3|28/05/2020|JAY001<br>Purchase Ledger||Carriage|6.95||
||||Postage<br>Administration<br>Account<br>Centre||Account Totals<br>9.85<br>Net Balance Month 12<br>9.85<br>____________|____________|0.00<br>____________|
|||||||9.85||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4170 Fixtures & Fittings<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>200<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||1|31/03/2020|LPC001<br>Purchase Ledger||Fixtures and Fittings|120.49||
||3|28/05/2020|JAY001<br>Purchase Ledger||Wheelie Bins for Terracycle|89.85||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|19.36||
||||Fixtures & Fittings<br>Administration<br>Account<br>Centre||Account Totals<br>229.70<br>Net Balance Month 12<br>229.70<br>____________|____________|0.00<br>____________|
|||||||229.70||





13/06/2021 

Page 11 

User :EW 

12:24 

## Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4180 Cleaning Materials<br>110 Administration|Date<br>Reference<br>4180 Cleaning Materials<br>110 Administration|Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>200<br>0|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||1|31/03/2020|LPC001<br>Purchase Ledger||Cleaning Materials|1.29||
||1|01/04/2020|6<br>Journal||Cleaning Materials (Complete)||50.20|
||2|28/02/2020|COM001<br>Purchase Ledger||Cleaning Materials|50.20||
||5|19/08/2020|CUST001<br>Purchase Ledger||Covid-19 Stickers for Opening|195.00||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|10.04||
||||Cleaning Materials<br>Administration<br>Account<br>Centre||Account Totals<br>206.33<br>Net Balance Month 12<br>256.53<br>____________|____________|50.20<br>____________|
|||||||256.53||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4190 Cleaning<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>3,096<br>0|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||1|01/04/2020|6|Journal|Cleaning Contract (Complete C)||215.00|
||1|01/04/2020|6|Journal|Cleaning Contract (Complete C)||215.00|
||2|06/03/2020|COM001<br>Purchase Ledger||Monthly Cleaning|215.00||
||5|28/08/2020|COM001<br>Purchase Ledger||Village Hall Clean|30.00||
||7|08/10/2020|COM001<br>Purchase Ledger||Cleaning of Village Hall|332.31||
||8|03/11/2020|COM001<br>Purchase Ledger||Cleaning of Hall during Covid|66.46||
||9|01/12/2020|COM001<br>Purchase Ledger||Monthly Cleaning - Dec 20|420.93||
||9|08/12/2020|COM001<br>Purchase Ledger||Credit against 17777||155.08|
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|43.00||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|6.00||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|66.46||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|13.29||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|53.17||
||||Cleaning<br>Administration<br>Account<br>Centre||Account Totals<br>661.54<br>Net Balance Month 12<br>1,246.62<br>585.08<br>____________<br>____________|____________||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4200 Gas<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>900<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||1|01/04/2020|104|Cashbook|Gas<br>60.00|||
||1|20/04/2020|SSE001<br>Purchase Ledger||Final Gas Bill<br>116.23|||
||1|29/04/2020|SSE001<br>Purchase Ledger||Gas<br>123.64|||
||2|01/05/2020|109<br>Cashbook||Gas<br>64.29|||
||2|07/05/2020|106<br>Cashbook||Scottish Hydro<br>116.23|||
||2|18/05/2020|108<br>Cashbook||Closing balance<br>123.64|||
||3|01/06/2020|BULBJUN<br>Cashbook||June Gas Payment<br>42.86|||





13/06/2021 

Page 12 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

12:24 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4200 Gas<br>110 Administration|Date<br>Reference<br>4200 Gas<br>110 Administration|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||4|30/06/2020|BULBJUL|Cashbook|Gas Monthly DD|42.86||
||4|01/07/2020|SSE001<br>Purchase Ledger||Final SSE Hydro Gas Invoice|273.93||
||4|01/07/2020|9<br>Journal||Entered into cashbook||116.23|
||5|03/08/2020|DD0801<br>Cashbook||Monthly gas (est)|43.57||
||6|01/09/2020|DD0903<br>Cashbook||Monthly DD - Gas|42.86||
||7|01/10/2020|DD<br>Cashbook||Monthly Bill - Gas|42.86||
||8|01/11/2020|DD<br>Cashbook||Monthly Gas|79.10||
||9|01/12/2020|DD<br>Cashbook||Monthly Gas|75.53||
||9|01/12/2020|DD<br>Cashbook||Correction of error||15.00|
||10|04/01/2021|DD<br>Cashbook||Monthly Gas|96.42||
||11|01/02/2021|DD<br>Cashbook||Monthly Gas|96.42||
||12|01/03/2021|DD<br>Cashbook||Monthly Gas|96.42||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|5.81||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.18||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|5.81||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.18||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|13.69||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|12<br>Journal||Incorrectly attributed VAT|6.43||
||12|31/03/2021|13<br>Journal||Correcting incorrect VAT||5.81|
||||Gas<br>Administration<br>Account<br>Centre||Account Totals<br>1,482.50<br>Net Balance Month 12<br>1,619.54<br>137.04<br>____________<br>____________|____________||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4210 Electric<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>900<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||1|01/04/2020|104|Cashbook|Electricity<br>75.00|||
||2|01/05/2020|109|Cashbook|Electric<br>64.28|||
||3|01/06/2020|BULBJUN|Cashbook|June Electric Payment<br>85.71|||
||4|24/06/2020|SSE002<br>Purchase Ledger||Electric - 6 Feb - 1 Apr 20<br>206.15|||
||4|30/06/2020|BULBJUL<br>Cashbook||Electric Monthly DD<br>85.71|||
||5|03/08/2020|DD0801<br>Cashbook||Monthly electricity (est)<br>85.00|||
||6|01/09/2020|DD0903<br>Cashbook||Monthly DD - Electric<br>85.71|||
||7|01/10/2020|DD<br>Cashbook||Monthly Bill - Electric<br>85.71|||
||8|01/11/2020|DD<br>Cashbook||Monthly Electric<br>49.47|||
||8|17/11/2020|SSE002<br>Purchase Ledger||Final Electric Bill<br>175.67|||





13/06/2021 

Page 13 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

User :EW 

12:24 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4210 Electric<br>110 Administration|Date<br>Reference<br>4210 Electric<br>110 Administration|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||9|01/12/2020|DD|Cashbook|Monthly Electricity|49.47||
||10|04/01/2021|DD|Cashbook|Monthly Electricity|32.15||
||11|01/02/2021|DD|Cashbook|Monthly Electric|32.15||
||12|01/03/2021|DD|Cashbook|Monthly Electric|32.15||
||12|31/03/2021|11|Journal|Incorrectly accounting for VAT|66.06||
||12|31/03/2021|11|Journal|Incorrectly accounting for VAT|25.00||
||12|31/03/2021|12|Journal|Incorrectly attributed VAT|10.30||
||12|31/03/2021|12|Journal|Incorrectly attributed VAT|6.43||
||12|31/03/2021|12|Journal|Incorrectly attributed VAT|6.43||
||12|31/03/2021|12|Journal|Incorrectly attributed VAT|6.43||
||||Electric<br>Administration<br>Account<br>Centre||Account Totals<br>1,264.98<br>Net Balance Month 12<br>1,264.98<br>0.00<br>____________<br>____________|____________||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4220 Water<br>110 Administration||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>300<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||1|08/04/2020|103|Cashbook|Monthly DD|3.50||
||1|16/04/2020|WAVE001<br>Purchase Ledger||Sewerage Charges|90.04||
||2|11/05/2020|107<br>Cashbook||Monthly DD|3.50||
||3|08/06/2020|JUNWATER<br>Cashbook||Monthly DD|3.50||
||4|01/07/2020|10<br>Journal||Entered into cashbook||123.64|
||4|08/07/2020|JULWATER<br>Cashbook||July DD|3.50||
||5|10/08/2020|DD0802<br>Cashbook||Monthly water DD|3.50||
||6|08/09/2020|DD0901<br>Cashbook||Monthly Water DD|3.50||
||7|08/10/2020|DD<br>Cashbook||Monthly DD Water|3.50||
||8|09/11/2020|DD<br>Cashbook||Monthly DD|5.00||
||9|08/12/2020|DD<br>Cashbook||Monthly Water DD|5.00||
||10|08/01/2021|DD<br>Cashbook||Monhtly Water|5.00||
||11|08/02/2021|DD<br>Cashbook||Monthly DD|5.00||
||12|08/03/2021|DD<br>Cashbook||Monthly DD|5.00||
||12|31/03/2021|13<br>Journal||Correcting incorrect VAT||6.18|
||||Water<br>Administration<br>Account<br>Centre||Account Totals<br>9.72<br>Net Balance Month 12<br>139.54<br>____________|____________|129.82<br>____________|
|||||||139.54||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4400 Window Cleaning<br>120 Maintenance||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>80<br>0|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||5|12/08/2020|GDL001<br>Purchase Ledger||Window Cleaning<br>10.00|||





13/06/2021 12:24 

Page 14 User :EW 

Longstanton Village Hall & Recreation 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4400 Window Cleaning<br>120 Maintenance|Date<br>Reference<br>4400 Window Cleaning<br>120 Maintenance|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||Window Cleaning<br>Maintenance<br>Account<br>Centre||Account Totals<br>10.00<br>Net Balance Month 12<br>10.00<br>____________|____________|0.00<br>____________|
|||||||10.00||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4410 Fire Extinguisher<br>120 Maintenance||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>330<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||10|16/12/2020|CHU001<br>Purchase Ledger||Extinguisher Contract|71.60||
||10|14/01/2021|CHU001<br>Purchase Ledger||Servicing of Extinguishers|58.35||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|14.32||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|11.66||
||||Fire Extinguisher<br>Maintenance<br>Account<br>Centre||Account Totals<br>155.93<br>Net Balance Month 12<br>155.93<br>____________|____________|0.00<br>____________|
|||||||155.93||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4420 Plumbing & Heating<br>120 Maintenance||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>300<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||5|25/08/2020|KIL001<br>Purchase Ledger||Connect electric water heater|267.00||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|53.40||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT|122.73||
||||Plumbing & Heating<br>Maintenance<br>Account<br>Centre||Account Totals<br>443.13<br>Net Balance Month 12<br>443.13<br>____________|____________|0.00<br>____________|
|||||||443.13||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4430 Repairs<br>120 Maintenance||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>600<br>5,460|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||1|31/03/2020|FEN001<br>Purchase Ledger||Repairs to roof<br>170.00|||
||1|31/03/2020|FEN001<br>Purchase Ledger||Additional Charge<br>30.00|||
||5|12/08/2020|GDL001<br>Purchase Ledger||Repair front door & new lock<br>40.00|||
||5|12/08/2020|GDL001<br>Purchase Ledger||Repairs & paint fence and gate<br>118.00|||
||5|12/08/2020|GDL001<br>Purchase Ledger||Paint and repair doors<br>146.15|||
||7|27/10/2020|PSS001<br>Purchase Ledger||Single point Water Heaters<br>613.67|||
||9|08/12/2020|GDL001<br>Purchase Ledger||Repair of Suspending Ceiling<br>33.22|||
||9|11/12/2020|DBR001<br>Purchase Ledger||078/LVH7/Repairs<br>529.00|||
||12|31/03/2021|11<br>Journal||Incorrectly accounting for VAT<br>40.00|||





13/06/2021 

Page 15 

User :EW 

## Longstanton Village Hall & Recreation 

12:24 

Nominal Ledger Report by ACCOUNT 

|A/c Code<br>Centre<br>Month|A/c Code<br>Centre<br>Month|Date<br>Reference<br>4430 Repairs<br>120 Maintenance|Date<br>Reference<br>4430 Repairs<br>120 Maintenance|Source|Transaction Detail||Credit|
|---|---|---|---|---|---|---|---|
|||||||Debit||
|||||||||
||||Repairs<br>Maintenance<br>Account<br>Centre||Account Totals<br>1,720.04<br>Net Balance Month 12<br>1,720.04<br>0.00<br>____________<br>____________|____________||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>4435 Grounds Maintenance<br>120 Maintenance||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
|||||||||
||||||Opening Balance<br>0.00|||
||5|12/08/2020|GDL001<br>Purchase Ledger||Weed killing and removal|93.99||
||||Grounds Maintenance<br>Maintenance<br>Account<br>Centre||Account Totals<br>93.99<br>Net Balance Month 12<br>93.99<br>____________|____________|0.00<br>____________|
|||||||93.99||
|A/c Code<br>Centre<br>Month||Date<br>Reference<br>6001 Transfer to EMR<br>100 General Income||Source|Transaction Detail|Annual Budget<br>Committed|Credit<br>0<br>0|
|||||||Debit||
||||||Opening Balance<br>0.00|||
||7|23/10/2020|BACS|Cashbook|Pavilion Earmarked Reserves|20,526.62||
||||Transfer to EMR<br>General Income<br>Account<br>Centre||Account Totals<br>20,526.62<br>Net Balance Month 12<br>20,526.62<br>____________|____________|0.00<br>____________|
|||||||20,526.62||





13/06/2021 

Longstanton Village Hall & Recreation 

Balance Sheet as at 

12:27 

|31st March 2020|31st March 2020|31st March 2020|31st March 2021|31st March 2021|
|---|---|---|---|---|
||Current Assets||||
||1,467<br>Debtors||0||
||1,117<br>VAT Control A/c||1,117||
||22,479<br>Current Bank A/c||43,231||
||25,062||44,348||
|||Total Assets<br>25,062||44,348|
|||Current Liabilities|||
||540|Other Creditors|60||
||300|Holding Deposits|300||
||250|Damage Deposits|250||
||||610||
|||Total Assets Less Current Liabilities<br>23,972||43,738|
|||Represented By|||
|||23,972 General Reserves||23,211|
|||0 Pavilion Earmarked Reserves||20,527|
|||23,972||43,738|
||and reflects its Income and Expenditure during the year.<br>The above statement represents fairly the financial position of the authority as at<br>________________________________    Date : ___________________<br>________________________________     Date :____________________<br>Signed :<br>Chairman<br>Signed :<br>Responsible<br>Financial<br>Officer||||





Date : 13/06/2021 Longstanton Village Hall & Recreation Time: 12:24 Trial Balance for Month No: 12 

Page 1 

User : EW 

Trial Balance for Month No: 12 

Account Number Order 

|||Account Name||Centre Name||Debit|Debit|Credit|
|---|---|---|---|---|---|---|---|---|
||A/c Code||Centre||||||
||||||||||
||105|VAT Control A/c||||1,116.66|||
||200|Current Bank A/c||||43,231.24|||
||310|General Reserves||||||23,972.26|
||320|Pavilion Earmarked Reserves||||||20,526.62|
||501|Other Creditors||||||59.97|
||560|Receipts in Advance|100|General Income||250.00|||
||565|Holding Deposits||||||300.00|
||566|Damage Deposits||||||250.00|
||1070|Pavilion Rent|100|General Income||||24,839.12|
||1075|Pavilion Insurance|100|General Income||||192.14|
||1100|Hall Hire|100|General Income||||1,417.97|
||1140|Office Rental|100|General Income||||2,701.62|
||1150|Recreation Ground Income|100|General Income||||200.00|
||4001|Refund of Deposit|110|Administration||350.00|||
||4100|Bank Charges|110|Administration||72.00|||
||4120|Professional Fees|110|Administration||925.00|||
||4130|Subscriptions & Memberships|110|Administration||792.16|||
||4140|Insurance|110|Administration||887.01|||
||4150|Stationery|110|Administration||21.30|||
||4160|Postage|110|Administration||9.85|||
||4170|Fixtures & Fittings|110|Administration||229.70|||
||4180|Cleaning Materials|110|Administration||206.33|||
||4190|Cleaning|110|Administration||661.54|||
||4200|Gas|110|Administration||1,482.50|||
||4210|Electric|110|Administration||1,264.98|||
||4220|Water|110|Administration||9.72|||
||4400|Window Cleaning|120|Maintenance||10.00|||
||4410|Fire Extinguisher|120|Maintenance||155.93|||
||4420|Plumbing & Heating|120|Maintenance||443.13|||
||4430|Repairs|120|Maintenance||1,720.04|||
||4435|Grounds Maintenance|120|Maintenance||93.99|||
||6001|Transfer to EMR|100|General Income||20,526.62|||
|||||Trial Balance Totals :<br>Difference||||74,459.70|
||||||||||
|||||||74,459.70|||
|||||||0.00|||






URL:       http://www.canalbs.co.uk/ Email:     admin@canalbs.co.uk 

## **canlb as** 

35 Westfield Road Manea,  Nr. March Cambs.  PE15  0LS Tel   01354-680319 **[ltd]** 

## **Independent Internal Audit Service for Parish and Town Councils** 

29[th] April 2021 

The Chairman Longstanton Parish Council Longstanton Village Institute 24 High Street Longstanton Cambridge  CB24 3BS 

Dear Sir 

INDEPENDENT INTERNAL AUDIT FOR Financial  Year End 2020/2021 

As  a  result  of  my  year  end  inspection,  which  because  of  the  pandemic  has necessitated using remote technology rather than the usual face-to-face interview, I have  enclosed  a  report  of  my  findings together  with  any  observations  and recommendations for the Council to consider. 

In the time allotted it is not possible for me to inspect all Council documents available on your Council web site, but a spot check has raised the following issues. I have clarified most of them with the Clerk and the Chairman who attended a meeting held on  Zoom,  but  of  course  I  have  not  been  able  to  inspect  any  original  council documents.  I would also remind the Council that it is not in my remit to check the accuracy of the Council accounts. 

I trust that the Parish Council have been satisfied with the level of service we have provided during this difficult period and that they will consider appointing Canalbs Ltd to undertake the Independent Internal Audit for the next financial year.  Our charge for this service will be £47.50 per hour for the next financial year,  and, in line with Inland Revenue our mileage rate will stay at 45p per mile. 

. 

Yours sincerely 

Jacquie Wilson (Mrs) Director 



29.04.21 

## Canalbs ltd 

## REPORT AND OBSERVATIONS TO LONGSTANTON COUNCIL 

## EMPLOYMENT 

I have noted that Section 1 Item 7 of the AGAR has been completed with a “No” with a covering note of Assertion – I have recommended that this should include a reference to the fact that this statement is principally related to employment issues. 

I understand that after taking legal advice from an ACAS recommended employment legal adviser  a formal grievance procedure has taken place and the complaint was upheld.  I also understand  the  Council  is  still  in  the  process  of  completing  work  on  some  of  the recommendations  made  as  part  of  the  grievance  hearing/investigation.  In  line  with  the guidance suggested that was received from CPALC and the ACAS recommended specialists regarding committee vs. working group, and a working group being more practical and less onerous in terms of administration the Employment Committee is to be disbanded.  I agree with this advice and would recommend the formation of an Employment Working Group to research and recommend matters to the full council. 

Regarding communications from working groups, committees or individual councillors, please note  that  all  council  correspondence  should  be  sent  through  the  Proper  Officer/Clerk  of Council Office. 

## BURIAL GROUND 

It would appear that 

- the land is actually owned by SCDC and that through an administrative error the parish council has been maintaining it since 1954. 

- The tree growing through one of the graves has been removed. 

- The Parish Council has recently approved the recommendation to join the ICCM to help advise on issues that have been noted after a full inspection of the ground. 

## COUNCIL POLICIES 

The Clerk confirmed that some of the policies have already been updated and it has been checked that they are compliant with the General Data Protection Regulations. 

The  Risk  Assessment  and  Management  Policy  will  be  amended  to  reflect  the  Resolution approved recently that the General Reserve will in future be held at 9 months of the Annual Precept. 

The meeting of the Parish Council in May is due to review the complete Policy and will ascertain that all areas specified in the Policy have been adhered to and that the Policy continues to be fit for purpose. 

At the March meeting there was a proposal to arrange a volunteer litter picking event.  This has had to be deferred due to the pandemic and a certain lack of support.  The Parish Council already has taken full advice from recognized organisations on how to ensure that future events run safely. 

## FINANCE 

I have reviewed the procedures  and documents presented to the Council and find them satisfactory and comprehensive. 

I understand that the risk assessment for Prepaid Milti-card the Council has introduced states that only the Clerk is signatory with a £300 limit and maximum of £200 for a single purchase. A statement of account is presented to the Finance Committee at each meeting. 

The Fixed Asset Register has now been added to the web site.  It is understood that this will reduce when certain assets are transferred to Norths Stowe Town Council now it is in place. SOLE TRUSTEES 



The web site still records that the the council are sole trustees for three charities. Box 11 had not been ticked on the AGAR. _Jacquie Wilson (Mrs)  Director_ (2)