Bank Statement Lines (tfcmg5511m000)

Use this session to view bank statement lines.

 

Electronic Bank Statement

  • A system for automatic processing of electronic bank statements received from the bank on disk, tape, over the Internet, or by modem.
  • The electronic bank statement files.
General
IBAN/Bank Account

International Bank Account Number. An international standard account identifier for identifying an account held by a financial institution, in order to facilitate automated processing of cross border transactions. The IBAN is provided by the bank/branch servicing the account.

Bank Statement ID

The bank statement identifier from the bank.

The bank statement sequence number from the bank.

The currency of the bank statement.

Balances
Opening Balance

The amount of the opening balance.

Closing Balance

The amount of the closing balance.

Exception

If this check box is selected, one or more errors or warnings exist.

Statistics
Total

The total debit amount.

The total credit amount.

Matched

The matched debit amount.

The matched credit amount.

Percentage

The percentage of matched debit amounts.

%

The percentage of matched credit amounts.

Line

The sequence number of the bank statement line, always starting with value “1”.

Page Number

If the bank statement was sent in multiple pages, this is the current page number.

Details
Business Partner's Name

The business partner name retrieved from the bank statement line.

Bank Account

The bank account number from which or to which an amount is transferred.

Bank Identifier

The SWIFT code that identifies financial institutions. The BIC consists of eight or eleven contiguous characters.

Pay-to/Pay by Business Partner

The business partner's title.

Booking Date

The date the transaction was booked at the bank.

Value Date

The date the transaction was posted by the bank.

Detail Line(s)

If this check box is selected, one or more detail lines exist.

Matching Status

The matching status of the bank statement line.

The status can be one of the following:

  • Not Matched
  • Partially Matched
  • Fully Matched
  • Posted
Exception

If this check box is selected, one or more errors or warnings exist.

Amount Details
Amount in Bank Currency

The amount on the electronic bank statement.

The currency on the electronic bank statement.

Incoming/Outgoing

The type of bank transaction. In case of a remaining amount, this indicator determines whether an unallocated payment or an unallocated receipt will be created.

Matched Amount

The amount that was already assigned.

Unmatched Amount

The amount that remains to be assigned.

Bank Charges in Bank Currency

The costs a bank charges to process the transactions. The bank charges can depend on the type of transfer, for example, whether the transfer is between different banks or between branches of the same bank. In addition, the bank charges can vary for different ranges of transaction amounts.

Original Amount

The invoice amount.

The invoice currency.

Exchange Rate

The price at which one currency can be exchanged for another currency. In other words, the amount which one currency will buy another currency at a particular time.

Rate Date

The exchange rate used was valid at this date and time.

References
Description

The description on the bank statement, for example, the invoices paid.

Check Number

The check number used for the payment.

Document Reference

The transaction type and document number, or the trade note number.

Bank Reference

A unique number used by the banks to reference each invoice. The bank reference number can be a string of 20 or more digits, composed in such a way that a number check can be performed to check its validity.

In some countries, the bank reference number is a critical component of payment and receipt transactions, especially if payment slips are used. If bank reference numbers are used, the bank reference number must appear on the invoice document, on the payment slip if applicable, and on the payment document.

Mandate Reference

The number of a direct debit mandate.

Return Reason Code

The return reason code.

Return Reason Description

The return reason description.

Description

The entire description.

 

Validate
Accept

Sets a warning to Accepted. When all warnings are accepted, the Exception check box is cleared.

Match Bank Statements
Post Bank Statements
EBS Matching Rules
Bank Statement Warnings/Errors
Document History
Matching Results
Only Not Completed Lines

Displays only the lines that were not yet fully matched and for which action is required.