HI Kenji, Thanks for sharing this awesome video (VA - Actual v Budget). How could I access your course with more Finance & Accounting Reports Models? Thanks
Hi, love the video and your quick shortcuts to help put it together, but your Var.% at 9:52mins are confusing. Surely for Utilities, a budget of 112 and spend of 140 is a 25% overspend (not a 20% overspend as your spreadsheet shows)?
This is great. My Budget spreadsheet is very similar using a "actual" sheet and the variance dashboard but I start a new one every month, I've never figured out how to stretch it out for a year. Will be incorporating these UPGRADES for sure. Also, love your presentation style - boom-boom-boom. No fluff. Get-er-done!
@@KenjiExplains Hey - Curious on your thoughts on this. In my current budget sheet, since I start a new once every month, it's easy to use the expense sheet to also work as a checkbook registry to know current balance at the bank and project future balance once I spend all the budgeted expenses. Do you have any thoughts on how to incorporate something similar into your version?
5:31, i wonder how it would be done with those common accounting representations via codes with instruction (which code responds to which thing on other sheet page) and dispersed version of variables for SUMIF without months names repeating itselfs. Another Match or Index?
This is great!! I completed this exact budget vs actual but did not realize at the time the issue I now have with being able to keep my notes. For example, I need to be able to use this same format but each month have my notes per line item. How do I create notes for each month and have it change to the appropriate month along with the data when I use the drop down.
For years, I used to use excel and google sheets to budget and forecast my finances. This year, I released an app that does it for me with minimal maintenance. Give Money Spider and Money Spider Lite a try on Android.
I've built a number of budget vs actual reports - I would suggest, firstly using full contiguous data both for the budget and actual - then create a simple data model and pivot report - this can be built to be fully automatically updated If you have your data in segments like shown here, it makes it more manual and time consuming I do love the visual style however
hello, kenji your contents are really helpfull i enjoy learning from them..... but for this specific dashboard, how can i make the variance for years and choose between them !!! Thank you
Thanks for the video, when I tried to make the actual date at 12:50 my excel can't accept cause the formula isn't on the list that we take how i do it then ?
Hi Kenji, thanks for this video man it sures help a lot. Quick question is there a way on how I could calculate the total ACTUAL savings instead of just showing how much you save per month?
Really love your content Kenji! I just secured an internship this summer because of your video. I learnt a lot. Please keep it up. Also, do you have any suggestions about how I should behave during the internship? Should I ask a lot of questions or be prepared with everything? The position is within an accounting firm in Nyc. Looking forward to your reply!
That's awesome to hear congratulations!!! Regarding your questions, I think it's good to ask questions (shows you're passionate) and you'll learn a lot more than if you're just quietly sitting on the sidelines. Also, you come across as more humble than somebody who thinks they know it all...hope this is helpful! Best of luck with the internship :)
Hey! xlookup wouldn't have worked as there were both a row and a column variable that we needed to account for (date + line item)...the xlookup formula is very easy & convenient to use though!
@@SiaosiMaka i actually like that he uses index-match, because i have excel 2016, and unfortunaltely xlookup would not work for this version. But now i have a full tutorial for my dashboard. Lucky me. 😀
Great work thank you, one question how can i add also the organization’s in the excel ? for example i want to know the spend of each org in a month for an item.. thank you ..
This is great. But what is the cleanest way that you have found to physically import all of your actual transactions? I have 30 or more transactions each month and I'm trying to automate this import.
Hi Kenji, for the expense %var, why did u divided the variance by the actual value? Shouldn't it always be divided by the budget? Mathematically, the minus only affect the numerator, not with the denominator? cmiiw
I follow that showing Utilities as unfavorable $28 makes more sense but when looking at the % change, it goes from 25% change to -20% change. I follow the mathematical change but conceptually, is it right to say that my variance is off by 25% or 20%? Especially since on the income side we are using Actual as the base whereas in the Expense you are using Budget as the base. Thanks!
Hi Kenji, thanks for great video, i want u to make a video talking about Data analyst and Mart document and do the report use by pivot and vlook up. please.
@@KenjiExplains no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.
Hello Kenji , Thank you so much for starting this is very helpful , I'm working on this Excel sheet but I'm getting error when using index match its showing #N/A how to resolve this error?
Love the content but unless one is already a little more advanced in excel (at which point one probably knows all this already) it's impossible to follow, especially with the amount of shortcuts. A beginner doesn't need to know these, a beginner needs to understand what they are doing there. I've been studying excel for a while so I was only a little lost. It was very helpful for me thank you!
Hi Kenji, great vid - I was wondering if this 'comparison' graphing could be done where there is a CHOOSE used in the data? i.e. could I have a graph comparing multiple scenarios without typing each set of resulting values out as you have in the budget vs analysis?
Hello there Kenji, nice video Kenji, really useful and helpful. Can you do another video on how to shows multiple month on the dashboard? It would be really nice to know how to do that. Thankyou in advance!
Hey Kenji, Can you please create dashboard for warehouse inventory analysis......It will be a great help for us. Want to know consumption patterns of consumables with help of Excel, ageing analysis report. Need one complete video on that topic.
*When it comes to investing, I'm so ignorant about it, I hereby ask; What's your say or thought for anyone with over $20k looking for the best ways to make good returns off it? I will appreciate any help here on how to do this*
@Lucy Bernardi Interesting, I've always been fascinated with investing and I need to start now. Could you possibly give more information on your Investment Professional and how I can reach out to her?
👉 Sign up to The Daily Upside here: bit.ly/3jzBzIW
HI Kenji, Thanks for sharing this awesome video (VA - Actual v Budget). How could I access your course with more Finance & Accounting Reports Models? Thanks
Where was this "no-nonsense guy" all these years? An amazing teaching he does!
No time waste only to the point this is what today’s audience want to see 👍👍👍👍👌👌👌
Great vids - love your content. I really like how you build them all from scratch so we can see the shortcuts that all the pros use as well.
Glad you like them!
Just awesome. After a long time, watched worthy video with no timepass. Thanks a lot for sharing your knowledge.
Hi, love the video and your quick shortcuts to help put it together, but your Var.% at 9:52mins are confusing. Surely for Utilities, a budget of 112 and spend of 140 is a 25% overspend (not a 20% overspend as your spreadsheet shows)?
I learn a lot from Kenji teaching.
This is great. My Budget spreadsheet is very similar using a "actual" sheet and the variance dashboard but I start a new one every month, I've never figured out how to stretch it out for a year. Will be incorporating these UPGRADES for sure.
Also, love your presentation style - boom-boom-boom. No fluff. Get-er-done!
Thanks for the awesome comment! Yeah don't wanna waste your time :)
@@KenjiExplains Hey - Curious on your thoughts on this. In my current budget sheet, since I start a new once every month, it's easy to use the expense sheet to also work as a checkbook registry to know current balance at the bank and project future balance once I spend all the budgeted expenses. Do you have any thoughts on how to incorporate something similar into your version?
@@KenjiExplains Help us to sort-out the different years as well. please.
Simply, straightforward, concise, and precise. Thank you, Kenji!
Thank you for watching! Don't wanna waste people's time :)
Nice. For the variance I would use the IF statement so that I can keep the formulas consistent down the column. For example, =IF(D3>C3,C3-D3,D3-C3)
This is one of the best Video I have seen. You did a great job in that file.
Thank you so much for starting this, Kenji. You have no clue how much you are helping me with Excel everyday. Thank you thank you thank you! ❤️
Thanks mate Kenji, it did help me building my company budget vs actuals. Appreciate it!!
Thanks Kenji
You are awesome, you are master at what you do, and I can catch up the idea from first time.
Big thanks
Awesome video, I really enjoyed it having terrible flu rn I was able to get all information, informative and very easy to follow step by step
5:31, i wonder how it would be done with those common accounting representations via codes with instruction (which code responds to which thing on other sheet page) and dispersed version of variables for SUMIF without months names repeating itselfs.
Another Match or Index?
Thanks This was very useful for me and will apply in my job as finance officer
Awesome!
This is great!! I completed this exact budget vs actual but did not realize at the time the issue I now have with being able to keep my notes. For example, I need to be able to use this same format but each month have my notes per line item. How do I create notes for each month and have it change to the appropriate month along with the data when I use the drop down.
Love your style and pace is perfect. How to use these keyboard shortcuts on a Mac?
Could you please do a series on Financial Modelling Basic to Advanced
Very informative video, I like your video, and what you are teaching is practical since I also use this in my work.
For years, I used to use excel and google sheets to budget and forecast my finances. This year, I released an app that does it for me with minimal maintenance. Give Money Spider and Money Spider Lite a try on Android.
Thanks for the useful video. Can I know how to calculate the actual cost for all the month?
Thank you, Kenji! u save my life in the mid night
I've built a number of budget vs actual reports - I would suggest, firstly using full contiguous data both for the budget and actual - then create a simple data model and pivot report - this can be built to be fully automatically updated
If you have your data in segments like shown here, it makes it more manual and time consuming
I do love the visual style however
Love your contents bro👌 really love how straight forward, clean and how comprehensive they are. I'm a fan of your work, keep it up✊
Really appreciate the comment Paul! thanks for taking the time :)
Realky helpful Kenji .. i learnt a few new things like shortcuts and index fornula as well as use of text formula a bit better
hello, kenji your contents are really helpfull i enjoy learning from them..... but for this specific dashboard, how can i make the variance for years and choose between them !!! Thank you
Thank you so much Kenji! You are a genius! Can you make some cash flow forecasting template too? Thanks again!
Please make a video for budget and forecasting of an NPO . Thanks
Great video, thanks for your perspective and intellect.
Great video brother, its super helpful, so excel could do this, wow
Great Insights and Thanks for the Video....
Love to see your content its really means a lot
Hi Kenji, Thank you for this tutorial!
thanks for the comment Samuel!
@@KenjiExplains I implemented it today at work. I showed them your video and where i got the idea from :) thank you again, boss
Hey Bro, your teaching is so impressive, subscribing your channel for more information, thanks a lot.😊
Very helpful vdo
Thank you
I was searching for this
thank you so much ... Keep it up sir.. i have learnt INDEX MATCH AND SUMIF At once . thanks
Splendid boss!!! Keep it up and keep giving us more important stuff just like this ahead 💖💖💖
Thanks! More to come hopefully :)
Very nice xls file you ender up with. What about add a sheet with all the records pr category? How do you solve that?
Really helpful and explanation is easy to understand
Thanks for the video, when I tried to make the actual date at 12:50 my excel can't accept cause the formula isn't on the list that we take how i do it then ?
Love your content. Very applicative as I work in finance & accounting dept. You got nu subs bro!
I am from Viet Nam country, So I thank you for your videos.
great video, just having some issues replicating your examples on my own sheet. Would you be able to help if I sent you my file?
Thank you, thank you, thank you !!!
Fantastic videos.
Interesting and informative. Thanks for sharing
That’s it’s freaking awesome 😎, Do you the spreadsheet available?
Thanks! It's in the description
Hi Kenji, thanks for this video man it sures help a lot. Quick question is there a way on how I could calculate the total ACTUAL savings instead of just showing how much you save per month?
Really love your content Kenji! I just secured an internship this summer because of your video. I learnt a lot. Please keep it up.
Also, do you have any suggestions about how I should behave during the internship? Should I ask a lot of questions or be prepared with everything?
The position is within an accounting firm in Nyc. Looking forward to your reply!
That's awesome to hear congratulations!!! Regarding your questions, I think it's good to ask questions (shows you're passionate) and you'll learn a lot more than if you're just quietly sitting on the sidelines. Also, you come across as more humble than somebody who thinks they know it all...hope this is helpful!
Best of luck with the internship :)
Love the today function and conditional formatting!
Glad you like it!
you use inex-match function often. Why not use xlookup instead? just curious
Hey! xlookup wouldn't have worked as there were both a row and a column variable that we needed to account for (date + line item)...the xlookup formula is very easy & convenient to use though!
@@KenjiExplains Thanks for the reply. However, xlookup would work. You would just use xlookup within itself.
@@SiaosiMaka i actually like that he uses index-match, because i have excel 2016, and unfortunaltely xlookup would not work for this version. But now i have a full tutorial for my dashboard. Lucky me. 😀
wow easy to follow thanks kenji!
Great easy to understand video
que excelente ayuda! mil gracias desde Rancagua-Chile
Great work thank you, one question how can i add also the organization’s in the excel ? for example i want to know the spend of each org in a month for an item.. thank you ..
It’s little fast you have to reduce speed. Except speed the video is informative. Thank you for sharing.
This is great! Thanks
This is a absolutely sweet video
Thanks for putting this together. This is very helpful.
Thank you. This is very helpful.
You're very welcome!
My favorite is autosum. Very underrated.
Amazing,, Could you please do a dynamic annual budget for startup company video ?
Thanks. Keep it up
Noted thank you for the suggestion!
Exactly what i needed!!!
This is great. But what is the cleanest way that you have found to physically import all of your actual transactions? I have 30 or more transactions each month and I'm trying to automate this import.
Great video, Kenji. More power. :)
Hi Kenji, for the expense %var, why did u divided the variance by the actual value? Shouldn't it always be divided by the budget? Mathematically, the minus only affect the numerator, not with the denominator? cmiiw
Great lesson. Thank you, Kenji.
yay another video...don't forget to say to like and subscribe at the end
and in the begining
hahahah hope you don't mind...helps out with the algorithm!
I follow that showing Utilities as unfavorable $28 makes more sense but when looking at the % change, it goes from 25% change to -20% change. I follow the mathematical change but conceptually, is it right to say that my variance is off by 25% or 20%? Especially since on the income side we are using Actual as the base whereas in the Expense you are using Budget as the base. Thanks!
great explanation!
Hi Kenji, thanks for great video, i want u to make a video talking about Data analyst and Mart document and do the report use by pivot and vlook up. please.
Would it not be easier to put all the Actuals into a table and then use that summation for the loockups?
nice vid as always sir dont stop
More to come!
Thanks for the videos helping out a lot!
Glad you like them!
astounding upload Kenji Explains. I smashed the thumbs up on your video. Maintain up the superior work.
haha love to hear it! Thanks for the comment :)
@@KenjiExplains no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.
Hello Kenji , Thank you so much for starting this is very helpful , I'm working on this Excel sheet but I'm getting error when using index match its showing #N/A how to resolve this error?
same problem with me
Love the content but unless one is already a little more advanced in excel (at which point one probably knows all this already) it's impossible to follow, especially with the amount of shortcuts. A beginner doesn't need to know these, a beginner needs to understand what they are doing there.
I've been studying excel for a while so I was only a little lost. It was very helpful for me thank you!
Hi Kenji, great vid - I was wondering if this 'comparison' graphing could be done where there is a CHOOSE used in the data? i.e. could I have a graph comparing multiple scenarios without typing each set of resulting values out as you have in the budget vs analysis?
great content it really helps familiarise with different excel functions
Glad to hear that!
Hi! Good work
Heey... Amazing video, especially with the short cuts. Are you FMVA?
Thank you! Sorry not sure what that means haha??
Thank you thank you ❤
Investing in Crypto is a lucrative and a big chance to make money online nowadays 💥
Stocks are good but Crypto is better
Would you please share the row data spreadsheet so that we can practice accordingly?
hi can u show how to display selecting 3 years and month and category? thanks
Hello there Kenji, nice video Kenji, really useful and helpful. Can you do another video on how to shows multiple month on the dashboard? It would be really nice to know how to do that. Thankyou in advance!
Thank you! Check out this video I made here for a more advanced budget dashboard: ruclips.net/video/Do3sOFny5Hs/видео.html
@@KenjiExplains Ohhh sorry, didn't realize you've uploaded a new video. Thankyou anyway Kenji! I will definitely watch that video
Hey Kenji, Can you please create dashboard for warehouse inventory analysis......It will be a great help for us.
Want to know consumption patterns of consumables with help of Excel, ageing analysis report. Need one complete video on that topic.
Love this channel ..
Thanks!
Hi, Kenji. If possible can u make a video in Company Annual Budget vs Actual variance dashboard like this
Brilliant 👏
Can be available loan amotozation table ?
Sir, do you have vedios for excel accounting in a package?. I am gonn buy for you?. This is one is too difficulty and i want sequence lessons?.
Great tutorial, thank you so much!
Glad you enjoyed it!
So much more easily done with a pivot table.
Fantastic.
Great video!!
Thanks!
*When it comes to investing, I'm so ignorant about it, I hereby ask; What's your say or thought for anyone with over $20k looking for the best ways to make good returns off it? I will appreciate any help here on how to do this*
@Lucy Bernardi Interesting, I've always been fascinated with investing and I need to start now. Could you possibly give more information on your Investment Professional and how I can reach out to her?
Amazing!
thank you 😇