Reconciliation

PayMongo provides built-in tools to help you reconcile your payout records directly from the merchant dashboard. This page walks through how to use the Payout History and export features for your reconciliation workflow.

Payout History

The Payout History table gives you a complete list of all generated payouts, including key details for each record:

ColumnDescription
DateThe date the payout was generated
Payout IDA unique identifier for each payout record
AmountThe net amount deposited to your destination account
Receiving AccountThe destination account where the payout was sent
StatusCurrent state of the payout

Payout Breakdown

Clicking on any Payout ID opens the Payout Details panel, which shows a full breakdown of how the net payout amount was computed:

ItemDescription
Gross AmountTotal payments included in the payout
FeesLocal and Foreign fees per payment deducted from the payout
RefundedAmount returned to customers via refunds
DisputedAmount held due to disputes
AdjustmentsDebit or credit adjustments
Withholding TaxApplicable withholding tax (2%) from Fees Net of VAT added in the payout
Net AmountFinal amount deposited to the destination account

Transaction Logs

Each payout detail also includes a Transaction Logs table, which itemizes every transaction included in that particular payout. This is useful for tracing specific entries during reconciliation. Each log entry contains:

  • Type - Transaction type (e.g. Payment, Adjustment, Dispute, etc.)
  • Transaction Date - Exact timestamp of the transaction
  • Gross Amount - Amount before fees
  • Fee - Fee deducted for the transaction
  • Net Amount - Amount after fees
  • Description - Additional context for the entry

Exporting Payout Reports

To reconcile payouts against your internal records, you can export individual payout reports directly from the dashboard.

  1. Go to Payouts from your merchant dashboard.
  2. In the Payout History table, locate the payout you want to reconcile.
  3. Click Export on the corresponding row.
  4. The report will be downloaded as a CSV file containing the full transaction breakdown for that payout.