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