How Does the Inventory Adjustment Work? [With Examples]

If you're confused about the adjustment made to your income statement after inventory, you're not alone. Here, we'll look at ...

Share This Post

For anyone who has managed any retail location (not just a pharmacy), you know that at least a couple times per year an inventory company visits your site and counts everything in the store to provide a total value for current inventory.

You know that it is critical to get an accurate count and might have had regional or corporate offices providing detailed instructions on preparing for inventory. You also know that accounting does an inventory adjustment after getting your final inventory count.

In this post, we’ll look in-depth into the inventory adjustment to Cost of Goods Sold that occurs after inventory is taken. This is very helpful for any manager, whether in a pharmacy or not, to understand.

Let’s use examples to illustrate:

Let’s say you ended the last inventory with $100,000 on the shelf. You purchased $50,000 from your wholesaler between then and now. Because your purchases were $50,000, in a periodic inventory system your reported COGS (Cost of Goods Sold) for the period between inventories would be $50,000:

Inventory adjustment example 1

The total value of all the drugs you had in your possession during that time period is equal to the previous inventory + purchased goods over that time period: $150,000.

Now let’s go through a few scenarios to see how different ending Inventory amounts will affect COGS for the period.

Scenario 1

Inventory adjustment example 2

Scenario 1: Ending inventory of $80,000

This means that you had to have sold $150,000 – $80,000 = $70,000

You sold $70,000, but you only reported selling $50,000 (your COGS). That means you need to adjust COGS by $20,000, increasing your total expenses for the period and decreasing Net Revenue.

Scenario 2

Inventory adjustment example 3

Scenario #2: Ending inventory of $95,000

In this case the pharmacy sold $150,000 – $95,000 = $55,000

As in Scenario #1, we reported selling $50,000 but we actually sold $55,000; thus we need to add $5,000 to COGS, decreasing Net Revenue, but to a lesser extent than in Scenario #1.

Did you see what happened? A higher ending inventory decreases COGS for the period because it implies that you did not sell it and it instead is still on the shelf.

Basically what we are saying is if inventory is $95,000, you had to have sold all $50,000 off the shelf PLUS $5,000 of the $100,000 you originally had.

Many people I’ve met call this “taking a hit” at inventory when inventory is low because their income statement was falsely inflated and “looked better” prior to the COGS adjustment. It’s a frustration of many pharmacists and pharmacy managers, but it is required for accurate accounting!

Scenario 3

Now let’s look at one last example:

Inventory adjustment example 4

Scenario #3: $120,000

The pharmacy sold $150,000 – $120,000 = $30,000

However, we reported selling $50,000. So this time we need to subtract $20,000 from COGS, increasing Net Revenue for the period.

Again, these drugs were not sold yet (and so do not go under COGS) but rather were purchased and are still in inventory.

That is why an accurate count is so important.

The Bottom Line

As a manager or owner, if the inventory company arrives to count and a section is missed, for example, it basically appears you sold that entire section but you never got revenue to show for it; because of this, your overall revenue is going to look much lower than it should.

If you are interested in learning more about accounting and decoding that income statement you get every month, one of my favorite sites to learn more is actually the website for the textbook I used during my accounting courses for business school.

If you are a manager (and especially if you are an owner) I highly encourage you to bookmark it. All materials on the site are free and include powerpoints and sample questions so it’s a great resource

Healthcare Disclaimer: The information provided  on Pharmacists.org is for educational and informational purposes only and is not intended to serve as medical advice. Our tools are designed to provide general conversion estimations and should not be used as a substitute for professional medical advice, diagnosis, or treatment. Always seek the advice of your physician, pharmacist, or other qualified health provider with any questions you may have regarding a medical condition or medication. Read More in our Terms of Use.

Share This Post

Recent Articles

Share On:

More To Explore

Pharmacogenomics in the Community Pharmacy

It’s no secret that pharmacies are going to have to diversify their revenue streams and continue to expand on non-dispensing revenue in order to

An interview with Tyler Taylor, PharmD, of St. Louis Hills Pharmacy

St. Louis Hills Pharmacy has actually implemented compostable prescription vials in their store. In addition, they have an entire page of their website dedicated

Drug Supply Chain and Security Act Infographic

This infographic is a visual representation of the post Top Things to Know About the Drug Supply Chain and Security Act (DSCSA). Get your

Optimize Your Pharmacy Software System [18 Ways]

Making the most of your computer system is one of the easiest, no-cost ways you can improve your workflow, save time, and reduce the

Hazardous Drug Handling in the Community Pharmacy

One of the most commonly overlooked areas of community pharmacies I have either managed or worked in involves the handling and dispensing of hazardous

9 Tips for Managing Controlled Substances in the Pharmacy

It’s no secret controlled substances are one of the biggest subjects of any pharmacy inspection, so if your pharmacy doesn’t have a good handle

HIPAA and Drug Reps: What Info Can I Release?

I got an interesting email recently from a pharmacist who read an article I wrote in the past for Pharmacy Times about drug reps

Responding to a State Board of Pharmacy Complaint

This article is by Jeffrey Baird, esq., a healthcare attorney who practices with Brown and Fortunato, PC. I thought it gave a great overview

Best Practices: The Compliance Binder

The Compliance Binder is a pharmacy best practice that will really make your life easier. While not legally required, the compliance binder has everything

How to Manage a Drug Recall

Systems to quickly manage recalls are an important, but often overlooked, area of pharmacy operations. This was brought to the forefront of the public’s

Maximizing Your Pharmacy Switch

Your pharmacy switch routes the claim from your pharmacy to the insurance company. Here’s what you need to know.

6 Top Tips to Know about DSCSA (Drug Supply Chain Security Act)

Here’s what you need to know about DSCSA to stay compliant and avoid fines.

3 Most Frequently Asked Questions About the 340b Program

If you’re wondering where to get started with the 340b program, this is a great place to get started.

What is a Surety Bond?

What is a surety bond? Let’s look a little more closely at why you should get one for your pharmacy.

The Ultimate Guide to DMEPOS Accreditation for Pharmacies

Need to get DMEPOS Accreditation? Here’s a step-by-step guide.

How to Read an Income Statement

If you’re new to accounting and finance, the income statement can be confusing. Here’s what to look for.

Tips to get started with pharmacy sustainability

I’m sure you can guess from the title what this post is about. Today we’re going to talk about greening the community pharmacy. Why

5 Great Pharmacy Organization Ideas

If you’ve been putting off getting your pharmacy organized, there’s never been a better time to get started. Here are a list of ideas

Tracking Licenses and Certifications

This state law also requires all pharmacy technicians to ultimately obtain certification from NCCA-accredited organizations (i.e., PTCB or NHA) after a provisional grace period.

Infographic: USP 800 Visual Guide

This one guides you through a very brief overview of each chapter of USP 800.

The 7 BEST Shoes for Pharmacy Staff [2024]

Pharmacists spend a long time on their feet, and in such a demanding environment, a good pair of shoes becomes more than just an

The Pharmacy Equipment Marketplace

This week’s Quick Tip comes from Shawn Earl, PharmD. Dr. Earl is the founder of Pinnacle Pharmacy Group and specializes in pharmacy mergers and

Are you tracking exclusions?

This Quick Tip is a reminder for pharmacies that they need to be checking all their staff at hire and at least monthly to

The Correct Medical Refrigerator Temperature Range

According to the CDC Vaccine Storage and Handling Toolkit, the correct medical refrigerator temperature range is 36-46 Fahrenheit.
error: Content is protected !!