During the import of bank feeds, the feed may — depending on the bank’s format — contain various reference types, such as DOC, PID, CHQ, MSG, etc.
These reference types are usually imported and can be displayed on the lines in a Payment Reconciliation Journal.
However, in some cases, users may want one or more of these references to appear directly in the transaction text or in the manual advice text of the journal lines.
With this reference setup, users can choose which reference types to include in either the transaction text or the manual advice text, as well as define the order in which they are added.
Be aware: The transaction text in the Payment Reconciliation Journal lines can only contain a maximum of 140 characters.
Some Reference Type compositions can exceed the Payment Reconciliation Lines – Transaction Text limit (140 characters). To avoid truncation, users can setup to store Reference Type output in Manual Advice Text instead.
Pros : using the manual advice text
Manual Advice Text is effectively unlimited, so no loss of reference information.
If Manual Advice Text is used for automatching, richer content may increase match success.
Cons : using the manual advice text
Manual Advice Text won’t be part of the posting text (where Transaction Text normally is), so posting descriptions may become less descriptive.
Reference
Specifies the code of the Reference value to be added to the transaction text field.
ANY: Try any reference
NOTE: Do not use this, as it does not provide any useful value for the transaction text.
ACC: Own accountnumber
The reference may contain customer account number or bank account number,
if it is included in the payment information provided by the payer.
ACK: Banks own reference
The reference may contains the executing banks own reference for the transaction,
but is not firmly definable.
AFS: Senders reference
The reference may contain values from senders, if it is included in the payment information provided by the payer.
CHQ: Cheque reference
The reference might contain cheque number.
DAD: DirectDebit reference
The reference may contain Direct debit advice reference.
ADD: Additional reference
The reference may contain Additional reference.
DOC: Original document
The reference may contain the original document number (such as an invoice number)
if it is included in the payment information provided by the payer.
PID: Payment reference
The reference may contain payment reference number (such as a FIK, KID or other payment reference type), if it is included in the payment information provided by the payer.
STO: Store number
The reference may contain Store number.
AMC: References between FINSTA and POSTING BASIS.
Do not use this reference, as it is intended primarily for internal use.
MSG: Messages from bank/payer
The reference contains transaction information.
Default behavior for MSG reference value(s)
Transaction Text shows:
Bankfeed Posting Text (if present)
plus MSG reference values (as per current logic/formatting)
(may be truncated if exceeding 140 chars).
Alternative behavior when MSG is configured as “Add to manual text”
Case A: Bankfeed Posting Text exists (not empty)
Transaction Text: uses Posting Text (and does not add MSG reference values)
Manual Advice Text: includes MSG reference values
(and other references types setup to "Add to manual text")
Case B: Bankfeed Posting Text is empty
Transaction Text: fallback-fill with MSG reference values up to 140 chars
Manual Advice Text: includes MSG reference values
(and other references types setup to "Add to manual text")
NOT-XXX: Other reference
The reference contains non-placeable references and is not firmly definable.
E2E: End2End Id
The Reference contains a unique identifier for outgoing payments made through the Payment Journal.
This reference is used to match outgoing payments with the transaction lines in the imported bank feed.
It is already displayed on the Payment Reconciliation Lines in the Transaction ID field.
ULR: uniquelinkref
A unique reference used in communication with the bank to identify each individual transaction.
None: No reference
NOTE: Do not use this, as it does not provide any useful value for the transaction text.
Order of addition
Specifies the order of addition of the reference values to be added to the transaction text field.
Add to transaction text
Specifies if the reference values should be added to transaction text field.
Add to manual text
Specifies if the reference values should be added to the manual advice text factbox.
Deletes the selected lines