Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowWhen using the import file technique, the Name field is required. The name field is an individual's name. It can't be left blank.
If it is blank, does that skew the loos of the invoice?
Thanks!
Good day, @KT_HM. I'll share insights about importing customer lists in QuickBooks Online.
Once you import your customer's data, it's required to enter a customer's name since it's a part of the required field during mapping. This is why the system won't allow you to leave it blank.
In addition, the system won't allow to save an invoice if the customer's field is blank.
As a workaround, I'd suggest looking for a third-party app that would help import your customer's data into QuickBooks. Simply go to the Apps menu and click Find apps. Then, search for the application from there.
Moreover, I'd recommend sending this suggestion to our developers. They can review your request and most likely include it in future updates.
You can always get back to the Community if you have follow-up questions. We're ready to help you out.
The Display Name field is the only mandatory one to import Customer list data
Title | Company | FirstName | MiddleName | LastName | Suffix | DisplayName | PrintOnCheckName | BillingAddressLine1 | BillingAddressLine2 | BillingAddressLine3 | BillingAddressLine4 | BillingAddressCity | BillingAddressState | BillingAddressPostalCode | BillingAddressCountry | ShippingAddressLine1 | ShippingAddressLine2 | ShippingAddressLine3 | ShippingAddressLine4 | ShippingAddressCity | ShippingAddressState | ShippingAddressPostalCode | ShippingAddressCountry | PhoneNumber | MobileNumber | FaxNumber | OtherNumber | WebSite | CustomerType | SalesTerm | DefaultTaxCode | TaxExemptionReason | ResaleNumber | PaymentMethod | PreferredDeliveryMethod | BillWithParent | Currency | Notes | |
Mr. | Abacus Industries | Janice | Johnson | Janice Johnson | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 400 East Street | Dallas | TX | 99875 | (603) 555-2000 | (603) 555-2001 | (603) 555-2002 | (603) 555-2003 | [email address removed] | Residential | Net 30 | 12345678 | Check | Y | ||||||||||||||||
Mr. | Walker Associates | Leonard | Walker | Leonard Walker | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | (603) 555-3000 | (603) 555-3001 | (603) 555-3002 | (603) 555-3003 | [email address removed] | Commercial | Net 30 | Check | |||||||||||||||||||
Mr. | Pinnacle Partners | Lisa | Smith | Lisa Smith | 19 Jerico Drive | Bensalem | PA | 84256 | 19 Jerico Drive | Bensalem | PA | 84256 | (603) 555-4000 | (603) 555-4001 | (603) 555-4002 | (603) 555-4003 | [email address removed] | Net 30 | Check | None |
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here