Revolut Business Integration Skill v1.0
General reference only. This skill is general tax/accounting reference material for AI-assisted workflows. It has not been reviewed for any specific person's facts, documents, elections, deadlines, residency, filing status, or local procedures. Do not rely on it to file, pay, amend, or take a tax position without review by a qualified professional in the relevant jurisdiction.
Section 1 — Platform Overview
Revolut Business is a fintech banking platform offering multi-currency business accounts, corporate cards, expense management, and international payments. Headquartered in London, Revolut operates across the EEA, UK, US, Australia, and Japan. It is popular with startups, freelancers, and SMEs that need multi-currency capabilities without traditional banking overhead.
Revolut Business provides per-currency account statements and an aggregated transaction export. Unlike traditional banks, Revolut uses a neobank model with real-time transaction data and card-level spending controls.
Section 2 — Export Formats
| Format |
Use Case |
| CSV |
Transaction statements (per account or all accounts). Downloaded from Transactions > Export. |
| Excel (XLSX) |
Same data as CSV but formatted for Excel. |
| PDF |
Official bank statements. Per-currency, monthly. Required for formal purposes. |
| MT940 |
SWIFT standard for accounting software integration. |
| CAMT.053 |
European XML banking standard. |
| QIF |
Quicken import format. |
CSV exports are available per-currency account or aggregated. Column headers vary slightly by region and timezone setting.
Section 3 — Column Mapping
Transaction Statement CSV
| Column Header |
Meaning |
| Date started (UTC) |
Timestamp when the transaction was initiated. Format: YYYY-MM-DD HH:MM:SS. Timezone depends on account settings — may say "(UTC)" or "(Europe/Amsterdam)" etc. |
| Date completed (UTC) |
Timestamp when the transaction was completed/settled. Same timezone note as above. |
| ID |
Unique Revolut transaction identifier. |
| Type |
Transaction type code (see Section 4). |
| Description |
Transaction narrative: counterparty name, merchant, transfer reference. |
| Reference |
Payment reference or memo. |
| Payer |
Name of the person/entity who initiated the payment (incoming transfers). |
| Card number |
Last 4 digits of the card used (for card payments). Blank for non-card transactions. |
| Orig currency |
Original currency of the transaction (before any conversion). |
| Orig amount |
Original amount in the original currency. |
| Payment currency |
Currency the payment was settled in. |
| Amount |
Settlement amount in the payment currency. Positive = money in, negative = money out. |
| Fee |
Fee charged by Revolut for this transaction. Usually 0.00 for standard transactions. |
| Balance |
Running balance after this transaction in the payment currency. |
| Account |
Name/identifier of the Revolut account (e.g., "Main GBP", "EUR account"). |
| Beneficiary account number |
Recipient's account number (for outgoing transfers). |
| Beneficiary sort code or routing number |
Recipient's sort code (UK) or routing number (US). |
| Beneficiary IBAN |
Recipient's IBAN (for SEPA/international transfers). |
| Beneficiary BIC |
Recipient's BIC/SWIFT code. |
Note: Some regional exports may include additional columns like "Date started (Europe/London)" or omit "Date started (UTC)" depending on the account's timezone settings.
Section 4 — Transaction Type Codes
| Type |
Meaning |
| CARD_PAYMENT |
Debit card purchase at a merchant |
| CARD_REFUND |
Refund to the debit card |
| TRANSFER |
Bank transfer sent or received (SWIFT, SEPA, Faster Payments, ACH) |
| EXCHANGE |
Currency conversion between Revolut balances |
| TOPUP |
Money added from an external bank account or card |
| ATM |
Cash withdrawal from ATM |
| FEE |
Revolut service fee (subscription, card replacement, etc.) |
| REWARD |
Cashback or promotional credit |
| DIRECT_DEBIT |
UK/SEPA direct debit payment |
| TAX |
Tax withholding (applies in some jurisdictions for interest) |
| INTEREST |
Interest earned on balance |
| LOAN |
Loan disbursement or repayment |
Section 5 — Fee Structure
| Fee Type |
How It Appears |
| FX conversion (within allowance) |
Zero fee. Exchange at interbank rate during market hours. |
| FX conversion (over allowance or weekend) |
0.4%–1% markup on exchange rate. Appears as implicit spread, NOT as a separate fee. |
| International transfer (SWIFT) |
Fee in the Fee column. Typically £3–5 per transfer. |
| SEPA transfer |
Free on most plans. |
| UK Faster Payments |
Free. |
| Card payment (domestic) |
Free. |
| Card payment (cross-currency) |
Exchange rate spread applies. No explicit fee in the Fee column. |
| ATM withdrawal (over limit) |
Fee appears in the Fee column. £2 per withdrawal over the monthly limit. |
| Monthly subscription |
Separate row with Type = FEE. Free, Grow (£25/mo), Scale (£100/mo), Enterprise (custom). |
| Card replacement |
Separate row with Type = FEE. |
Section 6 — Tax-Relevant Fields
| Field |
Notes |
| Orig currency / Payment currency |
Needed for FX gain/loss calculations and determining tax jurisdiction. |
| Fee |
Deductible business expense. |
| Type = INTEREST |
Taxable income. |
| Type = TAX |
Tax withholding already deducted (e.g., interest withholding tax in some jurisdictions). |
| Beneficiary details |
IBAN, BIC, account number — needed for cross-border payment reporting (CRS/FATCA). |
| Account |
Identifies which currency balance the transaction belongs to. |
Revolut does not collect VAT/GST on behalf of merchants. Revolut's own subscription fees include VAT where applicable (shown on Revolut's invoice, not in the transaction CSV).
Section 7 — Multi-Currency Handling
| Scenario |
How It Appears |
| Single-currency account |
All rows share the same Payment currency. Straightforward. |
| Currency exchange |
Type = EXCHANGE. Two rows: one debit in the source currency, one credit in the target currency. Orig currency/Orig amount show the source; Payment currency/Amount show the target. |
| Cross-currency card payment |
Single row. Orig currency shows the merchant's currency (e.g., EUR). Payment currency shows the account currency (e.g., GBP). Orig amount and Amount differ by the exchange rate. |
| Implicit exchange rate |
Not shown as a column. Calculate: Amount ÷ Orig amount = effective rate. |
| Weekend/out-of-hours FX |
Revolut applies a markup (0.4–1%) on weekends. The rate is worse but appears the same way in the CSV — only the effective rate reveals the markup. |
Section 8 — Reconciliation Tips
- Timezone in column headers. Check whether the export says "(UTC)" or a local timezone. All dates within a file use the same timezone.
- "Date started" vs "Date completed". Use "Date completed" for bookkeeping purposes — this is when the transaction settled. "Date started" may be earlier for pending transfers.
- EXCHANGE transactions are internal. Currency exchanges between your own Revolut balances are not income or expense — they are inter-account transfers.
- Card payments may have different Orig and Payment currencies. A EUR purchase on a GBP account will show Orig currency = EUR and Payment currency = GBP. The FX conversion happens automatically.
- Fee column is usually zero. Most Revolut transactions are fee-free. When fees do appear, they are in the same row (unlike Wise where fees are separate rows).
- Balance column is per-currency. The running balance only makes sense within a single payment currency. Multi-currency exports may interleave currencies, making the Balance column confusing.
- Match to bank. Revolut IS the bank — there is no separate bank statement to reconcile against. Reconcile the Revolut CSV directly as your bank statement.
Section 9 — Common Gotchas
- Column headers vary by region. UK accounts may show "(UTC)", Dutch accounts "(Europe/Amsterdam)". The data is the same but header strings differ, which breaks parsers.
- EXCHANGE rows create two entries. Like Wise, a currency conversion creates two rows. If you only export one currency account, you see only one side. Export all accounts to see both.
- Orig amount vs Amount confusion. For domestic transactions, these are identical. For cross-currency, Orig amount is in the foreign currency and Amount is in your account currency. Revenue/expense should use Amount (your currency).
- Interbank rate vs Revolut rate. Revolut advertises the interbank rate but adds a markup outside market hours and above monthly allowances. The CSV does not flag when a markup was applied.
- Card number column for card disputes. When reconciling disputed card payments, the Card number (last 4 digits) is essential for matching.
- TOPUP is not income. Money added from your own external bank account is an inter-account transfer, not revenue.
- Fee rows (Type = FEE) are service charges. These are deductible business expenses but are not payment processing fees — they are subscription/service fees.
- Empty Payer field for outgoing. The Payer column is only populated for incoming transfers. For outgoing, look at the Description field for the recipient name.
Section 10 — Sample Data
Date started (UTC),Date completed (UTC),ID,Type,Description,Reference,Payer,Card number,Orig currency,Orig amount,Payment currency,Amount,Fee,Balance,Account,Beneficiary account number,Beneficiary sort code or routing number,Beneficiary IBAN,Beneficiary BIC
2026-03-15 09:23:45,2026-03-15 09:23:45,rev-abc123def456,TRANSFER,From Acme Ltd,INV-1042,Acme Ltd,,GBP,2500.00,GBP,2500.00,0.00,12500.00,Main GBP,,,,
2026-03-15 14:30:00,2026-03-15 14:30:12,rev-ghi789jkl012,CARD_PAYMENT,Amazon Business,,,,GBP,156.99,GBP,-156.99,0.00,12343.01,Main GBP,,,,
2026-03-16 08:00:00,2026-03-16 08:00:05,rev-mno345pqr678,EXCHANGE,Exchanged to EUR,,,,,1000.00,GBP,-1000.00,0.00,11343.01,Main GBP,,,,
2026-03-16 08:00:00,2026-03-16 08:00:05,rev-stu901vwx234,EXCHANGE,Exchanged from GBP,,,,GBP,1000.00,EUR,1152.30,0.00,1152.30,EUR account,,,,
2026-03-17 11:15:00,2026-03-17 11:15:33,rev-yza567bcd890,CARD_PAYMENT,Uber Eats,,,,EUR,23.50,EUR,-23.50,0.00,1128.80,EUR account,,,,
2026-03-18 09:00:00,2026-03-18 09:01:22,rev-efg123hij456,TRANSFER,To Jane Smith Contractor,March payment,,,GBP,3200.00,GBP,-3200.00,0.00,8143.01,Main GBP,12345678,040050,,
2026-03-19 00:00:00,2026-03-19 00:00:00,rev-klm789nop012,FEE,Revolut monthly plan,,,,GBP,25.00,GBP,-25.00,0.00,8118.01,Main GBP,,,,
2026-03-20 15:45:00,2026-03-20 15:45:00,rev-qrs345tuv678,CARD_PAYMENT,Hotel Marais Paris,,,*4521,EUR,189.00,GBP,-163.74,0.00,7954.27,Main GBP,,,,
Disclaimer
This skill and its outputs are provided for informational and computational purposes only and do not constitute tax, legal, or financial advice. Open Accountants and its contributors accept no liability for any errors, omissions, or outcomes arising from the use of this skill. All outputs must be reviewed and signed off by a qualified professional before filing or acting upon.
Source: OpenAccountants — open tax Guides for AI, reviewed by named CPAs/CAs/EAs. Quality: source-cited draft. For always-current figures and named-accountant backing, connect the OpenAccountants MCP server (openaccountants-mcp).
1---2name: revolut-business-integration3description: > Integration skill for Revolut Business statement CSV exports. Activate when the user uploads a Revolut Business CSV, Revolut statement, or mentions Revolut Business transactions.4license: AGPL-3.0-or-later (code) / OpenAccountants Guide License v1.0 (c5---67# Revolut Business Integration Skill v1.089> **General reference only.** This skill is general tax/accounting reference material for AI-assisted workflows. It has not been reviewed for any specific person's facts, documents, elections, deadlines, residency, filing status, or local procedures. Do not rely on it to file, pay, amend, or take a tax position without review by a qualified professional in the relevant jurisdiction.1011## Section 1 — Platform Overview1213Revolut Business is a fintech banking platform offering multi-currency business accounts, corporate cards, expense management, and international payments. Headquartered in London, Revolut operates across the EEA, UK, US, Australia, and Japan. It is popular with startups, freelancers, and SMEs that need multi-currency capabilities without traditional banking overhead.1415Revolut Business provides per-currency account statements and an aggregated transaction export. Unlike traditional banks, Revolut uses a neobank model with real-time transaction data and card-level spending controls.1617---1819## Section 2 — Export Formats2021| Format | Use Case |22|--------|----------|23| CSV | Transaction statements (per account or all accounts). Downloaded from Transactions > Export. |24| Excel (XLSX) | Same data as CSV but formatted for Excel. |25| PDF | Official bank statements. Per-currency, monthly. Required for formal purposes. |26| MT940 | SWIFT standard for accounting software integration. |27| CAMT.053 | European XML banking standard. |28| QIF | Quicken import format. |2930CSV exports are available per-currency account or aggregated. Column headers vary slightly by region and timezone setting.3132---3334## Section 3 — Column Mapping3536### Transaction Statement CSV3738| Column Header | Meaning |39|---------------|---------|40| Date started (UTC) | Timestamp when the transaction was initiated. Format: YYYY-MM-DD HH:MM:SS. Timezone depends on account settings — may say "(UTC)" or "(Europe/Amsterdam)" etc. |41| Date completed (UTC) | Timestamp when the transaction was completed/settled. Same timezone note as above. |42| ID | Unique Revolut transaction identifier. |43| Type | Transaction type code (see Section 4). |44| Description | Transaction narrative: counterparty name, merchant, transfer reference. |45| Reference | Payment reference or memo. |46| Payer | Name of the person/entity who initiated the payment (incoming transfers). |47| Card number | Last 4 digits of the card used (for card payments). Blank for non-card transactions. |48| Orig currency | Original currency of the transaction (before any conversion). |49| Orig amount | Original amount in the original currency. |50| Payment currency | Currency the payment was settled in. |51| Amount | Settlement amount in the payment currency. Positive = money in, negative = money out. |52| Fee | Fee charged by Revolut for this transaction. Usually 0.00 for standard transactions. |53| Balance | Running balance after this transaction in the payment currency. |54| Account | Name/identifier of the Revolut account (e.g., "Main GBP", "EUR account"). |55| Beneficiary account number | Recipient's account number (for outgoing transfers). |56| Beneficiary sort code or routing number | Recipient's sort code (UK) or routing number (US). |57| Beneficiary IBAN | Recipient's IBAN (for SEPA/international transfers). |58| Beneficiary BIC | Recipient's BIC/SWIFT code. |5960Note: Some regional exports may include additional columns like "Date started (Europe/London)" or omit "Date started (UTC)" depending on the account's timezone settings.6162---6364## Section 4 — Transaction Type Codes6566| Type | Meaning |67|------|---------|68| CARD_PAYMENT | Debit card purchase at a merchant |69| CARD_REFUND | Refund to the debit card |70| TRANSFER | Bank transfer sent or received (SWIFT, SEPA, Faster Payments, ACH) |71| EXCHANGE | Currency conversion between Revolut balances |72| TOPUP | Money added from an external bank account or card |73| ATM | Cash withdrawal from ATM |74| FEE | Revolut service fee (subscription, card replacement, etc.) |75| REWARD | Cashback or promotional credit |76| DIRECT_DEBIT | UK/SEPA direct debit payment |77| TAX | Tax withholding (applies in some jurisdictions for interest) |78| INTEREST | Interest earned on balance |79| LOAN | Loan disbursement or repayment |8081---8283## Section 5 — Fee Structure8485| Fee Type | How It Appears |86|----------|---------------|87| FX conversion (within allowance) | Zero fee. Exchange at interbank rate during market hours. |88| FX conversion (over allowance or weekend) | 0.4%–1% markup on exchange rate. Appears as implicit spread, NOT as a separate fee. |89| International transfer (SWIFT) | Fee in the Fee column. Typically £3–5 per transfer. |90| SEPA transfer | Free on most plans. |91| UK Faster Payments | Free. |92| Card payment (domestic) | Free. |93| Card payment (cross-currency) | Exchange rate spread applies. No explicit fee in the Fee column. |94| ATM withdrawal (over limit) | Fee appears in the Fee column. £2 per withdrawal over the monthly limit. |95| Monthly subscription | Separate row with Type = FEE. Free, Grow (£25/mo), Scale (£100/mo), Enterprise (custom). |96| Card replacement | Separate row with Type = FEE. |9798---99100## Section 6 — Tax-Relevant Fields101102| Field | Notes |103|-------|-------|104| Orig currency / Payment currency | Needed for FX gain/loss calculations and determining tax jurisdiction. |105| Fee | Deductible business expense. |106| Type = INTEREST | Taxable income. |107| Type = TAX | Tax withholding already deducted (e.g., interest withholding tax in some jurisdictions). |108| Beneficiary details | IBAN, BIC, account number — needed for cross-border payment reporting (CRS/FATCA). |109| Account | Identifies which currency balance the transaction belongs to. |110111Revolut does not collect VAT/GST on behalf of merchants. Revolut's own subscription fees include VAT where applicable (shown on Revolut's invoice, not in the transaction CSV).112113---114115## Section 7 — Multi-Currency Handling116117| Scenario | How It Appears |118|----------|---------------|119| Single-currency account | All rows share the same Payment currency. Straightforward. |120| Currency exchange | Type = EXCHANGE. Two rows: one debit in the source currency, one credit in the target currency. Orig currency/Orig amount show the source; Payment currency/Amount show the target. |121| Cross-currency card payment | Single row. Orig currency shows the merchant's currency (e.g., EUR). Payment currency shows the account currency (e.g., GBP). Orig amount and Amount differ by the exchange rate. |122| Implicit exchange rate | Not shown as a column. Calculate: Amount ÷ Orig amount = effective rate. |123| Weekend/out-of-hours FX | Revolut applies a markup (0.4–1%) on weekends. The rate is worse but appears the same way in the CSV — only the effective rate reveals the markup. |124125---126127## Section 8 — Reconciliation Tips1281291. **Timezone in column headers.** Check whether the export says "(UTC)" or a local timezone. All dates within a file use the same timezone.1302. **"Date started" vs "Date completed".** Use "Date completed" for bookkeeping purposes — this is when the transaction settled. "Date started" may be earlier for pending transfers.1313. **EXCHANGE transactions are internal.** Currency exchanges between your own Revolut balances are not income or expense — they are inter-account transfers.1324. **Card payments may have different Orig and Payment currencies.** A EUR purchase on a GBP account will show Orig currency = EUR and Payment currency = GBP. The FX conversion happens automatically.1335. **Fee column is usually zero.** Most Revolut transactions are fee-free. When fees do appear, they are in the same row (unlike Wise where fees are separate rows).1346. **Balance column is per-currency.** The running balance only makes sense within a single payment currency. Multi-currency exports may interleave currencies, making the Balance column confusing.1357. **Match to bank.** Revolut IS the bank — there is no separate bank statement to reconcile against. Reconcile the Revolut CSV directly as your bank statement.136137---138139## Section 9 — Common Gotchas1401411. **Column headers vary by region.** UK accounts may show "(UTC)", Dutch accounts "(Europe/Amsterdam)". The data is the same but header strings differ, which breaks parsers.1422. **EXCHANGE rows create two entries.** Like Wise, a currency conversion creates two rows. If you only export one currency account, you see only one side. Export all accounts to see both.1433. **Orig amount vs Amount confusion.** For domestic transactions, these are identical. For cross-currency, Orig amount is in the foreign currency and Amount is in your account currency. Revenue/expense should use Amount (your currency).1444. **Interbank rate vs Revolut rate.** Revolut advertises the interbank rate but adds a markup outside market hours and above monthly allowances. The CSV does not flag when a markup was applied.1455. **Card number column for card disputes.** When reconciling disputed card payments, the Card number (last 4 digits) is essential for matching.1466. **TOPUP is not income.** Money added from your own external bank account is an inter-account transfer, not revenue.1477. **Fee rows (Type = FEE) are service charges.** These are deductible business expenses but are not payment processing fees — they are subscription/service fees.1488. **Empty Payer field for outgoing.** The Payer column is only populated for incoming transfers. For outgoing, look at the Description field for the recipient name.149150---151152## Section 10 — Sample Data153154```csv155Date started (UTC),Date completed (UTC),ID,Type,Description,Reference,Payer,Card number,Orig currency,Orig amount,Payment currency,Amount,Fee,Balance,Account,Beneficiary account number,Beneficiary sort code or routing number,Beneficiary IBAN,Beneficiary BIC1562026-03-15 09:23:45,2026-03-15 09:23:45,rev-abc123def456,TRANSFER,From Acme Ltd,INV-1042,Acme Ltd,,GBP,2500.00,GBP,2500.00,0.00,12500.00,Main GBP,,,,1572026-03-15 14:30:00,2026-03-15 14:30:12,rev-ghi789jkl012,CARD_PAYMENT,Amazon Business,,,,GBP,156.99,GBP,-156.99,0.00,12343.01,Main GBP,,,,1582026-03-16 08:00:00,2026-03-16 08:00:05,rev-mno345pqr678,EXCHANGE,Exchanged to EUR,,,,,1000.00,GBP,-1000.00,0.00,11343.01,Main GBP,,,,1592026-03-16 08:00:00,2026-03-16 08:00:05,rev-stu901vwx234,EXCHANGE,Exchanged from GBP,,,,GBP,1000.00,EUR,1152.30,0.00,1152.30,EUR account,,,,1602026-03-17 11:15:00,2026-03-17 11:15:33,rev-yza567bcd890,CARD_PAYMENT,Uber Eats,,,,EUR,23.50,EUR,-23.50,0.00,1128.80,EUR account,,,,1612026-03-18 09:00:00,2026-03-18 09:01:22,rev-efg123hij456,TRANSFER,To Jane Smith Contractor,March payment,,,GBP,3200.00,GBP,-3200.00,0.00,8143.01,Main GBP,12345678,040050,,1622026-03-19 00:00:00,2026-03-19 00:00:00,rev-klm789nop012,FEE,Revolut monthly plan,,,,GBP,25.00,GBP,-25.00,0.00,8118.01,Main GBP,,,,1632026-03-20 15:45:00,2026-03-20 15:45:00,rev-qrs345tuv678,CARD_PAYMENT,Hotel Marais Paris,,,*4521,EUR,189.00,GBP,-163.74,0.00,7954.27,Main GBP,,,,164```165166---167168## Disclaimer169170This skill and its outputs are provided for informational and computational purposes only and do not constitute tax, legal, or financial advice. Open Accountants and its contributors accept no liability for any errors, omissions, or outcomes arising from the use of this skill. All outputs must be reviewed and signed off by a qualified professional before filing or acting upon.171172---173174_Source: [OpenAccountants](https://openaccountants.com/skills/revolut-business-integration) — open tax Guides for AI, reviewed by named CPAs/CAs/EAs. Quality: **source-cited draft**. For always-current figures and named-accountant backing, connect the OpenAccountants MCP server (`openaccountants-mcp`)._
openaccountants