QuickBooks Pro Plus desktop 2022 income and expense by month graph, get ready because we bookkeeping pros are moving up the hill top with QuickBooks Pro desktop 2022. Here 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 on the left hand side company drop down home page in the middle, maximize on the home page to the gray area reports drop down looking at the company and financial down on to the balance sheet standard report. We’re then going to be changing the dates and customizing the font in the custom reports.
00:38
Let’s bring that in date out to 1230 123 fonts and the numbers to change in that font to 14 on the font. Okay, yes, please. And okay. Same thing with the P and L as has been our custom company and financial profit and loss changing that in date to 1230 123 Customizing that report by going to the fonts and the numbers change in that font to 14 and okay, yes, please. And okay. So now we’re going to be looking at a graph basically given a breakout of the income and expenses on the income statement or profit and loss. So we’ll take a look at that graph and think about the reports supporting it, and how possibly we can construct the graph using Excel, if we so choose.
01:27
So we go to the reports drop down up top to find this one, it’s in the company and financials area, we’re looking at the income and expense graph. You can also get there, however, which we will do now, by going to the Report Center and the report, center, the reports and then the Report Center. So we’re in the normal area, the top standard tab, the company and financial, then we’re just going to scroll on down until we see a graph, which is hopefully the one we’re looking for here. Scrolling down, there’s our graph the income and expense graph, let’s run it, run that one.
02:00
And so this one’s a little bit more complicated, because you got some different types of options down here, you got the income and expenses, you can toggle back and forth from you got the by account by customer by class options up top, let’s first change the date, we need the date range, which is going to be from a 10123 to 1230 123 and run that report. So that range is going to be necessary to have this information, you know, we got this information up top. And then we’ve got the pie chart given given basically either the income or the expenses.
02:33
So in other words, the income and expenses are provided up top, and the income is in the green the expenses in the kind of reddish red color here. And we could see the key up top here, this information can you might be able to construct something like this by taking the information in essence from the income statement, exporting it from the income statement, and then creating your graph in that format. So for example, if you wanted this, your yearly information, you could go to your Profit and Loss report. And then instead of having a total, you can run this on a month by month basis, so month by month.
03:13
And so whoa, hold on a sec, I’m gonna say, Oh 10123, so January through December, month by month, and then you can pull if you were to export this to Excel, you’re really not looking for the details, you’re just looking for the totals for the for the bottom line items, income and expense line items that you can then possibly use to construct a graph of that nature. Although it might be a little bit more complex than the graphs we’ve looked at before. And then down below, we’ve got our pie chart here, the pie chart being broken out, either toggling back and forth between income and expenses, we’ll start at the income. If we’ve got income by account.
03:53
Now we’re looking at the income by account, which isn’t that interesting, which it may not be for many companies, because we might not have that many income accounts. Because we might only do one or two things on the income account side. This income number if I wanted to look at that number if I went back to the profit and loss here, and we were then to go back and say we want to Cust let’s go back to the totals, seeing the totals, we’ve got the income lines up top, I’m gonna I’m going to toggle this back down. So we’ve got that 449657. So I’m going to take that 44965 7.14
04:30
And then you might have like other income which is on the bottom that’s not part of the normal operations, which it looks like they have here in other income. If I close that one up to other income we’ve got plus the three seven 5.96. And so if we go back on over to our report, we’re looking at that four 5003 310 on this side. So we can also break this out by customer So I can get my customer information. Now this one looks substantially different because we are taking into consideration now the cost of goods sold. So if I went back on over to the profit and loss, and we’re looking at these items, because it’s a job cost system included, because that’s including the customer information, that’s where we get to the, to the gross profit of that 2695 dot 1.81.
05:23
And we can compare that then to over here, we’re at the 2697 65. So we could say minus the 2697 65.96. And that gives us a 147 difference. And that difference, if I go on down here was our income or close to our income line item here. Note that when you go to the customer item, and you sort by customer going back to the report, it is possible or more likely that you’re not going to tie in exactly to what’s on the income statement, because it’s possible to enter something that’s going to be going to an income statement accounts without assigning a customer to it. That’s not the case when you try to compare the subsidiary ledger for the accounts receivable.
06:07
Because generally QuickBooks forces you to use a customer. If you’re going to be assigning something to accounts receivable, it’s possible to assign something to an income account, or much more possible without assigning a customer. And when that happens, your your subsidiary reports, or your supporting reports won’t tie out exactly. So in any case, we got a similar kind of breakout down here with the pie chart now by our customers that we have broken out.
06:33
And then you can also do this by class. So if you have class tracking, we might do a whole nother section, we got courses on class tracking, which can be used for different ways or different uses. So you can break it out by class as well it started over.
06:46
And then you can do the same process by checking off the expense side of things. So same information up top. But now you’ve got your expenses broken out by categories, you got your nice pie chart down here, for the expenses broken out by category.
07:01
This is another item that you could generate yourself, in essence by taking a look at the income statement. And basically exporting this to Excel and get into your major categories, which you could break out to more categories, or you might just use your your sub categories. In other words, by collapse these items there, you got your nice expenses.
07:20
And you can basically break out your expenses by category creating a pie chart. In that way. If you wanted to do that fairly easily, I would think as well. We won’t go through it. But you could you could check that out. And then you could see this by customers not going to give you much much information because we’re on the expensive side of things which aren’t having customers assigned to it.
07:40
So and then you can have the expenses by class which again could be useful depending on how you’re going to be using the class tracking. If at all class tracking is a specialized thing that you’d have to turn on that you might want to use in certain instances.