Settlement Concepts

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.

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:

Amount Type	Description
Assigned 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.
Effective Amount	The sum of Assigned Amount and Expected Amount. Required for calculating payment amount values.

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.

Matching and settlement results

Settlement operations can produce various results – as kept in the field Matching Result on payments and bank statement items. According to the outcome, users may need to take additional action.

Matching Result	Description
Account matched	JustOn Cash Management has found a matching account, but has not completed the settlement. A user must proceed to manually settle the payment.
Entry matched	JustOn Cash Management has found a matching entry, but has not completed the settlement. A user must proceed to manually settle the payment.
Manually settled	A user has settled the payment manually.
Payment Id matched	JustOn Cash Management has found a matching payment based on a unique ID but the current transaction involves an amount with a reversed sign. Usually, this indicates a chargeback.
Settled by Payment Id	JustOn Cash Management has completed the settlement based on a matching unique ID.
Settled by automatic match	JustOn Cash Management has completed the settlement through data comparison based on active matching configurations.
Unmatched	JustOn Cash Management has either not found any matching data or found multiple possible matches. A user must review the matching configurations and repeat the automatic settlement, or proceed to manually settle the payment.

Settlement Approaches

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

• Automatic settlement using a unique criterion for system-initialized payment operations
• Automatic settlement using data comparison for payer-initialized payment operations
• Manual settlement

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.

Automatic Settlement Using a Unique Criterion

For system-initialized payment operations, that is, 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.

Automatic Settlement Using Data Comparison

Your business may allow bank transfer as a payment method, enabling customers (payers) 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.

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.

The data comparison is configurable, see Configuring Payment Matching.

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.

For details, see Manually Settling Entries.

Settlement Process Overview

Depending on which party has triggered the payment operation – the merchant using JustOn Cash Management features (system-initialized payment operations) or the customer (payer-initialized payment operations) –, the settlement will take place in two different ways.

System-Initialized Payment Operation

In a rough outline, the automatic settlement process for a system-initialized payment operation using a unique criterion takes place as follows:

Payment initializationExternal data retrievalSettlement

When initializing the payment transaction for an open entry via a connected bank account (using SEPA direct debit) or a payment provider (using the payment page), JustOn Cash Management creates an open payment record (Issued or Pending) – specifying a unique ID and related to the entry.

JustOn Cash Management gets information from the bank or payment provider about the executed payment transaction, creating a corresponding bank statement item or payment notification. Using the unique ID, JustOn Cash Management can relate the incoming information with the pending payment record.

Associating the matching bank statement item or payment notification, JustOn Cash Management completes the settlement. It sets the payment record to Collected and, consequently, the related entry to Balanced.

Payer-Initialized Payment Operation

For a payer-initialized payment operation – which requires a data comparison –, the settlement process looks different:

External data retrievalPayment matchingSettlement

With payment transaction executed on the payer's discretion, like a bank transfer, JustOn Cash Management retrieves information about a collected payment without immediate matching criterion.

JustOn Cash Management proceeds to execute a payment matching operation: it compares the bank statement item with open entries (or accounts), looking for matching data like customer number, statement number or amount.

Once successfully matched, JustOn Cash Management relates the payment (as produced from the bank statement item) with the corresponding entry. It sets the related entry to Balanced, completing the settlement.