A stock register is a database maintained by a company to track the history of its stock issues. This database contains detailed information about the company's stock and is used to record information about shareholders in the company. For publicly traded companies, maintaining an accurate and complete stock register is critical to ensure that the company has accurate information available at all times about its stock and stock holders.
Inward Outward Register Format - Doc Download. Dear Seniors, Please give me format of Cable quantities tracking format stock register format in exel. 7th February 2017 From Saudi Arabia, Riyadh # [email protected]. Dear Seniors, Please give me format of stock register format in exel. For electrical control panel manufacturing. Logs and Inventory Printable Business Form Templates in DOC format. Get all of our printable, customizable business forms for $47 as an instant download. Cash Register Log. Inventory Tracking Spreadsheet. List of Insurance Policies. Firearm Inventory.
The stock register includes data about stock issues, buybacks, and retirements so the company knows how many shares outstanding it has at any given time. For every share held by a stockholder, the entry has a unique number to identify the share, and it contains information about the owner including name, address, and par value of the share at the time it was purchased. Dates indicating when issues were made and when stock was purchased are also included in the stock register to allow the company to track its stock over time.
When someone who holds stock experiences a theft or loss that requires replacement of a stock certificate, the stock register is used to verify the claim and information about the replacement is noted. Likewise, when stock is sold, it must be re-registered with information about the new owner and the transfer. Personnel in charge of managing the stock register are charged with keeping it up to date and as complete as possible.
An asset register is pivotal to asset management. No matter what size your asset portfolio is, you need to keep a record of your asset information for asset planning, accounting and legislative compliance, and performance monitoring. To make things easier for you we’ve created an asset register template that you can freely download, customize and share.
In the upcoming weeks we’ll share tips on how some of the formulas were calculated. In the next tip, particularly, we’ll focus on the formula that calculates which financial year the asset was purchased in.
Note:Download the free asset register template
Applies To: Microsoft® Excel® 2007, 2010 and 2013
Manual Stock Register Format Sample
The financial years for the data under review is on the lookup worksheet.
The list of assets and their life spans are on the lookup worksheet.
The Vlookup function extracts the data into the assets register from the lookup worksheet under “Check useful life”.
The IF and AND functions are used to calculate the financial year when the asset was purchased under Assets Purchased by Fin Year.
Depreciation using the Straight line method is calculated in column O.