Bank transaction rules (CA204500)

This topic gives you information about the elements that you find in this window in Visma Net, such as fields, field values, buttons, and check boxes.

You can use this window to define and view the rules that are used to create new payments for imported bank transactions for which matching documents were not found in the system in the Process bank transactions (CA306000) window. You can define rules to create documents originating in the Cash management workspace only.

The system navigates you to this window when you click Create rule in the Process bank transactions (CA306000) and Process incoming payments (AR305000) windows.

In this case, fields in the Matching criteria section are filled with the transaction details automatically and you need to specify output details only.
You can clear or modify values in the Matching criteria section if some of the transaction details cannot be used as a criterion.
For example: You can modify the transaction description by using wildcard characters (* or ?) and the Use wildcards check box or clear the Description field.

If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view.

There are two types of search fields:

  • White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or % and get different results:

    • space: the result contains the words in any order,

    • %: the result contains the words in the specific order, and the % functions as a wildcard as well.

  • Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.

You can use the elements in this area to define a new rule and its settings. Or, to select an existing rule and view its settings.

Element Description
Rule A unique identifier for the rule. The alphanumeric string may contain up to 30 characters.
Description A detailed description of the rule. This alphanumeric string may contain up to 256 characters.
Active A check box that indicates (if selected) that the rule is available for use in the Process bank transactions (CA306000) window.

In this section, you specify multiple criteria that should be met by a bank transaction for the rule to be applied.

Element Description
Debit/Credit The type of transaction: Disbursement or Receipt.
Cash account The identifier of the cash account, which corresponds to the account in the bank.
Currency The currency of a transaction. The field is disabled and displays the currency of the selected cash account (if any).
Trans. code The code of the transaction.
Description

The description of the transaction. The application of this criterion depends on the value of the Use wild cards check box:

  • Cleared:
    The criterion is met if the description of a transaction contains a string you have typed in the Description field.
  • Selected:
    The criterion is met if the description of a transaction equals a string you have typed in the Description field.

The field is filled with a transaction description when you have been navigated here from the Process bank transactions (CA306000) window.
If you do not want to use a description as the criterion, make sure the field is cleared.

Match case A check box that indicates (if selected) that the font case of a transaction description should match to the font case in the Description field.
Use wild cards A check box that indicates that you can use wild card characters (* or ?) in the Description field. This is selected by default.
Use name from bank A check box that indicates (when selected) that the name from the bank can be used in the Description field.
Bank account number The IBAN/BBAN number to be used on the rule. The IBAN/BBAN will be updated from the bank transaction when creating a rule. The bank transaction rules will be picked in alphabetical order, so when there are several hits, the first matching rule will be used.
Amount matching mode The mode of the transaction amount matching. The following options are available:
  • None: The amount criterion is not used. This is the default.
  • Equal: The transaction amount must be equal to the number specified in the Amount field.
  • Between: The transaction amount must be in the range of the numbers specified in the Amount and the Max. amount fields.
Amount

The number used to compare a transaction amount.

Note: This field is only available if you have selected the options Between or Equal in the Amount matching mode field.
Max. amount

The maximum number used to compare a transaction amount.

Note: This field is only available if you have selected the option Between in the Amount matching mode field.

In this section, you provide the details of the rule application result.

Element Description
Action The action that is performed by the system when the rule is appslied. The following options are available:
  • Create document:
    The system creates a new document to match the imported bank transaction (that meets the specified criteria) for which a match was not found in the system (by using the entry type specified in the Resulting entry type field).
  • Hide:
    The system hides the imported bank transaction (that meets the specified criteria) from the list and marks it as processed.
    You can then clear the Processed and Hidden check boxes for the transaction by clicking the Unhide transaction button in the Import bank transactions (CA306500) window to be able to view and process the transaction again.
Resulting entry type

The identifier of the entry type that the system will use as a template to create a cash transaction to match the imported bank transaction (that meets the specified criteria) for which a match was not found in the system.

You can create entry types by using the Entry types (CA203000)  window.
The field is displayed if the Create document option is selected in the Action field.
Default offset account

The account that is used as the offset account for transactions being created.

The account is copied from the selected entry type. You can override this account on the bank transaction rule .

The bank transaction being made will inherit the account from the rule. If no account is set on the rule, the transaction will inherit the account from the entry type.
Default offset subaccount

The corresponding subaccount.

The subaccount is copied from the selected entry type. You can override this subaccount on the bank transaction rule .

The bank transaction being made will inherit the subaccount from the rule. If no subaccount is set on the rule, the transaction will inherit the subaccount from the entry type.
VAT zone The VAT zone that applies to the transaction.
VAT calculation mode

This field has a read-only value that always shows Gross.

Gross: The amount in the document detail line includes a tax or taxes.
VAT category A list of taxes associated with a product or a service when it is purchased or sold.
Branch The branch that applies to the transaction.

Related tasks

Create bank transaction rules

Related windows

Process bank transactions (CA306000)

Import bank transactions (CA306500)