 QuickBooks Online 2024, sales by customer graphs. Get ready and some coffee because we're diving into it with Intuit's 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 then we're gonna verify that we're not a robot. Opening up our major financial statement reports like we do every time. Reports on the left-hand side, we're in the favorites, right-clicking on that balance sheet so we can open it in a new tab. We're gonna right-click on the P&L profit loss, otherwise known as the income statement, opening it as well in a new tab. Let's go to that middle tab. We just opened up, closed up the hamburger and we're going back in time, back to 2023. 010123 tab, 123123 tab. First, a word from our sponsor. Yeah, actually we're sponsoring ourselves on this one because apparently the merchandisers, they don't wanna be seen with us. But that's okay, whatever, because our merchandise 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 accountinginstruction.com or accountinginstruction.thinkific.com. Run it to refresh it. Then we're gonna tab to the right, close up the hamburger. We're gonna go back to 2023. 2024 is looking scary. I'm going back to 03. 010123 tab, 123123 tab. We're gonna run it to refresh that one. These are our major two financial statement reports. Most of the reports giving us more information about one or multiple line items, more detail on one of these financial statement reports. This time, we're continuing on our quest for the graphs. So we're looking at the graphs here and we're exporting to Excel to create them. Normal graphs you might make if you're providing these to say a client might be backing up your income for example, income by customer, income by product or service, you could even do a pie chart for income by account category if you wanted to do that as well. And then you also put some easy graphs. You can go into the balance sheet. We did one for the accounts receivable last time, breaking out the AR by a customer who owes us the money. Just an easy graph to make fairly quickly. You could make a graph about your categories of assets as well, which you might start out by doing a balance sheet summary report because it'll have less subtotals. And then we did the accounts payable as well. And you could do the same for the liabilities if you wanted to and break out all your liabilities in a pie chart if you wanted to as well, which you might wanna start off with a summary balance sheet to do that. But this time, we're going into the income lines. Remembering that income over here is represented on the profit and loss by account usually. The account being what we receive the income for by category, the things that we're basically doing, goods and services by category. We usually don't put a lot of detail in here on the income statement by customer. We don't make accounts by customer because we can have a sub ledger. As we discussed when we looked at the sub ledgers, we can have a sub ledger by customer. We don't usually put a whole bunch of detail about every item or service in each different account over here either because we can usually have a sub ledger. However, remember that the sub ledgers will only be here if we're using the major sales forms to record revenue. Those being the invoice forms, the sales receipts. If you're recording revenue possibly with the bank feeds and using a deposit form, you're gonna lose some of the depth in reporting for these subsidiary ledger reports such as the sales by customer or the sales by item most likely. So in that case, you might want to put more detail on your profit and loss report in terms of making your sales items or line items or accounts for actual customers. The other thing you want to remember here is that the sub ledger might not tie out exactly to what is in your profit and loss because the QuickBooks system does not force you to add a customer every time you post something to an income line item the way it does on the balance sheet side of things for both the accounts receivable and the accounts payable where it does force you to choose either a customer or vendor so that your sub ledgers can't be out of whack. But if you're using the sales forms to record your sales, your sales should be fine but you might make a little adjustment to make sure it ties out exactly when you do your pie charts if it doesn't tie out exactly which might still be relevant or be useful for the pie charts because it's kind of an estimate for the visual. So let's go into the tab to the left. Let me show you what I mean. And we're gonna go down to the reports on the left hand side, close up the hand boogie and we'll scroll down to the sales side the income statement supporting type reports down here sales and customers. And then we have those two ones down here. We had the, what did we have? We had income by customer and then we had the sales by customer. I believe the sales by customer is what we want because I don't need the expenses that we're taking out. Let's open them both up, I'll just show you. If I right click and open the income by customer and then I right click and I open the sales by customer they sound like the same thing but they're slightly different. Let's see, we're gonna go up top and say a range change. Let's go from 010123 tab, 123123 tab, run it to refresh it. There's our income by customer. You can see an expense line that will include like cost of goods sold possibly where we don't, maybe we don't need that. You could do the net income, net income impact but usually you're probably looking into the top line when you're making your graphs. Therefore we'll use this report, close in the hand boogie bringing it back to 2000, 230123 tab, 123123 tab, run it to refresh it and there we have it. So once again, we have these subtotals in here which might be because we have jobs in place within it and we don't typically want those because those are gonna throw off or make it more difficult for us to make a graph. I would just like to have my lines and then the total, that'll be the easiest thing to use. So possibly I could collapse them, boom and now I've just got a straight list. That looks like really easy to make some graphs from if we just export this to Excel, that's perfecto just like my friend Mundo would do it, perfecto like Mundo. So then I was gonna say something else I totally forgot. There was something important, hold on a second. I remember, note that if I go down to the total down here 10,280.05, that should tie out to our income statement on this side if I look at my total income, 10,200. It's off by $80. So possibly something got recorded with a journal entry or something that didn't have a customer or something happened. It's off by 80, but 80 is somewhat immaterial and possibly in our thought process here. So the pie chart should still be good based on this sub ledger and I could just adjust it for the difference if I need to to make sure it ties out exactly to what is on my reports. So everything looks nice and neat. So we'll keep that in mind if I remember here. So I'll hit the dropdown. Let's export it to Excel so we can make some pie charts from it and possibly some bar charts and whatever we're feeling into at the time, whatever we think our customer would appreciate and enjoy. So there we have it, let's enable the editing. Now I'm gonna put this on our other worksheet that we've been working on. If you don't have this other worksheet, that's okay. You can do it on the export but I'm imagining that we're printing all of these reports out at one time and then I would like to add this one to it using it to make our graphs. So how can I get this tab over there? I can right click on the tab if I have both worksheets open, move or copy. I'm gonna copy it over to the month in reports, boom. And then okay, pulls it over first tab. I'm just gonna drag it to the right. Drag it to the right, there it is. I'm gonna call this my sales by customer data and then we'll just use this as our data and then maybe I'll put my graphs in another one and I'll hide this tab so that I can print it and it doesn't show up my data tab but only my cool graphs that I got from the data tab. All right, we'll do this a little bit more quickly cause we've seen a similar process in the past. I just wanna trim this down, clean it up, take the data, make a pie chart. So I'm gonna go from one to five, right click and delete all of this. I don't need the header. I don't need the total on down, right click and delete. I'm gonna make it all one format for the entire sheet which I wanna be like this cell to start off with which is Calibri 11. So I'm just gonna format that and format paint the entire worksheet. And then I'll right click and I'll format it the way I want it to look. So it's all uniform, everything's the same. You're not gonna confuse me with all this different looking stuff. We're gonna make it currency, negative numbers bracketed and red, get rid of the dollar sign. We don't need the pennies in our worksheet here. I don't think. So let's go ahead and say, okay, I'll in bold it because we need to be bold with our recording videos. I'm gonna, you don't need to bold it possibly on your end, but that's just what my producer says that I have to be bold. And so I don't wanna get fired or anything. So I'm gonna be as bold as I can here. So that's as bold as we can go. Excel won't let me get any more bold than that. So then I'm gonna say that, now if we make a, well, we have to put this into a filter from top to bottom. So I could go to the data here and then we could go filters and filter it this way. But I like entering a table. So I'm gonna make a table out of it, insert a table, boom. And then I could put the headers in here. This is the company, this is the customer sales. And then I'm gonna sort it from top to bottom, hitting the sort. We're going from Z to A, A, Z to A, A, A. All right, so then we're gonna, then now if I make a pie chart out of this, there's too much happening, too much happening here. So let me show you, it's gonna be too small of slices of the pie. So I'll go to the home tab. We're gonna have to make some adjustments to this if I wanna make a pie chart home tab. And charts, pie chart, let's just do the standard pie chart and see how you've got all those really little slices and the keys too long. I mean, that's like, that's not a pie. That's not even like a candy bar. No one's gonna appreciate the level of slice there. It's not gonna fill anyone up. So let's go ahead and see if we can just take like the top 10. One, two, three, four, five, six, seven, eight, nine, 10. And then we'll just do nine and then 10 will be everything else. I'm just gonna select all these. That adds up to two, five, four, six. So I'm gonna make this two, five, four, six and delete everything after it. I'm gonna call this other, other. And then I'll just delete, I can just delete. Now I'm gonna delete completely. I'll just delete this whole thing, the whole rows on my table and delete it. And then I might wanna double check that my table because I played with it. Make sure it still ties out to the total that I want it to tie out to. So I'm gonna say, let's make a total column, table design and I'm gonna add the total rows. So there's our total. And then I'm gonna compare that to what's on my report over here, which is 10,280. Now I'll make a slight tweak now because that one's not quite what's on my balance sheet, which is on the balance sheet, or no, on my income statement, it should be 10,200, maybe 10,201 if I round it. So I'm gonna say it should be 10,201. The difference, let's just do this. If I delete this one and subtract this, then this one should be 2466. There, now I have a total that ties out exactly to what's on my income statement, even though it doesn't exactly tie out to what was on this report, but you see what I mean? Because that will fit what's on the income statement now. So then we're gonna say, okay, it's still got some fairly small slices. We might even take it down further than that, but let's just play with this one for now. The legend, let's bring it to the right. And so that's okay, I guess. Top left, let's keep it on the right. I think that's the best. And then maybe I make it a little bit larger. And then we could once again, say we want the data labels and maybe we want it in percent format. So more options and then percent instead of values. And then I can close that. And then I can go to the format and within the word art style, I can make it white and then maybe bold. So it stands, okay, I'm gonna stop talking like that. What in the world is wrong with you? All right, note that I couldn't, now if I wanna check those percentages, I could say this is the percent of sales. And then this is gonna be equal to this number divided by the total. And then if I was to select all of that stuff to format it like a percent home tab, number percentify. You best percentify if you wanna recognize and then we'll sum it, okay? So there's our percentages. Now we could have done that first and then made the pie chart if we wanted to. I'm holding down shift to select the non-adjacent columns. And then I'm going to the insert and pie chart this way. See, so I could have done it that way. And then when I went to my data labels, I wouldn't have had to change them because they would be in percent format already. But either way you wanna do it, then it's up to you. It's up to you. So now I can select these again. Maybe I want like a bar graph as well. Insert, the bar graphs are right here. No, that's the histogram. Bar graphs are here. We've got the standard bar. We've got, now we've got the fancy looking bars this way. We haven't done that one yet. Let's do one of those. The 3D bars are not as deceiving. They don't annoy me as much. The 3D pie charts, I feel like some sneaky politician bureaucrat in the company's trying to manipulate me or something. But this one I don't think is really, is not as manipulative looking. Doesn't look like it's trying to throw off the numbers too much, although it makes it a little less clear. But I kind of like it. So I'm okay with that. So then I'm gonna say this is gonna be the data labels. We can put those on the top, which we can put in numbers this time, which is probably more common than percentages because the percentage would be like a pie chart thing. And then maybe we wanna put this on a new tab, just like we did before. So I'm gonna make a new tab and I'll copy this name, right click, or I'll just double click on it maybe and copy. I'll put that over here, but then wait, double click and then get rid of the data, even though it just is dat, which isn't quite right. And then I'll just copy, I'll just move these. I'm gonna right click and cut this and I'm gonna put it over here and paste it. And then I'll do that again, I'll just cut this and then I'll put it over here and paste it, boom. And then let's check out the layout, page layout back on over. And so it's still, maybe I don't want, maybe I wanna go landscape again, page layout, orientation, landscape, because these need to be appreciated in their full glory, it didn't do it. That's not landscape, is that landscape? Are you kidding me? It's not doing it. Let me just check out, oh, wait a second, what did I do? If I go to the print preview and we look at the whole workbook, let's just go to the active sheet. See, it's still portrait. I told you to go, here's another way I can go to landscape here. Okay, that'll do it too. Sometimes it gets a little wonky and it won't do what you tell it to. It's like my dog. Okay, so then I'm gonna make this a little bit larger and then I'll try to fit them both maybe on one page, landscape. So maybe, see if I can get them on one page, landscape. I'll make this one long. That one can be super long. This one doesn't really need to be as long, I feel like, because it's a pie, it's more of a square format. So that fits on one page. Put it down, I don't put it down here. And then, oh, oh, no, control Z. Put this here. Okay, maybe I can put this up and then drag it down. Okay, that's good enough. This is just an example. But if I print it, then I don't want this sheet. So we have the same thing, same problem we looked at before. If I go to the print options, if I wanna print the entire workbook now, wait a second, now it's on, well, wait a second. If I go to the entire workbook, it's just, it's going to a PDF printer and I want selected. Now notice I'm on one chart. Sometimes it doesn't let me do it when I'm on one chart too. So if it does that, just go on to another tab and then go back to the file print and then say I wanna go to the entire workbook. And then now it starts at the beginning, you might not have all this stuff in yours because you might not have followed everything I'm doing here because I went, but the point is, see now before that I have this sheet I don't want. And then I have my chart which is what I do want. So then let's close this back out and all we have to do is hide that one. So I'm gonna hide this one, right click and hide. And now I'll see these two sheets will be side by side at the end of our report. Let's go to the file and then I don't want, I could hide the data tabs here like I'm gonna hide this one again too. Hide that data tab, I'm gonna hide this data tab. And so now we just have the graphs and not the data tabs. All right, let's go back on over file, print and entire workbook. Let's check it out, admire, we'll admire the progress, the process, the landscape. Look at that, my client is gonna be so impressed. This is gonna be great. So there it is, let's print it out. Let's print it out, let's see what it looks like in a PDF format, because that's what I'm gonna email or put in my cloud drive. I'm just gonna save it over the top of this one. And then let's open it up and check it out in that format, make it larger. So here's our reports, balance sheet reports, balance sheets, we've got our income statements and then we've got our landscape view, still vertical. We got the fancy AR graph that looks different and then the customer. And then we've got our vendor balance graph and then we've got our AP ones that we did. They got the sales graphs that look fancy and the sales graphs. That is gonna knock the socks off of people and apparently people like when their socks get knocked off. I'm not sure, I would appreciate it myself but that's what there's a saying of anyways, that's the sales thing. We might go into another one of sales by item in a future presentation, so look out for that one.