Set up for adding value

1. Create a new item for the inventory being purchased (Inventory > Items List > New).

   • Select an Item Number that best suits your Items List.

   • Click the Buying Details and Selling Details tabs and specify the applicable Tax/GST Code to use when buying and selling. Check with your accounting advisor if you're unsure what to choose for your situation.

   • The Cost of Sales Account, Income Account For Tracking Sales, and Asset Account For Item Inventory will be specific to your business and must have previously been created. For more information on creating accounts, see Create detail and header accounts.

   Here's our example item (a second-hand car):
    

2. Create a new job which you'll use to track the expenses associated with improving the item (Lists > Jobs > New).

   • Select Detail Job.

   • Enter a suitable Job Number and Job Name.

   Here's our example:
    

1. Purchase the item

1. Enter a new purchase for the original item (Purchases > Enter Purchases > Layout > Item > OK).
2. Select the Supplier and enter the other transaction details. Here's our example purchase of a used car:
   
3. Check the transaction details then click Record.

2. Record the additional costs

Enter the additional costs using either a Spend Money or Purchases transaction. The accounts you allocate these expenses to will need to exist in you company file (create these accounts if required).

Also specify the Job (created earlier) to each expense associated with the item.

Our example shows a Spend Money transaction for the expenses associated with our second-hand car. Note the job specified in the Job column.

3. Report the expenses associated with the item

When all expenses have been recorded, use the Jobs Activity Summary reportto determine the expense values and the relevant expense accounts (Reports > Index to Reports > Accounts >Jobs > Job Activity Summary). This information is needed for transferring the expense amounts to the item.

1. Filter the Jobs Activity Summary report as follows:
   • In the Source Journal field, select All. 
   • Enter the Dated From and To dates to capture the entire Job activity for the item.
   • In the Jobs field, select the item's job number.
2. Click Run Report.

Here's our example which shows the value of the additional costs (Net Activity) associated with our second-hand car:

4. Adjust the item's value

With your Job Activity Summary values, you're set to add value to the inventory. This can be done using an Inventory Adjustment (Inventory > Adjust Inventory).

1. Enter the Date and Memo.
2. Enter the Item Number..
3. Enter zero in the Quantity and Unit Cost fields.
4. Refer to the Jobs Activity Summary report then enter the Amount and applicable Account.
5. Repeat steps 2-4 for each expense.

Here's our example for adding value to the used car:

When all the expenses have been entered, click Record. This transaction will reverse the expenses from the expense accounts and transfer them to the cost of the item. The expenses will be realised when the item is sold.

5. 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.

Our example shows the item's Current Value ($5317), which equals the item's original purchase cost plus the expenses ($5200 + $117).