Trouble finding city, state, zip for importing QuickBooks Customers from spreadsheet

I'm trying to build a spreadsheet to import customers from another application. I have QB2011. When editing addresses, the screen shows City, state,zip. Bbut when constructing the import using column specifications found here: it doesn't list those as defined fields. It shows BILLING ADDRESS 1 - BILLING ADDRESS 5, and likewise for SHIPPING. Do ADDRESS 3, 4 and 5 correspond to city, state ZIP? Am I looking at the wrong web page for definitions? How to I set up a spreadsheet to import these fields?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Open QuickBooks, then go to File, Utilities, Export, Lists to IIF files, and export the Customer List.

The resulting IFF file will show the fields at the top of the list and should give you the variables you need. I use IIF lists this way.
MarkAuthor Commented:
That was a brilliant idea, that may ultimately work! However, not quite there. The first several lines of the post-processed IIF file give:

NAME    Howey Cheatem
TIMESTAMP       1411131157
BADDR1  Attorney Dewey, Cheatem
BADDR2  1350 Standard Building
BADDR3  1370 Ontario St.
BADDR4  "Cleveland, OH 44113"
SADDR1  Attorney Dewey, Cheatem
SADDR2  1350 Standard Building
SADDR3  1370 Ontario St.
SADDR4  "Cleveland, OH 44113"

which shows city, state and ZIP integrated into ADDR4. No other columns in this export show ZIP code. Yet the QB Edit Customer > Edit Address Information show these fields broken out (see image).

What's going on?

Also, point of confusion ... The IIF export shows single-word column names like REFNUM, BADDR1, FIRSTNAME whereas the web-link on Importing Excel lists column names like ACCOUNT NUMBER, BILLING ADDRESS 1, FIRST NAME, etc. Does QB's import recognize these as synonyms? Confusing.
JohnBusiness Consultant (Owner)Commented:
I think you must combine city - state - zip into one field. It is the QuickBooks program that is interpreting the one field. So for me, it interprets  city - state - zip as city - province - postcode.

So I think you must use the one field in the IIF file as it was designed.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

MarkAuthor Commented:
OK, I'll give that a test run and see what it does. I'll let you know.
MarkAuthor Commented:
Thanks - didn't really pursue this as we upgraded QuickBooks and apparently the problem/need went away (I'm not the primary QB user).
JohnBusiness Consultant (Owner)Commented:
Thank you for the update.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.