Why is my COGS wrong on my e-commerce profit and loss?
The most common reason COGS is wrong on an e-commerce profit and loss is that inventory isn’t being tracked properly. If you’re recording product purchases as an expense instead of routing them through an inventory asset account, your COGS will match your purchases rather than your actual sales.
COGS should reflect the cost of products you actually sold during the period. The formula is Beginning Inventory plus Purchases minus Ending Inventory equals Cost of Goods Sold. If your accounting software isn’t calculating this correctly, or if you’re skipping the inventory step entirely, the numbers won’t make sense.
Check your ending inventory balance first. If it hasn’t changed in months or doesn’t match what’s actually sitting in your warehouse or FBA, your COGS is being calculated from a wrong number. Physical inventory counts need to happen regularly and get recorded in your books. Without accurate ending inventory, the formula breaks down.
Another common issue is missing landed costs. COGS should include everything you paid to get the product ready to sell. That means inbound shipping, customs duties, tariffs, and sometimes packaging materials. If you’re only counting the unit cost from your supplier, you’re understating what the inventory actually cost you. This makes your gross margin look better than it really is until you wonder where all your cash went.
Platform fees and fulfillment costs often get miscategorized too. Amazon FBA fees, pick and pack charges, and referral fees are operating expenses, not COGS. These are selling costs that happen after the product is ready to sell. When they get lumped into COGS, it inflates that line item and makes your gross margin look worse than it should be while understating your operating expenses.
Returns cause problems if they’re not handled correctly. When a customer returns a product, you need to reverse the revenue and add the inventory back. If you only reverse the revenue, your COGS stays inflated because you counted the cost without counting the return to inventory.
Multi-channel selling adds complexity. If you’re selling on Amazon, Shopify, and maybe a few other platforms, inventory movements need to reconcile across all of them. Selling the same product on multiple channels while only tracking inventory in one place creates gaps where COGS doesn’t match what actually moved.
For e-commerce businesses, getting COGS right matters more than in many other industries because margins are often thin. A 5% error in COGS could swing your reported profit dramatically. You might think you’re making money on a product line when you’re actually losing it.
The fix usually starts with establishing proper inventory tracking in your accounting software. Products get purchased into an inventory asset account. When they sell, the cost moves from inventory to COGS based on your costing method. Your Scottsdale bookkeeping services provider should be reconciling inventory regularly and making sure the flow from purchases to inventory to COGS follows the actual movement of goods.
If your books have been running without proper inventory accounting for a while, you’ll likely need to do some cleanup work to establish accurate balances before the numbers start making sense going forward.
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 should I look for when hiring a bookkeeper for my Shopify store?
Look for someone with specific e-commerce experience who understands how Shopify reports revenue, handles payment processor reconciliation, and knows multi-state sales tax rules. General small business bookkeeping skills aren't enough for the complexity of online selling.
Read answerWhy are my restaurant margins so thin?
Restaurant margins are naturally thin, typically 3% to 9% net profit. If yours are even tighter, the problem is usually hiding in food costs, labor efficiency, menu pricing, or a combination of all three made worse by poor financial visibility.
Read answerWhat does an outsourced controller do for a small business?
An outsourced controller handles financial oversight and reporting above basic bookkeeping. They manage your monthly close process, prepare meaningful financial statements, establish internal controls, and give you confidence your numbers are accurate.
Read answerWhat is A2X and do I need it for my Amazon accounting?
A2X is software that automatically pulls Amazon settlement data into your accounting software, breaking out sales, fees, refunds, and FBA charges. You probably need it once you're doing consistent volume and want accurate financials.
Read answerHow do I handle progress billing for construction projects?
Define billing milestones in your contract, create a schedule of values, and invoice consistently at each project phase. Track retainage separately and record each billing against the specific job in your accounting system.
Read answerWhy can't I figure out where my money is going?
The problem is usually looking at the wrong information. Bank statements show transactions but not patterns. Properly categorized books with monthly review show exactly where every dollar went.
Read answer