Set attributes to convert to the OFX format - ProperSoft

Set attributes to convert to the OFX format

This video talks about how to output to OFX format.

If you need to create OFX format, then use the converters like Bank2OFX, CSV2OFX, PDF2OFX, or other 2OFX converters. This video is for a better understanding of what parameters or attributes the OFX format requires.

Set attributes to convert to the OFX format Step 1: main menu

When you are using a 2OFX converter, then you will find the OFX Tab on the right sidebar.

Set attributes to convert to the OFX format Step 2: OFX Tab

And when you create the OFX file - all this transaction data will be saved in the OFX file, but there are also different attributes related to the whole OFX file, that can be set here.

Set attributes to convert to the OFX format Step 3: transaction data

The first one is the Account ID. If you convert the file for multiple accounts (you will see several accounts here, you can set all of them), the Account ID is digits only number. When you convert it for one account and then you need to convert for another account, make sure to change the Account ID to be different. Different software treats this Account ID in the OFX file differently. Some software, like Sage, requires exact Account ID to be set and some other software remembers your choices for that specific Account ID, remember which account in the accounting software, which account you choose to import your data. Some make a hard connection, some make a soft connection. So, it's better to use different Account IDs, when the files are meant for different accounts.

Set attributes to convert to the OFX format Step 4: Account ID

Another important thing is the Account Type. Make sure, to set the Account Type to match, what you have in your accounting software.

Set attributes to convert to the OFX format Step 5: Account Type

The next thing is Currency. Currency - you can set here and it has to match in your accounting software if your accounting software checks that Currency.

Set attributes to convert to the OFX format Step 6: Currency

Bank ID, Branch ID - some software, like Sage, require this to be set, exactly as you have. The Balance - some software requires, you can set it, if the Balance is provided in the source file, then it will be set or you can set it yourself.

Set attributes to convert to the OFX format Step 7: Balance

Usually, you will not use the 'Deterministic references', you will set a 'Regenerate references', you will 'Allow non-numeric checks', if your software allows. You will not 'Allow empty name', and you will 'Separate Splits', if any. So, this is the default set of settings and advanced topics for the separate video.

Set attributes to convert to the OFX format Step 8: Regenerate references

OFX files will have Date, Amount, Payee, Memo, Check number, Reference.

Set attributes to convert to the OFX format Step 9: Date, Amount, Payee

There are several different Targets, as you see there are little different specific settings for the OFX file. Make sure to select your accounting software to match this setting here. OFX file compatible with your software and plus it puts additional details, that would be useful to you, let's say when you select Xero - it would add the reference, but when you select a format, like Quickbooks Online, it will not put that reference, because it breaks the file.

Set attributes to convert to the OFX format Step 10: Target

Related articles