BigCommerce Xero Integration: Step-by-Step Setup Guide (2026)
BigCommerce uses third-party gateways — not its own payout system — which means every deposit reaching your Xero bank feed is already net of gateway fees and refunds. This guide covers chart of accounts setup, gateway clearing accounts, VAT/GST handling, and payout reconciliation using SyncTools.
BigCommerce merchants in the UK, Australia, and New Zealand consistently choose Xero as their accounting system — and with good reason. Xero’s VAT return automation, GST filing, and bank reconciliation tools are purpose-built for those tax environments. The problem is that BigCommerce and Xero don’t talk to each other, and the gap between them is more complicated than it looks.
Unlike marketplaces such as Amazon or Etsy — which deduct fees, collect VAT, and issue a single net payout — BigCommerce routes payments through whichever gateways you’ve configured (Stripe, PayPal, Square, Authorize.net, or others). Each gateway deposits on its own schedule, at its own net-of-fees amount. Xero sees only those net deposits in your bank feed. Your gross BigCommerce sales, the gateway fees deducted along the way, the tax you collected, and any refunds you processed are completely invisible without automation.
TL;DR: BigCommerce powers 60,000+ merchants across 150+ countries (BigCommerce 2025 Annual Report). Xero has more than 4.2 million subscribers, with dominant market share in the UK, Australia, and New Zealand (Xero Annual Report 2024). BigCommerce does not offer a native Xero integration. SyncTools bridges the gap — syncing gross sales, gateway fees, VAT/GST, refunds, and payout settlements to the correct Xero accounts automatically.
Using QuickBooks instead of Xero? See the BigCommerce QuickBooks integration guide.
Why BigCommerce and Xero Don’t Reconcile Out of the Box
BigCommerce and Xero each do their job well. BigCommerce manages your storefront, orders, checkout, and customer experience. Xero manages your general ledger, P&L, balance sheet, and tax filings. Neither system knows what the other is doing without a direct connection.
The specific accounting problems BigCommerce merchants on Xero encounter:
- Net payouts hide gross economics. Stripe deposits the gross order amount minus its 2.9% + $0.30 processing fee (or your negotiated rate). PayPal does the same with its fee structure. The figure that hits your Xero bank feed is already net — Xero has no visibility into the gross sales or gateway costs that produced it.
- Multiple gateways multiply the problem. BigCommerce commonly runs Stripe for card payments alongside PayPal Checkout and possibly a BNPL provider. Each gateway deposits on a different schedule — Stripe every 2 business days, PayPal on your configured auto-sweep schedule. Without dedicated clearing accounts per gateway, matching each deposit to the correct transactions is a manual exercise every payout cycle.
- Gateway fees are invisible in BigCommerce reports. Your BigCommerce control panel shows gross order revenue. It does not show you what Stripe or PayPal charged to process each transaction. Those fees live in your gateway dashboard, not in BigCommerce — and they don’t flow into Xero without an integration that pulls from both sources.
- Tax collected is not tax owed. VAT collected from UK buyers belongs to HMRC. GST collected from Australian buyers belongs to the ATO. If that tax flows into Xero as revenue rather than a liability, your P&L is overstated and your VAT or GST return becomes a manual correction project every quarter.
- Refund timing creates reconciliation lag. A refund approved in your BigCommerce control panel today may not settle in Stripe for three to five business days. Manual tracking of the lag between a BigCommerce refund event and its eventual effect on your bank balance creates a standing reconciliation puzzle in Xero.
SyncTools observation: BigCommerce merchants who set up proper gateway clearing accounts and fee separation in Xero before they reach 300 orders per month avoid the payout reconciliation backlog that consistently emerges once growth makes manual matching impossible.
BigCommerce Xero Integration Options
Three approaches exist for connecting BigCommerce to Xero:
| Method | Real-Time Sync | Fee Separation | VAT/GST Mapping | Multi-Gateway Support | Best For |
|---|---|---|---|---|---|
| Manual CSV Export | No | Manual only | Manual only | Manual | Under 30 orders/month |
| Third-Party CSV Importer | No | Partial | Partial | No | Low-volume, simple setups |
| Dedicated Sync App (SyncTools) | Yes | Full | Full | Yes (per-gateway clearing) | Most growing stores |
Manual CSV Export
BigCommerce provides order export CSVs, and Xero accepts CSV bank statement imports. At very low volume — under 30 orders per month — manual export works if you’re willing to extract gateway fees from Stripe or PayPal separately and manually allocate tax to a liability account. Most merchants outgrow this around the time they start running promotions or processing refunds regularly.
Third-Party CSV Importers
Some accounting add-ons accept BigCommerce CSV exports and map them to Xero. These work better than raw import but still require periodic manual downloads, rarely separate gateway fees from gross sales, and don’t produce the clearing account structure needed for clean Xero bank reconciliation.
Dedicated Sync App (SyncTools)
SyncTools connects directly to the BigCommerce API — no CSV downloads, no manual steps. Every order, fee, refund, and gateway payout settlement syncs to Xero in real time or on a daily batch schedule. The clearing account model means each gateway deposit matches a cleared Xero account balance in one click. For any growing BigCommerce store, this is the practical path. The rest of this guide covers the setup.
Setting Up Your Xero Chart of Accounts for BigCommerce
Build the right account structure in Xero before connecting the integration. Retrofitting your chart of accounts after syncing three months of data is significantly more work than doing it correctly up front.
Recommended BigCommerce Accounts in Xero
Revenue accounts:
- BigCommerce Product Sales — gross product revenue at the order amount before any fees or refunds
- BigCommerce Shipping Income — shipping charges collected from customers (if you want to track shipping revenue separately; many merchants fold it into product sales)
Contra-revenue accounts:
- BigCommerce Discounts — discount codes and coupon deductions; keeping these on a contra-revenue account preserves your gross sales figure while showing net sales separately
- BigCommerce Refunds — customer refunds reduce gross revenue; a dedicated account gives you visibility into refund volume as a separate P&L line
Expense accounts:
- Stripe Fees (or PayPal Fees, Square Fees, etc.) — create one expense account per gateway you use; this lets you see the cost of each payment method independently
- BigCommerce Subscription Fee — your monthly BigCommerce plan fee (Standard: $39/month, Plus: $105/month, Pro: $399/month)
Liability account:
- Sales Tax / VAT / GST Payable — tax collected from customers is not your revenue. Map to this liability account using the appropriate Xero tax rate for your jurisdiction (20% VAT Standard Rate for UK domestic sales; 10% GST for Australia; 15% GST for New Zealand; or US state-level tax codes if you use Xero for US sales tax tracking).
Clearing accounts (bank type — one per gateway):
- Stripe Clearing — a bank-type asset account for all Stripe-processed orders
- PayPal Clearing — a separate bank-type account for PayPal Checkout transactions
- Add one per additional gateway you use
Each clearing account acts as a staging ledger. Every BigCommerce transaction posts here at gross value as it occurs. When the net gateway deposit hits your Xero bank feed, you match it against the corresponding clearing account. The balance zeros out with each payout cycle — clean one-click reconciliation with no manual journals.
BigCommerce to Xero Account Mapping Reference
| BigCommerce Transaction | Xero Account | Account Type |
|---|---|---|
| Product sales (gross) | BigCommerce Product Sales | Revenue |
| Shipping collected | BigCommerce Shipping Income | Revenue |
| Discount codes applied | BigCommerce Discounts | Contra-revenue |
| Customer refunds | BigCommerce Refunds | Contra-revenue |
| Stripe processing fees | Stripe Fees | Expense |
| PayPal processing fees | PayPal Fees | Expense |
| Sales tax / VAT / GST collected | Sales Tax / VAT / GST Payable | Liability |
| Stripe payout deposit | Stripe Clearing (matched to bank) | Bank account |
| PayPal payout deposit | PayPal Clearing (matched to bank) | Bank account |
How to Connect BigCommerce to Xero with SyncTools
Step 1: Set Up Your Chart of Accounts in Xero
Create the accounts listed above before you connect SyncTools. In Xero, go to Accounting → Chart of Accounts → Add Account. Add each account with the correct type (Revenue, Expense, Liability, Bank). Every clearing account — Stripe Clearing, PayPal Clearing, and any others — must be set as a Bank type. This is what enables Xero’s bank reconciliation module to match gateway deposits to them.
Step 2: Connect BigCommerce to SyncTools
- Sign up or log in at app.synctools.io.
- Click Add Integration and select BigCommerce.
- Enter your BigCommerce store URL (e.g.,
yourstore.mybigcommerce.com). - SyncTools walks you through authorization — either OAuth or V2/V3 API credentials from your BigCommerce control panel, depending on your store configuration.
- Once authorized, SyncTools reads your order history, refunds, and product data. It never writes to or modifies your BigCommerce store.
Step 3: Connect Xero to SyncTools
- In SyncTools, click Add Accounting System and select Xero.
- Click Connect to Xero — you’ll be redirected to Xero’s OAuth authorization page.
- Log in to Xero and select the organisation you want to sync BigCommerce data to.
- Grant SyncTools access. SyncTools requests read/write access to contacts, invoices, credit notes, payments, and bank transactions. No API keys required.
Step 4: Map BigCommerce Transaction Types to Xero
In the SyncTools account mapping screen, assign each transaction type to its Xero account:
- Map Product Sales → BigCommerce Product Sales
- Map Shipping Collected → BigCommerce Shipping Income
- Map Discounts → BigCommerce Discounts
- Map Refunds → BigCommerce Refunds
- Map Stripe Fees → Stripe Fees expense account
- Map PayPal Fees → PayPal Fees expense account
- Map Tax Collected → Sales Tax / VAT / GST Payable (select the correct Xero tax rate for your jurisdiction)
- Map Stripe Payout → Stripe Clearing
- Map PayPal Payout → PayPal Clearing
SyncTools pre-fills suggested mappings based on your existing Xero chart of accounts. Review each line before your first sync.
VAT note for UK sellers: If you’re VAT-registered, select the 20% (VAT on Income) Xero tax rate for your VAT mapping. SyncTools will post each BigCommerce sale with the correct tax code so your Xero VAT return pulls in BigCommerce data automatically. For Australian GST, select GST on Income (10%). For New Zealand GST, select GST on Income (15%).
Important: BigCommerce is not a marketplace facilitator for VAT or GST. Unlike Etsy or Amazon, BigCommerce does not collect or remit VAT/GST on your behalf. Every VAT or GST amount that flows through your BigCommerce checkout is your obligation to remit — which is why correct Xero tax rate mapping matters so much here.
Step 5: Configure Sync Settings and Run Your First Sync
Sync mode options:
- Real-time — each BigCommerce order, refund, and fee event creates a transaction in Xero within minutes. Best for stores that want up-to-date financials throughout the day and prefer individual invoices per order in Xero.
- Daily batch — all transactions are grouped into a single daily journal entry. Reduces Xero invoice volume; preferred by accountants managing high-volume BigCommerce stores or merchants who want a cleaner Xero contacts list.
Payout reconciliation: Enable Clearing Account mode. Every transaction posts to the appropriate gateway clearing account (Stripe Clearing, PayPal Clearing) at gross value. When the gateway deposits the net amount to your bank and it appears in your Xero bank feed, you match it against the clearing account showing the same net balance — one-click reconciliation per payout cycle.
Click Run First Sync to import transactions. Standard and Plus plans support full historical backfill; Starter plans cover 90 days.
Open Xero and verify:
- BigCommerce sales appear in BigCommerce Product Sales (revenue)
- Gateway fees appear as separate expense entries
- VAT/GST collected is in the Tax Payable liability account, not in revenue
- Discounts and refunds appear as contra-revenue, not as missing revenue
- Each clearing account balance matches your next expected gateway deposit
Gateway Payout Reconciliation: How the Clearing Account Works
BigCommerce itself does not pay you. Your payment gateways do — on their own schedules, net of their own fees. This is the single biggest structural difference between BigCommerce accounting and marketplace accounting (Amazon, Etsy, Walmart).
Stripe (the most common BigCommerce gateway) deposits funds 2 business days after each charge is captured. Each Stripe payout is the sum of all captured charges from 2 days prior, minus Stripe’s processing fees (typically 2.9% + $0.30 per transaction) and any refunds processed in that period.
PayPal holds funds in your PayPal balance and sweeps to your bank account on your configured schedule (or manually). PayPal fees vary by plan and transaction type — typically 3.49% + $0.49 for standard card transactions.
Concrete example (UK seller, Stripe gateway):
Your BigCommerce store processes £5,000 in gross orders during Stripe’s 2-day settlement window. Stripe deducts:
- £148.00 in processing fees (2.9% × £5,000 + £0.30 × 20 orders — approximation)
- £250.00 in refunds issued during the same period
- £20.00 VAT on the refunds (reversed from the original collection)
Net Stripe deposit: £4,582.00
What SyncTools posts to Xero as transactions occur:
- £5,000.00 → BigCommerce Product Sales (revenue)
- £148.00 → Stripe Fees (expense)
- £250.00 → BigCommerce Refunds (contra-revenue)
- £1,000.00 → VAT Payable (liability — 20% on £5,000 gross, minus the refund VAT)
Stripe Clearing account balance: £4,582.00 (£5,000 revenue − £148 fees − £250 refunds − £20 VAT reversal)
In Xero’s bank feed: £4,582.00 appears from Stripe. You click Match — Xero matches it to the Stripe Clearing account showing the same £4,582.00. Reconciliation complete.
Your Xero P&L shows:
- Revenue: £4,750 (£5,000 gross sales minus £250 in refunds)
- Expenses: £148 in Stripe fees
- Net margin: £4,602 before your other costs
VAT collected (£1,000) sits in the liability section — correct for your VAT return, not inflating your income.
Without automation, you would manually extract each transaction from your Stripe dashboard, calculate the gateway fee for each order, create journal entries in Xero, and match the net bank deposit by hand — across every payout cycle, for every gateway.
VAT and GST Handling for BigCommerce Sellers Using Xero
BigCommerce’s VAT and GST model is fundamentally different from marketplace platforms. BigCommerce is not a deemed supplier or marketplace facilitator — you are responsible for collecting and remitting all VAT and GST yourself.
UK VAT-Registered Sellers
If you’re VAT-registered in the UK and selling to UK customers, you collect 20% VAT at checkout (or 0% for zero-rated goods like most food, children’s clothing, and books). That VAT belongs to HMRC and must be included in your quarterly or monthly VAT return.
SyncTools maps BigCommerce VAT to a dedicated VAT Payable liability account in Xero and applies the correct Xero tax rate (20% (VAT on Income) for standard-rated goods, 0% Zero Rated Income for zero-rated goods). Your Xero VAT return populates from BigCommerce sales data automatically — Box 1 (VAT due on sales) pulls in correctly without manual adjustment.
For cross-border sales to EU customers post-Brexit, VAT rules depend on whether you’ve registered for the EU One Stop Shop (OSS) scheme or in individual EU member states. SyncTools can map different EU tax rates to separate Xero tax codes — contact the SyncTools support team for EU multi-jurisdiction configuration.
Australian GST
If you’re GST-registered in Australia, you collect 10% GST on most sales to Australian customers. SyncTools maps BigCommerce GST to GST on Sales (10%) in Xero, so your Business Activity Statement (BAS) pulls GST data from Xero automatically.
New Zealand GST
New Zealand GST-registered sellers collect 15% GST. SyncTools maps this to the GST on Income (15%) rate in Xero, consistent with IRD reporting requirements.
US Sales Tax
BigCommerce integrates with Avalara and BigCommerce Tax (powered by Avalara) for automated sales tax calculation at checkout. SyncTools reads the finalized tax amount from each completed BigCommerce order and posts it to a Sales Tax Payable liability account in Xero. If you collect sales tax in multiple US states, SyncTools can split the tax line by jurisdiction — so your Xero sales tax payable balance matches your BigCommerce tax collected report by state.
The cardinal rule: tax collected is never revenue. It belongs in a liability account. Setting this correctly during initial account mapping takes 30 seconds and prevents months of corrective journal entries.
What Data Syncs — and What Doesn’t
Understanding exactly what flows from BigCommerce to Xero through SyncTools prevents reconciliation surprises weeks after go-live.
What syncs with a properly configured integration:
- Product sales (individual invoices per order or daily summary journals — your choice)
- Shipping charges billed to the customer
- Discount codes and coupon deductions
- Full refunds and partial refunds
- Sales tax, VAT, or GST collected — by jurisdiction if configured
- Payment gateway processing fees (Stripe, PayPal, Square, Authorize.net, BigCommerce Payments)
- Payout deposit settlements, matched to gateway clearing accounts
- Inventory quantity updates
What does not sync:
- Customer contact information (names, emails, shipping addresses)
- Product descriptions, images, or SEO data
- BigCommerce analytics (conversion rates, traffic data)
- Abandoned cart data
- Vendor purchase orders or supplier costs
- Custom fields not tied to financial transactions
Multi-currency orders: If your BigCommerce store accepts multiple currencies, SyncTools converts each order to your Xero base currency at the exchange rate on the order date and posts the FX gain or loss to a dedicated account. Xero’s native multi-currency features capture the exchange rate movements on the accounting side. This is particularly relevant for UK and EU cross-border sales.
Connecting to the BigCommerce Xero Integration Page
For a technical feature overview and quick-start options, see the BigCommerce Xero integration page. That page covers SyncTools’ BigCommerce-specific capabilities: supported data types, supported Xero regions, payout frequency options, and multi-gateway support details.
Troubleshooting Common Sync Problems
Most BigCommerce-to-Xero sync errors fall into four categories. Knowing the root cause cuts troubleshooting time from hours to minutes.
Problem: Duplicate transactions in Xero
Cause: Two integration tools running simultaneously — for example, a previously installed BigCommerce-Xero connector plus SyncTools, both reading the same orders and posting to Xero.
Fix: Disconnect any previously installed integration before activating SyncTools. Check the BigCommerce App Marketplace for active connected apps and revoke access to any you’re replacing. Then re-sync from SyncTools starting from the last clean date.
Problem: Revenue in Xero doesn’t match BigCommerce reports
Cause: Date range mismatch (BigCommerce uses order date; your integration may use payment date or payout date), or pending and incomplete orders included in one report but excluded from another.
Fix: Confirm both systems use the same date field. In SyncTools, set the sync date basis to order date to match BigCommerce reporting. Filter out cancelled or pending orders from your comparison.
Problem: Sales tax or VAT appearing in revenue accounts
Cause: The tax mapping is set to an income account instead of a liability account.
Fix: Update the mapping to Sales Tax / VAT Payable, then run a corrective sync for the affected period. You may need to delete the incorrectly posted transactions and re-import them. This is the most common setup error — and the most consequential for your VAT return accuracy.
Problem: Clearing account balance doesn’t match the gateway deposit
Cause: A refund, chargeback, or gateway fee posted with the wrong date or to the wrong clearing account, causing the balance to drift before the deposit arrives.
Fix: In SyncTools, run the per-order reconciliation report for the affected payout period. The report shows exactly where each BigCommerce transaction landed in Xero — including any that posted to the wrong clearing account or missed the payout window. Identify the misposted entries, correct the account assignment, and re-match in Xero.
Problem: Gateway fees missing from Xero
Cause: The integration is reading only BigCommerce order data without pulling gateway fee data from the payment processor API. BigCommerce order records do not include gateway fees — fee data comes from the gateway (Stripe, PayPal, etc.) separately.
Fix: Confirm SyncTools is connected to your gateway accounts as well as BigCommerce. In SyncTools, go to Integrations and verify that each payment gateway you use shows as an active connection. Gateway fee sync requires a separate authorization step from BigCommerce store sync.
Frequently Asked Questions
Does BigCommerce have a native Xero integration?
BigCommerce does not offer a built-in Xero integration as of 2026. Xero’s app marketplace does not include a first-party BigCommerce connector. BigCommerce merchants who use Xero connect the two systems using a dedicated sync tool like SyncTools, which reads the BigCommerce API in real time and posts transactions to Xero with full fee separation, VAT/GST mapping, and clearing-account payout reconciliation per gateway.
Is BigCommerce a marketplace facilitator for VAT like Amazon or Etsy?
No. BigCommerce is a hosted SaaS eCommerce platform for your own branded store — not a third-party marketplace. BigCommerce does not collect or remit VAT, GST, or US sales tax on your behalf. You collect tax through your BigCommerce checkout (automated by Avalara or BigCommerce Tax) and remit it to the relevant authority yourself. This is fundamentally different from Amazon FBA or Etsy, where the marketplace collects and remits in many jurisdictions. SyncTools maps your BigCommerce-collected tax to the correct Xero liability account so it never appears as income.
How often does Stripe deposit to my bank account when using BigCommerce?
Stripe deposits funds 2 business days after each charge is captured, by default. If your BigCommerce store processes orders on Monday, Stripe deposits Wednesday. Each Stripe payout batches all captured charges from the same settlement date, minus Stripe’s processing fees and any refunds from that period. SyncTools posts transactions to the Stripe Clearing account as they occur throughout the settlement period, so the clearing account balance matches the deposit when it arrives.
What if I use multiple payment gateways on BigCommerce?
SyncTools handles multiple gateways by creating a separate clearing account in Xero for each. If you use Stripe and PayPal simultaneously, Stripe deposits post to Stripe Clearing and PayPal deposits post to PayPal Clearing — independent reconciliation for each gateway, on each gateway’s payout schedule. This prevents the cross-contamination that occurs when multiple gateway deposits are matched against a single clearing account.
Can SyncTools backfill historical BigCommerce orders into Xero?
Yes. SyncTools supports historical backfill on Standard and Plus plans, allowing you to import past BigCommerce orders, gateway fees, and refunds into Xero — useful when migrating from spreadsheets or from another integration mid-year. The same account mapping applies to historical data.
What’s the difference between BigCommerce Xero and BigCommerce QuickBooks integration?
The core connection logic — mapping order types to accounts, handling fees, creating a clearing account — is similar across both accounting systems. The Xero-specific differences are: Xero uses bank feeds for reconciliation (not QuickBooks’s matching engine), Xero VAT returns and GST returns populate directly from Xero tax rates applied at the transaction level, and Xero’s multi-currency support handles FX differently from QuickBooks’s multicurrency module. UK, Australian, and New Zealand merchants typically prefer Xero because of its native VAT/GST return tooling.
Ready to connect BigCommerce to Xero? Start your free SyncTools trial — setup takes under 20 minutes and no developer access is required.
Already using QuickBooks? See how to connect BigCommerce to QuickBooks Online.
Related integrations:
- BigCommerce Xero Integration overview — full feature details and setup options for the SyncTools BigCommerce Xero connector
- WooCommerce Xero Integration — same Xero setup principles for merchants on WooCommerce
- Amazon Xero Integration — for multi-channel sellers also selling on Amazon
Related guides:
- BigCommerce Accounting Guide — chart of accounts, gateway fee structure, sales tax handling, and full accounting setup for BigCommerce sellers
- BigCommerce QuickBooks Integration — for merchants using QuickBooks instead of Xero
- eCommerce Bookkeeping: What Every Online Seller Must Know — accounting fundamentals behind every integration
See the integration page
BigCommerce Xero Integration
Ready to automate your accounting?
Connect Shopify, WooCommerce, or Linnworks to QuickBooks, Xero & more. Setup in minutes.