 QuickBooks Online 2022 Budget Reports. Get ready because it's go time with QuickBooks Online 2022. Online in our browser searching for QuickBooks Online Test Drive. Going into the Test Drive we're going to be choosing the United States version of it and verifying that we're not a robot. Sample Company Craig's design and landscaping holding control scrolling up just a bit to get to that one to five percent. We're also going to have the free 30 day trial version open just so we can compare the business view and the accounting view. If you don't have access to this at this time that's okay. We're just using it for a reference going back then to the sample company and we're then going to open a few tabs by right clicking on the tab up top and duplicating it back to the tab to the left. Do it again right clicking again and duplicate again back to the tab to the left right clicking again and duplicating again. As that's thinking we're going to go on back on over to the free 30 day trial version just so we can see where the reports are located which is under the business overview section and there are our reports and if you were to switch to the accounting view which you can do by going to the cog drop down and go to the accounting view you would have a similar view than what we are looking at in the sample company which we're going back to now. So we're in the second tab we're going to go down to the reports down below this is where they are located in the accounting view. We're going to open up our favorite to the balance sheet the profit and loss and screw up and do the good old range change on them 0 1 0 1 2 1 2 12 31 2 1 and run it closing the burger going to the tab to the right doing it again by the going to the reports down at the bottom this time the P and L the profit and loss the income statement going up top and ranging the changing 0 1 0 1 2 1 2 12 31 2 1 run it and then closing the hamburger now we're going to be looking at the budget type of reports remembering that the budget is a little bit different than any other kind of report because that's going to be a forecast into the future so just realize that when we're thinking about the budget when you're looking at the normal accounting process the budget isn't really something that kind of falls into the normal accounting in the definition of taking prior transactions and using them to construct financial statements the budget then is going to take the financial statements and make future projections based on past data as well as future information therefore the budget kind of takes into consideration multiple areas right you've got the accounting area which is the prior data that we're going to be using and the construction of the budget will be using accounting and then we've got kind of like corporate finance or decision making or managerial accounting you could call it type of topics where which means we're going to take that past data and make estimates or projections into the future which is which is typically kind of different than like normal or standard like bookkeeping type of accounting because that means we're actually looking into the future to make decisions on the data from the past and then you could cross over with like economics and so on which means we're going to take into consideration market data and what not as we make the projections into the future so on the accounting side of things if you're doing the accounting you're thinking I'm my primary job generally within QuickBooks is to enter data of prior transactions to make the financial statements on which the management can then make future decisions and use it to comply with any kind of things they've got to comply with such as taxes and reporting needs and then go into like you put your next hat on your other hat on which would be managerial accounting corporate finance kind of accounting and economics and what not and try to think about that past data how you can project it into the future now that also means that you would typically do that not in the QuickBooks system in other words I'm not going to construct the budget just within QuickBooks what we'll typically do is export the data from say a profit and loss report the performance report which is the first thing you would think about although you can do the balance sheet too and think about budgeting out the balance sheet but the performance report is the profit and loss and then perform your estimates possibly in something like Excel your projections out into the future once you have those projections then I would put them back into the QuickBooks system and that's where the bookkeeping falls into play with the accounting of the budget because then we got to account for the numbers that we're forecasting into the future putting them back into the system so that we can run comparative reports meaning I would like that what QuickBooks does well with a budget is run comparative reports what actually happens versus the budget so we can do the comparisons and track what we're doing in the future okay so that said if I go to the right tab over here and go down to the reports I don't think we have anything in the budgets at this time so if I type in budgets they don't have any budgets they didn't set up any budgets so let's set up a budget real quick and then we'll do this more in the budgeting section but just let's put some numbers in just so we can look at these reports I'm going to go to the first tab to do it the budget is located up top in the cog up top and then we're going to go into the budgeting information here budget and then we're going to apply add a budget we're just going to add a budget because they don't have one and we'll just say let's just call this budget one budget number one and then typically when we're thinking about the budget we're thinking about the income statement so that's what their default is because that's the performance report we can make multiple budgets we'll talk more about this later but let's just put a practice budget and then we're going to make it monthly quarterly or yearly we'll make a monthly one and then we're going to pre-fill I am going to pre-fill based on the prior year data so I'm looking at 2022 I'm going to take the 2021 data as the starting point to pre-fill the data and then make adjustments from there again you would probably want to make the adjustments outside of QuickBooks in something like Excel to think about what your number should be and then input them into the system in this way when you come back here now I'm going to there's the data it's on the right hand side notice that the sample file they were kind of lazy in my opinion you know they kind of they only put a few data points starting in September so in any case I'm going to add I'm just going to put a few more data points in here let's let's go ahead and create the budget once I create the budget now I can put a few more data points in here so I'm going to say let's go into here and say this is going to be I'll just pick a number 9 let's say it's the 950 and I'm just going to add that across so I'm going to say tab and then add it across and they'll just do this for some of them this is a discount I'll put this at the negative 50 let's say and then take that across and then I'm just looking over here and putting in a reasonable number so I'm going to say this is the landing services let's say 400 tab and then copy that across copy it across and then I'm just going to make it standard all the way across the months just so we can have something to play with here so you can see some reports this will be 300 and then copy it across copy it across Roger Roger that copy out it froze something is frozen I fixed it don't worry people I fixed it and then this one's going to be let's put this one at the 150 and then copy that across and so there we have that then I made this one 180 will copy that across and then this one down here is the total so that looks pretty good and then this looks this looks pretty good if I scroll down let's get some expenses in here some expense action on the automobile advertising let's make this one let's make this one like 110 that's not a one 110 and then we'll copy that across and then the automobile let's make this at 75 and copy that across and then the the fuel I'm going to put at I'm going to put this one at 190 and then copy that one across and that should be good that's enough to work with so let's go ahead and save this one save it and so there we have it it's been saved and so then I'm going to close it out going to close it out and then go back to our tab on the right and now I can look for my budget reports the budget reports let's refresh it I got to refresh it now let's look for our budget reports again budget so there they are there's our there's our budget overview and the budget versus actual now the budget overview is just going to give us you know an overview of our budget it'll look like basically an income statement type of report and the default is it's breaking out here by month so we got the month by month breakout and then we've got the total on the year on the right hand side for the income and then the expenses so we basically have an income statement in essence which is broken out by month and if you take a look up top you got the drop down it's going to be the budget that we have put in place here you could change the range up top so if I wanted to just see like the end of the year for example I could change this to like 10 1 2 2 and run that one so now we've got the end of the year information on the budget for the last three months the last quarter so the other report that we can take a look at is the budget versus actual which is a great report and that's kind of one of the major reasons that you want to put it back into the system so that when the actual time period goes by you can compare what actually happened to what was budgeted and then look at your look at your differences so let's open up the hamburger again go back down to the reports on down below and let's do a budget versus actual budget versus the actual stuff and the budget is like what we thought was going to happen and the actual is what actually happened so obviously to run this report and have it make sense you would have to have the actual time frame having passed so that you have some data inside it there's not much data in the actual here because all the data is in 2021 so in any case we've got we've got the actual information here there's not much activity we've got the budgeted information and it's broken out by by month here and then the budget over budget the over or under the difference between the two broken out by month and if I go all the way then to the right hand side all the way to the right then we've got our information for the total here's the budgeted information here's the actual again nothing much in the actual the difference and the percent of the budget so we could of course change the date range here so we might look at say the the let's say the first quarter of this time 01 01 2 2 maybe one might have some data in that area until let's say 03 31 2 2 and then run that one run that one hold control down scroll down this is obviously a much wider report because we do have this comparison information for it and then of course we've got our totals on the right hand side breaking out the comparisons on the side by side budget versus actual so again the general idea for the budgets would be one remember that the budgets are something that are kind of added on to the bookkeeping the bookkeeping your standard accounting bookkeeping job doesn't really include the budgets because the budgets represent management making projections into the future so when you're doing normal accounting you might not be thinking budget but accounting bookkeeping data input and what not is involved in the budgeting process usually you're going to take the past information and then add predictions about in the future which is going to require management to do to think about and then once those predictions have been made then you're going to take that budget possibly created in excel put it back into the quick book system however so that then you can do what quick books does well which is run reports taking the budget numbers versus the actual numbers and that'll give you relevant data that you can make decisions on as time passes obviously if any of the budgets change if you want to adjust the budgets you can go back on over here look at this budget by editing it or you can add you know another budget you can run multiple different budgets