Payout Report

Overview

The Payout Report provides a summarized financial view of funds paid out to the merchant for a given payout cycle.

It aggregates settlement activity into a single payout event, showing how transaction flows, refunds, and fees translate into the final payout amount transferred to the merchant’s settlement account.

Each row represents a single payout, linked to a reconciliation period.


Key Features

  • Aggregated view of settlement activity per payout
  • Clear breakdown of payment counts, refund counts, and fees
  • Visibility into payout amount and balances
  • Includes bank reference for reconciliation
  • Direct linkage to Settlement Report via Reconciliation ID
  • Structured format (e.g. CSV) for accounting and reconciliation

Report Characteristics

AttributeDescription
GranularityPayout-level (one row per payout)
FrequencyBased on payout schedule (e.g. daily)
FormatCSV
ScopeAll payouts generated within the reporting period
Currency representationMinor units unless otherwise specified

Use Cases

  • Bank reconciliation: Match payouts with bank statement entries
  • Settlement validation: Verify that settlement amounts are correctly aggregated
  • Accounting: Support financial reporting and bookkeeping
  • Cash flow tracking: Monitor incoming funds and balances
  • Exception handling: Identify missing or zero payouts

Relationship to Other Reports

The Payout Report is part of Aera’s broader reporting framework:

  • Daily Transaction Detail Report
  • Provides transaction-level activity
  • Daily Settlement Report
  • Provides financial breakdown per transaction

In practice:

  • Use Transaction Report → to understand what happened
  • Use Settlement Report → to understand what is settled
  • Use Payout Report → to understand what is paid out

Example Flow

  • Transactions processed → appear in Transaction Report (Transaction ID)
  • Transactions settled → appear in Settlement Report (Reconciliation ID)
  • Settlements aggregated → appear in Payout Report (same Reconciliation ID)

Availability

  • Generated based on the configured payout schedule
  • Covers settlement activity included in the payout
  • Made available once payout processing is completed

Delivery Options

The report can be accessed via:

  • Manual retrieval (via Aera Portal)
  • Automated delivery (via webhook + Reporting API)

For details, see Get Reports.


Report Structure

Each row in the report represents a single payout event.

The groupings presented below are for documentation purposes only; the actual report is delivered as a flat file without grouping.

Payout Identification

FieldDescription
MerchantIDAera MID
Payout DateDate of the payout
Settlement AccountAccount the settlement amount is paid to
Payout ReferenceReference in the bank statement, empty if Payout Amount is zero
Reconciliation ID FromID of the first reconciliation period (YYMMDD_nnn) included in the payout
Reconciliation ID ToID of the last reconciliation period (YYMMDD_nnn) included in the payout

Payment Summary

FieldDescription
Payment countTotal number of payment settlement transactions; equals the total payment count for the Reconciliation ID from the settlement report
Gross Payment AmountTotal payment settlement amount; equals the total payment amount for the Reconciliation ID from the settlement report excluding fees
CurrencyCurrency code of the amount fields
Refund countTotal number of refund settlement transactions; equals the total refund count for the Reconciliation ID from the settlement report
Gross Refund AmountTotal refund settlement amount; equals the total refund amount for the Reconciliation ID from the settlement report excluding fees (negative value)

Balance Information

FieldDescription
Balance InBalance after prior settlements, normally zero, negative if the merchant owes money, positive if lower than threshold amount
Balance OutBalance after this settlement, normally zero, negative if merchant owes money, positive if Payout Amount is lower than threshold amount

Fees & Payout

FieldDescription
Total Charges DeductedTotal fees (negative amount) deducted from the gross settlement amount; empty if gross settlement
Payout AmountAmount paid to the Settlement Account. Can be zero if: (1) no transactions, (2) negative Balance Out, or (3) amount is below the payout threshold (currently zero threshold)

Did this page help you?