how to make debit and credit sheet in excel

Поделиться
HTML-код
  • Опубликовано: 11 авг 2020
  • if formula for debit and credit in excel. how to separate debit and credit in excel.
    _/LINKS\
    ► Facebook:➜ / shahabislam123
    ► Twitter:➜ / shahabislam123
    ► Instagram:➜ / shahabislam6
    ► Website:➜ advanceexcelonline.blogspot.com/
    ================================================
    #deibtcredit #ledger #Excel
    How To Make Salary Sheet in MS Excel # 43
    • How To Make Salary She...
    Microsoft Word - Create Form (Office 2019)
    • Microsoft Word - Creat...
    How to Calculate gross Profit From Income Statement
    • how to calculate gross...
    Inventory Management excel formulas
    • inventory management e...
    How To Make Sale Report in Excel # 26
    • HOW TO MAKE SALES REPO...
    how to maintain store inventory in excel
    • how to maintain store ...
    #159 How To Make Food Cost Profit Sheet in Excel Hindi
    • #159 How To Make Food ...
    advance Excel Training For Job | Data Entry | functions for data analysis
    • advance Excel Training...
    hide excel sheet with password
    • hide excel sheet with ...
    #107 How To Make a Stock Management in MS Excel
    • #107 How To Make a Sto...
    How To Make Experience Certificate and Latter on MS word Hindi
    • How To Make Experience...
    How To Make Automatic student fee Collection and status system in Excel
    • How To Make Automatic ...
    How To Make General Ledger Trial Balance Sheet in Excel
    • How To Make General Le...
    #219 How To Make Daily Production Report in Excel Hindi
    • #219 How To Make Daily...
    How To Make Salary Pay Slip In MS Excel # 37
    • How To Make Salary Pay...
    how to Maintain petrol pump accounts in excel Hindi
    • how to maintain petrol...
    How To Make ID Card Design In Ms Word Urdu Tutorial
    • How To Make ID Card De...
    #283 How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi
    • #283 How To Make Stock...
    How To Make Resume / CV with Microsoft Word
    • How To Make Resume / C...
    How To Make Daily Production Report For Garment industry on Excel Hindi
    • How To Make Daily Prod...
    how to Create Notifications or Reminders Automatically in Excel
    • how to Create Notifica...
    #132 How To Make Monthly Interest amount Calculate Sheet in Excel Hindi
    • #132 How To Make Month...
    Click to see all our videos||
    / @shahabislam4912
    subcribe to our Channel ||
    / @shahabislam4912
    How To Make Bill / cash Book On MS word Hindi
    • How To Make Bill / cas...
    How To Make Sale Price Sheet IN MS Excel Tutorial In Hindi # 51
    • How To Make Sale Price...
    #88 How To Make Debit Credit sheet in Excel Hindi
    • #88 How To Make Debit ...
    #91 How To Make Balance Sheet in Excel Hindi
    • #91 How To Make Balanc...
    how to calculate retirement date in Excel
    • how to calculate retir...
    Top 50 Excel Shortcut in Hindi
    • Top 50 Excel Shortcut ...
    #269 How TO Maintain Cash Book ans Petty Cash Record in Excel 2019 Hindi
    • #269 How TO Maintain C...
    MS Excel Complete Course Hindi ||
    • #231 How To Make Reven...
    File Download Link Click Link goto Website
    advanceexcelonline.blogspot.c...

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

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

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

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

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

  • @unknownPerson-yr9gh
    @unknownPerson-yr9gh Год назад

    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... great job

  • @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.

  • @sanjaikv2851
    @sanjaikv2851 Год назад +3

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

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

    Well done Sir.

  • @MohiHash
    @MohiHash 2 года назад +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.

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

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

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

    Jazakumullahu khairan

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

    Very very good Sir Thenks

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

    Arre wah! kitna simple. Thank you bro. 🙏

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

    Very helpful tutorial. I want to get this software.

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

    thank you so much bahut help hui

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

    Bhai thank you 🤗

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

    Thank you sir!!

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

    very Good. Thaks

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

    W.salam sir.; Super info

  • @mrCetus
    @mrCetus 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.

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

    Thanks very helpful
    So divide by month with interest

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

    Your r doing very professionally but its lil bit complicated

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

    Thank you man great job ❤

  • @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.

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

    Thnk you sir 💖;:

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

    Very helpful , Thanks

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

    TQ SIRR. REALLY HELPS ME A LOT.

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

    Brilliant bro.. Thank you so much...

  • @NOOR-islaam4all
    @NOOR-islaam4all Год назад

    Excellent!

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

    Excellent

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

    so nice of you

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

    THANKS ALOT SIR. GOOD TUTORIAL

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

    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.

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

    THANKS DEAR IT WAS VERY USE FULL

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

    it's very helpful video sir

  • @Yt-Shorts255
    @Yt-Shorts255 Год назад

    Thank u so much sir

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

    Excellent tutorial.

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

    Thank you for giving me an idea.

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

    Thanks for this video😎

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

    Thank you!

  • @i2xbf
    @i2xbf 3 года назад +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

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

    Great sir

  • @user-pd1pi5yp4h
    @user-pd1pi5yp4h 10 месяцев назад +1

    Thanks

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

    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  2 года назад

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

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

    Thankyou bhai

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

    LOVE FROM bANGLADESH🤩🤩🤩🤩🤩🤩🤩

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

    THANKS BRO

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

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

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

    THANKS

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

    Marvelllous

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

    Wonderful

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

    Thnaks

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

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

  • @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.

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

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

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

    Super

  • @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.

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

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

  • @erdene-ochirmijid4040
    @erdene-ochirmijid4040 2 года назад +1

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

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

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

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

    Tq

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

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

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

    This video is fully helpful for me thank you 🙏

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

    good video sir

  • @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

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

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

  • @fasttraders5625
    @fasttraders5625 10 месяцев назад

    Nice

  • @ranaasif1422
    @ranaasif1422 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

  • @AkhterKhan-d5t
    @AkhterKhan-d5t 15 дней назад +1

    Your Greet

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

    👍👍

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

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

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

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

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

    Hello, wonderful tutorial, I would like to download the file but need access. I have sent a access request would you please approve it thank you.

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

    Me debit credit k item ko barana chahta hoo lekin neeche wali row khud neeche jaati rahe.. matlab final total wali row fixed rehni chahye.

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

    Mofiz bhai ke awaaz hai

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

    Capital Increase in the balance is 2500 ? How come sr?

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

    ❤❤❤

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

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

    Good job Sir, but SoooO Confusion and difficult proccedur ledger

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

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

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

    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

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

    Destination and tonnage wise automatically freight rate list me pick ho jaye aisa formulation bata dijiye , shukriya

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

    Sir PDF file Dana sa bohut help hoga

  • @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

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

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

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

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

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

    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

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

    Debit and credit

  • @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?

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

    APPLY YOUR FORMULAS BY PUTTING VALUES IN AL THE INTITIES , WHEN I APPLY YOUR FORMULAS ON MY EXCEL SHEET IT SHOW WRONG FORMULA

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

    Agr credit ky ya debit ky 2 cells rkhny hoon

  • @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.

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

    Need Complete Cargo Inventory Management Sheet.

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

    time sheet

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

    Please guide me. And make me correct

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

    Sir date k uper formula lag sakta h kya

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

    sir same processes krne pr bhi false aa rha h

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

    it don appear 'Range("l5:I20").formulas = " =(IF(AND(H5="",I5=""),"",J4+H5-I5)) can pls correct me

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

    Please tell formula of balance sheet

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

    Superb

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

    Op

  • @unainabbasi
    @unainabbasi 3 года назад +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  3 года назад

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