Project Cost Tracking Time Template

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	#	Date	Employee Name	Job Description	Job Code	Project	Client Name	Hours	Cost/Hour	Total Cost	Billable	Billing Rate	Billable
2	1	6 October 2020	John Doe	Creative Design for website	DES	Ecommerece Marketplace	ABC Media	5:30	$10.00	$55.00	YES	$15.00	$82.50
3	2	1 October 2020	Karen H	Marketing	MAR	Webiste Update	T Comm	1:00	$5.00	$5.00	YES	$10.00	$10.00
4	3	25 September 2020	Karen H	Marketing	MAR	Webiste Update	T Comm	1:00	$12.00	$12.00	YES	$15.00	$15.00
5	4	25 September 2020	Alfred A	Customer Support	SUP	Cart Implementation	T Comm	2:45	$25.00	$68.75	YES	$50.00	$137.50
6	5	6 October 2020	Alfred A	Customer Support	SUP	Ecommerece Marketplace	Starlight	3:25	$25.00	$85.42	YES	$50.00	$170.83
7	6	3 October 2020	John Doe	Creative Design for website	DES	Cart Implementation	ABC Media	0:25	$10.00	$4.17	NO	$12.00	$5.00
8	7	25 September 2020	Alfred A	Customer Support	SUP	Cart Implementation	T Comm	6:00	$10.00	$60.00	YES	$12.00	$72.00
9	8	3 October 2020	Alfred A	Customer Support	SUP	Cart Implementation	Starlight	5:30	$5.00	$27.50	YES	$10.00	$55.00
10	9	6 October 2020	Karen H	Marketing	MAR	Ecommerece Marketplace	Starlight	1:00	$5.00	$5.00	YES	$7.00	$7.00
11	10	3 October 2020	John Doe	Creative Design for website	DES	Webiste Update	ABC Media	1:00	$5.00	$5.00	YES	$7.00	$7.00
12	11	25 September 2020	Alfred A	Customer Support	SUP	Cart Implementation	Starlight	2:45	$10.00	$27.50	NO	$15.00	$41.25
13	12	3 October 2020	Karen H	Marketing	MAR	Cart Implementation	Starlight	3:25	$10.00	$34.17	YES	$10.00	$34.17
14	13	6 October 2020	Alfred A	Customer Support	SUP	Webiste Update	Starlight	0:25	$5.00	$2.08	YES	$15.00	$6.25
15	14	3 October 2020	John Doe	Creative Design for website	DES	Ecommerece Marketplace	ABC Media	6:00	$12.00	$72.00	YES	$50.00	$300.00
16	15	25 September 2020	Alfred A	Customer Support	SUP	Cart Implementation	Starlight	5:30	$25.00	$137.50	YES	$50.00	$275.00
17	16	10 October 2020	Karen H	Marketing	MAR	Cart Implementation	T Comm	1:00	$25.00	$25.00	YES	$12.00	$12.00
18	17	3 October 2020	Pauline C	Development	DEV	Webiste Update	Starlight	1:00	$10.00	$10.00	NO	$12.00	$12.00
19	18	10 October 2020	John Doe	Creative Design for website	DES	Cart Implementation	Starlight	2:45	$10.00	$27.50	YES	$10.00	$27.50
20	19	3 October 2020	Pauline C	Development	DEV	Ecommerece Marketplace	ABC Media	3:25	$5.00	$17.08	YES	$7.00	$23.92
21	20	10 October 2020	Alfred A	Customer Support	SUP	Cart Implementation	Stark Industries	0:25	$5.00	$2.08	YES	$7.00	$2.92
22	21	3 October 2020	Karen H	Marketing	MAR	Webiste Update	T Comm	6:00	$5.00	$30.00	YES	$15.00	$90.00
23	22	3 October 2020	Alfred A	Customer Support	DEV	Cart Implementation	Stark Industries	5:30	$10.00	$55.00	NO	$10.00	$55.00
24	23	3 October 2020	John Doe	Creative Design for website	DES	Ecommerece Marketplace	Stark Industries	1:00	$10.00	$10.00	YES	$15.00	$15.00
25	24	10 October 2020	Pauline C	Development	DEV	Webiste Update	ABC Media	1:00	$5.00	$5.00	YES	$50.00	$50.00
26	25	10 October 2020	Alfred A	Customer Support	SUP	Cart Implementation	Stark Industries	2:45	$12.00	$33.00	YES	$50.00	$137.50
27	26	10 October 2020	Karen H	Marketing	MAR	Ecommerece Marketplace	T Comm	3:25	$25.00	$85.42	YES	$12.00	$41.00
28
29
30
31
32
33
34
35
36
37
38
39
40
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