How to create General Ledger and Trial Balance with Excel (UrduHindi) || Google Work Sheet

Поделиться
HTML-код
  • Опубликовано: 29 фев 2016
  • This video is about creating complete ledger and trial balance with excel advance concepts.
    IF THERE IS ANY ISSUE COMPLETE IMPROVED TUTORIAL UPLOADED AGAIN HERE. • How to Create General ... .
    Template and complete working file can be downloaded from : www.myolesson.com
    Complete Template can be downloaded from the given link but Plz Dont forget to Write a positive comment and subscribe our channel to support us for future tutorials. www.myolesson.com
    If you needed any custom Excel Template for your business/personal use as per your requirements then kindly visit the link below and get it done with in 24hrs.
    Thanks
    Improved version Available here.. • How to Create General ...
    www.fiverr.com/xajidmughal/do....
    #Accounting #In #Excel

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

  • @atifmunawarhussain8245
    @atifmunawarhussain8245 6 лет назад +9

    One word ... AWWWWSUM .. God Bless You ,, Keep doing good work/

  • @ajeettanwar4331
    @ajeettanwar4331 6 лет назад +6

    Thanks Brother for Uploading such a useful video

  • @canitinagrawal4744
    @canitinagrawal4744 6 лет назад +4

    such a excellent and well explained tutorial. Thanks for knowledge sharing and updation. Best Rgds CA Nitin Agrawal, Raipur

  • @BobyKumar-yq3co
    @BobyKumar-yq3co 6 лет назад +2

    sir I don't have words to express my thank you... may god bless you and your family.... subahn allah.... kitna easy samjhaya aapne..

  • @warginosihim
    @warginosihim 7 лет назад +10

    Assalamu'alaikum brother, I'm Indonesian. Thank you so much for the lesson, even-though I don't understand your language but I know what do you mean. You'd explained very well.. may Allah Almighty bless you.

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

    We are from India
    Thanks a lot, very useful information
    Your voice is so pure and innocent
    God bless you

  • @immadahmed1230
    @immadahmed1230 7 лет назад +1

    amazing, cleared my concept of accounting as well as excel in just 13 min thank you

  • @G-RaakinMajeed
    @G-RaakinMajeed 6 лет назад +1

    Jazak Allah bro.. i got to see this video when it was much needed..

  • @thesunlight9860
    @thesunlight9860 6 лет назад +2

    Good work sharing the knowledge. Straight to the point.

  • @saquibfsyed9461
    @saquibfsyed9461 6 лет назад +1

    Waalykum Asslam brother, this is by far the best tutorial i have seen to learn how to create smart T accounts(auto calculating) based on General Journal entries. Thank you very much.

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

    Walikum Assalam Brother thank you so much for this Video very well explained 👍

  • @123kkambiz
    @123kkambiz 6 лет назад +1

    EXCELLENT INFORMATION, THANK YOU VERY MUCH FOR UPLOADING SUCH A USEFUL INFORMATIVE VIDEO, THOUGH, I AM NOT A HINDI OR ORDU SPEAKER BUT I UNDERSTOOD THE LANGUAGE PARTIALLY. I HAVE TO WATCH THE VIDEO FEW TIMES BECAUSE YOUR ACTIONS WERE VERY QUICK IN THE VIDEO.

  • @WaqasAli-tc4rg
    @WaqasAli-tc4rg 6 лет назад +1

    بہت ہی اچھے طریقے سے سمجھایا شکریہ جناب

  • @pradeepputhran2939
    @pradeepputhran2939 7 лет назад

    You are an expert, thanks, I really liked your super speedy tutorial, Thanks,

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

    THANK YOU SOO MUCH BROTHER....❤❤❤

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

    Simple and Great! Simply great tutorial.

  • @Liwantrang977
    @Liwantrang977 7 лет назад

    i like it so much bro... & i also downloaded this vidio thank's for the information about creating ledger using excel :) :) Many Thank's

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

    I have learnt alot from this veidio keep it up tnxs

  • @razirazi4327
    @razirazi4327 7 лет назад +1

    masha Allah
    very useful bro keep it up thanks for uploading

  • @harinderbhatti1764
    @harinderbhatti1764 6 лет назад

    vah....aapke samjhane ke andaz ka mai kayal hoon....may allah bless you.

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

    Thanks very helpful stuff ..

  • @ratikantabehera3492
    @ratikantabehera3492 6 лет назад +1

    Thank you sir. I have understood properly sir.

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

    Thank you so much. You are great.

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

    really good, the way of explaining is so simple and easy to get for anyone.

  • @shaykhulalam1589
    @shaykhulalam1589 6 лет назад

    Very basic work but many of us don't know how to do it in excel.Thanks.

  • @ardiyaspare6396
    @ardiyaspare6396 7 лет назад +4

    Thank you much Sir, Allah bless u lot. very useful video.

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

    really use full video
    thanks brother

  • @marinokitchenequip.factory1379
    @marinokitchenequip.factory1379 7 лет назад

    You have magical hands and mind. Great Video, May Allah enhance your knowledge

  • @crgr83
    @crgr83 6 лет назад

    Thank you for uploading such a helpful video.

  • @sabirtumbi5960
    @sabirtumbi5960 7 лет назад +1

    Sukriya Bhai. Bahut kaam aaya

  • @syedafsar3339
    @syedafsar3339 7 лет назад

    Thnak you very much, its very nice to maintain accounts with out accounting software.

  • @Islamic_Naat_And_Lectures
    @Islamic_Naat_And_Lectures 6 лет назад

    THANK YOU SO MUCH FOR SUCH A USEFUL VIDEOS

  • @Robert253433
    @Robert253433 7 лет назад +1

    Sir, great class thnx

  • @KhurrumIqbal1
    @KhurrumIqbal1 5 лет назад +21

    If we use pivot table for trial balance, it would be faster and also it gives you individual ledger as well.

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

      Could u send me a format using this (pivot table)..?

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

      How ? Can upload a video or something?'

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

      @@salahpulikkal6695 yes send me this file on khurrum.iqbal@gmail.com, I will make you a quick pivot table along with individual ledger in separate sheets

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

      @@KhurrumIqbal1 I am keeping a small entities accounting data like this....
      Prepared TB using Pivotable..
      I want individual ledgers as u said..
      I will send that to u....
      Thanks in advance...

  • @mahamza86
    @mahamza86 6 лет назад

    Very Helpful, JazakAllah

  • @adeebashyjal1809
    @adeebashyjal1809 6 лет назад

    Thank you so much Sir for this great useful video...

  • @clarence1221
    @clarence1221 6 лет назад

    Thank you Brother. Very Educational. Best Regards

  • @sharique786
    @sharique786 7 лет назад +1

    assalamualaikum
    i appruciate ur work
    may allah give more success
    keep making such useful vdos

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

    thank u ALLAH bless you sir

  • @ahsanfiaz3663
    @ahsanfiaz3663 6 лет назад +1

    very helpful, Thank you

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

    Good execution of accounting expertise. Keep it up bro.

  • @khantasticfaiyaz4681
    @khantasticfaiyaz4681 6 лет назад +2

    This was very useful. Thanks

    • @LearnWithPurpose
      @LearnWithPurpose  6 лет назад

      Thanks for appreciations. P.S Subscribe us for future updates and new stuff.

  • @changemaker3999
    @changemaker3999 7 лет назад

    Sukriya.............SAJID Vai.
    from Bangladesh.

  • @niju.a3445
    @niju.a3445 8 лет назад +1

    THANKS sir. VERY GOOD AND KEEP IT UP.

  • @palashdas5296
    @palashdas5296 7 лет назад +1

    Very good i am impressed. Please upload more business video.

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

    thank you so much for such amazing and informative video....keep it up!

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

      Welcome dear , hope you will recommend our channel and already subscribed for more useful videos .. thanks

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

    Great job all the best to you

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

    Very Informative, Keep Going Dear

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

    Thank you sir for class

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

    I am Asnan Malik From Gujranwala Punjab

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

    Very informative. Kindly make tutorial of posting voucher entries to proper ledger account

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

    Ma Sha Allah, great work bro!

  • @sam03064152011
    @sam03064152011 6 лет назад +3

    Great work

  • @alamwajalzarqageneraltradingll
    @alamwajalzarqageneraltradingll 7 лет назад +1

    Great bro thumbs up for you

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

    good one. i appreciate your efforts brother.

  • @tapdeelhusen3700
    @tapdeelhusen3700 7 лет назад

    i like your explanation and o got it all but some where i got it very well

  • @softwareguide7246
    @softwareguide7246 6 лет назад +1

    Awesome bhai

  • @anilchaudahry8109
    @anilchaudahry8109 7 лет назад

    I like this learning video. thank you very much!

  • @ahsanali50
    @ahsanali50 7 лет назад

    very useful video. thanks a bunch

  • @SHAFIQKHAN-rw4hz
    @SHAFIQKHAN-rw4hz 7 лет назад

    ma sha allah allah pak aap ko kamyabi atta farmay

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

    Useful, thanks for sharing.

  • @abdul_qadir7780
    @abdul_qadir7780 5 лет назад +2

    wha bhai kya bat ha ap ki.. :-)

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

    Bht acha btya apny bro

  • @majidyamin4876
    @majidyamin4876 5 лет назад +2

    Aslamualikum bro! Thank you very much for this video, please upload how to make full sofware in excel for a small business

  • @user-ye9by6iq6g
    @user-ye9by6iq6g 5 лет назад

    Jabraa fan ho gaya bhaijaan

  • @queengcina8659
    @queengcina8659 7 лет назад

    good and help full ,thanks alot

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

    Zabardast bht acha sumjha apny sir .....bus jo jo kam ap kry rahy hoty uski keys or short keys bata diya kry k thanks alot

  • @vegetaprinceofallsaiyans
    @vegetaprinceofallsaiyans 6 лет назад +2

    Mashallah bhai

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

    Thanks For The Idea Searing

  • @ranju26bala
    @ranju26bala 7 лет назад +1

    THNKS FOR UPLODING THIS VIDEO

  • @ju-anneroseayson6098
    @ju-anneroseayson6098 6 лет назад +1

    thank you, you help me a lot!

    • @LearnWithPurpose
      @LearnWithPurpose  6 лет назад

      Welcome. We have uploaded more useful tutorials on our channel kindly make a visit and benefited.

  • @phona2007
    @phona2007 6 лет назад +1

    Love your work...

    • @LearnWithPurpose
      @LearnWithPurpose  6 лет назад

      Thanks

    • @amwebapp1129
      @amwebapp1129 6 лет назад

      Great Also see this video on general ledger by #amwebapp. explain very Well how to manage general ledger or customer ledger in real time software . AmWebApp provide the best billing software with multiple functionality.
      ruclips.net/video/5Fu8vPbX8nU/видео.html
      #amwebapp

  • @umerelegance9344
    @umerelegance9344 6 лет назад +1

    Sir you are great plz advanced excel formulas and the financial accounting in excel and formulas as well.

    • @LearnWithPurpose
      @LearnWithPurpose  6 лет назад +1

      ruclips.net/channel/UCLyiGg2MEoVRNWmzYgacbGw

    • @amwebapp1129
      @amwebapp1129 6 лет назад

      Great Also see this video on general ledger by #amwebapp. explain very Well how to manage general ledger or customer ledger in real time software . AmWebApp provide the best billing software with multiple functionality.
      ruclips.net/video/5Fu8vPbX8nU/видео.html
      #amwebapp

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

    AWSOME!!!!

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

    thanks ,its very helpful

  • @ImranMohammedkhi
    @ImranMohammedkhi 7 лет назад +1

    Ma sha Allah

  • @idreessh
    @idreessh 8 лет назад +1

    AOA . THANKS BROTHER. VERY GOOD AND KEEP IT UP.

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

    thank u so much bhai...

  • @testwork4734
    @testwork4734 5 лет назад +2

    Good work very helpful

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

      thanks , stay with us and watch other useful tutorial from this channel ..

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

    EXCELLENT BRO

  • @osddgg1117
    @osddgg1117 7 лет назад +1

    You are doing great job sir

  • @PSPunnu
    @PSPunnu 7 лет назад

    very Helpful for beginner

  • @syedsheeraz6373
    @syedsheeraz6373 7 лет назад +1

    thanks bro

  • @muhammadadil9547
    @muhammadadil9547 7 лет назад

    thank you.. its good

  • @MuhammadSafdar-fr8su
    @MuhammadSafdar-fr8su 6 лет назад

    Excellent way to teach

  • @BahonarKhorshed
    @BahonarKhorshed 6 лет назад +1

    thank you sir

  • @ranim7062
    @ranim7062 6 лет назад

    Thank you so much.

  • @irfuirfan9881
    @irfuirfan9881 6 лет назад

    Walekum assalaam..Bhai☺️
    Nice video

  • @urduhinditutorials2998
    @urduhinditutorials2998 7 лет назад

    Great job sir thanks

  • @MohdShadab-xf7jn
    @MohdShadab-xf7jn 4 года назад

    Thank you bhai..

  • @Pankaj-Verma-
    @Pankaj-Verma- 5 лет назад +1

    Thanks!

  • @shajibsaha840
    @shajibsaha840 7 лет назад +1

    Thank U very much.

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

    nice video actualy i am from kerala and i understand ur video good work bro
    NB:bro decrease ur speed while saying thank you

  • @09shirish
    @09shirish 7 лет назад +1

    thanks sir

  • @stilgottheblues
    @stilgottheblues 7 лет назад +2

    Sajid Bhai Thank you a lot. I want to know one thing. If a company has several buyers then how can It track from which customer It will get account receivable? This is a very important to know for me. Plz help.

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

    Very Helpful

  • @umairsiddiqui3204
    @umairsiddiqui3204 7 лет назад +1

    Assalamualikom !
    Thank you for sharing your work brother. please let me know if I can create subsidiary and control ledgers too (GL-->Ledgers-->Tb). Thanks

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

    Thanks for such a excellent tutorial. Plz sir give a complete from journal to balance sheet plzzz or link of video respective sequence. Plzz
    From journal to balance sheet.

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

    Thanks use full Video

  • @Pugman101
    @Pugman101 6 лет назад +1

    Thank you for your helpful video. had one question. How do we group multiple ledgers under one head. For example if I have 3 staff members and I make the entry in their accounts separately. What do I have to do so that all those entry add up and automatically enter into one head called staff salary?