 thinking about the expense side of things now be broke being broken out this could be a quite long report if you had a lot of vendors which oftentimes people do and then you could do the same by employees products and services so if we run it by products and services now you've got them up top and you can see what you're selling in terms of income and and the cost of goods sold that's associated with the income on a product by product basis which could be uses useful and then you have your tags tags as a special kind of tool that is another sorting category and you can see you can sort it here you might also as we're thinking about these if you have if you have class tracking on you can also often basically sort your income statement by class tracking those are specialty tools class tracking and tags location tracking similar tools we have another section or course specializing in those areas as well so that's going to be one way that you can do comparative reports let's go back to the total another way that you can do the comparative types of reports is that you can say I want to have the current period and then compare it to the prior period so if we want to compare December to the prior month of November I can change the range up top to 11 let's go to 12 12 1 2 3 so now I have the month of December up top just the month of December and then I want to compare it to the prior month selecting the drop down I can say give me the prior month and it defaults here to November that looks correct so I'm just going to say let's run that so now we have a comparative report but now they put the current month first and that's fine because that's our most important month and then the prior month second also note with these comparative reports we can only compare two periods because likely with the comparative reports the next step you want to do is not add up the two periods having a total which is nice too on the income statement where it's not as big deal on the balance sheet but what you want to do instead is subtract them to see the difference in what your performance was in the current month versus the prior month in this case so if I select the drop down we say give me the dollar change poor favore if you please I'm going to pull out the trustee calculator and so we can do some calculations so then of course we have for example the totals down here two four five five point six four might well wait that's not right the current month is up top one two nine six point five eight minus the two four five five point six four that gives us the negative one one five nine uh oh six that's great we can compare that to our prior months and stuff and how we're how we've been doing in the past but if we want to compare it to another company like if we were a McDonald's and we want if we were like a hamburger shop and we want to compare to McDonald's or something they make way too much money for me to think to compare my dollars to dollars but we could compare possibly percentages when we benchmark and so if we run the percentages in our performance type report percent change run that one run that one so now if I do that same thing I've got the one two six nine point five eight minus the two four five five point six four that gives us a negative one five five our one one five nine oh six and then I divide that by the prior month that's how you do the percent increase or decrease by the prior month two four five five point six four and that gives us if I move the decimal two places over a 48.2 percent increase so if we are decrease I'm sorry because it was a negative here but if so if hamburger sales went down but for us by 48 percent that's her or whatever the sale and I compared that to like a McDonald's did their sales follow a similar trend would be the question if they did then maybe the assumption would be of course that if they market thing and not an us thing it's not that people just got mad at us and they they canceled us on the YouTubes or something and then now no one likes us and they keep on stealing our hamburgers and throwing them at people for some reason because I don't know what happened but in any case now we can say we could do it and on these ones like two forty seven point eight one minus two four two twenty seven point oh one we get the one twenty I can take that and divide it by the prior month one two seven point oh one and then that's going to be ninety five point one one percent increase in this case right and we can see that on a line by line basis that's nice I can I can customize this report like I typically would customizing up top because it might be used for external usages and we do our normal negative numbers bracketed I often will remove the pennies show it in red and then in the headers and footers we might remove the date time report basis then of course we might change the name now on the profit and loss the basic name change you might do if it was just a normal profit and losses call it an income statement just that might stand you apart a little bit because maybe some people maybe some people see that as more like a professional or whatever they like to call it an income statement rather than a profit and loss it just depends on what you've what you've gotten used to I guess so you can then call it an income statement and there but when we do a comparative we might want to call it a comparative income statement so now it's a comparative income statement and then of course once we do this if we're going to save this to our external reporting like we did with the balance sheets we might want to save