 QuickBooks Desktop 2023. Accounts Payable Graphs. Let's do it with Intuit's QuickBooks Desktop 2023. Support Accounting Instruction by clicking the link below, giving you a free month membership to all of the content on our website, broken out by category, further broken out by course, each course then organized in a logical, reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files, and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. Here we are in QuickBooks Desktop Sample. Rock Castle Construction Practice File provided by QuickBooks going through the setup process we do every time maximizing the homepage to the gray area view dropdown, hide icon bar, open windows list checked off, open windows open on the left hand side, reports, drop down company and financial P&L profit loss income statement changing that range in 010124 to 123124. That's January to set to December 2024 customize it fonts and numbers to change the font to 12. Okay. Yes, please. Okay. Reports drop down company and financial this time the balance sheet drop down for the fiscal year 123124 customize it so we can get to the font so we can change it on up to 12. Rise it on up. Okay. So there we have the two major financial statements reports that being the balance sheet and the income statement all other reports pretty much giving us more information expanding on one or multiple lines in the major financial statement reports we have open here. Now we're going to be looking at the accounts payable graphs we looked at accounts receivable graphs last time accounts payable is down here it is and a cruel account there goes up when we enter bills and then it goes down when we pay the bills. Off so we're only vendors people that are providing us goods and services and so we're going to sort that out by a graph so it pictorially. So the report that this would be based on then would be if I go to the reports drop down we go to the vendors and payables and we've got the accounts vendors balance summary let's do that one. And so there it is so now we've got this customize it fonts and numbers change in the font to 12 so we could see it a bit better a bit better. So there it is so now this is who we owe listed out and then there's the total 26 636 92 time out to the balance sheet if we wanted to present that pictorially possibly because we want to show it monthly to like a client or to like a supervisor or because we want to put it into a presentation and have pretty colors on it and everything or we just like to look at the colorful thing that we can go to the reports drop down and you could find it in the vendors and payables. We've got our graph right there you can also find it in the report center of course let's do it that way to maximize the report center because it always unmaximizes which is just annoying but you know get over it. That's how it works and then here it is we'll run it right there it's stupid that it does that though but whatever. So there it is so we've got this now it looks a lot like the accounts receivable graph that we looked at last time but now this is people we owe money to as opposed to people owe in us money. Once again we've got the pie chart down below which is nice but it's quite static. Once again it's got this kind of 3d impact which I don't personally like although it's kind of a cool effect because it seems deceptive to me because once again this blue icon which was this vendor looks like it's a lot bigger than it should be when compared to the green one here which is obviously a lot bigger in reality. So it seems when I see something like that I think slimy marketers trying to pull one I'm trying to try to skew my opinion or something but maybe that's just me maybe a little paranoid but there is that now if I look at this and we see how are these calculated. We can go up top and so this is going to be the Perry the vendor balance summary. So this one let's pull out a trusty calculator here and just do a calculation with it. That's what we do with calculators do some calculation. Pull that thing out this is Perry we're going to say this is going to be the 6705 divided by the total of 26636.92 moving the decimal two places over 25.17. So we're going to say okay does that tie out here 25.17 there it is. Now note that if you put this graph because it's nice and colorful into a presentation you give it to someone in the month in summary or something then they might actually ask you what it means. So you got to have you got to be able to say okay yeah that's my that's who we owe the money to that's the percentage that we owe in comparison basically to the total down here. This report up top represents the aging report so you could find that by going to the reports drop down. You can go to the vendor and payable AP aging as of 123124 and so there we have it so we owe like if we look at the percentages here. This one is 3459.2 of the total 26636.92 about 1213% or so. And so you can see this this it's in thousands here but that's basically the concept or the idea of that one. Now again you can't do much more for this so it's a nice graph but you can't change the colors you can't do much more other than this. I can't change the fact that we have 10 vendors represented what if I want less or more what if I want the pies to be larger by having less vendors and more in this other category or less can't do much about it because it is what it is. So it's a lot more flexible to be able to export this stuff to Excel note that if you did want to present this to somebody you could of course print it and you could print it as a PDF file which to a PDF printer which could save it as a PDF which could be useful if you want to group it with other reports for example. You could also open up any Microsoft program like like this is this is PowerPoint and you might do some screen clippings right you can you snip it as a screen clipper or you can use the Microsoft program image screenshot and then I'm going to take a clipping and you might just say well maybe I just want like the pie chart here. And then maybe you don't maybe you don't need the title so once again the screen clipping little formatting I can go up top and say let's crop this down to here. Let's make it a little bit larger so I could see it for now let's remove in the picture formatting remove the background. So now all the stuff in pinks what's going to be removed I want to keep this stuff I want to keep this stuff so don't remove that that stuff's important PowerPoint. Can't you tell can't you tell the important stuff so something like that. And then you can then of course you can copy the key over insert and you can say let's put the key in to so like that. That's one way that you can easily kind of put this together in you know whatever format you're presenting this to somebody. You can copy that over in Excel or something if you're making an Excel worksheet to put all your reports on one report. That's one easy way to put this pictorial thing in there next time though we'll we'll try to take the report which is going to be the vendor balance summary which is going to be easier to do. Then it was with the accounts receivable because we don't have the problem of jobs here we don't have those sub accounts so I could just export this really easily and then just make this into a pie chart. And so we'll do that next time because like I say that would be give you way more flexibility to do what you want to customize the colors that you want in the pie chart. And to customize you know to look and feel of it to not make it look deceptive with this 3D kind of stuff and so on which again it's not my I just. But you know it's kind of cool at the same time not trying to put it down or anything unless they're trying to deceive with it if they're not trying to deceive with it then you know whatever it's a cool effect but so. So we'll do that next time.