• Contents

Adjustments

Last updated 04/10/2017

Adjustments increase or decrease your stock. This article contains everything you need to know about adjustments.

Overview


Adjustments are a very important part of Cin7.

They serve two purposes only:

  1. Increasing your inventory
  2. Decreasing your inventory

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.

Creating an Adjustment


To Create an Adjustment

  1. From the left Navigation click Stock, then choose the Adjustments module.
  2. In the Adjustments list page, click New Adjustment.
  3. Enter a line item into the transaction.
  4. Enter the quantity. This can either be positive or negative. Positive will increase the inventory, negative will decrease the inventory.
  5. To finalize the transaction, enter a Completed Date.
  6. Enter a date in the Adjust to Xero box to alter the inventory balance in your accounting software if appropriate (see below).
Adjusting Batch/Serial stock items

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.

Adjusting Stock tracked by Location

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.

Using Adjustments to Change the value of stock


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

  1. Adjust out the inventory by creating an adjustment with a negative value.
  2. In a separate adjustment, create a positive adjustment to bring back in the stock at the new value.
  3. Complete and then Import both transactions to your accounting software if appropriate (see below).

Importing Adjustments to your Accounting Software


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.

Adjusting Stock by location, serial number, and batch

Batch / Serial stock items

  • If they are "Batch" or "Serial" items, 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.

Locations

  • 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.
  • Same goes if you want 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.

FAQs

I can see some 'auto-adjustments' in my adjustments module. What are these?

For more information see Auto-Adjustments.

Is it possible to import adjustments?

It is possible to import adjustments - but it is far easier to use the stocktake master module instead - see Stock for more information.

How do I adjust out stock that is in holding? 

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:

 

How do I adjust stock in and out for one product on the same adjustment? 

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"