How to use Bank2OFX (version 3)

This tutorial shows how to convert a transaction file to OFX format. We will use Bank2OFX utility. IMPORTANT: Bank2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats. For the latest version of Bank2OFX tutorial, visit this page.

Step by step instructions for Windows

Follow the steps below for the Windows version, followed by the Mac version.

Make sure you are using the latest version of Bank2OFX. Download it from the Bank2OFX download page. Start Bank2OFX and select the transaction file (it could be QBO file, OFX file, QFX file, QIF file, PDF file, MT940 file or STA).Review transactions before converting, check that dates are correct, have the correct year, deposits and withdrawals are assigned correctly. 

Try a different PDF Library if your PDF file is not parsed correctly by the selected library. You can change the PDF library for better parsing a specific PDF file. 

Set the Account ID (number) and the Account Type before creating the OFX file. For multiple accounts, use a different Account ID for each account. 

Make sure to set Currency. And you can set Bank ID, Branch ID if your accounting software requires. 

Choose the OFX Target to better work with your accounting software or use the "Regular OFX" option.  

Click the 'Convert' button to create an OFX file.  

Confirm the file name and location. 

Import created OFX file into Xero

Click on 'Manage Account' and look for the link 'Import a Statement'. In your accounting software, look for "Upload a bank file" or similar links to upload created OFX file.

Click the 'Browse' button and select the OFX file. 

Then click the 'Import' button. 

Once the transactions are imported, you can review, categorize them under the account. 

Step by step instructions for macOS

Make sure you are using the latest version of Bank2OFX. Download it from the Bank2OFX download page. Start Bank2OFX and select the transaction file (it could be QBO file, OFX file, QFX file, QIF file, PDF file, MT940 file or STA). IMPORTANT: Bank2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Review transactions before converting, check that dates are correct, have the correct year, deposits and withdrawals are assigned correctly. 

Set the Account ID (number) and the Account Type before creating the OFX file. For multiple accounts, use a different Account ID for each account.

Make sure to set Currency. And you can set Bank ID, Branch ID if your accounting software requires. 

Choose the OFX Target to better work with your accounting software or use the "Regular OFX" option. 

Click the 'Convert' button to create an OFX file.  

Confirm the file name and location. 

Import created OFX file into Xero

Click on 'Manage Account' and look for the link 'Import a Statement'. In your accounting software, look for "Upload a bank file" or similar links to upload created OFX file.

Click the 'Browse' button and select the OFX file. 

Then click the 'Import' button. 

Once the transactions are imported, you can review, categorize them under the account.