Sales Tax, Inventory & COGS Corrections in QuickBooks (E-commerce & Retail)
Misclassified transactions? Learn the CPA-designed method to reclassify categories, classes, and locations in QuickBooks-without breaking history or reconciliations.
E-commerce accounting breaks quietly: inventory quantities stop matching your platform, COGS posts in the wrong month, and sales tax is either over- or under-collected. This guide shows the CPA-designed QuickBooks cleanup process we use for Shopify, Amazon, WooCommerce, Stripe, and PayPal. We rebuild item/GL mappings, reconcile payouts (gross → fees → reserves → net), correct inventory valuation, and fix COGS timing so margins are real. We also align sales tax for marketplace facilitator rules and nexus, then deliver CPA-reviewed financials with a period-lock recommendation. Prefer to hand it off? Request a QuickBooks cleanup quote-we’ll fix history and move you into a predictable monthly close.
Why E-commerce Files Drift
Payouts booked as net revenue (fees/chargebacks not mapped)- Inventory purchased to expense (skips asset and timing)
- Refunds and discounts posted inconsistently across channels
- Sales tax recorded as revenue or liability in the wrong periods
- CSV/app integrations writing to the wrong items or accounts
Inventory & COGS Corrections
- Move from “expense on purchase” to asset on purchase → COGS on sale using items.
- Migrate SKUs to inventory items with correct cost method; backfill beginning quantities/values.
- If perpetual not feasible, implement periodic adjusted COGS from inventory system exports.
- For landed cost: capture freight/duties into inventory value (via item cost or capitalization JE with schedule).
- Month-end: reconcile Inventory Asset to subledger/export; investigate variances.
Timing & Cutoff
- Sales belong in the period shipped/recognized; COGS must align to those sales.
- Use inventory reports from the platform/IMS to compute month-end adjustments if QBO isn’t itemized historically.
- Document cutoff policy; have the CPA review timing entries before lock.
Sales Tax Cleanup
- Identify channels where marketplace facilitator remits (e.g., Amazon)-do not double-count as your liability.
- For direct carts (Shopify/Stripe), configure correct collect/remit jurisdictions.
- Reclass revenue booked as tax; true-up Sales Tax Payable to filings.
- Keep a jurisdiction roll-forward workpaper; reconcile payable to returns each month.
Step-by-Step Cleanup
Scope
- List channels, gateways, SKUs, apps, tax jurisdictions, inventory method.
Payout Rebuild
- Remap settlements for last 3-12 months; tie each to bank.
Inventory & COGS
- Convert SKUs to items or compute periodic COGS; post correcting JEs with workpapers.
Sales Tax
- Segment facilitator vs direct; reclass and true-up liabilities; attach filings.
QA & CPA Review
- Margin analysis by channel, variance notes, period-lock recommendation.
Reports to Validate After Fixes
- P&L by Channel (sales, fees, refunds, net margin)
- Inventory Valuation vs Inventory Asset (no unexplained variance)
- COGS % Trend (stabilized month to month)
- Sales Tax Payable Reconciliation to jurisdictions/returns
- Cash Reconciliation (payouts tie to bank without suspense)
Mini Case Example
A Shopify + Amazon seller showed inflated revenue and random COGS. We rebuilt payout mappings (fees/chargebacks/reserves), converted SKUs to inventory items, capitalized freight into landed cost, and corrected sales-tax liabilities for facilitator jurisdictions. Result: margins stabilized, Inventory Asset tied to valuation, and Sales Tax Payable matched filed returns. CPA reviewed and locked the year; lender accepted the package.
Ready to Fix Inventory, COGS & Sales Tax the Right Way?
We’ll rebuild mappings, stabilize margins, and deliver CPA-reviewed financials.
Frequently Asked Questions
Yes. We post a one-time reclassification to Inventory Asset with support, then move to itemized or periodic COGS. A CPA review documents the transition.
Map them to dedicated contra-revenue and expense accounts so gross sales, fees, refunds, and net deposit reconcile cleanly.
Mismatched timing (expense on purchase), incorrect SKU mapping, or periodic adjustments missing. We align method, adjust timing, and stabilize with month-end controls.
No. Facilitators remit only for their channels. Your direct sales (e.g., Shopify) still require collection and filing where you have nexus.
Yes. We remeasure FX at period-end and reconcile payout conversions; CPA reviews FX impacts before lock.
Typical e-commerce cleanups finish in 2-4 weeks after access, depending on order volume and number of channels.
View all answers in our full QuickBooks Cleanup FAQ →
Ready to fix the past and close this month?
Get a CPA-reviewed QuickBooks cleanup with a firm timeline.