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 do bookkeeping for a retail store?
Retail bookkeeping centers on tracking sales from your point of sale system, managing inventory costs, reconciling cash, and handling sales tax. The key is connecting your daily sales activity to accurate cost of goods sold calculations.
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 track inventory across multiple Amazon warehouses?
Amazon automatically distributes FBA inventory across fulfillment centers and tracks it for you. Your job is pulling the right reports and reconciling Amazon's data with your accounting records.
Read answerHow do I calculate inventory shrinkage for my retail business?
Inventory shrinkage is the difference between what your records show and what you physically count. Divide the difference by your book inventory value, then multiply by 100 to get your shrinkage percentage.
Read answerHow do I set up payroll for my small business?
Setting up payroll requires an EIN, state tax registrations, workers' comp insurance, and a method for processing pay. Arizona keeps it relatively simple with no local income taxes, but you still need accounts with the Department of Revenue and Department of Economic Security.
Read answerWhat's the best way to track food costs?
Weekly inventory counts and purchase tracking by category are the foundation. Compare actual food costs to theoretical costs from your POS to catch waste, over-portioning, or theft before they eat your margin.
Read answer