average cost of good

Mathieu ThomasMathieu Thomas Member Posts: 5
edited October 2019 in Accounts Hosted
Hi there,

I created a list of inventory items and recently noticed that some of them come with an average cost of goods ($10) where others have nothing. 
Result is the P&L is incorrect and I cannot seem to find a way to delete this cost.
For info I don't use the inventory management functionalities and never entered any cost for these items.


  • Crabn GearCrabn Gear Member Posts: 7
    edited September 2018
    Yes we had the same problem. The average cost is coming from when you enter the bill for this item.
     I have the same problem when I transfer stock from built items over to inventory items the cost comes up different. I have tried everything with no luck. thanks Mark 
  • John GJohn G Reckon Staff Posts: 2,283 ✭✭
    edited September 2018
    Hello Mathieu and Mark,

    Thanks for asking.

    When you activate the Inventories feature Reckon Accounts will keep tabs of the average cost of inventory items you purchase through Enter Bill and Write Cheque functions (and Adjustment Notes for returns).  For opening balances of Inventories and transfers you will need to use the Suppliers > Inventory Activities > Adjust Quantity / Value on Hand function to manually change the quantities and values of the stock.  

    Although you can affect the value "Inventory Asset" shows on the Balance Sheet through a General Journal, that transaction will not impact on the independent Inventory module that tracks your stock levels and its average cost.  

    When you sell an inventory item Reckon Accounts will remove that number of stock from its Inventory on Hand and transfer its cost of goods sold at the average cost of all purchases of that item to the Cost of Goods Sold account (type: COGS) for calculation of the Gross Profit on the Profit & Loss Report.  

    Hope this explanation helps.

  • Mathieu ThomasMathieu Thomas Member Posts: 5
    edited September 2018
    Hi John,

    Thanks for this, this really helps, 

    The thing bizarre is that I only have a few items with an average cost and I have no ideas where it is coming from as I never entered them trough a bill with a cost associated... 

    I don't want this to impact my PL so I guess if I bring the value to 0 then the average cost will return to ?
  • John GJohn G Reckon Staff Posts: 2,283 ✭✭
    edited September 2018
    Hi Mathieu,

    Go to Lists > Item List, right click one of your items and select FastReport.  Change the Dates field to All to see all transactions that have been made for this item.  Click on an entry in the Report to see the transaction detail.  

    Hope this provides some insight to what has happened.

  • AnnieAnnie Member Posts: 6
    edited October 2019
    Hi John

    This has helped me so much.  

    Many thanks
Sign In or Register to comment.