I was literarily screaming after seeing your TB audit video and it was so helpful for the Audit i will be doing for a company next week. Thanks a lot for all the nuggets and analysis tips. They were so helpful. Please could you do videos for auditing all line items on the balance sheet? Thanks🍀
Thank you much for these useful tips, I am also an auditor and struggled my way to format a client's aging schedule. have not looked at your other videos, but if you don't have a video on how to format a GL detail, can you please educate us on that?
Question, what's the best way for an auditor/accountant to real grasp journal entries and knowing how they affect/impact financial statements across the board (cashflow, balance sheet, tax returns, etc). I really want to get strong in this area. See an entry and know exactly where it will ended up and its affect on the reports. What can I do to sharpen this? Appreciate your insight. Thanks!
Prep a corporate tax return without using QuickBooks. Export the Income Statement, Balance Sheet, and GL Detail to excel. From there make your necessary adjustments (manually record journal entries and reference them to/from the right account) and make sure any changes flow from/to the proper account and have the correct ending balance.. Always pay attention to how equity changes as this is usually the last (and most difficult) step. In short: you can do this if you don't know anything about taxes, but you will need excel and QB. Just make an adjustment in QB...find the changes...then manually do it in excel. Hope this helps.
Alt W J will zoom it to 100%. Of course to adjust it to other zoom%ges, the Alt W Q tab and entering the percentage works great! Could you please do a video on testing revenues, payroll and expenses? I have been enjoying your videos. Thanks for showing real life examples and templates and not just talking theory!!
Please send me an email and I am happy to share it bryancarreto12@gmail.com - If it helped please tag me or share it with your friends to help grow the channel. Best of luck
An alternative to decimal points, you can go to the settings in the control panel and change the default to zero decimals places. Control panel > change date, time, and number formats > advanced settings > currency > No. of digits after decimal Lmk if anyone else has shortcuts they’ve found practical.
Vlook up and pivot tables please!! This was extremely helpful
I will definitely make a video on this topic next! Appreciate the thumbs up everyone
@@BryanCarretoCPASir please make a Video on most Excel Formulas used in Auditing with Live examples. Thank you
I have watched so many tutorials.. this was by far the best...the only needed for a new auditor ...and your other videos are just binge worthy
I was literarily screaming after seeing your TB audit video and it was so helpful for the Audit i will be doing for a company next week. Thanks a lot for all the nuggets and analysis tips. They were so helpful.
Please could you do videos for auditing all line items on the balance sheet?
Thanks🍀
Nice thanks for the tips! Any advice for running through Tickmarks on workpapers? I always get lost in the sea of Tickmarks!
Vlook ups and pivot tables, I start audit in August so any tips on how to actually audit as a first year would be great
This was extremely helpful and very easy to understand and follow. I literally took notes and feel a tad more competent.
You're an amazing coach, Bryan. Grateful for you!
Thanks for making videos about this, as a first year auditor it really helps.
Loveee your videos!! 💗
Thank you much for these useful tips, I am also an auditor and struggled my way to format a client's aging schedule. have not looked at your other videos, but if you don't have a video on how to format a GL detail, can you please educate us on that?
Great job. It will only get better. Also, Alt + H + I + R is a common one for me.
Very helpful
Hi Bryan, and thanks for videos. They are very helpful. How can I seek your help directly?
Hi DM me on instagram @bryan_carreto
Question, what's the best way for an auditor/accountant to real grasp journal entries and knowing how they affect/impact financial statements across the board (cashflow, balance sheet, tax returns, etc). I really want to get strong in this area. See an entry and know exactly where it will ended up and its affect on the reports. What can I do to sharpen this? Appreciate your insight. Thanks!
Prep a corporate tax return without using QuickBooks. Export the Income Statement, Balance Sheet, and GL Detail to excel. From there make your necessary adjustments (manually record journal entries and reference them to/from the right account) and make sure any changes flow from/to the proper account and have the correct ending balance.. Always pay attention to how equity changes as this is usually the last (and most difficult) step.
In short: you can do this if you don't know anything about taxes, but you will need excel and QB. Just make an adjustment in QB...find the changes...then manually do it in excel.
Hope this helps.
That was really hopeful man, thank you
It was great thank you
The Gridlines alt+W+VG go away from the entire sheet, how did your data table didn't had any affect?
Alt W J will zoom it to 100%. Of course to adjust it to other zoom%ges, the Alt W Q tab and entering the percentage works great! Could you please do a video on testing revenues, payroll and expenses? I have been enjoying your videos. Thanks for showing real life examples and templates and not just talking theory!!
Where can I get a sample template of this? Wanting to follow but wanted this exact template to work through it as you explain. Thanks!!
Please send me an email and I am happy to share it bryancarreto12@gmail.com - If it helped please tag me or share it with your friends to help grow the channel. Best of luck
Awesome video, thanks! How long did it take you to memorize all these shortcuts?
More excels videos. Please 🙏 thank you 😊
You got it! ;)
How to make notes/narrative nicely fit? And when I do copy and paste it always look ugly.
Thanks for this video.This is very helpful to accounting professionals🙂more excel content for accountant please. 😊
Your nationality and qualifications
For next time, can you please upload the excel file on youtube so we can download it and follow your steps to practice. Thank You.
An alternative to decimal points, you can go to the settings in the control panel and change the default to zero decimals places.
Control panel > change date, time, and number formats > advanced settings > currency > No. of digits after decimal
Lmk if anyone else has shortcuts they’ve found practical.
Can you please do a video on vlookup and pivot tables! I love your videos! ❤️❤️
I am working on this video as we speak lol... Thank you soooo much. Always here to help if you have questions
the echo of your voice is really bad in this video. Get some matrsesses or something in your room so that it wont sound like you are in empty hall
Brilliant teacher may I get your cell number plz sir