Most Amazon FBA sellers and Shopify store owners discover gaps on their balance sheets only after a surprise tax bill, a failed funding review, or a product launch that looked profitable on paper but drained the bank account. The problem is almost always the accounting behind the inventory.
The firms that fix this fastest are the ones that understand both eCommerce operations and accounting. At AMZ Accountant, we recognize that this combination is rare in general practice, which is why eCommerce sellers consistently outgrow their generalist accountants before they outgrow their platforms.
Keep reading to learn how inventory accounting for ecommerce works in practice, which costing methods protect your margins, what belongs inside your product cost, and which reporting habits turn clean numbers into smarter decisions.
Why Inventory Accuracy Drives Profit
Inaccurate inventory numbers do not just cause headaches at year-end. They erode your profit margin every single month.
How Stock Errors Distort Margin
When your unit count is wrong, your cost of goods sold (COGS) is wrong. COGS is the direct cost tied to the products you sell, and it sits at the top of your income statement. Overstate your inventory, and you understate COGS, which makes your margin look better than it actually is. Understate it, and you pay tax on profit you never earned. Neither error is harmless.
This is especially common for Amazon sellers managing stock across multiple fulfillment centers. Amazon splits shipments, loses units, and creates reimbursements that hit your account weeks later. If your books do not capture each of those movements, your gross margin percentage is unreliable from month one.
Shopify sellers face a similar problem when they sync inventory across their own warehouse and a third-party logistics provider (3PL). A 3PL is a company that stores and ships your products for you. When the 3PL count and your Shopify admin disagree, and neither matches your books, the margin you see in your dashboard is not the margin you are actually earning.
Why Cash Flow Suffers When Numbers Lag
Cash flow is not just about what is in your bank account. It is about knowing when to reorder, how much to order, and whether you can afford the next production run without burning your operating reserve. Lagging inventory numbers break all three of those decisions.
If your books show 800 units on hand but you actually have 400, you delay a reorder. That delay leads to a stockout, which on Amazon means lost ranking and lost revenue. If your books show 400 units but you have 800, you over-order and tie up cash in slow-moving stock.
Accurate inventory accounting gives you a real-time view of what you own, what it cost you, and how long it will take to sell. That visibility is what separates sellers who scale with confidence from sellers who guess and react. Once you see why accuracy matters, the next step is choosing the right method to maintain it.
The Core Methods Sellers Need to Know
Choosing the wrong inventory tracking method does not just create extra work. It can change your taxable income by thousands of dollars.
Perpetual Tracking vs Periodic Tracking
Perpetual tracking updates your inventory count in real time every time a sale, return, or purchase is recorded. Periodic tracking updates the count at set intervals, such as monthly or quarterly, based on a physical count. For most Amazon and Shopify sellers, perpetual tracking is the only practical choice.
| Method | Update Frequency | Best For | Risk |
| Perpetual | Real-time | Multi-channel sellers | Requires clean data inputs |
| Periodic | Monthly or quarterly | Low-volume single-channel | Gaps between count periods |
With tools like A2X that pull settlement data from Amazon and post it to QuickBooks Online, perpetual tracking is achievable without manual entry. The key is that every data source (your marketplace, your 3PL, your purchase orders) must feed the same system consistently.
FIFO and Weighted Average in Plain English
FIFO stands for first in, first out. It assumes you sell your oldest inventory first. If you bought 100 units at $8 and then 100 more at $10, FIFO says your first 100 sales cost $8 each. As product costs rise over time, FIFO tends to produce a lower COGS and a higher taxable income. For most U.S.-based eCommerce sellers, FIFO is the most commonly used and IRS-accepted method.
Weighted average cost takes your total inventory value and divides it by total units on hand to get a blended cost per unit. This smooths out price fluctuations and simplifies COGS calculations when you reorder frequently at slightly different costs.
- FIFO: Best when supplier costs are rising, and you want accurate margin by batch
- Weighted average: Best when you reorder frequently at similar prices and want simplicity
- LIFO (last in, first out): Not permitted under IFRS; rarely beneficial for eCommerce sellers in the U.S.
When Cost of Goods Sold Should Be Recognized
COGS should be recognized at the point of sale, not at the point of purchase. This is the matching principle in accounting: you match expenses to the revenue they generated. When a customer buys a product, you record the inventory cost as an expense on your income statement.
This timing matters for monthly reporting. If you record COGS when you pay your supplier, your monthly profit will swing wildly depending on when invoices land. That makes it nearly impossible to judge whether a particular month was actually profitable.
With A2X set up correctly inside QuickBooks Online, COGS entries post automatically at settlement, keeping your timing accurate. Knowing when to record the expense is only useful if you know what to include in the cost, which is where most sellers lose visibility into their margins.
What Should Be Included in Product Cost
Most sellers undercount their true product cost, which leads them to overprice or underprice products and to make reorder decisions based on the wrong data.
Unit Cost Beyond Supplier Pricing
Your supplier invoice is just the starting point. The actual cost of a unit sitting in your warehouse or FBA fulfillment center includes every dollar spent to get it there and make it sellable. This total is called landed cost.
Landed cost matters because it determines your real margin. If you sell a product for $30 and your supplier charges $10 per unit, you might think you are making $20 in gross profit. But if freight, duties, and prep add another $4, your actual margin shrinks by 20 percent before Amazon even takes its cut.
Freight, Duties, and Prep Fees
These three costs are consistently either unrecorded or thrown into operating expenses instead of inventory costs. That misclassification inflates your gross margin and understates COGS.
- Freight: Ocean, air, and domestic trucking costs tied to a specific purchase order
- Import duties: U.S. Customs charges based on HTS code and country of origin
- FBA prep fees: Labeling, bundling, poly-bagging, and inspection services paid to a prep center
- Inspection fees: Third-party quality checks before shipment from your supplier
Each of these belongs in your inventory cost, not your overhead. When you record them correctly in QuickBooks Online, your COGS reflects the true cost of each unit sold, and your margin reports become usable for real decisions.
Marketplace Fees vs Inventory Costs
Amazon referral fees, Shopify transaction fees, and fulfillment costs are not inventory costs. They are selling expenses and should be listed below gross profit on your income statement. Mixing them into your product cost distorts the picture in two directions.
If you bundle marketplace fees into COGS, your gross margin looks lower than it is, which might lead you to raise prices unnecessarily or drop a product that is actually healthy. Keeping these costs in their own expense categories lets you evaluate channel profitability separately. You can then compare what a product earns on Amazon versus Shopify with much more precision. Clean cost categories also help you catch errors that most sellers discover too late.
Common Mistakes Across Amazon and Shopify
Even sellers with solid processes make inventory accounting errors that compound quietly over time. Catching them early saves real money.
Returns, Refunds, and Damaged Stock
A return on Amazon does not automatically reverse the original sale in your books. If a customer returns a product and Amazon issues a refund, you need three things to happen: a revenue reversal, a COGS credit, and an assessment of whether the unit is resellable. If Amazon marks it as unsellable and disposes of it, that unit is a loss that must be written off.
Damaged stock that Amazon reimburses you for is a separate transaction. That reimbursement is income, but it should not be booked as product revenue. It belongs in a separate income line so your sales figures stay clean. A2X handles this separation automatically when configured correctly, which is one reason it is the preferred tool for Amazon settlement reconciliation.
Bundling, Kits, and Multi-Channel Complexity
Bundles and kits create a costing problem that spreadsheets almost always get wrong. When you sell a kit containing three SKUs, each SKU has its own cost. Your system needs to pull cost from each component and combine them into a single COGS entry at the time of sale.
Selling the same product on Amazon, Shopify, Walmart, and Etsy simultaneously makes this harder. Inventory deductions must happen in real time across all channels. If your Shopify admin does not sync with your Amazon FBA count, you will oversell, and your books will show units that no longer exist.
Year-End Count Problems and Cleanup
A physical inventory count at year-end is not optional. It is the check that catches every discrepancy your system missed during the year. Amazon provides a fulfillment center inventory report, but that number rarely matches your books without reconciliation.
Sellers who skip the count risk filing taxes with an inventory value that is materially wrong. The IRS can disallow COGS deductions if your records do not support them. A clean year-end count, reconciled against your QuickBooks Online balance sheet, protects every deduction you claim.
Fixing year-end problems is much easier when you have already built a monthly reporting workflow that catches issues early.
Building a Clean Workflow for Monthly Reporting
A reliable monthly close process is what separates sellers who know their numbers from sellers who find out at tax time.
Data Sources to Reconcile Each Month
Every month, you should reconcile at least four data sources against each other before closing your books:
- Amazon Seller Central: FBA inventory report and settlement statements
- Shopify admin: On-hand quantity by SKU and payout reports
- 3PL system: Physical count and outbound shipment records
- QuickBooks Online: Inventory asset balance and COGS entries
When these four sources agree, your books are clean. When they do not, the discrepancy tells you exactly where to look. Most reconciliation problems trace back to either a missing purchase order entry or an incorrect return.
How Automation Tools Reduce Manual Errors
Manual data entry is where inventory accounting breaks down fastest. One missed entry or transposed number can distort your balance sheet for months. Automation removes that risk at the source.
A2X automatically pulls Amazon and Shopify settlement data and maps it to the correct accounts in QuickBooks Online. This means every payout, fee, refund, and COGS entry posts without manual input. The result is a monthly close that takes hours instead of days, with far fewer errors to find and fix.
Reports That Support Better Reorders
Once your books are clean, three reports give you the data you need to make smarter inventory decisions:
| Report | What It Shows | Decision It Supports |
| Gross margin by SKU | Profit per unit after true landed cost | Which products to scale or cut |
| Inventory turnover | How fast stock sells relative to what you hold | Reorder timing and quantity |
| Days of inventory on hand | How many days until you run out at current sales rate | Cash flow planning |
These reports are only as accurate as the data feeding them. When your COGS, landed costs, and inventory counts are correct, these numbers become a genuine planning tool. The same data that drives reorder decisions also connects directly to your tax planning strategy.
Turning Better Numbers Into Smarter Decisions
Clean inventory accounting is not just a compliance task. It is the foundation for every profitable decision you make as a seller.
Using Inventory Data for Tax Planning
Your ending inventory balance directly affects your taxable income for the year. Higher ending inventory means lower COGS, which means higher taxable income. Lower ending inventory means higher COGS and lower taxable income.
This is not a loophole. It is how accrual accounting (the method where you record income and expenses when earned or incurred, not when cash moves) is supposed to work.
If you know your inventory balance in October, you can make proactive decisions before December 31. Strategies like timing a large reorder to increase COGS in the current tax year, or writing off unsellable inventory before year-end, can reduce your taxable income by thousands. But they only work if your books are accurate enough to act on in real time.
Margin Review Before You Scale
Scaling a product with a flawed margin is one of the fastest ways to grow your revenue while shrinking your profit. Before you increase ad spend, expand into a new channel, or place a larger production order, run a true margin review using landed cost, marketplace fees as a separate line item, and fulfillment cost per unit.
A product that looks like it runs at 40 percent gross margin might actually run at 24 percent once you include freight, duties, and Amazon’s referral and fulfillment fees. That 16-point gap is the difference between a product that funds your business and one that quietly drains it. Proactive tax planning for eCommerce sellers starts with knowing which products are actually making money.
When to Get Outside eCommerce Accounting Help
You should consider bringing in outside accounting support when any of the following apply:
- Your monthly close takes more than two days to complete
- Your COGS percentage fluctuates by more than 5 points month to month without a clear reason
- You are selling on three or more channels and reconciling manually
- You are approaching $500,000 in revenue and have never had a professional margin review
- You are planning to raise capital, seek a loan, or prepare for a business exit
Frequently Asked Questions
How do I record inventory purchases and freight so they flow into cost of goods sold (COGS) correctly?
Record inventory purchases as an asset in your inventory account, not as an expense. Add freight and duties to the same purchase entry so they are included in the unit’s landed cost. When the product sells, QuickBooks Online automatically transfers the cost from the inventory asset account to COGS, as long as your item records are set up correctly.
When should an eCommerce brand use FIFO, LIFO, or weighted average, and how does each method change taxable income?
FIFO is the most common method for U.S. eCommerce sellers and tends to produce higher taxable income when costs are rising because older, cheaper units are expensed first. Weighted average smooths cost fluctuations and works well for frequent reorders at similar prices. LIFO is generally not recommended for eCommerce and is prohibited under IFRS, making it a poor choice for sellers with international reporting requirements.
What journal entries do I need each month to reconcile Shopify, Amazon, and 3PL inventory counts to my books?
Each month, you need entries to record new inventory received, COGS for units sold by channel, inventory adjustments for discrepancies found during reconciliation, and write-offs for damaged or lost stock. A2X automates the Amazon and Shopify entries in QuickBooks Online, but 3PL discrepancies typically require a manual journal entry after you compare the 3PL count report to your book balance.
How do I handle inventory that’s lost, damaged, or reimbursed by Amazon so my P&L and balance sheet stay clean?
Write off lost or damaged inventory as a loss expense and reduce your inventory asset balance by the same amount. When Amazon reimburses you for lost units, record the reimbursement as other income, not product revenue, so your sales figures stay accurate. Keeping reimbursements in a separate income account also makes it easier to track how much Amazon owes you versus how much has been paid.
Which inventory apps integrate best with QuickBooks for multi-channel sellers, and what setup mistakes cause bad numbers?
A2X is the most widely used tool for syncing Amazon and Shopify settlement data into QuickBooks Online. The most common setup mistake is mapping all revenue and fees to a single income account instead of separating them by type, which makes reconciliation and margin analysis nearly impossible.
A second common error is not linking your inventory items in QuickBooks Online to the correct COGS account, which means sales post as revenue, but no cost entry follows.
How do I value bundles, kits, and FBA prep costs so margins by SKU match reality before a launch?
Build a landed cost sheet for each bundle that totals the cost of every component SKU plus any FBA prep fees, polybagging, or labeling costs associated with that specific kit. Enter the bundle as its own item in QuickBooks Online with a COGS value equal to that total. This way, when the bundle sells, the correct cost posts to COGS, and your margin report for that SKU reflects the actual cost to deliver the product.
Your Next Financial Decision Starts With Accurate Numbers
Inventory accounting for ecommerce is not a back-office task you clean up once a year. It is the system that tells you which products are profitable, when to reorder, how much tax you owe, and whether you can afford to scale. Every section of this guide builds toward one practical outcome: your books should reflect what your business actually earns, not what it appears to earn before all costs are accounted for.
If your inventory numbers are off, your COGS is wrong, your margins are guesses, and your tax planning is reactive. Fixing that does not require a complete overhaul. It usually starts with a single reconciliation pass and a clear conversation about which costs belong where.
Most eCommerce sellers leave thousands in deductions on the table every year. A free strategy call with AMZ Accountant takes 15 minutes and shows you exactly where yours are. Book your free call today, no commitment, no paperwork, just answers.