 QuickBooks Online 2022 Report Customization Filters 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, selecting the United States version of it And verifying that we're not a robot. Sample Company, Craig's Design and Landscaping Services This is holding control down, scrolling up just a bit to get to that one, two, five percent We also have the free 30-day version open so we can look at the business view as compared to the accounting view If you don't have access to this, that's okay, we'll use it more in the second half of the course Going back on over to Craig's Design and Landscaping Services We're going to be opening up a couple of reports up top, let's just open up two new tabs By going to the tab up top, right clicking on it, duplicating that tab Back to the tab to the left, right clicking on it and duplicating that tab Before, while that is thinking, I'm going to go back on over to the other item for the free 30-day trial Which is in the business view, just to note that the reports are located in the business overview And then in the reports, then we'll be in the same area Note that if you were to change the view to the accounting view, we'd have a similar view that we'll look at now Which is going to be on back to Craig's Design and Landscaping So we're in the second tab, we're going to go to the reports down below We're then going to go into the balance sheet, the balance sheet report Scrolling up top, range change from 0121 to 123121 and run it Close the hamburger and then go to the tab on the right And then we're going to go down to the reports again, this time the P to the L, the profit and loss, the income statement Scrolling back up top, we're going to change the range from 0121 to 123121 and run it Close in the hamburger on the left hand side We're going to go back to the first tab now, hold down control, scroll up just a bit We've been looking at formatting options using the balance sheet in particular But many of the formatting options being basically in most reports We have the formatting options in like the ribbon up top We have the formatting options down here and here We have the actual formatting options in the headers And then we have the customizing options which is what we're looking at now Within the customization we've got the couple dropdowns We're now looking at the filter dropdown Now the filter dropdown isn't something you're usually going to be using When you look at a balance sheet and an income statement, the standard types of reports But when you get into the detail of those reports then you might filter in on them And some other reports, these filtering options could be quite common So I'm going to close this back out and I'm going to go back down and say Well what if I drill down for example on cash That would give us what I would call like a general ledger type of account Which they call a transaction report Giving us the transactions basically by the date that they have been put into process Now because we're looking at a cash account We have a whole bunch of different transaction type accounts on this side So we might be looking at cash and say Hey look I would like to look at just the checks I would like to look at just the deposits for example And that would be a perfect tool for basically our filtering type of options So one of the most common options to filter by is the transaction type So if I go back up top and say okay let's customize this report We have the same customized kind of options here We're going to go down into the filtering tab And now I've got all these basically filtering kind of options related to this report Because we have more headers up top that we can sort by And one of the most common would be the transaction type So it's selecting all transaction types So we might say I might just want one transaction type Say check type forms and then I'm going to say Okay that's what I want let's run it And now we've got just the check type forms Now it might be the case that I want more than just the check type forms Because I'd like to see other forms that possibly are decreases So I could customize the report up top and say Alright let's go into the filters and see what we can do about that We're going to hit the drop down in the transaction type And we want to go to select multiple transaction types So we're going to say check maybe And then the credit card vendor credit Bill payment payments transfer deposit Billable expense charge Maybe we'll pick up a billable expense charge And then we'll take up the expense here I want to pick up that's the other main one I wanted to pick up And where's the bill payment The billable expense The bill payment and the bill payment credit card Let's keep those items in and run it So now we've got some more items that are typically going to be Decreases to the checking account And we've got multiple items over here We can do a similar kind of thing for the deposits And just look at the deposits so that would be a typical format Of the report Other filtering options if we go back up top and we customize this report We can then say let's say I go back to all here up top And then remove the transactions We can filter by accounts We can filter by basically names here So we might have specific names that we want to look at Basically transactions within which might be common Maybe not in this report but in other types of reports that we might be using We've got the customer, the vendor, the employee, the product or service The due date, the created date The cleared accounts receivable check printed amount We could search by actual amount which could be useful sometimes For looking for a specific area Now I also just want to close this back out And look at some other common reports where you might be using filters More likely if I go to the first tab and then go down to the reports again We go into the reports area And I'm going to go all the way down to like the accounting reports at the bottom Go down to some of these accounting reports It's likely that if we're using for example a transaction list by date report Which is common if we're trying to see the kinds of transactions that have happened Over a time frame, the activity that we have done 0121 to 123121 So you might run this and say okay what are the actual transactions that we have done Through this time frame and like with the transaction detail for the checking account You've got a lot of transaction types here So you've got a lot of different things that you could use to filter Transaction types, number, postings, name and so on and so forth But again one of the more common types would be the transaction type That you might be filtering by So you might go into here and say okay now I just want to look at the invoices for example So you might go in here and say okay I'm going to select that item, customize it And then go to the filters and say we're going to go to the transaction type as the filter And possibly we want the invoice for example And then run that and now you've got all the transactions for that period that are invoices So this is a common report that you'll have that kind of filtering The other common report for example if I hit the plus the hamburger Go down to the reports, if I go all the way down once again All the way down to the accounting reports This journal report, really good report for practice here This is another report that could record all the activity that happens over a time frame For example 01.01.21 to 12.31.21 on the time frame 12.31.21, 12.31.21 and there we have it But it gives you the full journal entry, the debits and the credits So it's not just the journal forms it's giving It gives you the deposit forms, the bill forms, the invoices Everything that has a financial transaction But then instead of giving you one line item Gives you the actual debits and credits that are involved And if you get into more complex transactions like the sale of inventory Here's an invoice for example You can actually analyze more in depth the accounts that are impacted The debits and credits that are involved So this is a really good report for that You also could use these two reports for billing type of processes And try to count the number of activities that you have done And basically bill based on either the accounts that are impacted Or the number of transactions instead of simply by hour We'll talk more about that in future presentations But then of course you can filter by these types of transactions And if I use my customization up top And I filtered and say once again I want to filter by like the invoices Because those are probably more complex kind of transactions Now I've got all my invoices And you can see there's some more complex transactions here If you wanted to look at this journal and look at say payroll transactions Which are often involving more than just two accounts Can be a little bit more complex Then you can drill down and look at the journal entries related to them And so a lot of different options with those filtering options But they're usually going to be used with some of the more kind of expansive And detailed reports rather than the major financial statement reports Balance sheet and income statement which are summarizing those points Into the major categories of the balance sheet and income statement accounts