 QuickBooks Online 2024. Customize report. Get ready because we're going to bookkeeping cloud nine 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 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 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 cents except zero amounts 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 into 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 cents 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 possibly want the decimal maybe if you're rounding there but 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 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 could 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 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 going to say rows and columns so we have the totals the days 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 column section because you could do that right at the header of