cancel
Showing results for 
Search instead for 
Did you mean: 

Bank Reconciliation/Clearing Supplier Credit Card Payments #COE #MODPIZZA

former_member95896
Active Contributor
0 Kudos

Hello,

We are issuing payments to some suppliers thru a commercial credit card program at our house bank. The supplier invoices are entered in S/4HANA Cloud, payments generated via Manage Automatic Payments and passed to the bank along with other payment methods via a payment media file. The open payment resides in a bank GL account much like the payment for a check waiting to be cashed.

Procedurally outside of S/4HC in the bank's commercial card system:

  1. The bank contacts the supplier and notifies them that they have a card payment available
  2. The supplier logs into the bank site and takes/transfers the payment
  3. The bank notifies us that the supplier payment has been settled and the amount associated with the payment appears on our credit card balance,
  4. We pay the credit card balance from bank accounts weekly.

The commercial card program at the bank is not part of their treasury operations. The payment settlement in step 3 does not appear in the daily BAI2 formatted bank statements like a payment associated with a check or ACH would. The outgoing payment in step 4 from us to the bank for the credit card balance is the only thing currently captured in our treasury BAI2 bank statements (payment rule F014). Those daily bank statements from the bank's treasury system are imported into S/4HANA Cloud via Manage Incoming Payments weekly (Monday/Tuesday a cash accountant extracts and uploads the previous week's statements from our house bank).

How can we clear the supplier payments from step 3 above without it looking like a duplicate payment out to the bank?

The bank can provide a BAI2 formatted list of the settled payments but when we import it via Manage Incoming Payment Files the system posting rule (currently this bank transaction 999 is assigned to F004) treats these settlements as outgoing payments to the bank which duplicate the actual outgoing payment in step 4 above coming thru in the treasury bank statement. Is there a posting rule which we can use which only clears the payments? Ideally we'd like the credit card payment above in step 4 to be between the bank and a technical account, and then the settlement of the supplier payments to offset the technical and clear the supplier payments.

Alternatively if there is no posting rule which will work the bank can provide a list of these settled payments in a spreadsheet or csv, is there an automated way we can consume this spreadsheet/csv to clear the settled credit card payments? We've used Clear G/L accounts and an open item filter connecting the supplier payments settled to the credit card balance payment as a stop gap but this is unsustainable in anything but the short term.

Isn't there a way to clear many to one other than this manual process?

Thanks for the help,

Ryan

Accepted Solutions (0)

Answers (1)

Answers (1)

I338079
Advisor
Advisor

Hello,

While using the credit card as a payment method for out going payment involves two process,

01.Making payment using credit card and settlement by the bank to the supplier this should treated as normal payment process like using Cheque.

02. Payment of credit card statement due.

To mange the above situation the option can be used .

Treat the credit card as separate bank account , maintain separate a house bank for the credit card account with different GL accounts. maintain separate house bank for original bank account.

The following accounting entry posted for each process

01. While making a supplier payment using credit card.

DT. Vendor Ac

CT. Credit card out going clearing Ac


02. Upon receiving the statement for credit card settlement and performing the EBS for credit card account.

DT. Credit card out going clearing Ac

CT Credit card main bank Ac

03. Payment of credit card Due using bank account

DT. Credit card main bank Ac

CT. Bank out going Ac

04. EBS and bank Reconciliation for bank account

DT Bank out going Ac

CT Main Bank Ac

This is not SAP standard solution. it is a workaround solution , and also it is consulting in nature. SAP is not responsible this solution.

Regards

Gnana