Profit-loss-over-50k-2.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2
3	PROFIT & LOSS TEMPLATE: TURNOVER ABOVE £50,000
4	Proﬁt and Loss for the Year ended 2020	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	YTD
5
6	Sales	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	90,000
7	Other business income	100	100	100	100	100	100	100	100	100	100	100	100	0
8
9														1200
10	Total turnover	7,600	7,600	7,600	7,600	7,600	7,600	7,600	7,600	7,600	7,600	7,600	7,600	91,200
11	Cost of goods bought for resale or goods used	3,000	2,000	4,000	3,000	5,000	6,000	7,000	8,000	9,000	4,000	2,000	2,000	0 55,000
12	Total cost of sales	3,000	2,000	4,000	3,000	5,000	6,000	7,000	8,000	9,000	4,000	2,000	2,000	55,000
13														0
14	Gross Proﬁt	4,600	5,600	3,600	4,600	2,600	1,600	600	400	1,400	3,600	5,600	5,600	36,200
15	Car, van and travel expense	400	400	400	400	400	400	400	400	400	400	400	400	0
16	Car, van and travel expense	400	400	400	400	400	400	400	400	400	400	400	400	4800
17														0
18	Wages, salaries and other staﬀ costs	120	120	120	120	120	120	120	120	120	120	120	120	1440
19														0
20	Payments to subcontractors	240	240	240	240	240	240	240	240	240	240	240	240	2880
21														0
22	Rent, rates, power and insurance costs	100	100	100	100	100	100	100	100	100	100	100	100	1200
23														0
24	Repairs and renewals of property and equipment	100	100	100	100	100	100	100	100	100	100	100	100	1200
25														0
26	Phone, fax, stationery and other oﬃce costs	100	100	100	100	100	100	100	100	100	100	100	100	1200
27														0
28	Advertising and business entertainment costs	100	100	100	100	100	100	100	100	100	100	100	100	1200
29														0
30	Interest on banks and other loans	5	5	5	5	5	5	5	5	5	5	5	5	60
31														0
32	Bank, credit card and other ﬁnancial charges	10	10	10	10	10	10	10	10	10	10	10	10	120
33														0
34	Irrecoverable debts wri[en oﬀ	10	10	10	10	10	10	10	10	10	10	10	10	120
35														0
36	Accountancy, legal and other professional fees													0
37														0
38	DepreciaUon and loss/proﬁt on sales of assets	300	200	200	200	200	200	200	200	200	200	200	200	2,500
39														0
40	Other business expenses		100	100	150	150	150	150	150	150	150	150	150	1550
41	Other business expenses		100	100	150	150	150	150	150	150	150	150	150	0
42	Total expenses	1,485	1,485	1,485	1,535	1,535	1,535	1,535	1,535	1,535	1,535	1,535	1,535	18,270
43														0 0
44	Net proﬁt/(loss)	3,115	4,115	2,115	3,065	1,065	65	2,135	1,935	2,935	2,065	4,065	4,065	17,930
45	Month 1= Start of the reportng period, normally the start of the trading.
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100