How To Close The Books For Dummies. Financial Close In 15 Steps
ฝัง
- เผยแพร่เมื่อ 14 พ.ค. 2024
- Join 10,000+ professionals who enrolled in the Controller Academy 🚀
controller-academy.com/course...
[coupon 30OFFCOURSE for 30% discount]
Or
Get my Controller bundle, which includes the Controller Academy
controller-academy.com/bundle...
[coupon 30OFFCOURSE for 30% discount]
In this video I show you how I perform financial close at month end in 15 steps.
Download a sample month-end close checklist 📆
thefincontroller.com/p/the-fi...
------------------------------
My other best selling courses:
🔥Take 30% off when you enroll in my online course “Night Before the Accounting Interview Guide” including All Levels Q&A🔥:
thefincontroller.com/p/the-ni...
📈Get My “Controller KPI Dashboard” (Excel + Course) with the most important P&L and Balance Sheet KPIs:
thefincontroller.com/p/contro...
---------------------------------------------------------------------
Hang Out with me on social media:
📸 / the_financial_controller
📱 / thefinancialcontroller
🙋🏼♂️ groups/78073...
DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!
All views expressed on my channel are mine alone. Not intended as financial or professional advice
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.
This guy explain way much better than 90% of people
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 🙌🏻
Thank you for doing this! I’ve been struggling with this chapter in my class!
Please consider videos on how financial analyst and accountants should approach reporting/presenting financial results and recommendations to senior management.
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!
Thanks Bill - I am not an accountant but had a curiosity around how this process works. I now have a greater appreciation for what the accounts and finance teams do every month and year!
These video are so helpful in reviewing basic accounting skills. Saving for the Becker program then signing up to sit down for the CPA!
Bill thank you for another amazing topic. Just what I was looking for . 😊
Better than all of the internal trainings I have seen combined!
This is really good 👌 now I know how the controller is using my work actual vs budget each month.
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?
Good video , PROFESSIONAL. I TOUCHED ALL YOUR VIDEOS TOO MUCH USEFULL... LOVELY WORK
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!
Very practical and informative video. Nice break down of steps.
Broke it down very well . Thanks
This is very helpful. Thanks for sharing.
Finally the TH-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.
Great content! Public Tax CPA here, love seeing the Financials from this viewpoint
I needed this soooo much 😂 thanks
This was very helpful!Thank you! 🙌🏻
You're so welcome!
Thank you .. I like to watch your video whenever I have a doubt..
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!
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!
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
Awesome.
Please make a video on expense control system through ERP via work order, grn, purchase order.
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!
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.
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!
I love your videos. Thank you for sharing your knowledge.
Thank you Nicole for watching my stuff!
Thank you. 🌷
This is a very good video, thank you for recording it!
Glad you enjoyed it!
Thank you so much you are a life saver 💗
You're welcome 😊
Great content. Thank you very much Bill.
Glad it was helpful!
Truly saving lives!!!
Amazing video with many concepts and information set.
Thank you Malik!
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
Wow, it's a very interesting lesson, thank you, bless you
Glad you liked it!
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?
Thank you very much
The. Best of. Best
I like this.classs
God. .Bless. all. You
Greetings - excellent video; however, I thought I heard you stated you were providing a prepaid expense template for us to review and possible use?
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?
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!
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
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
sir do u have a accounts payable aging? thanks. u help us a lot! godbless🙏🏻
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!
Could you please provide some detailed examples how to reconcile subledgers and general ledgers?
Thank you
Thank you sir
Thank you❤
You're welcome 😊
Congrats for 100K Subscibers.Proud that I am one among them.
Thank you!
Please show how you construct your month end checklist in Excel. I would so greatly appreciate that tutorial. Thank you for your consideration.
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
Could u please make detailed vedio reason for negative balance in ar and ap and how to fix it?
I’ve gotta show this to my coworker. This is really simple and she thinks closing AP is the same as closing the books.
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......
Nice one Sir🎉❤❤❤
Keep watching
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.
Smart!
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.
Could you please put a vedio related with Balance sheet Reconciliation with an examples?
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
Can you please upload a video on equity investment/investment in associates?
Amazing
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
How about if your don't book everything from the bank statement. How do u reconcile in such situation.
Pls make a video about how to prepare budget
can you please give us example abut deferred revenue?
very good
This video os liiiit❤❤❤
Do you have any accounting flowcharts / workflows?
can you make some video on treasury items accounting like debt, derivatives and investments?
Is it possible to download this video in writing?
Can you pls make a video for us taxation for Bookkeeper
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
Excellent 👍... Could please upload videos regarding FP&A
Yes, sure
Make a prscticall video on bank reconciliation
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
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.
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
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
Number 9 is repetitive of Number 8 but get your point. it's a typeo.
Tax provisions and payment?
We must see through the true nature of
everything and let go. It is ignorance that
motivates us to unearth wisdom.
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..
Step 9 is Deferred Revenue (not Accrued Expenese)
🎉
That sip of soda was... ❓
Sir make video how to cpa make millions of dollar
Go to internet/digital marketing page. This purely accounting And finance
Do u mean your subscribers are dummy????..Like its insulting
Without any examples with numbers this video is worthless
Thanks for ur effort ^^ could chatgpt helps with that ?
Hello, what's your LinkedIn profile?