September 2023 - August 2024 

**INCOME** 

_Month Name: September-23_ 

## simplestExample.xls 

|_Payment from:-_|_Payment from:-_|_Payment from:-_|||_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||_Paid to:-_||_Trading Income_||||||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|CLOTHES|
|||||||||||||||RECYCLING|
|1|Matchfunding||1000.00||||||||||||
|1|Plant Sale||100.00||||||||||||
|1|Parentpay||91.59||||0.00||||91.59||||
|1|Parentpay||2.96||||||||2.96||||
|5|Parentpay||2.96||||||||2.96||||
|11|C Lewis||35.00||35.00||||||||||
|12|Parentpay||29.56||||||||29.56||||
|19|Parentpay||26.60||||||||26.60||||
|21|Tata Steel||500.00||||||||||||
|26|Parentpay||182.17||||||||||182.17||
|26|Banked Cash||566.50||566.50||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
|**TOTALS**|||2537.34|0.00|601.50|0.00|0.00|0.00|0.00|0.00|153.67|0.00|182.17|0.00|
|1a<br>2a<br>10<br>11<br>12<br>13<br>14<br>15<br>16<br>17<br>18<br>19|||||||||||||||





Checksum
2537.34
2537.34

1a plus 2a 

Sum 10 to 25 

|**EXPENDITURE**<br>simplestExample.xls|**EXPENDITURE**<br>simplestExample.xls|**EXPENDITURE**<br>simplestExample.xls|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|_September-23_|_September-23_|_September-23_|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||||||||||||||
|_Payment details_|||||_Analysis ofpayments_||||||||||
||||_Paid by:-_||_Direct Costs_||||||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|CLOTHES<br>RECYCLING|
|1|CN001|6&8|363.67|||||363.67|||||||
|1|CN002|5|261.36|||||261.36|||||||
|1|CN003|1&3|92.27|||||||42.27|50.00||||
|1|CN004|2|500.00|||||||||500.00|||
|1|CN005|4|241.36||||||||||||
|4|Amazon|9|14.49|||||||14.49|||||
|14|Books for Bugs|7|140.00|||||140.00|||||||
|25|Shein|10|9.75|||||||9.75|||||
|29|Cut Price Wholesale||200.22|||||200.22|||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
||||||||||||||||
|**TOTALS**|||1823.12|0.00|0.00|0.00|0.00|965.25|0.00|66.51|50.00|500.00|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>34<br>35<br>36<br>37<br>38<br>39|||||||||||||||





Checksum
1823.12
1823.12

1b plus 2b 

Sum 30 to 45 

## **TRADING SUMMARY** 

|**_----------------Accounts-_**<br>**OPENING BALANCE**<br>Closing Balance last month<br>**INCOME**<br>**EXPENDITURE**<br>**CLOSING BALANCE**<br>Opening Balance for next month<br>**MOVEMENT**<br>**Trading Report**<br>Trading Income<br>Sum 1<br>Direct Costs<br>Sum 3<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>Sum 4<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42|September 2023 - August 2024|September 2023 - August 2024|September 2023 - August 2024|September 2023 - August 2024|_Month Name:_|_Month Name:_|_Month Name:_|_Month Name:_|_Month Name:_|_September-23_|_September-23_||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
||||||||||||||
||||||||||||||
||**_-----------------_**||||_Analysis of income_||||||||
||CASH<br>A/C|CHEQUE<br>A/C|||_Trading Income_||||||||
||3095.97||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|
||||||||||||||
||2537.34|0.00|601.50|0.00|0.00|0.00|0.00|0.00|153.67|0.00|182.17|0.00|
||1a|2a|10<br>11||12<br>13<br>14<br>15<br>16<br>17<br>18|||||||19|
||||||_Analysis ofpayments_||||||||
||||||_Direct Costs_||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|
||1823.12|0.00|0.00|0.00|0.00|965.25|0.00|66.51|50.00|500.00|0.00|0.00|
||1b<br>3810.19|2b<br>0.00|30<br>31||32<br>33<br>34<br>35<br>36<br>37<br>38|||||||39|
||714.22<br>0.00<br>1c<br>2c<br>0 to 17<br>755.17<br>0 to 40<br>1581.76<br>**-826.59**<br><br>0.00<br>182.17<br>182.17<br>**-644.42**<br>0 to 41<br>0.00<br>0.00<br>**-644.42**<br><br>0.00<br>**-644.42**||||**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>44<br>0.00 <br>LESS:<br>Depreciation on assets<br>as Trading Report<br>0.00<br>Capital equipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Change in Assets**<br>**0.00** <br>**Liabilities:**<br>VAT due to Customs & Excise<br>25 minus 45<br>0.00 <br>New Outside loans<br>23<br>0.00<br>New Personal loans<br>22<br>1600.00<br>LESS:<br>Loan repaym'ts (ex.Intr'st)<br>43<br>241.36<br>-<br>241.36<br>**Change in Liabilities**<br>**1358.64** <br>**Accounts:**<br>Movement in Cash account<br>1c<br>714.22<br>Movement in Bank account<br>2c<br>0.00 <br>LESS:<br>Grants for capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Change in Accounts**<br>**714.22**<br>**_Change in Nett worth_**<br>**-644.42**<br>Assets minus Liabilities plus change in Accounts||||||||
|||||||||||||V.A.T. due to C<br>V.A.T. reclaima<br> **_Nett amount_**<br> VAT due minus VAT re<br>Total value of S<br> Total value of P<br>**Standard Ho**|
|||||||||||-<br>0.00 <br>**0.00** <br>0.00 <br>0.00<br>1600.00<br>241.36|||
|||||||||||||'Billed' hours t<br>Overhead bur<br> **Standard Ho**<br>Overhead Burden divid<br>Note 1<br>Note 2|
|||||||||||-<br>241.36<br>**1358.64** <br>714.22<br>0.00 <br>0.00|||
|||||||||||-<br>0.00<br>**714.22**<br>**-644.42**||Note 1<br>Note 2|





_Month No._ 1 

|Other Income|Other Income|Other Income|Other Income|Other Income||
|---|---|---|---|---|---|
|||||||
|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|||1000.00||||
|||100.00||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||500.00||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|0.00|0.00|1600.00|0.00|0.00|0.00|
|20<br>21<br>22<br>23<br>24<br>25||||||





_Month No._ 1 

|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_||
|---|---|---|---|---|---|
||_Indirect costs_<br>_(Overheads)_|||||
|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|||||||
|||||||
|||||||
|||||||
||||241.36|||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|||||||
|0.00|0.00|0.00|241.36|0.00|0.00|
|40<br>41<br>42<br>43<br>44<br>45||||||





_Month No._ 1 

|Other Income|Other Income|Other Income|Other Income|Other Income||
|---|---|---|---|---|---|
|||||||
|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|0|0|1600.00|0.00|0.00|0.00|
|20<br>21<br>22<br>23<br>24<br>25||||||
|||||||
||_Indirect costs_<br>_(Overheads)_|||||
|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|241.36|0.00|0.00|
|40<br>41<br>42<br>43<br>44<br>45||||||



## **d Tax** 

Customs & Excise on sales able from C&E on expenditure 

||||
|---|---|---|
|Customs & Excise on sales|25|0.00|
|able from C&E on expenditure|45|0.00|
|**_owed to Customs & Excise_**||**0.00**|
|eclaimable|||
|Sales (excl. VAT)|Sum 10 to 17 plus 19+21+24|755.17|
|Purchases (excl. VAT)|Sum 30 to 41 plus 44|1581.76|



## **ur Calculation** 

this month rden Sum 41 to 42 0.00 **ur cost 0.00** 

ded by Billed hours Errors can occur in spreadsheets. Always check the results before acting on them. The Trading Reports on this page are for guidance only. More information is needed for a full Profit & Loss Account and a full Balance Sheet. 



|**INCOME**<br>simplestExample.xls|**INCOME**<br>simplestExample.xls|**INCOME**<br>simplestExample.xls|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|_October-23_|_October-23_|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||||
|_Payment from:-_||||||||||||_Analysis of income_||
||||_Paid to:-_||_Trading Income_|||||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|3|Roberts Recycling||32.10|||||||||||
|4|Parentpay||194.48||||0.00|||120.63|||73.85|
|10|Parentpay||241.18|||||||182.17|||59.01|
|17|Parentpay||103.40|||||||78.78|||24.62|
|24|Parentpay||46.75|||||||41.82|||4.93|
|27|C Lewis||15.00||||||15.00|||||
|27|Sumup||70.79|||||||70.79||||
|30|C Lewis||5.00||||||5.00|||||
|31|Parentpay||230.92|||||||145.25|||85.67|
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||





|||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||||
|||||||||||||||
|||||||||||||||
|**TOTALS**|||939.62|0.00|0.00|0.00|0.00|0.00|20.00|639.44|0.00|0.00|248.08|



Checksum 939.62 939.62 1a plus 2a Sum 10 to 25 

|**EXPENDITURE**<br>simplestExample.xls|**EXPENDITURE**<br>simplestExample.xls|**EXPENDITURE**<br>simplestExample.xls|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|_October-23_|_October-23_|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||||
|_Payment details_||||||||||||_Analysis ofpayments_||
||||_Paid by:-_||_Direct Costs_|||||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|4|Parentpay||36.00||||||||36.00|||
|9|Undy Primary School||300.00||||||300.00|||||
|11|Raffle Tickets 4 U||71.54||||||71.54|||||
|16|Chepstow Garden Centre||100.00||||||100.00|||||
|19|E Williams||75.03|||||5.16||44.64||||
|27|Asda|R2|19.45|||||7.95||11.50||||
|27|Asda|R1|28.50|||||||28.50||||
|30|E Williams||51.67|||||51.67||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||





|||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|**TOTALS**|||682.19|0.00|0.00|0.00|0.00|64.78|471.54|84.64|36.00|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>34<br>35<br>36<br>37<br>38<br>Checksum<br>682.19<br>682.19<br>1b plus 2b<br>Sum 30 to 45||||||||||||||



## **TRADING SUMMARY** 

|||||||||||_October-23_|_October-23_|
|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||
|||||||||||_Analysis of income_||
|CASH<br>A/C|CHEQUE<br>A/C||_Trading Income_|||||||||
|3810.19|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|||||||||||||
|939.62|0.00||0.00|0.00|0.00|0.00|20.00|639.44|0.00|0.00|248.08|
|1a|2|a|10<br>11<br>12<br>13<br>14<br>15<br>16<br>17<br>18|||||||||
||||_Analysis ofpayments_|||||||||
||||_Direct Costs_|||||||||
||||SPONSORED|FATHERS|MOTHERS|ELFRIDGES|XMAS|DISCOS|WONKA|SUMMER|OWN|





|**EXPENDITURE**<br>**CLOSING BALANCE**<br>Opening Balance for next month<br>**MOVEMENT**<br>**Trading Report**<br>Trading Income<br>Sum 1<br>Direct Costs<br>Sum 3<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>1<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>Sum 4<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>4||||EVENT|DAY|DAY|SANTA VISIT|FETE|||CIRCUS|CLOTHES DAY|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||682.19|0.00|0.00|0.00|0.00|64.78|471.54|84.64|36.00|0.00|0.00|
|||1b<br>4067.62|2b<br>0.00|||32<br>33<br>34<br>35<br>36<br>37<br>38<br>**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>44<br>0.00<br>LESS:<br>Depreciation on assets<br>as Trading Report<br>0.00<br>Capital equipment sold<br>24<br>0.00<br>-<br>0.00<br>**Change in Assets**<br>**0.00**<br>**Liabilities:**<br>VAT due to Customs & Excise<br>25 minus 45<br>0.00<br>New Outside loans<br>23<br>0.00<br>New Personal loans<br>22<br>0.00<br>LESS:<br>Loan repaym'ts (ex.Intr'st)<br>43<br>3.75<br>-<br>3.75<br>**Change in Liabilities**<br>**-3.75**<br>**Accounts:**<br>Movement in Cash account<br>1c<br>257.43<br>Movement in Bank account<br>2c<br>0.00<br>LESS:<br>Grants for capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Change in Accounts**<br>**257.43**<br>**_Change in Nett worth_**<br>**261.18**<br>Assets minus Liabilities plus change in Accounts|||||||
||||||||||||-<br>0.00<br>**0.00**<br>0.00<br>0.00<br>0.00<br>3.75||
||||||||||||-<br>3.75<br>**-3.75**<br>257.43<br>0.00<br>0.00||
||||||||||||-<br>0.00<br>**257.43**<br>**261.18**||





|||||||2|
|---|---|---|---|---|---|---|
||||||||
|Other Income|||||||
||||||||
|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|32.1|||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||





||||||||
|---|---|---|---|---|---|---|
||||||||
||||||||
||||||||
|32.10|0.00|0.00|0.00|0.00|0.00|0.00|
|19<br>20<br>21<br>22<br>23<br>24<br>25|||||||



_Month No._ 2 

|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_||
|---|---|---|---|---|---|---|
|||_Indirect costs_<br>_(Overheads)_|||||
|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
||||||||
||||||||
||||||||
||||||||
||||21.48|3.75|||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||





||||||||
|---|---|---|---|---|---|---|
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
|0.00|0.00|0.00|21.48|3.75|0.00|0.00|
|39<br>40<br>41<br>42<br>43<br>44<br>45|||||||



|||||||2|
|---|---|---|---|---|---|---|
||||||||
|Other Income|||||||
||||||||
|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|32.10|0|0|0.00|0.00|0.00|0.00|
|19<br>20<br>21<br>22<br>23<br>24<br>25<br>_Indirect costs_<br>_(Overheads)_|||||||
||||||||
|||_Indirect costs_<br>_(Overheads)_|||||
|RECYCLING|CAULIFLOWER|MEMBER|OTHER|UPS|CAPITAL|V.A.T.|





||CARDS|SHIPS|EXP'S|DONATIONS|EXPEND||
|---|---|---|---|---|---|---|
|0.00|0.00|0.00|21.48|3.75|0.00|0.00|
|39<br>40<br>41<br>42<br>43<br>44<br>45<br>**Value Added Tax**<br>V.A.T. due to Customs & Excise on sales<br>25<br>0.00<br>V.A.T. reclaimable from C&E on expenditure<br>45<br>0.00<br>**_Nett amount owed to Customs & Excise_**<br>**0.00**<br>VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br>Sum 10 to 17 plus 21+24<br>659.44<br>Total value of Purchases (excl. VAT)<br>Sum 30 to 42 plus 44<br>678.44|||||44<br>45<br>25<br>0.00<br>45<br>0.00||



## **Standard Hour Calculation** 

|'Billed' hours this month<br>Overhead burden<br>Sum 40 to 42<br>**Standard Hour cost**<br>Overhead Burden divided by Billed hours||
|---|---|
|Note 1<br>Errors can occur in spreadsheets. Always<br>check the results before acting on them.<br>Note 2<br>The Trading Reports on this page are for<br>guidance only. More information is needed<br>for a full Profit & Loss Account and a full<br>Balance Sheet.||





|**INCOME**<br>simplestExample.xls|**INCOME**<br>simplestExample.xls|**INCOME**<br>simplestExample.xls|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|_November-23_|_November-23_|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||||
|_Payment from:-_|||||_Analysis of income_|||||||||
||||_Paid to:-_||_Trading Income_|||||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|2|Banked cash||47.50|||||||47.50||||
|2|Banked cash||277.50||||0.00|||277.50||||
|6|E Williams||5.00||||||5.00|||||
|7|Parent Pay||88.63|||||||19.69|||68.94|
|7|E Williams||3.60|||||3.60||||||
|10|Magor Curchmen||225.00|||||||||||
|13|Banked cash||581.00||||||581.00|||||
|14|Parent Pay||24.62||||||||||24.62|
|15|DL Holder||10.00||||||10.00|||||
|21|Parent Pay||14.78||||||||||14.78|
|23|C Lewis||10.00||||||10.00|||||
|27|Homebargains Refund|R9|22.98|||||||||||
|27|Banked cash||2003.04||||||2003.04|||||
|27|Sum up||50.16||||||50.16|||||
|28|Parent Pay||516.98|||||516.98||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||
|||||||||||||||





|||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||||
|||||||||||||||
|||||||||||||||
|**TOTALS**|||3880.79|0.00|0.00|0.00|0.00|520.58|2659.20|344.69|0.00|0.00|108.34|
|1a<br>2a<br>10<br>11<br>12<br>13<br>14<br>15<br>16<br>Checksum<br>3880.79<br>3880.79<br>1a plus 2a<br>Sum 10 to 25<br>**EXPENDITURE**<br>September 2023 - August 2024||||||||||||17<br>18||
|||||||||||||||



|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|**EXPENDITURE**<br>September 2023 - August 2024|||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|_Month Name:_<br>simplestExample.xls||||||||||||_November-23_||
|||||||||||||||
|_Payment details_|||||_Analysis ofpayments_|||||||||
||||_Paid by:-_||_Direct Costs_|||||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|1|Home Bargains||33.42|||||||||||
|3|E Horton||64.71||||||40.96|||||
|6|BnM|R3|3.50|||||||||||
|6|Amazon||4.49||||||4.49|||||
|6|Amazon||20.79|||||||||||
|9|Amazon||20.99|||||||||||
|13|Emma Williams||45.00|||||45.00||||||
|14|Tesco||64.25|||||||||||
|14|Morrisons|R4|87.00|||||30.00|57.00|||||
|17|Amazon||8.99|||||||||||
|21|Elizabeth Bodenham||18.00|||||18.00||||||
|21|Emma Williams||71.30|||||42.00||||||
|22|Tesco|R6|7.50||||||7.50|||||
|22|Amazon||12.99||||||12.99|||||
|22|Tesco|R12|14.00|||||||||||





|22|Home Bargains|R5|23.47|||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|27|Tesco|R10|21.00|||||||||||
|27|Chepstow Garden Centre|R8|24.29|||||||||||
|27|Asda|R7|25.15|||||15.75||||||
|27|Cheap fabrics||19.06|||||||||||
|27|Morrisons||171.00|||||171.00||||||
|29|The Range||17.50|||||17.50||||||
|29|Home Bargains||33.49|||||33.49||||||
|29|Amazon||57.95|||||||||||
|30|Home Bargains||13.75|||||13.75||||||
|30|Morrisons||50.00|||||50.00||||||
|||||||||||||||
|||||||||||||||
|**TOTALS**|||933.59|0.00|0.00|0.00|0.00|436.49|122.94|0.00|0.00|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>34<br>35<br>36<br>37<br>38<br>Checksum<br>933.59<br>933.59<br>1b plus 2b<br>Sum 30 to 45||||||||||||||



## **TRADING SUMMARY** 

|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|September 2023 - August 2024<br>_Month Name:_|_November-23_|_November-23_|
|---|---|---|---|---|---|---|---|---|---|---|---|
|||||||||||||
|**_-----------------_**|||_Analysis of income_|||||||||
|CASH<br>A/C|CHEQUE<br>A/C||_Trading Income_|||||||||
|4067.62|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|||||||||||||
|3880.79|0.00||0.00|0.00|0.00|520.58|2659.20|344.69|0.00|0.00|108.34|
|1a|2|a|10<br>11<br>12<br>13<br>14<br>15<br>16<br>17<br>18|||||||||
||||_Analysis ofpayments_|||||||||
||||_Direct Costs_|||||||||
||||SPONSORED|FATHERS|MOTHERS|ELFRIDGES|XMAS|DISCOS|WONKA|SUMMER|OWN|





|**EXPENDITURE**<br>**CLOSING BALANCE**<br>Opening Balance for next month<br>**MOVEMENT**<br>**Trading Report**<br>Trading Income<br>Sum 1<br>Direct Costs<br>Sum 3<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>1<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>Sum 4<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>4||||EVENT|DAY|DAY|SANTA VISIT|FETE|||CIRCUS|CLOTHES DAY|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|||933.59|0.00|0.00|0.00|0.00|436.49|122.94|0.00|0.00|0.00|0.00|
|||1b<br>7014.82|2b<br>0.00|||32<br>33<br>34<br>35<br>36<br>37<br>38<br>**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>44<br>0.00<br>LESS:<br>Depreciation on assets<br>as Trading Report<br>0.00<br>Capital equipment sold<br>24<br>0.00<br>-<br>0.00<br>**Change in Assets**<br>**0.00**<br>**Liabilities:**<br>VAT due to Customs & Excise<br>25 minus 45<br>0.00<br>New Outside loans<br>23<br>22.98<br>New Personal loans<br>22<br>225.00<br>LESS:<br>Loan repaym'ts (ex.Intr'st)<br>43<br>23.75<br>-<br>23.75<br>**Change in Liabilities**<br>**224.23**<br>**Accounts:**<br>Movement in Cash account<br>1c<br>2947.20<br>Movement in Bank account<br>2c<br>0.00<br>LESS:<br>Grants for capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Change in Accounts**<br>**2947.20**<br>**_Change in Nett worth_**<br>**2722.97**<br>Assets minus Liabilities plus change in Accounts|||||||
||||||||||||-<br>0.00<br>**0.00**<br>0.00<br>22.98<br>225.00<br>23.75||
||||||||||||-<br>23.75<br>**224.23**<br>2947.20<br>0.00<br>0.00||
||||||||||||-<br>0.00<br>**2947.20**<br>**2722.97**||





_Month No._ 3 

|Other Income|Other Income|Other Income|Other Income|Other Income|Other Income||
|---|---|---|---|---|---|---|
||||||||
|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||||||
||||||||
||||||||
||||||||
||||||||
||||225.00||||
||||||||
||||||||
||||||||
||||||||
||||||||
|||||22.98|||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||
||||||||





||||||||
|---|---|---|---|---|---|---|
||||||||
||||||||
||||||||
|0.00|0.00|0.00|225.00|22.98|0.00|0.00|
|19<br>20<br>21<br>22<br>23<br>24<br>25|||||||



_Month No._ 3 

|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_||
|---|---|---|---|---|---|---|
|||_Indirect costs_<br>_(Overheads)_|||||
|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
||||33.42||||
|||||23.75|||
||||3.50||||
||||||||
||||20.79||||
||||20.99||||
||||||||
||||64.25||||
||||||||
||||8.99||||
||||||||
||||29.30||||
||||||||
||||||||
||||14.00||||





||||23.47||||
|---|---|---|---|---|---|---|
||||21.00||||
||||24.29||||
||||9.40||||
||||19.06||||
||||||||
||||||||
||||||||
||||57.95||||
||||||||
||||||||
||||||||
||||||||
|0.00|0.00|0.00|350.41|23.75|0.00|0.00|
|39<br>40<br>41<br>42<br>43<br>44<br>45|||||||



|||||||3|
|---|---|---|---|---|---|---|
||||||||
|Other Income|||||||
||||||||
|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|0.00|0|0|225.00|22.98|0.00|0.00|
|19<br>20<br>21<br>22<br>23<br>24<br>25|||||||
||||||||
|||_Indirect costs_<br>_(Overheads)_|||||
|RECYCLING|CAULIFLOWER|MEMBER|OTHER|UPS|CAPITAL|V.A.T.|





||CARDS|SHIPS|EXP'S|DONATIONS|EXPEND||
|---|---|---|---|---|---|---|
|0.00|0.00|0.00|350.41|23.75|0.00|0.00|
|39<br>40<br>41<br>42<br>43<br>44<br>45<br>**Value Added Tax**<br>V.A.T. due to Customs & Excise on sales<br>25<br>0.00<br>V.A.T. reclaimable from C&E on expenditure<br>45<br>0.00<br>**_Nett amount owed to Customs & Excise_**<br>**0.00**<br>VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br>Sum 10 to 17 plus 19+21+24<br>3524.47<br>Total value of Purchases (excl. VAT)<br>Sum 30 to 42 plus 44<br>909.84|||||44<br>45<br>25<br>0.00<br>45<br>0.00||



## **Standard Hour Calculation** 

|'Billed' hours this month<br>Overhead burden<br>Sum 40 to 42<br>**Standard Hour cost**<br>Overhead Burden divided by Billed hours||
|---|---|
|Note 1<br>Errors can occur in spreadsheets. Always<br>check the results before acting on them.<br>Note 2<br>The Trading Reports on this page are for<br>guidance only. More information is needed<br>for a full Profit & Loss Account and a full<br>Balance Sheet.||





## **1st QUATER TRADING SUMMARY** 

## September 2023 - August 2024 

## _**Totals from Months 1, 2 and 3**_ 

|**_---------Accounts-----------_**<br>CASH<br>CHEQUE<br>A/C<br>A/C<br>**OPENING BALANCE**<br>3095.97<br>0.00<br>SPONSORED<br>FATHERS<br>Closing Balance last Year<br>EVENT<br>DAY<br>**INCOME**<br>7357.75<br>0.00<br>601.50<br>0.00<br>1a<br>2a<br>10<br>11<br>SPONSORED<br>FATHERS<br>EVENT<br>DAY<br>**EXPENDITURE**<br>3438.90<br>0.00<br>0.00<br>0.00<br>1b<br>2b<br>30<br>31<br>**CLOSING BALANCE**<br>7014.82<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>3918.85<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>4939.08<br>Direct Costs<br>Sum 30 to 40<br>2798.15<br>**Gross Profit**<br>**2140.93**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>32.10<br>R/Grants & Other Income<br>538.59<br>18+21<br>570.69<br>**Total Income**<br>**2711.62**<br>Gross Profit + Other Income|||||_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|
|---|---|---|---|---|---|---|---|---|---|---|---|
||CASH<br>A/C|CHEQUE<br>A/C|||_Trading Income_|||||||
||3095.97|0.00|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
|||||||||||||
||7357.75|0.00|601.50|0.00|0.00|520.58|2679.20|984.13|153.67|0.00|538.59|
||1a|2a|10<br>11||12<br>13<br>14<br>15<br>16<br>17<br>18|||||||
||||||_Analysis ofpayments_|||||||
||||||_Direct Costs_|||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|
||3438.90|0.00|0.00|0.00|0.00|1466.52|594.48|151.15|86.00|500.00|0.00|
||1b<br>7014.82|2b<br>0.00|30<br>31<br>||32<br>33<br>34<br>35<br>36<br>37<br>38|||||||
||||||**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>44<br>0.00<br>LESS:<br>Depreciation on assets<br>as Trading Repor<br>0.00<br>Capital equipment sold<br>24<br>0.00<br>-<br>0.00<br>**Change in Assets**<br>**0.00**<br>**Liabilities:**<br>VAT due to Customs & Excise<br>25 minus 45<br>0.00<br>New Outside loans<br>23<br>22.98<br>New Personal loans<br>22<br>1825.00<br>LESS:<br>Loan repaym'ts (ex.Intr'st)<br>43<br>268.86<br>-<br>268.86<br>**Change in Liabilities**<br>**1579.12**<br>**Accounts:**<br>Movement in Cash account<br>1c<br>3918.85|||||||
|||||||||||-<br>0.00<br>**0.00**<br>0.00<br>22.98<br>1825.00<br>268.86||
|||||||||||-<br>268.86<br>**1579.12**<br>3918.85||





|Overheads<br>Sum 31 to 41<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the Period_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42|2798.15|2798.15|
|---|---|---|
||||
|||2798.15<br>**-86.53**|
|||**-86.53**|



|Movement in Bank account|2c||0.00|
|---|---|---|---|
|LESS:<br>Grants for capital equip.|20|0.00||
|||-|0.00|
|**Change in Accounts**|||**3918.85**|
|**_Change in Nett worth_**|||**2339.73**|



Assets minus Liabilities plus change in Accounts 



## _Year_ 

|Other Income|Other Income|Other Income|Other Income|Other Income|Other Income||
|---|---|---|---|---|---|---|
||||||||
|RECYCLING<br>|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|32.10|0|0|1825.00|22.98|0.00|0.00|
|19<br>20<br>21<br>22<br>23<br>24<br>25|||||||
|_Indirect costs_<br>_(Overheads)_|||||||
|||_Indirect costs_<br>_(Overheads)_|||||
|RECYCLING<br>|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|371.89|268.86|0.00|0.00|
|39<br>40<br>41<br>42<br>43<br>44<br>45|||||||



## **Value Added Tax** 

|V.A.T. due to Customs & Excise on sales|25|0.00|
|---|---|---|
|V.A.T. reclaimable from C&E on expenditure|45|0.00|
|**_Nett amount owed to Customs & Excise_**||**0.00**|
|VAT due minus VAT reclaimable|||
|Total value of Sales (excl. VAT)|Sum 10 to 17 plus 19+21+24|4971.18|
|Total value of Purchases (excl. VAT)|Sum 30 to 41 plus 44|3170.04|



## **Standard Hour Calculation** 

Billed' hours this Period Overhead burden Sum 41 to 42 371.89 



**0.00** 

## **Standard Hour cost** 

Overhead Burden divided by Billed hours 

|Note|1|Errors can occur in spreadsheets. Always|
|---|---|---|
|||check the results before acting on them.|
|Note|2|The Trading Reports on this page are for|
|||guidance only. More information is needed|
|||for a full Profit & Loss Account and a full|
|||Balance Sheet.|





September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|5|Parent Pay||440.43|||||440.43|
|6|Roberts Recycling||27.60||||0.00||
|6|Amazon||57.95||||||
|11|Groundworks||1057.50||||||
|11|C Lewis||4.00|||||4.00|
|11|Banked cash||10.00|||||10.00|
|11|Banked cash||577.26|||||577.26|
|11|Banked cash||833.50|||||833.50|
|12|Parent Pay||260.95|||||251.10|
|19|Parent Pay||264.89|||||259.96|
|27|Cutprice Wholesalers||0.95|||||0.95|
|28|Parent Pay||14.78||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||3549.81|0.00|0.00|0.00|0.00|2377.20|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>3549.81<br>3549.81<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|





|4|Amazon||54.88|||||||
|---|---|---|---|---|---|---|---|---|---|
|5|E Horton||61.00||||||61.00|
|5|J Peters||29.89|||||||
|11|Cutprices Wholesales||166.64||||||166.64|
|20|E Horton||19.00||||||19.00|
|20|E Williams||98.58||||||92.58|
|20|J Hughes||53.46||||||53.46|
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|**TOTALS**|||483.45|0.00||0.00|0.00|0.00|392.68|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>483.45<br>483.45<br>1b plus 2b<br>Sum 30 to 45||||||||||



## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|7014.82|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|3549.81|0.00||0.00|0.00|0.00|2377.20|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|483.45|0.00||0.00|0.00|0.00|392.68|
|1b<br>10081.18|2b<br>0.00||30<br>31<br>32<br>33||||





|Opening Balance for next month<br>**MOVEMENT**<br>3066.36<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2377.20<br>Direct Costs<br>Sum 30 to 40<br>423.67<br>**Gross Profit**<br>**1953.53**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>27.60<br>R/Grants & Other Income<br>1087.06<br>18+21<br>1114.66<br>**Total Income**<br>**3068.19**<br>Gross Profit + Other Income<br>Overheads<br>Sum 41 to 42<br>59.78<br>Depreciation<br>Calculate elsewhere or leave at 0<br>59.78<br>**_Profit (Loss) for the month_**<br>**3008.41**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>**3008.41**|Opening Balance for next month<br>**MOVEMENT**<br>3066.36<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2377.20<br>Direct Costs<br>Sum 30 to 40<br>423.67<br>**Gross Profit**<br>**1953.53**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>27.60<br>R/Grants & Other Income<br>1087.06<br>18+21<br>1114.66<br>**Total Income**<br>**3068.19**<br>Gross Profit + Other Income<br>Overheads<br>Sum 41 to 42<br>59.78<br>Depreciation<br>Calculate elsewhere or leave at 0<br>59.78<br>**_Profit (Loss) for the month_**<br>**3008.41**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>**3008.41**|Opening Balance for next month<br>**MOVEMENT**<br>3066.36<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2377.20<br>Direct Costs<br>Sum 30 to 40<br>423.67<br>**Gross Profit**<br>**1953.53**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>27.60<br>R/Grants & Other Income<br>1087.06<br>18+21<br>1114.66<br>**Total Income**<br>**3068.19**<br>Gross Profit + Other Income<br>Overheads<br>Sum 41 to 42<br>59.78<br>Depreciation<br>Calculate elsewhere or leave at 0<br>59.78<br>**_Profit (Loss) for the month_**<br>**3008.41**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>**3008.41**|
|---|---|---|
||**1953.53**<br>27.60<br>1087.06||
||1114.66<br>**3068.19**<br>59.78|1114.66|
|||**3068.19**|
||||
||59.78<br>**3008.41**||
||**3008.41**||



**Changes to Balance S Assets:** Capital equipment aqu LESS: Depreciatio Capital equ **Change in Liabilities:** VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay **Change in Accounts:** Movement in Cash acc Movement in Bank acc LESS: Grants for c **Change in** 

## _**Change in Nett worth**_ 

Assets minus Liabilities plus change in 



_Month Name: December-23_ 

_Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
||||||||||
||||||27.6||||
||||||||||
||||||||1057.5||
||||||||||
||||||||||
||||||||||
||||||||||
|||||9.85|||||
|||||4.93|||||
||||||||||
|||||14.78|||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|0.00|29.56|27.60|0.00|1057.50|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_December-23_|_December-23_|_December-23_|_December-23_|_December-23_|_December-23_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|





|||||||||54.88|
|---|---|---|---|---|---|---|---|---|
||||||||||
|24.99||||||||4.90|
||||||||||
||||||||||
|||6.00|||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|24.99|0.00|6.00|0.00|0.00|0.00|0.00|0.00|59.78|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_December-23_|_December-23_|_December-23_|_December-23_|_December-23_|_December-23_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis of income_<br>_Income_<br>Other I|||||||||
|_Income_|||||||||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|0.00|0.00|29.56|27.60|0|1057.5|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|24.99|0.00|6.00|0.00|0.00|0.00|0.00|0.00|59.78|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||





## **Sheet** 

## **Value Added Tax** 

|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>57.95<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**57.95** <br>count<br>1c<br>3066.36<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**3066.36**<br>**_h_**<br>**3008.41**<br>n Accounts|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>57.95<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**57.95** <br>count<br>1c<br>3066.36<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**3066.36**<br>**_h_**<br>**3008.41**<br>n Accounts|V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 41 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>57.95<br>0.00<br>0.00||
||-<br>0.00<br>**57.95** <br>3066.36<br>0.00 <br>0.00||
||-<br>0.00<br>**3066.36**<br>**3008.41**||



## _**h**_ 



_Month No._ 

4 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
|57.95|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|57.95|0.00|0.00|
|23<br>24<br>25|||



|_Month No._|_Month No._|4|
|---|---|---|
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|





0.00 0.00 0.00 43 44 45 

|_Month No._|_Month No._|4|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|57.95|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|
|43<br>44<br>45|||





||||||25|0.00|
|---|---|---|---|---|---|---|
||||||45|0.00|
|||||||**0.00**|
|Sum|10|to|17|plus|19+21+24|3462.30|
|Sum|30|to|40|plus|44|423.67|



59.78 **0.00** 

Always them. are for s needed d a full 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|4|Cauliflower Cards||499.00||||||
|23|Parentpay||105.86||||0.00||
|24|Banked Cash||665.05|||||665.05|
|30|Parentpay||86.18||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||1356.09|0.00|0.00|0.00|0.00|665.05|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>1356.09<br>1356.09<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|





|2|Parentkind||153.00||||||
|---|---|---|---|---|---|---|---|---|
|2|Monmuthshire Council||20.00||||||
|15|Emma J Williams||116.72||||||
|24|Amazon||29.50||||29.50||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||319.22|0.00|0.00|0.00|29.50|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>319.22<br>319.22<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

## September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||||_Trading_||
|10081.18|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|1356.09|0.00||0.00|0.00|0.00|665.05|
|1a|2|a|10<br>11||12<br>13||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|319.22|0.00||0.00|0.00|29.50|0.00|
|1b<br>11118.05|2b<br>0.00||30<br>31||32<br>33||
|1036.87<br>0.00|||||||
||||||<br>**Assets:**||





|1c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>Direct Costs<br>Sum 30 to 39 plus 42<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>41<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42|2c<br>837.40<br>166.22|2c<br>837.40<br>166.22|
|---|---|---|
||**671.18**<br>0.00<br>19.69||
||19.69<br>**690.87**<br>153.00|19.69|
|||**690.87**|
||||
||153.00<br>**537.87**||
||**537.87**||



Capital equipment aqu LESS: Depreciatio Capital equ **Change in Liabilities:** VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay **Change in** 

## **Accounts:** 

Movement in Cash acc Movement in Bank acc LESS: Grants for c **Change in** 

## _**Change in Nett worth**_ 

Assets minus Liabilities plus change in 



_Month Name: January-24_ 

_Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|||||||499|||
||86.17|||19.69|||||
||||||||||
||86.18||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|172.35|0.00|0.00|19.69|0.00|499.00|0.00|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_January-24_|_January-24_|_January-24_|_January-24_|_January-24_|_January-24_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|





||||||||153||
|---|---|---|---|---|---|---|---|---|
|||||||||20.00|
||107.16|9.56|||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|107.16|9.56|0.00|0.00|0.00|0.00|153.00|20.00|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



_Month Name: January-24_ 

_Analysis of income Income_ 

||||||||Other I|Other I|
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|172.35|0.00|0.00|19.69|0.00|499.00|0|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|0.00|107.16|9.56|0.00|0.00|0.00|0.00|153.00|20.00|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



## **Sheet** 

**Value Added Tax** 



|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**0.00** <br>count<br>1c<br>1036.87<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>499.00<br>-<br>499.00<br>**Accounts**<br>**537.87**<br>**_h_**<br>**537.87**<br>n Accounts|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**0.00** <br>count<br>1c<br>1036.87<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>499.00<br>-<br>499.00<br>**Accounts**<br>**537.87**<br>**_h_**<br>**537.87**<br>n Accounts|V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>41<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>0.00<br>0.00<br>0.00||
||-<br>0.00<br>**0.00** <br>1036.87<br>0.00 <br>499.00||
||-<br>499.00<br>**537.87**<br>**537.87**||



## _**h**_ 



_Month No._ 

5 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|0.00|0.00|0.00|
|23<br>24<br>25|||



|_Month No._|_Month No._|5|
|---|---|---|
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|





||||
|---|---|---|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|0.00|0.00|0.00|
|43<br>44<br>45|||



|_Month No._|_Month No._|5|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|0.00|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|
|43<br>44<br>45|||





||||||25|0.00|
|---|---|---|---|---|---|---|
||||||45|0.00|
|||||||**0.00**|
|Sum|10|to|17|plus|19+21+24|837.40|
|Sum|30|to|39|plus|42|319.22|



153.00 **0.00** 

Always them. are for s needed d a full 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|simplestExample.xls|simplestExample.xls|simplestExample.xls|simplestExample.xls|simplestExample.xls|simplestExample.xls|
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|2|Cauliflower Group||18.50||||||
|6|Parentpay||204.33||||137.86||
|9|Sumup||129.17||||||
|13|Parentpay||391.44||||206.79||
|13|Banked Cash||354.60||||||
|13|E Williams||10.82||||||
|21|Parentpay||99.84||||31.02||
|27|Parentpay||130.97||||110.29||
|27|RWE Renewables||500.00||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||1839.67|0.00|0.00|0.00|485.96|0.00|
|1a<br>2a<br>10<br>11<br>12<br>13<br>Checksum<br>1839.67<br>1839.67<br>1a plus 2a<br>Sum 10 to 25|||||||||



**EXPENDITURE** September 2023 - August 2024 

simplestExample.xls _Payment details Paid by:-_ 



||||||||||
|---|---|---|---|---|---|---|---|---|
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|1|TTS Group||1403.94||||||
|5|Farmfoods||124.25||||||
|5|Ikea||80.00||||80.00||
|5|Bookers||351.17||||||
|7|Asda||20.00||||||
|8|Bookers||21.37||||||
|12|BnM||7.00||||||
|15|Emma J Williams||44.59||||21.65||
|26|Discount Dragon||31.89||||||
|28|Doxdirect||43.33||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||2127.54|0.00|0.00|0.00|101.65|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>2127.54<br>2127.54<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C|_Trading_||||
|11118.05||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|||||||
|1839.67|0.00|0.00|0.00|485.96|0.00|
|1a|2a|10<br>11<br>12<br>13||||





|**EXPENDITURE**<br>**CLOSING BALANCE**<br>Opening Balance for next month<br>**MOVEMENT**<br>**Trading Report**<br>Trading Income<br>Sum 1<br>Direct Costs<br>Sum 3<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>1<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>Sum 3<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>4||||||MOTHERS<br>ELFRIDGES<br>DAY<br>SANTA VISIT<br>101.65<br>0.00<br>32<br>33<br>**Changes to Balance S**|MOTHERS<br>ELFRIDGES<br>DAY<br>SANTA VISIT<br>101.65<br>0.00<br>32<br>33<br>**Changes to Balance S**|
|---|---|---|---|---|---|---|---|
|||||||||
|||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|||2127.54|0.00|0.00|0.00|101.65|0.00|
|||1b<br>10830.18|2b<br><br>0.00|||||
|||||||<br>**Assets:**<br>Capital equipment aqu<br>LESS:<br>Depreciatio<br>Capital equ<br>**Change in**<br>**Liabilities:**<br>VAT due to Customs &<br>New Outside loans<br>New Personal loans<br>LESS:<br>Loan repay<br>**Change in**<br>**Accounts:**<br>Movement in Cash acc<br>Movement in Bank acc<br>LESS:<br>Grants for c<br>**Change in**<br>**_Change in Nett worth_**<br>Assets minus Liabilities plus change in||



Assets minus Liabilities plus change in 



_Month Name: February-24_ 

_Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|||||||18.5|||
||66.47||||||||
||129.17||||||||
||179.72|||4.93|||||
||354.60||||||||
||10.82||||||||
||49.13|||19.69|||||
|||20.68|||||||
|||||||||500.00|
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|789.91|20.68|0.00|24.62|0.00|18.50|0.00|500.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



_Month Name: February-24 Analysis of payments_ 

_Direct Costs_ 

_Indirect costs_ 



||||||||_(Overheads)_|_(Overheads)_|
|---|---|---|---|---|---|---|---|---|
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
||||||||||
|||124.25|||||||
||||||||||
|||||||||351.17|
||20.00||||||||
||21.37||||||||
|||||||||7.00|
|||10.74||||||12.20|
|||12.50||||||19.39|
|||43.33|||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|41.37|190.82|0.00|0.00|0.00|0.00|0.00|389.76|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



_Month Name: February-24_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|789.91|20.68|0.00|24.62|0.00|18.5|0|500.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||





|_Analysis ofpayments_<br>_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>41.37<br>190.82<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>500.00<br>ym'ts (ex.Intr'st)<br>43<br>1403.94<br>-<br>1403.94<br>**Liabilities**<br>**-903.94** <br>count<br>1c<br>-287.87<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>18.50<br>-<br>18.50<br>**Accounts**<br>**-306.37**<br>**_h_**<br>**597.57**<br>n Accounts|_Analysis ofpayments_<br>_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>41.37<br>190.82<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>500.00<br>ym'ts (ex.Intr'st)<br>43<br>1403.94<br>-<br>1403.94<br>**Liabilities**<br>**-903.94** <br>count<br>1c<br>-287.87<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>18.50<br>-<br>18.50<br>**Accounts**<br>**-306.37**<br>**_h_**<br>**597.57**<br>n Accounts|RECYCLING CAULIFLOWER<br>MEMBER<br>OTHER<br>CARDS<br>SHIPS<br>EXP'S<br>0.00<br>0.00<br>0.00<br>389.76<br>39<br>40<br>41<br>42<br>**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.<br>_Indirect costs_<br>_(Overheads)_|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>0.00<br>500.00<br>1403.94||
||-<br>1403.94<br>**-903.94** <br>-287.87<br>0.00 <br>18.50||
||-<br>18.50<br>**-306.37**<br>**597.57**|Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account an<br>Balance Sheet.|





6 

_Month No._ 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|0.00|0.00|0.00|
|23<br>24<br>25|||



_Month No._ 6 



||||
|---|---|---|
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|1403.94|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|1403.94|0.00|0.00|
|43<br>44<br>45|||



|_Month No._|_Month No._|6|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|0.00|0.00|0.00|
|23<br>24<br>25|||





||||
|---|---|---|
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|1403.94|0.00|0.00|
|43<br>44<br>45<br>25<br>0.00<br>45<br>0.00<br>**0.00**<br>Sum 10 to 17 plus 21+24<br>1296.55<br>Sum 30 to 42 plus 44<br>723.60|44<br>45<br>25<br>0.00<br>45<br>0.00||



## **0.00** 

Always them. are for s needed d a full 



## **2nd QUATER TRADING SUMMARY** 

## September 2023 - August 2024 

|**_---------Accounts-----------_**<br>CASH<br>CHEQUE<br>A/C<br>A/C<br>**OPENING BALANCE**<br>7014.82<br>0.00<br>SPONSORED<br>FATHERS<br>Closing Balance last Year<br>EVENT<br>DAY<br>**INCOME**<br>6745.57<br>0.00<br>0.00<br>0.00<br>1a<br>2a<br>10<br>11<br>SPONSORED<br>FATHERS<br>EVENT<br>DAY<br>**EXPENDITURE**<br>2930.21<br>0.00<br>0.00<br>0.00<br>1b<br>2b<br>30<br>31<br>**CLOSING BALANCE**<br>10830.18<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>3815.36<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>4511.15<br>Direct Costs<br>30<br>903.73<br>**Gross Profit**<br>**3607.42**<br>Trading Income minus Direct Costs<br>Other Income<br>Donations<br>19<br>27.60<br>R/Grants & Other Income<br>1131.37<br>18+21<br>1158.97<br>**Total Income**<br>**4766.39**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>622.54<br>Depreciation<br>Calculate elsewhere or leave at 0<br>622.54<br>**_Profit (Loss) for the Period_**<br>**4143.85**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>**4143.85**||||||||
|---|---|---|---|---|---|---|---|
||CASH<br>A/C|CHEQUE<br>A/C|||_Trading Income_|||
||7014.82|0.00|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|
|||||||||
||6745.57|0.00|0.00|0.00|485.96|3042.25|0.00|
||1a|2a|10<br>11||12<br>13<br>14|||
|||||||||
||||||_Direct_|||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|
||2930.21|0.00|0.00|0.00|131.15|392.68|24.99|
||1b<br>10830.18|2b<br>0.00|30<br>31||32<br>33<br>34|||
||||||**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>LESS:<br>Depreciation on asset<br>Capital equipment sol<br>**Change in Assets**<br>**Liabilities:**<br>VAT due to Customs & Excise<br>New Outside loans<br>New Personal loans<br>LESS:<br>Loan repaym'ts (ex.In<br>**Change in Liabilities**<br>**Accounts:**<br>Movement in Cash account<br>Movement in Bank account<br>LESS:<br>Grants for capital equ<br>**Change in Accounts**<br>**_Change in Nett worth_**<br>Assets minus Liabilities plus change in Accounts|||



Assets minus Liabilities plus change in Accounts 



_**Totals from Months 4, 5 and 6**_ 

_Year_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|Other Income|Other Income|Other Income|Other Income|Other Income|Other Income|
|---|---|---|---|---|---|---|---|---|---|
|||||||||||
|DISCOS|WONKA|SUMMER<br>CIRCUS<br>|OWN<br>CLOTHES DAY|RECYCLING <br>|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|
|962.26|20.68|0.00|73.87|27.60|517.5|1057.5|500.00|57.95|0.00|
|15<br>16<br>17<br>18||||19<br>20<br>21<br>22<br>23<br>24||||||
|_Analysis ofpayments_||||_Indirect costs_<br>_(Overheads)_||||||
|_Costs_||||||_Indirect costs_<br>_(Overheads)_||||
|DISCOS|WONKA|SUMMER<br>CIRCUS<br>|OWN<br>CLOTHES DAY|RECYCLING <br>|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|
|148.53|206.38|0.00|0.00|0.00|0.00|153.00|469.54|1403.94|0.00|
|35<br>36<br>37<br>38<br>44<br>0.00 <br>ts<br>as Trading Repor<br>0.00<br>ld<br>24<br>0.00<br>-<br>0.00 <br>**0.00** <br>25 minus 45<br>0.00 <br>23<br>57.95<br>22<br>500.00<br>ntr'st)<br>43<br>1403.94<br>-<br>1403.94<br>**s**<br>**-845.99** <br>1c<br>3815.36<br>2c<br>0.00 <br>uip.<br>20<br>517.50<br>-<br>517.50<br>**s**<br>**3297.86**<br>**4143.85**||||39<br>40<br>41<br>42<br>43<br>44<br>**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>25<br>V.A.T. reclaimable from C&E on expenditure<br>45<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br>Sum 10 to 17 plus 19+21+24<br> Total value of Purchases (excl. VAT)<br>Sum 30 to 41 plus 44<br>**Standard Hour Calculation**<br> Billed' hours this Period<br>Overhead burden<br>Sum 31 to 42<br>622.54<br> **Standard Hour cost**<br>**0.00**<br>Overhead Burden divided by Billed hours|||||44<br>25<br>45|
|||-<br>0.00 <br>**0.00** <br>0.00 <br>57.95<br>500.00<br>1403.94||||||||
|||-<br>1403.94<br>**-845.99** <br>3815.36<br>0.00 <br>517.50||||||||
|||||||||||
||||||||||622.54<br>**0.00**|
|||-<br>517.50<br>**3297.86**<br>**4143.85**||Note 1<br>Errors can occur in spreadsheets. Always<br>check the results before acting on them.<br>Note 2<br>The Trading Reports on this page are for<br>guidance only. More information is needed<br>for a full Profit & Loss Account and a full<br>Balance Sheet.||||||





V.A.T. 0.00 25 V.A.T. 0.00 45 0.00 0.00 **0.00** 5596.25 1526.27 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||_Ana_||_lysis of income_||||
||||_Paid to:-_<br>_r_||_ading Income_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|5|Parentpay||108.81||||65.48||
|5|Roberts recycling||27.00||||0.00||
|6|Rebecca Watkins||3.50||||3.50||
|11|Banked Cash||14.00||||14.00||
|12|Parentpay||357.44||||317.07||
|12|Sumup||100.27||||||
|13|Sumup||137.65||||||
|14|Doxdirect||43.33||||||
|15|Banked Cash||353.30||||||
|15|Sumup||204.43||||||
|19|Parentpay||11.82||||||
|19|Sumup||155.30||||||
|19|Banked Cash||229.40||||||
|19|Sumup||60.96||||||
|20|Sumup||112.06||||||
|21|Banked Cash||148.00||||||
|21|Emma Williams||1.83||||||
|21|Sumup||94.41||||||
|22|Banked Cash||116.00||||||
|22|Sumup||88.46||||||
|25|Banked Cash||227.80||||||
|25|Sumup||209.64||||||
|26|Parentpay||34.91||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||2840.32|0.00|0.00|0.00|400.05|0.00|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>2840.32<br>2840.32<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|||REF|CASH|CHEQUE|SPONSORED|FATHERS|MOTHERS|ELFRIDGES|





|DAY|DETAILS|No.|A/C|A/C|EVENT|DAY|DAY|SANTA VISIT|
|---|---|---|---|---|---|---|---|---|
|6|Ikea||50.00||||50.00||
|11|Asda||6.60||||||
|11|Chepstow Garden Centre||7.45||||7.45||
|11|Morris of Usk||195.00||||195.00||
|11|Tesco||12.50||||||
|12|postage||8.19||||||
|12|Tesco||30.30||||||
|12|Corrina Lewis||8.56||||8.56||
|12|Jenine Hughes||39.99||||||
|12|Ceri Campion||6.99||||||
|13|Bookers||244.75||||||
|13|Cutprice Wholesales||655.04|||||655.04|
|14|Emma J Williams||12.70||||||
|18|Bookers||466.02||||||
|18|Home Bargains||2.58||||||
|20|Emma J Williams||13.05||||||
|21|UndyPrimarySchool||5000.00||||||
|27|RubyMcLeod||135.00||||||
|27|Parentpay||3.50||||3.50||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||6898.22|0.00|0.00|0.00|264.51|655.04|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>6898.22<br>6898.22<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

## September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|10830.18|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|2840.32|0.00||0.00|0.00|400.05|0.00|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||





|**EXPENDITURE**<br>**CLOSING BALANCE**<br>Opening Balance for next month<br>**MOVEMENT**<br>**Trading Report**<br>Trading Income<br>Sum 1<br>Direct Costs<br>3<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>1<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>Sum 3<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>4||||||||
|---|---|---|---|---|---|---|---|
|||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|||6898.22|0.00|0.00|0.00|264.51|655.04|
|||1b<br>6772.28|2b<br><br>0.00|||32<br>33<br>**Changes to Balance**||
|||||||<br>**Assets:**<br>Capital equipment aqu<br>LESS:<br>Depreciatio<br>Capital equ<br>**Change in**<br>**Liabilities:**<br>VAT due to Customs &<br>New Outside loans<br>New Personal loans<br>LESS:<br>Loan repay<br>**Change in**<br>**Accounts:**<br>Movement in Cash acc<br>Movement in Bank acc<br>LESS:<br>Grants for<br>**Change in**<br>**_Change in Nett worth_**<br>Assets minus Liabilities plus change i||



## **Changes to Balance S Assets:** 

Capital equipment aqu LESS: Depreciatio Capital equ 

## **Change in** 

VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay 

## **Change in** 

Movement in Cash acc Movement in Bank acc LESS: Grants for c 

## **Change in** 

Assets minus Liabilities plus change in 



_Month Name: March-24_ 

|||||||||Other I|Other I|
|---|---|---|---|---|---|---|---|---|---|
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS||OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|||38.40|||4.93|||||
|||||||27||||
|||||||||||
|||||||||||
|||20.68|||19.69|||||
|||100.27||||||||
|||137.65||||||||
|||43.33||||||||
|||353.30||||||||
|||204.43||||||||
|||11.82||||||||
|||155.30||||||||
|||229.40||||||||
|||60.96||||||||
|||112.06||||||||
|||148.00||||||||
|||1.83||||||||
|||94.41||||||||
|||116.00||||||||
|||88.46||||||||
|||227.80||||||||
|||209.64||||||||
|||32.50|||2.41|||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|||||||||||
|0.00|0.00|2386.24|0.00||27.03|27.00|0.00|0.00|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22||||||||||



_Month Name: March-24 Analysis of payments Direct Costs Indirect costs (Overheads)_ XMAS DISCOS WONKA SUMMER OWN RECYCLING CAULIFLOWER MEMBER OTHER 



|FETE|||CIRCUS|CLOTHES DAY||CARDS|SHIPS|EXP'S|
|---|---|---|---|---|---|---|---|---|
||||||||||
|||6.60|||||||
||||||||||
||||||||||
|||12.50|||||||
|||||||||8.19|
|||30.30|||||||
||||||||||
|||||||||39.99|
|||||||||6.99|
|||244.75|||||||
||||||||||
|||12.70|||||||
|||466.02|||||||
|||2.58|||||||
|||13.05|||||||
||||||||||
|||135.00|||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|923.50|0.00|0.00|0.00|0.00|0.00|55.17|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_March-24_|_March-24_|_March-24_|_March-24_|_March-24_|_March-24_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis of income_|||||||||
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|2386.24|0.00|27.03|27.00|0.00|0.00|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||





|_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>0.00<br>923.50<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>5000.00<br>-<br>5000.00<br>**Liabilities**<br>**-5000.00** <br>count<br>1c<br>-4057.90<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-4057.90**<br>**_h_**<br>**942.10**<br>n Accounts|_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>0.00<br>923.50<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>5000.00<br>-<br>5000.00<br>**Liabilities**<br>**-5000.00** <br>count<br>1c<br>-4057.90<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-4057.90**<br>**_h_**<br>**942.10**<br>n Accounts|_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>0.00<br>923.50<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>5000.00<br>-<br>5000.00<br>**Liabilities**<br>**-5000.00** <br>count<br>1c<br>-4057.90<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-4057.90**<br>**_h_**<br>**942.10**<br>n Accounts|_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>0.00<br>923.50<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>5000.00<br>-<br>5000.00<br>**Liabilities**<br>**-5000.00** <br>count<br>1c<br>-4057.90<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-4057.90**<br>**_h_**<br>**942.10**<br>n Accounts|_Direct Costs_<br>XMAS<br>DISCOS<br>WONKA<br>SUMMER<br>OWN<br>FETE<br>CIRCUS<br>CLOTHES DAY<br>0.00<br>0.00<br>923.50<br>0.00<br>0.00<br>34<br>35<br>36<br>37<br>38<br>**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>5000.00<br>-<br>5000.00<br>**Liabilities**<br>**-5000.00** <br>count<br>1c<br>-4057.90<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-4057.90**<br>**_h_**<br>**942.10**<br>n Accounts|||_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_||
|---|---|---|---|---|---|---|---|---|---|
||DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S||
||0.00|923.50|0.00|0.00|0.00|0.00|0.00|55.17||
||||||39<br>40<br>41<br>42<br>**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|||||
||||-<br>0.00 <br>**0.00** <br>0.00 <br>0.00<br>0.00<br>5000.00|||||||
||||-<br>5000.00<br>**-5000.00** <br>-4057.90<br>0.00 <br>0.00|||||||
||||-<br>0.00<br>**-4057.90**<br>**942.10**||Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account an<br>Balance Sheet.|||||





_Month No._ 

7 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|0.00|0.00|0.00|
|23<br>24<br>25|||



_Month No._ 7 UPS CAPITAL V.A.T. 



|DONATIONS|EXPEND||
|---|---|---|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|5000.00|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|5000.00|0.00|0.00|
|43<br>44<br>45|||



|_Month No._|_Month No._|7|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|0.00|0.00|0.00|
|23<br>24<br>25|||
||||





||||
|---|---|---|
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|5000.00|0.00|0.00|
|43<br>44<br>45<br>25<br>0.00<br>45<br>0.00<br>**0.00**<br>Sum 10 to 17 plus 21+24<br>2786.29<br>Sum 30 to 41 plus 44<br>1843.05|44<br>45<br>25<br>0.00<br>45<br>0.00||



1898.22 **0.00** Always them. are for s needed d a full 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||_Ana_||_lysis of income_||||
||||_Paid to:-_<br>_r_||_ading Income_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|3|Parentpay||102.42||||||
|9|Parentpay||4.93||||0.00||
|12|Cutprice wholesales||14.08|||||14.08|
|23|Parentpay||9.85||||||
|30|Parentpay||562.29||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||693.57|0.00|0.00|0.00|0.00|14.08|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>693.57<br>693.57<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|





|2|Emma Horton||27.28||||||
|---|---|---|---|---|---|---|---|---|
|8|Full of bounce||60.00||||||
|17|Amazon||6.78||||||
|18|Amy King||42.00|||21.00|||
|22|Emma Williams||5.53||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||141.59|0.00|0.00|21.00|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>141.59<br>141.59<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|6772.28|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|693.57|0.00||0.00|0.00|0.00|14.08|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|141.59|0.00||0.00|21.00|0.00|0.00|
|1b<br>7324.26|2b<br>0.00||30<br>31<br>32<br>33||||





|Opening Balance for next month<br>**MOVEMENT**<br>551.98<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>673.86<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**673.86**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>0.00<br>R/Grants & Other Income<br>19.71<br>18+21<br>19.71<br>**Total Income**<br>**693.57**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>129.28<br>Depreciation<br>Calculate elsewhere or leave at 0<br>129.28<br>**_Profit (Loss) for the month_**<br>**564.29**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>12.31<br>**551.98**|Opening Balance for next month<br>**MOVEMENT**<br>551.98<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>673.86<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**673.86**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>0.00<br>R/Grants & Other Income<br>19.71<br>18+21<br>19.71<br>**Total Income**<br>**693.57**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>129.28<br>Depreciation<br>Calculate elsewhere or leave at 0<br>129.28<br>**_Profit (Loss) for the month_**<br>**564.29**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>12.31<br>**551.98**|Opening Balance for next month<br>**MOVEMENT**<br>551.98<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>673.86<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**673.86**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>0.00<br>R/Grants & Other Income<br>19.71<br>18+21<br>19.71<br>**Total Income**<br>**693.57**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>129.28<br>Depreciation<br>Calculate elsewhere or leave at 0<br>129.28<br>**_Profit (Loss) for the month_**<br>**564.29**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>12.31<br>**551.98**|
|---|---|---|
||**673.86**<br>0.00<br>19.71||
||19.71<br>**693.57**<br>129.28|19.71|
|||**693.57**|
||||
||129.28<br>**564.29**<br>12.31||
||**551.98**||



**Changes to Balance S Assets:** Capital equipment aqu LESS: Depreciatio Capital equ **Change in Liabilities:** VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay **Change in Accounts:** Movement in Cash acc Movement in Bank acc LESS: Grants for c **Change in** _**Change in Nett worth**_ 

Assets minus Liabilities plus change in 



_Month Name: April-24_ 

||||||||Other I|Other I|
|---|---|---|---|---|---|---|---|---|
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING||GRANTS|DONATIONS<br>REC'V'D|
|||97.49||4.93|||||
|||||4.93|||||
||||||||||
|||||9.85|||||
|||2.96|559.33||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|100.45|559.33|19.71|0.00|0.00|0.00|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_April_|_April_|_April_|_April_|_April_|_April_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING||MEMBER<br>SHIPS|OTHER<br>EXP'S|





|||27.28|||||||
|---|---|---|---|---|---|---|---|---|
||||60.00||||||
|||||||||6.78|
||||21.00||||||
|||||||||5.53|
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|27.28|81.00|0.00|0.00|0.00|0.00|12.31|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



_Month Name: April-24_ 

|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|100.45|559.33|19.71|0.00|0|0|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|0.00|0.00|27.28|81.00|0.00|0.00|0.00|0.00|12.31|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||





## **Sheet** 

## **Value Added Tax** 

|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**0.00** <br>count<br>1c<br>551.98<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**551.98**<br>**_h_**<br>**551.98**<br>n Accounts|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>0.00<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**0.00** <br>count<br>1c<br>551.98<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**551.98**<br>**_h_**<br>**551.98**<br>n Accounts|V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>0.00<br>0.00<br>0.00||
||-<br>0.00<br>**0.00** <br>551.98<br>0.00 <br>0.00||
||-<br>0.00<br>**551.98**<br>**551.98**||



## _**h**_ 



_Month No._ 

8 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|0.00|0.00|0.00|
|23<br>24<br>25|||



|_Month No._|_Month No._|8|
|---|---|---|
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|





0.00 0.00 0.00 43 44 45 

|_Month No._|_Month No._|8|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|0.00|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|
|43<br>44<br>45|||





||||||25|0.00|
|---|---|---|---|---|---|---|
||||||45|0.00|
|||||||**0.00**|
|Sum|10|to|17|plus|21+24|673.86|
|Sum|30|to|41|plus|44|129.28|



141.59 **0.00** 

Always them. are for s needed d a full 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|8|Parentpay||756.26||||||
|8|Your School Lottery||2.80||||0.00||
|14|Parentpay||947.30||||||
|20|S Freeman||16.00||||||
|21|Parentpay||4.93||||||
|21|Clients Deposit||6.00||||||
|22|Roberts Recycling||36.59||||||
|23|Easyfundraising||68.41||||||
|28|Banked cash||32.00||||||
|28|Banked cash||139.92||||||
|29|D Holder||16.00||||||
|29|Ready, steady,go||294.00||||||
|30|Parentpay||96.51|||96.51|||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||2416.72|0.00|0.00|96.51|0.00|0.00|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>2416.72<br>2416.72<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|





|2|Mrs R Patching-Jones||270.00||||||
|---|---|---|---|---|---|---|---|---|
|2|Magor Printing||440.00||||||
|7|Outdoor Root||50.00||||||
|13|Booker||234.96|||77.04|||
|15|Amazon||6.99||||||
|15|Holland & Barrett||14.25||||||
|30|Temu||19.15||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||1035.35|0.00|0.00|77.04|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>1035.35<br>1035.35<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|7324.26|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|2416.72|0.00||0.00|96.51|0.00|0.00|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|1035.35|0.00||0.00|77.04|0.00|0.00|
|1b<br>8705.63|2b<br>0.00||30<br>31<br>32<br>33||||





|Opening Balance for next month<br>**MOVEMENT**<br>1381.37<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2148.22<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**2148.22**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>36.59<br>R/Grants & Other Income<br>14.78<br>18+21<br>51.37<br>**Total Income**<br>**2199.59**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>856.19<br>Depreciation<br>Calculate elsewhere or leave at 0<br>856.19<br>**_Profit (Loss) for the month_**<br>**1343.40**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>179.16<br>**1164.24**|Opening Balance for next month<br>**MOVEMENT**<br>1381.37<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2148.22<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**2148.22**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>36.59<br>R/Grants & Other Income<br>14.78<br>18+21<br>51.37<br>**Total Income**<br>**2199.59**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>856.19<br>Depreciation<br>Calculate elsewhere or leave at 0<br>856.19<br>**_Profit (Loss) for the month_**<br>**1343.40**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>179.16<br>**1164.24**|Opening Balance for next month<br>**MOVEMENT**<br>1381.37<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2148.22<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**2148.22**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>36.59<br>R/Grants & Other Income<br>14.78<br>18+21<br>51.37<br>**Total Income**<br>**2199.59**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>856.19<br>Depreciation<br>Calculate elsewhere or leave at 0<br>856.19<br>**_Profit (Loss) for the month_**<br>**1343.40**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>179.16<br>**1164.24**|
|---|---|---|
||**2148.22**<br>36.59<br>14.78||
||51.37<br>**2199.59**<br>856.19|51.37|
|||**2199.59**|
||||
||856.19<br>**1343.40**<br>179.16||
||**1164.24**||



**Changes to Balance S Assets:** Capital equipment aqu LESS: Depreciatio Capital equ **Change in Liabilities:** VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay **Change in Accounts:** Movement in Cash acc Movement in Bank acc LESS: Grants for c **Change in** _**Change in Nett worth**_ 

Assets minus Liabilities plus change in 



_Month Name: May-24_ 

_Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
||||756.26||||||
||||||||||
||||937.45|9.85|||||
||||16.00||||||
|||||4.93|||||
||||||||||
||||||36.59||||
||||||||||
||||32.00||||||
||||||||||
||||16.00||||||
||||294.00||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|2051.71|14.78|36.59|0.00|0.00|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_May-24_|_May-24_|_May-24_|_May-24_|_May-24_|_May-24_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|





||||270.00||||||
|---|---|---|---|---|---|---|---|---|
|||390.00|50.00||||||
||||50.00||||||
|||||||||157.92|
|||||||||6.99|
|||||||||14.25|
||||19.15||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|390.00|389.15|0.00|0.00|0.00|0.00|179.16|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



_Month Name: May-24_ 

|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|0.00|2051.71|14.78|36.59|0|0|0.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|0.00|0.00|390.00|389.15|0.00|0.00|0.00|0.00|179.16|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||





## **Sheet** 

## **Value Added Tax** 

|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>217.13<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**217.13** <br>count<br>1c<br>1381.37<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**1381.37**<br>**_h_**<br>**1164.24**<br>n Accounts|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>217.13<br>22<br>0.00<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**217.13** <br>count<br>1c<br>1381.37<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**1381.37**<br>**_h_**<br>**1164.24**<br>n Accounts|V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>217.13<br>0.00<br>0.00||
||-<br>0.00<br>**217.13** <br>1381.37<br>0.00 <br>0.00||
||-<br>0.00<br>**1381.37**<br>**1164.24**||



## _**h**_ 



_Month No._ 

9 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
|2.80|||
||||
||||
||||
|6.00|||
||||
|68.41|||
||||
|139.92|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|217.13|0.00|0.00|
|23<br>24<br>25|||



|_Month No._|_Month No._|9|
|---|---|---|
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|





||||
|---|---|---|
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|0.00|0.00|0.00|
|43<br>44<br>45|||



|_Month No._|_Month No._|9|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|217.13|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|
|43<br>44<br>45|||





||||||25|0.00|
|---|---|---|---|---|---|---|
||||||45|0.00|
|||||||**0.00**|
|Sum|10|to|17|plus|21+24|2148.22|
|Sum|30|to|41|plus|44|856.19|



1035.35 **0.00** 

Always them. are for s needed d a full 



## **3rd QUATER TRADING SUMMARY** 

## September 2023 - August 2024 

|**_---------Accounts-----------_**<br>CASH<br>CHEQUE<br>A/C<br>A/C<br>**OPENING BALANCE**<br>10830.18<br>0.00<br>SPONSORED<br>FATHERS<br>Closing Balance last Year<br>EVENT<br>DAY<br>**INCOME**<br>5950.61<br>0.00<br>0.00<br>96.51<br>1a<br>2a<br>10<br>11<br>SPONSORED<br>FATHERS<br>EVENT<br>DAY<br>**EXPENDITURE**<br>8075.16<br>0.00<br>0.00<br>98.04<br>1b<br>2b<br>30<br>31<br>**CLOSING BALANCE**<br>8705.63<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>-2124.55<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>5608.37<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**5608.37**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>63.59<br>R/Grants & Other Income<br>61.52<br>18+21<br>125.11<br>**Total Income**<br>**5733.48**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>2828.52<br>Depreciation<br>Calculate elsewhere or leave at 0<br>2828.52<br>**_Profit (Loss) for the Period_**<br>**2904.96**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>246.64<br>**2658.32**||||||||
|---|---|---|---|---|---|---|---|
||CASH<br>A/C|CHEQUE<br>A/C|||_Trading Income_|||
||10830.18|0.00|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|
|||||||||
||5950.61|0.00|0.00|96.51|400.05|14.08|0.00|
||1a|2a|10<br>11||12<br>13<br>14|||
|||||||||
||||||_Direct_|||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|
||8075.16|0.00|0.00|98.04|264.51|655.04|0.00|
||1b<br>8705.63|2b<br>0.00|30<br>31||32<br>33<br>34|||
||||||**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>LESS:<br>Depreciation on asset<br>Capital equipment sol<br>**Change in Assets**<br>**Liabilities:**<br>VAT due to Customs & Excise<br>New Outside loans<br>New Personal loans<br>LESS:<br>Loan repaym'ts (ex.In<br>**Change in Liabilities**<br>**Accounts:**<br>Movement in Cash account<br>Movement in Bank account<br>LESS:<br>Grants for capital equ<br>**Change in Accounts**<br>**_Change in Nett worth_**<br>Assets minus Liabilities plus change in Accounts|||



Assets minus Liabilities plus change in Accounts 



_**Totals from Months 7, 8 and 9**_ 

_Year_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|Other Income|Other Income|Other Income|Other Income|Other Income|Other Income|
|---|---|---|---|---|---|---|---|---|---|
|||||||||||
|DISCOS|WONKA|SUMMER<br>CIRCUS<br>|OWN<br>CLOTHES DAY|RECYCLING <br>|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|
|0.00|2486.69|2611.04|61.52|63.59|0|0|0.00|217.13|0.00|
|15<br>16<br>17<br>18||||19<br>20<br>21<br>22<br>23<br>24||||||
|_Analysis ofpayments_||||_Indirect costs_<br>_(Overheads)_||||||
|_Costs_||||||_Indirect costs_<br>_(Overheads)_||||
|DISCOS|WONKA|SUMMER<br>CIRCUS<br>|OWN<br>CLOTHES DAY|RECYCLING <br>|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|
|0.00|1340.78|470.15|0.00|0.00|0.00|0.00|246.64|5000.00|0.00|
|35<br>36<br>37<br>38<br>44<br>0.00 <br>ts<br>as Trading Repor<br>0.00<br>ld<br>24<br>0.00<br>-<br>0.00 <br>**0.00** <br>25 minus 45<br>0.00 <br>23<br>217.13<br>22<br>0.00<br>ntr'st)<br>43<br>5000.00<br>-<br>5000.00<br>**s**<br>**-4782.87** <br>1c<br>-2124.55<br>2c<br>0.00 <br>uip.<br>20<br>0.00<br>-<br>0.00<br>**s**<br>**-2124.55**<br>**2658.32**||||39<br>40<br>41<br>42<br>43<br>44<br>**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>25<br>V.A.T. reclaimable from C&E on expenditure<br>45<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br>Sum 10 to 17 plus 21+24<br> Total value of Purchases (excl. VAT)<br>Sum 30 to 41 plus 44<br>**Standard Hour Calculation**<br> Billed' hours this Period<br>Overhead burden<br>Sum 31 to 42<br>3075.16<br> **Standard Hour cost**<br>**0.00**<br>Overhead Burden divided by Billed hours|||||44<br>25<br>45|
|||-<br>0.00 <br>**0.00** <br>0.00 <br>217.13<br>0.00<br>5000.00||||||||
|||-<br>5000.00<br>**-4782.87** <br>-2124.55<br>0.00 <br>0.00||||||||
|||||||||||
||||||||||3075.16<br>**0.00**|
|||-<br>0.00<br>**-2124.55**<br>**2658.32**||Note 1<br>Errors can occur in spreadsheets. Always<br>check the results before acting on them.<br>Note 2<br>The Trading Reports on this page are for<br>guidance only. More information is needed<br>for a full Profit & Loss Account and a full<br>Balance Sheet.||||||





V.A.T. 0.00 25 V.A.T. 0.00 45 0.00 0.00 **0.00** 5608.37 2828.52 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|4|Parentpay||102.91|||93.06|||
|4|Your School Lottery||43.60||||0.00||
|5|Banked Cash||276.34||||||
|5|Sum Up||11.80||||||
|6|Banked Cash||339.70||||||
|6|Emma Williams||56.00||||||
|7|Banked Cash||272.00||||||
|7|Banked Cash||26.36||||||
|10|Temu||9.59||||||
|10|Ready, Steady, Go||14.00||||||
|11|Parentpay||117.18|||117.18|||
|11|Sum Up||11.80||||||
|12|Sum Up||5.90||||||
|13|Your School Lottery||1.67||||||
|13|Sum Up||5.90||||||
|14|Sum Up||67.85||||||
|17|Sum Up||11.80||||||
|18|Parentpay||172.33|||172.33|||
|18|Sum Up||29.50||||||
|20|Sum Up||267.40||||||
|21|Banked Cash||72.80||||||
|21|Banked Cash||228.50|||3.50|||
|25|Amy King||100.00||||||
|25|Your School Lottery||8.70||||||
|26|The Welsh Italian Pizza Co||40.00||||||
|26|Sum Up||17.70||||||
|27|Sum Up||31.46||||||
|27|The TipsyTrailer||40.00||||||
|28|Banked Cash||136.00||||||
|28|Sum Up||5.90||||||
||||||||||
||||||||||
|**TOTALS**|||2524.69|0.00|0.00|386.07|0.00|0.00|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>2524.69<br>2524.69<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||





||||||||||
|---|---|---|---|---|---|---|---|---|
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|4|Wristbands||186.96||||||
|10|Books for bugs||124.74|||||124.74|
|11|Amazon||17.99||||||
|14|Booker||35.36|||14.49|||
|17|Iceland||45.30||||||
|19|Tesco||2.44|||2.44|||
|19|Tesco||21.80|||21.80|||
|21|Cash||50.00||||||
|24|Buyology||12.90||||||
|25|Little TopEntertainment||1999.99||||||
|26|Gemma Polak||200.00||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||2697.48|0.00|0.00|38.73|0.00|124.74|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>2697.48<br>2697.48<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|8705.63|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|2524.69|0.00||0.00|386.07|0.00|0.00|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|





|**EXPENDITURE**<br>**CLOSING BALANCE**<br>Opening Balance for next month<br>**MOVEMENT**<br>**Trading Report**<br>Trading Income<br>Sum 1<br>Direct Costs<br>3<br>**Gross Profit**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>1<br>R/Grants & Other Income<br>18+21<br>**Total Income**<br>Gross Profit + Other Income<br>Overheads<br>Sum 3<br>Depreciation<br>Calculate elsewhere or leave at 0<br>**_Profit (Loss) for the month_**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>4||2697.48|0.00|0.00|38.73|0.00|124.74|
|---|---|---|---|---|---|---|---|
|||1b<br>8532.84|2b<br><br>0.00|||||



Assets minus Liabilities plus change in 



_Month Name: June-24_ 

_Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|---|
|_Income_||||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS||OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
||||||9.85|||||
|||||||||||
|||||||||||
||||11.80|||||||
|||||||||||
||||56.00|||||||
||||272.00|||||||
|||||||||||
||||9.59|||||||
||||14.00|||||||
|||||||||||
||||11.80|||||||
||||5.90|||||||
|||||||||||
||||5.90|||||||
||||67.85|||||||
||||11.80|||||||
|||||||||||
||||29.50|||||||
||||267.40|||||||
||||72.80|||||||
||||225.00|||||||
||||||||||100.00|
|||||||||||
||||40.00|||||||
||||17.70|||||||
||||31.46|||||||
||||40.00|||||||
||||136.00|||||||
||||5.90|||||||
|||||||||||
|||||||||||
|0.00|0.00|0.00|1332.40||9.85|0.00|0.00|0.00|100.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22||||||||||



_Month Name: June-24_ 

_Analysis of payments_ 

_Direct Costs_ 

_Indirect costs_ 



||||||||_(Overheads)_|_(Overheads)_|
|---|---|---|---|---|---|---|---|---|
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|||||||||186.96|
||||||||||
|||||||||17.99|
||||14.98||||||
|||||||||45.30|
||||||||||
||||||||||
||||50.00||||||
||||12.90||||||
||||1999.99||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|2077.87|0.00|0.00|0.00|0.00|250.25|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_June-24_|_June-24_|_June-24_|_June-24_|_June-24_|_June-24_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis of income_|||||||||
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|0.00|1332.40|9.85|0.00|0.00|0.00|100.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|





||0.00|0.00|0.00|2077.87|0.00|0.00|0.00|0.00|250.25||
|---|---|---|---|---|---|---|---|---|---|---|
|||||||39<br>40<br>41<br>42<br>**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|||||
|||||-<br>0.00 <br>**0.00** <br>-5.89 <br>696.37<br>100.00<br>200.00|||||||
|||||-<br>200.00<br>**590.48** <br>-172.79<br>0.00 <br>0.00|||||||
|||||-<br>0.00<br>**-172.79**<br>**-763.27**|||||||





_Month No._ 

10 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
|43.60|||
|276.34|||
||||
|339.70|||
||||
||||
|26.36|||
||||
||||
||||
||||
||||
|1.67|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|8.70|||
||||
||||
||||
||||
||||
||||
||||
||||
|696.37|0.00|0.00|
|23<br>24<br>25|||



_Month No._ 10 



||||
|---|---|---|
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
||||
||||
||||
|||5.89|
||||
||||
||||
||||
||||
||||
|200.00|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|200.00|0.00|5.89|
|43<br>44<br>45|||



|_Month No._|_Month No._|10|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|696.37|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|





|200.00|0.00|5.89|
|---|---|---|
|43<br>44<br>45<br>25<br>0.00<br>45<br>5.89<br>**-5.89**<br>Sum 10 to 17 plus 21+24<br>1718.47<br>Sum 30 to 41 plus 44<br>2241.34|44<br>45<br>25<br>0.00<br>45<br>5.89||



2491.59 **0.00** Always them. are for s needed d a full 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|1|J A Mason||24.00||||||
|1|Stephs Snack Shop||40.00||||0.00||
|1|Otium Concierge||300.00||||||
|1|Sum Up||17.70||||||
|2|Your School Lottery||45.60||||||
|2|Sum Up||11.80||||||
|2|Castle Farm||40.00||||||
|3|Sum Up||88.49||||||
|4|Ready, Steady, Go||28.00||||||
|4|Sum Up||41.29||||||
|4|Corrina Lewis||6.00||||||
|5|Kate Coleman||500.00||||||
|5|Banked Cash||56.00||||||
|5|Banked Cash||224.00||||||
|5|Banked Cash||152.00||||||
|5|Banked Cash||240.60||||||
|5|FelicityHusband||24.00||||||
|5|Sum Up||69.80||||||
|8|Banked Cash||822.17||||||
|8|Sum Up||403.97||||||
|10|Banked Cash||50.00||||||
|12|Emma Williams||5.00||||||
|16|Your School Lottery||8.10||||||
|16|Banked Cash||423.15||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||3621.67|0.00|0.00|0.00|0.00|0.00|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>3621.67<br>3621.67<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|||REF|CASH|CHEQUE|SPONSORED|FATHERS|MOTHERS|ELFRIDGES|





|DAY|DETAILS|No.|A/C|A/C|EVENT|DAY|DAY|SANTA VISIT|
|---|---|---|---|---|---|---|---|---|
|1|Full of bounce||230.00||||||
|4|Iceland||77.80||||||
|8|Remake Newport||14.35||||||
|6|Hillcroft Garage||6.42||||||
|16|UndyPrimarySchool||8700.00||||||
|19|UndyPrimarySchool||1400.00||||||
|19|Asda||13.50||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||10442.07|0.00|0.00|0.00|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33|||||||||



Checksum 

10442.07 10442.07 1b plus 2b Sum 30 to 45 

## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|8532.84|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|3621.67|0.00||0.00|0.00|0.00|0.00|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|10442.07|0.00||0.00|0.00|0.00|0.00|
|1b|2|b|30<br>31<br>32<br>33||||





|**CLOSING BALANCE**<br>1712.44<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>-6820.40<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2339.82<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**2339.82**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>0.00<br>R/Grants & Other Income<br>0.00<br>18+21<br>0.00<br>**Total Income**<br>**2339.82**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>250.77<br>Depreciation<br>Calculate elsewhere or leave at 0<br>250.77<br>**_Profit (Loss) for the month_**<br>**2089.05**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>91.30<br>**1997.75**|**CLOSING BALANCE**<br>1712.44<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>-6820.40<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2339.82<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**2339.82**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>0.00<br>R/Grants & Other Income<br>0.00<br>18+21<br>0.00<br>**Total Income**<br>**2339.82**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>250.77<br>Depreciation<br>Calculate elsewhere or leave at 0<br>250.77<br>**_Profit (Loss) for the month_**<br>**2089.05**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>91.30<br>**1997.75**|**CLOSING BALANCE**<br>1712.44<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>-6820.40<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>2339.82<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**2339.82**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>0.00<br>R/Grants & Other Income<br>0.00<br>18+21<br>0.00<br>**Total Income**<br>**2339.82**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>250.77<br>Depreciation<br>Calculate elsewhere or leave at 0<br>250.77<br>**_Profit (Loss) for the month_**<br>**2089.05**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>91.30<br>**1997.75**|
|---|---|---|
||**2339.82**<br>0.00<br>0.00||
||0.00<br>**2339.82**<br>250.77|0.00|
|||**2339.82**|
||||
||250.77<br>**2089.05**<br>91.30||
||**1997.75**||



**Changes to Balance S Assets:** Capital equipment aqu LESS: Depreciatio Capital equ **Change in Liabilities:** VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay **Change in Accounts:** Movement in Cash acc Movement in Bank acc LESS: Grants for c **Change in** _**Change in Nett worth**_ 

Assets minus Liabilities plus change in 



_Month Name: July-24 Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
||||24.00||||||
||||40.00||||||
|||||||||300.00|
||||17.70||||||
||||||||||
||||11.80||||||
||||40.00||||||
||||88.49||||||
||||28.00||||||
||||41.29||||||
||||6.00||||||
|||||||||500.00|
||||56.00||||||
||||224.00||||||
||||152.00||||||
||||240.60||||||
||||24.00||||||
||||69.80||||||
||||822.17||||||
||||403.97||||||
||||50.00||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|2339.82|0.00|0.00|0.00|0.00|800.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_July-24_|_July-24_|_July-24_|_July-24_|_July-24_|_July-24_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS|DISCOS|WONKA|SUMMER|OWN|RECYCLING|CAULIFLOWER|MEMBER|OTHER|





|FETE|||CIRCUS|CLOTHES DAY||CARDS|SHIPS|EXP'S|
|---|---|---|---|---|---|---|---|---|
||||230.00||||||
|||||||||77.80|
||||14.35||||||
||||6.42||||||
||||||||||
||||||||||
|||||||||13.50|
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|250.77|0.00|0.00|0.00|0.00|91.30|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



_Month Name: July-24_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|0.00|2339.82|0|0.00|0|0|800.00|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|0.00|0.00|0.00|250.77|0.00|0.00|0.00|0.00|91.30|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||





|**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>481.85<br>22<br>800.00<br>ym'ts (ex.Intr'st)<br>43<br>10100.00<br>-<br>10100.00<br>**Liabilities**<br>**-8818.15** <br>count<br>1c<br>-6820.40<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-6820.40**<br>**_h_**<br>**1997.75**<br>n Accounts|**Sheet**<br>uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>481.85<br>22<br>800.00<br>ym'ts (ex.Intr'st)<br>43<br>10100.00<br>-<br>10100.00<br>**Liabilities**<br>**-8818.15** <br>count<br>1c<br>-6820.40<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**-6820.40**<br>**_h_**<br>**1997.75**<br>n Accounts|**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>481.85<br>800.00<br>10100.00||
||-<br>10100.00<br>**-8818.15** <br>-6820.40<br>0.00 <br>0.00||
||-<br>0.00<br>**-6820.40**<br>**1997.75**||



## _**h**_ 



_Month No._ 

11 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
||||
||||
|45.60|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|5.00|||
|8.10|||
|423.15|||
||||
||||
||||
||||
||||
||||
|481.85|0.00|0.00|
|23<br>24<br>25|||




**----- Start of picture text -----**<br>
Month No. 11<br>UPS  CAPITAL V.A.T.<br>**----- End of picture text -----**<br>




|DONATIONS|EXPEND||
|---|---|---|
||||
||||
||||
||||
|8700.00|||
|1400.00|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|10100.00|0.00|0.00|
|43<br>44<br>45|||



_Month No._ 11 

|_Month No._|_Month No._|11|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|481.85|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|10100.00|0.00|0.00|
|43<br>44<br>45|||





25 0.00 45 0.00 **0.00** Sum 10 to 17 plus 21+24 2339.82 Sum 30 to 41 plus 44 250.77 

342.07 

**0.00** 

Always them. are for s needed d a full 



September 2023 - August 2024 

## **INCOME** 

|simplestExample.xls|simplestExample.xls|simplestExample.xls|||||||
|---|---|---|---|---|---|---|---|---|
|_Payment from:-_|||||||||
||||_Paid to:-_||_Trading_||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||Credit note||655.04|||||655.04|
||Credit note||124.74|||||124.74|
||Credit note||289.40||||||
|2|Roberts Recycling||20.80||||||
|6|Your School Lottery||52.40||||||
|13|Easyfundraising||32.07||||||
||Groundworks _ Tesco Blue T|oken|352.50||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||1526.95|0.00|0.00|0.00|0.00|779.78|
|Checksum<br>**EXPENDITURE**<br>simplestExample.xls|||1a<br>2a<br>10<br>11<br>12<br>13<br>1526.95<br>1526.95<br>1a plus 2a<br>Sum 10 to 25<br>September 2023 - August 2024||||||
|_Payment details_|||||||||
||||_Paid by:-_||||||
|DAY|DETAILS|REF<br>No.|CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|





|2|Grove Print & Pack||289.40||||||
|---|---|---|---|---|---|---|---|---|
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|**TOTALS**|||289.40|0.00|0.00|0.00|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>Checksum<br>289.4<br>289.40<br>1b plus 2b<br>Sum 30 to 45|||||||||



## **TRADING SUMMARY** 

September 2023 - August 2024 

|**_-----------------_**|**_-----------------_**|**_-----------------_**|||||
|---|---|---|---|---|---|---|
|CASH<br>A/C|CHEQUE<br>A/C||_Trading_||||
|1712.44|||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
||||||||
|1526.95|0.00||0.00|0.00|0.00|779.78|
|1a|2|a|10<br>11<br>12<br>13||||
||||||||
||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|
|289.40|0.00||0.00|0.00|0.00|0.00|
|1b<br>2949.99|2b<br>0.00||30<br>31<br>32<br>33||||





|Opening Balance for next month<br>**MOVEMENT**<br>1237.55<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>779.78<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**779.78**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>20.80<br>R/Grants & Other Income<br>0.00<br>18+21<br>20.80<br>**Total Income**<br>**800.58**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>0<br>Depreciation<br>Calculate elsewhere or leave at 0<br>0.00<br>**_Profit (Loss) for the month_**<br>**800.58**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>289.40<br>**511.18**|Opening Balance for next month<br>**MOVEMENT**<br>1237.55<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>779.78<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**779.78**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>20.80<br>R/Grants & Other Income<br>0.00<br>18+21<br>20.80<br>**Total Income**<br>**800.58**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>0<br>Depreciation<br>Calculate elsewhere or leave at 0<br>0.00<br>**_Profit (Loss) for the month_**<br>**800.58**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>289.40<br>**511.18**|Opening Balance for next month<br>**MOVEMENT**<br>1237.55<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>779.78<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**779.78**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>20.80<br>R/Grants & Other Income<br>0.00<br>18+21<br>20.80<br>**Total Income**<br>**800.58**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>0<br>Depreciation<br>Calculate elsewhere or leave at 0<br>0.00<br>**_Profit (Loss) for the month_**<br>**800.58**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>289.40<br>**511.18**|
|---|---|---|
||**779.78**<br>20.80<br>0.00||
||20.80<br>**800.58**<br>0|20.80|
|||**800.58**|
||||
||0.00<br>**800.58**<br>289.40||
||**511.18**||



**Changes to Balance S Assets:** Capital equipment aqu LESS: Depreciatio Capital equ **Change in Liabilities:** VAT due to Customs & New Outside loans New Personal loans LESS: Loan repay **Change in Accounts:** Movement in Cash acc Movement in Bank acc LESS: Grants for c **Change in** _**Change in Nett worth**_ 

Assets minus Liabilities plus change in 



_Month Name: August-24_ 

_Analysis of income_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|||
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||Other I||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
||||||||||
||||||||||
||||||||||
||||||20.8||||
||||||||||
||||||||||
|||||||||352.50|
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|0.00|0.00|20.80|0.00|0.00|352.50|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||



|_Month Name:_|_Month Name:_|_Month Name:_|_August-24_|_August-24_|_August-24_|_August-24_|_August-24_|_August-24_|
|---|---|---|---|---|---|---|---|---|
||||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|





|||||||||289.40|
|---|---|---|---|---|---|---|---|---|
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
||||||||||
|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|289.40|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||



_Month Name: August-24_ 

|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|_Analysis of income_<br>_Income_<br>Other I|
|---|---|---|---|---|---|---|---|---|
|_Income_|||||||||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|
|0.00|0.00|0.00|0.00|0|20.80|0|0|352.50|
|14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22|||||||||
|_Analysis ofpayments_|||||||||
|_Direct Costs_|||||||_Indirect costs_<br>_(Overheads)_||
|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|
|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|289.40|
|34<br>35<br>36<br>37<br>38<br>39<br>40<br>41<br>42|||||||||





## **Sheet** 

## **Value Added Tax** 

|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>373.87<br>22<br>352.50<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**726.37** <br>count<br>1c<br>1237.55<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**1237.55**<br>**_h_**<br>**511.18**<br>n Accounts|uired<br>44<br>0.00 <br>on on assets<br>as Trading Report<br>0.00<br>uipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Assets**<br>**0.00** <br>& Excise<br>25 minus 45<br>0.00 <br>23<br>373.87<br>22<br>352.50<br>ym'ts (ex.Intr'st)<br>43<br>0.00<br>-<br>0.00<br>**Liabilities**<br>**726.37** <br>count<br>1c<br>1237.55<br>count<br>2c<br>0.00 <br>capital equip.<br>20<br>0.00<br>-<br>0.00<br>**Accounts**<br>**1237.55**<br>**_h_**<br>**511.18**<br>n Accounts|V.A.T. due to Customs & Excise on sales<br>V.A.T. reclaimable from C&E on expenditure<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br> Total value of Purchases (excl. VAT)<br>**Standard Hour Calculation**<br> 'Billed' hours this month<br>Overhead burden<br>Sum 31 to 42<br> **Standard Hour cost**<br>Overhead Burden divided by Billed hours<br>Note 1<br>Errors can occur in spreadsheets.<br>check the results before acting on<br>Note 2<br>The Trading Reports on this page<br>guidance only. More information is<br>for a full Profit & Loss Account and<br>Balance Sheet.|
|---|---|---|
||-<br>0.00 <br>**0.00** <br>0.00 <br>373.87<br>352.50<br>0.00||
||-<br>0.00<br>**726.37** <br>1237.55<br>0.00 <br>0.00||
||-<br>0.00<br>**1237.55**<br>**511.18**||



## _**h**_ 



_Month No._ 

12 

|ncome|ncome||
|---|---|---|
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
||||
||||
|289.40|||
||||
|52.40|||
|32.07|||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
||||
|373.87|0.00|0.00|
|23<br>24<br>25|||



|_Month No._|_Month No._|12|
|---|---|---|
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|





0.00 0.00 0.00 43 44 45 

|_Month No._|_Month No._|12|
|---|---|---|
||||
|ncome|||
|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|373.87|0.00|0.00|
|23<br>24<br>25|||
||||
||||
|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|0.00|0.00|
|43<br>44<br>45|||





||||||25|0.00|
|---|---|---|---|---|---|---|
||||||45|0.00|
|||||||**0.00**|
|Sum|10|to|17|plus|21+24|779.78|
|Sum|30|to|41|plus|44|0.00|



289.40 **0.00** 

Always them. are for s needed d a full 



## **4th QUATER TRADING SUMMARY** 

## September 2023 - August 2024 

|**_---------Accounts-----------_**<br>CASH<br>CHEQUE<br>A/C<br>A/C<br>**OPENING BALANCE**<br>8705.63<br>0.00<br>SPONSORED<br>FATHERS<br>Closing Balance last Year<br>EVENT<br>DAY<br>**INCOME**<br>7673.31<br>0.00<br>0.00<br>386.07<br>1a<br>2a<br>10<br>11<br>SPONSORED<br>FATHERS<br>EVENT<br>DAY<br>**EXPENDITURE**<br>13428.95<br>0.00<br>0.00<br>38.73<br>1b<br>2b<br>30<br>31<br>**CLOSING BALANCE**<br>2949.99<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>-5755.64<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>4838.07<br>Direct Costs<br>30<br>0.00<br>**Gross Profit**<br>**4838.07**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>20.80<br>R/Grants & Other Income<br>9.85<br>18+21<br>30.65<br>**Total Income**<br>**4868.72**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>2492.11<br>Depreciation<br>Calculate elsewhere or leave at 0<br>2492.11<br>**_Profit (Loss) for the Period_**<br>**2376.61**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42<br>630.95<br>**1745.66**||||||||
|---|---|---|---|---|---|---|---|
||CASH<br>A/C|CHEQUE<br>A/C|||_Trading Income_|||
||8705.63|0.00|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|
|||||||||
||7673.31|0.00|0.00|386.07|0.00|779.78|0.00|
||1a|2a|10<br>11||12<br>13<br>14|||
|||||||||
||||||_Direct_|||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|
||13428.95|0.00|0.00|38.73|0.00|124.74|0.00|
||1b<br>2949.99|2b<br>0.00|30<br>31||32<br>33<br>34|||
||||||**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>LESS:<br>Depreciation on asset<br>Capital equipment sol<br>**Change in Assets**<br>**Liabilities:**<br>VAT due to Customs & Excise<br>New Outside loans<br>New Personal loans<br>LESS:<br>Loan repaym'ts (ex.In<br>**Change in Liabilities**<br>**Accounts:**<br>Movement in Cash account<br>Movement in Bank account<br>LESS:<br>Grants for capital equ<br>**Change in Accounts**<br>**_Change in Nett worth_**<br>Assets minus Liabilities plus change in Accounts|||



Assets minus Liabilities plus change in Accounts 



_**Totals from Months 10, 11 and 12**_ 

_Year_ 

|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|Other Income|Other Income|Other Income|Other Income|Other Income|Other Income|
|---|---|---|---|---|---|---|---|---|---|
|||||||||||
|DISCOS|WONKA|SUMMER<br>CIRCUS<br>|OWN<br>CLOTHES DAY|RECYCLING <br>|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|
|0.00|0.00|3672.22|9.85|20.80|0|0|1252.50|1552.09|0.00|
|15<br>16<br>17<br>18||||19<br>20<br>21<br>22<br>23<br>24||||||
|_Analysis ofpayments_||||_Indirect costs_<br>_(Overheads)_||||||
|_Costs_||||||_Indirect costs_<br>_(Overheads)_||||
|DISCOS|WONKA|SUMMER<br>CIRCUS<br>|OWN<br>CLOTHES DAY|RECYCLING <br>|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|
|0.00|0.00|2328.64|0.00|0.00|0.00|0.00|630.95|10300.00|0.00|
|35<br>36<br>37<br>38<br>44<br>0.00 <br>ts<br>as Trading Repor<br>0.00<br>ld<br>24<br>0.00<br>-<br>0.00 <br>**0.00** <br>25 minus 45<br>-5.89 <br>23<br>1552.09<br>22<br>1252.50<br>ntr'st)<br>43<br>10300.00<br>-<br>10300.00<br>**s**<br>**-7501.30** <br>1c<br>-5755.64<br>2c<br>0.00 <br>uip.<br>20<br>0.00<br>-<br>0.00<br>**s**<br>**-5755.64**<br>**1745.66**||||39<br>40<br>41<br>42<br>43<br>44<br>**Value Added Tax**<br> V.A.T. due to Customs & Excise on sales<br>25<br>V.A.T. reclaimable from C&E on expenditure<br>45<br> **_Nett amount owed to Customs & Excise_**<br> VAT due minus VAT reclaimable<br>Total value of Sales (excl. VAT)<br>Sum 10 to 17 plus 21+24<br> Total value of Purchases (excl. VAT)<br>Sum 30 to 41 plus 44<br>**Standard Hour Calculation**<br> Billed' hours this Period<br>Overhead burden<br>Sum 31 to 42<br>3123.06<br> **Standard Hour cost**<br>**0.00**<br>Overhead Burden divided by Billed hours|||||44<br>25<br>45|
|||-<br>0.00 <br>**0.00** <br>-5.89 <br>1552.09<br>1252.50<br>10300.00||||||||
|||-<br>10300.00<br>**-7501.30** <br>-5755.64<br>0.00 <br>0.00||||||||
|||||||||||
||||||||||3123.06<br>**0.00**|
|||-<br>0.00<br>**-5755.64**<br>**1745.66**||Note 1<br>Errors can occur in spreadsheets. Always<br>check the results before acting on them.<br>Note 2<br>The Trading Reports on this page are for<br>guidance only. More information is needed<br>for a full Profit & Loss Account and a full<br>Balance Sheet.||||||





V.A.T. 0.00 25 V.A.T. 5.89 45 0.00 5.89 **-5.89** 4838.07 2492.11 



**YEAR INCOME** September 2023 - August 2024 

## _**Monthly Totals**_ 

simplest.xls 

|simplest.xls|||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|_Period_|||_Analysis of income_||||||||||
||_Paid to:-_||_Trading Income_||||||||||
||CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|
|**FIRST QUARTER**|||||||||||||
|Month<br>1|2537.34|0.00|601.50|0.00|0.00|0.00|0.00|0.00|153.67|0.00|182.17|0|
|Month<br>2|939.62|0.00|0.00|0.00|0.00|0.00|20.00|639.44|0.00|0.00|248.08|32.1|
|Month<br>3|3880.79|0.00|0.00|0.00|0.00|520.58|2659.20|344.69|0.00|0.00|108.34|0|
|**1st Quarter TOTALS**|**7357.75**|**0.00**|**601.50**|**0.00**|**0.00**|**520.58**|**2679.20**|**984.13**|**153.67**|**0.00**|**538.59**|**32.10**|
|**SECOND QUARTER**|||||||||||||
|Month<br>4|3549.81|0.00|0.00|0.00|0.00|2377.20|0.00|0.00|0.00|0.00|29.56|27.6|
|Month<br>5|1356.09|0.00|0.00|0.00|0.00|665.05|0.00|172.35|0.00|0.00|19.69|0|
|Month<br>6|1839.67|0.00|0.00|0.00|485.96|0.00|0.00|789.91|20.68|0.00|24.62|0|
|**2nd Quarter TOTALS**|**6745.57**|**0.00**|**0.00**|**0.00**|**485.96**|**3042.25**|**0.00**|**962.26**|**20.68**|**0.00**|**73.87**|**27.60**|
|**THIRD QUARTER**|||||||||||||
|Month<br>7|2840.32|0.00|0.00|0.00|400.05|0.00|0.00|0.00|2386.24|0.00|27.03|27|
|Month<br>8|693.57|0.00|0.00|0.00|0.00|14.08|0.00|0.00|100.45|559.33|19.71|0|
|Month<br>9|2416.72|0.00|0.00|96.51|0.00|0.00|0.00|0.00|0.00|2051.71|14.78|36.59|
|**3rd Quarter TOTALS**|**5950.61**|**0.00**|**0.00**|**96.51**|**400.05**|**14.08**|**0.00**|**0.00**|**2486.69**|**2611.04**|**61.52**|**63.59**|
|**FORTH QUARTER**|||||||||||||
|Month<br>10|2524.69|0.00|0.00|386.07|0.00|0.00|0.00|0.00|0.00|1332.40|9.85|0|
|Month<br>11|3621.67|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|2339.82|0.00|0|
|Month<br>12|1526.95|0.00|0.00|0.00|0.00|779.78|0.00|0.00|0.00|0.00|0.00|20.8|
|**4th Quarter TOTALS**|**7673.31**|**0.00**|**0.00**|**386.07**|**0.00**|**779.78**|**0.00**|**0.00**|**0.00**|**3672.22**|**9.85**|**20.80**|
||||||||||||||
|**YEAR TOTALS**|27727.24|0.00|601.50|482.58|886.01|4356.69|2679.20|1946.39|2661.04|6283.26|683.83|144.09|
|1a<br>2a<br>10<br>11<br>12<br>13<br>14<br>15<br>16<br>17<br>18<br>19<br>Checksum<br>27727.24<br>27727.24<br>1a plus 2a<br>Sum 10 to 25|||||||||||||



© R L Griffin 2000 

Page 119 



**YR EXPENDITURE** September 2023 - August 2024 

## _**Monthly Totals**_ 

simplest.xls 

|simplest.xls|||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|_Period_|||_Analysis ofpayments_||||||||||
||_Paid by:-_||_Direct Costs_||||||||||
||CASH<br>A/C|CHEQUE<br>A/C|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|
|**FIRST QUARTER**|||||||||||||
|Month<br>1|1823.12|0.00|0.00|0.00|0.00|965.25|0.00|66.51|50.00|500.00|0.00|0|
|Month<br>2|682.19|0.00|0.00|0.00|0.00|64.78|471.54|84.64|36.00|0.00|0.00|0|
|Month<br>3|933.59|0.00|0.00|0.00|0.00|436.49|122.94|0.00|0.00|0.00|0.00|0|
|**1st Quarter TOTALS**|**3438.90**|**0.00**|**0.00**|**0.00**|**0.00**|**1466.52**|**594.48**|**151.15**|**86.00**|**500.00**|**0.00**|**0.00**|
|**SECOND QUARTER**|||||||||||||
|Month<br>4|483.45|0.00|0.00|0.00|0.00|392.68|24.99|0.00|6.00|0.00|0.00|0|
|Month<br>5|319.22|0.00|0.00|0.00|29.50|0.00|0.00|107.16|9.56|0.00|0.00|0|
|Month<br>6|2127.54|0.00|0.00|0.00|101.65|0.00|0.00|41.37|190.82|0.00|0.00|0|
|**2nd Quarter TOTALS**|**2930.21**|**0.00**|**0.00**|**0.00**|**131.15**|**392.68**|**24.99**|**148.53**|**206.38**|**0.00**|**0.00**|**0.00**|
|**THIRD QUARTER**|||||||||||||
|Month<br>7|6898.22|0.00|0.00|0.00|264.51|655.04|0.00|0.00|923.50|0.00|0.00|0|
|Month<br>8|141.59|0.00|0.00|21.00|0.00|0.00|0.00|0.00|27.28|81.00|0.00|0|
|Month<br>9|1035.35|0.00|0.00|77.04|0.00|0.00|0.00|0.00|390.00|389.15|0.00|0|
|**3rd Quarter TOTALS**|**8075.16**|**0.00**|**0.00**|**98.04**|**264.51**|**655.04**|**0.00**|**0.00**|**1340.78**|**470.15**|**0.00**|**0.00**|
|**FORTH QUARTER**|||||||||||||
|Month<br>10|2697.48|0.00|0.00|38.73|0.00|124.74|0.00|0.00|0.00|2077.87|0.00|0|
|Month<br>11|10442.07|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|250.77|0.00|0|
|Month<br>12|289.40|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0|
|**4th Quarter TOTALS**|**13428.95**|**0.00**|**0.00**|**38.73**|**0.00**|**124.74**|**0.00**|**0.00**|**0.00**|**2328.64**|**0.00**|**0.00**|
||||||||||||||
|**YEAR TOTALS**|27873.22|0.00|0.00|136.77|395.66|2638.98|619.47|299.68|1633.16|3298.79|0.00|0.00|
|1b<br>2b<br>30<br>31<br>32<br>33<br>34<br>35<br>36<br>37<br>38<br>39|||||||||||||



Checksum 27873.22 27873.22 1b plus 2b Sum 30 to 45 

© R L Griffin 2000 

Page 120 



September 2023 - August 2024 

## **YEAR TRADING SUMMARY** 

## _**Year to Date Totals**_ 

|**_---------Accounts-----------_**<br>CASH<br>CHEQUE<br>A/C<br>A/C<br>**OPENING BALANCE**<br>2949.99<br>0.00<br>SPONSORED<br>FATHERS<br>Closing Balance last Year<br>EVENT<br>DAY<br>**INCOME**<br>27727.24<br>0.00<br>601.50<br>482.58<br>1a<br>2a<br>10<br>11<br>SPONSORED<br>FATHERS<br>EVENT<br>DAY<br>**EXPENDITURE**<br>27873.22<br>0.00<br>0.00<br>136.77<br>1b<br>2b<br>30<br>31<br>**CLOSING BALANCE**<br>2804.01<br>0.00<br>Opening Balance for next month<br>**MOVEMENT**<br>-145.98<br>0.00<br>1c<br>2c<br>**Trading Report**<br>Trading Income<br>Sum 10 to 17<br>20954.17<br>Direct Costs<br>30<br>10741.53<br>**Gross Profit**<br>**10212.64**<br>Trading Income minus Direct Costs<br>Other Income<br>Interest<br>19<br>144.09<br>R/Grants & Donations<br>827.92<br>18+21<br>972.01<br>**Total Income**<br>**11184.65**<br>Gross Profit + Other Income<br>Overheads<br>Sum 31 to 41<br>Depreciation<br>Calculate elsewhere or leave at 0<br>0.00<br>**_Profit (Loss) for the Period_**<br>**11184.65**<br>Total Income minus O'heads & Depreciation<br>Drawings<br>42|||||_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_|_Analysis of income_||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
||CASH<br>A/C|CHEQUE<br>A/C|||_Trading Income_||||||||
||2949.99|0.00|SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|
||||||||||||||
||27727.24|0.00|601.50|482.58|886.01|4356.69|2679.20|1946.39|2661.04|6283.26|683.83|144.09|
||1a|2a|10<br>11||12<br>13<br>14<br>15<br>16<br>17<br>18|||||||19|
||||||_Analysis ofpayments_||||||||
||||||_Direct Costs_||||||||
||||SPONSORED<br>EVENT|FATHERS<br>DAY|MOTHERS<br>DAY|ELFRIDGES<br>SANTA VISIT|XMAS<br>FETE|DISCOS|WONKA|SUMMER<br>CIRCUS|OWN<br>CLOTHES DAY|RECYCLING|
||27873.22|0.00|0.00|136.77|395.66|2638.98|619.47|299.68|1633.16|3298.79|0.00|0.00|
||1b<br>2804.01|2b<br>0.00|30<br>31<br>||32<br>33<br>34<br>35<br>36<br>37<br>38|||||||39|
||||||**Changes to Balance Sheet**<br>**Assets:**<br>Capital equipment aquired<br>44<br>0.00 <br>LESS:<br>Depreciation on assets<br>as Trading Repor<br>0.00<br>Capital equipment sold<br>24<br>0.00<br>-<br>0.00 <br>**Change in Assets**<br>**0.00** <br>**Liabilities:**<br>VAT due to Customs & Excise<br>25 minus 45<br>-5.89 <br>New Outside loans<br>23<br>1850.15<br>New Personal loans<br>22<br>3577.50<br>LESS:<br>Loan repaym'ts (ex.Intr'st)<br>43<br>16972.80<br>-<br>16972.80<br>**Change in Liabilities**<br>**-11551.04** <br>**Accounts:**<br>Movement in Cash account<br>1c<br>-145.98<br>Movement in Bank account<br>2c<br>0.00 <br>LESS:<br>Grants for capital equip.<br>20<br>517.50<br>-<br>517.50<br>**Change in Accounts**<br>**-663.48**<br>**_Change in Nett worth_**<br>**10887.56**|||||||**Value Add**|
|||||||||||||V.A.T. due t<br>V.A.T. recla<br> **_Nett amou_**<br> VAT due minus V<br>Total value<br> Total value<br>**Standard**|
|||||||||||-<br>0.00 <br>**0.00** <br>-5.89 <br>1850.15<br>3577.50<br>16972.80|||
|||||||||||||Billed' hou<br>Overhead<br> **Standard**<br>Overhead Burden|
|||||||||||-<br>16972.80<br>**-11551.04** <br>-145.98<br>0.00 <br>517.50|||
|||||||||||-<br>517.50<br>**-663.48**<br>**10887.56**||Note 1<br>Note 2|



© R L Griffin 2000 

Page 121 



**11184.65** 

Assets minus Liabilities plus change in Accounts 

© R L Griffin 2000 

Page 122 



_Year_ 23/24 

|Other Income|Other Income|Other Income|Other Income|Other Income||
|---|---|---|---|---|---|
|||||||
|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|||||||
|0|0|1600.00|0.00|0.00|0|
|0|0|0.00|0.00|0.00|0|
|0|0|225.00|22.98|0.00|0|
|**0.00**|**0.00**|**1825.00**|**22.98**|**0.00**|**0.00**|
|||||||
|0|1057.5|0.00|57.95|0.00|0|
|499|0|0.00|0.00|0.00|0|
|18.5|0|500.00|0.00|0.00|0|
|**517.50**|**1057.50**|**500.00**|**57.95**|**0.00**|**0.00**|
|||||||
|0|0|0.00|0.00|0.00|0|
|0|0|0.00|0.00|0.00|0|
|0|0|0.00|217.13|0.00|0|
|**0.00**|**0.00**|**0.00**|**217.13**|**0.00**|**0.00**|
|||||||
|0|0|100.00|696.37|0.00|0|
|0|0|800.00|481.85|0.00|0|
|0|0|352.50|373.87|0.00|0|
|**0.00**|**0.00**|**1252.50**|**1552.09**|**0.00**|**0.00**|
|||||||
|517.50|1057.50|3577.50|1850.15|0.00|0.00|
|20<br>21<br>22<br>23<br>24<br>25||||||



© R L Griffin 2000 

Page 123 



_Year_ 23/24 

|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_|_Indirect costs_<br>_(Overheads)_||
|---|---|---|---|---|---|
||_Indirect costs_<br>_(Overheads)_|||||
|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|||||||
|0|0.00|0.00|241.36|0.00|0|
|0|0|21.48|3.75|0.00|0|
|0|0|350.41|23.75|0.00|0|
|**0.00**|**0.00**|**371.89**|**268.86**|**0.00**|**0.00**|
|||||||
|0|0|59.78|0.00|0.00|0|
|0|153|20.00|0.00|0.00|0|
|0|0|389.76|1403.94|0.00|0|
|**0.00**|**153.00**|**469.54**|**1403.94**|**0.00**|**0.00**|
|||||||
|0|0|55.17|5000.00|0.00|0|
|0|0|12.31|0.00|0.00|0|
|0|0|179.16|0.00|0.00|0|
|**0.00**|**0.00**|**246.64**|**5000.00**|**0.00**|**0.00**|
|||||||
|0|0|250.25|200.00|0.00|5.89|
|0|0|91.30|10100.00|0.00|0|
|0|0|289.40|0.00|0.00|0|
|**0.00**|**0.00**|**630.95**|**10300.00**|**0.00**|**5.89**|
|||||||
|0.00|153.00|1719.02|16972.80|0.00|5.89|
|40<br>41<br>42<br>43<br>44<br>45||||||



© R L Griffin 2000 

Page 124 



_Year_ 23/24 

|Other Income|Other Income|Other Income|Other Income|Other Income||
|---|---|---|---|---|---|
|||||||
|CAULIFLOWER<br>CARDS|GRANTS|DONATIONS<br>REC'V'D|OTHER<br>INCOME|CAPITAL<br>SALES|V.A.T.|
|517.50|1057.50|3577.50|1850.15|0.00|0.00|
|20<br>21<br>22<br>23<br>24<br>25||||||
|||||||
||_Indirect costs_<br>_(Overheads)_|||||
|CAULIFLOWER<br>CARDS|MEMBER<br>SHIPS|OTHER<br>EXP'S|UPS<br>DONATIONS|CAPITAL<br>EXPEND|V.A.T.|
|0.00|153.00|1719.02|16972.80|0.00|5.89|
|40<br>41<br>42<br>43<br>44<br>45||||||



## **ded Tax** 

to Customs & Excise on sales 25 0.00 aimable from C&E on expenditure 45 5.89 _**unt owed to Customs & Excise**_ **-5.89** VAT reclaimable of Sales (excl. VAT) Sum 10 to 17 plus 21+24 20954.17 of Purchases (excl. VAT) Sum 30 to 41 plus 44 9175.51 

## **Hour Calculation** 

rs this Period burden Sum 31 to 42 

## **Hour cost** 

**0.00** 

n divided by Billed hours 

Errors can occur in spreadsheets. Always check the results before acting on them. The Trading Reports on this page are for guidance only. More information is needed for a full Profit & Loss Account and a full 

© R L Griffin 2000 

Page 125 



Balance Sheet.
1 ?R
I nwriftin ?nnn