filter Archives - QBGarage.com

When running a report in QuickBooks, the output is controlled by the Filters set for that report.

The Detail Level is one such filter.

It has 3 possible settings:

All
Summary only
All except summary

Many transactions in QuickBooks can have multiple line items. For example, a customer invoice may consist of 2 separate line items of $50 each that total $100.

With the Detail Level filter set to All, a QuickBooks report would show both the individual line items andthe total. In the above example, that’s the 2 line items of $50 each and the transaction total of $100.

With the Detail Level filter set to Summary only, a QuickBooks report would show only the transaction total. In the above example, that’s $100.

With the Detail Level filter set to All except summary, a QuickBooks report would show only the detail lines and exclude the transaction total. In the above example, that’s the 2 line items of $50 each.

The function of the Detail Level report filter is summarized in this Intuit knowledgebase article.

(+1 rating, 1 votes)

It’s relatively straightforward to prepare a report of invoices in number order and have QuickBooks automatically identify missing invoice numbers, such as where there are gaps in the sequence of numbers.

The key to preparing this report is to use another report as a building block. Identifying sequential transactions and those items missing from the list are common requirements for Banking reports. That causes the Missing Checks report to come to mind. This report is found on the Reports->Banking->Missing Checks menu selection.

Let’s start with this report. By default, this report asks you to specify a Bank account. Instead, simply choose an Accounts Receivable account.

QuickBooks Enterprise Solutions 10 Missing Checks

With the account selected, set a Filter for the Transaction Type. In the pulldown list on the left side of the Filters window, choose to include transactions having a Transaction Type of Invoice. If you have multiple Accounts Receivable accounts that you’d like to include, you can modify the Filter for Account on this screen as well. Although the Missing Checks report only allows you to select 1 account when first creating the report, you can select multiple accounts at this stage.

QuickBooks Enterprise Solutions 10 Transaction Type Filter

To complete the report, change the Report Title on the Header/Footer tab to reflect the actual contents of the report, which is a list of Missing Invoices.

QuickBooks Enterprise Solutions 10 Missing Invoices Header

The result is a list of invoices in invoice number order with each break in the sequence marked.

QuickBooks Enterprise Solutions 10 Missing Invoices Report

When the report is complete, click the Memorize… button to save these steps that created the report.

(+1 rating, 1 votes)

What Does the Detail Level Filter Do?

How Do I Print a Report of Invoices In Number Order To Identify Missing Invoice Numbers?

filter

Accounting

Developer

Intuit