Use an Inventory Table Template

How to Make an Inventory Table?

Allocation of equipment per employee

Each employee fills in the information about the product assigned to him/her, which saves you time. Only you, as the owner of the table, have a consolidated view of the entire IT stock.

Add the documents required for the inventory

Store all types of documents necessary for your follow-up, particularly purchase invoices, but also pictures of the equipment.

 

Classify the material based on a preset list of choices

Once you create a list of choices of type of material, your collaborator only has to choose the one that applies. This simplifies data entry, ensures consistency, and saves time. Since each material type is assigned a different color, you can see the distribution of the type of material at a glance.

Use this inventory table template.

Use this table template

Performing a physical inventory | Sequence of the day’s events, from A to Z

Compiling an annual stock inventory is a legal obligation and must take place no later than several days before the end of the fiscal year. The inventory involves physically checking merchandise so that the actual quantities in store can be compared with those in the digital list. Performing a physical inventory isn’t difficult in itself, but requires detailed advance planning and careful attention on the day of the inventory.

The first thing to decide is the date and time when the inventory will be taken. It needs to take place during a period of low activity in the day, when the business is closed, or sometimes even during the night.

This will enable the inventory manager to ensure that product inputs and outputs are kept to a minimum during the inventory process. The manager must also set up a suitable team with enough people to perform a double count in each predefined zone in the store.

This method of checking the merchandise will ensure optimal reliability of the results. If there is not enough internal staff, calling in temporary workers can be a good solution for this type of project. Each person participating in the inventory needs to know exactly what tasks are expected of them. An instruction manual could be distributed to team members in advance.

All these preparations will help the event flow more smoothly and keep errors to a minimum. A control chart will ensure verification of each step as it is completed.

 

 

Insert the right information for an efficient inventory

By first segmenting the locations where the stock is held (in store, in the warehouse), the inventory manager facilitates the counting work that is to follow. Once the breakdown of these areas has been determined, the teams can take their places and spread out over the designated areas with their counting sheets. These include a consolidated table with the following information:

  • Product reference
  • Product designation
  • Type of storage (raw materials, products in process of manufacture, finished products, merchandise)
  • Actual quantity (to be filled in on the day of the physical inventory)
  • Expected quantity (data extracted from the computer tool)

The teams work in pairs in most cases: one person counts by marking the product with a symbol as it is accounted for and the other notes it down in the table. This means that the counting process (carried out twice by two different teams) is faster and the margin of error greatly reduced. The physical stock inventory ends with the retrieval of data by the accounting department.

This department will be responsible for assessing the discrepancies between the actual counts and the expected stock data displayed in the company’s management tool (due to damage, losses and thefts, or errors in the quantities delivered by suppliers). It will also be able to place a value on the stock (valuation or depreciation) from an accounting perspective.

A well-conducted inventory provides important information to the company for the ongoing management of its stock and for tax and other financial reporting purposes.

Use this inventory table template. Use this table template
Our clients talk about Rowshare
  • ” In addition to saving time and improving the quality of our business information, RowShare brings peace of mind to our partners and enhances our business relationship with them. You can’t put a price on that!”

  • “We tried Excel, Google Sheets and Airtable, but they didn’t do the job with regards to letting users see only a part of the table while we see everything. Only RowShare could do that.”

  • “Following up on marketing outreach represents up to 2 hours a day, and this time has been reduced by at least 30 percent, thanks to RowShare. This is a savings of at least 40 minutes a day or nearly 2 working days saved per person per month!”

Need help?

Plan a demo

Go to Top