Automated Invoice and Stock [ Inventory ] Management in Excel - Inventory Management in Excel

Automated invoice and stock [ inventory ] management in excel - Inventory Management in excel ( Hindi ) - Stock Register
In this video you will learn how to create Invoice and Inventory Management in excel. You can easily create Invoice Generator with stock and inventory management in Excel with auto save invoice in PDF File - If you need to create sales invoice and maintain stock [ inventory ] in excel then this Fully Automatic Inventory Management System with Fully Automatic GST Invoice will help you to manage sale, purchase and inventory of stock. You can use this format as Stock Register and Inventory Management Software in excel to maintain your automatic sale purchase stock report.
Download Training File : deepakeduworld.com/invoice-an...
MS Word Home to View Complete Tutorial : • Microsoft Word A to Z ... ​​​​
MS Power Point Home to View Complete Tutorial : • MS Power Point Tutoria... ​​​​
My New Channel : bit.ly/3qFrbl5​​​​
Xlookup Complete Tutorial : • What Xlookup Can Do Fo... ​​​​
Vlookup Complete Tutorial : bit.ly/2K0C1Sb​​​​
#StockRegister​
#StockManagement​
#InventoryManagement​
#InvoiceInExcel
#InvoiceAndInvenory
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
​​​​
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld​
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakedu​​world
Thanks for watching #deepakeduworld​

Пікірлер: 1 000

  • @mihlar1963
    @mihlar19632 жыл бұрын

    This is indeed an amazing video, I was really looking for this invoice plus inventory management, though I am not fully familiar with the Hindi language but I managed to understand it. Superb work. Mihlar from Sri Lanka

  • @mohammadsaigar229
    @mohammadsaigar2293 жыл бұрын

    Thank You! Was going to buy an expensive software for this But now with this i've saved alot...:D

  • @greenday1guitarfreak
    @greenday1guitarfreak2 жыл бұрын

    You've helped me so much! Another tutorial of yours that I watched before worked like a charm! Now I have complete confidence this one's going to be of massive help too. Thanks!!

  • @inamsadaf9481

    @inamsadaf9481

    Жыл бұрын

    sir, send me link this form

  • @muzmil124

    @muzmil124

    Жыл бұрын

    Deepak

  • @muzmil124

    @muzmil124

    Жыл бұрын

    Resource

  • @DeepakEduWorld
    @DeepakEduWorld3 жыл бұрын

    Download Template deepakeduworld.com/invoice-and-inventory/

  • @zacky2728

    @zacky2728

    2 жыл бұрын

    Excel provide kr do bhai plz.. HSN me kya kiya h wo smjh nhi aa rha

  • @fahadrazakhan5409

    @fahadrazakhan5409

    9 күн бұрын

    Hh

  • @tejasgohil9387
    @tejasgohil93873 жыл бұрын

    Excellent and easy explanation. Thank you

  • @b-alert9335
    @b-alert93353 жыл бұрын

    Just wow don’t have anything to say searching this video from 3 years and finally I found it from your Chanel

  • @muraly3523

    @muraly3523

    2 жыл бұрын

    @Ganesh Kumar I have posted a video. Will be useful kzread.info/dash/bejne/m4eAk5uAmarFg7g.html

  • @pravindrakumarpatle3300
    @pravindrakumarpatle33002 жыл бұрын

    Excellent Sir, Bahut kuch sikhne ko mila, Thank You.

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

    Hi Sir You've helped me so much! Now I have complete confidence this one's going to be of massive help too. Thanks !!

  • @pramodkumarbiswal7189
    @pramodkumarbiswal71893 жыл бұрын

    Sir there is a problem when purchase price and selling price increases of the same product..please add some formulas to updates the latest price according to date.

  • @ayazksoomro
    @ayazksoomro2 жыл бұрын

    Great Job, But you should make inventory management in excel with reports, like monthly report and annual report

  • @Mumer-dg7it

    @Mumer-dg7it

    2 жыл бұрын

    Help bhai plz help Bhai VBA ka code kaha se milhe ga Invoice template Invoice ko pdf me save karen kia liye

  • @Rajan-kk8nl
    @Rajan-kk8nl2 жыл бұрын

    Your every classes are inspiration to me, very very useful, thank you so much sir.

  • @avinashcarneiro4452
    @avinashcarneiro44523 жыл бұрын

    Amazing Video, very good detail easy explanations with good examples. keep it up and keep going !!

  • @pasandmeri
    @pasandmeri2 жыл бұрын

    You software template is excellent. I have started using it in my shop. I need the following amendments: 1. GST column should be in a same row as in subtotal. In the left most row there should be SubTotal, then GST and then Net Total (SubTotal+GST). 2. The Column width should adjusted to reduce the width of Invoice No, GST column will come in the row of SubTotal, this width must be used to increase the width of Item.

  • @muraly3523

    @muraly3523

    2 жыл бұрын

    I have created a video today.Perhaps this video will help you kzread.info/dash/bejne/m4eAk5uAmarFg7g.html

  • @nextechpro6749
    @nextechpro67493 жыл бұрын

    I'm Big fan of your works bro majja agaya

  • @prabhakarpawar573
    @prabhakarpawar5733 жыл бұрын

    Sirji, bahot bahot Shukriya. Aapane Hamare liye invoice with inventory banaya.

  • @ganeshgain5521
    @ganeshgain55213 жыл бұрын

    Bhaiya app ka video se mujhe bohot help hoti ha, thank u.

  • @piyushparmar9922
    @piyushparmar99223 жыл бұрын

    SUPERB....SIR....BUT HOW TO ADD PURCHASE STOCK??? IS IT MANUAL?

  • @ashikchapagain1351
    @ashikchapagain13513 жыл бұрын

    Dear Sir , I Kindly request you to share this Sheet. I took a lot of time today but could not complete it well. Thank You

  • @user-pb2fy4ij7d
    @user-pb2fy4ij7d10 ай бұрын

    Your template is best one I have seen soo far! I rarely comment on anything, but you video has convinced me to right you a comment for helping me and many like me. Thanks a lot.

  • @harshkhatke9235
    @harshkhatke92352 жыл бұрын

    Thank you sir apke video dekh ke mene he banaya or aj ye muze apne dukan me bahut kam ara hai ❤️ thank you sir again

  • @prabhakarpawar573
    @prabhakarpawar5733 жыл бұрын

    Sir, make some changes in this invoice. We have created a data validation list of hsn code. Make that list searchable dropdown list plz.

  • @klisssb1
    @klisssb13 жыл бұрын

    How can we manage monthly account statement record of individual customers

  • @richardmonteiro22
    @richardmonteiro222 жыл бұрын

    Great Job... Very Innovative well explained... all the information's were very clear... Thanks a lot... God Bless...

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

    Bohat shukria bhai Deepak. Blkl sahi aur bohat mofeed kam kia ap ne. Lov from 🇵🇰

  • @MrPriyata
    @MrPriyata3 жыл бұрын

    When we create invoice in sale tab rows are gapping. Kindly suggest.

  • @naveenkumar-ts6oj
    @naveenkumar-ts6oj3 жыл бұрын

    How it works if same item has two different rates and how to update date also in sales sheet

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

    Excellent Deepakji aapney kafi mehnet ki hey is video ko bananey ke liye.....thank you very much 😊

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

    Thanq thanq so much deepak sir.....aapne meri billing wali problem solve kar diya is video ke madhyam se 🙏🙏🙏

  • @arifuddin3103
    @arifuddin31033 жыл бұрын

    Great work sir. How can we create Ledger from this invoice automatically.

  • @isabellaharper3493
    @isabellaharper34932 жыл бұрын

    Sometimes I really wondered how people make this huge profits investing on the stock market online, I agreed with you investing and earning is a legitimate way to gain financial freedom, but how is it done?

  • @marcusrobs9535

    @marcusrobs9535

    2 жыл бұрын

    Anyone who has traded cryptocurrency is well aware of how the volatile the market can be

  • @marcusrobs9535

    @marcusrobs9535

    2 жыл бұрын

    If you're not a day trader and don't wanna be hit by massive drops, diversification may be a good option for you

  • @charlottegomez5279

    @charlottegomez5279

    2 жыл бұрын

    When discussing crypto diversification frequently asked question is whether diversification is even possible

  • @charlottegomez5279

    @charlottegomez5279

    2 жыл бұрын

    Because the majority of stock market have some correlation to Bitcoin, they argue that investing in Bitcoin is not a true diversification strategy

  • @fredrickhoward1297

    @fredrickhoward1297

    2 жыл бұрын

    @PRlNCĖ D0NÑÊLL🔛 You just hit the point there bubby👍

  • @faheemfarooq2368
    @faheemfarooq23683 жыл бұрын

    Great and love to watch Thank You sit

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

    I'm from Pakistan. You such an amazing topic for Accounts related work. Great Job 👍🏻

  • @azhariqbal1390
    @azhariqbal13903 жыл бұрын

    Excellent video but there is a problem. The macro "sale" selects the entire invoice table and copies it to "Sales" sheet, but when are only 1 or 2 items, then the BLANK rows are also copied. What is the solution?

  • @subhambasfore2222

    @subhambasfore2222

    Жыл бұрын

    Sir did you find the solution? Please help me if you get the solution

  • @a-55bagulrohitarvind68

    @a-55bagulrohitarvind68

    Жыл бұрын

    You got any solution then please tell 🙏

  • @saminaarfan5546

    @saminaarfan5546

    Жыл бұрын

    Same problem is with me

  • @usamarajpoot4860

    @usamarajpoot4860

    Жыл бұрын

    Same problem😟

  • @Niazi_Data_Analyst

    @Niazi_Data_Analyst

    9 ай бұрын

    same problem I am facing. rows gap between first and 2nd invoice entries@@usamarajpoot4860

  • @31priyanshipatelviiia10
    @31priyanshipatelviiia10 Жыл бұрын

    I downloaded your video and learning as a regular basis. I learned lot ofnin excel.

  • @asimsiddiq475
    @asimsiddiq4753 жыл бұрын

    hello king, as usual, you give us a unique surprise, go ahead.

  • @sushilmishra7828
    @sushilmishra78283 жыл бұрын

    Sir ji =vlookup ke bad hsn nahi le raha hai

  • @niceeducom1584

    @niceeducom1584

    3 жыл бұрын

    Vlookup function me [hsn] nahi letha hai pls provide solution

  • @preparationwithrb567

    @preparationwithrb567

    3 жыл бұрын

    Table format phle kr lo, tb lega

  • @DJBOYZzz
    @DJBOYZzz3 жыл бұрын

    Serial number pr formula lg skta h =if(d16>1,1,"") Love from Pakistan 🇵🇰

  • @pulkitsankhala

    @pulkitsankhala

    3 жыл бұрын

    Bhag bae

  • @ShaliniSingh-er7vu
    @ShaliniSingh-er7vu2 жыл бұрын

    This invoice inventory video is really awesome.you have described it briefly thank you sir.

  • @MegaMindTech

    @MegaMindTech

    2 жыл бұрын

    Agree

  • @sidd9712
    @sidd97123 жыл бұрын

    Very useful and good knowledge given..👌👌

  • @smsambalpurionlineshop3176
    @smsambalpurionlineshop317610 ай бұрын

    Can we do this in Google sheet

  • @pcmartmatara9805
    @pcmartmatara98052 жыл бұрын

    its a really valuable video.i have crated a perfect invoice and inventory...thank you soo much Mr Deepak...kasun from Sri lanka...

  • @prabhakarpawar573
    @prabhakarpawar5733 жыл бұрын

    Bahot badhiya banaya sirji. Bahot bahot shukriya.

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

    Thanks to you now i can manage my whole business very easily

  • @kj9208
    @kj92082 жыл бұрын

    THANKS VERY MUCH SIR. ITS REALLY HATS OFF TO YOU FOR THIS SUPER DUPER AUTOMATED INVOICE VIDEO ON EXCEL. I AM REALLY THANKFULL TO YOU FOR THIS VIDEO.

  • @junaidshakirmentor
    @junaidshakirmentor2 жыл бұрын

    Very Amazing. Nice bro. 👍👍👍👍👍👍 Bhooot kamal ki video banai ha. Excellent 😍💕👍

  • @ghulamullahkhan597
    @ghulamullahkhan5972 жыл бұрын

    Love your beautiful teaching experience ❤ 😍 💕 ♥ 💖

  • @ghulamullahkhan597

    @ghulamullahkhan597

    2 жыл бұрын

    Sir deepak If we want to edit gst from 5% to any value how to change in the invoice.

  • @pixelddesignstudio2048
    @pixelddesignstudio20483 жыл бұрын

    Loved It. Can you please make a video of how to create the same sheet with all same features in Google Sheets?

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

    This vedio is really helpful full..you teach this very simply

  • @lifeexpress6896
    @lifeexpress68962 жыл бұрын

    Thank you for a very informative video. From Pakistan 💐💐❤️

  • @nasrullahtahirbhatti6929
    @nasrullahtahirbhatti69293 жыл бұрын

    Your this video is very informative. Please guide how to keep subtotal of invoice location same if we add or delete row in invoice. While transferring this subtotal to other sheet it's location is changed if we add or delete row in invoice.

  • @shahnewazmd.eliasrana7047
    @shahnewazmd.eliasrana70472 жыл бұрын

    Thanks for your wonderful video. Please let me know how would I adjust the return product and correction in the saved invoice if require.

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

    Sir your excel Knowledge is unbeatable

  • @FareedAhmed-cy7lh
    @FareedAhmed-cy7lh7 ай бұрын

    Wawo! just great, I made my own shop invoice easily and working properly thank u

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

    Great knowledge bro....much appreciated 👍

  • @mathematicsclasseasyway9250
    @mathematicsclasseasyway92503 жыл бұрын

    Excellent sir 👍🙏

  • @jawaidiqbal945
    @jawaidiqbal9452 жыл бұрын

    Bundle of THANKS to improve my skills

  • @rs2442
    @rs24423 жыл бұрын

    Kaam ki cheez hai 👍🏻

  • @8sajjadahmad
    @8sajjadahmad4 ай бұрын

    Bohat zabardast from pakistan great Deepak sir great

  • @qazifaizi5622
    @qazifaizi56222 жыл бұрын

    Sir, you are a very good teacher. Your method is very good. I suggest you create a WhatsApp group to send your lectures to.

  • @ejazejaz2979
    @ejazejaz29793 жыл бұрын

    Excellent guide for new generation

  • @shubhamdavande1638
    @shubhamdavande16382 жыл бұрын

    Bhaii aap ला javab ho.... Excellent explanation ❤️❤️❤️❤️❤️❤️❤️

  • @mdomarfarook454
    @mdomarfarook4543 жыл бұрын

    I am from Bangladesh . I used to view your videos . These are worthy and have much learning materials. I request you to make video on "Ms.Access" advance for such accounting software or inventory management.

  • @Holamundo007
    @Holamundo0073 жыл бұрын

    The best teacher in Utube❤️❤️❤️❤️❤️

  • @DeepakEduWorld

    @DeepakEduWorld

    3 жыл бұрын

    🤗🙂

  • @subhambasfore2222

    @subhambasfore2222

    Жыл бұрын

    @@DeepakEduWorld sir when I enter the one entry it's take all the blank cell....please give me the solution how to remove blank cell in SALE macro ?

  • @prabhakarpawar573
    @prabhakarpawar5733 жыл бұрын

    Tx, Dipak sir

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

    thank u so much , deepak brother , u r knowledge is excellent....

  • @thiyagarajanp2336
    @thiyagarajanp23363 жыл бұрын

    great work bro.

  • @bhanushalimehul
    @bhanushalimehul3 жыл бұрын

    Adding the invoice value in words will make this perfect. Kindly do that too...

  • @basweerrashid690

    @basweerrashid690

    2 жыл бұрын

    Why in words?

  • @muraly3523

    @muraly3523

    2 жыл бұрын

    My video will help you. If I have posted a video today. You watch and comment.

  • @sivagraphics3584
    @sivagraphics35842 жыл бұрын

    thanks bro thank you very much it was easy and clear explanation

  • @asadbai1246
    @asadbai12462 жыл бұрын

    Sir , Nice & Easy Explanation.

  • @alam21032008
    @alam210320083 жыл бұрын

    Serial number based purchase and sell will be very helpful.

  • @priyankalive178
    @priyankalive1782 жыл бұрын

    Sir, you have done great job. You teach to make invoice and in this video there an add of vyapar app for invoice thas a great😁😁😁

  • @amamm6683
    @amamm66832 жыл бұрын

    Excellent work.....you Rock

  • @iicsat2063
    @iicsat20633 жыл бұрын

    Excellent Mind blowing

  • @user-ci2gv5dr4l
    @user-ci2gv5dr4l Жыл бұрын

    smart guideline technique , valuable video

  • @julkernaim
    @julkernaim3 жыл бұрын

    Many many thanks. I'm from Bangladesh.

  • @ArchanaGargyaAnArtist
    @ArchanaGargyaAnArtist3 ай бұрын

    This is really an important and amazing video. Your explaining skills are great👏😍 Thank u so much

  • @sajidchoudhry
    @sajidchoudhry2 жыл бұрын

    Hi I have a question regarding purchase & stock. For example we have a purchase of mouse with different quality and price, in purchase sheet, HSN code, price and quantity is different, but when we refresh in stock sheet, it shows the both hsn code but with total sum of purchase quantity in both hsn code. Looking forward your earliest reply on this. Thank you

  • @manikverma1641
    @manikverma16413 жыл бұрын

    Sir nice explanation 👍👍

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

    U put so much effort... thanks so much

  • @naturalkrishna9965
    @naturalkrishna99653 жыл бұрын

    Great work sir

  • @subhashismajumdar3868
    @subhashismajumdar38683 жыл бұрын

    Wonderful ,👌👌👌🙏

  • @kishansingh4103
    @kishansingh41033 жыл бұрын

    Super bro vary good Fantastic video Lajwab

  • @bappamallick2388
    @bappamallick23883 жыл бұрын

    Thank you sir aap aisi wala video chahie hum lgoko very very happy and very very very thank you sir.

  • @RahulKumar-ly6ly
    @RahulKumar-ly6ly3 жыл бұрын

    Thanks sir very helpful video

  • @RaviSharma-dg9yv
    @RaviSharma-dg9yv3 жыл бұрын

    Informative video Thank you Sir

  • @qasimali0188
    @qasimali01883 жыл бұрын

    Awesome Brother It helps me a lot

  • @santupramanik7078
    @santupramanik70785 ай бұрын

    Sir apka video achha hay bahut sikha hay

  • @randyborneo6474
    @randyborneo64742 ай бұрын

    Sehat bos Q.. Terima kasih datanya

  • @azeemahmad8851
    @azeemahmad88513 жыл бұрын

    Zabardast hai bhai great yar 👍

  • @user-de8ev6fb8v
    @user-de8ev6fb8v7 ай бұрын

    I hope this message finds you well. I've been following your tutorials on creating macros for Excel. First and foremost, I want to express my gratitude for the valuable content you provide. Recently, I watched your video on creating a sale macro, and I successfully implemented it for scenarios where I sell multiple items in a single invoice. However, I've encountered an issue when entering only one item in the invoice. The macro doesn't seem to work properly in such cases. I would greatly appreciate it if you could provide guidance on resolving this issue. Your expertise has been instrumental in my learning journey, and any assistance you could offer on this matter would be immensely helpful. Thank you for your time and consideration.

  • @bharatd2003
    @bharatd20033 жыл бұрын

    Very informative

  • @apnamalakwalinfo505
    @apnamalakwalinfo5052 жыл бұрын

    amazing method .your style is good

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

    Bhaiya aapka video dekkar same chij maine google sheet me bana di thanks

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Bahut badhiya yogesh g 😊 👍

  • @yogeshpareek6697

    @yogeshpareek6697

    Жыл бұрын

    @@DeepakEduWorld BHAIYA ISME MERA KUCH NAHI HAI SAB AAP SE SIKHA HAI AAP TO MERE GURU HO JAI HO GURU DEV

  • @user-hu8zj7kc8v
    @user-hu8zj7kc8v Жыл бұрын

    Superb work brother,Thanks ❤

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi3 жыл бұрын

    Thanks for the share.

  • @sbcreativehut72
    @sbcreativehut723 жыл бұрын

    I'm very happy,,,, Thanks

  • @hajiserajuddin1058
    @hajiserajuddin10583 жыл бұрын

    Your a great ser.

  • @nadirkamalnadir
    @nadirkamalnadir2 жыл бұрын

    Dear Deepak Sir you are amazing. All the videos are full of knowledge, adding a lots of value to my work. Sir, Facing a problem in "Inserting Copied Cells" in the desired Sheet, following step by step guide. While Clicking on "Insert Copied Cell", Popup is coming and asking "Shift Cell Right" or "Shift Cell Down?". When selecting one option and click "OK", an error message is coming, saying, "This won't work because it would move cells in a table on your worksheet". I tried many time and got tired now. Hoping, you will help me here and give me solution. Thank you very much.

  • @muraly3523

    @muraly3523

    2 жыл бұрын

    I have posted a video today. See the demo first, and watch to the end if interested kzread.info/dash/bejne/m4eAk5uAmarFg7g.html

  • @rahmatrezaali6839

    @rahmatrezaali6839

    Жыл бұрын

    Did you get the answers

  • @muhammadumar6187
    @muhammadumar61872 жыл бұрын

    very weldone job Sir Love from Pakistan

  • @kamruzzamancanon2279
    @kamruzzamancanon22792 жыл бұрын

    bro i have a question. suppose i have 10 input spaces in my invoice but i need to input more products. as in, what do i do to increase more input places? basically i need flexible product input area. because i might need to input two products in an invoice once and might need to input 25 in the next.

Келесі