Matching incoming payments

Matching incoming payments

Content

• Incoming payments with KID/FIK

• Free-text matching

• MR1 – Invoice number standalone in the text field

• MR2 – KID in the text field

• MR3 – Invoice number at the start or end of a longer number in the text field

• MR4 – Invoice number at the start or end of the invoice number field

• MR5 – Invoice number in the KID field

• MR6 – KID = KID

• MR7 – Invoice number and customer number in the text field

• MR8 – Invoice number anywhere in the text field

• MR9 – Customer/supplier number anywhere in the text field

• MR10 – Search for customer/supplier name

• MR11 – Text-in-text match

• MR12 – Search by counter reference

• MR13 – Search for invoice number inside payment KID

• MR14 – Search for customized field from payment invoice number

Aritma Pay includes advanced rules for automatically matching incoming payments. These rules are configured in the Factoringselskap table in Visma Business. Navigate via Explorer → Tables → Accounting → Fixed information → Factoringselskap.

In this table, the following must be set:

• Fact.behandl. = 2 (OCR/KID definition).

• Bank account must be filled in (matching the incoming payment account, either as BBAN or IBAN, without spaces or punctuation).

• KID ref. digits = length of the invoice number.

• KID customer/supplier digits = length of the customer number.

• OCR bank account and General ledger account fee must also be completed.

Incoming payments with KID/FIK

• If the KID only consists of invoice number or customer number, go to Payment processing and check “Use only invoice number as KID” or “Use only customer number as KID”.

• If the KID consists of more than customer and invoice numbers, fill in the Factoring ID.

Example:
If Factoring ID = 7;13

• Customer number begins at position 7 (counting from 1).

• Invoice number begins at position 13.

Alternatively, you can use matching rule MR6 (KID = KID).

Free-text matching

Free-text matching can be used for payments with or without KID (OCR, CreMul, C54D, etc.).

• Codes are entered in the Free-text matching field in the format #([MR1]).

• Multiple rules can be combined: #([MR1] [MR2]).

• Rules are applied in the order written.

• The applied rule can be checked in the field External reference 3 in Visma Business.

Free-text matching rules always run before other rules selected in Payment processing.

Some rules require newer versions of Aritma Pay. It is recommended to upgrade before setting up matching rules.

Matching rules (MR)

• MR1 – Finds invoice number in the text field. Length must match “KID ref. digits”.

• MR2 – Finds KID in the text field. Length must be ≥ total of “KID customer digits” + “KID ref. digits”.

• MR3 – Invoice number at the start or end of a longer number in the text field.

• MR4 – Same as MR3 but searches in the invoice number field.

• MR5 – Invoice number inside the KID field (e.g. leading zeros missing).

• MR6 – Direct match: KID = KID. No length validation.

• MR7 – Finds both invoice number and customer number in the text field. Must follow the sequence defined in Factoring ID.

• MR8 – Invoice number located anywhere in the text field.

• MR9 – Customer or supplier number located anywhere in the text field.

• MR10 – Search for open items by customer/supplier name.

• MR11 – Match if the open item’s text is found inside the payment message text.

• MR12 – Search by counter reference.

• MR13 – Search for invoice number embedded in KID. Example: [MR13=<position>;<length>].

• MR14 – Search by custom SQL field. Example: [MR14=Ref].