How to automate Accounting Ledger, Trial Balance, Income Statement, Balance Sheet in Excel | English

[@EXCELDOERS]

Download File: downloadexcelfile.com/products/automate-accounting-excel-learning-file-youtube

[@mayamipk57]

That's a great help thanks

[@ngueukamcharleneaudrey457]

Please help me. My vlookup formula from sales and trial balance gives me errors. And I don't know how to fix this. Please help

[@francesbaliddawa7347]

Check that all spellings correct and no spaces. @@ngueukamcharleneaudrey457

[@10211321]

@@ngueukamcharleneaudrey457 same problem

[@mirjewel2777]

pls help me

[@kwabenagyimah8]

This guy just taught y''all Accounting in just an HOUR Bravo bro

[@LRR-333]

and all the required EXCEL knowledge to make it work!!

[@SimplesbyAKF]

Thanks bro. I'm a Finance Professional but for some reasons forgot all these things but due to this video i remember the basics plus it is in MS Excel and not any other fancy software. So many thanks.

[@taoreedolalekan2520]

This is a standard video on excel. you have done a great job in showing how to write up a final account with excel. well done sir

[@taiwowinjobi5720]

I'm an economist but has little knowledge of accounting with excel. This wonderful piece is highly explanatory and easy to understand. This is a free rare gift. Thank you for this great job. Much love from Nigeria❤

[@EXCELDOERS]

Thank u sir. It is an honor having u on our channel. Explore our channel for more such rare gifts.

[@louietoltolvlog9699]

@@EXCELDOERS Thank you. For restaurant, sales (will it include sales tax?) and cost of goods sold (will this be a purchased goods for making a sale). If restaurant makes monthly gross sales $600k in Sep. When they buy foods, food ingredients, kitchen supplies, do they all include cost of goods sale? Or kitchen supplies going to expense or equipment?

[@DarkWarrior_1]

​@@louietoltolvlog9699 no, look if we talk about it from accounting perspective, there are some costs which we call production costs which we include in inventory and ultimately charge them to cost of sales and there are some other costs which we call non production costs which are charged to statement of profit or loss for the period like administration, marketing and selling costs. Coming to your question, kitchen supplies for a restaurant which serves food would be production costs thus charged to cost of sales. In accounting we actually absorbs those costs in the products we produce because of certain financial reporting requirements to value inventory however for simple business like a restaurant you should charge them to cost of sales.

[@DarkWarrior_1]

​@@louietoltolvlog9699 costs of sales will include all costs including opening inventory, purchases during the month and wages of workers producing and serving food less closing inventory. Here is the formula Cost of sales = Opening inventory + Purchases during the period + Wages of workers -- closing inventory And yeah, if restaurant is required to pay income tax on earnings then this will include it if not then you don't need to include income tax.

[@SAMxIGRIS]

@@EXCELDOERS @38:31 How to do that Freeze thing? while selecting column C to E??? how to freeze them? >>>>>>>>>>>>>>>>"=VLOOKUP(F4,'Chart of Accounts'!$C:$E,3,0)"

[@michaelbarber8692]

I thought I knew excel but you taught me quite a few things plus a crash course in accounting. Great job!

[@EXCELDOERS]

most welcome

[@RareRiddemz]

I was looking for an easy way to build a ledger and link to TB. This is by far the BEST tutorial for that! Thank you!

[@EXCELDOERS]

Thank u

[@asifiqbal844]

The video was excellent, presenting the content in a straightforward and uncomplicated manner. I gained a wealth of knowledge from it, and the concepts were made easily understandable.

[@Wia_Creations]

This is awesome work. Not many presenters show and demonstrate the entire process of accounting acycle work. You also completed with free excel templates. Keep it up.

[@m.p.9438]

excel template is not free

[@ritiksingh8067]

This Guys clear all doubts realted to accounts just in one hour .

[@pagalkhan4869]

jazak Allah khair brother,, highly knowledgeble and remarkable video..

[@helenhussien8363]

Amazing vedio. We all struggle getting along with all these expensive software .your vedio is simplifies all. God bless u

[@Ms.MM084]

You are a LEGEND!!! THANK YOU SOOOO MUCH! You have saved me time and energy and added value to my business

[@EXCELDOERS]

You r most welcome. We can add more value in to business.. contact at [e-mail]

[@islamhussein9816]

your effort is really appreciated, thank you so much from Egypt

[@Mostafaahmedheshmat]

I would like to show the utmost respect and appreciation for these helpful video , thank you so much bro

[@EXCELDOERS]

@user-kh5xo1ne2u you r most welcome

[@Mostafaahmedheshmat]

Any other video of analyzing expenses using pivot table as well please​@@EXCELDOERS

[@muhammadnasir6145]

Just Geniuses............Subscribed just in one show. Thanks for well work.

[@bensonvah8141]

Bravo Sir. This is a brilliant peace of tutorial. It opened my eyes more. Thanks.

[@anandbb1]

you are awesome man! You taught accounting to non-account stream people in simplest possible way.

[@salmanonlinelearning]

you have performed all the steps in very easy steps. The method of teaching was awesome.

[@khinmaungtun4810]

I have been looking for this kind of things since 2015. Thank you so much for posting it.

[@EXCELDOERS]

My pleasure. Explore more on our channel and share with friends

[@AliHassan-nm3ks]

Thank you sir for this I am an accounting student. I have learnt from this lesson more I did in the school so far .

[@EXCELDOERS]

Great to hear that. Our schooling system is really far behind.

[@christopheronga8615]

For a completely ground zero level... I found this content very helpful. Thank you so much. ❤

[@thePowellsUnited]

Wow, this is the best I've seen for Excel finance! very well done!

[@immussssss]

Very nicely elaborated begins from the chart of accounts to till balance sheet , Awsm with single excel sheet .If the father of accounting Luca Pacioli alive still he would be really appreciated you . Thanks sir . helped a lot .This is more than the any accounting software

[@SDBV-OD30]

Greatest among all the videos i have ever seen on excel accounting ledger 👍👍👍👍

[@zuhanbizmian4116]

Nice video for Self Employed and who want to do Accounting himself, Nice teaching

[@KingdomUmrah]

I refresh my accounting knowledge by this video. thanks a lot from my bottom of heart for making such a wonderful, professional Accounting video.

[@isyahtajul]

Thank you so much for doing this tutorial! I can't buy the template because I'm short on money, but still, thanks for doing this tutorial for people who can't buy your template!

[@shehzadahmad971]

The best ever Excel presentation I watched. It made alot of things easier. Thank you. Also do one for complex entries

[@EXCELDOERS]

Thanks for admiring our content. Yes that is in plan for next videos.

[@yoya9193]

thank you, just finished your lecture. everything balanced out.

[@nasseralismaily8762]

Maa Shaa Allah Allah Bless You Regards from Muscat Oman

[@EXCELDOERS]

Ameen.

[@aikaramba100]

Awesome! Many thanks for this video. Perfect for small business, no need to spend money on pricey software.

[@NancyMixChannel]

IM ADDICTED AT YOUR VIDEOS. IVE LEARNED ALOT. THANK YOU FOR SHARING YOUR TUTORIAL

[@mmkgaming7642]

PLEASE CLEAR MY CONFUSION THAT HOW DID YOU FREEZE THE STATEMENT WHEN YOU WROTE SALES @ 39:28

[@EXCELDOERS]

Press function key F4 after selecting range

[@philosopherkizito911]

Hello @EXCELDOERS, thanks for making this video. Please do you have a video for year 2? To show the effects of retained profits or loss that will be carried over the next year on the ledger, Income statement, balance sheet and cash flow statement

[@sampathkumars3656]

well done sir. Step by step explanation . Clearly understood. Perfect.

[@mohammadkamran9727]

Wonderful Job. This was my Dream but I was not expert in Pivot table. Thank you very much. Fantastic Job Great Sir.

[@adnileb7033]

New subscriber here. Thank you for this wonderful video. This is very helpful for someone like me who wants to learn about using excel. Watching from Philippines.

[@abdulkabia-kf2tw]

Thank you sir I really love this tutorial May Allah reward you abundantly

[@EXCELDOERS]

@@abdulkabia-kf2tw Ameen

[@KaziMohiuddinAhmad]

This is good for beginners understanding well. Thank you.

[@jeffreysevilla8164]

i had to refresh my excel skills and your video really helped me a lot. great tutorial.. much appreciated.. thanks.. thanks..

[@EXCELDOERS]

Most Welcome

[@sharifullahfayez339]

You just done a great job dear honorable teacher million of thanks

[@msveephilippines]

I am now a fan of your hard work.

[@blessingkyakaspa3951]

Wow! Quite interesting and well understood. You're a great teacher!

[@sidikiekonneh6248]

Thank so much I have learned a lot from this video we need more sir

[@mistydrizzle6886]

My dear you are awesome ❤. I was looking for this for my new company and finally I found here. Thank you so much

[@shivarajkarki6158]

What a great work Sir, this is such a simple and huge knowledge of accounting process as well

[@EXCELDOERS]

Thank u :)

[@sumansharma9585]

What a great and precise explanation of full cycle accounting in a clear way and top of that great usage of excel. Great job sir 🙏👏👏

[@EXCELDOERS]

Thanks. Explore our channel u will find more stunning usage of excel

[@harjith.d.bubber]

Really liked the tutorial. Finally I can do my own books. Thank you so much

[@EXCELDOERS]

All the best.

[@jenycellgaray4183]

better to watch and do using another pc to follow. very useful. thank you

[@dondavison556]

Excellent Presentation! Users should save this for reference. Thank you.

[@davezdgalmancornelius6388]

This is awesome. The best Excel KZbin channel I watched so far.

[@EXCELDOERS]

Thank you for bring part of this community by subscribing to our channel.

[@EXCELDOERS]

Please subscribe to this channel to get more accounting learning material ahead. :) Thank you everyone.

[@BMNAZEEB72]

sure

[@noorealamsiddiqi8434]

Hi! May I know how did you did you make this formula $C:$E?

[@alainmm3632]

FANTASTIC!! I was looking for this type of information for months, and finally found it! Thanks!

[@MichaelJames-lt1vn]

Thanks a lot sir, your way of presentation was really nice and easy to follow

[@yneigmapsyko]

This video was an absolute gift. Thank you so much for teaching such valuable information like this.

[@EXCELDOERS]

You are most welcome. Stay connected and explore our channel for more gifts inside.

[@adyar23]

Thank you for teaching the basics of accounting. Being a Science student, this is the first time that I'm learning Accounting. Suppose, I'm doing consulting services, will my Account still be written as Sales? Secondly, if my partner is contributing to the business, under which Head should I mention?

[@izzuanafiq2489]

Ty, I got new job because learn from this

[@EXCELDOERS]

It s great to hear that. Congratz

[@assanjatta1136]

This video is really helpful but what is the shortcut you use to link the two worksheets I.e chart of accounts and general entries ?

[@EXCELDOERS]

I did not use any shortcut. Watch again..

[@assanjatta1136]

@@EXCELDOERS am having a problem with the data validation ranging the cells from the chart of accounts. I think you link the two worksheets that’s why you got it correct. So I will like to know how do that also

[@ExcelExplorers786]

Your skills have the potential to enhance my work significantly.🙂🙏

[@86rashidm]

Great tips easily learn ever what i had seen another youtube ! Thank you so much

[@anlynenyambu619]

I like this video ... could you please show how I can input my entries in a situation where it's a continuing business you have opening stock balance

[@tanyaspriggs4586]

Just what I needed to get the accounting cob webs out. Thank you so much!!!

[@RehanAshraf-o7b]

very nice, you have taught in very good way" Sumander ko Kozay main band karny wali baat hai. yeh sub accounts parhany waly student ko dekhna chahye.

[@mutasimelmubarak4341]

really u did great usefully jobs which is helpful a lot...Many thanks

[@bilaliqbal4629]

Excellent video + For balance Sheet we can add a little bit of work to automate it combining countif formula making it dynamic count and v lookup fixed assets current assets to make to more automatic and smooth. I agree it will make the work more complex for beginners to intermediate excel users. Anyhow Thanks for the efforts. Love & Peace ❤️

[@NadeemIqbalFranchiseAccountsHe]

thank you so much for your response. i want to ask about the Dashboard on this system

[@augustineemmanuel6897]

Wow! bravo you kill it man everything well explained and understood thank God for crossing this video

[@davidmukoro1166]

Whaoo. This is great indeed. I would have love you to add Fixed Asset with Drepreciation, so that Accumulated Depreciation Expenses can be seen in the Income Statement and Net Book value can be seen in the Balance Sheet.

[@mommyjill1988]

Because of this video!❤I do subscribe you sir.Salute!

[@magnumopus7199]

Creating my own accounting workbook to play around with. Thanknyou so much!

[@jeangreen432]

Very nice video, thank you for sharing your expertise in accounting with excel!

[@nadininikeshala3133]

Thank You for the great excel lesson. Learned so many things.

[@oyetayoadekola]

@exceldoers Hats off to your simple explanation. I noticed when the transactions increased in the journal and GLs, the Vlookup didn't expand automatically except you tweaked it manually. Can you show how Index and Match or any other tool could be used to address the weakness of Vlookup?

[@EXCELDOERS]

V easy. Instead of range Select whole column in formula

[@oyetayoadekola]

@@EXCELDOERS Oh, really! Thanks for that. Could you give a little guidance on that, please?

[@camondavids4084]

Great video, simple and to the point. Been waiting for something like this. You have most definitely earned a subscriber!

[@EXCELDOERS]

Welcome to the community. More to come ahead.

[@aslamarshad9609]

​@@EXCELDOERShello i need your help bro . How can i get next quarter of month income statement

[@syedkamraniqbal1433]

Can you plz guide how to incorporate opening balances in pivot table ledger

[@olufunmilolalawal8855]

This is really awesome. But there's a particular thing you did on that ledger sheet where the description change,I didn't quite get that part,seems like it skipped

[@EXCELDOERS]

Can u tell me time and second

[@EdwardTilley]

Great tutorial and just long enough to be comprehensive so thanks for this.

[@phemotee]

Excellent presentation my question are; 1, can I continue the journal entry and pivot table continue automatically. 2. Can I report income and balance sheet monthly with automate selection when January to December have been posted.

[@shahzaibgul8635]

That's a great help. Please make the cash flow statement regarding this topic.

[@EXCELDOERS]

It is already there in seperate video

[@marksmith4512]

If you add more income or expense categories will your report dynamically change to accommodate them ?

[@EXCELDOERS]

PNL and BS u will need to adjust. Rest will be adjusted

[@princeobinna7518]

Hello very great videos. Im new to excel and i notived youre very fast when doing data validation. My excel didnt do it like yours. Carr to help

[@taffyjones1642]

Fantastic video! So, if you are extracting the Trial Balance, how would you account for the opening balances in the respective accounts? This Trial Balance seem to be based only on transactions in the month.

[@EXCELDOERS]

@@taffyjones1642 u can filter the closing date

[@sergiopena2476]

Thanks to your video. Just have used it to organize my LLC accounting 🙌 The only problem I’m facing is my journal has around 600 entries and Excel is getting slower. Anyway I can handle that.

[@suzumuyaha48]

Thank you for this, it help me alot on starting it. I do have a question. If we are receiving money from clients it goes to Sales category right? Then how do we transfer it to cash or bank?

[@ilinkasoro8281]

I like your video. Thank you so much. Can you please show us how to input Trial Balance-beginning balances from the prior year into the current year Trial balance sheet?

[@nubiareymos3161]

Thank you for this excellent video. I want to learn more to find a job in account payable.

[@prince0768-t2l]

Best Video brother. What about the next financial year? would we continue on with the steps you have shown or is there some additional Excel settings we need to put in for the next financial years...

[@giftcp82]

Youve earned my sub and like. This is awesome

[@caseyemmanuel8517]

Thanks man for the insight It really worth the data and time spent. My knowledge have greatly increased 😊❤

[@salahudheenkm1974]

If i do like this, can i get P&L and BS for specified period? and how can i enter opening balances?

[@girishghadge8460]

Wow what a way to present Thank you so much

[@EXCELDOERS]

You are most welcome

[@innocentobigoldson22]

good day to you bro! I love your teaching so much. ln fact I have learnt a lot and mostly how better to use an excel sheet for accounting but I have a question, hw will the new month transaction be separated from the old month transaction if i need to prepare a month end income statement.

[@kebbajabang5636]

This is really helpful. How do I add a row(project name )on my worksheet?? Since am handling more than one project components ??

[@yeSMglobalaccountancytutoring1]

This video is super informative, I really loved it. I have a doubt, Why do we format the values as "number" instead of "currency" or " Accounting"?

[@EXCELDOERS]

it is up to you. it is about presentation.. some people prefer mentioning currency sign on top instead of showing in each line.

[@horizondigital6516]

Very well explained!!!! can you please tell me is there anyway to get this model in excel format to use it for my small online business. if it is not free then please let me know what is the price. Thanks

[@EXCELDOERS]

Kindly email me @ [e-mail]

[@rajapraturi9905]

Excellent Trial balance and GL prep in excel. Pl include with multiple cash and bank book entries

[@EXCELDOERS]

Many thanks

[@kotsitsashvilinika9662]

Best video ever! Thank you man.

[@AyubKhan-zr4zt]

Good job Sir, your work is really amazing ❤

[@HK-gk8ns]

Thank you so much!!! Can I apply this to keep track of rental income?