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
What is the best way to track intercompany transactions between healthcare entities in QuickBooks?
Set up Due To and Due From accounts in each entity's QuickBooks file to log every payment made on behalf of another entity. QuickBooks Online lacks built-in intercompany elimination, so you'll need manual journal entries and monthly reconciliation between entities.
Read answerWhat California labor laws affect salon payroll and bookkeeping?
California has strict rules around tip credits, daily overtime, meal and rest breaks, piece-rate pay, and worker classification that directly impact how salon owners run payroll and keep their books. Getting any of these wrong can trigger EDD audits and costly penalties.
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 does a nonprofit need for Form 990 preparation and how does bookkeeping help?
Form 990 requires functional expense allocation, revenue by source, key employee compensation, governance disclosures, and program accomplishments. Clean monthly bookkeeping with proper categorization makes 990 prep straightforward instead of an expensive reconstruction project.
Read answerHow do I set up bookkeeping for a medical practice with multiple LLCs and entities?
Each entity needs its own QuickBooks file with a consistent chart of accounts across all of them. Intercompany transactions like management fees, shared staff costs, and rent between entities must be tracked carefully and eliminated when you pull consolidated reports.
Read answerHow should a salon owner categorize tip income and tip payouts in bookkeeping?
Credit card tips flow through your merchant processor as part of the full deposit. Record the tip portion as a liability you owe stylists, not as your revenue. When you pay tips out, run them through payroll for proper tax withholding.
Read answer
