1. Accounting
  2. Banking
  3. Bank Statement Parsers SuiteApp
  4. Setting Up Standard Bank Statement Parsers
  5. Identifying Unique Account IDs for Standard Bank Statement Parsers

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:

A section of a BAI2-formatted file.

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:

    A section of an OFX or QFX-formatted file.

  • 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:

    A section of an OFX or QFX-formatted file that shows where the Account Number is located.

MT940 Unique Account ID

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

Sample:

A section of a MT940-formatted file.

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):

A section of a CAMT.053 file.

Sample (Other Identifier):

A section of a CAMT.053 file.

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

General Notices