Supplemental Guide Lesson 2: Import List Data Module 10: Complex Conversions 67 If importing customer and vendor lists: The address, city, state and ZIP are separate fields. If your list of existing customers or vendors is coming from QuickBooks Desktop, the address may be all in one field. You will need to break this data into separate fields for each record. It is suggested that you clear the opening balance and opening balance date fields. Otherwise, upon import, QuickBooks Online will create an invoice for the customer or bill for the vendor for the opening balance amount — invoices posting to AR, and income or bills posting to AP and other expense accounts. It is preferred that customers and vendors are imported first, then the individual transactions that make up the balance due be entered using the proper items or account details.