Guides

Manage inventory - Part 1 Introduction

Inventory comprises goods held by a business for sale or production. It does not include fixed assets, such as equipment or buildings. Nor does it include tools or consumable supplies used during operations. The value of inventory is an asset, because it can generate future income. Therefore, it appears on a company’s balance sheet.

So inventory must be counted and valued. It must be tracked as it is produced, bought, or sold. Manager includes many features to help manage inventory. Some are essential; others are optional. Program behavior changes, depending on which tools are used. This Guide explains how various tools and capabilities interact so you can decide which to use in your situation. It is divided into three parts: Introduction, Continuation, and Conclusion. You are reading Part 1 Introduction.

The three parts of this Guide do not furnish detailed, step-by-step instructions for enabling functional tabs, completing transaction forms, or generating reports. Those can be found in other Guides, to which hyperlinks are provided. Instead, they focus on relationships between the inventory management features of the program:

  • Inventory items are defined elements by which inventory is managed. They can have purchase and sales prices, specified tax codes to be applied, and individual units of measure. Their costs and revenues can be assigned to custom accounts. Most importantly, they have standard item codes, names, and descriptions by which they can be referenced.
  • Purchase invoices record purchases of inventory items from suppliers on credit.
  • Sales invoices record sales of inventory items to customers on credit.
  • Cash sales and purchases record transactions of inventory items paid at the time.
  • Production orders record in-house manufacture of inventory items from other inventory items and non-inventory cost inputs.
  • Inventory kits are sales entry shortcuts for combinations of inventory items stocked individually but sold together under a single identification. (The items may also be sold individually in other transactions.)
  • Delivery notes document delivery of goods to a location or customer.
  • Goods receipts document receipt of goods at a location or from a supplier.
  • Inventory locations are discrete places where inventory items are physically stored, such as different warehouses or shops.
  • Inventory transfers record movement of inventory items between inventory locations.
  • Inventory write-offs document the loss, damage, or other non-revenue-producing reduction of inventory.
  • Inventory reports provide information on changes in quantities, values, or locations of inventory. They also list profitability and price of inventory items.

Note
Purchase orders and sales orders are not included in this discussion because they are not actual financial transactions and have no impact on inventory. They are convenient shortcuts for recording orders to suppliers or from customers. And they can by copied to other transactions that affect inventory. But in the current version of Manager, purchase orders do not adjust inventory availability or backorder status. Nor do sales orders commit inventory to a particular customer or future sales transaction.

Example
All three parts of this Guide illustrate various aspects of inventory management using an example company, Brilliant Industries. Brilliant Industries sells electric lamps and lamp parts at wholesale. It is not required to collect or pay any taxes on sales or purchases in its jurisdiction. Brilliant has 6 different items in inventory and assigns 3-digit item codes:



Brilliant currently has two customers and two suppliers:

56 PM AND 08 PM

So far, Brilliant Industries has enabled just three tabs related to inventory management (Reports is always enabled for all businesses):

  • Customers
  • Suppliers
  • Inventory Items

Purchasing inventory

Inventory can be purchased with purchase invoices or cash payments.

Example
Brilliant Industries buys an initial stock of inventory via a combination of purchase invoice and cash payment. ACME Distributing presents its sales invoice upon delivery of the merchandise. So as soon as Brilliant enters the corresponding purchase invoice, the items are considered to be in stock. Edison Electrical Supply sells only over the counter. So Brilliant’s owner leaves Edison’s warehouse with purchased items in hand, having written a check on the spot.

Brilliant enables the Purchase Invoices tab. The Bank Accounts and Receipts & Payments tabs were enabled when the company’s bank account was established. The two transactions are entered as below:





Since all transactions were complete when they were entered, there is no need for Brilliant Industries to enable the Goods Receipts tab. The Inventory Items list shows the results of the two purchases:

Producing inventory

When inventory items are produced in-house, production orders record consumption of resources and output of new finished goods.

Example
Brilliant Industries can buy finished table lamps from ACME Distributing. But it can also produce them from parts purchased from various suppliers. It decides to manufacture a batch of 3 table lamps. So it enables the Production Orders tab and enters the following production order:



The inventory listing shows the increase in finished table lamps, as well as reductions in the three items that went into production. Also notice that average cost of table lamps has declined because of the production order. The cost of input items for a lamp (87.00 + 24.35 + 3.25 = 114.60) plus labor (75.00 / 3 = 25.00) is less (139.60) than the purchase cost of a finished lamp (195.00). In other words, Brilliant Industries can assemble table lamps itself for less than it can buy them, potentially allowing more profit:



Also note that total value of inventory has risen because of the 75.00 labor cost to manufacture 3 lamps. The company now has more invested in its inventory. But it can also sell that same inventory for much more because of the value added through manufacturing operations.

Selling inventory

Inventory can be sold with sales invoices or cash receipts.

Example
Brilliant Industries sells products to Bob’s Hardware. It enables the Sales Invoices tab and records the sale on the following sales invoice:



It also sells 1 case of LED bulbs to Lumen Lighting for cash, and enters that transaction as a receipt. Quantities on hand have decreased for table lamps, 60 Watt bulbs, and LED bulbs:



Because the goods were delivered immediately and either accompanied by a sales invoice or a cash receipt, Brilliant Industries did not use the Delivery Notes tab. Manager treated all inventory movements as having happened immediately.

Understanding backorders

When you have sold more inventory items than you own (have on hand) the situation is described as a backorder. That term is somewhat misleading, because additional stock has not necessarily been ordered. This situation shows up in Manager as negative inventory quantities. The negative quantity indicates how many units of the inventory item must be purchased or produced to satisfy existing sales.

Example
If Brilliant Industries had sold 3 cases of LEDs to Lumen Lighting in the previous example, a backorder situation would exist, because only 2 had been purchased and were on hand. The inventory list would show a quantity on hand of -1:

Inventory reports

Four reports became available when the Inventory Items tab was enabled:

  • Inventory Value Movement lists opening balances, value added through purchases or production orders, cost (on an average cost basis) of inventory sold, adjustments, and closing balances. The report can be generated for any defined period of time. An inventory item that is out of stock for the entire period will not be listed, because there will be neither value nor value movement at any time during the period. But an item that is in stock but has no movement will be included.

Example
Brilliant Industries began the year with no inventory, made initial purchases, produced some lamps, and made sales. Its Inventory Value Movement report is shown below. Notice that only the 2 cases of LEDs actually delivered are included; the backordered merchandise will not appear until more are purchased and delivered:

  • Inventory Quantity Movement corresponds closely with the previous report, but lists quantities instead of values. Items are included only when movement occurs during the period, regardless of whether stock exists on the opening and closing dates.

Example
Brilliant Industries’ matching Inventory Quantity Movement report is below. Note the backordered LED near the bottom of the list:

  • Inventory Profit Margin tabulates profits and margin rates on inventory items sold during a period. Items not sold during the period are omitted.

Example
Brilliant Industries sold only 3 different items during the reporting period, so only those show on the Inventory Profit Margin report:

  • Inventory Price List includes all current sales prices of inventory items. If a sales price is not defined, the item will not appear on the list. If a custom field has been defined for inventory items, the report can be filtered by content of the custom field.

Example
Brilliant Industries’ full current price list is show below:



Brilliant adds a custom field for inventory categories. It filters the report for Finished lamps, with a corresponding title:

45 AM

The resulting report appears below:

Note
Because Inventory Value Movement and Inventory Quantity Movement reports are related to transactions within a specified time period, they will not necessarily reflect total value or quantities of inventory on hand. That information can be obtained by drilling down on the Inventory on hand account in the Summary tab or by clicking on the Inventory Items tab. Both resulting lists can be exported to a spreadsheet program.

Support
Subscribe to Updates

Subscribe to our newsletter and get exclusive product updates you won't find anywhere else straight to your inbox.

© 2018 - Based in Sydney, Australia but providing goodness globally