QuickBooks Pro Plus desktop 2022 Sales by Customer Account and item graphs Get ready because we bookkeeping pros are moving up the hill top with QuickBooks Pro Plus desktop 2022. We are in our free QuickBooks sample file sample Rockcastle construction going through the setup process with the view drop down the open windows list left hand side company dropped down home page to the middle, opening up that home page or maximizing it to the gray area reports drop down we’re looking at the company and financial and that balance sheet standard, customized and the balance sheet standard as has been our custom and date 1231 to three fonts and the numbers change in that font size to 14 for fonts sake, okay?
00:48
Yes, please. And okay, let’s do the profit and loss now reports drop down company and financial the PnL profit and loss in date at 1230 123. Customizing that report go into the fonts and numbers tab change in that tab to 14 once again on the font. Okay, yes, please. And okay, our focus now on the profit and loss otherwise known as the income statement looking at that income line item, wanting to break it out in graph format by we could do it two main ways one, who we made the sales to by customer, and two by the items that we sold service or inventory items.
01:31
So we’ve got a pre formatted graph we’ll take a look at and then we’ll take a look at the reports that are used to format that graph. We’ll also think about how we can export this to Excel. Having a graph that could be a little bit more format, we can format it a little bit more options or more options to format it. So reports drop down, we’re looking at the sales item. And you can see here we got the sales graph, that’s going to be our major focus, we can also find that by going to the reports center,
01:59
let’s do that report center up top maximizing the Report Center going then to the sales on the left hand side, we got the Sales by Customer Information. And then down below down here we got the sales by item. Those are the two primary reports that we can use, or we can think about that will be generating the sales graphs reports, which can toggle back and forth between those two options. Let’s take a look at the sales graph report. QuickBooks bounce back up there for some so then there it is, let’s change the dates up top we have a similar formatting as the graphs for the accounts receivable and accounts payable.
02:37
We’ve got the dates up top which need a range this time because we’re talking about income over a certain time frame not as of a point in time, as was the balance sheet accounts of a receivable and accounts payable. Let’s make the starting date 12 Oh 123. And then I’m gonna say okay, so now we’ve got then the total down here of the 51 999 69. For the sales, let’s see if that ties out to the profit and loss. So we got the 51 to 41. So it doesn’t tie out exactly, there’s a difference between them, that could be possible given the fact.
03:12
In other words, it’s less likely that this number will tie out to the sub ledgers. If we break it out by customer than it is for say the accounts receivable to tie out to the sub ledgers because it is possible for us to enter something and allocate it to the income account without QuickBooks basically forcing us to assign it to a customer. That not being the case generally, when we put something into accounts receivable. So in other words, if you were to enter data into your system, for example, just a deposit and just assign it to the income account without assigning a customer,
03:47
you can do so and that will kind of throw off then your subsets your sub reports here to the amount on the income statement. You can’t do that so much in a QuickBooks at least for the accounts receivable and payable, they require you to enter a customer and vendor respectively, so that they’ll force you to kind of tie out the sub reports or sub ledgers to the general ledger or main report on the balance sheet. And in this case, the income statement. So let’s go back then on over.
04:14
So we have this information. So that’s the first thing you kind of want to note. If you were to print this information out, you’d say okay, there’s a difference here or you want to note that it exactly ties in so someone asks you a question about this report. You can answer the questions about that about that report. This gives us the breakout by the customers. So and by the by the item it’s currently on item. Let’s bring it on over to the by customer. So now we’ve got our customers and we got 1-234-567-8910 11 customers and it didn’t need to put anything into the other category because we it wasn’t that many customers to add it. If there was more customers that would be involved in here.
04:59
We might have The 10. And then an other category as we saw with the accounts receivable and accounts payable reports. And so we got the pie chart, we can’t do too much with the pie chart, but you got that nice pie chart, which once again, we could take the screenshots of them and add them say to a PowerPoint presentation, or to to our reports in Excel and print them all out on one report, if we would like to do that. And then we got the printing options.
05:26
Notice that the printing options are only for printing here, we don’t have the save as a PDF. But if you have the cute PDF printer, you can print it to the cute PDF printer saving it as a PDF as well. So those are the general items, if we go to the reports that’s that will support this data, we can go to the Report Center, this is breaking it out by customer. Scrolling up top, we can take a look at the Sales by Customer summary. Running that report gives us a nice breakout. If we change the dates up top, we got 12 one to 1231 to three, this report total at the 52 999 should tie out then to what we got on our our graph.
06:12
And you can see that we could use this report as well, as we did with the accounts receivable and accounts payable to export to Excel, this one needing a little bit more formatting because once it’s at job costs system, so we’d have to set everything up and remove the subtotals in order to basically make our pie graph with it. But we could go through that process that 50 to 999. Matching out to what is on the sales graph here. Then if we go to the items, if I want to see it broken up by item, we got our main items, this could be a nice a nice graph to have, if you were trying to look at the you know what it is we’re selling, one of the main things that we’re selling, and so on. So we’ve got our items broken out.
06:55
And then you could tie this into our other report by going to the Report Center, that would be in the sales area down in the items area down below sales by item summary, running that report, changing the dates up top to an endpoint of 1230 123. And our total by item things we sell inventory and service items, in other words, is this line item there it is the five to nine, nine, once again, that would tie out to what was on our graph. This is another report that we could export to Excel, you could see if we were to make a pie chart with it, we would have to clean it up, get in basically what we would like is just to have the items.
07:39
And then basically, we don’t need every column, we can clean up all the columns, basically just looking at this column and the items. And then we could do basically our graph types of calculations from it. If we wanted to see the calculations on these items would be something like taking the total here. So if I took like the subs, which are coming up to that 15 If I took this 1546 1.25 and divide it by the total, which is the 50 299 9.69 we get about 29.17 I move the decimal two places over.
08:16
So moving back over here we’re looking at then the subs at the 29.17. So those are where those percentages are at. You want to have an idea of where the percentages are at in the event that someone asks you a question about the nice colorful graph that we wanted to put in there to break up the data in either our presentation and or in our worksheet that we’re that we’re providing to our supervisors and or our customers or clients