Reconciling CAMT.054 entries from CAMT.053
When a bank delivers transaction details in a CAMT.054 file and the related statement in a CAMT.053 file, Continia Banking can match the two automatically. The shared MsgId links each batch transaction in the CAMT.053 to its details in the CAMT.054, so the bank account ledger entries posted from the CAMT.054 can be reconciled when the CAMT.053 is processed.
Note
You can enable Match CAMT.053 based on CAMT.054 reference from the Continia Feature Management page. For Swiss localizations, default CAMT Reference templates are assigned during activation.
This procedure describes how to set up the matching, process the CAMT.054, and then process the CAMT.053 to close the bank account ledger entries.
Before you start, note that:
- The CAMT.054 file must be processed before the CAMT.053 file.
- The bank format must provide a reference identifier. Currently, only MsgId is supported.
To enable CAMT reference matching
- Search (
) for and select Banking Import Setup. - Turn on the CAMT Reference toggle.
- In the CAMT Reference Template field, select the field on the Bank Transaction Header or Bank Transaction Line that supplies the self-reference from the CAMT.054.
- In the Related CAMT Reference Template field, select the field on the Bank Transaction Header or Bank Transaction Line that supplies the reference to the CAMT.054.
Note
Default templates for CAMT Reference Template and Related CAMT Reference Template are created during setup. In most cases, you do not need to change them.
To process the CAMT.054 file
- Search (
) for and select Payment Reconciliation Journal. - Import the CAMT.054 file. The reference is stored in the CAMT Reference field on each bank account reconciliation line.
- On the action bar, click Post > Post Payments Only.
Warning
Do not select Post Payments and Reconcile when posting the CAMT.054. The bank account ledger entries must remain open until the CAMT.053 file is posted. A warning prevents you from selecting this option.
To process the CAMT.053 file
- Search (
) for and select Payment Reconciliation Journal or Bank Account Reconciliation. - Import the CAMT.053 file. For lines that represent a CAMT.054 file, the reference is stored in the Related CAMT Reference field on the bank account reconciliation line.
- The matching routine compares all lines that contain a Related CAMT Reference with the bank account ledger entries created from the CAMT.054 that share the same value in the CAMT Reference field. If a match is found, a payment application proposal is created with Found By set to CAMT Reference.
- On the action bar, click Post to close the matched bank account ledger entries.
Warning
If you process the CAMT.053 file in the Payment Reconciliation Journal, do not select Post Payments Only. A warning prevents you from selecting this option.