Course Outline
Join PRO

How do I determine the cost of missing inventory?

Author:
Harold Averkamp, CPA, MBA

Definition of Determining the Cost of Missing Inventory

The approximate cost of missing inventory is the difference between 1) the cost of the inventory items that are physically present or accounted for, and 2) the cost of the inventory that should be on hand based on the accounting information.

Examples of Determining the Cost of Missing Inventory

If a company’s accounting records or its inventory system uses the perpetual inventory system (and it is maintained properly), determining the cost of the missing inventory is easy. You simply subtract the cost of the items that are in inventory from the costs shown in the perpetual inventory system.

If the perpetual inventory method is not used (or it is not maintained properly) you can determine the cost of the missing inventory with the following steps:

  1. Determine the cost of the inventory at the time of the previous physical inventory. Let’s assume this occurred on the prior December 31.
  2. Determine the cost of all the goods that were purchased since December 31.
  3. Combine Step 1 and Step 2 to arrive at the cost of goods available.
  4. Determine the cost of goods sold percentage. This is 100% minus the company’s normal gross profit percentage. (This should be available from the previous year’s income statements.
  5. Multiply the cost of goods sold percentage times the sales since December 31. The result is the approximate cost of goods sold.
  6. Subtract the approximate cost of goods sold (Step 5) from the cost of the goods available (Step 3). This is the approximate cost that should be in inventory.
  7. Determine the cost of the goods that are actually in inventory.
  8. Subtract the cost of the goods that are actually in inventory (Step 7) from the cost of goods that should be in inventory (Step 6). The shortage is the cost of the missing inventory.
Join PRO to Track Progress
Must-Watch Video

Learn How to Advance Your Accounting and Bookkeeping Career

  • Perform better at your current job
  • Refresh your skills to re-enter the workforce
  • Pass your accounting class
  • Understand your small business finances
Watch the Video

Join PRO or PRO Plus and Get Lifetime Access to Our Premium Materials

Read all 2,645 reviews

Features

PRO

PRO Plus

Features
Lifetime Access (One-Time Fee)
Explanations
Quizzes
Q&A
Word Scrambles
Crosswords
Bookkeeping Video Training
Financial Statements Video Training
Flashcards
Visual Tutorials
Quick Tests
Quick Tests with Coaching
Cheat Sheets
Business Forms
All PDF Files
Progress Tracking
Earn Badges and Points
Certificate - Debits and Credits
Certificate - Adjusting Entries
Certificate - Financial Statements
Certificate - Balance Sheet
Certificate - Income Statement
Certificate - Cash Flow Statement
Certificate - Working Capital
Certificate - Financial Ratios
Certificate - Bank Reconciliation
Certificate - Payroll Accounting

About the Author

Harold Averkamp

For the past 52 years, Harold Averkamp (CPA, MBA) has worked as an accounting supervisor, manager, consultant, university instructor, and innovator in teaching accounting online. He is the sole author of all the materials on AccountingCoach.com.

Learn More About Harold

Certificates of
Achievement

Certificates of Achievement

We now offer 10 Certificates of Achievement for Introductory Accounting and Bookkeeping:

  • Debits and Credits
  • Adjusting Entries
  • Financial Statements
  • Balance Sheet
  • Income Statement
  • Cash Flow Statement
  • Working Capital and Liquidity
  • Financial Ratios
  • Bank Reconciliation
  • Payroll Accounting
Badges and Points
  • Work towards and earn 30 badges
  • Earn points as you work towards completing our course
View PRO Plus Features
Course Outline
Take the Tour Join Pro Upgrade to Pro Plus