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 reconcile Toast POS with my accounting?
The key is understanding that Toast deposits net of fees, not gross sales. You need to record your full sales amount, then separately track processing fees and tips to match what actually hits your bank account.
Read answerHow do I handle Arizona sales tax collection?
Register for a Transaction Privilege Tax license with the Arizona Department of Revenue, then collect at the combined state, county, and city rates based on where your business is located. Arizona uses an origin-based system, so your location determines which rates apply for most in-person sales.
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 answerHow often should my books be updated?
Monthly is the minimum for most small businesses. Businesses with high transaction volume or cash-intensive operations benefit from weekly updates. The right frequency depends on how quickly you need financial information to make decisions.
Read answerHow do I handle contractor payments and 1099s?
Collect a W-9 before making the first payment, track all payments by contractor in your accounting software, and file 1099-NEC forms by January 31 for anyone you paid $600 or more.
Read answer