Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
  • Inventory Tracking Excel Template - Multiple Locations
Originally published: 01/03/2018 10:00
Last version published: 28/03/2018 17:24
Publication number: ELQ-40428-5
View all versions & Certificate
certified

Inventory Tracking Excel Template - Multiple Locations

Manage inventory that moves back and forth between multiple locations (up to 21).

inventory managementinventory trackingmultiple locationssku tracking

Description
This tool allows one to track how various inventory sku's move in and out of different locations. It uses an input card to enter transactions. Each transaction represents a move of one item to another location.

The database stores all entries.

You can query on a per sku basis to see how much of each inventory item is at each location and the full record of that sku.

Macros are used to enter the data and query a given sku.

More summaries include a detailed list of every location and how much of each skus is at each location. There is also a monthly summary that shows the net move of each sku per month by location.

Instructions are included in the inventory management excel template and a tutorial video is available.

This business tool includes
1 Excel template and 1 tutorial video

Acquire business license for $55.00

Add to cart

Add to bookmarks

Discuss

Further information

See the level of inventory amongst multiple locations.

Tracking multiple skus across multiple locations.

Situations where there are more than 21 locations to track.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Inventory Tracking Excel Template - Multiple Locations?

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

please wait...