cancel
Showing results for 
Search instead for 
Did you mean: 
MCPOA1
Level 1

Import a Custom Field to add to existing customers

I would like to add a custom field (parcel #) to my customer list. This would be appended to existing customers, and the common key would be the account number, so there are 508 accounts and there will be exactly 508 parcel numbers to import. Does this sound like something QuickBooks Desktop would let me do using a CSV or Excel file?

1 Comment 1
Catherine_B
QuickBooks Team

Import a Custom Field to add to existing customers

Hello there, MCPOA1.

 

You have the option to add custom fields to your Customer Information window. Let me show how:

 

  1. Go to the Customers menu and click Customer Center.
  2. Double-click on a customer whom you'll add a custom field to.
  3. Click the Additional Info menu.
  4. Under CUSTOM FIELDS, click Define Fields.
  5. Enter a label like Parcel Number then modify where to use the field and what kind of data you'll enter. 
  6. Select where the field be required to be displayed is it on a Transaction or List.
  7. Once done, click OK.

To edit existing customer having these data, you can use the Add/Edit Multiple List Entries. Here's how:

 

  1. Click Lists from the menu and select Add/Edit Multiple List Entries.
  2. Under the List drop-down, click Customers.
  3. At the upper-right, click Customize Columns to add the Parcel Number field. 
  4. Click OK and start adding parcel numbers to your customers.
  5. Select Save Changes.

Check out these articles for more details about personalizing your sales forms and managing customer profile:

 

Stay in touch whenever you need additional information. I'm always around to help.

Need to get in touch?

Contact us