Identifying Unique Account IDs for Standard Bank Statement Parsers

The Unique Account ID is required when you are mapping bank accounts in the format profile record. If you are using parsers in the Bank Statement Parsers SuiteApp, you can use the following methods to identify the unique account IDs:

BAI2 Unique Account ID

For BAI2–formatted files, use the Customer Account Number field in the Account Identifier record (Record 03, field 2).

Sample:

OFX/QFX Unique Account ID

For OFX or QFX-formatted files, use the following unique account IDs:

• For bank accounts, the unique account ID is the Account Number in the Bank Statement section.

  Sample:

  

• For credit card accounts, the unique account ID consists of the last 4 digits of the Account Number (ACCTID) tag, followed by an underscore, and then the Currency Code. In the following example, the unique account ID would be: 6008_USD.

  Sample:

  

MT940 Unique Account ID

For MT940–formatted files, use the Account Identification in Tag 25.

Sample:

CAMT.053 Unique Account ID

For CAMT.053 formatted files, the unique account ID is the account number found in either the IBAN or the Other tag, under the Account Identifier.

Sample (IBAN):

Sample (Other Identifier):

CSV Unique Account ID

For CSV formatted files, the unique account ID is the account number found in the Account Number column of your bank statement file.

Related Topics

Creating Financial Institution Records

Format Profile Creation

Bank Account Linking

Mapping Custom Bank Codes

Configuring Standard Bank Transaction Parsers

Downloading Sample Bank Statement Parsers Scripts

Setting Up Standard Bank Statement Parsers

General Notices