All About Accounting and Inventory

So in this simplified example of accounting and inventory, you can see that the auto shop started the year with 5 sets of tires costing a total of $2200. So they had $2200 worth of inventory on hand. At the end of the year, they sold all of the tires except for one set.

The $440 remains on their inventory sheet, and the $1760 moves to the Cost of Goods Sold section.

Note: if you need to track inventory in your business…unless you are extremely small and only have a very small inventory to track…you need a good accounting software to track your inventory and products sold, such as QuickBooks.

QuickBooks does a great job of tracking your current inventory. It will enable you to discern with the click of a button how much inventory you have on hand at any given point and how much that inventory is worth. It will also let you know which items are on order and when you can expect to receive those items.

QuickBooks will also keep track of the cost to make products you assemble yourself and the income you generate from selling them.

Accounting And Inventory Methods

The inventory accounting system can be done in two ways: periodic or perpetual.

Periodic inventory system means inventory is updated just once a year.

Perpetual inventory system means inventory is constantly updated as new products are purchased.

Depending on which transaction method you choose, there are many different ways to estimate and record your inventory. Your accountant will be familiar with all of them and help you decide which is the best method for you.

Also, to avoid any unpleasant surprises come tax time, consult your tax adviser a couple of times a year (especially towards the end of your tax year) regarding your accounting and inventory.

So those are the basic ins and outs of accounting and inventory. You must keep on top of merchandise inventory to make sure you have enough on hand to meet the needs of your customers, but not too much that you’re left with a warehouse full of unsold goods.

FIFO, LIFO And Weighted Average Cost Of Inventory

There are three ways to value inventory: FIFO (First In, First Out), LIFO (Last In, First Out), and Weighted Average Cost.

A business that makes or purchases physical products must account for how much goods inventory is on hand. For some businesses, physical inventory will be taken monthly, while others will be annually. GAAP or Generally Accepted Accounting Principles allow a company to use a few methods to keep track of inventory. The use of FIFO, LIFO, and weighted average cost are three common ways to value inventory and, as you imagine, will provide different numbers. Businesses in some industries will gravitate to certain methods due to the type of inventory. For many businesses, it may not matter as long as the method is used consistently. Businesses needing inventory financing will need to be more active in calculating their inventory costs, while businesses calculating inventory for the total cost of goods sold or cogs can oftentimes wait until years end or at the end of the accounting period.

What Is FIFO?

The FIFO method of FIFO accounting is abbreviated for First In, First Out, which means items that are first produced or acquired are also the first items to be sold. Why use FIFO? The FIFO method is typically used by most companies and provides the most accurate costs since older and less costly items are usually sold first.

FIFO Calculator

What Is LIFO?

The LIFO method is short for Last-In, First Out which assumes the newest inventory is sold first. Why use LIFO? The LIFO method is useful for businesses where inventory costs are going up, or inventory becomes quickly stale like computer processors. Companies sometimes use LIFO because it can reduce a business’s profits.

LIFO Calculator

What Is Weighted Average Cost Of Inventory?

The weighted average cost of inventory is simply adding up all of the inventory purchased in an accounting period and dividing by the number of units. Why use weighted average cost? This method is commonly used for businesses where inventories are combined, such as a gas station, as there is no way to differentiate between one shipment vs. another.

Inventory Ratio Analysis

There are two primary ratios that analyze how efficient a business is with their inventory, Inventory Turnover Ratio and Days Sales in Inventory.

What Is The Inventory Turnover Ratio?

The Inventory Turnover Ratio shows the number of times inventory is sold and restocked during an accounting period. If the number is too high, there may not be enough inventory on hand, while a number too low may mean the business is holding on to old inventory. Having old inventory may inflate the balance sheet as this inventory may not be sellable and means the company may have liquidity issues. Many people ask what the ideal turnover ratio is, and the answer depends on industry averages. The turnover ratio by itself is only useful to track over time, but ideal ratios are available as industry benchmark figures through your CPA or sources like RMA or IndustriousCFO.

How To Calculate Weighted Average Inventory

To calculate Inventory Turnover, take Net sales / Average Inventory. Net sales are found on the income statement, while inventory is found on the balance sheet. Average inventory is often used rather than ending inventory because a business’s inventory can vary greatly throughout the year, especially for seasonal businesses.

What Are The Days Sales In Inventory Ratio?

The Days Sales in Inventory Ratio (DSI) will show how long inventory stays in inventory before being sold. The faster inventory sells, means the faster cash gets replenished and can be reinvested. The calculation for DSI = 365 days/Inventory Turnover. The final number is the number of days it takes that item to sell. The lower the number, the better for a business’s cash flow.