Stock Controller job description. A Stock Controller is responsible for ensuring that the company's stock levels meet business needs. They do this by overseeing purchases and pricing reports, replenishing levels when necessary, and monitoring shipments or internal transfers between departments within one business enterprise. Inventory & Stock Management Template Click the link below to download this template Create Free Account Download: Excel 3 Different Tabs In the first tab, daily stock take, you need to record the daily movement of stock coming in or going out of your business. In this context, "in" and "out" can mean various things. RECEIVING AND MANAGING NEW STOCK Stock doesn't just appear out of nowhere. And so a critical part of warehouse management is being able to receive, unpack, put away and book in new inventory as efficiently as possible. The faster this happens, the sooner that stock becomes available for sale. Let's dive into how to use our Warehouse Management System Excel Template. Start in the Inventory sheet and add details about your items like Product Name, Description, Manufacturer. You also want to fill out Quantity Ordered, Location, Price, VAT, Amount Ext VAT, Stock, Reorder Quantity and Date Recorded. This stock inventory control template can help you identify when it's time to reorder stock, reduce excess inventory, access supplier information, and easily locate items in storage. It's easy to view the entire lifecycle of your stock, including items on backorder. Inventory Tracking Template - 20+ (in Excel & PDF) An inventory tracking template is a spreadsheet application that helps homes and small businesses have adequate management control of their stock. Using templates as a guide can make this task very clear and concise. Here are a few. 3. TradeGecko. TradeGecko is an inventory and sales management software solution. They offer an attractive and free inventory management workbook to get you started. To get this template, click the link below and then click the Make a copy button. This will save a copy of the template to your Google Drive. Get the template: Excel Inventory Template (web page). 9. Beverage Stocktake Pro Template. If you run a bar, pub, club, or restaurant, this is one of the best beverage inventory spreadsheet templates out there. It allows you to track drinks purchase costs, actual revenue, and gross profit and loss on a weekly basis. Businesses, receiving inspectors, and warehouse inspectors can use this template to monitor the process of warehouse receiving per item or material. Use this template in iAuditor to easily: Include vital and initial information such as purchase order number, material name and description, as well as quantity of the item received. Inventory Control Template design consists of two sections as follows: Heading Section and Inventory Section. Heading Section As usual, the first line here is the heading "Inventory Control Sheet". A checkbox next to the heading has been designed. If we check this box then all the items to be reordered will be highlighted. Step 3: Production Sheet. Create a spreadsheet in Google Sheets. It is a free alternative to MS Excel and is being used by more and more businesses. On the top leave one cell empty and fill in the subsequent ones with the months of the year row-wise. In the first column leaving the first cell empty fill up with names of each of the production Warehouse Stock Card Save, fill-In The