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:
- Create new item
- Enter inventory inword or purchase details
- Enter Stock outword or sale details
- Track total inwords and outword of stock
- Track closing balance of each stock item
Advantages of using this file are:
- No need to install any software, its made in excel
- No need to have any accounting knowledge
- 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 simple-inventory-management-tool-in-excel.zip
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
You need to be logged in to reply.