All Collections
A2X for Shopify
General Setup
Getting started with A2X for Shopify
Getting started with A2X for Shopify

How to import your Shopify sales to Xero, QuickBooks and Sage with A2X for Shopify

Ashley Schroder avatar
Written by Ashley Schroder
Updated over a week ago

About A2X for Shopify

A2X for Shopify imports your Shopify payouts and sales, and posts them to your accounting system in a way that makes it easy to reconcile the sales, refunds, discounts taxes and shipping against the cash receipts.

A2X for Shopify has several benefits for accounting:

  • Reconciles Shopify Payments perfectly, including all fees

  • Automatically imports accurate Shopify data

  • Scales to support 1000's of daily orders without sending 1000's of individual invoices to the accounting system

  • Supports multiple Shopify stores connecting to a single accounting system for multi-channel sellers

  • Supports multi-currency sellers and multiple tax rates

Supported Payment Gateways

  • Shopify Payments - payouts will reconcile directly to bank deposits

  • PayPal - transactions posted to accounting system with a clearing account

  • Amazon Pay - transactions posted to accounting system with a clearing account

  • Authorize - transactions posted to accounting system with a clearing account

  • Afterpay - transactions posted to accounting system with a clearing account

  • Other gateways - posted to accounting system with a clearing account, please contact support for specific gateway information.

1/ Creating an A2X for Shopify account

Create a new A2X for Shopify account from the Shopify sign-up page.

If you already have an existing A2X for Amazon account, you will be asked to confirm that you wish to create a new account. So, this is where you need to choose 'Continue with New Account'.

In the next window, choose 'Continue to Your New Account'.

Once your account is created it should look like this:

Now you are ready to set up your new A2X for Shopify account.


2/ Connecting to your accounting system

Click the Connect button for your accounting system and proceed with the connection process. You will be redirected to your accounting system to grant A2X permission.

If you are connecting A2X for Shopify to the same accounting system that you are already connected to with a different A2X account (either with Amazon or a different Shopify store), you should choose to share the existing connection, rather than create a new connection.



3/ Connecting an A2X for Shopify account to your Shopify store

Click the green 'Continue with Shopify' button and input your Shopify store name in the form below and click 'Connect':

Please note: If you receive an error message that says "this shop is currently unavailable", please try including a hyphen between each word in your shop name within the 'mystore' field.

You will be redirected to your Shopify store and asked to login and grant A2X permission to connect. You must grant this permission in order to use A2X for Shopify.

Once the permission is granted, you'll be redirected back to A2X and your first payouts will begin to import into A2X. The process usually takes 10-20 minutes and for larger Shopify stores, it can take several hours to complete.

Once imported you should see the payouts like shown below:

4/ Configuring the accounts and taxes for your Shopify sales

You need to configure A2X for Shopify to map your Shopify transactions into your accounting system.
​
A2X will offer to create several generic default accounts, or you can select your own individual mappings. We recommend working with your accountant on this initial setup as it will impact how the Shopify transactions appear in your financial reporting.

You can also customize how the A2X transactions are created, such as grouping the sales by country or province in the Settings > Invoice section of A2X. This can help if you have specific tax handling requirements for some countries.

Shopify Payments Gateway
The sales, refunds and other transactions that are paid via Shopify Payments will be imported to A2X in their own payouts, these will be posted as a single batch of transactions and will always match perfectly to the corresponding deposits from Shopify.
​
​Other Payment Gateways
If you are using other gateways or payment methods on your Shopify store, these will be imported separately into A2X for Shopify. Typically, you will need to define a clearing account for each of them, and post the corresponding payment proceeds to the same clearing account. The exact configuration for these accounts will differ depending on the payment methods.

You can disable, configure and preview these settlements in Settings > Connections.

Please Note: For more information about these mappings or if you have specific requirements that are not handled by the current mapping, please contact the A2X support team.

5/ Posting your Shopify payouts and reconciling them in your accounting system

Once you have connected and configured your account, you can send your payouts to your accounting system. To do that, click the Send link.

You will then see the payout in your accounting system and be able to match or reconcile it to the corresponding deposit. For example, below is Xero's bank reconciliation screen showing the matching payouts.

Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE

Did this answer your question?