Payout reconciliation reports

Payout reconciliation reports help you reconcile payouts to transactions and adjustments to understand how your payout amounts are calculated.

A payout is the money Paddle sends you from your sales. If your balance meets the minimum threshold, Paddle creates your payout on the 1st and sends the payment by the 15th. You'll receive funds by the payout method you've set in your settings.

When to use

Reconcile payouts to transactions and adjustments
Verify your payout totals against your remittance advice by summing balance movements to calculate how the payout is formed and close the books.
Audit fees and currency exchange
Review itemized gross, taxes, Paddle, chargeback, and retained fees in both transaction and balance currencies to confirm calculations and investigate variances.
Analyze revenue and product performance
Break down activity by product, price, country, origin, and billing frequency to see mix shifts, cohort patterns, and subscription dynamics affecting payouts.
Simplify tax reporting
Split activity by invoice entity, using United States state and ZIP where applicable, and include tax rates and tax mode to prove local compliance and support accurate indirect tax reporting.
Automate financial workflows
Generate reports via API to feed into accounting and BI systems so monthly reconciliations, checks, and dashboards run on schedule without manual intervention.

flowchart TD
    A[Receive payout] --> B[Find remittance reference in the dashboard or on your remittance advice]
    B --> C[Generate payout reconciliation report via the dashboard or API]
    C --> D[Sum balance_movement_in_balance_currency across all rows]
    D --> E{Does total equal payout amount<br/>on the remittance advice?}
    E -->|Yes| F[✓ Reconciled]
    E -->|No| G[Regenerate the report and re-check the total]
    G --> H{Still doesn't match?}
    H -->|No| F
    H -->|Yes| I[Contact support with your<br/>remittance reference]

Report filters

When generating payout reconciliation reports, you can filter by:

Field	Description	Use case
`remittance_reference`	Filter by a specific payout using its remittance reference. This gives you all transactions that contributed to that particular payout.	Reconciling a specific payout to your bank account.
`transaction_updated_date`	Filter by the date range when transactions were last updated. Use this to generate reports covering multiple payouts within a time period.	Monthly reconciliation reports or analyzing trends over time.

Report columns

The report itemizes how gross sales are reduced by taxes, fees, discounts, and adjustments to arrive at your final payout amount. Each deduction has its own column so you can see what impacts your payout:

Fields	Description
`paddle_fee_in_balance_currency` `paddle_fee_in_transaction_currency`	Processing fees charged by Paddle
`fx_fee_in_balance_currency`	Currency conversion costs for international transactions
`chargeback_fee_in_balance_currency` `chargeback_fee_in_transaction_currency`	Fees for dispute handling
`retained_fee_in_balance_currency` `retained_fee_in_transaction_currency`	Amounts kept by Paddle during refunds to cover gateway costs
`tax_in_balance_currency` `tax_in_transaction_currency`	Customer taxes
`subtotal_in_balance_currency` `subtotal_in_transaction_currency`	Pre-tax subtotal before any discount was applied
`discount_in_balance_currency` `discount_in_transaction_currency`	Total discount applied to the transaction
`discount_id_list` `discount_code_list` `discount_type_list` `discount_description_list` `discount_rate_list`	Comma-separated lists of discount metadata for each transaction
`payout_rebates_and_fees_in_balance_currency`	Manual rebates and SWIFT fees applied to the payout outside the normal transaction flow

Each row in the report is one balance movement. The balance_movement_type column tells you what kind of row it is, including sales, adjustments, rebates, and SWIFT fees. Every line item that makes up the payout total is represented.

Column headings on payout reconciliation reports mirror fields in the Paddle API. Data is provided in the following columns:

remittance_referencestring | null

Remittance reference for the payout. Found in the 'Remittance reference' column on the Payouts page or on the remittance advice document. null if the balance movement isn't tied to a payout.

transaction_idstring

Example: txn_01h04vsbhqc62t8hmd4z3b578c

Paddle ID of the transaction this balance movement is for, prefixed with txn_.

Pattern: ^txn_[a-z\d]{26}$

adjustment_idstring | null

Example: adj_01gya6twkp8y0tv1e19rsgst9m

Paddle ID of the adjustment applied to the transaction this balance movement is for, prefixed with adj_. null if balance movement isn't tied to an adjustment.

Pattern: ^adj_[a-z\d]{26}$

customer_idstring

Example: ctm_01grnn4zta5a1mf02jjze7y2ys

Paddle ID of the customer the transaction belongs to, prefixed with ctm_.

Pattern: ^ctm_[a-z\d]{26}$

subscription_idstring | null

Example: sub_01h04vsc0qhwtsbsxh3422wjs4

Paddle ID of the subscription the transaction belongs to, prefixed with sub_. null if the transaction isn't tied to a subscription.

Pattern: ^sub_[a-z\d]{26}$

payout_created_atstring (date-time) | null