You should watch the part one before watching this. Here is the link to the first part of this training👇 th-cam.com/video/ipLpVBN2FYo/w-d-xo.html&feature=shareb
This is very helpful to prepare transaction reports. And, would you, please continue with preparing the cash flow statement and financial ratios analysis, so that it will be complete package of the report?. Thank you!
Thank you for the lecture, ma. However, why did you use the Charts of Account to prepare your trial balance instead of the Journal Entries sheet? Can't we have our trial balance on the Journal Entry sheet instead?
Glad you got value… Looking at the journal entry sheet, you will notice there is a control that ensures every transaction entry balances off. In regards to your question, the trial balance can also be generated from the journal entries. This we did using the chart of account which makes up our general ledger. You can also generate on a different sheet if you so wish. It is not cast on stone. Thank you for engaging.
Good work again Amaka. It is interesting to see how formats are different in the Nigerian system of financial statements and the US System. Here we put Current accounts first and Non Current accounts below in the Balance Sheets. But its all presentation preferences. I enjoyed it. I hope to be able to automate and have the financial statements automatically populate... with minor tweaking as needed. Thanks again. My name is Femi
Thank you Femi for the feedback. Regarding the structure I believe is same. We start with the current too. Guess I did not take that into consideration when putting up this training. Well noted! Having the financial statement populate automatically is possible with minor tweak as you stated. Hope to share better ways soon 🤗 You are welcome. Thank you once again.
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.
Smiles… Thank you for engaging. This tutorial did not cover the aspect of your concern. However, a little tweak can be done to accommodate existing business and how to capture beginning balances. Hope to cover this in another video as text explanation will not do justice to it.
You should watch the part one before watching this.
Here is the link to the first part of this training👇
th-cam.com/video/ipLpVBN2FYo/w-d-xo.html&feature=shareb
It's helpful for me, thanks.
You are welcome…
Glad you got value
Thank you very much for this sharing and I feel your professional accounting guiding is a huge helpful to me.
You are welcome
Glad you got value
Different and unique Techniques 🤗
Thanks for your training and your Templates!
You are welcome.
Glad you got value
Helpful information 👍👌
This is very helpful to prepare transaction reports. And, would you, please continue with preparing the cash flow statement and financial ratios analysis, so that it will be complete package of the report?. Thank you!
Your request is well noted
Thank you👌
Interesting training Amaka! Great Job!
Thank you for the feedback.
Glad you got value
Thank you for the lecture, ma. However, why did you use the Charts of Account to prepare your trial balance instead of the Journal Entries sheet? Can't we have our trial balance on the Journal Entry sheet instead?
Glad you got value…
Looking at the journal entry sheet, you will notice there is a control that ensures every transaction entry balances off.
In regards to your question, the trial balance can also be generated from the journal entries.
This we did using the chart of account which makes up our general ledger.
You can also generate on a different sheet if you so wish.
It is not cast on stone.
Thank you for engaging.
@@AccountingOnExcel Thank you so much
Good work again Amaka. It is interesting to see how formats are different in the Nigerian system of financial statements and the US System. Here we put Current accounts first and Non Current accounts below in the Balance Sheets. But its all presentation preferences. I enjoyed it. I hope to be able to automate and have the financial statements automatically populate... with minor tweaking as needed. Thanks again. My name is Femi
Thank you Femi for the feedback.
Regarding the structure I believe is same.
We start with the current too.
Guess I did not take that into consideration when putting up this training.
Well noted!
Having the financial statement populate automatically is possible with minor tweak as you stated.
Hope to share better ways soon 🤗
You are welcome.
Thank you once again.
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.
Smiles…
Thank you for engaging.
This tutorial did not cover the aspect of your concern.
However, a little tweak can be done to accommodate existing business and how to capture beginning balances.
Hope to cover this in another video as text explanation will not do justice to it.
Hi, please how can we get this file to practice
Check the description section for the link.
I cant manage to download the excel book attached, any help?
Working to get the site back
individual salary advance & and individual Payable salary , show general income s. & balance sheet per month
Thank you for engaging.
The transaction mentioned can be captured.
And monthly income statement and balance sheet can also be prepared.
Pl Provide Sample File?
Check the description section for the link
Alredy check it but it is incomplete file
@@bhavneshparikh8283 I shared the practice file do you to practice along.
The essence is for you to learn by doing.
@@AccountingOnExcel can you share complete file?