All Collections
QuickBooks Desktop and QuickBooks Enterprise
Posting Amazon Cost of Goods Sold to QuickBooks Desktop and QuickBooks Enterprise
Posting Amazon Cost of Goods Sold to QuickBooks Desktop and QuickBooks Enterprise

How to calculate and post your cost of goods sold (COGS) to QuickBooks Desktop and QuickBooks Enterprise

Ashley Schroder avatar
Written by Ashley Schroder
Updated over a week ago

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


Related Articles: 

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

Did this answer your question?