Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

From time to time you may need to adjust inventory item quantities and values. For example, if your inventory gets damaged, you may have to write off some of your inventory or revalue it. See below for some examples of inventory adjustments.

This topic explains how to make an adjustment to a single item or a few items.

UI Expand
titleTo make an inventory adjustment

To make an inventory adjustment

  1. Go to the Inventory menu > Create inventory adjustment.

  2. Enter details of the adjustment.

  3. AThe Inventory journal number appears by default. You can change this is if you want, as well as the date of the adjustment. You can also enter a description of the inventory adjustment transaction.
    Select whether you want this adjustment to be allocated as an end-of-financial-year adjustment. EOFY adjustments can be excluded from your financial reports.
    B

    Choose the Item ID of the item you want to adjust (inventoried items only). The name and the current on-hand quantity of the item appear. To find an item, you can start typing the item number or item name into this field.

    UI Text Box
    sizemedium
    typenote

    Entering a new item?

    Click the dropdown arrow in the Item ID column and choose + Create Item. Enter the item details and click Save. Learn more about Creating items.


    Once you choose an item, its Current quantity is shown.

    C

    In the Adjustment column, enter the quantity by which you want to increase or decrease the quantity held. Only enter the quantity variation. Enter the quantity in inventory units, not buying or selling units. If you enter a positive number, that number is added to your on-hand inventory. If you enter a negative number, that number is subtracted from your on-hand inventory.
    When you enter the adjustment:

    • the New on hand column displays what the on-hand quantity of the item will be after recording the adjustment
    • the Unit cost of the item appears by default. This is calculated as the total cost of the item divided by the number of units on hand. If these are new items, enter their purchase cost
    • the Amount field displays the value of the adjustment.
    DChoose the account you want to assign the adjustment amount to. If you’re reducing the inventory value, this account is usually a cost of sales or expense account.
    EIf the item is related to a job, choose the Job.
    FYou can add a description of the adjustment line in the Memo field.
  4. Click Save to save the inventory adjustment.
UI Expand
titleTo view, edit or delete inventory adjustments

To view, edit or delete inventory adjustments

You can view, change or delete inventory adjustments from the Find transactions page (accessible via the Inventory menu or, the Banking menu, or the Accounting menu > General journals).

UI Text Box
sizemedium
typenote

You can't delete an inventory adjustment if it results in a negative on hand quantity or item values.

  1. Go to the Inventory menu > Inventory transactions to open the Find transactions page.
  2. Choose the Period you want to view inventory adjustments for.
  3. If necessary, choose Inventory journal as the Source journal.
  4. (Optional) If you're on the Debits and credits tab, you can choose the Account you assign your inventory adjustments to.
  5. Click the Reference no to open an inventory adjustment. If you want to
    • edit it, make any changes you want and click Save
    • delete it, click Delete.

UI Expand
titleExamples of inventory adjustments

Examples of inventory adjustments

The following are some examples of inventory adjustments.

Example 1

This inventory adjustment increases the number of items on hand by two and the total value of the items on hand by $700.

Example 2

This inventory adjustment decreases the number of items on hand by one but does not change the value of the items. The average cost of the items will increase as a result of this adjustment.

Example 3

This inventory adjustment increases the total value of the items on hand by $120 but does not change the number of items on hand. The average cost of the items will increase as a result of this adjustment.

Example 4

This inventory adjustment decreases the total value of the items on hand by $20 but does not change the number of items on hand. The average cost of the items will decrease as a result of this adjustment.

HTML
<div style="display: none;" data-swiftype-name="keywords" data-swiftype-type="enum">stock item inventory value</div>
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Inventory items and services

Inventory reports

Entering opening inventory balances

Tracking your stock levels

Reordering items

HTML Wrap
classacademyBanner