Identifying Unique Account IDs for Standard Bank Statement Parsers

You'll need the Unique Account ID when mapping bank accounts in the format profile record. If you're using parsers in the Bank Statement Parsers SuiteApp, here's how you can identify 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 these unique account IDs:

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

  Sample:

  

• For credit card accounts, the unique account ID is the last 4 digits of the Account Number (ACCTID) tag, an underscore, and the Currency Code. In the following example, the account ID is 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 files, the unique account ID is the account number in either the IBAN or Other tag, under Account Identifier.

Sample (IBAN):

Sample (Other Identifier):

CSV Unique Account ID

For CSV formatted files, the unique account ID is the account number 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