Importing from Revolut

Export your Revolut Stocks trading statements as XLSX and import them to automatically build your transaction history.

Last reviewed

Exporting your data from Revolut

Revolut provides stock trading statements through the app. You can download your trading activity as an XLSX file covering your full transaction history.

Downloading your trading statement

  1. Open the Revolut app on your mobile device
  2. Go to the Stocks section and find its statements or documents option
  3. Choose the date range you wish to export
  4. Download the statement as an XLSX file to your device
If you need to import the file from your computer, you can email the downloaded XLSX file to yourself or use a cloud storage service to transfer it from your phone.

Supported formats and columns

The import wizard recognises Revolut exports in XLSX format by these column headings: activity type, amount, price, quantity, symbol, trade date. The default currency is GBP. A row with a blank currency cell is recorded in USD.

DIVNRA rows (US withholding tax on a dividend) are not imported on their own: each is recorded as a withholding-tax cost on the same-day dividend for the same symbol and currency, and one with no matching dividend is set aside. Free share reward rows are imported as zero-cost buys.

Recognised transaction types

  • buy: recorded as Buy
  • sell: recorded as Sell
  • div: recorded as Dividend
  • ssp: recorded as Stock split
  • mas: recorded as Merger

Costs

This export has no per-trade cost column, so no dealing charges are read from it.

Rows set aside

Some rows are recognised but not imported. The review step lists each one and why:

  • Unrecognised action — not imported
  • Cash transaction — not currently imported
  • Date could not be read — not imported
  • Withholding tax with no matching dividend on the same date — not imported
  • A number on this row could not be read — check it and add it by hand

Rows with an activity type we do not recognise, such as custody fees, cash top-ups or currency conversion entries, are not imported; they are set aside and listed under “View skipped” in the review step, as is a row with a number that cannot be read (“A number on this row could not be read”), so a trade is never booked at zero. Trade dates are read as day/month/year or year-month-day. Check the count on the “Confirm” button (for example “Confirm 12 transactions”) against the number of trades in your statement if you want to be sure nothing you expected was left behind. This is an XLSX file, so importing it needs a plan that includes XLSX import; plans limited to CSV cannot import it.

Step-by-step import

Once you have your Revolut XLSX file ready, follow these steps to import it:

  1. Open Import statements in the sidebar, under Estate & assets → Portfolio
  2. Drop your file on the upload area or click to browse; the upload starts as soon as you choose the file
  3. The system detects the Revolut format from the column headings and reads your transactions
  4. Review the parsed transactions: rows that need attention carry a confidence badge
  5. Resolve any flagged items (e.g. unrecognised symbols or currency mismatches)
  6. Confirm the import (the button shows how many rows will be created, for example “Confirm 12 transactions”) to create your transaction records

Screenshot, for illustration only

The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The importer on its first step, upload, where you say what kind of statement it is, whose it is and which account it belongs to.
Revolut statements are in XLSX format (Microsoft Excel). The import wizard handles XLSX and the older XLS format natively, so you do not need to convert the file to CSV before uploading. It does not assume the headings sit on the first row either, so a title block above the table is no problem.

Cost line-item extraction

The Revolut export carries no cost columns. Revolut folds its commission into the Amount on each row and takes its currency margin inside the exchange rate, so neither appears as a separate figure to read. The currency margin is worked out for you on cross-currency trades and recorded as a foreign exchange cost. For anything itemised beyond that, upload the PDF statement as well.

See Understanding investment costs (opens in a new tab) for how each cost affects cost basis in each supported jurisdiction.

Common issues

Multi-currency transactions

Revolut supports trading in multiple currencies (USD, GBP, EUR, and others) within the same account. Each row in the export carries its own Currency value, and that is what is recorded against the transaction, so a US dollar trade stays in dollars. Where a row leaves the currency blank, it is treated as US dollars, which is what most Revolut stock trades settle in.

Fractional shares

Revolut allows fractional share trading, meaning you may see quantities such as 0.5 or 0.001234 in your export. The import wizard handles fractional quantities correctly, preserving the exact number of shares from the original transaction.

Stock split entries (SSP)

When a stock split occurs, Revolut records an SSP (Stock Split) entry in your statement. The import wizard recognises these entries and reads them as stock splits rather than skipping them. Check the result in your transactions after import.

US-listed securities and symbols

Most Revolut stock trades are for US-listed securities. Ticker symbols in the export follow the standard US exchange format (e.g. AAPL, TSLA, AMZN). European or UK stocks traded through Revolut may use different symbol conventions and could require manual matching during review.

Data security

Your uploaded files are processed using our self-hosted document processing system. Your financial data never leaves our servers without your approval and is not shared with any third-party services. The file itself is kept in your document vault so you can open the original statement alongside the imported rows, and you can delete it from there whenever you wish.

Before you import

Dedicated reader: Revolut files are read by a reader built for their layout, without AI.

These parts of the Statement import guide apply to every broker:

Related pages

Can’t find what you’re looking for?

Our support team is here to help. Contact us and we’ll get back to you as soon as possible.

Contact us

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.