Streamline sales forecast automation for IT with airSlate SignNow

How to create outlook signature

hey this is Chris from Financial modeling education and in today's video I'm going to show you how I quickly map actuals into a rolling forecast model so what I have here is just a company with a budget projection you can see we have actuals through May and then a forecast through the end of the year and then on this sheet here I have actuals that might come from an accounting system like QuickBooks or xero and I've got a lot of different accounts here but I need a quick way to bring all this information into my summary model without having to do a bunch of work each and every month and so what I'm going to be doing is mapping the lines that I have over here to my actuals so on the actuals tab I create a column that I call mapping and then for each and every each individual line item I tag it basically so I want these to be classified as Revenue all of these to be classified as direct cogs and then I make my way down the list so I take all my G and a and I basically put everything into buckets and then what I do at the summary level is I create a special formula to help me out and so if I open this up it says if the top is an actual then pull the sumifs from the actuals related to that specific column for January otherwise just give me the preceding month so I've simplified the forecast for this budget but basically you can see the budget just carries forward the latest actuals and so since I have new actuals as of June here you can see I have some activity I just want to quickly roll my model forward and so at the summary level I can just bring this actual forward one month and you'll see all of these figures and the forecast will change so I'm just going to press Ctrl R bring that forward one and you can see this all updated because what's happening now is this is referencing that column in June so if I trace it back it's saying it's looking up here in June and then it's mapping ing to this column over here and that brings me my summary there so it's a nice way to update it really quickly the real benefit though is let's say a new account gets added it's not going to mess up my entire model I can just add another mapping tag and then my summary model updates just fine so this is a great thing to put into practice if you have a business with a lot of different accounts or potentially changing chart of accounts so that you're not always moving accounts between one tab to another you want to map it in one place and then summarize it in another so hope you found this video helpful that's it for this one I'll see you in the next one