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.