Import a QIF/OFX file into MYOB
This tutorial shows how to import a QIF or OFX file with transactions into Online Accounting system - MYOB. Use the ProperConvert app to convert your transaction files to either QIF or OFX (make sure to select the QIF target as MYOB or for OFX select Regular OFX).
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'.
Let's select a QIF or OFX file, and for 'Date format if using QIF', you have to know how dates are shown on your QIF file. FOr OFX files, the date format can be ignored.
In our case, dates are day/month/year. The ProperSoft converterhas 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 are added. This is a default option of the Australian-based business, they do the dates by day/month/year.
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.
How to rollback imported 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.
