No video :(

👉LEARN CHART OF ACCOUNTS, DOUBLE ENTRY ACCOUNTING, GENERA LEDGER & TRIAL BALANCE IN EXCEL.

Подписаться 3,3 тыс.

Просмотров 39 тыс.

50% 1

A well-designed chart of accounts can impact the accounting cycle that results in the preparation of financial statements.
The accounting cycle starts with making daily entries of your business transactions into the books of accounts using the double-entry accounting principles.
In this training, You will understand the concept of debit and Credit which is the core of double-entry accounting.
You will also learn how to use Excel features and functions to make accounting entries from general journal through to trial balance.
In the second part of this training, you will learn how to prepare Financial Statement from the Trial balance.
To practice, download the workbook here 👇
accountingonex...
------------------------------------------------------------------------------------------------------------------
If you are a beginner in Excel, I have a free course that will help you get started here 👇
• Video
------------------------------------------------------------------------------------------------------------------
How about a template that helps with your bank reconciliation?
Interested, check it out here 👇
/ watchv=bmhnteabf68&lis...
------------------------------------------------------------------------------------------------------------------
Are you in a business that converts raw materials into finished goods?
Then you will love to check out this template 👇
• 👉RECORD-KEEPING EXCEL ...
------------------------------------------------------------------------------------------------------------------
Want to learn how to design simple Excel templates and how to use pre-designed templates, check it out here 👇
• 👉HOW TO EASILY TRACK I...
#dexcelcoach
#generaljournal
#generalledger
#trialbalance
#financialstatement
#doubleentryaccounting
#chartsofaccounts
#microsoftexcel
#accountingonexcel
#excelforprofessionals
#exceltutorial
#excelforaccountants

Опубликовано:

27 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 105

@AccountingOnExcel Год назад

Share your thoughts here in the comment section.

@danielonyedikachiokwandu6927 3 месяца назад

Please can you share a video on using Excel for Inventory account

@AccountingOnExcel 3 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rsYclebbv1M.htmlsi=xvdR54vfJjogYOkg Check the above link for a tutorial on inventory

@harjith.d.bubber 2 месяца назад

🙌

@asarerebeccaakosuaowusua5339 11 дней назад

Thank you

@danielonyedikachiokwandu6927 3 месяца назад

Heroes don't wear capes Thank you for the video

@AccountingOnExcel 3 месяца назад

Thank you for the kind words 🤗 Deeply appreciate 🙏

@IamEffiom 3 месяца назад

I'm a Radiographer with a touch of software development This really helped my mental health Thanks, and God bless you 🙏

@AccountingOnExcel 3 месяца назад

Glad it helped

@gracebosco2976 7 дней назад

Thanks a lot its easy to follow the video. I will try to work out that using the download file

@jeromebarns6151 3 месяца назад

Thank You! Thank You! Thank You! You are a wonderful generous human. May God bless you and I hope you prosper in everything you do ❤

@AccountingOnExcel 3 месяца назад

Amen 🙏 Thank you for the kind words.

@monirajv 8 месяцев назад

Very Useful tutorial, and Thanks for sharing your knowledge and the workbook

@AccountingOnExcel 8 месяцев назад

Glad you got value. Thank you for the feedback

@kalongokazenene8711 Месяц назад

Thank you for your excellent lessons. By following your instructions am able to do work which am proud of. You have saved my life. I really appreciate. I cant thank you enough

@AccountingOnExcel Месяц назад

Thank you for the feedback. Glad you got value ♥️🤗

@ravisanas3110 8 месяцев назад

You are the are teacher I am waiting for years ❤❤

@AccountingOnExcel 7 месяцев назад

Thank you for the feedback and kind words 🤗😊 Glad you got value.

@ivanthomas6262 3 месяца назад

Life saving Wow!

@oladean6375 10 месяцев назад

Thanks for the lecture, Emeka. You did very well.

@AccountingOnExcel 10 месяцев назад

Smiles🤗… Its Amaka, not Emeka Glad you got value. Thank you for the feedback

@moseschikhala5301 10 месяцев назад

You have made everything look so simple! Thanks

@AccountingOnExcel 10 месяцев назад

Glad you got value. Thank you for the feedback

@technovaganza7063 7 месяцев назад

Lucid explanations!!!! Thanks alot

@AccountingOnExcel 7 месяцев назад

Thank you for the kind words. Glad you got value.

@olunaija5620 3 месяца назад

Awesome and very helpful .. 👏👏 thank you

@AccountingOnExcel 3 месяца назад

You are welcome. Glad you got value

@nalinfernando5993 Месяц назад

Nice work, really appreciate it

@giftdubeka8935 7 месяцев назад

Very helpful information. I need more time to learn from you madam

@AccountingOnExcel 6 месяцев назад

Thank you for the feedback. Yeah, just create the time and practice along.

@oladean6375 10 месяцев назад

Amaka, you're my hero, the format is fantastic. Thanks, for sharing your knowledge with us.

@AccountingOnExcel 10 месяцев назад

Smiles🤗🤗 Glad you got value. Thank you for the feedback

@somukienibilly1456 11 месяцев назад

Many thanks for the Video. I am particularly impressed by the moderate steps taken to make the tutorial beneficial to beginners. Speech clarity was top-notch. Thanks again

@AccountingOnExcel 11 месяцев назад

Glad you found this helpful. Thank you for the feedback and kind words 🙏

@pauldoff5464 3 месяца назад

Thank you for the class, indeed I enjoyed the lecture and I really loved the way you simplified the terms.

@AccountingOnExcel 3 месяца назад

Glad you got value. Thank you for the feedback. I really appreciate 🙏

@fortunenwokosi-vp8md 2 месяца назад

This is awesome, thank you

@AccountingOnExcel 2 месяца назад

You are welcome. Glad you got value

@e-vatax 8 месяцев назад

I am from germany watching your videos and I love them. These are help for me to make my own videos for German Accounting videos.

@AccountingOnExcel 8 месяцев назад

I am glad you got value. Thank you for the feedback.

@iamonlygirl 10 месяцев назад

Excellent information. Thanks

@AccountingOnExcel 10 месяцев назад

Glad you got value. Thank you for the feedback.

@danielalphonsussumbi1049 Год назад

Very impressive. I am hight enlighten by this video...

@AccountingOnExcel Год назад

I am glad you got value. Thank you for the feedback.🤗

@WorldCommunity786 11 месяцев назад

nice work continue your efforts i appreciate you

@AccountingOnExcel 11 месяцев назад

You are welcome. Thank you for the feedback

@marksmith4512 5 месяцев назад

I completed the entire lesson and recreated the spreadsheet it was very exciting and helpful. Thank You!

@AccountingOnExcel 5 месяцев назад

Glad you got value and was able to replicate same. Feel free to share 🤗

@marksmith4512 5 месяцев назад

I Just wanted to comment that instead of wrapping the cell with if "", ''" you can use the iferror function within google sheets@@AccountingOnExcel

@DONSOLAS Год назад

Thank you very much. The video was helpful. I need an excel video for beginners.

@AccountingOnExcel Год назад

Glad you got value. Thank you for the feedback. Here is a beginners training playlist 👇 ru-vid.com/group/PL5vOIKGPGFFhhUVuE0jIrYIOSjGc7UkkP&feature=shareb

@subairvc616 6 месяцев назад

Awesome ❤

@AccountingOnExcel 6 месяцев назад

Glad you got value. Thank you for the feedback

@PeterNditi 2 месяца назад

Thank you very much madam, it has helped me a lot

@AccountingOnExcel 2 месяца назад

You are welcome Glad it helped 🤗

@sizomabu1036 7 месяцев назад

Thanks very much

@AccountingOnExcel 7 месяцев назад

You are welcome. Glad you got value

@understandthewordsfeelthes3036 9 месяцев назад

Helpful information 👍👌

@user-sc2jx9bi3u 10 месяцев назад

This is great...thank you

@AccountingOnExcel 10 месяцев назад

You are welcome Glad you got value

@Khadok360 8 месяцев назад

I am from Bangladesh i watching your video and i Learn chart of accounts

@AccountingOnExcel 8 месяцев назад

I am glad you got value. Thank you for the feedback

@user-mi4gj7hl1v Год назад

This is helpful for the basics. Thank you In addition, Vat output needs to be considered in your sales.

@AccountingOnExcel Год назад

You are right. In this training, we focused on the basics. Check out this playlist on Cash book manager. The template handles this aspect 👇 ru-vid.com/group/PL5vOIKGPGFFgQE1rUcmjwGxKJO7sHUZys&feature=shareb Thank you for the feedback. Thanks for engaging.

@MdAlaUddin-wj3bz Год назад

Thank you mam❤️

@AccountingOnExcel 10 месяцев назад

You are welcome

@abubakarolayiwola3188 Год назад

Thank you so much ma for the awesome lecture. I will like to have the dataset for practicing sake. Thanks

@marksmith4512 5 месяцев назад

I love this so much!!! Thank you! IS there anyway to automate the double entries like quickbooks

@AccountingOnExcel 5 месяцев назад

Thank you for the kind words. Based on your specificatio, a custom template can be designed.

@user-vp9kq9cu4l Год назад

Thanks this was helpful please do you have a budget video and format

@AccountingOnExcel Год назад

Glad you got value. Thank you for the feedback. No video on budget yet. Hope to have one soon. Just keep your eyes on this channel 🤗

@ademuyiwaadebanjo8201 Месяц назад

Thank you, this such great effort. Ma, how can one run a monthly report with the knowledge from this class. We used May 2023 as case study. what if i have my transactions running from january to june . Thank you

@marksmith4512 5 месяцев назад

You can use the iserror function to eliminate the N/a errors

@akinofe 11 месяцев назад

Amaka, this is great instruction. I normally have done it from scratch for each of my clients. But there is such wisdom in automating the functions from Chart of Accounts all the way to financial statements. Am going to try to recreate this in prep for my clients. Good work.

@asarerebeccaakosuaowusua5339 11 дней назад

Please what happens when your data is more than a month and to check the general journal every month

@AccountingOnExcel 11 дней назад

The slicers will update automatically and you can easily see buttons for each month. Give it a try and see the impact. Ensure you follow through the steps shown in the tutorial

@pumpkin_mustard4886 Год назад

I think this is amazing! Great Job. One problem I cant seem to get a trial Balance I keep on getting a #Ref I dont think I did anything wrong .. Maybe you can help me figure it out THANKS!

@AccountingOnExcel Год назад

Thank you for the feedback. A #Ref error shows a cell that a formula reference was deleted. Kindly do a second check carefully.

@pumpkin_mustard4886 Год назад

@@AccountingOnExcel it would be great if you put a template together for a nonprofit in excel

@shahriarchowdhury3276 Месяц назад

This is a newly started business for the first year. What about for second year? How could an ongoing business adopt this? Where will be the entry of capital, opening cash balance, opening stocks, opening bank balances, assets, drawings, depreciation, etc., and how those are calculated? Please reply as soon as possible and describe to us elaborately. We anticipate your continued cooperation. Thanks.

@samvargo7124 9 месяцев назад

Thanks so much for the great information on accounting in excel. I have a trial balance I need to enter to get started. Do I enter it in the column ‘Trial Balance’ on the Account Set-Up & Trial Balance spreadsheet or on the Journal Entry General Ledger spreadsheet? Thanks so much.

@AccountingOnExcel 8 месяцев назад

I am glad you got value. For the opening balances I will advice you use the General Ledger to capture it.

@NaalleeyeExplains 2 месяца назад

When you sold 5 units of Perfumes with total of 50,000, and the cost of goods sold of 5 units is 30,000! Then why? The COGS is a part of 50,000 so if 1 unit's cost 10,000 then its 5 units will be 50,000? So what is the COGS? 27:55

@AccountingOnExcel 2 месяца назад

The cost of one unit is 6,000 and the selling price is 10,000. For the sales of 5 units, the cost of sales will then be (6,000*5) which is 30,000 When you deduct the sales from cost of sales, you are left with Gross profit. Hope this answers your question?

@user-qt4cq6sn9g 7 месяцев назад

Please Ma'am, can i have the tamplate to download please

@sandyy9765 2 месяца назад

I can’t download the file, could you please share again ❤

@marcelkalonji6866 4 месяца назад

Amaka, I thank you for your tutorial. I am Marcel from the DRC. Could you end that lesson by establisshing the Cash-flow statement ? Many thanks, Marcel

@ronaldopascua8221 6 месяцев назад

Are Non Current Assets/Liabilities the same as Fixed Current/Liabilities?

@AccountingOnExcel 6 месяцев назад

They are not the same but are all Assests and Liabilities as the case may be.

@technovaganza7063 7 месяцев назад

Thanks mam for the video but unfortunately link for the workbook is not working.

@AccountingOnExcel 7 месяцев назад

I will check it out and revert. Apology on that

@akinofe 11 месяцев назад

Amaka, I wonder if you can make a video of data validation with multiple or dependent drop down list. For instance if my account name is Other Expense, Can I select another list of accounts (or sub account names) that are related to Other Expenses. For instance if one selects Other Expense, can they have a choice of selecting in another column some accounts (Telephone, Supplies, Bank Fees, etc) that are related to Other Expense. I don't know if am making sense?

@AccountingOnExcel 11 месяцев назад

Here is a video that answers the concerns raised👇 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HLZVI_gMeGQ.html&si=0kGO-uGmYBQDEV42 Hope it helps

@qaziqaisir2344 4 месяца назад

Please share sheet

@AccountingOnExcel 4 месяца назад

Kindly check out here 👇 www.accountingonexcel.ng/blog

@gamingwithangrybirds8257 10 месяцев назад

Where can i get this file? Could you please provide file for practice

@AccountingOnExcel 10 месяцев назад

Check the comment section for the link. Glad you got value

@prasadbhaste9067 4 месяца назад

website not open

@AccountingOnExcel 4 месяца назад

Apology on that… Will get it back soon Working on it

@iamonlygirl 10 месяцев назад

Is line 15 supposed to be 100,000?

@DONSOLAS 11 месяцев назад

i cant see insert slicers on my excel

@AccountingOnExcel 11 месяцев назад

First, you need to be certain your data is in an Excel table, then select any cell within the database, notice the table option on the menu bar, click on the design tab, you will see the “Insert Slicer” option in the tools section. There you go. Thank you for engaging.

@SomeName787 5 месяцев назад

I have no clue about accounting. Whatsoever! I just found this video interesting and started watching. Of course, for a novice like me it was kinda confusing, but I was able to follow fairly well. However, I don't understand the entry done in the portion of the clip from approx 29:00- 30:40. It is about "Part Payment to ABC Ltd". If general rule is that Assets are debited and Liabilities credited, why did you switch those two in this example? (for easier following, those are rows 20 and 21 in your Journal sheet) Why did you credited Current Liabilities and credited Current Assets? I thought it should be other way round, following your initial explanations (at 2:30), but after this entry I lost it completely...

@AccountingOnExcel 5 месяцев назад

Your concern is well understood. Thank you for taking time to go through the tutorial. As stated earlier in the training. Default entry for assets is debit - this means whenever there is an increase in assets you debut the account. When there is a decrease in assets you credit the same assets account to recognize the decrease. Same applies to Liabilities which has a default credit balance - meaning any transaction that will increase liability should be credited while any transaction that will reduce liabilities should be debited.