Matching Results (tfcmg2500m100)

Use this session to view the results of automatic and manual matching.

Field Information

View
Electronic Bank Statement

electronic bank statement

Matching Status
Converted
Importing in Process
Imported

The initial status of a bank statement that was received via a BOD.

Validation in Process
Not Applicable
Validation Warnings
Validated
Matching in Process
Partially Matched
Conversion in Process
Fully Matched
Posting in Process
Posting Errors
Posted
Exception

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

Lines
Cash Document

The transaction type selected in the Transactions (tfgld1101m000) session. This transaction type must be a Cash transaction type.

Document

The unique identification of the document used for the transaction type's financial transactions.

Line

The line number.

The combination of line number and document number identifies the transaction.

Company

The financial company in which to post the transactions. The current company appears by default.

If the transaction type is Journal, you can select a different company. If you select a different company, LN automatically creates an intercompany transaction.

Bank Statement Line

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

Bank Statement Sequence

The bank statement sequence number from the bank.

Budget Exception

If this check box is selected, a budget exception or an error occurred.

To correct the problem, you can decrease the amount, or use a different budget account by changing the ledger account and/or dimensions. If no error occurred in this area, the budget controller must resolve the exception. In case of a setup error, the error must be corrected in the area in which it was caused.

Deductions
Discount Amount

If the invoice is paid within an allowed discount period, LN deducts this amount from the total invoice amount.

You can access this field if the value in the Document field is

  • Receipt Transaction
  • Payment Transaction

LN gives the default discount amount, if the value in the LPS/Discount for Partial Payments field in the CMG Parameters (tfcmg0100s000) session is

  • Fully
  • Proportionally

If the Block Discount Exceeding Tolerance check box is selected in the CMG Parameters (tfcmg0100s000) session and the discount exceeds the discount tolerance amount defined in the Payment Terms (tcmcs0113s000) session, you cannot process bank transaction.

Late Payment Surcharge Amount

The late-payment surcharge amount.

Late payment surcharge is calculated using the percentage linked to the invoice in:

  • Sales Invoices (tfacr1110s000)
  • Purchase Invoice Entry (tfacp2600m000)
Payment Difference

The payment difference for the selected invoice.

You can access this field if the value in the Document field is:

  • Receipt Transaction
  • Payment Transaction

The payment difference amount and the percentage must both fall within the tolerances defined in t250he CMG Parameters (tfcmg0100s000) session or specifically for you in the Payment Authorizations (tfcmg1100m000) session.

Factoring Commission Amount

The factoring commission amount, expressed in the currency defined in the Currency/Rate (Home-Bank) field.

The default factoring commission depends on the values entered for the Commission on Partial Payments in the CMG Parameters (tfcmg0100s000) session. You can change the amount.

Details
General
Document Date

The date on which you carried out the transaction at the bank.

Default value

The current date appears, by default.

Based on this date, LN calculates the default amount received/paid, from the Receipt Transaction or Payment Transaction specified in the Type of Transaction field.

Type of Transaction

Select the transaction category for the data you maintain in this session.

Advance Payment Category

If you selected the Allow Advance Payment Category check box in the CMG Parameters (tfcmg0100s000) session and the posting method is Advance Payment, you must select a category.

Bank Reference

If you use bank reference numbers, this is the bank reference number of the invoice.

Invoice/Payment Details
Invoice-from/to Business Partner

Enter the invoice-from business partner code or invoice-to business partner code.

Invoice/Anticipated Document

The transaction type of the invoice settled, fully or partially, by the bank transaction.

You can access this field if the value in the Document field is:

  • Receipt Transaction
  • Payment Transaction
BP Payment No.

Enter the payment number used for payments to the business partner.

Line
Amounts in Bank/Transaction Currency
Amount in Bank Currency

The payment amount, expressed in the currency defined in the Currency/Rate field.

Amount in Invoice Currency

The payment amount, expressed in the currency defined in the Currency/Rate field.

The bank transaction currency.

Amounts in Home Currency
Currency Difference

The currency difference amount.

Currency differences arise due to exchange rate fluctuations.

Late Payment Surcharge

The late payment surcharge in the home currency.

Discount

The discount amount in the home currency.

Payment Difference

The payment difference in the home currency.

Factoring Commission

The factoring commission in the home currency.

The default factoring commission depends on the values entered for the Commission on Partial Payments in the CMG Parameters (tfcmg0100s000) session. You can change the amount.

Details
Fiscal Period

The fiscal year and the fiscal period number of the bank transaction.

Fiscal periods are defined in the Periods (tfgld0105m000) session.

Reporting Period

The reporting year and the period number determine the reporting period of the bank transactions.

Reporting periods are defined in the Periods (tfgld0105m000) session.

Group Tax Code

group tax code

Discount Date
Late Payment Surcharge Date
Document

The document number of the invoice settled, fully or partially, by the bank transaction.

You can access this field if the value in the Document field is:

  • Receipt Transaction
  • Payment Transaction
Schedule Line Number

The payment schedule line number.

If you use receipts against shipments, this number indicates the shipment.

Target Company

The financial company to which the transactions must be posted.

Series No. Composed Payment

The sequence number that belongs to the Transaction Type.

Pay-to/by Business Partner

The pay-to business partner or pay-by business partner.

Journal description

Comments for the transaction.

Currency/Rate (Home-Bank)

The currency used for the bank transactions.

Rate

The currency exchange rate. This rate is defined in the Currency Rates (tcmcs0108m000) session.

Currency/Rate (Bank - Transaction)

The code of the currency and the rate used in the bank transaction and the ISO 4217 alpha currency code (recommended).

Note: 
  • The currency can be modified only if the Type of Transaction is set to Unallocated Receipt, Unallocated Payment, Advance Receipt or Advance Payment.
  • The currency is defaulted with the invoice currency, if the Type of Transaction is set to Receipt Transaction or Payment Transaction.
  • The rate can be modified only if:
    • The Type of Transaction is set to Receipt Transaction, Payment Transaction, Unallocated Receipt, Unallocated Payment, Advance Receipt or Advance Payment.
    • The Currency/Rate (Bank - Transaction) differs from the currency of the bank.
  • This field is defaulted from the Original Rate if the currency of the invoice is the same as the Original Transaction Currency.
  • If the Type of Transaction is set to Unallocated Receipt, Advance Receipt, Unallocated Payment or Advance Payment, the Currency (Transaction) is defaulted from the Original Transaction Currency and the Rate (Bank-Transaction) is defaulted from the Original Rate.

Journal description

The result of the selected rate.

Bank Transaction Rate

The result of the selected rate.

Tax Country/Code

The tax country and tax code that apply to the transaction.

You can access this field:

  • If you select Advance Payment or Advance Receipt in the Document field.
  • If you select the Calculate Tax on Advance Payments/Receipts check box of the CMG Parameters (tfcmg0100s000) session.

LN only calculates the tax amount if the transaction amount is not less than the amount specified in the Minimum Amount for Tax Calculation field in the CMG Parameters (tfcmg0100s000) session.

Specify the country code for tax calculation. This country code must have been linked to the tax code in the Countries (tcmcs0110s000) session.

LN displays the country (for tax) linked to the discounts, late payment surcharges, and payment differences with respect to this partial payment in the Posting Data by Tax Code for Deductions (tfcmg0150m000) session.

Net/Gross

Either Net or Gross.

Payment Document Status
Transfer Method

The way in which the transactions are transferred to the bank.

If the supplier pays the bank costs, you cannot change this field.

Sundry Costs

The bank costs that do not belong to any other specified category.

If the supplier pays the bank costs, you cannot change this field.

Reference

Enter the reference text.

Registration Document Number

The document number (such as an external receipt number, supplier payment identification, customer receipt identification and so on) registered with the bank transactions for advanced payments, advanced receipts and cash journals.

Note: 
  • This field is applicable only if the Functionality for Slovakia and/or the Functionality for Czech Republic check boxes are selected Implemented Software Components (tccom0100s000) session.
  • The value in this field contains a maximum of thirty characters.
  • This value can be modified if Type of Transaction is set to Journal
  • This value can also be modified for Type of Transaction set to Advance Payment or Advance Receipt, only if the Calculate Tax on Advance Payments/Receipts check box is selected in the CMG Parameters (tfcmg0100s000) session.
Amount in Home Currency

The payment amount in the home currency.

Tax Amount in Bank Currency

The tax amount in the invoice currency.

If a tax code is linked to the invoice, LN displays the tax amount calculated on the basis of the data defined for the specified tax code in the payment/receipt currency.

Remittance

remittance code

Debit/Credit

Use this indicator to classify the amount as debit/credit. You can access this field if the transaction type is Journal.

Control Account

control account

Dimension 1

Enter the Dimensions.

Dimension 2
Dimension 3 - 12
Ledger Account

ledger account

Dimensions

The first dimension to which the transaction must be posted.

Dimension Description

The dimension description.

Cash Flow Reason

The cash flow reason of the transaction.

Transaction Template

transaction template

Tax Country/Code

The tax country to which the transaction template applies.

Invoice Date

invoice date

Due Date

due date

Tax Period

The year and the tax period in which the tax over the invoice amount is settled.

Tax Date

The date on which the Value Added Tax (VAT) is reported.

Note: 
  • This value can be modified if Type of Transaction is set to Journal
  • This value can also be modified for Type of Transaction set to Payment Reconciliation, Advance Payment or Advance Receipt, only if the Calculate Tax on Advance Payments/Receipts check box is selected in the CMG Parameters (tfcmg0100s000) session.
Invoice/Schedule Balance

invoice balance

Sundry Costs

The sundry cost amount in the home currency.

The currency used for the bank transactions.

Withholding Tax Amount
Net Amount Payable to Business Partner

The net payable invoice amount.

Withholding Income Tax

The withholding income tax amount.

Withholding Social Contribution

The withholding social contributions amount.

Social Contribution Company Expense

The social contributions (expense) amount.