BAI2 Duplicate Error Troubleshooting: Validation error occurred. Bank Statement File is a duplicate.

BAI2 Duplicate Error Troubleshooting: Validation error occurred. Bank Statement File is a duplicate.



In Workday, a "Duplicate" error during a BAI (Bank Administration Institute) file load typically triggers when the system detects that the statement you are trying to import has already been recorded in the tenant. Workday uses specific fields within the BAI2 file structure to determine uniqueness and prevent double-posting of transactions.

The error is usually caused by one of the following factors:

1. Re-use of the "Statement Number" (Record 02)

Workday checks the Statement Number field in the group header (Record 02). If you or the bank sends a file with a Statement Number that matches an existing record for that specific bank account, the connector will reject it.

  • The Fix: Ensure the bank is incrementing the statement number for each new file. If you are testing, manually increment this number in the file (often found at the end of the 02 record).

2. Matching File Metadata

The standard connector often validates the combination of:

  • Bank Account Number (Record 03)

  • Statement Date (Record 02)

  • Opening/Closing Balances

If you try to reload the exact same file (even with a different filename), Workday recognizes the internal data as a duplicate of a previously successful integration run.

3. Duplicate Transaction IDs (Record 88)

While less common for the "Statement Duplicate" error, if your tenant configuration is set to validate unique transaction references, duplicate Reference Numbers in the 88 (continuation) records can cause the load to fail. This often happens if the bank sends a "Previous Day" and "Current Day" file that overlap.

Troubleshooting Checklist

To pinpoint the cause, perform these steps:

StepAction
Check Audit TrailNavigate to the "View Bank Statement" report. Filter by the bank account and date to see if a statement already exists for that period.
Inspect Record 02Open the BAI file in a text editor. Look at the 02 record (Group Header). Check the Statement Number (usually the 9th field).
Verify Bank AccountEnsure the bank account number in Record 03 exactly matches the Bank Account ID or Account Number defined in Workday.
Integration EventsReview the "Integration Event" logs. Look at the "Messages" tab for a specific record ID or line number that Workday is flagging as the duplicate.

Note: If you genuinely need to reload a file (e.g., the previous load had incorrect mapping but "Success" status), you must first Delete or Cancel the existing bank statement in Workday before the connector will accept the file again. If your file contains multiple companies/accounts, and any of those were previously loaded, you will still receive the duplicate error.