Automate Trial Balance, Income Statement, Balance Sheet| Financial Statements Complete Tutorial

  Рет қаралды 508,272

Professional's Legacy

Professional's Legacy

Күн бұрын

Пікірлер: 414
@professionallegacy
@professionallegacy Жыл бұрын
3 Statements Financial Model with Projections: kzbin.info/www/bejne/Z4jMeHasgNB0l9E
@seerjughimire5322
@seerjughimire5322 9 ай бұрын
sir i am from nepal kathmandu watching your video. at 42:23 i could not calculate sum of balance
@Islamicvoice1.1
@Islamicvoice1.1 Ай бұрын
Hello, Is main jb Ledger increase ho jata hy to hm is ko By Date Select kertay hain to opening balance nai aata ,, ?? is ka solution Btain
@sirajnasir7620
@sirajnasir7620 9 күн бұрын
Kia yeh mein 1 small business Kay Liye bhi use kar lu theek rahy ga ? Aur dosra sawal Kay agr mein perpetual inventory system use na karu tou bhi theek rahy ga.ya sirf perpetual inventory system hi use karo
@TauseefAhmed-ei3ey
@TauseefAhmed-ei3ey Жыл бұрын
It is so real. The difference between you and other KZbinrs is simplicity in tutorials. Please keep doing this. You are doing such a great job. May Allah reward you. Thank You........
@pichhalperi
@pichhalperi Жыл бұрын
aap ne kitna acha samjhaya ... school ke zamanay mein yehi cheez sakhti se prhatey theh phir bhi samaj nahi aati thi
@advocateanwar81
@advocateanwar81 2 ай бұрын
us waqat sirf ratta tha, samjhane wala koi nhn tha aur is waqat is lye samjh aata he k hum filed men hen
@Pandit_ji501
@Pandit_ji501 Жыл бұрын
I'm from India i always watch your video..good effort...Sir....
@AliMuhammad-g3u
@AliMuhammad-g3u 10 ай бұрын
Such an amazing tutorial. I didn't get the whole concept from books but your tutorial helped me to get the bigger picture in accounting. Thank you and hats off to you ❤
@FalconKiyani
@FalconKiyani Жыл бұрын
PROFESSIONAL LEGACY IS THE ONLY CHANNEL WE NEED ON KZbin..............LOADS OF LOVE FROM UK
@abdulrasid9775
@abdulrasid9775 Жыл бұрын
Love u sir from Nepal 🇳🇵,Really u are doing a great work.. Its really helps internship students
@professionallegacy
@professionallegacy Жыл бұрын
It's my pleasure
@thebesttechnical3608
@thebesttechnical3608 12 күн бұрын
Never have I seen it explained so simply, my interest in excel is back again.......thank you!!!
@moretostore302
@moretostore302 Жыл бұрын
Such a great video sir. I'm an accountant Balance sheet ke lye pareshan hun bade trial balance wali videos bnae balance sheet bs clear hojae. Video bht shandar thi . Good job 👍 👍 👍
@zikriakhan313
@zikriakhan313 Жыл бұрын
MASHALLAH SIR 47.48 SEC TAK DEKH LI INCOME STATEMENT KAL BANAONGA OR SIR YOU ARE THE BEST ABSOULUTLY AWSOMEEEEEEEEEEEEEEEEEE
@Shanzay_zaidi
@Shanzay_zaidi Ай бұрын
i swear apky bolny ka tarika bhht pyara hy or ,jo ap sikha rahy hain ye mare or bht sary students ky kam any wala hy jo iss fileld mai ana chahty hain thank you sooooooooooooooooooooooo much for this class subscirbe bhi kar lia hy or inshallah mai apki ab videos dekhti bhi rahungi or like bhi krti rahungi ,,,new wali bhi previouse wali bhi
@ranatallat3718
@ranatallat3718 Жыл бұрын
You are great sir Allah pak AP ko khush rakhy
@MuhammadAdnan-ib4qf
@MuhammadAdnan-ib4qf Жыл бұрын
Thank you Sir, This was much needed class for me. A very real and detailed. You gave a complete review of professional work. Not like others who hid the real work done. If Tutorial are so detailed then I would 100% recommend your complete courses.
@khoju2007
@khoju2007 3 ай бұрын
An Absolute tutorial. I was looking for such thing to develop an automated accounting record sheet for my startup. This is the best place to learn accounting
@imamkhan1995
@imamkhan1995 8 ай бұрын
U r great sir, u have thought both financial account and Excel main shortcuts. Great job.
@Stoicstrides_21x
@Stoicstrides_21x 11 ай бұрын
I'm very thankful to you for giving us information like this 💓❤
@ruqiasultana4308
@ruqiasultana4308 9 ай бұрын
Thank you very much for such amazing tutorial, may Allah bless you with everything you want. I was looking for detailed explanation but I couldn't find anywhere. Your video is the best sir❤
@faisalnaveedansari
@faisalnaveedansari 3 ай бұрын
Verry Good Experience with you , Sir, JazakaAllah. Thank you for this Video.
@akhlaqueali6711
@akhlaqueali6711 9 күн бұрын
Your teaching skills are amazing 👌👌👌👍👍👍
@zauyt7198
@zauyt7198 Жыл бұрын
Jazakallah sir We are lucky hamy itna Kuch sikhny ko mil Raha hy ❤️🤌🏻
@MwasamaniGunda
@MwasamaniGunda 2 ай бұрын
Amazing game changer, I am a Tally erp9 user, this is a game changer sir. Thanks alot from Tanzania
@munaba641
@munaba641 7 ай бұрын
Thanks for sharing Excellent expertise services. May Allah’s blessings be upon you and family.ameen Munawar from Germany 🇩🇪
@Islamic-Education-786
@Islamic-Education-786 Жыл бұрын
MashAllah...bht maza aaya...i learnt many things here...
@pichhalperi
@pichhalperi Жыл бұрын
Bohhht Aaala ... aap ne meri problem solve kar di ... Thank you bro
@sheikhsahab2075
@sheikhsahab2075 3 ай бұрын
The way you explain is really helpful sir genuine practice material in comparison to others
@fokhrulislam2633
@fokhrulislam2633 Жыл бұрын
Can't explain how much I enjoyed the workflow you have shown. Also while watching, I got confused about whether you are "An Accounting Expert" or "An Excel Expert". Just kidding. 😁 Your Excel knowledge is super in your field of work. Thank you so much for sharing. 👍
@ash107108
@ash107108 Жыл бұрын
My dear Sir, excellent learning....I am so thankful
@shahnamchauhan5635
@shahnamchauhan5635 Жыл бұрын
Informative and useful Request to create a video on real time data with dummy numbers
@M.M.Saqib4436
@M.M.Saqib4436 Жыл бұрын
Thank You very much, Sir. May God Bless You.
@pushankumarpaul7572
@pushankumarpaul7572 4 ай бұрын
I LOVE THIS CHANNEL IT'S AMAZING
@muhammadabubakar3657
@muhammadabubakar3657 Жыл бұрын
Sir me audit firm me Kam kr Raha ho, ap ke video bot informational hai, kindly tax Sy related b videos banaye
@rizwanhanif2826
@rizwanhanif2826 Жыл бұрын
Assalamualaikum...
@rizwanhanif2826
@rizwanhanif2826 Жыл бұрын
Bhai apsy bt ho skti han personal ma.kch information leni the.
@muhammadzubairkhan3136
@muhammadzubairkhan3136 Жыл бұрын
Awesome Mehtab Sir!!!
@professionallegacy
@professionallegacy Жыл бұрын
Thanks for liking
@qudratullahskills
@qudratullahskills Жыл бұрын
Thank you sir ..i have watched full video...i learn a lot...and i think..i watch again for learn clear
@fraziqbal6938
@fraziqbal6938 Жыл бұрын
Very nice refresher on both accounting concepts and its application in Excel. Thank you very much!
@subhanahmad8387
@subhanahmad8387 Жыл бұрын
Sir thank you very much for this free toturial. Can you plz teach us how to prepare cashflow, changes in equity, and specially notes to financial statments and then overall boollet
@muhammadmehtabmanzar1736
@muhammadmehtabmanzar1736 Жыл бұрын
Yeah Sure, will check audience response and if it's good then I'll share, InshAllah.
@Abdul-552
@Abdul-552 Жыл бұрын
​@@muhammadmehtabmanzar1736❤❤❤
@taimooryaseen9661
@taimooryaseen9661 Жыл бұрын
Sir please cash flow and changes in Equity and notes ki bi videos bna dain thanks
@versevibesverse
@versevibesverse Жыл бұрын
Yes Please I really appreciate it if you do that......
@AbdulRafay-zg7hs
@AbdulRafay-zg7hs Жыл бұрын
Yes sir please
@abdullahsiddiqui8130
@abdullahsiddiqui8130 Жыл бұрын
You Amazed Me As always ❤
@abmshahinulkadir3949
@abmshahinulkadir3949 Жыл бұрын
Such a nice Presentation in Excel environment. Great work of formula.
@Maqsoodm786
@Maqsoodm786 19 күн бұрын
Hats off. to ur presentation
@MDNizamuddinRain-w7f
@MDNizamuddinRain-w7f Ай бұрын
thank you so much sir, It's a perfect and understandable tutorial.
@msakbar86
@msakbar86 Жыл бұрын
Absolutely amazing lecture. I love the way you teach😊
@osaidahmed2785
@osaidahmed2785 3 ай бұрын
Really informative and practical learning basic stage it is suggested that if you share discussed soft excel sheet inbox which is very helpful for all professional accountants
@naseerkhan7411
@naseerkhan7411 Жыл бұрын
Very Nice Brother really it is very helpful for us Great
@UmairKhan-lm4lv
@UmairKhan-lm4lv Жыл бұрын
Great work will be waiting for more genuine content like this.
@jrayub
@jrayub Жыл бұрын
amazing work, very clear and easy explanation with live practical, 👍
@BasharatAli-p8c
@BasharatAli-p8c 7 ай бұрын
I really learn very much things from your video . And I am thankful to you
@saimaali7947
@saimaali7947 5 ай бұрын
Even though i have old excel but this video helped me alot...i learned alot of things ...thanku
@techanalytics4655
@techanalytics4655 Жыл бұрын
Thank u so so much Mehnaz ! Very informative,knowledgable and useful skills of todays relevancy in job and preparing financials!
@arifnasir6845
@arifnasir6845 8 ай бұрын
Sir, your videos are very good, and the concepts are explained very clearly. I just wanted to ask how to show the opposite side in a ledger, like we do manually where we mention whether it's a debit or credit and for what reason.
@Sandepe_kumar
@Sandepe_kumar 4 ай бұрын
Awesome teaching style sir jee, love from India 🇮🇳
@NewSmart_Business_Ideas
@NewSmart_Business_Ideas Жыл бұрын
as an Accountant , it is as same as we are doing as professional , great initiate
@AsadArt7
@AsadArt7 4 ай бұрын
Inventory purchased of 500000 from multi media on 7 July 2023. Purchase account debit Multi media account credit Sir jb goods ka name na dia ho to hm purchase likhte or cash/ bank na btaya ho or name a jae jese company name aya to hm isko credit base Yani udhar smjte. Hmko to yahi sikhaya gya but mje apka logic smj ni aya apne entry wese pass ku ki please mje reason btaye apne hmare concepts wrong ker dea kindly mje zarur reply krna
@AsadArt7
@AsadArt7 4 ай бұрын
Kindly ap hi reply krdo mere comment ka k aisa ku
@RizwanRafiq-q3n
@RizwanRafiq-q3n Ай бұрын
​@@AsadArt7 there is difference between periodic and perpetual inventory system
@waseemabbasi9900
@waseemabbasi9900 Жыл бұрын
Sir you are really doing very well please sir make some videos on UAE vat and how to return vat
@2thepoint88
@2thepoint88 10 ай бұрын
Great job sir, may Allah bless you and grant you health wealth and success ameen regards
@faizal9611
@faizal9611 Жыл бұрын
Excellent presentation, Keep up the good work👍🏻
@Pastfacts.
@Pastfacts. Жыл бұрын
Thank you sir. Kai apne mere Request ko accept kya awar financial statement pi apne video banaye. Thank you again.
@atharali4676
@atharali4676 7 ай бұрын
mind-blowing brother, i liked your way to elaborate and easily presents the things.....Iam working in NGO so can you please make video on ngo grants
@brutalmotivations
@brutalmotivations 5 ай бұрын
Thank you so much sir. This is what i was looking for.
@husnatariq7637
@husnatariq7637 Жыл бұрын
This class is very helpful for me, Thanks Sir
@hussnainhaider7327
@hussnainhaider7327 Жыл бұрын
Doing great Job sir... May ALLAH reward you for this..AMEEN
@hamzaiqbal282
@hamzaiqbal282 Жыл бұрын
excellent initiative... continue this kind of series.
@muhammadfiaz1568
@muhammadfiaz1568 2 ай бұрын
wonderful. Well explained
@AnkitaShinde-xz6rg
@AnkitaShinde-xz6rg 25 күн бұрын
You are a best teacher🙂🙂🙂🙂🙂
@techanalytics4655
@techanalytics4655 Жыл бұрын
Amazing hard work inputted for the benefit of student community ❤❤❤
@prashantgunjal3465
@prashantgunjal3465 3 ай бұрын
Really loved your content ❤🎉🎉 thankyou for this beautiful understanding
@jinnahussainelluvilayil3473
@jinnahussainelluvilayil3473 2 ай бұрын
Oh my god cristal clear ♥️ thank brothet ✌️💯
@readfacts5098
@readfacts5098 Жыл бұрын
waoooooO sir you are amazing .. thank u so much
@farooqrasheed5337
@farooqrasheed5337 11 ай бұрын
Mashallah mehtab sir brilliant method and in polite way,❤
@waqaslodhi1439
@waqaslodhi1439 2 ай бұрын
Great job well done
@muhammadzubairkhan3136
@muhammadzubairkhan3136 4 ай бұрын
Great tutorial
@tahreemzehra
@tahreemzehra Жыл бұрын
Thank you soo much sir for such an amazing lecture
@aromantikmoment4249
@aromantikmoment4249 Жыл бұрын
To.... nice bhi, just lovely 🎉🎉🎉
@Abdul-552
@Abdul-552 Жыл бұрын
Great work sir 💯
@nasirrabbani5529
@nasirrabbani5529 5 ай бұрын
Excellent work....Mashallah keep it up Sir... im PIPFA student....
@SAKGB
@SAKGB Жыл бұрын
Asi video ka salu sa intizar tha agr phla hota to mara fiverr ka danda urooj pa hota btw thanks alot sir u made my day.waiting for video on cash flow Sir agr ap income statement or balance sheet ka template b share krta to or acha hota Again thanks allah ap ko.hamisha khosh rakha asmani , zamini shar sa mehfooz rakha allah ap ko or kamiyabi ata kara behak panjitan a,s
@muhammadmehtabmanzar1736
@muhammadmehtabmanzar1736 Жыл бұрын
Ameen, thank you. Temple is liy ni share kia k ap effort krain, it's for your benefit. ❤
@SAKGB
@SAKGB Жыл бұрын
Pr sir g excel pa pura tutorial banaya na
@muhammadmehtabmanzar1736
@muhammadmehtabmanzar1736 Жыл бұрын
​@@SAKGBcheck playlist.
@amirranashahzad8513
@amirranashahzad8513 Жыл бұрын
As usual excellent work I learnt many new tricks Thanks sir
@DurhamFlooringandKitchen
@DurhamFlooringandKitchen 3 ай бұрын
amazing- truly the best
@irfanrana3289
@irfanrana3289 Жыл бұрын
Thanks for this great learning sir
@AlexTechinformation
@AlexTechinformation Ай бұрын
i like a way of teaching .
@BasharatAli-p8c
@BasharatAli-p8c 7 ай бұрын
And I also followed your account. And I subscribed your channel. Because I really love this video . ❤
@adeelabbas8992
@adeelabbas8992 Жыл бұрын
Excellent teaching style
@hsbdailyshow3197
@hsbdailyshow3197 11 ай бұрын
Even-though i know all these things but the Presentation is very very Beautiful i would like to suggest you should Also make a video on Taxation and also Explore from A to Z the Softwares Like Quickbooks, Peachtree, Xero, Tally. it will Be awesome
@ahmershiekh8728
@ahmershiekh8728 3 ай бұрын
Very good sir , your lecture is amazing bht kuch seekhny ko mila 😊
@imamkhan1995
@imamkhan1995 8 ай бұрын
Keep going... Great presentation
@ashsamsuttalia4714
@ashsamsuttalia4714 Жыл бұрын
I am very beginner! trying to do by your guideline, and believe In Sha Allaha I will do....kindly inform Excell version !
@digitalgen
@digitalgen Жыл бұрын
video bht achi hy, kindly aik running business jo hy wo is mein entries kase kare ga i mean opening balances kase add ho ge
@JourneyJunctionExplorer
@JourneyJunctionExplorer Жыл бұрын
You teaching is unique 👍🏻👍🏻👍🏻
@maqsoodali7847
@maqsoodali7847 Жыл бұрын
You are great sir amazing and thank you for knowledge sharing with us ❤
@MwasamaniGunda
@MwasamaniGunda 2 ай бұрын
We should also be carefull while draging the pivot table fields to the value area, change the value fields to sum instead of count. Sometimes excel by default brings the value fields as count, and you might see 1,1,1,1,2,2,2,2, and the column titles on the pivot table reading to count of Debit or count of Credit. We use the drop down arrow to change value field settings to sum.
@muhammadwaseem7491
@muhammadwaseem7491 Жыл бұрын
Very helpful , I need all course
@GLTxSAHIL
@GLTxSAHIL 6 ай бұрын
manually khap raha tha u won my heart sir thank you for this automation
@MujahidRasool-x4j
@MujahidRasool-x4j 2 ай бұрын
Sir ,Your Way of Teaching Absolutely amazing Lots of love . Sir I have question hum Accounting Softwere say ksy financial Bana Sakty hin .Like SAP , ERP , Quickbook , Fast Accounts Kindly Guide me
@Pervaizali657
@Pervaizali657 5 ай бұрын
Amazing Lecture
@goodman-it2qy
@goodman-it2qy Жыл бұрын
It's too informative for accountant at work in ms excel.
@purushothamreddy6914
@purushothamreddy6914 Жыл бұрын
Great video, it's was nice learning to creation of ledger through slicers and pivot tables to TB. This while video From passing journey entries -ledger-tb-finacials- printout of FS
@sadamkhan-qs8bn
@sadamkhan-qs8bn 11 ай бұрын
superrrrrrbbbb lovelyy excellent bigfour power blindly go for buying this course
@shoaibsarwar8320
@shoaibsarwar8320 Жыл бұрын
Absolutely perfect .great job Sir
@saminaarif2687
@saminaarif2687 Жыл бұрын
Very informative and easy to understand
@BasharatAli-p8c
@BasharatAli-p8c 7 ай бұрын
You are very good motivation sir
@peacefullaughter8178
@peacefullaughter8178 Жыл бұрын
Good job ✌
@mdsheikh7192
@mdsheikh7192 Жыл бұрын
Really Amazing, Thank you so much.
@keepsmile4k
@keepsmile4k 7 ай бұрын
Tomorrow I have interview and this video cleared my all ambiguities and unclear questions Best regards
Bank Reconciliation Statements Master Class | Cash Book Reconciliation
40:54
Professional's Legacy
Рет қаралды 61 М.
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 62 МЛН
Excel for Accounting - 10 Excel Functions You NEED to KNOW!
19:05
Leila Gharani
Рет қаралды 2,1 МЛН
Balance Sheet Analysis In Just 40 Minutes | Balance Sheet Explained
37:10
FinnovationZ by Prasad
Рет қаралды 619 М.
Don't need to remember Excel formulas from now | Excel using A.I
10:53
Build a Dynamic 3 Statement Financial Model From Scratch
32:26
Kenji Explains
Рет қаралды 1,1 МЛН
#1 Cash Flow Statement ~ Introduction and Basic Concept
50:38
CA. Naresh Aggarwal
Рет қаралды 3 МЛН
Learn Financial Modelling - Step by Step
41:11
The Valuation School
Рет қаралды 1,4 МЛН
Accounting Crash Course - Be job ready in 1.5 hours!
1:33:00
Learn Accounting Finance
Рет қаралды 273 М.
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН