Loading...
Loading...
Import Wise (TransferWise) CSV exports with multi-currency handling.
npx skill4agent add openaccountant/skills wise-importtransaction_searchcategorizeexport_transactions| Wise CSV Column | Open Accountant Field | Notes |
|---|---|---|
| | Unique transfer ID for dedup |
| | Completion date |
| | Transfer description / recipient |
| | Transaction amount (signed) |
| | Source currency ISO code |
| — | Not stored |
| | Stored in notes for reference |
| | Wise fee (negative = expense) |
Total fees=Amount * ExchangeRateTotal 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 - Outflowsapi.transferwise.comBatch IDReference