How do I calculate cost of goods sold for my e-commerce store?
The formula is straightforward: Beginning Inventory + Purchases - Ending Inventory = Cost of Goods Sold. The tricky part for e-commerce sellers is knowing exactly what costs belong in that calculation.
Product cost is the obvious component. What you paid your supplier for the goods you sell. But COGS should also include costs directly tied to getting inventory ready for sale. Inbound freight and shipping to your warehouse or fulfillment center counts. If you import products, include customs duties and tariffs. Packaging materials that you purchase separately to prepare items for sale also belong here.
What doesn’t belong in COGS is where most sellers get confused. Outbound shipping to customers is an operating expense, not a product cost. Amazon referral fees, Shopify payment processing fees, and advertising spend are all operating expenses. FBA storage fees go to operating expenses too. Mixing these into COGS throws off your gross margin and makes it impossible to see which products actually make money.
You also need to pick an inventory costing method. Most e-commerce businesses use either FIFO (First In, First Out) or weighted average cost. FIFO assumes you sell your oldest inventory first, which matters when product costs change over time. Average cost takes your total inventory value and divides by units on hand. Both are acceptable for tax purposes. Pick one and stay consistent.
The formula only works when you know your accurate inventory value at the start and end of each period. If you’re not doing regular inventory counts or your system doesn’t track costs properly, your COGS calculation will be off. This is where many sellers run into problems. They look at their profit margins and something doesn’t add up, but they can’t pinpoint why.
Accurate COGS directly affects your gross profit margin, which tells you whether your pricing works. Understated COGS makes you think you’re making more per sale than you actually are. Overstated COGS leads to incorrect inventory valuation on your balance sheet and can cause issues at tax time.
If your current numbers don’t match reality, inventory accounting setup might be the issue rather than the formula itself. Getting the tracking right from the start saves hours of cleanup later and gives you margins you can actually trust for pricing and purchasing decisions.
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 account for Shopify payouts and transaction fees?
Record your gross sales as revenue and Shopify fees as a separate expense. Don't just book the net payout amount to income or you'll underreport revenue and miss tracking what you're actually paying in fees.
Read answerHow do I account for food waste and spoilage?
Food waste and spoilage flow through your cost of goods sold, not as a separate expense. Track waste daily by category so you can see how much of your food cost comes from loss versus productive use.
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 answerHow do I understand my profit and loss statement?
The profit and loss statement shows whether your business made or lost money over a period. Read it from top to bottom: revenue minus cost of goods sold gives gross profit, then subtract operating expenses to get net income.
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 answerHow do I handle tip reporting and payroll for servers?
Employees report tips to you monthly, and you withhold taxes on those tips through payroll. The challenge is setting up systems to capture cash tips and integrating credit card tip data from your POS.
Read answer