Inventory template usage guide:

The inventory Excel template, has 6 tabs: (Products, Stocks, Purchases, Transfers, Adjustments and Locations), a main panel and an extra tab called: Products, Stocks, Purchases, Transfers, Adjustments and Locations., a main panel and an extra tab called: "Support List".. In it, you can edit, if you wish, the list of available sizes for your products, as well as other variants or the reasons for an adjustment and their status.

In each of them, you will find a small user guide, let's see how they work!

1. Inventory Excel main panel

The main panel of the Inventory Excel is the starting point and overview of your business. In this first tab, you will find an overview of all products and their current status in terms of stock, sales and purchases. In addition, the main panel has a product finder, a timetable for your store staff if you want to use it, and a report with the status of your purchases. 

Use it whenever you want to know the location and availability of a particular product and the status of purchases.

Don't waste any more time searching your warehouse for the products you have or how much stock you have left. The "Products" tab in Inventory Excel is your new must-have tool. By adding your products to this section, you will have a complete and detailed list of everything you have in stock. In addition, you will be able to know the characteristics of each item, the quantity available and its value.

3. Stocks 

The "Inventory" tab is a very useful tool to know the status of your inventory in different locations. With this tab you can quickly see the amount of products you have in each of your stores, the amount of products sold and the total inventory. This way, you can be aware at all times of the status of your stock and ensure that you always have enough stock to meet your customers' demand, thus avoiding stock-outs.

To know the status of your stock, you will have to enter the unique code of your products, i.e. the SKU code (Stock Keeping Unit). It is a unique identification assigned to each product in inventory. The main purpose of the SKU code is to allow companies to keep track of their inventory, control sales and order management. 

You will see that once you have added all your products, the Excel template will show you the global view of the number of stock for each of your business locations.

4. Shopping

In the "Purchasing" section, you will be able to register all the order requests to your suppliers, together with the status of the order, the date of the order, the number of products and the warehouse/store where the goods will arrive. 

Knowing when shipments are expected will allow you to plan and prepare for the arrival of new products. In addition, with the information stored in this tab, you will be able to keep complete track of all transactions with your suppliers, know the status of your purchases and have a more exhaustive control of your inventory.

All you have to do is add the SKU code of your product and fill in the different columns with the data of your purchases that we mentioned before: The date of purchase, the supplier and the number of products ordered, for example. You can also add notes or comments that you need to remember.

In addition, thanks to the alerts we have configured, you will be able to keep your inventory excel updated at all times. Column I" will tell you if you have already added your items in the "Products" tab, in case you forget to do so, and "Column K" will remind you if you have pending tasks and actions.

5. Transfers

The "Transfers" tab, will help you manage your inventory movements between the different locations of your company. First, make sure you have a complete list of all the locations where you keep your inventory. Once you have registered them in the "Locations" tab, you will be able to select the source location and the destination location for each transfer.

Next, in column (B) you must specify the unique SKU of the product you want to transfer from one location to another. You will have to fill in all the columns with their respective data. Once you have added all the necessary information, you will be able to modify the status of the transfer and in column (J) you will be able to record when you have updated this movement.

Check the Alerts column to see if you have updated all stock movements! 

6. Adjustments

The "Adjustments" section of the inventory Excel is important because it gives you the ability to record and track any unexpected movements in your stock that do not correspond to purchases, sales or transfers between locations. For example, product loss or theft. 

Noting these changes in your stock will help you to keep an accurate control of the stock you have.

To do so, you will have to add the product code, the reason for the adjustment and the user who is responsible for the follow-up (in case you assign a specific person to be responsible). 

Do not forget to check the box (I) once you have updated the corresponding changes in the "stock" tab.

7. Locations

This tab allows you to keep track of the locations where you store your inventory. To add a new location, simply follow these steps:

First, select a name for your location and enter it in column (B). It can be the name of your store, or a numbering: "Store 1". You can customize the name according to your needs and delete the default examples.

Then, in column (C), select the type of location you want to add. You can choose from options such as store, showroom or warehouse.

Next, in columns (D) through (H), you can add additional location information such as address, city, zip code, country and phone number. These fields are optional, but providing accurate information can be helpful when managing your shipments and inventory transfers.

We have something much better for you: try our inventory management software Stockagile.

Inventory management is a crucial aspect of any business and can be a challenging task without the right tools. Although managing your inventory through an Excel template like this one is much more effective than doing it manually, there is always room for improvement. That's why we recommend you explore the solutions offered by our inventory and sales management software Stockagile, which will allow you to automate processes, control stock and track your sales. And all from one place.