Import MT940 into Wave: convert MT940 to OFX

Wave imports OFX files. Convert your MT940 file to OFX first, then import it. Read the full Wave import guide.

What is an MT940 file

MT940 is a SWIFT bank statement format used mostly by European and business banks. It has dates, amounts and the opening and closing balance, which give you a total to check against. The description is often one long field, so check that the payee and memo came out readably after conversion.

What is an OFX file

OFX (Open Financial Exchange) is a standard format for bank data. Many accounting apps import it. It holds the date, amount, payee, memo, check number and a transaction ID, along with the account ID and type. More about OFX.

Why convert MT940 to OFX

MT940 is a bank statement format that most accounting apps don't import. OFX is the most widely accepted bank format, with named fields and a transaction ID on each row, so an app can skip rows it already has.

Before you import: check the account in Wave

Wave keeps your data online, so there is no company file to back up. Check that the account exists and look at what is already imported for this period. Try Wave's direct bank connection first, and use a file import when that isn't available or doesn't work.

Step by step: convert MT940 to OFX

  1. Download, install and start ProperConvert. The trial is free.
  2. Open your MT940 file.
  3. Review the transactions to see how the app read your file. Check that the dates are correct, and that expenses are negative and deposits (payments to the account) are positive. The "Change +/-" button reverses the signs for the whole file, for bank and credit card accounts alike.
  4. Set the OFX settings below.
  5. Click Convert, then confirm the file name and location.

Set the OFX output settings

In the QBO/QFX/OFX tab on the right sidebar, set the file type to OFX and select OFX All apps as the OFX target, then set:

See all OFX settings.

Import the OFX file into Wave

Import the OFX file into the account in Wave. The transactions go directly into the register, marked as not reviewed. Once you review a transaction and assign an account, it counts toward the balance.

See the Wave import guide for more.

Wave OFX questions

How does Wave assign expense and income accounts?

OFX files don't carry categories, because your bank doesn't know your accounting setup. Wave learns your choices over time and preselects them on your next import.

Does Wave have bank feeds like QuickBooks?

No. Wave imports directly into the register but marks transactions as not reviewed. Once you review a transaction and assign an account, it counts toward the balance.

Does Wave support transfers between accounts?

Neither Wave import nor the OFX format supports transfers. Wave has a tool that finds matching transactions in two accounts with the same date and amount, and you can mark them as a transfer.

Related Wave conversions