Import a QIF file into MYOB - ProperSoft

Import a QIF file into MYOB

This tutorial shows how to import a QIF file with transactions into Online Accounting system - MYOB.

This is an Australian based Online accounting service. They support import for QIF and OFX files. When you sign up for the account, go to 'Banking' - 'Bank transactions'.

Import QIF into MYOB Step 1: click Banking

Look for the button 'Import statements'.

Import QIF into MYOB Step 2: Import statements

Select an account you want to import your data into. We will use a 'Cheque account'

Import QIF into MYOB Step 3: select account

Browse to select a CSV file and click 'Open'.

Import QIF into MYOB Step 4: select csv file

They say, that only QIF and OFX files are allowed.

Import QIF into MYOB Step 5: select csv file

Let's select a QIF file.

Import QIF into MYOB Step 6: select qif file

And for 'Date format if using QIF', you have to know how dates are shown on your QIF file.

Import QIF into MYOB Step 7: Date format if using QIF

In our case, dates are day/month/year. ProperSoft converters CSV2QIF, or Bank2QIF, or PDF2QIF have a special QIF Target, as MYOB. So, when you convert for MYOB, it will create the dates, as day/month/year, so you don't have to guess or check how the dates added. This is a default option of Australian based business, they do the dates by day/month/year. And in ProperSoft converters, when you select a QIF Target - MYOB, they follow this default setting.

Import QIF into MYOB Step 8: Date format in notepad

To import a QIF file, click 'Import now'.

Import QIF into MYOB Step 9: Import now

The statements have been imported successfully. Now we have four imported unallocated transactions - one deposit, three withdrawals.

Import QIF into MYOB Step 10: statements imported successfully

The process to review the transactions is called 'Allocate' or 'Match'. Now we have to allocate the transactions.

Import QIF into MYOB Step 11: allocate transactions

We have to say which Account belongs to, let's say it will be 'Sales 1'. And if you want a split, create few splits, you can do that.

Import QIF into MYOB Step 12: select account

Then you have to select Tax code and click 'Save'. This way you allocate the transactions, continue with all transactions.

Import QIF into MYOB Step 13: select tax code

Let's say, if you realized, that a QIF file was not imported correctly, click 'Import statements' - 'View Import History'.

Import QIF into MYOB Step 14: View Import History

Select an account you've imported your data.

Import QIF into MYOB Step 15: Select account where imported your data

Then click 'Action'.

Import QIF into MYOB Step 16: click action

Click the 'Continue' button.

Import QIF into MYOB Step 12: click continue

And then click the 'Delete' button.

Import QIF into MYOB Step 18: click delete button

This is how we delete them. We cannot actually delete the transaction, that was imported, we can delete the whole statement in this Online accounting system.

Import QIF into MYOB Step 19: qif deleted

Related articles