• Contents

Importing Adjustments to QuickBooks Online

Last updated 08/01/2021

How to import Adjustments into QuickBooks Online.

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.

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 QuickBooks Online:

  • 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 QuickBooks Online.

All Adjustments at once

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 QuickBooks Online.
  2. Select Upload Adjustments & COGS.
  3. Select Update All.

A confirmation will notify you if all adjustments have been imported successfully.

Individual Adjustments

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 QuickBooks Online.
  2. Select Upload Adjustments & COGS.
  3. Check the specific Adjustments you would like to import.
  4. Select Update Selected Adjustments.