1 Areas of application

Batch payment assignment is used when a single transfer is to be assigned to multiple documents and/or orders.

Within a transaction, invoices, credit notes and orders can be added as batch items.
Once batch items have been created, the regular assignment starts automatically.

2 Assignment options

There are two ways to assign items to a batch payment:

• CSV import
• Manual entry

A batch payment assignment can only be completed if the entire transaction amount is balanced by the assigned items.

In the batch payment modal, you can see at any time:

• the transaction amount
• the total of the items already assigned
• the outstanding amount required to complete the transaction

Only when both totals (transaction amount and total batch items) match can the assignment be completed and the automatic assignment started.

2.1 CSV import

The following table can be used as a template for the CSV import, which can be filled in Excel and converted to CSV format.

The CSV file must meet the following requirements:

• Structure of the first column
  • 1 = Header (column titles)
  • 2 = Content (all cells to be read as batch items)
  • 3 = Footer (e.g. address or account details)
• Mandatory columns and rules
  • Reference No.: no restrictions (corresponds to the intended use)
  • Amount: must not contain any letters
  • Currency: three-digit ISO 4217 currency code, corresponding to the transaction currency
  • Debit/Credit: only the values + or – are permitted

After uploading, you can drag and drop the columns from the preview to assign them to the areas. Then click on ‘Convert CSV to batch items’ to generate the batch items.

2.2 Manual entry

When adding manually, documents or orders can be searched for specifically. Enter the complete document or order number in the search field and select the desired result by clicking on it to add it as a batch item.

Items can be removed again using the icon in the Actions column.

The value in the Debit/Credit column is automatically pre-filled, but can be adjusted manually.
(The default value is based on the transaction indicator for the respective item.)

3 Correcting batch items

Batch items can only be corrected if they have been added manually. Items that have been added via CSV upload cannot be corrected.

How to proceed:

• Open the edit icon (pencil) in the Batch Items area within the transaction
• Add items as described in 2.2 Manual Addition or remove existing ones