Recon Templates

Select Administration>Recon Templates

Recon Templates contain all the logic for a particular account. Templates allow you to maintain the labels, datasets, mappings, and rules for many similar accounts in one place.

You can add, edit and copy a template.

Labels

• • Labels apply to all Recons assigned to the template

  • Add one Label per line

  • Users have a text field 'Label' on each Recon. When they click in the label box a drop down of configured labels will used for them to choose from. They can also capture their own value. This value will not be saved to the master list

Datasets and Field Mappings

• • Click 'Add dataset' to add additional datasets. You can add as many as you like.

  • Select the dataset type from the dropdown and give it a name so you can identify it

  • Use the account filter to specify which account in the dataset to include in the recon.

  • Use the Transaction Filter to specify which Transaction Types (if applicable) to include in the Recon

  • Any number of columns can be added to a template and can be named as required. Description and Reference are included by default and will map to the Description and Reference columns from the Source file if available

  • Select what columns from the Source File to map to the available fields in the application. There is no limit to the number of columns which can be mapped to a single field. Use the following Syntax; Description:Column1 + Column2, Reference: Column3, AdditionalColumn1: Column4, AdditionalColumn2: Column5

  • Check the Inverse box if the amounts but be inverted on import to match correctly

Match Rules

• • Any number of match rules can be configured

  • Matches will be executed in the order they are shown

  • Rules can be reordered by clicking on the name and dragging it to the desired position

  • Matches can match two or more items but all matches must sum to zero

  • Each rule requires 2 sides to be defined 'X' and 'Y' for Dataset, Filter and Pattern

  • Dataset: Select the required dataset from the dropdown. Matches can be across different datasets or within the same dataset.

  • Filter: Tell the matching engine which subset of data to look into to find the matches for the specific clause. It is a 'where' clause.

  • Pattern: The actual 'match rule'. The engine will use the patterns specified to find words or phrases that match exactly between transactions

  • If no pattern is specified the rule will match on amount only

  • Pattern and Filter both use Regular Expressions and you can apply a filter or pattern any column. Specify Field:Regex eg MembershipNumber:\d{8} will find transactions which have words in them of 8 digits and filter or match on these accordingly.

  • Examples of Regular expressions:

  • [a-zA-Z]{2,}\d{1,} will match a string with two or more letters followed by 1 or more number eg XYZT56764

  • [a-zA-Z]{2,}\s\d{1,} will match a string with two or more letters followed by a space followed by 1 or more number eg XYZT 56764

  • \d{6} will match a string of 6 numbers exactly

  • JNL\w+ will match JNL followed by any number of letters and numbersl eg JNLS457645

  • You can combine patterns in one rule by using the pipe (|) character. This works as 'OR'

  • For more advanced help on setting up Regular expressions click here. There are many tools available to help you test your regular expressions.

  • Day Range specifies the date range for which the matches are valid. If left blank, date is not considered. If set to 31 (for example) transactions in the match can be a maximum of 31 days apart.

  • Review and manually reconcile matches: When checked any matches found by this rule are suggested to the user to review and accept or reject