Description

Inventory Management Excel Spreadsheet Template

Register your suppliers and employees, record all the inflows and outflows of your inventory per distribution center used (when you have more than one inventory location) and have full control of your inventory, do product-specific reviews, and view ready-made dashboards showing the relevance of the main products of your stock!

Registration of Products, Suppliers and Professionals

In the first part of the worksheet you will enter important information about your Inventory. Therefore, you will first register the products used (up to 1000 products), suppliers (up to 2000 suppliers) and professionals (up to 200 professionals).

Distribution Centers and Storage Locations Register

Spreadsheet also allows you to register distribution centers (when you have more than one stock in different physical locations) and storage locations in a specific stock, so you centralize information from different locations.

Input and Output Movement in Stock

In the second part of the Worksheet you will be able to post entries and exits of items from your Inventory

General Inventory

To have a well-done inventory control, it is essential to check inventory to know the degree of accuracy of the information registered.

Distribution Centers Inventory

In addition to the general inventory that centralizes information from all the different distribution centers and inventory you control, it is also important to analyze each of these storage centers.

General Stock Report

Analyze month by month the entries and exits and see the consolidated result of how many products / materials you have registered in your inventory, the total amount of items and their market value.

Individual Analysis

You can also analyze individually the item that makes up your stock and the key information related to it as quantity in stock, what the status of that item is, the entries of entries and exits and the turnover of inventory, for example.

Stock Dashboard

Spreadsheet also comes as a dashboard (dashboard) where you can analyze key indicators and graphs related to your stock

Dashboard by Product

Choose a product and see key information, indicators and charts related to it.

Product Relevance Dashboard

Spreadsheet also has a control panel that automatically calculates the most relevant products from your stock

Inventory Management Excel Spreadsheet Template
average rating 4.7 out of 5
Based on 3 reviews
  • 5 Stars
    2 Reviews
  • 4 Stars
    1 Review
  • 3 Stars
    0 Reviews
  • 2 Stars
    0 Reviews
  • 1 Star
    0 Reviews
100% of reviewers would recommend this product to a friend
3 Reviews
Reviewed by Herbety Lima L., from Brazil
Verified Buyer
I recommend this product
Rated 5 out of 5
Review posted

Planilha de Controle de Inventário em EXCEL 4.0

planilha é ótima. Esta me ajudando muito diariamente no meu trabalho.

apenas um observação.

Quero muito excluir a aba de instruções ( Sugestões e sobre a LUZ )... Não estou precisando usar-los.Como faço pra excluir????

No demais é ótima e de fácil manuseio.

Parabéns e continuem inovando.

Loading...
Was this helpful?
Reviewed by ROBERTO M S.
Verified Buyer
I recommend this product
Rated 5 out of 5
Review posted

PLANILHA DE CONTROLE DE PATRIMONIO

ATENDE AO QUE FOI PROPOSTO PARA UTILIZAÇÃO. PARA PEQUENAS E MÉDIAS EMPRESAS.

Loading...
Was this helpful?
Reviewed by Edinelson Gois dos S.
I recommend this product
Rated 4 out of 5
Review posted

Ótimo para controle de Inventário

Ainda não pude preenchê-la totalmente mas até o momento foi bem útil.......................................................................................

Loading...
Was this helpful?
Download Free Trial Version

Product Specs:

  • License to 3 Computers
  • 100% Editable File
  • Immediate Access
  • Works on MAC and PC
  • All Excel Versions
  • Premium Support
  • Over 30.000 satisfied customers