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



Excel Worksheet Name
Sheeti
Sheet2
Sheet3


**----- Start of picture text -----**<br>
PEPYS HOUSE CHARITABLE TRUST PEPYS HOUSE CHARITABLE TRUST PEPYS HOUSE CHARITABLE TRUST<br>STATEMENT OF ACCOUNT YEAR TO 31ST DECEMBER 2021 INCOME RECEIVED YEAR TO 31ST DECEMBER 2021 OUTGOINGS PAID YEAR TO 31ST DECEMBER 2021<br>Balances as of 01.01.21 brought forward £ £ £ £<br>C Hoare & Co Current Account 5,723.95 Rental Income Repairs/improvements to property<br>C Hoare & Co Appeal Account 2,161.58 01.21-12.21 Rent from M T Quayle (12 x £900) 10,800.00 02.1.21 Nick Wilson Heating 186.00<br>COIF Account 11,930.03 01.21-12.21 Rent from Raby & Sons (1 x £360) 0.00 28.2.21 Marriott Security 169.20<br>Outstanding Gift Aid from previous years 713.75 23.5.21 Nick Wilson Heating 174.00<br>Monies owed to GOFP from previous year 8,481.03 05.8.21 Cromwell Fire Ltd 137.75<br>Total Balance 01.01.21 ### 15.12.21 Nick Wilson Heating 102.00<br>COIF account interest 10.66<br>Outstanding Long Term Debt 01.01.21 ### 768.95<br>Income for 2021 41,506.28 Donations Management Fee<br>Expenditure for 2021 14,410.00 01.21-12.21 Donations from R G G & E C Gain 100.00 15.11.21 Barker Storey Matthews 1,500.00<br>Net Income for 2021 ### Gift Aid on above 25.00 1,500.00<br>Pay Down of Long Term Debt 3.08.21 Legacy from GW 30,570.62<br>Predicted balance 39,144.56 Bank Charges<br>01.21-12.21 Faster payment fees 3.00<br>Balances as at 31.12.21 01.21-12.21 Other Donations 0.00 3.00<br>C Hoare & Co Current Account 34,303.54 Gift Aid from Other Donations 0.00<br>C Hoare & Co Appeal Account 2,161.58 Insurance<br>COIF Account 1,940.69 31.12.21 Eddison's Insurance - annual 3,806.45<br>Outstanding Gift Aid from previous years 738.75 3,806.45<br>Total Balance 31.12.21 39,144.56<br>Professional Fees<br>Outstanding Long Term Debt 31.12.21 ### 02.1.21 Eddisons 780.00<br>26.3.21 Leeds Day 945.60<br>Difference in Predicted and Actual Balance 0.00 30.4.21 Leeds Day 1,462.00<br>9.8.21 Leeds Day 40<br>9.8.21 Leeds Day 552<br>3,779.60<br>Trustee Expenses<br>01.21-12.21 PLG lunch with JM at Brooks 112.00<br>112.00<br>Debt Financing<br>01.21-12.21 Standing Order to S J Hawley (2 x £670) 1,340.00<br>01.21-12.21 Standing Order to Mrs C V Pryor (2 x £150) 300.00<br>01.21-12.21 Standing Order to D H Clough (2 x £1000) 2,000.00<br>01.21-12.21 Standing Order to D McGarva (2 x £400) 800.00<br>4,440.00<br>Total Income ### Total Outgoings 14,410.00<br>**----- End of picture text -----**<br>


3