My credit card statement has two kinds of debit entries:
- Payments from my bank account
- Refunds from retailers (say because of a return)
In my csv import rule, I have a rule that filters the first item, where I assign account2 to a dummy “transfers” account that I will match payments to from my bank statement.
if %description BPAY PAYMENTS
account2 transfers:credit:coles
However, I am not sure how to filter the second category. They show up with seemingly random descriptions. I don’t see a way to do an if condition on whether the amount if positive or negative. So all of the refunds get assigned to the default “income:unknown” category. I’d ideally like to assign account2 in this case to something like “transfers:credit:refunds”.
If there is no way of detecting those, but having said that, i’d delve deeper in the
if
statement. You can also make combo’s with and (prefix the next line with ampersand character) and using field matches.