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 ProperConvert app, which converts from more formats and converts to more formats.

This is tutorial for CSV2OFX version 3. For the next version, use this new CSV2OFX tutorial.

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.

CSV2OFX Windows Step 1: select a CSV file

Review transactions before converting, reassign columns if needed. Make sure expenses are negative and deposits are positive.

CSV2OFX Windows Step 2: review transactions before converting

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

CSV2OFX Windows Step 3: Account ID, Account Type

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

CSV2OFX Windows Step 4: currency

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

CSV2OFX Windows Step 5: Target

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

CSV2OFX Windows Step 6: click Convert

Confirm the file name and location.

CSV2OFX Windows Step 7: file name and location, save

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 '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.

CSV2OFX Windows Step 8: Upload transactions manually in Quickbooks

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

CSV2OFX Windows Step 9: click Browse to locate OFX file in Quickbooks

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

CSV2OFX Windows Step 10: add new account in Quickbooks

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

CSV2OFX Windows Step 11: Select Account Type in Quickbooks

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

CSV2OFX Windows Step 12:  transactions are imported in Quickbooks

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.

CSV2OFX Windows Step 13:  payee in Quickbooks

Import created OFX file into Xero

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

CSV2OFX Windows Step 14: import a bank statement in Xero

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

CSV2OFX Windows Step 15: import bank transactions in Xero

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

CSV2OFX Windows Step 16: click Browse in Xero

Then click the 'Import' button.

CSV2OFX Windows Step 17: click Import in Xero

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

CSV2OFX Windows Step 18: transactions are imported in Xero

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 ProperConvert app, which converts from more formats and converts to more formats.

CSV2OFX Mac Step 1: select a CSV file

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.

CSV2OFX Mac Step 2: review transactions before converting

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

CSV2OFX Mac Step 3: Account ID and Account Type

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

CSV2OFX Mac Step 4: currency

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

CSV2OFX Mac Step 5: OFX Target

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

CSV2OFX Mac Step 6: click Convert

Confirm the file name and location.

CSV2OFX Mac Step 7: confirm 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 'Banking' and click on it.

CSV2OFX Mac Step 8: Banking in Quickbooks

And then select the account you want to import your data into.

CSV2OFX Mac Step 9: select an account in Quickbooks

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.

CSV2OFX Mac Step 10: File Upload in Quickbooks

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

CSV2OFX Mac Step 11: click Browse in Quickbooks

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

CSV2OFX Mac Step 12: select an account in Quickbooks

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

CSV2OFX Mac Step 13: transactions are imported in Quickbooks

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.

CSV2OFX Mac Step 14: payee name in Quickbooks

Import created OFX file into Xero

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

CSV2OFX Mac Step 15: import a statement in Xero

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

CSV2OFX Mac Step 16: click browse in Xero

Then click the 'Import' button.

CSV2OFX Mac Step 17: click import in Xero

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

CSV2OFX Mac Step 18: transactions imported in Xero

Related articles