Summary Account vs Detail Account

Overview

Each QuickBooks transaction contains a summary account and one or more offsetting detail accounts.

This applies to standard transactions, bank transfers, and journal entries. For a journal entry, the first line acts as the summary account.

Filtering a QuickBooks report by an account normally returns only the lines posted directly to that account. For example, filtering by an Accounts Receivable account returns the summary line but not the offsetting invoice detail.

How QuickBooks Displays the Transaction

Using a QuickBooks Transaction List by Date report, the transaction can be displayed in three ways.

All Lines

The report includes both the summary account and the offsetting detail accounts.

Summary Only

The report includes only the summary account line.

All Except Summary

The report includes only the offsetting detail account lines.

Filter by Summary Account in QQube

Use the QQube field named Summary Account when you need to isolate transactions posted to a specific summary account while retaining their offsetting detail.

For example, a company may use multiple Accounts Receivable accounts. Filtering by the required Accounts Receivable account through Summary Account returns the invoice detail associated with that account.

Expected Result

The report returns the detail lines for transactions associated with the selected summary account. This filtering method is available in QQube but not in standard QuickBooks reporting.