सर ने सही लिखा है भाई...आप एक बार एकाउंटिंग अच्छे से पढ़ लो तो समझ में आ जायेगा। मुझे पता है आप ऐसा क्यों बोल रहे हैं... क्योंकि जब हमारे खाते में पैसा आता है तो क्रेडिट लिखा होता है, जबकि सर ने यहाँ ख़र्च को क्रेडिट बताया है...😀 पहले मुझे भी यही डाउट था , लेकिन अब नहीं है। सर ने जो लिखा है, वो सही है...👍
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😂
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.
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
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.
@@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
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.
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.
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.
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
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
क्या बात है गुरु जी आप धन्य हो 👍👍👍👍🙏🙏🙏🙏
Brother ye kis bank ka passbook hai interest rate add nahi hota hai
Iss formula sai interest rate add hoga aap he bolye bank passbook Mai interest v update hota hai
Uska kya formula hoga oh bolye brother
सर जी, आप बहुत ही साधारण पूर्वक व अच्छे से समझाते है। जिससे आराम से समझ में आ जाता है। धन्यवाद।
THANK YOU SIR JI AAP KE VIDEO SE MERI MADAD HO GAY THNQ ONCE AGAIN
Namaste sir, mein appka her video dekhata hun, bahut help full hai. Thank you sir you are great sir
आप बहुत अच्छा समझाते है सर बिना समय बर्बाद किये😊
I Love Your That Thing That You Provide Training Sheets With Your Video It Makes People Life Easy 💖💖💖💖💖💖
Hello All, There is a mistake in Column Title. Swap the Debit and Credit Column name
isse achi toh simple way m maine bna di
Video was nice, But you should write DEBIT in the cell where you typed CREDIT & vice-versa :)
it makes confusion
Aapki sahi videos usefull hoti h
Sir bahut achha lesson tha
Sir Your teaching is awsome.But here you have written credit in place of debit and debit in place of credit.
सर ने सही लिखा है भाई...आप एक बार एकाउंटिंग अच्छे से पढ़ लो तो समझ में आ जायेगा। मुझे पता है आप ऐसा क्यों बोल रहे हैं... क्योंकि जब हमारे खाते में पैसा आता है तो क्रेडिट लिखा होता है, जबकि सर ने यहाँ ख़र्च को क्रेडिट बताया है...😀 पहले मुझे भी यही डाउट था , लेकिन अब नहीं है। सर ने जो लिखा है, वो सही है...👍
Bani statment me chalta wo system jo ap bolte....sir is right
Bahut jabarjasti sir g
Tq so much sir ❤😊😊😊
In debit column you should to write credit and vice versa.
Thank you brother, since I was the video I was confused as I am commerce graduate. Anyways that we can figure it out
@@hbp7633 Thank you
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😂
gazab ka samjhate ho bhai
Bahut hi most Vedio Banaya hai Cashier k liye bahut hi Kam Ka hai.... Thank you Deepak Jiii.....
Super Baiya
Thanks you so much sir🎉❤😊
Sir g simple formula use kartai toh bhoot bariya hota
Good sir plz plz plz plz plz dashboard ki series ko bhe continue rakhe plz we are very more need.
Very nice.....
Thank you very much Sir 😁👍🏻.
Greate sirjee...
NICE WORK ....................
वाह वाह वाह
THNXX FOR EXCEL VIDEO
Very good, Deepak Bhai.
@DeepakEduWorld Bhai, Excel me "automatic invoice creation + pdf saving + keeping the database" par video banaiye... 🙏🙏
amazing video. deep like to you
Super sir
Thanks Deepak Sir 🙏
Thank You Sir 😊
Very good
Thank you so much Sir.💐💐💐 this is very Helpful for me.
Very useful information
Very knowledgeable video sir
Thank you sir!!
Love from Pakistan ♥️🙌
GReat bhai
Your videos are very helpful for me. Thanks a lot
वाह सही
Thanks for the video
Nice bro❤
Good work sir
Thnks sir
Thanks ❤
Love you sir
Great knowledge sir❤
Sir banking me jeetne bhi works hote hai uspe bhi video banayiye 🙏
Made my life easy😍
Nice one video sir
Thank sir for the tutorial
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.
Great 👍👍👍👍
That was nice . Thanks bro
GOOD
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
Thanks bro 🙏
Excellent sir 👌👌👍
Thank you sir for you this lesson
Great sir g
thank you
Very nice sir
Very nice ...Thank you ..
Best
Deepak Sir Google Drive ka Complete Tutorial banao Plz Sir
Nice sir
Amazing...
Great
Ye tou simple sun k formulay sa bho hoskta ha
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
Sir please balance sheet k baad k bad lager bhe bana dain
Bro please make a video on Microsoft power bi
best
Date, description, credit, commission, expenses,cash balance..... Iska formula dikhye na sir please 🙏
Bhaiya video to aaacchi hai par invoice kaat ke aur parchi number bhi aaajaye aesa kuch ho jaye
Sir 1500rs mange the ye karne ke liye apke vidio me bcha liye mere pese
Deepak sir yeh hum without If or and se bhi kar sakte hai, sirf plus or minus se
sir please post the vedio for how to maintain petty cash management for every month automatically
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.
Basic info... Kindly upgrade to advance excel
how to share printer with another computer sir video banao
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
Sure.. i will publish a video on your topic shortly 😊
@@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
Hi sir I'm waiting for video on diesel consumption
Can you please build excel sheet for stock market
Video sahi he lekin apne cash balance me credit amount add hota he or debit amount less hota he
Sir ms Excel me QR code kaise generate hota h please ek video espe bhi bana dijiye
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.
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.
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.
Telly prime per vidio banaye
❤❤❤❤❤❤
Ms Word Excel, Powerpnt ki Keyboard shortcut ka video banao plz Sir
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.
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
Debit and Creadit me Mistake hai
Creadit means Plus and Debit Means Minus
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
Hide Vali Row ko Retuns Kaise Laye
How to add Cash in Hand or Advance payment
Opening balance debit Nehi hota hei bro... credit balance hota hei
Sir mera data hai aap us ke liye bhi ek sheet bana sakte ho
Formula sahi hai lekin bhai account concept ki apne watt laga di because expenses always debit
Exce mai tally ki tarah voucher kese banaye