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
How often should a restaurant owner review their books and what reports matter most?
Weekly at minimum for food cost, labor cost, and daily sales trends. Monthly for the full P&L, prime cost analysis, A/P aging, and cash flow. Thin margins mean waiting too long to review your numbers can cost thousands before you notice.
Read answerHow do I set up QuickBooks Online for a new California business?
Start by creating your QBO account and selecting an industry-appropriate chart of accounts. From there, connect your bank accounts, configure California sales tax with the correct local district rates, and set up invoicing and payroll.
Read answerWhat is the best way to track intercompany transactions between healthcare entities in QuickBooks?
Set up Due To and Due From accounts in each entity's QuickBooks file to log every payment made on behalf of another entity. QuickBooks Online lacks built-in intercompany elimination, so you'll need manual journal entries and monthly reconciliation between entities.
Read answerHow do I track property management fees and contractor payments for rental properties?
Track management fees as an expense allocated to each property, and record every contractor payment with enough detail to file 1099-NECs at year end. Keeping expenses separated by property is the only way to know which ones are actually making money.
Read answerShould I set up an LLC for each rental property and how does that affect bookkeeping?
Many investors do, and for good reason. Separate LLCs protect your other assets if something goes wrong at one property. But each LLC needs its own bank account and books, which increases your bookkeeping costs and complexity.
Read answerWhat are the biggest bookkeeping mistakes restaurant owners make?
The costliest mistakes include not tracking food costs weekly, failing to reconcile POS reports to bank deposits daily, and commingling personal and business expenses. These errors hide profit leaks and create tax problems.
Read answer
