Equipment & Asset Tracking Template

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1

2	ASSET TRACKING TEMPLATE
3	TOTAL ASSET INVENTORY VALUE
4	$774.00			*Based upon TOTAL VALUE fields, below.
5
6	ASSET				LOCATION		PURCHASE				QUANTITY / VALUE				ASSET INFORMATION
7	ITEM NO.	NAME	DESCRIPTION	TYPE	DEPARTMENT	LOCATION ITEM STORED	DATE OF LAST ORDER	VENDOR	PURCHASE PRICE PER ITEM	WARRANTY EXPIRY DATE	CONDITION	QUANTITY	ASSET VALUE	TOTAL VALUE	MODEL	VENDOR NO.	REMARKS	PHOTOGRAPH / LINK
8	4321	Asset Name	Description of Asset	Asset Type	Department	Room 101	MM/DD/YY	Vendor Name	$35.00	MM/DD/YY	FAIR	17	$30.00	$510.00	Asset Model	3456
9	1234	Asset Two	Description of Asset Two	Asste Two Type	Department	Room 202	MM/DD/YY	Vendor Name	$0.00	MM/DD/YY	BAD	12	$22.00	$264.00	Asset Model	7896
10									$0.00		GOOD			$0.00
11									$0.00		POOR			$0.00
12									$0.00		GOOD			$0.00
13									$0.00		FAIR			$0.00
14											FAIR			$0.00
15											GOOD			$0.00
16											GOOD			$0.00
17											GOOD			$0.00
18											GOOD			$0.00
19											GOOD			$0.00
20											GOOD			$0.00
21											GOOD			$0.00
22											GOOD			$0.00
23											GOOD			$0.00
24											GOOD			$0.00
25											GOOD			$0.00
26											GOOD			$0.00
27											GOOD			$0.00
28											GOOD			$0.00
29											GOOD			$0.00
30											GOOD			$0.00
31											GOOD			$0.00
32											GOOD			$0.00
33											GOOD			$0.00
34											GOOD			$0.00
35											GOOD			$0.00
36
37	CLICK HERE TO CREATE IN SMARTSHEET
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