Join 10,000+ professionals who enrolled in the Controller Academy 🚀 controller-academy.com/courses/controller-academy [coupon 30offprice for 30% discount]
Thank you much, Bill. Allow me to put the video summary here. a) Balance sheets Step 1: Bank Reconciliation, pro tips: do weekly Step 2: Reconcile AR with invoicing data Step 3: Reconcile Prepaid Expenses, check for reasonableness Step 4: Reconcile Inventory, Qty by SKU, Aging for expiration dates Step 5: PP&E, |Review for large purchases, run depreciation, obsolete items Step 6: Accounts Payable, all vendor invoices are received, reconcile trial balance to sub ledger, aging report & avoid inflating cash balances unnecessarily Step 7: Credit cards recon, cc statements vs book balance Step 8: Accrued expenses Step 9: Unearned Revenue, amortize as needed Step 10: Long term debt vs Lender Statement, accrue interest b) P&L Step 11: Revenue accrual by customers (when you earned it) Step 12: Expense accrual, list of Expense GL Accounts Step 13: Review Open POs that not billed by vendors yet. Step 14: Actual vs Budget Step 15: Period over period comparison Step 16: Lock the period.
Please consider videos on how financial analyst and accountants should approach reporting/presenting financial results and recommendations to senior management.
Very good summary of the different steps of a month-end close. Some remarks though (might be because I am not based in the US) regarding missing tasks: - Provisions for any litigations, for warranty products (if selling products), ... - Tax reconciliations for VAT, payroll for social security, withholding taxes, Corporate Income Tax, ... - Payroll bonus (if applicable) - Revenues: credit notes review (along returns/cancellations) either issued or to issue, retroactive discounts (esp. for retailers) - Interco reconciliations: applicable only if several entities with re-invoicing (recharging), purchases and sales + AR/AP counterparts, ... important for consolidation - Review of deposits/guarantees (non-current assets), - Split long-term/short-term of debts/leasings - Management Accounts adjustments: mapping new accounts from P&L (income statement), review proper cost centers (analytical accounts) allocations + eventually journalized (reclasses)
You are one of the best creators in UA-cam regarding this complex topics. I’m ex PwC, I worked in audit and taxes. Nowadays I’m working only in taxes, and your videos are helping me to my personal development. Thank you very much.
This video is super helpful for a junior accountant like myself who works in public accounting, and is trying to prepare himself for a more advanced corporate role!
In my experience it happens mostly with older systems. Sometimes batch posting issues happen, or someone posts a manual entry to the AP/AR accounts. The reason it happens can change but it means something posted in the ledger and not the TB or vice versa. To reconcile, some software have reconciliation reports that you can run to identify the amounts causing the discrepancy. From there you need to locate the entries, and figure out what happened. It’s not cut and dry on how to fix this, it’s case by case. You usually end up having to book a manual JE to fix it. Hope this helps!
Amazing breakdown as usual, even with 15 years of experience in accounting i still struggle sometimes with the basics and that's why I love your detailed breakdown. Because of your coaching, I began a new consulting position in a cabinet in Montreal, so I have to ask, why do you have a mug from Montreal?
@@TheFinancialController Nothing has changed since my last comment. If accountants use your channel to close up gaps in their accounting education, I get that, but most of the questions I read seems to come from people who have NOT studied accounting and are taking short cuts. My concern is about you and others who look to monetize their accounting knowledge and water down the accounting profession at the same.
@@marvelouss719 People with your outlook gatekeep info and that is the reason so many accountants have skills gaps to begin with. If this knowledge were more available, these videos wouldnt have an audience.
Hi Bill could you make videos on how to reconcile the TB amount with the main GL account, how to prepare a prepaid schedule, AP reconciliation with main GL etc
Hey man, tax associate at a regional firm here, super enjoy your videos. Would love to get some more backstory on your wife's career and any advice she may have for other tax practitioners, e.g. how to "make it" long-term in tax. Keep killing it!
Finally the UA-cam algorithm brought me the video I was hoping for. There can be bottlenecks in the process of any entity's close. So there's a sequence of tasks that must be checked off the list before the next.
Justttttttt Amazzingggggggg...... I never get a dummy video of full explanation of month end process whenever I started searching job. But this time Bill, You really heard me. So so so thhankful, I am from India.😍😍😍
Hi Bill! I'm in this chaotic fun every month & could not function without my checklist. Love how organized you are! By the way, in your video, #9 is shown as "Accrued Expenses", but you do a great job (as usual) explaining "Deferred Revenue". Thanks for all you do to lift up the profession!
I always thought accounting was hard and kinda of hate it. You are explaining it so simple and everything starts to make sense. Thank you! I feel like I can finally understand things that I thought I never will :)!
This is so helpful! Thank you! I do have one question though -I work for a growing construction company and we have several projects carrying over month to month. Would you suggest doing a quarter close over a monthly close? Or do you have any recommendations for how to tweak the process to enable a monthly close?
Dear sir first thank for any support , i need some question 1.Business transaction and financial reports 2. accounting cycle(from opening to closing of AC Counts ) in practical 3. Nature and overview of General and special AC COUNTS Practical 4. cost & taxation accounting 5. Create A company and maintaining default information using peach tree accounting complete accounting 6. Record and report transaction using peach tree accounting complete accounting 7. Calculation-(Deprecation , lease, loan interest, cost buildup) 8. Closing report using peachtree accounting thank you for supporting and experience share sir thank you a lot.
Thanks so much for your videos! It’s so hard to find any good videos with tips/process guidance for Accounting, and your delivery is concise enough to make it full of value but detailed enough to be clear & actionable. Thanks!!
Thank you for sharing! You mentioned "maintaining an Excel table" for many items, and I wonder if it's a common practice to do them directly in accounting software like Quickbooks too?
Hello sir thank you for providing us this wonderful knowledge. I am working in accounting and I'm doing payroll as well. I am juggling making excelsiorate for garnishment. Can you please show it
Would you please suggest as a staff accountant who is more into analysis should he/she should accept an entry level audit associate position in an established cpa firm or take up a position in industry which provides month end close process experience.
Hi Bill, Thank you so very much for detailed yet simple checklist to the books of accounts for an organisation. You doing great job. My best wishes to you. God Bless keep spreading knowledge.
Thank you so much for your valuable videos. Would you create a video that explain how to do adjusting entries to clean the books. How to do that journal entries that allow to get clean balance sheets? Thank you again!!! Also explain about subsidiaries accounts. Thank you again!
Could you provide topic-wise explanations? For instance, I am studying CMA-US, whenever I hear a topic from your video it goes straight to my soul lol......
Another great video. Thank you for sharing. As someone who is currently in school for accounting I have not had a chance to practice these concepts yet, but will keep in mind for future use!
@@TheFinancialController thank you! I am very excited for all the doors it will open, little nervous for all the details surrounding it all, but I know with time and repetition things will get easier. My goal is to be a controller one day as well! Excited for the journey.
I have a potential non profit client that haven't reconciled their books in 5yrs and they didn't enter donation receipts in QB. How or where should I start? I'm hired to create classes for Donors and AP
Bill thank you so much for sharing your knowledge. I have been working in finance for over 15years after listening to your videos I have done all the jobs in finance except manager. I realized the jobs I did were staff accountant positions but they title it account payable or accounts receivable "clerk, specialist, assistant" I believe I'm pass a staff accountant but they called it different. Can I call it what it is on my resume. I have a BA accounting two years now.
You are always brilliant and you have a distinct style of explanation - can you make a video on the most important accounting standards that are used continuously in the work IBRAHIM From Egypt
Bill, this is very helpful. Can I use this checklist at work and for my team? You inspire me, and I want to do some modifications as this is for accounts receivable.
Hi Bill, thank you so much for your videos, I want to ask a question about collaboration: I'm accountant in Mexico and I'm looking for collaborate with another accountant in USA, do you think this is possible for me to work with another accountant in USA?
Hi sir Thank you for deliver as per commitent and how to prepare and close financial statements reporting and practical show me after export data and prepare components of financial statements. Please inbox me excell format in finance Manager
Join 10,000+ professionals who enrolled in the Controller Academy 🚀
controller-academy.com/courses/controller-academy
[coupon 30offprice for 30% discount]
Thank you much, Bill.
Allow me to put the video summary here.
a) Balance sheets
Step 1: Bank Reconciliation, pro tips: do weekly
Step 2: Reconcile AR with invoicing data
Step 3: Reconcile Prepaid Expenses, check for reasonableness
Step 4: Reconcile Inventory, Qty by SKU, Aging for expiration dates
Step 5: PP&E, |Review for large purchases, run depreciation, obsolete items
Step 6: Accounts Payable, all vendor invoices are received, reconcile trial balance to sub ledger, aging report & avoid inflating cash balances unnecessarily
Step 7: Credit cards recon, cc statements vs book balance
Step 8: Accrued expenses
Step 9: Unearned Revenue, amortize as needed
Step 10: Long term debt vs Lender Statement, accrue interest
b) P&L
Step 11: Revenue accrual by customers (when you earned it)
Step 12: Expense accrual, list of Expense GL Accounts
Step 13: Review Open POs that not billed by vendors yet.
Step 14: Actual vs Budget
Step 15: Period over period comparison
Step 16: Lock the period.
Thank you for this summary 🙌🏻
This guy explain way much better than 90% of people
Please consider videos on how financial analyst and accountants should approach reporting/presenting financial results and recommendations to senior management.
Very good summary of the different steps of a month-end close. Some remarks though (might be because I am not based in the US) regarding missing tasks:
- Provisions for any litigations, for warranty products (if selling products), ...
- Tax reconciliations for VAT, payroll for social security, withholding taxes, Corporate Income Tax, ...
- Payroll bonus (if applicable)
- Revenues: credit notes review (along returns/cancellations) either issued or to issue, retroactive discounts (esp. for retailers)
- Interco reconciliations: applicable only if several entities with re-invoicing (recharging), purchases and sales + AR/AP counterparts, ... important for consolidation
- Review of deposits/guarantees (non-current assets),
- Split long-term/short-term of debts/leasings
- Management Accounts adjustments: mapping new accounts from P&L (income statement), review proper cost centers (analytical accounts) allocations + eventually journalized (reclasses)
You are one of the best creators in UA-cam regarding this complex topics. I’m ex PwC, I worked in audit and taxes. Nowadays I’m working only in taxes, and your videos are helping me to my personal development. Thank you very much.
Thanks for sharing
This video is super helpful for a junior accountant like myself who works in public accounting, and is trying to prepare himself for a more advanced corporate role!
Can you please upload a video on reasons for differences between TB and Sub ledger of AR/AP and how to reconcile the same ?
Same question I have!
I second this! It would be very helpful
Ohh that would indeed be helpful
In my experience it happens mostly with older systems. Sometimes batch posting issues happen, or someone posts a manual entry to the AP/AR accounts. The reason it happens can change but it means something posted in the ledger and not the TB or vice versa. To reconcile, some software have reconciliation reports that you can run to identify the amounts causing the discrepancy. From there you need to locate the entries, and figure out what happened. It’s not cut and dry on how to fix this, it’s case by case. You usually end up having to book a manual JE to fix it. Hope this helps!
Amazing breakdown as usual, even with 15 years of experience in accounting i still struggle sometimes with the basics and that's why I love your detailed breakdown. Because of your coaching, I began a new consulting position in a cabinet in Montreal, so I have to ask, why do you have a mug from Montreal?
Haha thanks Eric. I was visiting my best friend in Montreal when I bought that.
@@TheFinancialController Nothing has changed since my last comment. If accountants use your channel to close up gaps in their accounting education, I get that, but most of the questions I read seems to come from people who have NOT studied accounting and are taking short cuts. My concern is about you and others who look to monetize their accounting knowledge and water down the accounting profession at the same.
@@marvelouss719 watering down the accounting profession? this isn't quantum mechanics.
@@marvelouss719 People with your outlook gatekeep info and that is the reason so many accountants have skills gaps to begin with.
If this knowledge were more available, these videos wouldnt have an audience.
Hi Bill could you make videos on how to reconcile the TB amount with the main GL account, how to prepare a prepaid schedule, AP reconciliation with main GL etc
Hey man, tax associate at a regional firm here, super enjoy your videos. Would love to get some more backstory on your wife's career and any advice she may have for other tax practitioners, e.g. how to "make it" long-term in tax. Keep killing it!
this is what us Tax Professionals NEED!
Finally the UA-cam algorithm brought me the video I was hoping for.
There can be bottlenecks in the process of any entity's close. So there's a sequence of tasks that must be checked off the list before the next.
These video are so helpful in reviewing basic accounting skills. Saving for the Becker program then signing up to sit down for the CPA!
Justttttttt Amazzingggggggg...... I never get a dummy video of full explanation of month end process whenever I started searching job. But this time Bill, You really heard me. So so so thhankful, I am from India.😍😍😍
Glad it helped!
So exciting! Just a bit bit mistake at Step # 9: deferred revenue but in the blackboard is Accrued Expenses.
You will be a great accounting teacher for sure if you would like to, I do learn a lot from your videos, thank you so much for the sharing!
Thank you!
Great content! Public Tax CPA here, love seeing the Financials from this viewpoint
Hi Bill! I'm in this chaotic fun every month & could not function without my checklist. Love how organized you are!
By the way, in your video, #9 is shown as "Accrued Expenses", but you do a great job (as usual) explaining "Deferred Revenue". Thanks for all you do to lift up the profession!
Haha thanks for catching this Paula
I always thought accounting was hard and kinda of hate it. You are explaining it so simple and everything starts to make sense. Thank you! I feel like I can finally understand things that I thought I never will :)!
Amazing!
Better than all of the internal trainings I have seen combined!
Hello Bill, In this Vlog you have covered all aspects of closing very briefly with simple step by Step approach. Amazing.
Glad it was helpful!
I wish you could teach me, you’re so thorough and down to earth. Just started watching you and have enjoyed 4 videos thus far.
Thank you so much!
Love how you make accounting easy to understand, can you do a video on Asset Register and Depreciation?
This is so helpful! Thank you! I do have one question though -I work for a growing construction company and we have several projects carrying over month to month. Would you suggest doing a quarter close over a monthly close? Or do you have any recommendations for how to tweak the process to enable a monthly close?
Dear sir
first thank for any support , i need some question
1.Business transaction and financial reports
2. accounting cycle(from opening to closing of AC Counts ) in practical
3. Nature and overview of General and special AC COUNTS Practical
4. cost & taxation accounting
5. Create A company and maintaining default information using peach tree accounting complete accounting
6. Record and report transaction using peach tree accounting complete accounting
7. Calculation-(Deprecation , lease, loan interest, cost buildup)
8. Closing report using peachtree accounting
thank you for supporting and experience share sir thank you a lot.
Bill thank you for another amazing topic. Just what I was looking for . 😊
thanks for your videos
as a mid 20s , 5 year qualified ACCA accountant, your videos are refreshing and something i would have treasured as a student.
Thanks so much for your videos! It’s so hard to find any good videos with tips/process guidance for Accounting, and your delivery is concise enough to make it full of value but detailed enough to be clear & actionable. Thanks!!
Thank you Tracy!
Thank you for sharing! You mentioned "maintaining an Excel table" for many items, and I wonder if it's a common practice to do them directly in accounting software like Quickbooks too?
Please show how you construct your month end checklist in Excel. I would so greatly appreciate that tutorial. Thank you for your consideration.
Thank you .. I like to watch your video whenever I have a doubt..
Hello sir thank you for providing us this wonderful knowledge. I am working in accounting and I'm doing payroll as well. I am juggling making excelsiorate for garnishment. Can you please show it
Would you please suggest as a staff accountant who is more into analysis should he/she should accept an entry level audit associate position in an established cpa firm or take up a position in industry which provides month end close process experience.
This is really good 👌 now I know how the controller is using my work actual vs budget each month.
Good video , PROFESSIONAL. I TOUCHED ALL YOUR VIDEOS TOO MUCH USEFULL... LOVELY WORK
Hi Bill, Thank you so very much for detailed yet simple checklist to the books of accounts for an organisation. You doing great job. My best wishes to you. God Bless keep spreading knowledge.
Thanks Kiran!
I’ve gotta show this to my coworker. This is really simple and she thinks closing AP is the same as closing the books.
Thank you so much for your valuable videos. Would you create a video that explain how to do adjusting entries to clean the books. How to do that journal entries that allow to get clean balance sheets? Thank you again!!! Also explain about subsidiaries accounts. Thank you again!
Could you provide topic-wise explanations? For instance, I am studying CMA-US, whenever I hear a topic from your video it goes straight to my soul lol......
Very practical and informative video. Nice break down of steps.
Could you please provide some detailed examples how to reconcile subledgers and general ledgers?
Number 9 is repetitive of Number 8 but get your point. it's a typeo.
Another great video. Thank you for sharing. As someone who is currently in school for accounting I have not had a chance to practice these concepts yet, but will keep in mind for future use!
Thanks Brent! Your hard work and studying will pay off..
@@TheFinancialController thank you! I am very excited for all the doors it will open, little nervous for all the details surrounding it all, but I know with time and repetition things will get easier. My goal is to be a controller one day as well! Excited for the journey.
Awesome.
Please make a video on expense control system through ERP via work order, grn, purchase order.
I have a potential non profit client that haven't reconciled their books in 5yrs and they didn't enter donation receipts in QB. How or where should I start? I'm hired to create classes for Donors and AP
Can you please make video on how to make a good career in finance in USA what would be good for this US CMA or CFA
Bill thank you so much for sharing your knowledge. I have been working in finance for over 15years after listening to your videos I have done all the jobs in finance except manager. I realized the jobs I did were staff accountant positions but they title it account payable or accounts receivable "clerk, specialist, assistant"
I believe I'm pass a staff accountant but they called it different. Can I call it what it is on my resume. I have a BA accounting two years now.
Yes you can call it staff if you done the work regardless of what they called it
Congrats for 100K Subscibers.Proud that I am one among them.
Thank you!
You are always brilliant and you have a distinct style of explanation - can you make a video on the most important accounting standards that are used continuously in the work
IBRAHIM From Egypt
Could u please make detailed vedio reason for negative balance in ar and ap and how to fix it?
Great work, and you made the things quit easy
Thank you! Cheers!
This is a very good video, thank you for recording it!
Glad you enjoyed it!
Can you please upload a video on equity investment/investment in associates?
Bill, this is very helpful. Can I use this checklist at work and for my team? You inspire me, and I want to do some modifications as this is for accounts receivable.
Yes, absolutely
This was very helpful!Thank you! 🙌🏻
You're so welcome!
How about if your don't book everything from the bank statement. How do u reconcile in such situation.
Make a prscticall video on bank reconciliation
Could you please put a vedio related with Balance sheet Reconciliation with an examples?
Greetings - excellent video; however, I thought I heard you stated you were providing a prepaid expense template for us to review and possible use?
Thank you for doing this! I’ve been struggling with this chapter in my class!
Broke it down very well . Thanks
Tax provisions and payment?
Great content. Thank you very much Bill.
Glad it was helpful!
can you please give us example abut deferred revenue?
Do you have any accounting flowcharts / workflows?
sir do u have a accounts payable aging? thanks. u help us a lot! godbless🙏🏻
Truly saving lives!!!
This is very helpful. Thanks for sharing.
can you make some video on treasury items accounting like debt, derivatives and investments?
Amazing video with many concepts and information set.
Thank you Malik!
Wow, it's a very interesting lesson, thank you, bless you
Glad you liked it!
Can you pls make a video for us taxation for Bookkeeper
Thank you very much
The. Best of. Best
I like this.classs
God. .Bless. all. You
I love your videos. Thank you for sharing your knowledge.
Thank you Nicole for watching my stuff!
Thanks for ur effort ^^ could chatgpt helps with that ?
Step 9 is Deferred Revenue (not Accrued Expenese)
Is it possible to download this video in writing?
Awesome thank you 🙏 Whose job normally is this? Does everyone work together? Or mostly the staff accountant? Or someone higher up? Thanks again
This takes a team of 2-5 accountants at a mid size company ranging from staff to manager
Thank you. 🌷
I needed this soooo much 😂 thanks
We must see through the true nature of
everything and let go. It is ignorance that
motivates us to unearth wisdom.
Excellent 👍... Could please upload videos regarding FP&A
Yes, sure
Hi Bill, thank you so much for your videos, I want to ask a question about collaboration: I'm accountant in Mexico and I'm looking for collaborate with another accountant in USA, do you think this is possible for me to work with another accountant in USA?
If you're a professional accountant you get this link from your professional group on LinkedIn or other social account
Thank you
Hi, is this checklist fully applicable in the UK?
Yes plus maybe a couple of local requirements (VAT reconciliation and reporting comes to mind)
Thanks!
Thanks Janice!
Excellent
Thank you so much you are a life saver 💗
You're welcome 😊
When you say open PO, does it mean goods received or service rendered however invoice hasn't been received yet from the vendor.. correct
yes
@@TheFinancialController dear sir, one more thumbs up from my side again.. I am watching this video again today..
Nice one Sir🎉❤❤❤
Keep watching
Thank you❤
You're welcome 😊
Hi sir
Thank you for deliver as per commitent and how to prepare and close financial statements reporting and practical show me after export data and prepare components of financial statements.
Please inbox me excell format in finance Manager
very good
Smart!
Can you please help me with my emails to answering
Amazing
This video os liiiit❤❤❤
🎉
That sip of soda was... ❓
Google drive cloud