|**GREEN SHELTER UK**|**GREEN SHELTER UK**|||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|**E. TRIAL BALANCE**||||||||||||||||
|**30/11/23**||||||||||||||||
|||||||||||||||||
|**DETAILS**||**OPENING TB**||**BANK A/C**||**CASH A/C**||**ADJUSTMENT**||**Acc**|**Prep**|**P&L**|**A/C**|**Balance sheet**||
|||Dr|Cr|Dr|Cr|Dr|Cr|Dr|Cr|Cr|Dr|Dr|Cr|Dr|Cr|
|Sales|||||||||||||-|||
|Donation unrestricted|||||||7,030.02||||||7,030.02|||
|Event Sponsor- Restricted|||||||6,415.00||||||6,415.00|||
|Stall rent|||||||750.00||||||750.00|||
|Purchase||||||||||||-||||
|PAYE|||||||||_-_|-||-||||
|Wages||||||||||||-||||
|Director ER||||||||||-||-||||
|Directors Salary||||||||||||-||||
|Hall Booking||675.00||2,650.00||||675.00|-||625.00|3,375.00||||
|Rent||||||||||||-||||
|Rates||||||||||||-||||
|Water||||||||||||-||||
|Gas||||||||||||-||||
|Electricity||||||||||||-||||
|Telephone||||||||||||-||||
|Cleaning||||||||||||-||||
|Event cost||||5,295.13||||||||5,295.13||||
|Repair & renewals||||||||||||-||||
|Fire & security||||||||||||-||||
|Bank interest||||||||||||-||||
|Bank charge||||6.62||||||||6.62||||
|Credit card charges||||||||||||-||||
|Subscription||||258.83||||||||258.83||||
|Accountancy||||||||||||-||||
|Insurance||||96.00||||||||96.00||||
|Companyhouse||||||||||||-||||
|Sundries||||||||||||-||||
|Advertising||||||||||||-||||
|Travelling& Delivery||||||||||||-||||
|PPS||||2,982.78||||||||2,982.78||||
|Interest received|||||||||||||-|||
|||||||||||||||||
|Stock||||||||||||-||-||
|Bank||2,841.32||5,257.23|2,841.32|||||||||5,257.23||
||||||||||||||||-|
|Cash in hand|||||||-|||||||-||
|Banking|||||14,195.02|14,195.02||||||||||
|Directors Loan A/C||||563.49|73.74|||-|675.00||||||185.25|
|F & F||||||||||||||-|-|
|Plant & Machinery||||||||||||||-|-|
|Motor Vehicle||||||||||||||-|-|
|Other Creditors|||35.00||||||||||||35.00|
|Cash withdraw|||||||-|||||||||
|C & E|||||||||-||-|||||
|P&L A/C|||3,481.32|||||||||||-|3,481.32|
|Share capital|||||||||||||||-|
||||||||||||||||-|
|Profit||||||||||||||-|-|
|||||||||||||||625.00|-|
|||||||||||||||||
|**Total**||**3,516.32**|**3,516.32**|**17,110.08**|**17,110.08**|**14,195.02**|**14,195.02**|**675.00**|**675.00**|**-**|**625.00**|**12,014.36**|**14,195.02**|**5,882.23**|**3,701.57**|
||||||||||||||**CLOSING STOCK FIGURE MISSING**|||
|Difference||-||-||-||-||||2,180.66||2,180.66<br>-||
|GP%|#DIV/0!|||||||||||||||





||||||||
|---|---|---|---|---|---|---|
|**GREEN SHELTER UK**|||||||
|**COMPARATIVE ANALYSIS**|||||||
|**45260.00**|||||||
|||||**Ratio analysis**||**Increase**|
|||**Thisyear**|**Lastyear**|**Thisyear**|**Lastyear**|**Trend**|
|**Sales**||**-**|**5,257.18**|100.00%|100.00%|**_-100.00%_**|
|**Donation unrestricted**||**7,030.02**|||||
|**Event Sponsor- Restricted**||**6,415.00**|||||
|**Stall rent**||**750.00**|||||
|**Purchase**||**-**||#DIV/0!|0.00%|**_#DIV/0!_**|
|PAYE||-|||||
|Wages||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Director ER||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Directors Salary||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Hall Booking||3,375.00|||||
|Rent||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Rates||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Water||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Gas||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Electricity||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Telephone||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Cleaning||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Event cost||5,295.13|2,576.44||||
|Repair & renewals||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Fire & security||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Bank interest||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Bank charge||6.62||#DIV/0!|0.00%|**_#DIV/0!_**|
|Credit card charges||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Subscription||258.83|249.78||||
|Accountancy||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Insurance||96.00|96.00|#DIV/0!|1.83%|**_0.00%_**|
|Companyhouse||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Sundries||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Advertising||-|152.09|#DIV/0!|2.89%|**_-100.00%_**|
|Travelling& Delivery||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|PPS||2,982.78||#DIV/0!|0.00%|**_#DIV/0!_**|
|Depn on TFA||-||#DIV/0!|0.00%|**_#DIV/0!_**|
|Loan interest||||#DIV/0!|0.00%|**_#DIV/0!_**|
|**Total Expenses**||**12,014.36**|**3,074.31**|#DIV/0!|58.48%|**_290.80%_**|
||||||||
||||||||
|Interest received||-|||||
||||||||
|**Opening stock**||**-**|**-**|#DIV/0!|0.00%|**_#DIV/0!_**|
|**Closing stock**||**-**|**-**|#DIV/0!|0.00%|**_#DIV/0!_**|
||||||||
||||||||
||||||||
|**Gross Profit**||**-**|**5,257.18**|#DIV/0!|100.00%|**_-100.00%_**|
|**GP%**||**#DIV/0!**|**100.00%**|||**_#DIV/0!_**|
||||||||
|**Net Profit**||**2,180.66**|**2,182.87**|#DIV/0!|41.52%|**_-0.10%_**|
|**NP%**||**#DIV/0!**|**41.52%**|||**_#DIV/0!_**|
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||