 Was a little bit different So I'll say negatives negatives Negatives Why are you so negative man? I'm not negative. I'm just putting the negatives in I'm a very positive Individual kind of something compared to some at least maybe depends on it's whatever and it's let's let's run this again Let's update it again and then If I go if I go down so now we're at the 1 0 3 8 1 0 3 8 pretty close if I go all the way to the right. We're at December 23 8 16 So 23 8 16 in December Okay, so so that's going to be our budget Summary report if I wanted to take a look at the whole year I could say 12 months in the period and then let's say that we want to show one period of 12 months and So now we've got our total which comes out to 125 972 and I'm got 125 965 125 972 so it's off by 7 which could be rounding so I'm cool with that because it's just a budget so so it shouldn't so that's kind of in Material so I'm like all right. That's good. And so let's say let's bring it back down to one period and We'll bring it back to 12 of those one periods So there we have it So now we've got this nice report that we can we can generate and we can you know kind of make our Projections we can provide it to a client and whatnot the project out into the future and then as time passes What we want is that variance report so now that we have this in here Let's go let's go and make another tab duplicate and Let's go into the accounting and reports again and look at the variance report What is this? I went into the 1099 thing or something. It's not where I've that's not where I want to be That's not where I was trying to go man Let's go to the very the budget variance report That's that's what I'm talking about. That's where we want to be All right, so up here then we've got our date range So let's just take a look at the first two months because we have data We have actual data in the first two months. So I could go from January one to February 28 and Then this is our one budget. So that's good and update it And so there we have it now We have our options here a cruel cash and we could show the accounting bases codes and decimals if we want probably don't We probably don't need the decimals We don't because we didn't put any pennies in there So I'll just take the decimals off and that can clean it up or make it a little bit smaller and Easier possibly to see all right. So this is the standard. So now we actually have numbers so now we are imagining that time has passed and The actual numbers have come through for January. So We have the actual numbers and then the budget numbers and the variance which of course is the difference So if we pull out the trusty calculator to do some trusty calculations We can say obviously if I took the total down here We've got the actual six nine two one one minus the budget seven three one nine two So so the the the actual is less than the budget and then that we've got the difference Which is the variance which is going to be That's calculated by taking the the variance over the budget amount. So divided by the budget seven three one nine two moving the decimal two places over about five percent and So so there we have it and then we have February Same thing. So we've got we've got the actual the budget the variance and the variance Percentage and then we could we do have our editing layout so we could Enable add notes so we can insert content and add notes to it We could edit the layout and we have that capacity to do our Our editing over here as we choose as well So we might have a report like this for example, and we might add a column that would sum up You know the total so you still have that flexibility that zero has with with making more flexible reports Because of that that great editing tool That it has here So let's go back on over now. Obviously if we went out into the future beyond this We wouldn't have any data left. So if I pull this all the way out to December for example We have the budgeted information all the way out through December But we don't have actual data out past February So it's actually not even going to generate it because we don't have any actual data for the actual numbers out past that point so So obviously the variance report is useful when we're comparing when time has passed We predicted what's going to happen We put a budget in place and then time has actually passed and we can make that comparison from The budget versus the actual now down here. You have a similar Kind of thing on the expenses just to just to look at the expense side of things. These are You know, here's here's the budgeted amount for the bank service charge This is the actual this was the budget and here's going to be The change and the variance and they gave you these nice little arrows to say If we're over or under So in this case, we're under budget and if we look if we looked at this we could say this is what actually happened 35 minus what was budgeted to one six a difference of one twenty one eighty one under budget and I can divide that by The budget amount to one six moving the decimal two places over that gives us our eighty four if I multiply times a hundred It's going to give us about eighty four Percent and we can see that all the way down here and then we have of course our totals And again, we've got the editing of the layout We can customize these and we could of course export these files to the PDF to excel if we want to further Adjust them with an Excel so that overall process of the budget We generally are going to say the accounting department isn't normally responsible for the budget alone Because they need added information from the management or the owner of the business But if but they were going to be included in the budgeting process because obviously it looks like an income statement in a balance sheet and We're experienced in making the income statement and the balance sheet from a technical perspective The way I would recommend doing that is taking the information from zero Downloading it to excel and then working with your team of the owner of the business management and the accountant in Order to make a budget that we can then put back into the system zero data inputting it into zero From excel possibly with a template and importing it or possibly just data inputting it so that zero can then run These nice reports one of the best ones being of course this budget versus actual Report that we could run as time passes to benchmark how we're doing compared to how we planned that we would be doing