QuickBooks Desktop 2023 accounts receivable graphs. Let’s do it with Intuit QuickBooks Desktop 2023. Here we are in QuickBooks Desktop sample Rockcastle construction practice file provided by
QuickBooks going through the setup process we do every time maximizing the homepage to the gray area view drop down, notice that we got the hide icon bar and open windows checked off.
We got open windows open on the left, reports drop down company and financial let’s take a look at the profit and loss Income Statement change that range a 101 to four to 1231 to four January to December customizing it so we can go to the fonts changing it to 12.
Okay, yes. Okay. Reports one more time, ooh, no vase boss, not the profit loss, but the balance sheet. And then we’ll hit the drop down.
Again, we’re looking for this fiscal year this time, and then we’re gonna go to the Customize reports, fonts and numbers change the font to 12. Okay, yes. Okay. That’s what we’ve been doing every time opening up the major to financial statement reports.
All other reports pretty much are giving some kind of information adding to one or multiple line items on the major two financial statement reports that we have here.
This time, we’re going to look at some graphs, and we’re going to specifically look at graphs that are going to be supporting backing up the accounts receivable account,
you’ll recall, the accounts receivable account represents money that is owed to us for services or goods that we provided customers owing us money, the accounts receivable goes up.
If I go back to the homepage, with an invoice which you would only use if you’re using an accrual basis rather than a cash basis accounts receivable being a record accrual account.
So if I go back over here, and then it goes down when we when we receive the payment. So we can find these reports by going into the reports drop down,
you would think it would be under the customers and receivables. And we’ve got this nice little receivable graph here, we can also find it by going to the Report Center up top. Let’s do that now the Report Center will maximize that to the gray area, we’ll go to the customers and receivables and there is the graph.
Let’s open that up. Now notice for internal use when you’re doing the actual you know bookkeeping process and trying to collect on the receivables, this might not be the most useful tool for that purpose because you’ll probably be working there within the Customer Center and so on and running other reports like an AR Aging report.
However, if you are providing this information externally, possibly as a bookkeeper monthly to the owner or possibly in, in accounting department, you might want the pictorial representations to graphs can be nice to be adding.
So they give you this nice little custom graph here. Also note that you could make graphs like this, which we will do in a future presentation with some of the sub ledger reports. So we will take a look at that in the future.
Okay, so we have up top we’ve got the date, we got the print, we’ve got the refresh, they give you two things here we’ve got the basically the aging graph up top, and then we’ve got the pie chart and that’s broken out by who owes us the money, the customers in essence, let’s change the date up top, we can change the date and make it as of 1231 to four.
So it’s as of a point in time report instead of a range report because it’s supporting a balance sheet line item scene or giving us a pictorial representation of where we stand at a certain point in time. So So then let’s go ahead and see this is the 98 105 19.
If I go back to the balance sheet, there’s the the 98 105 19. The subsidiary report to this would be if we go to the reports drop down and we go to customers and receivables.
Let’s take a look at the customer Balance Summary, customer Balance Summary Report. And we’ll make this well we’ll keep it there’s as of today let’s make it from a 101
to four to 1231 to four. So there we have it and now this is let’s go ahead and customize this fonts and numbers. Bring it up to 12 so we can see it a little bit more clearly.
Okay, so now we’ve got this broken out by customer so it’s a little bit more complicated because we have the sub customers
here so you’ve got some dropdowns which you might not have so much if you didn’t have like this particular company being a job cost company with the with the sub customers or jobs. But we can see the total down here 98 105 19
Okay, we can see that should tie out to the balance sheet that should tie out then to our report with our chart here, what 98 105 15.
And then if we look at some of our larger customers, we’ve got Robert, for example, if I go to Robert,
and we’re say, we’ve got enough I do the ratio, this is how we’re calculating this, we’re doing a ratio calculation, we’re taking the total, which is equal to the 14510 divided by the total down here divided by the 9810 5.19. And that’s going to give us our 14.7.
About, we go back to our chart, there’s where we get the 14.79 about percent if we move the decimal two places over. So clearly, the charts can be nice pictorially to be providing, if you are doing a presentation, especially if you’re doing a presentation.
And or if you’re giving this chart to someone as part of the package that you’re giving them on a monthly basis or something like that. You do, of course want to be ready for someone to say, well, that’s a nice colorful pie chart.
What does it mean, right. And of course, what it means is, we’re we’re basically taking that report here, and we’re breaking down the largest customers who owes us the most amount of the accounts receivable, notice,
I believe they use like 10 1-234-567-8910, and then everything else, they just don’t enter the other category down below.
So we’re taking a pie chart, which has taken our top 10 people that owe us money in accounts receivable, taking the ratio of how much they owe as compared to the total. And then everything else above that 10 has been grouped together in the other category.
So in future presentations, we’ll actually make this report from this by exporting it to Excel, and then making the graph in Excel.
The benefit of making a graph in Excel is that once you get familiar with doing it, and it’s not too difficult to do any kind of graph that lends itself to a pie chart or any kind of graph,
you can take the source data and just export it to Excel, which is actually a more efficient way to do it’s a little bit more time consuming to do it. But you have a lot more options. To do that.
Notice if I go over here, I can’t adjust, say the format of this pie chart, for example, they’ve got like this 3d Look on the pie chart, I can’t really adjust the colors of it, or make it larger or smaller or anything like that. It is what it is,
it’s fairly nice, it’s really easy to pull up. But you know, we can’t do anything else to it. Notice that the fact that it is a 3d pie chart is kind of a confusing thing. I personally don’t like the 3d pie charts,
because they can be deceptive to me, it makes me feel like someone’s doing some kind of marketing trick. Because it makes like, for example, whatever’s upfront, look larger than this one.
So notice that this pie over here at 14.17 is a lot bigger than the 8.79 of this red slice. But the red slice, because it’s over here is is looking bigger,
and it kind of distorts things. So it looks cool, it’s a nice effect. But if someone’s trying to be manipulative, then they can use this distortion to manipulate the look and feel of the pie chart.
And I don’t like that, because it’s supposed to be something that’s going to give clarity to the picture, not distort the picture.
So So in any case, you can’t really so you can change those kinds of effects, and so on, if you were to export this to Excel.
So then we’ve got this one up top, and that’s going to be the aging report. So if I go to my reports drop down, and we go to
the, the customers and receivables and we look at the accounts receivable aging as of 1231 to four. So now we’ve got the this is the report that breaks out the stuff that’s currently due.
And then the reports that are one to 30 days, 31 to 6061 to 90, and so on and so forth.
And then that’s gonna be a percentage of the total. So for example, most of it is all current in this case. So that charts not that exciting looking. But we have 5000 in the 61 to 90 divided by or compared to 90 810 5.19.
That gives us our point oh five, or 5% that we see over here, that should be about 5% that we see here as compared to everything else being in the current area.
Now if you were to put this in a presentation of course you can print this chart out, so you can go to the printing options up here. And notice it doesn’t give you the printing as a PDF option. But you could save it as a PDF using the cute PDF printer, which remember is a free tool.
Some PDF printer can allow you to use the printing option to print it as a PDF or make it a PDF using the printing tool. I believe you can do We’ll go cute PDF printer, we’re not affiliated with them. And, and you can get a PDF printer and be able to print it that way.
Another way you might do it in a presentation is you might as you might take like a, a slide that you want to put this information on, you can go to Insert up top in insert in any kind of Microsoft,
Microsoft program Microsoft Office that is, and then I want to take a screenshot, you can also use screenshot using, you know, word snippet or something like that. But I want to take a clipping of the screen.
So I can take a clipping of the screen. And I might then say, okay, maybe I’m just going to clip this here. And I’ll put that in place. Maybe I don’t even need the title, because maybe I put the title up on the top of the slide. So I could even crop this. So maybe I crop up top, and I remove that.
But hold on a second, undo that I can, I can remove that I can crop that out, maybe I want to get rid of the white background, you could do that. And like this is PowerPoint, you can say remove the background. And then I want to keep like this area. So I’m just going to keep that till it.
Till it which ones you were messed up. Keep that. Keep that. And there it is, is that one kept? I think so. So there it is. So now you’ve got your graph.
There’s one little piece down here. Keep that. So there it is. And then and then I could I could insert the key, then I could say I’m going to go up here. Where was it, my screen is large. So the icons are all a little different screenshot,
we’re going to insert the key. And we can put this over here, boom, on this side, or something like that.
And you could format it however you would like to you could use the quick formatting tools might be useful over here, but you can then format it however you would like to. And that way that’s one way you might kind of easily add it,
you know, into a presentation without having to export it to Excel, or anything like that. You can also do that, or add these graphs to your Excel file, if you so choose, that you can make into a PDF, which we might do at the end of this whole presentation. But it is somewhat limited. It’s a lot limited in terms of a graph.
And it might be better to get used to actually seeing where’s the report, get the report information, export it to
Excel and then be able to make your graphs because that allows you to know how to make the graphs and allows you to adjust the graphs, you can do a whole lot more with the key and the format of the chart and how you want to represent this information.
You could actually just take the percentages over here and type that into Excel. But we’re gonna do that next time we’re gonna go to the to this actual report or one of these reports.
The customer balance report, most likely customer balance report like this one, and we’ll export it to Excel and then we’ll try to create a graph with it. That’ll be great.