Building on the previous guide that shows you how to set up A2X for use with QuickBooks Desktop and Enterprise, in this article we will show you ho to have A2X calculate an export your Amazon COGS in a format for use with QuickBooks Desktop and 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 > Costs. You will need to specify an expense account and asset account for the COGS debit and credit.
Once enabled you will set your costs in the Costs section of A2X, 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 like this:
If you click the Export COGS button you will get a CSV export that looks like this, based on your COGS configuration:
Now you can follow the same instructions as the settlement export for importing to QuickBooks Desktop and Enterprise, using CSV2QBJ.