Create and edit custom fields in QuickBooks Online Advanced
by Intuit•36• Updated 1 week ago
Learn how to create and use enhanced custom fields in QuickBooks Online Advanced.
Custom fields let you track the information that matters most to you and your customers.
In QuickBooks Online Advanced, you can create custom fields for almost anything: sales reps, customer types, vendor IDs, PO numbers, Project Managers, or info unique to your industry. You can add custom fields to sales forms, purchase orders, expense forms, customer profiles, and vendor profiles. This gives you more flexibility to add custom data and drive insights through detailed reports.
Note: Want to use this feature? You can upgrade to QuickBooks Online Advanced. If you don't have QuickBooks Online Advanced, here's how to add custom fields for other QuickBooks versions.
Create custom fields
You can have up to 12 active custom fields for each type of form (invoice, estimate, purchase order, expense, bill, and so on), and each type of profile (customer and vendor).
Besides text, you can also create custom dropdown, date, and number fields.
- Go to Settings , then select Custom fields.
- Select Add custom field. If you’ve already created a field, you’ll see Add field instead.
- Enter the name of the custom field in the Name field.
- Select the type of data in the Data type ▼ dropdown that will go in your custom field: Text and number, Number only, Date, or Dropdown list. If you select the Dropdown list, enter the items in the list.
- Select the category the custom field belongs to: Customer, Transaction, Vendor, or Project. Customer fields are for customer profiles, and vendor fields are for vendor profiles. You can assign transaction fields to sales forms (like invoices, estimates, and sales receipts) and purchase forms (like purchase orders, bills, expenses, and checks).
- Select the forms where you want the custom field to appear. Note: To use custom fields in purchase orders, you need to turn on purchase orders for your company first.
- If you want customers or vendors to see the field on a form (such as invoices, estimates, or purchase orders), select Print on form. A maximum of 3 custom fields may have Print on form turned on for any single form type (such as Sales Receipt or Invoice).
- When you’re finished, select Save.
Now that you have custom fields, learn about how you can use them:
- Search and sort with custom fields
- Use custom fields for vendors and expenses
- Use custom fields in reports
Manage your custom fields in one place
The custom fields page lists all your custom fields so you can manage them easily. To see it, go to Settings ⚙, then select Custom fields.
For each custom field, you can see what category it applies to and which forms it appears in. You also see the Print icon if the custom field is visible to customers or vendors on a form.
To edit a custom field:
- In the Actions column, select Edit.
- Edit the field's name, select the forms it appears on, and choose whether it's visible to customers or vendors.
- When you're done with your changes, select Save. Any edits you make here apply to all forms that use the field.
To make a custom field inactive:
- Select the arrow next to Edit.
- Select Make inactive.
- Select Yes in the pop-up message to confirm your choice.
Don’t worry about losing old custom field data If you make a custom field inactive, your past data won’t disappear. You’ll still see the field on sales forms and purchase orders you've used it on, but it won’t appear on new forms. |
Create or edit custom fields from a form or profile
You can also create and edit custom fields from any sales form, purchase order, expense form, customer profile, or vendor profile.
From a sales form (invoice, sales receipt, expense) or purchase form (expense and purchase order):
- Open an existing form or create a new one.
- Select the Gear icon at the top of the form (not on the navigation bar). This opens a panel with the Custom Fields section.
- To create a custom field, select + Add custom field. Fill out the info about the field, then select Save.
- To edit an existing field, select the pencil icon next to the field. Or, select Manage custom fields. This opens the Custom fields page so you can make edits. When you're done making changes, close the window to return to the form.
Important: | Keep in mind, that any changes you make to forms affect all forms and customer profiles using the custom field, not just this form. |
From customer and vendor profiles:
- Go to Sales, then Customers (Take me there).
- Find and open a customer profile.
- Select Edit.
- Go to the Custom fields tab.
- To create a custom field, select + Add custom field. Fill out the info about the field, then select Save.
- To edit an existing field, select Manage custom fields. This opens the Custom fields page so you can make edits. When you're done making changes, close the window to return to the profile.
- Select Save to save your changes.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Workflow features for estimates and invoices in QuickBooks Online Advancedby QuickBooks•13•Updated June 17, 2024
- Add custom fields to sales forms and purchase orders in QuickBooks Onlineby QuickBooks•274•Updated June 13, 2024
- Create and use custom fields in QuickBooks Desktopby QuickBooks•9•Updated June 13, 2024
- Use custom fields for vendors and expenses in QuickBooks Online Advancedby QuickBooks•62•Updated June 17, 2024