davols / nordea-ynab-convert

Nordea to YNAB (YouNeedABudget) converter for csv files.
GNU General Public License v2.0
0 stars 0 forks source link

Fix existing SE Nordea rows and add support for new Nordea site #2

Closed mirague closed 4 years ago

mirague commented 4 years ago

Two different sites, two different CSV formats

Nordea in Sweden currently has two portals you can log into. One is the "old" one located at https://internetbanken.privat.nordea.se/ and then there's the new one at https://netbank.nordea.se/.

This modal is shown when logging in: image

CSV format from the "old" site:

I've noticed that the CSV files that are actually exported today are not in line with the fields in bank2ynab. These should be updated accordingly.

Datum,Transaktion,Kategori,Belopp,Saldo
2020-05-05,Reservation Kortköp Spotify,,"-99,00",
2020-05-03,Reservation Kortköp HEMKOP,,"-34,95",
2020-05-05,Swish inbetalning JOHN DOE,,"3.000,00","8.778,76"
2020-05-05,Kortköp 200999 YOU NEED A BUDGET,,"-50,19","5.778,76"
2020-05-05,Autogiro K*SomeStore,,"-943,00","5.828,95"
2020-05-04,Kortköp 200999 APPLE COM BILL,,"-9,00","6.779,95"
2020-05-04,Kortköp 200999 STEAMGAMES COM,,"-165,00","6.788,95"
2020-05-01,Vardagspaket Månadspris kort,,"-12,00","6.953,95"
2020-04-30,Autogiro K*HEMKOP,,"-279,36","6.965,95"
2020-04-29,Autogiro K*DISCORD* N,,"-50,60","7.245,31"

CSV format from the new site:

Bokföringsdag;Belopp;Avsändare;Mottagare;Namn;Rubrik;Saldo;Valuta
2020-05-05;3000,00;;NAID-SE-SEK-7001011234;;Swish inbetalning JOHN DOE;8778,76;SEK
2020-05-05;-50,19;NAID-SE-SEK-7001011234;;;Kortköp 200501 YOU NEED A BUDGET;5778,76;SEK
2020-05-05;-943,00;NAID-SE-SEK-7001011234;;;Autogiro K*SomeStore;5828,95;SEK
Invalid date;-99,00;NAID-SE-SEK-7001011234;;;Reservation Kortköp Spotify;;SEK
Invalid date;-34,95;NAID-SE-SEK-7001011234;;;Reservation Kortköp HEMKOP;;SEK
2020-05-04;-15,00;NAID-SE-SEK-7001011234;;;Kortköp 200428 PP*0000CODE;6771,95;SEK
2020-05-04;15,00;;NAID-SE-SEK-7001011234;;Återköp 200428 PP*0000CODE;6786,95;SEK
mirague commented 4 years ago

Woops wrong repo!