Handling payment reconciliation journal postings

To optimize payment reconciliation, you can configure specific settings that control how journal entries are posted. These settings help simplify reconciliation, ensure accuracy, and provide flexibility in posting options.

This article describes the key posting settings.

Post sum per posting date

Location: Banking Import Setup, Payment Reconciliation FastTab.

• When enabled, this option consolidates bank statement entries into a single bank account entry for the entire statement.
• If the statement includes multiple posting dates, the system creates a sum posting for each date to maintain consistency.
• The system also posts a total amount for the entire statement.

Use Case: Simplifies reconciliation by reducing the number of entries.

Post sum per payment batch

Location: Banking Import Setup, Payment Reconciliation FastTab, or the payment reconciliation posting options dialog.

• When enabled, 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 No.
• Lines that aren't part of a payment batch are posted as usual. A payment batch whose amounts add up to zero is also posted as usual.
• You can't use this option together with Post Sum per Posting Date. Turning one on turns the other off.
• You must enable the feature on the Continia Feature Management page.

Use Case: Posts payment batches from CAMT.054 files on the bank account as the bank booked them. For more information, see Handling payment batches in CAMT.054 files.

Post payments options

Location: Payment Reconciliation Journal page, on the action bar, click Home > Post Payments Only/Post Payments and Reconcile Bank Account/Preview Postings.

Choose from the following options to control how payments are posted:

Use Case: Provides flexibility in managing open entries and reconciliation status.

Journal template and batch name requirement

Location: General Ledger Setup

To enforce the use of a template and batch name for posting, the user must enable the following setting using the standard design page feature:

• Enable: Journal Templ. Name Mandatory

This setting ensures that users must specify both a Journal Template Name and a Batch Name when posting.

Required fields:

• Bank Acc. Recon. Template Name
• Bank Acc. Recon. Batch Name

Use Case: Ensures consistency and traceability in posting processes.

Force document balance

Location: General Journal Templates

• Enabled by default, this setting ensures that the document is balanced before posting.
• If the document is not balanced, an error occurs unless you disable Force Doc. Balance.

Use Case: Prevents posting errors by enforcing balanced entries.

Best practices

• Use Post Sum per Posting Date to simplify reconciliation for large statements.
• Select Post Payments and Reconcile Bank Account to automatically close entries after posting.
• Always verify the Preview Postings before finalizing to ensure accuracy.
• Enable Force Doc. Balance to avoid posting unbalanced documents.