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
What bookkeeping does a contractor need to track?
Contractors need job-level cost tracking that standard bookkeeping doesn't provide. Every expense, labor hour, and subcontractor invoice should tie to a specific project so you can see which jobs actually make money.
Read answerHow do I track returns and chargebacks for my online store?
Record returns as revenue reductions and chargebacks as disputed transactions with their associated fees. Keep them in separate accounts so you can see patterns and understand your actual margins.
Read answerAre there bookkeepers in the East Valley who specialize in e-commerce?
Yes, several bookkeeping firms in the Greater Phoenix area specialize in e-commerce. Since bookkeeping is largely digital, you're not limited to firms physically located in the East Valley.
Read answerHow do I handle accounts payable efficiently?
Efficient accounts payable comes down to centralizing invoice intake, coding bills as they arrive, and batching payments on a set schedule. Most inefficiency comes from chasing paper, scrambling at the last minute, and paying bills one at a time.
Read answerWhat accounting firms in Scottsdale work with small businesses?
Scottsdale and the greater Phoenix area have many accounting options for small businesses. The key is finding a firm that matches your actual needs, whether that's bookkeeping, tax preparation, or higher-level financial guidance.
Read answerHow do I prepare my retail store books for an audit?
Start with reconciled accounts, verified inventory records, and documentation for every transaction. Retail audits focus heavily on inventory valuation, cash handling, and sales tax compliance.
Read answer