Building on the previous article that guided you through setting up A2X for use with QuickBooks Desktop and QuickBooks Enterprise, in this article we will guide you through the creation of your chart of accounts .csv file.
You will export your chart of accounts from QuickBooks, and then use this data to create your chart of accounts .csv file for upload.
Please Note: This article is written specifically for QuickBooks Desktop and QuickBooks Enterprise.
Let's get started!
STEP 1: Export Chart of Accounts File from QuickBooks
Windows: File > Utilities > Export > Lists to IIF Files
Mac: File > Export > Lists to IIF Files
Check the "Chart of Accounts" box and click "OK"
Name your file and click Save. It can be saved as an IIF file.
Please note: The following list of account types are required for A2X's accounts and taxes mapping.
Shopify Revenue (Income)
Shopify Fees (Expense)
Shopify Payouts Bank (Bank)
Shopify Clearing Account (Asset) for other payment gateways
Shopify Carry Forward Balance (Asset)
Shopify Credit Card (CC)
Shopify Inventory (Asset)
Shopify Cost of Goods (COGS)
Shopify Sales Tax Liability (Liability)
STEP 2: Edit Your Chart of Accounts IIF file and Save as a CSV to upload into A2X
Open your downloaded IIF file with Excel
Right-click on your file > Open with > Excel.
Handy Hints:
If Excel is not an available option, open Excel and go to File > Open > Browse > select the folder with your downloaded IIF file (e.g. Downloads) > change to All Files > select your IIF file.
OR
Choose text editor open and copy/paste the data into Excel.
Below is an example file. The information needed for your chart of accounts file is highlighted in orange. (Account Name, Type, and Number)
Copy/paste the orange columns into a .csv file.
Please note: Account numbers are required in the file. You can manually add account numbers to your file (typically any unique 4 or 5 digit number will work) or you can enable account numbers in QuickBooks. To enable account numbers in QuickBooks, go to Preferences > Transactions in QuickBooks and check the 'Use account numbers' box.
After copy/pasting the columns into a .csv file, your chart of accounts file should look like this:
Important note: If you have sub-accounts, account names should be listed as parent account:sub account. Example-
Your CSV file is now ready for upload!
STEP 3: Upload your chart of accounts file in A2X Settings > Connections
Choose your file and click on the orange Upload Accounts button.
You are now ready to map your accounts!
Should you need any assistance with your Chart of Accounts file upload, please contact our support team with any questions.
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