CSV2OFX: Convert CSV files to OFX and import into Quickbooks Online, Xero, Microsoft Money

This tutorial shows how to convert a CSV file from your bank or credit card statement to OFX format and import into Quickbooks Online and Xero. We will use the CSV2OFX utility. IMPORTANT: CSV2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

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 CSV2OFX. Download it from the CSV2OFX download page. Start CSV2OFX and select a CSV file. Review transactions before converting, reassign columns if needed. Make sure expenses are negative and deposits are positive. 

Set the Account ID (number) and the Account Type.  

Also check Currency, End balance, Bank ID and Branch ID. 

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 Quickbooks Online 

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for the 'Banking' and click on it. Click the 'Upload transactions manually' button. In your accounting software, look for 'File Upload, 'Import a statement', 'Upload a bank file', or similar links to upload created OFX file.

Then click the 'Browse' to locate your OFX file. And click 'Next'.  

Then select an account or add new to import and click 'Next'. 

Select the Account Type, choose Detail Type (in our case Bank and Checking Account). Click the 'Save and Close' and 'Next' buttons. 

Once the transactions are imported, you can review, categorize them under the account and add to the register.  

The payee name did not assign because this is Vendor Record that you have to select in Quickbooks. This is not an actual Payee from the OFX file.  

Import created OFX file into Xero

Look for the link 'Import a bank statement to get started' and click on it.

In this case, the OFX format is recommended. You can also do QFX, QBO, QIF, CSV formats.  

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 CSV2OFX. Download it from the CSV2OFX download page. Start CSV2OFX and select a CSV file. IMPORTANT: CSV2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Review transactions before converting, reassign columns if needed. Make sure expenses are negative and deposits are positive. Check that dates are correct, have a correct year, amount, payee name, memo, the check number is assigned. 

Set the Account ID (number) and the Account Type before creating the OFX file. 

Make sure to set the 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 Quickbooks Online

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for the 'Banking' and click on it.And then select the account you want to import your data into. 

Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file' or similar links to upload created OFX file. 

Then click the 'Browse' button and select the created OFX file. And click 'Next'. 

Then select an account in Quickbooks to import and click 'Next'. 

Once the transactions are imported, you can review, categorize them under the account and add to the register. 

The payee name did not assign because this is Vendor Record that you have to select in Quickbooks. This is not an actual Payee from the OFX file.  

Import created OFX file into Xero

Click on 'Manage Account' and look for the link 'Import a Statement'.

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.