Language:


Banking File - Spain - SEPA

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 Spain - SEPA Payment File Format.

Foreign Country Payment not selected - Domestic Payments


Configuration
  1. In the Company Info setting:

    1. Ensure the Company Name is correct.

    2. Enter your company's address in the first two Address fields (street in the first field, post code and town in the second field) and the Country field. The Country must use the two-character ISO 3166 format (i.e. "ES"). All three fields must be filled in for the address to be exported.

    3. Optionally enter a Bank Customer ID. This will be used if the Bank ID Code in a Bank record is blank (point 2c below).

  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), Bank ID Code (i.e. business ID or customer number at the bank) and, if you will be sending Payments in Currencies other than the Euro, an Exchange Rate Contract Number.

    4. If a Bank is outside the EU, specify a Clearing Code (use the ISO format i.e. five-character country code followed by a bank identifier), up to four lines of address and a Country (two-character ISO 3166 format).

  3. In the Contact records for each domestic Supplier:

    1. Enter the address using the second and third Invoice Address fields (street in the second field, post code and town in the third field) and the Country field (Country must use the two-character ISO 3166 format). All three fields must be filled in for the address to be exported.

    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 or Bank Account 2 fields.

    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'.
Payments
  1. Add a Bank Reference to each Payment row (flip H). This will be copied from the Reference in each Purchase Invoice being paid, and is the comment that will be visible to the Supplier. If a Payment row does not have a Bank Reference, the Supp. Inv. No. will be exported.

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

  3. Select "Express" or "Extra Urgent" as the Payment Method if appropriate.
Exporting
  1. Select "Express" or "Extra Urgent" as the Pay Method in the 'Specify Banking File' window if appropriate. This will cause "URGP" to be exported in the tag <Prtry> in <SvcLvl>. If selected, all Payments will be exported as "URGP". If not selected, only those Payments marked "Express" or "Extra Urgent" in step 7 above will be exported as "URGP".

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

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

  4. If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier if you want those rows to be grouped together in the export file. If selected, all Payments will be exported on a One Payment per Supplier basis. If not selected, only those Payments where the Payment Format is Per Supplier (step 6 above) will be exported on that basis.

  5. When a Payment is exported on a "Per Supplier" basis, the <Ustrd> tag will contain a long text string made up of references to each Purchase Invoice being paid. Usually, the Bank Reference from flip H of each Payment row will be exported in this tag in the format RFS//Bank Reference 1/Bank Reference 2. If there is no Bank Reference and you are using the Export Supplier Invoice Number option in the Bank Transfer setting, the Supp. Inv. No. of the Purchase Invoice being paid will be exported instead (e.g. RFS//Supp. Inv. No. 1/Bank Reference 2). If you are not using this option, the text "TRANSFER" will be exported (e.g. RFS//TRANSFER/Bank Reference 2).

  6. Deselect Batch Booking if the payment transactions will be processed separately on the bank side. This option causes "true" or "false" to be exported in the tag <BtchBookg<.

Foreign Country Payment selected - International Payments


Configuration
  1. In the Company Info setting, ensure the Reg. No. is correct.

  2. In the Banks setting:

    1. Enter a separate record for each Bank used by your Suppliers.

    2. Specify a BIC (SWIFT) in each Bank record, and up to three lines of address.

  3. In the Contact records for each international Supplier:

    1. Enter the address using the first three Address fields.

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

    3. Enter the Supplier's bank account number in the IBAN Code field or, if it is not in IBAN format, in the Bank Account or Bank Account 2 fields.

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

  4. In the Payment Modes setting, enter your bank account number in the Bank A/C No. field in each Payment Mode.
Purchase Invoices
  1. Specify a Supp. Inv. No. in each Purchase Invoice.
Exporting
  1. Select the appropriate Pay Method option in the 'Specify Banking File' window. "M" will be exported if Normal is selected or "P" otherwise.
---

Export functions in the Purchase Ledger and Integration modules:

Go back to: