Last updated 04/10/2017
Adjustments are a very important part of Cin7.
They serve two purposes only:
There are several reasons you may wish to change your inventory counts.
The first and most obvious reason is to account for any stock discrepancies that are found during stocktake.
It could be that you have gained stock - perhaps you have found stock that wasn’t initially counted.
It could be that you have lost stock - perhaps it has been stolen or lost. Occasionally stock becomes damaged or expires and has to be thrown away.
You may also wish to change the value of the inventory items in stock - adjustments are the best place to do this too.
To Create an Adjustment
Click into the Qty Adjusted column and add in the batch/serial numbers you want to receipt in to stock. If you are receipting out of stock, select them from the list and click the green arrow to remove them.
If you track stock by location you can receipt stock into a specific location by clicking the Qty Adjusted cell and adding a location under the Location column.
To receipt stock from a particular location, click into the Qty Adjusted cell and select the green arrow from the list of locations to remove stock from that location.
It is sometimes necessary to change the value of stock in your inventory. Perhaps the value was input incorrectly during set up, or you have found another error.
To do this
Adjustments can be imported to your accounting software through the appropriate module - just like importing a sale or a purchase.
If you’re using the periodic method of accounting, it is not necessary to import adjustments.
If you’re using the perpetual method, importing a positive adjustment will debit the 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.
Batch / Serial stock items
For more information see Auto-Adjustments.
It is possible to import adjustments - but it is far easier to use the stocktake master module instead - see Stock for more information.
Holding Stock can be adjusted out just like any other negative adjustment, but you must first clear the holding group by clicking into the holding column and clicking clear:
You will need to use separate lines for the positive and negative quantities. Note that if the net total value of the adjustment is 0 you will not be able to import to your accounting system. In this case you should navigate to the Review screen and set the Xero/QBO Status to "Do Not Import"