Inventory Tracking Excel Template - Multiple Locations
Originally published: 01/03/2018 10:00
Last version published: 04/03/2019 07:47
Publication number: ELQ-40428-8
View all versions & Certificate

Inventory Tracking Excel Template - Multiple Locations

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

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.

An SKU is a Stock Keeping Unit. Usually in the form of a bar code, an identification number is attached to a product in a shop in order to track and price it. They do not actually have to be physically attached to the physical good. They increase the efficiency of the supply chain and logistics for a business.

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 sku 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. The video has bookmarks enabled to allow the user to save the most important parts of the tutorial.

This Best Practice includes
1 Excel template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks


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.


  • Rate this Downloadable Best Practice

    Write a review

  • Brian Evans(last updated: 06/03/2019 21:46)


More Best Practices from Jason Varner

See all

Discussion feed for Inventory Tracking Excel Template - Multiple Locations

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

  • Werner Dercksen
    I’ve recently been employed as a regional Logistics and Rental fleet manager looking after approximately 600 machines. My previous roles were very simple compared to the very complex task at hand, the units are spread over 5 branches and have multiple departments requesting movement in the designated area as well as external movements across the country. Because of the commitment put in place to deliver exceptional service the logistical overheads are out of control ons needs a live platform for multiple users to direct requests fir movements well ahead of time. I’m very interested to know if this platform can provide the accuracy and simplicity I’m after?
    arrow_drop_uparrow_drop_downReply reply
    • Jason Varner
      It may. Some custom work may be required. Review the video to fully understand.
      arrow_drop_uparrow_drop_downReply reply

    5.0 / 5 (1 votes)

    please wait...