Improvements to the payout reconciliation report

What's new?

We've added new columns to the payout reconciliation report and now include manual rebates and SWIFT transfer fees as their own rows.

This means that every line item that makes up a payout is now visible in the report, so summing the balance_movement_in_balance_currency column matches your remittance advice exactly.

How it works

Reports in Paddle let you export information from your account to import into accounting software, ERPs, and other business intelligence tools.

New columns

The payout reconciliation report now includes more detail on each transaction and a clearer breakdown of how your revenue is calculated:

More context per row
customer_email, reason, and balance_movement_date make it easier to match line items back to specific buyers, see why an adjustment was applied, and order rows chronologically without leaving the report.
Subtotal and discount detail
New subtotal_* and discount_* columns in both transaction and balance currencies show how discounts impacted each row before tax was applied.

New movement types

The balance_movement_type column now includes two extra values, each corresponding to a new row type in the report:

Value	Description
`rebate`	Manual rebates applied to the seller's balance by Paddle. The amount appears in `payout_rebates_and_fees_in_balance_currency`.
`swift_fee`	International transfer (SWIFT) fees deducted from the payout. The amount appears in `payout_rebates_and_fees_in_balance_currency`.

Previously, these movements were deducted at payout time and didn't appear as line items in the report. Now they're represented as explicit rows, so summing balance_movement_in_balance_currency across the report equals the payout total on your remittance advice.

There's also a new payout_rebates_and_fees_in_balance_currency column that you can use as part of reconciliation.

Easier filtering and summing

chargeback_fee_in_transaction_currency and chargeback_fee_in_balance_currency now return 0 instead of null on rows where no chargeback fee applies. This makes filtering and summing these columns more reliable.

Next steps

This change is available now in version 1 of the Paddle API and in the dashboard. It's a non-breaking change.

Check out the payout reconciliation report reference and the generate reports guide for the updated columns and reconciliation formula.

Summary of changes

Reports

Feature

+ Added Field balance_movement_date

Timestamp of when the balance movement occurred.
+ Added Field customer_email

Email address of the customer associated with the transaction.
+ Added Field reason

Reason for an adjustment or rebate. Populated for adjustment and rebate rows only.
+ Added Field subtotal_in_transaction_currency

Pre-tax subtotal in the transaction currency.
+ Added Field subtotal_in_balance_currency

Pre-tax subtotal in the balance currency.
+ Added Field discount_in_transaction_currency

Total discount applied to the transaction in the transaction currency.
+ Added Field discount_in_balance_currency

Total discount applied to the transaction in the balance currency.
+ Added Field discount_id_list

Comma-separated list of discount IDs applied to the transaction.
+ Added Field discount_code_list

Comma-separated list of discount codes applied to the transaction.
+ Added Field discount_type_list

Comma-separated list of discount types applied to the transaction.
+ Added Field discount_description_list

Comma-separated list of discount descriptions applied to the transaction.
+ Added Field discount_rate_list

Comma-separated list of percentage rates for percentage-type discounts.
+ Added Field payout_rebates_and_fees_in_balance_currency

Rebate or fee amount applied to the payout outside the normal transaction flow. Populated for rebate and swift_fee rows only.
+ Added Enum value balance_movement_type

`rebate` added for manual rebates applied to the seller's balance by Paddle.
+ Added Enum value balance_movement_type

`swift_fee` added for international transfer fees deducted from payouts.
~ Updated Field chargeback_fee_in_transaction_currency

Now returns `0` instead of `null` when no chargeback fee applies to the row.
~ Updated Field chargeback_fee_in_balance_currency

Now returns `0` instead of `null` when no chargeback fee applies to the row.