Import adjustments into 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.
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.
Make sure you are logged into the correct QuickBooks Enterprise account.
In QuickBooks Web Connector, select Cin7 Omni from the list of connections, then select Update Selected.
In Cin7 Omni, from the left navigation, select Accounting, then the QuickBooks Enterprise app.
Select Refresh After Running QuickBooks Connector.
Import 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.
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:
Select Choose, next to Import Stock Adjustments.
The number in brackets represents the number of orders awaiting import.Check the specific Adjustments you would like to import.
Select Import/Update Orders.