Financial File Import support importing/mapping of custom fields into Bank Transaction object

Follow

Bao Do

• November 23, 2022 17:37

The Financial File Import allows the importing of bank/credit card files directly into Bank Direct Connect.  However there are limitations:

1. Must be an OFX/QFX file

2. Only the following data can be mapped and imported onto a Bank Transaction record:

• Payee (mapped to Description)
• Posting Date (mapped to Date)
• Amount (mapped to Amount)
• Check Number
• Memo

However, most financial institutions have additional data in the file which users wish to include in that import (such as a tax amount of a transaction, etc.).  

There needs to exist a way to map and import this additional data into the bank transaction.

FYI - Using any other data loading tools or AS's Import Templates will not work b/c the constraint of FFI requiring OFX/QFX is due to additional metadata on each record (such as FITID) also being imported which cannot be derived from the original file in its CSV form 

2

• Official comment

  

  Preasha Hussain

  • December 22, 2022 13:26

  Hello Bao, 

  Thank you for noting these limitations. I will submit this to the Product Development team for review. 

  Comment actions Permalink

Please sign in to leave a comment.