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 value inventory for my online retail business?
Most e-commerce businesses use FIFO (First In, First Out) to value inventory. This method assumes you sell your oldest inventory first, which typically matches how online retail works and simplifies compliance.
Read answerWhy is my COGS wrong on my e-commerce profit and loss?
COGS errors in e-commerce usually come from how inventory is tracked. If purchases go straight to COGS instead of through an inventory account, or if your ending inventory balance is wrong, your cost of goods sold won't match reality.
Read answerShould my retail store use cash or accrual accounting?
Most small retail stores can use cash accounting for simplicity, but accrual gives you a clearer picture of profitability when you carry significant inventory. The right choice depends on your size, inventory levels, and growth plans.
Read answerHow do I fix duplicate transactions in QuickBooks?
Duplicates happen when the same transaction enters QuickBooks twice, usually from manual entry combined with bank feeds. Find them in the Banking section or account registers, then delete the duplicate or use the Match function to link records correctly.
Read answerDo Arizona businesses have special bookkeeping requirements?
Arizona's Transaction Privilege Tax creates unique bookkeeping needs because rates vary by city. Tracking TPT by jurisdiction and filing on the correct schedule are the main Arizona-specific requirements.
Read answerWhat's the best way to manage accounts payable for retail vendors?
Centralize all invoices in one system, match them to receiving documents before approving, and schedule payments based on each vendor's terms. Weekly AP reviews prevent missed payments and help you take advantage of early payment discounts.
Read answer