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

  Рет қаралды 467,971

Professional's Legacy

Professional's Legacy

Күн бұрын

Пікірлер: 394
@professionallegacy
@professionallegacy Жыл бұрын
3 Statements Financial Model with Projections: kzbin.info/www/bejne/Z4jMeHasgNB0l9E
@seerjughimire5322
@seerjughimire5322 7 ай бұрын
sir i am from nepal kathmandu watching your video. at 42:23 i could not calculate sum of balance
@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........
@Pandit_ji501
@Pandit_ji501 10 ай бұрын
I'm from India i always watch your video..good effort...Sir....
@AliMuhammad-g3u
@AliMuhammad-g3u 8 ай бұрын
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 ❤
@sidkhan9871
@sidkhan9871 Жыл бұрын
aap ne kitna acha samjhaya ... school ke zamanay mein yehi cheez sakhti se prhatey theh phir bhi samaj nahi aati thi
@advocateanwar81
@advocateanwar81 21 күн бұрын
us waqat sirf ratta tha, samjhane wala koi nhn tha aur is waqat is lye samjh aata he k hum filed men hen
@FalconKiyani
@FalconKiyani 10 ай бұрын
PROFESSIONAL LEGACY IS THE ONLY CHANNEL WE NEED ON KZbin..............LOADS OF LOVE FROM UK
@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 👍 👍 👍
@globalincomemarketplace1
@globalincomemarketplace1 Жыл бұрын
Unlock the power of financial automation with this comprehensive tutorial! Learn to streamline Trial Balance, Income Statements, and Balance Sheets effortlessly. Don't miss this game-changing video!
@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
@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.
@Guessr_Community
@Guessr_Community 9 ай бұрын
Masha Allah Kamaal Lecture. Allah pak Apko Mazeed Barkaten Aur Kamyabian ata Farmae.Aameen😍😍😍
@khoju2007
@khoju2007 Ай бұрын
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
@faisalnaveedansari
@faisalnaveedansari Ай бұрын
Verry Good Experience with you , Sir, JazakaAllah. Thank you for this Video.
@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. 👍
@munaba641
@munaba641 5 ай бұрын
Thanks for sharing Excellent expertise services. May Allah’s blessings be upon you and family.ameen Munawar from Germany 🇩🇪
@muhammadsiddiqueakbar7550
@muhammadsiddiqueakbar7550 Жыл бұрын
Absolutely amazing lecture. I love the way you teach😊
@MwasamaniGunda
@MwasamaniGunda 28 күн бұрын
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.
@Stoicstrides_21x
@Stoicstrides_21x 9 ай бұрын
I'm very thankful to you for giving us information like this 💓❤
@fraziqbal6938
@fraziqbal6938 Жыл бұрын
Very nice refresher on both accounting concepts and its application in Excel. Thank you very much!
@M.M.Saqib4436
@M.M.Saqib4436 Жыл бұрын
Thank You very much, Sir. May God Bless You.
@MwasamaniGunda
@MwasamaniGunda 28 күн бұрын
Amazing game changer, I am a Tally erp9 user, this is a game changer sir. Thanks alot from Tanzania
@imamkhan1995
@imamkhan1995 6 ай бұрын
U r great sir, u have thought both financial account and Excel main shortcuts. Great job.
@HafizQasimSmart_Business_Ideas
@HafizQasimSmart_Business_Ideas Жыл бұрын
as an Accountant , it is as same as we are doing as professional , great initiate
@AsadArt7
@AsadArt7 2 ай бұрын
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 2 ай бұрын
Kindly ap hi reply krdo mere comment ka k aisa ku
@ash107108
@ash107108 Жыл бұрын
My dear Sir, excellent learning....I am so thankful
@zauyt7198
@zauyt7198 Жыл бұрын
Jazakallah sir We are lucky hamy itna Kuch sikhny ko mil Raha hy ❤️🤌🏻
@sheikhsahab2075
@sheikhsahab2075 Ай бұрын
The way you explain is really helpful sir genuine practice material in comparison to others
@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.
@techanalytics4655
@techanalytics4655 Жыл бұрын
Thank u so so much Mehnaz ! Very informative,knowledgable and useful skills of todays relevancy in job and preparing financials!
@abdullahsiddiqui8130
@abdullahsiddiqui8130 Жыл бұрын
You Amazed Me As always ❤
@techanalytics4655
@techanalytics4655 Жыл бұрын
Amazing hard work inputted for the benefit of student community ❤❤❤
@UmairKhan-lm4lv
@UmairKhan-lm4lv Жыл бұрын
Great work will be waiting for more genuine content like this.
@jrayub
@jrayub 11 ай бұрын
amazing work, very clear and easy explanation with live practical, 👍
@ranatallat3718
@ranatallat3718 Жыл бұрын
You are great sir Allah pak AP ko khush rakhy
@qudratullahskills
@qudratullahskills 10 ай бұрын
Thank you sir ..i have watched full video...i learn a lot...and i think..i watch again for learn clear
@ruqiasultana4308
@ruqiasultana4308 7 ай бұрын
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❤
@abmshahinulkadir3949
@abmshahinulkadir3949 11 ай бұрын
Such a nice Presentation in Excel environment. Great work of formula.
@osaidahmed2785
@osaidahmed2785 Ай бұрын
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
@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
@faizal9611
@faizal9611 11 ай бұрын
Excellent presentation, Keep up the good work👍🏻
@shahnamchauhan5635
@shahnamchauhan5635 Жыл бұрын
Informative and useful Request to create a video on real time data with dummy numbers
@zikriakhan313
@zikriakhan313 Жыл бұрын
MASHALLAH SIR 47.48 SEC TAK DEKH LI INCOME STATEMENT KAL BANAONGA OR SIR YOU ARE THE BEST ABSOULUTLY AWSOMEEEEEEEEEEEEEEEEEE
@saimaali7947
@saimaali7947 3 ай бұрын
Even though i have old excel but this video helped me alot...i learned alot of things ...thanku
@prashantgunjal3465
@prashantgunjal3465 Ай бұрын
Really loved your content ❤🎉🎉 thankyou for this beautiful understanding
@maqsoodali7847
@maqsoodali7847 Жыл бұрын
You are great sir amazing and thank you for knowledge sharing with us ❤
@pushankumarpaul7572
@pushankumarpaul7572 2 ай бұрын
I LOVE THIS CHANNEL IT'S AMAZING
@muhammadfiaz1568
@muhammadfiaz1568 27 күн бұрын
wonderful. Well explained
@tahreemzehra
@tahreemzehra Жыл бұрын
Thank you soo much sir for such an amazing lecture
@BasharatAli-p8c
@BasharatAli-p8c 5 ай бұрын
I really learn very much things from your video . And I am thankful to you
@Sandepe_kumar
@Sandepe_kumar 2 ай бұрын
Awesome teaching style sir jee, love from India 🇮🇳
@muhammadzubairkhan3136
@muhammadzubairkhan3136 Жыл бұрын
Awesome Mehtab Sir!!!
@professionallegacy
@professionallegacy Жыл бұрын
Thanks for liking
@husnatariq7637
@husnatariq7637 11 ай бұрын
This class is very helpful for me, Thanks Sir
@hussnainhaider7327
@hussnainhaider7327 10 ай бұрын
Doing great Job sir... May ALLAH reward you for this..AMEEN
@hamzaiqbal282
@hamzaiqbal282 Жыл бұрын
excellent initiative... continue this kind of series.
@nasirrabbani5529
@nasirrabbani5529 3 ай бұрын
Excellent work....Mashallah keep it up Sir... im PIPFA student....
@ashsamsuttalia4714
@ashsamsuttalia4714 Жыл бұрын
I am very beginner! trying to do by your guideline, and believe In Sha Allaha I will do....kindly inform Excell version !
@waqaslodhi1439
@waqaslodhi1439 21 күн бұрын
Great job well done
@nasirmahmood7333
@nasirmahmood7333 Жыл бұрын
Doing good job. My son took admission in ACCA after FSc and he was upset k samajh nahi aati. I will forward your video to him. InshaAllah he will understand basic concepts. Bus I request k financial accounting per zyada twaja deñ excel parhanay per zyada focus na kareñ.
@talhaali2553
@talhaali2553 11 ай бұрын
Hope you son get good understanding by the way excel is our Primary tool
@muhammadbahzad2977
@muhammadbahzad2977 Ай бұрын
Jis ko Excel nai ata us ko to samajna do bhai
@GLTxSAHIL
@GLTxSAHIL 4 ай бұрын
manually khap raha tha u won my heart sir thank you for this automation
@Pastfacts.
@Pastfacts. Жыл бұрын
Thank you sir. Kai apne mere Request ko accept kya awar financial statement pi apne video banaye. Thank you again.
@naseerkhan7411
@naseerkhan7411 Жыл бұрын
Very Nice Brother really it is very helpful for us Great
@Athar926
@Athar926 Жыл бұрын
Very impressive sir thankyou
@sidkhan9871
@sidkhan9871 Жыл бұрын
Bohhht Aaala ... aap ne meri problem solve kar di ... Thank you bro
@BasharatAli-p8c
@BasharatAli-p8c 5 ай бұрын
And I also followed your account. And I subscribed your channel. Because I really love this video . ❤
@waseemabbasi9900
@waseemabbasi9900 Жыл бұрын
Sir you are really doing very well please sir make some videos on UAE vat and how to return vat
@JourneyJunctionExplorer
@JourneyJunctionExplorer 11 ай бұрын
You teaching is unique 👍🏻👍🏻👍🏻
@amirranashahzad8513
@amirranashahzad8513 Жыл бұрын
As usual excellent work I learnt many new tricks Thanks sir
@Abdul-552
@Abdul-552 Жыл бұрын
Great work sir 💯
@farooqrasheed5337
@farooqrasheed5337 9 ай бұрын
Mashallah mehtab sir brilliant method and in polite way,❤
@razabhai9870
@razabhai9870 Ай бұрын
Jazak Allah bro❤
@irfanrana3289
@irfanrana3289 Жыл бұрын
Thanks for this great learning sir
@arifnasir6845
@arifnasir6845 6 ай бұрын
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.
@WarishKhan-o7w
@WarishKhan-o7w 3 ай бұрын
Sir I have just one doubt, after complete financial year. How we will add liability, current assets and cash, in next financial year. Will you please continue video on this topic .thank you
@FaheraliAli-eg2fl
@FaheraliAli-eg2fl 2 ай бұрын
Yes sir ic pa b kindly 1 video bnay mra b yah e question ha...
@MujahidRasool-x4j
@MujahidRasool-x4j 20 күн бұрын
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
@atharali4676
@atharali4676 5 ай бұрын
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
@Pervaizali657
@Pervaizali657 3 ай бұрын
Amazing Lecture
@muhammadzubairkhan3136
@muhammadzubairkhan3136 2 ай бұрын
Great tutorial
@qasimmuneerofficial8958
@qasimmuneerofficial8958 Жыл бұрын
Very impressive
@adeelabbas8992
@adeelabbas8992 Жыл бұрын
Excellent teaching style
@karvind251
@karvind251 Ай бұрын
Really superb
@hsbdailyshow3197
@hsbdailyshow3197 9 ай бұрын
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
@2thepoint88
@2thepoint88 8 ай бұрын
Great job sir, may Allah bless you and grant you health wealth and success ameen regards
@HafizQasimSmart_Business_Ideas
@HafizQasimSmart_Business_Ideas Жыл бұрын
agar koi shortcut keys samajh na aae to foran gogle karlen, aur write down kar k rakhin bohot helpful rahy ga
@ahmershiekh8728
@ahmershiekh8728 Ай бұрын
Very good sir , your lecture is amazing bht kuch seekhny ko mila 😊
@brutalmotivations
@brutalmotivations 3 ай бұрын
Thank you so much sir. This is what i was looking for.
@pandharinathjoshi6565
@pandharinathjoshi6565 11 ай бұрын
Excellent sir🙏🙏
@muhammadzubairkhan3136
@muhammadzubairkhan3136 Жыл бұрын
Sir Please Cash flow statement and statement of changes in Equity with explanatory notes to the accounts bhi prepare karne se related tutorial video banayein....Thanks
@Islamic-Education-786
@Islamic-Education-786 9 ай бұрын
MashAllah...bht maza aaya...i learnt many things here...
@rpkhunzai8946
@rpkhunzai8946 Ай бұрын
Outstanding very nice
@purushothamreddy6914
@purushothamreddy6914 11 ай бұрын
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
@qasimmuneerofficial8958
@qasimmuneerofficial8958 Жыл бұрын
Very useful
@versevibesverse
@versevibesverse Жыл бұрын
Sir please also make videos of all statements in QuickBooks using dummy data please. There are a lot of videos for quickbook learning but not a single one that using dummy data for making all type of statements and how to manage record for bank, make payment etc
@muhammadmehtabmanzar1736
@muhammadmehtabmanzar1736 Жыл бұрын
Good idea, It will take some time but I'll make it.
@dulhjee3222
@dulhjee3222 6 ай бұрын
Sir u r a very great person 👍👍👍👍👍
@Preetiisoni
@Preetiisoni 10 ай бұрын
It's very easy to understand....❤
@goodman-it2qy
@goodman-it2qy 11 ай бұрын
It's too informative for accountant at work in ms excel.
@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
@aromantikmoment4249
@aromantikmoment4249 Жыл бұрын
To.... nice bhi, just lovely 🎉🎉🎉
@DurhamFlooringandKitchen
@DurhamFlooringandKitchen Ай бұрын
amazing- truly the best
@peacefullaughter8178
@peacefullaughter8178 Жыл бұрын
Good job ✌
@neerajverma4263
@neerajverma4263 4 ай бұрын
Awesome presentation sir 👍👍
@shoaibsarwar8320
@shoaibsarwar8320 11 ай бұрын
Absolutely perfect .great job Sir
Bank Reconciliation Statements Master Class | Cash Book Reconciliation
40:54
Professional's Legacy
Рет қаралды 54 М.
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37
How it feels when u walk through first class
00:52
Adam W
Рет қаралды 26 МЛН
Cool Parenting Gadget Against Mosquitos! 🦟👶 #gen
00:21
TheSoul Music Family
Рет қаралды 33 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 758 М.
How to create Financial Statements from scratch! A step-by-step guide!
18:51
The Financial Controller
Рет қаралды 344 М.
Build a Dynamic 3 Statement Financial Model From Scratch
32:26
Kenji Explains
Рет қаралды 1,1 МЛН
Palestine Must Be Free | Stand-up Comedy by Daniel Fernandes
15:07
Daniel Fernandes
Рет қаралды 114 М.
Excel Based Accounting Software (100% FREE!)
14:41
Tetracarbon (Phillip Wong)
Рет қаралды 264 М.
FINANCIAL STATEMENTS: all the basics in 8 MINS!
9:06
Accounting Stuff
Рет қаралды 695 М.
Accounting Crash Course - Be job ready in 1.5 hours!
1:33:00
Learn Accounting Finance
Рет қаралды 210 М.
Don't need to remember Excel formulas from now | Excel using A.I
10:53
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37