bobwill Posted December 11, 2014 Share Posted December 11, 2014 What is the format of the CSV file that MoneyLine expects. My bank CSV ouput file contains a deposit and payment field. It appears to me that the assingment of fields in the field transactions menu does not allow you to have more than one "amount" field..... My format is : DATE, CHECK NUMBER, PAYEE, CATEGORY, PAYMENT, DEPOSIT ANY ADVICE.????? I KNOW THE SUBJECT SHOULD BE CSV NOT CVS THE PHARMACY Link to comment Share on other sites More sharing options...
nextstep Posted March 6, 2015 Share Posted March 6, 2015 There needs to be some sort of reprogramming so that there are alternative input fields. My CSV gives also Deposit & Withdrawl and having to massage my withdrawls with a -1 to give the correct amount is quite tedious. Can I suggest MoneyLine is adjusted to allow either "Amount" OR "Depost" & "Withdrawl" when choosing input fields? Can I also suggest tha the "Options" section has a "CSV Import" tab where fields can be selected & remain as default for future. thanks. Link to comment Share on other sites More sharing options...
alex.v Posted May 15, 2016 Share Posted May 15, 2016 I am a new user. bought it, hope it actually works. try to upload data from the csv file. mapped the fields as requested - pause and then still the same empty table on the screen. no messages, no transactions. what should i do to have my data on? Link to comment Share on other sites More sharing options...
cobbies Posted November 26, 2017 Share Posted November 26, 2017 If you import your CSV into Excel, you can quickly combine deposit and withdrawal columns using a formula like =IF(D2=0,E2,0-D2). You need to adjust the formula depending on which columns you have withdrawal and deposit data, but once you get the formula correct, it's very simple to move your mouse to the lower right corner of the cell that you typed the formula into and double click and Excel will run down the sheet and put the correct value in every cell. Then you can re-save the file as a CSV and it will import correctly Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now