Simple In/Out Inventory Management Excel Template  - 1 Location -
  • Simple In/Out Inventory Management Excel Template  - 1 Location -
  • Simple In/Out Inventory Management Excel Template  - 1 Location -
  • Simple In/Out Inventory Management Excel Template  - 1 Location -
  • Simple In/Out Inventory Management Excel Template  - 1 Location -
  • Simple In/Out Inventory Management Excel Template  - 1 Location -
  • Simple In/Out Inventory Management Excel Template  - 1 Location -
Originally published: 01/03/2018 10:00
Last version published: 12/10/2018 09:59
Publication number: ELQ-60512-7
View all versions & Certificate
certified

Simple In/Out Inventory Management Excel Template - 1 Location -

This excel model will help you track the quantity and value of your inventory.

inventory managementinventory templatesimpletrack inventory

Description
The layout was designed to be as simple and easy to use as possible. You will have a primary tab called 'current state' where you list all the unique sku's / descriptions and any meta-data for your inventory items.

An SKU is a Stock Keeping Unit. Usually in the form of a bar code, an identification number is attached in order to track the location of a product. However, it does not have to be attached physically to the product. This aids with the logisitics and supply chain of goods.

There are then two tabs on either side (in and out). The in tab is to enter new inventory into your system and the out tab is to remove it. Each row will act as a transaction that updates the 'current state' of your inventory.

The quantity and $ value of your current inventory will be displayed on a per sku level as well as an aggregate.

A monthly count and $ change of inventory by date has also been added if you so choose to see such information, but those tabs can be deleted if you want to simply see the in/out and 'current state' tabs.

An instructional video is available for this Excel Inventory Management Template.

This business tool includes
1 Excel template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

Track and report the inventory levels of a single location.

A system where inventory is going and coming from 1 location.

When there is inventory being held at multiple locations.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Simple In/Out Inventory Management Excel Template - 1 Location -?

The user community and author are here to help. Go ahead!

please wait...