Child pages
  • Adding value to inventory

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID:9104

In some industries, adding value to inventory items is a common practice. Your software can be used to track an item's additional costs which can then be included in the cost of the finished item.

Setting up your company file to add value to your inventory

All that's required is a Job to track the expenses, and the Item itself.

 

UI Expand
title1. Create the job
  1. Go to the Lists menu and choose Jobs.
  2. Click New.
  3. Enter the Job information as per the window below, specifying a suitable Job Number and Job Name.
    Image RemovedImage Added
UI Text Box
typenote

Want to learn more about jobs?

See the AccountEdge help (Australia | New Zealand).

UI Expand
title2. Create the item
  1. Go to the Inventory command centre and click Items List.
  2. Click New.
  3. Setup the Item as per the window below, selecting an Item Number that best suits your Items List. Note: The accounts selected in the lower section of the window will be specific to your business and must have been created in your software.
    Image RemovedImage Added
  4. Click the Buying Details and Selling Details tabs and specify the applicable Tax/GST Code to use when buying and selling. Speak to your accountant or the ATO/IRD for advice of the applicable tax/GST codes to use in your circumstances.
  5. Click OK.

    UI Text Box
    typenote
    This item is setup using the perpetual inventory control method. Please seek your accountant's advice if you are unfamiliar with the various methods of accounting for inventory and how they can affect your accounting records. 

How is value added to an item?

Expenses that are incurred to place an item in a saleable condition are recorded using a Bill or Spend Money transaction and allocated to the relevant cost of sales account. These expenses are then transferred to the cost of the Item using an Adjust Inventory transaction.

 

UI Expand
title1. Purchase the item
  1. Go to the Purchases command centre click Enter Purchases.
  2. Click Layout and choose Item then click OK.
  3. Select the Supplier's Card then enter the Date and other transaction details.
  4. Enter the amount Received, the Item Number and Price.
  5. Check the transaction details then click Record. See our example Item type Bill below.
    Image RemovedImage Added
UI Expand
title2. Record the additional costs

Enter the additional costs using either a Spend Money or Purchases transaction.

The window below shows an example Spend Money transaction used to record an expense associated with the Item.

Image Removed Image Added

UI Text Box
typenote

The relevant Job Number is applied to the expenses associated with the Item

UI Expand
title3. Report the expenses associated with the item

Use the Jobs Activity Summary report to determine the expenses and the ledger account allocations. This information is needed for transferring the relevant expense amounts to the Item.

To use this report:

  1. Go to the Accounts command centre and click Reports.
  2. Scroll down and highlight the Jobs Activity Summary report (under the Jobs sub-heading).
  3. Click Customise.
  4. In the Source Journal field, select All.
  5. Enter the Dated From and To dates to capture the entire Job activity for the Item.
  6. In the Jobs field, select the item's job number.
  7. Click Display. The window below shows an example Jobs Activity Summary report.

Image RemovedImage Added 

UI Expand
title4. Adjust the item's value

An Adjust Inventory transaction can now be used to transfer the expenses from the relevant cost of sales accounts to the cost of the Item.

  1. Go to the Inventory command centre and click Adjust Inventory.
  2. Enter the Date and Memo.
  3. In the lower portion of the window, enter the Item Number.
  4. Enter zero in the Quantity and Unit Cost fields.
  5. Refer to the Jobs Activity Summary report then enter the Amount and Account.
  6. Repeat steps 3 - 5 for each expense.

The window below shows an example Adjust Inventory transaction.

Image RemovedImage Added 

UI Text Box
typenote
  • Compare the Amounts and Accounts with the Jobs Activity Summary report shown in Task 3 above.
  • This transaction will reverse the expenses and transfer them to the cost of the Item. Due to the nature of the perpetual inventory system, the expenses will be realised when the Item is sold. 
UI Expand
title5. Confirm the item's adjusted value
The adjusted value of the Item can be confirmed by going to the Inventory command centre and clicking Items List. Open the Item and check the amount in the Current Value field.

The window below shows the item's Current Value ($5317.00), which equals the item's purchase price plus the expenses ($5200.00 + $117.00).

Image RemovedImage Added

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Making inventory adjustments (Australia)

Making inventory adjustments (New Zealand)

I Buy, I Sell, I Inventory and linked accounts

Periodical inventory