BigCommerce + Xero Setup Guide

Pamela Calilung
Customer success manager Request support

Overview of BigCommerce + Xero integration

Connect BigCommerce and Xero to start syncing your daily sales transactions.

  • Sales sync
    • On a daily basis, the integration will sync a summary of your previous day’s sales data into Xero generating an invoice.
    • Opt to sync all orders into separate invoices.PREMIUM
    • You can customise your preferred sales summary view choosing from a wide array of formats.PREMIUM
    • Capture all payment transactions including fees, tax and gift cards.
    • Easily reconcile deposits into the clearing accounts.
  • Cost of goods sold (COGS) sync
    • Sync your cost of goods sold and inventory amounts to track your gross profit and margins directly in your financial reports.PREMIUM

Before you start

How to set up BigCommerce + Xero integration

  1. Register or sign in the Amaka dashboard to get started.
  2. Click the New integration button and select BigCommerce + Xero from the integrations list to commence the setup.
  3. Click the Connect new account button underneath the BigCommerce logo. Follow the guided authentication process to grant all relevant permissions.
  4. Authenticate your Xero account following the same procedure, then click Save + Continue.
  5. Follow the wizard to choose your preferred setup method, mapping and scheduler options to complete the setup of the integration.
  6. Click Save + Continue to finish and activate the integration.

After completing the setup, the new integration will be listed on the app dashboard where you can edit it or start a new one.

Express setup
Every day, an invoice with your daily sales summary will be created into Xero.

The integration will automatically map sales and payments from BigCommerce into Xero by creating the following default accounts:

Account mapping
Transaction TypeXero AccountAccount TypeAccount Code
SalesBigCommerce SalesRevenueBC-20000
DiscountsBigCommerce DiscountsRevenueBC-20001
Shipping/Delivery FeesBigCommerce Shipping/Delivery FeesRevenueBC-20002
Handling FeeBigCommerce Handling FeeRevenueBC-20003
Wrapping FeeBigCommerce Wrapping FeeRevenueBC-20004
Payment mapping
Payment TypeXero AccountAccount TypeAccount Code
Payment MethodBigCommerce {Payment Method Name} ClearingCurrent AssetsBC-61___
Gift CardBigCommerce Gift CardCurrent LiabilityBC-80000
Store CreditBigCommerce Store CreditCurrent LiabilityBC-80001
All Other Payment TypesBigCommerce Other Payment ClearingCurrent AssetsBC-60000
Tax account mapping (for US only)

Setting up with Express, BigCommerce taxes are mapped to the preset account called BigCommerce Collected Taxes. The total tax amounts for each tax rate are synced into separate line items and mapped to this current liability account.

Xero AccountAccount TypeAccount Code
BigCommerce Collected TaxesCurrent LiabilityBC-80002
Advanced setup
The advanced setup will allow you to choose your own custom mapping in relation to sales and payments in BigCommerce.
Recommended for professional bookkeepers and accountants.
Guided setup
Schedule a call with one of our integration experts that will guide you through the setup. Schedule a call now

FAQ on how to set up BigCommerce + Xero

Yes! Using our free integration, a summary of your previous day’s sales data is automatically synced from BigCommerce into Xero as an invoice. This means you get perfectly reconciled accounts.
Forever free plan available. Visit our pricing page to find out more about premium features.
Of course! If you would like to request a walkthrough or discuss the capabilities of the integration in more detail, you may schedule a support session with one of our integration experts.
Sure, you can select the date that you wish the data to be synced from through the integration scheduler page.
In case you have revoked the access or changed credentials of an account used for an integration, you can easily reconnect it by expanding the options menu and clicking the Reconnect (or Edit) button in the Connected accounts page.
At any time, you can access your Amaka dashboard and disable an integration by either turning it OFF or deleting it entirely. You can follow the instructions here.

What’s next?

Need any help?
Need help? Visit our Help desk or Schedule a support session.