@EmeraldLLC wrote:
Herein lies my question: When I'm in the Add/Edit Multiple List Entries screen, I get columns titled "Company Name", "Name", "Phone", "BillTo 1", "BillTo 2", etc.
In my "BillTo 3" field, the CITY, STATE & ZIP is all in one cell.
When is Quickbooks going to sort this out so I can have one column for city, one for State, and one for zip, so I can sort my list effectively??
@EmeraldLLC
Prepare your Customer List data with the following template
| Customer Name | Is Active | Company Name | Salutation | First Name | M.I. | Last Name | Job Title | Contact | Phone | Fax | Alt. Phone | Alt. Contact | Email | CC | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Customer Type | Terms | Sales Rep | Resale No. | Price Level | Account Number | Credit Limit | Payment Method | Notes | Sales Tax Code | Sales Tax Item | Job Status | Job Start Date | Job Projected End | Job End Date | Job Description | Job Type | Currency |
| Acme Tools | Y | Acme Tools | Mrs. | Jane | M | Doe | AP Clerk | Jane Doe | (908) 123-4567 | (908) 123-4567 | (908) 123-4567 | John Doe | [email address removed] | | Acme Tools | One Main Street | | | Washington | WA | 12345 | USA | Acme Tools | One Main Street | | | Washington | WA | 12345 | USA | Commerical | Net 30 | KLM | ACME | Commercial | 989 | 1000 | Visa | This is a commerical customer. | Tax | MA | | | | | | | |
| Adams Landscaping | Y | Adams Landscaping | Mr. | John | | Smith | Manager | John Smith | (777) 888-9999 | (777) 888-9999 | (777) 888-9999 | Jane Smith | [email address removed] | | Adams Landscaping | Two Church Street | | | Smithville | OH | 98765 | USA | Adams Landscapting | Two Church Street | | | Smithville | OH | 98765 | USA | | Net 30 | | | | 12345 | 5000 | Check | This is a new customer | Non | | | | | | | | |
| Superstore | Y | Superstore | Ms | Karen | | Jones | | Karen Jones | (888) 888-8888 | (888) 888-8888 | | | [email address removed] | | Superstore | 1 North Street | | | Anytown | TN | 88888 | USA | Superstore | 1 North Street | | | Anytown | TN | 88888 | USA | | Net 30 | | | | | | | | Tax | MA | | | | | | | |
| Timmy's Gas Station | Y | Timmy's Gas Stattion | Mr. | Tim | | Burnham | | Tim Burnham | (777) 777-7777 | (777) 777-7777 | | | [email address removed] | | Timmy's Gas Stattion | 1800 West Street | | | Jones | AL | 98765 | USA | Timmy's Gas Stattion | 1800 West Street | | | Jones | AL | 98765 | USA | | | | | | | | | | | | | | | | | | |
then utilize one of these migration tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
