How to Add a Filter to a Report in QuickBooks
QuickBooks includes report filters that let you set custom criteria for the transactions you want to include in a report. For example, you may want to include only certain accounts in your profit and loss report in order to analyze a specific type of income and expense. This can be accomplished using filters. To add a filter to a QuickBooks report, follow these six steps.
This feature works the same in versions 2011–2016 of QuickBooks.- From the report window, click Customize Report.
- In the Modify Report dialog box, select the Filters tab.
- In the Choose Filter section, from the Filter list box, select the desired filter. Criteria options for the selected filter load to the right of the list box.
- Specify the value(s) you want for the report. Notice that after you select a filter and specify its criteria, it is listed in the Current Filter Choices list box. You can remove a filter by selecting it in the list box and clicking Remove Selected Filter.
- To set additional filters, repeat steps 3 and 4.
- When you finish specifying filters, click OK. The report updates to reflect your filtering criteria. You can print or save the report as usual.
Related Articles
- How to Transfer Funds Between Bank Accounts in QuickBooks
- How to Create a Company File in QuickBooks Using Express Start
- How to Create a Profit and Loss Report in QuickBooks
- How to Customize an Invoice Form in QuickBooks
- How to Add Inventory Items in QuickBooks
- How to Write Checks and Enter Bills in QuickBooks
- How to Use the Account Register in QuickBooks
- How to Delete and Void Checks in QuickBooks
- How to Export a QuickBooks Report to Microsoft Excel
- How to Add Credit Card Accounts in QuickBooks
- How to Run a Sales Tax Report in QuickBooks
- How to Enter a Credit Memo in QuickBooks
- How to QuickZoom on a Report Item in QuickBooks
- How to Track Time for a Single Activity in QuickBooks
- How to Customize the Icon Bar in QuickBooks
- How to Customize Preferences in QuickBooks
- How to Create a Memorized Report in QuickBooks
- How to Change the Default Sales Tax in QuickBooks
- How to Create a Sales Tax Group in QuickBooks
- How to Add a Filter to a Report in QuickBooks (this article)
- How to Perform an Advanced Find in QuickBooks
- How to Add Items to the Item List in QuickBooks
- How to Close a Company File in QuickBooks
- How to Change the Header and Footer in a QuickBooks Report
- How to Enter Credit Card Charges in QuickBooks
- How to Run a Time Tracking Report in QuickBooks
- How to Add Vendors in QuickBooks
- How to Select Payments to Include in a Deposit in QuickBooks
- How to Apply Sales Tax to an Invoice in QuickBooks
- How to Quick Add a Name in a Timesheet in QuickBooks
- How to Use the Open Window List in QuickBooks
- How to Record and Receive Customer Payments in QuickBooks
- How to Track Vehicle Mileage in QuickBooks
- How to Reconcile an Account in QuickBooks
- How to Delete a Memorized Transaction in QuickBooks
- How to Record a Sales Tax Payment in QuickBooks
- How to Create a Memorized Transfer in QuickBooks
- How to Set up a Vehicle List in QuickBooks
- How to Enable Class Tracking in QuickBooks
- How to Set Up a List of Class Items in QuickBooks
- How to Edit a Memorized Transaction in QuickBooks