Processing Total IN files
FinDock Total IN file processing is in pilot. If you would like to participate in the pilot, please contact FinDock Support.
The Total IN file format is used in Sweden to report PlusGiro, Bankgiro and other payments processed through the Total IN services of Nordea.
Total IN reconciliation process
FinDock automatically picks up Total IN files for processing once they are uploaded to Chatter. Files are first parsed by ProcessingHub into transaction sets and transactions. Matching is then carried out through Guided Matching managed and custom rules.
The overall flow is illustrated below with three basic steps:
- Fetch file from Chatter.
- Parse and extract file content into transaction sets and transactions.
- Match, update and enrich payment data through Guided Matching.
Targets for Total IN processing
For each originating bank account of your TotalIN files, you need to configure a target for ProcessingHub to use in the reconciliation process.
When creating targets for Total IN processing, use the following configuration:
- Target type: Sweden-for-FinDock
- Target subtype: Total IN
- Append Length Digit To OCR Reference: set according to your bank’s specifications
- OCR Reference Length: set according to your bank’s specifications
- Bank account number: your PlusGiro account number associated with your Total IN service
- Duplicate file protection: enable (recommended) to ensure duplicate files are not processed
Total IN file structure
The basic file structure is illustrated below, where a single file can have one or more Accounts and Currencies sections, which in turn have one Transactions section. Each Transactions section has one Payment / Deduction entry and several optional informational entries along with it.
When ProcessingHub parses a Total IN file, a single Transaction Set record is created for the file. Each Accounts and Currencies section in that file is parsed into a Transaction record related to the transaction set.
Transaction creation
Based on the Record Type (first two characters), ProcessingHub identifies the type of record the line represents.
When a Payment/Deduction record is created, ProcessingHub adds the associated "Records for Sender account etc." in the Raw XML Entry field of the Transaction record. Account holder name is taken from the Name entry. Address line 1 is then extracted from the Address entry, while City, Postal Code and Country Code come from the "Postal code, city, countrycode" entry.
Total IN field mapping
The following table outlines the mapping between Total IN fields for payments and fields on Transaction Set and Transaction.
| Total IN Record | Total IN Field | FinDock Object | FinDock Field |
|---|---|---|---|
| Opening record File | Total IN ID | Transaction Set | Electronic Sequence Number |
| Start record Account and currency | Receiving account | Transaction Set | IBAN |
| Start record Account and currency | Currency | Transaction Set | Currency |
| Opening record File | Date created | Transaction Set | From Date |
| Opening record File | Date created | Transaction Set | To Date |
| Payment record/Deduction record | Sender-Bankgiro number | Transaction | IBAN |
| Payment record/Deduction record | Customer reference | Transaction | Payment Reference |
| Payment record/Deduction record | Total IN transaction serial number | Transaction | End To End Id |
| Payment record/Deduction record | Amount | Transaction | Amount |
| Deduction record | Deduction code | Transaction | Reason Code |
| Payment sender records/Name | Name 1 && Name 2 | Transaction | Account Holder Name |
| Payment sender records/Address | Address1 | Transaction | Address Line 1 |
| Payment sender records/Postal code, city, countrycode | City | Transaction | City |
| Payment sender records/Postal code, city, countrycode | Country code | Transaction | Country |
| Payment sender records/Postal code, city, countrycode | Postal code | Transaction | Postal Code |
| Opening record File | Date created | Transaction | Date |
Extending Total IN processing with Guided Matching
Out of the box, FinDock extracts the information from Total IN files required to update payment data in Salesforce. However, the files may contain other information that you would like to use.
Through Guided Matching, you can do just about anything you want with the information in the file. You can also create rules that extend the logic of the already parsed data on Transaction Set and Transaction records.