Tracking inventory is a big task. Here is a file, using this excel file you can create Items.

Update inword and outwords and check the inventory balances.

The file is very simple and useable.

With help of this file you can:

  1. Create new item
  2. Enter inventory inword or purchase details
  3. Enter Stock outword or sale details
  4. Track total inwords and outword of stock
  5. Track closing balance of each stock item

Advantages of using this file are:

  1. No need to install any software, its made in excel
  2. No need to have any accounting knowledge
  3. Plug and play, have it in pandrive and use it whenever wanted

You can download the simple inventory management file in excel from this link 

Posted 4 years ago by Rahul Rai

Thanks for uploading the file. The file was created after a trader requirements.

If you want any other features to be added please write on this forum.

Posted 4 years ago by CA Pulkit Sharma

Your Reply:

You need to be logged in to reply.