 QuickBooks Online 2022, transaction list by date report. 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, then 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. Scroll it up just a bit to get to that one, two, five percent. We're also going to have the free 30-day trial version open just so we can look at the business view, comparing it to the accounting view. If you don't have access to it, that's okay. We're just using it for reference at this time. Going back to the sample company, opening up a few tabs that we can put some reports into. Going to the tab up top, right-clicking on it and duplicating the tab. Back to the tab to the left, right-clicking on it and duplicating the tab. Duplicating the duplication process, a duplicated time by right-clicking on the tab and duplicating the tab. As those are thinking, we're going to jump back on over to our online view or the free 30-day trial version so we can look at the business view and where the reports are located, which is in the business overview section in the reports. If you were to change to the accounting view, which you can do by hitting the cog dropdown up top, changing to the accounting view, you would be in the view we're looking at in the sample company back to it to see it. We're in the second tab up top. Now we're in the accounting view going down to the reports located here in the accounting view, closing up the hamburger, going into our favorite balance sheet report, the FAVE. It's my FAVE. We're going to go up top and range change it from 010121 to 123121 and run it. I was running. Next tab on over going down to the reports again. This time the income statement, profit and loss, P to the L, closing up the hamburger, ranging to the changing 012121 to 123121 and run that one too. Now we're going to go to the tab on the right. We're going to go into the reports again. This is where the new stuff happened. This is the magic stuff or the new interesting stuff. We're going to go all the way down to the accounting reports down below to get to that transaction list by date report all the way down to these accounting reports way down below for my accountant. And we're looking at the transaction by date, not by account, but by date report. This is a really nice report for a couple different reasons or a couple different uses. You can use it, for example, if you're a supervisor or something like that to kind of check on the work that someone has done. And it'll give you kind of the detail of what has been done. You could also use it if you're an instructor to check on the work that someone has done. You may also use it for a billing kind of purposes because you might try to say as a bookkeeper or accountant that I want to basically set up my billing structure so that I am not trying to count my hours per se or count the hours of my staff, but rather trying to say I'm going to give you a set price based on how many transactions that I provide for you if you fall into this set of transactions. This is how much I'm going to bill you and I can give you a list of the transactions and things can be a little bit more concrete, possibly easier in some cases under that type of structure. For that kind of report, this is a good report to use or the journal report, which could actually give you more detail breaking everything out by the accounts that are impacted and possibly you can make your range of billing based on the number of accounts that are impacted. That's another structure you could try or think about using. But we'll look at that report next time. First, let's look at the transaction list by date report going into it. Let's change the date range up top from 010121 to 123121 and run it. So now we've got all the transactions listed by date. You might say this looks similar to a transaction list report, but I drill down onto an account, but it's different because it's not particular to a particular account. It's not a general ledger account. It's all the transactions by date. So in other words, if I went to my balance sheet account and I was to say, let's drill down onto the checking account, it looks similar because now you've got a transaction report, but this is the detail for that particular account, which is kind of like a general ledger account because it's given me the transactions by date, but only with relation to the checking account. Whereas this report is giving us the transaction by date for all of the activity. So this is all of the activity that is constructing basically the balance sheet and the income statement, but it's not been organized into the balance sheet and the income statement. It's just organized by date and then the balance sheet and the income statement are of course taking this information and constructing it into the balance sheet and the income statement by account. So what we got here is we got the date on the left hand side. We can have it by date. We got the transaction type. These are going to be the forms. So if I hit the plus button over here, these are going to be the types of forms that are used to create the financial transactions. Then close it up the hamburger. We got the numbers, which would be check numbers, you know, numbers of the form numbers and those types of reference numbers here. Posting, if it's been posting or not, we've got the name, which could be the customer name or the vendor name, typically most common, possibly employee name. The memo, if we had added the memo, it would be here. The account is going to be here and then they've got the split account. So if there's only two accounts impacted, this is a great report because you get to see, you know, the two accounts that are going to be impacted. You can then go and look in the financial statements. I could find this deposit by checking the checking account, drilling down on the checking account, and I'll see this deposit on 8-7 if I wanted to. Let's try it on 8-7. If I drill down on the checking account, which I already did, 8-7, there's the deposit. Told you. Told you we could find it there. I knew it. Anyway, going back on over. So then, so that's nice, but if there's more than two accounts affected, then you've got the split item over here. So it's not quite as detailed. That's what the split means. It means there's more than two accounts affected. So the second account is going to be split between the two. So this will give you basically all the activity that has happened, all the types of transactions, deposits, bills, invoice, and so on and so forth, the checks, the expense type of forms, the credit memo we saw there, and so on. And you can also go into this type of report for various reasons, and you might want to try to search for particular items. You might want to say, I want to pull up all the data and search for a particular item. And again, one of the most common ways to search is by transaction type. So you might go into here and say, this is a great one to practice your filter options with. Go up top and say, let's customize and do some filtering, filtering. And you often filter by the transaction type, transaction type filter. And I could then select a couple of filtering kind of things like an invoice possibly. And let's do an invoice and then do also a sales receipt and voices and sales receipts and run it running. And so there we have, so now we've got that filtering option in place. So you can do a bunch of different filtering options in this report. Good practice to practice your filtering options. Notice that some of this, if I wanted to see this kind of filter with the invoice and the sales receipt, I could go to the first tab into the sales area, which is kind of like the customer center. And then go into the all transactions because these are transactions that are involved in the sales type of thing and look up those particular transactions as well. So you could go into the invoices here and I have to do one at a time here. So I could do multiple filters on the other side. But that's another place you can go here. Over here, of course, I could filter by multiple different things and filter that stuff out. You can remove the filter by clicking here to remove the filter. You can also remove the filter by going into the customize area and of course adjusting the filters within there as well. So we'll be taking a look at this report more when we enter the data into the system for our practice problem. And at the end of each section, we'll take a look at this form. And that will be the form that you can kind of use to check your numbers to try to see if you line up, meaning if we were at the same starting point and all of these transactions lined up, we should be at the same ending point. That's why it's a great form for review purposes. It's a great form for teaching purposes and whatnot. If you're following along with a practice problem where you're trying to see how much a client did and it could be a good form for billing because I could try to count these transactions and determine a billing rate based on number of transactions and you could, you might say, well, how am I going to count all this? A lot of transactions. You could export this to Excel and just use a nice quick count feature to see how many transactions there are and then base it off of that. So it's a pretty fast process that could speed up your billing time.