how to make debit and credit sheet in excel

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

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

  • @CyberLinkComputers
    @CyberLinkComputers Год назад +2

    Superb Sir . . . . Thank you so much Allah Apko Hamesha Abaad Rakhay Ameen ♥

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

    it's very helpful video sir

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

    Thanks for information I have e totally kharch in office I have saved in my devise Thanks a lot🙏

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

    Arre wah! kitna simple. Thank you bro. 🙏

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

    LOVE FROM bANGLADESH🤩🤩🤩🤩🤩🤩🤩

  • @razwang.7844
    @razwang.7844 Год назад

    TQ SIRR. REALLY HELPS ME A LOT.

  • @MetroIndustries
    @MetroIndustries 2 года назад +2

    Very helpful , Thanks

  • @SurjeetSingh-vs9so
    @SurjeetSingh-vs9so 2 года назад +1

    good video sir

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

    Excellent tutorial.

  • @shreesuryawanshi9386
    @shreesuryawanshi9386 2 года назад +2

    Bhai thank you 🤗

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

    IT WAS REALLY GREAT. THANK YOU FOR THE EFFORTS YOU PUT INTO CREATING THIS VIDEO

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

    I love ur voice so much....u r real gem....

  • @Sha-Sha.
    @Sha-Sha. Год назад +4

    Sir debit ko minus and credit ko add nahi krna tha?

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

    Assalam o Alaikum sir..ye Jo ap short cut keys use krte Hain inko bhi mention Kiya kren

  • @md.atiarrahman9748
    @md.atiarrahman9748 Год назад

    very Good. Thaks

  • @ahmedabdulaleem5304
    @ahmedabdulaleem5304 11 месяцев назад

    Jazakumullahu khairan

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

    Sir ye tho simple hai, surf +, - ho Raha hai interest iss Mai add hoga 😇

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

    THANKS DEAR IT WAS VERY USE FULL

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

    Thanks very helpful
    So divide by month with interest

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

    Brilliant bro.. Thank you so much...

  • @ar-ramzafamily2517
    @ar-ramzafamily2517 2 года назад +1

    THANKS ALOT SIR. GOOD TUTORIAL

  • @tinuolaogunlade5649
    @tinuolaogunlade5649 3 года назад +7

    Good Afternoon wonderful tutor, I appreciate all Indian tutors on youtube, they have helped me so far but please try to teach more in English. I can't understand your language but I need this lesson.

  • @raj28san
    @raj28san 3 года назад +3

    Hi Sir, you are simply fantastic. super explanation of debit credit. I watch your video most of the time and it is very very interesting and knowledgable. Thank you Sir God Bless you. As I practice my daughter really like it.

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

    Sir. Account se related bi video upload kr do jese tally erp 9 and Busy accountancy etc

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

    Thank you for giving me an idea.

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

    Very nice explanation of this formulas but only one mistake debit side minus Hoga & credit side plus hoga

  • @globalfinancelimited741
    @globalfinancelimited741 7 месяцев назад

    Fantastic tutorial. Where can i download this excel sheet. Cant find it

  • @MohiHash
    @MohiHash 3 года назад +3

    Thanks. Very helpful tutorial. I used it for my google sheet for kids pocket money and monthly expenses and it worked great. Only issue I can't leave a cell blank and have to put zero if nothing else otherwise the formula breaks and starts again. But that's no big deal as there are just a few entries every month and I can easily add zeros manually to empty debit or credit fields.

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

    Very nice video

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

      Thanks

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

      @@shahabislam4912 no thanks you really deserve like and subscribe
      I also want to get some more lacture so I subscribe and click on bell icon for more videos

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

      @@shahabislam4912 and i also see more videos in your channel about Excell and Word

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

    Great sir

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

    Thank you man great job ❤

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

    Hello Sir good tutorial but I am confused!!! In accounting EXPENSE ACCOUNT IS DEBIT BALANCE RIGHT?? Your example is CREDIT. Why???

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

    Thank you!

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

    Very helpful tutorial. I want to get this software.

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

    Jazakallah brother this was perfect and just what I was looking. The formulas are simple and clearly explained, and in Urdu loved it. May Allah swt bless you and your family and fill your life with barakat and His mercy. You my brother have a subscriber

  • @HASNAINALI-ql3yl
    @HASNAINALI-ql3yl 3 года назад

    so nice of you

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

    Thanks for this video😎

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

    Good job Sir, but SoooO Confusion and difficult proccedur ledger

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

    Agr credit ky ya debit ky 2 cells rkhny hoon

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

    Made-in-Pakistan is one of the leading platforms for wholesale trade globally. We want to serve every buyer and supplier around every corner of the world.

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

    Very very good Sir Thenks

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

    thank you so much bahut help hui

  • @NOOR-islaam4all
    @NOOR-islaam4all 2 года назад

    Excellent!

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

    Excellent

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

    Thank you sir!!

  • @Yt-Shorts255
    @Yt-Shorts255 2 года назад

    Thank u so much sir

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

    Agr hmary pas last year ka balance na ho to kia kren

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

    Explain why if and function are used here when only sum formulas can be used?

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

    Thnaks

  • @Md.Asif.Khalid
    @Md.Asif.Khalid 3 года назад

    AoA.
    Sir ap ny F3 me cash balance likh k zhort key use ki jis sy cell bara ho gya and jb C4 me last year's balance likha os k bad phir apny wohi short key use ki.
    Kindly wo short key bta dy

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

    Your r doing very professionally but its lil bit complicated

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

    Masha Allah. Sir agar opening balance minus (-) me ho ky Kya karen sir plz reply

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

    Good

  • @AnuragSharma-sn6bk
    @AnuragSharma-sn6bk 2 месяца назад +1

    जय श्री राम 🙏🚩🕉️

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

    Assalam o alaikum sir mny same bnaya h jesy apny btya hua h but jb hm value ziada inter krty hn chahy debit me y credit me to wo ## ka sign dy deta h like 100000 ya 500000 add krty hn tb

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

      ap column width bri karen. us column k top me jakar jahan abc k nam are hote hen column waha line per double click karen.

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

      @@shahabislam4912 thanks boss it's working...

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

    Sir date k uper formula lag sakta h kya

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

    Super

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

    You are posting entries just how we post entries in ledger? Not in journal?

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

    Need Complete Cargo Inventory Management Sheet.

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

    THANKS BRO

  • @SOLO_Rythm.Studio
    @SOLO_Rythm.Studio 3 года назад

    This video is fully helpful for me thank you 🙏

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

    Very supper way of explanation. Masha Allah. May I request you to please explain the excel functions and formulas using in Finance Organization.

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

      ruclips.net/channel/UCcOsbNCxgUZMPoHEI1w-1RAsearch?query=finance

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

    Mofiz bhai ke awaaz hai

  • @User-Js-0804
    @User-Js-0804 2 года назад

    don't west your time , Start watching 7:38 Sec

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

    Nice

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

    Thankyou bhai

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

    Hi sir ye formula ek hi lejar me 2 bar kam kio nhi krrha h =IF(AND bala batana sir

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

    i put this formula in sheet but showing false in balance column....please tell what is my mistake

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

    Sir how to write 100,000.00 in excel.....by formula its putting one extra comma after 1 for eg its showing it as 1,00,000.00

  • @subratasinha7420
    @subratasinha7420 2 года назад +5

    Wrong formula debit aur credit ka matlab ulta kar diye he apne

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

    SIR PLZZ MERI PROBLEM SOLVED KEJIYE
    JESE IDBI BANK KI STATMENT MAI DR AMONUT OR CR AMOUNT AK HE COLOUM MAI HOTI HAI
    AGAR HAME DR KA COLOUM ALAG OR CR KA COLOUM ALAG RAKHNA HO TO KESE HOGA PLZZZ VIDEO BANAO ESPE SIR

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

      ruclips.net/video/tP5qRJ76Ugw/видео.html

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

    Wonderful

  • @sanjayrocky7685
    @sanjayrocky7685 9 месяцев назад

    Tq

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

    Please tell formula of balance sheet

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

    Please add thees formulas in description so that we can copy and past

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

    Many many thanks for your prompt reply. Please tell me what the formula will be if I connect the 'credit' (E5) instead of the 'description' (C4) and get serial numbers as and when only a credit entry is entered? I want to know how many EMIs I have paid by seeing only the last serial number against the last credit entry.

  • @MuhammadUsama-cd6rq
    @MuhammadUsama-cd6rq 3 года назад

    Thnk you sir 💖;:

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

    THANKS

  • @AkhterKhan-d5t
    @AkhterKhan-d5t 4 месяца назад +1

    Your Greet

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

    sir same processes krne pr bhi false aa rha h

  • @dineshkumar-xe1sw
    @dineshkumar-xe1sw 3 года назад +1

    Sir, it's too much good but I've a question, when I put my credit balance it is shows in subtract sign in cash balance

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

    Marvelllous

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

    W.salam sir.; Super info

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

    thanks but please tell me what if there in no debit and credit entry in specific date then this formula not working.pls help.

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

    assalamu alaikum bhai mujhe bhi ek excel sheet banani hai mere pass ek image hai wo main aapko send karta hu uss type ka muhe banana hai kya aap meri help kar sakte hai. wo sheet jo banani hai wo masjid ki hai.

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

    Sbi account mai mistake se kisine 1000 bhejatha phir auto debit ho geya kesse

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

    Good morning # value aata hai time in or time out ko jab select mana jise ki =(D5-E5)+(G5-F5) formula

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

    Well done Sir.

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

    I would like to add debit automatically to debit column even if it's entered in credit column if the description is " amount debited" , how can I do that ? Pls help

  • @smastore-pk
    @smastore-pk 3 года назад

    As salam o aalaikum
    bhai ma ne ye formula apply kia start ki entries ma work kar raha hai us k bad #VALUE! show ho raha hai, kindly help aisa ku ho raha hai.

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

    Debit and credit

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

    Goodnight can someone help please when I write count I can't choose countA cause the crochet not turns red and it tell me to counts the number of cells that are not empty. What should I do please please please.

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

    or mre axcell me formula copy to ho rha h lkn value ek hi arhi js cell me formula put kia ho uski chnge nh arhi copy past per

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

    bhai mre excell me formula lag to rha h lkn jb new valu dal rhe hn to formula automatically abdate nh kar raha us ko click kr k enter karna parh rha h phr wo abdate kar rha h ap plz mri help kar dn

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

      formula menu me calculation option last me he usme automatic click karen

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

    Purchase of Chair ko Cr Q kiya hai? Purchase to expense hai Dr hona Chahiye.

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

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

    mjhe confusion ha k ap ny cash balance ma formula lgaty hue debit or credit ko uper nechy select kiu kia koi uper ka or koi nechy ka select kr k formula lgaya? kiu?

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

    Sir ager hme ye check Krna h ki credit kitni Baar hua count mein tb hum kaise krenge

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

    👍👍

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

    Sir How To Remove - minus sign After this formula is given ?