Useful stock register template for stock summary report, inventory report, stock entry report, stock value report.
Stock summary report is useful to see the inventory summary of all items for the given duration. Use this report to see the opening stock, total stock inward, total stock outward, closing stock of all items. You can create stock summary report of any day, week, month, year or any custom date range. You can create a separate stock report for all the stores and godowns. You can also a combined data in one report of all the stores & godowns.
Opening Stock is the stock available in the store/goodown at the beginning of the duration.
Stock Inward is the item purchased or received in the store/godown for the given time duration.
Stock Outward is the item sold or issued from the store/godown for the given time duration.
Closing Stock is the stock left in the store/godown at the end of the given time duration.
Closing Stock = Opening Stock + Stock In - Stock Out
Stock entry report is useful to see all the stock in, stock entries of the item for the given time period.
Use this report to see the bill number, stock in/out, remaining stock of all stock entries. All stock entries are ordered in the order of start to end time. So you can see the remaining stock at any entry level.
You can create the stock entry of any item for any time period. You can also see the remark in every stock entry.
Bill Number is unique for the stock entry and useful to check more details of the entry number.
Stock Inward is the item purchased or received in the store.
Stock Outward is the item sold or issued from the store/godown.
Remaining Stock is stock left after the stock inward/outward entry
Remaining Stock = Opening Stock + Stock In - Stock Out
Stock value report is useful to stock value of each item at the time of the report generation.
Use this report to see the available stock quantity, selling price, stock value of each item.
You can create the stock value report of any store, godown.
Available Stock Quantity is the quantity available of the item in the store/godown at the present time
Selling Price is the price at which item is being sold.
Stock Value is the total valuation of the available stock of the item in store. You can used either selling or purchase price to calculate the stock value. Stock Value = Available Stock Quantity x Item Price
Stock Value = Available Stock Quantity x Item Price
Start your 7 days free trial now. No need to pay up front. Automatic cloud data backup
Trusted by 2,00,000+ small businesses in India. Made in India