Settlement Concepts

payment_app_intro JustOn Cash Management is a Salesforce app that integrates Salesforce CRM with European banks and payment service providers. The app allows you to trigger payments and track payment information related to your business with customers.

You will be able to prepare and execute payment operations based on your orders, invoices or other statements that involve payments or payouts, as well as to retrieve information on processed payments and to associate it with the corresponding accounts receivable or accounts payable. Broadly speaking, JustOn Cash Management helps reconcile accounts.

Understanding Settlement

Businesses sell and purchase products and services. These operations involve payments or payouts. To settle (or reconcile) accounts, you need to retrieve information on processed payments and to associate it with the corresponding accounts receivable or accounts payable.

pay_app_settle

Settlement in JustOn Cash Management

The settlement implementation allows users (or the software) to assign registered payments to open entries. In this sense, it constitutes the reconciliation means.

Implementation Details

To settle accounts, JustOn Cash Management relates entries with payments using entry items.

Entry Item Concepts

As a result of a settlement operation, entry items associate entries with payments in an n:m relationship. This allows, for example, to distribute one money transfer to multiple entries or to settle one entry with multiple money transfers.

This means: the amount of an entry and the amount of a payment do not necessarily need to be the same. The settlement implementation allows to

  • Associate one entry with multiple payments
  • Associate multiple entries with one payment
  • Associate partial payment amounts with an entry

Entry items "live" and can be modified – through user interaction, like manual assignments, or automatic processes, like settlement by end-to-end ID or payment processing via payment providers. That is, entry items are subject to change, may become 0, but will never be deleted.

Entry Item Amount Values

The entry item holds the actual amount used for the settlement operation. In addition, an entry item can block a certain amount during an ongoing payment transaction, represented as Expected Amount – which is 0 after the collection has completed.

With respect to the settlement progress, the following amount values on entry items are relevant:

pay_app_entryitem_amounts

Amount Type Description
Amount Shows the amount assigned to an entry in order to settle it using this entry item. Produces both the Settled Amount on the related entry and the Assigned Amount of the related payment. Negative values are payments, positive values are payouts (see Payment Types).
Expected Amount Shows the expected amount of a pending (requested but not collected) payment, produces the Expected Amount on the related entry. Negative values are payments, positive values are payouts.

Entry and Payment Lifecycle gives an outline view of how these values change as payment and settlement progress.

General Settlement Logic

The settlement operation applies the following logic, irrespective of the settlement approach:

  • The actual settlement amount usually defaults to the available amount of the relevant payment record.
  • To prevent overpayments, the settlement amount (as a result of a reassignment or optionally set by a user, see Manually Settling Individual Entries) will never exceed the open amount of the entry. Any remaining amount remains on the payment – available to be assigned to another entry.
  • In case of n:m settlements, a newer entry/payment pair takes precedence, which would, if necessary, modify the settlement amount of a previous entry/payment pair.
  • If the Account fields of an entry and a payment differ, JustOn Cash Management considers this as a debtor change.

    With the settlement operation, the amount of existing entry items associated to entries of different accounts becomes 0. Once completed, the account of the payment is set to the account of the entry.

  • The payment date of an entry item is set to the payment date of the associated payment.

  • The payment date of an entry is updated each time a settlement operation takes place, where

    • the payment date of the entry is set to the payment date of the newest entry item with a non-zero amount if the sum of all entry items settles the open amount of the entry,
    • the payment date of the entry is cleared if the sum of all entry items falls below the open amount of the entry.
  • With ongoing payment transactions (payments in the statuses Open or Issued), JustOn Cash Management blocks the settlement amount, represented as Expected Amount. The expected amount becomes 0

    • after the collection has completed so that the settlement can take place, or
    • if the collection has failed permanently, which frees the money from the entry for another collection attempt.

Settlement Approaches

The association between entries and payments can take place in various ways:

Automatic Settlement Using a Unique Criterion

When initiating payment transactions via a payment provider integration or a connected bank account, there is, usually, a unique ID – a payment provider ID or, with direct debits or credits produced from JustOn Cash Management, an end-to-end ID. Using the unique ID, JustOn Cash Management can complete the settlement – relating the executed money transfer with the original receivable/payable. Generally, this is the safest – and therefore, preferred – way to settle entries with payments.

pay_app_ebics_match

Settlement After Payment Matching

Your business may allow bank transfer as a payment method, enabling customers to execute payments at their discretion. In this case, there is no unique ID. On bank statement retrieval or when triggered manually, JustOn Cash Management therefore proceeds to execute a payment matching operation: it compares bank statement items (and payments created from them) with accounts and entries, looking for matching data like the customer number or statement number – as passed with the reference text – or the amount.

pay_app_auto_match

JustOn Cash Management's account matching mechanism includes comparison by IBAN (taken from the Debtor IBAN or Creditor IBAN fields), by account number (retrieved from the Reference field) and by account name or contact name (taken from the Debtor Name or Creditor Name fields).

The entry matching mechanism includes comparison by statement number (retrieved from the Reference field), by amount or by date correlation (where the entry's Statement Date must be before the bank statement item's Booking Date or Value Date). Since entries are always related to accounts, the entry matching mechanism will always produce an account match.

During the matching process, JustOn Cash Management filters bank statement items for the status BOOK and checks for matching payment records – consequently, it will either change an existing payment (like in case of a chargeback or refund) or create a new one.

After successful matching, JustOn Cash Management completes the settlement, relating the bank statement items and the produced payments with an account and, depending on the given data, with an entry.

Should the automatic matching yield no immediate results, JustOn Cash Management marks the processed payments as Unmatched. In this case, users are to review matching configurations and repeat the automatic settlement, or associate the payments to entries manually.

The data comparison is configurable, see Configuring Payment Matching.

Settlement or payment matching?

Make sure not to confuse settlement with payment matching.

Settlement
Settlement is the mechanism for effectively associating payments with entries using entry items.
Payment matching
Payment matching is the operation that compares bank statement items or payments with entries using customizable matching configurations. After successful matching, JustOn Cash Management can complete the actual settlement.

Manual Settlement

Users can manually select a payment and associate it with an entry. The manual settlement process allows users to

  • Create payments from bank statement items,
  • Associate unassigned payments to entries, or
  • Re-associate payments to different entries.

pay_app_manual_match

For details, see Manually Settling Entries.