Building on the previous article that shows you how to set up A2X for use with QuickBooks Desktop or QuickBooks Enterprise, in this article we will show you how to have A2X calculate and export your Amazon COGS in a format that you can use with QuickBooks Desktop or QuickBooks Enterprise.
STEP 1: Configure Cost of Goods Sold
To use Cost of Goods Sold in A2X you must be on a plan that supports it, and then enable it under Settings > Cost of Goods Sold. You will need to specify an expense account and asset account for the COGS debit and credit.
Once enabled, you will set your costs on the Costs page of A2X, because you need to tell A2X the cost to use for each Amazon SKU.
Lastly, you can refresh one or more settlements to have the COGS calculation updated using the newly uploaded cost prices.
You can read more about COGS HERE.
STEP 2: Export Cost of Goods Sold data
Once A2X has calculated your Cost of Goods Sold you will see it when you review each settlement:
STEP 3: Export your settlement data
A2X will export a specially formatted Sales and Fees, and Cost of Goods Sold journal file for each of your settlements. You will import the IIF files to your version of QuickBooks Desktop or or QuickBooks Enterprise.
To export the settlement and COGS data from A2X, click on the blue "Export" buttons to export the data. To import the IIF files into QuickBooks, follow the steps below.
(Windows) File → Utilities → Import → IIF Files
(Mac) File → Import → From IIF Files
Uploading your Chart of Accounts File for QuickBooks Desktop: For more information on uploading your chart of accounts, read our article HERE
Carry Forward Balance: A "carry forward balance" account is required. For more information on the carry forward balance, read our article HERE
Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE