Processing Swish reports
FinDock can automatically reconcile and match payments in Swish reports from Handelsbanken and Swedbank. The report files need to be in comma-separated values (CSV) format and uploaded to Chatter for processing.
Swish report handling
For each payment record in a Swish report, FinDock extracts the record details the file, transforms it to JSON, and then adds the JSON content to the Raw Message field of a new inbound report. From there Guided Matching extracts details into specific fields for reconciliation as outlined in the tables below.
Out of the box, FinDock extracts only the most essential data from the raw JSON. However, the Swish reports contain more information that you may want to use to enrich Salesforce data and improve matching results.
Using Guided Matching, you can do just about anything you want with the information in the Raw Message JSON on the inbound report.
Handelsbanken Swish report mapping
The following table outlines the mapping between Handelsbanken Swish report information records (type 02) and Inbound Report records. Each information record is parsed into an Inbound Report record with type Swish-for-FinDock and subtype Handelsbanken report.
The start record (type 01) and end record (type 03) for the Handelsbanken Swish report are ignored in the parsing process.
| Record field | Inbound Report field | Description |
|---|---|---|
| Business organization number | N/A | Beneficiary's organization/SHB number |
| Account number | N/A | Beneficiary's BBAN or IBAN |
| BIC | N/A | Always HANDSESS |
| Swish number | N/A | Beneficiary's Swish number |
| Transaction date | N/A | Date of payment YYYY-MM-DD |
| Transaction type Swish | Debit Credit Type | (See below) |
| Amount | Amount | Payment amount |
| Currency | N/A | Always SEK |
| Mobile no. | Account Number | Payer's mobile number |
| Name | N/A | Payer's name |
| Payment reference | Payment Reference | Unique Getswish/Riskbanken reference |
| Notification | N/A | Message from payer |
| Order ID | N/A | E-commerce order ID |
| Time stamp | N/A | Date and time of transaction |
| Booking Date | N/A | Booking date of payment |
| Instruction ID | N/A | Unique Id set by Swish |
| End to End ID | N/A | End-to-end Id except for SWR (Instruction ID) and SWU (Order ID) |
The Transaction type Swish field has several types which FinDock interprets as follows:
SWH= incoming payment = creditSWR= return of incoming payment = debitSWT= reversal of return = creditSWU= payout = debitSWZ= reversal of payout = credit
Swedbank Swish report mapping
Swedbank Swish reports have both PDF and CSV formats. The CSV format is used for reconciliation in FinDock. Each row in the CSV file is parsed into an Inbound Report record with type Swish-for-FinDock and subtype Swedbank report.
| Record field | Inbound Report field | Description |
|---|---|---|
| Radnr (Row Number) | N/A | Row number of the record in the CSV file |
| Clnr (Clearing Number) | N/A | Clearing number of beneficiary's bank |
| Kontonr (Account Number) | N/A | Beneficiary's bank account number |
| Bokfdag (Book Date) | N/A | Booking date of payment |
| Transdag (Transaction Date) | N/A | Date of transaction |
| Valutadag (Value Date) | N/A | Value date |
| Mottagarnr (Recipient Number) | N/A | Beneficiary's Swish number |
| Mottagarnamn (Recipient Name) | N/A | Beneficiary's name |
| Avsändarnr (Sender Number) | N/A | Payer's mobile number |
| Avsändarnamn (Sender Name) | Account Number | Payer's name |
| Meddelande (Payment Description) | N/A | Message from payer |
| Tid (Time) | N/A | Transaction time of day |
| Belopp (Amount) | Amount | Amount of payment |
| Orderreferens (Order Reference) | Payment Reference | Payment reference |