Set thresholds for transaction matching

Administrators can define thresholds to control matching accuracy. Enabling thresholds allows matches to occur even when transactions are not identical but fall within the specified tolerance.

Transaction matching thresholds

When setting up transaction matching, admins can enable custom thresholds to improve accuracy and flexibility. By default, thresholds are disabled.

  • Absolute Thresholds: Define a fixed amount difference allowed between transactions.

     Example:  

    Setting an amount threshold of 0 requires an exact match on both date and amount.

    If set to 10, transactions within $10 will be considered matches.

  • Percentage Thresholds: Define acceptable percentage differences between transaction amounts.

  • Date Thresholds: Allow matches within a specified number of days.

     Example:   A 4-day threshold matches transactions even if dates differ by up to 4 days.

When thresholds are applied, the system provides a clear reason for each match (e.g., “dates within 4 days” or “amounts within 10%”).

Set thresholds

  1. Navigate to the Unreconciled Transactions .

  2. Click .

  3. Select Model Settings.

  4. Toggle the button to enable custom thresholds. By default, thresholds are disabled.

  5. In the Type field, choose Absolute or Percent.

  6. Enter amount (for Absolute) or percentage value (for Percent).

  7. In the Date field, specify the number of days within which the threshold is allowed.

     Example:  

    • Type: Absolute

    • Amount threshold: $5

    • Day threshold: 0 (exact date required)

  8. Click OK

  9. Click and select Run Matching.

    The Result of transaction matching for this example:

    • Transaction A = $100 on Aug 20

    • Transaction B = $103 on Aug 20: Matched (within $5, same date)

    • Transaction C = $108 on Aug 20: Not matched (difference is $8)

    • Transaction D = $100 on Aug 21: Not matched (date mismatch, even though amount fits threshold)

Examples of threshold matching

  • Absolute Threshold (Amount = $10, Days = 0)

    • A transaction with $100 will match with $90 or $110 if the dates are the same.

    • If multiple matches are possible, the system matches the first one.

  • Percentage Threshold (10%)

    • A transaction of $200 can match with another transaction up to $220 (10% higher) or down to $180 (10% lower).

  • Date Threshold (Days = 4, Amount = $10)

    • A transaction dated Aug 20 will match with transactions on Aug 21, Aug 22, or Aug 25 (within 4 days).

    • The system shows the reason: “Dates are within 4 days and amounts are within 10.”