 QuickBooks Online 2022. Budgeted income statement, export to Excel and modify part number one. Get ready because it's go time with QuickBooks Online 2022. Here we are in our Get Great Guitars practice file. We set up with a 30 day free trial holding down control. Scrolling up a bit to get to the 1 to 5% currently in the home page. Otherwise known as the Get Things Done page in the business view as compared to the accounting view. If you want to change to the accounting view, it's something you can do by going to the cog up top. Switch to accounting view down below. We will be toggling back and forth between the two views either here or by jumping over to the sample company file currently in the accounting view. Back on over to the Get Great Guitars. We're going to open a few tabs to put reports in. Going to the tab up top, right clicking on it, duplicating that tab. We're going to go back to the tab to the left, right click on it again and duplicate it again. As that is thinking, I'm going to see where the reports are located over here in the accounting view which is on the reports on the left hand side. Going back to the business view in the Get Great Guitars. We're in the second tab. I'm going to be looking at an income statement report and a trial balance. Let's open those up by going to the business overview. We're going to go into the reports on the left hand side. Closing up the hamburger. I'm not opening up the balance sheet this time. Changing things up. Changing things up. Income statement, profit and loss here. The P and L range to the change from 010122 to 022822. We're going to run that report. Let's go to the tab to the right. This time a trial balance going into the business overview. We're going into the reports on the left hand side and I'm going to close up the hamburger. Let's do that first and then type in trial balance to find it and open up the trustee TV, the good old trial balance. Let's do the range change up top from 010122 to 022822 and run it. Now we're going to be looking at the budgeting process. We talked last time about the fact that the budgeting process back to the tab to the left on the income statement is in essence generally something that's outside of kind of the strict definition of what's done during the accounting process. In the accounting department because the accounting department is there to record prior or past transactions or current transactions as they are happening in such a way that we can then construct the financial statements from them on which in part internal users such as management can then make future decisions based on things like the budget. The budget then taking past information projecting out into the future with it to try to give us a give us a plan into the future. So that means that the QuickBooks system from an accounting standpoint is not designed to create the budget in essence it's designed really to once budget is created implemented into the QuickBooks system. So QuickBooks can do what it does well which is to generate reports especially a profit actual versus the budget number type of report. So what we're going to do here is take the past period number export it then to Excel and then try to try to then think about what's going to happen into the future based on the last year's numbers make some changes where necessary and then import it back into Excel putting it into the budget area that's going to be the general plan. We're going to be primarily focusing on the income statement which is going to be the performance type of statement. So this is what we have done for the last two months. This is the only two months of data we have in the system. This is our performance for the prior two months. We're going to kind of imagine here for our budgeting purposes that this happened basically in the last two months meaning in like November and December of the prior year so that we can imagine it happened before. And then we can make a budget based on that information that can be a standard 12 month budget out into the future. So a little bit of a variation there hopefully that's not too confusing but that's the idea. If you go to the first tab notice I'm going to where the budget is located. I'm going to go into the cog dropdown. We're going to go then into the tools over here and then we have the budgeting tool. That's where we're going to put the budget back in once we've created it. But to create the budget I'm going to export the past data the income statement and then create the budget and then come back in here and put it back into the system so that the QuickBooks system can give us reports like the actual versus the budget. Now I actually don't want to use the income statement numbers directly because I've got all these subtotals. I don't want all these subtotals. I just want to straight you know accounts. So the easiest thing to actually export in this case will probably be the trial balance which we can then just delete the balance sheet half of it and then create an income statement from it. So I know this is not an Excel course so I'm going to do this fairly quickly. If you want to skip over this and get back to the budgets that we're going to do pretty much next time you can do that but we're going to do some Excel work here. In order to do this I'm going to export this to Excel. This is the plan I would typically have when doing the budget for a company. I would take the data, export it to Excel, do the budget in Excel and then put it back in the system. All right, export to Excel. I'm going to put that into our folder here. I'm going to call it a budgeting folder. That's where it's going to go. I'm going to drag it and drop it. I'm going to grab it, drag it and drop it. That is mean to do to the file. It's just a file. It's just a file. You grabbed it, you dragged it and you dropped it into this pit of a folder. Okay, so then I'm going to right click on it over here. Let's make it large by the way. Let's make it a large icon so we can see it better. Then right click on it and rename it. This is going to be the budget. I'll just keep it at that. And now let's open it up. So now I'm just going to clean this thing up and make a single step income statement instead of a multiple step income statement. With all the subtotals on the way down. I just want income minus expenses. That's it. This simple income statement. So I'm going to make it a little bit larger. I'm at the one four five. Let's keep it there. And then I'm going to just delete a bunch of stuff. If I mess anything up, then I'm not worried about it because I can always create it again and do it again. So I don't need the header. I'm going to delete that, put my cursor on one, the whole column, and I'm going to go down to four. And I'm going to do this quickly because it's not an Excel course, but I'll try to, you know, explain what I'm doing. So I'm going to right click on that and delete that. So there we have that. Now I'd like to format the whole worksheet in a uniform formatting. So you can see here I'm in aerial eight. But if I'm over here, I'm in a Calibri 11. I'm going to go to Calibri 11 because that's more what I'm used to as my default position. So I'm going to take this item. I'm going to hit the format painter and I'm going to paintbrush the entire worksheet by then clicking on the little triangle. And then I'm going to format this entire worksheet in the format that I want it to be in. So now it's in like the basic Excel formatting, the starting point for Excel. I'm going to right click on it and then format this thing. And I'm going to try to make the whole thing a uniform format, which I'm going to make currency negatives are red and bracketed and the dollar signs removed. Should I keep the pennies? I don't really need a pennies because it's a budget. So I'll get rid of the pennies because it's going to be rounded anyway. So it'll be a little bit cleaner possibly. So there we have it. Okay, that looks good. I'm going to make the whole thing bold too because that might make it easier for you to see in a presentation purpose format. Okay, so then what we want to do is I just want the income statement side of things. So remember this is in order of balance sheet on top of the income statement. So assets, liabilities, equity, and then the income statement. So the income statement actually starts like right there that billable expense. So everything above that I don't need. I'm just going to remove it. I'm going to put my cursor on row 25 left click on it. Go all the way up to the top right click on the selected area and just delete that entire thing. I also don't need the totals down here. Let's put my cursor on column on row 18. It's a row. It's not a column. It's a row. There's only columns are vertical rows. I got it. I got it. Okay, so now we're going to make all these expenses. The debits are expenses on the income statement and the credits are income. I'm going to make the expenses negative. I'm not doing debits and credits here. I'm going to say all of the income is positive. All of the expenses are negative. And so I want to make all these numbers negative. So I could double click on them each one of them and put a negative sign in front of them. But that's tedious. And there's a little trick that we can do to do it faster. So let's do that. Let's do the trick. I'm going to put my cursor on the column B. This is a column this time. Control C. See, I know what the difference is. And then I'm going to go back on over here. I'm going to right click and I'm going to then I'm going to state. I'm going to paste it, but special space it in a special way. And I'm going to go down here and I want to put the special subtraction paste. Boom, special paste. And then just paste them all at negatives. So now that looks good. So I'm just going to copy and paste that back on over here so that those are all negatives now. That looks good. I'm going to right click on this one, delete it. And then I'm just going to move these over to the same column, grabbing them a couple of ways I can move them. I could grab like this column by putting it right there and move it over there. I think the easiest way is actually to cut, not copy, but cut, which you could do by right click and cut. Or you could say control X and then control C, control X and control C. I mean, control X and then control V, control X and then control V. That's what I meant. That's what I meant. And so this is going to be the net income at the bottom. And I can sum this up and I expect when I do, just for suspense of purposes here, what do we expect to happen? If I go to the income statement, we expect to have net income at 132405. Is that what's going to happen here? Let's check it out equals the sum brackets. And this is the trustee sum, the most popular function. And there it is 1324. That's it because I rounded it, right? 1324. So we didn't mess anything up. Everything is unmessed up. So that's what we have. So that can be then our starting point. This is in essence going to be our income statement without any of the subtotals. I just got a clean income statement, just positive numbers, income, negative numbers, expenses. I don't have a subtotal for the cost of goods sold or subtotal for all the income accounts or subtotal for gross profit or subtotal for the general expenses. The payroll, the total expenses, the other income, the other expenses and blah, blah, blah, blah. It's just if it's going, if it's income, it's positive. And if it's an expense, it's negative. That gets us to the bottom line in a single step, simple as possible and easiest on which to build a budget from next time. We're going to assume this in essence being the prior two months of data. And we're going to kind of assume it was before January. So this is like last November and December pretending that was the first two months, for example. And then we'll then we'll make a projection 12 months out based on it that we can put back into the QuickBooks system and run reports, budget versus actual for the first two months. And then we'll have just budget reports out into the future. Imagine we have not yet, of course, been in that point, don't have any actual data because that's in the future. So we'll do that in future presentations. It will be great.