How to setup hledger csv import rules for credit card statements?
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".
You can use an if rule with a regular expression pattern to match on positive/negative. Eg
But that doesn't sound helpful here since as you say they are both debits.
The payments from the bank should have fairly consistent descriptions, can't you filter on that ?
If there is no way of detecting those, but having said that, i'd delve deeper in the
ifstatement. You can also make combo's with and (prefix the next line with&character) and using field matches.