forums.lyricapps.com

My bank provides CSV files which I use to import transactions. The problem is that they use 2 fields for the amount. One field literally states 'Debit' or 'Credit' (but then in Dutch; Af/Bij), and the other field the amount (without any minus signs for debits).

In V4 I solved this by using a field in iCompta import configuration called 'Amount sign', but it's gone now :'( For me, importing transactions is useless now, as I have to check all transactions if it's debit/credit and change all the amounts accordingly (a lot of work). And without any transactions, iCompta is useless, so I hope to see this fixed (or workaround) really really soon. Thanks a lot in advance!

You can solve this by using a rule. First in the transaction fields mapping screen, map this "Af/Bij" field to the "Comment" field of iCompta for example.
Then go in the Rules screen and create a rule with the condition "The comment is [Dutch word for debit]" and the action "Invert amount". You can also add the action "Replace comment with [nothing]" to get rid of the temporary comment.

Thanks, that's a good solution!