How do I handle inventory accounting for e-commerce?
Start by tracking the true cost of every product you purchase. This means more than just what you paid the supplier. Include shipping to your warehouse or fulfillment center, customs duties if importing, and any other costs to get the product ready for sale. This landed cost becomes your inventory value on the books and determines your profit margin when you sell.
Pick an inventory costing method and stick with it. Most e-commerce businesses use FIFO (first in, first out), which assumes you sell your oldest inventory first. This works well for products that might change in cost over time. The IRS requires consistency here, so once you pick a method, you can’t switch without good reason.
Your accounting system needs to talk to your sales platforms. Whether you’re on Shopify, Amazon FBA, or multiple channels, every sale should reduce your inventory balance and record cost of goods sold. Some platforms integrate directly with QuickBooks or other accounting software. Others require manual exports or third-party apps to bridge the gap. The goal is matching what you sold to what it cost you to buy, without manual data entry errors piling up.
Returns and damaged inventory need their own process. When a customer returns a product, it goes back into inventory if it’s resellable or gets written off if it’s not. Damaged goods sitting in a warehouse still show as assets on your books until you adjust them out. Ignoring this inflates your inventory value and understates your losses.
Physical inventory counts matter even if your software tracks everything automatically. Do a full count at least quarterly, more often for high-volume sellers. Compare what you count to what the books say. Discrepancies happen from theft, damage, miscounts, and platform errors. Finding a $500 variance in March is manageable. Finding $8,000 missing at year end is a problem that affects your taxes and your ability to trust your numbers.
Working with Merrimack Valley bookkeepers who understand inventory accounting saves time and catches issues you might miss. E-commerce inventory has quirks that general bookkeepers don’t always understand, like FBA storage fees, multi-channel fulfillment, and platform-specific reporting. Getting this right means knowing your true margins and having accurate financial statements that help you make better buying decisions.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What is the best accounting software for small businesses?
QuickBooks Online is the standard for most small businesses. It works well, integrates with almost everything, and nearly all accountants and bookkeepers support it. But the software matters less than how it's set up.
Read answerWhat financial records should landlords keep?
Landlords should keep income records, expense receipts, property acquisition documents, lease agreements, and depreciation schedules. These records support tax deductions, protect you in disputes, and help track property profitability.
Read answerHow do I know if my bookkeeper is doing a good job?
Look for monthly reconciliations completed on time, accurate financial statements you can actually understand, and stress-free tax preparation. A good bookkeeper catches problems before you do.
Read answerWhat are the bookkeeping requirements for Airbnb hosts?
Airbnb hosts need to track all rental income, document deductible expenses, and monitor personal use days for tax purposes. Many hosts also face local occupancy tax obligations that require separate registration and reporting.
Read answerHow do I handle payroll for employees in multiple states?
You need to register with each state where employees work, withhold taxes according to that state's rules, and pay state unemployment insurance separately for each jurisdiction. The complexity comes from every state having different rates, forms, and deadlines.
Read answerHow do I organize receipts and invoices I've been collecting all year?
Start by separating receipts from invoices, then sort into expense categories that match your bookkeeping. Digitize paper receipts, match everything to bank statements, and set up a simple weekly habit so you never face the same pile next year.
Read answer
