background

How to import transactions / refunds

Tags:transactionsimportrefundstransactietransactiesterugbetaling
Show me

You can import transactions using a CSV file in two different ways:

Anywhere in your Twikey environment, you can access the import function on top of the page.

  1. Global Import:
    • Anywhere in your Twikey environment, you can access the import function at the top of the page.
    • Click the button and select Import.
    • On the import page, select "Transactions" from the dropdown menu, choose the format (CSV), and upload your file.
    • The transactions will automatically be placed in a batch according to their profile, where they can be prepared for collection.

  1. Transactions Menu:
    • Go to the "To Be Sent" screen/overview in the transactions menu.
    • Click the button
      and upload your file.

Import CSV file with transactions

This allows you to upload a set of separate transactions to your environment. After the upload, these transactions can be found in the Transactions tab of the agreement.

Import CSV file with refunds (linked to a mandate)

Negative transactions can be uploaded as well; transactions with a negative amount will be processed as a refund and linked to the given mandate. After the upload, these refunds can be found in the Refunds section.

Refunds can also be imported only linked to a customer, see ()[]

 
  • Uploading refunds for recurring credit card agreements is not supported.
  • If it concerns CORE mandates, the risk is up until 8 weeks, so don't refund to quick.
  • Automated refunds is not for all banks !

    • Required Fields

    mandateNumberThe mandate reference
    valueThe amount of the transaction, e.g. 12.36 or 12,36
    msgThe communication to the debtor

    Optional Fields

    refYour reference
    placePlace of the transaction
    reqcolldtRequested collection date. When this is not passed, we collect the transaction as soon as possible (YYYY-MM-DD).
      Once the file is imported the transactions are placed in a batch and need to be sent to the bank in order to collect the transactions.

    Updates

    Importing a file using the same transaction references to update existing ones, is not possible. This will create new transactions.

    Import CSV file with refunds (linked to a customer)

    Refunds can also be uploaded when a customer has no mandate.
    For this set the import type to refunds.

    Required Fields

    customerNumberThe customer reference
    ibanThe IBAN account
    bicThe BIC number of the IBAN
    valueThe amount of the refund, e.g. 12.36 or 12,36
    msgThe communication to the debtor

    Optional Fields

    refYour reference
    placePlace of the transaction
    reqcolldtRequested collection date. When this is not passed, we collect the transaction as soon as possible (YYYY-MM-DD).
      Once the file is imported the transactions are placed in a batch and need to be sent to the bank in order to collect the transactions.

    Template file

      Tip: Some editors format certain values to your local settings when opening a CSV file (e.g. MS Excel)
    Verify the file's content, or use another editor before uploading it in Twikey.

    Unable to import transactions

    Here you can find some common errors and causes when you are unable to import transactions:

    • Invalid SEPA character: The file includes characters that are not accepted.
    • Invalid amount: Ensure the amounts are formatted as a number
    Last Update: 2023-11-15