Revolut CSV to QIF
How to convert a Revolut Account Statement to Quicken Interchange Format (QIF)
Update:
Revolut has changed the format of the CSV export file and my service has not worked anymore. Since there was too little interest in the service I have decided to shut it down. Contact me, if you are still interested in the Revolut to QIF converter.
If you have a Revolut account and track your finances in some software, you know it is very annoying to enter the transactions manually. In the best case, the software can import transactions automatically. If there is no auto-import option for your Bank, you can often do it manually, if the Bank provides you with a compatible account statement export file.
The problem is: there is no defined standard for an account statement in the Excel or CSV format!
Every Bank has its account statement export format with custom column order and names. So, in most cases, you will need to edit the exported CSV/Excel file before import to your financial software.
In the case of Revolut, the export format is very uncommon, and I had to edit the CSV file a lot before I could import it into my banking software.
They have split the “Amount” column into two separated columns for received and paid transactions. So I had to join these columns in Excel since my banking software cannot import two amount columns.
I thought: “There should be a better way to do it!” and spend a couple of evenings building a small web service for this task.
Here it is: https://revolut2qif.tolbxela.com
Now I have a nice semi-automated way to convert the Revolut account statement into a file in the Quicken Interchange Format (QIF), which is widely supported and can be easily imported by my banking software.
Here is my way to do it:
1. Export the account statement as an Excel file
- Select your account in the Revolut app and click to the Icon
- Choose “Statement”
- Choose “Excel” as export format
2. Convert the file with Revolut2QIF
- Go to: the service was shut down
- select and upload your CSV file
If everything goes well, the converted QIF file will be automatically downloaded.
Now I can import the QIF file in my banking software.
The best thing is, your data is absolutely safe!
The Revolut2QIF service does not save files locally to convert them. The whole converting happens on the fly in the server’s memory.
This means, that:
All data from your file is immediately forgotten after converting.
And even better, the service is free now and does not cost you a cent!
Happy converting! ;-)
