Jessica Grant56 said:If any of my fellow accounting pros out there have figured this one out, please, help a girl out—I feel like I’ve been spinning my wheels for years now!!
It's about inventory shrinkage. We're allowed a 1% margin for loss—but how does that calculation actually work?!? Do I take all the items sold and apply 1% (to the cost price?), or is it based on the retail value? Or is there some other way to do it?
The "little" issue here is that I'm dealing with 1,444 different SKUs, though honestly, I don't care. I can pull subsets if the total sales for a specific item are low enough.
Look, obviously I'm going to hunt down every single penny we can save. Things are so tight at our company right now that we're basically breathing through a straw. And don't even get me started on those extra state income tax hikes—it really killed what little faith I had left in the government. It's why I clipped this headline from the news:
Belgians, Greeks, and Americans face some of the highest labor taxes in the world! DISGRACEFUL!!!!!
I went through the exact same struggle a few years back. After a lot of trial and error, I settled on creating a list of sold goods (using retail value) categorized by item groups for the allowable shrinkage—for example:
- clothing qty x price = amount
- footwear qty x price = amount
- women's socks qty x price = amount
etc.
following all the standard accounting guidelines.
For each category list, I'd subtract 1%, 1.5%, or 1.8% depending on the specific group, then record the deficit in the ledger and attach the corresponding inventory list.
Now, I’m certainly no professional CPA, so I can't say for sure if this is the textbook way to do it, 😉
but I believe it satisfies the regulatory requirements. At the end of the day, the key is having clear records of sold goods broken down by item type.