Copy of Business Success Dashboard

	A	C	F	H	J	K	M	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AI	AK	AL
1		Business Success Dashboard.
2
3		Profit after tax todate: £ 46563.72		Sales todate: £ 87996				Date, time		Turnover	Gross Profit	Operating Profit	Profit After Tax	Retained earnings	Cost of Sales	Admin Expenses	Corp TAX	Dividend taken	PAYE / NIC and Tax	Pension Payments	Sales VAT	Input Vat Claimed	Vat to pay	For data validation	May	£12,284.46
4								May		£19,919.00	£19,042.00	£15,166.00	£12,284.46	£10,634.46	£877.00	£3,876.00	£2,881.54	£1,650.00	£329.00	£139.00	£3,983.80	£401.00	£3,582.80		June	£7,059.96
5	Choose Month			Performace in : May		Taxes to be paid: May		June		£16,272.00	£14,021.00	£8,716.00	£7,059.96	£5,059.96	£2,251.00	£5,305.00	£1,656.04	£2,000.00	£397.54	£153.76	£3,254.00	£1,505.00	£1,749.00	Turnover	July	£12,249.63
6	May							July		£20,847.00	£20,050.00	£15,123.00	£12,249.63	£9,299.63	£797.00	£4,927.00	£2,873.37	£2,950.00	£405.84	£155.58	£4,169.40	£668.00	£3,501.40	Gross Profit	August	£9,401.67
7				Revenue	£19,919	VAT	£3,583	August		£20,227.00	£17,959.00	£11,607.00	£9,401.67	£4,301.67	£2,268.00	£6,352.00	£2,205.33	£5,100.00	£592.81	£196.51	£4,045.00	£704.00	£3,341.00	Operating Profit	September	£5,568.00
8				Gross Profit	£19,042	Corporation Tax	£2,882	September		£10,731.00	£179.00	£10,552.00	£5,568.00	£4,984.00	£946.96	£4,037.04	£3,200.00	£837.04	£2,146.00	£399.00	£1,747.00	£482.02	£172.24	Profit After Tax	October
9				Admin expenses	£3,876	NIC	£329	October																Retained earnings	November
10				Profit after tax	£12,284	PAYE	£329	November																Cost of Sales	December
11						Pension	£139	December																Admin Expenses	January
12								January																Corp TAX	Feburary
13						Total	£7,261	Feburary																Dividend taken	March
14								March																PAYE / NIC and Tax	April
15								April																Pension Payments	Year to date	£46,563.72
16								Year to date		£87,996.00	£71,251.00	£61,164.00	£46,563.72	£34,279.72	£7,139.96	£24,497.04	£12,816.28	£12,537.04	£3,871.19	£1,043.85	£17,199.20	£3,760.02	£12,346.44	Sales VAT
17																								Input Vat Claimed
18																								Vat to pay
19			Profit After Tax
20	Choose Metric
21	Profit After Tax
22									Monthly Summary	Turnover	Gross Profit	Operating Profit	Profit After Tax	Retained earnings	Cost of Sales	Admin Expenses	Corp TAX	Dividend taken	PAYE / NIC and Tax	Pension Payments	Sales VAT	Input Vat Claimed	Vat to pay
23									May	£19,919.00	£19,042.00	£15,166.00	£12,284.46	£10,634.46	£877.00	£3,876.00	£2,881.54	£1,650.00	£329.00	£139.00	£3,983.80	£401.00	£3,582.80
24										£16,272.00	£14,021.00	£8,716.00	£7,059.96	£5,059.96	£2,251.00	£5,305.00	£1,656.04	£2,000.00	£397.54	£153.76	£3,254.00	£1,505.00	£1,749.00
25									Target Total Sales
26
27
28
29
30
31
32
33
34
35
36
37
38
39	Created by John Olivant at www.rule29.co.uk
40	© Rule 29 Ltd 2021
41
42
43
44
45
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