Plain Text Accounting

165 readers

1 users here now

Bookkeeping and accounting with plain text files and scriptable, command-line-friendly software, such as Ledger, hledger, or Beancount.

founded 2 years ago

MODERATORS

zako

How to setup hledger csv import rules for credit card statements? (aussie.zone)

submitted 2 years ago by [email protected] to c/plaintextaccounting

2 comments fedilink hide all child comments

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 are viewing a single comment's thread
view the rest of the comments

[–] simonmic 1 points 2 years ago

You can use an if rule with a regular expression pattern to match on positive/negative. Eg

if %theamountfield /^-/

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 ?