Skip to content
stmtai

Convert Wise statements to QuickBooks.
Checked against the printed balances first.

Wise already offers a QuickBooks-formatted export with a running balance, and for one currency over one year it is usually fine.

Drop your bank statements here

One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.

Not ready to upload your own? See a sample result

5 pages free, no account. The QuickBooks download appears on the results page.

Download the statement from Wise

  1. In the Wise app or at wise.com, open the currency balance (or Jar) you need.
  2. Tap the three dots in the top-right corner and choose "Statements and reports".
  3. Pick the document type: the statement as PDF, CSV or XLSX, or one of the accounting export formats.
  4. Set the date range, up to 365 days per statement; longer periods need several files.
  5. Enter your Wise password to confirm, then save the download.
  6. The same menu is reachable from your initials in the top corner, and a separate "Statement of fees" is offered alongside.

Then drop the file above. Several months at once is fine; each statement comes back as its own .qbo file.

Before you upload: is the PDF password-protected?

Wise asks for your account password before it generates the file, but the PDF itself is not encrypted and opens freely once saved.

Wise and QuickBooks

Wise already offers a QuickBooks-formatted export with a running balance, and for one currency over one year it is usually fine. Converting the PDFs earns its place when the CSV column set has changed between years, or across many balances: each currency statement becomes its own .qbo with CURDEF set from the header.

Wise gives you the statement in CSV and XLSX as well as PDF, plus accounting exports formatted for QuickBooks, Xero and others, all from the same menu and with a running balance included. That is a better native export than most banks manage, and for one currency over one year the CSV is fine to import directly. Two things send people to the PDF: the CSV column set has changed over the years, so older and newer files do not stack cleanly, and business accounts with many balances end up with a dozen files that all need the same tidy-up. Converting the PDFs gives you one consistent layout across currencies and years.

Import into QuickBooks

  1. Drop the statement on the home page. Fix any flagged row (or swap debit/credit if the bank prints them reversed) until the badge is green.
  2. Click QuickBooks (.qbo).
  3. QuickBooks Online: Transactions → Bank transactions → Link account ▾ → Upload from file → choose the .qbo → pick the account → Next.
  4. QuickBooks Desktop: File → Utilities → Import → Web Connect Files → choose the .qbo → select the account.
  5. Review the imported transactions in the For Review tab and add them.

What usually goes wrong

  • Each currency balance is a separate statement, reconciled in that currency; the QuickBooks export sets the currency code (CURDEF) to match.
  • Reversed signs: money out imported as deposits. The most common complaint about statement converters. We show you the totals and let you swap before export.
  • Duplicate transactions on re-import because the FITID changes each time. Ours is derived from the row content, so the same statement always produces the same IDs.
  • "QuickBooks found an error" on upload, usually from a missing INTU.BID, unescaped ampersands or a bad date. Check any .qbo with our free QBO checker.

None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a Wise file.

Already have a .qbo that QuickBooks rejects?

Run it through the free QBO checker. It reads the file in your browser (nothing is uploaded) and lists exactly what QuickBooks will object to: missing INTU.BID, duplicate FITIDs, bad dates, unescaped ampersands, sign mismatches.

Wise and QuickBooks questions

I hold six currencies. Do I really need six statements?

Yes, and six ledger accounts to match. Each balance reconciles only in its own currency, and the converter sets the currency code in the QuickBooks export from the statement header so each file lands in the right account. Conversions between balances then post as transfers with the fee as a separate expense line.

Why is my Wise fee not in the exchange rate like at a bank?

Wise charges the fee explicitly and converts at the mid-market rate, so the fee prints as its own line on the statement of the currency you converted from. Book it as bank charges rather than burying it in an exchange gain or loss. The Statement of fees document summarizes them by month if you want a single figure.

Does it work with QuickBooks Online and Desktop?

Yes. The .qbo is OFX 1.02 with the INTU.BID QuickBooks requires, which both accept. Desktop imports via Web Connect.

What if QuickBooks rejects the file?

Run it through the QBO checker at /tools/qbo-checker; it explains what QuickBooks objects to. If the issue is with a file we produced, email support with the conversion ID and we fix the reader.

Can I get Wise transactions into QuickBooks without the bank's own export?

Yes. Download the statement PDF from Wise, drop it on this page and wait for the balance check, which compares the rows with the balances printed on the statement. Then download the QuickBooks file and import it with the steps above. No Wise template is involved; the statement is read the way a person reads it, and the balance check is what tells you the rows are complete.

More for this bank

All banks and formats · See a sample result