#283

Поделиться
HTML-код
  • Опубликовано: 28 апр 2019
  • How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi. Calculation Ms Excel 2019.
    #Stocksheet #salepurchase #Profitsheet

Комментарии • 232

  • @ShamimKhan-li7yc
    @ShamimKhan-li7yc 3 года назад +2

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

  • @rjenterprisefireoileandgas7409
    @rjenterprisefireoileandgas7409 3 года назад +2

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

  • @akshine23
    @akshine23 2 года назад +1

    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

  • @priyankasharma9047
    @priyankasharma9047 3 года назад +1

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

  • @sabirmirza6606
    @sabirmirza6606 2 года назад +1

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

  • @shariqkhan4505
    @shariqkhan4505 3 года назад

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

  • @muhammadshakeel3471
    @muhammadshakeel3471 4 года назад +3

    Assalamualaikum superb duperb performance

  • @durgasuthar1536
    @durgasuthar1536 3 года назад +3

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

  • @nadirazizaziz8172
    @nadirazizaziz8172 3 года назад +3

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

  • @AjmalKhan-zx8le
    @AjmalKhan-zx8le 3 года назад +4

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

  • @mrpremprajapati2090
    @mrpremprajapati2090 3 года назад +1

    Thanks sir full information video sir 👌👌👌

  • @ibrahimgangawali5752
    @ibrahimgangawali5752 4 года назад +2

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

  • @maruficomputereducation292
    @maruficomputereducation292 3 года назад +1

    100% true. And best trainer

  • @Cocktails418
    @Cocktails418 2 года назад

    YOU ARE GENOUS

  • @Ariijiina
    @Ariijiina 3 года назад +1

    Thank you so much sir help has helped me so much

  • @rheapeter9709
    @rheapeter9709 Год назад +1

    Thank you sir!!

  • @ilyasorakzai5817
    @ilyasorakzai5817 2 года назад

    Thank you so much sir
    Care on

  • @hafizibrahimshah6842
    @hafizibrahimshah6842 Год назад

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

  • @SzKhan-ef4to
    @SzKhan-ef4to Год назад +1

    BAHUT ACHCHA MASHA ALLAH

  • @freshtimehandwash1663
    @freshtimehandwash1663 2 года назад

    Walikum Assalam

  • @mahnoornoor6871
    @mahnoornoor6871 2 года назад

    Ur videos.r very helpful thanks

  • @ramkrsoni
    @ramkrsoni 3 года назад +1

    VERY USE FULL

  • @mrmasterofms6468
    @mrmasterofms6468 Год назад +1

    informative

  • @AlEmaan.Fabric
    @AlEmaan.Fabric 2 года назад +1

    Nice knowledge.

  • @ilyasorakzai5817
    @ilyasorakzai5817 2 года назад

    Sir you use very easy method

  • @moethawtartin9485
    @moethawtartin9485 3 года назад +1

    Thank u...this very useful for me😊

  • @ashishagarwal818
    @ashishagarwal818 Месяц назад +1

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

  • @tanukhan8367
    @tanukhan8367 4 года назад +2

    Thanx sir

  • @siddheshkorlekar7458
    @siddheshkorlekar7458 4 года назад +1

    Thank you so much Shahab bhai 😊

  • @darkff6610
    @darkff6610 Год назад

    Thank you so much sir👍🏻

  • @rinchennegi3117
    @rinchennegi3117 4 года назад +2

    I like your teaching sir

  • @tausifahmed3768
    @tausifahmed3768 Год назад +1

    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 🙏

  • @akhan8456
    @akhan8456 2 года назад +9

    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?

  • @upendragautamips401
    @upendragautamips401 3 года назад +1

    Very nice

  • @whitemoonstudio
    @whitemoonstudio 3 года назад

    Very good ! Thanks Buddy

  • @iqbalkhan8792
    @iqbalkhan8792 4 года назад +1

    Waleku assalam

  • @NawazViewers
    @NawazViewers 4 года назад +2

    Grt

  • @mdSalman-lx8nm
    @mdSalman-lx8nm 3 года назад +1

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

  • @UsmanGhani-vf3ow
    @UsmanGhani-vf3ow 4 года назад +3

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

  • @paighamofficial-0
    @paighamofficial-0 2 года назад +2

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

  • @tabassumhasankhan9539
    @tabassumhasankhan9539 3 года назад +3

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

  • @queen7438
    @queen7438 3 года назад +1

    Thank you sir ❤❤

  • @Muhammadarif2917.
    @Muhammadarif2917. 2 года назад

    Great

  • @amitkainth8464
    @amitkainth8464 9 месяцев назад

    Thanks sir

  • @srinivasp3654
    @srinivasp3654 4 года назад +1

    Very nice sir

  • @RScomputerinformation
    @RScomputerinformation 4 года назад +1

    You are good sir

  • @leosibbi1818
    @leosibbi1818 2 года назад

    EXCELLENT

  • @thilagavathi5702
    @thilagavathi5702 4 года назад +1

    Thank you sir

  • @MrVingo3
    @MrVingo3 3 года назад +7

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

  • @subechhabajracharya7814
    @subechhabajracharya7814 9 месяцев назад +1

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

  • @shaheenashakeel124
    @shaheenashakeel124 5 лет назад +3

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

  • @ilyasorakzai5817
    @ilyasorakzai5817 2 года назад

    Well done sir

  • @muhammadshakeel4482
    @muhammadshakeel4482 3 года назад

    Good

  • @shafiqsalam4883
    @shafiqsalam4883 5 лет назад +1

    Very Nice

  • @shntpandey11
    @shntpandey11 2 года назад +2

    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

  • @neerusharma8011
    @neerusharma8011 4 года назад +1

    Official accounts k liye isko use karna best hoga

  • @mohankhatumria9310
    @mohankhatumria9310 5 лет назад +10

    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 ?

  • @muhammadshakeel3471
    @muhammadshakeel3471 4 года назад +4

    Assalamualaikum excellent

  • @tarikulislamtanvir5904
    @tarikulislamtanvir5904 2 года назад

    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

  • @MuhammadUsman-hd7lv
    @MuhammadUsman-hd7lv 10 месяцев назад

    Bhai Aslamoalikum

  • @ranjanpahan779
    @ranjanpahan779 3 года назад +1

    Thanks

  • @plok_idea
    @plok_idea 4 года назад +1

    💗

  • @mitochondria2829
    @mitochondria2829 8 месяцев назад

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

  • @Noumanjavedshamsi
    @Noumanjavedshamsi 2 года назад

    Nice

  • @awaiskhan8135
    @awaiskhan8135 2 года назад

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

  • @abdulmajidkhan2136
    @abdulmajidkhan2136 4 года назад +2

    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 ruclips.net/video/sdA5UONhK8k/видео.html

  • @rlskhankhan6784
    @rlskhankhan6784 4 года назад

    Thnq sir

  • @saqibbasarikatti2303
    @saqibbasarikatti2303 2 года назад +1

    Bhi excel sheet bhi share karduna. Link pay

  • @yashish11
    @yashish11 3 года назад +2

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

  • @umarhassan119
    @umarhassan119 Год назад

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

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

  • @opboy9544
    @opboy9544 3 года назад

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

  • @listenhaq6455
    @listenhaq6455 2 года назад +1

    Please provide download link of this sheet

  • @mansoorrana7145
    @mansoorrana7145 4 года назад +2

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

  • @rlskhankhan6784
    @rlskhankhan6784 4 года назад +2

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

  • @KaleemKhan-gk1tm
    @KaleemKhan-gk1tm 4 года назад +1

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

  • @tapasari5615
    @tapasari5615 4 года назад +3

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

  • @user-xp7yl4bt2j
    @user-xp7yl4bt2j Год назад

    0:14 0:14 0:14

  • @numanahmad3480
    @numanahmad3480 3 года назад +2

    kindly share this file in description

  • @khalidshahzad1547
    @khalidshahzad1547 4 года назад +2

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

  • @UAE_Life323
    @UAE_Life323 2 года назад

    bhai ap ki speed to bht taiz ha,thora slow vido banaya krin

  • @janalam2507
    @janalam2507 2 года назад

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

  • @nepalinaanu6415
    @nepalinaanu6415 4 года назад

    Sir Is there any way to automatically copy the sheet 1 data to sheet 2.whenever I make change to sheet 1.. PLZ REPLY

  • @dbalouch5716
    @dbalouch5716 Год назад +2

    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

  • @matiullahsahil1139
    @matiullahsahil1139 4 года назад +2

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

  • @TheHiddenStories675
    @TheHiddenStories675 Год назад

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

  • @shrimegha861
    @shrimegha861 3 года назад

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

  • @soorajsooraj8206
    @soorajsooraj8206 3 года назад

    Sir video me profit huaa yaa loss

  • @rabiamumtazasst.ladywarden8958
    @rabiamumtazasst.ladywarden8958 4 года назад +1

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

  • @kundanjha8415
    @kundanjha8415 3 года назад

    Dawai ka sheet kese banayege

  • @playshortss
    @playshortss 5 лет назад

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

  • @sudeepkn1632
    @sudeepkn1632 4 года назад

    can u plz teach how to oparet exel in mobil formet

  • @MuhammadUsman-hd7lv
    @MuhammadUsman-hd7lv 10 месяцев назад

    Bhai where house kay pura program kesy bany gay. In and out. Sale purchase. Balance stock sheet. Day by day sale sheet. Weekly and monthly profit and loss sheet

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

  • @dhanishmehta
    @dhanishmehta 3 года назад +3

    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?

  • @anasahmed6055
    @anasahmed6055 4 года назад +1

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

    • @shahabislam4912
      @shahabislam4912  4 года назад

      Playlist me nhe he.
      ruclips.net/channel/UCcOsbNCxgUZMPoHEI1w-1RAvideos?disable_polymer=1

  • @tausifenglishcottage
    @tausifenglishcottage 3 года назад +1

    Sir thora dhire

  • @AAA-mq9jj
    @AAA-mq9jj 2 года назад

    if i buy product 1 muliple times at different prices and also sell them at different prices how to find profit at once?

  • @maliksmartgadgets5576
    @maliksmartgadgets5576 2 года назад

    Wiith formula excle sheet link upload kijiye🙏

  • @ariezazad207
    @ariezazad207 Месяц назад

    As salam mu alykum sir mera sawal he ager mere pass kisi anount k 2 item he ak ko maine 300 me beja 2sre ko bargaining hui 250 me beja ye qty or oss k amount me kaise adjust karu

    • @shahabislam4912
      @shahabislam4912  Месяц назад

      AP Do Column Bnae Ek Price Ka jitne ME Sale Karen Or Dosra Discount Price ME jo Sale Karen usme Add Karen.