#283

How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi. Calculation Ms Excel 2019.
#Stocksheet #salepurchase #Profitsheet

Пікірлер: 232

  • @rjenterprisefireoileandgas7409
    @rjenterprisefireoileandgas74093 жыл бұрын

    Sir jabardast saral aur sidhi language me samjaya aapne, 10:30 minutes me 10 dinoka gyan diya apne

  • @akhan8456
    @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?

  • @akshine23
    @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

    @shahabislam4912

    2 жыл бұрын

    Jazak Allah

  • @ShamimKhan-li7yc
    @ShamimKhan-li7yc3 жыл бұрын

    Walykum asslam Aap ne bahut achcha bataya Very very thanks 😀😀😀😀

  • @nadirazizaziz8172
    @nadirazizaziz81723 жыл бұрын

    Assalamualaikum This video is really very helpful thank you so much. " God bless you Sir "

  • @MrVingo3
    @MrVingo33 жыл бұрын

    How to manage product 1 things when we sold the same thing with different customers with diffrent price ??

  • @AjmalKhan-zx8le
    @AjmalKhan-zx8le3 жыл бұрын

    Thank you sir very easy how to data maintain in simple way 😍

  • @sabirmirza6606
    @sabirmirza66062 жыл бұрын

    Mashallah bhai, this is what I was looking for. Thanks alot

  • @durgasuthar1536
    @durgasuthar15363 жыл бұрын

    Thank you so much sir 🙏🙏🙏this is very helpful video

  • @priyankasharma9047
    @priyankasharma90473 жыл бұрын

    Sir apne bhut acha smjaya hai ......ap thoda slow smjaya kreye ..👍👍👍👍👍👍👍👍

  • @muhammadshakeel3471
    @muhammadshakeel34714 жыл бұрын

    Assalamualaikum superb duperb performance

  • @maruficomputereducation292
    @maruficomputereducation2923 жыл бұрын

    100% true. And best trainer

  • @shariqkhan4505
    @shariqkhan45053 жыл бұрын

    MASHA LOVE your voice. Bismillah hir REHMAAN ❤️🌷 .....wow what a good start MASHA ALLAH.

  • @moethawtartin9485
    @moethawtartin94853 жыл бұрын

    Thank u...this very useful for me😊

  • @ashishagarwal818
    @ashishagarwal818Ай бұрын

    Sir ap ki knowledge acch h pr ap tiping pr dhyan di dye

  • @mahnoornoor6871
    @mahnoornoor68712 жыл бұрын

    Ur videos.r very helpful thanks

  • @paighamofficial-0
    @paighamofficial-02 жыл бұрын

    Thank you for the polite request to put a project link in all your videos

  • @tausifahmed3768
    @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 🙏

  • @siddheshkorlekar7458
    @siddheshkorlekar74584 жыл бұрын

    Thank you so much Shahab bhai 😊

  • @Ariijiina
    @Ariijiina3 жыл бұрын

    Thank you so much sir help has helped me so much

  • @shntpandey11
    @shntpandey112 жыл бұрын

    If I purchase a same product with different rate what should I do?

  • @akhan8456

    @akhan8456

    Жыл бұрын

    I have asked the same question about an year ago but no reply

  • @UsmanGhani-vf3ow
    @UsmanGhani-vf3ow4 жыл бұрын

    Mr. Shahab Islam, Thanks 2 U, we need your others videos for SKU and Inventories for Forecasting and Demand Planning

  • @muhammadamjadmuhammadamjad5677

    @muhammadamjadmuhammadamjad5677

    3 жыл бұрын

    Plz contact me

  • @mohankhatumria9310
    @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 ?

  • @mrpremprajapati2090
    @mrpremprajapati20903 жыл бұрын

    Thanks sir full information video sir 👌👌👌

  • @shahabislam4912

    @shahabislam4912

    3 жыл бұрын

    So nice of you

  • @subechhabajracharya7814
    @subechhabajracharya78149 ай бұрын

    can you please make a new video with items being sold with different rates

  • @ibrahimgangawali5752
    @ibrahimgangawali57524 жыл бұрын

    Bahut acha hai sir thnk u so much god bless u ...

  • @tanukhan8367

    @tanukhan8367

    4 жыл бұрын

    Ya right

  • @mdSalman-lx8nm
    @mdSalman-lx8nm3 жыл бұрын

    Bro when I clicked on this video your starting intro voice is same like when flight ready to takeoff announcement tone. 😂👍👍

  • @hafizibrahimshah6842
    @hafizibrahimshah6842 Жыл бұрын

    Thank u sir this is very helpful for me...

  • @yashish11
    @yashish112 жыл бұрын

    Hello sir I want a detailed video on inventory management with same product of different sizes on excel

  • @rheapeter9709
    @rheapeter9709 Жыл бұрын

    Thank you sir!!

  • @shahabislam4912

    @shahabislam4912

    Жыл бұрын

    Most welcome!

  • @rinchennegi3117
    @rinchennegi31174 жыл бұрын

    I like your teaching sir

  • @Cocktails418
    @Cocktails4182 жыл бұрын

    YOU ARE GENOUS

  • @ilyasorakzai5817
    @ilyasorakzai58172 жыл бұрын

    Sir you use very easy method

  • @ilyasorakzai5817
    @ilyasorakzai58172 жыл бұрын

    Thank you so much sir Care on

  • @shahabislam4912

    @shahabislam4912

    2 жыл бұрын

    All the best

  • @queen7438
    @queen74383 жыл бұрын

    Thank you sir ❤❤

  • @khalidshahzad1547
    @khalidshahzad15474 жыл бұрын

    Sir please tell if products are sold at different rates then then how to calculate sale price of exact units ?

  • @tabassumhasankhan9539
    @tabassumhasankhan95393 жыл бұрын

    Assalamualaikum. Sir Amount ka grand total samjh nhi aaya please bta dijiye, bahut achcha video h Allha aapko or tarakki ata frmye.

  • @aamirsheikh5879

    @aamirsheikh5879

    2 жыл бұрын

    Tabassum apna fanka Kitna khula hua hen

  • @whitemoonstudio
    @whitemoonstudio2 жыл бұрын

    Very good ! Thanks Buddy

  • @shahabislam4912

    @shahabislam4912

    2 жыл бұрын

    You're welcome!

  • @nepalinaanu6415
    @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.Fabric
    @AlEmaan.Fabric2 жыл бұрын

    Nice knowledge.

  • @darkff6610
    @darkff6610 Жыл бұрын

    Thank you so much sir👍🏻

  • @shahabislam4912

    @shahabislam4912

    Жыл бұрын

    Most welcome

  • @neerusharma8011
    @neerusharma80114 жыл бұрын

    Official accounts k liye isko use karna best hoga

  • @RScomputerinformation
    @RScomputerinformation4 жыл бұрын

    You are good sir

  • @opboy9544
    @opboy95443 жыл бұрын

    Isss mein rates different ho skty hain,like ksi customer ko discount Dia?? Aur other expenses add krny hu toh??

  • @tanukhan8367
    @tanukhan83674 жыл бұрын

    Thanx sir

  • @mrmasterofms6468
    @mrmasterofms6468 Жыл бұрын

    informative

  • @shaheenashakeel124
    @shaheenashakeel1245 жыл бұрын

    Assalamualaikum sir mashaAllah itni ability aap ma han kahan se itni Knowledge late han pls tell owesome....................

  • @mehakiqbal8412

    @mehakiqbal8412

    4 жыл бұрын

    Hahaha parhne se ati h ability

  • @ramkrsoni
    @ramkrsoni3 жыл бұрын

    VERY USE FULL

  • @tarikulislamtanvir5904
    @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.ladywarden8958
    @rabiamumtazasst.ladywarden89584 жыл бұрын

    Aoa. How can we add IV, DV and CV for making mutual fund portfolio, kindly guide

  • @thilagavathi5702
    @thilagavathi57023 жыл бұрын

    Thank you sir

  • @matiullahsahil1139
    @matiullahsahil11394 жыл бұрын

    I want to make sheet for stock purches p/l it is ok

  • @listenhaq6455
    @listenhaq64552 жыл бұрын

    Please provide download link of this sheet

  • @tapasari5615
    @tapasari56154 жыл бұрын

    Day by day kaise maintain karu? E to one day ka hisab ha. Monthly report kaose karu?

  • @mitochondria2829
    @mitochondria28297 ай бұрын

    thank you sir, yeh sold ka rate 20% fix nhi laga sakty sir, formula????

  • @muhammadshakeel3471
    @muhammadshakeel34714 жыл бұрын

    Assalamualaikum excellent

  • @numanahmad3480
    @numanahmad34803 жыл бұрын

    kindly share this file in description

  • @srinivasp3654
    @srinivasp36544 жыл бұрын

    Very nice sir

  • @playshortss
    @playshortss5 жыл бұрын

    Sir aap kon se software se recording Kar rahay hain Or ye software free hai ya paid Wala hai

  • @sumit4691

    @sumit4691

    4 жыл бұрын

    camtesia

  • @awaiskhan8135
    @awaiskhan81352 жыл бұрын

    Sir plz create a video lecture about Powe BI excel training.

  • @shahabislam4912

    @shahabislam4912

    2 жыл бұрын

    As soon as possible

  • @janalam2507
    @janalam25072 жыл бұрын

    Sr it's too good clip but I'm confused in multiple rates amounts and also sold lets understand me with details

  • @amitkainth8464
    @amitkainth84648 ай бұрын

    Thanks sir

  • @upendragautamips401
    @upendragautamips4013 жыл бұрын

    Very nice

  • @umarhassan119
    @umarhassan119 Жыл бұрын

    Agr ek he profuct ko manage karn ho different dates main sale ho to usko kesy manage karein gy

  • @dhanishmehta
    @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

    @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

    @shahzilshafi8045

    Жыл бұрын

    ​@dhanishmehta brother did you find solution?

  • @shafiqsalam4883
    @shafiqsalam48835 жыл бұрын

    Very Nice

  • @sudeepkn1632
    @sudeepkn16323 жыл бұрын

    can u plz teach how to oparet exel in mobil formet

  • @freshtimehandwash1663
    @freshtimehandwash16632 жыл бұрын

    Walikum Assalam

  • @plok_idea
    @plok_idea4 жыл бұрын

    💗

  • @abdulmajidkhan2136
    @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

    @shahabislam4912

    4 жыл бұрын

    formatting or advance formula se hojega.excel series dekhen meri use idea mljega.

  • @nareshoraganti8356

    @nareshoraganti8356

    4 жыл бұрын

    Thank u sir, I want excel vellow cup vedio sir plz

  • @shahabislam4912

    @shahabislam4912

    4 жыл бұрын

    @@nareshoraganti8356 kzread.info/dash/bejne/pZh1l7eIfsuxaM4.html

  • @ranjanpahan779
    @ranjanpahan7793 жыл бұрын

    Thanks

  • @Hadees92
    @Hadees92 Жыл бұрын

    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-hd7lv
    @MuhammadUsman-hd7lv9 ай бұрын

    Bhai Aslamoalikum

  • @trojangamimg8483
    @trojangamimg84834 жыл бұрын

    How can we do this in excel mobile app ?

  • @mansoorrana7145
    @mansoorrana71454 жыл бұрын

    Sir aap ne expense ke beghair hi P&L bana dia

  • @iqbalkhan8792
    @iqbalkhan87924 жыл бұрын

    Waleku assalam

  • @rohitkadam1859
    @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

  • @rlskhankhan6784
    @rlskhankhan67844 жыл бұрын

    Formulas use karte time aap jaldi jaldi btane lgte ho WO nahi samajh mei aya

  • @saqibbasarikatti2303
    @saqibbasarikatti23032 жыл бұрын

    Bhi excel sheet bhi share karduna. Link pay

  • @rlskhankhan6784
    @rlskhankhan67844 жыл бұрын

    Thnq sir

  • @AAA-mq9jj
    @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?

  • @ilyasorakzai5817
    @ilyasorakzai58172 жыл бұрын

    Well done sir

  • @anasahmed6055
    @anasahmed60554 жыл бұрын

    Salam. Sir I hope you are fine. Sir yeh video aap ki konsi playlist main hain.

  • @shahabislam4912

    @shahabislam4912

    4 жыл бұрын

    Playlist me nhe he. kzread.info/dron/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos?disable_polymer=1

  • @mukeshbaroli5687
    @mukeshbaroli56874 жыл бұрын

    Hello sir I m from restaurant business I want to know how can I maintain my cutlery and crockery stock by item name

  • @shahabislam4912

    @shahabislam4912

    4 жыл бұрын

    kzread.info/dron/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos

  • @shahinbgd3046

    @shahinbgd3046

    4 жыл бұрын

    jo bac giye dusra din sale kore ga tu sir kesa note add me dale ga

  • @Muhammadarif2917.
    @Muhammadarif2917.2 жыл бұрын

    Great

  • @OmniaSerag
    @OmniaSerag3 жыл бұрын

    Hi Can I make this in smart phone? If I can tell me how please

  • @azeemmakeen1389
    @azeemmakeen13894 жыл бұрын

    Good

  • @NawazViewers
    @NawazViewers4 жыл бұрын

    Grt

  • @KaleemKhan-gk1tm
    @KaleemKhan-gk1tm4 жыл бұрын

    Sir video to theek hai... Magar thoda fast batate ho ..isliye samajh me nahi aaraha.

  • @dbalouch5716
    @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

  • @leosibbi1818
    @leosibbi18182 жыл бұрын

    EXCELLENT

  • @shahabislam4912

    @shahabislam4912

    2 жыл бұрын

    Many thanks!

  • @krishnabhaktabisidhyoshres3613
    @krishnabhaktabisidhyoshres36134 жыл бұрын

    How to add after purchase, please solution sir

  • @mohammedhidayathulla
    @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

  • @Amanabbasghouri
    @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

  • @tulsidasgoun4244
    @tulsidasgoun42444 жыл бұрын

    Sir jaise 100 ki total se 25% or 70% kaise alag karen

  • @muhammedali4393
    @muhammedali43934 жыл бұрын

    How to maintain partial sale????

  • @ImranKhan-kx1oi
    @ImranKhan-kx1oi3 жыл бұрын

    How to calculate sales for a pharma franchise company having 5 products... Total sale

  • @TheHiddenStories675
    @TheHiddenStories675 Жыл бұрын

    Nxt tym jo item stock ma ayegi new price ka sath toh usko kasa manage kra anyone know about it?

  • @shrimegha861
    @shrimegha8613 жыл бұрын

    Sir plz show how to do this in provision store day by day plz....

  • @Davisha1522
    @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

  • @shahabislam4912

    @shahabislam4912

    Жыл бұрын

    remarks kya update karna he each cell me 6000?

Келесі