Reconcile Shopify Payouts, Processing Fees & Historical COGS in 3 Seconds.
Shopify’s native order CSV omits product costs and payment fees—and updating a SKU cost breaks past reports. MarginDock is downloadable browser software that merges your Shopify Orders CSV, Payout Transactions CSV, and effective-date COGS locally in Chrome, exporting a 5-sheet accountant-ready Excel workbook.
1. Three-Way CSV Reconciliation
Drop Shopify’s native orders_export.csv and payout_transactions.csv. MarginDock matches multi-line orders, processing fees, refunds, and net bank deposits automatically.
2. Historical Effective-Date COGS
Record Unit Purchase Cost + Inbound Landed Cost (freight & duties) with effective date ranges. Updating next month’s supplier price never corrupts last month’s P&L.
3. Balanced Accounting Journals
Flags negative-margin orders, missing SKU costs, and blank-order payout adjustments—then exports a 5-sheet .xlsx workbook with balanced QuickBooks / Xero journal entries.
Privacy-First Local Architecture
MarginDock Chrome Extension executes 100% of CSV parsing, COGS lookups, and Excel generation inside your local Chrome browser memory. Your store’s orders, sales figures, and supplier costs are never uploaded to external servers.