JPK Bank Statements Line Selection Rules

The JPK Bank Statements Extract can be created for any specified period. The extract is always created for one bank account and assigned to the reporting legal entity.

The bank account reported must have a defined IBAN number since it's displayed as the account number in the file.

The JPK Bank Statements Extract is created as an XML file in the legally required format, JPK_WB. The bank statements are selected based on these rules:

• All bank statements with a start date between the dates From Date and To Date are selected.

• All lines with a value date between the dates in the parameters are selected. If the value date is blank, then the accounting date is retrieved from the line date, and is compared with the parameter dates.

• Debit lines are displayed as negative amounts.

• Credit lines are displayed as positive amounts.

• Statements lines are ordered by the line date.

• The extract opening balance is equal to the opening balance of the earliest bank statement period selected by the extract.

• The extract closing balance is calculated by adding or subtracting amounts of all lines in the extract to the opening balance.

• Credit and Debit totals are calculated:

  • Credit total is the sum of all positive amounts in the extract.

  • Debit total is the sum of all negative amounts in the extract. The total amount is displayed with a positive sign.

• All selected lines are counted and the line count is displayed in each line.

  The credit total, debit total, and the number of lines are displayed in the file Control section.

  You must have the Manage Bank Statement and Reconciliation Activities (CE_MANAGE_BANK_STATEMENT_AND_RECONCILIATION_ACTIVITIES_PRIV) privilege to enter bank statements. To enter bank statement lines:

  1. Navigate to Cash Management> Create Bank Statements page.

  2. Enter and save the bank statement header.

  3. Enter the bank statement lines.

  You may enter and save a Bank Statement. Reconciliation does not affect the content of the extract.

Enter all the bank statements for the reported period to generate the correct bank statement extract data. You must also populate the statement line level fields on the Create Bank Statement Line page:

• Booking Date

• Flow Indicator: Debit or Credit

• Amount: Positive amount

• Counterparty Bank Account Name

• Customer Reference

• Additional Entry Information