Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

What's important about the Modify Report window

The selections you make in this window change the current report. You can make as many—or as few—changes as you need.

Important fields

Report Dates

Report Dates

Columns

Columns

Include

This setting affects which accounts appear in transaction detail reports.

  • Select All to include all accounts in the report, regardless of whether there was any activity in the account during the time covered by the report.

  • Select In Use to include only those accounts used during the report period.

Open balance/Aging

This setting determines how QuickBooks calculates a customer's open balance in the aging report.

  • Select Current to show the customer's open balance as of today. All payments received through today's date are reflected in the open balances shown in the report.

  • Select As of Report Date to show the customer's open balance as of the ending date of the report. This lets you view your customers' open balances as of a date other than today. Payments received after the ending date of the report are not reflected in the open balances shown in the report.

Report Basis

This setting determines how the report calculates income and expenses.

  • Select Cash if you want the report to base income and expenses on the date that cash actually changes hands. For example, a cash basis report treats a customer payment for an invoice as income, but not an unpaid invoice.

  • Select Accrual if you want the report to base income on the date you billed a customer, and expenses on the date you entered a bill. For example, an accrual basis report includes both a customer payment and an unpaid invoice as income.

To change the report basis for all reports, and not just for this particular report, select the basis you want in the Reports & Graphs Preferences window. (Reports that list transactions individually always appear as accrual basis reports when you create them. To change one of these reports to cash basis, you must use the Modify Report window.)

Filters

Filters

Total by (unavailable for some reports)

The choices on this list change how QuickBooks groups and subtotals transactions in the report. You can group the transactions by periods of time (by each day, week, month, and so on), by account, by the person or organization related to the transaction (customer, vendor, employee, payee, and so on), by the special classifications you have set up (customer type, vendor type, class, and so on), or by other factors such as shipping method, payment terms, or tax implication.

Choose Total only if you don't want subtotal groupings in the report.

Sort by (unavailable for some reports)

The choices on this list change the order in which transactions appear in the report. You can list the transactions in chronological order (earliest first), by amount (either smallest or largest first), or by document number (for example, by check number).

Tips

  • Date lists transactions in chronological order, but doesn't group each day's transactions in any particular way.

  • Date/Transaction lists transactions in chronological order, grouping each day's transactions by transaction type. For a given day, the report lists all checks in a single block, all invoices in a single block, and so on.

KB ID# H_RPT_MODIFYRPT_WINDOW_TRANSLAYOUT
12/2/2016 4:23:49 PM
PPRDQSSWS404 9138 Pro 2017 ce8888