Hahah, it's a small collection of macros I've made over the years to speed up my workflow. I am cleaning it up and re-writing some of the tools to work better and plan to share it after that. You will get a link once it's ready if you are subscribed to our newsletter at magnimetrics.com/newsletter-sign-up/
Amazing video much helpful in practical life. Please make more videos on trail balance and FS with much more detail. Please also share file guide and reference .Thank you for this great videos
Hello Dobromir, Great video. Two question: Is this mapping tutorial good for both GAAP and IFRS financial statements generation? And, how can I get a copy of your excel mapping template?
Hi John, yes the concept in the video can be applied to both GAAP and IFRS. However, you will have to ensure you present everything as required by the relevant standards, as well as make any GAAP/IFRS adjustments to the final mapped numbers. The tutorial only shows how to get from a TB to a mapped FS, but you will have to make sure you are using the proper mapping for the specific case. I wouldn't say this is a template that you can just apply, it's more of a concept you need to follow. There's a link in the description of the video on where to find the Excel file, hope it helps :)
Amazing . Sir Pls advise I need to learn more and more and be expert in preparing TB PL and BS and would like to join the tutorials if any available. Thanks
Great Lesson. Sir I think it could be a good idea to produce a comprehensive Udemy/Skillshare course on ''TB mapping to create FS along with year end adjustments!? So we can have more firm level experience
This is quite a bigger topic. Generally, you can place all the notes on separate sheets and then follow the same approach, just add another Column in the Trial Balance, call it "Notes Mapping" and add your mapping there for the notes. Be careful not to use the same term twice. Example: If you have notes for Hired Services and Material Expenses, you can have a line Other in both. If you use "Other" in your Notes Mapping, you will end up adding both Hired Services' Other and Material Expenses' Other, so you should name the Notes Mapping uniquely, let's say HS-Other and ME-Other in this example. If you are looking to make a full set of Financial Statements with the notes, I would suggest checking for a web course like on Udemy or something like that.
You're welcome. If you are interested, I have a lot of financial articles on our analysis platform, magnimetrics.com Maybe something there might be helpful as well :)
I would assume they follow a similar approach. Perhaps, in a more complex scenario (e.g. a large public company), you will have a lot more analytical dimensions within accounts, so you might have to export various breakdowns and additional data to build the FS. However, the largest companies I've worked with (way smaller than Amazon, but in the hundreds of millions in revenue) have had automations in their ERPs where a combination of predefined mappings and strict journal entry controls resulted in the FS being pretty much automatically populated (with the exception of some disclosures and more specialized adjustments). However, the concept of mapping a detailed breakdown to a more aggregated view is always the same. Hope this helps 😊
Hello Dobri, as you know that TB deffrenciate from company to other company so if I want to do my own by this file to link FS with TB i have to fill each item from our TB plz advise
I've never really used accounting software, only exports from the accounting system of the companies I've worked for. I would guess all software solutions in the accounting space can do proper work, as long as they are configured correctly and the users know what they're doing.
How supplier advances is asset? Advances are given for goods and services which is not accomplished yet. So it is an Unearned Revenue and would be a current liability
Hi Shaikh, thank you for the question. Advances that Clients have given to us are Unearned Revenue and presented in current liabilities. However, advances we have given to our Suppliers when we have prepaid for goods/services are Current Assets. Hope this helps.
hi, awesome video, can you please share this file for our guide and reference, it will be a helpful for starter like us..thank you in advance for your help.
Well done .
Thanks, glad you liked it 😊
Excellent! Well explained. Lucid, concise and Crisp.
Glad it was helpful! 😊
Thank you! I love the video, it is very practical,the way you explain in simple way and your excel skills
Glad it was helpful, thanks :)
oh
good one
Thank you! Cheers! 😊
Thank you so much. Please do more and more videos for us.
Thank you, I will
Awesome, you are quick fingered! Do you have a follow-up on this to cover indirect method cashflow? Thank you!
Thanks! Haven't thought of making a video on preparing a cash flow statement, will think about it ;)
Nice video, i am wondering what does the custom tab called D-tools contain
Hahah, it's a small collection of macros I've made over the years to speed up my workflow. I am cleaning it up and re-writing some of the tools to work better and plan to share it after that. You will get a link once it's ready if you are subscribed to our newsletter at magnimetrics.com/newsletter-sign-up/
@@MintyAnalyst that’s what I thought, I’ve subscribed and waiting.Thanks
Great video , I like this template
Glad it was helpful :)
Amazing video much helpful in practical life. Please make more videos on trail balance and FS with much more detail. Please also share file guide and reference .Thank you for this great videos
Hi Haris, thanks for the comment. There's a link in the video description, you can download the file from there.
@@MintyAnalystHi Dobromir thanks for reply. Please help the link is not working
@@harismuhammad1569 it is working, just checked it again: magnimetrics.com/excel-downloads/
It's working now. Thank you
Plz make some more detail video on trail balance data mapping and then making 5 financial statements
Thank you for sharing this.
Thank you for the comment, glad it was helpful 😀
Wonderful man....you beauty
Heh, thanks Habib!
This is great Thank you for sharing!
Glad you enjoyed it!
Perfect! Just what I need.
Thanks, glad it was useful :)
Hello Dobromir, Great video. Two question: Is this mapping tutorial good for both GAAP and IFRS financial statements generation? And, how can I get a copy of your excel mapping template?
Hi John, yes the concept in the video can be applied to both GAAP and IFRS. However, you will have to ensure you present everything as required by the relevant standards, as well as make any GAAP/IFRS adjustments to the final mapped numbers. The tutorial only shows how to get from a TB to a mapped FS, but you will have to make sure you are using the proper mapping for the specific case. I wouldn't say this is a template that you can just apply, it's more of a concept you need to follow. There's a link in the description of the video on where to find the Excel file, hope it helps :)
Well explained
Thanks for sharing...
Please keep it up...
Thanks, I am trying to focus more on Excel tips and tutorials lately, so hopefully videos will get better and more informative :)
@@MintyAnalyst Hi please share more videos for same subject. Kindly share excel file also. Thanks
Amazing . Sir Pls advise I need to learn more and more and be expert in preparing TB PL and BS and would like to join the tutorials if any available. Thanks
I am always looking for new video ideas, feel free to share what you'd like to see next!
Great Lesson.
Sir I think it could be a good idea to produce a comprehensive Udemy/Skillshare course on ''TB mapping to create FS along with year end adjustments!?
So we can have more firm level experience
I am working on something like that but it's still early stages, and it's hard to dedicate time to it. Will happen eventually :)
Hello sir, Thanks for the video.
How in case of preparing FS including Notes to accounts and then mapping?Please guide.
This is quite a bigger topic. Generally, you can place all the notes on separate sheets and then follow the same approach, just add another Column in the Trial Balance, call it "Notes Mapping" and add your mapping there for the notes. Be careful not to use the same term twice. Example: If you have notes for Hired Services and Material Expenses, you can have a line Other in both. If you use "Other" in your Notes Mapping, you will end up adding both Hired Services' Other and Material Expenses' Other, so you should name the Notes Mapping uniquely, let's say HS-Other and ME-Other in this example. If you are looking to make a full set of Financial Statements with the notes, I would suggest checking for a web course like on Udemy or something like that.
@@MintyAnalyst I am grateful for your assistance Sir.
You're welcome. If you are interested, I have a lot of financial articles on our analysis platform, magnimetrics.com
Maybe something there might be helpful as well :)
@@MintyAnalyst Alright sir :)
@@MintyAnalyst How about a column cross-reference and use that as a numbering reference ? Every line item usually has a cross reference to notes
How to make financial statements from trial balance of a really large company say like Amazon
I would assume they follow a similar approach. Perhaps, in a more complex scenario (e.g. a large public company), you will have a lot more analytical dimensions within accounts, so you might have to export various breakdowns and additional data to build the FS. However, the largest companies I've worked with (way smaller than Amazon, but in the hundreds of millions in revenue) have had automations in their ERPs where a combination of predefined mappings and strict journal entry controls resulted in the FS being pretty much automatically populated (with the exception of some disclosures and more specialized adjustments). However, the concept of mapping a detailed breakdown to a more aggregated view is always the same. Hope this helps 😊
This is awesome.
Can you pls share this particular file?
You can find the link for download in the video description, I just added it.
What happens if the trial Balance gets mixed accounts? Let’s say you have 1.1, 1.2, 1.2, 1.1, 1.2 etc…
In my experience, account numbers are always unique, so using a simple vlookup/xlookup shouldn't be a problem. Or do you mean something else?
Superb..❤❤
Thanks 🤗
Hello Dobri,
as you know that TB deffrenciate from company to other company so if I want to do my own by this file to link FS with TB i have to fill each item from our TB plz advise
Yes, you have to, but the beat part is that TBs don't change a lot, so once you set it up, next year/quarter/month, updating it is a breeze 😉
Yes, you have to, but the beat part is that TBs don't change a lot, so once you set it up, next year/quarter/month, updating it is a breeze 😉
you are great lovle
thanks 😁
Can u upload vedio relating to proper software of accounting pls
I've never really used accounting software, only exports from the accounting system of the companies I've worked for. I would guess all software solutions in the accounting space can do proper work, as long as they are configured correctly and the users know what they're doing.
Excellent
Glad it was helpful!
How supplier advances is asset? Advances are given for goods and services which is not accomplished yet. So it is an Unearned Revenue and would be a current liability
Hi Shaikh, thank you for the question.
Advances that Clients have given to us are Unearned Revenue and presented in current liabilities. However, advances we have given to our Suppliers when we have prepaid for goods/services are Current Assets. Hope this helps.
Sir great
Thank you, glad it was helpful :)
hi, awesome video, can you please share this file for our guide and reference, it will be a helpful for starter like us..thank you in advance for your help.
I just added the link in the video description
oh
exactly ;)
What’s with the music?! Great lesson though!
I honestly don't know, I guess I thought it was a good idea 3 years ago 😅
sir share this file
link in the description
Pl sand template
hi there, not sure what you mean...
Dear sir sand this sample file
@@bhavneshparikh8283 the link is included in the video