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.
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.
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||Shows the amount assigned to an entry in order to settle it using this entry item. Produces both the
|Expected Amount||Shows the expected amount of a pending (requested but not collected) payment, produces the
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.
Accountfields 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
Issued), JustOn Cash Management blocks the settlement amount, represented as
Expected Amount. The expected amount becomes
- 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.
The association between entries and payments can take place in various ways:
- Automatic settlement using a unique criterion
- Settlement after automatic payment matching by data comparison
- Manual settlement
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.
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.
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 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.
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.