• Contents

Importing Adjustments to Xero

Last updated 25/09/2018

This article explains how to import Adjustments to Xero.

Overview


If you are using the Perpetual inventory accounting method, you will import adjustments to increase or decrease your inventory asset/SOH account using journals.

Accounting Methods

If you are using the Periodic method, then you do not need to import Adjustments to your Xero account. For the difference between the two methods, please see Perpetual Method and Periodic Method.

Depending on the stock movements within each adjustment, the net value will either be positive or negative.

Importing a positive adjustment will debit your inventory account and credit your allocated expenses account.

Importing a negative adjustment will credit your inventory account and debit your default expenses account. After this you may choose to direct this from your default expense account to an alternative account that deals specifically with stock loss, theft etc. if you have these set up.

There are three conditions for Adjustments to be imported into Xero:

  • The total of the adjustment is not 0, and
  • the completed date has been entered against the transaction, and
  • the 'Adjust To Xero' date field has been populated within the adjustment.

Importing Adjustments


There are two ways to import Adjustments into Xero.

Importing All Adjustments at the same time

This method will import all Adjustments at the same time. This is the quickest way to import all Adjustments.

  1. From the left navigation, select Accounting, then Xero.
  2. Click Upload Adjustments & COGS
  3. Click Update All
    A confirmation will notify you if all adjustments have been imported successfully.
Importing Individual Transactions

You may wish to only import one Adjustment, or inspect the Adjustments before importing. To do this:

  1. From the left navigation, select Accounting, then Xero.
  2. Click Upload Adjustments & COGS
  3. Check the specific Adjustments you would like to import.
  4. Click Update Selected Adjustments.