 QuickBooks Desktop 2023. Memorize reports. Let's do it within two. It's QuickBooks Desktop 2023. 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. Here we are in QuickBooks Desktop Sample Rock Castle construction practice file provided by QuickBooks going through the setup process. We do every time maximizing the homepage to the gray area of view dropdown, noting that we have the open windows list and hide icon bar checked off open windows on the left. Reports drop down company and financial P&L profit and loss income statement with the range change 01, 01, 2, 4, 2, 12, 31, 2, 4 and then we'll customize it and save fonts and numbers to change it to 12. Okay. Yes. Okay. And then we're going to go to the reports drop down again company and financial this time the balance sheet standard. We're going to this time hit the drop down to change it to the fiscal year and then customize it and go to the fonts and numbers change the font up to 12. Okay. Yes. And okay. That's what we have been doing every time. In the prior presentation we took a look at memorize reports categories which we will recap here helping us to sort our memorized reports. So for example, if this balance sheet as adjusted here because we adjusted the size of the fonts is something that we wanted to memorize. We could go to the memorized reports up top. We can change the name if we so choose within this category we can save it into a category and these are the categories that we set up last time which we will recap. We can also share this report template with others so if we have multiple users we might be able to share them with others or possibly if not using it just for our personal use as our personal reports. Closing this back out then we're going to go into the reports center reports drop down note first that you have the memorized reports here and a quick access bar which can be a useful thing to note. And then if I go into the report center also just realize here that you do have multiple categories that we will not see all of them at first in the report center because they don't have actual reports in them. The only one that does is this category down here. So if I go into the report center and then I'm going to maximize it because for some reason it unmaximizes every time we go in there then we go into the memorized tab. So you can see that these are the categories on the left. We only see one now because no other category has anything in it as of yet. But if I go to the edit memorized list we can see all the categories that we have set up. So to set up a category you can set these up fairly quickly. You could just go to the memorized report down below and say you want a new group and then add the group name that you would like. You can delete the categories quickly but first you have to delete the reports within the category and then you can delete the category itself. So we've set up the categories with the idea in mind that we're going to try to memorize our reports in such a way that at the end of the period at the end of the month and or year that we can then just go into the memorized reports and provide them to whoever we want to be providing to the client at the end of the period. That we want to make the process of printing those reports grouping those reports as easy as possible. Therefore we would like to set up the memorization of the reports already so we can make that process easy versus internal reports which may be we're going to memorize in a different format for our internal purposes and internal uses which might be different memorization. Okay so let's kind of think about just the balance sheet reports that we might put into this a month in reports. So as we do this we want to think about how to memorize and we also want to kind of recap the variety of just balance sheet reports that could be put together when we start to use these comparative reports for example to think about which reports we want to give to a client which can get overwhelming quite quickly. So let's go into the balance sheet here and start to think okay well first off we might want to make a report that's going to be easier for someone to read so maybe the first report that we might want to give to someone is a summary balance sheet. So let's actually open up a summary balance sheet I can go to the reports drop down and go to the company and financial and this time balance sheet but instead of the standard. Let's look at the summary balance sheets let's open that went up and you can see basically they they collapsed the categories which are which are the categories for for like cash type accounts accounts receivable type of accounts much smaller report easier to see and read. So let's do some customization let's do our standard customization to it. I'm going to go to customize report up top we'll go into the headers and footers so we got the company name that looks good the balance sheet summary balance sheet that's a good name. Good title so we're good there I'm going to remove the time the report basis and the print header. I'm going to put the footer maybe we want our name on the footer and then we're going to go to the fonts and numbers. And let's say that we want the parentheses read and we want no sense and maybe we want the size of the font to be 12 and I'm going to say OK yes and OK. So there we have the formatting I don't want that there let's get rid of that to header footer and we've got the date let's take the date off. OK so there we have it pretty nice easy to read report so we're going to say let's save that then I'm going to memorize it memorize the formatting putting it into here. I'm going to say this is going to be our month end reports and say OK and save that. So then if I was to hit the dropdown to see where that went we could find it in the reports memorized here under the month end reports. We can also go into the report center by going to the memorized reports in the report center see it here. If I close this out and then go into the reports dropdown and the report center and then memorize reports. I'm going to toggle off and then back on so it can refresh. We see the new category this way. There's the memorized reports. We can also get go back into the edit memorized reports if we so choose. I'm going to display it in a list format so there we have the summary balance sheet. We also might want to order these instead of alphabetical order. One way you could try to do that is to basically I name the report so you could say OK maybe if I could name it differently by going into the edit tab possibly and then the summary balance sheet. If I was going to right click and edit the memorized report maybe I'm going to put this in here as number one balance sheet reports. So now I've got a numbering system has changed you wish to save it. Yes. So now you've got the number one. So then we might go OK so next maybe I want a standard balance sheet reports so then I can go into the balance sheet and let's actually remove the summary. I'm going to close it. We might want just a standard balance sheet report for the full balance sheet which has a little bit more detail and data. Let's customize it with our normal formatting customize header and footer. We're going to say we want the balance sheet that looks good as a let's get rid of this this and this name and the footer fonts and numbers changing it to 12. That's OK. We've got that and then we're going to say parentheses around it and I'm going to say that no pennies and red. So there we go and I might save this one as another report that we're going to be providing at the end of the month so I could memorize this. This is going to be the balance sheet standard. Let's say it's going to go into the reports. I want to put it into the client month end reports. We'll put it right there and say OK. So if we go into the memorized reports now we've got this one. Let's put that at number two. I'm going to name it number two. So I'm going to say OK. Let's right click edit the memorized make that number two and save it. So there we have it. And if I close that out and I go into the report center again and then click on the standard and then memorize so it refreshes. I've got number one and number two report that I could then put together. If I go back to the balance sheet again and then we say well let's say we want a comparative type of report that we put together. I'll do this quickly because we've seen this in the past. I could customize the report and say maybe maybe I want a comparative report. So let's say we're going to say for the month of December. So we'll say 120124 to 1231 previous period change the dollar sign and percent. And then on the header and footer I'm going to call it a comparative comparative balance sheet. I'm going to say we have the save as of December. That looks good. I don't actually I don't want that because it's a comparative now with two periods and the footer is good. And I think this is good. So I'm going to say OK. So now we have a comparative balance sheet comparing two periods. So that's another report that we could run. So then I'm going to say let's memorize this. I'm going to make a new one because I've adjusted the report I was just looking at. And then I'm going to call it a comparative balance sheet. It's going to go into the month in reports and this is report number three. We're going to say report number three by going to the report center. Refresh it by going to standard and memorized. Now we've got three reports down below. We might do a different kind of comparative report. I might want a month by month comparison or if it's the end of the year maybe I want a quarter by quarter comparison. So I might say OK. Let's customize up top and let's bring this for the year 0 1 0 1 2 4. And let's say I'm not going to do the previous year but I want to see a quarter by quarter comparison possibly for the full year. And then OK. So now we've got each quarter comparative report. So then I can customize that so I could say this is going to be comparative for balance sheet quarter QT. Let's say just to make it different. And then we've got the report basis here. Let's keep that. So there it is quarter by quarter report. Maybe I will keep the name at that. I could make a better name than that. But let's save it just to practice memorizing memorizing new report. And I'm just making all these reports based on based on the original balance sheet. I'm going to say this is number four. I believe we're on. We're going to save that into our month end reports. OK. Check that out by going to the report center. Go to the standard and then memorized tabs. Now we have four reports. If I go back to the balance sheet we might want then the vertical analysis type of report. So for that let's go back to the customize. Let's make this for the fiscal year again fiscal year. And then I'm going to say this column percent of column header and verdict. I'm going to header and footer. I'm going to say this is the vertical analysis balance sheet. Let's say balance sheet. I might misspell this vertical analysis. Did I misspell that probably. Anyways if I misspell anything I apologize. So I could put the title here again. We can add that back in. I think everything else looks good. So wait a second quarters not quarters. We want this on this on the total. Now we could do a vertical analysis a comparative vertical analysis report and so on. So you can get into more detail there but we'll keep it here. So there we have it. And so let's memorize it and say new. And we're going to say this is going to be number five I believe we'll put that into our reports. OK. So then if I go back on over to the report center refresh standard memorized now we've got five reports here. You could do comparative reports to prior periods of course as well. So if I went back up to the balance sheet and then we did a comparison let's say customizing. Let's say we wanted to go from 12 the ending the last month even though it wasn't complete but 120124. And then I want to compare it to the prior year. You could say OK let's do that and do a percentage. Let's get rid of the percent this one and then this is going to be comparative balance sheet balance sheet. Compare to prior prior year type of report something like that. And then OK. So now we've got a balance sheet comparing December to December of the prior year something like that could be one report. So I'm going to memorize that we're going to say new. And I think we're on number six I believe OK. And then we'll say client month in reports OK. So there we have that and we could keep on going from from here I could say the quarter from this quarter to last quarter. I could say you know this six months to last month this year to last year. So notice we have a ton of different. We can also do the summary reports and do the same thing. Do I want to vertical analysis for the summary report as opposed to the to the full balance sheet report a comparative report for the summary report. So you can you can have a whole bunch of different reports that you can come to just with the balance sheet reports and obviously we could do a similar thing with the profit and loss or income statement which will do later. So whatever the kind of package that you want to put it together you want it to be readable look impressive but not overwhelming with all the different reports you can do then you might then try to customize that in your report center. I'm going to go back there by going to the reports dropdown and report center here standard and then memorize to see everything. So then you might and then when you want to create these to bundle them which will do in future presentations you could just simply open up the reports here one by one. We have them ordered by the name and hopefully then we can save them as a PDF and possibly email them in some kind of logical fashion. We'll work on zipping them or possibly trying to get them into one PDF file. So now that we have all the reports that we should be able to generate easily the next step in trying to give this information to a client in an organized fashion which is kind of half the battle for bookkeeping and accounting in general. Because they kind of it's the presentation is going to be important that gives them confidence that you know you're on top of things. So that's what we'll work on next time we'll take these reports and then put them into a how can we give this to someone impossibly putting it into a zip folder a cloud drive or giving like one file that we can zip it with with the use of Excel and cute PDF printer.