Update Note: Banking file export >> Sweden - ISO20022
Katrin Veskimäe
12-14-21
Operating system: macOS
Available from 8.5 2021-11-24 build 164


Need:
————
in Sweden from 1.2022 banks will only support import of ordered bank transactions in .xml file that uses ISO20022 format
this format supports in 1 file all types of payments directed to the bank


Solution:
——————


changes if VAT Law = SWE
===========================

PL >> Settings >> Bank transfer we renamed existing export "Sweden - SEPA" to "Sweden - ISO20022"
    this export supports export of following payments channels:

    - domestic via Bankgiro
    - domestic via Plusgiro
    - domestic via other banks
    - foergin SEPA - EURO zone transfer
    - foreign - international non SEPA transfer
if chosen system will export .xml file using ISO20022 format
NOTE! all current changes were based and tested using SEB bank formats)

PL >> Register >> Contact >> flip Accounts - added:

- new field BIC (SWIFT) - to specify suppliers bank BIC/SWIFT number, if empty system will check BIC/SWIFT from Bank record specified in Bank operator field on Contact record
- new section - Payment channel - to specify default payment channel for Supplier with following options:
    - - Bankgiro - set by default
    - - Plusgiro
    - - Other domestic
    - - SEPA Foreign - will be set automatically if on Contact record field Country is filled in and on this Country record VAT zone is set to = EU or EU post VAT
    - - Foreign - will be set automatically if on Contact record field Country is filled in and on this Country - VAT zone is set to = outside EU or outside EU post VAT


Logic for entering Suppliers bank details:
- all Payment channels accept supplier IBAN, in this case BIC/SWIFT number has to be provided
    enter Supplier bank account in IBAN format on flip Accounts >> field IBAN
    enter BIC/SWITF on flip Accounts >> field BIC/SWIFT
    alternatively - create in PL >> Banks >> new record for Supplier bank andante BIC/SWIFT number there, assign this bank to supplier record using field Bank Operator

- if Payment channel is Bankgiro and you have suppliers Bankgiro number - specify this number in field Bank account on supplier record
            you do not need to specify bank clearing details in this case
- if Payment channel is Plusgiro and you have suppliers BBAN account number (non IBAN) - specify this number in field Bank account on supplier record

            you do not need to specify bank clearing details in this case
- if Payment channel is Other domestic and you have suppliers BBAN account number (non IBAN) - specify this number in field Bank account on supplier record
            specify Bank clearing number in field Short on Contact record
- if Payment channel is Foreign and you have suppliers BBAN account number (non IBAN) - specify this number in field Bank account on supplier record
            in such case create Bank record for Supplier bank and specify Country clearing ID followed by Bank clearing ID in field Clearing
            (example PLKNR11401010 where PLKNR is country clearing ID and 11401010 is bank clearing number)


PL >> Register >> Purchase invoice >> flip Accounts - added:
- new section - Payment channel - if Supplier code is entered, Payment channel on Purchase invoice is set to be same os on this Supplier record automatically and can be adjusted by user if needed

   
- change logic for pasting data to field Bank account on Purchase invoice to be following:

    - - if Payment channel on Supplier = Bankgiro or Plusgiro - system first checks and copy data from field Bank account if empty from field IBAN
    - - if Payment channel on Supplier = Other domestic or SEPA or Foreign - system works as before - first checks and copy data from field IBAN and than if empty from field Bank account

PL >> Register >> Payments >> tile K added
- new column - Payment Channel - by default Payment channel specified on Purchase invoice will be copied here
        if you wish to exclude SEPA to be always added to separate Payments records you can use need aded checkbox in PL>Payment settings>>Do not allow to mix SEPA and non SEPA payment rows - this checkbox is optional to use!

- new column - Urgency - to specify if payment should be send faster ot not, with following options:
        - - Normal - by default for normal transfers
        - - Same day - faster same day transfer payment, not supported for Bankgiro/Plusgiro, user will get error if used, ignored by SEPA transfers
        - - Express - express transfer payment, not supported for Bankgiro/Plusgiro, user will get error if used, ignored by SEPA transfers

- new column - Bank fee - to specify fee split with options:
        - - Shared - by default

        - - Supplier pays
        - - We pay


Workflow:
==========
if in PL >> Settings >> Bank transfer >> Payment file format = Sweden - ISO20022
and user exports data from:
- Payment >> Operations >> Banking file format
or
- PL >> Routines >> Exports >> Banking file

system exports .xml file using ISO20022 format. All Payment lines will be included in 1 file no matter of payment channel.

For payment description system will take data from:

- Purchase Invoice >> field Reference - OCR/KID should be specified here if known
if empty
- Purchase Invoice >> field Supplier invoice number
if empty
- Payment >> flip A >> Column Text

Settings from:

- Payment >> flip Bank - checkbox Foreign, section Payment format, Payment Method, Bank fees

- Export >> Banking file - checkbox Foreign, One payment per supplier, Payment Method, Bank fees
will be ignored

NOTE! by now export each line of Payment as separate transaction to the bank, we plan to merge transactions to same supplier/payment channel/urgency/fees as next step

Current SEB specifications and export examples added to this Update note as well.

// Agnieszka Klimkiewicz [ 2021-12-06 - 11:20 GMT+2 ]
-----------------------------------------------------------
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Ibrahim Bashir
Hello, Auto Scan Import folder is ticked. with multi-company database how to tell the file to which company to be imported? is there somewhere to tag the company where the file to be imported? ...
08:08 28 Mar 2024
SoftIQ Technologies Ltd.
Hello, Our client who has a new contract is trying to access there old database but it gives an error when you try to open the system "window is blocked while license is shut-down ProgressWCla...
07:15 27 Mar 2024