Fully automatic General Ledger and Trial Balance in Excel by learning center

Поділитися
Вставка
  • Опубліковано 11 січ 2025

КОМЕНТАРІ • 39

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

    Sir I am from Tamil Nadu, Thankyou very much sir for this Vedio. It was very useful to me .I has created this for my business with help of your vedio sir.

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

    Thank you sir!!

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

    Nice

  • @jime1417
    @jime1417 3 роки тому +5

    May be a lot more useful if was in English

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

    Great excellence for professionalism but too fast for teaching

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

    Sir, would you say? which EXCELL version had u use

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

    Facing problem in vlookup i applied the same =iferror(vlookup(lookup value select that was revenue , table array ( select table) and fn plus f4 , 2, false,)
    But its not working

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

      Never select "fn" Button with f4, only and only "F4" Button key. apply again , then inform me

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

    Thank you sir. Please explain how to use standard formula for totalling date-wise debit and credit columns and balance in next line, like cash book in tally.

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

    UA-cam is used by worldwide so maybe you could speak English in order for other non- Indians to learn too, please?

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

      HI , YOU ARE RIGHT, MY 1ST 80 VIDEOS IS IN ENGLISH, BUT DEMAND WAS HIGH IN ENGLISH, PLEASE TELL ME I WANT HELP YOU, I HAVE ALSO MY FIVERR PROFILE WITH PAID SERVICE

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

    Sir how you can do that on excel. Automatically show menue e.g cash,expense etc box and you just selected......
    On my excel their no bar open of such option??

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

      please click on the playlist and watch more videos

  • @InfoBoykhurram
    @InfoBoykhurram 4 роки тому

    Bro plz toraaa sath bataa diaaa kry k esaa krny sy esaa hoga. Means ye column select krny gy to uska ye effect hoga. Means tora concept dy dia kryn

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

    👍 👍 😃

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

    I am not getting $s sign in table Array & it is not showing Dr. after dragging the cursor.

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

      If you want to apply dollor(sign) in formula Press F4(Button) from Your keyboard.

  • @VishnuKumar-xn8dg
    @VishnuKumar-xn8dg Рік тому

    COULD YOU PLEASE PROVIDE EXCEL SHEETS OF BOTH GENERAL LEDGER & TRIAL BALANCE, I HAVE CREATED ONE BUT THERE IS SOME ERROR IN DEBIT SIDE OF TRIAL BALANCE, ONE ENTRY IS NOT TAKING.
    I CAN PROVIDE FEE IF THERE IS ANY
    ALSO I WANT TO HAVE ONLINE CLASSES IF YOU PROVIDE, PLEASE REPLY, THANK YOU SO MUCH, FOR THIS E TUTORIAL

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

    Sale return in trail balance head

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

    Agr compound entry krni ho toh kaise karenge

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

    what is it on vlookup,the column index became 2 instead of 3.You excluded s.No column why is it so? THANKS FOR EVERYTHING WELL UNDERSTOOD.COULD FOLLOW AS AN ENGLISH SPEAKER.

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

      yes S.No is not a part of our formula. also excluded from Array

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

    PLEASE EXPLAIN HOW SE CAN PAY 15000 FROM 12000 IT IS NOT POSSIBLE

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

      you can pay 12000 as cash and 3000 will be a liability.so the entry will be Purchase item or service will be debited ;;;;;; Both Cash and Liability will be credited. If there any this type of issue in my video that i pass . it should be consider as a clerical error. and you can correct it

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

      studio.ua-cam.com/users/videoQevFhvuegQ4/analytics/tab-overview/period-default (watch this video you will learn debit and credit basic principal)

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

      @@learningcenterHD the sum if function only picks the criteria only and neglects the othe leg

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

      @@learningcenterHD Only Accounting and Finance students can understand this issue.

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

    Liability to elaborate nai kia

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

      please explain you question. it is necessary to practice after watching the tutorial as per your requirement. then what type of problem you are facing, then please inform me