Introducing the Payment Reconciliation Journal
The Payment Reconciliation Journal is designed to efficiently match payments with all types of ledger entries, including customer, vendor, employee, and bank account entries. Unlike the Bank Account Reconciliation, which moves multiple entries into separate journals for posting, the Payment Reconciliation Journal reconciles ledger entries directly within the journal. This means you can apply payments and perform reconciliation at the same time, or choose to complete reconciliation later when the journal is posted.
Continia Banking enhancements to the Payment Reconciliation Journal
Continia Banking offers the following enhancements to the standard Payment Reconciliation Journal:
- Import - import and match bank statement transactions and CSV files manually or automatically.
- Automatic matching - matches bank statement transactions with open ledger entries using configurable rules. For more information about the matching procedure, see Introducing reconciliation with Continia Banking.
- Apply proposals - automatically suggest matches for payments and ledger entries.
- Search rules - implement criteria to improve matching accuracy. For more information on search rules, see the Introducing search rules article.
- FactBox - access an extended FactBox that provides detailed matching information, aiding in accurate reconciliation.
- Posting groups - posting group fields (General Posting Type, Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group) are available on the Payment Reconciliation Journal page. They’re pre-filled from the G/L Account or source rule defaults, but you can change them as needed.
- Show more columns/actions - customize the page by showing additional data columns or actions via the Page tab.
- Post Multiple Applications as one sum Entry - this setting on the Banking Import Setup page allows you to handle multiple applications for the same account as one summarized entry during payment reconciliations when posted. See Posting multiple applications as one sum entry.
- Transaction Type - view the type of bank data imported into each journal on the Payment Reconciliation Journals page. The Transaction Type field indicates whether the journal contains account statements (for example, CAMT.053 files or CSV bank statements) or payments (for example, CAMT.054 files or CSV transactions), eliminating the need to open the Bank Transaction Header to verify the imported data. To maintain data consistency, a journal can contain only one transaction type. If a journal already contains imported account statements, payments can't be imported into that journal. Likewise, if a journal already contains payments, account statements can't be imported.
When you configure a bank account in the Payment Reconciliation Journal using Continia Banking, these enhancements become available.
The actions available on the Payment Reconciliation Journal
The Payment Reconciliation Journal page offers a range of actions designed to simplify matching payments with corresponding ledger entries.