How do I track cost of goods sold for e-commerce products?
COGS for e-commerce includes everything you spend to get products ready to sell. That means the purchase price from your supplier plus inbound shipping, packaging materials, and any customs or duties if you import. This total is called your landed cost, and it’s what matters for tracking profitability.
Most e-commerce sellers use accounting software like QuickBooks connected to their sales platforms. Shopify, Amazon, and Etsy can sync sales data into your books. But recording sales is only half the equation. You also need to track what each product costs and reduce inventory when items sell.
If you carry inventory, set up products as inventory items in your accounting software with accurate costs. When you receive a shipment, record the purchase and add to inventory. When you sell, COGS should pull from inventory automatically. This perpetual inventory method keeps your books accurate without manual adjustments every time something ships.
The challenge comes when costs fluctuate. Your supplier raises prices, shipping rates change, or you find a cheaper source. Update your item costs when this happens. Using outdated costs means your COGS is wrong and your margins look better or worse than reality.
For Amazon FBA sellers, keep FBA fees separate from COGS. The product and getting it to Amazon’s warehouse is COGS. The referral fees, fulfillment fees, and storage fees are selling expenses. Mixing these makes it impossible to know if a product is profitable before Amazon takes their cut.
Multi-channel selling adds complexity. If you sell the same product on Shopify, Amazon, and Etsy, you need consistent COGS regardless of channel. The margin might differ due to platform fees, but the underlying product cost stays the same.
Inventory management apps like A2X, Cin7, or DEAR Inventory can automate much of this. They pull sales from all your channels, calculate COGS using your item costs, and push accurate numbers into QuickBooks. An Andover, MA bookkeeping service familiar with e-commerce accounting can help set up these integrations correctly from the start.
The goal is knowing your true gross margin by product. If something costs $12 landed and sells for $30, your gross margin is $18 or 60%. If you’ve been recording cost as $8 because you forgot shipping and packaging, you think you’re making 73% when you’re actually at 60%. That difference matters when deciding which products to promote, discount, or discontinue.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What are the business tax requirements in Massachusetts?
Massachusetts businesses face several tax obligations including entity-level taxes, sales tax collection, payroll withholding, and annual reporting. The specific requirements depend on your business structure and activities.
Read answerWhat happens if I file taxes with inaccurate books?
Filing taxes with inaccurate books leads to one of two problems: you underpay and face IRS penalties, or you overpay and lose money you didn't owe. Either way, messy books create risk that's avoidable with proper records.
Read answerHow do I set up payroll for my small business?
Setting up payroll requires an EIN, state tax registrations, employee paperwork, and a system for calculating wages and remitting taxes. Most small businesses use payroll software or outsource the function entirely.
Read answerWhat financial reports do investors want to see from startups?
Investors expect to see your income statement, balance sheet, and cash flow statement along with burn rate and runway calculations. They also want key metrics specific to your business model and projections showing how you'll use their capital.
Read answerHow do I give my accountant access to my QuickBooks file?
In QuickBooks Online, go to Settings, then Manage Users, and invite them as an Accountant user. For QuickBooks Desktop, you'll either create an Accountant's Copy or share the file directly.
Read answerWhat payroll records am I required to keep?
Federal law requires you to keep payroll records for at least four years. This includes employee information, wage and hour data, tax filings, and payment records. Different agencies have slightly different requirements, so keeping everything for four years covers your bases.
Read answer
