Using field templates in Banking Import

  • 04/11/2025
  • 7 minutter at læse

Field templates in Continia Banking Import allow users to create and reuse configurations for text fields. This article provides an overview of key templates you can use and configure across reconciliation, matching, and payment reference rules.

On the Banking Import Setup page, you can define templates to control different aspects of the reconciliation and posting process. The setup uses the import settings as default values. However, they can be adjusted as needed on the following pages:

  • The Bank Account Card page
  • The Search Rule page
  • The Payment Reference Rule page

Import FastTab

The Default Statement Description Template specifies the default field used for the statement description (in the Bank Acc. Reconciliation) and transaction text (in the Payment Reconciliation Journal) when importing bank transactions. Predefined fields ensure consistent and clear transaction records.

Default templates

TemplateDescriptionField Selection TextField Selection Example
TRANSACDETAILTEXTText from the Bank Transaction Detail tableSpecifies the Detail Text field from the bank transaction detail for matching.`<Bank Transaction Detail
TRANSACPOSTDESCText from the Bank Transaction Line Posting Description.Specifies the Posting Description field from the bank transaction line for matching.`<Bank Transaction Line
TRANSACPOSTDESCSText from the Bank Transaction Line Posting Description and Posting Description 2.Specifies both Posting Description and Posting Description 2 fields from the bank transaction line for more comprehensive matching.`<Bank Transaction Line

To create a custom template:

  1. On the Banking Import Setup page, navigate to the Import FastTab, and in Default Statement Description Template field, select the three dots.
  2. On the Bank Statement Description Templates page, click New.
  3. Enter a Code and Description.
  4. In the Fields section, click Add fields to specify which fields to search. You can select multiple fields, which will be applied to the statement description and transaction text when importing bank transactions.

Matching FastTab

The Default Search Field Template specifies which fields to use when matching bank transactions during reconciliation. You can create your own custom templates by selecting the three dots.

Default templates

TemplateDescriptionExample
BANKTRANSACCODEBank Transaction Code`<Bank Acc. Reconciliation Line
DESCTRANSACDETAILSCombines Description, Transaction Text, and Detail Text for improved matching.`<Bank Acc. Reconciliation Line
DESCTRANSACTEXTUses both Description and Transaction Text for matching.`<Bank Acc. Reconciliation Line
DETAILTEXTFocuses only on Detail Text for matching transactions.`<Bank Acc. Reconciliation Line Detail
DOMAINFAMILYUses Domain Code, Family Code, and Sub-Family Code for classification-based matching.`<Bank Acc. Reconciliation Line

To create a custom template:

  1. On the Banking Import Setup page, navigate to the Matching FastTab, and in Default Search Field Template field, select the three dots.
  2. On the Search Field Templates page, click New.
  3. Enter a Code and Description.
  4. In the Field, click Add fields to specify which fields to search. You can select multiple fields, and the system applies them whenever the search field selection code is used in a search rule.

Amount Difference FastTab

The Posting Description Template defines the format for transaction descriptions, particularly when handling amount differences in bank reconciliation. These templates ensure consistency in transaction descriptions. Default templates are available, but custom templates can also be created.

Default templates

TemplateDescriptionDescription PatternExample
ACCNORELATEDPRTYNMEAccount No and Related-Party Name`Payment from <Bank Acc. Reconciliation LineAccount No.> <Bank Acc. Reconciliation Line
DESCRIPTIONDescription only`<Bank Acc. Reconciliation LineDescription>`
RELATEDPRTYNMERelated-Party Name`Payment from <Bank Acc. Reconciliation LineRelated-Party Name>`
RELATEDPRTYNMEVALDATRelated-Party Name and Value Date`Payment from <Bank Acc. Reconciliation LineAccount No.> <Bank Acc. Reconciliation Line
TRANSACTIONTEXTTransaction Text`<Bank Acc. Reconciliation LineTransaction Text>`

To create a custom template:

  1. On the Banking Import Setup page, navigate to the Amount Difference FastTab, and in Posting Description Template field, select the three dots.
  2. On the Posting Description Templates page, select New.
  3. Add a Code and Description.
  4. In the Fields section, click Add fields to specify which fields to search. You can select multiple fields, and the system applies them whenever the search field selection code is used in a search rule.

Payment reference search field templates

Payment reference search field templates define where Continia Banking should look for payment references when processing imported bank statement data. These templates are required for every payment reference rule.

When a payment reference rule is executed, the system searches the fields specified in the selected template to locate potential payment references. Templates can include fields from the:

  • Bank Account Reconciliation Line – main statement line fields
  • Bank Reconciliation Line Details – additional transaction details

Each template can include multiple field definitions, such as Description, Additional Transaction Info, or Remittance Information. The system evaluates all defined fields and validates any values found against the rule’s validation pattern and check digit settings.

Bemærk

The system automatically splits text values found in detail fields by spaces, treating each word as a potential payment reference. This helps identify references in fields containing multiple pieces of information.

To configure a payment reference search field template:

  1. Search (Search) for and select Payment Reference Rules.
  2. When creating or editing a rule, navigate to the Payment Reference Search Field Template field and select an existing template or create a new one.
  3. If you create a new template, define the fields to include. For example, Description, Related Party Name, or Remittance Information.