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

Ғылым және технология

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 Жыл бұрын

    Income & Gain is Credit All Expenses is Debit

  • @imarslanash7098

    @imarslanash7098

    4 ай бұрын

    YAHI MA KAHNY WAla tha is ny ghlt guide kiya ha

  • @tanisharajput3263

    @tanisharajput3263

    3 ай бұрын

    Are accounts me alag hota h

  • @shahaaqib6904

    @shahaaqib6904

    5 күн бұрын

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

  • @KeyserTheRedBeard
    @KeyserTheRedBeard2 жыл бұрын

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

  • @ss73pk
    @ss73pk4 ай бұрын

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

  • @amrdad7653

    @amrdad7653

    Ай бұрын

    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

    25 күн бұрын

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

  • @syedqudratullah4344
    @syedqudratullah43442 жыл бұрын

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

  • @rahul_mangrudiya
    @rahul_mangrudiya2 жыл бұрын

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

  • @user-lo4is8jh9j
    @user-lo4is8jh9j Жыл бұрын

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

  • @shayar_truptin147
    @shayar_truptin147 Жыл бұрын

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

  • @mridul1608
    @mridul16082 жыл бұрын

    Excellent tutorial vlog!

  • @ImranKhan-km6zw
    @ImranKhan-km6zw9 ай бұрын

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

  • @happywithinXO
    @happywithinXO6 ай бұрын

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

  • @rimsharazzaq1214
    @rimsharazzaq1214 Жыл бұрын

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

  • @khaksarali1990
    @khaksarali19909 ай бұрын

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

  • @deeppedia69
    @deeppedia692 жыл бұрын

    Sir Dil Garden Garden ho gya❤❤❤❤

  • @muhammadjaffar2847
    @muhammadjaffar28472 жыл бұрын

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

  • @familiapiratamcb6490
    @familiapiratamcb64905 ай бұрын

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

  • @ayaz0316
    @ayaz03162 күн бұрын

    Thanks very helpful 👍👍👍

  • @dipendrathapamagar1318
    @dipendrathapamagar13182 жыл бұрын

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

  • @shibnathmistry9486

    @shibnathmistry9486

    2 жыл бұрын

    I thought the same

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Exactly

  • @priyankakuntla7500
    @priyankakuntla75002 жыл бұрын

    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

  • @528tarot
    @528tarot Жыл бұрын

    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.

  • @liongaming6052
    @liongaming605211 ай бұрын

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

  • @ANDROMEDASEA
    @ANDROMEDASEA2 жыл бұрын

    Bahut achhe se aap samjhate hai sir thanks you so much

  • @azrazr5467
    @azrazr54672 ай бұрын

    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

  • @anuranjinrenju
    @anuranjinrenju Жыл бұрын

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

  • @riyanrn356

    @riyanrn356

    11 ай бұрын

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

  • @5minuteconcepts694
    @5minuteconcepts6942 жыл бұрын

    what to say more. just love youu 🥰🥰🥰

  • @sidckg5530
    @sidckg55302 жыл бұрын

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

  • @sivarao2733
    @sivarao27332 жыл бұрын

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

  • @rinabiswas5345
    @rinabiswas5345 Жыл бұрын

    Thank you sir, it's very easy process

  • @alicesunilchakmawounderfuldest
    @alicesunilchakmawounderfuldest2 жыл бұрын

    Thank you sir for information 🌼🙏🙏🌼

  • @killergaming2.082
    @killergaming2.082 Жыл бұрын

    Its really a practice video nice sir

  • @Armankhan-be9zk
    @Armankhan-be9zk2 жыл бұрын

    VERY EASY THAN OTHER VIDEO. THANK YOU BRO

  • @mirza1396
    @mirza1396 Жыл бұрын

    Sir thank you your method is easy

  • @m16chintu
    @m16chintu2 жыл бұрын

    Super and Perfect...

  • @shubhabarman5238
    @shubhabarman52382 жыл бұрын

    Thank you sir❤❤

  • @georgealfred5150
    @georgealfred5150 Жыл бұрын

    Very helpful bro!

  • @ranaakbar2993
    @ranaakbar2993 Жыл бұрын

    Thanku for video

  • @visheshaggarwal8229
    @visheshaggarwal8229 Жыл бұрын

    Thanks sir ji achi lagi video

  • @raheelamin1654
    @raheelamin16548 ай бұрын

    good bro thank you so much....

  • @karamkaand8775
    @karamkaand87752 жыл бұрын

    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

  • @tusharparihar2628
    @tusharparihar26287 ай бұрын

    Thank you so much 😍😍❣️❣️

  • @rheapeter9709
    @rheapeter9709 Жыл бұрын

    Thank you sir!!

  • @pranabdas4325
    @pranabdas43252 жыл бұрын

    Congratulation sir for 100k subscriber

  • @Malikvibes8
    @Malikvibes8 Жыл бұрын

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

  • @kartikverma7187
    @kartikverma7187 Жыл бұрын

    Thanks for sporting ❤

  • @swakharchowdhury1348
    @swakharchowdhury13482 жыл бұрын

    Wow..thank u

  • @subinagrg9971
    @subinagrg99712 жыл бұрын

    Thak you so much ♥️

  • @technicaldeepak919
    @technicaldeepak9192 жыл бұрын

    NICE 👍

  • @randolphkidze7709
    @randolphkidze7709 Жыл бұрын

    Thank you man

  • @DaoudKhan-vs7ct
    @DaoudKhan-vs7ct8 ай бұрын

    Very nice work ❤❤❤❤❤

  • @riobhutia9116
    @riobhutia91164 ай бұрын

    Thank you so much

  • @waheediqbalcheema
    @waheediqbalcheema2 жыл бұрын

    V Nice video

  • @atoztechnical8956
    @atoztechnical8956 Жыл бұрын

    Excellent knowledge

  • @ehteshamshah
    @ehteshamshah2 жыл бұрын

    As we study Expense is on Debit side

  • @ravishrestha8505

    @ravishrestha8505

    Жыл бұрын

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

  • @diwarspiro6304

    @diwarspiro6304

    Жыл бұрын

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

  • @ShahanAliKhan

    @ShahanAliKhan

    Жыл бұрын

    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 ❤

  • @user-ho7hf8lp2j
    @user-ho7hf8lp2jАй бұрын

    Thankyou sir ❤❤

  • @manojmoklaji6199
    @manojmoklaji6199 Жыл бұрын

    Sir good vedio for freshers

  • @puskarsharma2832
    @puskarsharma28322 жыл бұрын

    Same tarik may incom OR EXPENSE HOGA TYO KYA SAY GARINGE

  • @sandeshghadge691
    @sandeshghadge6917 ай бұрын

    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

  • @sdew7128
    @sdew71282 жыл бұрын

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

  • @armanahmad5829
    @armanahmad5829 Жыл бұрын

    Thanks bro...

  • @asimlatif1879
    @asimlatif18792 жыл бұрын

    Very nice

  • @Ankush_5620
    @Ankush_5620 Жыл бұрын

    Sir mana apki ya video 10 bar dakhi

  • @surendranaidu6588
    @surendranaidu6588 Жыл бұрын

    Thank you sir

  • @parveenbhatia3346
    @parveenbhatia33462 жыл бұрын

    Very good videos

  • @usamamuzaffar4438
    @usamamuzaffar44382 жыл бұрын

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

  • @mahisuper7284
    @mahisuper72842 жыл бұрын

    debit means expenses , credit means income

  • @muneeralikhan5504
    @muneeralikhan55042 жыл бұрын

    Exlent Sir

  • @yogeshsonar77
    @yogeshsonar778 ай бұрын

    WELL DONE

  • @sayediftekharraheman6324
    @sayediftekharraheman63244 ай бұрын

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

  • @sawerkhan3434
    @sawerkhan3434 Жыл бұрын

    Amazing

  • @Ayub395
    @Ayub395 Жыл бұрын

    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 ❤

  • @anwarululoom9159
    @anwarululoom91597 ай бұрын

    Thanks ❤

  • @jeetdutta2037
    @jeetdutta20372 жыл бұрын

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

  • @ShrizanThapa
    @ShrizanThapa10 ай бұрын

    ❤❤

  • @amritchoudhary7239
    @amritchoudhary7239 Жыл бұрын

    Very nice sir ji

  • @user-xd7pz3ox1y
    @user-xd7pz3ox1y7 ай бұрын

    Oh wow sir ❤

  • @azrazr5467
    @azrazr54672 ай бұрын

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

  • @mohammedimam3605
    @mohammedimam3605 Жыл бұрын

    How i will use the formula in mobile. I tried many times this not work

  • @JimGarments
    @JimGarments Жыл бұрын

    Thank you

  • @FajarSafoora-ib8ze
    @FajarSafoora-ib8ze7 ай бұрын

    thanks 👍😊

  • @shadabtechyt9792
    @shadabtechyt9792 Жыл бұрын

    Mujhe lgta hai sir aap ne debit ki jagah credit aur credit ki jagah debit likh diya h

  • @sksohan8177
    @sksohan817710 ай бұрын

  • @sujoydeysarkar6495
    @sujoydeysarkar64952 күн бұрын

    Sir journal wise hum entry kaise kare

  • @MSHTRICHY
    @MSHTRICHY2 жыл бұрын

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

  • @StudySpan

    @StudySpan

    2 жыл бұрын

    In accounts Income always comes under Debit

  • @alizaidi8326

    @alizaidi8326

    2 жыл бұрын

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

  • @Shashwata

    @Shashwata

    2 жыл бұрын

    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 жыл бұрын

    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

  • @anwarhossain5056
    @anwarhossain50564 ай бұрын

    THANKS

  • @user-rj3sp4yo7p
    @user-rj3sp4yo7p4 күн бұрын

    Thanks sir Tamara lidhe Mane aa aavadyu😢

  • @aslamwadani4744
    @aslamwadani47444 ай бұрын

    ❤ thank you dear ❤

  • @kaliantvurdupoetry2593
    @kaliantvurdupoetry25932 жыл бұрын

    How expances is crdt

  • @mubashirrunyal9312

    @mubashirrunyal9312

    Жыл бұрын

    Asset has debit balance nd liability has credit balance

  • @inamullah276
    @inamullah2762 жыл бұрын

    Tnkuuuu tnkuuuu tnkuuuuu g

  • @narendrachindarkar6671
    @narendrachindarkar66712 жыл бұрын

    Boht hard

  • @deeppedia69
    @deeppedia692 жыл бұрын

    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

  • @joydiplnstrumentalmusic8594
    @joydiplnstrumentalmusic85942 жыл бұрын

    Debit ka ghar ka ammount credit per hoga.. Expense kaise credit hoga.

  • @RakeshKumar-ce1pb
    @RakeshKumar-ce1pb Жыл бұрын

    Opening balance ke sath formula kese lagayege

  • @vijayingole5233
    @vijayingole5233 Жыл бұрын

    So super

  • @CommerceTalks
    @CommerceTalks7 ай бұрын

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

  • @RAMNIWAS-oh8ml
    @RAMNIWAS-oh8ml Жыл бұрын

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

  • @abinkm3558
    @abinkm35584 ай бұрын

    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
    @onkarsutrave84932 жыл бұрын

    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

  • @rejaneeshraj
    @rejaneeshraj9 ай бұрын

    Bro my problems is loan amount without interest -5327 to500 weekly my expenses calculator

  • @abdulhameedakhtarqureshi3007
    @abdulhameedakhtarqureshi300710 ай бұрын

    possible send excel google sheet so much good information

  • @manzoorali2832
    @manzoorali2832 Жыл бұрын

    great

  • @kaliantvurdupoetry2593
    @kaliantvurdupoetry25932 жыл бұрын

    Expances Dr ma gotta ha ya ctedt ma

Келесі