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 will be saved as an .iif file.
Please note: The following list of accounts types are required to complete A2X's accounts and taxes mapping.
- Amazon Revenue (Income)
- Amazon Fees (Expense)
- Amazon Advertising (Expense)
- Amazon Settlement Bank (Bank)
- Amazon Carry Forward Balance (Asset)
- Amazon Credit Card (CC)
- Amazon Inventory (Asset)
- Amazon Cost of Goods (COGS)
- Amazon Pending Balance (Asset)
- Amazon Reserved Balance (Asset)
- Sales Tax Liability (Liability)
- Amazon Lending (Liability)
STEP 2: Edit your Chart of Accounts IIF file and save as CSV to upload into A2X
Open your IFF file using Excel
Below is an example of your iif chart of accounts file exported from QB Desktop. The information needed for your chart of accounts for A2X file is highlighted in orange. (Account Name, Type and Number)
Handy Hint: If Excel is not an available option, then choose text editor open and copy/paste the data into Excel
Copy/paste the orange columns into a CSV file
After copy/pasting the columns into a CSV file, the chart of accounts will look like this:
Please note: If QuickBooks Account Numbers are 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 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.
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE