Veeqo
Veeqo
Ecommerce Operations

Inventory Accounting: What Every Retailer Needs to Know

SHARE

Inventory accounting is an aspect of running your ecommerce business that you just do not want to get wrong.

Mess it up, and you leave yourself open to:

  • Inaccurate forecasting.
  • Paying too much or too little tax.
  • Not knowing how profitable your business is.

But inventory accounting is (not surprisingly) a hugely complex subject.

So in this post we take a deep dive into it. Helping you understand exactly what goes into the accountancy side of holding inventory, and what to do to minimise the confusion come end of the tax year.

Download a printable version

Want to save a hard copy of this post for later? Download a PDF version to print, read offline or share with co-workers.

What is inventory accounting?

Inventory accounting is all about how a business would show the stock it holds in its financial records – balance sheets, profit & loss (P&L) reports, etc. This is typically more complex than it sounds as inventory is often a ‘live figure’ that’s constantly changing as sales are made and more stock purchased.

In retail, this can cover three production phases:

  1. Raw materials.
  2. In-progress items.
  3. Finished products ready for sale.

Your on-hand, unsold inventory needs to be included as an asset in end-of-year financial records. Meaning the crux of the matter in all this is to correctly track both the cost of any inventory sold and place an accurate value on the unsold inventory being held at the end of each accounting period.

Any increase or decrease in the value of goods affects your inventory value figure. This then, in turn, affects the value of your overall business.

Inventory accounting key terms

There are two key terms retailers need to be aware of when it comes to inventory accounting:

  1. Cost of goods sold (COGS). The direct costs of producing any goods sold by a company.
  2. Ending Inventory (EI). The value of any unsold, on-hand inventory at the end of an accounting period.

Let’s take a deeper look at each of these…

1) Cost of Goods Sold (COGS)

Cost of Goods Sold (COGS) is a core element of measuring a retail business’s profitability and inventory value.

As the name suggests, COGS refers to the value of products sold, including everything that went into it – materials, labour, tools used, etc. But (crucially) without factoring in any indirect costs – like distribution, advertising, sales force costs, etc.

As a result, COGS helps you determine the amount of gross profit made in one or more sales.

For example:

If you sell an item valued at $50 and the COGS is $30, your company has achieved a gross profit of $20. It’s a simple formula, though it can become more complex if manufacturing your own products.

All inventory sold will be listed under the COGS account in your income statement at the end of each business year.

2) Ending Inventory (EI)

It’s highly likely that a business will not sell the entirety of its inventory at the end of each accounting period. Meaning any on-hand, unsold stock becomes an asset that must be valued and included in financial statements.

This is referred to as Ending Inventory (EI), and is actually quite simple at first glance.

  1. Take the beginning inventory (the units carried over from the end of the previous financial period).
  2. Add any newly purchased inventory throughout the accounting period.
  3. Subtract any units sold.
  4. And this leaves the final inventory figure to be included as a company asset.

Inventory Accounting: Ending Inventory (EI) Calculation

However:

We need to assign an actual value to the unsold inventory figure (i.e. how much this company asset is worth in monetary terms). And this is where it can become a lot more complicated.

This is because:

  • Numerous purchases of new stock and raw materials are usually made during a typical 12-month accounting period.
  • Each purchase may have come at a different cost per unit.
  • Sales are also being made at the same time, turning inventory into cash.

So which cost per unit figure do you use to value unsold inventory when there are so many moving parts in a typical accounting period?

This is where inventory valuation methods come into play.

Inventory valuation methods

Sticking to a specific method for inventory valuation is critical for consistent, accurate and (most importantly) legally acceptable financial statements.

There are three main valuation methods retail companies use for inventory accounting:

  1. First In, First Out (FIFO).
  2. Last In, First Out (LIFO).
  3. Average Cost Method.

You’ll just need to stipulate which one is being used when submitting financial records and accounts.

1) FIFO

FIFO assumes inventory that was purchased first, is also the first to be sold. So the oldest on-hand inventory available is what will be used to fulfil an order.

There are a number of benefits to the FIFO method. Primarily, companies selling perishable goods (food and drinks) face less risk of their products spoiling or crossing best-before sale date. They can establish a smooth supply chain and ensure their clients receive the freshest items in their inventory.

All products received and sold must be recorded individually when using the FIFO accounting method. It’s possible that the FIFO system can lead businesses to under or overestimate the value of inventory in the future, due to market changes down the line.

2) LIFO

The LIFO approach works on the assumption that the most recent products added to your inventory are the first ones to be sold first.

This system works well for retail businesses specialising in non-perishable goods or those with a low risk of obsolescence. It can also increase COGS and lessen net profit (therefore reducing annual tax liability) if more recently purchased goods are more expensive.

Note: LIFO is an acceptable inventory accounting method in the US only.

You can learn more about LIFO vs FIFO in this video:

3) Average Cost

Average Cost (or weighted-average) inventory accounting method is totally different to the previous two.

This applies to businesses that choose not to track cost per inventory unit of each purchase delivery separately. With inventory value based on the average cost of items throughout the relevant period.

You can work out the average cost by simply dividing the overall cost of products for sale by the total number in the inventory.

You can learn more about the Average Cost method in this video:

Automating your inventory accounting

Inventory accounting can be a time-intensive, frustrating process for retail businesses – especially small or independent teams.

But it doesn’t have to be a rush of spreadsheets and paper receipts the week before every tax deadline. There’s reliable accounting software available to help automate and digitise as much as possible, the main two being:

  1. Xero
  2. QuickBooks

These programs won’t ‘do your accounts for you’. But they will make it much simpler to organise and present come the end of tax year.

Both Xero and QuickBooks do also have tools available to help with the inventory side of accounting.

However:

They are accounting softwares at heart. Meaning the inventory management functionality within them is relatively basic and underdeveloped.

So for growing retail and ecommerce businesses, it’s recommended to:

  1. Utilise a high-quality inventory management software as master of stock.
  2. Ensure this software has a direct Xero integration or QuickBooks integration to push relevant data across.

This leaves you with the best of both worlds – two high-quality softwares automating as much of your inventory and accounting processes as possible.

Final thoughts

Inventory accounting can be a complicated and unexciting task for retailers.

But getting it right is actually one of the most important things for a sustainable business. Otherwise, you risk a whole heap of legal and financial troubles raining down on you.

Use the advice in this post to help you understand the basics of what you need to know. Then make sure to seek the help of a professional when it comes to filing and submitting returns.

Disclaimer: This post is intended to help retail business owners understand what goes into inventory accounting. It should not be used as an instruction manual for completing tax forms and complex business accounts, and we highly recommend employing the services of a professional bookkeeper and/or chartered accountant to do this.

Download a printable version

Want to save a hard copy of this post for later? Download a PDF version to print, read offline or share with co-workers.

SHARE THIS ON:
The following two tabs change content below.

Written by Mike Glover

Content Editor at Veeqo
Content Editor at Veeqo. Writes good ecommerce stuff. Lover of all sports. Purveyor of the finest GIFs in the West.
Want more insights like this?

Join thousands of other subscribers and get the best content on ecommerce growth, marketplace trends and warehouse operations delivered directly to your inbox.