The Hidden Problem with Inventory Accounting

Categories:

Many independent pharmacy owners do not keep a perpetual inventory and are just guessing at their inventory. In this video, Ollin Sykes of Sykes & Company, P.A. explains how to keep up with inventory. A good script management and inventory system helps control cash, gross margins and profit. Your gross profit will not be accurate if you are guessing at your inventory. Hear the main factors that can impact the accuracy of inventory counts.

What is your inventory telling you about profits? Learn more here.


If you prefer to read this content, the video transcript is below.

Well, the key reason that inventory accounting doesn’t work is that most pharmacies don’t have a clue of what their inventory, either in the prescription area or the OTC area is, because they’re not keeping perpetual inventory systems and they’re taking manual counts periodically and they’re just guessing what that inventory levels are if they’re making adjustments during the course of the year. I would say our experience is only about 40% of the pharmacies are keeping perpetual inventory systems, and with the scan systems, where you’re scanning things in that come in the back door, you’re scanning things that go out through the register, whether that be prescriptions or OTC items that you’re selling, it’s so easy to be able to keep up with inventory if you do, if you do it properly. And the tools that are available by some of these script management systems and inventory systems that are out there make it much easier to deal with than ever before because everything is barcoded.

Everything can be scanned. And when you’re doing that, you can control not only your inventory, but can control your cash, control what your gross margin and your profit is. But if you don’t know what your inventory is and you’re just guessing, then your gross profit is not gonna be accurate. And if your gross profit’s not accurate, and that’s the single most important key performance indicator of all on your financial statements is to understand what that gross profit is, if it’s not accurate because you don’t know what those, that inventory is and you don’t know what your payables are that tie into that, then you got a system, an accounting system, that’s totally out of control. There’s a chance, not only for employee error, but there’s also a chance for pricing errors to occur. And so much of this pricing information is coming in because, obviously, you’ve got quantity times the price.

So quantity is what you get through the counts. The pricing is what you’re typically downloading from your wholesalers or, you know, whoever that you’re buying from, and, in some cases, that pricing information can be flawed or be in error and things need to be looked at and reviewed. And it’s like I tell pharmacies, if you take the top 15, 20, 25 drugs that you have in your prescription area by dollar volume on the shelf and just overview the quantity and the pricing of those drugs, that may be 75% of what you’ve got on your shelf and you should be able to spot whether there’s any obvious pricing errors or quantity errors just by doing a quick scan manually. So it’s not rocket science.

Even though you may have literally hundreds of drugs’ ADC codes on the shelf, again, I bet the top 25 represent, on a dollar value basis, 75, 80% of what you’ve got there. And if you just narrow it down to these high volume dollar items to make sure that you’re doing some kind of cycle counts. That’s what that’s called, typically, for the pharmacies that are keeping perpetual systems in place. They’re performing periodic cycle counts to verify what they have on a shelf. And maybe they have four pharmacy shelves. They’re counting one shelf every four months that’s being counted so they don’t have to stop what they’re doing and count it all at one time. But there could be pricing as well as could be quantity errors, and, yeah, they can occur all the time which is why you’ve gotta keep your eyes on it continuously.

Related Episodes

Compounding Success: Navigating GLP-1 Growth, Compliance, and Quality With Dr. Kevin Borg, PharmD

Looking at getting into compounding? Don’t just dabble, go all in.   That’s the theme of this week’s episode of The Bottom Line Pharmacy Podcast!  Scotty Sykes, CPA, CFP and Marketing guru Austin Murray of Sykes & Company, P.A. sat down with Dr. Kevin Borg PharmD,...

read more

Navigating the Pharmacy Marketplace Featuring Wade Hinkle, Founder and CEO of Pharmacy Market Place

Buying from primary vs. Secondary wholesalers, when is it best for your pharmacy and how does it impact your bottom line?   In this episode of The Bottom Line Pharmacy Podcast, Scotty Sykes, CPA, CFP, Bonnie Bond, CPA, and Ollin Sykes, CPA, CITP, CMA sit down with...

read more

The Bottom Line Pharmacy Podcast: Pharmacy Reconciliation 101: Managing Payments Effectively Featuring Vanessa Luu, Supervisor of Reconciliation at EnlivenHealth®

Is your pharmacy getting paid what it’s supposed to be getting paid? Make reconciliation your superpower!  In this episode of The Bottom Line Pharmacy Podcast, Scotty Sykes, CPA, CFP® and Bonnie Bond, CPA sit down with Vanessa Luu, Supervisor of Reconciliation at...

read more

The Bottom Line Pharmacy Podcast Pharmacy Automation Inside Out: Cost-Control and Tax Strategies Featuring Darin Gleason, ScriptPro

Questions about robotics and tax planning? Don’t miss this episode of The Bottom Line Pharmacy Podcast!  Join Scotty Sykes, CPA, CFP and Bonnie Bond, CPA as they sit down with Darin Gleason, National Sales Director for Retail Pharmacies at ScriptPro to discuss: ...

read more

The Bottom Line Pharmacy Podcast: Navigating Pharmacy Chain Closure Cash Flow Challenges Featuring Greco De Valencia Y Sanchez

With Walgreens planning to close 25% of its locations over the next 3 years, many independent pharmacies will face significant cash flow challenges from underwater scripts leaving and then coming back to new scripts transferring. In this episode of The Bottom Line...

read more

Maximizing Your Largest Expense – Inventory

Owning an independent pharmacy is not easy. Pharmacy owners have misreported inventory by millions of dollars, says Scotty Sykes, CPA, CFP®. Jared Barton of Inventory iQ* tells us how we can rectify the situation by putting the time and effort into the foundation of a...

read more

Search our Podcast Library

  • Type to Search

  • Filter by Category

  • Filter by Tag

Ready to take your pharmacy to the next level?

Contact us today to schedule a complimentary call with one of our pharmacy CPA advisors. Or jump right in and asses your growth potential with our Rx Assessment, exclusively for pharmacy owners.

CONTACT US      GET AN Rx ASSESSMENT

Schedule a complimentary call with one of our pharmacy CPA advisors, or jump right in and asses your growth potential with our Rx Assessment.

CONTACT USGET AN Rx ASSESSMENT