How to Maintain Inventory with Stock In or Stock Out in Excel

Поделиться
HTML-код
  • Опубликовано: 26 окт 2024

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

  • @gauravgupta23
    @gauravgupta23 2 года назад +18

    Dear Parvez, I have used your video and with multiple times pause and play, I have created my INVENTORY SHEET for REAL ACTUAL BUSINESS that I have started recently. With small Godown, and small inventory that i purchased, I was not knowing how to maintain MIS. But from your video I got the complete modified sheet for myself. I don't know if you will read this message or not, since your video is more than one year old, But if you read this, then do accept my HUGE THANKS for your such a wonderful guidance. I was using Vlookup and Pivot since 2013 and am using excel for complete MIS in my business, but this was amazing. Thanks once again.

  • @BannerGamimg
    @BannerGamimg 2 года назад +6

    Sir ji aapne dil khush kar diya☺️☺️
    Kaash aise hi teacher samjhate🥲

  • @SaurabhKSingh-xz5we
    @SaurabhKSingh-xz5we 9 месяцев назад

    very essential video hai sir, thankyou!

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

    Nice video sir bahut accha video laga aapka

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

    Vah..Sir aapka kam bahut badiya he. Jo excel me file dawanlod aapte he

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

      A great Inventory Management System in Excel
      Free download and ready to use
      ruclips.net/video/nFo_3wQViHw/видео.html

  • @NK-qu9vj
    @NK-qu9vj 4 года назад +1

    Excel may First video hai jo mujhe pasand aya

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

    Video is good but in my hand I just received material and make a column of receipt where material is add on when I issue material material will be minus from opening stock and balance is on closing stock..but in ur video I gain information

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

    Very nicely

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

    Thanks for helf full video.ish video ko aur ek bar kuchh naya hoga tu video upload kijiye.

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

    Aapke har video ko m dekhta hu or bahut kuchh sikhne ko milta h

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

    Boht achche se smjhaya hai bhai wo baat alg hai ki thoda sa smjh nhi aaya😅👍

  • @g.r.sunasara2319
    @g.r.sunasara2319 4 года назад

    Very good videos

  • @vaibhavdhamapurkar1915
    @vaibhavdhamapurkar1915 4 года назад +10

    Sir I'm working fmcg company so company dealing 200+ products but they want in stock maintain file with sales name(client name) I dont understand what I use format

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

      You can work in same format as above . This is only for stock. For Client wise report ,you have to maintain separate sheet. There you can keep the record of client only.

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

      Hi please phone number dena

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

    Nice 👍

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

    Very nice vdo.

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

    So many Many thanks sir

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

    Daud bhai ek video dispatcher ke liye Banai transport dispatched k liye

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

    very useful videos. Thanks sir

  • @Lalitkumar-rw7pe
    @Lalitkumar-rw7pe 5 лет назад +1

    Good one

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

    Hey sir can you make a video one gudoon and out formula also please if can

  • @s.j.graphicsdesignaccounti5340
    @s.j.graphicsdesignaccounti5340 5 лет назад

    bahut achchhi jaankari sir ji aapne di hai. sir ji sale order sheet banayiye 11 itme ka

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

    Amazing Video Sir
    Thank you

  • @ijazahmed-bz5xk
    @ijazahmed-bz5xk 5 лет назад

    Daood Bahi very nice

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

    Thank You bro

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

    can you make same video using user form and using multiple go downs

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

    Nice sir

  • @pritam3892
    @pritam3892 4 года назад +5

    Thank you for this amazing video boss. Very helpful any way of communicating for tips and tricks? whatsapp page seems to be full.

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

      9oo on ok oPollo oo lol o I'll be opolo o

  • @khtar_vlogs2356
    @khtar_vlogs2356 5 месяцев назад

    Very helpful this video, Great bhaiya ji ❤❤❤❤❤❤

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

    Thank you sir

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

    Sir, its very nice way to control the stock. can you please shave the link to download the excel sheet . thanks

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

      bro he already share in description

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

    Mst

  • @AbdurRahim-ot5gp
    @AbdurRahim-ot5gp 4 года назад +1

    Please make tutorial video for material inventory and hotel booking software

  • @NK-qu9vj
    @NK-qu9vj 4 года назад

    Super bro

  • @उम्मेसलमाबीड
    @उम्मेसलमाबीड 2 года назад +1

    What is the method to remove the taken table please tell me

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

    Great video and explanation Sumit

  • @machhindrabawaskar8728
    @machhindrabawaskar8728 25 дней назад

    Ram Ram Bhai

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

    Jabardarst

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

    Thanks sir

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

    Sir
    Mujhe is format me stock return ka bhi ek coloum chahiye jisme condition ye ho ki jb godown se Stock return aaye to wah godown Wale Stock se ghat jaye OR Main warehouse me jakar add ho jaye
    Please help me

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

    Yar perwez sb aap ka awaz mujhe buhut padand he awar sath me andsz b Masha Allah . yar parwez aap jab b koi program banate ho na to screen Zara bara Karo q k name b samajh to aaye na.

  • @RahulSharma-gu5be
    @RahulSharma-gu5be 2 года назад +1

    Thanks❤👍

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

    So amazing. Please show me how to create that template.

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

    sirji mast video
    1 like 1 view 1 download and subscirbe already
    u r great boss

  • @muhammadshahbaz-ru2bm
    @muhammadshahbaz-ru2bm 5 лет назад

    very nice

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

    Hi if stock transfer to godown to godowm than how to maintain..

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

    Thank you so much bhaijaan 🙏

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

    Awesome Sir

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

    Thnx

  • @parkashgaur4306
    @parkashgaur4306 3 года назад +5

    sir pls send the link for download the sheet

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

    Jo return Aya use purchase me dalo ya return wala sheet add karo

  • @MENXVIVEK
    @MENXVIVEK 5 месяцев назад

    Ok 👍

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

    Used items stock me ghtenge kya?

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

    Jewelry stone ki Excel m data entry kese kar te h plz btaye

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

    How to know which product we purchased or which product we sold, the name of the product

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

    Thanku sir

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

    Lekin Sir Isme ek problem to hogi na yadi koi product main location se shop 1 me bheje to main location minus nhi hoga aur shop 1 me plus nhi hoga to uske liye karna padega

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

    Sir purchase return aur damaged product ho toh uske liye kya kare??

    • @AlimKhan-bl5sh
      @AlimKhan-bl5sh Год назад

      Bhaii uka bhii ek column bana lo.. Simple.. Apko to sirf entry record dikhana h na

  • @GAURAVSHARMA-fp7qo
    @GAURAVSHARMA-fp7qo 5 лет назад +1

    Nice vedio sir,,,,
    Sir mai plywood company me kaam karta hu or doors ke size bohot zayada hote hai please koi aisa excel sheet btao ki usme door production or doors sale or balance stock pta chal sake,,,meri sheet bohot long ho chuki hai please help

  • @sandeepsinghchauhan9397
    @sandeepsinghchauhan9397 2 месяца назад

    How to use data consolidation in this file

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

    Nice!

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

    Sir koyla khadan me kaam use kar sakte hai kya

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

    Sir please starting lavel se bateye please jaise sheet pahle kaise ready karna hai then phir ustkai bad kaise work karna hai

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

    अभी तक आपका रिप्लाई नही आया सर

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

    Yah formula only one location keliye kaisse use kare

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

    Parvej bhai computer sikha rhe ho abhi ya ni

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

    Sir I need one formet for telecom company please help me

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

    How to create this software in excel..

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

    Mere pass multiple inward aur outward criteria hai wo kaise add on kren

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

    Bahut tipikal kardiya aapne parvez bhai video ko

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

    Kitne items bache hue hn or kitne use kr liye inka pta kase chalega....

  • @Adnankhan-ez6xo
    @Adnankhan-ez6xo Год назад

    Hi Sir Mujhe ek Inventory Sheet Create kerni h
    so plz sir help us

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

    Can i use mobile also ?????

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

    Hello sir can u plz give me like this one sheet for my cold store.....

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

    Lekin is sheet me hum date wise closing nhi dekh saktey k Kal Tak Kya closing thi hamarey stock ki

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

    Sir another WhatsApp group link plz share..

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

    Sir ise mobile par kar sakte he kya

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

    Store keeper ka interview Hindi m hota hai ya English me

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

    waah

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

    Ab isme aage godawan kaise add kare sir

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

    Thanks

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

    Sir beer bar ka opening or closing kya hai

  • @F35-i1q
    @F35-i1q 3 года назад +1

    Price aur code me kiya likha hai sir aapne ye bataya nahi

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

    Mobile me bhi ban sakta hai

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

    Sir isme price aur cost ki calculation kaise hogi

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

    Namaste sar Mujhe pump sambandhit software banvana hai

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

    Kcc loan ka aplay kab se hoga

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

    Sir consumption report kaise banate h

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

    Sir todha saf rahta to aur achaa hota ,.......just look clean please sir

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

    Full WhatsApp group

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

    Sir mere yaha pr teen shift me gadi nikalti h or 15 20 gadi unme daily ke liye diesel ka record rakhna h kitna hamare yaha pr total diesel a rha h or daily vahano me kitne ltr diesel dalta h or kitna remaining m rhe gya h or monthly ke hisab se bhi check kr sake please sir iske uper ek video upload kr do or sample bhi taiyar kr do sir please aaj ya kal tak kr do

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

    How to make daily weekly and monthly expenses sheet in excel

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

    Bhai apna sttching job Garment he kiya aap ka formula hamare kaam aa
    sakta he ....? Jese -
    SEWING material perches
    SEWING lagt material
    1)cutting maal 2) sttching ko diya maal
    3) fir redi job
    4) sttching job pement
    5) seling ko kitna maal dispatch huwa
    7) Seling pement
    8) Ritorn aya huwa maal
    Total amount
    Lagata or profit
    6)
    Kiya ise me Daunlod karke apne yous me laga sakta hu pliz Ripley mi Sir

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

    Hi
    Pls vidio on searchable drop down list

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

      Thanks for watching
      Next video is for searchable drop down list

  • @ASHISHKUMAR-pn2sn
    @ASHISHKUMAR-pn2sn 5 лет назад +1

    Sir please share another what'sup group

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

    sir stock inventory inflow outflow jaisa hai

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

    Sir kapda stock kya hota ha

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

    यदि इसमें मेन लोकेशन से कोई प्रोडक्ट दूसरे शॉप में गया तो मेन लोकेशन में माइनस कैसे होगा और और जिसमे हमने भेजा है उसमे इन कैसे होगा

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

    Humko low stock ka chaia

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

    क्या excel की file डोवनलोड लिंक मिलेगी ?

  • @sg.5032
    @sg.5032 5 лет назад +1

    Sir yes sheet kaise bnai uska vdo bhi hai kya aapke pass??

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

      Download kar lo link diya hua hai