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 balance as the report type continues to work for existing integrations, but isn't supported for new integrations. We strongly recommend using payout_reconciliation and 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 | 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 |
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.
Summary of changes
| Entity | Field | Change | Type |
|---|---|---|---|
| Report | type | + Added | Enum value |
| payout_reconciliation added. | |||
| Report | type | - Deprecated | Field |
| balance is deprecated. Use payout_reconciliation instead. | |||
| Report | remittance_reference | + Added | Field |
| Remittance reference number on the payout and on the remittance advice document. | |||