How To Use CSV2OFX

This tutorial shows how to use CSV2OFX utility. IMPORTANT: CSV2OFX is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.

Step by step instruction

Click the 'Download' button.

CSV2OFX Step 1: Download

And then select Windows or macOS version to download.

CSV2OFX Step 2: Windows or macOS version

Once downloaded and installed, start CSV2OFX. Read the welcome message that provides the main points about the conversion process.

CSV2OFX Step 3: Welcome message

Select a file with transactions that you would like to convert. It could be CSV or Excel file bank or credit card statement downloaded from online banking.

CSV2OFX Step 4: Select a file

Review transactions before converting, make sure dates are correct, expenses are negative, and payments to the account are positive.

CSV2OFX Step 5: Review transactions before converting

Set the Account ID and Account Type. The Account ID must be digits only. You can enter the actual account number or credit card number, or a shortened number. It is important to use the same number when you convert multiple files for the same account and use a different number, when you start converting for another account.

For example, let's start with the first file for a checking account. Convert the first file and use account id as 10000001. Then you convert a second file for the same checking account, keep the same Account ID 10000001.

CSV2OFX Step 6: Checking account

Then you start with a credit card account. For the first file for the credit card account, change the Account ID to another number, for example, 10000002. For the second file for this credit card account, keep the Account ID as 10000002.

CSV2OFX Step 7: Credit card account

When you start working with another account, make sure to adjust the Account Type as well.

The Currency can be adjusted and specific accounting software may require the Currency match as well as Bank ID and Branch ID.

CSV2OFX Step 8: Currency

The OFX target is important to set matching your accounting/finance software, as the converter will create the OFX file version compatible with your software.

CSV2OFX Step 9: Target

There are some other settings that discussed in another video, we would skip these for now as you need them only in specific situations and you know when you need to change these settings.

CSV2OFX Step 10: Other settings

Set the “Open after save” checkbox if you would like the software installed on your computer to open the created OFX file. If you have MS Money installed, it would be MS Money to open this OFX file.

CSV2OFX Step 11: Open after save

Click the 'Convert' button.

CSV2OFX Step 12: Convert

And confirm the filename and the file location.

CSV2OFX Step 13: Confirm the filename

To import the created OFX file manually, in MS Money, click File, Import, Downloaded Statement.

CSV2OFX Step 14: Downloaded Statement

Select the created OFX file. Click the 'Import' button.

CSV2OFX Step 15: Select the created OFX

Import complete.

CSV2OFX Step 16: Import complete

Review transactions.

CSV2OFX Step 17: Review imported transactions

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