How To Make Professional DEBIT and CREDIT Sheet in MS Excel ?

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

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

  • @satishcomputersportsedu.9440
    @satishcomputersportsedu.9440 2 года назад +17

    क्या बात है गुरु जी आप धन्य हो 👍👍👍👍🙏🙏🙏🙏

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

      Brother ye kis bank ka passbook hai interest rate add nahi hota hai

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

      Iss formula sai interest rate add hoga aap he bolye bank passbook Mai interest v update hota hai

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

      Uska kya formula hoga oh bolye brother

  • @NRICell
    @NRICell 10 месяцев назад +1

    सर जी, आप बहुत ही साधारण पूर्वक व अच्‍छे से समझाते है। जिससे आराम से समझ में आ जाता है। धन्‍यवाद।

  • @technobhai7310
    @technobhai7310 2 года назад +16

    Sir Your teaching is awsome.But here you have written credit in place of debit and debit in place of credit.

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

      सर ने सही लिखा है भाई...आप एक बार एकाउंटिंग अच्छे से पढ़ लो तो समझ में आ जायेगा। मुझे पता है आप ऐसा क्यों बोल रहे हैं... क्योंकि जब हमारे खाते में पैसा आता है तो क्रेडिट लिखा होता है, जबकि सर ने यहाँ ख़र्च को क्रेडिट बताया है...😀 पहले मुझे भी यही डाउट था , लेकिन अब नहीं है। सर ने जो लिखा है, वो सही है...👍

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

      Bani statment me chalta wo system jo ap bolte....sir is right

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

    THANK YOU SIR JI AAP KE VIDEO SE MERI MADAD HO GAY THNQ ONCE AGAIN

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

    Namaste sir, mein appka her video dekhata hun, bahut help full hai. Thank you sir you are great sir

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

    Bahut hi most Vedio Banaya hai Cashier k liye bahut hi Kam Ka hai.... Thank you Deepak Jiii.....

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

    Very good, Deepak Bhai.

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

      @DeepakEduWorld Bhai, Excel me "automatic invoice creation + pdf saving + keeping the database" par video banaiye... 🙏🙏

  • @atulkashyap6235
    @atulkashyap6235 Год назад +15

    Video was nice, But you should write DEBIT in the cell where you typed CREDIT & vice-versa :)

  • @feelthesong..1757
    @feelthesong..1757 Год назад +2

    आप बहुत अच्छा समझाते है सर बिना समय बर्बाद किये😊

  • @Islamic-Naats-n-Video-Channel
    @Islamic-Naats-n-Video-Channel 5 месяцев назад +1

    I Love Your That Thing That You Provide Training Sheets With Your Video It Makes People Life Easy 💖💖💖💖💖💖

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

    Aapki sahi videos usefull hoti h

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

    Sir bahut achha lesson tha

  • @RakeshPandey-nw5ql
    @RakeshPandey-nw5ql 2 года назад +1

    Bahut jabarjasti sir g

  • @Chillwithlofi878
    @Chillwithlofi878 11 месяцев назад +1

    Thanks you so much sir🎉❤😊

  • @Ayush-jh2od
    @Ayush-jh2od 9 месяцев назад

    amazing video. deep like to you

  • @Unknown-pe4di
    @Unknown-pe4di 5 месяцев назад +1

    Love from Pakistan ♥️🙌

  • @kunalkalyani6075
    @kunalkalyani6075 6 месяцев назад +2

    Thank you very much Sir 😁👍🏻.

  • @royaltechnicalmusic8333
    @royaltechnicalmusic8333 Месяц назад

    Tq so much sir ❤😊😊😊

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

    Very knowledgeable video sir

  • @YaAllah-v6n
    @YaAllah-v6n 7 месяцев назад

    Thank you so much Sir.💐💐💐 this is very Helpful for me.

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

    NICE WORK ....................

  • @mohdwasim9204
    @mohdwasim9204 3 месяца назад

    gazab ka samjhate ho bhai

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

    Great knowledge sir❤

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

    Great 👍👍👍👍

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

    Greate sirjee...

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

    Super Baiya

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

    That was nice . Thanks bro

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki 2 года назад +2

    Good sir plz plz plz plz plz dashboard ki series ko bhe continue rakhe plz we are very more need.

  • @academyoflearning111
    @academyoflearning111 2 года назад +7

    In debit column you should to write credit and vice versa.

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

      Thank you brother, since I was the video I was confused as I am commerce graduate. Anyways that we can figure it out

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

      @@hbp7633 Thank you

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

      I was typing this too but you have already raised the question. Good
      Otherwise mostly people are just enjoying this video with snacks without seeing the problem in video😂

  • @SurajVerma-op2dq
    @SurajVerma-op2dq 2 года назад +1

    Thanks Deepak Sir 🙏

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

    Sir g simple formula use kartai toh bhoot bariya hota

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

    Very useful information

  • @rajashekharshekhar3101
    @rajashekharshekhar3101 7 месяцев назад +1

    Nice bro❤

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

    Very nice.....

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

    Thank You Sir 😊

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

    Excellent sir 👌👌👍

  • @yashupanwar4891
    @yashupanwar4891 8 месяцев назад

    Your videos are very helpful for me. Thanks a lot

  • @Anwarhossain-k1n
    @Anwarhossain-k1n Год назад

    Thanks for the video

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

    THNXX FOR EXCEL VIDEO

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

    Good work sir

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

    Sir ji bahot badhiya video hai par meri query thoda alag hai, jaise ki agar date ko filter karu to usi date ka balance dikhana chahiye to is relate koi formula hai kya plz

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

    GReat bhai

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

    Made my life easy😍

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

    Thank sir for the tutorial

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

    Nice one video sir

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

    Super sir

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

    Sir I always follow your video and i use this formula to calculate my business account ledger. Sir Please create a video for vba code to debit and credit.

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

    Thank you sir!!

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

    Very good

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

    Sir banking me jeetne bhi works hote hai uspe bhi video banayiye 🙏

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

    Thanks bro 🙏

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

    वाह वाह वाह

  • @serventofgod3276
    @serventofgod3276 5 месяцев назад

    Thanks ❤

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

    वाह सही

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

    Love you sir

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

    Very nice ...Thank you ..

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

    Deepak sir yeh hum without If or and se bhi kar sakte hai, sirf plus or minus se

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

    Thank you sir for you this lesson

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

    Great sir g

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

    Very nice sir

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

    Deepak Sir Google Drive ka Complete Tutorial banao Plz Sir

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

    Bro please make a video on Microsoft power bi

  • @n56.7
    @n56.7 2 года назад

    Sir data ek sheet me aur dusre sheet me searchable drop-down+ dependable drop down ka ek chota sa video banay
    Ya short tips dijiye

  • @RiverMNS
    @RiverMNS 3 месяца назад +1

    ❤❤❤❤❤❤

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

    Thnks sir

  • @syedattaulhaq2310
    @syedattaulhaq2310 8 месяцев назад

    Ye tou simple sun k formulay sa bho hoskta ha

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

    GOOD

  • @pamelamukherjee5098
    @pamelamukherjee5098 5 месяцев назад

    Date, description, credit, commission, expenses,cash balance..... Iska formula dikhye na sir please 🙏

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

    Amazing...

  • @prakashkumar-ey5lk
    @prakashkumar-ey5lk 3 месяца назад

    Sir 1500rs mange the ye karne ke liye apke vidio me bcha liye mere pese

  • @kishorechandramondal5834
    @kishorechandramondal5834 28 дней назад +1

    Debit matlab Paisa nikala gaya hai
    Aur credit matlab jama Kiya Gaya hai

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

    Nice sir

  • @AbdulRazzak-u1s
    @AbdulRazzak-u1s Год назад +4

    Dear Sir,
    Thank you for the video. However, I am facing an issue with my credit customers. The customer's credit is more than their debit, which is causing the remaining balance to appear in brackets instead of in the minus. This is confusing my customer. Can you kindly assist me with this matter?
    Thank you.

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

    Bhaiya video to aaacchi hai par invoice kaat ke aur parchi number bhi aaajaye aesa kuch ho jaye

  • @PremkumarBharathan
    @PremkumarBharathan 8 месяцев назад

    sir please post the vedio for how to maintain petty cash management for every month automatically

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

    I am confused.
    Increase in Income is credited and increase in expense is debited but is video mai is kai ulat entry huwi hai why............ Can any one explain please.

    • @learnandshare426
      @learnandshare426 3 месяца назад

      In terms of Ledger (Cash Account) its different i.e all the cash receipts are recorded in the debit side while cash payments in the credit side of a ledger.

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

    Hi deepak sir.. I am following your videos can you do sir, we have to school buses how to find the kmpl and litters amount can you do one video please

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

      Sure.. i will publish a video on your topic shortly 😊

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

      @@DeepakEduWorld thank you sir... How to kilometers and diesel expanses and opening and closing diesel after filling diesel how we have in litters and ruppes

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

      Hi sir I'm waiting for video on diesel consumption

  • @ashusodhi5805
    @ashusodhi5805 4 дня назад +1

    agr cr or Dr ki entry ko ik sath calculate krna ho to kaise hoga??

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

    Ms Word Excel, Powerpnt ki Keyboard shortcut ka video banao plz Sir

  • @onlineparvez
    @onlineparvez 8 месяцев назад

    Great

  • @utkarshsrivastava2336
    @utkarshsrivastava2336 2 года назад +8

    Sir Cash Balance ka Formula Wrong Hai opening Balance + Credit - Debit hoga Sir 🙏🙏 Payment Dr. Side Jayega Na Ki Cr. Side

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

      Bhai Cashbook hai passbook nahi Jo debit se amount deducted ho gyi 😆😆😎😎🤗🔥🔥

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

    Basic info... Kindly upgrade to advance excel

  • @Shoukat-od7lf
    @Shoukat-od7lf 2 года назад +1

    Sir please balance sheet k baad k bad lager bhe bana dain

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

    Can you please build excel sheet for stock market

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

    thank you

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

    how to share printer with another computer sir video banao

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

    Hi, in this same format of excel can you add different bank account. if we select sbi bank in drop down in source money. Like money was debited from sbi for House Rent, then the balance sbi account need to know that.
    Sbi have ₹20000, icici have ₹10000 rent paid from sbi ₹5000 then the balance of sbi ₹15000

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

    Hello All, There is a mistake in Column Title. Swap the Debit and Credit Column name

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

    Sir ms Excel me QR code kaise generate hota h please ek video espe bhi bana dijiye

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

    Video sahi he lekin apne cash balance me credit amount add hota he or debit amount less hota he

  • @mdfarokh
    @mdfarokh Месяц назад +1

    How to add Cash in Hand or Advance payment

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

    best

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

    Best

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

    How are you, I hope you are well. I have already messaged you in the comments that you would be kind enough to make a video on POS software.

  • @nandkishor869
    @nandkishor869 17 дней назад +1

    Please correct yourself about debit and credit

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

    Very nice thanks

  • @bhautiqkodinariya7760
    @bhautiqkodinariya7760 Год назад +50

    Bro pehle aap credit debit sikh lo

  • @prince-68818
    @prince-68818 2 года назад +5

    Without if condition, we use only formula in credit balance then answer will be same. Like current credit balance = last credit balance + current debit - current credit. Because Excel automatically assume blank cell as zero value. Sorry sir, Then why we use if condition. Don't make complexity. Use simple formula.

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

    Ye debit aur credit ka yahi to matlab hota hai ki debit mai to dukandaar ne humse maal lekar paise nahi diye hai aur credit mai jo humare pass aaya hai

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

    Telly prime per vidio banaye