 QuickBooks Online 2022, Sales by Customer and Income by Customer, reports. Get ready because it's go time with QuickBooks Online 2022. Online in our browser, searching for QuickBooks Online, Test Drive, going into the Test Drive, looking for the United States version of it and verifying that we're not a robot. Sample company, Craig's Design and Landscaping Services holding control, scrolling up just a bit to get to that one, two, five percent. We're also going to be having open the free 30-day trial version just so we can take a look at the business view, comparing it to the accounting view. If you don't have access to this at this time, that's okay. We're just using it as a reference for now. Back to the sample company, we're going to be opening up a few tabs to put reports in, go into the tab up top, right-click it on that tab, duplicating it. Back to the tab to the left, right-clicking on it and duplicating it one more time. Let's do it again. Tab to the left, right-clicking on it, duplicate a duplicated time. Now we're going to go back to the 30-day trial version just to look at where the reports are located and the business view, which happens to be in the Business Overview section. And then the reports, if you were to go to change it to the accounting view, what you can do by going to the cog dropdown and going down to switch to the accounting view, you would have the accounting view similar to the view we're looking at in the sample company, over here in the sample company. We have now the second tab open. Let's go down to the reports and start opening up our favorite financial statement reports, starting with the balance shape. Going up top, closing the hamburger, range change, 010121212, 3121, run it. And then we're going to go to the tab to the right, open up the second favorite report, the financial statement report, the profit and loss. And scrolling up, range changing on it, 010121212, 3121, running that report, closing up the hamburger. Let's go back to the tab. Actually, we'll stay here on the profit and loss. Now we're going to look at a report that's going to be complimenting or giving a little bit more added information with regards to the income line items up top in the profit and loss. You'll recall, when we went over the profit and loss in the income statement, there's two major components to it. You could break it down to a single step income statement, which would just be revenue or income and expenses. And we said that on the income side, although there's a whole lot of accounts included in this company file, usually you only want a few different income line items outlining what it is that you sell so that you have a fairly condensed income statement and then you can break out the more detail in some subsidiary type of reports. So for example, people often have a bit of a problem with wanting to make an income line item for their large customers, meaning I'm going to make an income line item for Adam Smith and Erica something and whatever for the different income accounts. You don't typically want to do that because you want to just have the income account related to the general thing that you're getting the income for. And then if you want to break out that added information, use another report, which can break out the income by customer. The other problem people often have is to break out too many subcategories of their income accounts by what it is they sell. This is an income account for this one, product A, product B, product C, service one, service two. Don't typically want to do that either. You typically want to have the general large categories of the things that you're selling and then get that more refined detail by having the subreports that are going to give you a bit more detail about them. So keeping that in mind, let's take a look at some of these subreports, go into the tab to the right to do so. We're going to go down to the reports once again on the left-hand side, closing up the hamburger. And I'm going to scroll down, hold control, scroll down to get a little perception. I can see a little bit more here. And we're scrolling down to the sales and customers section. So they got a lot of stuff in here. Some of it may not be completely applicable to this category, but they kind of dumped some stuff in here. But most of the stuff is going to be related to sales, revenue line item, income on the income statement. And of course we sell stuff to customers. Although when you hear customers, you also think of kind of like that accounts receivable line item, which could be tied to the same transaction, the invoice, although the sales could also go up with the sales receipt. In other words, if I hit this plus item up top, we would expect these accounts or the sales account to be going up with an invoice or a sales receipt. So the two forms that QuickBooks want you to use when recording sales because they're going to be driven by the input of the products and services that we set up or looked at or thought about in prior presentations. And that's going to allow you to get the information and the sub reports you need. If, however, you have a system, for example, where you're just using bank feeds to create your books, you might use the deposit form in order to create your sales line. Every time you have a deposit, you record an increase to the check and account, the other side go into income. If you do that, however, you're going to lose some of the detail of these sub reports, breaking out the information by customer, breaking out the information by item, because those sub reports are dependent upon, generally, the sales forms of either the invoice or the sales receipt. So even if you're on a cash basis, if you're going to use the full effects of QuickBooks or more detail on the reporting, you would want to use the sales receipts. Okay, so let's go back in here and close up the hamburger. We've got the customer contact list, which isn't really a report form, it's just a contact list. We've got the deposit detail, which is kind of like a balance sheet type of item, but we would expect the end result of the sales to be deposited into the bank accounts, so that's why they might put that in here. The estimates and progress invoicing, that's going to be a specialized type of report. If you have progress billing related to it, same with the estimates by customer, if you're in the type of industry that has estimates and estimates are not something that's going to generally be on the income statement, but something that we might want to track anyways. And then we've got the income by customer summary. This is where we're going to be focused here. And then the inventory valuation detail, that's kind of like a balance sheet account, but they put it in here possibly because it's related to customers that ultimately sell the inventory to the customers. The inventory valuation summary, the payment method list, which is kind of a detailed kind of item instead of a financial reporting item on our payment methods. The physical inventory worksheet, again they put the inventory information in here. Product slash service list, so this is again just kind of a list, not really part of the financial statements of what we do and the invoices or sort of the inventory that we provide and the products we provide. And then we've got the sales by customer detail. Another report we'll take a look at, sales by customer. Notice that that looks really similar to the report that we just saw over here, which was income by customer. So we've got income by customer and sales by customer. They're slightly different, but they're quite similar in nature. Sales by customer summary, sales by customer type, so you could break it into detail on the type of customer. And then the sales by products and services. We'll take a look at that in future presentation, breaking it out by the things that we do now. And then they got the summary and the detail, time activities by customer, and transaction list by customer, and then transaction list by tag group. So we're going to be focusing in here on the income by customer. So the income by customer summary. Let's take a look at that first. So opening that one up and we'll pull up our timing. This is an income statement report. So you need a beginning and ending date as opposed to a balance sheet type of report. So it's 010121, 123121 and run. And then I'm going to hold control down, scroll up just a bit. And so now we've got our customers, but now we're not looking at what the customers owe us, but the income we've got from the customers, as we can see here. Now note what you got two lines. So you got the income line and the expense line. And the expense line is showing some of the activity that was regarded to the customer as well. In this case, the cost of goods sold. So when we sell inventory that we're tracking on a perpetual inventory system, you're going to get that cost of goods sold line, which is one of the differentiating factors here between the other income by customer or sales by customer type of report. The bottom line adding up to the 10, 280.05. If I go back to the income statement and go down to the bottom line of the income, we've got the 10, 277. So we've got a slightly different amount on the income line, 10, 280 versus the 10, 277. Now note these reports that are going to be subsidiary reports to the income line are not always going to be able to line up quite as exactly or there are more things in other words that can cause them not to line up, not to exactly match the amount on the balance sheet. More so, or the income statement, more so than we saw with the sub ledgers. If I jump over to the balance sheet for accounts receivable and the accounts payable, you'll recall that I said that with accounts receivable and accounts payable, the QuickBooks system forces you basically every time you post something to accounts receivable and accounts payable to choose a customer and a vendor depending on if it's a receivable or payable so that the sub ledgers will tie out. And for the income line items, that's not the case because it's quite possible that we enter something that we do not use the proper form for. So in other words, if I go back on over here and hit the plus button, usually we want to use an invoice form and we want to use a sales receipt form but it's quite possible, for example, for us to use a deposit form in which case we might have, we're going to mess up our sub ledgers. The sub ledger is not going to tie out to the actual general ledger and we might have adjusting journal entries as well that can cause that distinction or that difference. All right, let's go back on over. I'm going to right click. I'm going to open up another tab. Let's duplicate this tab and open it up somewhere else down here. It's thinking a long time so we're going to go down to the reports. There's too much ashen. My computer's old. I'm getting a new one I think but this one's holding out. It's doing okay. It's hanging in there. It's holding together. It'll hold together. So we're going to say this is going to be the income by customer. So now we've got the sales by customer. Let's take a look at the sales by customer summary and range change it once again to let's make this from 01.01.21 to 12.31.21 and run it. So there we have that and now we're looking at the sales. We just got the one line item and this is by customer. So it's supporting the income statement line item. It ties out to that 10.280.05 which we saw here. I believe 10.280.05 which is slightly different than what is on the balance sheet for the total income for that same time range which is 10.200 and I'm not going to try to dig down to find why don't you find the difference? No, I'm not going to do it. I'm tempted though. What's the difference? I want to know. I need to know. No, I don't need to know. So any case let's open up one more. Let's find the detail one. Report information and let's close this item up again. Scrolling down. I'm going to hold control. Scroll down just a bit and let's find the sales by customer detail this time. Run that one for the period of 0101.21 to 12.31.21 and run that report. So now we've got the information of our customers and we've got the detail related to those customers as well. So that's another way that we can see this information. Now of course you can get some of this information as well for internal use. If I go back to the first tab and I was to go to my sales area kind of like the customer center information and if I went into like my all sales area and closed up the hamburger we can try to filter this item by for example the sales type of transactions like the invoices or the sales receipts and so on. So I could say invoices and then check out that information all of them so we can get some of this information over here although those reports give us the more condensed more information and they also give us basically the totals at the bottom that we can kind of match out or at least try to match out to the income statement. We can also of course go into the customers here and we can sort information for individual customers and drill down into a particular customer to see the detail for that particular customer and we could do some filtering for the particular customer as well. Also note that we'll look at in future presentations possibly how you can use some of these reports here to make you know graphs and stuff with you might export some of this data and want to put it together for more extended use to drill down a little bit further on the data and possibly to make some visuals such as graphs and so on we might look at in future presentations.