Import your ING Germany bank statements via FinTS into YNAB.
Setup
Before setting this up, please register your FinTS product – it's free and takes only a few days.
If you don't do this, the application will fallback to the product id from the python-fints library, which should only be used for evaluation.
Since this application will need your ING pin and YNAB access token it's recommended to run this in your local network (could be a Raspberry Pi, it's pretty light).
There are various ways to start the application:
Local
This can be run on any environment with Python 3.7 or higher.
$ python3 -m pip install ing-ynab
$ touch .env # see configuration section
$ ing-ynab
Docker
$ cp .env.example .env # and customize fields
$ docker run --env-file .env docker.pkg.github.com/bahlo/ing-ynab/ing-ynab:2.0.2
docker-compose
version: "2.0"
services:
ing-ynab:
image: docker.pkg.github.com/bahlo/ing-ynab/ing-ynab:2.0.2
environment:
# Environment variables, see the configuration section
Configuration
The configuration is done via environment variables:
SLEEP_INTERVAL_SECONDS: Interval in seconds until the next check happens (defaults to 5 minutes).FINTS_PRODUCT_ID: Your FinTS product ID (deafults to python-fints one).ING_LOGIN: The login id of your ING account.ING_IBAN: The IBAN of the account you want to add.ING_PIN: The pin of your ING account (leave empty to be prompted).YNAB_ACCESS_TOKEN: Go to your budget settings to create one (leave empty to be prompted).YNAB_BUDGET_ID: On the webpage of your budget the first UUID in the path (https://app.youneedabudget.com/<BUDGET_UUID>/budget/202109).YNAB_ACCOUNT_ID: On the webpage of the bank account the last UUID in the path (https://app.youneedabudget.com/<BUDGET_UUID>/accounts/<BANK_ACCOUNT_UUID>).YNAB_FLAG_COLOR: If set, use that color for the imported transactions.DEBUG: Set to1to enable debug output and print transactions instead of importing them.
Security
You can pass in your bank pin and YNAB access token via environment variables, if you like. This has the drawback that anyone with system access can read and potentially use them so it's discouraged (but supported).
The alternative is not specifying YNAB_ACCESS_TOKEN and/or ING_PIN, which will cause the application to prompt you on startup. This has the drawback that you need to input them everytime the application restarts.
For docker you'll need to pass the -it flags to be able to input these variables. For docker-compose, add these fields:
tty: true
stdin_open: true
After starting with docker-compose up -d, run docker attach $container_id to attach to the container. Note that the prompt for the pin might be hidden, so you have to enter the pin directly.
FAQ
Why is this ING-only? Isn't FinTS a general protocol?
It is, but the implementations differ a lot. This actually started out as a general-purpose library but I can only really test ING and I rather have a specialised library than a multipurpose one where I can't guarantee functionality.
Can you support my bank?
The python-fints library supports a lot of banks, so probably. But we need to work together as I can't test it. Feel free to get in touch: [email protected]
How do I register the FinTS product?
- Go to the FinTS product registration
- Click
Registrierungsprozessto get to a PDF form - Fill in your data. If you don't know what else to put, here are some suggestions:
Firmenbezeichnung: Your nameProduktname:ing-ynabProduktkategorie:Web-Server
- Send the form to the email adress on the last page
After a week or two you will get your product id via email.
0 Oct 08, 2022
1.2k Jan 01, 2023
44 Dec 14, 2022
17 Dec 23, 2022
43 Oct 14, 2022
8 Nov 07, 2022
89 Aug 06, 2022
12 Jul 19, 2022
6 Jan 18, 2022
62 Nov 16, 2022
1 Nov 24, 2021
15 Dec 12, 2022
46 Dec 23, 2022
36 Oct 30, 2022
1 Dec 15, 2021
83 Dec 12, 2022
1.1k Dec 26, 2022
0 Jun 25, 2022
159 Dec 12, 2022
24 Sep 29, 2022