Shopify Payout Reconciler

Unbundles lump-sum Shopify Balance and merchant bank payouts into gross merchandise value, merchant processing fees, customer refunds, shipping label adjustments, and sales tax for penny-accurate QuickBooks Online reconciliation.

Features

• Automated Payout Decomposition: Extracts gross sales, fees, returns, carrier postage, and sales tax from Shopify settlement batches.
• Penny-Accurate Balancing Engine: Validates that Net Deposit = Gross Sales + Sales Tax - Refunds - Fees - Shipping Labels with zero delta against checking deposits.
• Double-Entry General Ledger Staging: Stages balanced debits and credits formatted for QuickBooks Online or Xero.
• Interactive Review Dashboard: Preact-powered visual audit surface for inspecting accounts and line items before posting.
• 100% Human-in-the-Loop: All entries stage as unposted drafts. Zero bank debits or unapproved ledger mutations.

Installation

assistant plugins install shopify-payout-reconciler

License

MIT

Details