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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.4  

Banking File - Sweden

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 various Swedish bank 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.

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 http://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 D 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 http://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 http://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.

Sweden - SEPA

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. Enter your company's address in the first two Address fields. Both fields must be filled in for the address and country to be exported.
      

   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 is blank (step 4 below), 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 Banks setting:
   
   1. Enter a separate record for each Bank used by your Suppliers, and one for your own Bank.
      

   2. For your own Bank, specify a BIC (SWIFT) and enter the Account (IBAN). Enter your Signer ID in the Factoring Type Code field (this will be exported in the <Id> tag (inside <InitgPty>)) and your Contract ID in the Bank ID Code field (this will be exported in the <Id> tag (inside <Dbtr>)).
      

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

   4. If a Supplier's Bank is not in your country, specify a BIC (SWIFT) in their Bank record, and enter the word "Foreign" in the Sort Key field.
      

   5. For your Suppliers' Banks, enter the country in which they are located in the Country field (in two-character ISO 3166 format).
   
   
3. In the Contact records for each Supplier:
   
   1. Enter the address ensuring that you use the second and third Invoice Address fields. Both fields must be filled in for these address lines and the country to be exported (in the <PstlAdr> tag inside <Cdtr>). For domestic Suppliers, the second Address field should consist of the post code and the town. The country will be taken from the prefix in the Supplier's IBAN.
      

   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, and enter the Supplier's country in the Country field (in two-character ISO 3166 format).
      

   3. Enter the Supplier's Bank in the Account Operator field using 'Paste Special'.
   
   
4. In the Payment Modes setting, enter your Bank on flip D of each Payment Mode using 'Paste Special' and ensure the Account (IBAN) is brought into the Bank A/C No field on flip A.

Payments

5. Ensure the To Bank A/C on flip H of each row contains the relevant Supplier's IBAN. 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>.
   

6. If you add a Bank Reference to a Payment row (flip H), it will be exported in the tag <Ref> inside <RmtInf>. The Bank Reference will be copied from the Reference in each Purchase Invoice being paid. If there is no Bank Reference, the <Ref> tag will not be exported, and instead the Supp. Inv. No. of the Purchase Invoice being paid will be exported in the tag <Ustrd> (also inside <RmtInf>). If the Purchase Invoice does not have a Supp. Inv. No., the text "TRANSFER" will be exported in <Ustrd>.
   

   If you export a Payment on a "Per Supplier" basis (points 7 and 9 below), the export function will check each row paying a particular Supplier for a Payment Code or Bank Reference (both on flip H, and both will have been copied from each Purchase Invoice). The first Payment Code or Bank Reference that it finds will be exported in the <Ref> tag. If no row has a Payment Code or Bank Reference, the <Ustrd> tag be exported instead. It will contain a text string constructed from the Supp. Inv. Nos. of each Purchase Invoice, in the format Invoice No.: Supp. Inv. No, 1, Supp. Inv. No. 2. If any Purchase Invoice does not have a Supp. Inv. No. or if a Payment row is a Prepayment or On Account Payment, the text "TRANSFER" will be exported (e.g. <Ustrd>Invoice No.: TRANSFER, Supp. Inv. No. 2</Ustrd>).
   

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

Exporting

8. Select "Shared" as the Bank Fees option in the 'Specify Banking File' window if appropriate. This will cause "SLEV" to be exported in the tag <ChrgBr>. You can use the Payment Settings setting to choose which option in the specification window will be selected by default.
   

9. If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier 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 this option, all Payments will be exported on a One Payment per Supplier basis. If you do not select it, only those Payments where the Payment Format is "Per Supplier" (step 7 above) will be exported on that basis.
   

10. If a Payment record contains a row paying an international Supplier, the BIC (SWIFT) of the Supplier's bank will be exported in the tag <BIC> inside <FinInstnId> inside <CdtrAgt>. The payment to an international Supplier will be detected by comparing the country prefix in your IBAN (in the Company Info setting) with that in the Supplier's IBAN. If the Supplier does not have an IBAN, the country prefix in your IBAN will be compared with the Country in the Supplier's Bank record or in the Contact record for the Supplier. The Supplier's country will be exported in the tag <Ctry> inside <Dtls> inside <RgltryRptg>. These tags will not be exported when paying domestic Suppliers, unless you select Foreign Payment in a particular Payment record. Do not select Foreign Country Payment in the 'Specify Banking File' window, because the resulting file will not contain any payments.

---

Export functions in the Purchase Ledger and Integration modules:

• Introduction
  

• Banking File, including:
  
  • Australia - ABA
    

  • 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)
    

  • Estonia - Riigikassa
    

  • Finland - SEPA
    

  • Germany - SEPA
    

  • Hungary - HVB
    

  • 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 SEPA)
    

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

  • Spain - SEPA
    

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

  • 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