Reconcile payouts to transactions and adjustments
Tie each payout to its underlying transaction‑linked movements to account for sales, taxes, fees, and FX, and then verify totals against your remittance advice.
What's new?
We've added a new payout reconciliation report to the Paddle platform. It includes all transaction-linked movements that make up your payouts, helping streamline your reconciliation process.
This replaces the balance report, which is now deprecated.
How it works
Reports in Paddle let you export information from your account to import into accounting software, ERPs, and other business intelligence tools.
To complement the existing reports in Paddle Billing, we've added a new payout reconciliation report that lets you trace each payout back to the transactions and adjustments that make it up. It gives a clear, step-by-step breakdown of how the gross amount is reduced by taxes, fees, FX, and adjustments to arrive at your net payout total.
You can filter by remittance reference to reconcile a specific payout, or by date range using transaction updated dates to cover multiple payouts.
The report includes itemized payout components in transaction and balance currencies, including gross amounts, taxes with rates, and fees such as Paddle, FX, chargeback, and those retained to cover gateway costs. It also includes customer location data to support local reporting requirements, and product and pricing details to help you analyze your revenue mix.
Migrating from the balance report
The payout reconciliation report replaces the balance report, which is now deprecated.
Passing
balanceas the reporttypecontinues to work for existing integrations, but isn't supported for new integrations. We strongly recommend usingpayout_reconciliationand migrating existing integrations to the new report type.
While the balance report provided a high-level overview, the payout reconciliation report offers a granular breakdown of every component that impacts your final payout.
Many fields returned in the balance report map to the payout reconciliation report, with some renames and replacements to reconcile your accounts more accurately.
| Change (details on hover) | Balance report field | Payout reconciliation report field |
|---|---|---|
| Same | subscription_id | subscription_id |
| Same | transaction_id | transaction_id |
| Same | adjustment_id | adjustment_id |
| Same | direction | direction |
| Replaced | type | balance_movement_type |
| Renamed | updated_at | transaction_updated_at |
| Same | balance_currency_code | balance_currency_code |
| Renamed | currency_code | transaction_currency_code |
| Renamed | payout_id | remittance_reference |
| Same | payout_created_at | payout_created_at |
| Same | payout_period_starts_at | payout_period_starts_at |
| Same | payout_period_ends_at | payout_period_ends_at |
| Same | payout_currency_code | payout_currency_code |
| Renamed | gross_amount | total_gross_in_transaction_currency |
| Replaced | amount | balance_movement_in_transaction_currency |
| Replaced | balance_amount | balance_movement_in_balance_currency |
Summary of changes to fields
This is a summary of the changes to fields in the Paddle API and webhooks:
Reports
| Field | Change | Notes |
|---|---|---|
type | New allowed value | payout_reconciliation added. |
type | Deprecated value | balance is deprecated. Use payout_reconciliation instead. |
Payouts
| Field | Change | Notes |
|---|---|---|
remittance_reference | New field | Remittance reference number on the payout and on the remittance advice document. |
Next steps
This change is available in version 1 of the Paddle API and in the dashboard.
It's a non-breaking change, meaning it doesn't impact existing integrations.
We strongly recommend migrating to the payout_reconciliation report type to access more comprehensive data and ensure future compatibility.
Check out the generate reports guide and the report entity overview in the API reference to get started.