 QuickBooks Online. Profit and loss, print, save as PDF, and create management reports. Get ready to start moving on up with QuickBooks Online. We're going to be using the free QuickBooks Online Test Drive Searching in our online search engine for QuickBooks Online Test Drive Selecting the option that has Intuit.com and the URL Intuit being the owner of QuickBooks. Support Accounting Instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical reasonable fashion making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files, and more like QuickBooks backup files when applicable. So once again click the link below for a free month membership to our website and all the content on it. We're going to be using the United States version of the software and verify that we're not a robot. Zoom in by holding down control up on the scroll wheel currently at 125% on the zoom in selecting the cog dropdown just to note that we're in the accounted view as opposed to the business view. We'll try to toggle back and forth between the two views so you can see where things are located in each of them. Right-click in the tab up top to duplicate it as we do every time. Right-click in the duplicated tab to duplicate it again as the tab to the right's thinking. We're going to go to the tab to the middle and open up our reports. The reports being the balance sheet report. That's one of our staples, the standards as that's thinking. Even though it's done, I'm going to time to the right reports on the left. And this time the profit loss, the P&L, the income statement are point of focus for this presentation. Closing the hamburger otherwise known as the hand boogie and changing the ranging. 010122 tab, 123122 tab, run it to refresh it, tab to the left. Close up the boogie, scroll up and change the range from 010122 tab, 123122 tab, run it to refresh it. That's the setup process we do every time. The major financial statement reports being the balance sheet, the income statement. Scroll in a bit here. Going to go to the tab to the right. Our focus has been on the income statement. And now we're going to be thinking about how we can present, how can we package this information to provide it to end users such as a client, possibly on a monthly basis, possibly on a quarterly basis or yearly basis. Now we went through some of the different options last time and customizing or saving those options to easily retrieve them so that you can make the quarter end, year end, month end as easy and efficient as possible. Now we're going to focus more on exporting those data and batching them, grouping them together. Our options, we can open each of those reports and email them. We can print them out and give them to someone if we have that option. Although more stuff is being digital these days, we can save it as a PDF file and then try to provide it on a cloud drive possibly so that they can have access to it that way. In which case we might want to number the files so they can have an ordering of them. We might try to use Excel which will do in a future presentation to package all the reports in one Excel file using that to create a PDF file. Or we might use their management tool over here on the left hand side. I'm going to go to the left reports and then they have a management tool over here to kind of group our reports together. Right now we're going to use save as a PDF and then we'll also take a look at this management tool quickly because we saw it during the balance sheet side of things as well and then next time we'll export to Excel and use that method. Either method we use, we're going to have to have some customized reports here. Now because I start over every time, we don't have any customized reports in our customized reports center. So I'm going to recreate the customized reports but I'm only going to do like three or four of them and do them quickly just so we can then see the next step which is to save this information and bundle it in some fashion. Alright so let's go to the income statement tab and let's just make a couple of these. So first time I'm going to collapse, I'm just going to collapse everything. I'm going to then go into my customization up top, do the standard customization without sense, brackets on the negatives, red on the negatives, header, footer. I'm going to call this an income statement. Let's call it a summary income statement. So this is my simplified income statement. And so there it is, no date, time, report, basis, boom, run it. I was running and then we're going to let's save customization. I'm going to add a group. The group is going to be month and reports. And then I'm just going to say that's my number one summary income statement. This is what we've done in the prior presentation so I'm doing it fairly quickly here. So we're going to save it and there it is. So if I go to the first tab, refresh the first tab with a little refresher button in next to the URL reports down below. There it is. It has been saved. Let's just do like two more. So I'm going to go up top and this time let's expand it and then let's do a comparison on a quarter by quarter comparison. So we'll do quarter by quarter comparison. Let's check out the quarters, run it, change the name up top. I'm going to say this is going to be a summary income statement. No, it's going to be a income statement. Let's say by quarter by quarter. I should probably get rid of that date thing at the bottom because it's no longer applicable really. So I can customize it and I can go down to the header and footer and that date thing at the bottom report period. That's the one I'm talking about. You know the thing. That's the thing. There it's gone now. And then we can save customization and make this number two, boom, income statement by quarter. Let's save one more just for our practice purposes here doing a comparative income statement. Let's bring it back to the totals, run it, and let's do a last quarter comparison. Let's go from 10, 01, 01, 2, 2, boom, and then I'm going to compare. We've done these in the past. That's why I'm doing them quickly here. I'm going to say previous period, percent change, dollar change, run it, run it again. You didn't run it. Okay, there they did it that time. So this is going to be a comparative income statement, comparative income statement. And by month or let's just call it that. We'll just call it a comparative thing because that's the only one we're going to do. So I'll copy that one and let's say we're going to save customization. This is number three, number three, boom, save it. So now we've got some reports saved next step. We're imagining it's the end of the month and we're not going to generate them all again. We're just going to go into the customized reports here. I'm going to refresh this and then they're nice and numbered for us. So at the end of the period, I could just go in here and open them up and change the date range and then bundle them together. So I'm this time going to save them as a PDF file and imagine we're going to provide them to someone possibly in a zipped file for an email or possibly using like a cloud drive. So I can open each one of these, simply change the date range up top and then I'm just going to print it. Drop down, report, export to a PDF and I've got my smart page breaks. It's going to be portrait, repeat page header. That looks good. Let's save it as a PDF. I'm in Chrome so it's going to be populating down here. I'm going to put that into my folder. I'm going to minimize. I got my folder right here. That's where I want it to go. Test drive reports. So I'm just going to add it to my reports folder and let's go actually into here. And so I'm just going to add it into my reports where I had my income statement last time or my balance sheet stuff last time. And so now I'm going to add my income statement stuff. And so I'm just going to pull that stuff over. Boom. And then I'll rename it. Now notice I named it again. I probably should have named them. I should have started on number five. So let's actually rename these in here. I'll make this one edit number five. Imagining that my balance sheet reports were in there. So this is number five. And then this is number six. Hold on a second. Number six after my balance sheet reports. And then save and close one more time. This one is number seven. Boom. So now if I add them to my balance sheet reports that I had over here. This one I'm going to make number seven. I'm going to right click rename number seven reports. Now it's in actually no that's number. Rename. That's number five. It's going to be in order. That's number five. Now it deleted the title entirely. Don't do that thing. Don't delete the title. I just want to change the number to number five. Okay. There it goes. All right. Then I'm going to do this one. Same thing. I'll just go into here. And then I could change the date range and just go if it was the end of the month. And then just save it as a PDF exported. I should say. And save it. Boom. And then I'll pull that over into my folder where I want it to go. Pull it over and then I'll rename it so I can put the number at number six right click rename. Don't delete the name. Just add the six in front of it. Okay. And then we can do it one more time closing this out. I'm going to go back and with number seven. So how easy it could be to go at the end of the munch and just bundle this together. Print them out and boom. Save as a PDF. Look at that. It's a beautiful system. And now we could just do that nice and easy. And hopefully there we go. And so then I'm going to right click on this one. And this is going to be number seven. Number seven. See and then once we have all these in a folder, we've got our balance sheet reports. We've got our income statement reports. We could provide this to a client now either emailing it. But now we've got seven attachments, which is getting quite long. So we don't want just seven attachments on an email. We could zip the file. I could go back to the file here. I'm going to delete the prior zip file. Right click on the file and compress it. Compress or zip it. And there it is. So that could be attached to an email. Now if I go into this, we can also provide this on a cloud drive, like a one drive or something like that or a Google drive. And they're numbered so that they can have some idea of what order they might want to open up the reports in. Now our other options are to export these to Excel and then possibly use Excel to further to put all of them in one report. We'll talk about how to do that next time with the help of the PDF printer. Our other option I'm going to go back is to use this neat management report tool, which gives us that nice quick management report. I won't go into it in detail here because we saw it in the balance sheet side of things. But once you have your reports set up, I might take my company overview. I might want to copy it so I always have the original format there. So I'm going to copy it over and then I'm going to edit it. I'm going to edit it. And so you've got your title page. You can add your logo. You can call it management report or something else. You can change the title page to something other than that one. You have a subtitle. So you've got a nice little intro. You can put your name here. Then on the second page, we can include a table of contents, which typically we would want to do. And that's just going to be our reports mainly in the table of context thus far. You've got your intro page might be the intro. This and then you can give your blurb. Here's the month in report month and reports, blah, blah, blah below. You can add your detail there, which is nice. And then we could go to the actual reports. Now by default, they pull in a profit and loss report. Now we looked at the balance sheet reports last time. So I don't want the default profit and loss. I want the ones that I've just customized. So I'm going to say remove this one, add the ones that we put in there. We put in there the summary income statement. So I've got a summary income statement and then add. I had the, the number six report and then I'm going to add another one. And then I've gotten my number seven. So now I can put those in there. Now I need to change the name so it doesn't show up with this title. So I'm going to edit this one. And then what I want in there is just, is just summary income statement. I think that'll work. Let's save it. And on this one, I'm going to edit this one. I don't want the number in there on the title. Do not want the number on the title. And then this one do not want the number on the title. And, and then the next page we have is an end note. So we can say in conclusion and, and we can say thank you or our conclusion page. So it's a nice little neat report. We can save it. We can check it out. Let's print it to check it out. And here's what it looks like. So now you can get all this stuff on one page. You get a title page and you get your table of contents and you get another intro page. We can give you a little blurb about the reports that you're going to have down below. And then you've got your balance sheet, which, which we did last in prior section. So that's not a custom one. That's just the standard balance sheet and then your income statement. So now you got your summary income statement, but it's custom now. And they've got this formatting that fits in here. We got the income statement by quarter. So, and then we included our comparative income statement and then our conclusion page. So it's a nice little report. You know, you've got, you've got a decent amount of flexibility to get everything on one page and add a nice little title page. So we've got that option next time we'll export them to Excel and we'll use Excel to create a PDF with all of them on one report. And note that if you, if you get really fancy, then you would probably be exporting them to Excel and possibly using Excel and Word to kind of integrate so that you can get a more complex and varied level of reports. So, so then you can do more customization and whatnot within your, your reports that way. And you can change things in Excel if you want different formatting in Excel. For example, although it gets a little bit more tedious to do because there are more, you know, you'd have to do that change every time as opposed to just kind of generating the automatic reports from QuickBooks. So we'll take a look at exporting to Excel and creating a PDF with all the reports in one place that time and possibly adding some formatting within Excel. Closing this out. Notice that if I hit the, the cog dropdown and switch this to the business view, we've really only been working in the reports once again. So that's located over here in the business overview area and then in the reports.