A Beginner’s Guide to Inventory Accounting - BusinessTown

A Beginner’s Guide to Inventory Accounting

Inventory accounting is more of an issue for product businesses, such as manufacturers, wholesalers, and retailers. However, if you are in a service business that also has some inventory, it could impact you, too.

Inventory accounting comes into play when you buy, use, and also hold in inventory identical goods at different prices. This leads to the question of how you account for the value of the inventory you have on hand versus the inventory you sold. There are different acceptable methods that you may choose for valuing inventory in these circumstances.

Let’s say you have a service business, such as a house painting business. Chances are, you keep some paint in inventory. Let’s say, to make things simple, that all you use is white paint, you only buy full-gallon cans, and you only use one brand. Sounds simple, but the price of paint may increase during the year. So, at the end of your accounting period, which price do you assign to each can of paint that you used during the period: the new price or the old price?

One way that accountants think about this is to ask the following: Are you assuming that you used the oldest and least expensive cans of paint first (called the First In/First Out, or FIFO, accounting method)? Or are you assuming that you used the most recent and most expensive cans of paint (called the Last In/First Out, or LIFO, accounting method)? Still another way accountants could look at your paint usage is to just use the average cost of your total inventory to assign value to each paint can used (this is the Weighted Average Method). It’s really not that complicated, but it can be a little tedious to keep track of.

Inventory accounting may sound like a huge undertaking, but in reality it is quite straightforward. You start with the inventory you have on hand. No matter when you sell product, the value of your inventory will remain constant based on accepted and rational methods of inventory accounting. Those methods include weighted average, first in/first out, and last in/first out.

If you need a little extra help with understanding these three types of inventory accounting, I will run through it again using new examples.

How Do I Calculate Inventory Value Using the FIFO Method?

First in/first out means exactly what it says. The first widgets you bring into inventory will be the first ones sold as product. First in/first out, or “FIFO,” as it is commonly referred to, is based on the principle that most businesses tend to sell the first goods that come into inventory first.

Suppose you buy five widgets at $10 apiece on January 3 and purchase another five widgets at $20 apiece on January 7. You then sell five widgets on January 30. Using first in/first out, the five widgets you purchased at $10 would be sold first. This would leave you with the five widgets that you purchased at $20, which would leave the value of your inventory at $100.

First In/First Out (FIFO) Inventory Accounting Formula

Five widgets at $10 each = $50
Five widgets at $20 each = $100
Total number of widgets = 10
Sell five widgets using cost of first purchased at = $10
Have five widgets left in inventory using cost of last purchased = $20

How Do I Calculate Inventory Value Using the LIFO Method?

This method, commonly referred to as “LIFO,” is based on the assumption that the most recent units purchased will be the first units sold. The advantage of last in/first out accounting, is that typically the last widgets purchased were purchased at the highest price, and that by considering the highest priced items to be sold first, a business is able to reduce its short-term profit, and hence, its taxes.

Suppose you purchase five widgets at $10 apiece on January 4 and five more widgets at $20 apiece on February 2. You then sell five widgets on February 20. The value of your inventory (using LIFO) would be $50, because the most recent widgets purchased, at a total value of $100 on February 2, were sold. You were left with the five widgets valued at $10 each.

Last In/First Out (LIFO) Inventory Accounting Formula

Five widgets at $10 each = $50
Five widgets at $20 each = $100
Total number of widgets = 10
Sell five widgets using cost of last purchased at = $20
Have five widgets left in inventory using cost of first purchased = $10

How Do I Value Inventory Using the Weighted Average Method?

Weighted average measures the total cost of items in inventory that are available for sale divided by the total number of units that were in inventory at the beginning of the accounting period and that were purchased during the accounting period. Typically, this average is computed at the end of an accounting period.

For example, suppose you purchase five widgets at $10 apiece and five widgets at $20 apiece. A “widget,” in this situation, is an imaginary item that could be just about any product. You sell five units of product. The weighted average method is calculated as follows:

Weighted Average Inventory Accounting Formula

Total Cost of Goods for Sale at Cost / Total Number of Units Available for Sale =
Weighted Average Cost per Widget
Five widgets at $10 each = $50
Five widgets at $20 each = $100
Total number of widgets = 10
Weighted Average – $150 / 10 = $15
$15 is the average cost of the 10 widgets

For More on Financial Statements and Business Plans

For more on how to create financial statements and projections see my course, Accounting & Financial Statements. This course includes step-by-step instructions, samples and templates for creating historical and pro forma income statements, balance sheets and cash flows.

You may also be interested in my course, How to Create a Business Plan. This course includes step-by-step video instructions, samples and fill-in-the-blank templates for both a one page business plan and a full length business plan.

Accounting & Financial Statements and How to Create a Business Plan are among the more than 130 courses included with BusinessTown. Other popular courses include Start-a-Business 101, How to Find a Business Idea and The Complete Guide to Digital Marketing. You can try BusinessTown for free.


About Bob Adams

Bob Adams is a Harvard MBA serial entrepreneur. He has started over a dozen businesses including one that he launched with $1500 and sold for $40 million. He has written 17 books and created 52 online courses for entrepreneurs. Bob also founded BusinessTown, the go-to learning platform for starting and running a business.

We make starting a business simple.

We make starting a business simple.

Our courses will show you exactly how to start and run a business

Our courses will show you exactly how to start and run a business

Learn everything you need to know to plan, start and grow a business

We’ll show you what to do right from the very beginning. You’ll learn how to find your idea, write your business plan, attract customers and all the other steps to building a successful business.

Our courses are taught by real entrepreneurs

You will learn from BusinessTown’s highly experienced experts and entrepreneurs. They will share their experience, wisdom and skills with you. And they will guide you through every aspect of planning, starting, and growing your business. 

Start a business you love, earn more money and live the life you want

Our easy-to-follow video courses will quickly teach you how to start and run a business. Our courses can turn your dreams into reality even if you don’t have a business idea or don’t know where to start.

You’ll find a course that’s perfect for you

Get unlimited access to 130+ courses. We cover it all…from finding your idea and creating your plan to making sales and building a successful business. No matter where you are in your business journey, there is a course just for you.

Learn at your own pace and on any device

Take all the courses you want. Anytime. Anywhere. Any device. Watch one video lesson a day (average 7 minutes) or binge watch the whole thing. It’s up to you!

Explore our top 3 courses and start learning now

OUR #1 MOST POPULAR COURSE

Start-a-Business 101

This course will teach you all the basics of starting a business. You will be guided step by step through the entire process of starting a business and becoming an entrepreneur.

FEATURED COURSE

How to Find a Business Idea

Learn how to find a great business idea with this course. Discover how to generate awesome business ideas, how to evaluate and validate them and how to choose the very best one for you.

FEATURED COURSE

How to Create a Business Plan

Learn how to create an excellent business plan from scratch! This course will walk you through every step from start to finish. You will be guided by instructional videos, a sample plan and a fill-in-the-blanks business plan template.

Get unlimited access to all these popular courses

You’ll get all the tools you need to succeed

You’ll get all the tools you need to succeed

Fill-in-the-blank templates and 50+ other tools will show you exactly what to do at any given step. They will save you time, keep you organized and help you get your business up and running as rapidly as possible. 

Our most popular tools include:

  • 300 Best Business Ideas, 111 pages
  • Business Idea Evaluation Worksheet
  • Ultimate Startup Checklist, 18 pages
  • Business Plan Template, 29 pages
  • Sample Business Plan, 35 pages
  • Marketing Plan Under $2k, 12 pages
  • Financial Statement Templates

What they are saying

What they are saying

Watch the video tour and get ready to become your own boss

Play

BusinessTown founder Bob Adams’s courses and books have been featured in:

Learn how to start a business with our video courses

130+ courses

Unlimited access

50+ tools

Templates & more

Discussion board

Get expert answers

Frequently asked questions

BusinessTown is an e-learning platform built for people interested in starting and running a business. 

On BusinessTown, you get unlimited access to 130+ business courses taught by real successful entrepreneurs and highly skilled experts. You also gain access to 50+ business tools and to our discussion board, where you can get expert answers to your business questions.

No matter what you want to learn or where you are on your business journey, there is a course for you. 

Marketing, ideas, financing, planning, naming, how to get started… BusinessTown covers everything you need to start and run your business right. 

The courses are available anywhere, anytime, on any device, and you can take them at your own pace. 

Create your BusinessTown account to get started and try BusinessTown free for 7 days. 

BusinessTown includes unlimited access to 130+ business courses taught by real successful entrepreneurs and highly skilled experts.

You also get full access to 50+ downloadable tools like worksheets, templates, and samples, and to our discussion board where you can get an answer to any business question you have. 

BusinessTown is $19.95 per month. It provides unlimited access to all 130+ courses, all tools, and our discussion board, where you can get expert answers to your business questions.

We offer a free 7-day trial. If you decide that BusinessTown is not for you, then just cancel within 7 days of starting your free trial and you will not be charged at all.

If you wish to cancel your BusinessTown account, you can do so through your account page under the Billing section. 

If you have any questions, email us at bbisson@businesstown.com. We are more than happy to help!

BusinessTown includes 130+ courses on all business topics: Getting started, business ideas, business plans, strategy, marketing, websites, social media, online advertising, finance, accounting, leadership, sales, legal issues, home-based businesses and more!

Looking for a business idea? Why don’t you check out our course How to Find a Business Idea. 

Do you need help creating your business plan? We’ve got you covered. Take a look at our course How to Create a Business Plan.

Do you want to be walked step by step through the entire process of starting a business? Check out our ultimate course, Start-a-Business 101. 

Are you not sure that you are ready to start your own business? Consider our course, What It Takes to Start a Business.

Are you looking for financing for a new or existing business? We offer 5 courses on financing a small business. We suggest you start with the course, How to Finance Your Business.

Do you want to learn about marketing? Because it’s so important, we offer over 30 courses on sales and marketing. Consider starting with the short course, Developing Your Marketing Message.

Want to learn about marketing online? We offer 5 courses on creating websites, 6 courses on digital marketing and 5 courses on promoting through social media. To get started we recommend the course, The Complete Guide to Digital Marketing.

Looking to get inspired and learn how other entrepreneurs succeeded in starting and growing their businesses? We offer several courses on this including, How to Succeed as a Woman Entrepreneur.

Do you already have a business and are looking to improve it? We have several courses on this topic. Try starting with the course, How to Boost Profits.

No matter where you are on your business journey, there is a course for you.   

On BusinessTown you have access to 50+ downloadable tools like worksheets, samples, and templates to help you start and run a business. 

Our most popular tools include:

The Ultimate Startup Checklist, 18 pages 

The 300 Best Small Business Ideas ebook, 105 pages 

The Complete Business Plan Template, 29 pages

Complete Sample Business Plan, 35 pages 

Sample Marketing Plan Under $2k, 12 pages

One Page Marketing Plan Template

One Page Sample Marketing Plan

50 Guerilla Marketing Tactics Worksheet, 8 pages

Business Idea Evaluation Worksheet 

8 Basic Steps to Making the Sale Template

Sales Presentations that Your Customers Will Love Template

Sales Presentation Sample Dialog

50 Ways to Generate Endless Sales Leads Worksheet 

Cold Calling Script Template and Sample

Emails that Land Sales Template and Sample

Voicemails that Get Callbacks Template and Sample

Income Statement Templates and Samples

Balance Sheet Templates and Samples

Cash Flow Templates and Samples

Calculate Depreciation Template

Key Financial Ratios Sample

How I Started a Successful Business with No Money and No Experience, Case Study

Key Questions to Select the Best Business Idea Worksheet

Validate Your Business Idea Worksheet

Using the 6-Step Approach to Choose a Business Idea Case Study

21 Easy-to-Start Part-Time Business Ideas Guide

42 Home-Based Businesses You Can Start Guide

Why I Repeatedly Changed the Legal Entity of My Business, Case Study

Evaluate Customer Segments and Competitors Worksheet

Differentiate Your Business from Competitors Worksheet

How I Differentiated My First Business in a Crowded Marketplace, Case Study

Creating a Press Release Template and Sample

Marketing Bob’s Rent-A-Bike, Case Study

Planning, Designing and Creating Your Website Worksheet

Search Engine Optimization Worksheet

50 Blog Post Ideas Worksheet

50 Creative Online Marketing Ideas Worksheet

Evaluate Potential Names for Your Business Worksheet

How I Financed Buying a Business Case Study

Cover Letter to Seek Financing Sample

Collection Letter Samples

The Four Quadrant Theory of Time Management Graphic

BusinessTown courses will show you how to start your business right and grow it into a highly successful enterprise. 

You will learn from highly experienced entrepreneurs and experts who have been there and done it. You won’t have to learn by trial and error. You won’t have to guess what to do next. BusinessTown courses will guide you through your entire business journey.

Even if you are a beginner you will quickly learn how to start a business you love. If you already have a business, BusinessTown will show how to grow it and make it better.

By just watching one video lesson a day (about 7 minutes average) you can quickly ramp up your business knowledge. No matter where you are on your business journey, there is a course for you taught by an expert on BusinessTown.

What would you like to learn more about today? Starting a business? How to find a business idea? How to write a business plan? How to do your marketing? How to build an online presence? How to get financing? How to prepare financial statements? BusinessTown has courses that cover all these topics and hundreds more.

So if you want to become a smarter entrepreneur and start and build a successful business, you’ll want to start streaming the courses on BusinessTown today.

Copyright © 2021 BusinessTown LLC. All rights reserved. BusinessTown ® is a registered trademark of BusinessTown LLC.

QUIZ: WHAT BUSINESS IS BEST FOR YOU?

QUIZ: WHAT BUSINESS IS BEST FOR YOU?