 QuickBooks Desktop 2023. Report Filter Options. Let's do it within 2-its. 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 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. Here we are in QuickBooks Desktop sample, raw, castle, construction, practice, file provided by QuickBooks going through the setup process we do every time, maximizing the homepage to the gray area, going to the view dropdown, noting we have the hide icon bar and open windows checked off, seeing it on the left hand side, reports, dropdown, company and financial, looking at that profit and loss, date, range, change, a 10124 to 123124 tab, January to December, customize it so I could change the font to 12, okay, yes please, okay. Next, reports, dropdown, company and financial, this time the big balance sheet. I'm going to then change it this way on the date, making it this fiscal year so I can then drill down more easily on the data and then I'm going to go to customizing it again, fonts and numbers, change it on up to 12, okay, yes and okay. So that's the setup process we have been doing every time. Last time we focused on some of the options to be changing reports that are in, I guess the ribbon up top, now we're going to look at more of the options that are in the customized reports area, noting that we want to consider the types of reports that are going to be affected, so we're going to go over this stuff using, in essence, a balance sheet and some of the transaction detail reports related to it, but realize that some of the differences may be on the account type in terms of which reports might impact differently, such as balance sheet reports, reporting as of a point in time and income statement reports or profit and loss reports going on over here, which have a range that are being affected January through December, also reports that have more detail back to the balance sheet, which is the one we're going to focus in on most are the ones that often are going to be more utilized within filtering options, such as if I double click on the cash icon here, zooming in, this is going to be a report that's like a general ledger transaction report. This has a lot more filterable components, so the filtering options are often more useful, quite useful on these longer, more detailed reports. Let's change the date, the range on this one too. I'm going to customize fonts and numbers and then change, let's bring it up to 12.2 and just see if that will work or if that's too much. That's not bad. I'm going to make these a little bit wider so we can see these. Okay, so let's think about some filtering options with this type of report. Now, normally, we've already got some filtering of course by date because we can change the date ranges up top. Typically, the filtering that we're going to be doing is by type. It's going to be one of the main things that we might want to filter by, although we could filter by name too would be another common filtering component, possibly cash as well, but oftentimes we would be filtering by type. Note that I'm in the checking account specifically because the detail, the general ledger, the transaction list in the checking account will have different types of transactions in it, much more so than other kind of general ledger accounts or transaction accounts because of the nature of cash being the lifeblood of the company, it being involved in every accounting cycle. So let's go up to our filtering options up top and let's say that we're going to go into the filters on the right hand side and the most common thing here is by type. So let's go on down here and say that we're going to filter by transaction type. Notice there's a huge array of filtering options because these are basically all the filtering options that you can have and a whole bunch of different kind of reports. We might talk about some of those options a little bit more shortly, but it's useful to know this transaction type filter because that's a very common one to be using. Then if I select that one, I'm going to select the dropdown. We can have multiple transaction types or I can pick one transaction type. So for example, if I'm just looking for deposits, then I can go to the deposits area and then you can see on the right hand side, we've applied that one filter. You got the account, you got the date, you got the transaction deposit transaction type. Let's say OK. And then it filters of course by the deposit. If I say show filters up top, it tells me the filters that we have involved here because we're basically a transaction account. We're specifically in the checking account. We got the custom filter, which is the transaction type on the deposit. If I remove that here, then you can see all the transactions come back into play. If I was trying to look at the decreases, for example, here to the checking account, notice that it gets a little bit difficult to do that even though the QuickBooks was trying to help us out. You'll recall that we had a check form, which is a form that decreases the checking account. But we also have these other check type forms, which are special depending on what they're used for, like a paycheck type form when we process payroll, a bill check form when we pay down the accounts payable. These are decreases to the checking account, but they actually have different types, which can be useful for filtering, but also a little bit more confusing than filtering just a check type form. Let's customize the report for those. We'll do the filters and this time I'm going to go to type again, transaction type, and then I'll hit the drop down and this time I want multiple transaction types. So I'm going to say multiple of them and then just choose the ones I want. We've got the check form. We've got the sales receipt. I'm going to try to choose mainly the decreases. A journal can decrease and that would be another one that was kind of a little bit difficult to be filtering by. A journal entry isn't normal in other words for a decrease, but in any case we'll go down and we've got the bill. We've got the bill card bill payment. That's the one I want bill payment sales tax payment would be a decrease inventory adjustment item receipt paycheck would be a decrease payroll liability check would be a decrease. For example, let's just do those and we'll say okay so now we've got the filters on the right hand side. So I'm going to say okay let's apply them out so now we've got the filters you can see them basically up top here I can hide the filters if I so choose. And now we've got in essence the types of forms or some of them at least which would be decreases so we can filter by in essence the decreases here to the account so that would be another kind of common filter that we could be using. So now I can remove the filter so this last component that's the filter that we added, and I could remove it here move selected filter. So that is gone now so if I say okay, the deposits now should have returned down below so now we've got our deposits have returned. Let's go back up top and just look at some of the other filtering options that are there if I go into the filter. We've got the filtering by account so within here we're basically in this one account so you could have reports that have multiple accounts that are impacted and then drill down on the account. Built by the aging by the amount so we can try to filter by the amount which could include any or we could say it's it's going to be equal to or have a range that will be involved. So we've got the day the billing status the class class is a custom field that we could use that gives us some more kind of sorting options when we enter data it's kind of a specialized area cleared color contract customer type. So we could if we're looking at customer reports we might have different types of customers that can help give us more filtering options date detail level discount available due date. Notice again this filters are including a bunch of different filters because they're all the filters that could be included in any kind of report that we would be making. So enter modified estimate activity so FOB shipping stuff and active inventory items of course specific to inventory reports we're not in an inventory reports. So remember these are like all the filters is adjusted items so like inventory items when you're searching for those kind of reports or service items job status. That would be for a job cost kind of system if you have searching by status open job in progress job type material memo. So that would be a common one that you might try to filter from if you're trying to search for a certain transaction to look for what's happening in the memo if you think you put a memo name which could include customers and vendors for example. So we've got a name field here and then we've got the account name account address city email. So if we're looking at like data for vendors or customers we could search by those common filtering address and phone numbers and so on pay period begin date pay period end date payment method. So that could be useful if we're if we logged in the different methods of payment that we received from and we want to see the difference between receipts we got from a credit card versus a versus a check or something like that payroll items. So obviously would help us with payroll searching by the specific items hourly versus salary or something like that posting status preferred delivery preferred vendor printed status received rep for sales rep sales tax code if we have different places that we're having sales tax could be a certain filtering field ship date ship via spouses name template terms transaction type that's the one most common one for us oftentimes when we're filtering by like these GL reports vendor type voided workers comp code and so on. So there's a bunch of different filtering fields it could be a little bit overwhelming to see how this works to start out with. But if you do the standard default filters filtering by type filtering possibly by memo filtering possibly by name and then you could use amounts if you want to search for transactions that are within a certain amount. You'll get pretty used to you know those kind of filtering options if you practice them a few times.