Previous

Vendor and employee reconciliation rules

  • 4 min.

Vendor and employee reconciliation rules are set up the exact same way as the customer reconciliation rules.

With Statement Intelligence, Payment Management automatically tries to match payments by using the payment's transaction ID which is created for all payments processed from the Payment Management payment journal. If a payment has not been processed from the payment journal, the transaction ID can't be used for matching the bank statement lines, in which case other parameters, such as date and amount, will be used.

If a unique match can't be found, you can set up vendor/employee reconciliation rules. You can specify a search text that is unique for a specific vendor/employee, and when the search text is found, Statement Intelligence translates that into a vendor/employee number, and inserts it on the statement line. You will then be able to select and apply the matching vendor/employee ledger entries.

Set up vendor reconciliation rules

  1. From the Bank Account Reconciliation page, select Rules, and Vendor Reconciliation Rules or Employee Reconciliation Rules.
  2. To create a new reconciliation rule, navigate to the action bar, and select New.
  3. Fill in the fields according to the descriptions in the table below.
ColumnDescriptionExample
Account No.Specify the vendor/employee number that should be applied to the payment line when a payment line meets the search rule.10000
Search textSpecify the text to search for when the reconciliation rule is used on the bank account reconciliation lines in order to identify a match.Could be anything
Search PrincipleSpecify how the search should be carried out when searching for the specified search text.Exact indicates that the search text must be the exact same as the description or notification on the payment, for the rule to be met.
From left indicates that the search text must match the first part of the description or notification on the payment, for the rule to be met.
From right indicates that the search text must match the last part of the description or notification on the payment for the rule to be met.
Within indicates that the search text must just appear some place in the description or notification on the payment, for the rule to be met.
Search in DescriptionEnable this setting if you want the search rule to search for the search text in the description field of the payment line.Enabled
Search in Additional InformationEnable this setting if you want the search rule to search for the search text in the payment line notification.Enabled

When you have finished setting up reconciliation rules you can close the page.