 QuickBooks Online 2022 Management Reports Customization 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 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 take a look at the business view and compare it to the accounting view If you don't have access to this at this time that's okay we're going to use it more in the second half of the course Going back to the sample file we're going to be opening up a few new tabs going to the tab up top right clicking on it Duplicating that tab back to the tab to the left right clicking on it duplicating the tab again And then I'm going to go on over as it is thinking to our 30 day test trial to look at the business view just to look at where the accounting section or the reports I should say section is located in the business view which is under the business overview and then into the reports Whereas if you were in the accounting view which you can get to by going to the cog drop down in the accounting view It will look similar to what we're looking at here in the sample file back to the sample file We're in the middle tab let's open up a few reports by going to the reports down on the left hand side This time I'm going to be opening up just the sample of the balance sheet which is the summary balance sheet first Which is in the business overview summary balance sheet and then I'm going to go to the tab to the right And open up the standard balance sheet we're going to be focusing in on these balance sheet reports that we've been working on in prior presentations Go to the reports down below and this time I want to take a look at the balance sheet standard which is just in the favorites And we can do some customization to it we're going to go up top and change the date range from 010121 to 123121 I'm going to do a little bit of customization as if we're going to use these reports for external use Giving these reports then to a potential customer possibly a client or management Customizing the reports doing our standard customization removing the pennies Making the negative numbers bracketed red on the negative numbers I'm going to go down to our header and footer Get rid of the footers for the date the time and the report basis and run it Then I'm going to go to the tab to the left do the same process that we've seen in prior presentations close the hamburger Range change up top from 010121 to 123121 run that report And then I'm going to go up top and customize it same customization removing the pennies And making the brackets for the negative numbers and read Then scrolling down to the footer and I'm going to get rid of the date the time and the report basis for our customization Let's go to the first tab and let's go down to our reports down below in the prior presentation We talked about customizing reports now obviously all those reports we customized last time are now gone I'm going to close the hamburger because I'm starting over each time as we go into the sample file So we could do a similar process and think about these external reports that we're going to be using And then use those reports to populate into the management reports Now notice they gave us kind of some stock management reports here These are pulling in some of the information from our reports and putting them into a kind of a more formal type of report So it looks like this if I was to view over here that the standard company overview would be kind of like the standard report You probably want to copy that report if you're going to do anything different to it and kind of keep the standard as the standard So if I was to view this report for example it looks like this So we've got our report looking kind of fancy Scroll let's go up through it going up management report Craig's design and so on For the title page we've got the date on down below for management use only the titles And then they add the standard profit and loss and balance sheet as the standard So that's the standard report now we could do some customization to this so let's close this out And let's say okay I'm going to hit the drop down on the right hand side and I'd like to make a copy of this report So that I can keep the standard report there and then this is going to be our report number one And let's we'll do some editing then to this report So that means that if I'm thinking if I'm a bookkeeper or if I work inside of a company and I'm going to organize reports for external use I'm going to imagine here that I'm a bookkeeper giving the information then to a client at the end of the month and or a year Then my options are if I go back to my reports to standardize all these reports I can email these reports to the client But that's not great because if I email them one at a time that doesn't look very professional and as we can see we can get a lot of reports that we might want to give at month end We can print the reports and or save them as a PDF file which is better We can zip the PDF file and give one PDF file with all the reports in it which isn't too bad that's kind of nice But it still has a lot of files that are kind of not really tied together it may be a little bit harder to order them We can export them to Excel and we can use Excel to create one PDF file from all the reports in Excel which we'll take a look at as well And that could give you another level of that might be a preferred way for some people and we can memorize the reports and possibly give them in this format Pulling them into this kind of formal report which could give it a more professional type of feel as well So let's do this for this is what we're going to work on this time I'm going to go to the tab to the right and I'm going to memorize these reports first or save the customization so I can see these reports that I'll be working on So I'm going to save the customization I'm going to make a new group and this is going to be this is I'm going to call this group month end reports So I'll pull this I'll pull the customization in from the month end reports I'm going to add them I'm going to call this number one because I want them to kind of be in order so I'm going to say number one you know the balance sheet summary report And I'll save that so we'll save it and that should be customized if I go to the tab to the right I'm also going to save this one And I'm going to say let's save the customization on this one and then I'm going to I'm trying to customize it again I don't want to I want to save the customization balance sheet report let's say this is report number two and then I'm going to add that to my month end reports So we'll save that and let's modify this one and do a comparative balance sheet just to have another report that we might add So I'm going to do that by by just looking at the last month so I'm going to say from from eleven let's say twelve oh one twenty one to twelve thirty one twenty one run it And then I'm going to look at the prior period previous period November so we ran this report in the past and just run this report And then I'll do some customization up top I'll call this a comparative comparative comparative balance sheet hopefully the name is correct I'm going to copy that we're spelled properly customize it just one more customization I'm going to get rid of the header of the report period To get that to get rid of that item and then I'll also I also want the change and the change on the percent and the change here So this is the report we've seen in the past it's another customized report I'm going to save that customizing it and this is going to be balance sheet two So I'm going to save this one to number three hopefully it doesn't overwrite my balance sheet two and I'm going to call it a comprehensive balance sheet into the month in reports And save that okay so now I'm going to go back to the first tab and let's see what we have in our customized reports I'm going to refresh it so that hopefully that'll pull in the reports that we have customized So now we've got our three reports here so we've got our three reports it's in order so I tried to put them in order so no matter what we do if we print them Or if we if we put them into our management report we can kind of see the order that I would prefer to have them in now let's go into our management report and see if we can customize it So I'm going to copy the report let's make this like our month in kind of report so I'm going to say okay let's see if we can we can change that report period And I'm going to say let's put the the custom dates and I'm going to say from 0101 to 1 to 2 well let's I got to use this thing up top alright fine We're going to say this is from January 1 to December December so January 2021 to December And then let's let's edit it I'm going to hit the drop down and edit the report and let's see what we've got here we've got up top We've got the cover style that we can choose different styles on the cover so if we wanted to choose something a little different we got the cover the logo If we had our logo populated in our preferences would then pull in here the cover management report you might call it you know your accountants report or something Accountants month and report or something like that if you wanted to change the title accountant month in report or something And then the subtitle name you might put you know your your firm's name or something something like that report period report period that you can for the period ended So you might put for the period ended it's drawing that in so for the period ended December 31st 2022 So I would like it to be didn't I say for 2021 for the report end date should be for the period ended December 31st 2021 I thought it was supposed to be prepared by you can put your name here and then we can say preparation date we can keep that or remove it if we so choose And then the disclaimer saying you know this is for management use only so that looks good let's go ahead and save that we'll say and well my name's not right I misspelled my name hold on a second hold the phone and then on the second tab we've got our table of contents which we can include or exclude the table of contents So we've got that included and we've got the profit and loss that is being included here as well as the balance sheet those are the standard reports which I would like to basically adjust And then on the third page we can put basically a note into the third page here so I'm just going to put a test note this could be your introduction or something like that And then just put a test it'll add this page to the report then and then we've got our profit and loss so here's where we can add the primary pages and instead of the profit and loss I'm going to say No I'm going to add I'm going to see if I can trash these trash this is trash and then add the report that we want to be picking up from our month and here they are month in reports So we have them up top so this is this is the subcategory into the name so that's the one I want title month in report custom custom field one one twenty one so that looks good so compare previous year No compare previous period no I'm going to say add another one and then we wanted this report number two and that's going to be the balance sheet so that looks good and then I'm going to say that looks good And let's say the next one holding control scroll down so I could see the add new one and then let's add the third report this one might be a little tricky because it's a comparative report so I would think the date range would have to be eleven it's got to be yeah it is That was right twelve oh one two one so that looked good and then so we can save that let's save it and see if that produces what we would like and then the last page include include this page include break down so you can have your summary page this is you know summary Summary things look good look good or something like that right you can have your last page and so we're going to save it and close it save it and close it let's check it out let's view it I'd like to edit the name of the thing can't I edit like edit the category name let's call it this is month in report month and report as of twelve thirty one two two one and save it and close it and so let's check it out so this obviously you can do a lot more customization but you can get the idea of it here we can view it and then see what we have on it and so I can scroll back up top and say okay we pulled in our our month and report we got her name on it for the period ended December thirty first two thousand twenty one by Robert date prepared it's for management use only table of contents now includes month in reports number one balance sheet so so notice we might want to be able to clean this up a little bit so I might go in there and clean that up summary and then introduction this is our test page so you could include this or not include this if you had some kind of introduction you wanted to put before the actual reports and then you've got the reports which is the balance sheet which looks right right looks right and then the the month in balance sheet so this is the first one was the summary balance sheet wasn't it yeah and then the longer balance sheet so longer balance sheet and then you've got the comparative did that pull over correct it looks like it did right so there we have it now of course you don't have as much like if you export this to excel or something like that you can actually you can you can customize it a little bit a little bit differently so this could be a great tool but you're still kind of locked into you know the format that the system is going to give you so when you look at those categories for the balance sheet for example you might say maybe I want to call it something else like cat like the cash accounts you might want to call them cash or something like that and that's a little bit more difficult to do in here which you could do pretty easily if you export it to excel and made like your own reports that way let's see if I can I'm going to edit this one again edit it again and if I went to the table of contents into the table of contents could they won't let me they won't let me edit this report as well so notice that's a little restrictive because because now I'm stuck with the name that I called the report and if I if I put it into the memorized reports it puts the subcategory of month in reports and then the name which has the one in it and I can't I can't basically remove that in the table of contents so that's a little it's a little annoying so it's I'm sure it's a little bit finicky but the goal is that it's going to be easy to make a more formal type of report you and so that's could be a good good tool to look into and you can you can look into using that tool and seeing if that's a more professional way that you want to present them obviously we can also just export these reports to to a PDF which will look at future presentations and or we can make our own basically a report that can be a more professional report basically exporting them and possibly using Microsoft and possibly word depending on how how complex we wanted to do and look at that type of process so we'll do a compare and contrasting of then printing these reports and future presentations exporting them to excel making our own PDF file with multiple reports on them in future presentations