Skip to content

Reconciliation reports

Last updated: March 22, 2023

We provide the following reports so you can reconcile between payments/payouts and fees, payouts settled to you and your bank statement, and manage your balances. Select each one to find out more.

  • Financial actions reports: provide an accurate representation of all actions during a payment's or payout's life-cycle that impact your currency account's available balance with us. Together with the payouts reports, you will be able to reconcile payments and any associated fees against payouts paid out to you.

  • Balance reports: provide you with a view of monetary inflows and outflows across your currency accounts as well as the opening and closing available balances over a specified period of time. This allows you to determine any necessary actions required to be undertaken to your currency account. For example, the transfer of funds between your currency accounts or balance top-ups.

  • Payouts reports: provide an overview of payouts paid to you from us, with the associated breakdown of fees applied over a specific period of time. This allows you to reconcile payouts with amounts paid out to your bank account and shown on bank statements.


Setting up access to your reconciliation reports

Financial actions, balance and payouts reports are provided in CSV format via Secure File Transfer Protocol (SFTP).

To set up access to your financial actions, balance, and payouts reports via SFTP, contact your Customer Success Manager.

We will then give you an SFTP server, port, and username, and grant you access to your private key.

What you need to do:

  • Provide Checkout.com with an OpenSSH RSA public key
  • Create and securely store a private key

Creating a public and private key pair

  1. 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.com
  • checkout-sftp, which is the private key you'll need to access your SFTP client
  1. To get the public key using the command line, run cat if you're running a macOS or Linux system, or more if you're running a Windows system. Alternatively, use your system's file explorer.
  2. Send the public key to your Customer Success Manager or Solutions Engineer.
  3. 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.


Downloading reports

Reports will be uploaded in the following folder structure:

  • Client Name > {"{Entity Name}"} > Reports-{"{Entity Name}"} > Invoices > invoice_{EntityID}_{Currency}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}.pdf

  • Client Name > {"{Entity Name}"} > Reports-{"{Entity Name}"} > Balance > statement_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}.csv

  • Client Name > {"{Entity Name}"} > Reports-{"{Entity Name}"} > Payouts > payouts_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv

  • Client Name > {"{Entity Name}"} > Reports-{"{Entity Name}"} > Financial-Actions > Payout-ID > financial-actions_{EntityID}_{Payout Date: YYYYMMDD}_{PayoutID}_1.csv

  • Client Name > {"{Entity Name}"} > Reports-{"{Entity Name}"} > Financial-Actions > Date-Range > financial-actions_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv

Large CSV reports with more than 1,000,000 rows are split into multiple reports of 1,000,000 so they're easier deal with. Split files include a suffix _#. For example, if a financial actions report by date range has 2,400,000 rows, the following files would 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


Using your reports

Follow the links below to find out more information on the contents of your reports and how to use them for your reconciliations: