Wise Statement to CSV/Excel — QuickBooks & Xero Import
Wise already offers CSV exports and Xero sync for some workflows. Exact Statement is most useful when you need older history, PDF statements, or one normalized file across multiple currencies and destinations.
Files are validated locally, split into chunks, then uploaded directly to secure storage.
Official Wise guidance: one statement per active currency · PDF or CSV for older manual uploads · Xero sync every 4 hours when the feed is connected
How Wise Statement Access Actually Works
Wise is not a classic monthly-bank-statement story. The important detail is where sync stops and manual statement uploads start.
If Xero is connected, start there first
Wise says bank-feed sync to Xero runs automatically every 4 hours after the connection is enabled.
Older than the connection date
Wise lets you choose an earlier start date in Bank feed activity, up to one year back from the connection flow.
Older than one year means manual statements
For older history, Wise tells you to download a statement in PDF or CSV format for every currency you have activated.
Think per currency, not one bank feed file
Wise account history is often split by currency wallet. That affects both the download workflow and the import logic afterward.
What Makes Wise Statements Different
Wise statements are multi-currency workflow documents. The main risks are choosing the wrong source, missing wallets, and handling fees or FX rows incorrectly.
Statements are currency-specific
Wise explicitly tells users to download a statement for every activated currency when they need manual uploads for older history.
Bank-feed sync and manual upload coexist
If you are already connected to Xero, some periods sync automatically while older windows still require statement downloads and manual import.
Fees and FX details need cleanup
Transfers, conversions, and fees can show as related but distinct lines. That matters when the destination system only wants one signed amount column.
Descriptions mix platform and counterparty text
Wise rows often include transfer refs, recipient names, and platform wording in one description cell, which needs payee cleanup.
QBO and Xero expect different final shapes
Even if Wise gives you CSV, the final import file still has to match the target platform's required columns and sign logic.
Locked PDFs must be unlocked first
If your downloaded Wise file is password-protected, unlock it before upload. Exact Statement does not remove statement passwords for you.
Common Wise Import Pitfalls
Wise is easy to underestimate because it already exports data. The real work is in choosing the correct source and shaping it correctly for the accounting target.
One wallet, one statement file
If you pull only one currency file, you may think the export is incomplete when the missing transactions actually live in another currency statement.
Older history falls outside live sync
Wise says older than one year requires manual statement upload. That is exactly where a cleaned PDF-to-CSV workflow becomes useful.
Transfer fees can become separate rows
If you import without checking the sign and fee rows, the totals can drift from the official statement period.
Wise CSV still needs QBO or Xero remapping
A Wise CSV can be perfectly valid for Wise and still need destination-specific columns, signs, and references before import.
Preview A Wise Multi-Currency Export
The sample below shows the kind of row cleanup you need when one Wise account produces fees, transfers, and different currencies across the same bookkeeping window.
| Date | Amount | Payee | Description | Reference | Transaction Type | Balance | Currency | Account ID |
|---|---|---|---|---|---|---|---|---|
| 03/02/2025 | 6.80 | Berlin Coffee | CARD PAYMENT BERLIN COFFEE | CARD | Credit | 1423.22 | EUR | EUR wallet |
| 04/02/2025 | 250.00 | Wise transfer | TRANSFER TO GBP BALANCE | FX-2401 | Credit | 1173.22 | EUR | EUR wallet |
| 04/02/2025 | 1.14 | Wise fee | CONVERSION FEE | FEE | Credit | 1172.08 | EUR | EUR wallet |
| 04/02/2025 | -212.45 | Wise transfer | RECEIVED FROM EUR CONVERSION | FX-2401 | Debit | 980.54 | GBP | GBP balance |
| 06/02/2025 | -1450.00 | ACME LLC | CLIENT PAYMENT ACME LLC | INV-204 | Debit | 3110.00 | USD | USD balance |
Sample rows for preview only. Wise examples are shown per currency because that is how manual backfill guidance is written in the Wise help center.
How Wise Fields Map Into Import Files
The hard part with Wise is rarely “can I get data out?” It is “did I choose the right source and normalize it correctly?”
| Field In Statement PDF | Exact Statement Output | QuickBooks Online | Xero CSV |
|---|---|---|---|
| Statement date | Normalized Date | Date | Date |
| Activity / transfer text | Payee + Description split | Description | Payee + Description |
| Amount + fee rows | Signed Amount per row | Amount or Credit/Debit | Amount + Transaction Type |
| Transfer / conversion reference | Reference | Optional | Reference |
| Currency wallet / balance | Currency + balance for XLSX review | Not required | Currency kept for review, not import |
Sources: Wise to Xero help · Intuit CSV format guide · Xero CSV import guide.
Wise Statement to CSV — Frequently Asked Questions
No. Wise says connected Xero bank feeds sync automatically every 4 hours. Manual statement upload mainly matters for older history or for workflows outside the live feed connection.
Wise says you can choose an earlier start date in Bank feed activity up to one year. Older than one year requires manual statement download.
Because manual statement history is handled per activated currency. If you use multiple wallets, each currency can have its own statement file and reconciliation path.
Treating Wise-native CSV as if it already matched QBO or Xero import columns. Multi-currency rows, fees, and conversion references still need cleanup for the final destination format.
Unlock it before upload. Exact Statement does not remove statement passwords for you.
Need the official help pages? Wise Xero help · support@exactstatement.com.
Convert Your Wise Statement Now
Upload a Wise statement PDF and export a clean CSV or Excel file for QuickBooks Online, Xero, or multi-currency review.