Programme SAP REIDE_TLS_RECONCILE_CL_ACC - Analysis: Reconciliation of Bank Clearing Account

Purpose
This report analyzes the bank clearing account used by the aggregatedposting for the service provider (ETHIM, ETHI, ETHIM_TAX) anddistribution lot.

Prerequisites
Reconciliation keys determined on the basis of the selection must befully transferred to the general ledger. If this does not occur, theprogram ends.
Also, the selected reconciliation key may not contain any archivedposted documents. If it does, the reconciliation key is excluded fromfurther analysis. However, the program does not end.

Selection
The following parameters are available in the selection options:

  • Company Code

  • G/L Account (Bank Clearing) - G/L account used as clearing account
  • during aggregated postings and during distribution lot postings
    • Fiscal Year

    • Posting Date

    • In the output options, you can specify which lists you want to display:
      • Reconciliation list

      • Grid Usage Bills list - For this list, you can specify restrictions for
      • grid usage bills based on their payment status:
        Not paid
        Partially paid
        Fully paid
        Overpaid
        Reversals only paid (this means that unpaid reversed grid usage billswill not be displayed)
        • Message list (log)
        • Output

          • In the Bank Clearing Account Reconciliation list, postings to bank
          • clearing accountsin FI are compared to postings in FI-CA (which havesubsequently been transferred to the general ledger). The postings aresummarized based on the following:
            The period (during which the posting took place in FI)
            The reference transaction (FKKSU means transfer posting to generalledger from FI-CA; BKPF means direct posting in FI; descriptions forothers are in DB table TTYP)
            The transaction currency.
            The FI-CA postings are categorized as bills (aggregated postings forservice provider), payments (distribution lot postings) and others. Anyquestionable summarized postings (if the reference transaction is otherthan FKKSU, or the FI amount differs from FI-CA total amount) arehighlighted in red.
            • The Grid Usage Bills and Payments list contains grid usage bills based
            • on the restrictions specified on the selection screen. The followingdata is also displayed for grid usage bills:
              Reference to distribution lot item which clears the bill (if a gridusage bill is cleared by more than one distribution lot item, the string"************" is displayed)
              Sum of payment amounts (also taking reversals into account)
              Number of payments
              Number of reversals
              Bill not in selection (distribution lot item was in selection specifiedby fiscal year and posting date, but original grid usage bill was notselected because of its posting date)
              Posting status:
              -,,N - Grid usage bill not paid
              -,,P - Grid usage bill paid partially
              -,,F - Grid usage bill paid fully
              -,,O - Grid usage bill overpaid