Need Help Creating a Stores Register Format for Tracking Inward, Outward, and Closing Stock?

subrakrishn
Dear Seniors,

I am looking for a stores register format that will include inward, outward, and closing stock of each item. I kindly request your assistance in providing me with a detailed format.

Thank you.
siddharthjrs
Stock Register Attachment

Please refer to the attachment of the Stock Register; it might be of some help to you. Please enable the macros before using this Excel sheet. Suggestions are most welcome.

Regards,
Siddharth Singh
1 Attachment(s) [Login To View]

manisharh
I am working in a manufacturing unit, and I want to maintain my stock register so that I can easily verify rates and stock available with me. Please suggest how this can be possible?
tennythomas
Hello, I have some doubts about the stock register created by siddharthjrs from Nagpur. Please explain the opening stock and closing stock in the stock register. Who will input the opening stock and closing stock? The accountant, storekeeper, or both? Please provide me with a way to contact siddharthjrs.

Thanks in advance.
rajiv7508
I am looking for a store cum inventory register with auto costing. We are sending materials to various locations and need to implement this process. Please revert with your valuable feedback.

Regards
shiva6978
I am looking for a stock register format with opening stock, inward, outward, and closing stock of each item. Here, I have downloaded a register, but it's secured with a password. Request you to help me by sending a detailed format.

Regards,
Shiva
Rajeshwariannu
Dear Sir, I have checked the Excel stock register. It is very good and useful for me. Could you please send the password to unprotect the sheet?

Regards,
Rajeshwari
Admin Officer
Ashwin Darji
Request for Stock Register Format

I like your stock register store. I am looking for a store's register format that will have inward, outward, and closing stock of each item. Could you please help me by sending a detailed format? I am an accountant in a shop that deals with insecticides, seeds, and fertilizers. I maintain the stock register in your created stock register. I have made some changes and added some items. Can you help me with the following:

1. In the Master sheet, I have changed the Item Code myself. In column B, what items have been entered?
2. In the Query sheet, how do I add my items?
3. Query - I have added insecticides, seeds, fertilizers, and some company names.

Thank you,

Regards,
Ashwin Darji
Sankheda-Vadodara-Gujarat
daelin
Please could you tell us the password as we can't change what's inside the Excel? I need your help here because I am using your formula to control my stock. I'm really grateful if you see this message and reply to us as soon as possible.
anupama saluza
Dear Sir,

Thank you for putting in the effort to create such a well-formulated stock register. I have tried using this register for my shop, but I am encountering some issues with deletions in the received entries. Could you please provide the protection password?

Regards,
Anupama
KhurramH
Good day,

I have used the stock register. It is very good and useful for us. Can you please share the password to unprotect the sheet.

Best regards,
KhurramH
HARIDASAN1956
I am looking for a store's register format which will include the Receipt of stores, Issue of stores, and closing stock of each item and query. I request your help by sending a detailed format.

With best regards,

Haridas

Email: hrds_pv@yahoo.com
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute