QFILE Checkout Automated

As a browser-based web interface, QFILE Checkout Automated is intended for your non real-time critical applications such as catalog orders, recurring payments and subscriptions. The payment details of your consumers are prepared in tabular format, uploaded and automatically processed.

All transactions are available in the QPC Payment Center. Currently we support payments via Credit Card and SEPA Direct Debit, and refund and recurring as back-end operations.

Detailed information in German for using this product: Bedienungsanleitung in Deutsch

Demo access for testing purposes
URL	https://portal.qenta.com/automated/
Username	test
Password	jcv45z

Demo access for testing purposes

URL

https://portal.qenta.com/automated/

Username

test

Password

jcv45z

Uploading payment details

First, you need to create a transaction file which includes all your necessary payment data. Remember to meet the format requirements described later in this chapter. If you use an xls-file you need to convert the file into a tab-delimited text file since otherwise the transactions will not be uploaded.

After successful login, QFILE Checkout Automated opens and you may select and upload the relevant file which is then automatically processed.

Example of an xls-file to upload in QFILE Checkout Automated: Request example

Defining the file format

The max. number of uploaded transaction must not exceed 3000 transaction per file. The max. file size must not exceed 2 MB.
Before uploading the file remember to convert the xls-file into a tab-delimited text file since otherwise the transactions are not recognized and not uploaded.
If your consumer is a company instead of a private person, enter Firma or Fa in the column "First name" and the relevant company's name in the column "Last name".

Please use the following format for uploading the payment details of your customers and remember that the number of headers must correspond exactly to the number of columns (except for the column for the customer statement, which is optional and can therefore be omitted):

Credit Card (8-9 columns)

Credit card number	Expiration date	CVC	Currency	Amount	First name	Last name	Number ^[1]	Customer statement ^[2]
9500000000000001	12/2022	Has to be empty.	EUR	109,91	Max	Mustermann	12345
9400000000000003	05/2023	Has to be empty.	USD	44,60	Ingrid	Wantsall	263547
9200000000000007	04/2021	Has to be empty.	GBP	22,75	Sue	Shoppingmaster	2534
9500000000000002	12/2023	Has to be empty.	EUR	42,23	Lisa	Kaufrausch	54321	ONr.54321 payment

Credit card number

Expiration date

CVC

Currency

Amount

First name

Last name

Number ^[1]

Customer statement ^[2]

9500000000000001

12/2022

Has to be empty.

EUR

109,91

Max

Mustermann

12345

9400000000000003

05/2023

Has to be empty.

USD

44,60

Ingrid

Wantsall

263547

9200000000000007

04/2021

Has to be empty.

GBP

22,75

Sue

Shoppingmaster

2534

9500000000000002

12/2023

Has to be empty.

EUR

42,23

Lisa

Kaufrausch

54321

ONr.54321 payment

Direct Debit without SEPA (9 columns)

Bank name	Bank country	Bank code	Account number	Currency	Amount	First name	Last name	Number
Wirecard Demobank	AT	12345	123456	EUR	1	Max	Mustermann	12342

Bank name

Bank country

Bank code

Account number

Currency

Amount

First name

Last name

Number

Wirecard Demobank

12345

123456

EUR

Max

Mustermann

12342

Recurring Transactions (6-8 columns)

Source order number	Currency	Amount	First name	Last name	Number	Customer statement ^[3]	Merchant CRM ID ^[4]
1234567	EUR	112,15	Max	Mustermann	17		7654321
EUR	223,23	Lisa	Kaufrausch	18	ONr.18 recur	7654000	EUR

Merchant CRM ID should have only 40 characters. Strings longer than 40 characters may be truncated.

Refunds (3-4 columns)

Currency	Amount	Number	Customer statement ^[5]
EUR	1	12345
EUR	35	54321	ONr.54321 refund

SEPA Direct Debit, minimum (8 columns)

IBAN	BIC ^[6]	Currency	Amount	First name	Last name	Number	Customer statement ^[7]
DE42512308000000060004		EUR	123,34	Max	Mustermann	21

IBAN

BIC ^[6]

Currency

Amount

First name

Last name

Number

Customer statement ^[7]

DE42512308000000060004

EUR

123,34

Max

Mustermann

SEPA Direct Debit, full (12 columns)

IBAN	BIC	MandateId	MandateSignatureDate	CreditorId	Due date	Currency	Amount	First name	Last name	Number	Customer statement ^[8]
DE42512308000000060004	WIREDEMMXXX	Abo-12345	01.02.2021	AT12ZZZ00000000001	13.02.2021	EUR	12,34	Max	Mustermann	42	My Statement 2

IBAN

BIC

MandateId

MandateSignatureDate

CreditorId

Due date

Currency

Amount

First name

Last name

Number

Customer statement ^[8]

DE42512308000000060004

WIREDEMMXXX

Abo-12345

01.02.2021

AT12ZZZ00000000001

13.02.2021

EUR

12,34

Max

Mustermann

My Statement 2

Downloading the result

After uploading the payment details of your customers, the file is processed. Once processing of the file is completed, the transactions can be downloaded as tab-delimited text file which you may convert back into an xls-file.

Example of an xls-file returned from QFILE Checkout Automated: response_wca-example.txt

The following format is representing the returned transactions. Remember that the number of headers must correspond exactly to the number of columns.

Credit Card (9 columns)

Credit card number	Currency	Amount	First name	Last name	Number ^[9]	Order number ^[10]	Authcode ^[11]	Message
9500000000000001	EUR	109,91	Max	Mustermann	12345	12345	DEMO	Payment OK
9400000000000003	USD	44,6	Ingrid	Wantsall	263547	263547	DEMO	Payment OK
9200000000000007	GBP	22,75	Sue	Shoppingmaster	2534	2534	DEMO	Payment OK

Credit Card with customer statement (10 columns)

Credit card number	Currency	Amount	First name	Last name	Customer statement	Number ^[12]	Order number ^[13]	Authcode ^[14]	Message
9500000000000002	EUR	42,23	Lisa	Kaufrausch	ONr.54321 payment	54321	54321	DEMO	Payment OK

Credit card number

Currency

Amount

First name

Last name

Customer statement

Number ^[12]

Order number ^[13]

Authcode ^[14]

Message

9500000000000002

EUR

42,23

Lisa

Kaufrausch

ONr.54321 payment

54321

DEMO

Payment OK

Direct debit without SEPA (12 columns)

Bank name	Bank country	Bank code	Account number	Currency	Amount	First name	Last name	Number	Order number	Authcode	Message
Wirecard Demobank	AT	12345	123456	EUR	1	Max	Mustermann	12342	12342	DEMO	Payment OK

Bank name

Bank country

Bank code

Account number

Currency

Amount

First name

Last name

Number

Order number

Authcode

Message

Wirecard Demobank

12345

123456

EUR

Max

Mustermann

12342

DEMO

Payment OK

SEPA Direct Debit, minimum (11 columns)

IBAN	BIC	Currency	Amount	First name	Last name	Number	Customer statement	Order number	Authcode	Message
DE42512308000000060004	WIREDEMMXXX	EUR	123,34	Max	Mustermann	21	My statement 1	21	DEMO	Payment OK

IBAN

BIC

Currency

Amount

First name

Last name

Number

Customer statement

Order number

Authcode

Message

DE42512308000000060004

WIREDEMMXXX

EUR

123,34

Max

Mustermann

My statement 1

DEMO

Payment OK

SEPA Direct Debit, full (15 columns)

IBAN	BIC	Mandate Id	Mandate signature date	Creditor Id	Due date	Currency	Amount	First name	Last name	Number	Customer statement	Order number	Authcode	Message
DE42512308000000060004	WIREDEMMXXX	Abo-12345	01.02.2014	AT12ZZZ00000000001	13.02.2014	EUR	12,34	Max	Mustermann	42	My statement 2	0	DEMO	Payment OK

IBAN

BIC

Mandate Id

Mandate signature date

Creditor Id

Due date

Currency

Amount

First name

Last name

Number

Customer statement

Order number

Authcode

Message

DE42512308000000060004

WIREDEMMXXX

Abo-12345

01.02.2014

AT12ZZZ00000000001

13.02.2014

EUR

12,34

Max

Mustermann

My statement 2

DEMO

Payment OK

Recurring transactions (6 columns)

Source order number	Currency	Amount	Order number	Authcode	Message
1234567	EUR	102,15	17	DEMO	Payment OK

Source order number

Currency

Amount

Order number

Authcode

Message

1234567

EUR

102,15

DEMO

Payment OK

Recurring transactions with customer statement (7 columns)

Source order number	Currency	Amount	Customer statement	Order number	Authcode	Message
7654321	EUR	42,23	ONr.18 recur	18	DEMO	Payment OK

Source order number

Currency

Amount

Customer statement

Order number

Authcode

Message

7654321

EUR

42,23

ONr.18 recur

DEMO

Payment OK

Refund (4 columns)

Currency	Amount	Order number	Message
EUR	1	12345	Credit note OK

Currency

Amount

Order number

Message

EUR

12345

Credit note OK

Refund with customer statement (5 columns)

Currency	Amount	Customer statement	Order number	Message
EUR	35	ONr.54321 refund	54321	Credit note OK

Currency

Amount

Customer statement

Order number

Message

EUR

ONr.54321 refund

54321

Credit note OK

1. Number defined by you and transmitted in the file. If the number is set to “0” by you, QENTA will assign a corresponding number.

2. Optional

3. Optional

4. Optional

5. Optional

6. Optional

7. Optional

8. Optional

9. Number defined by you and transmitted in the file. If the number is set to “0” by you, QENTA will assign a corresponding number.

10. Number used by QENTA for processing the file.

11. Authorization code from financial service provider which is automatically returned.

12. Number defined by you and transmitted in the file. If the number is set to “0” by you, QENTA will assign a corresponding number.

13. Number used by QENTA for processing the file.

14. Authorization code from financial service provider which is automatically returned.