The Financial File Import utility is accessible by clicking the Import File button on the Bank Transactions screen. This provides the ability to import a financial file for uploading Bank Transactions.
The Financial File Import is an easy to use wizard for uploading and importing a financial file. Once the import process is complete, the newly imported transactions will be available on the Unmatched Bank Transactions tab and the All Bank Transactions tab.
Up to 500 Bank Transactions can be imported from a single import file. Additionally, there is no date limit for transactions being imported from a file.
Note: Only one file can be imported at a time.
The Financial File Import utility supports the OFX (Open Financial Exchange) and QFX (standard OFX with additional licensing information) file formats. These file formats are available for download from certain bank and credit card companies.
Note: If you are outside of the United States, before importing the file into the new BDC Financial File Import, you need to convert the CSV file from your Financial Institution to an OFX file. The Bank2CSV program can be used for this conversion.
Important: If you download Bank Transactions using our service provider (Yodlee), it is possible to import those same Bank Transactions using the import file process. Therefore you should ensure that the Financial File Import (OFX or QFX file) is filtered properly to avoid duplicate Bank Transactions.
Import Foreign Bank Transactions
The Financial File Import utility provides the ability to import foreign Bank Transactions. Foreign Bank Transactions consist of transactions that are in a different currency than the Ledger currency. Source records created from foreign Bank Transactions or matched to them will be in the same currency as the foreign Bank Transactions. The GL Transactions created from the source records will be converted into the currency of the Ledger.
Do you want to:
Import a Financial File
- Navigate to Accounting Home and click the Create Entries tab. Then, under the Banking menu, click Bank Direct Connect.
- Click Import File. The Financial File Import dialog box displays.
- Select of the following:
Note: Only one file at a time can be imported.
- Upload Files - navigation to the location of the file that you want to import.
- Drop Files - drag and drop the import into the Select File box.
- When the file has been uploaded, click Done.
Note: The spinner might display briefly while the file is verified.
- When the File Verified message displays, click Next.
- If this is a new import, click the Lookup icon to search for and select the Ledger and the GL Account.
Note: If this is an import file that was previously imported, the Ledger and GL Account will automatically display. You can modify the Ledger and GL Account, if necessary, but only new Bank Transactions will be affected. Transactions will only match source records that are found for the selected Ledger and GL Account.
- Click Import. The imported Bank Transactions display on the All Bank Transactions tab. If any of the transactions are unmatched, they will display on the Unmatched Bank Transactions tab.
If the import is not picking up the <NAME> field, it might be because it was split into two or more lines. The entire value needs to be on one line. If it spans multiple lines, the <Name> value lines will need to be combined into one line. See the example below.
Old (two lines):
<NAME> this is the value for the N
AME field. </NAME>
New (one line):
<NAME> this is the value for the NAME field. </NAME>
When a file is imported and records are missing (not imported), the issue might be related to the <FITID> field value being a duplicate of another record. A record with a duplicate <FITID> will not be imported. If there are duplicates, we recommend updating the <FITID> of the record that was not imported by adding .1 or .2 or a similar value. See the example below.
Two transactions had the exact same FITID of <FITID>21003-807.01.2021</FITID>. The first record was imported. The second record was not because it was a duplicate of the first record that was already imported. Change the <FITID> of the second record to <FITID>21003-807.01.2021.2</FITID>. After making the change, re-import the Financial File.
Note: Any record that has already been imported will not be re-imported when the file is processed again.
- There will no longer be a date limit for transactions being imported from a file. The only limitation that needs to be considered when importing transactions from a file is the total number of transactions in the OFX file (currently, no more than 500).
- This article was new with the Jasmine release.