BigCommerce + QuickBooks Online setup guide

Overview of BigCommerce + QuickBooks Online integration

Connect BigCommerce and QuickBooks Online 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 QuickBooks generating an invoice.
    • Opt to sync all orders into separate invoices.
    • You can customise your preferred sales summary view by choosing from a wide array of formats.
    • Capture all payment transactions including gift cards, tips, tax and payment fees.
    • 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.

How to set up BigCommerce + QBO integration

  1. Register or sign in to the Amaka dashboard to get started.

  2. Click the New integration button and select BigCommerce + QuickBooks Online from the integrations list to commence the setup.

  3. Sign in to your BigCommerce account by clicking the Connect new account button underneath BigCommerce logo. Follow the guided authentication process to grant all relevant permissions.

  4. Authenticate your QuickBooks Online account following the guided authentication process, then click Save + Continue.

  5. Follow the wizard to choose your preferred configuration method, invoice breakdown, invoice format, mapping and scheduler options to complete the setup of the integration.

  6. Click Save + Continue to finish and activate the integration.

If you have selected today’s date as your scheduled sync start date, your transactions will not appear in QuickBooks Online until tomorrow.

Configuration methods

At the beginning of your setup wizard, you’ll be able to choose your preferred configuration method from the options listed below.

Express configuration

Every day, an invoice with your daily sales summary will be created in QuickBooks Online.

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

Account mapping
Transaction Type QuickBooks Online Account Account Type
Sales BigCommerce Sales Revenue
Discounts BigCommerce Discounts Revenue
Shipping/Delivery Fees BigCommerce Shipping/Delivery Fees Revenue
Handling Fee BigCommerce Handling Fee Revenue
Wrapping Fee BigCommerce Wrapping Fee Revenue
Payment mapping
Payment Type QuickBooks Online Account Account Type
Payment Method BigCommerce {Payment Method Name} Clearing Current Assets
Gift Card BigCommerce Gift Card Current Liability
Store Credit BigCommerce Store Credit Current Liability
Other Payment Types BigCommerce Other Payment Clearing Current Assets
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.

QuickBooks Online Account Account Type
BigCommerce Collected Taxes Account Type
Advanced configuration

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 Specialists that will help you decide on the best configuration method for you and guide you through the setup.

Schedule a call now

FAQ on how to set up BigCommerce + QuickBooks

Find answers to the most frequently asked questions about this integration.

Yes! Using our free integration, a summary of your previous day’s sales data is automatically synced from BigCommerce into QuickBooks Online as an invoice. This means you get perfectly reconciled accounts.

Amaka’s BigCommerce accounting integration works on Simple Start, the lowest tier plan available for QuickBooks Online.

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.

For the BigCommerce + QuickBooks Online integration by Amaka, you can choose to sync sales to a summarized invoice or to a categorized invoice. With a summarized invoice, total sales are synced into a single income account in QuickBooks Online. If you select a categorized invoice, you can map each BigCommerce product or category to a specific income account.

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.

Was this article helpful?