Balance Sheet in Excel by CA. Pankaj Deshpande
Вставка
- Опубліковано 21 жов 2024
- FREE Tally Prime Course. Click the link below to enrol for free. www.indradhanu...
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.indradhanu...
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.inf...
फर्म का बेलेंस सीट बेहतरीन तरीके से समझाया है। धन्यवाद सर, हमें बिना लाभ वाले अपार्टमेंट सोसायटी के बेलेंस सीट की जानकारी देंगे।
जरूर.
Thanks sir bahut acha video banaya hai
Thanks sir bhut acha samja rhe ho app
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
Tnk u sir bohut bar blnc sheet try kar raha ta aaj succs hogaya
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
❤❤❤❤❤❤full excel sikhane ki video bna do sir,,jo accounting me use hota ho ❤❤❤❤❤
Dhanyawad sir tumhi mahiti chaangli dili
Marathi feedback baddal dhanyavaad
Excellent Pankaj
Thank you Shashank bhau
Sir ek Long and Separate Video bnaiye... Please Sir... Audit prr... Kaise Audit ki jayee.... Kisi company ki practically..
For this type of topics, please register for Accounting Friend lecture series for free. Click here.
accountingfriend.indradhanu.info
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🙏
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
I will try to upload more such 🎥
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
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
Thank You Sir
Thanks Sir, F & O Trading ke liye Balance sheet banane ki jankari dijiye, please.
SIR, Apna Mobile no share karenge, please.
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
Thank you so much sir
Thanks sir
Thanku so much sir
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
sir washing center balance sheet kaise banate hai
Thanku you so much sir. you teach in well manner and easiest way
Welcome
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.
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
Thank u so much sir..bahot he easy way mein samjhaya aapne..🙏🙏
Thank you for your feedback.
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
@@IndradhanuAcademy u r most welcome....
VERY good
Agar ham balance sheet banate h to creditor site ka amount debit site me dikhe to use kaha dalenge
very nice sir.i am very much oblidged to you for this class.
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
Thank you very much for this edifying content
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
Dear sir
I want to perchase a flate/house without less my capital so please tell me how move entry
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
Very very helpful
Looking nice
Thank you
Thanks a lot
thank you sir for making 3 min video into 24 min video
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.
Nice sir❤
Thank Q so much
Welcome
THANKS SIR.....
Welcome.
Very very very thanks sir☺☺😃🙏🙏🙏
& good job 👏🏼👏🏼👌🏻👌🏻👍🏼
Your support motivates me to create more such videos.
Bro balance sheet me captil account to daal diya crrunt profit kon dale gaa
Thanks for helping
Most welcome
Nice video sir Thank You for your guidance
Welcome
Sir excel ka all fourmula ka use btao
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
very good
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
THANKS SIR. REALY HELPFUL VIDEO
Welcome
Kya 19-20 ki balance sheet me change kr skate h kya
If income tax return is filed then you can't change it.
Very nice sir
Thank you.
Very well explained. Keep it up
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
Thanks sir very nice video
sir can you explain in details of liabilities and assests
Yes. I will upload a new video for this.
@@IndradhanuAcademy THANK YOU
MAAN GAYE GURU....
GOOD TEACHING KNOWLEDGE
HELPFUL VIDEO. THANKS A LOT
Thank you for your feedback. You can connect with me live in Accounting Friend Lecture Series. Please register at accountingfriend.indradhanu.info
Sir yadi fixed assets main depreciation rahe to use kaise type karenge?
Watch this video.
ua-cam.com/video/YBzZoPyEthk/v-deo.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
Sir is course ki fee kia hn aur online kia medium pa hoga
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
Register for above session and join it tomorrow morning. You can talk to me directly.
Thank u sir
Welcome
Good morning sir, aap balance sheet ka main head sub head and under sub head account pr video bana dijiye pls sir
Sure
Sir ji process kya h balance sheet bnana ka . Links kasa Krna hota h excel m . Legal, trial balance , notes, balance sheet
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
This issue is to handled on case to case basis. No video can be recorded for this.
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.
Thank you for your suggestion.
LEFT SIDE (FA,INV.,CA)KA AMOUNT KESE DALE JO DONO KA AMOUNT SEM AAGYA
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
Sir estimated and projected balance sheet pe vedeo banaiye
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
Sir please make a video on how to calculate depreciation in company balance sheet please
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
Thank u sir ♥️♥️♥️♥️
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.
👍Very helpful
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
Nice
Well explained tq Sir 🙏
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 u so much sir❤️❤️❤️
Welcome
I want automated data collection posting of Trading,PL,BS on excel from ledger which is auto data collected from journal.
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
Sir ekbar horizontal format bhi dikha dijiye balancesheet ka excel me
ua-cam.com/video/8Anqh_dsR2U/v-deo.html
Click above link. This video is already uploaded.
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?
Accountant is responsible for many things. His job is to complete accounting on monthly basis correctly, report to management on regular basis.
sir practically tax audit full kaisa kar plz bataya
You can register for our weekly live sessions at accountingfriend.indradhanu.info. Register for free.
Sir mere ko dout hai ki dono side ka total = kaise aa gaya
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
Thank you so much sir 👍👍👍👍
I am happy to know that I am able to add some value to your knowledge.
Yeh LLP pr bhi applicable hoga
Yes.
Nice video sir👌
Sir salery sheet ka v h kya
Salary Accounting video is available on paid basis. Please go to academy.indradhanu.info
Please call on 9552555739 or 9420066104 for best offer.
Hmko na apka koi msg aaiya na hi ap mujhe what's app group mein add kiye ....
You will be added to today. Sorry I missed it.
Sir I want tally but how to do the copy tally purchase and sales in excel and balance sheet
I couldn't understand what you want to say. Please explain
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
Sure
Sir school k liye balance sheet ki entry explain kriye please
Accounting remains the same for school also.
Sir u r a excellent teacher can u plz explain in English
Sure. I will have to re record this video.
Sir, pls make a video of debtor and creditor reconcilition in excel pls make
Sure. Very soon you will get it.
@@IndradhanuAcademy thankyou sir
BALANCE SHEET KEWAL CA. HI BANA SAKTA PLEASE REPLY SIR
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 opening balance needed?????
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
Use export button. You can export any tally report to excel.
Sir hame ek help karde
What help?
car two wheller washing center
Please give me Excel file format DIJIYE
Please give me your email
Sir ji coching fees
Please call on 9552555739 or give your number to call.
Sir real estate ke accounting ke baare me btaye
Ok. Please wait for some time. I will upload a video on real estate Accounting.
vaise yahi kam karte hai kya CA FIRM MEIN
Variety of work is done in CA firm. This is one of the work.
Sir pls...schedule 3 ka ek full fledged valance sheet n pl drafting dikhaye excel me
Ok
Ok
Sir please upload a video of preparing financial statements.
Sure
Not Showing Clearly 😔
Your internet speed may be low
Sir excel share kijya
Trading and profit lossas account
Sir, please use little bit English
Sure. Next time you will see the difference.
Shabha 😭😭😭🙏
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
Excellent
Time pass jyada krte ho sir 😂
Noted. Thank you for your feedback.
Bakwaas
Thanks Sir
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
Thank you sir!!
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
Thank you show much sirji
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
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
Thank you sir
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
Thank you so much sir 🙏
Thank you sir
Thank you sir
Thank you for your feedback