Import MT940 into MYOB: convert MT940 to QIF

MYOB imports QIF files. Convert your MT940 file to QIF first, then import it. Read the full MYOB 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 a QIF file

QIF is an older plain text format for transactions, with a line for each date, amount, payee, memo, check number and category. It has no transaction IDs and no currency. More about QIF.

Why convert MT940 to QIF

MT940 is a bank statement format that most accounting apps don't import. QIF is a plain text format that apps without OFX support often import, and it can carry categories. It has no transaction IDs, so import each period only once.

Before you import: check the account in MYOB

Check that the account exists and which periods are already imported. Importing the same file twice, or statements with overlapping periods, creates duplicate transactions.

Step by step: convert MT940 to QIF

  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 QIF settings below.
  5. Click Convert, then confirm the file name and location.

Set the QIF output settings

In the QIF tab on the right sidebar, select MYOB as the QIF target. MYOB has special requirements for QIF files, and this target meets them. It writes dates as DD/MM/YYYY. See all QIF settings.

Import the QIF file into MYOB

  1. Log in to MYOB, click Banking, then Bank Transactions.
  2. Click Import Statements and select the account to import into.
  3. Browse to the QIF file and click Open.
  4. Set "Date format if using QIF" to DD/MM/YYYY.
  5. Click Import now.
  6. Review the transactions: check the assigned account and tax code, and split transactions if needed.

See the MYOB import guide for more.

MYOB QIF questions

Why does MYOB refuse my QIF file?

MYOB has special requirements for QIF files, so a QIF written for another app fails. Convert it with the MYOB QIF target.

Can MYOB allocate transactions automatically?

Yes. You can create a rule from a transaction (payee, amount and description), so MYOB allocates matching transactions on the next import.

How do I undo an import?

Click Import Statements, then View Import History. Select the account you imported into, then click Action, Continue and Delete.

Related MYOB conversions