QFILE Checkout Automated

QFILE Checkout Automated is intended for non-real-time critical applications such as catalog orders and subscriptions. The payment details of the consumers are prepared in tabular format, uploaded, and automatically processed.

Here is a demo access for testing purposes.

Uploading payment details

The merchant needs to create a transaction file that includes all necessary payment data. It must be converted into a tab-delimited text file (image example below) since otherwise the transactions can’t be uploaded.

After successful login, QFILE Checkout Automated opens and the merchant selects and uploads 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 transactions must not exceed 3000 transactions 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 the 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".

Do not use the special character “ ' “ e.g. “Sarah O’Brian” otherwise all transactions in the file can’t be processed.

Use the following format for uploading the payment details of the customers and remember that the number of headers must correspond exactly to the number of columns.

Credit Card

Table 1. Credit Card (8-9 columns)
Credit card number	Data	Value
`9500000000000001`	Expiration date	`12/2025`
	CVC	Has to be empty.
	Currency	`EUR`
	Amount	`109,91`
	First name	`Max`
	Last name	`Mustermann`
	Number	`12345`
	Customer statement
Credit card number	Data	Value
`9400000000000003`	Expiration date	`05/2026`
	CVC	Has to be empty.
	Currency	`USD`
	Amount	`44,60`
	First name	`Ingrid`
	Last name	`Wantsall`
	Number	`263547`
	Customer statement
Credit card number	Data	Value
`9200000000000007`	Expiration date	`04/2025`
	CVC	Has to be empty.
	Currency	`GBP`
	Amount	`22,75`
	First name	`Sue`
	Last name	`Shoppingmaster`
	Number	`2534`
	Customer statement
Credit card number	Data	Value
`9500000000000002`	Expiration date	`12/2025`
	CVC	Has to be empty.
	Currency	`EUR`
	Amount	`42,23`
	First name	`Lisa`
	Last name	`Kaufrausch`
	Number	`54321`
	Customer statement	`ONr.54321 payment`

SEPA Direct Debit

Table 2. SEPA Direct Debit, minimum (8 columns)
IBAN	Data	Value
`DE42512308000000060004`	BIC
	Currency	`EUR`
	Amount	`123,34`
	First name	`Max`
	Last name	`Mustermann`
	Number	`21`
	Customer statement

Table 3. SEPA Direct Debit, full (12 columns)
IBAN	Data	Value
`DE42512308000000060004`	BIC
	`MandateId`	`Abo-12345`
	`MandateSignatureDate`	`01.02.2025`
	`CreatorId`	`AT12ZZZ00000000001`
	`Due date`	`13.02.2025`
	`Currency`	`EUR`
	`Amount`	`123,34`
	`First name`	`Max`
	`Last name`	`Mustermann`
	`Number`	`42`
	`Customer statement`	`My Statement 2`

Table 4. SEPA Direct Debit, full (12 columns)
Data	Value
IBAN	`DE42512308000000060004`
BIC
MandateId	`Abo-12345`
MandateSignatureDate	`01.02.2025`
CreatorId	`AT12ZZZ00000000001`
Due date	`13.02.2025`
Currency	`EUR`
Amount	`123,34`
First name	`Max`
Last name	`Mustermann`
Number	`42`
Customer statement	`My Statement 2`

Value for the column "BIC" for SEPA Direct Debit is optional.

Recurring Transactions

Table 5. Recurring Transactions (6-8 columns)
Source order number	Data	Value
`1234567`	Currency	`EUR`
	Amount	`112,15`
	First name	`Max`
	Last name	`Mustermann`
	Number	`17`
	Customer statement
	Merchant CRM ID
Source order number	Data	Value
`7654321`	Currency	`EUR`
	Amount	`223,23`
	First name	`Lisa`
	Last name	`Kaufrausch`
	Number	`18`
	Customer statement	`ONr.18 recur`
	Merchant CRM ID
Source order number	Data	Value
`7654000`	Currency	`EUR`
	Amount	`334,23`
	First name	`Sasha`
	Last name	`Treukund`
	Number	`19`
	Customer statement	`ONr.19 recur`
	Merchant CRM ID	`253-651-abc-234`

Merchant CRM ID should have only 40 characters.

Refunds

Table 6. Refunds (3-4 columns)
Currency	Amount	Number	Customer statement
`EUR`	`1`	`12345`
`EUR`	`35`	`54321`	`ONr.54321 refund`

Downloading the result

After uploading the payment details of the customers, the file is processed and the transactions can be downloaded as a tab-delimited text file which can be converted back into an xls file.

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

Credit Card

Table 7. Credit Card (9 columns)
Credit card number	Data	Value
`9500000000000001`	Currency	`EUR`
	Amount	`109,91`
	First name	`Max`
	Last name	`Mustermann`
	Number	`12345`
	Order number	`12345`
	Authcode	`DEMO`
	Message	`Payment OK`
Credit card number	Data	Value
`9400000000000003`	Currency	`USD`
	Amount	`44,6`
	First name	`Ingrid`
	Last name	`Wantsall`
	Number	`263547`
	Order number	`263547`
	Authcode	`DEMO`
	Message	`Payment OK`
Credit card number	Data	Value
`9200000000000007`	Currency	`GBP`
	Amount	`22,75`
	First name	`Sue`
	Last name	`Shoppingmaster`
	Number	`2534`
	Order number	`2534`
	Authcode	`DEMO`
	Message	`Payment OK`

Table 8. Credit Card with customer statement (10 columns)
Credit card number	Data	Value
`9500000000000002`	Currency	`EUR`
	Amount	`42,23`
	First name	`Lisa`
	Last name	`Kaufrausch`
	Customer statement	`ONr.54321 payment`
	Number	`54321`
	Order number	`54321`
	Authcode	`DEMO`
	Message	`Payment OK`

SEPA Direct Debit

Table 9. SEPA Direct Debit, minimum (11 columns)
IBAN	Data	Value
`DE42512308000000060004`	BIC
	Currency	`EUR`
	Amount	`123,34`
	First name	`Max`
	Last name	`Mustermann`
	Number	`21`
	Customer statement	`My statement 1`
	Order number	`21`
	Authcode	`DEMO`
	Message	`Payment OK`

Table 10. SEPA Direct Debit, full (15 columns)
IBAN	Data	Value
`DE42512308000000060004`	BIC
	MandateId	`Abo-12345`
	Mandate signature date	`01.02.2025`
	Creditor Id	`AT12ZZZ00000000001`
	Due date	`13.02.2025`
	Currency	`EUR`
	Amount	`12,35`
	First name	`Max`
	Last name	`Mustermann`
	Number	`42`
	Customer statement	`My statement 2`
	Order number	`0`
	Authcode	`DEMO`
	Message	`Payment OK`

Table 11. SEPA Direct Debit, full (15 columns)
Data	Value
IBAN	`DE42512308000000060004`
BIC
MandateId	`Abo-12345`
Mandate signature date	`01.02.2025`
Creditor Id	`AT12ZZZ00000000001`
Due date	`13.02.2025`
Currency	`EUR`
Amount	`12,35`
First name	`Max`
Last name	`Mustermann`
Number	`42`
Customer statement	`My statement 2`
Order number	`0`
Authcode	`DEMO`
Message	`Payment OK`

Value for the column "BIC" for SEPA Direct Debit is optional.

Recurring transactions

Table 12. Recurring transactions (6 columns)
Source order number	Data	Value
`1234567`	Currency	`EUR`
	Amount	`102,15`
	Order number	`17`
	Authcode	`DEMO`
	Message	`Payment OK`

Table 13. Recurring transactions with customer statement (7 columns)
Source order number	Data	Value
`7654321`	Currency	`EUR`
	Amount	`42,23`
	Customer statement	`ONr.18 recur`
	Order number	`18`
	Authcode	`DEMO`
	Message	`Payment OK`

Refund

Table 14. Refund (4 columns)
Currency	Amount	Order number	Message
`EUR`	`1`	`123445`	`Credit note OK`

Table 15. Refund with customer statement (5 columns)
Currency	Amount	Customer statement	Order number	Message
`EUR`	`35`	`ONr.54321 refund`	`54321`	Credit note OK

Table 16. Refund with customer statement (5 columns)
Data	Value
`Currency`	`EUR`
`Amount`	`35`
`Customer statement`	`ONr.54321 refund`
`Order number`	`54321`
`Message`	`Credit note OK`