Convert Revolut statements to Excel, CSV or QBO

You can choose PDF or Excel when you download a personal statement. In the app, open the currency under Accounts on the Home screen, tap Statement, pick the timeframe and the format, and generate and share the file. On the web the steps are similar: open Accounts, pick the currency account, choose Statements, select the timeframe and file type, and download. Repeat for each currency. Business accounts have statements per currency account as well, and Revolut lists PDF, CSV and CAMT.053 XML formats for them, with MT940 mentioned on some pages.

Since Revolut can give you Excel or CSV directly, the converter matters mainly when the PDF is the only copy you have. That happens more often than you might think. A PDF is what lenders and letting agents ask for, so it is often the file that gets saved, emailed and archived, while the spreadsheet version is never downloaded.

When a PDF contains more than one currency block, the converter reads each block on its own. Every currency keeps its own opening balance, its own closing balance and its own balance check, and there is no conversion between currencies. Euro rows stay in euros, dollar rows in dollars. If you are importing into QuickBooks or Xero, the cleanest approach is one bank account per currency in your ledger and one converted file per currency to go with it.

The details of the transaction table are the least certain part of this page. The converter expects separate Money out and Money in columns, a running Balance column and short dates such as Jan 5, 2024. These come from public descriptions and are not confirmed on an official Revolut page. If your statement looks different, for example with a single signed amount column or another date style, the balance check is where a mismatch will show.

Within the assumed layout, the converter takes the direction of a payment from its column. Money out becomes a negative amount, Money in a positive one. Each row's balance can be checked against the previous row, as well as against the closing balance of the block. Descriptions that wrap onto a second line, such as a reference under a transfer, are joined back into the description of their row.

Revolut is marked Beta here. The test replica was built from public descriptions and an assumed layout, not from a real Revolut statement, so it stays Beta until real files confirm or correct it. Scanned or photographed statements are not supported.

After the balance check passes, download Excel or CSV, or produce a QBO, OFX or Xero CSV file for each currency.