Import a Transaction file into MYOB

Importing a transaction file into MYOB accounting system is a quick and easy way to add a large number of transactions to your account at once. This can save you a lot of time and effort, especially if you have a large number of transactions to enter manually. Here's a step-by-step guide on how to import a transaction file into MYOB:

If you are familiar with this system, you know that it is usually for Australian businesses. MYOB supports OFX and QIF import and if you have another format, you could use a ProperConvert app to convert to OFX or QIF.

MYOB has special requirements for QIF files, make sure to select QIF target as MYOB. For OFX files, "Regular OFX" should work fine with MYOB.

If you downloaded MYOB from your Online Banking, then you would just upload it to MYOB. If your OFX file is not accepted by MYOB, then use the ProperConvert to convert to either OFX (we extract transaction details from your non-importable OFX and created a good OFX file) or QIF file. We suggest starting with OFX first as OFX is currently widely acceptable format, when QIF is old, retiring, phasing out format.

To proceed with the OFX file, first, you need to login into MYOB. Then click on 'Banking' - 'Bank transactions'.

See below specific use cases to import transaction files into Xero:

Import an OFX file into MYOB

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

Import OFX into MYOB Step 1: click Banking

Click 'Import statements'.

Import OFX into MYOB Step 2: Import statements

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

Import OFX into MYOB Step 3: select account

Browse to select an OFX file and click 'Open'.

Import OFX into MYOB Step 4: select ofx file

And 'Date format if using QIF' setting applicable to QIF files for OFX files, you can ignore it.

Import OFX into MYOB Step 5: Date format if using QIF

To import an OFX file, click 'Import now'.

Import OFX into MYOB Step 6: Import now

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

Import OFX into MYOB Step 7: statements imported successfully

We have to review transactions, Account, Tax code, split transactions if needed. Continue with all transactions. You can also create a rule for the next OFX import, if it is the same - Payee, Amount, same Description. Then this accounting system will be allocated automatically.

Import OFX into MYOB Step 8: review transactions

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

Import OFX into MYOB Step 9: View Import History

Select an account you've imported your data.

Import OFX into MYOB Step 10: Select account where imported your data

Then click 'Action'.

Import OFX into MYOB Step 11: click action

Click the 'Continue' button.

Import OFX into MYOB Step 12: click continue

And then click the 'Delete' button.

Import OFX into MYOB Step 13: click delete button

This is the way to roll back from an incorrectly imported OFX file.

Import OFX into MYOB Step 14: click delete button

Import a QIF file into MYOB

Use the ProperConvert 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 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 are added. This is a default option of the 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

See this tutorial as a video:

Related articles