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
@francesbaliddawa734711 ай бұрын
Check that all spellings correct and no spaces. @@ngueukamcharleneaudrey457
@1021132111 ай бұрын
@@ngueukamcharleneaudrey457 same problem
@mirjewel277710 ай бұрын
pls help me
@kwabenagyimah651610 ай бұрын
This guy just taught y''all Accounting in just an HOUR Bravo bro
@SimplesbyAKF11 ай бұрын
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.
@taoreedolalekan25208 ай бұрын
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
@michaelbarber869210 ай бұрын
I thought I knew excel but you taught me quite a few things plus a crash course in accounting. Great job!
@EXCELDOERS9 ай бұрын
most welcome
@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.
@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.
@louietoltolvlog969911 ай бұрын
@@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_18 ай бұрын
@@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_18 ай бұрын
@@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)"
@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
@christopheronga86154 ай бұрын
For a completely ground zero level... I found this content very helpful. Thank you so much. ❤
@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
@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 exceldoers@gmail.com
@pagalkhan486911 ай бұрын
jazak Allah khair brother,, highly knowledgeble and remarkable video..
@islamhussein98166 ай бұрын
your effort is really appreciated, thank you so much from Egypt
@EXCELDOERS Жыл бұрын
Please subscribe to this channel to get more accounting learning material ahead. :) Thank you everyone.
@jeffreysevilla81647 ай бұрын
i had to refresh my excel skills and your video really helped me a lot. great tutorial.. much appreciated.. thanks.. thanks..
@EXCELDOERS7 ай бұрын
Most Welcome
@aikaramba10028 күн бұрын
Awesome! Many thanks for this video. Perfect for small business, no need to spend money on pricey software.
@EXCELDOERS Жыл бұрын
Finally Wait is Over. In continuation of this video, Cash Flow Statement is prepared in following Video. Please watch the learn automating Cash Flow Statement in Excel: kzbin.info/www/bejne/qKjKq5WPh52taLM
@EXCELDOERS Жыл бұрын
For More Videos: kzbin.info
@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
@sidikiekonneh62483 ай бұрын
Thank so much I have learned a lot from this video we need more sir
@sampathkumars365625 күн бұрын
well done sir. Step by step explanation . Clearly understood. Perfect.
@immussssss3 ай бұрын
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
@anandbb1 Жыл бұрын
you are awesome man! You taught accounting to non-account stream people in simplest possible way.
@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.
@abdulkabia-kf2tw25 күн бұрын
Thank you sir I really love this tutorial May Allah reward you abundantly
@EXCELDOERS25 күн бұрын
@@abdulkabia-kf2tw Ameen
@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.
@EXCELDOERS Жыл бұрын
Learn How to automate inventory management in Excel, manage inventory stock balances with inventory register in English. Video link below: kzbin.info/www/bejne/iZfdYYaBgdKsobs
@dondavison5563 ай бұрын
Excellent Presentation! Users should save this for reference. Thank you.
@ExcelExplorers7864 ай бұрын
Your skills have the potential to enhance my work significantly.🙂🙏
@alainmm36324 ай бұрын
FANTASTIC!! I was looking for this type of information for months, and finally found it! Thanks!
@salmanonlinelearning Жыл бұрын
you have performed all the steps in very easy steps. The method of teaching was awesome.
@RareRiddemz5 ай бұрын
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!
@EXCELDOERS5 ай бұрын
Thank u
@NancyMixChannel Жыл бұрын
IM ADDICTED AT YOUR VIDEOS. IVE LEARNED ALOT. THANK YOU FOR SHARING YOUR TUTORIAL
@sumansharma95857 ай бұрын
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 🙏👏👏
@EXCELDOERS7 ай бұрын
Thanks. Explore our channel u will find more stunning usage of excel
@86rashidm2 ай бұрын
Great tips easily learn ever what i had seen another youtube ! Thank you so much
@Sarumanthewhite8889 күн бұрын
Truely impressive, thank you sir! ❤❤❤❤
@EXCELDOERS Жыл бұрын
Learn how to create multiple bulk sheet with VBA Macros automation in Excel in 50 second short video: kzbin.infoJu-pCg1qsVk Subscribe to the Channel for more learning video for Accounting and Excel Tricks
@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.
@Rahma-b7q2 ай бұрын
Thank you are a work of art, from heaven. I love you.
@magnumopus71995 ай бұрын
Creating my own accounting workbook to play around with. Thanknyou so much!
@jenycellgaray41836 ай бұрын
better to watch and do using another pc to follow. very useful. thank you
@nasseralismaily8762 Жыл бұрын
Maa Shaa Allah Allah Bless You Regards from Muscat Oman
@EXCELDOERS Жыл бұрын
Ameen.
@mistydrizzle68865 ай бұрын
My dear you are awesome ❤. I was looking for this for my new company and finally I found here. Thank you so much
@shivarajkarki615811 ай бұрын
What a great work Sir, this is such a simple and huge knowledge of accounting process as well
@EXCELDOERS11 ай бұрын
Thank u :)
@caseyemmanuel85173 ай бұрын
Thanks man for the insight It really worth the data and time spent. My knowledge have greatly increased 😊❤
@jeangreen4324 ай бұрын
Very nice video, thank you for sharing your expertise in accounting with excel!
@kiddielearningtv Жыл бұрын
I am now a fan of your hard work.
@TheCabeir4 ай бұрын
good job.learning in 2024 may
@amifarrell71855 ай бұрын
THANK YOU! Very clear explanation. Well done !
@ErnestKekeli-v2e3 ай бұрын
Thanks so much for sharing your expertise here. Great job
@harjith.d.bubber Жыл бұрын
Really liked the tutorial. Finally I can do my own books. Thank you so much
@EXCELDOERS Жыл бұрын
All the best.
@sandy026685 ай бұрын
That what we call excel ninja 🔥.
@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 ❤️
@tanyaspriggs4586 Жыл бұрын
Just what I needed to get the accounting cob webs out. Thank you so much!!!
@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.
@aslamarshad960911 ай бұрын
@@EXCELDOERShello i need your help bro . How can i get next quarter of month income statement
@salioucisse35046 күн бұрын
100% helful tutorial and many thanks for sharing : )
@blessingkyakaspa39516 ай бұрын
Wow! Quite interesting and well understood. You're a great teacher!
@augustineemmanuel68977 ай бұрын
Wow! bravo you kill it man everything well explained and understood thank God for crossing this video
@EdwardTilley9 ай бұрын
Great tutorial and just long enough to be comprehensive so thanks for this.
@nubiareymos31614 ай бұрын
Thank you for this excellent video. I want to learn more to find a job in account payable.
@nadininikeshala313310 ай бұрын
Thank You for the great excel lesson. Learned so many things.
@nandarlinn Жыл бұрын
I learned a lot from this. Thank You so much.❤
@mommyjill19886 ай бұрын
Because of this video!❤I do subscribe you sir.Salute!
@85MA Жыл бұрын
Quality Work that we benefied all
@davidmukoro11665 ай бұрын
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.
@aanyujesca-e7b6 ай бұрын
Thanks for the work done I have learnt some topics in Accounts.
@chocochoco739228 күн бұрын
Very useful & thank you so much!
@thomasmason8855Ай бұрын
An amazing work. Thanks
@rajeshparsekar29944 ай бұрын
very helpful and simple to understand
@girishghadge8460 Жыл бұрын
Wow what a way to present Thank you so much
@EXCELDOERS Жыл бұрын
You are most welcome
@TheNeilsolaris Жыл бұрын
That's really great, particularly being able to prepare it in just one hour, whilst explaining as you went along. If I were to carry on from here, I'd add a user form, to make data entry much quicker and easier. I could write code to make it impossible to input data that didn't balance. If you used pivot tables for the income statement and balance sheet, I guess you could make it more dynamic, and with some code, you could get the user to enter the date range.
@sweetsforsouls944 ай бұрын
very informative. hope there are more videos like this. Thank you!
@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?
@shahzaibgul86354 ай бұрын
That's a great help. Please make the cash flow statement regarding this topic.
@EXCELDOERS4 ай бұрын
It is already there in seperate video
@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.
@giftcp826 ай бұрын
Youve earned my sub and like. This is awesome
@rajdruk8 ай бұрын
very good teaching, thank you very much
@EstherLance-lm9mf4 ай бұрын
Great job , very helpful 👏
@lovelypanda5 ай бұрын
WOW, thanks for the tutorial! Love it ❤
@mutasimelmubarak4341 Жыл бұрын
really u did great usefully jobs which is helpful a lot...Many thanks
@mkarvj9 ай бұрын
Thank you so much for the video sir. This is very much informative and useful
@EXCELDOERS9 ай бұрын
your most welcome
@princeobinna75183 ай бұрын
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
@JasonNukuse-do7sy3 ай бұрын
you are very good,please do part 2 for the following year
@francislungu8 ай бұрын
Thank you so much! I love how you teach
@EXCELDOERS8 ай бұрын
U r most welcome
@androidtvbox28913 ай бұрын
I like your video a lot and trying to replicate the same thing in Google Sheets. However there is a minor mistakes in your video. It should be "Journal Entries" instead of "General Entries".
@finalmale7 ай бұрын
Excellent job done ❤
@MohamedRagab-ud7ct4 ай бұрын
Helpful thank a lot , Jazak Allah Khair
@rotimioladunni77619 ай бұрын
This is awesome. Thanks for sharing, I learnt a lot from this
@EXCELDOERS9 ай бұрын
Most Welcome
@MotiarAlim5 ай бұрын
Vary good presentation !!!!!!
@jerrymamangun11087 ай бұрын
Thank you for this wonderful video.
@mansareddy76319 ай бұрын
Really great video! Explained very well. Thank you!
@joannebranzuela2684 Жыл бұрын
Thank you so much! I love how you present it. I learned more about Excel and can now use it for my bookkeeping. I wish you include a Statement of cash flows up to closing. Thank you😘😘😘
@EXCELDOERS Жыл бұрын
Video Uploaded for cash flow statement kzbin.info/www/bejne/qKjKq5WPh52taLM