How do I track inventory across multiple e-commerce platforms in QuickBooks?
QuickBooks Online has basic inventory features, but it was not built to manage stock across multiple sales channels. It doesn’t know what’s listed on Amazon vs. what’s on Shopify vs. what you’re selling wholesale. It tracks quantities in one place with no awareness of where sales are happening. If you try to rely on QBO alone for multi-channel inventory, you’ll end up with overselling, stockouts, and cost of goods sold numbers that don’t reflect reality.
The solution is a dedicated inventory management system that acts as the hub between your sales channels and QuickBooks. Tools like Cin7, DEAR (now part of Cin7), SkuVault, or Ordoro connect directly to Amazon, Shopify, WooCommerce, and wholesale order systems. When a sale happens on any channel, the IMS updates stock levels everywhere in near real time. One sale on Amazon reduces available quantity on Shopify automatically. That’s the piece QuickBooks simply cannot do on its own.
The data flow works like this. Your sales channels send order data to the inventory management system. The IMS tracks what’s in stock, what’s committed, and what needs reordering. It then pushes the financial side of things into QuickBooks, including revenue, COGS, and inventory asset values. QuickBooks becomes your financial record while the IMS handles the operational inventory work. Trying to reverse this by making QuickBooks the center of your inventory process will create more manual work than it saves.
Choosing the right tool depends on your volume and complexity. If you’re doing a few hundred orders a month across two channels, something like Ordoro or Zoho Inventory might be enough. If you’re running thousands of SKUs across Amazon, Shopify, and wholesale with warehouse operations, Cin7 or SkuVault are better fits. The monthly cost of these tools pays for itself quickly when you stop losing money to overselling and inventory miscounts.
Setting this up correctly from the start matters more than which tool you pick. SKU mapping needs to be consistent across every platform. Your chart of accounts in QuickBooks needs to be structured so that COGS and inventory categories make sense for how you actually sell. Inventory accounting for multi-channel sellers gets complicated fast, and errors in the initial setup create problems that compound month after month.
A few things to watch out for. Amazon fees, FBA storage costs, and refunds all need to flow into QuickBooks correctly or your profit margins will look wrong. Shopify payment processing fees are a separate line item. Wholesale orders often have different payment terms and pricing tiers that need distinct handling. Each channel has its own quirks that affect how the numbers land in your books.
If you’re already selling on multiple platforms and your QuickBooks inventory numbers don’t match what you actually have on shelves, the fix usually starts with getting a proper IMS in place and then cleaning up the historical data in QuickBooks. Our Orange County small business bookkeeping services include helping e-commerce sellers get their systems connected properly so the financial data flowing into QuickBooks is accurate and useful, not just a mess of disconnected transactions from different platforms.
Orange County's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote with no surprises.
More Questions
What financial metrics should a wholesale distributor track monthly?
Start with gross margin by product line, inventory turnover, and cash conversion cycle. Add days sales outstanding, days payable outstanding, fill rate, and return rate for a complete picture. Together these metrics show where cash gets stuck and where margin leaks.
Read answerHow should a wholesale company handle inventory valuation in QuickBooks?
QuickBooks Online uses FIFO by default, which works well for most wholesale distributors. The bigger challenge is keeping your book inventory accurate through regular physical counts and variance reporting.
Read answerHow do I handle sales tax nexus for an e-commerce business selling across multiple states?
After the 2018 Wayfair Supreme Court decision, most states can require you to collect sales tax once you cross their economic nexus threshold. For California-based e-commerce sellers, that means collecting CA sales tax plus registering and filing in every other state where you hit the threshold.
Read answerDo I need a bookkeeper for my e-commerce side hustle or can I DIY?
If you're selling under $50K a year on a single platform, DIY bookkeeping can work fine. But most e-commerce sellers hit complexity faster than they expect, especially around sales tax nexus, inventory tracking, and platform fee reconciliation.
Read answerWhat chart of accounts should a dental or medical practice use in QuickBooks?
Medical and dental practices need a chart of accounts with revenue split by provider or service line, insurance versus self-pay income, and expense categories for supplies, malpractice insurance, equipment leases, and EHR subscriptions. The standard QuickBooks template doesn't include these.
Read answerHow do I set up inventory accounting in QuickBooks for a wholesale distribution business?
Enable inventory tracking in QuickBooks Online, set up products with accurate costs, and organize by category or product line. Most wholesalers with hundreds of SKUs will need a third-party inventory app that syncs with QBO to handle landed costs, reorder points, and real reporting.
Read answer
