For reconciling incoming payments in the customer’s system, GiroCheckout provides report files in various formats:
- Credit card payment reports for each payout (available in EPA or CSV format)
- Daily transaction reports for all payment methods (CSV format)
These files can be retrieved via an SFTP account, which is individually created for each customer and secured using public-private key authentication. In many municipalities, these data are already retrieved and provided by their data center (e.g., ekom21, GovConnect, or SID). If this is not the case, the customer can request an SFTP account directly from S-Public Services by sending us a public key (see details below).
Note: EPA files use a machine-readable format that cannot easily be read by humans. Meaningful use of these files therefore requires software integration that automatically retrieves and imports the files into the customer’s own systems. These formats are not suitable for manual data reconciliation.
CSV files can generally be loaded and displayed in tabular form without significant effort using commonly available software such as Microsoft Excel.
EPA Format
Download the descriptions and examples using the following links.
EPA File in CSV Format
This format is simply an alternative representation of the same information contained in EPA files. The data is provided in CSV format because it is easier to read than EPA, and some customers prefer this format.
CSV Transaction Reports
The CSV files correspond to the manual exports from the transaction overview in GiroCockpit. There are three formats (Versions 1–3), although Format 1 is no longer offered.
Requesting an SFTP Account for Receiving Report Files
Please contact kundensupport@s-publicservices.de and provide a public key in RSA format. Ensure that the key is provided in the following format (single line, with the ssh-rsa prefix):
ssh-rsa AAAB3NzaC1yc2EAAAABJQAAAQEA1[...]3K0v8RZANXEIQ== my_email@example.com
or
ssh-ed25519 AAAAC3NzaC1l[...]oijLu0zzTa+ my_email@example.com
Once the account has been created, you will receive a notification containing the server address and your username. To log in, you will need your private key. On the server, you will find an “out” directory where we will place the report files.