How To Create Month End Close Checklist. Start With The Financial Statements Line Items!
HTML-код
- Опубликовано: 28 авг 2024
- In this video I show you how I create a month-end close checklist, which acts as a guide for the whole accounting team to close the month and produce financial statements.
The idea is simple, by looking at each line item on the financial statement, we can think of the accounting task needed to finalize this line item.
Go ahead and download my free close template:
thefincontroll...
🔥My online course “Night Before the Accounting Interview Guide” including All Levels Q&A🔥:
thefincontroll...
------------------------------------------------------------------
📈 Get $25 off MY ONLINE COURSE ON FINANCIAL METRICS
thefincontroll...
Use Coupon Code: Save25
-------------------------------------------------------------------
My Recommended Products (I will only share what I love ❤ here)
⚪️ 📸 My camera: amzn.to/3hXFSuj
⚪️ 📢 My Mic: amzn.to/2G0bu5s
⚪️ 🔦 My studio lights: amzn.to/301vAU3
⚪️ 🧠 Roger CPA Review Course (get 50% off): www.uworld.com...
⚪️ 📚 Learning//SkillShare (get 2 weeks free): www.skillshare...
My Recommended Finance & Accounting Books 📚+🧠=💥
⚪️ Auditing: amzn.to/361wJhZ
⚪️ Forensic Accounting: amzn.to/2G6t9bo
⚪️ Introduction to Finance: amzn.to/2ExgUEA
⚪️ Introduction to Managerial Accounting: amzn.to/33SEyE4
---------------------------------------------------------------------
Hang Out with me on social media:
📱 / thefinancialcontroller
🙋🏼♂️www.facebook.c...
📸 / the_financial_controller
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.
You know, NO ONE, JUST NO ONE, is this generous! You're a blessing to all of us who wanna step up and apply for a controller role, anywhere in the world! Thanks! Hope God bless you abundantly!
Thank you so much!
Absolutely totally agree. God bless you!!!! ❤
Wish I could like this comment a million times
Awesome, Bill! This is more than generous!!! You are a big blessing to accountability and the corporate world. Thank you so much.
Thank you, thank you. I'm starting a new job after being out of accounting for awhile and I was afraid I would forget how to do something. Your videos are a great refresher for me. I'm a fan now.
Great! Thanks!
Thanks for this! I’m currently transitioning to a new role and this has helped me a lot to understand what I’ll be doing, prepare for it better and perform better faster hopefully.
After 3 years this visdoe ..i am here to get help
.to learn from you sir..❤
Bill, you are the only one that help me to understand what about the accountability with the USGAAP, I´m from Mexico and for a lucky situation I´ll be on charge with USA to work as a SENIOR ACCOUNTER. Here in Mexico we work with the NIIF´s and PCGA. You are an excellent teacher and partner as Accountant. Thank very much and God Bless you
This is the essence of knowledge of Accounting and monitoring what a manager requires! thanks for imparting knowledge.
Thanks!
Babu... month end close process is something all accounting managers should develop. This is not taught in accounting courses, but how do you ensure everything is accounted for?
i am a senior accounting and finance student and I am doing my best to improve my skills so later on I will be able to compete other fresh graduates to get the job and your channel is helping me too much I literally did not find your gold info on any other web or channel thank u so much
Thanks Joseph!
Brilliant content , I've been looking for this information for ages. Thank you for sharing this with us :)
Thanks Keshnie!
Could you please assist with the file of you were able to download it? I would really love to adopt this on my new role..... thanks
Nice video! Small tip: for the dates in the deadline column, you could insert formulas refererring to the date as is filled for 'Month Ending'. For example: bank reconciliation, would be: ='Month Ending'+'the number (1) in column D'. This way you would only need to change the date in 'Month Ending' whenever you are closing a new month. When you only want to get working days as outcome, that's possible as well (in Excel, maybe not in Google Sheets?), but I would need to look up how. Anyway, thanks for this video!
Thanks for this tip Romke!
Absolutely!
Yes I thought that exactly, but problem with that is it wouldn't account for weekends.
@@anz3e If you work 5 days with 2 days rest, you can create a column with 4 if Statements.
Column B = Deadline Working Day
Column C = Adjusted Deadline Working Day (If Statements Column)
Column D = Deadline Date ('Month Ending' (Day 0) + Adjusted Deadline Working Day)
you add to the Adjusted Day working deadline (Column C):
0 days if deadline day = 5 or less
2 days if the deadline day is => 6
4 days if => 11
6 days => 16
8 days => 21
(not sure you'd need more as that would bring you over the current month, which should go against the month-end process itself).
it would be something like this example:
(In Column C, you write this formula):
=IF(B7=6,B7=11,B7=16,B7=21,B7
@@anz3e my exact reservation
Thank you! I just got a job as an accounting manager and have a lot of knowledge on accounting but have to make a month end process from scratch
You got this!
Extremely helpful real world overview of the month end process. Thank you!
I would agree :)
Thank You so Much
You have no idea how much I am blessed by You.
Thank You for blessing yourself and other's with your generosity.
You are so welcome
Nice one.. But i got a suggestion, u can use remove duplicate option in excel rather than removing the blank lines one by one.. U can save some time.
I actually didn't know remove duplicate can remove blank rows. Nice job Kishor!
Have got a clear picture of Month end closure. I was looking for this for a long time. Thanks. A video on intercompany reconciliation, AP to GL reconciliation would be much helpful.
Your videos are very educative and helpful. Thank you
This man is brilliant!! This info will help me a lot.. Thank you sir!
I agree lol kidding thanks
Thank you for this video! More of similar content and more frequent videos will be highly appreciated.
Thanks Priyanka, sure
This is really helpful. The first video that gave a concise way of knowing closing procedures.
Thanks for watching 😎
❤❤❤❤❤❤❤❤❤❤❤❤😊 You are a pure blessing and may GOD bless you and yours! ❤❤❤
Wow, thank you
Super Thanks , yes what an honest person and so helpful . I cannot thank you enough.
Our pleasure!
This is awesome stuff, thank Bill for sharing!
Thanks David!
Thank you bill, informative, Infact i was looking for this today morning,. Perfect timing. I love your work, thanks Man,
Nice, didn't expect the Google sheets / Excel formatting tips with the Data Validation and Conditional formatting.
Great. This is going to help me in my new role. It was difficult for me to achieve the various tasks/operations in a systematic way
Thank you for your videos! Your free help and advice are invaluable!
I need to create month end checklist at my new job and i would defo follow this format!! great video thank you
Glad you liked it!
really I'm searching for that explanation from long time Thanks a lot
Glad to hear that
It's great content. Thank you so much, Bill. I wish you all the best. Please keep doing your great work.
Thanks 🙏
You are a Financial controller indeed. much apprecited
Thanks Paul!
This is great! Your channel is literally gold! I am going to use this to help me build handover notes. Keep up the awesome content!!
Thank you Hannah!
I must confess that you’re a great teacher of our time. Any link for pdf download please
thank you so much!!! I wish I had this but it's never too late, will be implementing this right away.
Glad it was helpful Katie!
I learned a lot from your videos. Thank you Bill!
Glad it’s helpful
Hi Bill, I'll be a Senior Accountant soon. I'm just finishing my turnover activities. Your videos helped me a lot. I want to see myself as a Financial Controller in the future.
I have a question, do petty cash needed to be replenish in every month-end or is it done when it already hit a threshold before being exhausted?
I hope you can give a valuable insight.
Thank you.
Thanks a lot, Bill for the great video. This was the first step ( preparation of checklist) for the end-month closing operation. How about doing the closing operation in detail based on a real-life model (plus their required adjusting journal entries) as you do in most of your videos plus, I mean a process from the beginning to the last step.
Ok will do
@@TheFinancialController 🙏🎎
Excellent question! This is exactly what I need. wonder if he created the videos... I don't see it..
Super training for me as Head Bookkeeper .You are the best 👍
Great to hear!
You are awesome my friend. This really helps.
I really enjoy ur all videos sir, very much lucrative. Thanks alot
This vlog serves a great help to me thanks for sharing
This is exactly what I needed. Thank you very much.
You're very welcome!
Question: How would you record deposit in transit from the prior month in the bank reconciliation for this month? The deposit from let's say January shows up in the bank statement for February but not in the cash books.
Really all your videos are amazing , I am very happy with following you, Thanks a lot Bill
Thanks 🙏
Thank you so much, Bill for sharing!
My pleasure!
So Lucky to subscribe this channel.. thank you Mr Bill
Thanks
Awesome Bill
Had to subscribe right away! Love the content already. Thanks!
Welcome aboard!
Brilliant and Informative, Helped a lot, Thanks!
Is it important to learn accounting for a specific organization such as heathcare, scool districts, or grocery store. Or is all accounting knowledge about the same?
Amazing content. Helps achieve month end process much easier
Thanks
Nathanael, it also accomplishes the completeness of financial reporting/financial statements.
Thank you again Bill. Can't thank you enough.
Excellent content. It gave me some new ideas. Thank you
This is excellent and very useful. Thank you so much. Bill
wow! brilliant! all in good time for Christmas :)
Merry Christmas and thanks for watching
Thanks for such a great clarification.
Thanks for watching;)
Fabulous content.
Greatful for your support dear
Can you make video on working on these task?
God bless you
Super helpful!! thank you Bill :)
Thanks Cindy!
Thank you for this video! Really helpful.
Wowew it was AWESOME!? Thank you!
Can you please make a video for IFRS 16? With real-life examples. We learn it in theory, but how it is applicable in real-life? Thank you very much.
Can you do all of this in excel ? I love this idea to manage my bookkeepers , thanks for the video .
Do you think this would work in a calendar system ?
Yes it would work
Excellent content. Many thanks for this
Your channel is very informative. Ty
Thank you for watching:)
Hello. I recently found out about your content and I'm still getting into it. Great material! I was wondering if you could create a video and go more into depth about how these tasks are executed. I would really appreciate it! Thanks
That’s the plan! Thanks for watching!
@@TheFinancialController sounds great! will be waiting for that. Thanks :)
One of the interviewers asked me why we need to close books of accounts every month why not on a yearly basis or on a quarterly basis.I managed to answer but I would like to hear your answer 😉😊
Great question. I will try to cover it
Thank you, So, much for your content.
Thanks Bill this is really helpful! Can you please also do a video on Power BI?
Ok will do
Requesting to make video on ERP system.
Good idea ok
Great stuff!!! I owe u for this..
This is very helpful.
Great video! Thank you 🙂
This is so good. Now wondering if there is an FP&A checklist :)
Ok I will think about that for a video
Very helpful content. Thanks for sharing:)
Thanks for watching!
great stuff like always. Whats best to do with this information once closed out? is there a difference if its cash and accrual? thx bro
This is super super helpful!!!! Thank you!!!
Thanks Lola!
Thanks a lot, very useful.
You are the man 🙏
great video
brilliant 👏 👏
thank you
Appreciate your efforts 💐
Thank Ahmed 🧐
I need this so bad
Invaluable!! Thank you.
Thank you!
Thank you so much for this video
Most welcome 😊
Thank you very much.
Great stuff. I salute.
Thanks friend
Great video!!!!
Nice 🎉
Thanks for creating great contents 👍
Glad you like them!
I can't see the link to the sample. Could you help
You are awesome
Great stuff, as always!
Thank you! Cheers!
Thanks Man!
Hi, nice information, could you please help me with some question i do have, i'm trying to get on the road with the USGAAP, and the monthly report than a SEC and not SEC company need to report monthly, could you help me with that, please, thanks in advance to you.
This is a very useful tool...Great FC!
I'm still trying to find the free template, kindly help.
Got it but keeps giving error 'cannot open this link' please assist, I would really love to adopt this template. Thanks
very useful info, thanks so much
Thank you!
I appreciate you!
Hi Bill hope u good, I have been tasked to create a month end process for a company that prepares its reports and accounts from bank statements , they're still in a process of implementing an ERP , how do I go about it ? thanks
Thanks
Amazing content 👍🏻
Thank you
Very helpfull 🔥🥰