Assigning Payments to Entries

Payment settlement, that is, the association between entries and payments, can take place in various ways:

• Automatic settlement using a unique criterion and through data comparison when retrieving bank data
• Automatic settlement on bank statement items
• Manual individual 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.

Retrieving Bank Data

Note

Make sure that the button Retrieve is available on the Bank Statement list view, see Enabling Bank Statement Download.

You can retrieve banking transactions from the bank accounts subject to a specific EBICS bank account credential in the status Active for a specific period.

1. Open the Bank Statements tab.
2. Click Retrieve.

3. Select the relevant EBICS bank account credential and define the period for which you want to retrieve the transactions.

   JustOn Cash Management can retrieve banking data up to the day before the current date.

   
   Configuring bank statement retrieval

4. Click Next.

   This retrieves the banking transactions for the bank accounts subject to the selected EBICS bank account credential and the specified period from the bank. As part of the data retrieval, JustOn Cash Management automatically associates existing payment records (as related to entries) with matching bank statement items according to an end-to-end ID and retrieved bank statement items (and corresponding new payment records) with matching entries through data comparison.

   
   Bank statement retrieval confirmation

   Clicking Finish returns you to the downloaded bank statements on the Bank Statements tab.

Info

As part of the data retrieval, JustOn Cash Management automatically associates

• existing payment records (as related to entries) with matching bank statement items (from the original bank account and according to the end-to-end ID), or
• retrieved bank statement items (and corresponding new payment records) with matching entries through data comparison based on active matching configurations.

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 not found any matching data. A user must review the matching configurations and repeat the automatic settlement, or proceed to manually settle the payment.
Unmatched, multiple results	JustOn Cash Management has found multiple possible matches for different accounts or business entities. A user must review the matching configurations and repeat the automatic settlement, or proceed to manually settle the payment.

With the matching results Unmatched or Unmatched, multiple results, the processing log (as saved in the Payment field Matching Records) may indicate troubleshooting information.

• The message No matching results found indicates that none of the available matching configurations can extract data to be processed from the available bank statement items. That is, the (regular expression-based) input string filter provided as parser configuration does not retrieve data for the intended comparison from the Reference field of the bank statement item. In this case, review the input string filter as part of the matching configuration. You can use tools like, for example, regex101 to define and test your regular expressions.
• An applied matching configuration may return "number-of-results" : 0 for an entry match or account match. This indicates that the input string filter has extracted usable data from the bank statement item, but the data comparison with entries or accounts does not produce a result. In this case, review the processing log in the Payment field Matching Records. The recorded comparison data may indicate why the comparison has not found matching entries or accounts. If you are not able to find and correct the error, do not hesitate to contact JustOn Support.

Starting Automatic Settlement on Bank Statement Items

Some use cases may require to trigger the automatic settlement manually – for example, if your business imports banking data via CSV files, creating bank statements and bank statement items without bank integration.

As part of the settlement process, JustOn Cash Management associates

• bank statement items with matching payment records (as related to entries) according to an end-to-end ID, or
• bank statement items (and corresponding new payment records) with matching entries through data comparison based on active matching configurations.

Automatic settlement is possible for bank statement items that either do not have related payments or whose related payments are not associated with entries (via entry items).

Note

Make sure that

• the button Settle Automatically is available on the Bank Statement Item list view, see Enabling Settlement From Bank Statement Items
• there are active matching configurations, see Configuring Payment Matching

To trigger the automatic settlement process:

1. Open the Bank Statement Items tab.

2. Filter the list view or select the bank statement items to be processed.

   Continuing without selection includes all listed bank statement items.

3. Click Settle Automatically.

   This displays the number of bank statement items to be processed.

   

4. Click Next.

   This starts the automatic settlement process. The page shows the job progress and log messages.

   

   Clicking Finish returns you to the Bank Statement Items tab.

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 not found any matching data. A user must review the matching configurations and repeat the automatic settlement, or proceed to manually settle the payment.
Unmatched, multiple results	JustOn Cash Management has found multiple possible matches for different accounts or business entities. A user must review the matching configurations and repeat the automatic settlement, or proceed to manually settle the payment.

With the matching results Unmatched or Unmatched, multiple results, the processing log (as saved in the Payment field Matching Records) may indicate troubleshooting information.

• The message No matching results found indicates that none of the available matching configurations can extract data to be processed from the available bank statement items. That is, the (regular expression-based) input string filter provided as parser configuration does not retrieve data for the intended comparison from the Reference field of the bank statement item. In this case, review the input string filter as part of the matching configuration. You can use tools like, for example, regex101 to define and test your regular expressions.
• An applied matching configuration may return "number-of-results" : 0 for an entry match or account match. This indicates that the input string filter has extracted usable data from the bank statement item, but the data comparison with entries or accounts does not produce a result. In this case, review the processing log in the Payment field Matching Records. The recorded comparison data may indicate why the comparison has not found matching entries or accounts. If you are not able to find and correct the error, do not hesitate to contact JustOn Support.

Manually Settling Individual Entries

The manual settlement process allows users to

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

Info

Payments must be in the status Collected, Final or Reversed for them to be associated to entries.

Payments that have already been processed by the automatic settlement with payment matching but not assigned to entries are set to the matching result Unmatched.

Bank statement items must have the status code BOOK to be eligible for a settlement operation. If the bank statement item is not linked to a payment, JustOn Cash Management creates a corresponding payment record upon settlement.

1. Open the relevant payment or bank statement item.

2. Click Settle Manually.

   This launches a screen flow that allows for successively modifying the settlement-relevant values for Account, Entry and Settlement Amount. Be aware that the corresponding input fields have a hierarchical relationship:

   • Modifying Account clears Entry and Settlement Amount.
   • Modifying Entry clears Settlement Amount.

   Account and Entry are mandatory, Settlement Amount is optional.

3. Optionally, select or modify the account, then click Next.

   

   Use this option to re-assign a payment to a different account.

4. Search for and select the target entry, then click Next.

   

   The Entry list shows only entries in the status Open. In addition, the available entries depend on the selected account.

5. Optionally, specify the settlement amount, then click Next.

   

   This may be required when distributing one payment to multiple entries.

   Clicking Next executes the settlement operation, associating the current payment with the selected entry via an entry item.

   

   Clicking Finish completes the screen flow and returns you to the detail view of the original payment or bank statement item.