QuickBooks Training Post:

To filter a report in QuickBooks Desktop 2012 or above; First, pull the base report you want to use, then on the top-left of the report, click on Customize Report window:

  1. Then click the Filters tab.
  2. On the Filter list, select whichever filter(s) you want to use.
  3. On the Filter detail information, choose or enter additional information that QuickBooks needs so the filter works correctly.
  4. From the current filter choices column, highlight a filter that you want to remove and click Remove Selected Filter. OPTIONAL, IF YOU WISH TO REMOVE A PARTICULAR FILTER
  5. Click OK.

screen-shot-2016-10-25-at-3-01-21-am

List Filters

Filter

Description/Definition

Account

You can select a single account (ex: Sales Income), a group of accounts (All income/expense Accounts) or multiple accounts (you can manually or automatically choose accounts) from the dropdown list.
Include Split Detail is only active for the balance sheet accounts and enables you to include the “other side” of transactions, called the “splits.”

Class

Class you created in QuickBooks. You can select one or multiple classes from the dropdown list.

Customer Type

Select a customer type or multiple customer types from the dropdown menu.

Item

You can select a single item (ex: Cabinets), a group of items (All services) or multiple items (you can manually or automatically choose items) from the dropdown list.

Job Type

Select one job type or multiple job types.

Name

You can select a single name, a group of names or multiple items (you can manually or automatically choose items).

Payment Method

Choose a single or multiple payment methods from the dropdown list.

Preferred Delivery Method

Select the preferred delivery method.

Sales Tax Code

Choose a single or multiple tax codes from the dropdown menu.

Ship Via

Select single or multiple methods from the dropdown list. Applies to invoices, credit memos, sales orders, sales receipts, but not estimates.

Templates

Select single or multiple templates from the dropdown list. Applies to invoices, credit memos, sales orders, sales receipts, estimates and statements.

Terms

Choose single or multiple payment terms from the dropdown list.

Content filters

Filter

Description/Definition

Amount

=: transactions equal to a selected amount.
<=: transactions less than or equal to a selected amount.
>=: transactions greater than or equal to a selected amount.

Detail Level

Choose whether to show or hide the detail lines for each transaction.
All: Show both summary and detail information.
Summary Only: Show only the summary (usually source) information.
All Except Summary: Show only the detail (usually target) information.

Transaction type

Select a single or multiple transaction types from the dropdown list.

State filters

Filter

Description/Definition

Aging

Enter the number of days back to track overdue bills and invoices.

Billing Status

Any: All transactions, whether billable or not.
Not Billable: Transactions not marked as billable to customers.
Unbilled: Transactions marked as billable but not yet billed yet to the customers.
Billed: Transactions marked as billable and already billed to the customer.

Cleared

Choose whether or not you want to include cleared transactions (those that have been reconciled against your bank or credit card statement).
Either: All transactions, whether cleared or not.
No: Uncleared transactions only.
Yes: Cleared transactions only.

Estimate Active

Choose whether or not you want to include active estimates (estimates that you have marked as ‘Active’ on the Estimate form).
Either: All estimates
No: Inactive estimates only
Yes: Active estimates only

Is Adjusment

Choose whether or not to include adjusting entries.
Either: all transactions
No: transactions that do not include adjustment
Yes: transactions that include adjustment

Paid Status

Choose whether or not you want to include fully-paid invoices and bills.
Either: All paid and unpaid transactions.
Closed: Paid transactions only.
Open: Unpaid transactions only.

Posting Status

Choose whether or not you want to include posted transactions that QuickBooks records in one of your registers.
Either: All non-posting and posting transactions.
Non-Posting: Only non-posting transactions (estimates, pending sales, purchase order and sales orders).
Posting: Only posting transactions (invoices, bills, checks, and other transactions that affect your books).

Voided

Choose whether or not to include voided transactions.
Either: All transactions.
No: Non-voided transactions only.
Yes: Voided transactions only.

Date filters

Filter

Description/Definition

Date

Select a date range from the dropdown list or enter a From date and a To date.

Due Date

Includes transactions that Due Date is within the date range you select. Use the dropdown or the From and To date fields to select the date range. This filter applies to both sales and expenses.

Entered/Last modified

Includes transactions that were entered or were last modified within the date range you select.

Paid Through

This Payroll filter applies only to Liability Payments. Each Liability Pay¬ment has a Paid Through date, indicating that liabilities due up through that date have been paid. The Paid Through filter includes all Liability Payments with a Paid Through date on or before your selected date.

Ship Date

Includes transactions with a ship date within your selected range. Applies to invoices, credit memos, sales orders, sales receipts, but not estimates.


Text filters

Filter

Description/Definition

FOB

Stands for “free on board” and refers to the location from which you ship a product.
In the field provided, you can type:
ORIGIN: if the buyer is paying the freight
DESTINATION: if the seller is paying the freight

Memo

Enter the words (or characters) that must be in the source memo field or the target memo field.

P.O. Number

Enter the customer purchase order number here.

 

VIDEOS:

Building Custom Reports in QuickBooks Desktop

 

Source vs. Target

 

Job Costing, Work-in-Progress, and Custom Fields:

 

Customer Type & Job Status:

 

Summary Vs. Transaction Detail vs. List Reports

 

Cash vs. Accrual Reports

The post Customizing Report Filters in QuickBooks Desktop + VIDEOS appeared first on QuickBooks Training & QuickBooks Consulting. Best rated in Miami & Broward.

Source: Hector\’s QuickBooks Blog

Share →

Leave a Reply

Your email address will not be published. Required fields are marked *