OpenCharities

This text was generated using OCR and may contain errors. Check the original PDF to see the document submitted to the regulator.

← Friends Of Undy Primary School

2024-08-31-accounts

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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
2a
10
11
12
13
14
15
16
17
18
19

Checksum 2537.34 2537.34

1a plus 2a

Sum 10 to 25

EXPENDITURE
simplestExample.xls		 EXPENDITURE
simplestExample.xls		 EXPENDITURE
simplestExample.xls		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September-23 September-23 September-23
Payment details Analysis ofpayments
Paid by:- Direct Costs
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 CLOTHES
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
2b
30
31
32
33
34
35
36
37
38
39

Checksum 1823.12 1823.12

1b plus 2b

Sum 30 to 45

TRADING SUMMARY

----------------Accounts-
OPENING BALANCE
Closing Balance last month
INCOME
EXPENDITURE
CLOSING BALANCE
Opening Balance for next month
MOVEMENT
Trading Report
Trading Income
Sum 1
Direct Costs
Sum 3
Gross Profit
Trading Income minus Direct Costs
Other Income
Donations
19
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
Sum 4
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
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
A/C		 CHEQUE
A/C		 Trading Income
3095.97 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
11		 12
13
14
15
16
17
18		 19
Analysis ofpayments
Direct Costs
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
3810.19		 2b
0.00		 30
31		 32
33
34
35
36
37
38		 39
714.22
0.00
1c
2c
0 to 17
755.17
0 to 40
1581.76
-826.59

0.00
182.17
182.17
-644.42
0 to 41
0.00
0.00
-644.42

0.00
-644.42		 Changes to Balance Sheet
Assets:
Capital equipment aquired
44
0.00
LESS:
Depreciation on assets
as Trading Report
0.00
Capital equipment sold
24
0.00
-
0.00
Change in Assets
0.00
Liabilities:
VAT due to Customs & Excise
25 minus 45
0.00
New Outside loans
23
0.00
New Personal loans
22
1600.00
LESS:
Loan repaym'ts (ex.Intr'st)
43
241.36
-
241.36
Change in Liabilities
1358.64
Accounts:
Movement in Cash account
1c
714.22
Movement in Bank account
2c
0.00
LESS:
Grants for capital equip.
20
0.00
-
0.00
Change in Accounts
714.22
Change in Nett worth
-644.42
Assets minus Liabilities plus change in Accounts
V.A.T. due to C
V.A.T. reclaima
Nett amount
VAT due minus VAT re
Total value of S
Total value of P
Standard Ho
-
0.00
0.00
0.00
0.00
1600.00
241.36
'Billed' hours t
Overhead bur
Standard Ho
Overhead Burden divid
Note 1
Note 2
-
241.36
1358.64
714.22
0.00
0.00
-
0.00
714.22
-644.42		 Note 1
Note 2

Month No. 1

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

Month No. 1

Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)
Indirect costs
(Overheads)
CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
241.36
0.00 0.00 0.00 241.36 0.00 0.00
40
41
42
43
44
45

Month No. 1

Other Income Other Income Other Income Other Income Other Income
CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0 0 1600.00 0.00 0.00 0.00
20
21
22
23
24
25
Indirect costs
(Overheads)
CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00 241.36 0.00 0.00
40
41
42
43
44
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
simplestExample.xls		 INCOME
simplestExample.xls		 INCOME
simplestExample.xls		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 October-23 October-23
Payment from:- Analysis of income
Paid to:- Trading Income
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
simplestExample.xls		 EXPENDITURE
simplestExample.xls		 EXPENDITURE
simplestExample.xls		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 October-23 October-23
Payment details Analysis ofpayments
Paid by:- Direct Costs
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
2b
30
31
32
33
34
35
36
37
38
Checksum
682.19
682.19
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

October-23 October-23
Analysis of income
CASH
A/C		 CHEQUE
A/C		 Trading Income
3810.19 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
11
12
13
14
15
16
17
18
Analysis ofpayments
Direct Costs
SPONSORED FATHERS MOTHERS ELFRIDGES XMAS DISCOS WONKA SUMMER OWN
EXPENDITURE
CLOSING BALANCE
Opening Balance for next month
MOVEMENT
Trading Report
Trading Income
Sum 1
Direct Costs
Sum 3
Gross Profit
Trading Income minus Direct Costs
Other Income
Donations
1
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
Sum 4
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
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
4067.62		 2b
0.00		 32
33
34
35
36
37
38
Changes to Balance Sheet
Assets:
Capital equipment aquired
44
0.00
LESS:
Depreciation on assets
as Trading Report
0.00
Capital equipment sold
24
0.00
-
0.00
Change in Assets
0.00
Liabilities:
VAT due to Customs & Excise
25 minus 45
0.00
New Outside loans
23
0.00
New Personal loans
22
0.00
LESS:
Loan repaym'ts (ex.Intr'st)
43
3.75
-
3.75
Change in Liabilities
-3.75
Accounts:
Movement in Cash account
1c
257.43
Movement in Bank account
2c
0.00
LESS:
Grants for capital equip.
20
0.00
-
0.00
Change in Accounts
257.43
Change in Nett worth
261.18
Assets minus Liabilities plus change in Accounts
-
0.00
0.00
0.00
0.00
0.00
3.75
-
3.75
-3.75
257.43
0.00
0.00
-
0.00
257.43
261.18
2
Other Income
RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
32.1
32.10 0.00 0.00 0.00 0.00 0.00 0.00
19
20
21
22
23
24
25

Month No. 2

Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)
Indirect costs
(Overheads)
RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
21.48 3.75
0.00 0.00 0.00 21.48 3.75 0.00 0.00
39
40
41
42
43
44
45
2
Other Income
RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
32.10 0 0 0.00 0.00 0.00 0.00
19
20
21
22
23
24
25
Indirect costs
(Overheads)
Indirect costs
(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
40
41
42
43
44
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 21+24
659.44
Total value of Purchases (excl. VAT)
Sum 30 to 42 plus 44
678.44		 44
45
25
0.00
45
0.00

Standard Hour Calculation

'Billed' hours this month
Overhead burden
Sum 40 to 42
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.
INCOME
simplestExample.xls		 INCOME
simplestExample.xls		 INCOME
simplestExample.xls		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 November-23 November-23
Payment from:- Analysis of income
Paid to:- Trading Income
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
2a
10
11
12
13
14
15
16
Checksum
3880.79
3880.79
1a plus 2a
Sum 10 to 25
EXPENDITURE
September 2023 - August 2024		 17
18
EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024		 EXPENDITURE
September 2023 - August 2024
Month Name:
simplestExample.xls		 November-23
Payment details Analysis ofpayments
Paid by:- Direct Costs
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
2b
30
31
32
33
34
35
36
37
38
Checksum
933.59
933.59
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 September 2023 - August 2024
Month Name:		 November-23 November-23
----------------- Analysis of income
CASH
A/C		 CHEQUE
A/C		 Trading Income
4067.62 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
11
12
13
14
15
16
17
18
Analysis ofpayments
Direct Costs
SPONSORED FATHERS MOTHERS ELFRIDGES XMAS DISCOS WONKA SUMMER OWN
EXPENDITURE
CLOSING BALANCE
Opening Balance for next month
MOVEMENT
Trading Report
Trading Income
Sum 1
Direct Costs
Sum 3
Gross Profit
Trading Income minus Direct Costs
Other Income
Donations
1
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
Sum 4
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
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
7014.82		 2b
0.00		 32
33
34
35
36
37
38
Changes to Balance Sheet
Assets:
Capital equipment aquired
44
0.00
LESS:
Depreciation on assets
as Trading Report
0.00
Capital equipment sold
24
0.00
-
0.00
Change in Assets
0.00
Liabilities:
VAT due to Customs & Excise
25 minus 45
0.00
New Outside loans
23
22.98
New Personal loans
22
225.00
LESS:
Loan repaym'ts (ex.Intr'st)
43
23.75
-
23.75
Change in Liabilities
224.23
Accounts:
Movement in Cash account
1c
2947.20
Movement in Bank account
2c
0.00
LESS:
Grants for capital equip.
20
0.00
-
0.00
Change in Accounts
2947.20
Change in Nett worth
2722.97
Assets minus Liabilities plus change in Accounts
-
0.00
0.00
0.00
22.98
225.00
23.75
-
23.75
224.23
2947.20
0.00
0.00
-
0.00
2947.20
2722.97

Month No. 3

Other Income Other Income Other Income Other Income Other Income Other Income
RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
225.00
22.98
0.00 0.00 0.00 225.00 22.98 0.00 0.00
19
20
21
22
23
24
25

Month No. 3

Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)
Indirect costs
(Overheads)
RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
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
40
41
42
43
44
45
3
Other Income
RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0 0 225.00 22.98 0.00 0.00
19
20
21
22
23
24
25
Indirect costs
(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
40
41
42
43
44
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
3524.47
Total value of Purchases (excl. VAT)
Sum 30 to 42 plus 44
909.84		 44
45
25
0.00
45
0.00

Standard Hour Calculation

'Billed' hours this month
Overhead burden
Sum 40 to 42
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.

1st QUATER TRADING SUMMARY

September 2023 - August 2024

Totals from Months 1, 2 and 3

---------Accounts-----------
CASH
CHEQUE
A/C
A/C
OPENING BALANCE
3095.97
0.00
SPONSORED
FATHERS
Closing Balance last Year
EVENT
DAY
INCOME
7357.75
0.00
601.50
0.00
1a
2a
10
11
SPONSORED
FATHERS
EVENT
DAY
EXPENDITURE
3438.90
0.00
0.00
0.00
1b
2b
30
31
CLOSING BALANCE
7014.82
0.00
Opening Balance for next month
MOVEMENT
3918.85
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
4939.08
Direct Costs
Sum 30 to 40
2798.15
Gross Profit
2140.93
Trading Income minus Direct Costs
Other Income
Donations
19
32.10
R/Grants & Other Income
538.59
18+21
570.69
Total Income
2711.62
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
A/C		 CHEQUE
A/C		 Trading Income
3095.97 0.00 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
11		 12
13
14
15
16
17
18
Analysis ofpayments
Direct Costs
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
7014.82		 2b
0.00		 30
31
 32
33
34
35
36
37
38
Changes to Balance Sheet
Assets:
Capital equipment aquired
44
0.00
LESS:
Depreciation on assets
as Trading Repor
0.00
Capital equipment sold
24
0.00
-
0.00
Change in Assets
0.00
Liabilities:
VAT due to Customs & Excise
25 minus 45
0.00
New Outside loans
23
22.98
New Personal loans
22
1825.00
LESS:
Loan repaym'ts (ex.Intr'st)
43
268.86
-
268.86
Change in Liabilities
1579.12
Accounts:
Movement in Cash account
1c
3918.85
-
0.00
0.00
0.00
22.98
1825.00
268.86
-
268.86
1579.12
3918.85
Overheads
Sum 31 to 41
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the Period
Total Income minus O'heads & Depreciation
Drawings
42		 2798.15 2798.15
2798.15
-86.53
-86.53
Movement in Bank account 2c 0.00
LESS:
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
 CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
32.10 0 0 1825.00 22.98 0.00 0.00
19
20
21
22
23
24
25
Indirect costs
(Overheads)
Indirect costs
(Overheads)
RECYCLING
 CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00 371.89 268.86 0.00 0.00
39
40
41
42
43
44
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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
3549.81
3549.81
1a plus 2a
Sum 10 to 25
September 2023 - August 2024
Payment details
Paid by:-
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2b
30
31
32
33
Checksum
483.45
483.45
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
7014.82 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
3549.81 0.00 0.00 0.00 0.00 2377.20
1a 2 a 10
11
12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
483.45 0.00 0.00 0.00 0.00 392.68
1b
10081.18		 2b
0.00		 30
31
32
33
Opening Balance for next month
MOVEMENT
3066.36
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2377.20
Direct Costs
Sum 30 to 40
423.67
Gross Profit
1953.53
Trading Income minus Direct Costs
Other Income
Donations
19
27.60
R/Grants & Other Income
1087.06
18+21
1114.66
Total Income
3068.19
Gross Profit + Other Income
Overheads
Sum 41 to 42
59.78
Depreciation
Calculate elsewhere or leave at 0
59.78
Profit (Loss) for the month
3008.41
Total Income minus O'heads & Depreciation
Drawings
42
3008.41		 Opening Balance for next month
MOVEMENT
3066.36
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2377.20
Direct Costs
Sum 30 to 40
423.67
Gross Profit
1953.53
Trading Income minus Direct Costs
Other Income
Donations
19
27.60
R/Grants & Other Income
1087.06
18+21
1114.66
Total Income
3068.19
Gross Profit + Other Income
Overheads
Sum 41 to 42
59.78
Depreciation
Calculate elsewhere or leave at 0
59.78
Profit (Loss) for the month
3008.41
Total Income minus O'heads & Depreciation
Drawings
42
3008.41		 Opening Balance for next month
MOVEMENT
3066.36
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2377.20
Direct Costs
Sum 30 to 40
423.67
Gross Profit
1953.53
Trading Income minus Direct Costs
Other Income
Donations
19
27.60
R/Grants & Other Income
1087.06
18+21
1114.66
Total Income
3068.19
Gross Profit + Other Income
Overheads
Sum 41 to 42
59.78
Depreciation
Calculate elsewhere or leave at 0
59.78
Profit (Loss) for the month
3008.41
Total Income minus O'heads & Depreciation
Drawings
42
3008.41
1953.53
27.60
1087.06
1114.66
3068.19
59.78		 1114.66
3068.19
59.78
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
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
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
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
35
36
37
38
39
40
41
42
Month Name: Month Name: Month Name: December-23 December-23 December-23 December-23 December-23 December-23
Analysis of income
Income
Other I
Income
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 0.00 0.00 29.56 27.60 0 1057.5 0.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
24.99 0.00 6.00 0.00 0.00 0.00 0.00 0.00 59.78
34
35
36
37
38
39
40
41
42

Sheet

Value Added Tax

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

h

Month No.

4

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
57.95
57.95 0.00 0.00
23
24
25
Month No. Month No. 4
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.

0.00 0.00 0.00 43 44 45

Month No. Month No. 4
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
57.95 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
1356.09
1356.09
1a plus 2a
Sum 10 to 25
September 2023 - August 2024
Payment details
Paid by:-
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2b
30
31
32
33
Checksum
319.22
319.22
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
10081.18 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
1356.09 0.00 0.00 0.00 0.00 665.05
1a 2 a 10
11		 12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
319.22 0.00 0.00 0.00 29.50 0.00
1b
11118.05		 2b
0.00		 30
31		 32
33
1036.87
0.00

Assets:
1c
Trading Report
Trading Income
Sum 10 to 17
Direct Costs
Sum 30 to 39 plus 42
Gross Profit
Trading Income minus Direct Costs
Other Income
Donations
19
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
41
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
42		 2c
837.40
166.22		 2c
837.40
166.22
671.18
0.00
19.69
19.69
690.87
153.00		 19.69
690.87
153.00
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
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
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
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
35
36
37
38
39
40
41
42

Month Name: January-24

Analysis of income Income

Other I Other I
Income
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 172.35 0.00 0.00 19.69 0.00 499.00 0 0.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 107.16 9.56 0.00 0.00 0.00 0.00 153.00 20.00
34
35
36
37
38
39
40
41
42

Sheet

Value Added Tax

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

h

Month No.

5

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25
Month No. Month No. 5
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
45
Month No. Month No. 5
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2a
10
11
12
13
Checksum
1839.67
1839.67
1a plus 2a
Sum 10 to 25

EXPENDITURE September 2023 - August 2024

simplestExample.xls Payment details Paid by:-

DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2b
30
31
32
33
Checksum
2127.54
2127.54
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
11118.05 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
1839.67 0.00 0.00 0.00 485.96 0.00
1a 2a 10
11
12
13
EXPENDITURE
CLOSING BALANCE
Opening Balance for next month
MOVEMENT
Trading Report
Trading Income
Sum 1
Direct Costs
Sum 3
Gross Profit
Trading Income minus Direct Costs
Other Income
Donations
1
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
Sum 3
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
4		 MOTHERS
ELFRIDGES
DAY
SANTA VISIT
101.65
0.00
32
33
Changes to Balance S		 MOTHERS
ELFRIDGES
DAY
SANTA VISIT
101.65
0.00
32
33
Changes to Balance S
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
2127.54 0.00 0.00 0.00 101.65 0.00
1b
10830.18		 2b

0.00

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

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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
22

Month Name: February-24 Analysis of payments

Direct Costs

Indirect costs

(Overheads) (Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
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
35
36
37
38
39
40
41
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 789.91 20.68 0.00 24.62 0.00 18.5 0 500.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
41.37
190.82
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
500.00
ym'ts (ex.Intr'st)
43
1403.94
-
1403.94
Liabilities
-903.94
count
1c
-287.87
count
2c
0.00
capital equip.
20
18.50
-
18.50
Accounts
-306.37
h
597.57
n Accounts		 Analysis ofpayments
Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
41.37
190.82
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
500.00
ym'ts (ex.Intr'st)
43
1403.94
-
1403.94
Liabilities
-903.94
count
1c
-287.87
count
2c
0.00
capital equip.
20
18.50
-
18.50
Accounts
-306.37
h
597.57
n Accounts		 RECYCLING CAULIFLOWER
MEMBER
OTHER
CARDS
SHIPS
EXP'S
0.00
0.00
0.00
389.76
39
40
41
42
Value Added Tax
V.A.T. due to Customs & Excise on sales
V.A.T. reclaimable from C&E on expenditure
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Total value of Purchases (excl. VAT)
Standard Hour Calculation
'Billed' hours this month
Overhead burden
Sum 31 to 42
Standard Hour cost
Overhead Burden divided by Billed hours
Note 1
Errors can occur in spreadsheets.
check the results before acting on
Note 2
The Trading Reports on this page
guidance only. More information is
for a full Profit & Loss Account and
Balance Sheet.
Indirect costs
(Overheads)
-
0.00
0.00
0.00
0.00
500.00
1403.94
-
1403.94
-903.94
-287.87
0.00
18.50
-
18.50
-306.37
597.57		 Note 1
Errors can occur in spreadsheets.
check the results before acting on
Note 2
The Trading Reports on this page
guidance only. More information is
for a full Profit & Loss Account an
Balance Sheet.

6

Month No.

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25

Month No. 6

UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
1403.94
1403.94 0.00 0.00
43
44
45
Month No. Month No. 6
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
1403.94 0.00 0.00
43
44
45
25
0.00
45
0.00
0.00
Sum 10 to 17 plus 21+24
1296.55
Sum 30 to 42 plus 44
723.60		 44
45
25
0.00
45
0.00

0.00

Always them. are for s needed d a full

2nd QUATER TRADING SUMMARY

September 2023 - August 2024

---------Accounts-----------
CASH
CHEQUE
A/C
A/C
OPENING BALANCE
7014.82
0.00
SPONSORED
FATHERS
Closing Balance last Year
EVENT
DAY
INCOME
6745.57
0.00
0.00
0.00
1a
2a
10
11
SPONSORED
FATHERS
EVENT
DAY
EXPENDITURE
2930.21
0.00
0.00
0.00
1b
2b
30
31
CLOSING BALANCE
10830.18
0.00
Opening Balance for next month
MOVEMENT
3815.36
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
4511.15
Direct Costs
30
903.73
Gross Profit
3607.42
Trading Income minus Direct Costs
Other Income
Donations
19
27.60
R/Grants & Other Income
1131.37
18+21
1158.97
Total Income
4766.39
Gross Profit + Other Income
Overheads
Sum 31 to 41
622.54
Depreciation
Calculate elsewhere or leave at 0
622.54
Profit (Loss) for the Period
4143.85
Total Income minus O'heads & Depreciation
Drawings
42
4143.85
CASH
A/C		 CHEQUE
A/C		 Trading Income
7014.82 0.00 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE
6745.57 0.00 0.00 0.00 485.96 3042.25 0.00
1a 2a 10
11		 12
13
14
Direct
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE
2930.21 0.00 0.00 0.00 131.15 392.68 24.99
1b
10830.18		 2b
0.00		 30
31		 32
33
34
Changes to Balance Sheet
Assets:
Capital equipment aquired
LESS:
Depreciation on asset
Capital equipment sol
Change in Assets
Liabilities:
VAT due to Customs & Excise
New Outside loans
New Personal loans
LESS:
Loan repaym'ts (ex.In
Change in Liabilities
Accounts:
Movement in Cash account
Movement in Bank account
LESS:
Grants for capital equ
Change in Accounts
Change in Nett worth
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
CIRCUS
 OWN
CLOTHES DAY		 RECYCLING
CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES
962.26 20.68 0.00 73.87 27.60 517.5 1057.5 500.00 57.95 0.00
15
16
17
18		 19
20
21
22
23
24
Analysis ofpayments Indirect costs
(Overheads)
Costs Indirect costs
(Overheads)
DISCOS WONKA SUMMER
CIRCUS
 OWN
CLOTHES DAY		 RECYCLING
CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND
148.53 206.38 0.00 0.00 0.00 0.00 153.00 469.54 1403.94 0.00
35
36
37
38
44
0.00
ts
as Trading Repor
0.00
ld
24
0.00
-
0.00
0.00
25 minus 45
0.00
23
57.95
22
500.00
ntr'st)
43
1403.94
-
1403.94
s
-845.99
1c
3815.36
2c
0.00
uip.
20
517.50
-
517.50
s
3297.86
4143.85		 39
40
41
42
43
44
Value Added Tax
V.A.T. due to Customs & Excise on sales
25
V.A.T. reclaimable from C&E on expenditure
45
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Sum 10 to 17 plus 19+21+24
Total value of Purchases (excl. VAT)
Sum 30 to 41 plus 44
Standard Hour Calculation
Billed' hours this Period
Overhead burden
Sum 31 to 42
622.54
Standard Hour cost
0.00
Overhead Burden divided by Billed hours		 44
25
45
-
0.00
0.00
0.00
57.95
500.00
1403.94
-
1403.94
-845.99
3815.36
0.00
517.50
622.54
0.00
-
517.50
3297.86
4143.85		 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.

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:-
r		 ading Income
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
2840.32
2840.32
1a plus 2a
Sum 10 to 25
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
2b
30
31
32
33
Checksum
6898.22
6898.22
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
10830.18 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
2840.32 0.00 0.00 0.00 400.05 0.00
1a 2 a 10
11
12
13
EXPENDITURE
CLOSING BALANCE
Opening Balance for next month
MOVEMENT
Trading Report
Trading Income
Sum 1
Direct Costs
3
Gross Profit
Trading Income minus Direct Costs
Other Income
Interest
1
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
Sum 3
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
4
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
6898.22 0.00 0.00 0.00 264.51 655.04
1b
6772.28		 2b

0.00		 32
33
Changes to Balance

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
Change in
Change in Nett worth
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
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
35
36
37
38
39
40
41
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 2386.24 0.00 27.03 27.00 0.00 0.00 0.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
0.00
923.50
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
0.00
ym'ts (ex.Intr'st)
43
5000.00
-
5000.00
Liabilities
-5000.00
count
1c
-4057.90
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-4057.90
h
942.10
n Accounts		 Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
0.00
923.50
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
0.00
ym'ts (ex.Intr'st)
43
5000.00
-
5000.00
Liabilities
-5000.00
count
1c
-4057.90
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-4057.90
h
942.10
n Accounts		 Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
0.00
923.50
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
0.00
ym'ts (ex.Intr'st)
43
5000.00
-
5000.00
Liabilities
-5000.00
count
1c
-4057.90
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-4057.90
h
942.10
n Accounts		 Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
0.00
923.50
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
0.00
ym'ts (ex.Intr'st)
43
5000.00
-
5000.00
Liabilities
-5000.00
count
1c
-4057.90
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-4057.90
h
942.10
n Accounts		 Direct Costs
XMAS
DISCOS
WONKA
SUMMER
OWN
FETE
CIRCUS
CLOTHES DAY
0.00
0.00
923.50
0.00
0.00
34
35
36
37
38
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
0.00
22
0.00
ym'ts (ex.Intr'st)
43
5000.00
-
5000.00
Liabilities
-5000.00
count
1c
-4057.90
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-4057.90
h
942.10
n Accounts		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)
DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 923.50 0.00 0.00 0.00 0.00 0.00 55.17
39
40
41
42
Value Added Tax
V.A.T. due to Customs & Excise on sales
V.A.T. reclaimable from C&E on expenditure
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Total value of Purchases (excl. VAT)
Standard Hour Calculation
'Billed' hours this month
Overhead burden
Sum 31 to 42
Standard Hour cost
Overhead Burden divided by Billed hours
Note 1
Errors can occur in spreadsheets.
check the results before acting on
Note 2
The Trading Reports on this page
guidance only. More information is
for a full Profit & Loss Account and
Balance Sheet.
-
0.00
0.00
0.00
0.00
0.00
5000.00
-
5000.00
-5000.00
-4057.90
0.00
0.00
-
0.00
-4057.90
942.10		 Note 1
Errors can occur in spreadsheets.
check the results before acting on
Note 2
The Trading Reports on this page
guidance only. More information is
for a full Profit & Loss Account an
Balance Sheet.

Month No.

7

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25

Month No. 7 UPS CAPITAL V.A.T.

DONATIONS EXPEND
5000.00
5000.00 0.00 0.00
43
44
45
Month No. Month No. 7
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
5000.00 0.00 0.00
43
44
45
25
0.00
45
0.00
0.00
Sum 10 to 17 plus 21+24
2786.29
Sum 30 to 41 plus 44
1843.05		 44
45
25
0.00
45
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:-
r		 ading Income
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
693.57
693.57
1a plus 2a
Sum 10 to 25
September 2023 - August 2024
Payment details
Paid by:-
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2b
30
31
32
33
Checksum
141.59
141.59
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
6772.28 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
693.57 0.00 0.00 0.00 0.00 14.08
1a 2 a 10
11
12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
141.59 0.00 0.00 21.00 0.00 0.00
1b
7324.26		 2b
0.00		 30
31
32
33
Opening Balance for next month
MOVEMENT
551.98
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
673.86
Direct Costs
30
0.00
Gross Profit
673.86
Trading Income minus Direct Costs
Other Income
Interest
19
0.00
R/Grants & Other Income
19.71
18+21
19.71
Total Income
693.57
Gross Profit + Other Income
Overheads
Sum 31 to 41
129.28
Depreciation
Calculate elsewhere or leave at 0
129.28
Profit (Loss) for the month
564.29
Total Income minus O'heads & Depreciation
Drawings
42
12.31
551.98		 Opening Balance for next month
MOVEMENT
551.98
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
673.86
Direct Costs
30
0.00
Gross Profit
673.86
Trading Income minus Direct Costs
Other Income
Interest
19
0.00
R/Grants & Other Income
19.71
18+21
19.71
Total Income
693.57
Gross Profit + Other Income
Overheads
Sum 31 to 41
129.28
Depreciation
Calculate elsewhere or leave at 0
129.28
Profit (Loss) for the month
564.29
Total Income minus O'heads & Depreciation
Drawings
42
12.31
551.98		 Opening Balance for next month
MOVEMENT
551.98
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
673.86
Direct Costs
30
0.00
Gross Profit
673.86
Trading Income minus Direct Costs
Other Income
Interest
19
0.00
R/Grants & Other Income
19.71
18+21
19.71
Total Income
693.57
Gross Profit + Other Income
Overheads
Sum 31 to 41
129.28
Depreciation
Calculate elsewhere or leave at 0
129.28
Profit (Loss) for the month
564.29
Total Income minus O'heads & Depreciation
Drawings
42
12.31
551.98
673.86
0.00
19.71
19.71
693.57
129.28		 19.71
693.57
129.28
564.29
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING GRANTS DONATIONS
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
15
16
17
18
19
20
21
22
Month Name: Month Name: Month Name: April April April April April April
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING MEMBER
SHIPS		 OTHER
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
35
36
37
38
39
40
41
42

Month Name: April-24

Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I
Income
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 100.45 559.33 19.71 0.00 0 0 0.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 0.00 27.28 81.00 0.00 0.00 0.00 0.00 12.31
34
35
36
37
38
39
40
41
42

Sheet

Value Added Tax

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

h

Month No.

8

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25
Month No. Month No. 8
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.

0.00 0.00 0.00 43 44 45

Month No. Month No. 8
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
0.00 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
2416.72
2416.72
1a plus 2a
Sum 10 to 25
September 2023 - August 2024
Payment details
Paid by:-
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2b
30
31
32
33
Checksum
1035.35
1035.35
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
7324.26 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
2416.72 0.00 0.00 96.51 0.00 0.00
1a 2 a 10
11
12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
1035.35 0.00 0.00 77.04 0.00 0.00
1b
8705.63		 2b
0.00		 30
31
32
33
Opening Balance for next month
MOVEMENT
1381.37
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2148.22
Direct Costs
30
0.00
Gross Profit
2148.22
Trading Income minus Direct Costs
Other Income
Interest
19
36.59
R/Grants & Other Income
14.78
18+21
51.37
Total Income
2199.59
Gross Profit + Other Income
Overheads
Sum 31 to 41
856.19
Depreciation
Calculate elsewhere or leave at 0
856.19
Profit (Loss) for the month
1343.40
Total Income minus O'heads & Depreciation
Drawings
42
179.16
1164.24		 Opening Balance for next month
MOVEMENT
1381.37
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2148.22
Direct Costs
30
0.00
Gross Profit
2148.22
Trading Income minus Direct Costs
Other Income
Interest
19
36.59
R/Grants & Other Income
14.78
18+21
51.37
Total Income
2199.59
Gross Profit + Other Income
Overheads
Sum 31 to 41
856.19
Depreciation
Calculate elsewhere or leave at 0
856.19
Profit (Loss) for the month
1343.40
Total Income minus O'heads & Depreciation
Drawings
42
179.16
1164.24		 Opening Balance for next month
MOVEMENT
1381.37
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2148.22
Direct Costs
30
0.00
Gross Profit
2148.22
Trading Income minus Direct Costs
Other Income
Interest
19
36.59
R/Grants & Other Income
14.78
18+21
51.37
Total Income
2199.59
Gross Profit + Other Income
Overheads
Sum 31 to 41
856.19
Depreciation
Calculate elsewhere or leave at 0
856.19
Profit (Loss) for the month
1343.40
Total Income minus O'heads & Depreciation
Drawings
42
179.16
1164.24
2148.22
36.59
14.78
51.37
2199.59
856.19		 51.37
2199.59
856.19
1343.40
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
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
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
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
35
36
37
38
39
40
41
42

Month Name: May-24

Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I
Income
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 0.00 2051.71 14.78 36.59 0 0 0.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 0.00 390.00 389.15 0.00 0.00 0.00 0.00 179.16
34
35
36
37
38
39
40
41
42

Sheet

Value Added Tax

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

h

Month No.

9

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
2.80
6.00
68.41
139.92
217.13 0.00 0.00
23
24
25
Month No. Month No. 9
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
45
Month No. Month No. 9
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
217.13 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
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-----------
CASH
CHEQUE
A/C
A/C
OPENING BALANCE
10830.18
0.00
SPONSORED
FATHERS
Closing Balance last Year
EVENT
DAY
INCOME
5950.61
0.00
0.00
96.51
1a
2a
10
11
SPONSORED
FATHERS
EVENT
DAY
EXPENDITURE
8075.16
0.00
0.00
98.04
1b
2b
30
31
CLOSING BALANCE
8705.63
0.00
Opening Balance for next month
MOVEMENT
-2124.55
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
5608.37
Direct Costs
30
0.00
Gross Profit
5608.37
Trading Income minus Direct Costs
Other Income
Interest
19
63.59
R/Grants & Other Income
61.52
18+21
125.11
Total Income
5733.48
Gross Profit + Other Income
Overheads
Sum 31 to 41
2828.52
Depreciation
Calculate elsewhere or leave at 0
2828.52
Profit (Loss) for the Period
2904.96
Total Income minus O'heads & Depreciation
Drawings
42
246.64
2658.32
CASH
A/C		 CHEQUE
A/C		 Trading Income
10830.18 0.00 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE
5950.61 0.00 0.00 96.51 400.05 14.08 0.00
1a 2a 10
11		 12
13
14
Direct
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE
8075.16 0.00 0.00 98.04 264.51 655.04 0.00
1b
8705.63		 2b
0.00		 30
31		 32
33
34
Changes to Balance Sheet
Assets:
Capital equipment aquired
LESS:
Depreciation on asset
Capital equipment sol
Change in Assets
Liabilities:
VAT due to Customs & Excise
New Outside loans
New Personal loans
LESS:
Loan repaym'ts (ex.In
Change in Liabilities
Accounts:
Movement in Cash account
Movement in Bank account
LESS:
Grants for capital equ
Change in Accounts
Change in Nett worth
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
CIRCUS
 OWN
CLOTHES DAY		 RECYCLING
CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES
0.00 2486.69 2611.04 61.52 63.59 0 0 0.00 217.13 0.00
15
16
17
18		 19
20
21
22
23
24
Analysis ofpayments Indirect costs
(Overheads)
Costs Indirect costs
(Overheads)
DISCOS WONKA SUMMER
CIRCUS
 OWN
CLOTHES DAY		 RECYCLING
CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND
0.00 1340.78 470.15 0.00 0.00 0.00 0.00 246.64 5000.00 0.00
35
36
37
38
44
0.00
ts
as Trading Repor
0.00
ld
24
0.00
-
0.00
0.00
25 minus 45
0.00
23
217.13
22
0.00
ntr'st)
43
5000.00
-
5000.00
s
-4782.87
1c
-2124.55
2c
0.00
uip.
20
0.00
-
0.00
s
-2124.55
2658.32		 39
40
41
42
43
44
Value Added Tax
V.A.T. due to Customs & Excise on sales
25
V.A.T. reclaimable from C&E on expenditure
45
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Sum 10 to 17 plus 21+24
Total value of Purchases (excl. VAT)
Sum 30 to 41 plus 44
Standard Hour Calculation
Billed' hours this Period
Overhead burden
Sum 31 to 42
3075.16
Standard Hour cost
0.00
Overhead Burden divided by Billed hours		 44
25
45
-
0.00
0.00
0.00
217.13
0.00
5000.00
-
5000.00
-4782.87
-2124.55
0.00
0.00
3075.16
0.00
-
0.00
-2124.55
2658.32		 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.

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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
2524.69
2524.69
1a plus 2a
Sum 10 to 25
September 2023 - August 2024
Payment details
Paid by:-
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
2b
30
31
32
33
Checksum
2697.48
2697.48
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
8705.63 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
2524.69 0.00 0.00 386.07 0.00 0.00
1a 2 a 10
11
12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
EXPENDITURE
CLOSING BALANCE
Opening Balance for next month
MOVEMENT
Trading Report
Trading Income
Sum 1
Direct Costs
3
Gross Profit
Trading Income minus Direct Costs
Other Income
Interest
1
R/Grants & Other Income
18+21
Total Income
Gross Profit + Other Income
Overheads
Sum 3
Depreciation
Calculate elsewhere or leave at 0
Profit (Loss) for the month
Total Income minus O'heads & Depreciation
Drawings
4		 2697.48 0.00 0.00 38.73 0.00 124.74
1b
8532.84		 2b

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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
22

Month Name: June-24

Analysis of payments

Direct Costs

Indirect costs

(Overheads) (Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
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
35
36
37
38
39
40
41
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 0.00 1332.40 9.85 0.00 0.00 0.00 100.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 0.00 0.00 2077.87 0.00 0.00 0.00 0.00 250.25
39
40
41
42
Value Added Tax
V.A.T. due to Customs & Excise on sales
V.A.T. reclaimable from C&E on expenditure
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Total value of Purchases (excl. VAT)
Standard Hour Calculation
'Billed' hours this month
Overhead burden
Sum 31 to 42
Standard Hour cost
Overhead Burden divided by Billed hours
Note 1
Errors can occur in spreadsheets.
check the results before acting on
Note 2
The Trading Reports on this page
guidance only. More information is
for a full Profit & Loss Account and
Balance Sheet.
-
0.00
0.00
-5.89
696.37
100.00
200.00
-
200.00
590.48
-172.79
0.00
0.00
-
0.00
-172.79
-763.27

Month No.

10

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

Month No. 10

UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
5.89
200.00
200.00 0.00 5.89
43
44
45
Month No. Month No. 10
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
696.37 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
200.00 0.00 5.89
43
44
45
25
0.00
45
5.89
-5.89
Sum 10 to 17 plus 21+24
1718.47
Sum 30 to 41 plus 44
2241.34		 44
45
25
0.00
45
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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
3621.67
3621.67
1a plus 2a
Sum 10 to 25
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
2b
30
31
32
33

Checksum

10442.07 10442.07 1b plus 2b Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
8532.84 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
3621.67 0.00 0.00 0.00 0.00 0.00
1a 2 a 10
11
12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
10442.07 0.00 0.00 0.00 0.00 0.00
1b 2 b 30
31
32
33
CLOSING BALANCE
1712.44
0.00
Opening Balance for next month
MOVEMENT
-6820.40
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2339.82
Direct Costs
30
0.00
Gross Profit
2339.82
Trading Income minus Direct Costs
Other Income
Interest
19
0.00
R/Grants & Other Income
0.00
18+21
0.00
Total Income
2339.82
Gross Profit + Other Income
Overheads
Sum 31 to 41
250.77
Depreciation
Calculate elsewhere or leave at 0
250.77
Profit (Loss) for the month
2089.05
Total Income minus O'heads & Depreciation
Drawings
42
91.30
1997.75		 CLOSING BALANCE
1712.44
0.00
Opening Balance for next month
MOVEMENT
-6820.40
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2339.82
Direct Costs
30
0.00
Gross Profit
2339.82
Trading Income minus Direct Costs
Other Income
Interest
19
0.00
R/Grants & Other Income
0.00
18+21
0.00
Total Income
2339.82
Gross Profit + Other Income
Overheads
Sum 31 to 41
250.77
Depreciation
Calculate elsewhere or leave at 0
250.77
Profit (Loss) for the month
2089.05
Total Income minus O'heads & Depreciation
Drawings
42
91.30
1997.75		 CLOSING BALANCE
1712.44
0.00
Opening Balance for next month
MOVEMENT
-6820.40
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
2339.82
Direct Costs
30
0.00
Gross Profit
2339.82
Trading Income minus Direct Costs
Other Income
Interest
19
0.00
R/Grants & Other Income
0.00
18+21
0.00
Total Income
2339.82
Gross Profit + Other Income
Overheads
Sum 31 to 41
250.77
Depreciation
Calculate elsewhere or leave at 0
250.77
Profit (Loss) for the month
2089.05
Total Income minus O'heads & Depreciation
Drawings
42
91.30
1997.75
2339.82
0.00
0.00
0.00
2339.82
250.77		 0.00
2339.82
250.77
2089.05
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
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
(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
35
36
37
38
39
40
41
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 0.00 2339.82 0 0.00 0 0 800.00
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 0.00 0.00 250.77 0.00 0.00 0.00 0.00 91.30
34
35
36
37
38
39
40
41
42
Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
481.85
22
800.00
ym'ts (ex.Intr'st)
43
10100.00
-
10100.00
Liabilities
-8818.15
count
1c
-6820.40
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-6820.40
h
1997.75
n Accounts		 Sheet
uired
44
0.00
on on assets
as Trading Report
0.00
uipment sold
24
0.00
-
0.00
Assets
0.00
& Excise
25 minus 45
0.00
23
481.85
22
800.00
ym'ts (ex.Intr'st)
43
10100.00
-
10100.00
Liabilities
-8818.15
count
1c
-6820.40
count
2c
0.00
capital equip.
20
0.00
-
0.00
Accounts
-6820.40
h
1997.75
n Accounts		 Value Added Tax
V.A.T. due to Customs & Excise on sales
V.A.T. reclaimable from C&E on expenditure
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Total value of Purchases (excl. VAT)
Standard Hour Calculation
'Billed' hours this month
Overhead burden
Sum 31 to 42
Standard Hour cost
Overhead Burden divided by Billed hours
Note 1
Errors can occur in spreadsheets.
check the results before acting on
Note 2
The Trading Reports on this page
guidance only. More information is
for a full Profit & Loss Account and
Balance Sheet.
-
0.00
0.00
0.00
481.85
800.00
10100.00
-
10100.00
-8818.15
-6820.40
0.00
0.00
-
0.00
-6820.40
1997.75

h

Month No.

11

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
45.60
5.00
8.10
423.15
481.85 0.00 0.00
23
24
25

----- Start of picture text -----
Month No. 11
UPS CAPITAL V.A.T.
----- End of picture text -----

DONATIONS EXPEND
8700.00
1400.00
10100.00 0.00 0.00
43
44
45

Month No. 11

Month No. Month No. 11
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
481.85 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
10100.00 0.00 0.00
43
44
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
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
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
EXPENDITURE
simplestExample.xls		 1a
2a
10
11
12
13
1526.95
1526.95
1a plus 2a
Sum 10 to 25
September 2023 - August 2024
Payment details
Paid by:-
DAY DETAILS REF
No.		 CASH
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
2 Grove Print & Pack 289.40
TOTALS 289.40 0.00 0.00 0.00 0.00 0.00
1b
2b
30
31
32
33
Checksum
289.4
289.40
1b plus 2b
Sum 30 to 45

TRADING SUMMARY

September 2023 - August 2024

----------------- ----------------- -----------------
CASH
A/C		 CHEQUE
A/C		 Trading
1712.44 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
1526.95 0.00 0.00 0.00 0.00 779.78
1a 2 a 10
11
12
13
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT
289.40 0.00 0.00 0.00 0.00 0.00
1b
2949.99		 2b
0.00		 30
31
32
33
Opening Balance for next month
MOVEMENT
1237.55
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
779.78
Direct Costs
30
0.00
Gross Profit
779.78
Trading Income minus Direct Costs
Other Income
Interest
19
20.80
R/Grants & Other Income
0.00
18+21
20.80
Total Income
800.58
Gross Profit + Other Income
Overheads
Sum 31 to 41
0
Depreciation
Calculate elsewhere or leave at 0
0.00
Profit (Loss) for the month
800.58
Total Income minus O'heads & Depreciation
Drawings
42
289.40
511.18		 Opening Balance for next month
MOVEMENT
1237.55
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
779.78
Direct Costs
30
0.00
Gross Profit
779.78
Trading Income minus Direct Costs
Other Income
Interest
19
20.80
R/Grants & Other Income
0.00
18+21
20.80
Total Income
800.58
Gross Profit + Other Income
Overheads
Sum 31 to 41
0
Depreciation
Calculate elsewhere or leave at 0
0.00
Profit (Loss) for the month
800.58
Total Income minus O'heads & Depreciation
Drawings
42
289.40
511.18		 Opening Balance for next month
MOVEMENT
1237.55
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
779.78
Direct Costs
30
0.00
Gross Profit
779.78
Trading Income minus Direct Costs
Other Income
Interest
19
20.80
R/Grants & Other Income
0.00
18+21
20.80
Total Income
800.58
Gross Profit + Other Income
Overheads
Sum 31 to 41
0
Depreciation
Calculate elsewhere or leave at 0
0.00
Profit (Loss) for the month
800.58
Total Income minus O'heads & Depreciation
Drawings
42
289.40
511.18
779.78
20.80
0.00
20.80
800.58
0		 20.80
800.58
0.00
800.58
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
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
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
15
16
17
18
19
20
21
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
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
289.40
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 289.40
34
35
36
37
38
39
40
41
42

Month Name: August-24

Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I		 Analysis of income
Income
Other I
Income
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D
0.00 0.00 0.00 0.00 0 20.80 0 0 352.50
14
15
16
17
18
19
20
21
22
Analysis ofpayments
Direct Costs Indirect costs
(Overheads)
XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 289.40
34
35
36
37
38
39
40
41
42

Sheet

Value Added Tax

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

h

Month No.

12

ncome ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
289.40
52.40
32.07
373.87 0.00 0.00
23
24
25
Month No. Month No. 12
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.

0.00 0.00 0.00 43 44 45

Month No. Month No. 12
ncome
OTHER
INCOME		 CAPITAL
SALES		 V.A.T.
373.87 0.00 0.00
23
24
25
UPS
DONATIONS		 CAPITAL
EXPEND		 V.A.T.
0.00 0.00 0.00
43
44
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-----------
CASH
CHEQUE
A/C
A/C
OPENING BALANCE
8705.63
0.00
SPONSORED
FATHERS
Closing Balance last Year
EVENT
DAY
INCOME
7673.31
0.00
0.00
386.07
1a
2a
10
11
SPONSORED
FATHERS
EVENT
DAY
EXPENDITURE
13428.95
0.00
0.00
38.73
1b
2b
30
31
CLOSING BALANCE
2949.99
0.00
Opening Balance for next month
MOVEMENT
-5755.64
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
4838.07
Direct Costs
30
0.00
Gross Profit
4838.07
Trading Income minus Direct Costs
Other Income
Interest
19
20.80
R/Grants & Other Income
9.85
18+21
30.65
Total Income
4868.72
Gross Profit + Other Income
Overheads
Sum 31 to 41
2492.11
Depreciation
Calculate elsewhere or leave at 0
2492.11
Profit (Loss) for the Period
2376.61
Total Income minus O'heads & Depreciation
Drawings
42
630.95
1745.66
CASH
A/C		 CHEQUE
A/C		 Trading Income
8705.63 0.00 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE
7673.31 0.00 0.00 386.07 0.00 779.78 0.00
1a 2a 10
11		 12
13
14
Direct
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE
13428.95 0.00 0.00 38.73 0.00 124.74 0.00
1b
2949.99		 2b
0.00		 30
31		 32
33
34
Changes to Balance Sheet
Assets:
Capital equipment aquired
LESS:
Depreciation on asset
Capital equipment sol
Change in Assets
Liabilities:
VAT due to Customs & Excise
New Outside loans
New Personal loans
LESS:
Loan repaym'ts (ex.In
Change in Liabilities
Accounts:
Movement in Cash account
Movement in Bank account
LESS:
Grants for capital equ
Change in Accounts
Change in Nett worth
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
CIRCUS
 OWN
CLOTHES DAY		 RECYCLING
CAULIFLOWER
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
SALES
0.00 0.00 3672.22 9.85 20.80 0 0 1252.50 1552.09 0.00
15
16
17
18		 19
20
21
22
23
24
Analysis ofpayments Indirect costs
(Overheads)
Costs Indirect costs
(Overheads)
DISCOS WONKA SUMMER
CIRCUS
 OWN
CLOTHES DAY		 RECYCLING
CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
EXPEND
0.00 0.00 2328.64 0.00 0.00 0.00 0.00 630.95 10300.00 0.00
35
36
37
38
44
0.00
ts
as Trading Repor
0.00
ld
24
0.00
-
0.00
0.00
25 minus 45
-5.89
23
1552.09
22
1252.50
ntr'st)
43
10300.00
-
10300.00
s
-7501.30
1c
-5755.64
2c
0.00
uip.
20
0.00
-
0.00
s
-5755.64
1745.66		 39
40
41
42
43
44
Value Added Tax
V.A.T. due to Customs & Excise on sales
25
V.A.T. reclaimable from C&E on expenditure
45
Nett amount owed to Customs & Excise
VAT due minus VAT reclaimable
Total value of Sales (excl. VAT)
Sum 10 to 17 plus 21+24
Total value of Purchases (excl. VAT)
Sum 30 to 41 plus 44
Standard Hour Calculation
Billed' hours this Period
Overhead burden
Sum 31 to 42
3123.06
Standard Hour cost
0.00
Overhead Burden divided by Billed hours		 44
25
45
-
0.00
0.00
-5.89
1552.09
1252.50
10300.00
-
10300.00
-7501.30
-5755.64
0.00
0.00
3123.06
0.00
-
0.00
-5755.64
1745.66		 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.

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
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING
FIRST QUARTER
Month
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
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
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
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
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
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
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
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
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
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
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
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
2a
10
11
12
13
14
15
16
17
18
19
Checksum
27727.24
27727.24
1a plus 2a
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
A/C		 CHEQUE
A/C		 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
CLOTHES DAY		 RECYCLING
FIRST QUARTER
Month
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
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
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
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
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
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
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
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
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
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
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
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
2b
30
31
32
33
34
35
36
37
38
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-----------
CASH
CHEQUE
A/C
A/C
OPENING BALANCE
2949.99
0.00
SPONSORED
FATHERS
Closing Balance last Year
EVENT
DAY
INCOME
27727.24
0.00
601.50
482.58
1a
2a
10
11
SPONSORED
FATHERS
EVENT
DAY
EXPENDITURE
27873.22
0.00
0.00
136.77
1b
2b
30
31
CLOSING BALANCE
2804.01
0.00
Opening Balance for next month
MOVEMENT
-145.98
0.00
1c
2c
Trading Report
Trading Income
Sum 10 to 17
20954.17
Direct Costs
30
10741.53
Gross Profit
10212.64
Trading Income minus Direct Costs
Other Income
Interest
19
144.09
R/Grants & Donations
827.92
18+21
972.01
Total Income
11184.65
Gross Profit + Other Income
Overheads
Sum 31 to 41
Depreciation
Calculate elsewhere or leave at 0
0.00
Profit (Loss) for the Period
11184.65
Total Income minus O'heads & Depreciation
Drawings
42		 Analysis of income Analysis of income Analysis of income Analysis of income Analysis of income Analysis of income Analysis of income
CASH
A/C		 CHEQUE
A/C		 Trading Income
2949.99 0.00 SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
11		 12
13
14
15
16
17
18		 19
Analysis ofpayments
Direct Costs
SPONSORED
EVENT		 FATHERS
DAY		 MOTHERS
DAY		 ELFRIDGES
SANTA VISIT		 XMAS
FETE		 DISCOS WONKA SUMMER
CIRCUS		 OWN
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
2804.01		 2b
0.00		 30
31
 32
33
34
35
36
37
38		 39
Changes to Balance Sheet
Assets:
Capital equipment aquired
44
0.00
LESS:
Depreciation on assets
as Trading Repor
0.00
Capital equipment sold
24
0.00
-
0.00
Change in Assets
0.00
Liabilities:
VAT due to Customs & Excise
25 minus 45
-5.89
New Outside loans
23
1850.15
New Personal loans
22
3577.50
LESS:
Loan repaym'ts (ex.Intr'st)
43
16972.80
-
16972.80
Change in Liabilities
-11551.04
Accounts:
Movement in Cash account
1c
-145.98
Movement in Bank account
2c
0.00
LESS:
Grants for capital equip.
20
517.50
-
517.50
Change in Accounts
-663.48
Change in Nett worth
10887.56		 Value Add
V.A.T. due t
V.A.T. recla
Nett amou
VAT due minus V
Total value
Total value
Standard
-
0.00
0.00
-5.89
1850.15
3577.50
16972.80
Billed' hou
Overhead
Standard
Overhead Burden
-
16972.80
-11551.04
-145.98
0.00
517.50
-
517.50
-663.48
10887.56		 Note 1
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
CARDS		 GRANTS DONATIONS
REC'V'D		 OTHER
INCOME		 CAPITAL
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
21
22
23
24
25

© R L Griffin 2000

Page 123

Year 23/24

Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)		 Indirect costs
(Overheads)
Indirect costs
(Overheads)
CAULIFLOWER
CARDS		 MEMBER
SHIPS		 OTHER
EXP'S		 UPS
DONATIONS		 CAPITAL
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
41
42
43
44
45

© R L Griffin 2000

Page 124

Year 23/24

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