ING Columns

[DavidJinho]

Hi Niels,

Thanks for creating this tool! I'm trying to set it up for my ING account however not sure how I should set up the columns.

ING provides me with:
Date, Payee, Account, Counterparty, Code, Debit/Credit, Amount, Transaction Type, Notifications, Resulting Balance, Tag

Could you tell me how to do this correctly? Also, there is no column for inflow and outflow, all amounts are in one column and the previous debit/credit column indicates if its an outflow or inflow.

Thanks,
David

[nielsmaerten]

Hi David,
You're going to want to try the v1.1.0 preview. This new version supports the column layout you're describing.

Here's an example of what your parser configuration could look like:

- name: ing-checking
  header_rows: 1
  footer_rows: 0
  delimiter: ";"
# Date, Payee, Account, Counterparty, Code, Debit/Credit, Amount, Transaction Type, Notifications, Resulting Balance, Tag
  columns: [date,payee,skip,skip,skip,in_out_flag,amount,skip,memo,skip,skip]
  outflow_indicator: "Af"
  date_format: yyyy/MM/dd

Note the new "in_out_flag" column and the "outflow_indicator":
If the value in the column "in_out_flag" is 'Af', the number in "amount" will be treated as outflow. Otherwise, ynab-buddy will assume it's inflow.

Hope this works for you!
I'm still testing out v1.1.0, so let me know if you run into any bugs ;)

[DavidJinho]

Hi Niels,

Thanks, that did the trick! Appreciate you making this, super helpful :)

One thing I noticed is that the flag color is not working, maybe that's a bug.

Thanks,
David

[nielsmaerten]

Hey David,
What's the color you've set for the flag? Here's a list of the ones that work.

Also, the color will only be set if the transaction wasn't already in YNAB.
That means if you previously entered the transaction manually, then that color will be used after the manual transaction gets matched with the imported one.

If it's still not working the way it should, feel free to open a bug report :)
cheers,
niels

[DavidJinho]

He Niels,

I just kept it default to be honest, so purple.

I'll try it again when I have some more transactions next week.

Cheers,
David

[DavidJinho]

Hi Niels,

Just to follow-up on this, I changed the color to blue and did another import, and all worked fine.

Cheers,
David