Bookkeeping, payroll, and controller services for small businesses in Scottsdale and Greater Phoenix.

Call or Text: (623) 439-9961

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's the best way to track Amazon seller fees in QuickBooks?

The key is breaking apart Amazon's net deposits into gross sales and individual fee categories. You can do this manually using settlement reports or automate it with integration tools like A2X.

Read answer

Why don't my Amazon deposits match my sales reports?

Amazon deposits are net amounts after fees, refunds, advertising costs, and reserves are deducted. The number hitting your bank is what remains after Amazon takes its cut, not your gross sales.

Read answer

How do I reconcile Amazon payouts with my bank account?

Amazon deposits a net payout that includes sales minus fees, refunds, and reserves. Use your Settlement Report from Seller Central to see what's inside each deposit and record the components separately in your books.

Read answer

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 answer

How do I do bookkeeping for my Amazon FBA business?

The key is understanding that Amazon deposits aren't your revenue. They're the net result after fees, refunds, and deductions. You need integration software to break down settlements properly and careful tracking of inventory costs.

Read answer

Scottsdale bookkeeping firm serving small businesses across Greater Phoenix. Full-service bookkeeping, payroll, and outsourced controller services backed by over a decade of hands-on accounting experience.

Location

15333 N Pima Rd, Ste 305 Office 363, Scottsdale, AZ 85260

Client Reviews

5-Star Rated Firm

© 2026 LedgeTrakr Bookkeeping