Skip to Content
avatar image
Former Member

Bank Reco in FICA

Hi All,

In FICA I am using direct debit run (FPY1) to take money directly from consumers' bank accounts.Now when the bank is returning the file it contains both successful and unsuccessful payments.Successful payments should be debited to Bank A/c crediting the Bank Clearing A/c and unsuccessful payments should be posted as Returns.Now my question is whether standdard programme or Tcode is available in FICA to process the Bank Return File to process both successful and unsuccessful payments?

Thanks

Banasri

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 14, 2010 at 05:39 AM

    Program-RFKKRL00

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      What you are saying is Bank Reconciliation from FI.

      I want to know whether from Return Programme in FICA , the successful entries will be posted.

      Thanks,

      Banasri

  • Jun 29, 2010 at 12:26 AM

    Hi,

    The return progarm-RFKKRL00 is only used for updating dishonor in FI-CA.

    Moreover, when a direct debit run happens for a customer in FI-CA, the following entries take place-

    Bank A/c Dr

    To Bank Clearing A/c

    Bank Clearing A/c Dr

    To Sundry Debtors

    These entries get captured in the reconciliation key and are transferred to FI in the nightly GL batch run.If any dishonor happens it would reverse the above entry and will be transferred to FI as well.

    I am not sure why successful payments needs to be updated, as if it any dishonor happens it will anyways be updated and flow from FI-CA to FI.

    Hope it Clarifies.

    Thanks,

    Amlan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Banasri.

      How we have set it up for our Outgoing Payment Run (just reverse entries for Direct Debit) :

      1. Payment Run in FI-CA

      DR Control Account

      CR Bank Clearing (total amount of payments)

      2. Bank statement is loaded through FI and posts

      DR Bank Clearing

      CR Bank

      In the event that we have a reject in our payment run, we also get the whole payment file back with those rejected identified. We created a custom program based off FPB5 (RFKKRL00) which takes only those rejected items and creates them in a FICA return log and reverses the payments. This creates the following entries

      DR Bank Clearing

      CR Control Account

      The settlement amount on the bank statement is then the total of the payment run less and the value of the rejects and that can clear off against the two documents in your bank clearing account.

      Thanks

      Natalie