To use custom matching, the feature must be enabled under Setup > Company > General Preferences > Custom Preferences > ERP fast forward Bank Reconciliation.
Additionally custom matching rules need to be setup under Setup > Bank Reconciliation Setup > Custom Matching Rules.
To create a new Custom Matching Rule:
- Give the rule a name (just for your own reference)
- In case there might be multiple rules matching a particular transaction, give the rule a priority. The rule with priority closest to zero will have preference over the others. Decimal numbers are allowed (for example 0.5)
- In the field 'Apply To', select one or multiple bank accounts that this rule applies to. Leave blank to apply to all bank accounts.
- Set the criteria and fields to set.
The user may for example set a matching rule for Counterparty, to automatically recognize a payment coming from a certain customer. Or when the description contains 'Bank Fees', book the amount to a certain GL account.
- For each bank statement line all the rules are validated.
- If more then one rule applies to a line, all rules are executed.
- Custom matching overrides the automatic matching.