Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Import custom fields for Customers, Vendors, or Employees via an IIF File

When importing Customer, Vendor, or Employee information into QuickBooks, you may need to bring in the custom field data as well. Custom fields can be imported through IIF or with the Advanced Import feature in QuickBooks Desktop.
Detailed instructions

For illustration purposes, export your Customer List to your desktop and open the exported file.

In MS Excel, the open file looks like the figure below:

  • Rows 1 and 2 define the IIF file and include the QuickBooks version (cell 2C) and edition (cell 2B).
  • Rows 3 - 20 define your custom fields and assign them to Customer, Vendor, or Employee.  In the highlighted section, three custom fields are set up for Customers, but not for Vendors or Employees. If you have already set up custom fields in your company data file, you can delete these rows from your import file.
  • Row 21 is the headers for the Customer List information. The columns for the custom fields are not shown in the illustration; they are off to the far right.
  • Rows 22 and up are the Customer List information.

KB ID# HOW13111
12/7/2016 7:58:47 PM
QYPPRDQBKSWS05 9138 Pro 2017 f4d342