Reconciliation Rules

Recon rules can be written using either the Easy Rule Editor (Add Easy Rule) or the Advanced Rule editor (Add Rule). For guidance on which editor to use see here. This page also gives hints and tips on designing advanced Recon rules.

Easy Rules

  • Allows you to select which columns to include in your match, filter the transaction set and do a group by if required

  • Exact matches and other matches with ranges and tolerances can be configured as required

  • If you convert to an advanced rule, it can't be undone

Advanced Rules

  • You need to write the full XMl structure for your rule and the SQ queries for each dataset

  • Must be used if you are writing helper rules

Common sections across both editors

Create Journal for Difference and related settings

If a tolerance is specified on the amount match criteria you need to create a journal for the difference with all the necessary attributes. Remember, balancing entries are always created on the cashbook side

    • Batch Type: It is often a good idea to create a batch type especially for Auto Recon journals so that they can be easily identified

    • Cashbook Transaction Type: A defined cashbook transaction type can also be helpful

    • GL Account Mappings: A different GL Account can be specified for both positive and negative differences. You can also specify GL Accounts per account in the domain if required

Run Rules across accounts

    • You can configure any rule, easy or advanced, to run across accounts

    • This allows you to automate matches that need to happen between transactions in different accounts

    • Remember to remove any exact amount match on accountid from the rule to allow this to happen

    • See here for more info on what happens when a match across accounts is made