Skip to content

Managing Payment Entries

JustOn allows for tracking collections for invoices. To this end, it can register payment operations that have occurred in external systems as payment entries and match them to invoices. Each payment entry represents a record of a bank statement, that is, a registered payment operation intended to meet an open invoice amount.

Basically, there are two ways to acquire payment entries:

  • via an integration with an external payment provider, like PayPal or Stripe, or
  • importing bank statements from CSV files.


This documentation covers the payment entry import from CSV files.

After importing payment entries, you assign them to invoices. This is a two-step process:

First, JustOn automatically matches payment entries to existing invoices and dunnings. This produces a list of likely matches based on the following main conditions:

  • The invoice has the status Open, or, respectively, the dunning has the status Closed.
  • The invoice number or, respectively, the dunning number is found in the reference field of the payment entry.

If JustOn cannot find a matching invoice number, it compares the contents of the reference field with the account number. For further details, see Matching Logic.

Second, after reviewing the matching proposals, users assign the payment entries to invoices or dunnings. This creates balance records of the type Payment, which are assigned to the corresponding invoices or dunnings. The originally imported payment entries are set to the status Converted.

Overpayments are split along the open invoice amount: one part covers the open invoice amount and is assigned to the invoice, whereas the remainder is assigned to the account. If there are more than one open invoices found for an account, JustOn settles the oldest one first.

For payment entries assigned to dunnings, JustOn distributes the payment amount to the invoices referred to by the dunning. The oldest invoice of the dunning is settled first. In case of an overpayment, JustOn creates an account balance for the remaining amount.


For information about payment entry data, refer to the Payment Entry object reference.

Importing Payment Data

Payment Amount Calculation

When creating the payment entry from imported payment data, the effective payment amount is calculated as follows:

Field Description
Credit For deposits from customers. An empty value equals 0.
Debit For payouts to customers. An empty value equals 0.
Payment Amount Credit - Debit


The invoice amount or credit amount is matched against the calculated payment amount.

Settling a credit of -10 €


CreditDebitPayment Amount


CreditDebitPayment Amount
Settling an invoice of 10 €


CreditDebitPayment Amount


CreditDebitPayment Amount

Starting Payment Data Import


Make sure that the CSV file import is configured according to your CSV file format. For details, see CSV Import Configuration.

  1. Open the Payment Entries tab.
  2. Click Import CSV File. pay_entry_import
    Selecting a CSV file for a payment data import
  3. Select the CSV file to be uploaded, and select the corresponding CSV import configuration.
    Optionally, specify the rows to be skipped during the import.
  4. Click Upload File.
    ▶ This starts the import process. After it is completed, JustOn displays the list of payment entries.

Matching Payment Entries

Matching Logic

Basically, the automatic matching process compares all words (strings separated by spaces) that are contained in the Reference field of the payment entry with specified fields of matching target objects. The custom setting Payment Matching Fields determines which fields of which objects to consider, controlling the matching scope.

The matching process involves multiple passes.

The basic procedure compares the payment entry Reference content with invoice fields. To this end, JustOn ships pre-defined matching settings for the invoice number and the account number:

Name Field Active Source
Invoice Number Name (= Invoice No.) Invoice__c
Account Number Account__r.AccountNumber Invoice__c

Should this pass yield no results, a second one is performed: JustOn searches fields of related objects in order to find the correct invoice, like a customer number from the account.

Note that the order of the matching field definitions is irrelevant to the matching process. In the first pass, all invoice fields are examined, in the second pass all other fields.


For the payment matching to succeed,

  • avoid specifying multiple invoices per payment operation, and
  • prevent line breaks, space characters or semicolons from breaking the invoice number in the reference string.

Importing payment entries as output by accounting systems (rather than bank statements) helps facilitate the payment matching in JustOn.

In most cases, no customization is needed. Depending on your data or business requirements, you may need, however, to modify the matching logic. In this case, make sure that you use only fields that are set to be unique, that is, whose value can only exist once in your org. Otherwise you may produce poor results or break the matching logic.


For details about customizing the matching logic, see Payment Matching Fields.

Executing Matching Procedure


Make sure that the matching fields are configured according to your payment data and target object. For details, see Payment Matching Fields.

To execute the automatic matching process:

  1. Open the Payment Entries tab.
  2. From the list view picklist, select New.
  3. Select the checkboxes next to the payment entries you want to match to target objects.
    Not explicitly selecting payment entries includes all listed payment entries.
  4. Click Match.
  5. Select the checkboxes next to the targets to which you want to match the selected payment entries.
  6. Click Continue.
    ▶ This executes the automatic matching process.

To finally assign matched payment entries to target objects:

  1. In the Payment Entries tab, select Matched from the list view picklist.
  2. Review the matches.
  3. Select the checkboxes next to the payment entries you want to assign to target objects.
    Not explicitly selecting payment entries includes all listed payment entries.
  4. Click Assign.
  5. Select the checkboxes next to the targets to which you want to assign the selected payment entries.
  6. Click Continue.
    ▶ This creates balance records of the type Payment, assigned to the corresponding target objects, and sets the selected payment entries to the status Converted.