| UTTOXETER HEATH COMMUNITY CENTRE TRIAL BALANCE 31ST MARCH 2020 Income Room Hire etc Grants/Donations Received Not Allocated Grants/Donations Community Garden Wages Heat&Light Cost of Events Repairs & Maintence Renovation & Disturbance Costs Phone, Printing, Postage & Stationery Rates Cleaning Costs Kitchen Costs Computer Photocopier Costs Website Advertising Insurance Accountancy Motor Expencies Community Garden Expences Sundry Expences HSBC Bank Account Lloyds Bank Account Community Garden Bank Account Debtors Prepayments Creditors VAT Accruals/Deferred Income Reserves Building Costs Building Grants/Loana Dif |
Balance Sheet 03/31/2019 2,236.71 55,703.44 1,455.76 -1,090.00 13,017.57 -2,000.00 -15,636.86 409,077.80 -462,764.42 |
Balance Sheet 03/31/2019 2,236.71 55,703.44 1,455.76 -1,090.00 13,017.57 -2,000.00 -15,636.86 409,077.80 -462,764.42 |
Reverse Reserves 03/31/2019 1,455.76 -1,090.00 -2,000.00 -1,455.76 1,090.00 2,000.00 |
Lloyds Receipts -11,700.89 -3,149.06 -11,000.00 28,190.13 -2,340.18 |
Lloyds Payments 456.67 1,133.34 21,877.89 8,865.94 457.06 2,041.95 653.10 1,654.84 89.77 100.00 480.00 675.00 463.50 -67,166.59 3,530.91 4,686.62 20,000.00 |
HSBC Receipts -7,568.06 -800.00 9,881.65 -1,513.59 |
HSBC Payments 41.67 246.67 327.37 90.00 155.32 1,710.11 1,377.95 228.00 367.31 -4,846.65 302.25 |
Community Garden -1,673.55 1,105.96 2,210.29 195.30 -1,838.00 |
Community Garden -1,673.55 1,105.96 2,210.29 195.30 -1,838.00 |
Debtors/Pre 03/31/2020 -929.00 -200.00 -212.52 -3,500.00 -580.00 1,341.52 4,080.00 |
Cred/Acc 03/31/2020 67.00 11,064.00 200.00 165.00 -496.00 -11,000.00 |
Proft & Loss -18,176.85 -2,769.05 -1,673.55 20,966.74 5,365.94 547.06 2,197.27 0.00 2,363.21 1,377.95 1,274.84 317.77 100.00 480.00 0.00 367.31 -1,160.00 0.00 1,105.96 463.50 0.00 |
Balance Sheet 7,271.71 16,726.98 2,210.29 1,341.52 4,080.00 -496.00 13,192.26 -12,838.00 -15,636.86 0.00 413,764.42 -442,764.42 0.00 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 13,148.10 | -13,148.10 |
| TOTAL FOR YEAR LLOYDS RECEIPTS BANK RECOCILIATION YEAR Balance b/f 1/04/2019 Receipts Payments Closing Balance 31/03/2019 |
28,190.13 Income VAT 55,703.44 28,190.13 -67,166.59 16,726.98 |
14,041.07 |
|---|---|---|
| 11,700.89 2,340.18 |
||
| 14,041.07 | ||
14,149.06 28,190.13 1,000.00 Poly Tunnel 11,000.00 Salary Grant 2,149.06 General
14,149.06
| Quarter to | 31 March 2020 | Heat & | ||||||
|---|---|---|---|---|---|---|---|---|
| 2020 | Description | Ref | BANK | VAT | Wages | Light | Constuction | Cleaning |
| Jan 03 | B Smith & Sons- Repair Door | 84.00 | 0.00 | |||||
| Jan 27 | E Underhill Wages | 359.20 | 359.20 | |||||
| Jan 27 | E Tompkinson Wages | 855.77 | 855.77 | |||||
| Jan 31 | Opus | 4,862.64 | 810.44 | 4,052.20 | ||||
| Feb 07 | MD Expenses | y | 547.06 | 62.78 | 111.61 | |||
| Feb 07 | Bhygenic | y | 1,042.80 | 173.80 | 869.00 | |||
| Feb 07 | BW Belcher | y | 58.80 | 9.80 | ||||
| Feb 13 | Mee Accounting | y | 126.00 | 21.00 | ||||
| Feb 13 | SJL | y | 15.00 | 2.50 | 12.50 | |||
| Feb 13 | Testsafe PAC Testing | y | 222.54 | 37.09 | ||||
| Feb 26 | E Tompkinson Wages | 855.77 | 855.77 | |||||
| Feb 26 | E Underhill Wages | 359.20 | 359.20 | |||||
| Feb 26 | A50 Furniture | y | 120.00 | 20.00 | ||||
| Mar 02 | Opus | y | 426.25 | 71.04 | 355.21 | |||
| Mar 25 | E Tompkinson Wages | 855.77 | 855.77 | |||||
| Mar 25 | E Underhill Wages | 359.20 | 359.20 | |||||
| Mar 25 | E Underhill Wages Tax Refund | 130.40 | 130.40 | |||||
| Mar 31 | Opus | 928.32 | 928.32 | |||||
| 12,208.72 | 1,208.45 | 3,787.81 | 5,335.73 | 0.00 | 980.61 | |||
| TOTAL FOR YEAR LLOYDS PAYMENTS | 67,166.59 | 3,530.91 | 21,877.89 | 8,865.94 | 4,686.62 | 1,654.84 |
27
Repairs Phone Renewals Stationery Accounting Kitchen 84.00
Sundry
43.60 172.63
89.77
66.67 Party Refund
49.00
105.00
185.45
100.00
| 462.05 172.63 105.00 89.77 0.00 66.67 |
462.05 172.63 105.00 89.77 0.00 66.67 |
462.05 172.63 105.00 89.77 0.00 66.67 |
|---|---|---|
| 12,208.72 | ||
| 2,041.95 653.10 675.00 89.77 0.00 23,090.57 |
||
| Analysis Of Sundries Website Start Up Grant - Income Polytunnel Contra Grant Contra HBL Loan Sundry Events Youth Group Party Refund - Income Computer Costs |
67,166.59 480.00 390.00 833.34 300.00 20,000.00 463.50 457.06 66.67 100.00 |
|
| 23,090.57 |
| TOTAL FOR YEAR HSBC RECEIPTS BANK RECOCILIATION FOR YEAR Balance b/f 1/04/2019 Receipts Payments Closing Balance 31/03/2020 |
9,881.65 Income VAT 2,236.71 9,881.65 -4,846.65 7,271.71 |
9,081.65 800.00 9,881.65 7,568.07 1,513.58 9,081.65 |
|---|---|---|
| Quarter to 31 March 2020 2020 Description Ref Jan 07 NEST Jan 15 Sage Jan 22 Tesco Mobile Jan 29 BT Mobile Jan 30 NEST Feb 13 Sage Feb 18 Water Plus y Feb 24 Tesco Mobile Feb 27 NEST Mar 03 BT Mobile Mar 13 Sage Mar 16 Pennon y Mar 23 Tesco Mobile Mar 27 NEST Mar 30 BT Mobile TOTAL FOR YEAR HSBC PAYMENTS |
BANK 134.17 26.40 48.99 67.92 64.40 26.40 95.15 50.99 64.40 67.92 26.40 420.62 48.49 64.40 67.92 |
VAT 0.00 4.40 8.17 11.32 0.00 4.40 0.00 8.50 0.00 11.32 4.40 0.00 8.08 0.00 11.32 71.91 302.25 |
Phone Post Stationery 22.00 40.82 56.60 22.00 42.49 56.60 22.00 40.41 56.60 |
Water Rates 95.15 420.62 |
Repairs Renewals |
|
|---|---|---|---|---|---|---|
| 1,274.57 | 359.52 | 515.77 | 0.00 | |||
| 4,846.65 | 1,710.11 1,377.95 |
155.32 |
Deposit Returned Kitchen
Water Wages Rates Nest Sundries 134.17
64.40
64.40
64.40
| 0.00 0.00 0.00 327.37 0.00 |
0.00 0.00 0.00 327.37 0.00 |
0.00 0.00 0.00 327.37 0.00 |
|---|---|---|
| 1,274.57 | ||
| 41.67 228.00 0.00 327.37 703.98 |
||
| Analysis of Sundries Poly Tunnel Events Insurance |
4,846.65 246.67 90.00 367.31 |
|
| 703.98 |
UTTOXETER HEATH COMMUNITY CENTRE DEBTORS/CREDITORS 31st March 2020
DEBTORS After Date Receipts
Lloyds £ 04/22/2020 Lions Donation 200.00
HSBC
Bettson 204.00 Income Net Of VAT St Giles Hospice 212.52 Recharge Cleaner May 19 U3A 350.00 Income Net Of VAT Jun 22 ESBC 375.00 Income Net Of VAT 1,341.52
TOTAL
Prepayment
BHGienic £869 yr to 30/11/20 580.00 Elec Overpaid 3,500.00 4,080.00
CREDITORS
£
Apr 14 Mary Expenses 200.00 Cleaning Apr 14 Mee Accounting 165.00 Acc Apr 21 Party Refund 67.00 Income Apr 21 Nest 64.00 Wages 496.00
Deferred Income
HBL Grant Wages 11,000.00 Rec 7/3/20
UTTOXETER HEATH COMMUNITY CENTRE COMMUNITY GARDEN 31 st MARCH 2020
| COMMUNITY GARDEN 31 st MARCH 2020 |
|||
|---|---|---|---|
| INCOME ESBC UTC Lions Shed Lawnmower Race Course Bike Ride Sundry EXPENDITURE Hardcore for Path M D Expenses Opening Bank Balance Receipts Payments Bank Balance 31 March 2020 |
£ 1,000.00 1,000.00 538.00 300.00 426.00 237.55 10.00 3,511.55 £ 1,151.28 149.98 1,301.26 0.00 3,511.55 -1,301.26 2,210.29 |
Income £ 1,000.00 426.00 237.55 10.00 |
|
| 1,673.55 | |||
| Goods 959.40 146.56 |
|||
| 1,105.96 | |||
Specifc c/fwd £ 1,000.00 538.00 300.00
1,838.00 VAT 191.88 3.42 195.30