SAP Knowledge Base Article - Public

2669287 - How to Solve Bank Statement File Upload Failed Errors

Symptom

You have received below error message when uploading a bank statement file.

No bank account active on DD.MM.YYYY for account number X, national bank code Y, and currency ZZZ found, Bank account missing or cannot be determined.

Closing balance  must match opening balance Y of the next bank statement

Opening balance X  must match closing balance of the previous bank statement Y

Calculated closing balance X is different from stated -Y

Sum of debit items X must match Total Debit Amount Y

Sum of credit items X must match Total Credit Amount Y

Bank statement currency must match all other currencies on header

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the File Management view.
  3. Go to the Inbound Files sub view.
  4. Perform the action New Inbound file to upload a new file.
  5. You receive an error message.

Cause

The error messages received while uploading bank statements are due to incorrect Bank Statement File. Customer need to check with the bank for these inconsistencies in the file.

Resolution

  1. No bank account active on DD.MM.YYYY for account number X, national bank code Y, and currency ZZZ found, Bank account missing or cannot be determined. Resolution: You need to correctly maintain the Bank data in the My Banks View Liquidity Management Workcenter. Make sure that a bank is entered in the system with a bank account number, national bank code and currency as maintained in the file. The bank account should be active before the bank statement date specified in the file.
  2. Closing balance  must match opening balance Y of the next bank statement. Resolution: The closing balance of a bank statement must match the opening balance of the next bank statement. You need to check the balances with your bank to provide the correct information in the file.
  3. Opening balance X  must match closing balance of the previous bank statement Y. Resolution: The opening balance of a bank statement must match the closing balance of the previous bank statement. You need to check the balances with your bank to provide the correct values in the file.
  4. Calculated closing balance X is different from stated -Y. Resolution: The opening balance value is missing in the file.  Therefore the calculated closing balance is different from the actual closing balance entered in the file. You need to check the balances with your bank to provide the correct values in the file.
  5. Sum of debit items must match Total Debit Amount Y. Resolution: The total debit entered on header record level does not match the sum of all debit items in the bank statement. You need to check the balances with your bank to provide the correct values in the file.
  6. Sum of credit items X must match Total Credit Amount Y. Resolution: The total credit maintained on header record level does not tally with the sum of all credit items in the bank statement. You need to check the balances with your bank to provide the correct values in the file.
  7. Bank statement currency must match all other currencies on header. Resolution: The currency must be same for all the records on the header. The bank statement currency must be equal to the Opening balance currency, closing balance currency, Total debit amount currency and total credit amount currency. If there is no record present in the bank statement for above record types, the file can't be uploaded.  will not be able to match the currencies for the entire header.

Keywords

All other currencies on head, Bank statement currency must match, Bank statement upload error, Calculated closing balance, Currency mismatch , KBA , opening balance , all other currencies on head , bank statement file error , bank statement upload , AP-PAY , Payment Processing , Problem

Product

SAP Business ByDesign all versions