Import debit mandates (Belgium)

You can import existing debit mandates for Belgian debtors, Belgian DOM80 mandates, using two default import definitions supplied by Profit. You must use this functionality if you use 'direct debit' and you want to reuse your existing mandates for SEPA 'direct debit' in Profit.

You must reuse Belgian DOM80 mandates for SEPA 'direct debiting' by including the features of the DOM80 mandate in the first delivery. Belgian collectors can request a migration file of their current debtor mandates from the Belgian National Bank (NBB). In order to be able to deliver the data from these DOM80 mandates with the first SEPA collection for the debtor, you need to import this file. For each DOM80 mandate in the migration file, the import creates a 'Standard continuous' debit mandate and enters the central 'direct debit' mandate features in the history fields of the debit mandate. You require this data for delivery in the first SEPA collection file.

Until the transition to SEPA on 1 February 2014, all Belgian debit mandates are held in a central register. This differs from the SEPA regulations in which the collector is responsible for the administration of debit mandates. For the conversion of DOM80 mandates to SEPA collection mandates, a number of steps apply:

  1. Before you perform the steps below, you must first perform the steps described in the standard procedure Configure automatic collection with SEPA.
  2. Obtain the migration file with DOM80 mandates from the NBB.
  3. You import this file using the default import definition supplied with Profit. View/check the debit mandates. After this, you can collect.

    Note:

    The menu item General / Financial / Management / Import / Collection mandate  can be authorised using the Authorisation tool.

To import debit mandates:

  1. Go to: Financial / Management / Import debtor and creditor / Collection mandate.
  2. Select Import definition addition (through a delivered file):
  3. Click on: Next.
  4. Select the file with extension .IPD to be imported.

    The continuous mandates to be imported are ‘matched’ with the debtors from the environment.

    You have two different import definitions:

    • Begin with the import definition: 1e Stap incassomachtigingen (Dom).ipd. This checks on 'direct debit' number.
    • Then use 2e Stap incassomachtigingen (IBAN).ipd. This checks on IBAN number.

    You have two import definitions because the mandates to be imported that are in the NBB file can be accessed using 'direct debit' number and also IBAN number. For a complete import, you need to run both import definitions.

    You start with the import definition Step 1. You can try to import any lines ending up in the error file once again by performing Step 2. All the remaining lines contain mandates that cannot be matched with debtors in Profit. You can check these mandates yourself and perhaps add them to your debtors manually.

    The import definitions (the .IPD files) are available as a file, for example, in the following folder (depending on your operating system):

    \Documents and Settings\All Users\Application Data\Profit\AFAS Data\Environments\<Environment name>\Units\Omgevingsnaam\Kernel\Import

To view and check debit mandates:

You can view the imported debit mandates.

  1. Go to: Financial / Debtor / Collection mandate.
  2. Open the properties of the debit mandate.
  3. Go to the tab: Management.

    The DOM80 data can be found on this tab of the debit mandate. Because a difference exists between Collector ID (old) and Collector ID and between Mandate feature (old) and Mandate feature after the import, Profit automatically delivers a 'change' of mandate data with the SEPA file. This conforms with the 'Febelfin' specification and you are not required to undertake any further manual action.

    When the first SEPA collection transaction is entered on the debtor's account, Profit will automatically ensure that, as from the next collection transaction of the debtor, only the SEPA data is still delivered. You can see this on the Management tab in the Debit Mandate properties. The DOM80 data in Collector ID (old) and Mandate feature (old) is overwritten with the SEPA data. There is no longer a difference between the 'old' data and the data 'now applicable'. Profit therefore does not deliver a 'change mandate'.

  4. For more information, refer to the procedure described in view debit mandates.

After this, you can collect.

See also

Directly to

  1. Configure automatic collection with SEPA
  2. Authorise collection
  3. Authorise partial collection
  4. Add the Payments in transit suspense account
  5. Add a collection reduction account
  6. Add a general journal for payments in transit
  7. Record the collector ID and administration settings for SEPA collection
  8. Configure the bank account number for automatic collection
  9. Mandate forms report layout
  10. Configure sales contact profile for mandate forms report layout
  11. Configure debtor for automatic collection via SEPA
  12. Add a payment condition with collection instalments
  13. Import debit mandates
  14. Import debit mandates (Belgium)
  15. Configure a bank link for internet banking (AFAS Online)