Quickbooks desktop custom field drop-down list

QuickBooks was designed to be used by numerous types of small businesses. Custom fields help you tailor it to meet your own needs.

One of the reasons that QuickBooks is so popular is that it can be used by a wide variety of business types, from pet stores to landscaping companies to coffee shops. Many companies are satisfied with the software as is and don’t need to make any modifications.

But have you ever needed to include more information in your customer records? Do your transaction forms need an additional field or two? QuickBooks makes this possible by supporting custom fields that you can define for yourself. It’s not difficult to do, and it can help you, for example:

Generate more focused reports.
Make customer and vendor records more detailed.
Create records for similar-but-different inventory items.

Here’s how it works.

Changing QuickBooks Forms

You may already know that you can change the structure and content of some QuickBooks forms, including invoices, estimates, sales receipts, statements, and purchase orders. To see what’s possible, open the Lists menu and select Templates. Right-click on the screen and select New. Choose the form you want to create and click OK. You can make changes in the window that opens and click Additional Customization to make more modifications.

You have tremendous control over the content and structure of your forms in QuickBooks.

Creating Custom Fields for Records

QuickBooks does not include custom field creation in the Basic Customization and Additional Customization windows, although your new fields will appear in the Additional Customization window. Rather, you go to the Customer Center, Vendor Center, or Employee Center, depending on what kind of records you want to change. You can add up to 15 custom fields for those three types of records (no more than seven per type).

Open the Customers menu and select Customer Center. Make sure the Customers & Jobs tab is highlighted. Double-click on any record to open its Edit Customer window and then click on Additional Info. In the lower right corner, click Define Fields. The window that opens displays four columns. In the first, Label, you’ll enter the names of your new custom fields. Click in any or all of the next three columns to indicate which records should contain them: customer, vendor, or employee.

You can create up to 15 custom fields in QuickBooks Pro and Premier, but you’re limited to seven per record type.

Think carefully about what custom fields you want to create before you start. Once you’ve defined them and started using them in records and transactions, you won’t want to change them.

Adding Custom Fields to Items

You can also add up to five custom fields to your item records. Open the Lists menu and select Item List. Select an item and double-click it to open its Edit Item window, then click Custom Fields over to the right. In the window that opens, click Define Fields. This feature works like the one we just explained for adding custom fields to contact records. You enter the Label name and click in the Use column to create a checkmark.

Using Custom Fields

It’s easy to enter information in the custom fields you’ve created in your customer, vendor, and employee records. You go through the same process you did to create them. Open a record and click Additional Info. You’ll see your new fields in the column to the right. Just enter the information in each record and click OK.

It’s easy to find the custom fields you’ve created and enter the appropriate information in each record.

As we said earlier, the custom fields you’ve created will be available to add to the appropriate form templates when you customize them. You’ll also be able to choose them as filters when you generate reports.

Dealing with Limitations

Obviously. QuickBooks’ custom fields have some shortcomings. You can probably work within the limits placed on contact records, but you may want to track more targeted information than the software’s limits allow when you’re dealing with items. If you sell t-shirts and you have a large inventory in different sizes and colors, for example, you’ll have to create an item record for each configuration rather than using custom fields.

You chose—or may be planning to choose—QuickBooks because it can work for so many types of businesses. Custom fields are one way the software provides to personalize its features. But there may come a time when you outgrow its capabilities. You might need to install an add-on application to deepen specific functional areas like inventory, or you may need to upgrade your edition of QuickBooks entirely. We can help when you reach this point. Please contact us if you need help with the program’s custom fields, or if it’s time for you to expand your current accounting system.

June 29, 2018

Sometimes, you find that your business needs to keep track of more information about items, customers, vendors, or employees than QuickBooks has available fields for. Not everyone needs the same information, so it makes sense to be able to track what’s important to you. For situations like this, there’s a solution in the form of custom fields. These are fields that you can add to several of your lists, specifying what they’re for, and what type of data they can hold. You can even choose whether they’ll be required when creating a list element or a transaction.

Breaking Down Custom Fields

QuickBooks Desktop Pro and Premier allow up to 5 custom fields for items.
QuickBooks Enterprise allows up to 15 custom fields for items.

Pro and Premier can have up to a total of 15 custom fields for customers, vendors, and employees, with a maximum of 7 per category.
Enterprise allows for up to 30 customer/vendor/employee fields with a maximum of 12 per list.

This means that in Pro/Premier, you could have 6 vendor custom fields, 6 customer custom fields, and 3 employee custom fields, or 7, 7, and 1 respectively. Any combination that adds up to 15 or less, with no more than 7 per list.

Similarly, in Enterprise you could have 10 custom fields for each of the three name types, or you could have 12 of two types and 6 of the third type. Again, any combination that adds up to 30 or less, with no more than 12 per list. If you try to add more fields than that, you’ll see an error message:

For the name-related custom fields, even if you have room for more custom fields, selecting too many for a category will give this error:

In either case, you’ll need to re-purpose an existing custom field to make room for the new one, or find another way to track it, such as in the memo field if that’s not otherwise used.

Defining Your Field

Let’s look at the process for creating a custom field. It’s a little different, depending on whether we’re talking about items or names; let’s look at items first.

You’ll start by going to the “Item List” or “Inventory Center” and edit any item.
On the right-hand side of the “Edit Item” window, in the middle of the options is a button labeled “Custom Fields”.
Click that to see the list of currently defined fields. If none exist yet, you’ll see this message:
Let’s listen to the message and click “Define Fields,” then.
When we click that, we’ll get a new window with a list box where we’ll set up each field we want for items, and some parameters about it.

“Label” is the name of the field itself. We could create something like “Color” to track the color of an item, or “Weight,” if that’s something that’s handy for you to have for shipping purposes. After typing in the label, be sure to check “Use” on that row to make the custom field active. The “What kind of data?” option will default to “Any text”. To restrict this, you can select a data format from the drop-down list.

So, for a “weight” custom field, you might want to select numbers only, with whichever decimal option makes the most sense for you. For a “color” custom field, you could use text, but this could lead to many different entries or spellings that would make reporting on this difficult. The option near the bottom, “User’s multi-choice list…” allows us to create a list of custom values in a drop-down menu. In this window, we’ll type in the options we want on the drop-down, one to a line, with no punctuation between. Each entry has a 30-character limit, with a maximum of 100 entries in the list:

If you want to make sure users can only select options you’ve entered, uncheck the box at the bottom that allows users to enter their own text. Otherwise, while an option can be selected from the list, custom text can be manually typed in as well. Click “OK” when you’re done adding entries.

Back on the “Set Up Custom Fields” screen, you can check boxes to choose whether you’d like each field you’ve created to be required, with separate options for whether it’s to be required when creating a list element or when creating a transaction that has the field enabled on its template. Once you’re done creating your field, click “OK” to go back to the item’s custom field window. Here, you’ll now see the fields you created on the left side of this window. You can enter default values here or leave them blank. Default values will auto-fill onto transactions when those elements are used, if set, but they can also be changed on an individual transaction as needed.

To get the custom field onto your transaction, you’ll need to edit the transaction template in the “Additional Customization” window and check off the field for “screen and/or print,” like you would any default field. See our post on customizing templates for further details. As far as custom fields for names go, the process is very similar.

Start by opening the “customer,” “vendor,” or “employee list” and edit one of the names there.
Find the “Additional Info” tab on the left. This is where you can see custom fields for names and fill in default values if desired.
Click “Define Fields” in the lower right to add new fields.

While adding custom fields to items only shows you the item-related custom fields, those for names are all created in the same list. You’re again going to choose a label for the field, but rather than just selecting that the field is in use, you’ll select which list or lists it’s in use for. You’ll also select a data format, just like with the item custom fields, and you’ll select whether these fields are required when saving lists or transactions as well.

If you decide to stop using a custom field, you can uncheck it in the “Define Fields” window to remove it from lists, though note that this will not free up one of the active slots for another custom field. You’d need to re-purpose an existing custom field, which means historical transactions would have the field’s new label but old data, so it’s something to keep in mind before doing so. You can clear out defaults using add/edit multiple list entries, but there’s no way to mass remove the field data on old transactions. If the field has been added to transaction templates, you’ll need to edit those templates to remove the field before you can deactivate it:

Once you’ve decided on the custom fields you need, and set them up, the last step is to start using them! By adding the custom fields to your transactions, and using them when appropriate, not only do you track more details important to your business, but you give yourself another avenue for discovery via reporting.

Many QuickBooks reports will allow you to use custom fields as “columns” and “filters”. You could discover that your customers love purple widgets and don’t care for green ones, and that might really help you plan your next order. Decide on the data that’s important to you, add the fields to track it, and create reports to get you the insights you need from that data. These three steps for making the most of custom fields are just one more way QuickBooks can make it easier for you to empower your business success.

ANNOUNCEMENT:

Looking for more QuickBooks guidance? We’re hosting a Two-Day Seminar/Webinar on QuickBooks Desktop – on the 3rd and 4th of October 2019. It will take place at our Learning Center, and online! Space IS Limited; get your spot while spots remain.