Reconcile Shopify Payments in Xero — Payout Matching

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

Create a new bank account in Xero (Accounting → Bank Accounts → Add Bank Account). Name it 'Shopify Payments' and select 'Other' as the account type. This acts as a holding account for Shopify transactions.

Separating fees lets you track your actual processing costs as expenses. Your revenue is recorded at the gross amount (matching your 1099-K), while fees reduce your profit as expenses rather than reducing revenue.

After processing all transactions and matching all payouts, your Shopify Clearing Account balance in Xero should match Shopify's 'Available Balance' in Settings → Payments. Any difference indicates missing transactions.

Pending payouts haven't been deposited yet. Only reconcile transactions from completed payouts that have actually hit your bank account.

Most businesses reconcile monthly at month-end. Import all transactions from the month, match to bank deposits, and verify the clearing account balance.

Order totals differ from payouts due to payment gateway fees (2.9% + $0.30 per transaction) and Shopify transaction fees (0.5%), which are deducted before money reaches your bank account.

A clearing account is a temporary holding account that tracks Shopify transactions before allocating them to final accounts. It simplifies reconciliation by breaking down batch payouts into individual sales, fees, and taxes.

Yes! Our converter handles multiple Shopify stores by processing each store's payout export separately. Export from each store, convert with our tool, and import to Xero. No third-party apps or subscriptions needed.

Our converter preserves foreign currency amounts from Shopify exports. For multi-currency reconciliation, export each currency separately and import to Xero with the appropriate currency settings. This file-based approach gives you full control without third-party integration fees.

Map sales revenue to an Income account, refunds/discounts to a Contra Income account, and fees to an Expense account (e.g., 'Shopify Fees' or 'Merchant Fees').