QuickBooks Online 2022 reports month to save as PDF and export to Excel. 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 ctrl scroll up just a bit to get to the one to 5% currently in the homepage, otherwise known as the get things done pick things to the accounting view,
00:31
it’s something you can do by going to the cog up top and the switch to the 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,
00:45
going back over we’re going to be open up a few tabs that we can put reports in, well, let’s just start off by opening up one tab that we’ll be putting reports in right clicking on the tab up top, duplicating that tab.
01:00
And when you’re opening up reports, if you were in the accounting view, let’s jump back on over here, it would be under the Reports area on the left hand side back on over to the Business View where it is located in the business overview and then into the reports.
01:16
Now last time, we opened up basically all the reports and thought about the types of reports we can save that we might want to save them in some format for presentational purposes, at the end of the month at the end of the quarter at the end of the year. In our case, after the two months of data input that we have put in place.
01:36
Now we’re going to just open up those reports and basically save them as a PDF and think about how we might want to present them. Notice that if you’re doing bookkeeping,
01:44
especially for clients externally, this is really important, not just the numbers that are involved in it, but the formatting that you’re providing to the client, because you want them to be confident that you’re, you know, doing the bookkeeping in a proper way. And part of that is simply presentation.
01:59
So we’re going to close this back out. And this is what we have to we’re imagining now that we have basically set this up. And now in future years or future periods, we can simply go into these reports, change the date, and then save them as we want to save them.
02:13
So that’s what we’ll do. Now note that we listed, we numbered them to try to make it as easy as possible. So we can order them in this fashion. That will make it easy for us to order them if we’re going to give them in the format of a PDF file.
02:25
So there’ll be an order in one folder, possibly. And if we were going to present them in other fashions or group them in other ways as well. The few ways that you might think about grouping these reports is one, you can email them individually,
02:38
which is not what I would recommend, because that will be way too many emails, and not you know, as professional looking, you can attach all these onto one email. But now you got nine attachments. So I don’t think that’s as professional as you can be as well,
02:51
because you’ve now got nine attachments that they would have to download at one time, you can zip all of them into one folder, which I think is a better way to go if you’re going to be emailing them out. Or you can try to put them in one PDF file, possibly with the use of Excel and a PDF printer, which we will practice doing.
03:10
Or you can use the Manage reports tool on the right hand side and then modify one of these reports, including the reports in it, which is another way you can get everything on one page with a little bit different formatting, which might be a formatting that you prefer and might look professional in that way as well.
03:28
I’m not going to get into the Manage reports item here. We’ve talked about that in the past. If that. So look into that that’s a tool that you can use, we won’t be doing that here. Instead, we’ll be exporting them as a PDF, we’ll be zipping the file, we’ll export them to excel as well.
03:44
And make one PDF with the use of Excel and a cute PDF printer saving all that information into our folder here for the second month. So that’s what we’ll be doing. Let’s get to it. So we’re going to open up the balance sheet.
03:59
This is our summary balance sheet, the least intimidating balance sheet we have, I’m going to save that one. And I’m just going to first export it to Excel. And I’m going to open it I’m sorry, I’m going to first export it to a PDF file. And then we’ll look at the Excel formatting of it. Opening up the PDF.
04:16
I’m going to save it as a PDF, and I’m in Chrome. So it’s going to open up this item down below in Chrome as the browser, I’m then just going to drag it and drop it into my folder here, just grabbing it, dragging it and dropping it where we want it to go.
04:35
I’m going to try to do all of these until in terms of a PDF and then we’ll go back in and export them as an Excel file and then use the Excel file to make one PDF. So that’s what we got so far. I’m going to close this out. I’m going to right click on the tab up top duplicate fat tab and repeat the process this time for the second report.
04:57
So we’re going to go to the reports on the left 10 side business overview reports on Report Number two, the comparative Balance Sheet. Now note, as you group this stuff, you might say, Well, I would rather have like my income statement, after the simple income statement after the simple balance sheet, you might prefer that order.
05:16
I’m not saying this is the best or only order, you might put it in. So again, put some thought into it and think about what you how you want these reports to be shown, and what order they should be in for your clients.
05:28
So that then when they have questions, you can basically try to get to those questions as easily as possible. So I’m going to say this is gonna hit the drop down, let’s export this to a PDF, save it as a PDF, opening up our folder, dragging and dropping it.
05:44
So I’m just going to say grab that thing, grab it left, click, hold it down with the left finger, don’t let it go. Don’t let it fall till it’s in the folder and drop it ah, falls into the folder, I’m going to right click on it again, let’s duplicate it again, for report numero trace.
06:03
Number three, as it’s, as it’s called, reports on the left hand side, we’re going to then go into the hamburger closes it up, open it up report number three vertical analysis on the income statement. So I’ll set up for us the dates are already set. So we can just export it, look how easy it is, now that it’s all set up, just export it,
06:28
and then save it as a PDF. We’re going to drag that on over and drop it into our folder. And then I’m going to close this out and make another one right click and duplicate again. So we can do the process another time, go into the reports on the left hand side, closing up the ham book, ERP.
06:51
And then we’re going into the third report now are the fourth report aren’t where it’s the fourth report, the income statement, I’ve got four tabs up top right fourth report. And there it is, it’s set up. This is the income statement summary where it’s collapsed.
07:07
So that simplest format of the income statement, let’s go ahead and export that to a P D F, saving it, grabbing it, dragging it over dropping it and close this out and open up another tab, right click and duplicate another tab. So we can do it again with the fourth the fifth report in our list of reports by going to the reports on the left hand side, closing up the handbook.
07:37
And the fifth report we had was an income statement. So I’m going to open up the the income statement for the fifth report standard. It’s like comparative income statement. So I Oh by month,
07:49
okay, and then let’s export that one, as a P D F saving it, grabbing it, dragging it over to our report, I’m going to close this back out, right click up top, open another tab. So I can grab the sixth report, I believe we’re on which is the comparative income statement.
08:10
Now it’s taking the difference between the two months, and go back up top and then I’m going to say I want to export this one to P D F, pour five or PDF, pour five or grabbing it and then dragging it and then dropping it.
08:25
Closing that back out right clicking up top and duplicating again. Now we’re looking for number seven. Number seven, report, opening it up. This is the vertical analysis report. Let’s go ahead and export that to a P D F, saving it as a PDF poor file for grabbing it, dragging it,
08:49
dropping it and closing it and then right clicking up top and duplicating a couple more times reports on the left hand side we’re now going to the to the trial balance. Let’s open that one up the trusty T B, let’s go ahead and hit the drop down, export to the p d f save it as a PDF, grab it left clicking it grabbing it with my left click finger and dragging it to the drop in.
09:18
And then right click one more time. I think this is the last one duplicating again, go into the reports on the left hand side, closing the hand Boogie going down to the transaction list by date this time and then we’re going to export that one to a p d f I’m going to hold Ctrl scroll down a bit so I can see my exporting thing up top and then export to the p d f save it as a P D F,
09:46
click on it, drag it and drop it to where you want it to go. This is what we have thus far. Now note that’s a lot of stuff for one attachment to an email. So you might take that and say I’m going to zip it to the report
10:00
Reports, month two, which you probably would say, February, month two, I’m gonna say for practice problems, and then grab all that, drag it in, and then possibly do that do the zipping thing, right clicking and zipping it, send it to a zipped file. That’s one way we can do it.
10:23
And then we can attach the zip file. But we also might want one PDF with all the reports in it in order. So let’s try doing that with the exporting and CutePDF features back to the first tab. So now what I’m going to do is I’m going to, I’m going to export it as an Excel file, and try to put all of this stuff on one Excel worksheet.
10:43
So I’m going to take that first one, and I’m going to drag it and drop it because that’s where all the reports are going to go, eventually dragging it and dropping it. So here it is. And then I’m going to open that one up. And I’m going to rename it to my reports my total reports, item.
11:01
So hold on, let’s not open it up. First, let’s let’s, let’s rename it before we open it by right clicking on it, right clicking on it, and then rename it. And I’m just going to call this reports, reports for month two. And this is where I’ll put all the reports, open it up.
11:22
Now this time opening it, there we have it first tab is going to be the balance sheet. So now let’s go let’s go back on over and just open the rest of them up.
11:31
So now I’m going to go back on over and it’s going to go tab to tab, tab to tab drop down, open up Excel, you need Excel to do this, by the way, if you don’t have Excel, then of course,
11:41
it won’t open in Excel because Excel is necessary to to open it. Then I’m just going to grab this, once it’s open, I’m going to put my cursor on the triangle up top, right click on the selected area and copy the selected area.
11:55
And I’m going to put that over on my other Excel worksheet where I want it to be, I’m going to hit the plus button. And I’m just going to call this report number two, for simplicity purposes, put it in a one, right click and paste it. Now we could go into formatting, I’m not going to get into a lot of formatting here to make it look a little nicer.
12:15
What I want to do however, for the minimal formatting is make sure it fits on one page wide. I’ll do that by clicking the Layout tab to see if it fits on one page wide. This one does not. So I’m going to go back on over there’s the split right there.
12:29
So I could just make this a little bit smaller, it should basically fit on one page. So let’s keep it at that looks good. I’ll save it thus far. Go back into my reports. That was the number two report I think let’s call this just number three report.
12:47
I’m going to export this one to excel hit the drop down, export it to Excel, simply open it up, then I’m just going to grab it by putting my cursor on the triangle, right click and copy the whole thing, and then go back on over to my first worksheet.
13:05
And I’m going to hit another tab, which is I’m just going to call tab three now and put my cursor up in a one or select the whole worksheet and Ctrl V or right click and paste, see that it fits on one page by going through the page layout on the left hand side on the right hand side on the bottom.
13:22
It doesn’t for some reason, they’re making this column really wide. So we’ll shorten it up there. It fits on a page. Looks good, looks good.
13:31
So that’ll be good. And then we’re going to go back on over and do it again. So we’ll go back on over next tab to the right, going to export this one, hit the drop down, export it to Excel, simply open it up in Excel.
13:47
So there we have it going to grab it by putting my cursor on the triangle, right click and copy and then go back on over to the first tab, hit the plus button, this is going to be number four,
14:00
put that in a one and Ctrl V or paste it that one should fit on one page wide, I’m not even going to check it because that’s totally fits on a page. Let’s go back on over to the next one. And we’re gonna say let’s export this one to excel as well. Opening it up.
14:19
There it is. Let’s go ahead and copy that put my cursor on the triangle Ctrl C and then going back on over to that first tab again, making another one. This is going to be just some number five, I’ll call it and a one or the entire worksheet on the triangle Ctrl V paste in it. Let’s see if that fits on one page by going to the Page Layout and back on over looks like it does indeed. Let’s go back and say next one next. And we’ll export this one to excel. Open it up in Excel. And then we’re going to copy it putting our cursor on the triangle Ctrl C to copy it Going back to the first tab, making a new tab, double clicking on the name, this is number six. Putting that in a one, control the paste in it down does it fit on one page, let’s take a look at the page layout, check it out, it does. Let’s go back and do it again. So now we’re going to say we’re on the next tab to the right. And we will export this one to excel, exporting another one to Excel.
15:28
So there it is, let’s go ahead and copy it, put my cursor on the triangle Ctrl C, copy the entire thing. Back to the first worksheet, I’m going to call this number seven tab down below, paste it in a one on tab number seven. Going back on over, we’re almost there. Let’s go to the tab to the right. And let’s go ahead and export the trial balance to excel.
15:54
The trustee ti B. So there it is putting my cursor on the triangle Ctrl C, back down below, we’re going to go to the first tab lot of sheets open, I should close them up, but double clicking eight. Putting that in a one a one. There we go in.
16:13
So now we’re going to go one more time that we need to do this one more time tab to the right. And then transaction this one’s going to need some editing, I can tell right now already, just by glancing at it, it’s too wide. The thing is too wide.
16:32
What do you have against wide reports. I don’t like pasted them together when I’m trying to read them a copy of this one, I need to fix it, something must be done. Putting that one over here. This is Report Number nine, a one and pasting it. And so let’s check out if I go to the Page Layout tab and back on over way too wide.
16:53
Here’s our cut offs. So this one’s going to have to go to landscape, I would say let’s go to Page Layout tab up top and say this one needs to be landscaped, landscaped, the lawn needs to be mode, and then on and then I’m going to and I’m going to merge these cells so I can do stuff support.
17:14
So the Home tab, get rid of the merge, Jason, no merging, get you d merge, please. So I can do some editing, D merge. And then then we’re gonna move the headers over because that column A is not necessary. Is it? Like why did they even put that there, I don’t need that column. It’s stupid. So I’m going to right click on it and delete it, get rid of that column. And then this memo line that’s excessively long, let’s make that waist smaller.
18:07
So there we go. It fits. Now let’s center these again, but not by merging. but rather by selecting the items right clicking and saying I’m going to format the cells and center across center across a less well known but quite useful technique. Let’s do that here as well right click and format the cells and center it across.
18:33
One more time selecting these items, right clicking, formatting the cells and centering them across. So now I can make these turn this I’m going to save this so I don’t lose it.
18:47
And I’m going to try to use this to print one PDF file with all of our reports on it using the cute PDF printer, go to the File tab up top, looking at the print option, and I’m going to change this to the cute PDF printer. If you don’t have a PDF printer, you could do this one. I’m not sure I’m not sure if it’s cute or not really.
19:07
That’s what they call it. But it’s functional. I’ll tell you that it’s not just it’s not just because it’s cute that you’d want it. We’re going to say this is going to we want to get to the entire workbook here. It’s got 12 pages. Let’s see if everything fits on one page wide. There it is.
19:23
We could do some more formatting, of course, but that we’re just kind of given the given the example here. So everything looks like it’s it’s fitting well enough for the example problem. Let’s go ahead and print it out, which will actually save it as a PDF. So we’re going to print it out, which really saves it as a PDF.
19:47
So where is it it takes some time because that was a lot. That’s a lot to save. There it is. So now I’m just going to go ahead and save it right there. plop it down right there. And then I’m going to minimize all of these tabs to try to get to.
20:03
I should just delete all this. Okay, here it is. So now we can give this report to someone one at a time, we could zip it, we can give them the Excel file, but you usually don’t do that unless they want it in Excel for some reason.
20:15
And you can also give it to them in this PDF format, which can open up with a PDF reader or in a browsers such as this, where you got all the reports on one page, they’re kind of formatted a little bit differently formatted to the left the alignment is something you can kind of work on but it’s kind of nice that they get it in this one PDF file,
20:36
which can look kind of fancy and have less stuff that they need to open when you give them the email if they just want to, if they just want to check it out and see if you’re doing it what you’re doing.
20:46
And they have some confidence that stuff’s getting done over there, data’s being entered and so on. Notice that this last one is in landscape format. And you can see it on a PDF without without shifting or changing or rotating at a 90 degree, which is nice. So there there it is.