I need an inventory software to keep track of the stationery checked out by the other workers at my job.

Question

As part of my job, I am in charge of the stationery. I buy the stationery, keep the records of the stationery, distribute the stationery to the other employees and have then sign for it. However, I have been running into to problems to try and keep a proper record. Could you please suggest a software that I could use? Also, I was thinking of using Excel, but I am at a lost of what the columns could be. I have no idea where to start when it comes to organizing the information in Excel. PLEASE HELP ME.... AND THANKS IN ADVANCED.

Answer 1

You can give inFlow Inventory a try. They have a Free version that is free forever, but limits to 100 products and customers. The software itself is very easy to use and fast to install.

Here is their website:

http://www.inflowinventory.com

Hope this helps!

Answer 2

Regardless of whether you do it manually or use Excel the following should work for you.

You should have one file card or spreadsheet set of columns per item.  You want 5 columns organized as follows:

Column 1: Transaction Date

Column 2: Quantity received (purchases and usable returns)

Column 3: Quantity issued or scrapped

Column 4: Quantity on hand

Column 5: Notes/Employee Signature or name

Since you want the employees to sign for the stationary they use I would suggest that you use 3x5 or 4x6 file cards rather than a computer and Excel.

Hope this helps

Jerry-the-bookkeeper