 QuickBooks Online 2024 Customize Report. Get ready because we're going to Bookkeeping Cloud 9 with QuickBooks Online 2024. Here we are online in our browser searching for QuickBooks Online Test Drive looking for the result that has Intuit.com and the URL Intuit being the owner of QuickBooks selecting the United States version of the software and verifying that we're not a robot. Open it up our major financial statement reports like we do every time reports on the left hand side and then within the favorites we're going to right click on that balance sheet report open in new tab right click on the profit and loss open in new tab go up to that middle tab we just open close up the hamburger there's our balance sheet let's do a range change up top going from 010123 tab 123123 that's January to December 2023 run it to refresh it tab into the right closing the hand boogie ranging to the change in 010123 tab 123123 and run it to refresh it let's go back on over to the balance sheet this is where our point of focus has been and we talked last time about the components of the balance sheet the comparison between the balance sheet and the income statement between our two major reports and we talked about some of the formatting items the formatting and customized items that are in this gray area up top as well as this header section here first a word from our sponsor yeah actually we're sponsoring ourselves on this one because apparently the merchandisers they don't want to be seen with us but but that's okay whatever because our merchandise is is better than their stupid stuff anyways like our trust me i'm an accountant product line yeah it's paramount that you let people know that you're an accountant because apparently we're among the only ones equipped with the number crunching skills to answer society's current deep complex and nuanced questions if you would like a commercial free experience consider subscribing to our website at accounting instruction dot com or accounting instruction dot think of it dot com now we want to go into the customized settings further into these customized settings some of the information in here will be duplicated and i think the idea from quickbooks is they had they're kind of not knowing which how much stuff they want within the customize and how much stuff they want in this ribbon area so some of it is basically duplicated they might change it over time that's why we update the course from time to time so that we have the up-to-date locations of all these little functions but typically the functions will remain the same they might just change exactly the like the formatting and where they are located so let's go into the customization up top we have the customization categories if i close all of the triangles we've got the general we've got the rows and columns we've got the filters we got the headers and footers let's start off with the top one the general information so we have the periods note that this period information is the exact same thing that we saw over here in a prior presentation therefore most likely you're going to be going into that stuff on this side and not going into the customized reports to get there and then we got the accounting method once again that was something that was over here as well so you have that toggle that they put over here now with the accounting method i'm recommending remember to use the accrual method i went into a big long rant on it last time as to why that's the case so if you have if you're thinking i want to click over to the cash method over here just go into my rant before and and then think about it and see if that is the thing you want to do in the prior presentation but in any case we're then going to the number formatting so this is new stuff we've got the divide by 1000 without sense uh accept zero amounts uh negative numbers and show in red so let's go through these one at a time we're going to say first divide by 1000 now most of the time small reports or companies might not do this but if you have a large numbers then dividing by 1000 is a way to take off some zeros to round basically so if we click that one off we're going to say boom and then it rounds it out to the thousand so if i go in to my trusty calculator here and we were to say that we had 1.2 times 1000 that's where that's the amount here so if i go back up top again and we say i'm going to go back up top to my customization and then if i bring it back off we were at the 1201 right so it rounds it to the thousands now if i take if i do that here and i say divide by 1000 and we want to have the without sense then it's going to take off the decimal so now it takes off the decimal that wasn't really sense here that was the rounded that was the rounded amount here right so you probably you probably possibly want the decimal maybe if you're rounding there but that those are the rounding one now if i bring it back to where we were here's where we were and now i have the pennies here so what if i want to round it to the pennies i just want to take off the pennies i'm not going to divide by a thousand just want to take off the pennies well that's the sense so we don't want sense we want the report to make sense but not have pennies that's what we're talking about so that's a little bit cleaner obviously the question would be is is the financial statement reports are they still uh when you take off or round certain items do you have what you need for decision making purposes usually for external reporting taking off the pennies is fine for the internal reports i like to have the pennies on there because i want to see the exact numbers when i do my data input information so i would usually take off the pennies for external reporting possibly divide if i'm looking with working with large numbers then we have the accept zero amount this is checked off by default and that's probably the way that we want to keep it let's run the report just to see what that is doing if i go down here for example to this truck account you can see it has a parent subsidiary account relationship let's go back to the first half just to get an idea of what that means if i go into the transactions and then go into my chart of accounts when we set up our accounts we could set them up so that we have a parent type of account and then put other accounts below it so we have this subsidiary relationship that's what's creating that particular drop down when we do that oftentimes we don't want to actually post anything to this truck account but instead just use it to give us the drop down and then post to the accounts below it so you can see that nothing over here is posted to the truck account and it didn't put a zero which is nice because the zero would be a little bit messy right so instead it has the drop down and here's the amount here and then it gives us the total below also down below in retained earnings you can see nothing's in retained earnings but it still keeps retained earnings because that's like a permanent account and it doesn't put as it didn't put a zero there if i go back up top and customize it and then uncheck that one you can see that in this subsidiary truck account there it puts the zero which is a little bit ugly right it's not as nice and then it puts it here now if you want to remove the zeros that don't have anything in there remember that was here where you can say i want to have uh not active accounts that had activity in them but non-zero accounts so that'll remove all the accounts that have zeros in them so so usually if you want to remove the zeros you'll do this and usually by default you'll just keep this one checked off and just don't mess with that one typically so then let's go to the next one we're gonna say rows and columns so we have the totals uh the days uh the months and this is all stuff that we saw over here same exact drop down that we had over here just repeated show non-zero amounts this is the same exact drop down that i just showed you over here so once again you probably will not go into the rows and columns section because you could do that right at the header of or the ribbon it might be called of uh the report let's go into the filters filters is a really important area depending on the reports that we go into oftentimes you're not going to filter say a balance sheet report but you will often use a filter for like a transaction detail report so let's do one of the let's go into like the checking account and you can see this time they're giving us the new report settings so this has the fancy new settings in it so if you filtered this way it it's right here this is where the filtering option is in this one and then oftentimes if i hit the drop down we oh wait a sec we'll keep that one there because this is already filtering we'll add another filter and then if i hit the drop down we often want to filter by transaction type as we saw before equals and then maybe i want to just take a look at like the deposits right and then i can i can filter and just see those we can add another filter if i add another filter that will then reduce it down it's not going to show like i can't add another one and give me deposits and expenses instead if you want deposits and expenses or deposits and something else you can check two of these off as well let's say deposits and uh what a cash expense or something then i have two of them checked off so now i should be able to see both of those items lined up over here now if you go to the classic view i'm going to switch to the classics view now you have the setup that we saw before and so here's our information in the classic view and then up top we can customize the reports and now you've got your filtering options here and this drop down type of setting so this one's already checked off as the checking account once again we could filter by the transaction type for example and then possibly choose one or multiple of these items here's a check and then we could choose a uh a deposit so we have two of them checked off and we could say run it and so now we've got the the transaction types so it's still up in the air as to whether uh QuickBooks is going to run with you would think uh soon they're going to run with uh the modern view which i think they probably will because it does look kind of nice i think it works pretty well out but they still have the classic view on some of the reports including the balance sheet report so we'll see how that we'll see how that plays out you know and if once they finalize it we'll we'll update the course again at some point and uh and we'll we'll see what they did so they're ab testing that particular feature right now it appears so that's going to be the filtering uh and then we have the headers and footers so in the headers and footers we've got the company name we've got the report title and those are the items up top so we saw that you could remove like we could just remove them here and say okay now we don't have a company name and report title if i oh hold on a sec run it if i customize it put those back in we could change the name but we could always we could already do that over here so if i went in here and i changed the name i can do that in here i'm not sure you can delete it in here maybe you can delete the whole yeah you can you can even delete the whole thing in here so you really don't need to go up to that customized area to get to get to that because you can already do it like on the face here so uh just note that it's probably the faster way to do it uh i'd like to return the title now i'll just say company name company name and uh and report balance sheet okay and then the period the report periods let's run that again and then let let me just show you the page layout and so here's the layout of the report and if i scroll down you can see that at the at the footer it's got a cruel basis and then the date and the time you might not want all that stuff on the footer you can't see it unless you go to the print but when you print it it'll show when you printed it well actually you can't see it here it's on the footer there so what if i want to remove that i want it out i want that out of here get that out of here so report period uh we'll say take that off now hold on the report period took off this uh date on the on the top let me show you that again the report period is and i was going to go to these three that take off the footer the report period takes off this one i don't even think you were able to do that before because i i i believe at some point we couldn't actually take so that's kind of nice that's actually works well because when you run like a report like if i if i run this report let's put it back on and just show you when you might want to use that if i if i ran this report and i said it i want it quarter by quarter then this it says as of december 31st but it's not really as of december 31st anymore because you have it's as of each of these four quarters right so so in that case you might want to remove this and then rely on these or and rely on these as basically your dates in a essence it would be nice if you can edit that still but at least you can remove it that's nice and then the footers we can remove the footers down here date time report basis and i can say boom and then down here footer gone if i was to print this thing then no footer they can't tell when you printed it i've got the date up top you don't need to know when i printed it you don't need to know the basis because we are it's sort of cruel they you know so we'll take that off and then we can go into the alignment this is just the alignment of the header so it's we can go left align and the footer we can left align it and then let's say that we want let's put the footer back in there so we can check it out so now it's on the left footers on the left and then if i go boom and say we want it to be centered that's what it was before if i want to put it on the right put it on the right now it's on the right we're doing a a dosy do turn to the left turn to the right and then back to the center back to the center and there we have it so note uh pretty pretty uh nice options overall if you're used to the desktop version uh some things that you might notice is the desktop version has some more options for the font formatting of the font and it had some options for like increase in the size of the text and that kind of stuff which they haven't done with the online version i'm not sure exactly why maybe i think maybe it's because if you really wanted to dig into that stuff you could you can connect this with uh with excel and you can export it to excel pretty easily and then go crazy with formatting on fonts and what stuff if you wanted to although it takes more time to do that because those kind of changes you would have to do uh every time uh the size of the font we can't change uh as easily and here which which i maybe already said that but you could on the desktop but you can zoom in for the view so that's nice and again if uh later on we'll talk about exporting to excel which also gives you a wider expansive options has its pros and cons so we'll look at that maybe not next time but we'll look at that at some point