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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 2024-03-16  

Banking File - Sweden - Handelsbanken, Nordea, PostGirot, SE-Banken and Swedbank

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 Handelsbanken, Nordea, PostGirot, SE-Banken and Swedbank Swedish bank Payment File Formats. Please refer here for details about the ISO20022 SEB, Nordea and ISO20022 Handelsbanken Payment File Formats.

Sweden - Handelsbanken, Sweden - Nordea, Sweden - SE-Banken and Sweden - Swedbank
Foreign Country Payment not selected - Domestic Payments

Configuration

1. In the Contact records for each domestic Supplier:
   
   1. Enter the Supplier's bank account number in the Bank Account or Bank Account 2 field. If the Supplier's bank account is held at the bank selected as the Payment File Format, enter the Supplier's bank account number in the Bank Account 2 field. Otherwise, enter it in the Bank Account field. For example, if the Payment File Format is Sweden - Nordea and the Supplier's bank account is held at the Nordea bank, use the Bank Account 2 field. If it is held at a different bank, use the Bank Account field. If the Payment File Format is Sweden - Swedbank and the Supplier's bank account is held at Swedbank, use the Bank Account 2 field. and so on.
      

   2. If you enter a Reference for a Supplier, it will be copied to each Purchase Invoice and exported from there.
   
   
2. In the Payment Modes setting, enter your bank account number in the Bank A/C No. field in each Payment Mode.

Purchase Invoices

3. Specify a Reference or a Supp. Inv. No. in each Purchase Invoice.

Payments

4. Information will be exported in different formats depending on whether the Supplier's bank account is held at the bank selected as the Payment File Format. This is determined by checking whether the To Bank A/C in a Payment row is the same as the Bank Account (account at a different bank) or the Bank Account 2 (account at the same bank) in the Contact record for the Supplier. If the To Bank A/C in a row does not match either of the Bank Accounts in the Contact record, the row will not be exported correctly. Therefore, you should not change the To Bank A/C in any Payment row.

Exporting

5. For a Payment row to be exported, the To Bank A/C must not be blank.
   

6. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).
   

7. Select Pay on Due Date in the 'Specify Banking File' window if appropriate. Selecting this option will cause the later of the Payment Date and the Due Date of the Purchase Invoice being paid to be exported for each Payment. Otherwise, the Payment Date of each Payment will be exported.
   

8. 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.

Sweden - Handelsbanken
Foreign Country Payment selected - International Payments

Configuration

1. 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.
      

   3. For your own Bank, enter the Account (IBAN) of your bank account.
      

   4. For your Suppliers' Banks, specify a Clearing Code (use the ISO format i.e. five-character country code followed by a bank identifier).
   
   
2. In the Payment Codes setting, enter Payment Codes as listed at https://www.skatteverket.se.
   

3. In the Bank Transfer setting, enter an N/L Method and a Contract. The N/L Method will be exported in RT6 position 80 and, if the N/L Method is "T", the Contract will be exported in RT6 positions 45-54.
   

4. In the Contact records for each international Supplier:
   
   1. Enter the address using the first, second and third Address fields.
      

   2. Enter the Supplier's bank account number in the IBAN Code field or, if it is not in IBAN format, in the Bank Account field. The IBAN format is recommended for cross-border payments within Europe, and mandatory for payments in EUR within the EU, EES and Switzerland.
      

   3. In the Sort Code field, enter the two-character ISO 3166 Country Code of the country where the Supplier's bank is located. Using the Sort Code field for this purpose allows a Supplier and its bank to be located in different countries.
      

   4. If you enter the Supplier's Bank in the Account Operator field using 'Paste Special'. the Clearing Code and BIC (SWIFT) will be exported from that Bank record to RT4 positions 44-67 and 68-78 respectively. In this case, the Supplier's bank account number in (b) above should be in IBAN format because "BP" will be exported in positions 79-80.
      

      Otherwise, you should enter the Clearing Code in the Bank Account 2 field and the BIC (SWIFT) in the Account Operator field, to be exported in RT4 positions 44-67 and 68-78 respectively.
      

   5. If you enter a Payment Code for a Supplier, it will be copied to each Purchase Invoice and from there to each Payment row.
      

   6. If you enter a Reference for a Supplier, it will be copied to each Purchase Invoice and from there to the Bank Reference field in each Payment row (flip H).
   
   
5. In the Payment Modes setting:
   
   1. Enter your bank account number in the Bank A/C No. field in each Payment Mode (Bankgiro number).
      

   2. Enter "SE" in the Sort Code field.
      

   3. Enter your Bank on flip A using 'Paste Special'.

Purchase Invoices

6. Specify a Supp. Inv. No. in each Purchase Invoice.

Payments

7. Ensure each Payment row has a Payment Code and a Bank Reference (both flip H).

Exporting

7. For a Payment row to be exported, the To Bank A/C must not be blank.
   

8. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).
   

9. Select the appropriate Bank Fees option in the 'Specify Banking File' window. "9" will be exported in RT3 position 78 if We Pay is selected, "1" if Suppliers Pay is selected or "0" otherwise. You can use the Payment Settings setting to choose which option in the specification window will be selected by default. "0" is the most common option.
   

10. Select the appropriate Pay Method option in the 'Specify Banking File' window. "T" will be exported in RT3 position 79 if Express or Extra Urgent is selected, "C" if Normal is selected and the Type of the Payment Mode is "Received Cheques" or "Own Cheques", or "B" otherwise.

Sweden - Nordea and Sweden - SE-Banken
Foreign Country Payment selected - International Payments

Configuration

1. In the Company Info setting:
   
   1. Ensure the Company Name is correct.
      

   2. Enter your company's address in the first three Address fields.
   
   
2. 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.
      

   3. For your own Bank, enter the Account (IBAN) of your bank account.
      

   4. For your Suppliers' Banks, specify a Clearing Code (use the ISO format i.e. five-character country code followed by a bank identifier), and the Supplier's Account Number in IBAN format in the Account (IBAN) field. This means you will need a unique Bank record for each Supplier.
   
   
3. In the Contact records for each international Supplier:
   
   1. Enter the address using the first, second and third Address fields.
      

   2. Enter the country where the Supplier is located in the Country field (two-character ISO 3166 format).
      

   3. The Nordea and SE-Banken exports do not use the Payment Code field or the Payment Codes setting. Instead you should enter a three-character payment code for each Supplier in the Sort Code field, referring to the list at https://www.skatteverket.se. It will be copied to each Purchase Invoice and from there to each Payment row (exported in RT7 positions 9-11).
      

   4. If you enter the Supplier's Bank in the Account Operator field using 'Paste Special'. the BIC (SWIFT), Account (IBAN) and Clearing Code will be exported from that Bank record to RT4 positions 9-20, 21-50 and 51-80 respectively.
      

      Otherwise, you should enter the BIC (SWIFT) in the Account Operator field, the Supplier's bank account number in the Bank Account field and the Clearing Code in the Bank Account 2 field, to be exported in RT4 positions RT4 positions 9-20, 21-50 and 51-80 respectively.

4. In the Payment Modes setting, enter your bank account number in the Bank A/C No. field in each Payment Mode.

Purchase Invoices

5. Specify a Supp. Inv. No. in each Purchase Invoice.

Payments

6. Ensure each Payment row has a Sort Code (i.e. payment code).

Exporting

7. For a Payment row to be exported, the To Bank A/C must not be blank.
   

8. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).
   

9. Select Bank 1 or Bank 2 as appropriate in the 'Specify Banking File' window. "0" will be exported in RT3 position 74 if Bank 1 is selected or "1" if Bank 2 is selected (Sweden - SE-Banken only, Sweden - Nordea will create an empty file if Bank 2 is selected).
   

10. Select the appropriate Bank Fees option in the 'Specify Banking File' window. "2" will be exported in RT3 position 78 if We Pay is selected or "0" otherwise. You can use the Payment Settings setting to choose which option in the specification window will be selected by default.
    

11. Select the appropriate Pay Method option in the 'Specify Banking File' window. "1" will be exported in RT3 position 80 if Express is selected or "0" otherwise.

Sweden - Swedbank
Foreign Country Payment selected - International Payments

Configuration

1. 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.
      

   3. For your own Bank, enter the Account (IBAN) of your bank account.
      

   4. For your Suppliers' Banks, specify a Clearing Code (use the ISO format i.e. five-character country code followed by a bank identifier), and the Supplier's Account Number in IBAN format in the Account (IBAN) field. This means you will need a unique Bank record for each Supplier.
   
   
2. In the Contact records for each international Supplier:
   
   1. Enter the address using the first, second and third Address fields.
      

   2. Enter the country where the Supplier is located in the Country field (two-character ISO 3166 format).
      

   3. The Swedbank export does not use the Payment Code field or the Payment Codes setting. Instead you should enter a three-character payment code for each Supplier in the Sort Code field, referring to the list at https://www.skatteverket.se. It will be copied to each Purchase Invoice and from there to each Payment row (exported in RT7 positions 9-11).
      

   4. If you enter the Supplier's Bank in the Account Operator field using 'Paste Special'. the BIC (SWIFT), Account (IBAN) and Clearing Code will be exported from that Bank record to RT4 positions 9-20, 21-50 and 51-80 respectively.
      

      Otherwise, you should enter the BIC (SWIFT) in the Account Operator field, the Supplier's bank account number in the Bank Account field and the Clearing Code in the Bank Account 2 field, to be exported in RT4 positions RT4 positions 9-20, 21-50 and 51-80 respectively. In this case, no payment code will be exported unless you enter them in the Bank Code fields in Purchase Invoices yourself.

3. In the Payment Modes setting, enter your bank account number in the Bank A/C No. field in each Payment Mode.

Purchase Invoices

4. Specify a Supp. Inv. No. and a Bank Code (i.e. payment code) in each Purchase Invoice.

Exporting

5. For a Payment row to be exported, the To Bank A/C must not be blank.
   

6. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).
   

7. Select the appropriate Bank Fees option in the 'Specify Banking File' window. "2" will be exported in RT3 position 78 if We Pay is selected or "0" otherwise. You can use the Payment Settings setting to choose which option in the specification window will be selected by default.
   

8. Select the appropriate Pay Method option in the 'Specify Banking File' window. "1" will be exported in RT3 position 80 if Express is selected or "0" otherwise.

Sweden - PlusGirot (Domestic Payments only)

Configuration

1. In the Company Info setting:
   
   1. Ensure the Company Name and Telephone Number are correct.
      

   2. Enter your Customer Number at PlusGirot in the Bank Customer ID field.
      

   3. Enter your bank account number in the Bank 2 field.: this will be used if the Bank A/C No. field in a Payment Mode is empty.
   
   
2. In the Contact records for each Supplier:
   
   1. Enter the Supplier's bank account number in the Bank Account or Bank Account 2 field. If the Supplier's bank account is a PlusGirot account, enter the Supplier's bank account number in the Bank Account 2 field. Otherwise, enter it in the Bank Account field.
      

   2. If you enter a Reference for a Supplier, it will be copied to each Purchase Invoice and exported from there.
   
   
3. In the Payment Modes setting, enter your bank account number in the Bank A/C No. field in each Payment Mode.

Purchase Invoices

4. Specify a Reference or a Supp. Inv. No. in each Purchase Invoice.

Payments

5. Information will be exported in different formats depending on whether the Supplier's bank account is a PlusGirot account. This is determined by checking whether the To Bank A/C in a Payment row is the same as the Bank Account (account is not a PlusGirot account) or the Bank Account 2 (account is a PlusGirot account) in the Contact record for the Supplier. If the To Bank A/C in a row does not match either of the Bank Accounts in the Contact record, the row will not be exported correctly. Therefore, you should not change the To Bank A/C in any Payment row.

Exporting

6. A Payment record will only be exported if the Currency in the footer is SEK, EUR or blank.
   

7. A Payment row will only be exported if the I. Cur. on flip B is SEK, EUR or blank.
   

8. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).
   

9. Select Pay on Due Date in the 'Specify Banking File' window if appropriate. Selecting this option will cause the Due Date of the Purchase Invoice being paid to be exported for each Payment. Otherwise, the Payment Date of each Payment will be exported. In both cases, if the date is in the past, the current date will be exported.
   

10. Specify a single-digit Prod. No. in the specification window, to be exported as character 13 in the first line of the export file. If you leave the field blank, "1" will be exported. You can set a default value for this field in the Bank Transfer setting.
    

11. If you select the Unexported Only option in the 'Specify Banking File' window, Payments in the range that have been marked as Ordered will be exported. Payments that have been marked as OK will not be exported. 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 that have not been marked as Ordered will not be exported. Payments and individual Payment rows that have been invalidated will also not be exported

---

Export functions in the Purchase Ledger and Integration modules:

• Introduction
  

• Banking File, including:
  
  • Australia - ABA
    

  • Croatia (Croatia - SEPA)
    

  • Czech banking file formats (includes Czech - ABO and Czech - CITI bank)
    

  • Danish banking file formats (includes BGBank, Den Denske Bank, Jyske Bank, Midtbank, SYDBANK and Unibank)
    

  • Estonian banking file formats (includes Riigikassa and Swedbank Gateway)
    

  • Finnish banking file formats (includes SEPA pain 002 and SEPA pain 003)
    

  • Germany - SEPA
    

  • Hungary - HVB
    

  • Italy - SEPA
    

  • Latvian banking file formats (includes FidaVista and SEPA)
    

  • Lithuanian banking file formats (includes LITAS-ESIS 1.1 and SEPA)
    

  • Namibia
    

  • New Zealand banking file formats (includes ANZ, ASB, BNZ, KiwiBank, National Bank and Westpac)
    

  • Norwegian banking file formats (includes DnB Telepay, K-Link, SparNett, Postbanken, Telepay 2 and ISO20022)
    

  • Polish banking file formats (includes Elixir, ING Bank and Reiffaisen Bank)
    

  • South Africa - First National Bank
    

  • Spain - SEPA
    

  • Swedish banking file formats - part 1 (includes Handelsbanken, Nordea, PostGirot, SE-Banken and Swedbank)
    

  • Swedish banking file formats - part 2 (includes ISO20022 SEB, Nordea and ISO20022 Handelsbanken)
    

  • UK - BACS
  
  
• Intrastat Purchase Invoices UK
  

• Open Purchase Invoices
  

• P/L Liquidity List

Go back to:

• Home page for Purchase Ledger manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form