When you have set up templates that can be used to code your banking transactions. You can also automates the matching with the help of a set of matching parameters you set up yourself.
- Go to Banking - Process transactions
- Select Banking templates in the right hand column
- In the section Unmatched transaction: Drag a transaction to a banking template (see above)
- You are asked if you want to create a match between the transaction and the template for automatic matching in the future.
- Answer YES for a match modal to appear. Here you can enter the parameters for this match.
- The match is added to a match list under Banking - Import bank statement
NOTE: template matching as a functionality is activated automatically as you start matching.
The next time you work with banking:
- Templates and transactions have been matched according to your template matching rule and can be found under Matched transactions at the bottom of your screen.
- Click on the transaction to examine the match
- If necessary, you can:
- Delete the match
- Change the template
- Go to manual coding to edit the journal
- When you are satisfied with your matches, click Process all
- Journals will be created from your matches. These can be found in the journal list and can be tracked to the bank statement.
- The transactions in the bank account statements will have a link to the journal created in by the match. See Banking and the Audit trail
The Match Modal
The match modal offers the a number of match parameters which are listed below.
NOTE: All parameters, except he Name & template match, can be edited or left blank if they are not to be used in the matching process.
- In the Name field: The company & template name are input automatically as a match parameter. The match is both obligatory & automatic when the match is done while matching transactions.
- The amount (Total of the Transaction in EUR) is taken from the transaction amount. Enter the amount as positive or negative to make sure a template only matches against transactions of the correct type.
- Transaction total allowed deviation +/- : enter for example 10 to get a deviation of +/- 10 Euro from the total transaction amount. Leave blank and no deviation from the amount will be allowed.
- Reference number is taken from the transaction. This can also be a transaction text if there is no reference number.
- Transaction text: Here accountants can enter keywords that need to be matched. In many payment cases the information imported here is the name of the company. A wildcard search (*) is available for this field. Use * to insert a wild card i your search and make it mor flexible.
- Expected day of the month: is the expected transaction date, for ex the 15th every month, taken from the transaction.
- Expected days deviation allowed: enter for example 2 to get a deviation of +/- 2 days around the expected day of the month.
The Match List
When a match has been created it is automatically placed in the Journal template match rule list under the section for Automatic matches in the main view under Banking- Import Bank Statements.
From this table the user can:
- Get an overview of all the template matches in use
- See who created the matches
- Access the match parameters for each template and edit them
- Delete the match
- Create matches manually by clicking on Create.
The transaction text can be an exact match but it also allows for wildcards where * (asterisk) matches any text.
See below examples of valid matching rules:
- phone* (matches any text beginning with phone)
- *phone (matches text ending with phone)
- *phone* (matches text containing phone)