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
What accounting method should I use for my Shopify store?
Most small Shopify stores can legally use cash basis accounting, but accrual often makes more sense once you're carrying inventory. Cash is simpler for tax prep, but accrual shows actual profitability by matching product costs to the revenue they generate.
Read answerWhat reports do I need to download from Amazon Seller Central each month?
The Settlement Report and Date Range Transaction Report are essential. FBA sellers also need storage fee and inventory adjustment reports. These downloads let you reconcile deposits and track the fees Amazon takes.
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 answerDo I need FIFO or LIFO for my retail inventory?
For most retail businesses, FIFO is the better choice. It matches how inventory actually moves through your store and keeps your balance sheet accurate. LIFO creates complexity that rarely benefits smaller retail operations.
Read answerHow do I track inventory for my online store?
Connect your sales platforms to accounting software, track cost of goods sold accurately, and reconcile physical counts regularly. The challenge isn't the tracking itself but getting all systems to sync reliably.
Read answerDo I need an accountant who understands e-commerce accounting?
Yes. E-commerce involves unique challenges like payment processor reconciliation, inventory costing, multi-channel tracking, and multi-state sales tax that general accountants often struggle with.
Read answer