• Contents

Importing Adjustments into QuickBooks Enterprise

Last updated 08/01/2021

How to import Adjustments to QuickBooks Enterprise.

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 two conditions for Adjustments to be imported into QuickBooks Enterprise:

  • The total of the adjustment is not 0, and
  • the "Adjust To Xero" date field has been populated within the adjustment.

Running the QuickBooks Web Connector


Before you can import anything into QuickBooks Enterprise you must first run the QuickBooks Web Connector, if you have not already done so recently.

  1. Make sure you are logged into the correct QuickBooks Enterprise account.
  2. In QuickBooks Web Connector, select Cin7 from the list of connections, then select Update Selected.
  3. In Cin7, from the left navigation, select Accounting, then the QuickBooks Enterprise app.
  4. Select Refresh After Running QB Connector.

Importing Adjustments


There are two ways to import Adjustments into QuickBooks Enterprise.

All Adjustments at once

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

  1. Select Import Stock Adjustments.
    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. Select Choose, next to Import Stock Adjustments.
    The number in brackets represents the number of orders awaiting import.
  2. Check the specific Adjustments you would like to import.
  3. Select Import/Update Orders.