 QuickBooks Online 2022 Save Customization or Memorize Report. Get ready because it's go time with QuickBooks Online 2022. Online in our browser searching for QuickBooks Online Test Drive, going into the Test Drive, selecting the United States version of it and verifying that we're not a robot. Sample Company, Craig's Design and Landscaping Services, holding Control, scrolling up just a bit to get to that one to five percent. We're also going to have the free 30-day trial version open just so we can look at the business view in comparison to the accounting view. If you don't have access to this yet, that's okay. We'll be using it more in the second half of the course. Going back on over to the sample file. We now want to look at the memorization of reports or the Save Customization feature. So to do that, let's open up a couple reports. We're going to duplicate some tabs up top, right-click it on the tab up top, duplicating it. I'm going to go to the tab to the left and duplicate the duplication. Right-clicking again, duplicate again. As those are thinking, I'm going to jump back over to the free 30-day trial version just so we can see where the reports are located in the business view, which is over here in the business overview. And then in the reports, if we were to go to the accounting view, which you could do here by going to the cog and then go to the accounting view, you would have a layout similar to what we're going to look at in the sample file. Back to the sample file. We're then in the second tab. We're going to go to the reports on down below. And then we're going to be looking at our balance sheet report. Let's open up the good old balance sheet report. And then let's do a range change up top from 010121212313121 and run it. Run nine, close in the hamburger tab to the right. Let's go on down to the reports again and open up our favorite other second favorite report, profit and loss to good old P to the L income statement, otherwise known as range change from 0101212123121. Run it, close the hamburger, and we're going to go back to the first tab. Now, we've made some changes to the balance sheet in the past. And you might say, well, do I have to make those changes every time, especially if I make a comparative type of report? Or can I save those? And we've mentioned a few times that we can save the customization. If you're used to the desktop version, it would be called basically memorizing the report, which I think is kind of actually easier to say instead of saving customization, you're going to memorize the report. But we're going to save the customization here, very descriptive term. So let's do a quick customization here. I'm going to say customize the report. And let's just say that we're doing our standard customization possibly for like external purposes or external readings of it. And we're going to say let's let's do let's take out the pennies. Let's show the negative numbers with brackets. Let's put some red red on it as well on the footer. Let's get rid of the get rid of the company name. No in the footer. I want the name, the date, the time and the report basis just for some standard customization. Run that report running it. So now it's a little bit cleaner to look at. We don't have the footer at the bottom. Now, if this is what we want to do every time, then we can we can save the customization. So I could go up top and say let's save the customization and let's call it a balance sheet. And then we might say balance sheet that is for like external use or something like that. And then I'm going to add a group to it. Now, when you add the groups, you got to be careful, first of all, to make sure that you've added it in this section. And then second, you got to think about what kind of groups do I want to be having if you have multiple users of the QuickBooks file, you might simply save the group by your your name and then determine whether or not you want to share the reports that you have with other users or these going to be reports that are specific to you for your particular things that you are working in on. And the other way you might want to think about saving reports are basically internal reports, reports that you want customized for internal use versus external reports, those that you're going to give to supervisors and or clients. And you might then want to think about the external reports in terms of, for example, are these going to be month in type of reports? Are these going to be a year and type of reports and so on. So let's first start off with just a simple put our name here. I'm going to say add a group, we're going to add a group and say I'll just put my name Robert Robert, and then I'll save it. I'll add that group. That's my formal name. And we're going to say you can call me Bob those Robert in any case, we're going to save that. So now we got the name of here, we're going to pick that one. And then we're just going to save this down below and it should save the customization. And then we're going to go to the tab on the left hand side. And we can go down to the reports then and note that you might have to refresh the screen to make sure it pulls over because we're in a separate tab. But now we're going to go to the custom reports tab on the right. And so now I'm going to close the hamburger and there it is. There's our little dropdown for our category and our report and we can open it from here. So in the future, I can simply go here, instead of going to the standard tab to open the reports that are already customized for us in the way that we want to see them. So also notes and the next thing we might want to say, okay, maybe I should add some groups here that are basically going to be customized and let's think about it customized as if we're going to give external reports to outside users versus basically internal reports that are going to be for internal use. So for example, I might go to this this same balance sheet and I might say, okay, well maybe maybe for internal use, I like I want to have the pennies, for example. So maybe I customize the report and say for internal use, I'm going to I'm going to have the sense in there. And that's the only different difference maybe for this report. And then I'll save this for my internal use. So I'm going to save customization balance sheet for internal, internal use, internal use, which I might put under my name, or I might say let's add a group. That's for for internal internal use, internal use, or something like that. And I'm going to add it. And these are going to be basically the reports that I'm going to open as I check my my data entry when I enter items into the system I'll save that. So now the save customization if I go to the tab to the right I have to refresh it in order to see what's going on I can hit the little circle refresh circle up top. And that should do what we want it to do it could take a little bit of time. So there we have it now we've got the internal use balance sheet report. So we got a different kind of categorization. And then I might put the other the other report without the pennies in it back into into the external use report or maybe like a month and type of report so I might basically customize this, or let's customize it again and remove the pennies. And then I'm going to put this into the to into the month end reports let's call it month end reports, and year end reports imagining we're going to give these to clients here. Now also realize that if I go back to the first tab, we also have this neat tool on the right, which, which is a managed report. So this is one way that you could use this tool to make a kind of a more formal presentation that you would provide if you're like doing accounting or bookkeeping to management at the end of the month. And but to pull the information into this report you could still pull that in from your custom reports so you might want to custom the report, and then give it in this format or possibly you can create your own, you know, zipped files of the reports you want to give, or possibly make your PDF file that you could put up and we'll do that with Excel. So a couple different usages there. Let's just test this out first let's not get ahead of ourselves here. So we're going to say save customization. And then I'm going to say this is the balance sheet for external use again. I'll say external use. And then I'm going to make a couple groups here I'm going to add a group down below. And I'm going to say these are month and reports month and reports at it. And so we'll save we'll save that and then I'm going to add add another group, which is going to be year and reports. So I'm going to add it I'm going to change the name slightly so it'll basically if you don't change the name it might actually just move the report instead of adding a new one so I'm going to say month and report and just me at the end, which stands for month and not me, and then month and report, and we'll just add that to the group here so I'm going to save that into the month and reports and if I go back up let's do another one. Customization again, and I also want to put it into I'm going to change the name a year and report and put it into the year and report because both the month and and the year and will have this standard format of the balance sheet is what I'm imagining here we're going to go back to the prior tab, and then refresh it refresh. And so now if I scroll down you can see in the month and we've got this report and in the, and then we have this other one in the year end. So that we could start to kind of group our reports so that at the end of the year we could just basically pull these reports directly into our our financial statements and we might even try basically numbering these reports so that so that when we add them into our system, they'll be kind of in order because I think they're going to be an alphabetical order here so you could try to say, I'm going to make this number one, the balance sheet reports so that when people try to construct the financial statements, they can just take the custom reports and put them in place in order check the report period. Okay, so number one on the month and reports right. And so then if I go back and I say okay let's take this same balance sheet let's just focus in on the month and reports and let's let's say that we want a comparative report of some sort of some sort. So let's say we did this as of a year by year comparison. Let's just do the end of the month comparison. So let's make this 123121. No, let's make it 120121 to 123121. And then I'm going to hit the drop down here on here. And let's say we want the previous period, which is the month of November, the dollar change and the percent change. And then I'm going to run that report. So there is that I'm going to do some customizations. This is going to be a comparative balance sheet comparative balance sheet, something like that. And I'll save the name there so that I can copy that into my memorized reports. I don't want this date down below so I'm going to customize up top and say in the header in the headers and footer section, we want to get rid of the report period run it. So there we have it. So I might say okay I'm going to save this every every month and I'm going to try to compare it to the prior month and I'm going to run this report every time so I'm going to say let's let's save the customization. And I'm going to put this one into the month end reports. And so there we have that and save it there and I'll put let's make this one like the second report number two report that we have and I'm going to say let's actually make this the number three report and then save it and then go back on over to the first tab and refresh. So now we've got our month end and then this one down here let's make the this one actually the second one and then we'll also do a summary balance sheet so I'm going to edit this one. And let's put a number two on this one. Numero dose, dosy dose, and then okay. So there we go and now let's make like a summary balance sheet let's go to this last tab and hit the plus button, and then we could go down to our reports. And let's say that we want a standard report and a summary so we'll just pick up the summary balance sheet. Where's that one balance sheet summary, and then close up the hamburger range change from 010121 to 123121. And then let's run it running and so then we got this short balance sheet just easier to read one let's put that one up top on our report, because it's probably the easiest one to see so I'm going to customize it. Get rid of the pennies to our standard we're going to say get rid of the pennies brackets, make it read and I don't want anything on the foot. Clean foot please clean off the foot. And so there we go, run it. Okay, and then let's save the customization summary. And I'm going to put this into the month end reports. And I'll call this number one report, number one report, and then let's save that. And let's go back to the first tab again. And if I refresh it let's refresh it up. Ah, all right back to the custom reports and scrolling down so now we've got these three reports down here with regards to the to the memorized reports. And so now whenever I do with regards to giving these reports to say a client at the end of the month, I could just go through these reports and basically print them out in the order that's here, and hopefully make that process as easy as possible without having to do the customization, or think about the order too much that I need to put them in. And I might give them to someone by just emailing them, I might zip them, I might then export them to Excel try to make one PDF file which we'll talk about later, or I might then put them into this managed report report, which is another kind of formal way that we can draw those reports into that report as well. So we'll talk about some of those strategies in the future. But whatever strategies you use, you first got to think about which reports you want to be giving to the customer and my thought would be, do the easier summary reports and then expand on those reports for the more complex reports in in the future. And also note that you could we could go on just with the balance sheet reports for a long period of time at the month in reports I might have, you know, a month by month report comparison, we could have comparing the current month to the prior month, we could be comparing the current year to date to the prior year to date. We could be doing a vertical analysis report. So you got to just you could we could go on for quite some time with just balance sheet reports, not even getting into the other statement which we'll talk about later the income statement reports, in terms of what we might provide to a client at the end of the month, or the end of the year and we want to do it in such a way that they're not overwhelmed, but they feel like we're doing you know we're doing our work here and we're giving them a lot of good information. So we'll talk more next time about using this and we'll format them into the managed reports on this side and we'll also talk about how we can export and print these reports to provide them to clients and or supervisor.