QuickBooks Online 2020 to print, email and create a PDF of reports Get ready because it’s go time with QuickBooks Online 2022. Online in our browser search for QuickBooks Online test drive going into the test drive, we’re going to be looking at the United States version of it and verifying that we’re not a robot. sample company Craig’s design and landscaping holding ctrl scrolling up just a bit to get to that one to 5%, we’re also going to have the free 30 day trial version open just so we can look at the business view and compare it to the accounting view.
00:37
If you don’t have access to this at this time, that’s okay, we’ll use it more in the second half of the course, going back on over to the sample company, we’re now going to be generating reports and thinking about how we might save and print those reports, possibly giving them to a supervisor or our general theory, or general practice problem and mindset being that we’re an accountant.
00:37
And we’re going to be given these reports, then to our clients at the end of the month and or end of the year. Go into the tab up top right clicking on it, we’re going to be duplicating the tab up top, let’s do it again, put our cursor on the first tab, right clicking on it and duplicating it. Again, as this item thinks I’m going to jump over to the free 30 day test trial, just so we can look at where the Report Center is in the business view, which is under the business overview items.
01:30
And in the reports. If you went to the accounting view, which is in the Cogut drop down and go into the accounting view, you would have a similar view to what we will look at here in the sample file. Going back to the sample file, we’re on the second tab, we’re going to scroll down and open up a couple of reports once again, go into the Report tab down below. Closing the hamburger we’ve been focusing in on the balance sheets type reports, I’m going to start out with the summary balance sheet though.
01:59
Summary balance sheet or balance sheet summary as it’s called here, changing the date range from a 101 to one to 1230 121. Let’s run it and then go to the tab to the right, open up a standard balance sheet by going to the reports on down below. And this time, I’m going to open up just a standard balance sheet, just the standard balance sheet, close up the hamburger scroll up top reigns change it from Oh 101 to one to 1231 to one run it.
02:29
Now we’re thinking about getting these reports say to a client at the end of the month and prior presentations, we talked about the concept of formatting these reports for internal and external use, which you might have different needs for them customizing the reports, which you can then find by going I’m going to go to the first tab to the reports areas.
02:50
And then you can go to the customized area. And then your reports would be listed here. We don’t have them here because I’m logging back in every time with a new presentation. And then we talked about how we can take those reports and group them to give them to the customer or to management. One way we could do that was with the management reports, which we talked about last time,
03:12
which is a great tool, but it’s still somewhat restricted, and that you can’t change some things related to it. So there might could be some restrictions to it, you might want some more freedom to do some other formats to give it to someone which might be easier faster. And or you can do more things with regards to the reports. Your other options would then be to go into your reports and simply email the reports if I go into the report itself, I can email this way.
03:39
And I can email report by report. However, if you have a lot of reports as you possibly could have at the end of the month, or here, that becomes awfully tedious and you’re going to annoy the person that you’re giving the reports to. So although that’s one way to do it, it’s probably not the most professional way to do it. You can also print the reports.
04:00
And then, and then give them formally just as a printed report. But you can also then save them as a PDF file. And then you can zip the file of a PDF file so that when you email them, they’re going to be at least in one zipped file, or you could put them on a cloud drive, which possibly could be a more secure way of transmitting the files, put them on a one drive type of file, or on any kind of Amazon storage or whatever cloud storage file. The other method you could do is export it to Excel.
04:32
And the reason this is a really nice method is because when you export it to Excel, you can also use Excel as well as a PDF printer, which we’ll take take a look at which we’re going to use a cute PDF printer which is a free printer to then make one PDF file with all the reports on it similar to that management report.
04:51
But giving you them the flexibility of formatting in Excel and basically then and then putting all of them into one into one report. So it might look a little less formal with the wording and so on, that the management report would have. But you can get all the reports in one place, and you got a little bit more Format Control in that method. And obviously, if you want to step it up a bit from there for more format, formal and control, you can tie together,
05:19
Microsoft Office, and word and so on. So what we’re going to do now is we’re going to focus in on on saving these items as a PDF, and then zipping the files to provide to a client. So what we want to do is find a destination folder first. So I’m going to say, here’s my destination folder, I’m just going to put them into a QuickBooks Online folder, you obviously might have your folder set up by client.
05:42
So you might have this as my client folders. And then within the client folders, you might have your clients and then within that particular folder, you might then Sort your information by year maybe, or simply by date that you’re going to basically source your information by, and then record your information into that folder.
06:02
So I’m going to I’m going to go back over this is where I’m going to put my stuff. And I can then export it a couple different ways, I can actually use the printer and a cute PDF printer to make a PDF. Or I can of course, hit the drop down and make a PDF. This way, I think it’s useful to know how to use a PDF printer. Because if you don’t have a printing option in this program, or any option, you can use the printing option to make a PDF.
06:31
So there is a free PDF, I don’t have any association with them. But if you go to cute PD PDF, printer PDF printer, you could have access to that’s one thing you might look into with regards to a PDF printer. So this is the Adobe PDF printer. Here’s the cute PDF printer. And so this is one option, you can look into other options, any kind of PDF printer that basically will take something that you’re going to use the printing capacity to make a PDF out of could be a useful tool in the future.
07:08
So keep that over here. I’m going to go back on over. So let’s let’s then print out some of these reports. Let’s do it a couple different ways. Let’s do it the first way, which is just to basically export it as a PDF. I’ll get into the excel in a future presentation. So now we’re just going to make PDFs of them export as a PDF. And so there we have it. So that looks looks good. We have some limiting kind of formatting options here.
07:33
So we don’t have a whole lot of formatting options, which is again, another reason if you have a very extensive reports, exporting to Excel can be a useful tool. But we’re going to go ahead and save as a PDF from here, saving it as a PDF. And then I can open the file and show the folder I’m going to show the folder.
07:55
So there is where it is being downloaded, I’m going to cut and paste it, let’s go ahead and cut that one, cut it, cut it out and paste it right here, I’m gonna make the view a little bit larger. And so then I can open that one up. if I so choose. At this point, we’re going to open it up with the PDF. So let’s open it up with edge. PDF file. And so there there we have it, I’m going to close that back out, close that back out, I can also open it with Adobe don’t have Adobe Reader, open it up with Adobe Reader, so you don’t have to be online to open it. So there it is with Adobe Reader as well.
08:44
Closing that back out. And let’s go back in to our next report. So I’m going to say that was the balance sheet, let’s go into that was the summary balance sheet. Let’s go into our balance sheet. Now we’re only looking at a few a few reports, the balance sheet, the summary balance sheet.
09:01
Also note, I probably should have gone go on here and done some customization for it as we’ve seen in the past, which would be like customizing it, I’m going to say I want brackets around it for external use removing the pennies, possibly, and then down at the bottom, get rid of the footer maybe and then save that report. And then I might customize it so that I don’t have to do that again later. And add a new group and call this our month end reports.
09:35
And then add that and then save it so that I can then in future. At the end of the next month. For example, I can then just go into the first tab, we can go into the reports. And in the Customize area. We’ve got our custom reports here that I can pull up and not have to format again. If I then go to the standard balance sheet. I could do the same thing I could customize the report I’m going to say I won’t want the without cents here, brackets and then read.
10:06
And then I’m going to put on the footer, that I would like the no date time report basis. And okay, I could customize that, I can save the customization of that report, putting it into our month end reports. So I don’t have to do that again. And then I can basically print it. So now I’m going to print it again, I can export it, let’s use the PDF printer this time just to practice it. Here’s your printing options.
10:34
So the Orientation PORTRAIT versus landscape. And so portrait works well for the standard reports. Obviously, if it was too wide, you could try going to landscape, smart page breaks. So we’re using the smart page breaks and the repeat the page header. So on the second page, if it was having two pages,
10:53
the header would stay there. Again, notice you’ve got some fairly limited kind of options with regards to your formatting here. It’s interesting that they do give you some kind of kind of text options, adding text and add in. So this would be like format, or like adjusting a PDF kind of options that you would have here, which is kind of interesting. It’s not very formal looking.
11:17
But it’s kind of it’s kind of interesting that those can be useful for like internal type of reports that you want it to basically mark up in that format. But in any case, let’s go ahead and this time, I’m going to print it instead of saving as a PDF. Note that these two formats that we looked at exporting as a PDF and basically printing it take you to in essence the same place.
11:37
But instead of saving as a PDF or emailing now I’m going to print it and use the cute PDF printer to actually print the file. So here it is printed out as a notice it prints basically as a PDF. I’m going to hit the printer up top here. And then the printer I want to use then is see if I could find the cute PDF printer, which is where is it? I don’t have it here, hold on a second.
12:04
Okay, I’ve added it now. So we got the CutePDF printer, just to show you that you could use you could use this option in this program and other programs, when you don’t have the capacity to save it as a PDF. We’ll use it when we get to the Excel items as well. So there we have this, and you’ve got your printing options.
12:20
So let’s print it in that format. And then it’s going to give me a little saving button. So there it goes. And then I’m going to have to name it here, I’m just going to call it balance sheet. And I should probably be putting the name and then I mean the date, but I’ll just keep it at that. So I’ll save it. And so that’s another kind of tool that we can be using. So I’m going to say yes, here, I don’t know what it’s talking about. Okay, so now we’ve got those two items here. Let’s do one more.
12:51
And obviously, you can imagine that if we have the income statement and other reports, we can have a whole lot of reports that we would be dealing with. Let’s do our next one, which is a little bit more fancy one, we’re going to say we’re going to make this as of 1231. To one, let’s make this 1201 to one, and then I’m going to do my comparative report, which the drop down previous period, last month, Dollar change, percent change, run it.
13:17
And then I’ll change the name here and make this a comparative comparative Balance Sheet. And I’ll copy that, we’re just going to copy that. And then I’m going to customize it going to get rid of the Get rid of the report period, this thing right there. As we’ve seen in the past, I know I’m doing this fast, but we’ve got that item.
13:41
And then I can memorize this, I can save the customization, again, saving the customization, this time calling it a comparative Balance sheet to the month end reports so that we have them in the future.
13:53
So if I go to my first tab, and I refreshed the month end reports, maybe I could do it by clicking off and then back on the reports. Now we’ve got our three reports in there that are memorized or saved. And then we can then let’s go ahead and print this again, as a PDF was exported. This time, we don’t need to use the CutePDF printer, save it as a P D, F, and then open it.
14:22
And then I’m going to save it this time. Save it doing it the right way this time desktop and then this is going into the the folder What is all this stuff I have on my desktop navigation comparative Balance Sheet. Let’s save it right there. Boom. And so now if I was to give this to somebody now I’ve got these three reports which I could I could give them three emails or I might want to zip the reports.
14:54
Also I might want to order the report so I could put a little number before them I could say let’s put it like a one here and then, then actually, that should be a two. That’s like the second report number two, numero dos, and then this is going to be number one, the summary. And then the comparative, rename comparatives of that might be a little bit nicer. So they can at least see which ones you think they should be opening in order, maybe soon, because it’ll be an order by the number.
15:27
And then we can put them into another folder. And let’s say let’s put these into a folder and call them month and month, is that how do you spell and reports and let’s put them into that folder, just dragging them in there. And then let’s zip that folder, right clicking that folder and send it to a zipped folder. So now I could give it to someone in one folder in a zipped folder. So that’s going to be a little bit nicer, then even an attachment with three different attachments.
16:00
And if we had 10 attachments, it would be kind of a problem. And in that zipped folder, we have them kind of ordered, when they should open them. So that’s a little bit nicer. So now if we go back to our options, here, we’ve seen that we have the option of of making a management report, which is more formal looking,
16:20
but does have some restrictions, it might be a little bit more difficult to do, we can basically email the reports, we can print them or save them as a PDF, we can zip the folder of the PDF to provide them in one email or put them on a cloud drive, like a OneDrive, or, or any kind of Amazon cloud storage or something that we can share with a client. And next time, we’ll take a look at exporting that to excel.
16:47
And the reason we could do that is not generally so we can give the Excel file to somebody else but so that we can use the Excel file in conjunction with the cute PDF printer to make one PDF with all the reports on it. So it won’t look as formal as say, possibly this report method. But it does give something with all the reports on one document.
17:08
And then of course, if you wanted to get more formal, you could you can then use a combination of Excel and Word to try to make a formal kind of report and so on. But so we’ll talk more about the Excel and creating a PDF, all the files on one PDF using that method next time