|Numbers Sheet Name|Numbers Table Name|
|---|---|
|Sheet1||
||Table 1|
|Sheet1-1||
||Table 1|
|Sheet2||
||Table 1|
|Sheet3||
||Table 1|





## Excel Worksheet Name 

Sheet1 Sheet1-1 Sheet2 Sheet3 



|**Rotary Club of Lymington Trust Fund**|||||
|---|---|---|---|---|
|**Charity Commission Registered No 1028522**<br>**Annual Accounts 2020**|**Year ended 30 June 2020**||**Year ended 30**|**June 2019**|
|**Receipts and Payments Account**<br>**Unrestricted Funds**|||||
||**2019-20**|**2019-20**|**2018-19**||
|**Receipts**|||||
|**Donations and Collections**|||||
|Shoebox Appeal<br>Pound Store|446.00<br>3.18||438.50<br>24.92||
|Shelter/Aqua Box Appeals - Donations<br>Public Donations|140.00<br>15.00||85.00<br>300.00||
|Gift Aid|2,462.06||1,997.49||
|Donations from Members|453.73||199.00||
|Quiz night/donation/grant T Pruss School|0.00||7,862.95||
|URC Xmas Tree (surplus from previous year)<br>Annual sub due to General a/c|175.00||45.00||
|||**3,694.97**||**10,952.86**|
|**Operating Activities to Generate Funds**|||||
|Santa Wagon|992.68||2,343.29||
|Santa on the Quay|1,650.20||2,044.77||
|Charity Dinner - cancelled|80.00||4,178.00||
|Lymington Spectacular 2019|28,507.00||36,272.11||
|Lymington Spectacular 2020 - cancelled - income in adv|2,625.39||||
|Quiz Night|0.00||693.60||
|Milford Spring Plant Fair - cancelled|40.00||826.20||
|||**33,895.27**||**46,357.97**|
|**Interest Received**||**0**||**0.00**|
|**Total Unrestricted Receipts**||**37,590.24**||**57,310.83**|
|**Restricted Funds**|||||
|**Foundation Charity**|||||
|Bonus Ball Receipts|422.90||512.46||
|Donations from Members for Pennington School|5,000.00||845.00||
|Wessex District Donation for Pennington School<br>Donations from Members for Oakhaven|4,000.00<br>500.00||||
|Supper raffles|0.00||63.50||
|Part Gift Aid|||1,006.88||
|Donations from Members for Rotary Intl Foundation|1,041.00||||
|**Total Restricted Receipts**||**10,963.90**||**2,427.84**|
|**TOTAL INCOME**||**£48,554.14**||**£59,738.67**|



**A Ogilvie Hon Treasurer** 

**Independent Examiners** 

**D Sayers** 

**G Lewis** 

**Payments** 

|Lymington Spectacular 2019|17,485.06||15,124.14||
|---|---|---|---|---|
|Lymington Spectacular 2020 - cancelled -|954.77||||
|Blue Plaque Leaflets|0.00||74.00||
|Milford Spring Plant Fair|40.00||260.00||
|Counting Machine for Events<br>Internet costs etc|0.00<br>0.00||178.80<br>162.03||
|Santa on the Quay|923.77||1,329.19||
|Charity Dinner|115.52||638.21||
|Stick on Aluminium Labels to promote Rotary|130.20||||
|Lymington Newsletter Sub & fee for year|300.00||||
|||**19,949.32**||**17,766.37**|
|**Charitable Payments**|||||
|Grants paid (per schedule)|21,838.74||29,400.15||
|Charitable Activities (per schedule)|2,930.25||3,772.12||
|||**24,768.99**||**33,172.27**|
|**Total Unrestricted Payments**||**44,718.31**||**50,938.64**|
|**Restricted Grants paid (per schedule)**||**12,120.00**||**2,486.00**|
|**Total  Payments**||**£56,838.31**||**£53,424.64**|
|**(Deficit) Surplus of Receipts less Payments**|||||
|Unrestricted deficit<br>Restricted deficit|-7,128.07<br>-1,156.10||**6,372.19**<br>**-58.16**||
|**Total**|**-8,284.17**||**6,314.03**||
|Cash Funds at 28 June 2019|17,787.47||11,493.44||
|Adj from 2018-19- see prev yr bank rec’s|20.00|17,807.47|||
|**Cash Funds at 30 June 2020**||**£9,523.30**||**£17,807.47**|
|**Statement of Assets and liabilities**|||||
|Assets|||||
|Cash at Bank|||||
|Current account as at 30 June 2020|9,523.30||17,807.47||
|**Net Assets**||**9,523.30**||**£17,807.47**|
|Note: Equipment owned by the Charity is written off for accounting purposes in the year of purchase|||||
|**Reserves**|||||
|Santa Collection (incl Santa on the Quay)|1,507.86||1,099.43||
|General|8,015.44||9,708.04||
|Lymington Spectacular (Inc SkinGroup LS Sponsorship £7|0.00||7,000.00||
|**Total Unrestricted Funds**||**9,523.30**||**17,807.47**|
|**Restricted Funds**|||||
|Polio+|0.00||0.00||
|Rotary Foundation|0.00||0.00||
|Pennington Junior School PTA|0.00||||
|Oakhaven Hospice Part Restricted|0.00||||
|||**0.00**|||
|**Total Funds at 30 June 2020**||**£9,523.30**||**£17,807.47**|
|**Schedule to Receipts and Payments Account**|||||
|**Grants Paid Unrestricted Funds**|||||
|1st Lymington & Pennington Scout Group|500.00||||
|1st Milford Rainbows|||100.00||
|1st Tiptoe Brownies|||150.00||
|AFC Pennington - Youth|250.00||||
|Age Concern, Hampshire|100.00||||
|Air Cadets|||500.00||
|All Saints Lunch Club|||250.00||
|Aquabox|480.00||||
|Bags of Love|404.73||304.20||
|Beaulieu Primary School|248.81||250.00||
|Brockenhurst Primary School|250.00||250.00||
|Compass Counselling Service|300.00||||
|Dictionary 4 Life|1,092.00||1,148.00||
|Forca 14|250.00||||
|Fortune Centre|||400.00||
|Gateway Club|||500.00||
|hArt Silverlinks|100.00||||
|Hedgehog Rescue|||100.00||
|Honeypot|||250.00||
|Jubilee Sailing Trust|500.00||||
|Lymington Armed Forces Breakfast Club|250.00||||
|Lymington CE School|||100.00||
|Lymington Centre Pre-School|250.00||||
|Lymington Community Association|10,000.00||||
|Lymington Cricket Club Juniors|250.00||||
|Lymington Dementia Group|||300.00||
|Lymington Infants Pre School|||250.00||
|Lymington Infants School|231.76||||
|Lymington Town Band|250.00||250.00||
|Lymington Town FC Sprites|250.00||||
|Mercy Ships|250.00||250.00||
|Milford on Sea Charitable Trust|250.00||||
|Milford on Sea Pre School|||100.00||
|Milford on Sea Primary School|||250.00||
|Minstead Trust|||500.00||
|Naomi House Children's Hospice|||250.00||
|National Museum RN|||150.00||
|New Forest Basics Bank|250.00||||
|New Forest CAB|||250.00||
|New Forest Hospital Radio|||500.00||
|New Forest Trust|||150.00||
|Oakhaven Hospice|500.00|(£500 Restric)|500.00||
|Olivia Inspires|250.00||||
|Orangutan Appeal UK|400.00||300.00||
|Pedall|250.00||||
|Pennington Infant School|||250.00||
|Pennington Pre-Prep|||100.00||
|Piam Brown Ward|||100.00||
|Red Box project|||200.00||
|RNLI|||2,300.00||
|Rose Road|||463.75||
|Sea Scouts|||500.00||
|Shelter/ Aqua Boxes|||2,660.00||
|Shelterbox|1,180.00||||
|South Baddesley Jnr School|||250.00||
|South Baddesley Primary School|250.00||||
|Spurgeons Children's Charity|||100.00||
|St John|||400.00||
|St Joseph’s Primary|258.82||||
|St Josephs Jnr School|||250.00||
|St Luke’s Primary|250.00||||
|St Lukes School Sway|||250.00||
|St Mark’s PCC, Pennington|70.00||||
|St Thomas PCC|250.00||||
|The Childrens Trust|||500.00||
|The Friends of St Thomas Church|71.94||75.00||
|Tim Pruss Mem School|||10,362.95||
|Tools for Self Reliance|200.00||200.00||
|UK Sepsis Trust|310.68||400.00||
|URC|140.00||||
|Various Schools Hi Viz jackets|||486.25||
|Vision Aid|200.00||200.00||
|Wessex Neurological Centre Trust|||500.00||
|Wheelchair Foundation|300.00||300.00||
|William Gilpin Primary School|250.00||250.00||
||**21,838.74**|**21,838.74**|**29,400.15**|**29,400.15**|
|**Grants Paid Restricted Funds**|||||
|Rotary Foundation|2,250.00||2,106.00||
|Polio + £250, incl Crocus bulbs £120|370.00||380.00||
|Pennington Junior School PTA|9,000.00||||
|Oakhaven Hospice Part Restricted|500.00||||
|||**12,120.00**||**2,486.00**|
|**Charitable Activities**|||500.00||
|Jaipur Limb project|1,250.00||540.00||
|Priestlands Various|485.35||624.98||
|Kids Out|0.00||800.19||
|Solent Mead Entertainment and Bingo Prizes|535.00||232.00||
|Rotary Young Chef|110.00||500.00||
|Gambia Medical equipment|0.00||574.95||
|Shoeboxes|549.90||||
|||**2,930.25**||**3,772.12**|
|**TOTAL**||**£36,888.99**||**£35,658.27**|



3 



**Lymington Rotary Trust Charitable Incorporated Organisation Charity Commission Registered No 1195558 Accounts for the Year ended 30 June 2023** 

|**Receipts and Payments Account**<br>**Unrestricted Funds**<br>**Receipts**<br>**Donations and Collections**<br>General Donations from Rotary Members<br>75th Charter Anniversary Donations<br>**Operating Activities to Generate Funds**<br>Classic Car Show - August 2022<br>Summer Spectacular - August 2023<br>Queen's Platinum Jubilee - Picnic in the Park<br>75th Charter Anniversary Quiz Night<br>Santa Wagon and Santa on the Quay<br>**Total Unrestricted Receipts**<br>**Restricted Funds**<br>Donations for Rotary International Foundation<br>Raffle Receipts for Rotary International Foundation<br>Street Collection for Pakistan Floods Appeal<br>Street Collection for Turkey/Syria Earthquake Appeal<br>School's Donation for Turkey/Syria Earthquake Appeal<br>Shoeboxes Donations<br>Matching District Grant<br>Donation for International purposes<br>**Total Restricted Receipts**<br>**Total Receipts**|**2022-23**<br>200.00<br>2,325.00|**2022-23**<br>200.00<br>2,325.00|
|---|---|---|
||2,525.00||
||5,527.65<br>4,434.61||
||-||
||79.32<br>3,571.52<br>13,613.10||
||||
||||
||**16,138.10**<br>580.00||
||88.00<br>500.10<br>2,048.00<br>217.95<br>279.00<br>3,500.00<br>750.00||
|||**7,963.05**<br>**£24,101.15**|





## **Lymington Rotary Trust Charitable Incorporated Organisation Charity Commission Registered No 1195558 Accounts for the Year ended 30 June 2023** 

## **Receipts and Payments Account (continued)** 

## **Payments** 

|**Operating Activities to Generate Funds**<br>Summer Spectacular 2023<br>Santa on the Quay<br>**Charitable Payments**<br>Grants paid (per schedule)<br>Charitable Activities (per schedule)<br>**Total Unrestricted Payments**<br>**Restricted Funds**<br>Grant paid to PICU (part)<br>Appeals (part)<br>Raffle Prizes for Rotary International Foundation fund-raising<br>**Total Payments**<br>**Surplus of Receipts less Payments**<br>Unrestricted surplus<br>Restricted surplus<br>**Total**<br>Cash Funds at 1 July 2022<br>**Cash Funds at 30 June 2023**|851.93<br>100.00<br>951.93<br>9,695.95<br>608.50<br>10,304.45<br>**11,256.38**<br>3,500.00<br>2,766.05|851.93<br>100.00<br>951.93<br>9,695.95<br>608.50<br>10,304.45<br>**11,256.38**<br>3,500.00<br>2,766.05|
|---|---|---|
||336.16||
|||**6,602.21**<br>**£17,858.59**|
|||4,881.72<br>1,360.84|
|||6,242.56<br>6,089.33|
|||**£12,331.89**|





## **Lymington Rotary Trust Charitable Incorporated Organisation Charity Commission Registered No 1195558 Accounts for the Year ended 30 June 2023** 

|**Statement of Assets and Liabilities**<br>**Assets**<br>Cash at Bank -<br>Current Account<br>**Net Assets**<br>**Reserves**<br>**Unrestricted Funds**<br>Santa Fund<br>**Restricted Funds**<br>Rotary Foundation<br>**Total Funds at 30 June 2023**<br>**P G Edwards - Trustee**<br>**17th April 2024**<br>General|**30 June 2023**|
|---|---|
||12,331.89|
||**£12,331.89**<br>2,321.52<br>9,639.53<br>11,961.05<br>370.84<br>**£12,331.89**|



