Import a QIF file into MYOB

Use the Transactions app to convert your transaction files to required by your accounting software file format.

This tutorial shows how to import a QIF file with transactions into the 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'.Look for the button 'Import statements'. 

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

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

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

Let's select a QIF file. 

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

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. 

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

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

The process to review the transactions is called 'Allocate' or 'Match'. Now we have to allocate the 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.  

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

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

Select an account you've imported your data. 

Then click 'Action'. 

Click the 'Continue' button. 

And then click the '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.