Difference between cost price and unit value in inventory

16/09/2019 11:34 AM

Difference between cost price and unit value in inventory

I know I have been told this several times, but could you once again explain the difference between cost price and unit value in inventory. Where does cost price show and where does value show other than the reports in inventory where both show side by side. Why do we need two values at all when in our system 90% of the items both values are same?

Riya Sood
16/09/2019 11:54 AM

The difference between cost price and unit value in inventory is that unit value is the actual value as per your vendor invoice without sales taxes / GST while cost price is the total amount of money spent without sales taxes / GST to procure the item. Unit value is a financial quantity that matches with your balance sheet one on one. It defines the financial value of your opening stock, current stock and closing stock. It also derives purchase and changes in inventory in your profit and loss account. In simple words it is the legal value of your stock. Cost price is unit value plus all overhead expenses. It includes but is not limited to transportation cost, labor and so on. Unit value cannot change unless there is a formal stock revaluation done. Cost price is a dynamic quantity and based on the settings pre-selected in the system, it can keep changing. Cost price is mainly used to decide the selling price of the product and it appears in all such reports and places where the actual cost is required to be taken into account. If the user has the required permissions to do so, cost price can be altered manually to account for intangible costs like employee time and cost of opportunity etc. Therefore, normally cost price is either the same as value or it is more. However, under exceptional circumstances it can be less as well. 

Examples where cost price changes :

Suppose you have purchase an article last month and your vendor invoice showed taxable value Rs 100 per item. Your inventory will show Rs 100 as cost price and Rs 100 as value. You balance sheet as well as your profit and loss account will show Rs. 100. Suppose today you receive an invoice from you transporter for Rs. 10 for the same consignment. After accounting this invoice your cost price will show Rs 110 while your value will stay Rs 100. This extra 10 Rs will show in your indirect expense. Suppose after a while you receive another invoice from labor contractor for Rs. 20 for the same consignment. After accounting this, your cost price for the item will be revised to Rs 130 while value still remains unchanged at 100. 

When you see the same product in price lists it will show you cost price as 130 and you can decide your selling price based on 130. If you have set auto-margins on the price list, system will automatically suggest the price based on those margins.

I hope this explains. 

If you are not sure about what to do, just accepts all defaults and let Tuhund help you out. 

16/09/2019 10:33 PM

Thank you for the explanation. Do we have any place where we can see table like value, overhead expenses, total cost? 

Riya Sood
16/09/2019 10:52 PM

Of course. This is an important report helpful in many ways. There is a “Purchase Cost” button in home page of price management where you see price maps. That takes you to the report where you can see average value, average net cost, average expense, total value, total net cost, total expense for each product. You have a number of filters too that you should explore. It will give you very valuable and elaborate information that very few other ERP systems have. 

User Community Home

ERP Interest Groups

Topics : 16|Last Topic : 14/01/2020 11:03 PM
Questions and queries about Accounting a Finance module. Working with cost centers. General Ledger, Accounts receivable, Accounts payable, financial statements, expense claims management, commission payables and receivable claims, Forex, Currency, Assets, Depreciation, Taxes and TDS, etc.
Topics : 12|Last Topic : 09/03/2020 11:53 PM
Information about Tuhund. Tuhund has moved far beyond and is much larger for just being called an ERP.
Topics : 4|Last Topic : 10/04/2019 11:32 AM
Point of sales software, Andriod and IOS applications and other software linked with Tuhund. API for connecting with Tuhund and building applications on top of Tuhund backbone.
Topics : 1|Last Topic : 10/10/2019 09:36 AM
Discussions on ERP in general and comparison of various ERP, their features, working, issues and workarounds
Topics : 3|Last Topic : 15/12/2019 11:19 AM
Questions and queries about Human Resource Management Module
Topics : 14|Last Topic : 25/11/2019 08:42 PM
Questions and queries about Inventory and Procurement Modules. Products and product categorization. Vendors Price Lists, Quotations & Invoices, Requests For Purchase, Requests for Quotes, Purchase Orders, Purchase Invoices, Tenders, Store Management, Locations, Stock. Inventory reports, margin analysis, ageing analysis.
Topics : 2|Last Topic : 26/12/2018 01:46 PM
Questions related to GST, GSTR1, GSTR3B. Issues and problems faced in GST Portal.
Topics : 2|Last Topic : 29/12/2018 11:34 PM
Knowledge sharing, support and help with Project Management Module; Project Schedule Management, Project Scope Management, Project Resource Management, Material Management, Expense Management, Deliverable, Billing and Invoicing.
Topics : 18|Last Topic : 01/02/2020 07:43 AM
All about Sales and Customer Relationship Module. Tasks, reminders and events. Inquiries, opportunities and business leads. Different types of sales targets and key performance indicators.
Topics : 1|Last Topic : 12/12/2018 12:57 PM
We welcome suggestions from our customers, third party users as well as from general public. Our aim is continual improvement of Tuhund. We are not going to stop or slow down development of Tuhund. Please let us know what you are looking for in Tuhund and we will make sure it is added.
Topics : 4|Last Topic : 28/07/2019 11:19 PM

Keywords

#access #accounting #accounts #activity #adapter #admin #advance #ageing #agent #aging #amount #analysis #android #app #application #approval #assets #attachment #attendance #automatic #backup #balance #balancesheet #bank account #bank #barcode #bi #boe #bonded #bounce #branch #browser #business development #business intelligence #calculation #cash #change #charts #chat #claims #clearing #comments #commission #companies #company #compliance #configure #consumption pattern #control #conversation #conveyance #coordinates #cost #costcenter #courier #credit note #credit #crm #currency #custom duty #customer #customization #dashboard #data #database #date #default #delivery charges #delivery #depreciation #discount #discussion #disk #document #download #drill down #drive #duplicate #elevate #email address #email client #email message #email #employee #entries #epf #evidence #excel #exchange #expense #failure #filters #finance #financial year #forwarding #function #group #gst rate #gst returns #gst #import #indent order #indent sale #information #inquiries #install #instructions #integration #inventory #invoice #journal #kilometer #ledger balance #ledger #license #limit #live #loading #location #locking #login #logout #logs #macbook #machine #management #maps #margin #marketing #mass mail #master #migration #mobile #module #newsletter #number #odometer #online #opening balance #outbox #payable #payment #payroll #pdf #performance #petty cash #picture #pnl #point of sales #pos #prefix #price list #price #printer #process #procurement #product #products #profit #proforma invoice #project #promotional #purchase invoice #purchase order #purchase #quotation #rate #reading #receivable #recipient #reconciliation #register #report #request #requirement #requisition #resource #retail #revenue #revision #rfq #rules #saas #salary #sales return #sales #salesmen #sample #schedule #scope #search #section #selection #sensitive #sensors #server #services #settings #share #sms #software #space #statement #sticker #stock #storage #stuck #subledger #support #synchronize #system #target #tasks #tax invoice #tax liability #tax #template #therefore #thermal #topics #tracking #transaction #user #value #vat #vendor #vouchers #warehouse #warranty #wbs #widget #zones
Tuhund Logo
TUHUND®
Home About us Modules CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers Community Blog
M Home Schedule Demo About us Community Blog
CRM HR SALES BI SERVICES MANAGEMENT INVENTORY MANAGEMENT ACCOUNTING AND FINANCE PROCUREMENT PROJECT MANAGEMENT ERP ADMINISTRATION DATA REPOSITORY API & SUB PORTALS Careers
Request Demo