This presentation we will generate, analyze, print and export to Excel a budgeted Profit and Loss report, we’ll take a look at a budget of profit and loss and a budget versus actual Profit and Loss report. Let’s get into it with Intuit QuickBooks Online. Here we are in our get great guitars file. You’ll recall last time we enter data for the budget. And we did so by going to the cog up top and then we went to the tools we went to the budgeting information, and we entered this budgeted information. If you were to edit it, then you can go back into it and enter that information here. I’m going to close this back up, then we’re going to then go into our reports.
00:37
Now I’m going to go to the reports on the left hand side. I’m going to type in up top for the budget information. I’m looking for the budget information and I have an overview report. We have the budget versus actual I’m going to take a look at the budget overview report. So budget overview. I’m going to close up the hamburger and hold out can scroll control and scroll up just a bit to get That one to five. So here we have the budget. The budget overview for 2020 of these is the P and L budget, and it’s going to be showing January through December 2020. So we have the information down below. And this will of course reflect what we have input into the system.
01:16
The net income as we saw in the data input screen being negative up until August, and we are showing profit on the year of the 6001 71. For the year, you have some of your standard kind of customization tools up top if I was to customize the date range, we can go from January for example for the first quarter, which would be in on Oh 331 to zero and run that report. And then we would say January, February and March and of course the total for that three month time period. We have the similar customizations up top where we would we would do our similar kind of customizing, remove the pennies are going to make the negative Numbers bracketed, it will make them read. Scrolling down, we’re going to say that the header and footer, we’re going to remove the date and time.
02:08
So we’ll remove the date and time, we’re going to go ahead and run that report. So there we have that, and looks good. So I’m going to go back up top, and I’m gonna, I’m going to take it for the full year again, as a 1231 to zero. And then let’s go ahead and do our printing of that report will print it as a PDF file and will export it to excel. So I’m going to go to the printing option. And I’m going to be printing it using that cute PDF printer.
02:35
So we’re going to go ahead and print it’s going to be presenting to the cutepdf printer, which means it’s going to be printing as a PDF, then we’ll go ahead and save it. Then we’ll say okay, what do we want to put it so I’m going to select the drop down, we’re going to say it’s in that course data. I’m going to make another folder and I’m going to call it number 11 budget budget teen something like that. And then I’m going to put it into the budget team folder. And then I’m going to call it the budget overview. And then save that. Then I’ll close this back out. And then let’s export it to excel as well. So I’m going to export it to excel, open it up in Google Chrome.
03:16
So there it is, I’m going to go ahead and well, we could do some formatting here. If I go to the second tab, and back to the first tab, so Page Layout View back to normal view of it doesn’t fit on a page. So we got to do some formatting with this particular one. We’re going to go back up top to the page layout, I’m going to go to the to the page setup. I like select the orientation, bring it to the landscape, and we’re pretty close. That’s pretty close. And then we can basically shorten this one up possibly can shore that one up. And maybe we can shorten all these up.
03:51
If I highlight all of them and I double click on them. It’ll make them a little bit uneven, but it’ll shorten them as small as they can go. And we could change basically font sizes if we need to. But I’ll just, it seems like we should be able to make these a little bit smaller, I’m not sure what I’m going to, I’m going to highlight the whole thing and make these a bit smaller and see if it smaller that it makes this one not quite fit like that one a little bit bigger.
04:18
All right, something like that seems to fit. All right, now I’m going to save this thing, I’m going to go back up top, I’m gonna go to the File tab, we’re going to save the report. Going to locate where we want to put it, we’re going to go to the Browse function to do that, of course, I’m going to put it down here in our budgeting folder. And this is I’m just going to call this budgets and save that. And there we have it. So I’m going to minimize this and take a look at our other report now. So let’s go ahead and duplicate the tab up top for this one. So I’m in I’m in QuickBooks, I’m going to right click the tab and duplicate it. Then I’m going to go back to the tab to the left. I’m going to open up the hamburger I’m going to hold down Control and scroll down a little bit to get back to 100%.
04:57
So it doesn’t do anything funny and then I’m going to go down and reports on the left hand side looking for that other report, the budget versus actual Report, I’m going to search for that one. So I’m going to go into the search field and type in budget. And we have the budget versus actual, that’s the one we want. I’m going to pick that one up, open it up. And then we’ll close up the hamburger again, we don’t need the hamburger anymore. I’m going to hold down Control and scroll up just a bit. So we have that budget versus actual. Now we can change the dates up top, I only want to look at the budget versus actual for like the two month time period, because that’s the only time period where we have actual data in it.
05:33
So I’m going to select the first tab up top, I’m going to say a 10120 dates up top 202 29 to zero, that’s going to be the two months of data, actual data that we have. And then if we scroll down we see our information of course. So this is what actually happened. This is what would be on the P and L for January. This is the budgeted information for January. This is the difference the difference between the two We also see the percentage of the budget. So we had the percentage of the budget, then for February, the actual number, the budgeted number, the over budget, and then the percentage of the percentage of the budget. And then finally, we have the totals for the two month time period, the actual the budgeted for that, you know, combining January in February, the budget overview, and I mean, sorry, the the over budget, the difference, and then the budget percentage.
06:30
So you can see those numbers all the way down. So our comparisons a little bit arbitrary, because of course, we didn’t have a lot of data, we just kind of picked numbers for the budget. But if we were to compare this out with a, you know, we didn’t have any equipment rental, and in January we budgeted 1000. sales were much better here in January, and the sales of the products were much better as well. And then the cost of goods sold is higher due to the sales being higher and We had the budget for the bank service charge we had the depreciation for the budget that we didn’t record the depreciation in January. If I look at February here, let’s take a look at February, we had the depreciation so 900 difference on the depreciation insurance. Here, there’s a bit closer, they roll off by 600 and payroll taxes.
07:27
So you could basically go down through and you know, do your analysis from the budget to the actual information. You have some some of your familiar characteristics up top notice what has been selected for you is basically the the dollar over budget and the percent of budget you don’t need those, but that’s there by default. Typically, if I take them off and run that report, it looks a little a little bit easier to look at. But those are those are two things that you would typically want to see if you’re comparing the budget versus actual this would just be comparing the budget and actual but not seeing the difference. between the two, we probably want to see that. So I’m going to go back up top. Those are going to be these items up top. And we’ll run that report.
08:08
All right, and so we’re back to the the real, let’s go ahead and run it, because I don’t think we’re back there yet. There it is. Now we’re back. Okay, and then let’s do the customization up top, I’m going to go ahead and customize this. And we’re going to say that we want to remove the pennies, we want to make the negative numbers bracketed and red. When it go to the header and footer, we’re going to remove the date, the time, the report basis, and then run that report. And then let’s do our printing options. And we’re going to go back up top and we’re going to print it to a PDF file and we’ll also export it to excel.
08:43
So we’re going to print it here. We’re going to be printing it to the cute PDF printer. So let’s do that say print down below. And then it asks us where we want to put it. It’s in the right places time. So I’m going to say this is the budget versus actual report say That was an export it to excel, I’m going to close this one out so we can do so and then I’m going to select the drop down here, Export to Excel, it’ll then open up in the bottom left of the Google Chrome, and I’ll open it up from there. There it is, let’s go ahead and copy this entire thing, I’m going to put my cursor on the triangle up top, and then right click and copy of the entire thing.
09:19
So we’re going to copy the entire thing, then I’m going to minimize this one, we’re back into the prior report that we have saved, I’m going to select the plus button down at the bottom. And then I’m going to double click on the sheet and then I’m going to put that this is going to bethe budget versus x tool. And then I’m going to go back up top and a one right click and paste there, put that up top. Let’s check and see if it fits on a page we’re going to go to down below the Page Layout View doesn’t fit on a page. Let’s go back to the normal view and see what we can do about it. So then we’re going to go and do our first thing we typically do when this happens.
09:53
We’re going to go to the page layout up top. We’re going to go to the page setup. We’re going to change it to the orientation, we’re going to make that landscape And again, that makes it really close here, not quite there, if I if I highlight the entire thing for all the columns and make this a bit smaller, and like a bit smaller, and now it’s a little too small and a little larger, but not that large, but like a little smaller. And let’s do it one more time was the little bit. And so there now that looks pretty good. I don’t see any numbers that have been removed due to that process. So I’m going to keep it there. That looks pretty good.
10:33
Let’s go ahead and save this. Then I’m going to go to the File tab and we’ll print this as a PDF file with all reports on it will go to the Browse function at the bottom. That’s not what I wanted to do. I want to go to the print. Then we’re going to print it to the cute PDF printer. I want to print not just the active worksheet, but the entire workbook which will have the two pages or three pages. That’s what we want. So I’m going to go ahead and print it to the cute PDF printer. And then it’s going to ask us where do we want to put it, it’s going to the right place that looks good.
11:08
So I’m going to go ahead and save it there. Now let’s take a look at our our reports that we have thus far and see how we might give this to somebody, we put them into the budgeting information, we could either attach these two reports, or we could put them into a folder and attach the folder after we zip the folder like this. And I’ll put these two reports into the folder. And we should call the folder something other than New Folder.
11:33
So I’ll rename it and call it budget teen or something like that. And then I’ll click on the folder and we could zip the folder by sending it to a compressed or zip file. So then we can we can attach that to an email or we can open up this report this PDF report and attach simply this PDF report which will have the three pages on it. I believe it does have three pages right yep. So those are the three formats we can provide this information to somebody