 QuickBooks Online 2023, transaction list by date report. Get ready to start moving on up with QuickBooks Online. We're gonna be using the free QuickBooks Online test drive searching in our online search engine for QuickBooks Online test drive, selecting the option that has into it.com and the URL into it being the owner of QuickBooks. We're gonna be picking the United States version of the software and verifying that we're not a robot. Zooming in by holding down control up on the scroll wheel currently at the 125% zoom in. Hit the cog dropdown to note that we're in the accountant view as opposed to the business view. We'll try to toggle back and forth between the two views so we can see where stuff's at in both of them. Right-clicking on the tab up top to duplicate the tab as we do every time, right-clicking the duplicated tab to duplicate it again back to the tab to the middle. We're going down to the reports on the left. We wanna be picking up that balance sheet standard report as that's thinking, tab to the right and reports on the left once again, this time the P to the L, the profit to the loss, the income statement, close up the hamburger, otherwise known as the hamburger, and do the range change from a one, a one, two, two, tab 1231, two, two, tab, run it to refresh it, tab it to the middle, close up the boogie, scroll up, range to the change from a one, a one, two, two, tab, 1231, two, two, tab, and run it. That's the setup process we do every time gets us in the mood for accounting stuff. 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. So we've got our two major reports, the balance sheet, the income statement, most other reports giving us more information on one or multiple line items within it. We're now gonna go to the tab to the right, right click on it and duplicate again to open up other reports, this time being the transaction list report. So we're gonna go to the reports on the left and close up the hamburger. I'm gonna scroll down a little bit, zoom it down to 150 and we're gonna go back down to those accountant reports and focus some more on some of the specific reports in here. Now we talked about the general ledger report which kind of breaks everything out by account and then date within it. In a prior presentation, that's the traditional detail report, kind of like a transaction detail report. We also have something similar over here, which is the transaction detail by account, breaking out the detail, the activity that has happened by account, but oftentimes or sometimes it could be useful to break out the entire, all the transactions not by account, but rather by date. And for that we have these two reports, the transaction list by date and transaction list with splits by date. So I wanna go into these two in a little bit more detail and we can practice basically sorting around and how we might use these two reports. So I'm gonna open this one up first, right clicking, duplicating this report and then we're gonna then go to the tab to the right, change the range from 010122 tab, 123122 tab, run it, close up the hand boogie. Now this report isn't really giving us more line item on one, isn't giving us more information on one line item of the financial statements, balance sheet income statement, but rather is giving us a detail on the whole construction of the balance sheet and the income statement. So you'll recall that if I look at the balance sheet, so for example, I'm gonna run a comparative balance sheet up top for November and December. So I'm gonna set the date for just the month of December here, which will be 120122. And then I'm gonna compare that to the prior period, which will be November, previous period, and then the change in the dollar change and run it. Now if I look at this, the November, this is where we stood as of the end of November. This is where we stand as of the point in time, December 31st. The difference between the two is the change. That's actually the activity that happened. Now, if I wanna look at more detail in terms of this change item here, I can look at it on an account by account basis, drilling down on the account or looking at, in essence, a general legend, ledger, a transaction detail, or I can try to look at that by transaction, which is basically what we're doing here. So in other words, if I was to run this report just for the month of December from 120122 to 1231, then this is the activity on date and actual form that is showing the change. That is making up this change, getting us from the November 30th point in time to the December 31st point in time. So that could be a useful report for multiple things. It's great for reviewing. So if you're in a teaching situation, this will be helpful for us because we'll be able to work a practice problem. And we could say, okay, if we started at this point and then we have all this data input that hasn't been input the same, then we have to end at the same end point. So if you're trying to review something like in a practice problem, you could check your balance sheet, your income statement or your trial balance. If something is off, then you can look at this detailed report and say, okay, if something is on this detail report and it's not on my side, then the question is, what's the problem? How is that the case? Was it a timing issue? That's often the issue. You wanna change the date range then and see if it's a date range problem and then change the date range. And then if it's on your side, but it's not on this side, then the question is, well, what happened there? Did you duplicate something or has something been input incorrectly? So that's one use for it. In a school setting, similar situation would be in a review type of situation when you're a supervisor and you're trying to review the work that has been done by staff, for example. Then again, you can run this report and get a quick look at the types of data input they have been putting in place. And you can see the number of transactions that they've put in place. And you can also see the types, what are they using to put those transactions in place in a nice quick format. So that's a nice useful tool for it as well. From a billing perspective, this could be a useful way to kind of get away from the billing of just billing hourly. So if you're a bookkeeper and you're saying, hey, I bill hourly on it, maybe you can come up with some other billing structure that's a bit more concrete because sometimes hourly billing can be tedious on our side to figure out the number of hours. And it can also be kind of tedious on the client side because it's somewhat ambiguous in terms it's not really concrete number of hours that how productive you were during those number of hours. Sometimes that's the only way to do it. But if you could set up a system where you have, say, monthly billing based on the number of transactions, that's another method that you can do. You can get more detailed than that. You might say, if you're within this range of transactions, if I did over anywhere from 50 to 100 transactions, I bill you this much. If I go from 100 to 200, I bill you this much. And so on and so forth. That could be a little bit more concrete and you can actually provide the client with this information as verification, concrete evidence of the information that you've put into the system. You can actually count these transactions quite easily as well because you can export this to Excel and just run account formula to count the number of lines that are in the transactions. So that can help you to verify the number of transactions that have taken place pretty easily. You might say, well, then I've gotta go in here and count everything. Well, you can export it to Excel. Let's just to show that I can say, let's go and export it to Excel and we'll just count it up. So I'm gonna open up this item here and then once it's in Excel, I can enable the editing and then I'm gonna make this a little larger. And so then you could do some kind of count. I count formula and say this equals count and you could get a little bit more detail on the count ifs, if there's something in it or something, but if you just said count the number of items, I could go up here and count the number of items and then there's 75 on the items and or you can obviously look at the line items here, 86, you're at line 86 and then it starts at line six. Now, again, that's not perfect because you got some split items here. So you could try to think about how you would deal with these kind of split items and whatnot and you can use different count if formulas to do that, but you wouldn't have to go in here and physically count one at a time if you could export them to Excel is the general idea. Now, also, this is a great report to kind of filter on so you can go into here and try to filter by all of your transactions. This is kind of similar if I go to the first tab and I go to the expenses tab and I go to my expenses tab up top where you have this filtering by all of the account types, but these are only in the vendor, kind of the vendor side of things cycle and then you can do the same thing on the sales side of things and you could sort by all the types of transactions that are on the sales cycle. So you could do a similar thing over here except you've got all of your transactions and you could sort by the transaction types, which is a quite common filtering technique. So if I wanted to go over here and say customize, it would be quite common to go to the filtering on this report and search by the transaction type. So possibly you want the bills, for example, we can say the bill items and then maybe the bill payments. Maybe we want those items for whatever reason. Now you've got your filtering options that can break that down. So this is a really nice report to practice with those filtering items. You might want to be focusing in on a certain transaction for whatever reason and use that type of report. Okay, let's open up the other one. I'm gonna go back to the, I'm gonna leave that one there, go back to the tab to the left and open the transaction list with splits. So this is a neat report too, giving you more detail. Now you see, I'm gonna go back to the tab to the right, the problem with this report. I'm gonna customize and get rid of the filter that I put on there. So I'm gonna unfilter it. And so there we go, let's just unclick this. What am I doing? Run it. Okay, so just a quick look. Notice we've got the date on the left-hand side. We've got the transaction type. We've got the number. We've got the posting name, if applicable. Another area, typically these are employees, vendors and customers. Memo, if we have a memo and then the other account or the account impacted and then the split. These two are showing the double entry accounting system, meaning this bill, for example, had an impact on accounts payable and the other side is in miscellaneous. So if I went to the balance sheet and I drilled down to the transaction detail in accounts payable, I would find this. If I went to miscellaneous expense on the income statement, I would find it. However, you've got these split items down here where it's not giving you the transaction because multiple transactions are being impacted instead of just two and therefore you end up with a split. So it doesn't give you all the data that you would like. You'd have to drill down on the form itself to get the further data. But if you go to the detailed one over here then, then it's gonna give you the detail. So now I'm gonna go from 010122 to 123122 and run it. So now it's a bit longer of a report. It's not in journal entry format. You're not talking debits and credits, but you no longer have that split where it's kind of hiding data. So if you get to a more complex transaction like this one, you can see all the activity within the transaction. So like these invoices are more complex transactions. So this gives you kind of like that journal report, all the detail within it, but it's a little bit more compact than the journal report and you're not using the debits and credits so you can see the impact on all the accounts. This is also a good one that you might construct your billing on because now you might say, hey look, I'm not gonna make my billing structure based on just how many transactions maybe. Maybe I'm gonna say if you're within these many accounts that were impacted because it's more complex if you're in a construction company to make an invoice that has all this stuff going on as opposed to an invoice that you make for a service company that just sells one thing or one line item. And it's more complex to do a payroll transaction, for example, that has a bunch of stuff going on. So maybe you create your billing structure and say, I'm not gonna say bill you with, if you're within 100 transactions, but if you're within 100 accounts that are impacted, within that range, I'd bill you so much. And if you're within whatever other range, I'd bill you so much. It's another way that you might be able to construct a concrete, verifiable kind of structure for your billing to make it a little bit easier on you instead of having the ambiguous kind of hour thing and possibly still be able to provide something concrete. You can, of course, still export this to Excel and count the number of lines. You might have to use a count if kind of formula if there's something in the line or something like that. But that's another option. So those are nice reports. And then you also have the transaction or the journal report will go into a little bit later, which is a similar kind of report as well. All right, so I'm gonna open up the hamburger. I'm gonna go to the left, open up the hamburger, go to the cog dropdown, switch to the business view, just to see where stuff's located in it. And we know that the homepage is now called the get things done page. No slacking off at home for us. We're at the home basis, get things done place. And then we've got the reports are located here. And then we also went into the get paid and paid area. That's where the customer and vendor information is. But I touched on those transaction items which are actually in the bookkeeping area. And that's a little bit different than the other view. This is where the sales transactions and expenses are side by side instead of in like their respective vendor cycles there. So there are those items.