BooksReady

Convert a Wise statement CSV to QuickBooks Online

In short: A Wise statement CSV covers one currency balance, newest first, with day-first dates, signed amounts, a running balance, and fees that can appear as their own rows. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Convert your file

Wise to QuickBooks Online (CSV)

statement_<number>_<currency>_<dates>.csv

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from Wise

  1. In Wise open the currency balance you want.
  2. Choose Statements (or Statements and reports) and pick the dates.
  3. Choose CSV as the format and download.
  4. Upload the file here. Each currency balance is a separate file.

Why a raw Wise export fails in QuickBooks Online

Imported raw, QuickBooks Online sees about twenty columns, dates written day first such as 05-08-2024, and the running balance and exchange columns alongside the amount.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

What is unusual about the Wise file

  • One file per currency balance, newest first, dates written DD-MM-YYYY.
  • Amount is signed and is what moved the balance; the Running Balance column is used to check the file.
  • A fee can be its own row ("Charges for: TRANSFER-...") while the main row also shows it under Total fees; the fee is counted once.
  • Currency conversions between your own Wise balances appear in both currency files.
  • Several layouts exist (with or without Date Time and Transaction Type columns); columns are matched by name.
  • Journal entries are not offered: the statement does not say which money coming in is sales and which is your own money, a loan or a refund.

What QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

2. Before and after

Before: the Wise statement CSV as downloaded

"TransferWise ID",Date,Amount,Currency,Description,"Payment Reference","Running Balance","Exchange From","Exchange To","Exchange Rate","Payer Name"...
TRANSFER-102,20-08-2024,0.00,USD,Received money from Test Payer,,1996.17,,,,Test Payer,,,,,,,,0.00
BALANCE-300,15-08-2024,-100.00,USD,Converted 100.00 USD to 92.00 EUR,,1996.17,USD,EUR,0.92000,,,,,,,,,0.00
CARD-201,12-08-2024,10.00,USD,"Card transaction of 10.00 USD refunded by Coffee, Inc",,2096.17,,,,,,,"Coffee, Inc",4321,Sam Placeholder,,,0.00
CARD-200,10-08-2024,-45.10,USD,"Card transaction of 45.10 USD issued by Coffee, Inc",,2086.17,,,,,,,"Coffee, Inc",4321,Sam Placeholder,,,0.00
TRANSFER-101,05-08-2024,-11.35,USD,Wise Charges for: TRANSFER-101,,2131.27,,,,,Wise,,,,,,,0.00
TRANSFER-101,05-08-2024,-357.38,USD,Sent money to John Doe,Rent,2142.62,,,,,John Doe,LT21 1111 2222 3333 4444,,,,,,11.35
TRANSFER-100,01-08-2024,1500.00,USD,Received money from Acme Ltd,Invoice 42,2500.00,,,,Acme Ltd,,,,,,,,0.00

After: what QuickBooks Online receives

After: wise-2024-08-01-to-2024-08-15-quickbooks-3col.csv
DateDescriptionAmount
08/01/2024Received money from Acme Ltd - Invoice 421500.00
08/05/2024Sent money to John Doe - Rent-357.38
08/05/2024Wise Charges for: TRANSFER-101-11.35
08/10/2024Card transaction of 45.10 USD issued by Coffee, Inc-45.10
08/12/2024Card transaction of 10.00 USD refunded by Coffee, Inc10.00
08/15/2024Converted 100.00 USD to 92.00 EUR-100.00

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

3. Import the converted file into QuickBooks Online

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

Questions

Are Wise fees counted twice?
No. A Wise statement can show a fee as its own row and again in the Total fees column of the transfer it belongs to. The converter uses the amount on each row as written and never subtracts Total fees, then checks the result against the Running Balance column.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
I have balances in several currencies. What do I download?
Wise gives one statement per currency balance. Download and convert each one, and keep each currency in its own account in your books. A conversion between your balances shows up in both files.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert Wise

Other exports to QuickBooks Online (CSV)

Common import problems