How to automate Accounting Bookkeeping , Ledger and Trial Balance in Microsoft Excel | Hindi Urdu

Поділитися
Вставка
  • Опубліковано 18 вер 2024
  • In this video you will learn how to create and automate accounting ledger and general journal in Microsoft Excel and maintain accounts in more advance way.
    You will also learn the advance feature of Table and Pivot Table, slicer and much more.
    After watching this video you will be able to do following:
    How to create accounting General Journal in Excel?
    How to do bookkeeping in Microsoft Excel?
    How to create Trail Balance in MS Excel
    How to create Table in Excel?
    How to create accounting party, customer, client or any kind of ledger in excel?
    How to create trail balance in excel?
    How to use Pivot Slicer in excel?
    How to use advance formatting in excel?
    This Video is essential to watch for every person including students, officers and business person.
    To get this file. Please subscribe to this channel
    For More Videos: www.youtube.co...
    To get this file with Ledger, Trial Balance, Income Statement, Balance Sheet and Cash Flow:
    Download File: www.downloadex...
    visit: www.exceldoers...
    Facebook page / exceldoers
    For Queries & Business: exceldoers@gmail.com
    #Ledger #Bookkeeping #TrailBalance #GeneralJournal #MSExcel #Excel #TrailBalance #Student #Job #Officer #Business #Hisab #Hindi #Urdu #MicrosoftExcel #PivotTable #Slicer #PivotSlicer #Table #Automate #Create #Ledgeraccounts

КОМЕНТАРІ • 500

  • @EXCELDOERS
    @EXCELDOERS  Рік тому +11

    Wait is over those, who was looking for Trial Balance, Income Statement and Balance sheet in Excel. Finally video has been uploaded. Checkout below link:
    ua-cam.com/video/pgBsyTKAwLw/v-deo.html

  • @NeerajSingh-wx6rd
    @NeerajSingh-wx6rd 3 місяці тому +3

    I had deadline to do it so tried chat gpt and worked as suggested but after spending 3 hours i gave up as didnt feel confidence and started searching on you tube and bingo i saw your video in recommendation.
    Its awesome you made it very simple.
    Thank you😊

    • @EXCELDOERS
      @EXCELDOERS  3 місяці тому

      Thats great. Now its ur duty to share on your profile so other can benefit too :)

  • @thetrueguidance
    @thetrueguidance 2 роки тому +5

    Wonderful! I am 51 years old and having experience in computer 32 years. Surely, you have made it in very easy and simple way.

    • @SHAHG-mx2zf
      @SHAHG-mx2zf 2 роки тому

      ua-cam.com/video/2L95R2Ngw0I/v-deo.html
      #GL #GeneralLedger #exceltutoring #excelonline #excelvba #excelword #excelrankformula #excel formula hacks #excel interview questions #excel attendance sheet #educ

  • @md.sakerurrahman5311
    @md.sakerurrahman5311 3 роки тому +6

    Brother,I am very much grateful to you for your splendid presentation on such a crucial topic regarding ledger accounts.

  • @prakashrao3607
    @prakashrao3607 3 роки тому +7

    Great! Explained in a very simple and understandable way !!

  • @MuhammadAbdullah-ck1lx
    @MuhammadAbdullah-ck1lx 2 роки тому +16

    Thank you so much brother. You made my life super simple. The most effective, practical, simple, and to the point video ever seen on this topic. May Allah Bless you with success and uncountable blessings

  • @syedharis1461
    @syedharis1461 Рік тому +2

    kia baat hai bro ! so simple , point to point behtreen . mushkil topic lekin gool gappy ki trah mazeedar bana kar samjhany pr dil ki gehrai se shukar guzar. love from pakistan.

  • @Hello-jq6qb
    @Hello-jq6qb 3 місяці тому

    اردو میں آسان ویڈیو پر زبردست تعریف

  • @nadeemkhan-rz3wy
    @nadeemkhan-rz3wy 3 роки тому +6

    It is very helpful for me, please make a trial balance and balance sheet.

  • @wellwisherofhumanity
    @wellwisherofhumanity 2 роки тому

    Jazakallahu kheyr.
    Aapka ye video mere liye intehai mufid raha.
    Allah aako khush rakhe.

  • @ramdanech7215
    @ramdanech7215 Рік тому

    Thanks owasi menon sir, ये इतना फायदेमंद विडियो है । कमाल का आइडिया दिया है। मेरा काम बहुत आसान हो गया। ये तो tally software जैसा हो गया आपका बहुत शुक्रिया

  • @solarenergysolutions1
    @solarenergysolutions1 3 роки тому +3

    Very informative Sir thank you so much ❤

  • @velunandhu6249
    @velunandhu6249 Рік тому +1

    super madam I'm ur student joined class very useful this course

  • @abdulmajeed-gc3mu
    @abdulmajeed-gc3mu Рік тому +1

    Sir -Great education

  • @CreativeCorner3
    @CreativeCorner3 3 роки тому +6

    Helpful & Very Comprehensive. Have been looking for many month for this. But, Please make clear that grow to make a subsidiary ledger in this sheet and kindly make a Trial Balance and Profit and Loss Statement.
    A Complete Account Format

    • @EXCELDOERS
      @EXCELDOERS  3 роки тому +1

      Thank u for feedback

    • @HK-gk8ns
      @HK-gk8ns 2 роки тому

      +1 please. Thank you

  • @subairmk899
    @subairmk899 2 роки тому +6

    Very useful video. I think before formating to the table, format each cell then convert to table. For inserting additional row, you can press tab at the last column of the to table, just above the sum row. Though the video is excellent

  • @Dubailif3
    @Dubailif3 2 роки тому +1

    Great Video Really Apreciate your efford. God Bless you

  • @vikash-ob2wd
    @vikash-ob2wd 2 місяці тому

    Hats off to your teaching skills, lots and lots of love from india.

  • @santani788
    @santani788 11 місяців тому +1

    Useful video Excel accounting Bro 😊

  • @DreamFirms
    @DreamFirms 3 роки тому +3

    This video is a great help! I learned a lot!

  • @ekorek1145
    @ekorek1145 3 роки тому +1

    Very knowledgeable. Thumbs up

  • @greenday1guitarfreak
    @greenday1guitarfreak 2 роки тому +2

    Thank you so much! This was massive help!!

  • @bharoshkumarthakur4410
    @bharoshkumarthakur4410 3 роки тому +11

    Hello sir,
    I respect you so much ❤💯
    This is awesome for transactions management and also request you to make more best videos like this and also provide all information ...

    • @EXCELDOERS
      @EXCELDOERS  3 роки тому +1

      *_Sure. Stay in touch.. Thank u so much_*

    • @bharoshkumarthakur4410
      @bharoshkumarthakur4410 3 роки тому

      @@EXCELDOERS why not!! I am always with you ❤💕♥

    • @projectdirector512
      @projectdirector512 2 роки тому

      @@EXCELDOERS hello there, my dr and cr column is showing blank..

  • @faheemakhtar3965
    @faheemakhtar3965 Рік тому +1

    Bohat bohat pasand aahe excellent skills

  • @ShahrukhSk007
    @ShahrukhSk007 Рік тому

    Keep Uploading Videos Like This About Accounting

  • @aakaisar76
    @aakaisar76 3 роки тому +15

    Thanks for this...its very helpful and more informational for everyone.....I would be very glad if you make Trial Balance & Balance Sheet along with Journal & Ledger.
    Thanks again

    • @HK-gk8ns
      @HK-gk8ns 2 роки тому

      Yes, please make TB and Balance Sheet video as well. Thank you

    • @yobizsolutions
      @yobizsolutions 2 роки тому

      Check this out. ua-cam.com/video/tQG5vWMF_Wc/v-deo.html

  • @RD-nm5eu
    @RD-nm5eu 3 роки тому +1

    Thanks for splendid information, keep posting video like this.

  • @quantitysurveyor1793
    @quantitysurveyor1793 2 роки тому +1

    Thank you sir, for sharing good stuff and Lectures.

  • @samayagroup789
    @samayagroup789 2 роки тому +1

    Really outstanding job brother Keep it up ALLAH BLESS YOU COUNTLESS

    • @EXCELDOERS
      @EXCELDOERS  2 роки тому

      AMEEN. THANKS

    • @anonBrook
      @anonBrook 2 роки тому

      @@EXCELDOERS do you have a video on how to calculate profit & loss using this system?

  • @excelinfo8243
    @excelinfo8243 3 роки тому

    behtareen! no need of purchasing accounting software it made my work so easy better than any accounting package. Thanks alot.

  • @TheArzueshaoq
    @TheArzueshaoq 2 роки тому +1

    Nice and easy. Please upload a video of complete video of financial statements .... Thanks

  • @soothingrelaxation8776
    @soothingrelaxation8776 7 місяців тому +1

    Teach krny ka انداز لاجواب ❤

  • @D_love_letter
    @D_love_letter 3 роки тому +1

    Thanks 👍 dear 😊 i liked it very much and you helped me

  • @ashfaquewkhan
    @ashfaquewkhan 6 днів тому

    Good One....If there is an category column it will be much helpful to find expense on specific category

  • @aminshaikhkgn2001
    @aminshaikhkgn2001 2 роки тому +5

    Excellent explanation and easiest way to follow. Jazakallah Khair for making life easy of many. 🎉

  • @stc.asif1
    @stc.asif1 2 роки тому +1

    Thanks 💐🌸 alot bhai 🙏 😊 you're so kind May Allah bless you all the happiness and rewards you 🙏

    • @EXCELDOERS
      @EXCELDOERS  2 роки тому

      Jazakallah. Ameen. Remember in your prayers. May Allah help us all.

    • @stc.asif1
      @stc.asif1 2 роки тому

      @@EXCELDOERS ameen sum ameen 🙏

  • @jahankhan7238
    @jahankhan7238 Рік тому

    A lot of thanks to give some amazing information sir.....

  • @rivbonstore9646
    @rivbonstore9646 2 роки тому +1

    great i learn lot from this

  • @eirene3498
    @eirene3498 3 роки тому +3

    Very well explained, with a lot of clarity on mechanics of ledger & pivot report, Thanks

    • @EXCELDOERS
      @EXCELDOERS  3 роки тому +1

      _Many Thanks_

    • @khizarhabibkhan3719
      @khizarhabibkhan3719 4 місяці тому

      ​ @EXCELDOERS AoA bro i am having some problem with your automation video when i made Ledger out of general journal it shows credit line items first then shows debit line items (there is no problem within Date Column) it is just (Entry structure) presentation problem that i am having can you help me out? i want to show debit line item first and then credit line second of every general entry in Ledger.

  • @zedanzaki
    @zedanzaki 2 роки тому +1

    Zabardast please make more videos on accounting in excel

  • @wasiqtariq6160
    @wasiqtariq6160 2 роки тому

    Behtreeen maza aya dekhny m thankyou

  • @MultiRanjha
    @MultiRanjha 2 роки тому

    Simply i love your teaching style...👍👍👍

  • @sayeed.lubaba_2008
    @sayeed.lubaba_2008 2 роки тому +2

    Hello Sir,
    I respect you so much and also request you to make Trial Balance,Final Account etc... please

  • @muhammadalikunduvayil
    @muhammadalikunduvayil Рік тому +1

    thank you sir, good presentation .

  • @safreenaliyakath8590
    @safreenaliyakath8590 4 місяці тому

    Kudos to you to share this info to all.

  • @nousophal
    @nousophal 2 роки тому +4

    Thank you so much for your video. Could you create income statement and balance sheet by linking this.

  • @Ihasnainasghar
    @Ihasnainasghar Рік тому

    Behtareen kafi help mili, ik help apkey ley table pr jahan total aya tha wahan us sey uppar ja kar tab dabyen gey to continue table bhar jaye ga

  • @Commerce388
    @Commerce388 2 роки тому

    Nice videos and I really appreciated ..Satisfactory

  • @Humayun392
    @Humayun392 2 роки тому

    hank you so much brother. excellent vvvv simple way

  • @farhankermani789
    @farhankermani789 Рік тому

    what an excellent video. Very well done

  • @SherMubejo
    @SherMubejo Рік тому

    Thanks Owais Memon Bhai. You have made my life lot more easier. Learnt a lot today. God Bless. 😊

  • @samadhussain4557
    @samadhussain4557 3 роки тому +1

    Thank you sir. It helps me alot 👌

  • @mishalacrafts
    @mishalacrafts 3 роки тому +1

    Great, this is quite helpful. Thank you so much

    • @mishalacrafts
      @mishalacrafts 3 роки тому

      Good to see someone from my city, Karachi helping us learn excel and as a simple and useful illustration :)

  • @fhcomputer1959
    @fhcomputer1959 Рік тому

    GREAT JOB BRO.

  • @anuj8216
    @anuj8216 2 роки тому

    Thank you for amazing video and very helpful

  • @naveedshahzad8182
    @naveedshahzad8182 8 місяців тому

    Thank you brother the nice stuff pivot table be very effective.
    Well-done

  • @ubaidmiandad3040
    @ubaidmiandad3040 3 роки тому +4

    Well-done, i apprecite your sheets, plz make clear that gow to make a subsidiary ledger in this sheet and kindly make a trial balance and profit and loss statement as well. Thanks

  • @lions4mk
    @lions4mk 4 місяці тому

    V.nice video brother Salamat rahen

  • @zaidsaleem1723
    @zaidsaleem1723 Рік тому

    Amazing course.
    You've made my life so much easy.

  • @KevinCastillousac
    @KevinCastillousac 2 роки тому

    You are a genius. Thanks friend

  • @waseemraja9988
    @waseemraja9988 2 роки тому

    Great informative video Dear, it solves my problems, Thanks Again

  • @ibrahimmuhammad9509
    @ibrahimmuhammad9509 2 роки тому +1

    soft too your lecture

  • @anmoljangid551
    @anmoljangid551 2 роки тому

    Best video for making Ledgers a/c

  • @yogeshjoshi6924
    @yogeshjoshi6924 Рік тому

    Thank you so much sir....Very helpful ..🙏🙏

  • @debapriyabhattacharya5115
    @debapriyabhattacharya5115 2 роки тому

    Amazingly simple and effective video. Thanks

  • @g4gopangvlog605
    @g4gopangvlog605 3 роки тому +1

    Very informative 👍

  • @Punjabigmr
    @Punjabigmr 3 роки тому +1

    Its really helpful
    I want learn more Sir

    • @EXCELDOERS
      @EXCELDOERS  3 роки тому

      visit my channel for more useful videos in urdu/hindi

  • @kavi_geet9959
    @kavi_geet9959 2 роки тому +1

    Excellent thanks 🙏🏽

  • @faharijlal435
    @faharijlal435 2 роки тому

    Thanks sir for so much useful knowledge.

  • @shoumafarhan2593
    @shoumafarhan2593 2 роки тому

    Thank youu, this is very helping me A LOT

  • @understandthewordsfeelthes3036

    Helpful information 👍

  • @govindmasrajisuthar
    @govindmasrajisuthar 2 роки тому

    Good
    I am from Gujarat, India

  • @sreekumarganesan7680
    @sreekumarganesan7680 2 роки тому

    Much appreciated for the tutorial video, keep going.

  • @Asadfoursix
    @Asadfoursix 3 роки тому +2

    Very beautiful tutorial, ❤️

  • @miaanshoaib8989
    @miaanshoaib8989 Рік тому

    amazing smart work

  • @mrsimkareem
    @mrsimkareem 2 роки тому +4

    Absolutely great explanation! Even though do not speak/understand your language, was able to do this just by watching. Clear and well. The only problem I seem to have is with the date! Somehow it does not organize in my ledger as I want, by oldest first etc etc. Can you help with this? Looking forward to more of this kind of video's.

    • @EXCELDOERS
      @EXCELDOERS  Рік тому

      email me ur file at exceldoers@gmail.com

  • @Muhammadahmad-rq5qk
    @Muhammadahmad-rq5qk Рік тому

    You are great man sir❣

  • @thetru4659
    @thetru4659 2 роки тому +1

    Can you make a video please, how to maintain the accounting of ( Excel) a taxi vehicle business. Vehicle purchase, daily collection, diesel, bata, repair and maintenance, tax and insurance,loan etc. Thank you

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 роки тому +3

    Thanks a lot. Please explain date wise debit and credit total in two columns and balance in next line, just like in tally cash book.

  • @hasnainshopchk
    @hasnainshopchk 3 роки тому +3

    Dear It is an interesting and informative video and really helped me to make General Journal, Ledger etc. But I also want to create profit and loss statement by using these entries. So can you help and make video on this.

  • @rajadey1552
    @rajadey1552 Рік тому

    Too good sir 🙂

  • @awanflourmill247
    @awanflourmill247 2 роки тому

    very very nice wheat a great video... superb work great you are amazing brother.... keep it up... love you bro

  • @allinall-education-health-9036

    Thanks for your help

  • @CCAFO
    @CCAFO Рік тому

    It is very good!

  • @KomalSingh-uq3bx
    @KomalSingh-uq3bx Рік тому

    Amazing 👍🤞🤟

  • @CreativeCorner3
    @CreativeCorner3 3 роки тому +2

    Very Helpful Video. Please Share any Complete Format of GL

  • @smartonlinelearning23
    @smartonlinelearning23 Рік тому

    Super bro

  • @CreaturesLover
    @CreaturesLover 2 роки тому

    Thank you so much brother

  • @imsalman_
    @imsalman_ 2 роки тому

    This is amazing brother

  • @kishorpanara4191
    @kishorpanara4191 3 роки тому

    Dear video dekha achha laga pls practice file in distribution thank you sir

  • @accountanttraining1322
    @accountanttraining1322 2 роки тому

    good zaberdast Mashallah

  • @ghafoorkhan
    @ghafoorkhan 2 роки тому

    Wonderful way to explain

  • @riobhutia9116
    @riobhutia9116 6 місяців тому

    Very informative thank you

  • @crazyfun7372
    @crazyfun7372 2 роки тому

    Nice explain..

  • @muhammadirfanmansoor7005
    @muhammadirfanmansoor7005 2 роки тому

    Amazing
    🥰🥰🥰🥰🥰🥰🥰🥰
    Main to apka fan ho gaya

  • @naumanasgher5421
    @naumanasgher5421 Рік тому

    Great 👍

  • @muhammadsaifi
    @muhammadsaifi Рік тому

    Love you sir great explained

  • @ouruniverse.n
    @ouruniverse.n Рік тому +1

    excellent bro❤

  • @sajjadhussain-bb4cw
    @sajjadhussain-bb4cw 2 роки тому

    Thankyou brother very easy to understand. ❤️

  • @hayze.d_fine009
    @hayze.d_fine009 8 місяців тому +1

    Amazing, you are ... if you can create english and your language for us to understand much better

    • @EXCELDOERS
      @EXCELDOERS  8 місяців тому

      English version is available on our channel.. please visit