All Collections
Xero Support
General Use & Operations
How to adjust your Xero inventory tracking quantities manually using A2X's COGS export CSV
How to adjust your Xero inventory tracking quantities manually using A2X's COGS export CSV

This article explains how to export the skus and quantities sold per month and make a manual adjustment in Xero for inventory tracked items

Natalie Flex avatar
Written by Natalie Flex
Updated over a week ago

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

  1. How to export the COGS CSV file in bulk

  2. 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.

Steps:
- 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

Did this answer your question?