Skip to content

Reconciliation reports

Last updated: 9th August 2022

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 our 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 set it up for you, providing you with an SFTP server, port, username and private key to access your reports.

Downloading reports

Reports will be uploaded in the following folder structure:

sftp delivery folder structure v

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: