Access your reports and financial data
Last updated: July 10, 2024
Retrieve your reports with a flexible range of options to meet your integration preferences.
You can use our Reports
API to retrieve the following reports:
- Authentication reports
- Balance reports
- Bank Payouts reports
- Card Payouts reports
- Disputes reports
- Financial actions reports (for example, by date range or payout ID)
- Fraud Detection reports
- Issuing Authorizations reports
- Issuing Cards reports
- Issuing Chargebacks reports
- Issuing Presentments reports
- Issuing Settlement Activity reports
- Issuing Settlement Summary reports
- Payments reports
- Payouts reports
- Reported Fraudulent Transactions reports
- Retrievals reports
- Settlement statement
You can access and download your scheduled reports programmatically, collect them at your chosen interval (for example, daily, weekly, or monthly), and automate reconciliation.
For the full API specification, see the API reference.
Reports are provided in CSV format via Secure File Transfer Protocol (SFTP).
To set up access to your reports, contact your Account Manager or [email protected].
We will then give you:
- an SFTP server
- a port
- a username
- access to your private key
You will need to:
- Provide Checkout.com with an OpenSSH RSA public key.
- Create and securely store a private key.
- In your command line, run the following command to create the key pair:
ssh-keygen -t rsa -b 4096 -f "checkout-sftp"
This will generate two files:
checkout-sftp.pub
, which is the public key you need to share with Checkout.comcheckout-sftp
, which is the private key you'll need to access your SFTP client
- To retrieve the public key using the command line, run
cat
if you're using a macOS or Linux system, ormore
if you're using a Windows system. Alternatively, use your system's file explorer. - Send the public key to your Account Manager or [email protected].
- Use the private key as a credential to sign in to your SFTP client.
Information
We recommend you encrypt your secret key using the AES-256 cipher.
Reports will be uploaded in the following folder structure:
Invoices:
- Directory: {entity name} > reports-{entity name} > invoices
- File name format:
invoice_{EntityID}_{Currency}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}.pdf
Balance reports:
- Directory: {entity name} > reports-{entity name} > balance
- File name format:
statement_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}.csv
Balance breakdown:
- Directory: {entity name} > reports-{entity name} > balance-breakdown
- File name format:
balance-breakdown_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Payouts reports:
- Directory: {entity name} > reports-{entity name} > payouts
- File name format:
payouts_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Settlement statements:
- Directory: {entity name} > reports-{entity name} > settlement-statements
- File name format:
settlement-statement_{EntityID}_{Payout Date: YYYYMMDD}_{Payout ID}.pdf
Settlement breakdown:
- Directory: {entity name} > reports-{entity name} > settlement-breakdown
- File name format:
settlement-breakdown_{EntityID}_{Payout Date: YYYYMMDD}_{PayoutID}_1.csv
Financial actions by payout ID:
- Directory: {entity name} > reports-{entity name} > financial-actions > payout-id
- File name format:
financial-actions_{EntityID}_{Payout Date: YYYYMMDD}_{PayoutID}_1.csv
Financial actions by date range:
- Directory: {entity name} > reports-{entity name} > financial-actions > date-range
- File name format:
financial-actions_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Payments reports:
- Directory: {entity name} > reports-{entity name} > payments
- File name format:
payments_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Retrievals reports:
- Directory: {entity name} > reports-{entity name} > retrievals
- File name format:
retrievals_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Disputes reports:
- Directory: {entity name} > reports-{entity name} > disputes
- File name format:
disputes_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Fraud Detection reports:
- Directory: {entity name} > reports-{entity name} > fraud_detection
- File name format:
fraud_detection_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Reported Fraudulent Transactions reports:
- Directory: {entity name} > reports-{entity name} > reported_fraudulent_transactions
- File name format:
reported_fraudulent_transactions_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Card Payouts reports:
- Directory: {entity name} > reports-{entity name} > paytocard
- File name format:
paytocard_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Bank Payouts reports:
- Directory: {entity name} > reports-{entity name} > paytobank
- File name format:
paytobank_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Issuing Authorizations reports:
- Directory: {entity name} > reports-{entity name} > issuing_authorizations
- File name format:
issuing_authorizations_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Issuing Cards reports:
- Directory: {entity name} > reports-{entity name} > issuing_cards
- File name format:
issuing_cards_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Issuing Chargebacks reports:
- Directory: {entity name} > reports-{entity name} > issuing_chargebacks
- File name format:
issuing_chargebacks_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Issuing Presentments reports:
- Directory: {entity name} > reports-{entity name} > issuing_presentments
- File name format:
issuing_presentments_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Issuing Settlement Activity reports:
- Directory: {entity name} > reports-{entity name} > issuing_settlement_activity
- File name format:
issuing_settlement_activity_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Issuing Settlement Summary reports:
- Directory: {entity name} > reports-{entity name} > issuing_settlement_summary
- File name format:
issuing_settlement_summary_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Authentication reports:
- Directory: {entity name} > reports-{entity name} > sessions_authentication
- File name format:
sessions_authentication_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
Reports have a maximum of 1,000,000 rows per CSV file. If the volume of data is greater than that, it's split into multiple files, containing up to 1,000,000 rows each.
Split files include a number at the end of their filename. For example, if a financial actions report by date range has 2,400,000 rows, the following files will be created:
financial-actions_{Entity ID}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}_1.csv
financial-actions_{Entity ID}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}_2.csv
financial-actions_{Entity ID}_{Start Date:YYYYMMDD}_{End Date:YYYYMMDD}_3.csv
Use Checkout.com's Financial actions API to:
- query your financial action data
- perform near real-time reconciliation
- programmatically retrieve the history of a given payment
- programmatically retrieve the fees for a given payment or action during its lifecycle
This gives you full visibility over the financial impact of a payment shortly after it's successfully processed, without needing to wait for CSV reports.
You can query your financial action data by payment ID
, action ID
, or reference
. For the full API specification, see the API reference.
Information
To learn more, reach out to your Account Manager or [email protected].