Adyen-for-platform icon

Reporting

Learn about different types of reports and how to use them to reconcile your balance platform accounts.

Adyen offers a wide range of reports that give you the flexibility to provide insight for your business, and for the business of your users.

There are two distinct ways to make insights available to your users:

  • You can quickly cover key use cases in a straight-forward way by leveraging Adyen’s components.
  • You can build fully-customized reports using an extensive range of custom reports.

Keep in mind that the reports in the Customer Area are not directly available to your users, and that you may need to filter the reports by balance account before sharing those reports.

Recommendation
Accelerate your go-to-market strategy by leveraging Dashboard Components immediately. You can then later build custom reporting into your integration, when (and if) your users demand more advanced capabilities in their reports.

Video resources for reporting

Dashboard components for key use cases (standard)

Reporting components are drop-in solutions built for you to cover key reporting and dashboard use cases for your sub-merchants. When you use components, you can avoid having to set up complex data pipelines or extensive frontend solutions for your users.

Reporting components cover three key use cases:

  • Transactions Overview: show transactions as a list to your user.
  • Payouts Overview: show how a user’s received payout relates to transactions.
  • Report Overview: allows users to filter and download available reports for a specific balance account.

Transactions Overview

The Transactions Overview component allows users to filter and view a list of transactions, showing the total incoming and outgoing funds of a specific balance account. Each transaction overview provides details such as the date and time, payment method, transaction type, and amount for each transaction.

Recommendation
Start by leveraging the Transactions Overview component in combination with the Transaction Details component. These components serve the core needs of your users, while allowing time for you to build out and launch more advanced scenarios if needed.

Payouts Overview

The Payouts Overview component allows users to filter and view a list of automatic payouts for a specific balance account. Your users will want to reconcile the daily payout they received to the transactions they processed during a business day.

Report Overview

Adyen has plans to launch a Report Overview component that allows users to filter and download available reports for a specific balance account. The report data is automatically generated every day, so users always have access to the most current data. Currently only available for the Payout Report, other reports will be added in the future.

Recommendation
Start by leveraging the Payouts Overview Component in combination with the Payout Details Component. This solution services core needs of your users, while allowing time for you to build out and launch more advanced scenarios if needed. The Reports Component will soon allow users to download the overview of debits and credits resulting in their (daily) payout - making closing books easier than ever for your users and operational staff.

Adyen invoice reconciliation

To reconcile your Adyen invoice, please use our Interactive Payment Accounting Report (IPAR). Look for:

  • Processing fees: select statuses Received and SentforRefund.
  • Payment method fees: select statuses Settled and SentforRefund, Refunded and Chargeback (including Chargeback and ChargebackReversed if relevant).
  • Revenue protect fees: select statuses Received.

For further steps on how to reconcile your invoice, please refer to this Adyen Help page.

Custom reporting and reconciliation (advanced)

For more advanced use cases, you can leverage an extensive range of reporting. This offers you maximum flexibility in meeting user requirements and internal data policies. Building custom reporting requires a solid understanding of key accounting principles and data engineering.

This section covers key concepts you need to understand when building custom reports. It also summarizes key reports and lists your options and recommendations on data ingestion.

Key reporting concepts

To build custom reporting flows, your team must understand various key concepts like value-date accounting and settlement delays.

Value date accounting

We use value-date accounting in our reports. When you reconcile your transactions, note the difference between the booking date and the value date.

  • The booking date is when the event (like a payment capture) takes place.
  • The value date is when the funds are credited or debited to a balance account. This is when the real movement of money happens, and funds become available in your user's balance account.

When reconciling your user’s balances, always use the value date as an indicator of when a transaction gets credited/debited to your user’s account:

Transfer lifecycle booking and value dates

Settlement delay

Depending on the configured settlement delay of your platform, a payment gets credited to a balance account with a certain delay after the initial sales day. For instance, with a delay of two business days, a payment from Monday is credited to a balance account on Wednesday.

Key reports

Adyen generates reports for your Payments processing and for your Adyen for Platforms platform.

Example Adyen platform with a Payments processing integration

We recommend using the reports for Payments processing to reconcile your invoice and to get payment-level insights. You can use the balance platform reports for margin and balance calculations and to reconcile payouts made to your users.

Balance Platform Payout Report

Purpose: The Balance Platform Payout Report (BPPR) is a daily report that contains all scheduled payouts initiated on that day including the transactions that were part of the payout.

Limitations:

  • Only reconciles scheduled/automatic payouts; cannot be used for manually triggered payouts.
  • Not more than one scheduled payout occurred on the same day; additional payouts will result in incorrect data within this report.
  • This report only works if you are leveraging our Sales Day Payout model.

Use: For a more limited integration of our reports, you can focus solely on the Payout Report. Assuming you only have regularly scheduled payouts on your balance platform, this report allows you to fully reconcile the sweeps done to your balance accounts.

Balance Platform Accounting Report - Adyen for Platforms

Purpose: The Balance Platform Accounting Report (BPAR) is a daily report that tracks all balance changes in your platform. For example, processed payments, internal transfers, payouts, fees, invoice deductions, etc. An interactive version of this report is available for generating similar insights within specific parameters.

You can combine this report with the Balance Platform Balance Report to reconcile your user’s balances or create a rolling balance. We provide a downloadable sample BPAR in csv format.

Note: This use case requires that you eliminate all events in the report where no real money movement has taken place. For example, where the status is Received, Authorized, Canceled, Expired, etc., as those events do not impact the balance of an account.

Use: We recommend to ingest at least all BPARs on your end, and to build a ledger based on the data provided. This allows you to obtain full insights into all balances on your entire platform and to confirm processed payments and (internal) transfers.

Balances

There can be various reasons to keep track of the account balances in your balance platform. For example, to make an on-demand payout to your user, you need to know how much cash is available on the balance account of that user.

To check the balance positions on the balance accounts of your users, you can:

Balance Platform Fee Report

Purpose: The Balance Platform Fee Report aggregates transactional fees incurred by a sub-merchant for a given billing cycle.

Use: To understand sub-merchant’s costs, to reconcile an invoice, or as an input into a margin analysis.

Other reports

The following are some other reports that can provide more information about balances and events across your balance platform.

Balance Platform Statement Report
  • Purpose: The Balance Platform Statement Report is a daily report that provides insights about the starting balance, all transactions that changed the balance, and the ending balance for the available currencies. Note: When both the opening and ending balance of a balance account are zero, this account is not included in the report.
  • Use: Similar to the BPAR, you can use this report to reconcile your user’s balances. Simply filter on a balance account and find all balance mutations for that account in the 'Amount' column.
Payment Accounting Report - Payments processing
  • Purpose: The Payment Accounting Report on payments lifecycle status changes, events, and modifications for all transactions. An interactive version allows you to generate the report based on specific parameters.
  • Use: You can use this report to see the costs associated with different statuses and perform invoice reconciliation.
Settlement Detail Report - Payments processing
  • Purpose: The Settlement Detail Report includes the details of payments that have been settled to you by Adyen and other balance movements that occurred in that batch, see journal types.
  • Use: Includes the payment funds and per-transaction costs that are available on the accounting reports, as well as the total balance adjustments originating from the Monthly invoice. This report also includes any one-off inbound wire transfer deposits to your balance platform, so that you can optionally track these amounts to default liable account postings.

Reporting cadence and consumption

Reports can be consumed in various ways, depending on the timing requirements of your use case:

Recommendation
Automatically generate daily reports and ingest them directly into your cloud environment through Adyen’s Data Out feature. This removes the need for you to set up complex data pipelines for each report. To learn more about Data Out, reach out to your Adyen contact.