During the sales process I try to avoid questions regarding inventory valuation and to be honest I do this because I do not understand the differences and what impact the valuation options have on the financials. I am not an accountant nor do I try to be, however I should really have a better understanding of inventory valuation methods after years of selling to
There are lots of good articles and websites on this subject matter and I have learned that the way you value your inventory can have a huge effect on your financials. After researching this topic, I have also learned that I am probably not qualified to write an intelligent article on inventory valuation. Therefore, I am going to list some resources for you and me to reference.
Probably the easiest for me to understand came from my Bing search term Inventory Valuation Method Under GAAP.
Another good resource is the AccountingCoach website. There is a good explanation
I have also attached a white paper
Dynamics GP uses the following valuation methods:
Valuation Method | Description within Dynamics GP |
FIFO perpetual | Items purchased first are considered sold first (First In, First Out). Detailed information about the cost of all items is maintained, and the inventory is valued at its actual cost. The current cost for items is the cost of the item the first time it was received. |
LIFO perpetual | Items purchased last are considered sold first (Last In, First Out). Detailed information about the cost of all items is maintained, and the inventory is valued at its actual cost. The current cost for items is the cost of the item the last time it was received. |
Moving average perpetual | The cost of items with the same item number is totaled and an average cost is assigned to the items. The average cost of an item is revalued throughout the period as you enter increase transactions for items. The average cost also is used as the current cost. The formula is:(Current units x current moving average cost) + (New units x purchase price) / (Current units + new units) |
FIFO periodic | Items purchased first are considered sold first (First In, First Out), and are valued at their standard cost. To update the standard cost, you can use the Inventory Year-End Closing window. At the end of the year, the standard cost can be adjusted to the current cost. |
LIFO periodic | Items purchased last are considered sold first (Last In, First Out), and are valued at their standard cost. To update the standard cost, you can use the Inventory Year-End Closing window. At the end of the year, the fixed cost can be adjusted to the current cost, or the cost of the item the last time it was received. |
As stated previously, I am not an expert however there is a plethora of information on inventory valuation and best practices for Dynamics GP on the Internet. I do think that I have learned enough to know that I will continue to defer to one of our consultants on this matter during the sales process!
If you care to comment on the information above or have any questions please feel free to contact me at 817-640-0016 x 109 or by emailing me at nphillippi@customis.com.
Have you ever thought about publishing an e-book or guest authoring on other blogs?
I have a blog based on the same subjects you discuss
and would really like to have you share some stories/information.
I know my viewers would enjoy your work. If you're even remotely interested, feel free to
send me an e-mail.
It's hard to come by knowledgeable people on this topic, but you seem like
you know what you're talking about! Thanks
Nancy, thanks for pointing out how important it is to select the appropriate method for your business. It is critical that the choice they may for their system does match their business philosophy!
And thanks for the resource links...funny, I just posted about attending Long Beach State in my post. The 49ers get two mentiones this week!
Nice and straightforward, even though its a confusing topic. Well done!