Working in the payment reconciliation journal

  • 12/11/2025
  • 6 minutes to read

The Payment Reconciliation Journal in Business Central, enhanced by Continia Banking, simplifies matching and applying payments to ledger entries.

When importing bank transactions, Continia Banking will be able to automatically reconcile most of the lines. If a transaction cannot be matched or some information is missing, you can manually review and apply the payment in the journal.

To handle proposals from automatic matching

When Continia Banking suggests matches for imported transactions, you can review and apply these proposals in the Payment Reconciliation Journal.

To handle proposals from automatic matching:

  1. Populate the journal by importing a bank statement using direct or manual import. Continia Banking automatically applies its advanced matching rules to suggest how these transactions should be applied.
  2. On the Payment Reconciliation Journal page, select a line and on the action bar, click Manual Application > Apply Entries.
  3. When a match is found for an open ledger entry and the amounts align (considering currency exchange rates, discounts, and tolerances), the payment application proposal is automatically matched, and the status is set to Completed. You can then move on to the next lines or post the journal. For example, the system proposes a match if:
    • Transaction text and amount match - the system will auto apply the proposals. The line is ready for posting.
    • External document number match found - the system automatically applies the proposal and status on the line is set to Completed.
    • End-to-End ID match found - payments sent with a unique end-to-end ID are matched directly to the corresponding entries, facilitating a seamless match and readying them for posting.
  4. After reviewing all matches, use Post Payments Only to close the ledger entries without reconciling them to the bank account ledger.
  5. Reconcile the corresponding bank entries by going to the Bank Account reconciliation page and selecting Post and Reconcile.

For more details on how to handle posting in the Payment Reconciliation Journal, refer to the Handling payment reconciliation journal postings article.

To apply matching rules manually

If a transaction doesn’t automatically match, you can manually edit the fields or add a search rule.

To apply matching rules manually:

  1. If a transaction doesn’t automatically match, you can do the following:
    • Use search rules - you can add a search rule and apply it manually. This involves identifying related parties or other matching criteria not automatically processed. For example, use specific rules to find related customer or vendor records when automatic matching doesn't apply, ensuring that the correct entries are matched. For more information on search rules, refer to the Introducing Search Rules and Setting up Search Rules articles.
    • Adjust and apply amounts - for entries where amounts do not match exactly, you can manually adjust the amount to fit or split transactions across multiple lines as needed. For example,
      • If a payment covers multiple invoices, you can split the payment across these lines and apply the amounts accordingly
      • If a transaction in your bank account is not in the bank statement, you can create the missing transaction and reimport the bank statement file or enter the transaction manually.
      • If a transaction in the internal bank account corresponds to a bank transaction but the information is too different to give a match, you can review the information and then match the two manually.
  2. Once all matching and adjustments are complete, you can post the applied lines. This closes the ledger entries. On the action bar, use the Post Payments Only feature to close the ledger entries without reconciling them to the bank account ledger. Afterwards, you can go into the Bank Account reconciliation and then reconcile the bank ledger entries that were created in the payment reconciliation journal. Select Post and reconcile to reconcile the bank account and you're done.

To review posting groups before posting

With Continia Banking, you can review and update posting group fields (Gen. Posting Type, Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group) directly on the Payment Reconciliation Journal page.

To review posting groups before posting:

  1. On the Payment Reconciliation Journal page, select Page > Show More Columns to display posting group fields.
  2. Review pre-filled values from G/L Account or rule defaults.
  3. Update any fields as needed before posting.
  4. Post the journal. The system uses the updated values instead of defaults for posting.