Import an OFX file into MYOB

Modified on Fri, Jul 2, 2021 at 3:31 PM

This tutorial shows how to import an OFX file with transactions into the Online Accounting system - 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 ProperSoft converter, like the [Transactions] app, Bank2QIF, or Bank2OFX, or PDF2QIF, or PDF2OFX, or CSV2OFX, or CSV2QIF. And for QIF files ProperSoft converters have the specific MYOB Target to create compatible MYOB QIF files and use a specific date format, another thing, that the MYOB system expects. If you use some converter, you would select just a Regular OFX file to create compatible with the MYOB OFX file. 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 you could use a Bank2OFX converter and convert your not-compatible OFX file to a compatible OFX file. To proceed with the OFX file, first, you need to login in MYOB. Then click on 'Banking' - 'Bank transactions'.

Click 'Import statements'. 

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

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

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

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

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

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

Let's say, if you realized, that the OFX 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 the way to roll back from an incorrectly imported OFX file. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article