Language:


HansaManuals Home   >> Standard ERP   >> Purchase Ledger   >> Exports  

Eelmine   Järgmine               Prindi kogu peatükk               Otsi  

Juhend HansaWorld Enterprise'i versioonile 2024-03-16  

Banking File - Sweden - ISO20022 SEB, Nordea and ISO20022 Handelsbanken

This page contains some guidance about where to enter information in order for it to be included correctly in Banking File export files when they are produced using the ISO20022 SEB, Nordea and ISO20022 Handelsbanken Swedish bank Payment File Formats . Please refer here for details about the Handelsbanken, Nordea, PostGirot, SE-Banken and Swedbank Payment File Formats.

Configuration

  1. In the Company Info setting:

    1. Ensure the Company Name and Country are correct. The Country should use the two-character ISO 3166 format.

    2. After entering a record for your bank in the Banks setting (point 3 below), enter its Code in the Bank Code field. This Bank will be used to supply the Bank ID Code if there is no Bank in a Payment Mode (this will usually be the case if you have a single bank account).

    3. Enter your bank account number in IBAN format including two-character country prefix in the Bank 2 field. The bank account number will be used if the Bank A/C No in a Payment Mode (point 5 below) and the Account (IBAN) in the Bank record for your Bank (point 3c below) are both blank, and the country prefix will be used as the country in which you are located (the export function will sometimes use the country prefix and sometimes the Country field itself for this purpose).

  2. In the Payment Codes setting, enter Payment Codes as listed at https://www.skatteverket.se.

  3. In the Banks setting:

    1. Enter a separate record for each Bank used by your Suppliers, and one for your own Bank.

    2. Specify a BIC (SWIFT) in each Bank record (optional in the case of the Banks used by your Suppliers, see point 4d below).

    3. For your own Bank, enter the Account (IBAN) and Bank ID Code (your Contract/Customer/Organisation ID at the bank). This will be exported in the <Id> tag (inside <InitgPty>) and is required by SEB (optional for other banks).

    4. If you will be sending Payments to a Supplier's Bank in Currencies other than the Euro (i.e. if you will use Currencies other than the Euro as the Bank Currency in Payment rows to the Supplier), you may need to specify an Exchange Rate Contract Number in that Supplier's Bank record. This will be exported in the <CtrctId> tag inside <XchgRateInf>.

    5. For your Suppliers' Banks, enter the country in which they are located in the Country field (in two-character ISO 3166 format).

    6. If you will pay a Supplier using the "Foreign" Payment Channel (point 4e below), specify a Clearing Code in that Supplier's Bank. Use the ISO format i.e. five-character country code followed by a bank identifier/clearing number.

  4. In the Contact records for each Supplier:

    1. Enter the Country in which the Supplier is located. This will be exported in the <PstlAdr> tag inside <Cdtr>. If you do not specify a Country, "SE" will be exported in this tag. When you specify the Country, the Payment Channel (point 4e below) will change depending on the VAT Zone in the connected record in the Countries setting.

    2. Enter the Supplier's bank account number in IBAN format including two-character country prefix in the IBAN Code field.

      If the bank account number is not in IBAN format, enter it in the Bank Account or Bank Account 2 fields. For example, if the Payment Channel (step 4e below) of a Supplier is "Bankgiro", enter their Bankgiro number in the Bank Account field. If the Payment Channel of a Supplier is "Bankgiro" or "Postgiro", the Bank Account will be copied to Purchase Invoices and onwards to Payment rows. For other Payment Channels, the IBAN Code will be copied.

    3. Enter the Supplier's Bank in the Account Operator field using 'Paste Special'.

    4. Optionally, enter the BIC (SWIFT) of the Supplier's bank account in the BIC (SWIFT) field. If you do not specify a BIC (SWIFT) in the Contact record for a Supplier, it will be taken from the relevant record in the Banks setting (points 4c and 3b above). For all Payment Channels (point 4e below) a BIC (SWIFT) here or in the Bank record is required if the bank account number is in IBAN format.

    5. Choose a Payment Channel on the 'Accounts' card in the Contact records for each Supplier. The available options are "Bankgiro", "Plusgiro", "Other Domestic", "SEPA Foreign" (i.e. foreign, within the Euro zone) and "Foreign". When you specify a Country (point 4a above), the Payment Channel will be set to "SEPA Foreign" (if the VAT Zone in the connected record in the Countries setting is "Inside EU" or "Inside EU (Post VAT)", to "Foreign" (if the VAT Zone in the connected Country is "Outside EU" or "Outside EU (Post VAT)" or to "Bankgiro" (otherwise or if you do not specify a Country). The Payment Channel will be copied to each Purchase Invoice and from there to each Payment row (flip K).

    6. If the Payment Channel in point 4e above is "Other Domestic", enter the Sort Code of the Supplier's Bank on the 'Accounts' card of their Contact record. This will be copied to each Purchase Invoice and from there to each Payment row (flip H).

    7. If the Payment Channel is "SEPA Foreign" or "Foreign", enter a Payment Code for the Supplier if necessary (i.e. if there will be high-value transactions). This will be copied to each Purchase Invoice and from there to each Payment row (flip H).

  5. In the Payment Modes setting, enter your Bank on flip A of each Payment Mode using 'Paste Special' and ensure the Account (IBAN) is brought into the Bank A/C No field. This step is optional if you have a single bank account.
Payments
  1. Ensure the To Bank A/C on flip H of each row contains the relevant Supplier's bank account number. Usually this will have been copied from the Purchase Invoice being paid. If this field is empty, the Supplier's bank account number will be taken from the IBAN Code, Bank Account or Bank Account 2 fields in the Contact record for the Supplier If the bank account number is not in the IBAN format, the tag <IBAN> in <CdtrAcct> will not be exported and instead the bank account number will be exported in the tag <Othr>.

  2. If there is a Bank Reference in a Payment row (flip H), it will be exported in <RmtInf>. By default, the Bank Reference will have been copied from the Reference in each Purchase Invoice being paid but you can add one or edit the default. If there is no Bank Reference, the Supp. Inv. No. of the Purchase Invoice being paid will be exported. If the Purchase Invoice does not have a Supp. Inv. No. or a payment row is a Prepayment or On Account Payment, the first 50 characters from Text in the Payment row will be exported.

    If you export a Payment on a "Per Supplier" basis (points 8 and 13 below), the <Ustrd> tag will be exported inside . This will contain a text string constructed from the Bank References from each Payment row or, if a Payment row does not have a Bank Reference, from the Supp. Inv. No. of the Purchase Invoice being paid, in the format <Ustrd>Bank Reference 1,Supp. Inv. No. 2,Bank reference 3</Ustrd>. If any Payment row does not have a Bank Reference and the Purchase Invoice does not have a Supp. Inv. No. or if a Payment row is a Prepayment or On Account Payment, the first 50 characters from the Text in the Payment row will be exported (e.g. <Ustrd>Bank Reference 1,Payment Row Text 2,Supp. Inv. No. 3</Ustrd>).

  3. Select "Per Supplier" as the Payment Format on the 'Bank' card if appropriate.

  4. Specify a Payment Channel, Urgency and Bank Fee on flip K of each row in a Payment, using 'Paste Special' in each case. By default, the Payment Channel will be copied from the Purchase Invoice being paid, and in turn the Payment Channel in the Purchase Invoice will be copied from the Contact record for the Supplier (point 4e above).

    If you need to keep SEPA payments separate (i.e. you do not want a Payment to include a row in which the Payment Channel is "SEPA Foreign" together with a row with any other Payment Channel), select the Do not allow mix of SEPA and non SEPA Payment rows option in the Payment Settings setting.

    If the Payment Channel is "Bankgiro" or "Plusgiro", you will not be able to save a Payment if the Urgency in any row is "Same day". If the Payment Channel is "SEPA Foreign" the Urgency in every row must be "Normal".

    The Urgency will be exported in the <SvcLvl> tag as follows:

    • If the Payment Channel is "Bankgiro" or "Plusgiro", the Urgency will not be used and "MPNS" (if the Payment File Format is ISO20022 SEB, Nordea) or "NURG" (if the Payment File Format is ISO20022 Handelsbanken) will be exported in the tag <Prtry>.

    • If the Payment Channel is "SEPA Foreign", the Urgency will not be used and "SEPA" will be exported in the tag <Cd>.

    • If the Urgency is "Normal" or "Same day", the Payment Channel is "Other Domestic" and the Supplier's bank account number is in IBAN format or has a BIC (SWIFT), "MPNS" will be exported in the tag <Prtry> (if the Payment File Format is ISO20022 SEB, Nordea) or "NURG" will be exported in the tag <Cd> (if the Payment File Format is ISO20022 Handelsbanken).

    • If the Urgency is "Normal" or "Same day", the Payment Channel is "Other Domestic", and the Supplier's bank account number is not in IBAN format and does not have a BIC (SWIFT), NURG" will be exported in the tag <Cd>.

    • If the Urgency is "Normal" or "Same day" and Payment Channel is "Foreign", "NURG" will be exported in the tag <Cd>.

    • If the Urgency is "Express", "URGP" will be exported in the tag <Cd>.

    If the Urgency is "Same day" and the Payment Channel is not "SEPA Foreign", the <SvcLvl> tag will be followed by "SDCL" inside <LclInstrm>. If the Urgency is "Normal" or "Same day", "SUPP" will then be exported inside <CtgyPurp>.

    If the Payment Channel is not "SEPA Foreign", Bank Fees of "Shared", "Supplier pays" and "We pay" will cause "SHAR", "CRED" and "DEBT" respectively to be exported in the tag <ChrgBr>.

    If the Payment Channel is "SEPA Foreign" or "Foreign", any Payment Code specified on flip H together with its Description from the Payment Codes setting will be exported in the tag <Dtls> inside <RgltryRptg>.

Exporting
  1. If you specify a Currency in the specification window, only Payment rows with that Currency as Bank Currency will be exported.

  2. Select Pay on Due Date if appropriate. If you select this option, the later of the Payment Date from the Payment and the current date will be exported in the tag <ReqdExctnDt>. Otherwise, the current date will be exported. You can use the Payment Settings setting to choose whether the Pay on Due Date option in the specification window will be selected by default.

  3. If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier or Batch Booking in the 'Specify Banking File' window if you want those rows to be grouped together as a single payment in the export file. If you select either of these options, all Payments will be exported on a One Payment per Supplier basis. If you do not select either of them, only those Payments where the Payment Format is "Per Supplier" (point 7 above) will be exported on that basis.

  4. If you select the Unexported Only option in the 'Specify Banking File' window, Payments in the range that have not been marked as Ordered and those that have been marked as Ordered will be exported. Payments that have been marked as OK will not be exported. After the export process, any unordered Payments in the range will be marked as Ordered automatically. If you need to export a Payment that has been marked as OK, select the All option in the 'Specify Banking File' window but be careful when specifying the range of Payments to be exported as any Payments in the range that have previously been exported will be exported again. Payments and individual Payment rows that have been invalidated will never be exported.
---

Export functions in the Purchase Ledger and Integration modules:

Go back to:

Eelmine   Järgmine   Algusesse            Prindi kogu peatükk