Confirm Transactions in the Payment Provider Ledger

This document is a guide on how to confirm transactions in the payment provider ledger.

Introduction

  • A confirmation of an external reference is performed when the payment provider has specified commission and VAT amount for several payment transactions.
  • A bank transfer for the remaining amount has been issued, along with a reconciliation reference.
  • New account entries are created in the payment provider ledger by running the API OPS291MI (Payment provider ledger entries) for each such transaction confirmed by the payment provider.

Workflow

The API is run for an external reference that has status 20-'External reference received' in 'Payment Provider Ledger. Display' (OPS290).

The original payment amount that was accounted on a suspense account is offset in full in the form of a new account entry.

New account entries for commission amounts and VAT are created.

The remainder after subtracting commission and VAT is accounted on a reconciliation account, a reconciliation reference is entered to be used for internal reconciliation. This is the same reference that the payment provider includes when issuing the bank transfer.

In detail, the API creates these account entries in 'Payment Provider Ledger. Display Entries' (OPS291):
Information type Description

11-'Offset payment amount'

This represents an offset of the payment amount from the POS voucher. The accounting string is copied from information type 01.

21-'Payment confirmed, not received'

This represents the amount of the payment to be put on a suspense account for payments that are confirmed but not yet received. This constitutes the entirety of the payment excluding commission amounts and VAT. Accounting dimensions 1-7 are populated according to accounting rule OP60-102. The rule should be set up to account the amount on a reconciliation account.

31-'Commission'

An entry with this information type is created if a commission amount is entered. This represents the commission amount taken by the payment provider. Accounting dimensions 1-7 are populated according to accounting rule OP60-182.

41-'VAT receivable'

An entry with this information type is created if a VAT amount is entered. This represents the VAT amount that is taken by the payment provider. Accounting dimensions 1-7 are populated according to accounting rule OP60-211.
Note: This requires VAT details to be fully specified in 'Credit Card Interface Settings. Open' (CRS434) for the third-party ID.

Entries are created in status 20-'Account entry created'. The external reference in (OPS290) is updated to status 40-'Account entries created'.