Skip to main content

Bank postings

This page explains the matching and mapping fields that you can use while importing bank postings. This page serves purely as a reference and it assumes that you already have a basic understanding of the import tool.

As soon as you have imported bank postings into your system, the process of assigning the payments to orders is started automatically.

1. Matching fields

Table 1 explains the fields that are available for matching bank posting data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 1. Matching fields for importing bank postings
Setting Explanation

Payment ID

Which column of your CSV file lists the payment IDs? Choose this column here.
If a payment ID already exists, the corresponding data are updated. If there is no payment with this ID in the system, a new payment with this ID is created.
Note that with this, only bank postings are imported. Payments of payment providers, as e.g. PayPal or Klarna, are not imported.

2. Mapping fields

This chapter explains the fields that are available for mapping bank postings. Use these fields to specify which column of your file corresponds to which data field in your system.

Basic procedure:

  1. In your CSV file: Enter a valid import value into a column.

  2. In plentymarkets: Assign this column to the appropriate mapping field.

  3. After the import: Check the result in the back end.

No mapping field? Default value applies!

If you don’t include a certain piece of information in your CSV file, i.e. if you don’t use a certain mapping field, then the data will be given the default value.

2.1. Mapping

2.1.1. Amount posted

Required field

Which posting amount is to be assigned to the payment? Enter this amount into your CSV file.

Default value: No default value

Permitted import values: Numeric

2.1.2. Currency

Which currency is to be assigned to the payment? Enter this currency into your CSV file.

Default value: Euro

Permitted import values: Alphanumeric

2.1.3. Posting date

Which posting date is to be assigned to the payment? Enter this date into your CSV file.

Default value: The day of the import

Permitted import values: Alphanumeric

2.1.4. Contact ID

Which contact is to be assigned to the payment? Enter the ID of this contact into your CSV file.

Default value: No default value

Permitted import values: Numeric

2.1.5. Payment property

Which payment property is to be assigned to the payment? Enter the data of the selected property into your CSV file.

As Value, you can select the following:

  • Designated use

  • Name of sender

  • Email of sender

  • Bank code number of sender

  • Account number of sender

  • IBAN of sender

  • BIC of sender

  • Name of receiver

Default value: No default value

Permitted import values: Numeric

2.1.6. Debit/Credit

Is the bank posting credit or debit? Enter this accordingly into your CSV file.

Default value: No default value

Permitted import values: Alphanumeric

To top