How to automate Accounting Bookkeeping , Ledger and Trial Balance in Microsoft Excel | Hindi Urdu

[@EXCELDOERS]

Wait is over those, who was looking for Trial Balance, Income Statement and Balance sheet in Excel. Finally video has been uploaded. Checkout below link: kzbin.info/www/bejne/ppilpKyKgKaqgtk

[@NeerajSingh-wx6rd]

I had deadline to do it so tried chat gpt and worked as suggested but after spending 3 hours i gave up as didnt feel confidence and started searching on you tube and bingo i saw your video in recommendation. Its awesome you made it very simple. Thank you😊

[@EXCELDOERS]

Thats great. Now its ur duty to share on your profile so other can benefit too :)

[@thetrueguidance]

Wonderful! I am 51 years old and having experience in computer 32 years. Surely, you have made it in very easy and simple way.

[@SHAHG-mx2zf]

kzbin.info/www/bejne/aH2cZoVog8yqZqs #GL #GeneralLedger #exceltutoring #excelonline #excelvba #excelword #excelrankformula #excel formula hacks #excel interview questions #excel attendance sheet #educ

[@ramdanech7215]

Thanks owasi menon sir, ये इतना फायदेमंद विडियो है । कमाल का आइडिया दिया है। मेरा काम बहुत आसान हो गया। ये तो tally software जैसा हो गया आपका बहुत शुक्रिया

[@syedharis1461]

kia baat hai bro ! so simple , point to point behtreen . mushkil topic lekin gool gappy ki trah mazeedar bana kar samjhany pr dil ki gehrai se shukar guzar. love from pakistan.

[@EXCELDOERS]

Thanks Brother

[@wellwisherofhumanity]

Jazakallahu kheyr. Aapka ye video mere liye intehai mufid raha. Allah aako khush rakhe.

[@velunandhu6249]

super madam I'm ur student joined class very useful this course

[@EXCELDOERS]

Thank u

[@soothingrelaxation8776]

Teach krny ka انداز لاجواب ❤

[@EXCELDOERS]

Thanks

[@soothingrelaxation8776]

Sir debit and credit ka sum nai aa raha Mery pass. Bata den

[@soothingrelaxation8776]

Sir kon sa version used ho raha hy vedio MN

[@prakashrao3607]

Great! Explained in a very simple and understandable way !!

[@md.sakerurrahman5311]

Brother,I am very much grateful to you for your splendid presentation on such a crucial topic regarding ledger accounts.

[@EXCELDOERS]

Thank u brother

[@excelinfo8243]

behtareen! no need of purchasing accounting software it made my work so easy better than any accounting package. Thanks alot.

[@EXCELDOERS]

Love u

[@CreativeCorner3]

Helpful & Very Comprehensive. Have been looking for many month for this. But, Please make clear that grow to make a subsidiary ledger in this sheet and kindly make a Trial Balance and Profit and Loss Statement. A Complete Account Format

[@EXCELDOERS]

Thank u for feedback

[@HK-gk8ns]

+1 please. Thank you

[@samayagroup789]

Really outstanding job brother Keep it up ALLAH BLESS YOU COUNTLESS

[@EXCELDOERS]

AMEEN. THANKS

[@anonBrook]

@@EXCELDOERS do you have a video on how to calculate profit & loss using this system?

[@ShahrukhSk007]

Keep Uploading Videos Like This About Accounting

[@nadeemkhan-rz3wy]

It is very helpful for me, please make a trial balance and balance sheet.

[@Ihasnainasghar]

Behtareen kafi help mili, ik help apkey ley table pr jahan total aya tha wahan us sey uppar ja kar tab dabyen gey to continue table bhar jaye ga

[@subairmk899]

Very useful video. I think before formating to the table, format each cell then convert to table. For inserting additional row, you can press tab at the last column of the to table, just above the sum row. Though the video is excellent

[@Dubailif3]

Great Video Really Apreciate your efford. God Bless you

[@EXCELDOERS]

Ameen

[@vikash-ob2wd]

Hats off to your teaching skills, lots and lots of love from india.

[@MultiRanjha]

Simply i love your teaching style...👍👍👍

[@stc.asif1]

Thanks 💐🌸 alot bhai 🙏 😊 you're so kind May Allah bless you all the happiness and rewards you 🙏

[@EXCELDOERS]

Jazakallah. Ameen. Remember in your prayers. May Allah help us all.

[@stc.asif1]

@@EXCELDOERS ameen sum ameen 🙏

[@eirene3498]

Very well explained, with a lot of clarity on mechanics of ledger & pivot report, Thanks

[@EXCELDOERS]

_Many Thanks_

[@khizarhabibkhan3719]

​ @EXCELDOERS AoA bro i am having some problem with your automation video when i made Ledger out of general journal it shows credit line items first then shows debit line items (there is no problem within Date Column) it is just (Entry structure) presentation problem that i am having can you help me out? i want to show debit line item first and then credit line second of every general entry in Ledger.

[@Cr7ronaldofanz]

Useful video Excel accounting Bro 😊

[@solarenergysolutions1]

Very informative Sir thank you so much ❤

[@MuhammadAbdullah-ck1lx]

Thank you so much brother. You made my life super simple. The most effective, practical, simple, and to the point video ever seen on this topic. May Allah Bless you with success and uncountable blessings

[@EXCELDOERS]

Ameen.

[@SherMubejo]

Thanks Owais Memon Bhai. You have made my life lot more easier. Learnt a lot today. God Bless. 😊

[@faheemakhtar3965]

Bohat bohat pasand aahe excellent skills

[@EXCELDOERS]

Jazakallah

[@zaidsaleem1723]

Amazing course. You've made my life so much easy.

[@Hello-jq6qb]

اردو میں آسان ویڈیو پر زبردست تعریف

[@quantitysurveyor1793]

Thank you sir, for sharing good stuff and Lectures.

[@DreamFirms]

This video is a great help! I learned a lot!

[@RD-nm5eu]

Thanks for splendid information, keep posting video like this.

[@Humayun392]

hank you so much brother. excellent vvvv simple way

[@ekorek1145]

Very knowledgeable. Thumbs up

[@aakaisar76]

Thanks for this...its very helpful and more informational for everyone.....I would be very glad if you make Trial Balance & Balance Sheet along with Journal & Ledger. Thanks again

[@HK-gk8ns]

Yes, please make TB and Balance Sheet video as well. Thank you

[@yobizsolutions]

Check this out. kzbin.info/www/bejne/qoKqZqmNgquSjcU

[@zedanzaki]

Zabardast please make more videos on accounting in excel

[@EXCELDOERS]

Sure I will

[@naveedshahzad8182]

Thank you brother the nice stuff pivot table be very effective. Well-done

[@debapriyabhattacharya5115]

Amazingly simple and effective video. Thanks

[@TheArzueshaoq]

Nice and easy. Please upload a video of complete video of financial statements .... Thanks

[@bharoshkumarthakur4410]

Hello sir, I respect you so much ❤💯 This is awesome for transactions management and also request you to make more best videos like this and also provide all information ...

[@EXCELDOERS]

*_Sure. Stay in touch.. Thank u so much_*

[@bharoshkumarthakur4410]

@@EXCELDOERS why not!! I am always with you ❤💕♥

[@projectdirector512]

@@EXCELDOERS hello there, my dr and cr column is showing blank..

[@greenday1guitarfreak]

Thank you so much! This was massive help!!

[@Loveone-tarotreader]

Thanks 👍 dear 😊 i liked it very much and you helped me

[@aminshaikhkgn2001]

Excellent explanation and easiest way to follow. Jazakallah Khair for making life easy of many. 🎉

[@EXCELDOERS]

Jazakallah and Sukriya.

[@indiangamerz3788]

@@EXCELDOERS Are u porki or Indian

[@jahankhan7238]

A lot of thanks to give some amazing information sir.....

[@kishorpanara4191]

Dear video dekha achha laga pls practice file in distribution thank you sir

[@waseemraja9988]

Great informative video Dear, it solves my problems, Thanks Again

[@shoumafarhan2593]

Thank youu, this is very helping me A LOT

[@ubaidmiandad3040]

Well-done, i apprecite your sheets, plz make clear that gow to make a subsidiary ledger in this sheet and kindly make a trial balance and profit and loss statement as well. Thanks

[@yogeshjoshi6924]

Thank you so much sir....Very helpful ..🙏🙏

[@SreekumarGanesan]

Much appreciated for the tutorial video, keep going.

[@ArtStar_Mishal]

Great, this is quite helpful. Thank you so much

[@ArtStar_Mishal]

Good to see someone from my city, Karachi helping us learn excel and as a simple and useful illustration :)

[@abdulmajeed-gc3mu]

Sir -Great education

[@ashfaquewkhan]

Good One....If there is an category column it will be much helpful to find expense on specific category

[@sayeed.lubaba_2008]

Hello Sir, I respect you so much and also request you to make Trial Balance,Final Account etc... please

[@hasnainshopchk]

Dear It is an interesting and informative video and really helped me to make General Journal, Ledger etc. But I also want to create profit and loss statement by using these entries. So can you help and make video on this.

[@nousophal]

Thank you so much for your video. Could you create income statement and balance sheet by linking this.

[@wasiqtariq6160]

Behtreeen maza aya dekhny m thankyou

[@faharijlal435]

Thanks sir for so much useful knowledge.

[@samadhussain4557]

Thank you sir. It helps me alot 👌

[@Commerce388]

Nice videos and I really appreciated ..Satisfactory

[@muhammadalikunduvayil]

thank you sir, good presentation .

[@EXCELDOERS]

You are most welcome

[@alishaomahoney2144]

Thank you! Just what in was looking for and you explained it so well too❤

[@john7180]

I'm impressed on how you guys don't use an accounting software. Like.. In Brazil we have many just like SAP.

[@sajjadhussain-bb4cw]

Thankyou brother very easy to understand. ❤️

[@anmoljangid551]

Best video for making Ledgers a/c

[@KevinCastillousac]

You are a genius. Thanks friend

[@shafaulislamrazu8030]

I followed all turns to get this file as you instructed to follow. Yet waiting to get this file.

[@EXCELDOERS]

email me

[@thetru4659]

Can you make a video please, how to maintain the accounting of ( Excel) a taxi vehicle business. Vehicle purchase, daily collection, diesel, bata, repair and maintenance, tax and insurance,loan etc. Thank you

[@farhankermani789]

what an excellent video. Very well done

[@CreativeCorner3]

Very Helpful Video. Please Share any Complete Format of GL

[@EXCELDOERS]

Will soon

[@safreenaliyakath8590]

Kudos to you to share this info to all.

[@taxcare8784]

very information video. sir my question is that from that ledger how we make TRIAL Balance, P & L Acc and finally balance sheet.thanks

[@EXCELDOERS]

for TB, use the same Pivot Table with Fields Account Debit and Credit and Balance

[@jaidalexander9375]

@@EXCELDOERS Is there any other video demonstrating the same in trail balance?

[@HK-gk8ns]

+1 please, Thank you

[@mrsimkareem]

Absolutely great explanation! Even though do not speak/understand your language, was able to do this just by watching. Clear and well. The only problem I seem to have is with the date! Somehow it does not organize in my ledger as I want, by oldest first etc etc. Can you help with this? Looking forward to more of this kind of video's.

[@EXCELDOERS]

email me ur file at [e-mail]

[@rivbonstore9646]

great i learn lot from this

[@EXCELDOERS]

Glad to hear that

[@sathyanarayanansatagopan9069]

Thanks a lot. Please explain date wise debit and credit total in two columns and balance in next line, just like in tally cash book.

[@lions4mk]

V.nice video brother Salamat rahen

[@muslimenterprises6919]

اسلام علیکم امید ہے مزاج بخیریت ہونگے۔ بھائ جان آپکی ویڈیو بہت اچھی لگی۔ آپکی اگر کوئی profit calculation and distribute to investor sheet ہے تو برائے کرم مجھے بتائیں۔

[@HMImran-sh7wx]

Sir GJ se ledger tk ap ne vid me bta diya ha kindly agy Profit & LOss kesy bnaye gy isi sheet me ? vid apki bht achi ha i watched twice and perfectly practiced

[@kashifqasim8069]

a very useful video for every one. all the account you took were Dr account ( cash, plant, johon account receivable , etc )on the other hand what about if there were Cr account (liabilities & capital ) as well. if our general has both out how make balance formula.

[@awanflourmill247]

very very nice wheat a great video... superb work great you are amazing brother.... keep it up... love you bro

[@nikkidaily4814]

Thank you so much , it’s very helpful, but why there is no trial balance? Hope to see you update how to creat trial balance ，thank you again 👍👍👍

[@HK-gk8ns]

+1 please, thank you

[@Punjabigmr]

Its really helpful I want learn more Sir

[@EXCELDOERS]

visit my channel for more useful videos in urdu/hindi

[@rfarhad69]

Hello, thanks for u video (automatic bookkeeping, ledger & trile balance), it was so helpful for me in my work place. I have facing some problems which i describing below... How to show pervois balance total. i.e. i have data for three months like april, may & june. i am creating ledger for june, now how to show the balance of previous two month (april & may-as opening balance). If will pleasure to help me to solv this problem...

[@Bangashscc]

Very useful video I APPRECIATE

[@muhammadirfanmansoor7005]

Amazing 🥰🥰🥰🥰🥰🥰🥰🥰 Main to apka fan ho gaya

[@EXCELDOERS]

Love u.

[@ijazabed]

Thanks, dear, your video was very helped full to me, I have created a pivot table, and one problem that I am facing is, when I press refresh it results in changes in the layout of the pivot table. account column gets disappeared and column width gets changed. Can you please help me out on that?

[@EXCELDOERS]

Right click, pivot table setting, uncheck autofit

[@KomalSingh-uq3bx]

Amazing 👍🤞🤟

[@aliaraexpress]

Please make a video with full of accounts. (GJ, GL, BS, P&F, TB) Total accounts.

[@muhammadsaifi]

Love you sir great explained

[@hemantapte5138]

Nicely explained. Thanks.

[@A.R.P.Railway]

Thank you Awais Bhai

[@hayze.d_fine009]

Amazing, you are ... if you can create english and your language for us to understand much better

[@EXCELDOERS]

English version is available on our channel.. please visit

[@Malik-ix2kx]

Thanks. Bery Very Helpful

[@c.a.m.p.sphysiotherapyclin1601]

Loved this video. Thanks

[@biswajitkaran89]

Sir, very very interesting and informative but making Trail Balance is due. Please make it as soon as possible.

[@EXCELDOERS]

I will

[@ibrahimmuhammad9509]

soft too your lecture

[@DipongkarRoyshuvo]

Thank's A lot, It's made my day.

[@silaspaul144]

Please, can you do an English Language version of this video tutorial? Thanks.

[@EXCELDOERS]

Sure.. i ll do this in english in my upcoming videos.. please stay connected to my channel and subscribe.

[@buzztutorials]

you can on captions instead

[@NeilCWCampbell]

I'll admit it was awkward to understand but as above I just used captions.. Thanks for the upload dude...it was appreciated here in United Kingdom 😊

[@Mahakaal-w2j]

No never

[@ramkrishanpal7360]

Hindi sikhiye 😊😊

[@amanurraza8775]

Too informative, Sir.... I literally loved ur methodology 🥰

[@Jamil_14]

Great! Thank you so much