How to Convert Wise CSV to QuickBooks Format: Step-by-Step Guide (2026)

Transparency: I built Tally Assistant, which auto-converts Wise CSVs to any format. This guide covers manual conversion in Excel and automated alternatives.

Quick Answer

Wise exports CSVs in European format (semicolons, comma decimals, DD/MM/YYYY dates). QuickBooks expects US format (commas, period decimals, MM/DD/YYYY). The conversion takes 5 steps in Excel or Google Sheets. Or you can use an AI tool that reads Wise CSVs directly — no conversion needed.

---

Why Wise CSVs Break QuickBooks Imports

Wise (formerly TransferWise) is a European company. Its default CSV export follows European locale conventions:

	Wise CSV	QuickBooks Expects
Column separator	; (semicolon)	, (comma)
Decimal separator	, (e.g., 1.500,00 EUR)	. (e.g., 1,500.00 USD)
Date format	DD/MM/YYYY	MM/DD/YYYY
Thousands	. (e.g., 1.500,00)	, (e.g., 1,500.00)

When you upload a Wise CSV to QuickBooks, one of three things happens:

1. Error: "Unable to parse file" — QuickBooks can't read semicolon-delimited files
2. Wrong amounts: 1.500,00 EUR imports as $1.50 instead of $1,500.00
3. Wrong dates: 03/07/2026 shows as March 7 when it means July 3

---

Method 1: Manual Conversion in Google Sheets (5 Minutes)

Step 1: Open the Wise CSV Correctly

Don't double-click the CSV (Excel will auto-format and corrupt the data). Instead:

1. Open Google Sheets (sheets.google.com)
2. File → Import → Upload → Select your Wise CSV
3. In the import dialog, set:
   • Separator type: Semicolon
   • Convert text to numbers: Uncheck (prevents auto-formatting)
4. Click Import Data

You should now see columns properly separated: Date | Description | Amount | Currency | Balance

Step 2: Fix the Number Format

Wise amounts look like 1.500,00 and need to become 1500.00.

1. Create a new column next to your Amount column
2. Use this formula (assuming Amount is in column C, row 2):

   =VALUE(SUBSTITUTE(SUBSTITUTE(C2; "."; ""); ","; "."))
   

3. Drag the formula down for all rows
4. Copy the formula column → Paste as Values over the original Amount column
5. Delete the formula column

What this does: Removes periods (thousands separator), replaces comma with period (decimal), converts to a number.

Step 3: Fix the Date Format

Wise uses DD/MM/YYYY. QuickBooks expects MM/DD/YYYY.

1. Select the Date column
2. Format → Number → Date → Choose the US format
3. Verify: dates like 03/07/2026 (July 3) should now show correctly

For extra safety, create a backup of the original column before reformatting.

Step 4: Add Required QuickBooks Columns

QuickBooks expects certain columns. Add these as needed:

QuickBooks Column	Wise CSV Equivalent	Notes
Date	Date	Already present
Description	Description	Already present
Amount	Amount	Converted in Step 2
Account	—	Add manually (e.g., "Wise Business Account")
Transaction Type	—	"Deposit" or "Payment" based on sign

Step 5: Export as QuickBooks-Compatible CSV

1. File → Download → Comma Separated Values (.csv)
2. Name it: Wise-[Year]-[Month]-QuickBooks.csv
3. Upload to QuickBooks

---

Method 2: Quick Conversion in Excel (3 Minutes)

Excel handles European CSV slightly differently:

1. Open Excel → Data → From Text/CSV
2. Select your Wise CSV
3. In the Power Query editor:
   • Delimiter: Semicolon
   • Data Type Detection: Do not detect data types
4. Click Transform Data
5. Select the Amount column:
   • Replace Values: . → "" (remove thousands separator)
   • Replace Values: , → . (convert decimal)
   • Data Type: Decimal Number
6. Select the Date column:
   • Data Type: Date → Using Locale: English (United States)
7. Close & Load → Save as CSV

---

Method 3: Multi-Currency Wise CSVs

If your Wise account holds USD, EUR, and GBP, the CSV may contain rows in all three currencies. This adds complexity:

1. Separate by currency first — filter the Currency column, copy each currency's rows to a separate sheet
2. Convert each currency independently — EUR amounts to USD, GBP to USD, etc.
3. Use the exchange rate from the transaction date — not today's rate

Important: The Amount column shows the value in that currency. A EUR row showing 1.500,00 means €1,500.00 — not $1,500.00. You need to add a converted column with the USD equivalent at the transaction date's exchange rate.

For this, use Wise's own exchange rate (shown in the transaction details, not the CSV) or a historical rate from Frankfurter API or XE.com.

---

Method 4: Skip Conversion — Use AI CSV Import

If you process Wise CSVs monthly, manual conversion adds up. At 5 minutes per conversion × 12 months = 1 hour/year just reformatting Wise files.

AI bookkeeping tools (like Tally Assistant) solve this by:

1. Auto-detecting the format — semicolon vs comma, European vs US numbers, DD/MM/YYYY vs MM/DD/YYYY
2. Parsing amounts correctly — 1.500,00 EUR is recognized as €1,500.00, not $1.50
3. Handling multi-currency — Each currency is preserved, then converted to your base currency at daily exchange rates
4. Working with any platform — Wise, Revolut, PayPal, Stripe, 200+ banks — all parsed by the same AI

No Excel formulas, no manual column mapping, no reformatting. Upload and done.

---

Quick Troubleshooting

Problem	Likely Cause	Fix
All data in one column	Opened directly in Excel without specifying semicolon delimiter	Use Import wizard, set delimiter to semicolon
Amounts are off by 1000x	European thousands separator misinterpreted	Convert using SUBSTITUTE formula (Step 2)
Dates are wrong month/day	DD/MM/YYYY interpreted as MM/DD/YYYY	Reformat date column with correct locale
Negative amounts flipped	Wise uses European accounting convention	Multiply by -1 if needed for your tool
Missing currency column	You downloaded simplified CSV, not detailed	Use Statements → Custom → Detailed CSV

---

Bottom Line

Wise → QuickBooks conversion is a 5-minute Excel exercise once you know the steps. The semicolon delimiter is the root of most problems. If you're doing this monthly across multiple banks and platforms, an AI tool eliminates the reformatting entirely.

👉 Import your Wise CSV with AI — auto-detects format, handles multi-currency, no conversion needed. Free plan available.