Excel FIFO multiple products. No VBA!!!
Вставка
- Опубліковано 12 вер 2024
- In this tutorial I demonstrate Excel model which calculates FIFO formula for many products. The model also calculates inventory by products and distinguishes them by their unique purchase prices. The model has no Visual Basic! ENJOY! :-)
this is exactly what i need, can't find the file on your website tho.
This is very useful, thank you. However, the site is down. Any chance to get the excel file somewhere? Thank you!
@costviewer
I have been following your UA-cam channel & your fifo excel sheet is superb..
I'm stock trader & I want to maintain an excel for investments on FIFO basis.
For example: I purchased X company's share which has opening balance form last year & also purchase made this year & now I sell the shares soo I want to that FIFO method should be applied first shares from opening balances should be reduced thn from purchases..
If u can help my by providing a template or if u can guide how to build such an template, It will be a great help..
Thanks..
Hello, I am from Iraqi Kurdistan..salm your hands worked well ... I have a question: how many rows can I include after cell 39..Can I list more than 2000 cells towards the bottom and start from cell 39
hello , website is not accessible , will you send me a link where this file can be downloaded ? please and thank you
@costviewer
i am having an issue with the table. if the sale amount exceeds the total purchases up to that row then it does not calculate correctly. for instance, I purchase 10 units at $10 a piece and then another 10 units at $9 a piece. then my first sale is 12 units it will calculate all the 12 units sold at $10 COGS.
Super sheet! Excellent
You are amazing ❣️
Hi, when using the multiple products tab, does anyone know why when adding rows, the value error appears for select rows in columns P-T? doesn't happen to every row, only a few, but obviously if I F2 any other cell in P-T, it also recreates the same error
when i evaluate the formula in the broken cells, it shows Sum(--IF({0;0;0;0;0;0;0;0;0;0;0;0;0}
I tried to seperate each table into each sheet and adjust the formula accordingly but it doesn't work the same. Can you help me take a look?
This is the great excel file which I need it very much. But here one thing is missing, that is, how is Opening Balance? How could I set formula for Opening Balance? Please, help me. Thanks.
Hello, may I know how to show the item even with zero balance?
Very good but bogs down with larger amounts of data. If one could simplify and get rid of array formulas to speed up calculations with more records this could be great.
exactly. does anyone have solution for this. any simple formula for this?
Hi,
the Model is really excellent. but where is Day column. as I always wanted to know daily usage?
Hi Irfan, what you can do is as follows:
1. In cell for example E13 type in date (this cell will be white-shaded then).
2. In column A, next to SKU/ID, add Day column. Below type in dates. And then somewhere above, say in range [C7:C9] (next to SKU summary), you can write SUMIFS formula which would summarize used quantities for a given SKU in a given day (day is referred to cell E13).
I'm trying for sometime but it's not helping me...
how does automatically FIFO if products in different expired dates
Costviewer site is not opening, Can you please help ?
Hello Could you please share the download link i need it
Hey @costviewer the site seems inactive. Can you help get the file.
hi can you please share the files? website stops working
how to get this file due to the website domain expired. If anyone has the file please share. Thanks much
sorry web address not working. please can you share with me?
Can you share this file , please :)
Hi.
Here's the link to download site:
www.costviewer.com/en/do-pobrania
@@costviewer2406 thank you
Hey guy, when i see formula in P27, then "enter" -> "#value".
How could i fix it, i wanna change formulas. Please help me. Thanks.
you need to press F2 and then Ctrl+Shift+Enter
how to add column?
HI!.. I CAN´T SEE NOTHING, NEITHER THE FORMULAS OR THE SHEETS. AND THE LINK OF COSTVIEWER IT DOESNT EXIST.
Hello. Link:
www.costviewer.com
does exist :-)
And this is a link to English website: www.costviewer.com/en
And here's a link for downloads section:
www.costviewer.com/en/do-pobrania
thank you very much
Hi.
Here's the link to download site:
www.costviewer.com/en/do-pobrania
@@costviewer2406 Hi, The link is not working. Kindly assist.
@costviewer hi, can you please reupload this file? And give us link. You have such a great vids and skill
I can not see the excel
Thanks sir
Hi, Can i get this excel file? I think it will be much more helpful for me. Can you send me it? thanks
just go to costviewer.com/en/do-pobrania
There you will find Excel file.
this's exactly what i need it. Thanks a lot :)
could you share with me as well?
@wan yan chow : costviewer.com :)
Awsome..can you do it for weighted average perpetual ? I need it please..any ideas ?
This is easy :-)
CostViewer for multiple items ? Would be much appreciated if you could help with this one
I plan to also add LIFO but the solution I know would only work with Excel 365.
I can't find the file please share the file