DEV Community

Kayabyte
Kayabyte

Posted on Originally published at kayabyte.dev

How to Connect Wix Stores to Xero for Automated Invoice Sync (2026)

Disclosure: I develop Accounting Sync for Xero, an integration app that syncs Wix Stores orders and refunds to Xero.

Wix Stores does not include a native direct connection to Xero. As a result, online sales, shipping charges, and refunds do not reach your general ledger automatically.

To maintain accurate bookkeeping, business owners typically choose between manual entry, recurring CSV imports, multi-step automation scripts (Zapier/Make), or dedicated sync apps. Here is an overview of each approach and what configuration steps are essential in Xero before you connect.


Prerequisites in Xero Before Connecting

Whichever workflow you select, establishing these accounting structures in Xero ensures accurate balance matching:

  1. Sales Revenue Account: Most stores map general item sales to account 200 - Sales. If you track shipping revenue separately, configure a distinct income code (e.g. 205 - Shipping Income).
  2. Payment Clearing Account: E-commerce payments (via Stripe, PayPal, or Wix Payments) do not hit your primary bank account immediately; payouts arrive bundled 2–3 days later minus transaction fees. Standard practice is to record sales against a dedicated clearing account (e.g. Wix Payments Clearing) and reconcile bank payout transfers against that account, allowing transaction fees to balance cleanly.
  3. Tax Rate Mapping: Every tax line charged in Wix Stores must match an active Xero tax type (e.g. UK VAT 20%, Australian GST 10%, New Zealand GST 15%, or state sales taxes). If your store displays tax-inclusive prices, invoices must be designated tax-inclusive in Xero.
  4. Customer Contact Strategy: Decide whether to generate individual Xero contact cards per customer (preserving purchase history) or consolidate all orders under a shared contact (e.g. Wix Online Store Customers) to keep your contact list uncluttered.

4 Methods to Sync Wix Orders with Xero

1. Manual Entry

  • Process: For each completed sale in Wix Dashboard > Sales > Orders, create a manual sales invoice in Xero (Business > Invoices > New Invoice), replicate line items and taxes, and click Record a Payment. For returns, create a credit note.
  • Fit: Viable only for very low volume (1–3 bespoke orders per week). Highly susceptible to data-entry errors and missed refunds.

2. CSV Export and Import

  • Process: Export orders from Wix as a CSV file (Sales > Orders > Export) and import them into Xero using Xero's invoice template (Business > Invoices > Import).
  • Limitations: The file structures differ substantially; columns must be manually transformed. Imported invoices land as drafts or awaiting payment, requiring manual payment reconciliation. Duplicate imports can accidentally create duplicate sales.

3. Automation Tools (Zapier / Make)

  • Process: Construct multi-step automations triggered by "New Wix Order" to invoke "Create Xero Invoice".
  • Limitations: Complex order variations—tax-inclusive pricing, partial coupon discounts, gift cards, line-item tax overrides, and refund credit notes—often fail or require convoluted conditional branching.

4. Dedicated Wix App: Accounting Sync for Xero

  • Using Accounting Sync for Xero:
    • Every completed Wix Stores sale automatically creates an authorized, fully paid sales invoice in Xero.
    • Automatically manages partial and full refunds by issuing matched credit notes with refund payments.
    • Precise tax mapping for multi-jurisdiction VAT/GST and tax-inclusive pricing.
    • Automated duplicate prevention prevents re-posting existing orders.

Pricing & Availability

  • Accounting Sync for Xero:
    • Free plan available ($0/month for testing with up to 10 orders/mo).
    • Pro plan: $14.99/month for unlimited automatic order and refund synchronization.
    • 14-day free trial on paid plans.
    • Works on standard Wix and Wix Studio sites.

Disclosure: The author is the creator of Accounting Sync for Xero on the Wix App Market.

Top comments (0)