How should ecommerce inventory be connected to QuickBooks Online?
QuickBooks Online’s built-in inventory features struggle once you have more than a handful of SKUs or sell across multiple channels. The usual fix is a dedicated inventory app sitting between your store and QBO. Cin7 Core, SOS Inventory, and Shopify’s native inventory all work depending on volume and complexity. The store handles sales, the inventory app handles operations, and QBO becomes the financial source of truth.
SKUs have to match exactly across every system. The same product needs the same SKU in Shopify, in your inventory app, and in QBO if you keep items there. “WIDGET-001” in one system and “Widget-001” in another will fail to sync or post to the wrong item entirely. Set a naming convention before you connect anything and stick with it. Mismatches break integrations silently, and you usually find out months later when the numbers don’t reconcile.
Purchase costs flow in when you receive product from a supplier. The inventory app records the receipt at cost, which posts to QBO as an increase to inventory asset and a corresponding bill. Freight, duties, and any landed cost adjustments need to be captured at receipt or shortly after. Skip these and your unit cost is wrong, which means your margins and COGS are wrong too.
COGS hits when the product sells, not when you buy it. The inventory app should be configured to recognize COGS at fulfillment, calculating cost based on the method you chose (FIFO, weighted average, or specific identification) and pushing the entry to QBO. Inventory asset goes down, COGS expense goes up. Booking purchases straight to COGS without running them through inventory asset first is one of the most common mistakes we see, and it makes monthly financials almost meaningless.
Stock counts still matter even with a clean system. Real inventory drifts from system quantities through damage, theft, miscounts at receipt, and mis-picks at fulfillment. Cycle count fast movers weekly and slow movers monthly or quarterly. Adjustments need to flow into QBO as shrinkage entries, not just sit in the inventory app.
At month end, three numbers need to agree: the inventory value in your store, the value in your inventory app, and the inventory asset balance in QBO. They rarely match on their own. Variances come from sync delays, mis-mapped SKUs, missing landed costs, or adjustments made in one place but not the others. Inventory accounting done properly means reconciling monthly, documenting variances, and posting adjusting entries so the balance sheet reflects what’s actually on the shelf.
This setup takes time to get right, and most sellers don’t have the bandwidth to manage it alongside running the business. If you’re looking for small business accounting, bookkeeping and tax services in Jacksonville, NC that understand how ecommerce inventory actually works, we can help configure the integration and keep the three systems in sync.
Trusted Accounting for Small Businesses
First Step:
Start With a Call
Tell us about your business and what you need help with. We'll ask a few questions, evaluate your current situation, and let you know how GMJ can support your books, taxes, and day-to-day operations.
More Questions
What records should a restaurant gather before business tax preparation?
Restaurants need reconciled books, POS annual reports, payroll and tip summaries, 1099s, sales tax filings, year-end inventory counts, fixed asset records, and loan statements. Pulling these together before tax prep starts saves time and prevents missed deductions.
Read answerHow should a restaurant chain or multi-location operator track location-level profitability?
Set up each location as a class in your books and tag every transaction to it. POS sales, payroll, and expenses all need to flow in with the location already assigned so you can produce a real P&L for each store every month.
Read answerHow should a nonprofit separate program, management and fundraising expenses?
Identify direct costs by function first, then allocate shared costs using a consistent, documented method like time studies or square footage. Write down your allocation policy, apply it the same way every period, and keep the supporting records so your Form 990 and board reports hold up to scrutiny.
Read answerHow can tax planning change when an owner is choosing LLC, S corp or partnership treatment?
Entity choice changes how income flows to your personal return, how much self-employment tax you pay, and what compensation rules apply. Each structure has trade-offs around payroll, distributions, basis tracking, and state filings that shape your planning every year.
Read answerWhat should a cash flow forecast include for a seasonal business?
A seasonal cash flow forecast needs to map expected receipts, payroll, vendor and inventory payments, debt service, taxes, and owner draws month by month, not as annual averages. The whole point is knowing in July whether you'll have cash to cover February.
Read answerHow should bars separate liquor sales, food sales, tips and merchant fees?
Set up distinct POS categories for liquor, beer, wine, and food that map to separate revenue accounts in your books. Keep sales tax and tips as liabilities until remitted or paid out, and book merchant fees as their own expense instead of netting them against sales. Apply the same category structure to COGS so you can calculate pour cost and food cost accurately.
Read answer
