How should an e-commerce business track COGS when products come from multiple suppliers?
Your product cost is not just what the supplier charges you. It’s the total amount you spend to get that item into sellable condition. When you source from multiple suppliers with different pricing, shipping methods, and import requirements, getting this number right is the difference between knowing your real margins and guessing at them.
Use the landed cost method for every product. That means your per-unit cost includes four components: the supplier’s unit price, inbound shipping allocated across units in the shipment, import duties and tariffs if the product is coming from overseas, and any prep or labeling fees like FBA prep, poly bagging, or barcode stickering. Add those together and you have your true cost. A product that costs $8.00 on the supplier invoice might actually cost $11.40 once ocean freight, customs duties, and warehouse prep are factored in. If you’re only recording the $8.00, every margin calculation you run is wrong.
When two suppliers sell you the same product at different prices, record each purchase at its actual landed cost. QuickBooks Online tracks COGS on a FIFO basis, meaning when you sell a unit it deducts the cost of the oldest inventory first. If you bought 100 units at $11.40 landed and later 100 more at $12.10 from a different supplier, QBO expenses the $11.40 units first as you sell through them. This works correctly as long as you record each purchase accurately when it happens. Proper inventory accounting requires this discipline with every shipment received.
Set up your inventory items in QuickBooks with enough detail to track costs by product or product category. Don’t lump everything into one generic inventory account. If you sell phone cases and screen protectors, track them separately so you can see COGS for each line. That granularity is what makes your reporting useful.
Run a COGS report by product or category every month. This is how you catch margin erosion before it damages your profitability. Maybe a supplier raised prices 5% three months ago and you never adjusted your selling price. Maybe freight costs from one vendor crept up. Maybe duties changed on a tariff code. You won’t notice any of this looking at total COGS as one number. Breaking it down by category shows you exactly where margins are shrinking and which supplier relationships need attention.
For imported products, keep documentation organized by shipment. Each inbound shipment has its own supplier invoice, freight bill, customs entry, and duty charges. Allocate those costs across the units in that shipment to arrive at your per-unit landed cost. Do this consistently every time product arrives, not retroactively at the end of the quarter when you can’t remember which charges went with which shipment.
The common mistake is treating COGS tracking as something you clean up later. It needs to happen as inventory comes in. If you wait, costs get estimated or averaged incorrectly, and your product-level profitability data becomes unreliable. Every pricing and purchasing decision you make depends on accurate cost data. Our Orange County small business bookkeeping services work with e-commerce sellers to build this tracking into their regular workflow so the numbers are right from the start, not reconstructed after the fact.
Orange County's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote with no surprises.
More Questions
How do I track purchase orders and vendor payments for a wholesale business?
Use QuickBooks Online to create purchase orders, receive inventory, and match vendor bills. Track PO status, vendor payment terms, and early payment discounts. Run A/P aging reports regularly because large orders can tie up cash for 60 to 90 days before you sell through.
Read answerHow does sales tax work for wholesale transactions in California?
Wholesale sales to resellers are generally exempt from California sales tax, but only if the buyer provides a valid resale certificate. Without that certificate on file, you as the seller owe the tax.
Read answerHow should a medical practice allocate shared overhead costs across multiple locations?
Pick an allocation method that reflects how each location actually drives the cost. Revenue-based, patient volume, headcount, and square footage are the most common approaches. The method you choose matters less than documenting it and applying it consistently.
Read answerWhat are the bookkeeping requirements for importing goods into California?
California importers need to track customs duties by harmonized tariff code, pay use tax on goods when sales tax wasn't collected at entry, file with the CDTFA, and maintain resale certificate files if selling wholesale. Getting any of these wrong creates audit exposure.
Read answerHow often should a restaurant owner review their books and what reports matter most?
Weekly at minimum for food cost, labor cost, and daily sales trends. Monthly for the full P&L, prime cost analysis, A/P aging, and cash flow. Thin margins mean waiting too long to review your numbers can cost thousands before you notice.
Read answerWhat is landed cost and how do I track it for imported goods?
Landed cost is the total cost of getting a product to your warehouse, including freight, duties, insurance, and handling fees. For accurate COGS, all of these costs must be allocated to inventory rather than expensed separately.
Read answer
