How to Create Debit and Credit Account Ledger in Microsoft Excel | Debit and Credit in Excel

Поделиться
HTML-код
  • Опубликовано: 3 фев 2022
  • In this video we will learn to Create Business Debit and Credit Account Ledger in Microsoft Excel step by step.
    #debitandcredit
    #debit_and_credit_sheet_in_excel
    #excel_debit_credit
    #studyspan
    Music: Outside
    Musician: @iksonmusic
    Thank you
  • НаукаНаука

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

  • @soumyamodak786
    @soumyamodak786 Год назад +31

    Income & Gain is Credit
    All Expenses is Debit

    • @imarslanash7098
      @imarslanash7098 4 месяца назад +1

      YAHI MA KAHNY WAla tha is ny ghlt guide kiya ha

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

      Are accounts me alag hota h

    • @shahaaqib6904
      @shahaaqib6904 9 дней назад

      Expenses and losses are debited while income and gains are credited .

  • @ss73pk
    @ss73pk 4 месяца назад +21

    Dear don't misguide, all expenses are debit. Please study the accounting rules.

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

      That’s banking account concept isn’t it
      As per account debit what comes
      Credit what goes out thats what we studied right

    • @khanafrina1176
      @khanafrina1176 29 дней назад

      Debit all the expenses
      Credit all the incomes
      Golden rule remember that 😅​@@amrdad7653

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

    Excellent tutorial vlog!

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

    Super bahot acha kam mera kam asan krdia heav an nice life thank you

  • @ImranKhan-km6zw
    @ImranKhan-km6zw 9 месяцев назад +1

    Thank you sir aap ki wajah se mujhe excel par ledge maintain karna agya

  • @rimsharazzaq1214
    @rimsharazzaq1214 Год назад +5

    very impressively mentioned every point. thanks its really useful and helped me alot

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

    fascinating upload StudySpan. I shattered the thumbs up on your video. Always keep up the exceptional work.

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

    sir , your are very good teacher , nice and knowledge able video

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

    Sir Dil Garden Garden ho gya❤❤❤❤

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

    Great knowledge we earn day by day. That's why o subscribed your channel.

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

    Excellent video....so very very nice... Thank you sir

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

    Bro I am from Hyderabad very good explanation for those who don't know ms excel for beginners it hlp alot thank u so much

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

    Thank you! You helped me with exactly what I needed :)

  • @user-lo4is8jh9j
    @user-lo4is8jh9j Год назад +9

    Sir Income increase then records in the Credit Sides. and Expenses Increses then records Debits Sides. Please reads role of Debits & Credits Rules accordibg to the International Accounting Standatds (IFR).

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

    Thank you so much you helped me so much love you bro from Africa Mozambique

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

    Thank you so much you solved my problem otherwise i need to look for website providing conversion

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

    Bahut achhe se aap samjhate hai sir thanks you so much

  • @khaksarali1990
    @khaksarali1990 9 месяцев назад +7

    Income and Expenses is Nominal Account and in Nominal acount rules Expenses is Debit and income is credits, any budy explain this topic ❤

  • @Armankhan-be9zk
    @Armankhan-be9zk 2 года назад +1

    VERY EASY THAN OTHER VIDEO. THANK YOU BRO

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

    Thank you sir❤❤

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

    Thank you sir, it's very easy process

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

    Thank you sir for information 🌼🙏🙏🌼

  • @killergaming2.082
    @killergaming2.082 Год назад

    Its really a practice video nice sir

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

    Sir thank you your method is easy

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

    Wahh bhai mene apki awaz k sath sath bnaya ...tnx

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

    Great Video.... Very informative ❤️👍🏻

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

      Abe , wo galat bata rha hai , sabka job le dubega ye bhaiya 😂😂😂

  • @dipendrathapamagar1318
    @dipendrathapamagar1318 2 года назад +13

    Entry he has done of debit and credit are just opposite..
    Dr.All expenses and loses
    Cr.All incomes and gains

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

    Super and Perfect...

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

    Thanks sir ji achi lagi video

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

    Thank you so much 😍😍❣️❣️

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

    Very helpful bro!

  • @ayaz0316
    @ayaz0316 7 дней назад

    Thanks very helpful 👍👍👍

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

    Thank you sir!!

  • @5minuteconcepts694
    @5minuteconcepts694 2 года назад

    what to say more. just love youu 🥰🥰🥰

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

    good bro thank you so much....

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

    NICE 👍

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

    Thanku for video

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

    Excellent knowledge

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

    Thank you man

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

    Thak you so much ♥️

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

    V Nice video

  • @ehteshamshah
    @ehteshamshah 2 года назад +38

    As we study Expense is on Debit side

    • @ravishrestha8505
      @ravishrestha8505 Год назад +12

      According to journal rules, expense is on debit side,but in ledger it is always opposite.

    • @diwarspiro6304
      @diwarspiro6304 Год назад +5

      This table is for cash account so income is on debit side and expense on credit side

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

      If both are debit then what is credit

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

      Excuse me sir sir kindly reply me
      😢

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

      Income and Expenses is Nominal Account and in Nominal acount rules Expenses is Debit and income is credits, any budy explain this topic ❤

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

    Very nice

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

    Sir good vedio for freshers

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

    Wow..thank u

  • @DaoudKhan-vs7ct
    @DaoudKhan-vs7ct 8 месяцев назад

    Very nice work ❤❤❤❤❤

  • @riobhutia9116
    @riobhutia9116 4 месяца назад +1

    Thank you so much

  • @528tarot
    @528tarot Год назад +1

    General ledger sa pahlay excel pa journal entries ki spreadsheet or bad main trial balance banana zarori ha ? Ya ye sheet kafi hoti ha for making financial statements like income statement and balance sheet.

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

    Credit what comes In and Debit what goes out....ye to fukrey movie me sikhya tha Laali ki mam ne.....but sir I really appyour efforts to educate us...bohot acchi video thi....Thanx

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

    Very good videos

  • @user-ho7hf8lp2j
    @user-ho7hf8lp2j Месяц назад +1

    Thankyou sir ❤❤

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

    Sir suggest a book for ms office(word, excel, and PPT and dadabase)

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

    Congratulation sir for 100k subscriber

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

    WELL DONE

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

    Thanks for sporting ❤

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

    Thanks bro...

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

    Exlent Sir

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

    Amazing

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

    BROTHER thank you very much this subscrition is gift to you by me for this information.

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

    ❤ thank you dear ❤

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

    Sir mana apki ya video 10 bar dakhi

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

    Very nice sir ji

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

    Thank you sir

  • @azrazr5467
    @azrazr5467 2 месяца назад +1

    Sir ham ya save kasa kry q k is app ma JB share kro to free trial ka option da rhy ha but share ni ho Ra na save ho Ra h

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

    Thanks ❤

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

    Boht hard

  • @user-xd7pz3ox1y
    @user-xd7pz3ox1y 7 месяцев назад

    Oh wow sir ❤

  • @FajarSafoora-ib8ze
    @FajarSafoora-ib8ze 7 месяцев назад

    thanks 👍😊

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

    Thank you

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

    ❤❤

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

    So super

  • @anwarhossain5056
    @anwarhossain5056 4 месяца назад +1

    THANKS

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

    great

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

    debit means expenses , credit means income

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

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

    Tnkuuuu tnkuuuu tnkuuuuu g

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

    Start se video banate ta k ap ne jo cells or rows banai hai wo bhi logo ko pata chal jata

  • @user-lg8ph8ne7k
    @user-lg8ph8ne7k Год назад

    NICE VIDEO

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

    Sir humble request to you
    Please online Bill kaishe kat te Hai & GST Bill. Please make a video for us.❤❤❤❤❤❤❤❤❤

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

      Kindly check out, on my channel. I have already upload a video on it

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

    Nominal A/C
    👇👇
    All Expenses and losses= Dr.
    All income and gain। =Cr.

  • @AzharKhan-yi2nr
    @AzharKhan-yi2nr 2 года назад

    nice

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

    Same sheet me how we can add another sheet debit and credit using another sheet date If I used debit then auto catch those sheet date and same for credit also

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

    Sir according to accounting rule all expenses are dr and all incomes are cr tu apne keu expenses ku cr kiya or income ku dr please sir boliya??????

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

    Hey bro some mistake, that is all the expenses & losses as shown on the debit side. And the same time incomes & gains as shown on the credit side

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

    Good

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

    Good vedio

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

    Sir, Very good video .One small doubt. Is Income comes under debit or credit ???

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

      In accounts Income always comes under Debit

    • @alizaidi8326
      @alizaidi8326 2 года назад +6

      All incomes and gains are credit
      All expenses and losses are debit

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

      In personal database it's *Credit* bhai,
      But in accountancy it's debit, because in order to fund your account, the amount first need to deduct from your department account.

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

      This is Cash book Or Cash a/c features
      Accordingly which have entries

    • @ABHISHEK-237
      @ABHISHEK-237 Год назад

      @@Shashwata reason behind company and its owner, other employees have distinct entity ....so jo aapke liye income hai vo company ke liye expense hai or jo aapka expense hai isliye income dr. huya its a personal account from approach of traditional but company is a real account that's why ye huwa

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

    Sir Ek Microsoft Excel ka full video banao please

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

      I have already created a playlist on Microsoft Excel Tutorial. Kindly check out

  • @user-rj3sp4yo7p
    @user-rj3sp4yo7p 8 дней назад

    Thanks sir Tamara lidhe Mane aa aavadyu😢

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

    Sir udhar sale purchase karne pr kise dr. Or cr. Krna hai

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

    possible send excel google sheet so much good information

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

    Agar Mera Credit debit se zyada ho jaaye to balance mai minus result aayega to is case me Kya kia jae

  • @Waheedin
    @Waheedin 2 месяца назад +1

    Tq

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

    Income always credit hoti hey but expenses always debit hote h? Please check again n guide

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

      That is Nominal Acount ledger, in Nominal Acounts Debit are Expenses and Credit is Income ❤

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

    All expenses is debit balance and all income is credit balance .... So you should give attention on the point

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

    Same tarik may incom OR EXPENSE HOGA TYO KYA SAY GARINGE

  • @RAMNIWAS-oh8ml
    @RAMNIWAS-oh8ml Год назад

    सर जैसे हमारा bal CR मे आ रहा है तो हम cr मे से डेबिट घटाए या जोड़े या Bal Dr आएगा इसको आप manual Leger से बताए या dr मे से CR घटाए

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

    Sir excel ka pra full video banao sir piz 🙏

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

      I have already created a playlist on Microsoft Excel Tutorial. Kindly check out

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

    Sir income increase honay se credit hota hai
    Expense increase honay se debit hota hai
    Aap ne ulat kiya hai, kindly explain.

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

    Tx