How to Import Wise Transactions into QuickBooks (and Why the Feed Stops)

Short answer: Connect Wise to QuickBooks Online and it will sync your transactions, but the authorization expires after 90 days and has to be renewed. When it lapses, the feed stops silently. Reconnecting only brings back the last 90 days, because QuickBooks will not download transactions older than that on any bank connection. For anything the gap swallowed, download the Wise statement, convert it to a QBO file, and import it.

Most articles about Wise and QuickBooks tell you how to click Connect. The useful part is what happens ninety days later, and what to do about the currencies.

Does Wise work with QuickBooks?

Yes. Wise has a QuickBooks Online integration, and for ongoing bookkeeping it works fine. Two conditions apply before you start. You cannot connect at all if your QuickBooks subscription level does not allow the connection, and if you want to connect more than one currency balance, you have to enable multi-currency in QuickBooks first.

Then there is the clock. Wise states it plainly: the authorization to share your data with QuickBooks will expire after 90 days, and at that point you need to authorize sharing your data again.

The 90-day trap, in two rules

Neither rule is a secret. It is the combination that quietly destroys a set of books.

Rule one, from Wise: the QuickBooks authorization expires after 90 days.

Rule two, from Intuit: QuickBooks will not download transactions older than 90 days through a bank connection.

Now picture the ordinary version of events. Your authorization lapses in March. Nothing pops up, nothing emails you, and the feed simply stops delivering. You are busy, so you notice in July, when a reconciliation refuses to balance. You reconnect, feeling like you have fixed it. QuickBooks pulls the last 90 days, which reaches back to April.

March is gone. Not delayed, not pending. The feed is not permitted to reach that far back, so no amount of reconnecting or refreshing will ever produce those transactions. The only way to recover the month is to import it from a file.

Method 1: the live integration, kept alive

Use the feed for current activity, and treat the reauthorization as a real recurring task rather than something you will remember. Put a reminder in your calendar for every 80 days or so, comfortably inside the window. If you manage client books, put it on the client's close checklist, because this failure is invisible from the outside until the numbers stop tying out.

Method 2: convert the statement to a QBO file

This is how you recover a gap, and how you load history from before the connection existed.

1. In Wise, open the balance you need, choose Statements, set the date range, and download the PDF. Do this once per currency.
2. Upload it to the Wise statement to QBO converter and choose QBO as the output format.
3. In QuickBooks Online, go to Transactions, then Bank transactions, and choose Upload from file. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files.
4. Map each currency's file to its matching QuickBooks account and review.

A statement has no authorization attached to it and no date window. If Wise issued it, it converts, and it does not care that the period ended two years ago.

How do I handle Wise multi-currency in QuickBooks?

This is where most of the actual difficulty lives, and it is a structural mismatch rather than a bug.

Wise holds many currencies inside one account. QuickBooks holds exactly one currency per account. So a single Wise account with USD, EUR, and GBP balances becomes three separate accounts in QuickBooks, each with its own register and its own reconciliation. Wise requires multi-currency to be enabled in QuickBooks before it will connect more than one balance, and it is worth knowing that once you turn multi-currency on in QuickBooks, you cannot turn it back off.

Carry that separation through your files. One statement per currency, one QBO file per statement, one QuickBooks account per file. Do not merge currencies into a single import and hope QuickBooks works it out, because it will not, and the register you end up with cannot be reconciled against any statement you actually possess.

How to book a Wise currency conversion

A conversion is not one transaction. It is two sides and a fee, and treating it as a single line is the second most common way Wise books go wrong.

When you convert USD to EUR, money leaves the USD balance, Wise takes a fee, and a smaller amount arrives in the EUR balance at the rate applied that day. In QuickBooks that becomes a transfer between two accounts. The fee is an expense. Any difference between the rate Wise used and the rate on your books lands as a realized exchange gain or loss.

Book it as one line and the USD account goes wrong immediately while the EUR account never receives anything at all. This is another reason a converted statement helps: both sides of the conversion and the fee come through as separate rows with real dates and real amounts, which is precisely what you need to construct the transfer and the gain or loss.

Avoiding duplicates

If the feed is running again after a lapse, do not import a converted file over the top of it. Open the register, find the oldest transaction the reconnected feed delivered, and end your converted file the day before it. Fill the hole, do not overlap it.

QuickBooks does attempt duplicate detection on a Web Connect import, but it matches on amount, date, and reference. Wise descriptions are not always identical between the feed and the statement, so overlapping ranges will produce doubles. Also keep each upload under 1,000 transactions and 350 KB, the caps QuickBooks Online enforces, and split by month if a file is rejected.

Is Wise a bank?

No. Wise is a money services business. It holds your money rather than taking deposits, which is why the language on a Wise statement differs from a bank statement and why the account is not FDIC-insured in the way a bank account is. For bookkeeping this changes nothing: the statements are transaction records and they reconcile normally. It matters when a lender or an auditor asks what kind of account this is.

The workflow that survives contact with reality

Reauthorize the connection before it expires, reconcile per currency rather than in aggregate, book conversions as transfers with a fee, and convert statements for anything the feed missed. Do those four things and Wise stops being the account that breaks your close every quarter.

Most people using Wise this way are getting paid by clients overseas, which means the other half of the reconciliation is the invoices themselves, and pulling the line items off those into your ledger is its own chore that an invoice data extraction tool can take off your hands. If you would rather work in a spreadsheet than in QuickBooks, the Wise statement to Excel converter gives you the same data as XLSX or CSV. And for the rule that underpins the whole 90-day trap, why QuickBooks only imports 90 days of transactions spells out what every type of connection can and cannot reach.