KORONA POS Free Inventory Spreadsheet Template

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Period ending:
3	Bar or room:
4
5	Counted by:
6	Item ID	Item Name	Category	Supplier	Purchase Date	Purchase Price	Selling Price	Quantity in Stock	Reorder Level	Reorder Status	Quantity on Order	Total Value	Location	Barcode	Notes
7	001	Item A	Gadgets	Supplier X	1/2/2023	$10.00	$15.00	100	20	Stock OK	10	$1,000.00	Aisle 1	123456789012	Seasonal Item
8	002	Item B	Gadgets	Supplier Y	2/5/2023	$15.00	$20.00	150	30	Stock OK	15	$2,250.00	Aisle 2	246802468024	Best Seller
9	003	Item C	Accessories	Supplier Z	4/8/2024	$8.00	$10.00	200	50	Stock OK	20	$1,600.00	Aisle 3	612182430364	Slow Moving
10										Reorder		$0.00
11										Reorder		$0.00
12										Reorder		$0.00
13										Reorder		$0.00
14										Reorder		$0.00
15										Reorder		$0.00
16										Reorder		$0.00
17										Reorder		$0.00
18										Reorder		$0.00
19										Reorder		$0.00
20										Reorder		$0.00
21										Reorder		$0.00
22										Reorder		$0.00
23										Reorder		$0.00
24										Reorder		$0.00
25										Reorder		$0.00
26										Reorder		$0.00
27										Reorder		$0.00
28										Reorder		$0.00
29										Reorder		$0.00
30										Reorder		$0.00
31										Reorder		$0.00
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