 QuickBooks Desktop 2023. Transaction list by date report. Let's do it within two weeks. QuickBooks Desktop 2023. 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 then 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. QuickBooks Desktop Sample Rock Castle construction practice file provided by QuickBooks going through the setup process we do every time maximize in the home page to the gray area going to the view drop-down noting we got the hide icon bar and open windows list check off the open windows open on the left hand side reports drop-down company financial P&L profit loss range into the change in 010124123124 January to December 224 customize the report with the fonts the numbers so we can change it to 12 okay yes that's okay okay so reports drop-down again company financial this time the big balance sheet changing with the drop-down we're going to go to the fiscal year customize it fonts and numbers change it 12 okay yes okay you did that way fast that's because the setup process we do every time that's what we do every time we got the balance sheet the income statement or profit and loss open those being the major two financial statement reports all other reports pretty much are going to be giving us more detail about one or multiple line items on the major financial statement reports balance sheet income statement reports this time we're going to be taking a look at a transaction by account report that's going to be our main focus now note that if you look at any account say on the balance sheet and the income statement and we wanted to drill down on it as we've seen multiple times using the zoom feature double clicking on the checking account for example we get this transaction by account report which is in essence kind of like a general ledger type of report it's giving us the transactions that have been in order or are in order by date of the transaction and the impact on the balance and it gives us more detail than that to it gives us the kind of forms that were impacted the name the memo and so on and so forth so this is a report that can be very filterable we can basically filter it by type and so on the transaction by account will look similar in nature but it's going to be showing it not just the transactions in the checking account or whatever account we drill down on but all transactions entered by date so let's close this back out and check that out we can find it a few different ways we can go to the accounting drop down it's under the account and taxes we got the transaction detail by account up top that's not the one we want we want the transaction detail by date down here we could also find that in the report center so let's go up to the report center and we're going to go down into the accounting and taxes I'm going to maximize the report center to the gray area so we might go into some more other reports down here but we're not going to go into basically all of them let's just give a quick recap of some of those reports we got the trial balance that's basically the balance sheet on top of the income statement we might take a look at that in a bit more detail but in essence it's it's a balance sheet on top of the income statement showing the debits and credits one of the reasons that they put reports down in the accounting and taxes is when those reports have debits and credits displayed in them because oftentimes quick books is trying to give the end result without debits and credits do things with a plus and minus format but if you're trying to learn the debits and credits these reports can be great and even if you don't understand debits and credits that trial balance can still be quite useful we might look at that more detail in the future we got the general ledger which is going to be kind of like the transaction detail report when we use the zoom feature that we just saw for a cash account for example but basically for all the accounts it will then be in order by the account same order as the trial balance balance sheet on top of the income statement in essence but showing us the detail we got this transaction detailed by account so this is going to give us that detail report again but it's going to give us by account it's quite similar to the general ledger but the general ledger has those debits and credits column and this is it's formatted this one has the debits and credits column so it's quite similar in nature of our report but that's not the one we're going to focus in on because we want the transactions by date we've got the journal report we'll talk about possibly later as well this is a great report because it shows you the debits and credits on a journal of transaction by transaction basis not just for those that we entered journal entries for but all transactions because all impacts on the financial statements balance sheet and income statement can be thought of in terms of the double entry accounting system as a journal entry debits and credits we'll get to that later we've got the audit trail report we've got the voided deleted transactions summary so it could help us out for deleted transactions voided deleted transactions detail transaction list by date now this is the one that we're going to focus in on here which is going to give us all those transactions but not by account but instead by date and then you've got your lists down before below you've got the account lists which is basically a more of an information report kind of giving you the accounts fixed asset lists for those property plants and equipment income tax income tax preparation income tax summary income tax detail these will be important if you're focusing in on the income tax format meaning every account you set up you add an income tax line item which sounds really good in theory but I haven't seen it really used effectively in practice because in theory you could basically use that income tax thing and possibly assign all the accounts to an income tax account and then if you get the right software possibly even export it to the tax software but I haven't seen this work completely cleanly and whenever you do tax adjustments it's often easier to just do those adjustments like in Excel or something like that so in my experience it's still usually people have to basically just take the income statement on its on its basis in QuickBooks and then export it to Excel or some kind of formatting software to do any kind of tax adjustments that's needed but it's got potential that thing's got potential and in any case we are focused here on the transaction list by date let's go into it here let's change the dates up top from 010124 to 123124 I'm gonna try to make it a little bit larger but we can't make it too large I'm gonna customize fonts and numbers change the font let's bring it up to like maybe 11 will that work it's gonna it's gonna make a lot of skinny columns so I'm gonna say let's make the date a little bit wider see if we can see more stuff here I'm gonna try to expand some of this stuff the memo the account on the split and notice you have the capacity to make the reports wider with these with these little three dot things in a similar way as you would do in Excel now note it looks a lot like the the transaction reports when we drill down which are similar to the GL reports but it's it's got all of the transactions listed by date it's not basically given them in order by account now this can be useful for a few different reasons one is that you can just see the detail so if I was to like bill somebody for the activity if I entered all the data for this year for example they can see exactly kind of what I input on a transaction by transaction basis that can be nice and it can also be nice in a billing system so for example if you don't want to bill people hourly and you want something like so a little bit more concrete you can possibly try to set up a billing system by how many transactions you enter into the system so you can say I'm going to charge you this much every month depending on how many transactions I enter into the system and then you can actually give them something a little bit more concrete the actual transactions that you entered into the system which which is the baseline for your billing instead of something that's a little bit more vague in terms of just the hours which can which can you know change depending on how how attentive you are you know when you're entering the information into the system so that's one good thing if you're a supervisor then you can kind of check to see how much work someone else is doing if they're doing data input by basically running a report like this and seeing the activity that they have put in place for a school setting or if you're doing practice problems this report can be great too for kind of reviewing the work that someone has been done and if we're kind of comparing our work to the example work meaning if we work the problem here our ourselves on our end together and then you work the problem on your side then if you're balance sheet and the profit and loss do not tie out we can go to the transaction detail report and basically compare each transaction line by line so that's another great tool for the transaction detail report now once you open the transaction detail report we can also sort it and the main sort field would typically be by type so we got the bills we got the invoices we got the payments and so on and so forth then of course we've got the date it's an order by date of transaction when the transaction was put into the system doesn't matter what account it's going to what cycle it's going to it's going it's in place by date you've got the numbers were applicable the name vendors customers employees typically you've got the memo you've got the split account now note the split account can only show you one other you know one other side the other side of the account so if you're talking about normal transactions then I'm sorry this is the account and then you've got the split account so you've got two accounts that are impacted that it's showing you here for many normal transactions there are only two accounts impacted meaning when you enter something home page into a form like a bill pay check invoice so on oftentimes there's only two two accounts impacted like a cash account and for a check a cash account and an expense account for example and so that this report's great for that because it can show that on one line however if there's multiple accounts impacted it can't show you the multiple accounts that's why you have this split component here so for more complex transactions like payroll for example then it's not going to give you all that detail so if you want more detail you can run the journal entry report that's one report that gives you all the detail in terms of a journal entry and then you've got the total on on the right hand side of the amount of the transaction that was put into place so for example this bill had an impact the name of the vendor it had an impact for the amount of 1500 accounts impacted 2000 that's accounts payable and the split to 543 00 it's like a job looks like a job thing for materials I would think or something like that so we've got that all the way down of course we've got all the different types of transactions put in place which are typically going to be some kind of form that we used in any cycle bills pay bill invoice receive payment enter the payroll pay the payroll liabilities and so on or a journal entry if we entered simply a journal entry and then we've got all the detail on that so that's going to be this report now the other thing that that you might be if you're using this for billing for example you might say hey if I enter so many transactions I'm going to bill you this much and if I enter some other range of transactions I will bill you this much and so on but when you do that if you're using something like payroll remember that those complex transactions the ones that have the splits the ones that are going to be large in nature then you might want to account for that so for example if you have payroll transactions you might say well payroll in and of itself is something that I'm going to charge you this much more for or something like that and or you might have a third party do the payroll if you're a bookkeeper working in that format or you could run the general ledger report which actually gives you all the detail and then you might try to bill people in terms of how many accounts are impacted instead of on how many transactions because some journal entries some transactions are going to be much more complex payroll transactions are much more complex than entering a check right so so you might try to build them in terms of how many accounts were impacted we'll take a look at that report in a future presentation so just other things you might do with this report you might try to filter by the transaction so if you want to take like all the activity that happened broken out by type on the left and then filter by the type we can go to customize up top you might then go okay I'm going to go to the filters and typically we often filter by type so we're going to go transaction type that's a common filter very common and then you might have multiple types that you're going to filter by and maybe you want the bills and maybe you want the pay bills possibly just to pick a pick a couple okay okay and so there we've got the bills and the pay bills which is nice so then I can show the filters up top if we so choose we can see the filters here I can go then to the customize again I can go into my filters I can pick that filter there's the new one that we made and then I can remove the selected filter I can revert to the original taking me back to the original so I can do that and if I wanted to go back to my transaction detail and say I'm going to pick some other filters possibly I want you know invoices sales receipts like the sales type of journal entry transaction sales types of forms okay okay and so now we've got just the invoices and the sales receipt which we had one in that so those are some common filters that you might be using this transaction report for so once again just to recap it's going to give you a list of everything but not by account it's just going to order it by date all the transactions that have been involved will be in will be here showing in that format transactions typically being the things that are entered by forms on the home page the use of it could be that you're searching for something in particular using your filtering option or possibly you're using it to bill because you're going to set up your billing system in such a way that that you're going to charge people so much for how many transactions you have that's one way you might set up the billing system which I highly recommend considering as opposed to just an hourly rate because then it's something a little bit more concrete it can make the billing system a little bit easier it's also great for reviewing people's work if you're working as a supervisor and it's great as we will see when you're doing a practice problem if you want to check your work to attempt to a standard so when we enter the data and you enter the data we'll check the balance sheet we'll check the income statement if something isn't working will then go to the transaction list by date and you can check every transaction usually it's a date issue that's a problem and we can use that to fix the problem