Reports via SFTP

Introduction

SFTP reports allows you to receive detailed report information on your SFTP space every day, facilitating the reconciliation of transactions and refunds processed through Satispay.

The SFTP reconciliation provided by Satispay allows for two distinct types of reports:

• Transaction report: allows you to align your internal records with individual transactions processed by Satispay, including both payments and refunds.

  • TRANSACTION REPORT EXAMPLE

  • TRANSACTION REPORT EXAMPLE w/ Meal Voucher

• Settlement report: enables you to reconcile Satispay payouts with your bank account statement. This aids in tracking the flow of funds from your business, starting from Satispay and ending in your bank account.

  • SETTLEMENT REPORT EXAMPLE

The number of total transactions available in the report can differ from the settlement one.
Reasons are reported below:

• Bank holiday (on the bank holiday transaction may be performed but the credits will be settled on the first working day after the payout is performed)
• Refunds
• IBAN validation
• Other technical reasons from bank side

General Process

This is an outline of how the service works:

• The reports will be executed daily and handles retries ensuring that the output is provided consistently by minimizing the delays.
• At the established hour the service will connect to the SFTP and upload the file in the location specified in the setup phase.
• It is advisable to wait at least 30 minutes after the scheduled timing to retrieve the document.

SFTP setup and requirements

SFTP is a Secure File Transfer Protocol which is used to share data securely especially in B2B environments.
The reports will be shared in a CSV (Comma-Separated Values) format via SFTP to your server.

Required actions to enable this feature:

1. Setup your SFTP server.
2. Provide Satispay the SFTP server details, including:
   • host: hostname or IP address where your server is located
   • port: designated port where the service is accessible
   • username: username required to login into your service
   • path: directory path on your server where the reports will be uploaded (by default it will be /)
   • filename: name format of the uploaded file (you can read more in the Filename structure section)
3. Once Satispay has processed your request, you will receive a public RSA-2048 key that you will need to configure with the previously sent username.
4. Once Satispay has tested that the authentication is successful, your daily reports will be activated.

If necessary, you can configure your firewall to limit the access exclusively to our NAT IPs.

Our system generates reports with a 1-day offset, delivering yesterday's data in today's reports.
This offset is adjustable, allowing you to shift the reporting period as needed.

Filename structure

Available filename placeholders:

• {date} represents the date of the report
• {chunk_number} represents the file chunk number
• {total_chunk_number} represents the total chunks available for a specific day

Example:

transactions_satispay_{date}_{chunk_number}_{total_chunk_number}.csv

transactions_satispay_20200120_001_005.csv

In this specific example 20200120 is the transaction date, 001 indicates that this is the first file in a series and 005 indicates that there are a total of 5 files.