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)