Wise Import
Overview
Import transaction data from Wise (formerly TransferWise) CSV statement exports. Handles multi-currency accounts, conversion fees, and international transfers. Maps Wise's transfer-centric format into Open Accountant transactions.
Wilson Tools Used
transaction_search — check for existing Wise transactions to prevent duplicates
categorize — assign categories to imported Wise transactions
export_transactions — export reconciled Wise data
Column Mapping
| Wise CSV Column |
Open Accountant Field |
Notes |
TransferWise ID or ID |
reference_id |
Unique transfer ID for dedup |
Date |
date |
Completion date |
Description |
description |
Transfer description / recipient |
Amount |
amount |
Transaction amount (signed) |
Currency |
currency |
Source currency ISO code |
Running Balance |
— |
Not stored |
Exchange Rate |
notes |
Stored in notes for reference |
Total fees |
amount (separate row) |
Wise fee (negative = expense) |
Workflow
- Ask the user for the Wise CSV file path and which currency account(s) to import.
- Parse the CSV and validate Wise column headers.
- Process each row:
- Incoming transfers: positive amount, category "Income:Transfer"
- Outgoing transfers: negative amount, category based on description
- Conversion fees: separate negative entry, category "Fees:Currency Conversion"
- Card payments: negative amount, categorize by vendor
- For multi-currency transfers:
- Record the transaction in the source currency
- Store the exchange rate and target amount in notes
- Create the fee entry separately (Wise charges a conversion fee distinct from the exchange rate)
- Deduplicate using Wise transfer ID.
- Preview import summary per currency: inflows, outflows, fees, net.
- Insert transactions and confirm.
Without Wilson
To work with Wise exports manually:
Downloading from Wise
- Log in at wise.com
- Click on the relevant currency account (e.g., USD, EUR, GBP)
- Go to Statements (right side or under account menu)
- Select the date range
- Choose CSV format (also available: PDF, XLSX)
- Click Download
- Repeat for each currency account you want to import
Manual Processing in a Spreadsheet
- Open the CSV in Google Sheets or Excel.
- Identify transaction types by the Description and Amount sign:
- Positive amounts = money received (income, incoming transfers)
- Negative amounts = money sent (expenses, outgoing transfers, card payments)
- Separate fees: Wise embeds fees in certain rows. Look for rows with "fee" in the description or where the Description references a parent transfer.
- Some Wise CSVs have a
Total fees column — use this directly.
- If not, fees appear as separate rows with descriptions like "Conversion fee" or "Transfer fee."
- Multi-currency handling:
- If you have multiple currency accounts, keep them in separate sheets or add a "Currency" filter.
- Do NOT sum amounts across currencies without converting first.
- To convert:
=Amount * ExchangeRate (use the rate from the Wise statement, not a live rate).
- Summary formulas (per currency):
Total Inflows: =SUMIFS(Amount, Amount, ">0", Currency, "USD")
Total Outflows: =ABS(SUMIFS(Amount, Amount, "<0", Currency, "USD"))
Total Fees: =ABS(SUMIFS(TotalFees, Currency, "USD"))
Net: =Inflows - Outflows
- Reconcile: The running balance in the last row should match your Wise account balance.
Alternative: Wise API
For developers, Wise has a public API at api.transferwise.com that can pull statements programmatically. Requires an API key from your Wise business account settings.
Important Notes
- Wise CSV format varies slightly between personal and business accounts. Business accounts include additional columns like
Batch ID and Reference.
- Multi-currency: each currency account exports separately. If you converted USD to EUR, the debit appears in your USD statement and the credit in your EUR statement.
- Wise fees are typically lower than traditional banks (0.3-2% depending on corridor) but they appear as separate line items, not embedded in the exchange rate.
- "Balance cashback" rows are small interest payments from Wise — import these as "Income:Interest".
- Wise card transactions may appear with temporary merchant descriptions that update after settlement. If you import early, descriptions may change.
1---
2name: wise-import
3description: >
4 Import Wise (TransferWise) CSV exports with multi-currency handling.
5metadata:
6 source: https://skillmd.com/skills/openaccountant/wise-import
7---
8
9# Wise Import
10
11## Overview
12Import transaction data from Wise (formerly TransferWise) CSV statement exports. Handles multi-currency accounts, conversion fees, and international transfers. Maps Wise's transfer-centric format into Open Accountant transactions.
13
14## Wilson Tools Used
15- `transaction_search` — check for existing Wise transactions to prevent duplicates
16- `categorize` — assign categories to imported Wise transactions
17- `export_transactions` — export reconciled Wise data
18
19## Column Mapping
20
21| Wise CSV Column | Open Accountant Field | Notes |
22|---|---|---|
23| `TransferWise ID` or `ID` | `reference_id` | Unique transfer ID for dedup |
24| `Date` | `date` | Completion date |
25| `Description` | `description` | Transfer description / recipient |
26| `Amount` | `amount` | Transaction amount (signed) |
27| `Currency` | `currency` | Source currency ISO code |
28| `Running Balance` | — | Not stored |
29| `Exchange Rate` | `notes` | Stored in notes for reference |
30| `Total fees` | `amount` (separate row) | Wise fee (negative = expense) |
31
32## Workflow
331. Ask the user for the Wise CSV file path and which currency account(s) to import.
342. Parse the CSV and validate Wise column headers.
353. Process each row:
36 - **Incoming transfers**: positive amount, category "Income:Transfer"
37 - **Outgoing transfers**: negative amount, category based on description
38 - **Conversion fees**: separate negative entry, category "Fees:Currency Conversion"
39 - **Card payments**: negative amount, categorize by vendor
404. For multi-currency transfers:
41 - Record the transaction in the source currency
42 - Store the exchange rate and target amount in notes
43 - Create the fee entry separately (Wise charges a conversion fee distinct from the exchange rate)
445. Deduplicate using Wise transfer ID.
456. Preview import summary per currency: inflows, outflows, fees, net.
467. Insert transactions and confirm.
47
48## Without Wilson
49To work with Wise exports manually:
50
51### Downloading from Wise
521. Log in at **wise.com**
532. Click on the relevant currency account (e.g., USD, EUR, GBP)
543. Go to **Statements** (right side or under account menu)
554. Select the date range
565. Choose **CSV** format (also available: PDF, XLSX)
576. Click **Download**
587. Repeat for each currency account you want to import
59
60### Manual Processing in a Spreadsheet
611. Open the CSV in Google Sheets or Excel.
622. **Identify transaction types** by the Description and Amount sign:
63 - Positive amounts = money received (income, incoming transfers)
64 - Negative amounts = money sent (expenses, outgoing transfers, card payments)
653. **Separate fees**: Wise embeds fees in certain rows. Look for rows with "fee" in the description or where the Description references a parent transfer.
66 - Some Wise CSVs have a `Total fees` column — use this directly.
67 - If not, fees appear as separate rows with descriptions like "Conversion fee" or "Transfer fee."
684. **Multi-currency handling**:
69 - If you have multiple currency accounts, keep them in separate sheets or add a "Currency" filter.
70 - Do NOT sum amounts across currencies without converting first.
71 - To convert: `=Amount * ExchangeRate` (use the rate from the Wise statement, not a live rate).
725. **Summary formulas** (per currency):
73 ```
74 Total Inflows: =SUMIFS(Amount, Amount, ">0", Currency, "USD")
75 Total Outflows: =ABS(SUMIFS(Amount, Amount, "<0", Currency, "USD"))
76 Total Fees: =ABS(SUMIFS(TotalFees, Currency, "USD"))
77 Net: =Inflows - Outflows
78 ```
796. **Reconcile**: The running balance in the last row should match your Wise account balance.
80
81### Alternative: Wise API
82For developers, Wise has a public API at `api.transferwise.com` that can pull statements programmatically. Requires an API key from your Wise business account settings.
83
84## Important Notes
85- Wise CSV format varies slightly between personal and business accounts. Business accounts include additional columns like `Batch ID` and `Reference`.
86- Multi-currency: each currency account exports separately. If you converted USD to EUR, the debit appears in your USD statement and the credit in your EUR statement.
87- Wise fees are typically lower than traditional banks (0.3-2% depending on corridor) but they appear as separate line items, not embedded in the exchange rate.
88- "Balance cashback" rows are small interest payments from Wise — import these as "Income:Interest".
89- Wise card transactions may appear with temporary merchant descriptions that update after settlement. If you import early, descriptions may change.