Improvement: Import csv please include record_type 'expense' or 'income'
When importing csv files, record_type is not supported so all are imported as income.
Hello, well we judge now if it is income or expense by the fact if it is + or - item. You can have + and - in Income category (I know how it sounds, but some users do it) - the only way of telling if you got or gave money is by its positive or negative value.
We are considering best implementation for two column CSV files and it should be implemented in one of next import improvements, thanks for the report.
So possible solution for you would be to mass edit your CSV in excel and everywhere, where it is Expense add - before the number and then merge these columns into one.
=(incomeColumn) - (expenseColumn)
Роман Ковтюх commented
I have the same issue. In csv-file from my bank there are two separated columns for debit and credit operations. So it would be better if I could specify different column for each transaction type.
Having the same problem. However, I'm not sure it's necessary to add record_type if the category already has a setting of Expense / Income. I would have assumed that imported records would use the category template metadata. However, upon import the exp/inc field is ignored. All imported records are set to income regardless of the category setting.