An overview of our Cost of Goods Sold feature can be found HERE
Please note: The Cost of Goods Sold and FBA Inventory Valuation features are available as part of our Starter plan and higher.
1/ Enable Cost of Goods Sold feature
Go to your A2X Settings page:
Select Cost of Goods Sold tab, then select Enable Cost of Goods Sold:
The Cost of Goods Sold entry that A2X sends to your accounting system will deduct the overall cost of goods sold value for that period from your inventory asset account balance and allocate it to your cost of goods sold expense account.
So, the next step of the set up is to:
2/ Map the Cost of Goods Sold expense account and the Inventory asset account
- Your accounting system may already have a Cost of Goods sold expense account which can save you having to create another one, if you don't necessarily need to. If your accounting system has a default Cost of Goods Sold account, then you can simply link it to A2X, as shown below:
- The Inventory account is a little different. The default Inventory account in accounting systems is generally reserved for the accounting systems internal inventory functions, therefore it is best to create a new Current Asset account* called Amazon Inventory in your accounting system.
The new inventory account can then be linked to A2X, as shown below:
Lastly, click Save Settings.
Please note: You can account for COGS on one level or expand to other levels, if you business requires this level of tracking.
Click on the orange plus sign to expand and see the different levels of tracking:
3/ Input your Product Cost Prices
There are two methods to provide A2X with your cost price data.
Once the cost prices are uploaded to A2X you will need to refresh the settlements in your A2X account. This can be done by either clicking the 'Refresh' button beside each settlements of by enabling bulk actions which you can learn more about HERE
4/ Reviewing and sending COGS invoices to the accounting system
After you enable COGS in the A2X settings, upload your costs and configure your asset and expense accounts, you can click Review for a specific settlement to see the details of the COGS for that period, and send the data to your accounting system. The COGS entries will appear below the usual Sales and Fees entries, and you will see one or two entries depending on whether the settlement period spans more than one month.
You will see the number and cost of items sold divided into three categories:
As each Amazon settlement is processed, the quantity of product sold is calculated and the cost value of the product is totaled into entries in the same way as the sales and fees.
Click "Send One/Two Invoices..." to send the COGS entry to your accounting. It needs to be sent separately from your sales and fees entry.
You can configure A2X to include or exclude the non-Amazon shipments, which allows COGS calculations for non-Amazon sales shipped from Amazon FBA.
You can upload different cost data and then "Refresh" a settlement to have A2X re-calculate and apply the new cost of goods sold values. Great when you have calculated new average costs for your products!
At an accounting report level, a balance sheet report in your accounting system will show you your closing stock balance as at the end of any month or period, and your profit and loss report or income statement will show you the total cost of goods sold expense.
When you send the COGS entries over to Xero, they will be in Draft Bills.
All you need to do is click Approve!
When you send them over to QuickBooks Online, they are found in the Journals
just like the sales entries, but split between the various inventory and COGS accounts.
You don't need to do anything with the COGS entries once they reach QuickBooks.
Tip: Click HERE to head over to our COGS & Inventory support center where you can find more articles relating to the use of A2X's Cost of Goods Sold and FBA Inventory Valuation features.