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
- Sign up for a BigCommerce account and a Xero account (if you haven’t already).
How to set up BigCommerce + Xero integration
- Register or sign in the Amaka dashboard to get started.
- Click the New integration button and select BigCommerce + Xero from the integrations list to commence the setup.
- Click the Connect new account button underneath the BigCommerce logo. Follow the guided authentication process to grant all relevant permissions.
- Authenticate your Xero account following the same procedure, then click Save + Continue.
- Follow the wizard to choose your preferred setup method, mapping and scheduler options to complete the setup of the integration.
- 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.
Setup methods
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:
Default accounts mappingAccount mapping
Transaction Type | Xero Account | Account Type | Account Code |
Sales | BigCommerce Sales | Revenue | BC-20000 |
Discounts | BigCommerce Discounts | Revenue | BC-20001 |
Shipping/Delivery Fees | BigCommerce Shipping/Delivery Fees | Revenue | BC-20002 |
Handling Fee | BigCommerce Handling Fee | Revenue | BC-20003 |
Wrapping Fee | BigCommerce Wrapping Fee | Revenue | BC-20004 |
Payment mapping
Payment Type | Xero Account | Account Type | Account Code |
Payment Method | BigCommerce {Payment Method Name} Clearing | Current Assets | BC-61___ |
Gift Card | BigCommerce Gift Card | Current Liability | BC-80000 |
Store Credit | BigCommerce Store Credit | Current Liability | BC-80001 |
All Other Payment Types | BigCommerce Other Payment Clearing | Current Assets | BC-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 Account | Account Type | Account Code |
BigCommerce Collected Taxes | Current Liability | BC-80002 |