Filter, search, and sort with custom fields in QuickBooks Online Advanced

Learn how to use custom fields to organise and track data in QuickBooks Online Advanced.

Custom fields let you track specific data across your sales forms, purchase orders, and customer profiles. You can create custom fields to track everything from sales reps to special customer information.

You can also use your custom fields to organise lists, narrow search results, and filter financial reports. This helps you track specific details that are important to your business.

Note: Want to use this feature? You can upgrade to QuickBooks Online Advanced.

Sort your lists by custom field

Organise your invoice, customer, and expense lists so they’re easier to read. For example, you can sort your invoices by sales rep to see which transactions each one worked on.

1. Select any one of the following:
   • For Invoices: Follow this link to complete the steps in product
   • For Customers: Follow this link to complete the steps in product
   • For Expense transactions: Follow this link to complete the steps in product
2. Select the Gear icon on the list.
3. Tick the box next to a custom field to add it as a column.
4. Select the Gear icon again to close the window.
5. Select the Custom Field column header to sort the list as per the data type of the custom field, for example, either alphabetically or numerically.

Search for transactions with a specific custom field

See every transaction using a specific custom field. For example, if you create a customer loyalty programme custom field, you can search for all transactions using it.

1. Select the Search icon.
   1. Type the custom field value.
   2. Select a transaction from the search results.
2. To filter a transaction, select the Search  icon, then select Go to transactions search.
   1. From the Transaction type dropdown, select the type.
   2. Select Additional Filters.
   3. In the Additional Filters section on the right, enter the value in the Custom Field field.

Use custom fields in your reports

When you run reports, take advantage of custom fields to get deeper insights into your business. For example, you can filter a report to show just the data you’re interested in. Learn how to use custom fields in reports.