Balance Sheet in Excel by CA. Pankaj Deshpande
FREE Tally Prime Course. Click the link below to enrol for free. www.indradhanuacademy.com/cou...
FREE course for business owners. Click below to enrol for free.
Business Owners ke 3 Chakravyuh
In my journey of last 21 years, I have observed some common problems with business owners.
1. Not able to withdraw sufficient money from business on regular basis.
2. Profit is on paper only and not in bank account
3. Not able to pay taxes on time.
These problems are the result of financial traps.
This course explains how a business owner is trapped into financial struggle and unable to manage the cash flow. This course also explains how to avoid these traps.
Business Owners Ke 3 Chakravyuh (indradhanuacademy.com)
About Indradhanu Academy :
Indradhanu Academy is a premium academy in Nagpur providing training to two types of people,
a. Aspiring Accounting Professionals
b. SME Business Owners
Courses for becoming an Accounting Professional :
We have premium training course (online as well as offline) for those who wish to become accounting professionals and start earning within 60 days. Following is the link for two courses for becoming an accounting professional.
Course for Business Owners :
SME businesses are the backbone of economy of our country. It is generally seen than any SME owner has to face lot of challenges on many fronts. Ultimately this leads to overall dis-satisfaction in personal as well as professional life of any SME business owners.
At Indradhanu Academy, we provide peace of mind to business owners by providing practical workable solutions using “Power of Accounting”.
We have a unique course for SME Owners as “sme to SME”.
“sme” stands for small and medium enterprise
“SME” stands for Systematically Managed Enterprise.
This course is extremely useful for moving towards Systematically Managed Enterprise. This course is one stop solution for achieving overall peace of mind in professional as well as personal life.
Click below to know more and buy the course.
sme to SME (indradhanuacademy.com)
Accounting Friend Lecture Series :
This is a weekly lecture series, free of cost for inner circle members only. Not for all. CA. Pankaj Deshpande and other experts conduct sessions for variety of topics every week for 45 minutes. Click the link below to know more and apply for registration.
www.indradhanuacademy.com/f/a...
To connect with CA. Pankaj Deshpande on social media
Instagram : capankajd
Linkedin : capankajd
Facebook : capankajd
This video explain how to quickly prepare a balance sheet in excel with proper formatting. This video explains basic rules about formatting of excel sheets.
Course For Accounting Professionals :
You can join our 3 days live online class "Learn & Earn ! Be an accounting professional " by clicking the link below.
imjo.in/z45wfX
This is a very useful class for those who wants to start their career as an accounting professional and start earning within 30 days. You will learn Fundamentals of Accounting, How accounting can be done even without Debit and Credit. What it takes to join accounting profession, how to start the career, what are the advantages of Accounting Profession, Why it is the best suited profession for females and many more such aspects.
Click here to register for next live class.
imjo.in/z45wfX
Course for Business Owners :
We teach financial wisdom to business owners. With financial wisdom, a business owner can growth their profits by taking RIGHT financial business decisions at RIGHT point of time. Using financial wisdom, a business owner can reduce losses and leakages in business. How ? click on the link below to know more.
indradhanu.info/Welcome/cours...
Пікірлер: 201
Thank you so much sir 🙏
Thank you very much for this edifying content
@IndradhanuAcademy
2 жыл бұрын
Welcome ! You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. Click here to register for free. accountingfriend.indradhanu.info
Thanks sir bahut acha video banaya hai
Thanks a lot
MAAN GAYE GURU.... GOOD TEACHING KNOWLEDGE
HELPFUL VIDEO. THANKS A LOT
@IndradhanuAcademy
3 жыл бұрын
Thank you for your feedback. You can connect with me live in Accounting Friend Lecture Series. Please register at accountingfriend.indradhanu.info
Thank You Sir
फर्म का बेलेंस सीट बेहतरीन तरीके से समझाया है। धन्यवाद सर, हमें बिना लाभ वाले अपार्टमेंट सोसायटी के बेलेंस सीट की जानकारी देंगे।
@IndradhanuAcademy
3 жыл бұрын
जरूर.
Very very very thanks sir☺☺😃🙏🙏🙏 & good job 👏🏼👏🏼👌🏻👌🏻👍🏼
@IndradhanuAcademy
3 жыл бұрын
Your support motivates me to create more such videos.
Thank you so much sir
Thank you so much sir 👍👍👍👍
@IndradhanuAcademy
4 жыл бұрын
I am happy to know that I am able to add some value to your knowledge.
Thanku so much sir
@IndradhanuAcademy
Жыл бұрын
Thank you🙏 very much for your feedback. You can connect with me live in accounting friend sessions. Also you can get free tally course without any conditions. Please click here to enroll. www.indradhanuacademy.com/courses/tally-prime-for-freshers
Nice video sir Thank You for your guidance
@IndradhanuAcademy
2 жыл бұрын
Welcome
Thank Q so much
@IndradhanuAcademy
Жыл бұрын
Welcome
Thanks sir bhut acha samja rhe ho app
@IndradhanuAcademy
Жыл бұрын
Welcome and thank you for your support. You can connect with me live tomorrow morning at 11 am on 4th Dec. 22. I am conducting a live webinar on the topic "how to effectively conduct stock audit". Please click the link below and register for free. bit.ly/3ARvkco If you are viewing this after 4th Dec. 22, click here to register for accounting friend lecture series. We have conducted 111 sessions on 111 different topics. Click below and register for free. You will receive all invitations I'm future accountingfriend.indradhanu.info
Thanks sir very nice video
Thank u so much sir❤️❤️❤️
@IndradhanuAcademy
3 жыл бұрын
Welcome
Thanks for helping
@IndradhanuAcademy
3 жыл бұрын
Most welcome
Sir ji process kya h balance sheet bnana ka . Links kasa Krna hota h excel m . Legal, trial balance , notes, balance sheet
Thank you show much sirji
@IndradhanuAcademy
2 жыл бұрын
Welcome Usha ji ! You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. So far 97 sessions are completed. Click here to register for free. accountingfriend.indradhanu.info
very nice sir.i am very much oblidged to you for this class.
@IndradhanuAcademy
2 жыл бұрын
Thank you🙏. You can connect with me live in Accounting Friend lecture series. Click here to register for free. accountingfriend.indradhanu.info Today, it was session number 110
Very well explained. Keep it up
@IndradhanuAcademy
2 жыл бұрын
Thank you for your feedback. You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. So far 99 sessions are completed on 99 different topics. Now we are conducting a mega session no 100 on a very special topic. Please register on link below. accountingfriend.indradhanu.info
Tnk u sir bohut bar blnc sheet try kar raha ta aaj succs hogaya
@IndradhanuAcademy
2 жыл бұрын
Excellent ! You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. Click here to register for free. accountingfriend.indradhanu.info
Agar ham balance sheet banate h to creditor site ka amount debit site me dikhe to use kaha dalenge
Thank you sir
@IndradhanuAcademy
3 жыл бұрын
Most welcome. Please register at accountingfriend.indradhanu.info to connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am.
sir washing center balance sheet kaise banate hai
Thanku you so much sir. you teach in well manner and easiest way
@IndradhanuAcademy
3 жыл бұрын
Welcome
Thank u so much sir..bahot he easy way mein samjhaya aapne..🙏🙏
@IndradhanuAcademy
3 жыл бұрын
Thank you for your feedback.
@IndradhanuAcademy
3 жыл бұрын
You can attend weekly live sessions free. So far we have completed 71 sessions on 71 different topics. Just register on the link below. accountingfriend.indradhanu.info
@rajgirap7231
3 жыл бұрын
@@IndradhanuAcademy u r most welcome....
Nice video sir👌
Well explained tq Sir 🙏
@IndradhanuAcademy
3 жыл бұрын
Thank you for your feedback. You may connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. This Sunday it will be session no. 90. Click here to register for free. accountingfriend.indradhanu.info
Thank you sir!!
@IndradhanuAcademy
Жыл бұрын
Welcome. You can connect with me live tomorrow morning at 11 am on 4th Dec. 22. I am conducting a live webinar on the topic "how to effectively conduct stock audit". Please click the link below and register for free. bit.ly/3ARvkco If you are viewing this after 4th Dec. 22, click here to register for accounting friend lecture series. We have conducted 111 sessions on 111 different topics. Click below and register for free. You will receive all invitations I'm future accountingfriend.indradhanu.info
Bro balance sheet me captil account to daal diya crrunt profit kon dale gaa
Thank u sir ♥️♥️♥️♥️
@IndradhanuAcademy
3 жыл бұрын
Welcome. You can connect with me live in Accounting Friend lecture series on every Sunday morning. Click here to register for free. accountingfriend.indradhanu.info. Today it was 85th session.
Sir, ak query hai Ak accountant ki jimmedari me sirf taxation aur saal ke end me sirf ye balance sheet hi taiyar karke deni hoyi hai na .ya aur kuch bhi hota hai?
@IndradhanuAcademy
4 жыл бұрын
Accountant is responsible for many things. His job is to complete accounting on monthly basis correctly, report to management on regular basis.
Sir ek Long and Separate Video bnaiye... Please Sir... Audit prr... Kaise Audit ki jayee.... Kisi company ki practically..
@IndradhanuAcademy
2 жыл бұрын
For this type of topics, please register for Accounting Friend lecture series for free. Click here. accountingfriend.indradhanu.info
Thank u sir
@IndradhanuAcademy
2 жыл бұрын
Welcome
Nice sir❤
Dhanyawad sir tumhi mahiti chaangli dili
@IndradhanuAcademy
2 жыл бұрын
Marathi feedback baddal dhanyavaad
thank you sir for making 3 min video into 24 min video
@IndradhanuAcademy
2 жыл бұрын
You are a brilliant student and hence you can understand balance sheet in excel in 3 seconds also. But every student is not a brilliant student like you. Hence I explained completed process in detail. Sorry for wasting your time.
VERY good
THANKS SIR.....
@IndradhanuAcademy
2 жыл бұрын
Welcome.
Dear sir I want to perchase a flate/house without less my capital so please tell me how move entry
@IndradhanuAcademy
Жыл бұрын
Get a loan and buy it. For learning in detail, you can connect with me live in accounting friend lecture series. So far we have completed 110 sessions on 110 different topics. Click here to register for free. accountingfriend.indradhanu.info
Sir in excel sheet more data is there in that closing balance to opening balance copy & paste special is more time will take . So any shortcut in find & replace with special characters is may I use or any tricks is may there . Example A1 :A500 (in value is there 300,400,240,280 more) & D1:D500(others value are there). How to D1:D500 values put in A1 :A500 (instead of value of A1 :A500 ). Without copy paste hence data is more copy paste special is more will take time is any. Tricke is there save time. Please I hope you answer me sir.
@IndradhanuAcademy
3 жыл бұрын
We are conducting accounting friend lecture series. You please register for live session, ask the query and get the solution. Click the link below. accountingfriend.indradhanu.info
👍Very helpful
@IndradhanuAcademy
2 жыл бұрын
Thank you for your feedback. You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. So far 99 sessions are completed. Click here to register for free. accountingfriend.indradhanu.info
Sir yadi fixed assets main depreciation rahe to use kaise type karenge?
@IndradhanuAcademy
2 жыл бұрын
Watch this video. kzread.info/dash/bejne/i3auvNGJqajamM4.html You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. Click here to register for free. accountingfriend.indradhanu.info
I want automated data collection posting of Trading,PL,BS on excel from ledger which is auto data collected from journal.
@IndradhanuAcademy
2 жыл бұрын
For such matters of you can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. Click here to register for free. accountingfriend.indradhanu.info
Kya 19-20 ki balance sheet me change kr skate h kya
@IndradhanuAcademy
Жыл бұрын
If income tax return is filed then you can't change it.
Sir u r a excellent teacher can u plz explain in English
@IndradhanuAcademy
3 жыл бұрын
Sure. I will have to re record this video.
Very nice sir
@IndradhanuAcademy
4 жыл бұрын
Thank you.
Sir ji mera ek query he- Humne ek business start karne ke liye capital lagate 5 lac and bank se loan liye 5 lac to hame agar pehla year me profit se 1 lac loan pay karte he to ' balance sheet me equity ki head me mera liability hoga 4 lac to 1 lac Jo hamne business profit se pay Kiya ose kya hum profit and loss ki head me as a expense dikha sakte he and 1 lac Jo hamne loan pay Kiya to mera asset to ohi he to kya 1 lac mera capital me add hoga ? Please reply me
@IndradhanuAcademy
Жыл бұрын
You need to learn accounting concepts to understand balance sheet. You can connect with me live in Accounting friend lecture series. Click here to register for free. Accountingfriend.indradhanu.info
Very very helpful
@samx55
4 жыл бұрын
Looking nice
@IndradhanuAcademy
4 жыл бұрын
Thank you
Listed CO ki balance sheet final karna with consolidation and with all Ind As effect bhi batao sir. Yeh choti B Sheet se kya hoga.
@IndradhanuAcademy
3 жыл бұрын
Thank you for your suggestion.
Sir please upload more videos on audit in detail. Like for how to do audit of Directors remuneration, current a/c, unsecured loans expenses detailed vouching etc.. tnx sir in advance🙏
@IndradhanuAcademy
Жыл бұрын
Thank you🙏 very much for your feedback. You can connect with me live in accounting friend sessions. Also you can get free tally course without any conditions. Please click here to enroll. www.indradhanuacademy.com/courses/tally-prime-for-freshers
@IndradhanuAcademy
Жыл бұрын
I will try to upload more such 🎥
Sir I want tally but how to do the copy tally purchase and sales in excel and balance sheet
@IndradhanuAcademy
3 жыл бұрын
I couldn't understand what you want to say. Please explain
Excellent Pankaj
@IndradhanuAcademy
2 жыл бұрын
Thank you Shashank bhau
sir can you explain in details of liabilities and assests
@IndradhanuAcademy
3 жыл бұрын
Yes. I will upload a new video for this.
@goldenretrievergsd5888
3 жыл бұрын
@@IndradhanuAcademy THANK YOU
very good
@IndradhanuAcademy
2 жыл бұрын
Thank you for your feedback and support. You can connect with me live in accounting friend lecture series. So far we have completed 109 sessions on 109 different topics. Click here to register for free. accountingfriend.indradhanu.info
LEFT SIDE (FA,INV.,CA)KA AMOUNT KESE DALE JO DONO KA AMOUNT SEM AAGYA
@IndradhanuAcademy
Жыл бұрын
For personalised questions, you can connect with me live in accounting friend sessions. Also you can get free tally course without any conditions. Please click here to enroll. www.indradhanuacademy.com/courses/tally-prime-for-freshers
Thanks Sir, F & O Trading ke liye Balance sheet banane ki jankari dijiye, please.
@RAJNEESH748
2 жыл бұрын
SIR, Apna Mobile no share karenge, please.
@IndradhanuAcademy
2 жыл бұрын
9552555739. You can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. So far we have completed 99 sessions on 99 different topics. Click here to register for free. accountingfriend.indradhanu.info
Sir please make a video on how to calculate depreciation in company balance sheet please
@IndradhanuAcademy
2 жыл бұрын
Ok. For understanding such matters in detail, you can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. So far 105 sessions are completed on 105 new topics. Click here to register. accountingfriend.indradhanu.info
Sir real estate ke accounting ke baare me btaye
@IndradhanuAcademy
4 жыл бұрын
Ok. Please wait for some time. I will upload a video on real estate Accounting.
Sir excel share kijya
Sir excel ka all fourmula ka use btao
@IndradhanuAcademy
Жыл бұрын
You can connect with me live tomorrow morning at 11 am on 4th Dec. 22. I am conducting a live webinar on the topic "how to effectively conduct stock audit". Please click the link below and register for free. bit.ly/3ARvkco If you are viewing this after 4th Dec. 22, click here to register for accounting friend lecture series. We have conducted 111 sessions on 111 different topics. Click below and register for free. You will receive all invitations I'm future accountingfriend.indradhanu.info
Nice
BALANCE SHEET KEWAL CA. HI BANA SAKTA PLEASE REPLY SIR
@IndradhanuAcademy
3 жыл бұрын
Balance Sheet is to be prepared by accountant of business. Then it is signed by business owner. Them it is audited by CA. Legally CA never prepares Balance Sheet. . Anybody who knows accounting can prepare Balance Sheet.
Sir, pls make a video of debtor and creditor reconcilition in excel pls make
@IndradhanuAcademy
4 жыл бұрын
Sure. Very soon you will get it.
@keshavkumar-ze6hh
4 жыл бұрын
@@IndradhanuAcademy thankyou sir
Sir school k liye balance sheet ki entry explain kriye please
@IndradhanuAcademy
3 жыл бұрын
Accounting remains the same for school also.
Sir mere ko dout hai ki dono side ka total = kaise aa gaya
@IndradhanuAcademy
Жыл бұрын
To understand such matters in detail you can connect with me live tomorrow morning at 11 am on 4th Dec. 22. I am conducting a live webinar on the topic "how to effectively conduct stock audit". Please click the link below and register for free. bit.ly/3ARvkco If you are viewing this after 4th Dec. 22, click here to register for accounting friend lecture series. We have conducted 111 sessions on 111 different topics. Click below and register for free. You will receive all invitations I'm future accountingfriend.indradhanu.info
car two wheller washing center
Very nice
@IndradhanuAcademy
2 жыл бұрын
Thank you for your feedback. For detailed understanding we conduct accounting lecture series on every Sunday morning at 11 am. So far 102 sessions are completed on 102 different topics. Click here to register for free. accountingfriend.indradhanu.info
Sir salery sheet ka v h kya
@IndradhanuAcademy
2 жыл бұрын
Salary Accounting video is available on paid basis. Please go to academy.indradhanu.info Please call on 9552555739 or 9420066104 for best offer.
Sir ekbar horizontal format bhi dikha dijiye balancesheet ka excel me
@IndradhanuAcademy
3 жыл бұрын
kzread.info/dash/bejne/anWi08qYlNa4Yrg.html Click above link. This video is already uploaded.
Sir sales tax may case ke liye kase balance sheet banai or gross profit or net profit ka ratio kase increase kare plz is per ek video bana digiye
@IndradhanuAcademy
3 жыл бұрын
This issue is to handled on case to case basis. No video can be recorded for this.
Sir hame ek help karde
@IndradhanuAcademy
Жыл бұрын
What help?
sir opening balance needed?????
@IndradhanuAcademy
3 жыл бұрын
This video is not about preparation of balance after taking into consideration, opening balance and transactions. This video is about preparation of balance sheet in excel when you finalized books of accounts, i.e. Accounting, Audit everything is over and we just need to prepare a balance sheet in excel.
Tally ERP 9 se Excel sheets pe balance sheet kaise banaye
@IndradhanuAcademy
3 жыл бұрын
Use export button. You can export any tally report to excel.
Sir estimated and projected balance sheet pe vedeo banaiye
@IndradhanuAcademy
2 жыл бұрын
Sure. For such matters you can connect with me live in Accounting Friend lecture series on every Sunday morning at 11 am. So far we have completed 99 sessions on 99 different topics. Click here to register for free. accountingfriend.indradhanu.info
THANKS SIR. REALY HELPFUL VIDEO
@IndradhanuAcademy
2 жыл бұрын
Welcome
Sir is course ki fee kia hn aur online kia medium pa hoga
@IndradhanuAcademy
Жыл бұрын
New Financial Year is starting. It is the right time to set the the things right in Accounting System. We are conducting Accounting Friend Session No. 115 on this topic *Tally Mistakes to be avoided in new Financial Year* Date : 5th Mar. 23 Time : 11 am. Faculty : CA. Pankaj Deshpande. Indradhanu academy Click here for Register for free. bit.ly/3ZCBFCu
@IndradhanuAcademy
Жыл бұрын
Register for above session and join it tomorrow morning. You can talk to me directly.
Hmko na apka koi msg aaiya na hi ap mujhe what's app group mein add kiye ....
@IndradhanuAcademy
3 жыл бұрын
You will be added to today. Sorry I missed it.
Please give me Excel file format DIJIYE
@IndradhanuAcademy
3 жыл бұрын
Please give me your email
Balance sheet profit and loss....in sabka likn trial balance se hota hai, please IF function use karke kaise sab kaam hota hai real life me, please new video se samjha dijiye
@IndradhanuAcademy
3 жыл бұрын
Sure
Sir pls...schedule 3 ka ek full fledged valance sheet n pl drafting dikhaye excel me
@IndradhanuAcademy
4 жыл бұрын
Ok
@IndradhanuAcademy
4 жыл бұрын
Ok
Good morning sir, aap balance sheet ka main head sub head and under sub head account pr video bana dijiye pls sir
@IndradhanuAcademy
2 жыл бұрын
Sure
Sir ji coching fees
@IndradhanuAcademy
Жыл бұрын
Please call on 9552555739 or give your number to call.
vaise yahi kam karte hai kya CA FIRM MEIN
@IndradhanuAcademy
3 жыл бұрын
Variety of work is done in CA firm. This is one of the work.
Not Showing Clearly 😔
@IndradhanuAcademy
2 жыл бұрын
Your internet speed may be low
Trading and profit lossas account
Sir please upload a video of preparing financial statements.
@IndradhanuAcademy
4 жыл бұрын
Sure
Sir, please use little bit English
@IndradhanuAcademy
3 жыл бұрын
Sure. Next time you will see the difference.
Shabha 😭😭😭🙏
@IndradhanuAcademy
2 жыл бұрын
Thank you for your support. To understand such matters in detail, you can connect with me lu ve in Accounting Friend lecture series. So far 109 sessions are comepleted on 109 different topics. Click here to register for free. accountingfriend.Indradhanu.Info
Patil and patil company
@IndradhanuAcademy
Жыл бұрын
Excellent
Time pass jyada krte ho sir 😂
@IndradhanuAcademy
2 жыл бұрын
Noted. Thank you for your feedback.
Bakwaas
Thank you so much sir 🙏
@IndradhanuAcademy
3 жыл бұрын
Welcome Vimal Kumar
Thanks sir
@IndradhanuAcademy
4 жыл бұрын
Welcome
sir practically tax audit full kaisa kar plz bataya
@IndradhanuAcademy
3 жыл бұрын
You can register for our weekly live sessions at accountingfriend.indradhanu.info. Register for free.
Yeh LLP pr bhi applicable hoga
@IndradhanuAcademy
2 жыл бұрын
Yes.
Thank you sir
@IndradhanuAcademy
Жыл бұрын
Welcome. You can connect with me live tomorrow morning at 11 am on 4th Dec. 22. I am conducting a live webinar on the topic "how to effectively conduct stock audit". Please click the link below and register for free. bit.ly/3ARvkco If you are viewing this after 4th Dec. 22, click here to register for accounting friend lecture series. We have conducted 111 sessions on 111 different topics. Click below and register for free. You will receive all invitations I'm future accountingfriend.indradhanu.info
Thanks Sir
@IndradhanuAcademy
2 жыл бұрын
Thank you for your feedback. For understanding such matters in detail, we conduct accounting lecture series on every Sunday morning at 11 am. So far 102 sessions are completed on 102 different topics. Click here to register for free. accountingfriend.indradhanu.info