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
How do I handle consignment inventory in my books?
The key rule is that whoever owns the goods records them as inventory. If you're selling someone else's products on consignment, those items don't hit your inventory until they sell. If you're placing your goods with another retailer, they stay on your books until that retailer makes a sale.
Read answerWhat bookkeeping do HVAC and plumbing businesses need?
HVAC and plumbing businesses need job costing to track profitability by service call, inventory management for parts, payroll tracking for technicians, and cash flow management to handle seasonal fluctuations.
Read answerHow do I do bookkeeping for a restaurant?
Restaurant bookkeeping requires tracking daily sales from your POS, managing food and labor costs as percentages of revenue, handling tips correctly for payroll, and reconciling cash every single day.
Read answerWhen should a small business hire an outsourced controller?
Most small businesses are ready for an outsourced controller when they've outgrown basic bookkeeping but can't justify a full-time financial manager. This usually happens between $1 million and $5 million in revenue, though complexity matters more than a specific number.
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 set up payroll for my small business?
Setting up payroll requires an EIN, state tax registrations, workers' comp insurance, and a method for processing pay. Arizona keeps it relatively simple with no local income taxes, but you still need accounts with the Department of Revenue and Department of Economic Security.
Read answer