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
Won't import csv file of bank ledger from QuickBooks 2017 Pro into Express Acccounts.
in Express Accounts
Posted
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.