QuickBooks HelpQuickBooksHelpIntuit

Use custom fields in reports in QuickBooks Online Advanced

by Intuit6 Updated 2 months ago

Learn how to use custom fields in your reports in QuickBooks Online Advanced.

In QuickBooks Online Advanced, you can create custom fields and use them in various ways to track what matters most to you. In this article, we’ll show you how to use custom fields in reports so you can get a clear picture of how your business is doing.

Note: Not all reports support custom fields or all features of custom fields. See below for details.

What you can do with custom fields in reports

Ready to get a deeper understanding of your business? Here’s what you can do with custom fields in reports:

  • Add custom fields as columns so you can see key details about each transaction or line item.
  • Sort items by a custom field so you can organize and scan the report easily.
  • Group items by a custom field so you can see the activity and totals for the same type of item in one place.
  • Filter items by custom fields so you can see just the data you’re interested in.

How to get started

First, go to Reports (Take me there). Then browse or search for a report you’re interested in.

Once you have the report you want, follow these steps to take advantage of custom fields.

Add custom fields as columns to a report

  1. Find and open the report you want to run.
  2. Select the gear icon at the top right of the report.
    QBOAdv_custom_fields_add_columns_to_reports.png
  3. Under Change columns, select the checkbox for each custom field you want to add.
  4. Select anywhere outside the settings panel to close it. QuickBooks adds the columns to the right side of the report. To reorder the columns, select the gear icon again, then select Reorder columns.

Sort items in a report by a custom field

  1. Find and open the report you want to run.
  2. Select Sort at the top left of the report.
  3. In the Sort by dropdown list, select the custom field you want to sort the report by.
    QBOAdv_sort_by_custom_fields_in_reports.png
  4. Under Sort in, select between Ascending order or Descending order. The sort takes effect instantly.

Group items in a report by a custom field

  1. Find and open the report you want to run.
  2. Select Customize at the top of the report screen.
  3. In the Customize report panel, select Rows/Columns to expand the section (if needed).
  4. In the Group by dropdown list, select the custom field you want to group the report items by.
    QBOAdv_group_by_custom_fields_in_reports.png
  5. Select Run report.

Filter items in a report by custom fields

  1. Find and open the report you want to run.
  2. Select Customize at the top of the report screen.
  3. In the Customize report panel, select Filter to expand the section. (You may need to scroll down the panel to see it.)
  4. Select the checkbox for each field you want to use as a filter. Then enter or select the specific values for each field.
    QBOAdv_filter_with_custom_fields_in_reports.png
  5. Select Run report.

Reports you can use custom fields with

The tables below show all of the reports in QuickBooks and which ones support features of custom fields. We’re working to make additional reports supporting custom fields, so check back here regularly.

Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
Profit and Loss ComparisonNoNoNoNo
Profit and Loss by MonthNoNoNoNo
Profit and Loss % Total Income ReportNoNoNoNo
Quarter Profit and LossNoNoNoNo
Profit and Loss YTD ComparisonNoNoNoNo
Profit and Loss by CustomerNoNoNoNo
Profit and LossNoNoNoNo
Profit and Loss DetailNoNoNoNo
Profit and Loss by LocationNoNoNoNo
Profit and Loss by ClassNoNoNoNo
Balance Sheet SummaryNoNoNoNo
Balance SheetNoNoNoNo
Balance Sheet ComparisonNoNoNoNo
Transaction ReportNoNoNoYes
Realized Exchange Gains & LossesNoNoNoYes
Unealized Exchange Gains & LossesNoNoNoNo
Company SnapshotNoNoNoNo
Cash FlowNoNoNoNo
Budget OverviewNoNoNoNo
Budget ActualsNoNoNoNo
Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
A/R Aging SummaryNoNoNoNo
A/R Aging DetailYesNoNoYes
Customer Balance SummaryNoNoNoNo
Customer Balance DetailYesYesNoYes
CollectionsYesYesNoNo
Open InvoicesYesYesNoYes
Invoice ListYesYesYesYes
Invoices and Received PaymentsNoNoNoNo
Statement ListNoNoNoNo
Terms ListNoNoNoNo
Unbilled timeNoNoNoNo
Unbilled chargesNoNoNoNo
Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
Customer contact listYesYesYesYes
Sales by class summaryNoNoNoYes
Deposit detailNoNoNoNo
Sales by customer detailYesYesYesYes
Estimates & progress invoicing summary by customerNoNoNoYes
Sales by customer summaryNoNoNoYes
Estimates by customerYesYesYesYes
Sales by customer type detailYesYesYesYes
Income by customer summaryNoNoNoNo
Sales by location detailYesYesYesYes
Inventory valuation detailYesNoNoNo
Sales by location summaryNoNoNoYes
Inventory valuation summaryNoNoNoNo
Sales by product/service detailYesYesYesYes
Payment method listYesYesYesYes
Sales by product/service summaryYesYesYesYes
Physical inventory worksheetNoNoNoNo
Time activities by customer detailNoNoNoNo
Product/service listNoNoNoNo
Transaction list by customerYesYesYesYes
Sales by class detailYesYesYesYes
Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
1099 Contractor balance detailsNoNoNoNo
1099 Contractor balance summaryNoNoNoNo
Accounts payable aging detailNoNoNoNo
Accounts payable aging summaryNoNoNoNo
Bill payment listNoNoNoNo
Bills and applied paymentsNoNoNoNo
Unpaid billsYesYesNoYes
Vendor balance detailsNoNoNoNo
Vendor balance summaryNoNoNoNo
Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
1099 Transaction detailNoNoNoNo
Check detailNoNoNoNo
Expenses by vendor summaryNoNoNoNo
Open purchase order list by vendor*YesYesYesYes
Open purchase orders detailNoNoNoNo
Purchases by class detailNoNoNoNo
Purchases by location detailNoNoNoNo
Purchases by product/service detailNoNoNoNo
Purchases by vendor detailNoNoNoNo
Transaction list by vendor*YesYesYesYes
Vendor contact listYesYesYesYes

*Supports purchase order custom fields only.

Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
Sales tax liabilityNoNoNoNo
Taxable sales detailYesYesYesYes
Taxable sales summaryNoNoNoYes
Report nameAdd custom field
as column
Sort by
custom field
Group by
custom field
Filter by
custom field
Account listNoNoNoNo
Reconciliation reportsNoNoNoNo
Trial balanceNoNoNoNo
Class listNoNoNoNo
Location listNoNoNoNo
JournalNoNoNoNo
Invalid journal transactionsNoNoNoNo
Transaction detail by accountNoNoNoYes
General ledgerNoNoNoNo
Transaction list with splitsNoNoNoYes
Transaction list by dateYesYesNoYes
Recent transactionsYesYesNoYes
Recurring template listNoNoNoNo
QuickBooks Online Advanced

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this