> For the complete documentation index, see [llms.txt](https://developer.paddle.com/llms.txt).

# Improvements to the payout reconciliation report

New columns for subtotal, discount metadata, customer email, balance movement date, and reason. Plus, rebate and SWIFT fee rows so every line item in your payout is now visible in the report.

---

## What's new?

We've added new columns to the [payout reconciliation report](https://developer.paddle.com/build/reports/payout-reconciliation.md) 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](https://developer.paddle.com/build/reports.md) 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](https://developer.paddle.com/build/reports/payout-reconciliation#how-to-reconcile.md).

### 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](https://developer.paddle.com/build/reports/payout-reconciliation.md) and the [generate reports guide](https://developer.paddle.com/build/reports.md) for the updated columns and reconciliation formula.
## Summary of changes

| Name | Type | Change | Entity | Description |
| --- | --- | --- | --- | --- |
| `balance_movement_date` | Field | added | Reports | Timestamp of when the balance movement occurred. |
| `customer_email` | Field | added | Reports | Email address of the customer associated with the transaction. |
| `reason` | Field | added | Reports | Reason for an adjustment or rebate. Populated for adjustment and rebate rows only. |
| `subtotal_in_transaction_currency` | Field | added | Reports | Pre-tax subtotal in the transaction currency. |
| `subtotal_in_balance_currency` | Field | added | Reports | Pre-tax subtotal in the balance currency. |
| `discount_in_transaction_currency` | Field | added | Reports | Total discount applied to the transaction in the transaction currency. |
| `discount_in_balance_currency` | Field | added | Reports | Total discount applied to the transaction in the balance currency. |
| `discount_id_list` | Field | added | Reports | Comma-separated list of discount IDs applied to the transaction. |
| `discount_code_list` | Field | added | Reports | Comma-separated list of discount codes applied to the transaction. |
| `discount_type_list` | Field | added | Reports | Comma-separated list of discount types applied to the transaction. |
| `discount_description_list` | Field | added | Reports | Comma-separated list of discount descriptions applied to the transaction. |
| `discount_rate_list` | Field | added | Reports | Comma-separated list of percentage rates for percentage-type discounts. |
| `payout_rebates_and_fees_in_balance_currency` | Field | added | Reports | Rebate or fee amount applied to the payout outside the normal transaction flow. Populated for rebate and swift_fee rows only. |
| `balance_movement_type` | Enum value | added | Reports | `rebate` added for manual rebates applied to the seller's balance by Paddle. |
| `balance_movement_type` | Enum value | added | Reports | `swift_fee` added for international transfer fees deducted from payouts. |
| `chargeback_fee_in_transaction_currency` | Field | updated | Reports | Now returns `0` instead of `null` when no chargeback fee applies to the row. |
| `chargeback_fee_in_balance_currency` | Field | updated | Reports | Now returns `0` instead of `null` when no chargeback fee applies to the row. |