search

leolabs / you-need-a-parser

Convert CSV files to a format that can be imported in YNAB
https://ynap.leolabs.org
MIT License
33 stars 12 forks source link

Has Revolut changed the CSV structure? #554

Open mfilej opened 2 years ago

mfilej commented 2 years ago

I tried dropping a .csv I got from the Revolut website (tried via the iOS app as well) and the YNAP website said "No parser is available for this file."

I glanced at the spec and the filename seems to match, but the CSV header looks different than the one in the spec file.

From the spec file:

const content = `Completed Date ; Reference ; Paid Out (RON) ; Paid In (RON) ; Exchange Out; Exchange In ; Balance (RON); Exchange Rate ; Category
24 Mar 2020 ; Premium plan fee ; 29.99 ;  ;  ;  ; 13.09 ;  ; Services
1 Apr 2019 ; To Piglet ; ; 1.42 ;  ;  ; 43.08 ;  ; Transfers

The file that I exported:

Type,Product,Started Date,Completed Date,Description,Amount,Fee,Currency,State,Balance
CARD_PAYMENT,Current,2021-11-30 17:52:23,2021-12-01 05:25:00,petrol.si,-42.01,0.00,EUR,COMPLETED,1073.72

Am I exporting the CSV incorrectly? Or have they really changed format?

leolabs commented 2 years ago

Hey @mfilej,

Sorry for the late reply!

It seems that Revolut have changed their CSV structure. I'll see if I can implement support for the new format this week.