Inventory_Management_Excel_Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
INVENTORY MANAGEMENT WORKBOOK
3
How to use this template
4
The only inventory management software your business needs
5
Efficient Inventory Management is the backbone to any business that buys and sells products. This template will help you with basic inventory management. To understand basic inventory management principles, read our ebook - Inventory Management: Getting Started
6
Products
7
8
Enter the details of your products in the Products sheet.
9
Enter a suitable name that describes the product.
10
For advice on defining your SKUs, click here
11
Original Stock Level: Enter the original stock of each product at the point of time when you start to use this spreadsheet. This is important in order for the spreadsheet to maintain an accurate running total of the stock level.
12
Reorder Point: Enter the stock level at which you reorder a fresh shipment of the product. To learn how to determine reorder points for your products, click here.
13
Enter the Cost Price as the price at which you buy the product from your supplier. If needed, you can overwrite this value for specific cases on the Purchases sheet.
14
Enter the Markup value for the product to decide the price at which you sell the product to your customers. If needed, you can overwrite this value for specific cases on the Sales sheet.
15
“Orders waiting to be fulfilled” are automatically calculated from the Sales sheet. This calculates the number of Sales Orders placed for a specific SKU which are yet to be fulfilled.
16
“Stock waiting to be received” is automatically calculated from the Purchase sheet. It calculates the quantity of Purchase Orders for a specific SKU that have not arrived yet.
17
“Stock on hand” is automatically calculated by adding the Purchase Orders and subtracting Sales Orders from the Original Stock Levels. If this value drops below the Reorder Point, the cell will turn red.
18
19
Purchases
20
21
Enter the details of your purchases in the Purchases sheet.
22
If the arrival date isn’t confirmed, leave it blank so that the spreadsheet can count the order under “Stock waiting to be received”.
23
The Unit Price is set as the Cost Price from the Products sheet, but if necessary, you can overwrite this with a different price.
24
The Amount is calculated automatically
25
26
Sales
27
28
Enter the details of your Sales Orders in the Sales sheet.
29
If you have yet to send out the Sales Order, leave the Sent Date blank so that the spreadsheet can count the order under “Orders waiting to be fulfilled”.
30
The Unit Price is set at the Retail Price from the Products sheet, but if necessary, you can overwrite this with a different price.
31
The Amount is calculated automatically
32
33
Report
34
35
Report on values from the Products, Purchases, and Sales tabs.
36
Use the dropdown menu to select the Product Name and Year in order to filter accordingly. If you prefer to view your total sales, purchases, and purchases from suppliers across all products without any specific time frames, please select (ALL).
37
38
Export to TradeGecko
39
40
Start a free trial of TradeGecko, or sign in to your existing account.
41
Go to File > Save As > and choose .csv as your file type
Log in to your TradeGecko account and under Inventory > Products > choose the “Import Products’ option.
This Excel is already formatted for easy upload.
42
Log in to your TradeGecko account and under Inventory > Products > choose the “Import Products’ option.
43
This Excel is already formatted for easy upload.
44
45
Is this sheet getting messy and out of control? Try TradeGecko for free and say goodbye to spreadsheets!
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
Loading...