If you’ve looked at templates and found that they don’t quite meet your company’s inventory needs, you can create your own sheet. By customizing your sheet, you ensure that you capture all the data you need in one accessible document. Follow these steps to create your own inventory card.
Here’s how to create your own inventory card in just four steps:
Step 1. Open a spreadsheet
You can use any spreadsheet you like. Common spreadsheets are Microsoft Excel, Google Sheets and Numbers. If more than one person needs to access the spreadsheet, make sure all permissions are granted and access is allowed.
Step 2. Name your titles
This gives you the information you will collect about each item in inventory. Feel free to use templates to create the headers you want to use.
Common headers include:
- Item name
- SKU number
- Unit price
- Number in stock
- Sale price
- Minimum purchase quantity
- Command time
- Discontinued item
Step 3. Enter basic item information
You create your own template which should contain all the item information. The only columns that change on a regular basis are the unit or sales price and the number in stock. You may also need to adjust the sheet if an item is discontinued. This step is time consuming but necessary whether or not you use a template or create your own sheet.
Step 4. Save your work
Be sure to save your work and name the file as an inventory template so you can access it regularly when you need to take inventory. When you do, make a copy of the file and rename it to a filename that includes the inventory date. For example, you can take a monthly inventory and optionally name the file “August 2022 Inventory” for easy reference.