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

Поділитися
Вставка

КОМЕНТАРІ • 196

  • @soumyamodak786
    @soumyamodak786 2 роки тому +44

    Income & Gain is Credit
    All Expenses is Debit

    • @imarslanash7098
      @imarslanash7098 9 місяців тому +2

      YAHI MA KAHNY WAla tha is ny ghlt guide kiya ha

    • @tanisharajput3263
      @tanisharajput3263 9 місяців тому +2

      Are accounts me alag hota h

    • @shahaaqib6904
      @shahaaqib6904 5 місяців тому +1

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

  • @ImranKhan-km6zw
    @ImranKhan-km6zw Рік тому +5

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

  • @syedqudratullah4344
    @syedqudratullah4344 2 роки тому +2

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

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

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

  • @ayazsultan-n2h
    @ayazsultan-n2h Рік тому +17

    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).

  • @bantiguchait9336
    @bantiguchait9336 14 днів тому +1

    Thanks for this video it is useful for me.... ❤

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

    Sir Dil Garden Garden ho gya❤❤❤❤

  • @familiapiratamcb6490
    @familiapiratamcb6490 11 місяців тому

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

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

    Bahut achhe se aap samjhate hai sir thanks you so much

  • @gagandeepkaur9942
    @gagandeepkaur9942 5 місяців тому +1

    Super dopeer idea thank you sir❤

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

    Thanks sir ji achi lagi video

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

    Thank you sir, it's very easy process

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

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

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

    Sir mana apki ya video 10 bar dakhi

  • @ehteshamshah
    @ehteshamshah 2 роки тому +48

    As we study Expense is on Debit side

    • @ravishrestha8505
      @ravishrestha8505 2 роки тому +16

      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 Рік тому +4

      If both are debit then what is credit

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

      Excuse me sir sir kindly reply me
      😢

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

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

  • @muhammadjaffar2847
    @muhammadjaffar2847 2 роки тому +2

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

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

    Sir thank you your method is easy

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

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

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

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

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

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

    good bro thank you so much....

  • @mridul1608
    @mridul1608 2 роки тому +4

    Excellent tutorial vlog!

  • @killergaming2.082
    @killergaming2.082 2 роки тому

    Its really a practice video nice sir

  • @Rooneygameing65
    @Rooneygameing65 5 місяців тому

    Waoooo sirr v nice 👍👍👍👍👍

  • @rahul_mangrudiya
    @rahul_mangrudiya 2 роки тому +2

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

  • @Dawood-Little-StoryWorld
    @Dawood-Little-StoryWorld Рік тому

    Very nice work ❤❤❤❤❤

  • @rimsharazzaq1214
    @rimsharazzaq1214 2 роки тому +5

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

  • @worldentertaiment2690
    @worldentertaiment2690 3 місяці тому +1

    Thanks brother for sharing

  • @anuranjinrenju
    @anuranjinrenju 2 роки тому +2

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

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

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

  • @ålåãrhah
    @ålåãrhah 4 місяці тому +2

    bhi super ho giya great 👍🫀

  • @KuldeepRekhaKuldeepRekha
    @KuldeepRekhaKuldeepRekha 3 місяці тому +2

    Thx sir ❤

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

    Thank you so much 😍😍❣️❣️

  • @dipendrathapamagar1318
    @dipendrathapamagar1318 2 роки тому +14

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

  • @ayaz0316
    @ayaz0316 5 місяців тому +1

    Thanks very helpful 👍👍👍

  • @AmitShukla-j7j
    @AmitShukla-j7j 6 місяців тому +1

    Thankyou sir ❤❤

  • @happymind1418
    @happymind1418 22 дні тому +1

    income credit me hogi debit me nahi sir baaki apne acha samjhya but iss confusion ko dur kare taaki jinko rule ni pta accounting ke wo galt na kare

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

    Thanku for video

  • @PrabhjotKaur-b3y
    @PrabhjotKaur-b3y Рік тому

    Oh wow sir ❤

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

    Sir good vedio for freshers

  • @Armankhan-be9zk
    @Armankhan-be9zk 2 роки тому +1

    VERY EASY THAN OTHER VIDEO. THANK YOU BRO

  • @aslamwadani4744
    @aslamwadani4744 10 місяців тому

    ❤ thank you dear ❤

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

    • @learnandshare426
      @learnandshare426 3 місяці тому

      Under real account: Rule - Debit what comes in, Credit what goes out😅

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

    V Nice video

  • @KeyserTheRedBeard
    @KeyserTheRedBeard 2 роки тому +2

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

  • @shubhabarman5238
    @shubhabarman5238 2 роки тому +2

    Thank you sir❤❤

  • @5minuteconcepts694
    @5minuteconcepts694 2 роки тому

    what to say more. just love youu 🥰🥰🥰

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

    Congratulation sir for 100k subscriber

  • @theworldbeauty29
    @theworldbeauty29 Рік тому +2

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

  • @asimlatif1879
    @asimlatif1879 2 роки тому +2

    Very nice

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

    Very helpful bro!

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

    Excellent knowledge

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

    Thank you sir for information 🌼🙏🙏🌼

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

    Thanks for sporting ❤

  • @riobhutia9116
    @riobhutia9116 9 місяців тому +1

    Thank you so much

  • @528tarot
    @528tarot 2 роки тому +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.

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

    WELL DONE

  • @FajarSafoora-ib8ze
    @FajarSafoora-ib8ze Рік тому

    thanks 👍😊

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

    Super and Perfect...

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

    Thak you so much ♥️

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

    Thanks ❤

  • @Vimalsinhparmar-n2n
    @Vimalsinhparmar-n2n 5 місяців тому +1

    Thanks sir Tamara lidhe Mane aa aavadyu😢

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

    Very nice sir ji

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

    Boht hard

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

    Thank you sir!!

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

    So super

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

    Good vedio

  • @mahisuper7284
    @mahisuper7284 2 роки тому +2

    debit means expenses , credit means income

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

    NICE VIDEO

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

    Thank you sir

  • @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 2 роки тому

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

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

    Exlent Sir

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

    Thank you man

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

    Thanks bro...

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

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

    NICE 👍

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

    Wow..thank u

  • @anwarhossain5056
    @anwarhossain5056 9 місяців тому +1

    THANKS

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

    Very good videos

  • @azrazr5467
    @azrazr5467 7 місяців тому +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

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

    Tnkuuuu tnkuuuu tnkuuuuu g

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

    great

  • @MohammadAmransahak
    @MohammadAmransahak 4 місяці тому

    according to the International Accounting Standards (IFR) When liabilities, income, equity increase there is Credit when they decrease there is Debit.
    When Asset and expense increase there is Debit when they decrease there is Credit.
    if i am not right then please guide me sir

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

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

    Thank you

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

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

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

    Amazing

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

    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

  • @abinkm3558
    @abinkm3558 9 місяців тому

    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

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

  • @khanbanaras5145
    @khanbanaras5145 4 місяці тому +1

    good

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

    Good

  • @sayediftekharraheman6324
    @sayediftekharraheman6324 9 місяців тому

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

  • @Ayub395
    @Ayub395 2 роки тому +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 ❤

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

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

  • @vinodsrivastava9144
    @vinodsrivastava9144 Рік тому +6

    Please correct Credit is income and Debit is expenses

    • @RupeshAgrawal-s5h
      @RupeshAgrawal-s5h 3 місяці тому

      Debit all losses and expenses and credit all income and gain

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

  • @AzharKhan-yi2nr
    @AzharKhan-yi2nr 2 роки тому

    nice

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

  • @RakeshKumar-ce1pb
    @RakeshKumar-ce1pb Рік тому

    Opening balance ke sath formula kese lagayege

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

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

    • @learnandshare426
      @learnandshare426 3 місяці тому

      But in terms of ledger (cash account) its different. When you receive income in cash its recorded in the debit of ledger and vice versa.

    • @mdail3987
      @mdail3987 3 місяці тому

      @@learnandshare426 Revenue: Measures a company's ability to generate sales
      Income: Measures a company's ability to generate profits