Language:


Banking File - Italy - 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 Italy - SEPA Payment File Format, for domestic payments.

Configuration

  1. In the Company Info setting:

    1. Ensure the Company Name and VAT Reg. No. are correct.

    2. Fill in the E-Invoice Account and Bank 1 fields. The Bank 1 field should contain the ABI code of your 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 you have not specified an Account (IBAN) in the record in the Banks setting representing the Bank from where you will issue payments (steps 2b and 4 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. For your own Bank, enter the Account (IBAN).

  3. In the Contact records for each Supplier:

    1. Enter the Supplier's company registration number in the Reg. No. 1 field.

    2. Enter the Supplier's bank account number in the IBAN Code field.

    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 A of each Payment Mode using 'Paste Special'.
Payments
  1. If there is a Bank Reference in a Payment row (flip H), it will be exported in the tag <Ustrd> inside <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. It is the comment that will be visible to the Supplier. If a Payment row does not have a Bank Reference, the Reference or, if that is blank, the Supp. Inv. No. of the Purchase Invoice being paid will be exported.

    If you export a Payment on a "Per Supplier" basis (points 6 and 8 below), a text string constructed from the Bank References in each Payment row paying a particular supplier will be exported in <Ustrd> inside <RmtInf>. In effect this text string will list the Bank References of the Purchase Invoices being paid, using the format <Ustrd>/Bank Reference 1/Bank Reference 2</Ustrd>. If a Payment row does not have a Bank Reference, the Reference or, if that is blank, the Supp. Inv. No. of the Purchase Invoice being paid will be exported instead (e.g. <Ustrd> /Supp. Inv. No. 1/Bank Reference 2</Ustrd>).

  2. Select "Per Supplier" as the Payment Format on the 'Bank' card if appropriate.
Exporting
  1. Select Pay on Due Date in the 'Specify Banking File' window 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.

  2. 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 6 above) will be exported on that basis.

  3. Do not select the Foreign Country Payment option in the 'Specify Banking File' window, because the resulting file will not contain any payments.

  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: