How do I calculate my retail store's gross profit margin?
The formula is straightforward: subtract your cost of goods sold from your revenue, divide by revenue, and multiply by 100 to get a percentage. If your store brought in $50,000 in sales last month and your cost of goods sold was $30,000, your gross profit margin is 40%.
Getting your cost of goods sold right is where most retailers struggle. COGS includes what you paid for the inventory you actually sold, plus freight and shipping to get products to your store. It doesn’t include rent, payroll, utilities, or other operating expenses. Those come out after gross profit when calculating net profit.
Many retailers confuse markup with margin, and this leads to pricing mistakes. If you buy a product for $60 and sell it for $100, your markup is 67% ($40 profit divided by $60 cost). But your gross margin is 40% ($40 profit divided by $100 selling price). Margin tells you what percentage of each sale is gross profit. Markup tells you how much you added to your cost. They’re related but not interchangeable.
Shrinkage affects your real margin even if it doesn’t show up in your basic calculation. Theft, damage, and counting errors all reduce inventory without generating sales. If you’re calculating margin from purchase records alone without adjusting for shrinkage, your numbers look better than reality. Regular inventory counts help you see the actual picture.
Markdowns hit margin harder than most retailers realize. You might achieve a 55% margin at full price, but once clearance sales and promotions enter the mix, your blended margin drops significantly. Tracking margin separately for full-price versus marked-down sales shows where profit is actually coming from.
The most useful approach is tracking gross margin by category or product line. Some categories carry your store while others barely break even once you factor in the shelf space they occupy. A retail bookkeeping setup that tracks margin by category helps you make smarter purchasing and merchandising decisions.
Your accounting software should calculate this automatically if transactions are coded correctly. QuickBooks can generate gross profit reports by category when your chart of accounts and product categories are configured properly. If you’re calculating margin manually from spreadsheets each month, the right small business bookkeeping system can save you hours and give you more useful information.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I reconcile accounts that haven't been reconciled in months?
Start with the oldest unreconciled month and work forward chronologically. Gather all your bank and credit card statements, then tackle one account at a time until you're current.
Read answerWhy can't I figure out where my money is going?
The problem is usually looking at the wrong information. Bank statements show transactions but not patterns. Properly categorized books with monthly review show exactly where every dollar went.
Read answerHow do I do job costing for my construction business?
Job costing means assigning every expense to a specific project so you can see which jobs make money. Set up cost codes by phase, track labor and materials in real time, and compare actual costs to estimates weekly.
Read answerAre there bookkeepers in the East Valley who specialize in e-commerce?
Yes, several bookkeeping firms in the Greater Phoenix area specialize in e-commerce. Since bookkeeping is largely digital, you're not limited to firms physically located in the East Valley.
Read answerWhat accounting software works best for retail stores?
The best accounting software for retail depends on your inventory complexity and POS system. QuickBooks Online and Xero both work well for most retail stores, but the right choice depends on what integrations you need and how many products you carry.
Read answerWhy are my restaurant margins so thin?
Restaurant margins are naturally thin, typically 3% to 9% net profit. If yours are even tighter, the problem is usually hiding in food costs, labor efficiency, menu pricing, or a combination of all three made worse by poor financial visibility.
Read answer