CSV2OFX: Convert CSV/XLS/XLSX to OFX

What can I do with CSV2OFX (CSV/XLS/XLSX to OFX Converter)?

• Download, install and run the software
• Select a file with transactions
• Review transactions and click Convert to create a OFX file
• Import created file to Xero, Sage One or other OFX importing software or online service

Why should I trust CSV2OFX?

• It runs and processes your files on your computer - no data leaves your computer
• It does not send your transactions anywhere
• Please check our product testimonials

If I need any help with conversion, can you help me?

• Free support is available before and after the purchase
• All license options include at least 14 days of the conversion support after the purchase
• The Professional and Team licenses include ongoing conversion support
• Please use the Support page or email us at support@propersoft.net.

Can I try before purchasing?

• Yes. CSV2OFX is free to download and try.
• Your file will be fully parsed in the trial mode, so you can verify that CSV2OFX understands your transactions file correctly.
• You can create a fully functional and loadableOFX file before purchasing (with limitation to 10 transactions - this limitation is removed after you register).

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 CSV2OFX utility.

Step by step instructions for Windows

See below steps 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 'Save and Close' and 'Next' button.

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

Payee name did not assign because this is Vendor Record that you have to select in Quickbooks. This is not 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.

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, check number is assigned.

Before creating OFX file set the Account ID (number) and the Account Type.

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

Payee name did not assign because this is Vendor Record that you have to select in Quickbooks. This is not 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.