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: 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
You'll need to open your .iif file using Excel.
Right-click your file > open with > Excel
Handy Hint: If Excel is not an available option, choose text editor open, then 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.
After copy/pasting the columns into a .csv file, your chart of accounts list should look like this:
Please note: If QuickBooks Account Numbers is not enabled, you can manually add account numbers in column C. Account numbers are required in A2X.
Your .csv file is now ready for upload!
STEP 3: Upload your chart of accounts file by going to A2X Settings > Connections
Choose your file, and click on the orange "Upload Accounts" button.
You are now ready to map your accounts!
Hint: If you are in chat and wish to view this article outside of the chat window, please click HERE