Choose which type of inventory spreadsheet is a better fit for you, based on the size and needs of your business and hit download!
Input details of all your inventory into the template to get clear visibility of your stock position. You might find it useful to read our guide to inventory management to help get you started.
Open a TransferWise for Business account and when it comes to paying international suppliers, use their local currency to save on exchange rate fees.
If you run a small business or ecommerce store, you can probably meet your inventory management needs with our basic Excel inventory list template.
Use it to track raw materials and products by quantity and unit price. You’ll also find some handy formulas to help you keep track of inventory value per item and when you need to reorder stock.
If you run a more complex business or a large ecommerce store, you might need a more comprehensive inventory management template. In this case, choose our Excel inventory management template.
This template has all the features of the basic template, plus an extra tab to help you manage all your vendor information in one place.
Check out the glossary of terms, below, to help you get more from our free excel inventory template with formulas.
Prefer working in Google Sheets? Check out our Google Sheets inventory templates.
Managing your inventory properly is a great way to save money and boost your profit margin.
Save even more if you’re buying inventory from overseas by using TransferWise for Business to pay international suppliers.
Hold 50+ currencies, get local bank account details for fee free international payments in major currencies, and convert your money at the mid-market exchange rate, avoiding sneaky mark-up fees charged by some traditional banks.
Sign up now and do business without borders.
Here are the key features and formulas we’ve used, to help you make the most of your inventory spreadsheet.
When an item reaches its minimum stock quantity, it’ll automatically flag up in the reorder auto fill column to let you know you need to know more.
See the full value of your inventory at a glance. This column multiplies stock quantity and item cost to give you the total value of your inventory of that product.
Keep your customers happy by never running out of key lines. Set your chosen minimum stock quantity, and when your inventory hits that level, you’ll get an alert in the reorder column.
Input product lead time so you know how many days it’ll take between ordering your stock and it arriving.
Keep a record of the number of items to reorder when the quantity of that product left in stock falls below the chosen reorder level.
Inventory management is an important part of the supply chain process.
Good inventory management processes help your business order the correct amount of stock, cut the costs of storing excess products, keep key lines on sale and ensure order fulfilment.
Grow your business and increase your profits by connecting with customers and suppliers all over the world.