Document and Account Recognition setup
  • 22 May 2024
  • PDF

Document and Account Recognition setup

  • PDF

Article summary

In this manual chapter, we will introduce you to Bankfeed recognition rules and setup.

First, there is a list of recognition used in order of priorities:

  • Document Number Recognition
    Document number recognition is a top priority in Bankfeed. By recognizing the document, you can identify the customer/vendor and apply payment to it. For document recognition, we use "Document Recognition Setup (Bankfeed)". It's based on Regular Expression formulas (Regex), and Bankfeed consultants usually set it up.

  • Customer/Vendor IBAN or Registration No. (if used)
    If this information is provided in statement lines, customers and Vendors can be identified using their IBAN or Registration Number information from the cards. Some banks do not provide IBANs or the payee/payer's registration number in their transactions, so this feature can be limited.
    Let's read about it in more detail.

  • Repeated texts which can be linked to certain Accounts.
    This setup is one of the easiest to use and understand. If you see repeated texts in the bank transactions (Statement lines), you can just map this text to the desired Account and Account Number in the setup table "Text-to-Account Mapping (Bankfeed)".

Document Recognition Setup (Bankfeed)

The system is able to extract and identify document numbers from the "Message to recipient" field in transactions. To accomplish this, we need to define document recognition rules. We utilize text recognition formulas described in Regex (Regular Expression Language) for this purpose.

Once we have identified the most common variants of document numbers in the "Message to recipient" field, we employ Regex templates in the "Document Recognition Setup (Bankfeed)".

For more information about Regex (Regular Expression Language), you can visit the Regex Regular Expression Language - Quick Reference | Microsoft Docs.

image.png

The fields Transaction domain code and Transaction subfamily code, Credit/debit indicator contain the values that are specified in the XML files of the bank statement for specific transactions and in the Statement Lines (Bankfeed). This allows us to describe different text recognition formulas for different transactions. If Transaction domain code and Transaction subfamily code fields are empty it means that all combinations are available.

image.png

FieldDescription
Document TypeSpecify the type of document the system should search according to the recognized text.
Cust.L.E. – Doc.No. Field No.Here you can select which document No. should be used for matching. Usually used 6 – Document No, 63 – External Document No.. If it’s 0, no documents will be searched in these entries.
Vend.L.E. – Doc.No. Field No.Here you can select which document No. should be used for matching. Usually used 6 – Document No, 63 – External Document No.. If it’s 0, no documents will be searched in these entries.

If you are unsure whether we are using the correct text recognition formula, you can stand on a specific line, enter the text in the bottom field, "Input," and then see if we get the desired result in the "Result" field.

image.png

What information is used to identify customer/vendor cards?

When parsing bank statement lines to the system, customers/vendors are identified by:

Posted documents and the name of the customer/vendor.
This is related to Document Recognition formulas. The customer's/vendor's name is also checked if the document is identified.
The company Registration Number in the customer ‘s/vendor ‘s card (field Registration No.).
If the Customer/Vendor card Registration No. is filled out, and this information is provided in the incoming Statements lines; the Customer/Vendor can be identified using this information.
The bank account information (IBAN field) in the customer ‘s/vendor ‘s card.
If the Customer/Vendor have IBANs in the BC, and this information is provided in the incoming Statement lines; the Customer/Vendor can be identified using this information.

When Bankfeed identifies Customers/Vendors, you will see these Account Recognition Types in the Statement Lines (Bankfeed) and journal lines:

• Identified by the Customer's/Vendor's Registration No.

image.png

• Identified by Customer's/Vendor's IBAN

image.png

• Identified by Customer‘s/Vendor's Name and Document No.

image.png

• Identified by Document No.

image.png

How to setup recognition based on repeated texts?

Bank transactions often cannot be identified according to any other criteria except Text. Repeated texts can be filled in the setup table Text-to-Account Mapping (Bankfeed).
This window can be found either using Search or in the payment journal by selecting Process > Text-to-Account Mapping.

image.png

FieldDescription
Mapping TextSpecify the Text that should appear in the "Message to the recipient" field. This can be a fragment of Text.
Account TypeSpecify which account type should be assigned in the lines where this mapping text is found.
Account No.Specify which account number should be assigned in the lines where this mapping text is found.
Part of WordMark this if your entered text fragment will be part of one big Text. For example "bolt.eu" will be part of "bolt.eu/r/2310120524 CARD_PAYMENT".
Information

When "Text-to-Account mapping" is filled, the setup will apply to new lines. If you want to apply it to existing lines, use the function Refresh Recognition in the Statement Lines (Bankfeed) page. Journal lines must be created again after the "Refresh Recognition" function.