How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi. Calculation Ms Excel 2019. #Stocksheet #salepurchase #Profitsheet
Жүктеу.....
Пікірлер: 232
@rjenterprisefireoileandgas74093 жыл бұрын
Sir jabardast saral aur sidhi language me samjaya aapne, 10:30 minutes me 10 dinoka gyan diya apne
@akhan84562 жыл бұрын
How would you deal with a situation where an item is sold with different rates each day or may be multiple times in a day even?
@akshine232 жыл бұрын
Mashallah Mashallah Allah Pak apko jazaay khar ata frmay or dunya o akhrat ke hr hr kamyabe khuse say navazy ap nay mare mushkil asan ke Allah pak ap or apke nasloon ke taa Qamat hr hr mushkil musebat prshane tang dste hadsat dukh say nejat ata frmay ameen
@shahabislam4912
2 жыл бұрын
Jazak Allah
@ShamimKhan-li7yc3 жыл бұрын
Walykum asslam Aap ne bahut achcha bataya Very very thanks 😀😀😀😀
@nadirazizaziz81723 жыл бұрын
Assalamualaikum This video is really very helpful thank you so much. " God bless you Sir "
@MrVingo33 жыл бұрын
How to manage product 1 things when we sold the same thing with different customers with diffrent price ??
@AjmalKhan-zx8le3 жыл бұрын
Thank you sir very easy how to data maintain in simple way 😍
@sabirmirza66062 жыл бұрын
Mashallah bhai, this is what I was looking for. Thanks alot
@durgasuthar15363 жыл бұрын
Thank you so much sir 🙏🙏🙏this is very helpful video
@priyankasharma90473 жыл бұрын
Sir apne bhut acha smjaya hai ......ap thoda slow smjaya kreye ..👍👍👍👍👍👍👍👍
@muhammadshakeel34714 жыл бұрын
Assalamualaikum superb duperb performance
@maruficomputereducation2923 жыл бұрын
100% true. And best trainer
@shariqkhan45053 жыл бұрын
MASHA LOVE your voice. Bismillah hir REHMAAN ❤️🌷 .....wow what a good start MASHA ALLAH.
@moethawtartin94853 жыл бұрын
Thank u...this very useful for me😊
@ashishagarwal818Ай бұрын
Sir ap ki knowledge acch h pr ap tiping pr dhyan di dye
@mahnoornoor68712 жыл бұрын
Ur videos.r very helpful thanks
@paighamofficial-02 жыл бұрын
Thank you for the polite request to put a project link in all your videos
@tausifahmed3768 Жыл бұрын
Asw सर एक वीडियो बनाए please जिसमे एक बिल में लोट में स्टॉक आता है जिसमे उसके बिल का descurption जिसमे date,bill no,D.O No,etc है और उसके मैटेरियल का description जैसे item name,qty,size,हो बिल महीने में 10से ज्यादा आता है same item और अलग item भी,स्टॉक का total भी एक जगह रहे, सर इसका format बहुत लोगो से तैयार करवाया नही हुआ प्लीज you can see, its like challange 🙏
@siddheshkorlekar74584 жыл бұрын
Thank you so much Shahab bhai 😊
@Ariijiina3 жыл бұрын
Thank you so much sir help has helped me so much
@shntpandey112 жыл бұрын
If I purchase a same product with different rate what should I do?
@akhan8456
Жыл бұрын
I have asked the same question about an year ago but no reply
@UsmanGhani-vf3ow4 жыл бұрын
Mr. Shahab Islam, Thanks 2 U, we need your others videos for SKU and Inventories for Forecasting and Demand Planning
@muhammadamjadmuhammadamjad5677
3 жыл бұрын
Plz contact me
@mohankhatumria93104 жыл бұрын
Sir, this exel sheet is all in one. This is 90% useful in our trading shop. How we add-on New stock entry with Dates ?
@mrpremprajapati20903 жыл бұрын
Thanks sir full information video sir 👌👌👌
@shahabislam4912
3 жыл бұрын
So nice of you
@subechhabajracharya78149 ай бұрын
can you please make a new video with items being sold with different rates
@ibrahimgangawali57524 жыл бұрын
Bahut acha hai sir thnk u so much god bless u ...
@tanukhan8367
4 жыл бұрын
Ya right
@mdSalman-lx8nm3 жыл бұрын
Bro when I clicked on this video your starting intro voice is same like when flight ready to takeoff announcement tone. 😂👍👍
@hafizibrahimshah6842 Жыл бұрын
Thank u sir this is very helpful for me...
@yashish112 жыл бұрын
Hello sir I want a detailed video on inventory management with same product of different sizes on excel
@rheapeter9709 Жыл бұрын
Thank you sir!!
@shahabislam4912
Жыл бұрын
Most welcome!
@rinchennegi31174 жыл бұрын
I like your teaching sir
@Cocktails4182 жыл бұрын
YOU ARE GENOUS
@ilyasorakzai58172 жыл бұрын
Sir you use very easy method
@ilyasorakzai58172 жыл бұрын
Thank you so much sir Care on
@shahabislam4912
2 жыл бұрын
All the best
@queen74383 жыл бұрын
Thank you sir ❤❤
@khalidshahzad15474 жыл бұрын
Sir please tell if products are sold at different rates then then how to calculate sale price of exact units ?
@tabassumhasankhan95393 жыл бұрын
Assalamualaikum. Sir Amount ka grand total samjh nhi aaya please bta dijiye, bahut achcha video h Allha aapko or tarakki ata frmye.
@aamirsheikh5879
2 жыл бұрын
Tabassum apna fanka Kitna khula hua hen
@whitemoonstudio2 жыл бұрын
Very good ! Thanks Buddy
@shahabislam4912
2 жыл бұрын
You're welcome!
@nepalinaanu64153 жыл бұрын
Sir Is there any way to automatically copy the sheet 1 data to sheet 2.whenever I make change to sheet 1.. PLZ REPLY
@AlEmaan.Fabric2 жыл бұрын
Nice knowledge.
@darkff6610 Жыл бұрын
Thank you so much sir👍🏻
@shahabislam4912
Жыл бұрын
Most welcome
@neerusharma80114 жыл бұрын
Official accounts k liye isko use karna best hoga
@RScomputerinformation4 жыл бұрын
You are good sir
@opboy95443 жыл бұрын
Isss mein rates different ho skty hain,like ksi customer ko discount Dia?? Aur other expenses add krny hu toh??
@tanukhan83674 жыл бұрын
Thanx sir
@mrmasterofms6468 Жыл бұрын
informative
@shaheenashakeel1245 жыл бұрын
Assalamualaikum sir mashaAllah itni ability aap ma han kahan se itni Knowledge late han pls tell owesome....................
@mehakiqbal8412
4 жыл бұрын
Hahaha parhne se ati h ability
@ramkrsoni3 жыл бұрын
VERY USE FULL
@tarikulislamtanvir59042 жыл бұрын
Its a work which can be done by childrens, If u can, explain how to calculate profit and loss for same product with different purchase price and sell price according to stock
@rabiamumtazasst.ladywarden89584 жыл бұрын
Aoa. How can we add IV, DV and CV for making mutual fund portfolio, kindly guide
@thilagavathi57023 жыл бұрын
Thank you sir
@matiullahsahil11394 жыл бұрын
I want to make sheet for stock purches p/l it is ok
@listenhaq64552 жыл бұрын
Please provide download link of this sheet
@tapasari56154 жыл бұрын
Day by day kaise maintain karu? E to one day ka hisab ha. Monthly report kaose karu?
@mitochondria28297 ай бұрын
thank you sir, yeh sold ka rate 20% fix nhi laga sakty sir, formula????
@muhammadshakeel34714 жыл бұрын
Assalamualaikum excellent
@numanahmad34803 жыл бұрын
kindly share this file in description
@srinivasp36544 жыл бұрын
Very nice sir
@playshortss5 жыл бұрын
Sir aap kon se software se recording Kar rahay hain Or ye software free hai ya paid Wala hai
@sumit4691
4 жыл бұрын
camtesia
@awaiskhan81352 жыл бұрын
Sir plz create a video lecture about Powe BI excel training.
@shahabislam4912
2 жыл бұрын
As soon as possible
@janalam25072 жыл бұрын
Sr it's too good clip but I'm confused in multiple rates amounts and also sold lets understand me with details
@amitkainth84648 ай бұрын
Thanks sir
@upendragautamips4013 жыл бұрын
Very nice
@umarhassan119 Жыл бұрын
Agr ek he profuct ko manage karn ho different dates main sale ho to usko kesy manage karein gy
@dhanishmehta3 жыл бұрын
Thanks Brother for this video Can you please guide how to maintain the same thing productwise ratewise ie (FIFO) basis Unless I finish my first rate qty, 2nd rate should not consider. This will very helpful.
@dhanishmehta
2 жыл бұрын
Hello Brother I am still looking for the solution for the stock to be maintained for particular product with multiple purchase & Sales rate on FIFO basis Pls give me the solution........
@shahzilshafi8045
Жыл бұрын
@dhanishmehta brother did you find solution?
@shafiqsalam48835 жыл бұрын
Very Nice
@sudeepkn16323 жыл бұрын
can u plz teach how to oparet exel in mobil formet
@freshtimehandwash16632 жыл бұрын
Walikum Assalam
@plok_idea4 жыл бұрын
💗
@abdulmajidkhan21364 жыл бұрын
ASSALAM-O-ALAIKUM SIR AAP KI VIDEO BOHAT ACHI LAGI ISMAY SE KAFI KUCH TO MUJHAY PATA THA LEKIN AAP SE BHI BOHAT KUCH SEEKHNAY KO MILA .. SAWAL YE HAI K ISI SHEET KO AGAR HUM SOFTWARE TYPE MAIN CONVERTED KARNA CHAHAIN TO KESSAY KAR SAKTAY HAIN
@shahabislam4912
4 жыл бұрын
formatting or advance formula se hojega.excel series dekhen meri use idea mljega.
@nareshoraganti8356
4 жыл бұрын
Thank u sir, I want excel vellow cup vedio sir plz
Excel 2016 sheet me 365*7 sell me Namaz ki Takveem me sirf time likha hua he aur un sabhi sell me ek shath 2 minutes plus keae kare
@MuhammadUsman-hd7lv9 ай бұрын
Bhai Aslamoalikum
@trojangamimg84834 жыл бұрын
How can we do this in excel mobile app ?
@mansoorrana71454 жыл бұрын
Sir aap ne expense ke beghair hi P&L bana dia
@iqbalkhan87924 жыл бұрын
Waleku assalam
@rohitkadam18593 жыл бұрын
When we have stok off x-300 and we sale only x-200 then remaining amount and stock shown as per your sheet but after next day when we sale remaining 100 x it was not calculate please explain or add this
@rlskhankhan67844 жыл бұрын
Formulas use karte time aap jaldi jaldi btane lgte ho WO nahi samajh mei aya
@saqibbasarikatti23032 жыл бұрын
Bhi excel sheet bhi share karduna. Link pay
@rlskhankhan67844 жыл бұрын
Thnq sir
@AAA-mq9jj2 жыл бұрын
if i buy product 1 muliple times at different prices and also sell them at different prices how to find profit at once?
@ilyasorakzai58172 жыл бұрын
Well done sir
@anasahmed60554 жыл бұрын
Salam. Sir I hope you are fine. Sir yeh video aap ki konsi playlist main hain.
@shahabislam4912
4 жыл бұрын
Playlist me nhe he. kzread.info/dron/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos?disable_polymer=1
@mukeshbaroli56874 жыл бұрын
Hello sir I m from restaurant business I want to know how can I maintain my cutlery and crockery stock by item name
jo bac giye dusra din sale kore ga tu sir kesa note add me dale ga
@Muhammadarif2917.2 жыл бұрын
Great
@OmniaSerag3 жыл бұрын
Hi Can I make this in smart phone? If I can tell me how please
@azeemmakeen13894 жыл бұрын
Good
@NawazViewers4 жыл бұрын
Grt
@KaleemKhan-gk1tm4 жыл бұрын
Sir video to theek hai... Magar thoda fast batate ho ..isliye samajh me nahi aaraha.
@dbalouch5716 Жыл бұрын
Bhai ap khod confuse ho or ya video dakho to hum bhi confuse ho rhe hy. Agar galti ho gai to dobara sare complete video bna date take bat smjh mn aye or clear ho
@leosibbi18182 жыл бұрын
EXCELLENT
@shahabislam4912
2 жыл бұрын
Many thanks!
@krishnabhaktabisidhyoshres36134 жыл бұрын
How to add after purchase, please solution sir
@mohammedhidayathulla5 жыл бұрын
assalamu alaikum sir do you know about financial modelling course please make education video on that it will be very useful in future in Sha Allah
@Amanabbasghouri3 жыл бұрын
Can you please tell... What if we want to add more products accounts then how will go down the total automatically... Please tell, tomorrow is my exam
@tulsidasgoun42444 жыл бұрын
Sir jaise 100 ki total se 25% or 70% kaise alag karen
@muhammedali43934 жыл бұрын
How to maintain partial sale????
@ImranKhan-kx1oi3 жыл бұрын
How to calculate sales for a pharma franchise company having 5 products... Total sale
@TheHiddenStories675 Жыл бұрын
Nxt tym jo item stock ma ayegi new price ka sath toh usko kasa manage kra anyone know about it?
@shrimegha8613 жыл бұрын
Sir plz show how to do this in provision store day by day plz....
@Davisha1522 Жыл бұрын
Mera ek excel sheet dusre sheet shift karna hai or jo source sheet hai usme ek row me 6000 ke value ka count uske saamne mujhe uska remark update karna hai automatic it’s possible please create one video for this
Пікірлер: 232
Sir jabardast saral aur sidhi language me samjaya aapne, 10:30 minutes me 10 dinoka gyan diya apne
How would you deal with a situation where an item is sold with different rates each day or may be multiple times in a day even?
Mashallah Mashallah Allah Pak apko jazaay khar ata frmay or dunya o akhrat ke hr hr kamyabe khuse say navazy ap nay mare mushkil asan ke Allah pak ap or apke nasloon ke taa Qamat hr hr mushkil musebat prshane tang dste hadsat dukh say nejat ata frmay ameen
@shahabislam4912
2 жыл бұрын
Jazak Allah
Walykum asslam Aap ne bahut achcha bataya Very very thanks 😀😀😀😀
Assalamualaikum This video is really very helpful thank you so much. " God bless you Sir "
How to manage product 1 things when we sold the same thing with different customers with diffrent price ??
Thank you sir very easy how to data maintain in simple way 😍
Mashallah bhai, this is what I was looking for. Thanks alot
Thank you so much sir 🙏🙏🙏this is very helpful video
Sir apne bhut acha smjaya hai ......ap thoda slow smjaya kreye ..👍👍👍👍👍👍👍👍
Assalamualaikum superb duperb performance
100% true. And best trainer
MASHA LOVE your voice. Bismillah hir REHMAAN ❤️🌷 .....wow what a good start MASHA ALLAH.
Thank u...this very useful for me😊
Sir ap ki knowledge acch h pr ap tiping pr dhyan di dye
Ur videos.r very helpful thanks
Thank you for the polite request to put a project link in all your videos
Asw सर एक वीडियो बनाए please जिसमे एक बिल में लोट में स्टॉक आता है जिसमे उसके बिल का descurption जिसमे date,bill no,D.O No,etc है और उसके मैटेरियल का description जैसे item name,qty,size,हो बिल महीने में 10से ज्यादा आता है same item और अलग item भी,स्टॉक का total भी एक जगह रहे, सर इसका format बहुत लोगो से तैयार करवाया नही हुआ प्लीज you can see, its like challange 🙏
Thank you so much Shahab bhai 😊
Thank you so much sir help has helped me so much
If I purchase a same product with different rate what should I do?
@akhan8456
Жыл бұрын
I have asked the same question about an year ago but no reply
Mr. Shahab Islam, Thanks 2 U, we need your others videos for SKU and Inventories for Forecasting and Demand Planning
@muhammadamjadmuhammadamjad5677
3 жыл бұрын
Plz contact me
Sir, this exel sheet is all in one. This is 90% useful in our trading shop. How we add-on New stock entry with Dates ?
Thanks sir full information video sir 👌👌👌
@shahabislam4912
3 жыл бұрын
So nice of you
can you please make a new video with items being sold with different rates
Bahut acha hai sir thnk u so much god bless u ...
@tanukhan8367
4 жыл бұрын
Ya right
Bro when I clicked on this video your starting intro voice is same like when flight ready to takeoff announcement tone. 😂👍👍
Thank u sir this is very helpful for me...
Hello sir I want a detailed video on inventory management with same product of different sizes on excel
Thank you sir!!
@shahabislam4912
Жыл бұрын
Most welcome!
I like your teaching sir
YOU ARE GENOUS
Sir you use very easy method
Thank you so much sir Care on
@shahabislam4912
2 жыл бұрын
All the best
Thank you sir ❤❤
Sir please tell if products are sold at different rates then then how to calculate sale price of exact units ?
Assalamualaikum. Sir Amount ka grand total samjh nhi aaya please bta dijiye, bahut achcha video h Allha aapko or tarakki ata frmye.
@aamirsheikh5879
2 жыл бұрын
Tabassum apna fanka Kitna khula hua hen
Very good ! Thanks Buddy
@shahabislam4912
2 жыл бұрын
You're welcome!
Sir Is there any way to automatically copy the sheet 1 data to sheet 2.whenever I make change to sheet 1.. PLZ REPLY
Nice knowledge.
Thank you so much sir👍🏻
@shahabislam4912
Жыл бұрын
Most welcome
Official accounts k liye isko use karna best hoga
You are good sir
Isss mein rates different ho skty hain,like ksi customer ko discount Dia?? Aur other expenses add krny hu toh??
Thanx sir
informative
Assalamualaikum sir mashaAllah itni ability aap ma han kahan se itni Knowledge late han pls tell owesome....................
@mehakiqbal8412
4 жыл бұрын
Hahaha parhne se ati h ability
VERY USE FULL
Its a work which can be done by childrens, If u can, explain how to calculate profit and loss for same product with different purchase price and sell price according to stock
Aoa. How can we add IV, DV and CV for making mutual fund portfolio, kindly guide
Thank you sir
I want to make sheet for stock purches p/l it is ok
Please provide download link of this sheet
Day by day kaise maintain karu? E to one day ka hisab ha. Monthly report kaose karu?
thank you sir, yeh sold ka rate 20% fix nhi laga sakty sir, formula????
Assalamualaikum excellent
kindly share this file in description
Very nice sir
Sir aap kon se software se recording Kar rahay hain Or ye software free hai ya paid Wala hai
@sumit4691
4 жыл бұрын
camtesia
Sir plz create a video lecture about Powe BI excel training.
@shahabislam4912
2 жыл бұрын
As soon as possible
Sr it's too good clip but I'm confused in multiple rates amounts and also sold lets understand me with details
Thanks sir
Very nice
Agr ek he profuct ko manage karn ho different dates main sale ho to usko kesy manage karein gy
Thanks Brother for this video Can you please guide how to maintain the same thing productwise ratewise ie (FIFO) basis Unless I finish my first rate qty, 2nd rate should not consider. This will very helpful.
@dhanishmehta
2 жыл бұрын
Hello Brother I am still looking for the solution for the stock to be maintained for particular product with multiple purchase & Sales rate on FIFO basis Pls give me the solution........
@shahzilshafi8045
Жыл бұрын
@dhanishmehta brother did you find solution?
Very Nice
can u plz teach how to oparet exel in mobil formet
Walikum Assalam
💗
ASSALAM-O-ALAIKUM SIR AAP KI VIDEO BOHAT ACHI LAGI ISMAY SE KAFI KUCH TO MUJHAY PATA THA LEKIN AAP SE BHI BOHAT KUCH SEEKHNAY KO MILA .. SAWAL YE HAI K ISI SHEET KO AGAR HUM SOFTWARE TYPE MAIN CONVERTED KARNA CHAHAIN TO KESSAY KAR SAKTAY HAIN
@shahabislam4912
4 жыл бұрын
formatting or advance formula se hojega.excel series dekhen meri use idea mljega.
@nareshoraganti8356
4 жыл бұрын
Thank u sir, I want excel vellow cup vedio sir plz
@shahabislam4912
4 жыл бұрын
@@nareshoraganti8356 kzread.info/dash/bejne/pZh1l7eIfsuxaM4.html
Thanks
Excel 2016 sheet me 365*7 sell me Namaz ki Takveem me sirf time likha hua he aur un sabhi sell me ek shath 2 minutes plus keae kare
Bhai Aslamoalikum
How can we do this in excel mobile app ?
Sir aap ne expense ke beghair hi P&L bana dia
Waleku assalam
When we have stok off x-300 and we sale only x-200 then remaining amount and stock shown as per your sheet but after next day when we sale remaining 100 x it was not calculate please explain or add this
Formulas use karte time aap jaldi jaldi btane lgte ho WO nahi samajh mei aya
Bhi excel sheet bhi share karduna. Link pay
Thnq sir
if i buy product 1 muliple times at different prices and also sell them at different prices how to find profit at once?
Well done sir
Salam. Sir I hope you are fine. Sir yeh video aap ki konsi playlist main hain.
@shahabislam4912
4 жыл бұрын
Playlist me nhe he. kzread.info/dron/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos?disable_polymer=1
Hello sir I m from restaurant business I want to know how can I maintain my cutlery and crockery stock by item name
@shahabislam4912
4 жыл бұрын
kzread.info/dron/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos
@shahinbgd3046
4 жыл бұрын
jo bac giye dusra din sale kore ga tu sir kesa note add me dale ga
Great
Hi Can I make this in smart phone? If I can tell me how please
Good
Grt
Sir video to theek hai... Magar thoda fast batate ho ..isliye samajh me nahi aaraha.
Bhai ap khod confuse ho or ya video dakho to hum bhi confuse ho rhe hy. Agar galti ho gai to dobara sare complete video bna date take bat smjh mn aye or clear ho
EXCELLENT
@shahabislam4912
2 жыл бұрын
Many thanks!
How to add after purchase, please solution sir
assalamu alaikum sir do you know about financial modelling course please make education video on that it will be very useful in future in Sha Allah
Can you please tell... What if we want to add more products accounts then how will go down the total automatically... Please tell, tomorrow is my exam
Sir jaise 100 ki total se 25% or 70% kaise alag karen
How to maintain partial sale????
How to calculate sales for a pharma franchise company having 5 products... Total sale
Nxt tym jo item stock ma ayegi new price ka sath toh usko kasa manage kra anyone know about it?
Sir plz show how to do this in provision store day by day plz....
Mera ek excel sheet dusre sheet shift karna hai or jo source sheet hai usme ek row me 6000 ke value ka count uske saamne mujhe uska remark update karna hai automatic it’s possible please create one video for this
@shahabislam4912
Жыл бұрын
remarks kya update karna he each cell me 6000?