This tutorial shows how to use CSV2OFX utility. IMPORTANT: CSV2OFX is now replaced with the Transactions app, which converts from more formats and converts to more formats.
You can download CSV2OFX at https://www.propersoft.net/products/csv2ofx
Click the 'Download' button.
And then select Windows or macOS version to download.
Once downloaded and installed, start CSV2OFX. Read the welcome message that provides main points about the conversion process.
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.
Review transactions before converting, make sure dates are correct, expenses are negative, and payments to the account are positive.
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.
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.
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.
OFX target is important to set matching your accounting/finance software, as the converter will create the OFX file version compatible with your software.
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.
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.
Click the 'Convert' button.
And confirm the filename and the file location.
To import the created OFX file manually, in MS Money, click File, Import, Downloaded Statement.
Select the created OFX file. Click the 'Import' button.