QuickBooks Pro Plus desktop 2022 accounts payable graphs Get ready because we bookkeeping pros are moving up the hill top with QuickBooks Pro desktop 2022. Here we are in our QuickBooks sample file sample Rockcastle construction going through the setup process with a view drop down the open windows list on the left hand side company dropped down home page in the middle maximize in that home page, go into the reports drop down taking a look at the company and financial balance sheet standard down at the bottom. We’re going to go to the Customize and reports up top change in that end date to 1231 30 123.
00:39
And then the fonts and numbers change in that font to 14. Okay, yes, please. And okay, same thing for the income statement reports drop down company and financial profit and loss income statement and date 1230 123 customizing the reports go into the fonts and numbers change in that font to 14. And okay, yes, please. And okay, let’s go back on over to the balance sheet now in the home page or on the open windows, I should say. And we’re looking now at the accounts payable.
01:16
Now if I go down on the balance sheet to the liabilities looking at the accounts payable account, this represents the money that we owe to other people for goods and services vendors have provided to us, the subsidiary reports backing that or supporting that number is in our the vendor broken out or that number broken out by vendor who owes us the money and the aging reports. We also have the graph that can be provided to by QuickBooks. So let’s go to those items.
01:47
Reports drop down those would be in the vendors and payables. We have down here, the aging reports. And then we have this graph the accounts payable graph, I’d also like to go into that graph by going to the reports center. So reports drop down reports center. And then let’s go into the payables the vendors and payables on the left hand side maximizing this report center again, and we see this graph down here. So they got this graph, and I’m going to run that one, I’m going to run that one. And let’s change the dates up top to 1230 123. And so there we have.
02:27
So there we have our graph. So up top, we have the aging. And then down below, we have the pie chart, which is similar to the accounts receivable pie chart, this one instead of breaking out what is owed to us by customer giving us what we owe by vendor. And you got the similar key on the right hand side, the percentages, got the 10 customer or vendors, and then the rest of them grouped together in this total item for the pie chart. This is perfect kind of data for a pie chart, because you got that nice breakout breaking everything out to the total down below.
03:00
Nice pie chart, we could copy this pie chart as we did in the prior presentation to like a PowerPoint, do a screen clipping of it and paste it, for example, which is nice, but it is somewhat limited. We can’t rotate the pie chart, it’s in a 3d format, which I feel like it’s kind of deceptive in some ways, although you can’t rotate it. So it’s not purposely kind of deceptive because it does make part of the chart look bigger than it otherwise would if it was a flat chart which can be used, you know, to be kind of manipulative. But and you also can’t change the number of 10 vendors over here.
03:34
So for that reason, you can’t create this pie chart fairly easily as we did with the accounts receivable by exporting the reports related to the pie chart as well. So those reports would be if I go to the reports center, this pie chart is in essence breaking out down here of the vendor balance summary. So if I run that report, we can see the vendor Balance Summary.
03:57
Now I might run this one I wasn’t going to but notice this one’s a lot cleaner than what we did on the customer side because it doesn’t have those subtotals. So you might have gotten a little bit overwhelmed when we did the the the graph in Excel because we had to do some cleaning up of the data. But oftentimes, because that’s because it was a job cost system. This one’s just a list of items that add up to that bottom line number, let’s make the dates from oh, let’s make them from Oh 130 123 to 1230 123. And so we could just basically export this and make a chart from it pretty easily.
04:32
And so there is that also if we go to the reports then and by the way that that numbers down here that 26 636 92 The other reports up top are being broken out by the aging report. So if I go to the Report Center, you could create those were a little bit more complex to create if you were to use the data but quite possible, you can export this information and basically use the this information to help you with that data which would basically be The totals make it a graph, in essence of the totals on down below.
05:03
So the 23 177 72 and the 3004 5920. For the first two categories, the main categories here, going back to our center. So here we have our item around up to that 5000, and then up to around the 25. So this was around what should be around 3000. And up to like 223. So it’s kind of hard to see on this graph, because once again, they made it in that 3d. So where’s that line? Like, right there versus right, there’s, it’s not the most specific graph, but you can see a good little visual there on that graph.
05:42
Again, you could create that one in Excel two, using an essence, the data from this report. Okay, so that’s going to be the general idea. If I go back to this one, also note that you might also say, Well, where did the percentages come from? Remember, if you put a graph on, on your presentations, or in your packages that you’re going to provide to a client, or you’re doing a presentation even more. So get ready for someone to ask, actually ask you about the numbers in the craft, you know, they’re gonna say, Well, what does that what does that 26 636 come from?
06:15
Well, you want to be able to say, okay, that comes from the balance sheet. If you look on the balance sheet, you got the accounts payable 26 636 92. And then they’re gonna say, Well, where did the percentages, you know, where did the percentages come from? What is how do you get those numbers? Well, that’s if you look at the if you look at the accounts receivable, report, the vendor balance detail, and you pull out the trusty calculator, for some trusty calculations, calculator, we need you for the rescue, I can’t calculate in my head anymore, let’s just choose a large one like this 6000.
06:54
So that’s going to be the 6705 divided by the total, which is the 2663 6.92. And if I move the decimal two places over, it’s about 25.17. So if I go back over here, there’s that first 120 5.17. So you want to be able to kind of reference that if people you know drill down. Obviously, there’s a couple of reasons to give something like this. One is that it does give a nice visual representation of the data.
07:22
And two, it breaks up all the numbers. So you get a nice colorful chart, which is just aesthetically kind of nice, but you want to make sure that although it’s kind of aesthetically nice that you can also break down the numbers especially if you’re in a presentation format. To explain you know why it went logically be in there. And then of course, the dates up top you can change, you can print it notice it doesn’t have the option to save it as a PDF.
07:46
But if you have your cute PDF printer, you could print it to the CutePDF printer and print this out in that format. And you can also do like screenshots of it and so on to clip it in that format as we did in the prior presentation with the accounts receivable. So next time we might try to recreate these ones possibly both of these this time in a graph in Excel which should be a little bit easier. And for many companies, this process will be similar to the accounts receivable that accounts receivable had a little bit more data due to the job cost system that’s being used for this particular company.