- 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.
Bank Statement Lines (tfcmg5511m000)Use this session to view bank statement lines.
Electronic Bank Statement
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. Status 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”. 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 pay-to business partner or the pay-by business partner. 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:
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. Original 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. Only Not Completed Lines Displays only the lines that were not yet fully matched and for which action is required.
| |||