How should e-commerce businesses track inventory across multiple platforms?
The challenge with selling on multiple platforms is that Shopify, Amazon, and your POS system all track inventory their own way. If these don’t sync to a single source of truth, you end up with mismatched counts, incorrect cost of goods sold, and financial statements that don’t reflect reality.
SKU consistency is the foundation. Every product needs a single SKU that’s used everywhere. When the same product has different identifiers on different platforms, you can’t match sales back to inventory or track costs properly. Set up a master product list with one SKU per item and enforce it across Shopify, Amazon, your point of sale, and your accounting software.
Track purchase costs at the item level. When you buy inventory, record what you paid per unit including shipping and any fees to get the product to you. This landed cost is what you’ll use to calculate cost of goods sold. If you buy the same product at different prices over time, you need a consistent method. Weighted average cost works well for most e-commerce businesses because it smooths out price variations without requiring you to track specific units.
COGS timing matters more than most sellers realize. When you sell an item on Amazon, the cost should hit your books at the time of sale, not when Amazon deposits the funds two weeks later. If your accounting only captures costs when cash moves, your profit reports are wrong because revenue and costs are mismatched in time.
Reconcile platform reports to your accounting software monthly. Shopify gives you a payout report. Amazon gives you settlement reports. Your POS has its own sales reports. Each one captures fees, refunds, and settlements differently. Your books need to show gross sales, platform fees, net deposits, and the corresponding inventory cost for each sale. This reconciliation catches errors before they compound into a mess that takes hours to untangle.
Inventory accounting software becomes necessary once you’re selling meaningful volume across channels. Tools like Cin7, Skubana, or Stocky act as a central hub that syncs inventory counts and feeds data to your accounting software. Without this layer, you’re manually updating counts across platforms and hoping nothing oversells before you catch it.
The accounting integration is where things often break down. You might have perfect inventory tracking in your management software, but if it doesn’t flow correctly into QuickBooks, your financial statements are still wrong. Make sure the integration handles sales, cost of goods sold, and inventory adjustments properly.
If your books are already a mess from trying to manage multiple platforms without proper systems, bookkeeping cleanup and catch-up services can get you back to accurate records. The goal is knowing exactly what you have, what it cost, and what you’re making after platform fees across every channel.
Greater Houston's Small Business Bookkeeping Partner
The Next Step:
A Quick 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.
More Questions
What job costing setup works best in QuickBooks Online for contractors?
QuickBooks Projects works well for smaller contractors tracking a handful of jobs. Larger operations with multiple job types or detailed cost breakdowns benefit from adding classes, items, estimates, and progress invoicing.
Read answerHow do I clean up old accounts receivable balances in QuickBooks?
Cleaning up old AR requires reviewing each invoice individually. Look for unapplied payments, duplicate invoices, bad debt that needs to be written off, and payments received outside QuickBooks that were never matched.
Read answerWhat payroll setup should a small business have before hiring its first employee?
Before hiring, you need a federal EIN, Texas Workforce Commission registration, a clear worker classification, chosen pay schedule, payroll system, and proper withholding configuration. Getting these right from day one prevents penalties and keeps your books clean.
Read answerHow do I use bookkeeping reports to decide whether to raise prices?
Clean books let you analyze margins by service, product, or job type rather than just looking at overall profitability. This shows you which specific offerings need price adjustments instead of raising everything across the board.
Read answerWhat is the best way to separate rental property repairs from capital improvements?
Set up separate accounts in your bookkeeping for repairs and fixed assets. Code expenses based on whether the work maintains existing condition or adds value and extends life. Have your tax preparer review significant items since the final treatment affects your taxes.
Read answerHow should a landlord track mileage, property management fees and mortgage interest?
Track everything at the property level. Mileage needs contemporaneous logs with purpose documented. Mortgage interest and property taxes come from lender statements, and owner contributions should stay separate from operating income.
Read answer