Handling payment batches in CAMT.054 files

A payment batch is several payments that the bank booked as one amount on the bank statement. A CAMT.054 file can contain one or more payment batches. Continia Banking imports all transactions in a payment batch individually. To handle the transactions as payment batches during reconciliation and posting, you can post each payment batch as a sum in the Payment Reconciliation Journal, or merge the lines of each payment batch in the Bank Acc. Reconciliation.

Payment batch information on imported lines

During import, Continia Banking fills the Payment Batch ID field on each line, so lines in the same payment batch get the same number. Continia Banking adds the batch number during the conversion to all transactions in the payment batch. It doesn't come directly from the ISO file.

If the bank statement contains payment batches, the Bank Transaction Lines page shows the Payment Batch Transaction ID.

The Payment Batch ID field is available on the Bank Acc. Reconciliation lines and in the Payment Reconciliation Journal. To see this column, on the action bar, click Page > Show More Columns.

To post payment batches as sums in the Payment Reconciliation Journal

When you turn on Post Sum per Payment Batch, posting the journal creates one bank account entry per payment batch and posting date instead of one per line. Lines belong to the same payment batch when they have the same Bank Transaction No. and Payment Batch ID.

The following applies:

• Lines that aren't part of a payment batch are posted as usual.
• A payment batch whose amounts add up to zero is posted as usual.
• All entries get the same document number.
• The bank account entry uses the dimensions of the first line of the payment batch.
• Rounding differences can occur when posting in foreign currencies.

To post payment batches as sums:

1. Search () for and select Banking Import Setup.
2. On the Payment Reconciliation FastTab, turn on Post Sum per Payment Batch. Alternatively, turn on the option in the payment reconciliation posting options dialog.
3. In the Payment Reconciliation Journal, preview the posting to see how the payment batches are posted. The journal itself doesn't show the sums, because they're created during posting.
4. Post the journal with the Post Payments action. The posting on the bank account follows the payment batches in the file.

To merge payment batches in the Bank Account Reconciliation

In the Bank Account Reconciliation, there's no posting option for payment batches. Instead, you merge the lines of a payment batch into one line by applying a merge rule that uses the Payment Batch ID field. You must merge the lines manually.

To create the merge rule:

1. Search () for and select Merge Rules.
2. Click New.
3. On the General FastTab, enter a code and a description for the merge rule.
4. On the Merging FastTab, in the Merge by field, select Table Field.
5. In the Merge by Table field, select Bank Acc. Reconciliation Line.
6. In the Merge by Field field, select Payment Batch ID.

To merge the lines of a payment batch:

1. On the Bank Acc. Reconciliation page, select the statement lines.
2. On the action bar, click Rules > Apply Merge Rule.
3. In the Apply Merge Rule dialog box, select the merge rule, and then click OK.

Continia Banking merges the lines based on the Payment Batch ID field.

Related information

Setting up merge rules
Merging bank statement lines manually
Handling payment reconciliation postings
Reconciling CAMT.054 entries from CAMT.053