Sign Up, Its Free

Join our Affiliate Program by simply copying the link of our products on your site and earn affiliate commission on every sale

Are you a Marketing expert, having some strategic tools? Come and Join as our Vendor

If you are a Vendor looking to sell tools in any specific category which is not present at the moment on our platform, for instance, say "Branding and Strategy." Simply, email us along with one of your sample business tools on "[email protected]" and we will add the same after verifying.

We have our showcased inventory as well so that the upcoming vendors can view the quality of business tools we are looking for.

What's New

Inventory Tracking in Excel: Warehouse + Up to 499 Locations / 500 SKUs

Type of Business :

Financial Models

Price : USD 75 75.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    Inventory tracking can be difficult, especially if you are operating out of a primary warehouse that ships things to various locations and then those locations actually sell the inventory. This Accounting tool is a great way to keep track of up to 500 SKUs for up to 500 different jobs sites, including the total value of each SKU in inventory and the average cost per unit.

  • Full Description

    This tracker uses a data entry macro system that lets the user enter each transaction and push it to the database tab. The database tab can then be queried and formulas are used to report the amount of units at each location as well as the movements that happen in each location per month. There are also individual reporting features that let the user define a given SKU and see all movements for that particular item and the stock level per location. Note, if you want to automate more of the input card for what kind of data is entered, you can set up vlookups based on other data about each SKU, for example the cost per unit.

  • Table of Content
    No. Content
    1 1
  • Reviews

    No Review. Write a review and be the first.

Related Products