Importing Paypal CSV file
Posted: Sat Sep 04, 2021 3:39 pm
Hi, I am trying to import a PayPal CSV file into MMEX. There is only one column for transactions in the CSV file, either positive values or negative, so I select in the 'Amount' section, in the Import Dialog, 'Positive values are deposits'. The file is imported successfully, but all the amounts have been imported as withdrawals, even though many are deposits!
Here are the first five entries in the CSV account I have tried (this is my first time using MMEX):
Date,Name,Type,Net,Balance,,,
03/12/2014,John Smith,General Payment,200.00,200.00,,,
03/12/2014,Peopleperhour.com,Express Checkout Payment,-183.42,16.58,,,
10/12/2014,John Smith,General Payment,-5.00,11.58,,,
22/12/2014,Steven Smith,Website Payment,3.66,15.24,,,
22/12/2014,Indiegogo Inc,Website Payment,-0.36,14.88,,,
(I set the five columns to: 'Date, Payee, Type, Amount, Don't Care' so that the Balance column is ignored. It's really helpful for me to keep it in the CSV file so that I can compare it to what MMEX shows in its balance column after importing the file.)
All the values in the 'Net' column (which I have set as the 'Amount' column in MMEX) appear in the Withdrawals column after importing. I can't find any mention of this 'Amount' option in the help file, nor in this forum, does anybody know what I'm doing wrong? I've tried using 'Positive values are withdrawals' to see if that made any difference - it didn't (not that I expected it to!)
Also, a few little requests for the programmers: In the import dialog window, it doesn't remember any of the settings from the last time you used it. So I have to change to my second bank account every time (I'm importing stuff from my second bank account to begin with), then I have to change the radio button of the fields template I have set up, to number 1, then I have to change the date format, to recognise the Paypal format - every single time. Can it be made to remember all the settings that you used last time?
Secondly - there appears to be no Undo function. So I accidentally imported my second bank account's CSV file into my first bank account, (see previous paragraph for why), and then I had the second bank account's transactions all mixed up with the first bank account's transactions, in date order, and the only possible way I could see to fix this was to manually delete over a hundred transactions from the second account, one by one. Is there no Undo function in MMEX? If so, I can't possibly carry on using it.
Here are the first five entries in the CSV account I have tried (this is my first time using MMEX):
Date,Name,Type,Net,Balance,,,
03/12/2014,John Smith,General Payment,200.00,200.00,,,
03/12/2014,Peopleperhour.com,Express Checkout Payment,-183.42,16.58,,,
10/12/2014,John Smith,General Payment,-5.00,11.58,,,
22/12/2014,Steven Smith,Website Payment,3.66,15.24,,,
22/12/2014,Indiegogo Inc,Website Payment,-0.36,14.88,,,
(I set the five columns to: 'Date, Payee, Type, Amount, Don't Care' so that the Balance column is ignored. It's really helpful for me to keep it in the CSV file so that I can compare it to what MMEX shows in its balance column after importing the file.)
All the values in the 'Net' column (which I have set as the 'Amount' column in MMEX) appear in the Withdrawals column after importing. I can't find any mention of this 'Amount' option in the help file, nor in this forum, does anybody know what I'm doing wrong? I've tried using 'Positive values are withdrawals' to see if that made any difference - it didn't (not that I expected it to!)
Also, a few little requests for the programmers: In the import dialog window, it doesn't remember any of the settings from the last time you used it. So I have to change to my second bank account every time (I'm importing stuff from my second bank account to begin with), then I have to change the radio button of the fields template I have set up, to number 1, then I have to change the date format, to recognise the Paypal format - every single time. Can it be made to remember all the settings that you used last time?
Secondly - there appears to be no Undo function. So I accidentally imported my second bank account's CSV file into my first bank account, (see previous paragraph for why), and then I had the second bank account's transactions all mixed up with the first bank account's transactions, in date order, and the only possible way I could see to fix this was to manually delete over a hundred transactions from the second account, one by one. Is there no Undo function in MMEX? If so, I can't possibly carry on using it.