Inventory Management

17.00 €
35.00 €
Excel course/files short description

3D Excel small inventory management template

Excel course/files description


Manage your small inventory in Excel, update it, and use that data to track small equipment, packaging, tools, and other items; from the point of purchase to their depreciation.

Determine the inventory number, depreciation rate, group of small inventory, and form.

Track the inventory by projects and cost centers (by responsible persons and departments), record releases from the stock and available items in the stock.

The template includes the following  functionalities:

  • List of receipts, issues, and stocks of small inventory in quantity and value,
  • List small inventory by suppliers, projects, cost centers,
  • List small inventory by accounts and account groups,
  • Monitor small inventory by unspecified fixed asset and by material,
  • Monitor depreciation by the months/year of purchase,
  • Calculation of the number of depreciation years.


You can create also your own reports.

YOU WILL GET THE FOLLOWING FILES IN ZIP FORMAT:
Excel Files are in English and Slovenian language.

Eng:
Small Inventory Management.xlsm

Slo:
Drobni inventar.xlsm

Recommended:  for users who want to make their work with Microsoft Excel easier and better 
For: Microsoft Excel 2016, 2019, 2021, and  Microsoft Office 365.