Download this template here: [ Ссылка ]

This was so hard to figure out how to do right, but it is done. The logic here will let the user enter their purchase history and sales history. Based upon that data, it will spit out a COGS value for each individual sale batch that is in line with FIFO (first in, first out). It will go for up to 400 batches and is easily expandable.

I used FIFO because it is demanded by IFRS and is also acceptable by GAAP.

свернуть