Skip to main content

CODA file processing

CODA, or geCOdeert DAgafschrift is a bank statement or ‘Coded statement of account’ filetype used in Belgium.

Reconciling CODA files#

The reconciliation process allows you to update and confirm your payment data in Salesforce. FinDock turns CODA files into a Transaction Set with Transaction records that are processed using Guided Matching.

Requirements#

Like other Bank statements, CODA files are uploaded to a specific Salesforce Chatter group to be parsed by FinDock. FinDock requires a SEPA target with the bank account for which you want to reconcile a CODA file.

For more information on the general Processing bank statement processing flow, please read our Processing bank statements article.

CODA file structure#

FinDock parses CODA files following the structure set out by Febelfin, the Belgian Federation for the Financial sector, as documented in the Coded statement of account (CODA) description (PDF). This document contains every detail on CODA, so it’s worth checking out if you wish to understand CODA reconciliation further.

Fixed Width files#

CODA files are structure Fixed Width data files. Fixed Width files are arranged in columns, but instead of the columns being separated by a character like a comma or semicolon every row is the same length. Every column has their own fixed width.

ID(10) Name(15) Address(25) Amount(7)

This is complicated by the fact that, in the case of CODA, what data is available can be determined by the content of other columns. So unlike with a CSV or Excel file, each row in the file can have a different structure, and not every row is a separate transaction.

Transaction records#

A CODA file consists of transaction records, identified by a transaction ID. A transaction can consist of several cash movements, indicated by movement records for instance when fees are deducted or exchange rates are applied.

When the transaction code starts with 2 or 3, the transaction is treated as a summary transaction and ignored when creating Salesforce records. Only the underlying transactions, with transaction code 6 or 7 are created as Transaction records in Salesforce.

Coded Statement of Account 3.1 Type

TypeSub-TypeSub-TypeDescription
0Simple amount without detailed data; e.g. : an individual credit transfer (free of charges)
1Amount as totalised by the customer; e.g. a file regrouping payments of wages or payments made to suppliers or a file regrouping collections for whic the customer is debited or credited with one single amount. As a matter of principle, this type is also used when no detailed data is followi (type 5).
5detail of 1 Standard procedure is no detailing. However, the customer may ask for detailed data to be included into his file after the overall record (type 1).
2Amount as totalised by the bank; e.g. : the total amount of a series of credit transfers with a structured communication As a matter of principle, this type will also be used when no detailed data (type 6 or 7) is following.
6detail of 2, simple amount without detailed data Normally, data of this kind comes after type 2. The customer may ask for a separate file containing the detailed data. In that case, one will speak of a ‘separate application’. The records in a separate application keep type 6.
7detail of 2, simple account with detailed data The records in a separate application keep type 7.
9detail of 7 The records in a separate application keep type 9.
3Simple amount with detailed data; e.g. in case of charges for cross-border credit transfers
8detail of 3

Movement and Information records#

A transaction contains detailed data in the form of movement records, which can in turn have information records with additional information. A transaction’s movement and information data stored in the Raw XML field on the Transaction record could look like follows:

21000100009876546498751245 00000001976111801912180015000007013X000001mAZbQAM/abcdefg 19121823801 0
2200010000 0000123456 KREDBEBB 1 0
2300010000BE12345687952177 EURJAN JANSEN 0 1
31000100019876546498751245 001500001001JAN JANSEN 1 0
3200010001JAARGETIJDENLAAN 150 B16 1050 BRUSSEL 0 0

The rows starting with a 2 are movement records, where 21 is the main movement record and the rows starting with 22 and 23 store additional data about the movement. The rows starting with a 3 are information records, where 31 is the main information record and the rows start with 32, and possibly even 33 store additional information.

Each type of record (21, 22, 23, 31, 32, 33) has its own structure. A movement record starting with 21 for instance has the following structure.

2|1|0001|0000|2007211901244519 |0000000000506000|210720|00150000|0 |210720|198|0|1| |0|

The detailed structure of all records can be found in Annexe I of the Coded statement of account (CODA) starting at page 14.

Example: Data record 2.1 - "movement record"

PositionsNumberTypeContentTag
11NRecord identification = 20
21NArticle code = 12.00721E+15
3-64NContinuous sequence number Starts at 0001 and is increased by 1 for each movement record referring to another movement on the daily statement of account. If there are more than 9,999 transactions, the number goes up to 0000 and then 0001.90400
7-104NDetail number starts at 0000 and is increased by 1 for each movement record for the same continuous sequence number. If there are more than 9,999 details relating to one single transaction, the number goes up to 0000 and then 0001.210720
11-3121ANReference number of the bank This information is purely informative.61/8
321NMovement sign: 0 = credit 1 = debit61/3
33-4715NAmount: 12 pos. + 3 decimals61/5
48-536NValue date or 000000 if not known (DDMMYY)61/1
54-618NTransaction code (see enclosure II)61/6
621NCommunication type: 0 = none or unstructured 1 = structuredABCDE123345
63-11553ANCommunication zone: - if pos. 62 = 0 free communication in pos. 63 up to 115 - if pos. 62 = 1 type of structured communication in pos. 63 up to 65, and communication as of pos. 66 (see enclosure III)61/9
116-1216NEntry date DDMMYY61/2
122-1243NSequence number statement of account on paper or Julian date or zeros. As for a non-Belgian account number: last 3 positions of the first part of the statement of account number.28/c
1251NGlobalisation code Marks the beginning and end of a globalisation for each hierarchy level.
1261NNext code: 0 = no record 2 or 3 with record identification 2 is following 1 = a record 2 or 3 with record identification 2 is following
1271ANBlank
1281NLink code with next data record: 0 = no information record is following (data record 3) 1 = an information record is following

Guided matching for CODA#

FinDock provides managed and suggested Guided Matching rules for CODA. You can add your own Guide Matching rules to the predefined rule sets.

Using Guided Matching for CODA#

To start reconciliation of CODA, upload your file to Chatter. The file is picked up by FinDock and transformed into Transaction records. FinDock creates a Transaction record in Salesforce for each transaction record in the CODA file, with the movement records as data in the Raw XML field.

Transactions can also be grouped or summarized in a transaction record in the file. In those cases FinDock only creates Transaction records from the detailed records and the summary transaction is left out. For more information about summarized transactions, please read section 3. Coding of the transaction, specifically section 3.1 type of the Coded statement of account (CODA) description linked above.

Matching rule behavior of managed rules#

note

The Guided Matching rules defined for CODA apply to all CODA files, regardless of the target used.

Once Transaction records have been created, Guided Matching will take over. With a set of pre-configured Guided Matching rules, FinDock:

  1. Maps fields from the CSV (as stored in the ‘Raw Message’ field) to the Transaction
  2. Extracts relevant data (see below for mapping)
  3. Searches for existing Installments based on the extracted data
    1. If found, sets the Contact based on the existing Installment
    2. If not found:
      1. Ask the user for Contact information by providing a search bar that allows you to both search and select an existing Contact, as well as create a new Contact.
      2. Creates a new Installment with the selected contact
  4. Processes the Installment by updating the amount and changing the status if applicable.

CODA transaction matched

The managed rules create mapping for Transaction as outlined in the table below.

FieldRecord identification (pos. 1-2)Additional logicValues in pos.Example
Type (debit / credit)21-32 (0=credit, 1=debit)0
Account Servicer Reference21-11-312.00721E+15
Actual Amount21-33-47 (leading 0s, 3 decimals)90400
Value Date21-48-53 (DDMMYY, 000000 if unknown)210720
Reported Payment Method Code21-55-56 (or do we need the full transaction code?)5
Reported Payment Method-Based on Transaction code. See table below-SEPA credit transfer
Description / Communication / Additional Entry information21Structured or unstructured based on 62 = 0 or 163-115unstructured: 7013X000001mAZbQAM/Donation towards campaign X
Entry Date21116-121210720
Payment Reference2222 exists64-98ABCDE123345
End to end id2222 exists64-98 (identical to payment reference?)ABCDE123345
Bank Account Number (IBAN) & Currency code2323 exists11-47BE68539007547034 EUR
Account Holder Name2323 exists48-82Jan Jansen
Reason Code2222 exists114-117AC03

Extending FinDock Guided Matching rules for CODA#

FinDock does not parse bank specific rules for unstructured communication out of the box. You can however parse this data by extending the out-of-the-box provided Guided Matching rules yourself or executing business logic on the Additional Entry Information field where the communication is stored.

CODA Guided matching rule setup

For instance, if you know that the first 18 characters of the (unstructured) communication contains the CampaignId present in your Salesforce environment, you could either:

  • extract the CampaignId from the Additional Entry Information with a Regex rule on Campaign into a free field on the Transaction record and then Query the campaign based on the extracted Id.
  • directly parse the CampaignId with a Fixed Width rule of your own on the RAW XML field where the original CODA movement and information records with regards to this Transaction are stored.

Or if you want to parse the address of a detailed information record (starting with 31 and 32) with structured communication, you could use the Fixed Width rule to get the Street based on its position in the record. You can limit the extraction of these characters to when the record itself indicates the communication is structured and contains a specific set of data to prevent extracting data from records that do not provide the right data.

For instance, in the example below we extract the Street from positions 11-45 on line 32 in the Raw XML field, but only when position 40-43 on line 31 is ‘1001’: a structured communication (1) with data concerning the counter party (001) as per the Febelfin CODA rules.

CODA guided matching fixed with street parsing