QFILE Checkout Automated
QFILE Checkout Automated
QFILE Checkout Automated is intended for your non real-time critical applications such as catalog orders and subscriptions. The payment details of your consumers are prepared in tabular format, uploaded and automatically processed.
Demo access for testing purposes.
Uploading payment details
First, you need to create a transaction file that includes all your necessary payment data. If you use an xls file you must convert the file into a tab-delimited text file as you can see in the example below, 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 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 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".
You must not use 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 your customers and remember that the number of headers must correspond exactly to the number of columns.
Credit card number | Expiration date | CVC | Currency | Amount | First name | Last name | Number | Customer statement |
---|---|---|---|---|---|---|---|---|
|
12/2022 |
Has to be empty. |
EUR |
109,91 |
Max |
Mustermann |
12345 |
|
|
05/2023 |
Has to be empty. |
USD |
44,60 |
Ingrid |
Wantsall |
263547 |
|
|
04/2021 |
Has to be empty. |
GBP |
22,75 |
Sue |
Shoppingmaster |
2534 |
|
|
12/2023 |
Has to be empty. |
EUR |
42,23 |
Lisa |
Kaufrausch |
54321 |
ONr.54321 payment |
Source order number | Currency | Amount | First name | Last name | Number | Customer statement | Merchant CRM ID |
---|---|---|---|---|---|---|---|
|
EUR |
112,15 |
Max |
Mustermann |
17 |
||
|
EUR |
223,23 |
Lisa |
Kaufrausch |
18 |
ONr.18 recur |
|
|
EUR |
334,23 |
Sasha |
Treukund |
19 |
ONr.19 recur |
253-651-abc-234 |
Merchant CRM ID should have only 40 characters. |
Currency | Amount | Number | Customer statement |
---|---|---|---|
EUR |
1 |
12345 |
|
EUR |
35 |
54321 |
ONr.54321 refund |
IBAN | BIC | Currency | Amount | First name | Last name | Number | Customer statement |
---|---|---|---|---|---|---|---|
DE42512308000000060004 |
EUR |
123,34 |
Max |
Mustermann |
21 |
IBAN | BIC | MandateId | MandateSignatureDate | CreatorId |
---|---|---|---|---|
|
|
|
|
Due date |
Currency |
Amount |
First name |
Last name |
Number |
Customer statement |
13.02.2021 |
EUR |
12,34 |
Max |
Mustermann |
42 |
My Statement 2 |
Value for the column "BIC" for SEPA Direct Debit is optional. |
Downloading the result
After uploading the payment details of your customers, the file is processed and the transactions can be downloaded as a tab-delimited text file which you may convert 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 number | Currency | Amount | First name | Last name | Number | Order number | Authcode | Message |
---|---|---|---|---|---|---|---|---|
|
EUR |
109,91 |
Max |
Mustermann |
12345 |
12345 |
DEMO |
Payment OK |
|
USD |
44,6 |
Ingrid |
Wantsall |
263547 |
263547 |
DEMO |
Payment OK |
|
GBP |
22,75 |
Sue |
Shoppingmaster |
2534 |
2534 |
DEMO |
Payment OK |
Credit card number | Currency | Amount | First name | Last name | Customer statement | Number | Order number | Authcode | Message |
---|---|---|---|---|---|---|---|---|---|
|
EUR |
42,23 |
Lisa |
Kaufrausch |
ONr.54321 payment |
54321 |
54321 |
DEMO |
Payment OK |
IBAN | BIC | Currency | Amount | First name | Last name |
---|---|---|---|---|---|
DE42512308000000060004 |
EUR |
123,34 |
Max |
Mustermann |
Number | Customer statement | Order number | Authcode | Message |
---|---|---|---|---|
21 |
My statement 1 |
21 |
DEMO |
Payment OK |
IBAN | BIC | MandateId | Mandate signature date | Creditor Id | Due date |
---|---|---|---|---|---|
|
|
|
|
13.02.2014 |
Currency | Amount | First name | Last name | Number | Customer statement | Order number | Authcode | Message |
---|---|---|---|---|---|---|---|---|
EUR |
12,35 |
Max |
Mustermann |
42 |
My statement 2 |
0 |
DEMO |
Payment OK |
Value for the column "BIC" for SEPA Direct Debit is optional. |
Source order number | Currency | Amount | Order number | Authcode | Message |
---|---|---|---|---|---|
1234567 |
EUR |
102,15 |
17 |
DEMO |
Payment OK |
Source order number | Currency | Amount | Customer statement | Order number | Authcode | Message |
---|---|---|---|---|---|---|
7654321 |
EUR |
42,23 |
ONr.18 recur |
18 |
DEMO |
Payment OK |
Currency | Amount | Order number | Message |
---|---|---|---|
EUR |
1 |
|
Credit note OK |
Currency | Amount | Customer statement | Order number | Message |
---|---|---|---|---|
EUR |
35 |
ONr.54321 refund |
|
Credit note OK |