Won't import csv file of bank ledger from QuickBooks 2017 Pro into Express Acccounts.

[MickeyM]

When clicked on the CSV Import wizard, the click to assign function does not produce any drop downs to assign the csv headers to the EA data fields.

It did once but did not import any data. Now it won't do anything at all with the csv file.

[YS LI]

1) Yes , I 'd the almost same problem. A little lucker than you is that some of my data can be transfered,  it was transaction date, but the others,  nothing. 

2)  I 'd read the online  help again and realized that key role of  " assign function"   is to build up a so call - "matched " link -  between your csv data and express account formatted data base.  The reason you didn't get any data is  because the " matached link " didn't build up successfully.   

3) To to that,  I decided to give  my data a proper  title at top of  each coloum  in my CSV file, delete any empty rows between the title row and data rows, and click the  save button (not the save as)this csv file again, and close it.  

4) After that I tried to do the assignment again. The good thing is datas can be inputed now , but bad thing is data are wrong or in wrong place.

5) I had  tried  assign my  data titles  to   "Date,  Memo,Amount,Deposit, Paymen "   individually  many times,  finally I found one of them works well.   Bank data was transfered into my EA,  all the transaction date and amount are correct.  There still exist some mistakes and missing data,  it were not 100% as expected but  good enough for me.

6 ) The reason why its not 100% perfect , I think because there are so many banks in the world, and each bank has its own format  at the title area, and the express account won't recognized each of them.  For example, my bank's csv file,  at title area, there are only two cells has data,   1st  cell's data is  "Account details for:"   The 2nd  cell's data is  my account info: "XXXbank  -- number XXX" .  If I didn't do any changes , when I do "bank reconcile "-  only this two datas  "Account details" and "XXXbank --numberXXX" will be assigned to  Date,  Memo,Amount,Deposit, Payment -- any one you wish to assign to.  Obviously, those are  wrong. Another reason is that when  using excel to open csv file and save it again, some data format may be changed or lost  and lead to the disorder in transfering data into EA.

7) Except your bank and EA has  sit down and work together to work out a standard CSV format and work flow to let EA recognized it automatically , you won't get a 100% automate transfered result

😎 Hope my experience may help you.