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 bookkeeping mistakes do small retail stores make?
Small retail stores commonly fail to track inventory as an asset, mix personal and business transactions, and skip daily cash reconciliation. These mistakes make financial reports meaningless and create tax problems.
Read answerWhat financial reports does a retail business need each month?
Retail businesses need a profit and loss statement, balance sheet, cash flow report, and inventory-specific reports like aging and turnover. These reports help you track margins, manage cash tied up in products, and make smarter buying decisions.
Read answerHow much does bookkeeping cost for a small business?
Small business bookkeeping typically costs $200 to $600 monthly for basic services. The actual price depends on transaction volume, industry complexity, and whether you need just the basics or more comprehensive financial management.
Read answerHow often should my books be updated?
Monthly is the minimum for most small businesses. Businesses with high transaction volume or cash-intensive operations benefit from weekly updates. The right frequency depends on how quickly you need financial information to make decisions.
Read answerHow do I do bookkeeping for a retail store?
Retail bookkeeping centers on tracking sales from your point of sale system, managing inventory costs, reconciling cash, and handling sales tax. The key is connecting your daily sales activity to accurate cost of goods sold calculations.
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