Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

A blank line appears between the name and the address after you import a Name List from an IIF file

After you import a Name (Customer, Vendor,  Employee or Other Name) list, a blank line is inserted between the name and address. The blank line can be seen when printing forms for the Name.

Why this is happening

This occurs when you import a Name List using  the Intuit Interchange Format (IIF) and the import has an error in the its setup. There are multiple address columns in the IIF file with these labels:

  1. Customer Billing Address: BADDR1, BADDR2, BADDR3, BADDR4 and BADDR5.
  2. Customer Shipping Address: SADDR1, SADDR2, SADDR3, SADDR4 and SADDR5.
  3. Vendor or Employee Address: ADDR1, ADDR2, ADDR3, ADDR4 and ADDR5.
  4. Other Name Address: BADDR1, BADDR2, BADDR3, BADDR4 and BADDR5.

If the second address column (BADDR2, SADDR2,  ADDR2) is left blank, and if the street address is entered into the third address column (BADDR3 SADDR3, ADDR3), when imported into QuickBooks, there will be a blank line between the name and address when printing forms.

How to fix it

To resolve this issue, you need to correct the IIF file in Microsoft Excel. Follow these steps to change the address columns that will import into QuickBooks:

  1. Open the IIF file in Microsoft Excel.
  2. Use Copy and Paste to move address elements to the left so that there are no blank cells within any of the addresses.
  3. CAUTION: Using Cut and Paste can alter the structure of the IIF file and cause additional importing issues.
  4. Save the IIF file.
  5. In QuickBooks, go to File > Utilities > Import > IIF Files and import the IIF file.
  6. Verify that the address appears correctly on the forms.



KB ID# SLN41273
4/24/2017 6:06:50 AM
QYPPRDQBKSWS03 9138 Pro 2017 7a785e