Inventory Template

Track all the products and items that come through the door with the inventory template. The solution helps track what matters, whether the issue is stock wastage, finance, audit, insurance or improved management.

How to use the Inventory Template

General Information

Owner – May refer to the owner or direct representative of the business, house or area.

Name – First and last name of the owner
Address – First segment of a person’s address which may include the number and road/avenue in which the inventory area is located.
Address II – Refers to City, state, province and nation.
Phone – Number available to connect with the owner. It usually includes 10 to 11 digits with country calling code, area code.
E-mail – Electronic method to contact the owner

Inventory Manager – Person in charge of managing the inventory. The inventory manager may be the same as the owner.

Name – Name of the inventory manager
Contact – Form of communication with the inventory manager. May include phone, email or another method.
Date of Last Review – Helps to determine when an inventory check has been done and whether another one is overdue.

Major Insurance – Space to provide information about the major insurance used to protect the inventory. Some organizations may have multiple insurances, for this purpose, only use the major, most relevant provider. Consider having an insurance management template in case multiple insurances are needed.

Company – Name of the company used to insure the inventory.
Contact – Form of communication with the insurance company. May include phone, email or another method.
Policy # – Unique identifier used by the insurance to determine the policy owner.

Table

The table is where every inventory activity is managed and kept. It is divided into four segments, acquisition, quantity, value and miscellaneous.

Acquisition – Provides key information on an inventory purchase, helping to answer some of the what, why, when, who of each inventory item.

Name – Label of the item purchased.
Description – Relevant information to describe the item.
Location – The place that the item is or will be stored.
Date – Day of purchase.
Supplier – Seller of the item.
Assurance – Guarantee, warranties and other provisions given by the seller or product creator.

Quantity – Number of items acquired, added or left in the inventory.

Initial – Number of acquired items when the acquisition was done.
Current – Number of items available at the time of the inventory check.

Value – Used to determine the value of the inventory at the time of the acquisition and inventory checks.

Initial – Amount paid to acquire the item(s).
Current – Value of the remaining items, accounting for quantity and depreciation when possible.

Miscellaneous – Additional information used to process inventories.

Condition – The state of an inventory ranging from excellent to critical mainly due to wear and tear.
Model – Type of item used to better manage items that fall under the same name or categories.
ID – Unique identifier for the item. It may be used, for example, in cases multiple purchases of the same item are made.
Comments – Additional information added by the inventory manager to give more meaning to the data.