Import debit mandates

You can import debit mandates. You can use an import to change debit mandates (for example, change the date, status, feature) and revoke them.

You can import multiple mandates per debtor and even per bank account number.

  • If the import file contains a mandate, which the debtor in question already has then it is overwritten by the mandate from the import file. The status of the mandate becomes Active.
  • If multiple debtors are found who use the same bank account number then the line is rejected. The error information identifies the debtors.

    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. Next, you proceed with importing using the wizard.

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

  3. Select which debtor field is to be used for the matching in Compare organisation on.

    You can compare by: Organisation/person, CoC number, VAT Number, IBAN number, Name (debtor), DebtorNumber, Direct debit number (only applies to Belgium).

    You can compare by: DebtorNumber+IBAN number if debtors are present with multiple bank accounts for which the same reference is used and you want to use the import to change the reference of the debit mandate (to a unique reference for a certain combination of debtor + bank account). In that case, the import action should import the debtor number into the Compare on field and the IBAN number into the IBAN number field.

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)