सर ने सही लिखा है भाई...आप एक बार एकाउंटिंग अच्छे से पढ़ लो तो समझ में आ जायेगा। मुझे पता है आप ऐसा क्यों बोल रहे हैं... क्योंकि जब हमारे खाते में पैसा आता है तो क्रेडिट लिखा होता है, जबकि सर ने यहाँ ख़र्च को क्रेडिट बताया है...😀 पहले मुझे भी यही डाउट था , लेकिन अब नहीं है। सर ने जो लिखा है, वो सही है...👍
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
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.
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
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.
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.
@@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
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.
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
![Hunxho - Ball Forever [Official Video]](http://i.ytimg.com/vi/nki9ZTF9Uls/mqdefault.jpg)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/1.gif)
क्या बात है गुरु जी आप धन्य हो 👍👍👍👍🙏🙏🙏🙏
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
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
सर जी, आप बहुत ही साधारण पूर्वक व अच्छे से समझाते है। जिससे आराम से समझ में आ जाता है। धन्यवाद।
Video was nice, But you should write DEBIT in the cell where you typed CREDIT & vice-versa :)
it makes confusion
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 💖💖💖💖💖💖
THANK YOU SIR JI AAP KE VIDEO SE MERI MADAD HO GAY THNQ ONCE AGAIN
Very good, Deepak Bhai.
@DeepakEduWorld Bhai, Excel me "automatic invoice creation + pdf saving + keeping the database" par video banaiye... 🙏🙏
Aapki sahi videos usefull hoti h
आप बहुत अच्छा समझाते है सर बिना समय बर्बाद किये😊
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
Bahut hi most Vedio Banaya hai Cashier k liye bahut hi Kam Ka hai.... Thank you Deepak Jiii.....
Sir bahut achha lesson tha
Love from Pakistan ♥️🙌
Bahut jabarjasti sir g
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😂
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
Thank you very much Sir 😁👍🏻.
Good sir plz plz plz plz plz dashboard ki series ko bhe continue rakhe plz we are very more need.
Tq so much sir ❤😊😊😊
Thanks you so much sir🎉❤😊
Very knowledgeable video sir
Very nice.....
NICE WORK ....................
Super Baiya
Thank you so much Sir.💐💐💐 this is very Helpful for me.
Thanks Deepak Sir 🙏
Very useful information
Super sir
Deepak sir yeh hum without If or and se bhi kar sakte hai, sirf plus or minus se
Sir banking me jeetne bhi works hote hai uspe bhi video banayiye 🙏
Sir g simple formula use kartai toh bhoot bariya hota
Made my life easy😍
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.
That was nice . Thanks bro
gazab ka samjhate ho bhai
amazing video. deep like to you
Your videos are very helpful for me. Thanks a lot
Greate sirjee...
Good work sir
Great knowledge sir❤
Thank sir for the tutorial
Thank You Sir 😊
Very good
Thank you sir!!
वाह वाह वाह
Bhaiya video to aaacchi hai par invoice kaat ke aur parchi number bhi aaajaye aesa kuch ho jaye
Excellent sir 👌👌👍
THNXX FOR EXCEL VIDEO
Great 👍👍👍👍
Nice bro❤
Thanks for the video
Thank you sir for you this lesson
Very nice ...Thank you ..
Nice one video sir
GReat bhai
Sir please balance sheet k baad k bad lager bhe bana dain
वाह सही
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
Thnks sir
Love you sir
Bro please make a video on Microsoft power bi
Deepak Sir Google Drive ka Complete Tutorial banao Plz Sir
Great sir g
Thanks ❤
Amazing...
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
Thanks bro 🙏
Very nice sir
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.
GOOD
sir please post the vedio for how to maintain petty cash management for every month automatically
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.
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
Video sahi he lekin apne cash balance me credit amount add hota he or debit amount less hota he
Can you please build excel sheet for stock market
Date, description, credit, commission, expenses,cash balance..... Iska formula dikhye na sir please 🙏
Sir Cash Balance ka Formula Wrong Hai opening Balance + Credit - Debit hoga Sir 🙏🙏 Payment Dr. Side Jayega Na Ki Cr. Side
Bhai Cashbook hai passbook nahi Jo debit se amount deducted ho gyi 😆😆😎😎🤗🔥🔥
Best
Nice sir
thank you
Sir wo formula lagane ke baad dragon kiya toh woh nhi ho rha h..???
Give any suggest plz...
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.
Ye tou simple sun k formulay sa bho hoskta ha
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.
Sir mera data hai aap us ke liye bhi ek sheet bana sakte ho
Great
Sir ms Excel me QR code kaise generate hota h please ek video espe bhi bana dijiye
Sir hum ne pocha tha k excel me print kese krte hain
Agr koi salary sheet mark sheet ya aur koi data print krna ho
To kese kre?
do you have any videos abt lookup formula?
Formula sahi hai lekin bhai account concept ki apne watt laga di because expenses always debit
Sir could you please make the same in google sheets with some changes .
Basic info... Kindly upgrade to advance excel
bank se ..wallet se...paytm se deduct kaise kare isi me
Ms Word Excel, Powerpnt ki Keyboard shortcut ka video banao plz Sir
best
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
If I Filter will it work?
ENTRY JYADA HO TO BALANCE NEXT SHEET PE TRANSFER KAISE KARAN...