Users of the QuickBooks Desktop and QuickBooks Enterprise products can use A2X to account for their Shopify transactions.
This guide will show you how to setup A2X for use with QuickBooks Desktop and Enterprise, and how to export your Shopify Payout data for accounting and reconciliation.
You will be ready to use A2X with QuickBooks Desktop or QuickBooks Enterprise by completing these 3 steps:
Setting up A2X - accounts, tax rates, bank accounts
Mapping your accounts and taxes
Exporting your payout data from A2X and importing into QuickBooks Desktop or QuickBooks Enterprise
Before proceeding, please ensure that you have:
Created an A2X for Shopify account and connected your A2X account to your Shopify Store.
Uploaded your QuickBooks chart of accounts to A2X. For more information on uploading your chart of accounts to A2X, read our article HERE.
STEP 1: Set up A2X
When you land on the screen below, click on the blue 'Custom connection' option and click 'connect to custom', as shown below:
You will then be taken to Settings > Connections page to set up your chart of accounts, tax rates and bank accounts.
Upload Chart of Accounts & Tax Files
A2X needs your chart of accounts and tax rates in order to configure your accounting for Shopify Payouts. For more information on uploading your chart of accounts to A2X, read our article HERE.
Confirm Export Format and Select Bank Accounts
In the Export Format section, confirm the export format is 'QuickBooks Desktop or QuickBooks Enterprise (IIF)' and click save
Select your bank account where Shopify deposits your payouts, your credit card where Shopify charges any amounts owed and an asset account that can hold your month-end pending payout.
Save your settings.
STEP 2: Map your accounts and taxes
A2X needs to know how you want to map your Shopify transactions into your accounting system. The mapping process is performed on the Accounts and Taxes page.
This is a standard part of the A2X set up process for all users (both Online and Desktop). If you’d like some help with this our support team can give you some tips and pointers, but in general you’ll want to discuss this with your accountant as it affects the way your financial statements will appear.
STEP 3: Export your payout data
A2X will export a specially formatted IIF file for each of your payouts. You will import the IIF file to your version of QuickBooks Desktop or QuickBooks Enterprise.
Export the A2X payout data in IIF
Click the export link for any payout as shown below:
Import IIF into QuickBooks
(Windows) File → Utilities → Import → IIF Files
(Mac) File → Import → From IIF Files
Uploading your Chart of Accounts File: For more information on uploading your chart of accounts to A2X, read our article HERE.
Further A2X for Shopify support material can be found HERE.
Hint: If you are in chat and wish to view this article outside of the chat window, please click HERE.