Did you know that you can export a SKUs and quantities sold list from A2X into a CSV file? This file offers a convenient option for sellers to view their SKUs sold on a payout basis, or pivot the data to aggregate the information and generate a customized report based on your preference.
The article below will cover the following information
How to export the COGS CSV file in bulk
How to create a manual adjustment in Xero for inventory tracking
1. How to export the COGS CSV file in bulk
Start by enabling the COGS feature in your settings
Next, as needed, enter your COGS per SKU (or simply apply a $0.00 cost to each item in your Costs page as a temporary workaround), choose your home currency, and click save. If you are using Xero's inventory tracking, then it is not necessary to duplicate that information in A2X.
Next, go to your settlements page, and select "Actions > Enable Bulk Actions"
You will see a list of bulk action options available with checkboxes along the right-hand side of each settlement file to select.
- Select the payouts to apply the bulk action, and
- Choose the "Export COGS" selection from the dropdown list
- Click "Apply" to export the SKUs and quantities sold into a CSV file
*Important note: Do not select the "Send COGS" option in this step.
This will bulk-send the cogs entries to your accounting system without adjusting the Xero tracking inventory quantities. Be sure to select the "export cogs" option instead.
With your CSV file, you can view your SKUs and quantities sold, separated by each payout. An example of CSV export is below.
2. How to create a manual adjustment in Xero for inventory tracking
To adjust your tracking inventory manually in Xero, go to Products and Services > Select your Inventory item > New Adjustment.
On this screen in Xero, reduce the quantities in the inventory by the quantities sold. This step will adjust your inventory balance and your preferred chart of account selected in the "Adjustment account" field.
Another option for adjusting the inventory items in bulk for items sold is to create an invoice in Xero and enter your SKUs and quantities sold
Your Inventory asset balance, cost of goods sold account, and the inventory quantities of each tracked product will be adjusted accordingly.
Example before and after Xero inventory quantities
Example after creating the $0.00 invoice
Example inventory asset and COGS accounts as of the invoice date