Matching bank account ledger entries by posting date and amount

Date and amount matching is a reconciliation mechanism that matches imported bank statement lines with bank account ledger entries based on an exact match of posting date and amount.

Enabling this feature means that it will also create payment application proposals using the combination of posting date and amount. For a match, the posting date matches the transaction date (with or without a tolerance depending on your settings) from the bank statement and the amount matches exactly.

To set matching by posting date and amount on the Banking Import Setup page

You can enable date and amount matching globally for all bank accounts by configuring the Bank Ledger Entries field and the Date and Amount field on the Banking Import Setup page. When enabled here, date and amount matching becomes the default behavior for all bank accounts unless overridden on the individual bank account card. If this setting is disabled, date and amount matching is not applied unless explicitly enabled on a bank account.

To set matching by posting date and amount on the bank account card

You can override the global setup for individual bank accounts by configuring the Date and Amount Matching field on the bank account card. Additionally, on the bank account card you can determine how entries with the same posting date and amount are handled.

Some companies have recurring payments or subscription scenarios that generate one or more bank account ledger entries with the same posting date and amount. To ensure these entries are applied consistently during reconciliation, you can define how Continia Banking should apply the oldest or manually selected ledger entry when multiple matches are found.

By setting reconciliation methods on the bank account, you control whether Continia Banking automatically applies the oldest entry or whether you select the appropriate entry manually.

To set the reconciliation method for a bank account:

  1. Search (Search) for and select Bank Accounts.
  2. Open the bank account card where you want to configure reconciliation behavior.
  3. Navigate to the Payment Import FastTab and, on the Payment Import FastTab, check the value set for the Date and Amount Matching field:
    • If the field is set to Yes, date and amount matching is enabled for this bank account, regardless of the global setting.
    • If the field is set to Blank, date and amount matching follows the global setting on the Banking Import Setup page. For this Reconciliation Method Debit and Reconciliation Method Credit settings to take effect, the Date and Amount field must be enabled on the Banking Import Setup.
    • If the field is set to No, date and amount matching is disabled for this bank account.
  4. Find the Reconciliation Method Debit and Reconciliation Method Credit fields. For each field, choose how ledger entries should be applied when multiple entries have the same posting date and amount. The options are:
    • Select Apply to Oldest to automatically apply the ledger entry with the earliest posting date.
    • Select Manual to manually select the correct ledger entry during reconciliation.
  5. Use the Tolerance Days - Before and Tolerance Days - After fields to allow matching of entries within a specified number of days before or after the posting date.

Note

When date and amount matching is disabled, either because the Date and Amount Matching field is set to No, or because the field is Blank while the global setting on Banking Import Setup is also disabled, Continia Banking automatically clears the Reconciliation Method Debit and Reconciliation Method Credit fields.

If the reconciliation method is set to Apply to Oldest and more than one bank account ledger entry is found with the same posting date and amount, Continia Banking automatically applies the oldest ledger entry. If the method is set to Manual, you choose which ledger entry to apply during reconciliation.